{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Break-Even Simple"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":42,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Break-Even Simple","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[45,2,45,12]]}
[]
[]
[]
[]
[null,null,"Sales Revenue",null,{"$f":"C5&\" \"&TEXT(G5,\"0.0%\")","v":"Sales Revenue 100.0%"},{"$f":"Revenues","v":5000},{"$f":"IF(Revenues=0,\"\",F5/Revenues)","v":1}]
[null,null,"Cost of Sales",null,{"$f":"C6&\" \"&TEXT(G6,\"0.0%\")","v":"Cost of Sales 80.0%"},{"$f":"Cost_of_Sales","v":4000},0.8]
[null,null,{"$f":"LabelGP","v":"Gross Profit"},null,{"$f":"C7&\" \n\"&TEXT(G7,\"0.0%\")","v":"Gross Profit \n20.0%"},{"$f":"Gross_Profit","v":1000},0.2]
[null,null,"Allocated Fixed Expenses",null,{"$f":"C8&\" \"&TEXT(G8,\"0.0%\")","v":"Allocated Fixed Expenses 10.0%"},{"$f":"AllocatedFixedCosts","v":500},0.1]
[null,null,"Income Before Tax",null,{"$f":"C9&\" \n\"&TEXT(G9,\"0.0%\")","v":"Income Before Tax \n10.0%"},{"$f":"F7-F8","v":500},0.1]
[null,null,"Income Taxes",100,{"$f":"C10&\" \n\"&TEXT(G10,\"0.0%\")","v":"Income Taxes \n2.0%"},null,{"$f":"IF(Revenues=0,\"\",D10/Revenues)","v":0.02}]
[null,null,"Net Income (Loss)",null,{"$f":"C11&\" \n\"&TEXT(G11,\"0.0%\")","v":"Net Income (Loss) \n8.0%"},{"$f":"F9-D10","v":400},0.08]
[]
[]
[null,null,null,null,"LastGoodSpinnerValue",69.759193420410156]
[null,null,"FixedOverhead",500,"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":166.66666666666666},{"$f":"2*E18","v":333.33333333333331},"quantity"]
[null,null,"Sales Revenue",{"$f":"Price*D18","v":0},{"$f":"Price*E18","v":5000},{"$f":"Price*F18","v":10000}]
[null,null,"Cost of Sales",{"$f":"Unit_Cost*D18+D21","v":500},{"$f":"Unit_Cost*E18+E21","v":4666.6666666666661},{"$f":"Unit_Cost*F18+F21","v":8833.3333333333321}]
[null,null,"Fixed Expenses",{"$f":"AllocatedFixedCosts","v":500},{"$f":"AllocatedFixedCosts","v":500},{"$f":"AllocatedFixedCosts","v":500}]
[]
[null,null,null,"Revenues","Units Sold",null,"Price","Unit Cost","Cost of Sales",null,"Gross Profit",{"$f":"LabelGP& \" %\"","v":"Gross Profit %"}]
[null,null,"Enter Data:",5000,null,null,30,25,4000,null,{"$f":"Revenues-Cost_of_Sales","v":1000},{"$f":"IF(Revenues=0,0,Gross_Profit/Revenues)","v":0.2}]
[null,null,"Breakeven Point:",{"$f":"IF( ISERROR(BreakevenQty*Price), \"     NA\", BreakevenQty*Price)","v":3000},{"$f":"IF( (Price-Unit_Cost) = 0, \"NA\", AllocatedFixedCosts/(Price-Unit_Cost))","v":100},null,{"$f":"Price","v":30},{"$f":"Unit_Cost","v":25},{"$f":"IF( ISERROR(BreakevenQty*Unit_Cost), \"     NA\", BreakevenQty*Unit_Cost)","v":2500},null,{"$f":"IF( ISERROR(BreakevenREV-BreakevenCOS), \"     NA\", BreakevenREV-BreakevenCOS)","v":500},{"$f":"IF( ISERROR(BreakevenGP/BreakevenREV), \"     NA\", BreakevenGP/BreakevenREV)","v":0.16666666666666666}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Value of Allocated Fixed Expenses:",null,{"$f":"D15","v":500}]