SuperCalc ver. 1.12 Break Even AnalysisF2¶  P7 #" Break Even Analysisc Wo!"Units SoldEv""Profit or Loss Analy"Product Names Analy¢CB18s Analy¦C2*B3*(.01*(100-B19))-(B9+(B16*C2))"Retail Price3*(.01*(P0etai¢C 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)sB¢C@C4+B18.01*(¦C5*B3*(.01*(100-B19))-(B9+(B16*C5))"" Development*(.01*(P0 Dev¢CPC5+B18.01*(¦C6*B3*(.01*(100-B19))-(B9+(B16*C6))!" MarketingBP0 Mar¢C`C6+B18.01*(¦C7*B3*(.01*(100-B19))-(B9+(B16*C7))!" OtherC7*BP0 Oth¢CpC7+B18.01*(¦C8*B3*(.01*(100-B19))-(B9+(B16*C8))"TOTAL Fixed Cost01*(¢SUM(B6:B8)(¢C€C8+B18B8)(¦C9*B3*(.01*(100-B19))-(B9+(B16*C9)) ¢C�C9+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 Oth¢DC14+B18.01*¦C15*B3*(.01*(100-B19))-(B9+(B16*C15))"TOTAL Variable Cost*£SUM(B12:B15)100-B19¢DC15+B18B15)¦C16*B3*(.01*(100-B19))-(B9+(B16*C16))¢DC16+B18.01*¦C17*B3*(.01*(100-B19))-(B9+(B16*C17))"Quantity Increment1*P100nt¢DC17+B18t1*¦C18*B3*(.01*(100-B19))-(B9+(B16*C18))"Discount Rate (%)01*P50sco¢DC18+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))