SuperCalc Ver. 1.06 Break Even AnalysisF2¶  P7 !" Break Even Analysis "Units Sold!"Profit or Loss"Product Name¡CB18£C2*B3*(.01*(100-B19))-(B9+(B16*C2))"Retail PriceA@00¡C C2+B18£C3*B3*(.01*(100-B19))-(B9+(B16*C3))¡C0C3+B18£C4*B3*(.01*(100-B19))-(B9+(B16*C4))"Fixed Costs" (Totals)¡C@C4+B18£C5*B3*(.01*(100-B19))-(B9+(B16*C5))!" DevelopmentA@0000¡CPC5+B18£C6*B3*(.01*(100-B19))-(B9+(B16*C6)) " MarketingA@0000@0¡C`C6+B18£C7*B3*(.01*(100-B19))-(B9+(B16*C7)) " OtherA@0000¡CpC7+B18£C8*B3*(.01*(100-B19))-(B9+(B16*C8))"TOTAL Fixed Cost¡SUM(B6:B8)¡C€C8+B18£C9*B3*(.01*(100-B19))-(B9+(B16*C9)) ¡C�C9+B18 £C10*B3*(.01*(100-B19))-(B9+(B16*C10)) "Variable Costs " (Per Unit) ¡DC10+B18 £C11*B3*(.01*(100-B19))-(B9+(B16*C11)) " Labor @@0 ¡DC11+B18 £C12*B3*(.01*(100-B19))-(B9+(B16*C12)) " Materials @@0 ¡DC12+B18 £C13*B3*(.01*(100-B19))-(B9+(B16*C13)) " Packaging @@0 ¡DC13+B18 £C14*B3*(.01*(100-B19))-(B9+(B16*C14)) " OtherA@0.50¡DC14+B18£C15*B3*(.01*(100-B19))-(B9+(B16*C15))"TOTAL Variable Cost¡SUM(B12:B15)¡DC15+B18£C16*B3*(.01*(100-B19))-(B9+(B16*C16))¡DC16+B18£C17*B3*(.01*(100-B19))-(B9+(B16*C17))"Quantity IncrementAC100¡DC17+B18£C18*B3*(.01*(100-B19))-(B9+(B16*C18))"Discount Rate (%)@BP50¡DC18+B18£C19*B3*(.01*(100-B19))-(B9+(B16*C19))¡DC19+B18£C20*B3*(.01*(100-B19))-(B9+(B16*C20))¡D C20+B18£C21*B3*(.01*(100-B19))-(B9+(B16*C21))¡D!C21+B18£C22*B3*(.01*(100-B19))-(B9+(B16*C22))¡D"C22+B18£C23*B3*(.01*(100-B19))-(B9+(B16*C23))¡D#C23+B18£C24*B3*(.01*(100-B19))-(B9+(B16*C24))¡D$C24+B18£C25*B3*(.01*(100-B19))-(B9+(B16*C25))¡D%C25+B18£C26*B3*(.01*(100-B19))-(B9+(B16*C26))¡D&C26+B18£C27*B3*(.01*(100-B19))-(B9+(B16*C27))¡D'C27+B18£C28*B3*(.01*(100-B19))-(B9+(B16*C28))¡D(C28+B18£C29*B3*(.01*(100-B19))-(B9+(B16*C29))¡D)C29+B18£C30*B3*(.01*(100-B19))-(B9+(B16*C30))¡D0C30+B18£C31*B3*(.01*(100-B19))-(B9+(B16*C31))¡D1C31+B18£C32*B3*(.01*(100-B19))-(B9+(B16*C32))