SuperCalc ver. 1.12 Break Even AnalysisF2¶  P7 #" Break Even Analysis00)^!"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))دددددد