{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Budget-5 Profit Centers"],"not_rendered":{"defined_names":24,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget-5 Profit Centers","index":0,"n_rows":57,"n_cols":21,"rows_kept":57,"merged":[[58,1,58,20]]}
[null,"POINT HERE FIRST"]
["ANNUAL BUDGET FORECAST - 5 PROFIT CENTERS"]
["Site","Operating Exp","Month","Month","Month","Q1","Month","Month","Month","Q2","S1","Month","Month","Month","Q3","Month","Month","Month","Q4","S2","Year"]
[null,null,1,2,3,null,4,5,6,null,null,7,8,9,null,10,11,12]
["Site 1",null,{"$f":"SUM(C6:C11)","v":{"v":31175,"d":"$31,175"}},{"v":30675,"d":"$30,675"},{"v":31175,"d":"$31,175"},{"v":93025,"d":"$93,025"},{"v":31175,"d":"$31,175"},{"v":32075,"d":"$32,075"},{"v":34375,"d":"$34,375"},{"v":97625,"d":"$97,625"},{"v":190650,"d":"$190,650"},{"v":34175,"d":"$34,175"},{"v":34150,"d":"$34,150"},{"v":34775,"d":"$34,775"},{"v":103100,"d":"$103,100"},{"v":34675,"d":"$34,675"},{"v":35575,"d":"$35,575"},{"v":35575,"d":"$35,575"},{"v":105825,"d":"$105,825"},{"v":208925,"d":"$208,925"},{"v":399575,"d":"$399,575"}]
[null,"Salaries",10000,10000,10000,{"$f":"SUM(C6:E6)","v":30000},10000,10000,13000,{"$f":"SUM(G6:I6)","v":33000},{"$f":"J6+F6","v":63000},12000,12000,12000,{"$f":"SUM(L6:N6)","v":36000},12000,12000,12000,{"$f":"SUM(P6:R6)","v":36000},{"$f":"S6+O6","v":72000},{"$f":"T6+K6","v":135000}]
[null,"Supplies",3000,2500,3000,8500,2500,3000,2500,8000,16500,3300,2800,3300,9400,2800,3300,2800,8900,18300,34800]
[null,"Equipment",4575,4575,4575,13725,4575,4575,4575,13725,27450,4575,4575,4575,13725,4575,4575,4575,13725,27450,54900]
[null,"Lease Pmts",9600,9600,9600,28800,9600,9600,9600,28800,57600,9600,9600,9600,28800,9600,9600,9600,28800,57600,115200]
[null,"Advertising",2500,2500,2500,7500,2500,2500,2500,7500,15000,2500,2500,2500,7500,2500,2500,2500,7500,15000,30000]
[null,"Other",1500,1500,1500,4500,2000,2400,2200,6600,11100,2200,2675,2800,7675,3200,3600,4100,10900,18575,29675]
[]
[]
["Site 2",null,{"$f":"SUM(C15:C20)","v":{"v":29700,"d":"$29,700"}},{"v":29700,"d":"$29,700"},{"v":29700,"d":"$29,700"},{"v":89100,"d":"$89,100"},{"v":30200,"d":"$30,200"},{"v":25800,"d":"$25,800"},{"v":28100,"d":"$28,100"},{"v":84100,"d":"$84,100"},{"v":173200,"d":"$173,200"},{"v":25100,"d":"$25,100"},{"v":25575,"d":"$25,575"},{"v":25700,"d":"$25,700"},{"v":76375,"d":"$76,375"},{"v":26100,"d":"$26,100"},{"v":27000,"d":"$27,000"},{"v":27500,"d":"$27,500"},{"v":80600,"d":"$80,600"},{"v":156975,"d":"$156,975"},{"v":330175,"d":"$330,175"}]
[null,"Salaries",7500,7500,7500,{"$f":"SUM(C15:E15)","v":22500},7500,7500,10000,{"$f":"SUM(G15:I15)","v":25000},{"$f":"J15+F15","v":47500},7500,7500,7500,{"$f":"SUM(L15:N15)","v":22500},7500,7500,7500,{"$f":"SUM(P15:R15)","v":22500},{"$f":"S15+O15","v":45000},{"$f":"T15+K15","v":92500}]
[null,"Supplies",2000,2000,2000,6000,2000,2000,2000,6000,12000,2000,2000,2000,6000,2000,2500,2500,7000,13000,25000]
[null,"Equipment",8000,8000,8000,24000,8000,2700,2700,13400,37400,2700,2700,2700,8100,2700,2700,2700,8100,16200,53600]
[null,"Lease Pmts",8200,8200,8200,24600,8200,8200,8200,24600,49200,8200,8200,8200,24600,8200,8200,8200,24600,49200,98400]
[null,"Advertising",2500,2500,2500,7500,2500,3000,3000,8500,16000,2500,2500,2500,7500,2500,2500,2500,7500,15000,31000]
[null,"Other",1500,1500,1500,4500,2000,2400,2200,6600,11100,2200,2675,2800,7675,3200,3600,4100,10900,18575,29675]
[]
[]
["Site 3",null,{"$f":"SUM(C24:C29)","v":{"v":56000,"d":"$56,000"}},{"v":56000,"d":"$56,000"},{"v":56000,"d":"$56,000"},{"v":168000,"d":"$168,000"},{"v":60000,"d":"$60,000"},{"v":60900,"d":"$60,900"},{"v":65700,"d":"$65,700"},{"v":186600,"d":"$186,600"},{"v":354600,"d":"$354,600"},{"v":60700,"d":"$60,700"},{"v":61175,"d":"$61,175"},{"v":61300,"d":"$61,300"},{"v":183175,"d":"$183,175"},{"v":61700,"d":"$61,700"},{"v":62100,"d":"$62,100"},{"v":62600,"d":"$62,600"},{"v":186400,"d":"$186,400"},{"v":369575,"d":"$369,575"},{"v":724175,"d":"$724,175"}]
[null,"Salaries",20000,20000,20000,{"$f":"SUM(C24:E24)","v":60000},22000,22000,27000,{"$f":"SUM(G24:I24)","v":71000},{"$f":"J24+F24","v":131000},22000,22000,22000,{"$f":"SUM(L24:N24)","v":66000},22000,22000,22000,{"$f":"SUM(P24:R24)","v":66000},{"$f":"S24+O24","v":132000},{"$f":"T24+K24","v":263000}]
[null,"Supplies",5000,5000,5000,15000,5000,5000,5000,15000,30000,5000,5000,5000,15000,5000,5000,5000,15000,30000,60000]
[null,"Equipment",9500,9500,9500,28500,11000,11000,11000,33000,61500,11000,11000,11000,33000,11000,11000,11000,33000,66000,127500]
[null,"Lease Pmts",17000,17000,17000,51000,17000,17000,17000,51000,102000,17000,17000,17000,51000,17000,17000,17000,51000,102000,204000]
[null,"Advertising",3000,3000,3000,9000,3000,3500,3500,10000,19000,3500,3500,3500,10500,3500,3500,3500,10500,21000,40000]
[null,"Other",1500,1500,1500,4500,2000,2400,2200,6600,11100,2200,2675,2800,7675,3200,3600,4100,10900,18575,29675]
[]
[]
["Site 4",null,{"$f":"SUM(C33:C38)","v":{"v":28500,"d":"$28,500"}},{"v":28750,"d":"$28,750"},{"v":28750,"d":"$28,750"},{"v":86000,"d":"$86,000"},{"v":29250,"d":"$29,250"},{"v":29650,"d":"$29,650"},{"v":30100,"d":"$30,100"},{"v":89000,"d":"$89,000"},{"v":175000,"d":"$175,000"},{"v":29450,"d":"$29,450"},{"v":29925,"d":"$29,925"},{"v":30050,"d":"$30,050"},{"v":89425,"d":"$89,425"},{"v":30450,"d":"$30,450"},{"v":30850,"d":"$30,850"},{"v":31350,"d":"$31,350"},{"v":92650,"d":"$92,650"},{"v":182075,"d":"$182,075"},{"v":357075,"d":"$357,075"}]
[null,"Salaries",7700,7700,7700,{"$f":"SUM(C33:E33)","v":23100},7700,7700,8350,{"$f":"SUM(G33:I33)","v":23750},{"$f":"J33+F33","v":46850},7700,7700,7700,{"$f":"SUM(L33:N33)","v":23100},7700,7700,7700,{"$f":"SUM(P33:R33)","v":23100},{"$f":"S33+O33","v":46200},{"$f":"T33+K33","v":93050}]
[null,"Supplies",2100,2350,2350,6800,2350,2350,2350,7050,13850,2350,2350,2350,7050,2350,2350,2350,7050,14100,27950]
[null,"Equipment",6500,6500,6500,19500,6500,6500,6500,19500,39000,6500,6500,6500,19500,6500,6500,6500,19500,39000,78000]
[null,"Lease Pmts",8500,8500,8500,25500,8500,8500,8500,25500,51000,8500,8500,8500,25500,8500,8500,8500,25500,51000,102000]
[null,"Advertising",2200,2200,2200,6600,2200,2200,2200,6600,13200,2200,2200,2200,6600,2200,2200,2200,6600,13200,26400]
[null,"Other",1500,1500,1500,4500,2000,2400,2200,6600,11100,2200,2675,2800,7675,3200,3600,4100,10900,18575,29675]
[]
[]
["Site 5",null,{"$f":"SUM(C42:C47)","v":{"v":74450,"d":"$74,450"}},{"v":74450,"d":"$74,450"},{"v":74450,"d":"$74,450"},{"v":223350,"d":"$223,350"},{"v":76500,"d":"$76,500"},{"v":76900,"d":"$76,900"},{"v":80700,"d":"$80,700"},{"v":234100,"d":"$234,100"},{"v":457450,"d":"$457,450"},{"v":77625,"d":"$77,625"},{"v":80200,"d":"$80,200"},{"v":80325,"d":"$80,325"},{"v":238150,"d":"$238,150"},{"v":80800,"d":"$80,800"},{"v":81200,"d":"$81,200"},{"v":81700,"d":"$81,700"},{"v":243700,"d":"$243,700"},{"v":481850,"d":"$481,850"},{"v":939300,"d":"$939,300"}]
[null,"Salaries",31500,31500,31500,{"$f":"SUM(C42:E42)","v":94500},33000,33000,37000,{"$f":"SUM(G42:I42)","v":103000},{"$f":"J42+F42","v":197500},33000,35100,35100,{"$f":"SUM(L42:N42)","v":103200},35100,35100,35100,{"$f":"SUM(P42:R42)","v":105300},{"$f":"S42+O42","v":208500},{"$f":"T42+K42","v":406000}]
[null,"Supplies",7450,7450,7450,22350,7450,7450,7450,22350,44700,8200,8200,8200,24600,8200,8200,8200,24600,49200,93900]
[null,"Equipment",8000,8000,8000,24000,8000,8000,8000,24000,48000,8100,8100,8100,24300,8100,8100,8100,24300,48600,96600]
[null,"Lease Pmts",23550,23550,23550,70650,23550,23550,23550,70650,141300,23550,23550,23550,70650,23550,23550,23550,70650,141300,282600]
[null,"Advertising",2450,2450,2450,7350,2500,2500,2500,7500,14850,2575,2575,2575,7725,2650,2650,2650,7950,15675,30525]
[null,"Other",1500,1500,1500,4500,2000,2400,2200,6600,11100,2200,2675,2800,7675,3200,3600,4100,10900,18575,29675]
[]
[]
[]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C52:C57)","v":{"v":219825,"d":"$219,825"}},{"v":219575,"d":"$219,575"},{"v":220075,"d":"$220,075"},{"v":659475,"d":"$659,475"},{"v":227125,"d":"$227,125"},{"v":225325,"d":"$225,325"},{"v":238975,"d":"$238,975"},{"v":691425,"d":"$691,425"},{"v":1350900,"d":"$1,350,900"},{"v":227050,"d":"$227,050"},{"v":231025,"d":"$231,025"},{"v":232150,"d":"$232,150"},{"v":690225,"d":"$690,225"},{"v":233725,"d":"$233,725"},{"v":236725,"d":"$236,725"},{"v":238725,"d":"$238,725"},{"v":709175,"d":"$709,175"},{"v":1399400,"d":"$1,399,400"},{"v":2750300,"d":"$2,750,300"}]
[null,"Salaries",{"$f":"C42+C33+C24+C15+C6","v":76700},76700,76700,{"$f":"SUM(C52:E52)","v":230100},{"$f":"G42+G33+G24+G15+G6","v":80200},80200,95350,{"$f":"SUM(G52:I52)","v":255750},{"$f":"J52+F52","v":485850},{"$f":"L42+L33+L24+L15+L6","v":82200},84300,84300,{"$f":"SUM(L52:N52)","v":250800},{"$f":"P42+P33+P24+P15+P6","v":84300},84300,84300,{"$f":"SUM(P52:R52)","v":252900},{"$f":"S52+O52","v":503700},{"$f":"T52+K52","v":989550}]
[null,"Supplies",19550,19300,19800,58650,19300,19800,19300,58400,117050,20850,20350,20850,62050,20350,21350,20850,62550,124600,241650]
[null,"Equipment",36575,36575,36575,109725,38075,32775,32775,103625,213350,32875,32875,32875,98625,32875,32875,32875,98625,197250,410600]
[null,"Lease Pmts",66850,66850,66850,200550,66850,66850,66850,200550,401100,66850,66850,66850,200550,66850,66850,66850,200550,401100,802200]
[null,"Advertising",12650,12650,12650,37950,12700,13700,13700,40100,78050,13275,13275,13275,39825,13350,13350,13350,40050,79875,157925]
[null,"Other",7500,7500,7500,22500,10000,12000,11000,33000,55500,11000,13375,14000,38375,16000,18000,20500,54500,92875,148375]