Help with calculating revenue

T

TahoeGirl

New Member
Joined
Mar 28, 2009
Messages
2
I need help calculating revenue and for a workbook.

In the range H3:H43, enter a formula using defined names to calculate the revenue, which is determined by the units sold multiplied by the price per unit.

  • The sales price of each unit can vary from $5 to $15 (in whole numbers.)
<TABLE style="WIDTH: 565pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=751 border=0><COLGROUP><COL style="WIDTH: 12pt; mso-width-source: userset; mso-width-alt: 585" width=16><COL style="WIDTH: 158pt; mso-width-source: userset; mso-width-alt: 7680" width=210><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" span=3 width=73><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 12pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" width=16 height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 158pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=210> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=77> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 59pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=79> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=64> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 17pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=22> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=73> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=73> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=73> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=64> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl69 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: black">Units Sold</TD><TD class=xl70 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue 0.5pt solid; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: green"> Revenue</TD><TD class=xl71 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue 0.5pt solid; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: red"> Expense</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>0</TD><TD class=xl66 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl66 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>1,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>1,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>2,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>2,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>3,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>3,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>4,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>4,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>5,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>5,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99">Sales Price per Unit:</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>6,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99">Manufacturing Cost per Unit:</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>6,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99">Fixed Monthly Expense:</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>7,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99">Break-Even Point (Units Sold):</TD><TD class=xl76 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>7,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl75 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99">Revenue at Break-Even Point:</TD><TD class=xl77 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>8,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>8,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>9,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>9,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>10,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>10,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>11,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>11,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>12,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>12,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>13,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>13,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>14,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>14,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>15,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>15,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>16,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>16,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>17,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>17,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>18,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>18,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>19,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>19,500</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl65 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue 0.5pt solid; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white" align=right>20,000</TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl67 style="BORDER-RIGHT: blue 0.5pt solid; BORDER-TOP: blue; BORDER-LEFT: blue; BORDER-BOTTOM: blue 0.5pt solid; BACKGROUND-COLOR: white"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99" height=17> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99"> </TD></TR></TBODY></TABLE>

Please help!!
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
=SUMIF('Profit Analysis'!H3:H43,1,'Profit Analysis'!H3:H43,2,'Profit Analysis'!H3:H43,3,'Profit Analysis'!H3:H43,4,'Profit Analysis'!H3:H43,5,'Profit Analysis'!H3:H43,6,'Profit Analysis'!H3:H43,7,'Profit Analysis'!H3:H43,8,'Profit Analysis'!H3:H43,9,'Profit Analysis'!H3:H43,10,'Profit Analysis'!H3:H43,11,'Profit Analysis'!H3:H43,12,'Profit Analysis'!H3:H43,13,'Profit Analysis'!H3:H43,14,'Profit Analysis'!H3:H43,15)

I know this is not right. Excel wouldn't even accept it. I am completely confused and Excel dumb. Yes this is homework and the book is more confusing then help. Unfortunately I don't have anyone who knows Excel this well to help me.

Please Help!
 
Upvote 0
OK...Let's see if we can help.

The main point of the example is to have you understand the use of Named Ranges.

With Sheet1
B3: (the cell to hold the Sales Price per Unit)
G3:G43 contains various Units Sold values

First, create a Named Range for the Sales Price per Unit cell:
Select cell B3
From the Excel Main Menu:
Insert.Names.Define
Names in Workbook: UnitSalesPrice
Refers To: Sheet1!$B$3
Click: OK

Second, use that Named Range in formulas:
Select cell H3
Type: =...Click on G3...type: *...Press [F3]...Select: UnitSalesPrice
Press ENTER
That will put this formula in H3: =G3*UnitSalesPrice
(Notice you don't have to enter sales price cell B3
...That cell has a Name!)

Copy that formula down through H43.

Now..each time you enter a new Sales Price per Unit...the Revenue changes.

Does that help?
 
Upvote 0
Re: Help with calculating revenue the range is H3:H43. Need to calculate the revenue by units sold and multiply by price per unit.

This formula does not work and it could be that she did not printscreen it. I am having the same problem.



-- removed inline image ---





Ron Coderre said:
OK...Let's see if we can help.

The main point of the example is to have you understand the use of Named Ranges.

With Sheet1
B3: (the cell to hold the Sales Price per Unit)
G3:G43 contains various Units Sold values

First, create a Named Range for the Sales Price per Unit cell:
Select cell B3
From the Excel Main Menu:
Insert.Names.Define
Names in Workbook: UnitSalesPrice
Refers To: Sheet1!$B$3
Click: OK

Second, use that Named Range in formulas:
Select cell H3
Type: =...Click on G3...type: *...Press [F3]...Select: UnitSalesPrice
Press ENTER
That will put this formula in H3: =G3*UnitSalesPrice
(Notice you don't have to enter sales price cell B3
...That cell has a Name!)

Copy that formula down through H43.

Now..each time you enter a new Sales Price per Unit...the Revenue changes.

Does that help?
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
537
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
478
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
901
epactheactor
E

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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