{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["19.20 Prelim  4.10.2019","Website Copy","19.20 Operating","Sheet1","Qtr 1","Qtr 2","Qtr 3","Qtr 4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"19.20 Prelim  4.10.2019","index":0,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["ACCT#","EXPENSES","BUDGET","2018/2019","BUDGET"]
[null,"DESCRIPTION","2018/2019","50% BUDGET","2019/2020","Notes"]
["59022-2","Fire Vehicle Maintenance ",5700,2700,3000]
["59040-2","Shop Supply/ Tools/ Equip",3500,336,2000]
["59043-2","Tires",750,1556,1200]
["59060-2","Radio Equipment ",1500,1162,1500]
["59065-2","Clothing",2000,244,3000]
["59066-2","Foam / Fire Extinguishers",300,186,300]
["59070-2","Gen Medical / Fire Supply",3000,760,2100]
["59072-2","Office",700,436,700]
["59075-2","Fire Hose",800,0,800]
["59092-2","Annual Physicals",1100,620,1100]
["59093-2","Fire Protection",100,0,200]
["59100-2","FD Administrative Exp",29500,14712,30375]
["59101-2","Dues & Subscriptions",1400,362,1000]
["59110-2","Volunteer Expense",1500,94,1500]
["59120-2","Chief's Compensation",20941,11180,21928]
["59130-2","Drill & Response",11000,4781,11000]
["59140-2","Travel Expense",100,0,100]
["59200-2","Workers Comp.",11730,6110,19000]
["59320-2","FICA Exp",2484,17088,1615]
["59079-2","Fuel Expense",8500,5253,7500]
["59090-2","Training Expense",600,0,600]
["59330-2","Unemployment Exp.",2290,1650,378]
["59340-2","SDI Exp.",158,1035,110]
["59501-2","SCBA Testing",1200,0,1200]
["59610-2","Strike Team Wages Exp.",25000,208102,25000]
["59620-2","Strike Team Expense",1,5165,1]
["59630-2","Grant Writing",1000,2040,1000]
["Xfer Out","CSD Budget Expense",39878,20847,39475]
[null,"TOTAL COLUMN ",{"$f":"SUM(C4:C31)","v":176732},{"$f":"SUM(D4:D31)","v":306419},{"$f":"SUM(E4:E31)","v":177682}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ACCT #","REVENUE",{"$f":"C2","v":"BUDGET"},{"$f":"D2","v":"2018/2019"},"BUDGET","NOTES"]
[null,null,{"$f":"C3","v":"2018/2019"},"50% BUDGET",{"$f":"E3","v":"2019/2020"}]
["45000-1","Tax Revenue",157431,93153,171881]
[44000,"Interest/misc",300,171,300]
["xfer out","Fire Truck Pmt- Rolling stock",32786,null,32786]
["46600-2","Strike Team Income",50000,245044,50000]
["48100-2","Gain/Loss Sale of Asset",1,0,1]
["48550-2","Grant Revenue",1,0,1]
["TOTAL REVENUE:",null,{"$f":"SUM(C44:C49)","v":240519},{"$f":"SUM(D44:D49)","v":338368},{"$f":"SUM(E44:E49)","v":254969}]
[]
["ACCT#","CAPITOL EXPENDITURES",{"$f":"C2","v":"BUDGET"},{"$f":"D2","v":"2018/2019"},"BUDGET"]
[null,null,{"$f":"C3","v":"2018/2019"},"50% BUDGET",{"$f":"E3","v":"2019/2020"}]
["12430-2","Grant Purchases",1,null,1]
["xfer in","Fire Truck Pmt",32786,null,32786]
[null,"New C-41 Vehicle",null,null,7500]
[null,"2 SCBAs",6000,null,12000]
["xfer out","To Rolling Stock Acct",25000,null,25000]
["TOTAL CAPITAL EXPENDITURES:",null,{"$f":"SUM(C54:C58)","v":63787},{"$f":"SUM(D54:D58)","v":0},{"$f":"SUM(E54:E58)","v":77287}]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C50-(C32+C59)","v":0},{"$f":"D50-(D32+D59)","v":31949},{"$f":"E50-(E32+E59)","v":0}]

{"sheet":"Website Copy","index":1,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["ACCT#","EXPENSES","BUDGET","2018/2019","BUDGET"]
[null,"DESCRIPTION","2018/2019","50% BUDGET","2019/2020"]
["59022-2","Fire Vehicle Maintenance ",5700,2700,3000]
["59040-2","Shop Supply/ Tools/ Equip",3500,336,2000]
["59043-2","Tires",750,1556,1200]
["59060-2","Radio Equipment ",1500,1162,1500]
["59065-2","Clothing",2000,244,3000]
["59066-2","Foam / Fire Extinguishers",300,186,300]
["59070-2","Gen Medical / Fire Supply",3000,760,2100]
["59072-2","Office",700,436,700]
["59075-2","Fire Hose",800,0,800]
["59092-2","Annual Physicals",1100,620,1100]
["59093-2","Fire Protection",100,0,200]
["59100-2","FD Administrative Exp",29500,14712,30375]
["59101-2","Dues & Subscriptions",1400,362,1000]
["59110-2","Volunteer Expense",1500,94,1500]
["59120-2","Chief's Compensation",20941,11180,21928]
["59130-2","Drill & Response",11000,4781,11000]
["59140-2","Travel Expense",100,0,100]
["59200-2","Workers Comp.",11730,6110,19000]
["59320-2","FICA Exp",2484,17088,1615]
["59079-2","Fuel Expense",8500,5253,7500]
["59090-2","Training Expense",600,0,600]
["59330-2","Unemployment Exp.",2290,1650,378]
["59340-2","SDI Exp.",158,1035,110]
["59501-2","SCBA Testing",1200,0,1200]
["59610-2","Strike Team Wages Exp.",25000,208102,25000]
["59620-2","Strike Team Expense",1,5165,1]
["59630-2","Grant Writing",1000,2040,1000]
["Xfer Out","CSD Budget Expense",39878,20847,39475]
[null,"TOTAL COLUMN ",{"$f":"SUM(C4:C31)","v":176732},{"$f":"SUM(D4:D31)","v":306419},{"$f":"SUM(E4:E31)","v":177682}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ACCT #","REVENUE",{"$f":"C2","v":"BUDGET"},{"$f":"D2","v":"2018/2019"},"BUDGET"]
[null,null,{"$f":"C3","v":"2018/2019"},"50% BUDGET",{"$f":"E3","v":"2019/2020"}]
["45000-1","Tax Revenue",157431,93153,171881]
[44000,"Interest/misc",300,171,300]
["xfer out","Fire Truck Pmt- Rolling stock",32786,null,32786]
["46600-2","Strike Team Income",50000,245044,50000]
["48100-2","Gain/Loss Sale of Asset",1,0,1]
["48550-2","Grant Revenue",1,0,1]
["TOTAL REVENUE:",null,{"$f":"SUM(C44:C49)","v":240519},{"$f":"SUM(D44:D49)","v":338368},{"$f":"SUM(E44:E49)","v":254969}]
[]
["ACCT#","CAPITOL EXPENDITURES",{"$f":"C2","v":"BUDGET"},{"$f":"D2","v":"2018/2019"},"BUDGET"]
[null,null,{"$f":"C3","v":"2018/2019"},"50% BUDGET",{"$f":"E3","v":"2019/2020"}]
["12430-2","Grant Purchases",1,null,1]
["xfer in","Fire Truck Pmt",32786,null,32786]
[null,"New C-41 Vehicle",null,null,7500]
[null,"2 SCBAs",6000,null,12000]
["xfer out","To Rolling Stock Acct",25000,null,25000]
["TOTAL CAPITAL EXPENDITURES:",null,{"$f":"SUM(C54:C58)","v":63787},{"$f":"SUM(D54:D58)","v":0},{"$f":"SUM(E54:E58)","v":77287}]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C50-(C32+C59)","v":0},{"$f":"D50-(D32+D59)","v":31949},{"$f":"E50-(E32+E59)","v":0}]

{"sheet":"19.20 Operating","index":2,"n_rows":61,"n_cols":3,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["ACCT#","EXPENSES","BUDGET"]
[null,"DESCRIPTION","2019/2020"]
["59022-2","Fire Vehicle Maintenance ",3000]
["59040-2","Shop Supply/ Tools/ Equip",2000]
["59043-2","Tires",1200]
["59060-2","Radio Equipment ",1500]
["59065-2","Clothing",3000]
["59066-2","Foam / Fire Extinguishers",300]
["59070-2","Gen Medical / Fire Supply",2100]
["59072-2","Office",700]
["59075-2","Fire Hose",800]
["59092-2","Annual Physicals",1100]
["59093-2","Fire Protection",200]
["59100-2","FD Administrative Exp",30375]
["59101-2","Dues & Subscriptions",1000]
["59110-2","Volunteer Expense",1500]
["59120-2","Chief's Compensation",21928]
["59130-2","Drill & Response",11000]
["59140-2","Travel Expense",100]
["59200-2","Workers Comp.",19000]
["59320-2","FICA Exp",1615]
["59079-2","Fuel Expense",7500]
["59090-2","Training Expense",600]
["59330-2","Unemployment Exp.",378]
["59340-2","SDI Exp.",110]
["59501-2","SCBA Testing",1200]
["59610-2","Strike Team Wages Exp.",25000]
["59620-2","Strike Team Expense",1]
["59630-2","Grant Writing",1000]
["Xfer Out","CSD Budget Expense",39475]
[null,"TOTAL COLUMN ",{"$f":"SUM(C4:C31)","v":177682}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ACCT #","REVENUE","BUDGET"]
[null,null,{"$f":"C3","v":"2019/2020"}]
["45000-1","Tax Revenue",171881]
[44000,"Interest/misc",300]
["xfer out","Fire Truck Pmt- Rolling stock",32786]
["46600-2","Strike Team Income",50000]
["48100-2","Gain/Loss Sale of Asset",1]
["48550-2","Grant Revenue",1]
["TOTAL REVENUE:",null,{"$f":"SUM(C44:C49)","v":254969}]
[]
["ACCT#","CAPITOL EXPENDITURES","BUDGET"]
[null,null,{"$f":"C3","v":"2019/2020"}]
["12430-2","Grant Purchases",1]
["xfer in","Fire Truck Pmt",32786]
[null,"New C-41 Vehicle",7500]
[null,"2 SCBAs",12000]
["xfer out","To Rolling Stock Acct",25000]
["TOTAL CAPITAL EXPENDITURES:",null,{"$f":"SUM(C54:C58)","v":77287}]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C50-(C32+C59)","v":0}]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Qtr 1","index":4,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["ACCT#","EXPENSES","BUDGET","Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,"DESCRIPTION","2019/2020","Quarter","2020-07-01","2020-08-01","2020-09-01","Totals","Remaining","Left"]
["59022-2","Fire Vehicle Maintenance ",4000,null,34,89,436,{"$f":"D3+E3+F3+G3","v":559},{"$f":"C3-(D3+E3+F3+G3)","v":3441},{"$f":"I3/C3","v":0.86024999999999996}]
["59040-2","Shop Supply/ Tools/ Equip",2000,null,115,96,null,{"$f":"D4+E4+F4+G4","v":211},{"$f":"C4-(D4+E4+F4+G4)","v":1789},{"$f":"I4/C4","v":0.89449999999999996}]
["59043-2","Tires",1400,null,20,1660,null,{"$f":"D5+E5+F5+G5","v":1680},-280,-0.2]
["59060-2","Radio Equipment ",1500,null,null,163,2500,2663,-1163,-0.77533333333333332]
["59065-2","Clothing",4200,null,null,798,190,988,3212,0.76476190476190475]
["59066-2","Foam / Fire Extinguishers",400,null,null,414,null,414,-14,-3.5000000000000003E-2]
["59070-2","Gen Medical / Fire Supply",2200,null,null,50,11,61,2139,0.97227272727272729]
["59072-2","Office",700,null,183,null,null,183,517,0.73857142857142855]
["59075-2","Fire Hose",800,null,null,363,178,541,259,0.32374999999999998]
["59079-2","Fuel Expense",6500,null,258,1050,403,1711,4789,0.73676923076923073]
["59090-2","Training Expense",600,null,null,270,null,270,330,0.55000000000000004]
["59092-2","Annual Physicals",1000,null,null,null,null,0,1000,1]
["59093-2","Fire Protection",200,null,null,null,null,0,200,1]
["59100-2","FD Administrative Exp",30861,null,2571,2571,2571,7713,23148,0.75007290755322253]
["59101-2","Dues & Subscriptions",1300,null,null,400,null,400,900,0.69230769230769229]
["59110-2","Volunteer Expense",1500,null,22,40,null,62,1438,0.95866666666666667]
["59120-2","Chief's Compensation",22279,null,1829,1844,1859,5532,16747,0.75169442075497106]
["59130-2","Drill & Response",10000,null,null,null,null,0,10000,1]
["59140-2","Travel Expense",100,null,null,null,null,0,100,1]
["59200-2","Workers Comp.",14997,null,3643,null,null,3643,11354,0.75708475028339006]
["59320-2","FICA Exp",1700,null,912,10294,366,11572,-9872,-5.8070588235294114]
["59330-2","Unemployment Exp.",378,null,150,1129,8,1287,-909,-2.4047619047619047]
["59340-2","SDI Exp.",110,null,68,682,33,783,-673,-6.1181818181818182]
["59501-2","SCBA Testing",1200,null,null,null,null,0,1200,1]
["59610-2","Strike Team Wages Exp.",25000,null,4132,65436,533,70101,-45101,-1.8040400000000001]
["59620-2","Strike Team Expense",500,null,162,1141,857,2160,-1660,-3.32]
["59630-2","Grant Writing",750,null,null,null,null,0,750,1]
["Xfer Out","CSD Budget Expense",42225,null,6503,1455,1350,{"$f":"D30+E30+F30+G30","v":9308},32917,0.7795618709295441]
[null,"TOTAL COLUMN ",{"$f":"SUM(C3:C30)","v":178400},{"$f":"SUM(D3:D30)","v":0},{"$f":"SUM(E3:E30)","v":20602},{"$f":"SUM(F3:F30)","v":89945},{"$f":"SUM(G3:G30)","v":11295},121842,56558,0.31702914798206278]
[]
["ACCT #","REVENUE",{"$f":"C1","v":"BUDGET"},"Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,null,"2019/2020","Quarter","2020-07-01","2020-08-01","2020-09-01","Totals","Remaining","Left"]
["45000-1","Tax Revenue",169543,null,null,null,14093,{"$f":"SUM(D35:G35)","v":14093},{"$f":"C35-H35","v":155450},{"$f":"I35/C35","v":0.91687654459340695}]
[44000,"Interest/misc",800,null,104,100,95,299,{"$f":"C36-H36","v":501},0.62624999999999997]
["xfer out","Fire Truck Pmt- Rolling stock",32786,null,null,null,null,0,{"$f":"C37-H37","v":32786},1]
["46600-2","Strike Team Income",50000,null,null,null,null,0,50000,1]
["48100-2","Gain/Loss Sale of Asset",1,null,null,null,null,0,1,1]
["48550-2","Grant Revenue- donation",1,null,null,100,null,100,-99,-99]
["TOTAL REVENUE:",null,{"$f":"SUM(C35:C40)","v":253131},0,104,200,14188,14492,238639,0.94274901138145861]
[]
["ACCT#","CAPITOL EXPENDITURES",{"$f":"C1","v":"BUDGET"},"Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,null,"2019/2020","Quarter","2020-07-01","2020-08-01","2020-09-01","Totals","Remaining","Left"]
["12430-2","Grant Purchases",1,null,null,null,null,{"$f":"SUM(D45:G45)","v":0},{"$f":"C45-H45","v":1},{"$f":"I45/C45","v":1}]
["xfer in","Fire Truck Pmt",32786,null,null,null,null,{"$f":"SUM(D46:G46)","v":0},32786,1]
["12350-2","2 SCBAs",9500,null,null,null,9009,{"$f":"SUM(D47:G47)","v":9009},491,5.1684210526315791E-2]
[null,"2019 Fire Chiefs Rig",7444,null,620,620,620,{"$f":"SUM(D48:G48)","v":1860},5584,0.75013433637829119]
["xfer out","To Rolling Stock Acct",25000,null,null,null,null,{"$f":"SUM(D49:G49)","v":0},25000,1]
["TOTAL CAPITAL EXPENDITURES:",null,{"$f":"SUM(C45:C49)","v":74731},0,620,620,9629,10869,63862,0.85455834927941554]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C41-(C31+C50)","v":0},0,-21118,-90365,-6736,-118219,118219]

{"sheet":"Qtr 2","index":5,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["ACCT#","EXPENSES","2021-2022"]
[null,"DESCRIPTION","FD Budget"]
["59022-2","Fire Vehicle Maintenance ",4000]
["59040-2","Shop Supply/ Tools/ Equip",2000]
["59043-2","Tires",1200]
["59060-2","Radio Equipment ",1500]
["59065-2","Clothing",3000]
["59066-2","Foam / Fire Extinguishers",300]
["59070-2","Gen Medical / Fire Supply",1800]
["59072-2","Office",700]
["59075-2","Fire Hose",800]
["59079-2","Fuel Expense",7500]
["59090-2","Training Expense",1000]
["59092-2","Annual Physicals",1500]
["59093-2","Fire Protection",200]
["59100-2","FD Administrative Exp",30375]
["59101-2","Dues & Subscriptions",1000]
["59110-2","Volunteer Expense",1500]
["59120-2","Chief's Compensation",21928]
["59130-2","Drill & Response",10000]
["59140-2","Travel Expense",100]
["59200-2","Workers Comp.",19000]
["59320-2","FICA Exp",1615]
["59330-2","Unemployment Exp.",378]
["59340-2","SDI Exp.",110]
["59501-2","SCBA Testing",1200]
["59610-2","Strike Team Wages Exp.",25000]
["59620-2","Strike Team Expense",1]
["59630-2","Grant Writing",500]
["Xfer Out","CSD Budget Expense",39475]
[null,"TOTAL ",{"$f":"SUM(C3:C30)","v":177682}]
[]
[]
[]
[]
["ACCT #","REVENUE","2021-2022"]
[null,null,"FD Budget"]
["45000-1","Tax Revenue",171881]
[44000,"Interest/misc",300]
["xfer out","Fire Truck Pmt- Rolling stock",32786]
["46600-2","Strike Team Income",50000]
["48100-2","Gain/Loss Sale of Asset",1]
["48550-2","Grant Revenue- donation",1]
[null,"TOTAL REVENUE:",{"$f":"SUM(C38:C43)","v":254969}]
[]
["ACCT#","CAPITOL EXPENDITURES","2021-2022"]
[null,null,"FD Budget"]
["12430-2","Grant Purchases",1]
["12403-2","SCBA",12000]
["xfer in","Fire Truck Pmt",32786]
["over bug","2019 Fire Chiefs Rig",7500]
["xfer out","To Rolling Stock Acct",25000]
[null,"TOTAL CAPITAL EXPENDITURES:",{"$f":"SUM(C48:C52)","v":77287}]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C44-(C31+C53)","v":0}]

{"sheet":"Qtr 3","index":6,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["ACCT#","EXPENSES","BUDGET","Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,"DESCRIPTION","2019/2020","Quarter","2020-01-01","2020-02-01","2020-03-01","Totals","Remaining","Left"]
["59022-2","Fire Vehicle Maintenance ",3000,3653,232,2719,1414,{"$f":"D3+E3+F3+G3","v":8018},{"$f":"C3-(D3+E3+F3+G3)","v":-5018},{"$f":"I3/C3","v":-1.6726666666666667}]
["59040-2","Shop Supply/ Tools/ Equip",2000,619,432,null,55,{"$f":"D4+E4+F4+G4","v":1106},{"$f":"C4-(D4+E4+F4+G4)","v":894},{"$f":"I4/C4","v":0.44700000000000001}]
["59043-2","Tires",1200,2339,23,449,null,{"$f":"D5+E5+F5+G5","v":2811},-1611,-1.3425]
["59060-2","Radio Equipment ",1500,1682,1071,575,144,3472,-1972,-1.3146666666666667]
["59065-2","Clothing",3000,1239,null,799,1279,3317,-317,-0.10566666666666667]
["59066-2","Foam / Fire Extinguishers",300,389,null,null,null,389,-89,-0.29666666666666669]
["59070-2","Gen Medical / Fire Supply",2100,2106,26,11,681,2824,-724,-0.34476190476190477]
["59072-2","Office",700,365,200,null,null,565,135,0.19285714285714287]
["59075-2","Fire Hose",800,195,null,null,null,195,605,0.75624999999999998]
["59079-2","Fuel Expense",7500,5306,472,876,550,{"$f":"D12+E12+F12+G12","v":7204},{"$f":"C12-(D12+E12+F12+G12)","v":296},{"$f":"I12/C12","v":3.9466666666666664E-2}]
["59090-2","Training Expense",600,229,null,null,null,229,371,0.61833333333333329]
["59092-2","Annual Physicals",1100,120,null,null,null,120,980,0.89090909090909087]
["59093-2","Fire Protection",200,0,null,null,90,90,110,0.55000000000000004]
["59100-2","FD Administrative Exp",30375,15186,2531,2531,2531,22779,7596,0.25007407407407406]
["59101-2","Dues & Subscriptions",1000,300,null,null,null,300,700,0.7]
["59110-2","Volunteer Expense",1500,502,null,62,null,564,936,0.624]
["59120-2","Chief's Compensation",21928,10065,1830,1830,1830,15555,6373,0.29063298066399124]
["59130-2","Drill & Response",11000,6694,null,null,null,6694,4306,0.39145454545454544]
["59140-2","Travel Expense",100,100,null,null,null,100,0,0]
["59200-2","Workers Comp.",19000,7662,3831,null,14216,25709,-6709,-0.35310526315789476]
["59320-2","FICA Exp",1615,3880,140,140,140,4300,-2685,-1.6625386996904026]
["59330-2","Unemployment Exp.",378,2024,148,129,86,{"$f":"D24+E24+F24+G24","v":2387},-2009,-5.3148148148148149]
["59340-2","SDI Exp.",110,116,9,9,9,{"$f":"D25+E25+F25+G25","v":143},-33,-0.3]
["59501-2","SCBA Testing",1200,0,null,null,null,0,1200,1]
["59610-2","Strike Team Wages Exp.",25000,34241,null,null,null,34241,-9241,-0.36964000000000002]
["59620-2","Strike Team Expense",1,458,null,null,null,458,-457,-457]
["59630-2","Grant Writing",1000,0,null,null,null,0,1000,1]
["Xfer Out","CSD Budget Expense",39475,28633,2008,1584,935,{"$f":"D30+E30+F30+G30","v":33160},6315,0.15997466751108297]
[null,"TOTAL COLUMN ",{"$f":"SUM(C3:C30)","v":177682},{"$f":"SUM(D3:D30)","v":128103},{"$f":"SUM(E3:E30)","v":12953},{"$f":"SUM(F3:F30)","v":11714},{"$f":"SUM(G3:G30)","v":23960},176730,952,5.3578865613849464E-3]
[]
["ACCT #","REVENUE",{"$f":"C1","v":"BUDGET"},"Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,null,"2019/2020","Quarter","2020-01-01","2020-02-01","2020-03-01","Totals","Remaining","Left"]
["45000-1","Tax Revenue",171881,147237,null,null,null,{"$f":"SUM(D35:G35)","v":147237},{"$f":"C35-H35","v":24644},{"$f":"I35/C35","v":0.1433782675222974}]
[44000,"Interest/misc",300,1391,119,107,200,1817,{"$f":"C36-H36","v":-1517},-5.0566666666666666]
["xfer out","Fire Truck Pmt- Rolling stock",32786,null,null,null,null,0,{"$f":"C37-H37","v":32786},1]
["46600-2","Strike Team Income",50000,23869,21965,19540,null,65374,-15374,-0.30747999999999998]
["48100-2","Gain/Loss Sale of Asset",1,null,null,null,null,0,1,1]
["48550-2","Grant Revenue- donation",1,null,null,2625,null,2625,-2624,-2624]
["TOTAL REVENUE:",null,{"$f":"SUM(C35:C40)","v":254969},172497,22084,22272,200,217053,37916,0.14870827433923339]
[]
["ACCT#","CAPITOL EXPENDITURES",{"$f":"C1","v":"BUDGET"},"Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,null,"2019/2020","Quarter","2020-01-01","2020-02-01","2020-03-01","Totals","Remaining","Left"]
["12430-2","Grant Purchases",1,4412,null,null,null,{"$f":"SUM(D45:G45)","v":4412},{"$f":"C45-H45","v":-4411},{"$f":"I45/C45","v":-4411}]
["xfer in","Fire Truck Pmt",32786,null,32786,null,null,{"$f":"SUM(D46:G46)","v":32786},0,0]
[null,"2 SCBAs",12000,15922,null,null,null,{"$f":"SUM(D47:G47)","v":15922},-3922,-0.32683333333333331]
["over bug","2019 Fire Chiefs Rig",7500,4317,620,620,620,{"$f":"SUM(D48:G48)","v":6177},1323]
["xfer out","To Rolling Stock Acct",25000,null,null,null,null,{"$f":"SUM(D49:G49)","v":0},25000,1]
["TOTAL CAPITAL EXPENDITURES:",null,{"$f":"SUM(C45:C49)","v":77287},24651,33406,620,620,59297,17990,0.23276877094466081]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C41-(C31+C50)","v":0},19743,-24275,9938,-24380,-18974,18974]

{"sheet":"Qtr 4","index":7,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["ACCT#","EXPENSES","BUDGET","Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,"DESCRIPTION","2019/2020","Quarter","2020-04-01","2020-05-01","2020-06-01","Totals","Remaining","Left"]
["59022-2","Fire Vehicle Maintenance ",3000,8018,null,311,394,{"$f":"D3+E3+F3+G3","v":8723},{"$f":"C3-(D3+E3+F3+G3)","v":-5723},{"$f":"I3/C3","v":-1.9076666666666666}]
["59040-2","Shop Supply/ Tools/ Equip",2000,1106,123,280,444,{"$f":"D4+E4+F4+G4","v":1953},{"$f":"C4-(D4+E4+F4+G4)","v":47},{"$f":"I4/C4","v":2.35E-2}]
["59043-2","Tires",1200,2811,null,null,125,{"$f":"D5+E5+F5+G5","v":2936},-1736,-1.4466666666666668]
["59060-2","Radio Equipment ",1500,3472,null,163,null,3635,-2135,-1.4233333333333333]
["59065-2","Clothing",3000,3317,136,429,null,3882,-882,-0.29399999999999998]
["59066-2","Foam / Fire Extinguishers",300,389,null,null,null,389,-89,-0.29666666666666669]
["59070-2","Gen Medical / Fire Supply",2100,2824,-60,12,530,3306,-1206,-0.57428571428571429]
["59072-2","Office",700,565,398,null,40,1003,-303,-0.43285714285714288]
["59075-2","Fire Hose",800,195,null,null,759,954,-154,-0.1925]
["59079-2","Fuel Expense",7500,7204,419,478,910,{"$f":"D12+E12+F12+G12","v":9011},{"$f":"C12-(D12+E12+F12+G12)","v":-1511},{"$f":"I12/C12","v":-0.20146666666666666}]
["59090-2","Training Expense",600,229,null,null,null,229,371,0.61833333333333329]
["59092-2","Annual Physicals",1100,120,null,null,null,120,980,0.89090909090909087]
["59093-2","Fire Protection",200,90,50,null,null,140,60,0.3]
["59100-2","FD Administrative Exp",30375,22779,2531,2531,2531,30372,3,9.8765432098765426E-5]
["59101-2","Dues & Subscriptions",1000,300,990,null,null,1290,-290,-0.28999999999999998]
["59110-2","Volunteer Expense",1500,564,null,526,381,1471,29,1.9333333333333334E-2]
["59120-2","Chief's Compensation",21928,15555,1830,1830,1830,21045,883,4.0268150310105798E-2]
["59130-2","Drill & Response",11000,6694,null,null,3751,10445,555,5.0454545454545453E-2]
["59140-2","Travel Expense",100,100,null,null,null,100,0,0]
["59200-2","Workers Comp.",19000,25709,3831,null,null,29540,-10540,-0.55473684210526319]
["59320-2","FICA Exp",1615,4300,140,140,427,5007,-3392,-2.10030959752322]
["59330-2","Unemployment Exp.",378,2387,80,null,197,{"$f":"D24+E24+F24+G24","v":2664},-2286,-6.0476190476190474]
["59340-2","SDI Exp.",110,143,14,4,4,{"$f":"D25+E25+F25+G25","v":165},-55,-0.5]
["59501-2","SCBA Testing",1200,0,null,null,1240,1240,-40,-3.3333333333333333E-2]
["59610-2","Strike Team Wages Exp.",25000,34241,null,null,null,34241,-9241,-0.36964000000000002]
["59620-2","Strike Team Expense",1,458,null,null,null,458,-457,-457]
["59630-2","Grant Writing",1000,0,null,null,null,0,1000,1]
["Xfer Out","CSD Budget Expense",39475,33160,1345,1554,4244,{"$f":"D30+E30+F30+G30","v":40303},-828,-2.0975300823305891E-2]
[null,"TOTAL COLUMN ",{"$f":"SUM(C3:C30)","v":177682},{"$f":"SUM(D3:D30)","v":176730},{"$f":"SUM(E3:E30)","v":11827},{"$f":"SUM(F3:F30)","v":8258},{"$f":"SUM(G3:G30)","v":17807},214622,-36940,-0.20789950585878142]
[]
["ACCT #","REVENUE",{"$f":"C1","v":"BUDGET"},"Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,null,"2019/2020","Quarter","2020-04-01","2020-05-01","2020-06-01","Totals","Remaining","Left"]
["45000-1","Tax Revenue",171881,147237,24644,null,null,{"$f":"SUM(D35:G35)","v":171881},{"$f":"C35-H35","v":0},{"$f":"I35/C35","v":0}]
[44000,"Interest/misc",300,1817,116,337,100,2370,{"$f":"C36-H36","v":-2070},-6.9]
["xfer out","Fire Truck Pmt- Rolling stock",32786,null,null,null,32786,32786,{"$f":"C37-H37","v":0},0]
["46600-2","Strike Team Income",50000,65374,null,null,null,65374,-15374,-0.30747999999999998]
["48100-2","Gain/Loss Sale of Asset",1,null,null,null,null,0,1,1]
["48550-2","Grant Revenue- donation",1,2625,null,null,null,2625,-2624,-2624]
["TOTAL REVENUE:",null,{"$f":"SUM(C35:C40)","v":254969},217053,24760,337,32886,275036,-20067,-7.8703685546085991E-2]
[]
["ACCT#","CAPITOL EXPENDITURES",{"$f":"C1","v":"BUDGET"},"Previous ","Month","Month","Month","Year to Date","Budget ","%"]
[null,null,"2019/2020","Quarter","2020-04-01","2020-05-01","2020-06-01","Totals","Remaining","Left"]
["12430-2","Grant Purchases",1,4412,null,1233,null,{"$f":"SUM(D45:G45)","v":5645},{"$f":"C45-H45","v":-5644},{"$f":"I45/C45","v":-5644}]
["xfer in","Fire Truck Pmt",32786,32786,null,null,null,{"$f":"SUM(D46:G46)","v":32786},0,0]
["12400-2","2 SCBAs",12000,15922,null,null,null,{"$f":"SUM(D47:G47)","v":15922},-3922,-0.32683333333333331]
["over bug","2019 Fire Chiefs Rig",7500,6177,620,620,620,{"$f":"SUM(D48:G48)","v":8037},-537]
["xfer out","To Rolling Stock Acct",25000,null,null,null,14188,{"$f":"SUM(D49:G49)","v":14188},10812,0.43247999999999998]
["TOTAL CAPITAL EXPENDITURES:",null,{"$f":"SUM(C45:C49)","v":77287},59297,620,1853,14808,76578,709,9.1735996998201508E-3]
[]
["BUDGET SURPLUS/DEFICIT:",null,{"$f":"C41-(C31+C50)","v":0},-18974,12313,-9774,271,-16164,16164]