{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Budget","Summary","Adm. Expenses","Service Expenses","Income Details","Selling Expense","Module1"],"not_rendered":{"charts":5,"defined_names":39,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":57,"n_cols":12,"rows_kept":57,"merged":[[58,3,58,8]]}
[]
[]
[{"$nulls":8},"BUSINESS BUDGET",null,null,"This column contains labels used by the"]
[{"$nulls":7},"Month/Year:",{"$f":"NOW()","v":"2010-04-19T20:27:14.440"},null,null,"template's five charts. They will not "]
[{"$nulls":11},"be included when you print this sheet."]
[]
[{"$nulls":3}," SUMMARY","ACTUAL","BUDGETED","OVER BUDGET","UNDER BUDGET"]
[{"$nulls":3}," Total income",{"$f":"E20","v":{"v":1432500,"d":"1,432,500.00"}},{"$f":"F20","v":{"v":1318080,"d":"1,318,080.00"}},{"$f":"IF(E8-F8>0,E8-F8,\"\")","v":{"v":114420,"d":"114,420.00"}},{"$f":"IF(E8-F8<0,E8-F8,\"\")","v":""},{"$nulls":3},"Total Income"]
[{"$nulls":3}," Total expenses",{"$f":"IF(E31+E46+E56,E31+E46+E56,\"\")","v":{"v":339760,"d":"339,760.00"}},{"$f":"IF(F31+F46+F56,F31+F46+F68,\"\")","v":{"v":314910,"d":"314,910.00"}},{"$f":"IF(E9-F9>0,E9-F9,\"\")","v":{"v":24850,"d":"24,850.00"}},{"$f":"IF(E9-F9<0,E9-F9,\"\")","v":""},{"$nulls":3},"Total Expenses"]
[{"$nulls":3}," Income less expenses:",{"$f":"IF(E8-E9,E8-E9,\"\")","v":{"v":1092740,"d":"1,092,740.00"}},{"$f":"IF(F8-F9,F8-F9,\"\")","v":{"v":1003170,"d":"1,003,170.00"}},{"$f":"IF(E10-F10>0,E10-F10,\"\")","v":{"v":89570,"d":"89,570.00"}},{"$f":"IF(E10-F10<0,E10-F10,\"\")","v":""}]
[]
[{"$nulls":3}," INCOME DETAILS","ACTUAL","BUDGETED","OVER BUDGET","UNDER BUDGET","NOTES"]
[{"$nulls":3}," Sales",{"v":1400000,"d":"1,400,000.00"},{"v":1200000,"d":"1,200,000.00"},{"$f":"IF(E13-F13>0,E13-F13,\"\")","v":{"v":200000,"d":"200,000.00"}},{"$f":"IF(E13-F13<0,E13-F13,\"\")","v":""},"Increase advertising next year.",null,null,"Sales"]
[{"$nulls":3}," Interest earned",{"v":5000,"d":"5,000.00"},{"v":4500,"d":"4,500.00"},{"v":500,"d":"500.00"},"",{"$nulls":3},"Interest"]
[{"$nulls":3}," Fees",{"v":1000,"d":"1,000.00"},{"v":980,"d":"980.00"},{"v":20,"d":"20.00"},"",{"$nulls":3},"Fees"]
[{"$nulls":3}," Commissions",{"v":10000,"d":"10,000.00"},{"v":98000,"d":"98,000.00"},"",{"v":-88000,"d":"-88,000.00"},{"$nulls":3},"Commissions"]
[{"$nulls":3}," Rent",{"v":9000,"d":"9,000.00"},{"v":8000,"d":"8,000.00"},{"v":1000,"d":"1,000.00"},"",{"$nulls":3},"Rent"]
[{"$nulls":3}," Royalties",{"v":2500,"d":"2,500.00"},{"v":2600,"d":"2,600.00"},"",{"v":-100,"d":"-100.00"},{"$nulls":3},"Royalties"]
[{"$nulls":3}," Other",{"v":5000,"d":"5,000.00"},{"v":4000,"d":"4,000.00"},{"v":1000,"d":"1,000.00"},"",{"$nulls":3},"Other"]
[{"$nulls":3}," Total income:",{"$f":"IF(SUM(E13:E19),SUM(E13:E19),\"\")","v":{"v":1432500,"d":"1,432,500.00"}},{"$f":"IF(SUM(F13:F19),SUM(F13:F19),\"\")","v":{"v":1318080,"d":"1,318,080.00"}},{"v":114420,"d":"114,420.00"},""]
[]
[{"$nulls":3}," EXPENSE DETAILS","ACTUAL","BUDGETED","OVER BUDGET","UNDER BUDGET","NOTES"]
[{"$nulls":3}," SELLING"]
[{"$nulls":3}," Salaries and wages",{"v":246000,"d":"246,000.00"},{"v":248000,"d":"248,000.00"},{"$f":"IF(E24-F24>0,E24-F24,\"\")","v":""},{"$f":"IF(E24-F24<0,E24-F24,\"\")","v":{"v":-2000,"d":"-2,000.00"}},{"$nulls":3},"Salaries"]
[{"$nulls":3}," Commissions",{"v":10000,"d":"10,000.00"},{"v":12000,"d":"12,000.00"},"",{"v":-2000,"d":"-2,000.00"},{"$nulls":3},"Commissions"]
[{"$nulls":3}," Advertising",{"v":6000,"d":"6,000.00"},{"v":8000,"d":"8,000.00"},"",{"v":-2000,"d":"-2,000.00"},"Increase Here 3%.",null,null,"Advertising"]
[{"$nulls":3}," Delivery",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Delivery"]
[{"$nulls":3}," Shipping",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Shipping"]
[{"$nulls":3}," Travel",{"v":4600,"d":"4,600.00"},{"v":5600,"d":"5,600.00"},"",{"v":-1000,"d":"-1,000.00"},{"$nulls":3},"Travel"]
[{"$nulls":3}," Other",{"v":1000,"d":"1,000.00"},{"v":1200,"d":"1,200.00"},"",{"v":-200,"d":"-200.00"},{"$nulls":3},"Other"]
[{"$nulls":3}," Total sales expenses:",{"$f":"IF(SUM(E24:E30),SUM(E24:E30),\"\")","v":{"v":267600,"d":"267,600.00"}},{"$f":"IF(SUM(F24:F30),SUM(F24:F30),\"\")","v":{"v":274800,"d":"274,800.00"}},"",{"v":-7200,"d":"-7,200.00"}]
[{"$nulls":3}," Percent of total:",{"$f":"IF(E9,E31/E9,\"\")","v":{"v":0.7876147869084059,"d":"78.76%"}},{"$f":"IF(F9,F31/F9,\"\")","v":{"v":0.8726302753167572,"d":"87.26%"}}]
[{"$nulls":3}," ADMINISTRATIVE"]
[{"$nulls":3}," Salaries and wages",{"v":12000,"d":"12,000.00"},{"v":10000,"d":"10,000.00"},{"$f":"IF(E34-F34>0,E34-F34,\"\")","v":{"v":2000,"d":"2,000.00"}},{"$f":"IF(E34-F34<0,E34-F34,\"\")","v":""},{"$nulls":3},"Salaries"]
[{"$nulls":3}," Employee benefits",{"v":5000,"d":"5,000.00"},{"v":6000,"d":"6,000.00"},"",{"v":-1000,"d":"-1,000.00"},{"$nulls":3},"Benefits"]
[{"$nulls":3}," Payroll taxes",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},"","",{"$nulls":3},"Payroll"]
[{"$nulls":3}," Insurance",{"v":14000,"d":"14,000.00"},{"v":14000,"d":"14,000.00"},"","",{"$nulls":3},"Insurance"]
[{"$nulls":3}," Loans",{"v":6000,"d":"6,000.00"},{"v":5000,"d":"5,000.00"},{"v":1000,"d":"1,000.00"},"",{"$nulls":3},"Loans"]
[{"$nulls":3}," Office supplies",{"v":4000,"d":"4,000.00"},{"v":4100,"d":"4,100.00"},"",{"v":-100,"d":"-100.00"},{"$nulls":3},"Supplies"]
[{"$nulls":3}," Travel & entertainment",{"v":200,"d":"200.00"},{"v":190,"d":"190.00"},{"v":10,"d":"10.00"},"",{"$nulls":3},"Travel"]
[{"$nulls":3}," Postage",{"v":300,"d":"300.00"},{"v":320,"d":"320.00"},"",{"v":-20,"d":"-20.00"},{"$nulls":3},"Postage"]
[{"$nulls":3}," Furnishings",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Furnish"]
[{"$nulls":3}," Contributions",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Contribute"]
[{"$nulls":3}," Dues",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Dues"]
[{"$nulls":3}," Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Other"]
[{"$nulls":3}," Total admin. expenses:",{"$f":"IF(SUM(E34:E45),SUM(E34:E45),\"\")","v":{"v":42000,"d":"42,000.00"}},{"$f":"IF(SUM(F34:F45),SUM(F34:F45),\"\")","v":{"v":40110,"d":"40,110.00"}},{"v":1890,"d":"1,890.00"},""]
[{"$nulls":3}," Percent of total:",{"$f":"IF(E9,E46/E9,\"\")","v":{"v":0.12361667059100541,"d":"12.36%"}},{"$f":"IF(F9,F46/F9,\"\")","v":{"v":0.12736972468324284,"d":"12.74%"}}]
[{"$nulls":3}," SERVICE & EQUIPMENT"]
[{"$nulls":3}," Accounting",{"v":1200,"d":"1,200.00"},{"v":1500,"d":"1,500.00"},{"$f":"IF(E49-F49>0,E49-F49,\"\")","v":""},{"$f":"IF(E49-F49<0,E49-F49,\"\")","v":{"v":-300,"d":"-300.00"}},{"$nulls":3},"Accounting"]
[{"$nulls":3}," Legal",{"v":5000,"d":"5,000.00"},{"v":6000,"d":"6,000.00"},"",{"v":-1000,"d":"-1,000.00"},{"$nulls":3},"Legal"]
[{"$nulls":3}," Utilities",{"v":15000,"d":"15,000.00"},{"v":15789,"d":"15,789.00"},"",{"v":-789,"d":"-789.00"},"Too high.",null,null,"Utilities"]
[{"$nulls":3}," Telephone",{"v":5000,"d":"5,000.00"},{"v":4800,"d":"4,800.00"},{"v":200,"d":"200.00"},"",{"$nulls":3},"Telephone"]
[{"$nulls":3}," Equipment purchases",{"v":3400,"d":"3,400.00"},{"v":3000,"d":"3,000.00"},{"v":400,"d":"400.00"},"",{"$nulls":3},"Equipment"]
[{"$nulls":3}," Rent & maintenance",{"v":560,"d":"560.00"},{"v":600,"d":"600.00"},"",{"v":-40,"d":"-40.00"},{"$nulls":3},"Rentals"]
[{"$nulls":3}," Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","",{"$nulls":3},"Other"]
[{"$nulls":3}," Total S&E expenses:",{"$f":"IF(SUM(E49:E55),SUM(E49:E55),\"\")","v":{"v":30160,"d":"30,160.00"}},{"$f":"IF(SUM(F49:F55),SUM(F49:F55),\"\")","v":{"v":31689,"d":"31,689.00"}},"",{"v":-1529,"d":"-1,529.00"}]
[{"$nulls":3}," Percent of total:",{"$f":"IF(E9,E56/E9,\"\")","v":{"v":0.08876854250058865,"d":"0.09"}},{"$f":"IF(E9,F56/F9,\"\")","v":{"v":0.10062875107173479,"d":"0.10"}}]

{"sheet":"Summary","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[25,2,25,10]]}

{"sheet":"Adm. Expenses","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[25,2,25,10]]}

{"sheet":"Service Expenses","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[25,2,25,10]]}

{"sheet":"Income Details","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[25,2,25,10]]}

{"sheet":"Selling Expense","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[25,2,25,10]]}

{"sheet":"Module1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}