Help with a formula

E

excelUsr

New Member
Joined
Apr 4, 2011
Messages
1
Hi - Can someone help with the following formula?

An airline sells 120 tickets for a flight that seats 100. Each ticket is non-refundable and costs $200. The unit cost of flying is $80 / ticket. If flight is overbooked each person who does not find a seat is given $300. Assume it is equally likely that any number of people between 91-120 show up for the flight. How much expected profit will the flight generate?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
I am thinking school also.

I would like to help.

I do have what I would think is a solution but I need to know what your thoughts are on this.

So is it an assignment?
What do you have so far, like do you have the raw number details of the question in a sheet and which cells contain what?

Please forgive me if this is not school work.
 
Upvote 0
Hi,

I have come up with this problem as well.

The thing that confuses me is how to compute random between 91-120.

But my guess is to calculate profit (120 tickets*cost ticket)-(flying passanger * unit cost). If 100 fly the profit is 16000. Then you expand it from 101 to 120 substracting the overbooked*cost overbooking, and from 91-99 changing the number of flying passangers from first formula.

If you average the totals turns 14020.

Is that correct? Is there an easiest way?
 
Upvote 0
Here is what I came up with:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Passengers</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Tickets Sales</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Cost / Passenger</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Overbook Refund</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Profit</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">91</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7280</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10920</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">92</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7360</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11040</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">93</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7440</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11160</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">94</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7520</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11280</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">95</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11400</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">96</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7680</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11520</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">97</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7760</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11640</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">98</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7840</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11760</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">99</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7920</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11880</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">100</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">12000</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">101</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">300</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11900</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">102</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11800</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">103</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">900</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11700</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">104</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11600</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">105</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1500</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11500</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">106</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11400</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">107</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2100</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11300</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">108</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11200</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">109</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2700</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11100</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">110</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11000</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">111</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3300</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10900</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">112</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10800</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">113</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3900</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10700</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">114</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10600</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">115</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4500</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10500</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">116</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23200</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10400</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">35</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">117</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5100</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10300</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">36</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">118</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23600</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5400</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10200</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">37</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">119</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23800</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5700</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10100</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">38</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">120</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">24000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">6000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10000</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">39</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Average Cost</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fac090; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11120</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">40</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Ave. Profit Range</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10000 - 12000</TD></TR></TBODY></TABLE>
Sheet1​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F9</TH><TD style="TEXT-ALIGN: left">=E9*$A$5</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G9</TH><TD style="TEXT-ALIGN: left">=IF(E9>100,8000,E9*$A$3)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H9</TH><TD style="TEXT-ALIGN: left">=IF(E9>100,(E9-100)*300,0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I9</TH><TD style="TEXT-ALIGN: left">=F9-G9-H9</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>I</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">39</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fac090; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11120</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">40</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10000 - 12000</TD></TR></TBODY></TABLE>
Sheet1​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I39</TH><TD style="TEXT-ALIGN: left">=AVERAGE(I9:I38)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I40</TH><TD style="TEXT-ALIGN: left">=MIN(I9:I38)&" - "&MAX(I9:I38)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
 
Upvote 0
My question is similar to the original post. I was recently given a new task at work where I now have to track sales performance by our sales staff with their targeted goal. I am hoping that there may be a resource of <samp id="url">excel formulas that I can refer to rather than creating new ones for each task. What I ultimately need done is to create a spreadsheet that daily sales numbers can be entered and a running tally would subtract from the goal and ultimately countdown to 0. I know it probably does not make much sense, but it does in my mind. There are roughly 50 employees needing to be tracked.
</samp>
 
Upvote 0
I agree with your solution, but there is only one point that makes me doubt. "Ticket sales". The problem says "the airline sells 120 tickets" and they appear from 91 to 120, but you are assuming only revenue from the ones that flew. Am I reading too much into this or should we count 24000 flat from the whole 120 tickets sold?


repairman615 said:
Here is what I came up with:

Excel 2007<table style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules="all" cellpadding="2"><colgroup><col style="BACKGROUND-COLOR: #e0e0f0" width="25"><col><col><col><col><col></colgroup><thead><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><th>
</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr><td style="TEXT-ALIGN: center; COLOR: #161120">8</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Passengers</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Tickets Sales</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Cost / Passenger</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Overbook Refund</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Profit</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">9</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">91</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7280</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10920</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">10</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">92</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7360</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11040</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">11</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">93</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7440</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11160</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">12</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">94</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">18800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7520</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11280</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">13</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">95</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11400</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">14</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">96</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7680</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11520</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">15</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">97</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7760</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11640</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">16</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">98</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7840</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11760</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">17</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">99</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7920</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11880</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">18</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">100</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">12000</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">19</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">101</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">300</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11900</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">20</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">102</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11800</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">21</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">103</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">900</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11700</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">22</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">104</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">20800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11600</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">23</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">105</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1500</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11500</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">24</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">106</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">1800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11400</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">25</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">107</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2100</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11300</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">26</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">108</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11200</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">27</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">109</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">21800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">2700</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11100</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">28</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">110</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11000</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">29</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">111</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3300</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10900</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">30</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">112</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10800</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">31</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">113</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">3900</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10700</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">32</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">114</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">22800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10600</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">33</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">115</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4500</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10500</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">34</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">116</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23200</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">4800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10400</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">35</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">117</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5100</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10300</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">36</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">118</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23600</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5400</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10200</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">37</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">119</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">23800</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5700</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10100</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">38</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">120</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">24000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">6000</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10000</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">39</td><td style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">
</td><td style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">
</td><td style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">
</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Average Cost</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fac090; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11120</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">40</td><td style="TEXT-ALIGN: right">
</td><td style="TEXT-ALIGN: right">
</td><td style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid">
</td><td style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Ave. Profit Range</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10000 - 12000</td></tr></tbody></table>
Sheet1​


<table style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules="all" cellpadding="2" width="85%"><tbody><tr><td style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<table style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules="all" cellpadding="2" width="100%"><thead><tr style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><th width="10">Cell</th><th style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</th></tr></thead><tbody><tr><th style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width="10">F9</th><td style="TEXT-ALIGN: left">=E9*$A$5</td></tr><tr><th style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width="10">G9</th><td style="TEXT-ALIGN: left">=IF(E9>100,8000,E9*$A$3)</td></tr><tr><th style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width="10">H9</th><td style="TEXT-ALIGN: left">=IF(E9>100,(E9-100)*300,0)</td></tr><tr><th style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width="10">I9</th><td style="TEXT-ALIGN: left">=F9-G9-H9</td></tr></tbody></table></td></tr></tbody></table>


Excel 2007<table style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules="all" cellpadding="2"><colgroup><col style="BACKGROUND-COLOR: #e0e0f0" width="25"><col></colgroup><thead><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><th>
</th><th>I</th></tr></thead><tbody><tr><td style="TEXT-ALIGN: center; COLOR: #161120">39</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fac090; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">11120</td></tr><tr><td style="TEXT-ALIGN: center; COLOR: #161120">40</td><td style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">10000 - 12000</td></tr></tbody></table>
Sheet1​


<table style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules="all" cellpadding="2" width="85%"><tbody><tr><td style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<table style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules="all" cellpadding="2" width="100%"><thead><tr style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><th width="10">Cell</th><th style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</th></tr></thead><tbody><tr><th style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width="10">I39</th><td style="TEXT-ALIGN: left">=AVERAGE(I9:I38)</td></tr><tr><th style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width="10">I40</th><td style="TEXT-ALIGN: left">=MIN(I9:I38)&" - "&MAX(I9:I38)</td></tr></tbody></table></td></tr></tbody></table>
Click to expand...
 
Upvote 0
Hello Sol,

I would think you read enough in to it. :)

You are right. When I did change the Ticket Sales to 24000, the result was 14020.

-Jeff

By the way, Welcome to the Board!
 
Upvote 0
I am having the same issue with the same problem.
I got until the point that has been shown in the picture but what would the expected profit be? Are we taking the average of the profit from 91 to 120 which is 11120
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
377
Jagadeshrao
J
C
  • Question Question
Need help with look up formula
Replies
5
Views
667
GuzmanServices
G
A
  • Question Question
create report for 40000 rows to calculation stock across sheet based on sheet name in cell value
Replies
1
Views
369
Amer Omar
A
E
  • Solved
list formula
2
Replies
15
Views
1K
awoohaw
awoohaw
L
  • Question Question
Excel finance task
Replies
2
Views
501
Fluff
Fluff

Forum statistics

Threads
1,224,603
Messages
6,179,850
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top