SuperCalc ver. 1.12 Break Even AnalysisF2  P7 #" Break Even Analysisc Wo!"Units SoldEv""Profit or Loss Analy"Product Names AnalyCB18s AnalyC2*B3*(.01*(100-B19))-(B9+(B16*C2))"Retail Price3*(.01*(P0etaiC C2+B18.01*(C3*B3*(.01*(100-B19))-(B9+(B16*C3))C0C3+B18.01*(C4*B3*(.01*(100-B19))-(B9+(B16*C4))"Fixed CostsB" (Totals)sBC@C4+B18.01*(C5*B3*(.01*(100-B19))-(B9+(B16*C5))"" Development*(.01*(P0 DevCPC5+B18.01*(C6*B3*(.01*(100-B19))-(B9+(B16*C6))!" MarketingBP0 MarC`C6+B18.01*(C7*B3*(.01*(100-B19))-(B9+(B16*C7))!" OtherC7*BP0 OthCpC7+B18.01*(C8*B3*(.01*(100-B19))-(B9+(B16*C8))"TOTAL Fixed Cost01*(SUM(B6:B8)(CC8+B18B8)(C9*B3*(.01*(100-B19))-(B9+(B16*C9)) CC9+B18.01*( C10*B3*(.01*(100-B19))-(B9+(B16*C10)) "Variable Costs*(.01* " (Per Unit)t DC10+B18.01* C11*B3*(.01*(100-B19))-(B9+(B16*C11)) !" LaborC11* P0 Lab DC11+B18.01* C12*B3*(.01*(100-B19))-(B9+(B16*C12)) !" Materials* P0 Mat DC12+B18.01* C13*B3*(.01*(100-B19))-(B9+(B16*C13)) !" Packaging* P0 Pac DC13+B18.01* C14*B3*(.01*(100-B19))-(B9+(B16*C14))!" OtherC14*P0 OthDC14+B18.01*C15*B3*(.01*(100-B19))-(B9+(B16*C15))"TOTAL Variable Cost*SUM(B12:B15)100-B19DC15+B18B15)C16*B3*(.01*(100-B19))-(B9+(B16*C16))DC16+B18.01*C17*B3*(.01*(100-B19))-(B9+(B16*C17))"Quantity Increment1*P100ntDC17+B18t1*C18*B3*(.01*(100-B19))-(B9+(B16*C18))"Discount Rate (%)01*P50scoDC18+B1801*C19*B3*(.01*(100-B19))-(B9+(B16*C19))DC19+B18.01*C20*B3*(.01*(100-B19))-(B9+(B16*C20))D C20+B18.01*C21*B3*(.01*(100-B19))-(B9+(B16*C21))D!C21+B18.01*C22*B3*(.01*(100-B19))-(B9+(B16*C22))D"C22+B18.01*C23*B3*(.01*(100-B19))-(B9+(B16*C23))D#C23+B18.01*C24*B3*(.01*(100-B19))-(B9+(B16*C24))D$C24+B18.01*C25*B3*(.01*(100-B19))-(B9+(B16*C25))D%C25+B18.01*C26*B3*(.01*(100-B19))-(B9+(B16*C26))D&C26+B18.01*C27*B3*(.01*(100-B19))-(B9+(B16*C27))D'C27+B18.01*C28*B3*(.01*(100-B19))-(B9+(B16*C28))D(C28+B18.01*C29*B3*(.01*(100-B19))-(B9+(B16*C29))D)C29+B18.01*C30*B3*(.01*(100-B19))-(B9+(B16*C30))D0C30+B18.01*C31*B3*(.01*(100-B19))-(B9+(B16*C31))D1C31+B18.01*C32*B3*(.01*(100-B19))-(B9+(B16*C32))