SuperCalc Ver. 1.06 Break Even AnalysisF2  P7 !" Break Even Analysis "Units Sold!"Profit or Loss"Product NameCB18C2*B3*(.01*(100-B19))-(B9+(B16*C2))"Retail PriceA@00C C2+B18C3*B3*(.01*(100-B19))-(B9+(B16*C3))C0C3+B18C4*B3*(.01*(100-B19))-(B9+(B16*C4))"Fixed Costs" (Totals)C@C4+B18C5*B3*(.01*(100-B19))-(B9+(B16*C5))!" DevelopmentA@0000CPC5+B18C6*B3*(.01*(100-B19))-(B9+(B16*C6)) " MarketingA@0000@0C`C6+B18C7*B3*(.01*(100-B19))-(B9+(B16*C7)) " OtherA@0000CpC7+B18C8*B3*(.01*(100-B19))-(B9+(B16*C8))"TOTAL Fixed CostSUM(B6:B8)CC8+B18C9*B3*(.01*(100-B19))-(B9+(B16*C9)) CC9+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.50DC14+B18C15*B3*(.01*(100-B19))-(B9+(B16*C15))"TOTAL Variable CostSUM(B12:B15)DC15+B18C16*B3*(.01*(100-B19))-(B9+(B16*C16))DC16+B18C17*B3*(.01*(100-B19))-(B9+(B16*C17))"Quantity IncrementAC100DC17+B18C18*B3*(.01*(100-B19))-(B9+(B16*C18))"Discount Rate (%)@BP50DC18+B18C19*B3*(.01*(100-B19))-(B9+(B16*C19))DC19+B18C20*B3*(.01*(100-B19))-(B9+(B16*C20))D C20+B18C21*B3*(.01*(100-B19))-(B9+(B16*C21))D!C21+B18C22*B3*(.01*(100-B19))-(B9+(B16*C22))D"C22+B18C23*B3*(.01*(100-B19))-(B9+(B16*C23))D#C23+B18C24*B3*(.01*(100-B19))-(B9+(B16*C24))D$C24+B18C25*B3*(.01*(100-B19))-(B9+(B16*C25))D%C25+B18C26*B3*(.01*(100-B19))-(B9+(B16*C26))D&C26+B18C27*B3*(.01*(100-B19))-(B9+(B16*C27))D'C27+B18C28*B3*(.01*(100-B19))-(B9+(B16*C28))D(C28+B18C29*B3*(.01*(100-B19))-(B9+(B16*C29))D)C29+B18C30*B3*(.01*(100-B19))-(B9+(B16*C30))D0C30+B18C31*B3*(.01*(100-B19))-(B9+(B16*C31))D1C31+B18C32*B3*(.01*(100-B19))-(B9+(B16*C32))