{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Break-Even Chart"],"not_rendered":{"charts":1,"images":1,"defined_names":36,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Break-Even Chart","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"merged":[[32,2,32,9]]}
[]
[]
[null,null,"Break-Even Analysis"]
{"$rows_empty":22}
[{"$nulls":3},"Break-Even Point (units) =",{"$f":"((E28/(E30-E29)))","v":{"v":2000,"d":"2,000 "}},{"$nulls":3},"Break-Even Point ($'s) =",{"$f":"(E26*E30)","v":{"v":10000,"d":"$10,000"}}]
[]
[null,null,"Total Fixed Costs","TFC =",{"v":3000,"d":"$3,000"},null,null,"Formulas:"]
[null,null,"Variable Cost per Unit","VCU =",{"v":3.5,"d":"$3.50"},null,null,"BEP (units) = TFC/(SPU-VCU)"]
[null,null,"Sales Price per Unit","SPU =",{"v":5,"d":"$5.00"},null,null,"BEP ($'s) = BEP (units) * SPU"]
[]
[]
[]
[]
[null,null,"Unit Increment x-axis",null,{"v":400,"d":"400 "}]
[]
[null,null,"Graph Data:"]
[null,null,"Total"]
[null,null,"Units","TFC","TVC","TC","Sales","Profit"]
[null,null,0,{"$f":"$E$28","v":3000},{"$f":"(C40*$E$29)","v":0},{"$f":"(D40+E40)","v":3000},{"$f":"(C40*$E$30)","v":0},{"$f":"(G40-F40)","v":-3000}]
[null,null,{"$f":"$E$35+C40","v":400},3000,1400,4400,2000,-2400]
[null,null,800,3000,2800,5800,4000,-1800]
[null,null,1200,3000,4200,7200,6000,-1200]
[null,null,1600,3000,5600,8600,8000,-600]
[null,null,2000,3000,7000,10000,10000,0]
[null,null,2400,3000,8400,11400,12000,600]
[null,null,2800,3000,9800,12800,14000,1200]
[null,null,3200,3000,11200,14200,16000,1800]
[null,null,3600,3000,12600,15600,18000,2400]
[null,null,4000,3000,14000,17000,20000,3000]