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

{"sheet":"Manufacturing Overhead Budget","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"merged":[[23,1,23,8]]}
[]
[]
[null,"Manufacturing Overhead Budget"]
[null,"For the Year ended 12/31/2009"]
[]
[{"$nulls":3},"First","Second","Third","Fourth",null,"% of "]
[{"$nulls":3},"Quarter","Quarter","Quarter","Quarter","Totals","Total"]
[null,"Indirect Materials and Supplies",null,{"v":5800,"d":"$5,800"},{"v":5900,"d":"$5,900"},{"v":6000,"d":"$6,000"},{"v":7000,"d":"$7,000"},{"$f":"IF(SUM(D8:G8),SUM(D8:G8),\"\")","v":{"v":24700,"d":"$24,700"}},{"$f":"IF(SUM(H8),H8/$H$21,\"\")","v":{"v":0.10452814219212865,"d":"10.5%"}}]
[null,"Indirect Labor",null,{"v":12600,"d":"12,600 "},{"v":12600,"d":"12,600 "},{"v":12600,"d":"12,600 "},{"v":12600,"d":"12,600 "},{"v":50400,"d":"50,400 "},{"v":0.21328819297503174,"d":"21.3%"}]
[null,"Employee Benefits",null,{"v":7600,"d":"7,600 "},{"v":7600,"d":"7,600 "},{"v":7600,"d":"7,600 "},{"v":7600,"d":"7,600 "},{"v":30400,"d":"30,400 "},{"v":0.12865002115954297,"d":"12.9%"}]
[null,"Manufacturing Supervision",null,{"v":15000,"d":"15,000 "},{"v":15000,"d":"15,000 "},{"v":15000,"d":"15,000 "},{"v":15000,"d":"15,000 "},{"v":60000,"d":"60,000 "},{"v":0.25391451544646637,"d":"25.4%"}]
[null,"Utilities Costs",null,{"v":2900,"d":"2,900 "},{"v":2900,"d":"2,900 "},{"v":2900,"d":"2,900 "},{"v":2900,"d":"2,900 "},{"v":11600,"d":"11,600 "},{"v":0.0490901396529835,"d":"4.9%"}]
[null,"Small Tools",null,{"v":1200,"d":"1,200 "},{"v":1200,"d":"1,200 "},{"v":1200,"d":"1,200 "},{"v":1200,"d":"1,200 "},{"v":4800,"d":"4,800 "},{"v":0.02031316123571731,"d":"2.0%"}]
[null,"Property Taxes",null,{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":4000,"d":"4,000 "},{"v":0.016927634363097757,"d":"1.7%"}]
[null,"Insurance",null,{"v":1200,"d":"1,200 "},{"v":1200,"d":"1,200 "},{"v":1200,"d":"1,200 "},{"v":1200,"d":"1,200 "},{"v":4800,"d":"4,800 "},{"v":0.02031316123571731,"d":"2.0%"}]
[null,"Depreciation, Machinery",null,{"v":3100,"d":"3,100 "},{"v":3100,"d":"3,100 "},{"v":3100,"d":"3,100 "},{"v":3100,"d":"3,100 "},{"v":12400,"d":"12,400 "},{"v":0.052475666525603044,"d":"5.2%"}]
[null,"Factory Rent",null,{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":20000,"d":"20,000 "},{"v":0.08463817181548879,"d":"8.5%"}]
[null,"Repairs and Maintenance",null,{"v":3300,"d":"3,300 "},{"v":3300,"d":"3,300 "},{"v":3300,"d":"3,300 "},{"v":3300,"d":"3,300 "},{"v":13200,"d":"13,200 "},{"v":0.0558611933982226,"d":"5.6%"}]
[null,"Other",{"$nulls":5},"",""]
[null,"Other",{"$nulls":5},"",""]
[null,"Totals",null,{"$f":"IF(SUM(D8:D20),SUM(D8:D20),\"\")","v":{"v":58700,"d":"$58,700"}},{"$f":"IF(SUM(E8:E20),SUM(E8:E20),\"\")","v":{"v":58800,"d":"$58,800"}},{"$f":"IF(SUM(F8:F20),SUM(F8:F20),\"\")","v":{"v":58900,"d":"$58,900"}},{"$f":"IF(SUM(G8:G20),SUM(G8:G20),\"\")","v":{"v":59900,"d":"$59,900"}},{"v":236300,"d":"$236,300"},{"v":1,"d":"100.0%"}]