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

{"sheet":"Break-Even Simple","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"merged":[[45,2,45,12]]}
[]
[]
[]
[]
[null,null,"Sales Revenue",null,{"$f":"C5&\" \"&TEXT(G5,\"0.0%\")","v":"Sales Revenue 100.0%"},{"$f":"Revenues","v":{"v":5000,"d":"$5,000"}},{"$f":"IF(Revenues=0,\"\",F5/Revenues)","v":{"v":1,"d":"100%"}}]
[null,null,"Cost of Sales",null,{"$f":"C6&\" \"&TEXT(G6,\"0.0%\")","v":"Cost of Sales 80.0%"},{"$f":"Cost_of_Sales","v":{"v":4000,"d":"$4,000"}},{"v":0.8,"d":"80%"}]
[null,null,{"$f":"LabelGP","v":"Gross Profit"},null,{"$f":"C7&\" \n\"&TEXT(G7,\"0.0%\")","v":"Gross Profit \n20.0%"},{"$f":"Gross_Profit","v":{"v":1000,"d":"$1,000"}},{"v":0.2,"d":"20%"}]
[null,null,"Allocated Fixed Expenses",null,{"$f":"C8&\" \"&TEXT(G8,\"0.0%\")","v":"Allocated Fixed Expenses 10.0%"},{"$f":"AllocatedFixedCosts","v":{"v":500,"d":"$500"}},{"v":0.1,"d":"10%"}]
[null,null,"Income Before Tax",null,{"$f":"C9&\" \n\"&TEXT(G9,\"0.0%\")","v":"Income Before Tax \n10.0%"},{"$f":"F7-F8","v":{"v":500,"d":"$500"}},{"v":0.1,"d":"10%"}]
[null,null,"Income Taxes",{"v":100,"d":"$100"},{"$f":"C10&\" \n\"&TEXT(G10,\"0.0%\")","v":"Income Taxes \n2.0%"},null,{"$f":"IF(Revenues=0,\"\",D10/Revenues)","v":{"v":0.02,"d":"2%"}}]
[null,null,"Net Income (Loss)",null,{"$f":"C11&\" \n\"&TEXT(G11,\"0.0%\")","v":"Net Income (Loss) \n8.0%"},{"$f":"F9-D10","v":{"v":400,"d":"$400"}},{"v":0.08,"d":"8%"}]
[]
[]
[{"$nulls":4},"LastGoodSpinnerValue",69.75919342041016]
[null,null,"FixedOverhead",{"v":500,"d":"$500.00"},"FixedOverhead"]
[]
[]
[null,null,{"$f":"PartItemName & \" sold during What-If scenario\"","v":" sold during What-If scenario"},0,{"$f":"IF(Revenues = 0, Units_Sold, Revenues/Price)","v":{"v":166.66666666666666,"d":"167"}},{"$f":"2*E18","v":{"v":333.3333333333333,"d":"333"}},"quantity"]
[null,null,"Sales Revenue",{"$f":"Price*D18","v":{"v":0,"d":"0.00"}},{"$f":"Price*E18","v":{"v":5000,"d":"5,000.00"}},{"$f":"Price*F18","v":{"v":10000,"d":"10,000.00"}}]
[null,null,"Cost of Sales",{"$f":"Unit_Cost*D18+D21","v":{"v":500,"d":"500.00"}},{"$f":"Unit_Cost*E18+E21","v":{"v":4666.666666666666,"d":"4,666.67"}},{"$f":"Unit_Cost*F18+F21","v":{"v":8833.333333333332,"d":"8,833.33"}}]
[null,null,"Fixed Expenses",{"$f":"AllocatedFixedCosts","v":{"v":500,"d":"500.00"}},{"$f":"AllocatedFixedCosts","v":{"v":500,"d":"500.00"}},{"$f":"AllocatedFixedCosts","v":{"v":500,"d":"500.00"}}]
[]
[{"$nulls":3},"Revenues","Units Sold",null,"Price","Unit Cost","Cost of Sales",null,"Gross Profit",{"$f":"LabelGP& \" %\"","v":"Gross Profit %"}]
[null,null,"Enter Data:",{"v":5000,"d":"$5,000"},null,null,{"v":30,"d":"$30.00"},{"v":25,"d":"$25.00"},{"v":4000,"d":"$4,000"},null,{"$f":"Revenues-Cost_of_Sales","v":{"v":1000,"d":"$1,000"}},{"$f":"IF(Revenues=0,0,Gross_Profit/Revenues)","v":{"v":0.2,"d":"20.00%"}}]
[null,null,"Breakeven Point:",{"$f":"IF( ISERROR(BreakevenQty*Price), \"     NA\", BreakevenQty*Price)","v":{"v":3000,"d":"$3,000"}},{"$f":"IF( (Price-Unit_Cost) = 0, \"NA\", AllocatedFixedCosts/(Price-Unit_Cost))","v":{"v":100,"d":"100.00"}},null,{"$f":"Price","v":{"v":30,"d":"$30.00"}},{"$f":"Unit_Cost","v":{"v":25,"d":"$25.00"}},{"$f":"IF( ISERROR(BreakevenQty*Unit_Cost), \"     NA\", BreakevenQty*Unit_Cost)","v":{"v":2500,"d":"$2,500"}},null,{"$f":"IF( ISERROR(BreakevenREV-BreakevenCOS), \"     NA\", BreakevenREV-BreakevenCOS)","v":{"v":500,"d":"$500"}},{"$f":"IF( ISERROR(BreakevenGP/BreakevenREV), \"     NA\", BreakevenGP/BreakevenREV)","v":{"v":0.16666666666666666,"d":"16.67%"}}]
{"$rows_empty":18}
[{"$nulls":10},"Value of Allocated Fixed Expenses:",null,{"$f":"D15","v":{"v":500,"d":"$500"}}]