{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Quarterly Budget Analysis"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Quarterly Budget Analysis","index":0,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[49,1,49,7]]}
[]
[]
[null,"Quarterly Budget Analysis"]
[]
[null,{"$f":"NOW()","v":"2010-04-19T17:44:28.430"}]
[null,"XYZ Manufacturing, Inc."]
[]
[null,"For the Quarter Ending:","2010-03-31"]
[]
[null,null,"This Quarter",null,null,"Year-to-Date"]
[null,"Budget Item","Budget","Actual","Variance","Budget","Actual","Variance"]
[null,"Sales Revenue",{"v":500000,"d":"$500,000"},{"v":550000,"d":"$550,000"},{"$f":"IF(SUM(C12:D12),D12-C12,\"\")","v":{"v":50000,"d":"$50,000"}},{"v":1000000,"d":"$1,000,000"},{"v":1200000,"d":"$1,200,000"},{"$f":"IF(SUM(F12:G12),G12-F12,\"\")","v":{"v":200000,"d":"$200,000"}}]
[null,"Cost of sales",{"v":300000,"d":"300,000 "},{"v":320000,"d":"320,000 "},{"$f":"IF(SUM(C13:D13),D13-C13,\"\")","v":{"v":20000,"d":"20,000 "}},{"v":600000,"d":"600,000 "},{"v":640000,"d":"640,000 "},{"$f":"IF(SUM(F13:G13),G13-F13,\"\")","v":{"v":40000,"d":"40,000 "}}]
[null,"Gross Profits",{"$f":"IF(SUM(C12:C13),C12-C13,\"\")","v":{"v":200000,"d":"$200,000"}},{"$f":"IF(SUM(D12:D13),D12-D13,\"\")","v":{"v":230000,"d":"$230,000"}},{"$f":"IF(SUM(C14:D14),D14-C14,\"\")","v":{"v":30000,"d":"$30,000"}},{"$f":"IF(SUM(F12:F13),F12-F13,\"\")","v":{"v":400000,"d":"$400,000"}},{"$f":"IF(SUM(G12:G13),G12-G13,\"\")","v":{"v":560000,"d":"$560,000"}},{"$f":"IF(SUM(F14:G14),G14-F14,\"\")","v":{"v":160000,"d":"$160,000"}}]
[null,"Variable Expenses"]
[null,"Selling Expenses",{"v":100000,"d":"$100,000"},{"v":120000,"d":"$120,000"},{"$f":"IF(SUM(C16:D16),D16-C16,\"\")","v":{"v":20000,"d":"$20,000"}},{"v":200000,"d":"$200,000"},{"v":240000,"d":"$240,000"},{"$f":"IF(SUM(F16:G16),G16-F16,\"\")","v":{"v":40000,"d":"$40,000"}}]
[null,"Inspection ",{"v":10000,"d":"10,000 "},{"v":8000,"d":"8,000 "},{"v":-2000,"d":"(2,000)"},{"v":20000,"d":"20,000 "},{"v":16000,"d":"16,000 "},{"v":-4000,"d":"(4,000)"}]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[null,"Total Variable Expenses",{"$f":"IF(SUM(C16:C24),SUM(C16:C24),\"\")","v":{"v":110000,"d":"$110,000"}},{"v":128000,"d":"$128,000"},{"v":18000,"d":"$18,000"},{"v":220000,"d":"$220,000"},{"v":256000,"d":"$256,000"},{"v":36000,"d":"$36,000"}]
[null,"Fixed Expenses"]
[null,"Rent",{"v":60000,"d":"$60,000"},{"v":70000,"d":"$70,000"},{"$f":"IF(SUM(C27:D27),D27-C27,\"\")","v":{"v":10000,"d":"$10,000"}},{"v":120000,"d":"$120,000"},{"v":150000,"d":"$150,000"},{"$f":"IF(SUM(F27:G27),G27-F27,\"\")","v":{"v":30000,"d":"$30,000"}}]
[null,"Depreciation",{"v":20000,"d":"20,000 "},{"v":19000,"d":"19,000 "},{"v":-1000,"d":"(1,000)"},{"v":40000,"d":"40,000 "},{"v":38000,"d":"38,000 "},{"v":-2000,"d":"(2,000)"}]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[{"$nulls":4},"",null,null,""]
[null,"Total Fixed Expenses",{"$f":"IF(SUM(C6:C27),SUM(C27:C35),\"\")","v":{"v":80000,"d":"$80,000"}},{"$f":"IF(SUM(D6:D27),SUM(D27:D35),\"\")","v":{"v":89000,"d":"$89,000"}},{"v":9000,"d":"$9,000"},{"$f":"IF(SUM(F6:F27),SUM(F27:F35),\"\")","v":{"v":160000,"d":"$160,000"}},{"$f":"IF(SUM(G6:G27),SUM(G27:G35),\"\")","v":{"v":188000,"d":"$188,000"}},{"v":28000,"d":"$28,000"}]
[null,"Income From Operations",{"$f":"IF(SUM(C14,C25,C36),C14-C25-C36,\"\")","v":{"v":10000,"d":"$10,000"}},{"v":13000,"d":"$13,000"},{"v":3000,"d":"$3,000"},{"v":20000,"d":"$20,000"},{"v":116000,"d":"$116,000"},{"v":96000,"d":"$96,000"}]
[null,"Interest Income",{"v":2000,"d":"2,000 "},{"v":3000,"d":"3,000 "},{"$f":"IF(SUM(C38:D38),D38-C38,\"\")","v":{"v":1000,"d":"1,000 "}},{"v":4000,"d":"4,000 "},{"v":6000,"d":"6,000 "},{"$f":"IF(SUM(F38:G38),G38-F38,\"\")","v":{"v":2000,"d":"2,000 "}}]
[null,"Interest Expense",{"v":1000,"d":"1,000 "},{"v":1500,"d":"1,500 "},{"$f":"IF(SUM(C39:D39),D39-C39,\"\")","v":{"v":500,"d":"500 "}},{"v":2000,"d":"2,000 "},{"v":3000,"d":"3,000 "},{"$f":"IF(SUM(F39:G39),G39-F39,\"\")","v":{"v":1000,"d":"1,000 "}}]
[null,"Net Income Before Taxes",{"$f":"IF(SUM(C37:C39),C37-SUM(C38:C39),\"\")","v":{"v":7000,"d":"$7,000"}},{"$f":"IF(SUM(D37:D39),D37-SUM(D38:D39),\"\")","v":{"v":8500,"d":"$8,500"}},{"$f":"IF(SUM(C40:D40),D40-C40,\"\")","v":{"v":1500,"d":"$1,500"}},{"$f":"IF(SUM(F37:F39),F37-SUM(F38:F39),\"\")","v":{"v":14000,"d":"$14,000"}},{"$f":"IF(SUM(G37:G39),G37-SUM(G38:G39),\"\")","v":{"v":107000,"d":"$107,000"}},{"$f":"IF(SUM(F40:G40),G40-F40,\"\")","v":{"v":93000,"d":"$93,000"}}]
[null,"Taxes",{"v":2000,"d":"2,000 "},{"v":1500,"d":"1,500 "},{"$f":"IF(SUM(C41:D41),D41-C41,\"\")","v":{"v":-500,"d":"(500)"}},{"v":4000,"d":"4,000 "},{"v":3000,"d":"3,000 "},{"$f":"IF(SUM(F41:G41),G41-F41,\"\")","v":{"v":-1000,"d":"(1,000)"}}]
[null,"Net Income After Taxes",{"$f":"IF(SUM(C40:C41),C40-C41,\"\")","v":{"v":5000,"d":"$5,000"}},{"$f":"IF(SUM(D40:D41),D40-D41,\"\")","v":{"v":7000,"d":"$7,000"}},{"$f":"IF(SUM(C42:D42),D42-C42,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(F40:F41),F40-F41,\"\")","v":{"v":10000,"d":"$10,000"}},{"$f":"IF(SUM(G40:G41),G40-G41,\"\")","v":{"v":104000,"d":"$104,000"}},{"$f":"IF(SUM(F42:G42),G42-F42,\"\")","v":{"v":94000,"d":"$94,000"}}]
[]
[null,"Non-Income Statement Items"]
[null,"Loan Repayments",{"v":14000,"d":"14,000 "},{"v":13000,"d":"13,000 "},{"$f":"IF(SUM(C45:D45),D45-C45,\"\")","v":{"v":-1000,"d":"(1,000)"}},{"v":28000,"d":"28,000 "},{"v":26000,"d":"26,000 "},{"$f":"IF(SUM(F45:G45),G45-F45,\"\")","v":{"v":-2000,"d":"(2,000)"}}]
[null,"Owner Withdrawals (or dividends)",{"v":20000,"d":"20,000 "},{"v":25000,"d":"25,000 "},{"$f":"IF(SUM(C46:D46),D46-C46,\"\")","v":{"v":5000,"d":"5,000 "}},{"v":20000,"d":"20,000 "},{"v":25000,"d":"25,000 "},{"$f":"IF(SUM(F46:G46),G46-F46,\"\")","v":{"v":5000,"d":"5,000 "}}]
[null,"Fixed Asset Expenditures",{"v":100000,"d":"100,000 "},{"v":90000,"d":"90,000 "},{"$f":"IF(SUM(C47:D47),D47-C47,\"\")","v":{"v":-10000,"d":"(10,000)"}},{"v":100000,"d":"100,000 "},{"v":90000,"d":"90,000 "},{"$f":"IF(SUM(F47:G47),G47-F47,\"\")","v":{"v":-10000,"d":"(10,000)"}}]