{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Projected Income Statement"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":15,"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":"Projected Income Statement","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,8]]}
[]
[null,"Projected Income Statement",null,null,null,"Break-Even Analysis"]
[null,"Revenue",null,null,null,"Units","Revenue","Expenses","Income"]
[null,null,"Units Sold",27000,null,null,{"$f":"D6","v":810000},{"$f":"D20","v":1228000},{"$f":"D21","v":-418000}]
[null,null,"Price per Unit",30,null,10000,300000,1143000,-843000]
[null,null,"Total Revenue",{"$f":"Units_Sold * Price_per_Unit","v":810000},null,20000,600000,1193000,-593000]
[null,"Fixed Expenses",null,null,null,30000,900000,1243000,-343000]
[null,null,"Administrative",235000,null,40000,1200000,1293000,-93000]
[null,null,"Equipment",296000,null,50000,1500000,1343000,157000]
[null,null,"Advertising",167000,null,60000,1800000,1393000,407000]
[null,null,"Salary and Benefits",395000,null,70000,2100000,1443000,657000]
[null,null,"Total Fixed Expenses",{"$f":"SUM(D8:D11)","v":1093000},null,80000,2400000,1493000,907000]
[null,"Variable Expenses",null,null,null,90000,2700000,1543000,1157000]
[null,null,"Material Cost per Unit",2,null,100000,3000000,1593000,1407000]
[null,null,"Total Material Cost",{"$f":"D14 * D4","v":54000}]
[null,null,"Manufacturing Cost per Unit",3]
[null,null,"Total Manufacturing Cost",{"$f":"D16 * D4","v":81000}]
[null,null,"Total Variable Expenses",{"$f":"D15 + D17","v":135000}]
[null,"Summary"]
[null,null,"Total Expenses",{"$f":"D12 + D18","v":1228000}]
[null,null,"Operating Income",{"$f":" D6 - D20","v":-418000}]