{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[1,2,2,7],[5,2,5,3],[6,2,6,3],[7,2,7,3],[7,7,8,8],[8,2,8,3],[10,2,11,2],[10,3,10,6],[10,7,11,7],[10,8,11,8],[11,5,11,6]],"flags":["formulas_cached_only"]}
[]
[null,null,"I call this formula the break-even-plus-profit formula. The number of units, needed to make a desired level of profit, is equal to the total fixed costs, plus the desired profit divided by the selling price minus the variable costs per unit.  This is represented with the following formula.  You can calculate results electronically with this formula, if you delete the numbers in the white boxes, and enter your own numbers.  Your calculated result will appear in red, on the right. "]
[]
[]
[]
[null,null,"Total Fixed Costs",null,"=",{"v":20000,"d":"$20,000.00"}]
[null,null,"         Selling Price    ",null,"=",{"v":2,"d":"$2.00"}]
[null,null,"Veriable Costs per unit ",null,"=",{"v":1,"d":"$1.00"},null,"Calculated result is presented below in red"]
[null,null,"desired profit",null,"=",{"v":10000,"d":"$10,000.00"}]
[]
[null,null,"Number of units=","Total Fixed Costs + Desired Profit",{"$nulls":3},"=",{"v":30000,"d":"30,000"}]
[{"$nulls":3},"Selling Price    ","_","Veriable Costs per unit"]