{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Department Expenses"],"not_rendered":{"external_links":1,"defined_names":15},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Department Expenses","index":0,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[1,2,1,5],[3,2,3,4]],"flags":["formulas_cached_only"]}
[]
[null,null,"Interdepartmental Reporting"]
[]
[null,null,"Model key                                                                                                                                                                                                                                      "]
[null,null,"White cells with text are fields that you can edit."]
[null,null,"Gray cells with bold text contain formulas that should not be changed."]
[]
[]
[null,null,"Department budget",{"v":550000,"d":"$550,000.00"}]
[null,null,"Department","Sales costs","Advertising costs","Shipping costs"]
[null,null,"Sales",{"v":12000,"d":"$12,000.00"}]
[null,null,"Cost of sales",{"v":7500,"d":"7,500.00"}]
[null,null,"Marketing",null,{"v":10000,"d":"10,000.00"}]
[null,null,"Shipping",null,null,{"v":8000,"d":"8,000.00"}]
[null,null,"Finance",{"v":36849,"d":"36,849.00"}]
[]
[null,null,"Totals",{"v":56349,"d":"$56,349.00"},{"v":10000,"d":"$10,000.00"},{"v":8000,"d":"$8,000.00"}]
[{"$nulls":3},"Total departmental costs",null,{"v":74349,"d":"$74,349.00"}]
[null,null,"Expenses"]
[null,null,"Travel",{"v":10500,"d":"$10,500.00"}]
[null,null,"Supplies",{"v":9000,"d":"9,000.00"}]
[null,null,"Salaries",{"v":120000,"d":"120,000.00"}]
[null,null,"Repairs",{"v":8000,"d":"8,000.00"}]
[]
[{"$nulls":3},"Total",null,{"v":147500,"d":"$147,500.00"}]
[]
[{"$nulls":3},"Total Expenses",null,{"v":147500,"d":"$147,500.00"}]
[]
[{"$nulls":3},"Total Costs and Expenses",null,{"v":221849,"d":"$221,849.00"}]
[]
[null,null,"Outstanding Budget",{"v":328151,"d":"$328,151.00"}]
[]
[null,null,"% of Budget Used:",{"v":0.40336181818181815,"d":"40%"}]