Public records library › 26-262 › Fleet Reserve Schedule 2027 FINAL.xlsx
Request 26-262
Fleet Reserve Schedule 2027 FINAL.xlsx
Excel · 236 KB · released by the City of Moscow on request 26-262
Excel file. Download it to open in the matching program.
SHA-256 ce33d93d929f0eb609ac669353bc37dcc6e6c2a60f9d6ee5c440480d3a317756
Extracted text
Machine-extracted text layer of the file above, shown verbatim for search and reading. Tables and slides lose their layout. The original file governs.
# Fleet Reserve Schedule 2027 FINAL.xlsx - path: - path: Fleet Reserve Schedule 2027 FINAL.xlsx - type: xlsx - size: 236425 bytes - sheets: 9 - extraction method: xlsx (openpyxl, cached values) === Sheet: 2014Fleet Schedule === | | | | | | | Audited 2012 | Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Residual Balance | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Ending | Purchases | | | 2005-2006 | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | | | | | In | Police | | Suburban Surveying | 1/2 ton 4 wd | Core Cut, Salter, Deicer | 4 wheeler | Plow blade | Mower | 5 yard dump truck | Stencil Truck | Dump Truck | 1/2 ton pickup | Vehicle | 2012 | 2012 | General Fund | | 245000 | 757177 | 758012.15 | 784122.15 | 658889.68 | 369002.68000000005 | 585495 | | | 0 | 0 | 375939.26 | 101065.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 860368.52 | 101065.74 | Streets | | 100000 | 346950 | 198484.58 | 306987.58 | 105689.55 | 449720.55 | 317623 | | | 0 | | 0 | 0 | | 0 | 44000 | 23085 | | | 0 | 0 | 0 | 148706.36 | 0 | 0 | 101831.64000000001 | 215791.36 | Parks & Rec | | 80000 | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 108393.5 | 149394 | | | 0 | 16000 | | | | | 28239.46 | | 7298.6 | | 26164.93 | | | | | | 103691.01000000001 | 61702.99 | Total Governmental Funds | | 425000 | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 927116.73 | 1052512 | 0 | | 0 | 16000 | 375939.26 | 101065.74 | 0 | 0 | 72239.45999999999 | 23085 | 7298.6 | 0 | 26164.93 | 0 | 0 | 148706.36 | | 0 | 1065891.17 | 378560.08999999997 | Water | | 0 | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | | | 0 | -8000 | 77000 | | | | 0 | | | | | | | 0 | 23758.46 | 0 | 161457.54 | 23758.46 | Sewer | | 0 | 45400 | 90800 | 159055 | 274835.66 | 530973.6599999999 | 161797 | | | 0 | -8000 | 212000 | | | | 21557.91 | | 7298.6 | 0 | | 194245 | | | 0 | 0 | 142695.49 | 223101.51 | Sanitation | | | | | | 0 | 7862 | 11862 | | | | | 4000 | | | | | | | | | | | | | 0 | 15862 | 0 | Total Enterprise Funds | | 0 | 93600 | 187919.93 | 278943.93 | 389119.62 | 623684.6199999999 | 289875 | 0 | | 0 | -16000 | 293000 | 0 | 0 | | 21557.91 | 0 | 7298.6 | 0 | 0 | 194245 | 0 | 0 | | 0 | 320015.03 | 246859.97 | Information Systems | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | | | | | 4000 | | | | | | | | | | | | | 0 | 15325 | 0 | Total Internal Service Fund | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 0 | | 0 | 0 | 4000 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 15325 | 246859.97 | Total City Funds | | 425000 | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 1558126.7999999998 | 1353712 | 0 | | 0 | 0 | 672939.26 | 101065.74 | 0 | 0 | 93797.37 | 23085 | 14597.2 | 0 | 26164.93 | 194245 | 0 | 148706.36 | | 0 | 1401231.2 | 872280.03 | | | | | | | Adopted Budget 2013 | Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning Ajustment | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | | 2005-2006 | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | Residutal adjustment for 2012-2013 W/C balance | 2012-2013 | 2012-2013 | | | In | Police | Fire | Paint 8 Police Vehicles | 1/2 ton 4 wd | Striper | 4 or 6 wheeler | Toolcat Skidsteer equipment | Sander | Wacker & trailer | Stencil Truck | | 1 ton truck | Front loader Service truck | 2013 | 2013 | General Fund | | 245000 | 757177 | 758012.15 | 784122.15 | 658889.68 | 0 | 585495 | -5000 | 860368.52 | 855368.52 | | -110000 | 29335 | 148000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3000 | 0 | 0 | 618703.52 | 151000 | Streets | | 100000 | 346950 | 198484.58 | 306987.58 | 105689.55 | 84848.96000000002 | 317623 | | 101831.64000000001 | 101831.64000000001 | 110000 | | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 110000 | 5800 | 0 | 0 | 78031.64000000001 | 133800 | Parks & Rec | | 80000 | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 530973.6599999999 | 149394 | | 103691.01000000001 | 103691.01000000001 | 0 | 4000 | 40000 | 0 | 0 | 0 | 0 | 0 | 8000 | 8700 | 0 | 0 | 0 | 0 | 27000 | 0 | 103991.01000000001 | 43700 | Total Governmental Funds | | 425000 | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 615822.6199999999 | 1052512 | -5000 | 1065891.17 | 1060891.17 | 110000 | -106000 | 69335 | 148000 | 0 | 0 | 0 | 18000 | 8000 | 8700 | 0 | 0 | 110000 | 8800 | 27000 | 0 | 800726.17 | 328500 | Water | | 0 | 48200 | 97119.93 | 119888.93 | 114283.96 | 7325.45 | 116216 | | 161457.54 | 161457.54 | 0 | -2000 | 115800 | | | | 0 | | 0 | 17100 | 0 | | | 6700 | | 140000 | 111457.54000000004 | 163800 | Sewer | | 0 | 45400 | 90800 | 159055 | 274835.66 | 0 | 161797 | | 142695.49 | 142695.49 | 0 | -2000 | 89100 | | | | 22000 | 0 | 10000 | 0 | 0 | 0 | | 3600 | | 51500 | 142695.49 | 87100 | Sanitation | | | | | | 0 | 0 | 11862 | | 15862 | 15862 | 0 | | 4000 | | | | | | | | | | | | | | 19862 | 0 | Total Enterprise Funds | | 0 | 93600 | 187919.93 | 278943.93 | 389119.62 | 7325.45 | 289875 | 0 | 320015.03 | 320015.03 | 0 | -4000 | 208900 | 0 | 0 | 0 | | 0 | 10000 | 17100 | 0 | 0 | 0 | 10300 | 0 | 191500 | 274015.03 | 250900 | Information Systems | | 0 | 0 | 4000 | 8000 | 3325.45 | 0 | 11325 | | 15325 | 15325 | 0 | | 4000 | | | | | | | | | | | | | | 19325 | 0 | Total Internal Service Fund | | 0 | 0 | 4000 | 8000 | 3325.45 | 0 | 11325 | 0 | 15325 | 15325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19325 | 0 | Total City Funds | | 425000 | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 623148.0699999998 | 1353712 | -5000 | 1401231.2 | 1396231.2 | 110000 | -110000 | 282235 | 148000 | 0 | 0 | 0 | 18000 | 18000 | 25800 | 0 | 0 | 110000 | 19100 | 27000 | 191500 | 1094066.2000000002 | 579400 | | | | | | | Projected 2013 | Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning Ajustment | Audited | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Ending | Purchases | | | 2005-2006 | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2012-2013 | Residutal | | | In | Police | | Suburban Surveying | 1/2 ton 4 wd | Core Cut, Salter, Deicer | 4 wheeler | Plow blade | Mower | 5 yard dump truck | Stencil Truck | Dump Truck | 1/2 ton pickup | Vehicle | 2013 | 2013 | General Fund | | 245000 | 757177 | 758012.15 | 784122.15 | 658889.68 | 369002.68000000005 | 585495 | 855368.52 | 909542.52 | 0 | 0 | -110000 | 29335 | 148000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3000 | 0 | 0 | 623703.52 | 151000 | Streets | | 100000 | 346950 | 198484.58 | 306987.58 | 105689.55 | 449720.55 | 317623 | 101831.64000000001 | 78031.64000000001 | | 110000 | | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 110000 | 5800 | 0 | 0 | 78031.64000000001 | 133800 | Parks & Rec | | 80000 | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 108393.5 | 149394 | 103691.01000000001 | 103991.01000000001 | | 0 | 4000 | 40000 | 0 | 0 | 0 | 0 | 0 | 8000 | 8700 | 0 | 0 | 0 | 0 | 27000 | 0 | 103991.01000000001 | 43700 | Total Governmental Funds | | 425000 | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 927116.73 | 1052512 | 1060891.17 | 1091565.17 | 0 | 110000 | -106000 | 69335 | 148000 | 0 | 0 | 0 | 18000 | 8000 | 8700 | 0 | 0 | 110000 | 8800 | 27000 | 0 | 805726.17 | 328500 | Water | | 0 | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | 161457.54 | 111457.54000000004 | | 0 | -2000 | 80800 | | | | 0 | | 0 | 17100 | 0 | | | 6700 | | 185000 | 31457.540000000008 | 208800 | Sewer | | 0 | 45400 | 90800 | 159055 | 274835.66 | 530973.6599999999 | 161797 | 142695.49 | 142695.49 | | 0 | -2000 | 89100 | | | | 22000 | 0 | 10000 | 0 | 0 | 0 | | 3600 | | 75000 | 119195.48999999999 | 110600 | Sanitation | | | | | | 0 | 7862 | 11862 | 15862 | 19862 | | 0 | | 4000 | | | | | | | | | | | | | | 19862 | 0 | Total Enterprise Funds | | 0 | 93600 | 187919.93 | 278943.93 | 389119.62 | 623684.6199999999 | 289875 | 320015.03 | 274015.03 | 0 | 0 | -4000 | 173900 | 0 | 0 | 0 | | 0 | 10000 | 17100 | 0 | 0 | 0 | 10300 | 0 | 260000 | 170515.03 | 319400 | Information Systems | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | | 0 | | 4000 | | | | | | | | | | | | | | 19325 | 0 | Total Internal Service Fund | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19325 | 0 | Total City Funds | | 425000 | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 1558126.7999999998 | 1353712 | 1396231.2 | 1384905.2 | 0 | 110000 | -110000 | 247235 | 148000 | 0 | 0 | 0 | 18000 | 18000 | 25800 | 0 | 0 | 110000 | 19100 | 27000 | 260000 | 995566.2000000001 | 647900 | | | | | | | Adopted 2014 | Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning Budget | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | | 2005-2006 | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2013 Carryover Residual | | | In | Police | Fire | Engineer Vehicles | 1/2 ton 4 wd | Sweeper | 4 or 6 wheeler | Toolcat Skidsteer equipment | Mowers | trailer | PoliceArmored Rescue | | Generator | Bucket Truck | 2014 | 2014 | General Fund | | 245000 | 757177 | 758012.15 | 784122.15 | 658889.68 | 369002.68000000005 | 585495 | 618703.52 | 623703.52 | 454266.37 | 0 | 300000 | 0 | 170500 | 33000 | 38000 | | | | | | | 0 | 0 | | | 536469.8900000001 | 241500 | Streets | | 100000 | 346950 | 198484.58 | 306987.58 | 105689.55 | 449720.55 | 317623 | 78031.64000000001 | 78031.64000000001 | | 200000 | 10570 | 40200 | | | | 22500 | 230000 | | | 0 | 0 | 0 | 5700 | | | 49461.640000000014 | 258200 | Van Pool | | | | | | | | | | | 11091 | 10570 | | | | | | | | | | | | | | | | 21661 | 0 | Parks & Rec | | 80000 | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 108393.5 | 149394 | 103991.01000000001 | 103991.01000000001 | | 100000 | 4000 | 40000 | 0 | | | 0 | | 0 | 0 | 39300 | 6000 | | 7720 | 0 | 80000 | 114971.01000000001 | 133020 | Total Governmental Funds | | 425000 | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 927116.73 | 1052512 | 800726.17 | 805726.17 | 465357.37 | 310570 | 314570 | 80200 | 170500 | 33000 | 38000 | 22500 | 230000 | 0 | 0 | 39300 | 6000 | 0 | 13420 | 0 | 80000 | 722563.5400000002 | 632720 | Water | | 0 | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | 111457.54000000004 | 31457.540000000008 | | 0 | -2000 | 2000 | | | | 0 | | 0 | 0 | 0 | | | 0 | 0 | 0 | 31457.540000000008 | 0 | Sewer | | 0 | 45400 | 90800 | 159055 | 274835.66 | 530973.6599999999 | 161797 | 0 | 119195.48999999999 | | 0 | -2000 | 89500 | | | | 22500 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | 184195.49 | 22500 | Sanitation | | | | | | 0 | 7862 | 11862 | 0 | 19862 | | 0 | | 4000 | | | | | | | | | | | | | | 23862 | 0 | Total Enterprise Funds | | 0 | 93600 | 187919.93 | 278943.93 | 389119.62 | 623684.6199999999 | 289875 | 111457.54000000004 | 170515.03 | 0 | 0 | -4000 | 95500 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 239515.03 | 22500 | Information Systems | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 0 | 19325 | | 0 | | 4000 | | | | | | | | | | | | | | 23325 | 0 | Total Internal Service Fund | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 0 | 19325 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23325 | 0 | Total City Funds | | 425000 | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 1558126.7999999998 | 1353712 | 912183.7100000001 | 995566.2000000001 | 465357.37 | 310570 | 310570 | 179700 | 170500 | 33000 | 38000 | 22500 | 230000 | 0 | 0 | 39300 | 6000 | 0 | 13420 | 0 | 80000 | 985403.5700000002 | 655220 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Includes Minor Equip | | | | | | | | 1200 | | | | | | | | 2100 | | | | | | | | 2500 | | | | | | | | 3000 | | | | | | | | 5000 | | | | | | | | 1700 | | | | | | | | 3600 | | Total Minor Equip | | | | | | 19100 [70 non-empty rows] === Sheet: 2015 Fleet Schedule projections === ` | | | | | | | Audited 2013 | Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning Ajustment | Audited | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Ending | Purchases | | | 2005-2006 | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2012-2013 | Residual | | | In | Police | Fire Vehicle | Suburban Surveying | 1/2 ton 4 wd | Stensil Truck | 4X2 Gator & ATV | Plow blade | Sweeper Repair | Spreader | Athey Loader Burmanator | Dump Truck Plow | 1/2 ton pickup | Case 321 Backhoe | 2013 | 2013 | General Fund | | 245000 | 757177 | 758012.15 | 784122.15 | 658889.68 | 369002.68000000005 | 585495 | 855368.52 | 909542.52 | 0 | 0 | -110000 | 29335 | 126247 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 702630.52 | 126247 | Streets | | 100000 | 346950 | 198484.58 | 306987.58 | 105689.55 | 449720.55 | 317623 | 101831.64000000001 | 78031.64000000001 | | 110000 | | 24555 | 0 | 0 | 0 | 0 | 62954 | 0 | 0 | 18797 | 4995 | 15452 | 5000 | 0 | 0 | 105388.64000000001 | 107198 | Parks & Rec | | 80000 | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 108393.5 | 149394 | 103691.01000000001 | 103991.01000000001 | | 0 | 4000 | 40000 | 0 | 0 | 0 | 0 | 0 | 7448 | 8622 | 0 | 0 | 0 | 0 | 24086 | 0 | 107835.01000000001 | 40156 | Total Governmental Funds | | 425000 | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 927116.73 | 1052512 | 1060891.17 | 1091565.17 | 0 | 110000 | -106000 | 93890 | 126247 | 0 | 0 | 0 | 62954 | 7448 | 8622 | 18797 | 4995 | 15452 | 5000 | 24086 | 0 | 915854.17 | 273601 | Water | | 0 | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | 161457.54 | 111457.54000000004 | | 0 | -2000 | 145800 | | | | 0 | | 0 | 0 | 0 | | | | | | 255257.54000000004 | 0 | Sewer | | 0 | 45400 | 90800 | 159055 | 274835.66 | 530973.6599999999 | 161797 | 142695.49 | 142695.49 | | 0 | -2000 | 89100 | | | | 21801 | 0 | 10340 | 0 | 0 | 0 | | | | 69950 | 127704.48999999999 | 102091 | Sanitation | | | | | | 0 | 7862 | 11862 | 15862 | 19862 | | 0 | | 4000 | | | | | | | | | | | | | | 23862 | 0 | Total Enterprise Funds | | 0 | 93600 | 187919.93 | 278943.93 | 389119.62 | 623684.6199999999 | 289875 | 320015.03 | 274015.03 | 0 | 0 | -4000 | 238900 | 0 | 0 | 0 | | 0 | 10340 | 0 | 0 | 0 | 0 | 0 | 0 | 69950 | 406824.03 | 102091 | Information Systems | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | | 0 | | 4000 | | | | | | | | | | | | | | 23325 | 0 | Total Internal Service Fund | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23325 | 0 | Total City Funds | | 425000 | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 1558126.7999999998 | 1353712 | 1396231.2 | 1384905.2 | 0 | 110000 | -110000 | 336790 | 126247 | 0 | 0 | 0 | 62954 | 17788 | 8622 | 18797 | 4995 | 15452 | 5000 | 24086 | 69950 | 1346003.2000000002 | 375692 | | | | | | | Adopted 2014 | Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning Budget | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | | 2005-2006 | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2013-2014 | 2013 Carryover Residual | | | In | Police | Fire | Engineer Vehicles | 1/2 ton 4 wd | Sweeper | 4 or 6 wheeler | Toolcat Skidsteer equipment | Mowers | trailer | PoliceArmored Rescue | | Generator | Bucket Truck | 2014 | 2014 | General Fund | | 245000 | 757177 | 758012.15 | 784122.15 | 658889.68 | 369002.68000000005 | 585495 | 855368.52 | 779601 | 623704 | 95148 | 0 | 300000 | 0 | 170500 | 33000 | 38000 | | | | | | | 0 | 0 | | | 238101 | 241500 | Streets | | 100000 | 346950 | 198484.58 | 306987.58 | 105689.55 | 449720.55 | 317623 | 101831.64000000001 | 267462 | 78032 | | 200000 | 10570 | 40200 | | | | 22500 | 230000 | | | 0 | 0 | 0 | 5700 | | | 238892 | 258200 | Van Pool | | | | | | | | | | 21661 | | | 10570 | | | | | | | | | | | | | | | | 32231 | 0 | Parks & Rec | | 80000 | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 108393.5 | 149394 | 103691.01000000001 | 199992 | 103992 | | 100000 | 4000 | 40000 | 0 | | | 0 | | 0 | 0 | 39300 | 6000 | | 7720 | 0 | 80000 | 202972 | 133020 | Total Governmental Funds | | 425000 | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 927116.73 | 1052512 | 1060891.17 | 1268716 | 805728 | 95148 | 310570 | 314570 | 80200 | 170500 | 33000 | 38000 | 22500 | 230000 | 0 | 0 | 39300 | 6000 | 0 | 13420 | 0 | 80000 | 712196 | 632720 | Water | | 0 | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | 161457.54 | 29458 | 31458 | | 0 | -2000 | 2000 | | | | 0 | | 0 | 0 | 0 | | | 0 | 0 | 0 | 33458 | 0 | Sewer | | 0 | 45400 | 90800 | 159055 | 274835.66 | 530973.6599999999 | 161797 | 142695.49 | 127704.49 | 142695 | | 0 | -2000 | 89500 | | | | 22500 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | 196704.49 | 22500 | Sanitation | | | | | | 0 | 7862 | 11862 | 15862 | 19862 | 19862 | | 0 | | 4000 | | | | | | | | | | | | | | 23862 | 0 | Total Enterprise Funds | | 0 | 93600 | 187919.93 | 278943.93 | 389119.62 | 623684.6199999999 | 289875 | 320015.03 | 177024.49 | 194015 | 0 | 0 | -4000 | 95500 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 254024.49 | 22500 | Information Systems | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | 19325 | | 0 | | 4000 | | | | | | | | | | | | | | 23325 | 0 | Total Internal Service Fund | | 0 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | 19325 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23325 | 0 | Total City Funds | | 425000 | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 1558126.7999999998 | 1353712 | 1396231.2 | 1465065.49 | 1019068 | 95148 | 310570 | 310570 | 179700 | 170500 | 33000 | 38000 | 22500 | 230000 | 0 | 0 | 39300 | 6000 | 0 | 13420 | 0 | 80000 | 989545.49 | 655220 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Includes Minor Equip | | | | | | | | | | Audited FB | 1465065 | | 1114216 | 350849 | | | | | | | | | | A/R ==> | 0.4899999999906868 | | | | | | Projected 2014 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Additions | Deletions | | | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | | | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | | | | | | | | | W/ Rebalance | Reallocate after Budget 2015 | | In | Police | Fire | Engineer Vehicles | 1/2 ton 4 wd | Sweeper | | | Mowers | trailer | Water Service Truck | | Chipper | Bucket Truck | 2014 | 2014 General Fund | | 702630.52 | 702630.52 | 702630.52 | 702630.52 | 702630.52 | 702630.52 | 702630.52 | 702630.52 | 702630.52 | 0 | 153000 | 0 | 134748 | 31360 | 0 | | | | | | | 0 | 0 | | | 383522.52 | 166108 Streets | | 105388.64 | 105388.64 | 105388.64 | 105388.64 | 105388.64 | 105388.64 | 105388.64 | 105388.64 | 105388.64 | 150000 | | 40200 | | | 11236 | 20421 | 211608 | | | 0 | 0 | 0 | 6038 | | | 46285.640000000014 | 249303 Van Pool | | 32234 | | | | | | | | 32234 | 3000 | | | | | | | | | | | | | | | | 35234 | 0 Parks & Rec | | 194663 | 194663 | 194663 | 194663 | 194663 | 194663 | 194663 | 194663 | 194663 | 0 | 4000 | 40000 | 0 | | | 0 | | 0 | 0 | 33738 | 3645 | | | 0 | 62345 | 130935 | 99728 Total Governmental Funds | | 1034916.16 | 1002682.16 | 1002682.16 | 1002682.16 | 1002682.16 | 1002682.16 | 1002682.16 | 1002682.16 | 1034916.16 | 153000 | 157000 | 80200 | 134748 | 31360 | 11236 | 20421 | 211608 | 0 | 0 | 33738 | 3645 | 0 | 6038 | 0 | 62345 | 595977.16 | 515139 Water | | 255257.54 | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | 161457.54 | 255257.54 | 0 | -2000 | 2000 | | | 11236 | 0 | | 0 | 0 | 0 | | 173070 | 0 | 0 | 0 | 74951.54000000001 | 184306 Sewer | | 127704.49 | 127704.49 | 127704.49 | 127704.49 | 127704.49 | 127704.49 | 127704.49 | 127704.49 | 127704.49 | 0 | -2000 | 89500 | | | 11236 | 24076 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | 183892.49 | 35312 Sanitation | | 23862 | | | | 0 | 7862 | 11862 | 15862 | 23862 | 0 | | 35500 | | | | | | | | | | | | 35319 | | 24043 | 35319 Total Enterprise Funds | | 406824.03 | 175904.49 | 224824.41999999998 | 247593.41999999998 | 241988.45 | 220415.45 | 255782.49 | 305024.03 | 406824.03 | 0 | -4000 | 127000 | 0 | 0 | 22472 | 24076 | 0 | 0 | 0 | 0 | 0 | 173070 | 0 | 35319 | 0 | 282887.03 | 254937 Information Systems | | 23325 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 23325 | | | 4000 | | | | | | | | | | | | | | 27325 | 0 Total Internal Service Fund | | 23325 | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 23325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27325 | 0 Total City Funds | | 1465065.19 | 1178586.65 | 1231506.58 | 1258275.58 | 1247996.06 | 1230423.06 | 1269789.65 | 1323031.19 | 1465065.19 | 153000 | 153000 | 211200 | 134748 | 31360 | 33708 | 44497 | 211608 | 0 | 0 | 33738 | 3645 | 173070 | 6038 | 35319 | 62345 | 906189.1900000001 | 770076 | | | | | | | | | | | | | | | | | | | | | | | | | | | | Includes Minor Equip | | | | | | | | | | 0.30000000004656613 | 1465065 | | | | | | Adopted 2015 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Beginning | Projected | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | Purchases 2016 | | 2015 | | | 2006-2007 | 2007-2008 | 2008-2009 | 2009 2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | Beginning 2014-2015 | | | | In | Police | Fire 2 Pumper trucks | Sanitation truck | SKID Steer | Van Pool Van | 1/2 ton 4x4 truck | 1 ton truck | trailer | dump truck | Toolcat spreader | | 3/4 ton truck | New equipment for Ballfields | 2015 | 2015 General Fund | | | 757177 | 758012.15 | 784122.15 | 658889.68 | 369002.68000000005 | 585495 | 855368.52 | 779601 | 383522.52 | | | | 30260 | 141500 | 0 | 0 | 0 | 0 | | | | | | | | | 272282.52 | 141500 | | 228000 | | 291500 Streets | | | 346950 | 198484.58 | 306987.58 | 105689.55 | 449720.55 | 317623 | 101831.64000000001 | 267462 | 46285.640000000014 | | | | 151585 | | | | | | | 0 | 10500 | 102300 | 0 | | | | 85070.64000000001 | 112800 | | 299000 | | 55000 Van Pool | | | | | | | | | | 21661 | 35234 | | | | | | | | | 35000 | | | | | | | | | 234 | 35000 | | 0 MSCB | | | | | | | | | | | 0 | | | | 118500 | | | | | | | | | | | | | 118500 | 0 | 118500 Parks & Rec | | | 296529.69 | 331469.88 | 252836.88 | 174724.5 | 108393.5 | 149394 | 103691.01000000001 | 199992 | 130935 | | 4000 | | 7150 | | | | | | 23000 | 0 | 6650 | | 7500 | | | 0 | 104935 | 37150 | | 123300 | | 32000 Total Governmental Funds | | | 1400656.69 | 1287966.6099999999 | 1343946.6099999999 | 939303.7300000001 | 927116.73 | 1052512 | 1060891.17 | 1268716 | 595977.16 | 0 | 4000 | 0 | 307495 | 141500 | 0 | 0 | 0 | 35000 | 23000 | 0 | 17150 | 102300 | 7500 | 0 | 0 | 118500 | 462522.16000000003 | 444950 | 0 | 650300 | | 378500 Water | | | 48200 | 97119.93 | 119888.93 | 114283.96 | 84848.96000000002 | 116216 | 161457.54 | 29458 | 74951.54000000001 | | | 2000 | 98400 | | | | 29550 | | 23000 | | | 54450 | | 0 | 32000 | | 32351.540000000008 | 239400 | | 85000 Sewer | | | 45400 | 90800 | 159055 | 274835.66 | 530973.6599999999 | 161797 | 142695.49 | 127704.49 | 183892.49 | | | 2000 | 142170 | | | | 29550 | | | | | 173250 | | | | | 121262.48999999999 | 202800 | | 55000 Sanitation | | | | | | 0 | 7862 | 11862 | 15862 | 19862 | 24043 | | | | 4000 | | | 24000 | | | | | | | | | | | 4043 | 24000 | | 0 Total Enterprise Funds | | | 93600 | 187919.93 | 278943.93 | 389119.62 | 623684.6199999999 | 289875 | 320015.03 | 177024.49 | 282887.03 | 0 | 0 | 4000 | 244570 | 0 | 0 | 24000 | 59100 | 0 | 23000 | 0 | 0 | 227700 | 0 | 0 | 32000 | 0 | 157657.03 | 466200 | | 140000 | | 0 Information Systems | | | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | 27325 | | 0 | | 4000 | | | | | | | | | | | | | | 31325 | 0 Total Internal Service Fund | | | 0 | 4000 | 8000 | 3325.45 | 7325.45 | 11325 | 15325 | 19325 | 27325 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31325 | 0 | | 0 | | 0 Total City Funds | | | 1494256.69 | 1479886.5399999998 | 1630890.5399999998 | 1331748.8 | 1558126.7999999998 | 1353712 | 1396231.2 | 1465065.49 | 906189.1900000001 | 0 | 4000 | 4000 | 556065 | 141500 | 0 | 24000 | 59100 | 35000 | 46000 | 0 | 17150 | 330000 | 7500 | 0 | 32000 | 118500 | 651504.1900000001 | 911150 | | 790300 | | 378500 | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fleet Purchases | | | | | | | | | | | | | | | | | | | | | | | | | | | Hoist is purchased from Fleet Accumulation Fund Balance | | | 65500 | | | | | | | | | | | | | | | | | | | | | | | | | | | Total Equipment Plus Vehicle Purchase | | | 976650 [75 non-empty rows] === Sheet: 2015 Adopted Fleet Schedule === | | Audit 2014 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | Beginning | Beginning | Additions | Deletions | | 2012-2013 | 2013-2014 | | | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | | W/ Rebalance | | | In | Police | Fire | Engineer Vehicles | 1/2 ton 4 wd | Sweeper | | | Mowers | trailer | Water Service Truck | | Chipper | Bucket Truck | 2014 | 2014 General Fund | | 702630.52 | 702630.52 | 0 | 153000 | 100000 | 129881 | 36621.66 | 34163 | | | | | | | 0 | 0 | | | 448964.86 | 200665.66 Streets | | 105388.64 | 105388.64 | 150000 | | 165700 | | | 0 | 20420.98 | 211608 | | | 0 | 0 | 0 | 0 | | | 189059.66 | 232028.98 Van Pool | | | 32234 | 3000 | | 0 | | | | | | | | | | | | | | 35234 | 0 Parks & Rec | | 194663 | 194663 | 0 | 4000 | 40000 | 0 | | | 0 | | 0 | 0 | 27700 | 6038 | | 0 | 0 | 62345 | 134580 | 96083 Total Governmental Funds | | 1002682.16 | 1034916.16 | 153000 | 157000 | 305700 | 129881 | 36621.66 | 34163 | 20420.98 | 211608 | 0 | 0 | 27700 | 6038 | 0 | 0 | 0 | 62345 | 807838.52 | 528777.64 Water | | 161457.54 | 255257.54 | 0 | -2000 | 2000 | | | 0 | 0 | | 0 | 0 | 0 | | 173168.75 | 0 | 0 | 0 | 86088.79000000001 | 173168.75 Sewer | | 127704.49 | 127704.49 | 0 | -2000 | 89500 | | | 0 | 24076 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | 195128.49 | 24076 Sanitation | | 15862 | 23862 | 0 | | 36457 | | | | | | | | | | | | 35319 | | 25000 | 35319 Total Enterprise Funds | | 305024.03 | 406824.03 | 0 | -4000 | 127957 | 0 | 0 | 0 | 24076 | 0 | 0 | 0 | 0 | 0 | 173168.75 | 0 | 35319 | 0 | 306217.28 | 232563.75 Information Systems | | 15325 | 23325 | | | 4000 | | | | | | | | | | | | | | 27325 | 0 Total Internal Service Fund | | 15325 | 23325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27325 | 0 Total City Funds | | | | | | | 129881 | 36621.66 | 34163 | 44496.979999999996 | 211608 | 0 | 0 | 27700 | 6038 | 173168.75 | 0 | 35319 | 62345 | 1141380.8 | 761341.39 | | | | | | | | | | | | | | | | | | | | | Includes Minor Equip | | Adopted 2015 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | Projected | Delayed Purchases | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | Purchases 2016 | 2015 | | Audit Ending Balance of $1,290,671 | | | In | Police | Fire 2 Pumper trucks | Sanitation truck | SKID Steer | Van Pool Van | 1/2 ton 4x4 truck | 1 ton truck | trailer | dump truck | Toolcat spreader | | 3/4 ton truck | New equipment for Ballfields | 2015 | 2015 General Fund | | 598254.86 | | | 30260 | 141500 | 0 | 0 | 0 | 0 | | | | | | | | | 487014.86 | 141500 | | 228000 | 291500 Streets | | 189059.66 | | | 151585 | | | | | | | 0 | 10500 | 102300 | 0 | | | | 227844.66000000003 | 112800 | | 299000 | 55000 Van Pool | | 35234 | | | | | | | | 35000 | | | | | | | | | 234 | 35000 | | 0 MSCB | | 0 | | | 118500 | | | | | | | | | | 7500 | | | 94500 | 16500 | 102000 Parks & Rec | | 134580 | 4000 | | 7150 | | | | | | 23000 | 24000 | 6650 | | | | | 0 | 92080 | 53650 | | 123300 | 32000 Total Governmental Funds | | 957128.52 | 4000 | 0 | 307495 | 141500 | 0 | 0 | 0 | 35000 | 23000 | 24000 | 17150 | 102300 | 7500 | 0 | 0 | 94500 | 823673.52 | 444950 | 0 | 650300 | 378500 Water | | 86088.79000000001 | | 2000 | 98400 | | | | 29550 | | 23000 | | | 54450 | | 0 | 32000 | | 43488.79000000001 | 139000 | | 85000 Sewer | | 195128.49 | | 2000 | 142170 | | | | 29550 | | | | | 173250 | | | | | 132498.49 | 202800 | | 55000 Sanitation | | 25000 | | | 4000 | | | 24000 | | | | | | | | | | | 5000 | 24000 | | 0 Total Enterprise Funds | | 306217.28 | 0 | 4000 | 244570 | 0 | 0 | 24000 | 59100 | 0 | 23000 | 0 | 0 | 227700 | 0 | 0 | 32000 | 0 | 180987.28 | 365800 | | 140000 | 0 Information Systems | | 27325 | 0 | | 4000 | | | | | | | | | | | | | | 31325 | 0 Total Internal Service Fund | | 27325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31325 | 0 | | 0 | 0 Total City Funds | | 1290670.8 | 4000 | 4000 | 556065 | 141500 | 0 | 24000 | 59100 | 35000 | 46000 | 24000 | 17150 | 330000 | 7500 | 0 | 32000 | 94500 | 1035985.8 | 810750 | | 790300 | 378500 | | | | | | | | | | | | | | | | | Hoist is purchased from Fleet Accumulation Fund Balance | | | 65500 | | | | | | | | | | | | | | | | | | | Sub Total | 876250 | Fleet Purchases | | | Projected Actual Expenses 2015 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | Projected | Delayed Purchases | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | Purchases 2016 | 2015 | | Audit Beginning Balance of $1,290,671 | | | In | Police | Fire 2 Pumper trucks | Sanitation truck | SKID Steer | Van Pool Van | 1/2 ton 4x4 truck | 1 ton truck | trailer | dump truck | Toolcat spreader | | 2 ton quad crew cab | New equipment for Ballfields | 2015 | 2015 General Fund | | 598254.86 | | | 30260 | 141500 | 0 | 0 | 0 | 0 | | | | | | | | | 487014.86 | 141500 | | 228000 | 291500 Streets | | 189059.66 | | | 151585 | | | | | | | 0 | 10500 | 102300 | 0 | | | | 227844.66000000003 | 112800 | | 299000 | 55000 Van Pool | | 35234 | | | | | | | | 0 | | | | | | | | | 35234 | 0 | | 0 MSCB | | 0 | | | 118500 | | | | | | | | | | 7500 | | | 94500 | 16500 | 102000 Parks & Rec | | 134580 | 4000 | | 7150 | | | | | | 23000 | 24000 | 6650 | | | | | 0 | 92080 | 53650 | | 123300 | 32000 | 0 Total Governmental Funds | | 957128.52 | 4000 | 0 | 307495 | 141500 | 0 | 0 | 0 | 0 | 23000 | 24000 | 17150 | 102300 | 7500 | 0 | 0 | 94500 | 858673.52 | 409950 | 0 | 650300 | 378500 Water | | 86088.79000000001 | | 2000 | 98400 | | | | 29550 | | 23000 | | | 54450 | | 0 | 52000 | | 23488.790000000008 | 159000 | | 85000 Sewer | | 195128.49 | | 2000 | 142170 | | | | 29550 | | | | | 8250 | | | | | 297498.49 | 37800 | | 55000 Sanitation | | 25000 | | | 4000 | | | 0 | | | | | | | | | | | 29000 | 0 | | 0 Total Enterprise Funds | | 306217.28 | 0 | 4000 | 244570 | 0 | 0 | 0 | 59100 | 0 | 23000 | 0 | 0 | 62700 | 0 | 0 | 52000 | 0 | 349987.28 | 196800 | | 140000 | 0 Information Systems | | 27325 | 0 | | 4000 | | | | | | | | | | | | | | 31325 | 0 Total Internal Service Fund | | 27325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31325 | 0 | | 0 | 0 Total City Funds | | 1290670.8 | 4000 | 4000 | 556065 | 141500 | 0 | 0 | 59100 | 0 | 46000 | 24000 | 17150 | 165000 | 7500 | 0 | 52000 | 94500 | 1239985.8 | 606750 | | 790300 | 378500 | | | | | | | | | | | | | | | | | | | | Hoist is purchased from Fleet Accumulation Fund Balance | | | 65500 | | Adopted 2016 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | Projected | Beginning | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | 2016 | | 2017 | | Projected Beginning Balance 2015-2016 | 2015-2016 | | | In | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 | | | W/ Rebalance General Fund | | 487014.86 | | | | 0 | 50000 | 9000 | 24500 | | 0 | | | | | | | | | | | 421514.86 | 83500 Streets | | 227844.66000000003 | | | -1000 | 240500 | | | | | | 41000 | 160000 | | | | | 165000 | | | | 103344.66000000003 | 366000 Van Pool | | 35234 | | 1000 | | | | | | | | | | | | | | | 36000 | | | 234 | 36000 MSCB | | 16500 | | | | | | | | | | | | | | | | | | | | 16500 | 0 Parks & Rec | | 92080 | | 4000 | | 0 | | | | | | 0 | | 24500 | 42000 | 5300 | | | | | | 24280 | 71800 Total Governmental Funds | | 858673.52 | 0 | 5000 | -1000 | 240500 | 50000 | 9000 | 24500 | 0 | 0 | 41000 | 160000 | 24500 | 42000 | 5300 | 0 | 165000 | 36000 | 0 | 0 | 565873.52 | 557300 | 0 | 0 | | 0 Water | | 23488.790000000008 | | | 2000 | 97000 | | | | | | 45000 | | | | | | | | | | 73488.79000000001 | 45000 Sewer | | 297498.49 | | | 2000 | 104000 | | | | | | 57000 | | | | | 10000 | 165000 | | | | 167498.49 | 232000 Sanitation | | 29000 | | | | 0 | | | | | | | | | | | | | | | | 29000 | 0 | | 0 Total Enterprise Funds | | 349987.28 | 0 | 0 | 4000 | 201000 | 0 | 0 | 0 | 0 | 0 | 102000 | 0 | 0 | 0 | 0 | 10000 | 165000 | 0 | 0 | 0 | 269987.28 | 277000 | | 0 | | 0 Information Systems | | 31325 | | 0 | | 4000 | | | | | | | | | | | | | | | | 35325 | 0 Total Internal Service Fund | | 31325 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35325 | 0 | | 0 | | 0 Total City Funds | | 1239985.8 | 0 | 5000 | 3000 | 445500 | 50000 | 9000 | 24500 | 0 | 0 | 143000 | 160000 | 24500 | 42000 | 5300 | 10000 | 330000 | 36000 | 0 | 0 | 871185.8 | 834300 | | 0 | | 0 [76 non-empty rows] === Sheet: 2016 Adopted Fleet Schedule === | | Audit 2015 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | 8 | | Beginning | Additions | Deletions | | 2014-2015 | | | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Ending | Purchases | | | | | In | General Govt | Police | Sanitation truck | SKID Steer | Van Pool Van | 1/2 ton 4x4 truck | 1 ton truck | trailer | dump truck | Toolcat spreader | Minor equipment | 3/4 ton truck | New equipment for Ballfields | 2015 | 2015 General Fund | | 590580.52 | 21270 | | 30260 | | 106382 | | | | | | | | | | | | 535728.52 | 106382 Streets | | 186310 | | | 151585 | | | | | | | | 10880 | 96835 | | | | | 230180 | 107715 Van Pool | | 35234 | 12360 | | | | | | | | | | | | | | | | 47594 | 0 MSCB | | | | | 118500 | | | | | | | | 3150 | | | | | 77543 | 37807 | 80693 Parks & Rec | | 133380 | 4000 | | 7150 | 0 | | | | | 23232 | 26800 | 0 | | | | | | 94498 | 50032 Total Governmental Funds | | 945504.52 | 37630 | 0 | 307495 | 0 | 106382 | 0 | 0 | 0 | 23232 | 26800 | 14030 | 96835 | 0 | 0 | 0 | 77543 | 945807.52 | 344822 Water | | 86089 | 0 | -2000 | 98400 | | | | 26427 | | 20352.05 | | | 54335.82 | | 3427 | 47838 | | 34109.130000000005 | 152379.87 Sewer | | 195128 | 0 | -2000 | 142170 | | | | 29854 | | | | | | | 8233 | | | 301211 | 38087 Sanitation | | 27500 | 0 | | 4000 | | | | | | | | | | | | | | 31500 | 0 Total Enterprise Funds | | 308717 | 0 | -4000 | 244570 | 0 | 0 | 0 | 56281 | 0 | 20352.05 | 0 | 0 | 54335.82 | 0 | 11660 | 47838 | 0 | 366820.13 | 190466.87 City Shop | | 0 | 65500 | 0 | | 60279 | | | | | | | | | | | | | 5221 | 60279 Information Systems | | 27325 | 15520 | | 4000 | 21652 | | | | | | | | | | | | | 25193 | 21652 Total Internal Service Fund | | 27325 | 15520 | 0 | 4000 | 21652 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30414 | 81931 4 Total City Funds | | 1281546.52 | 53150 | -4000 | 556065 | 21652 | 106382 | 0 | 56281 | 0 | 43584.05 | 26800 | 14030 | 151170.82 | 0 | 11660 | 47838 | 77543 | 1343041.65 | 617219.87 | | Adopted 2015 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | Beginning | Projected | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | Purchases 2016 | | 2015 | | 2013-2014 | Beginning 2014-2015 | 2014 Audit Ending Balance of $1,290,675 | | | In | Police | Fire 2 Pumper trucks | Sanitation truck | SKID Steer | Van Pool Van | 1/2 ton 4x4 truck | 1 ton truck | trailer | dump truck | Toolcat spreader | | 3/4 ton truck | New equipment for Ballfields | 2015 | 2015 General Fund | | 779601 | 535728.52 | 599705 | | | 30260 | 141500 | 0 | 0 | 0 | 0 | | | | | | | | | 424488.52 | 141500 | | 228000 | | 291500 Streets | | 267462 | 230180 | 186310 | | | 151585 | | | | | | | 0 | 10500 | 102300 | 0 | | | | 268965 | 112800 | | 299000 | | 55000 Van Pool | | 21661 | 47594 | 35235 | | | | | | | | 35000 | | | | | | | | | 12594 | 35000 | | 0 MSCB | | | 0 | 0 | | | 118500 | | | | | | | | | | 7500 | | | 94500 | 16500 | 102000 Parks & Rec | | 199992 | 94498 | 133380 | 4000 | | 7150 | | | | | | 23000 | 24000 | 6650 | | | | | 0 | 51998 | 53650 | | 123300 | | 32000 Total Governmental Funds | | 1268716 | 908000.52 | 954630 | 4000 | 0 | 307495 | 141500 | 0 | 0 | 0 | 35000 | 23000 | 24000 | 17150 | 102300 | 7500 | 0 | 0 | 94500 | 774545.52 | 444950 | 0 | 650300 | | 378500 Water | | 29458 | 34109.130000000005 | 86090 | | 2000 | 98400 | | | | 29550 | | 23000 | | | 54450 | | 0 | 32000 | | -8490.869999999995 | 139000 | | 85000 Sewer | | 127704.49 | 301211 | 195130 | | 2000 | 142170 | | | | 29550 | | | | | 173250 | | | | | 238581 | 202800 | | 55000 Sanitation | | 19862 | 31500 | 27500 | | | 4000 | | | 24000 | | | | | | | | | | | 11500 | 24000 | | 0 Total Enterprise Funds | | 177024.49 | 366820.13 | 308720 | 0 | 4000 | 244570 | 0 | 0 | 24000 | 59100 | 0 | 23000 | 0 | 0 | 227700 | 0 | 0 | 32000 | 0 | 241590.13 | 365800 | | 140000 | | 0 Information Systems | | 19325 | 25193 | 27325 | 0 | | 4000 | | | | | | | | | | | | | | 29193 | 0 Total Internal Service Fund | | 19325 | 25193 | 27325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29193 | 0 | | 0 | | 0 Total City Funds | | 1465065.49 | 1300013.65 | 1290675 | 4000 | 4000 | 556065 | 141500 | 0 | 24000 | 59100 | 35000 | 46000 | 24000 | 17150 | 330000 | 7500 | 0 | 32000 | 94500 | 1045328.65 | 810750 | | 790300 | | 378500 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | Adopted 2016 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | 2016 | | 2017 | | Audited Beginning Balance 2015-2016 | | | | | In | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 | | | Audit Adjustment to $1,597,075 | Audit Ending Balance of $1,597,075 General Fund | | 535728.52 | 135032 | 629684.22 | | | 0 | 50000 | 9000 | 24500 | | 0 | | | | | | | | | | | 605184.22 | 83500 Streets | | 235401 | | 235401 | | -1000 | 240500 | | | | | | 41000 | 160000 | | | | | 165000 | | | | 108901 | 366000 Van Pool | | 47594 | 40001 | 87595 | 1000 | | | | | | | | | | | | | | | 36000 | | | 52595 | 36000 MSCB | | 37807 | | 37807 | | | | | | | | | | | | | | | | | | | 37807 | 0 Parks & Rec | | 94498 | 75000 | 169498 | 4000 | | 0 | | | | | | 0 | | 24500 | 42000 | 5300 | | | | | | 101698 | 71800 Total Governmental Funds | | 951028.52 | 250033 | 1159985.22 | 5000 | -1000 | 240500 | 50000 | 9000 | 24500 | 0 | 0 | 41000 | 160000 | 24500 | 42000 | 5300 | 0 | 165000 | 36000 | 0 | 0 | 906185.22 | 557300 | 0 | 0 | | 0 Water | | 34109.130000000005 | | 34109.130000000005 | | -2000 | 97000 | | | | | | 45000 | | | | | | | | | | 84109.13 | 45000 Sewer | | 301211 | | 301211 | | -2000 | 104000 | | | | | | 57000 | | | | | 10000 | 165000 | | | | 171211 | 232000 Sanitation | | 31500 | | 31500 | | | 0 | | | | | | | | | | | | | | | | 31500 | 0 | | 0 Total Enterprise Funds | | 366820.13 | 0 | 366820.13 | 0 | -4000 | 201000 | 0 | 0 | 0 | 0 | 0 | 102000 | 0 | 0 | 0 | 0 | 10000 | 165000 | 0 | 0 | 0 | 286820.13 | 277000 | | 0 | | 0 Information Systems | | 29193 | | 29193 | 0 | | 4000 | | | | | | | | | | | | | | | | 33193 | 0 Total Internal Service Fund | | 29193 | 0 | 29193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33193 | 0 | | 0 | | 0 Total City Funds | | 1347041.65 | 250033 | 1555998.35 | 5000 | -5000 | 445500 | 50000 | 9000 | 24500 | 0 | 0 | 143000 | 160000 | 24500 | 42000 | 5300 | 10000 | 330000 | 36000 | 0 | 0 | 1226198.35 | 834300 | | 0 | | 0 [59 non-empty rows] === Sheet: 2017 Adopted Fleet Schedule === | | Audit 2016 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | 8 | | Beginning | Additions | Deletions | | 2015-2016 | | | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor Equipment | Purchases | | | | | In | General Govt | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 General Fund | | 629684 | 0 | | 0 | | | | | | | | | | | | | | | | | 629684 | 0 Streets | | 235401 | | -1000 | 240500 | | | | | | | | | | | | | | | | | 474901 | 0 Van Pool | | 87595 | 1000 | | | | | | | | | | | | | | | | | | | 88595 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 MSCB | | 37807 | | | 11850 | | | | | | | | | | | | | | | | | 49657 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 Parks & Rec | | 169498 | 4000 | | 0 | 0 | | | | | | | | | | | | | | | | 173498 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 Total Governmental Funds | | 1159985 | 5000 | -1000 | 252350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1416335 | 0 Water | | 34109 | 0 | -2000 | 97000 | | | | | | | | | | | | | | | | | 129109 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 | 0 Sewer | | 301211 | 0 | -2000 | 104000 | | | | | | | | | | | | | | | | | 403211 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 | 0 Sanitation | | 31500 | 0 | | 0 | | | | | | | | | | | | | | | | | 31500 | 0 Total Enterprise Funds | | 366820 | 0 | -4000 | 201000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 563820 | 0 City Shop | | 0 | 0 | 0 | | | | | | | | | | | | | | | | | | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 | 0 Information Systems | | 29193 | 0 | | 4000 | | | | | | | | | | | | | | | | | 33193 | 0 Total Internal Service Fund | | 29193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 33193 | 0 4 Total City Funds | | 1555998 | 5000 | -5000 | 457350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 2013348 | 0 | | Adopted 2015 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | Beginning | Projected | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | Purchases 2016 | | 2015 | | 2013-2014 | Beginning 2014-2015 | 2014 Audit Ending Balance of $1,290,675 | | | In | Police | Fire 2 Pumper trucks | Sanitation truck | SKID Steer | Van Pool Van | 1/2 ton 4x4 truck | 1 ton truck | trailer | dump truck | Toolcat spreader | | 3/4 ton truck | New equipment for Ballfields | 2015 | 2015 General Fund | | 779601 | 629684 | 599705 | | | 30260 | 141500 | 0 | 0 | 0 | 0 | | | | | | | | | 518444 | 141500 | | 228000 | | 291500 Streets | | 267462 | 474901 | 186310 | | | 151585 | | | | | | | 0 | 10500 | 102300 | 0 | | | | 513686 | 112800 | | 299000 | | 55000 Van Pool | | 21661 | 88595 | 35235 | | | | | | | | 35000 | | | | | | | | | 53595 | 35000 | | 0 MSCB | | | 0 | 0 | | | 118500 | | | | | | | | | | 7500 | | | 94500 | 16500 | 102000 Parks & Rec | | 199992 | 173498 | 133380 | 4000 | | 7150 | | | | | | 23000 | 24000 | 6650 | | | | | 0 | 130998 | 53650 | | 123300 | | 32000 Total Governmental Funds | | 1268716 | 1366678 | 954630 | 4000 | 0 | 307495 | 141500 | 0 | 0 | 0 | 35000 | 23000 | 24000 | 17150 | 102300 | 7500 | 0 | 0 | 94500 | 1233223 | 444950 | 0 | 650300 | | 378500 Water | | 29458 | 129109 | 86090 | | 2000 | 98400 | | | | 29550 | | 23000 | | | 54450 | | 0 | 32000 | | 86509 | 139000 | | 85000 Sewer | | 127704.49 | 403211 | 195130 | | 2000 | 142170 | | | | 29550 | | | | | 173250 | | | | | 340581 | 202800 | | 55000 Sanitation | | 19862 | 31500 | 27500 | | | 4000 | | | 24000 | | | | | | | | | | | 11500 | 24000 | | 0 Total Enterprise Funds | | 177024.49 | 563820 | 308720 | 0 | 4000 | 244570 | 0 | 0 | 24000 | 59100 | 0 | 23000 | 0 | 0 | 227700 | 0 | 0 | 32000 | 0 | 438590 | 365800 | | 140000 | | 0 Information Systems | | 19325 | 33193 | 27325 | 0 | | 4000 | | | | | | | | | | | | | | 37193 | 0 Total Internal Service Fund | | 19325 | 33193 | 27325 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37193 | 0 | | 0 | | 0 Total City Funds | | 1465065.49 | 1963691 | 1290675 | 4000 | 4000 | 556065 | 141500 | 0 | 24000 | 59100 | 35000 | 46000 | 24000 | 17150 | 330000 | 7500 | 0 | 32000 | 94500 | 1709006 | 810750 | | 790300 | | 378500 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | Adopted 2016 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | 2016 | | 2017 | | Audited Beginning Balance 2015-2016 | | | | | In | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 | | | Audit Adjustment to $1,597,075 | Audit Ending Balance of $1,597,075 General Fund | | 535728.52 | 135032 | 629684.22 | | | 0 | 50000 | 9000 | 24500 | | 0 | | | | | | | | | | | 546184.22 | 83500 Streets | | 235401 | | 235401 | | -1000 | 240500 | | | | | | 41000 | 160000 | | | | | 165000 | | | | 108901 | 366000 Van Pool | | 47594 | 40001 | 87595 | 1000 | | | | | | | | | | | | | | | 36000 | | | 52595 | 36000 MSCB | | 37807 | | 37807 | | | 11850 | | | | | | | | | | | | | | | | 49657 | 0 Parks & Rec | | 94498 | 75000 | 169498 | 4000 | | 0 | | | | | | 0 | | 24500 | 42000 | 5300 | | | | | | 101698 | 71800 Total Governmental Funds | | 951028.52 | 250033 | 1159985.22 | 5000 | -1000 | 252350 | 50000 | 9000 | 24500 | 0 | 0 | 41000 | 160000 | 24500 | 42000 | 5300 | 0 | 165000 | 36000 | 0 | 0 | 859035.22 | 557300 | 0 | 0 | | 0 Water | | 34109.130000000005 | | 34109.130000000005 | | -2000 | 97000 | | | | | | 45000 | | | | | | | | | | 84109.13 | 45000 Sewer | | 301211 | | 301211 | | -2000 | 104000 | | | | | | 57000 | | | | | 10000 | 165000 | | | | 171211 | 232000 Sanitation | | 31500 | | 31500 | | | 0 | | | | | | | | | | | | | | | | 31500 | 0 | | 0 Total Enterprise Funds | | 366820.13 | 0 | 366820.13 | 0 | -4000 | 201000 | 0 | 0 | 0 | 0 | 0 | 102000 | 0 | 0 | 0 | 0 | 10000 | 165000 | 0 | 0 | 0 | 286820.13 | 277000 | | 0 | | 0 Information Systems | | 29193 | | 29193 | 0 | | 4000 | | | | | | | | | | | | | | | | 33193 | 0 Total Internal Service Fund | | 29193 | 0 | 29193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33193 | 0 | | 0 | | 0 Total City Funds | | 1347041.65 | 250033 | 1555998.35 | 5000 | -5000 | 457350 | 50000 | 9000 | 24500 | 0 | 0 | 143000 | 160000 | 24500 | 42000 | 5300 | 10000 | 330000 | 36000 | 0 | 0 | 1179048.35 | 834300 | | 0 | | 0 | | Projected Actual Expenses 2016 | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | 2017 | | 2016 | | Audited Beginning Balance 2015-2016 w Transfers | | | | | In | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 | | | Audit Adjustment to | Audit Ending Balance of $ General Fund | | 629684 | | | | | 0 | 38313 | 9233 | 21595 | | 0 | | | | | | | | | | | 560543 | 69141 | | 260000 Streets | | 474901 | | | | | | | | | | | 24447.1 | 157886 | | | | | 158381 | | | | 134186.90000000002 | 340714.1 | | 156000 Van Pool | | 88595 | | | | | | | | | | | | | | | | | | 29870.3 | | | 58724.7 | 29870.3 MSCB | | 49657 | | | | | | | | | | | | | | | | | | | | | 49657 | 0 Parks & Rec | | 173498 | | | | | | | | | | | 0 | | 21790.4 | 35382.33 | 4125 | | | | | | 112200.26999999999 | 61297.73 | | 195500 Total Governmental Funds | | 1416335 | 0 | 0 | 0 | 0 | 0 | 38313 | 9233 | 21595 | 0 | 0 | 24447.1 | 157886 | 21790.4 | 35382.33 | 4125 | 0 | 158381 | 29870.3 | 0 | 0 | 915311.87 | 501023.12999999995 | 0 | 611500 | | 0 Water | | 129109 | | | | | | | | | | | 24376.9 | | | | | | | | | | 104732.1 | 24376.9 | | 160000 Sewer | | 403211 | | | | | | | | | | | 22933 | | | | | 10000 | 141147.36 | | | | 229130.64 | 174080.36 | | 70000 Sanitation | | 31500 | | | | | | | | | | | | | | | | | | | | | 31500 | 0 | | 0 Total Enterprise Funds | | 563820 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 47309.9 | 0 | 0 | 0 | 0 | 10000 | 141147.36 | 0 | 0 | 0 | 365362.74 | 198457.25999999998 | | 230000 | | 0 Information Systems | | 33193 | | | | | | | | | | | | | | | | | | | | | 33193 | 0 Total Internal Service Fund | | 33193 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33193 | 0 | | 0 | | 0 Total City Funds | | 2013348 | 0 | 0 | 0 | 0 | 0 | 38313 | 9233 | 21595 | 0 | 0 | 71757 | 157886 | 21790.4 | 35382.33 | 4125 | 10000 | 299528.36 | 29870.3 | 0 | 0 | 1313867.6099999999 | 699480.3899999999 | | 841500 | | 0 | | Adopted 2017 Budget | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | | Purchases | Purchases | Ending | Purchases | | 2018 | | 2017 | | Audited Beginning Balance 2015-2016 | | | | | In | Police Cars (2) plus detective pickup | Fleet Forklift | Engineering Vehicle | Fire 2 Pumper trucks | 3/4 Truck | Heavy Duty 1 Ton Pickup | Excavator | 1/2 ton 4x4 truck (2) | Compressor | Mower | Power Vac & Meter read vheicle | Dump Truck | Van | 3/4 ton truck | | 2017 | 2017 | | | Audit Adjustment to | Audit Ending Balance of $ General Fund | | 546184.22 | | | | 0 | 176000 | 138000 | 0 | 0 | | 38000 | | | | | | | | | | | 546184.22 | 176000 | | 184500 | | 156000 | | | | | | | | | | | | | | | | | | | | | | | 0 Streets | | 108901 | | | 0 | | 223700 | | | | | | 0 | 0 | | 41000 | | | 0 | | | | 291601 | 41000 | | 290400 | | 260000 Van Pool | | 52595 | | | 28000 | | 0 | | | | | | | | | | | | | 35000 | | | 45595 | 35000 MSDCP | | 49657 | | | 4011 | | 4011 | | | | | | | | | | | | | | | | 57679 | 0 Parks & Rec | | 101698 | | | 4000 | | 116000 | | | | | 33000 | 40000 | | 0 | 0 | 43000 | | | | 0 | | 105698 | 116000 | | 163000 | | 91375 Emergency Vehicles | | | | | 177204 | | 100000 | | | | | | | | | | | | | | | | 277204 Total Governmental Funds | | 859035.22 | 0 | 0 | 213215 | 0 | 619711 | 138000 | 0 | 0 | 0 | 71000 | 40000 | 0 | 0 | 41000 | 43000 | 0 | 0 | 35000 | 0 | 0 | 1323961.22 | 368000 | 0 | 637900 | | 507375 Water | | 84109.13 | | | | -2000 | 112000 | | | | | | 0 | 0 | | | | 80000 | | | | | 114109.13 | 80000 | | 0 | | 25000 Sewer | | 171211 | | | | -2000 | 87000 | | | | | | 0 | 0 | | | | 0 | 0 | | | | 256211 | 0 | | 27000 Sanitation | | 31500 | | | | | | | | | | | | | | | | | | | | | 31500 | 0 | | 0 | | 22500 Total Enterprise Funds | | 286820.13 | 0 | 0 | 0 | -4000 | 199000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80000 | 0 | 0 | 0 | 0 | 401820.13 | 80000 | | 27000 | | 47500 Information Systems | | 33193 | | | | | 4000 | | | | | | | | | | | | | | | | 37193 | 0 Total Internal Service Fund | | 33193 | 0 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37193 | 0 | | 0 | | 0 Total City Funds | | 1179048.35 | 0 | 0 | 213215 | -4000 | 822711 | 138000 | 0 | 0 | 0 | 71000 | 40000 | 0 | 0 | 41000 | 43000 | 80000 | 0 | 35000 | 0 | 0 | 1762974.35 | 448000 | | 664900 | | 554875 Fire Trucks | | Bond Issue | | | | | 1080000 | | | | 1080000 | | | | | | | | | | | | | 1080000 | | 415000 | | | | | | | 1902711 | | | | | | | | | | | | | | | | | 1528000 [107 non-empty rows] === Sheet: 2017 Actual === | | Audit 2016 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | 8 | | Beginning | Additions | Deletions | | 2015-2016 | | | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor Equipment | Purchases | | | | | In | General Govt | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 General Fund | | 629684 | 0 | | 0 | | | | | | | | | | | | | | | | | 629684 | 0 Streets | | 235401 | | -1000 | 240500 | | | | | | | | | | | | | | | | | 474901 | 0 Van Pool | | 87595 | 1000 | | | | | | | | | | | | | | | | | | | 88595 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 MSCB | | 37807 | | | 11850 | | | | | | | | | | | | | | | | | 49657 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 Parks & Rec | | 169498 | 4000 | | 0 | 0 | | | | | | | | | | | | | | | | 173498 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 Total Governmental Funds | | 1159985 | 5000 | -1000 | 252350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1416335 | 0 Water | | 34109 | 0 | -2000 | 97000 | | | | | | | | | | | | | | | | | 129109 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 | 0 Sewer | | 301211 | 0 | -2000 | 104000 | | | | | | | | | | | | | | | | | 403211 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 | 0 Sanitation | | 31500 | 0 | | 0 | | | | | | | | | | | | | | | | | 31500 | 0 Total Enterprise Funds | | 366820 | 0 | -4000 | 201000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 563820 | 0 City Shop | | 0 | 0 | 0 | | | | | | | | | | | | | | | | | | 0 | 0 | | | | | | | | | | | | | | | | | | | | | | 0 | 0 Information Systems | | 29193 | 0 | | 4000 | | | | | | | | | | | | | | | | | 33193 | 0 Total Internal Service Fund | | 29193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 33193 | 0 4 Total City Funds | | 1555998 | 5000 | -5000 | 457350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 2013348 | 0 | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | Audited 2016 Schedule of Reserve funds in Fleet Management | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.680000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Minor equipment | Purchases | Purchases | Ending | Purchases | | 2016 | | 2017 | | Audited Beginning Balance 2015-2016 | | | | | In | Police Cars (1) | Police Radar Trailer | Engineering Vehicle | Fire 2 Pumper trucks | Fire Vehicle Pickup | Heavy Duty Pickup | Case Loader Replacment | 1/2 ton 4x4 truck (2) | Tractor | Mower | Sludge Pump | Dump Truck | | 3/4 ton truck | New equipment for Ballfields | 2016 | 2016 | | | Audit Adjustment to $1,597,075 | Audit Ending Balance of $1,597,075 General Fund | | 535728.52 | 135032 | 629684.22 | | | 0 | 40580.31 | 8848 | 22595.4 | | 0 | | | | | | | | | | | 557660.51 | 72023.70999999999 Streets | | 235401 | | 235401 | | -1000 | 240500 | | | | | | 39921.99 | 146607 | | | | | 157886 | | | | 130486.01000000001 | 344414.99 Van Pool | | 47594 | 40001 | 87595 | 11880 | | | | | | | | | | | | | | | 29870 | | | 69605 | 29870 MSCB | | 37807 | | 37807 | | | 11850 | | | | | | | | | | | | | | | | 49657 | 0 Parks & Rec | | 94498 | 75000 | 169498 | 4000 | | 0 | | | | | | 0 | | 21790.4 | 37321.33 | 4125 | | | | | | 110261.26999999999 | 63236.73 Total Governmental Funds | | 951028.52 | 250033 | 1159985.22 | 15880 | -1000 | 252350 | 40580.31 | 8848 | 22595.4 | 0 | 0 | 39921.99 | 146607 | 21790.4 | 37321.33 | 4125 | 0 | 157886 | 29870 | 0 | 0 | 917669.79 | 509545.42999999993 | 0 | 0 | | 0 Water | | 34109.130000000005 | | 34109.130000000005 | | -2000 | 97000 | | | | | | 42918.9 | | | | | | | | | | 86190.23000000001 | 42918.9 Sewer | | 301211 | | 301211 | | -2000 | 104000 | | | | | | 53688.89 | | | | | 3749.99 | 141360.72 | | | | 204411.4 | 198799.6 Sanitation | | 31500 | | 31500 | | | 0 | | | | | | | | | | | | | | | | 31500 | 0 | | 0 Total Enterprise Funds | | 366820.13 | 0 | 366820.13 | 0 | -4000 | 201000 | 0 | 0 | 0 | 0 | 0 | 96607.79000000001 | 0 | 0 | 0 | 0 | 3749.99 | 141360.72 | 0 | 0 | 0 | 322101.63 | 241718.5 | | 0 | | 0 Information Systems | | 29193 | | 29193 | 0 | | 4000 | | | | | | | | | | | | | | | | 33193 | 0 Total Internal Service Fund | | 29193 | 0 | 29193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33193 | 0 | | 0 | | 0 Total City Funds | | 1347041.65 | 250033 | 1555998.35 | 15880 | -5000 | 457350 | 40580.31 | 8848 | 22595.4 | 0 | 0 | 136529.78 | 146607 | 21790.4 | 37321.33 | 4125 | 3749.99 | 299246.72 | 29870 | 0 | 0 | 1272964.42 | 751263.9299999999 | | 0 | | 0 | | Adopted 2017 Budget | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.690000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | | Purchases | Purchases | Ending | Purchases | | 2018 | | 2017 | | Estimated ending 2015-2016 | Year end Transfers | | | | In | Police Cars (2) plus detective pickup | Fleet Forklift | Engineering Vehicle | Fire 2 Pumper trucks | 3/4 Truck | Heavy Duty 1 Ton Pickup | Excavator | 1/2 ton 4x4 truck (2) | Compressor | Mower | Power Vac & Meter read vheicle | Dump Truck | Van | 3/4 ton truck | | 2017 | 2017 | | | | Audit Ending Balance of $ General Fund | | 557660.51 | 244452 | 802112.51 | | -177204 | 176000 | 138000 | 0 | 0 | | 38000 | | | | | | | | | | | 624908.51 | 176000 | | 184500 | | 156000 Streets | | 130486.01000000001 | | 130486.01000000001 | 0 | -2700 | 223700 | | | | | | 0 | 0 | | 41000 | | | 0 | | | | 310486.01 | 41000 | | 290400 | | 260000 Van Pool | | 69605 | 10880.56 | 80485.56 | 28000 | | 0 | | | | | | | | | | | | | 35000 | | | 73485.56 | 35000 MSDCP | | 49657 | | 49657 | 4011 | | 4011 | | | | | | | | | | | | | | | | 57679 | 0 Parks & Rec | | 110261.26999999999 | | 110261.26999999999 | 4000 | | 116000 | | | | | 33000 | 40000 | | 0 | 0 | 43000 | | | | 0 | | 114261.26999999999 | 116000 | | 163000 | | 91375 Emergency Vehicles | | | 250000 | 250000 | 177204 | | 100000 | | | | | | | | | | | | | | | | 527204 | | | | | | | | | | | | | | | | | | | | | | | 0 Total Governmental Funds | | 917669.79 | 505332.56 | 1423002.35 | 213215 | -179904 | 619711 | 138000 | 0 | 0 | 0 | 71000 | 40000 | 0 | 0 | 41000 | 43000 | 0 | 0 | 35000 | 0 | 0 | 1708024.35 | 368000 | 0 | 637900 | | 507375 Water | | 86190.23000000001 | | 86190.23000000001 | | -2000 | 112000 | | | | | | 0 | 0 | | | | 80000 | | | | | 116190.23000000001 | 80000 | | 0 | | 25000 Sewer | | 204411.4 | | 204411.4 | | -2000 | 87000 | | | | | | 0 | 0 | | | | 0 | 0 | | | | 289411.4 | 0 | | 27000 Sanitation | | 31500 | | 31500 | | | | | | | | | | | | | | | | | | | 31500 | 0 | | 0 | | 22500 Total Enterprise Funds | | 322101.63 | 0 | 322101.63 | 0 | -4000 | 199000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80000 | 0 | 0 | 0 | 0 | 437101.63 | 80000 | | 27000 | | 47500 Information Systems | | 33193 | | 33193 | | | 4000 | | | | | | | | | | | | | | | | 37193 | 0 Total Internal Service Fund | | 33193 | 0 | 33193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37193 | 0 | | 0 | | 0 Total City Funds | | 1272964.42 | 505332.56 | 1778296.98 | 213215 | -183904 | 822711 | 138000 | 0 | 0 | 0 | 71000 | 40000 | 0 | 0 | 41000 | 43000 | 80000 | 0 | 35000 | 0 | 0 | 2182318.98 | 448000 | | 664900 | | 554875 Fire Trucks | | Bond Issue | | | | | 1080000 | | | | 1080000 | | | | | | | | | | | | | 1080000 | | 415000 | | | | | | | 1902711 | | | | | | | | | | | | | | | | | 1528000 | | Actual 2017 | | | | | | | | | | | | | | | | | | Prepared: | 2026-05-13 15:11:02.680000 | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | | Purchases | Purchases | Ending | Purchases | | 2018 | | 2017 | | Audited Beginning Balance 2016-2017 | 2017 | | | | In | Police Cars (2) plus detective pickup | Fleet Forklift | Engineering Vehicle | Fire 2 Pumper trucks | 3/4 Truck | Heavy Duty 1 Ton Pickup | Roller | 1/2 ton 4x4 truck (2) | PD generatorand compressor | Mower | Power Vac & Meter read vheicle | Dump Truck | Van | 3/4 ton truck | | 2017 | 2017 | | | Year End Transfers | Audit Ending Balance of $ General Fund | | 802112.51 | 200000 | | | -177204 | 176000 | 130842.06 | 0 | 0 | | 30347.959999999995 | | | | 11034.81 | | | | | | | 828683.68 | 172224.83 | | 184500 | | 156000 | | 0 | | | | | | | | | | | | | | | | | | | | | 0 Streets | | 130486.01000000001 | | | 0 | -2700 | 223700 | | | | | | 0 | 33023.86 | | 15288 | | | 0 | | | | 303174.15 | 48311.86 | | 290400 | | 260000 | | 0 Van Pool | | 80485.56 | 7865.8 | | 25881.26 | | 0 | | | | | | | | | | | | | 32101.11 | | | 82131.51 | 32101.11 | | 0 MSDCP | | 49657 | | | 4011 | | 4011 | | | | | | | | | | | | | | | | 57679 | 0 | | 0 Parks & Rec | | 110261.26999999999 | | | 4000 | | 116000 | | | | | 25845.46 | 34690.62 | | 0 | 0 | 36988.88 | | | | 0 | | 132736.31 | 97524.95999999999 | | 163000 | | 91375 | | 0 Emergency Vehicles | | 250000 | | | 177204 | | 100000 | | | | 514893 | | | | | | | | | | | | 12311 | 514893 Total Governmental Funds | | 1423002.35 | 207865.8 | 0 | 211096.26 | -179904 | 619711 | 130842.06 | 0 | 0 | 514893 | 56193.42 | 34690.62 | 33023.86 | 0 | 26322.809999999998 | 36988.88 | 0 | 0 | 32101.11 | 0 | 0 | 1416715.6500000001 | 865055.76 | 0 | 637900 | | 507375 Water | | 86190.23000000001 | | | | -2000 | 112000 | | | | | | 0 | 0 | | | | 39822.46 | | | | | 156367.77000000002 | 39822.46 | | 0 | | 25000 | | 0 Sewer | | 204411.4 | | | | -2000 | 87000 | | | | | | 0 | 0 | | | | 0 | 0 | | | | 289411.4 | 0 | | 27000 | | 0 Sanitation | | 31500 | | | | | | | | | | | | | | | | | | | | | 31500 | 0 | | 0 | | 22500 Total Enterprise Funds | | 322101.63 | 0 | 0 | 0 | -4000 | 199000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39822.46 | 0 | 0 | 0 | 0 | 477279.17000000004 | 39822.46 | | 27000 | | 47500 Information Systems | | 33193 | | | | | 4000 | | | | | | | | | | | | | | | | 37193 | 0 Total Internal Service Fund | | 33193 | 0 | 0 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37193 | 0 | | 0 | | 0 Total City Funds | | 1778296.98 | 207865.8 | 0 | 211096.26 | -183904 | 822711 | 130842.06 | 0 | 0 | 514893 | 56193.42 | 34690.62 | 33023.86 | 0 | 26322.809999999998 | 36988.88 | 39822.46 | 0 | 32101.11 | 0 | 0 | 1931187.8200000003 | 904878.22 | | 664900 | | 554875 [96 non-empty rows] === Sheet: Cash Flow === Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2017 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 1712813.78 | 1712813.78 | 0 | 0 | 0 | | 2965220.64 | | 0 | | 2965220.64 | | -899524.88 | | 39959.54 | -859565.34 2 | November | 114894.15 | 77356.55 | 37537.6 | 0 | 37537.6 | | 2965220.64 | | 0 | | 3002758.24 | | -78904.49 | | 40120.51 | -38783.98 3 | December | 170933.05 | 208470.65 | -37537.6 | 0 | 0 | | 3020775.56 | | 0 | | 3020775.56 | | -77681.37 | | 60340.5 | -17340.869999999995 4 | January | 81989.33 | 81989.33 | 0 | 0 | 0 | | 3016322.81 | | 0 | | 3016322.81 | | -77536.58 | | 81989.33 | 4452.75 5 | February | 78843.36 | 78843.36 | 0 | 0 | 0 | | 3015088.5 | | 0 | | 3015088.5 | | -77609.05 | | 78843.36 | 1234.3099999999977 6 | March | 131999.62 | 131999.62 | 0 | 0 | 0 | | 2961306.83 | | 0 | | 2961306.83 | | -77648.02 | | 131999.62 | 54351.59999999999 7 | April | 549095.62 | 549095.62 | 0 | 0 | 0 | | 2489909.35 | | 0 | | 2489909.35 | | -78267.47 | | 549095.62 | 470828.15 8 | May | 86574.77 | 86574.77 | 0 | 0 | 0 | | 2493676.02 | | 0 | | 2493676.02 | | -81455.44 | | 82808.1 | 1352.6600000000035 9 | June | 135912.84 | 135912.84 | 0 | 0 | 0 | | 2437427.78 | | 0 | | 2437427.78 | | -80367.7 | | 135912.84 | 55545.14 10 | July | 79199.11 | 119548.64 | 0 | 0 | -40349.53 | | 2437427.78 | | 0 | | 2397078.25 | | -79816.21 | | 119548.64 | 39732.42999999999 11 | August | 0 | 0 | 0 | 0 | 0 | | 2437427.78 | | 0 | | 2437427.78 | | -78267.47 | | 60000 | -18267.47 12 | September | 0 | 0 | 0 | 0 | 0 | | 2437427.78 | | 0 | | 2437427.78 | | -78267.47 | | 810000 | 731732.53 | | | | | | | | | | | | | | -1765346.15 | | 2190618.06 | 425271.91000000015 | | Estimated Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2016 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 531269.74 | 91372.91 | 439896.83 | 0 | 439896.83 | | 1911135.31 | | 0 | | 2351032.14 | | -529881.23 | | 44432.19 | -485449.04 2 | November | 72531.23 | 502428.06 | -429896.83 | 0 | 10000 | | 2221432.55 | | 0 | | 2231432.55 | | -74175.39 | | 192130.82 | 117955.43000000001 3 | December | 75981.42 | 85981.42 | -10000 | 0 | 0 | | 2239148.73 | | 0 | | 2239148.73 | | -73444.01 | | 66102.46 | -7341.549999999988 4 | January | 73575.22 | 73575.22 | 0 | 0 | 0 | | 2272923.88 | | 0 | | 2272923.88 | | -74410.07 | | 39800.07 | -34610.00000000001 5 | February | 128714.12 | 128714.12 | 0 | 0 | 0 | | 2219899.49 | | 0 | | 2219899.49 | | -75468.22 | | 128666.21 | 53197.990000000005 6 | March | 348241.03 | 348241.03 | 0 | 0 | 0 | | 1946252.94 | | 0 | | 1946252.94 | | -74441.13 | | 348071.24 | 273630.11 7 | April | 73238.63 | 73238.63 | 0 | 0 | 0 | | 1973142.46 | | 0 | | 1973142.46 | | -73199.83 | | 46020.59 | -27179.240000000005 8 | May | 75025.72 | 75025.72 | 0 | 0 | 0 | | 2010308.3 | | 0 | | 2010308.3 | | -74022.82 | | 37859.88 | -36162.94000000001 9 | June | 108195.96 | 108195.96 | 0 | 0 | 0 | | 1978587.15 | | 0 | | 1978587.15 | | -76474.81 | | 108195.96 | 31721.15000000001 10 | July | 220968.93 | 220968.93 | 0 | 0 | 0 | | 1832541.06 | | 0 | | 1832541.06 | | -74922.84 | | 220968.93 | 146046.09 11 | August | 74252.02 | 74252.02 | 0 | 0 | 0 | | 1870864.27 | | 0 | | 1870864.27 | | -74362.02 | | 35928.81 | -38433.21000000001 12 | September | 85291.31 | 85291.31 | 0 | 0 | 0 | | 2141797.33 | | 0 | | 2141797.33 | | -340006.9 | | 105325.87 | -234681.03000000003 | | | | | | | | | | | | | | -1614809.27 | | 1373503.0299999998 | -241306.24000000005 Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2015 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 129804.26 | 159804.26 | -30000 | 0 | 0 | | 1170236.9 | | 485662.69 | | 1655899.5899999999 | | -130891.76 | | 45225.4 | -85666.35999999999 2 | November | 123590.52 | 123590.52 | 0 | 0 | 0 | | 1249038.57 | | 487205.68 | | 1736244.25 | | -126875.59 | | 44788.85 | -82086.73999999999 3 | December | 127503.37 | 127503.37 | 0 | 0 | 0 | | 1307178.42 | | 484472.38 | | 1791650.7999999998 | | -122994.7 | | 69363.52 | -53631.17999999999 4 | January | 608643.19 | 608643.19 | 0 | 0 | 0 | | 1804583.91 | | | | 1804583.91 | | -125530.5 | | 111237.7 | -14292.800000000003 5 | February | 141456.69 | 141456.69 | 0 | 0 | 0 | | 1892327.27 | | | | 1892327.27 | | -140097 | | 53713.33 | -86383.67 6 | March | 128393.67 | 128393.67 | 0 | 0 | 0 | | 1939977.21 | | | | 1939977.21 | | -128843.83 | | 80743.73 | -48100.100000000006 7 | April | 159448.62 | 159448.62 | 0 | 0 | 0 | | 1904396.35 | | | | 1904396.35 | | -123960.75 | | 159302.12 | 35341.369999999995 8 | May | 127957.56 | 127957.56 | 0 | 0 | 0 | | 1956184.04 | | | | 1956184.04 | | -127718.07 | | 76169.87 | -51548.20000000001 9 | June | 124343.03 | 124343.03 | 0 | 0 | 0 | | 2001393.53 | | | | 2001393.53 | | -125711.67 | | 79133.54 | -46578.130000000005 10 | July | 126022.95 | 126022.95 | 0 | 0 | 0 | | 2083407.84 | | | | 2083407.84 | | -125188.8 | | 44008.64 | -81180.16 11 | August | 319829.35 | 319829.35 | 0 | 0 | 0 | | 1889003.41 | | | | 1889003.41 | | -124380.15 | | 319769.23 | 195389.08 12 | September | 131971.14 | 131971.14 | 0 | 0 | 0 | | 1911135.31 | | | | 1911135.31 | | -144967.43 | | 169621.78 | 24654.350000000006 | | | | | | | | | | | | | | -1547160.2499999998 | | 1253077.7100000002 | -294082.54000000004 Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2014 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 86773.27 | 96773.27 | -10000 | 0 | 0 | | 1277273.34 | | 490330.28 | | 1767603.62 | | -92451.72 | | 40362.95 | -52088.770000000004 2 | November | 89623.14 | 89623.14 | 0 | 0 | 0 | | 1314954.88 | | 482302.84 | | 1797257.72 | | -80931.92 | | 51277.82 | -29654.1 3 | December | 91759.85 | 91759.85 | 0 | 0 | 0 | | 1336639.53 | | 472507.43 | | 1809146.96 | | -76740.3 | | 63911.05 | -12829.25 4 | January | 88014.79 | 88014.79 | 0 | 0 | 0 | | 1348264.06 | | 458226.08 | | 1806490.1400000001 | | -72765.93 | | 76340.26 | 3574.3300000000017 5 | February | 88581.7 | 88581.7 | 0 | 0 | 0 | | 1389785.84 | | 489474.52 | | 1879260.36 | | -119615.92 | | 46868.2 | -72747.72 6 | March | 91098.22 | 91098.22 | 0 | 0 | 0 | | 1437120.19 | | 488183.05 | | 1925303.24 | | -89806.75 | | 43763.97 | -46042.78 7 | April | 145911.28 | 145911.28 | 0 | 0 | 0 | | 1406228.38 | | 488402.01 | | 1894630.39 | | -116236.18 | | 145911.28 | 29675.100000000006 8 | May | 116057.29 | 116057.29 | 0 | 0 | 0 | | 1381699.18 | | 488082.81 | | 1869781.99 | | -94614.84 | | 116057.29 | 21442.449999999997 9 | June | 153382.14 | 153382.14 | 0 | 0 | 0 | | 1319355.16 | | 487497.14 | | 1806852.2999999998 | | -89716.54 | | 153382.14 | 63665.60000000002 10 | July | 152854.6 | 152854.6 | 0 | 0 | 0 | | 1258941.62 | | 485128.42 | | 1744070.04 | | -86172.34 | | 152532.29 | 66359.95000000001 11 | August | 332485.61 | 332485.61 | 0 | 0 | 0 | | 1013276.81 | | 485902.46 | | 1499179.27 | | -86987.79 | | 331885.61 | 244897.82 12 | September | 276273.39 | 246273.39 | 30000 | 0 | 30000 | | 1078698.04 | | 483238.34 | | 1591936.3800000001 | | -316274.26 | | 245269.96 | -71004.30000000002 | | | | | | | | | | | | | | -1322314.49 | | 1467562.82 | 145248.33000000005 Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2013 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 97481.08 | 34136.99 | 63344.09 | 0 | 73344.09 | | 764426.92 | | 876080.85 | | 1713851.8599999999 | | -95651.83 | | 13188.65 | -82463.18000000001 2 | November | 97311.75 | 170655.84 | -73344.09 | 0 | 0 | | 808951.97 | | 876955.35 | | 1685907.3199999998 | | -95534.64 | | 123225.36 | 27690.72 3 | December | 94770.74 | 94770.74 | 0 | 0 | 0 | | 870958.34 | | 876946.65 | | 1747904.99 | | -94650.09 | | 31860.69 | -62789.399999999994 4 | January | 93822.34 | 93822.34 | 0 | 0 | 0 | | 894694.53 | | 871349.46 | | 1766043.99 | | -88116.75 | | 70086.15 | -18030.600000000006 5 | February | 95251.97 | 95251.97 | 0 | 0 | 0 | | 915836.7 | | 874463.9 | | 1790300.6 | | -97606.87 | | 74033.59 | -23573.28 6 | March | 113100.11 | 113100.11 | 0 | 0 | 0 | | 919257.18 | | 874404 | | 1793661.1800000002 | | -113040.21 | | 109679.63 | -3360.5800000000017 7 | April | 98054.04 | 98054.04 | 0 | 0 | 0 | | 915330.41 | | 877716.54 | | 1793046.9500000002 | | -97439.81 | | 98054.04 | 614.2299999999959 8 | May | 158445.38 | 158445.38 | 0 | 0 | 0 | | 854910.12 | | 862207.03 | | 1717117.15 | | -82515.58 | | 158445.38 | 75929.8 9 | June | 141222.72 | 141222.72 | 0 | 0 | 0 | | 917823.31 | | 834279.68 | | 1752102.9900000002 | | -71280.99 | | 35152.83 | -36128.16 10 | July | 142012.77 | 142012.77 | 0 | 0 | 0 | | 871801.79 | | 827791.99 | | 1699593.78 | | -88361.24 | | 142012.77 | 53651.529999999984 11 | August | 107395.68 | 107395.68 | 0 | 0 | 0 | | 1092486.24 | | 494124.95 | | 1586611.19 | | -26271.36 | | 86711.23 | 60439.869999999995 12 | September | 168392.98 | 158392.98 | 10000 | 0 | 10000 | | 1248451.83 | | 487007.96 | | 1745459.79 | | -319495.45 | | 190591.79 | -128903.66 | | | | | | | | | | | | | | -1269964.8199999998 | | 1133042.1099999999 | -136922.71000000005 Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2012 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 529317.75 | 529567.75 | -250 | 0 | 0 | | 406787.11 | | 1267756.42 | | 1674543.5299999998 | | -95510.05 | | 18149.97 | -77360.08 2 | November | 767013.31 | 771013.31 | -4000 | 0 | -4000 | | 1065850.87 | | 631882.97 | | 1693733.84 | | -95401.16 | | 109139.93 | 13738.76999999999 3 | December | 465179.67 | 461179.67 | 4000 | 0 | 0 | | 1209584.18 | | 375663.32 | | 1585247.5 | | -91832.03 | | 202489.29 | 110657.26000000001 4 | January | 591416.29 | 591416.29 | 0 | 0 | 0 | | 768734.46 | | 876308.56 | | 1645043.02 | | -93149.4 | | 32079.75 | -61069.649999999994 5 | February | 84675.68 | 84048.49 | 627.19 | 0 | 627.19 | | 768734.46 | | 871904.85 | | 1641266.5 | | -81104.67 | | 84048.49 | 2943.820000000007 6 | March | 1104414.15 | 1105041.34 | -627.19 | 0 | 0 | | 512689.96 | | 866458.73 | | 1379148.69 | | -93110.39 | | 356104.92 | 262994.52999999997 7 | April | 112166.78 | 112166.78 | 0 | 0 | 0 | | 539318.43 | | 874558.48 | | 1413876.9100000001 | | -105095.12 | | 71597.01 | -33498.11 8 | May | 108002.88 | 114216.38 | -6213.5 | 0 | -6213.5 | | 599366.95 | | 875471.91 | | 1468625.3599999999 | | -98466.53 | | 44932.56 | -53533.97 9 | June | 203252.45 | 203252.45 | 0 | 0 | -6213.5 | | 460479.1 | | 873794.46 | | 1328060.06 | | -33903.37 | | 173333.45 | 139430.08000000002 10 | July | 87587.53 | 87587.53 | 0 | 0 | -6213.5 | | 495205.41 | | 875900.63 | | 1364892.54 | | -87610.46 | | 52861.22 | -34749.240000000005 11 | August | 130381.91 | 123181.91 | 7200 | 0 | 986.5 | | 552391.2 | | 875601.57 | | 1428979.27 | | -131270.41 | | 65996.12 | -65274.29000000001 12 | September | 91908.16 | 82894.66 | 9013.5 | 0 | 10000 | | 764426.92 | | 876080.85 | | 1650507.77 | | -295281.74 | | 94313.71 | -200968.02999999997 | | | | | | | | | | | | | | -1301735.33 | | 1305046.42 | 3311.0900000000547 Fleet | 290-000-00-101-01 | | | | | | | 290-000-00-103-01 | | 290-000-00-103-05 2011 | Month | Cash | Expenses | Balance | | Cash Balance | | Balance | | Balance | | Total Cash & Investments | | Revenue | | Expense | Rev vs Exp 1 | October | 528641.81 | 526525.19 | 2116.62 | 0 | 2366.62 | | 915583.53 | | 1115899.13 | | 2033849.2799999998 | | -75806.76 | | 18857.17 | -56949.59 2 | November | 504245.79 | 506612.41 | -2366.62 | 0 | 0 | | 512775.41 | | 1341879.16 | | 1854654.5699999998 | | -68586.62 | | 248750.15 | 180163.53 3 | December | 471577.15 | 471577.15 | 0 | 0 | 0 | | 381862.94 | | 1420901.21 | | 1802764.15 | | -36684.09 | | 88701.18 | 52017.09 4 | January | 348474.09 | 328474.09 | 20000 | 0 | 20000 | | 668143.61 | | 1142588.26 | | 1830731.87 | | -72072.81 | | 42193.42 | -29879.39 5 | February | 450556.92 | 465556.92 | -15000 | 0 | 5000 | | 310274.37 | | 1260320.46 | | 1575594.83 | | -78995.24 | | 333906.92 | 254911.68 6 | March | 111693.6 | 111693.6 | 0 | 0 | 5000 | | 357468.27 | | 1255079.66 | | 1617547.93 | | -75631.2 | | 64499.7 | -11131.5 7 | April | 611789.85 | 611789.85 | 0 | 0 | 5000 | | 898674.06 | | 730323.85 | | 1633997.9100000001 | | -86198.71 | | 70397.8 | -15800.910000000003 8 | May | 628536.84 | 590062.96 | 38473.88 | 0 | 43473.88 | | 351202.7 | | 1277795.21 | | 1672471.79 | | -74971.24 | | 34466.6 | -40504.64000000001 9 | June | 441430.59 | 479904.47 | -38473.88 | 0 | 5000 | | 6423.84 | | 1528752.79 | | 1540176.6300000001 | | -86774.58 | | 220185.79 | 133411.21000000002 10 | July | 80746.29 | 50746.29 | 30000 | 0 | 35000 | | 17021.55 | | 1545462.71 | | 1597484.26 | | -97265.95 | | 39957.32 | -57308.63 11 | August | 430270.1 | 465270.1 | -35000 | 0 | 0 | | 331984.06 | | 1209417.21 | | 1541401.27 | | -76354.08 | | 132009.98 | 55655.90000000001 12 | September | 1370912.22 | 1370662.22 | 250 | 0 | 250 | | 179535.53 | | 1453718.31 | | 1633503.84 | | -216943.82 | | 147618.47 | -69325.35 | | | | | | | | | | | | | | -1046285.0999999999 | | 1441544.5 | 395259.4 [105 non-empty rows] === Sheet: 2018 === | | Adopted 2017 Budget | | | | | | | | | | | | | | | | | | Prepared: | 2017-02-09 09:27:10.650000 | | | | | | | | | | | | | | | | | | | | | | | | | | | | Projected | | Delayed Purchases | | | | | Additions | Deletions | Transfers | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | Purchases | | Purchases | Purchases | Ending | Total Budgeted Purchases | | Actual 2017 Purchases | Actual 2017 Ending | 2018 | | 2017 | | Audited Beginning Balance 2016-2017 | | | | | In | Police Cars (2) plus detective pickup | Fleet Forklift | Engineering Vehicle | Fire 2 Pumper trucks | 3/4 Truck | Heavy Duty 1 Ton Pickup | Excavator | 1/2 ton 4x4 truck (2) | Compressor | Mower | Power Vac & Meter read vheicle | Dump Truck | Van | 3/4 ton truck | Roller | 2017 | 2017 | | | Audit Adjustment to | 2017 Audit Ending Balance of $ General Fund | | 557660.51 | 244452.3 | 802112.81 | | -177204 | 176000 | 138000 | 0 | 0 | | 38000 | | | | 36000 | | | | | | | 588908.81 | 212000 | | 221728.53 | 579180.28 | 184500 | | 156000 Streets | | 130486.01000000001 | | 130486.01000000001 | 0 | -2700 | 223700 | | | | | | 0 | 0 | | 41000 | | | 0 | | | 45000 | 265486.01 | 86000 | | 67306.86 | 284179.15 | 290400 | | 260000 Van Pool | | 69605 | 10880.56 | 80485.56 | 28000 | | 0 | | | | | | | | | | | | | 35000 | | | 73485.56 | 35000 | | 32101.11 | 76384.45 MSDCP | | 49657 | | 49657 | 4011 | | 4011 | | | | | | | | | | | | | | | | 57679 | 0 | | | 57679 Parks & Rec | | 110261.26999999999 | | 110261.26999999999 | 4000 | | 116000 | | | | | 33000 | 40000 | | 0 | 0 | 43000 | | | | 0 | | 114261.26999999999 | 116000 | | 128585.66999999998 | 101675.6 | 211500 | | 91375 Emergency Vehicles | | | 250000 | 250000 | 177204 | | 100000 | | | | 515000 | | | | | | | | | | | | 12204 | 515000 | | 514893 | 12311 | | | | | | | | | | | | | | | | | | | | | | | 0 Total Governmental Funds | | 917669.79 | 505332.86 | 1423002.6500000001 | 213215 | -179904 | 619711 | 138000 | 0 | 0 | 515000 | 71000 | 40000 | 0 | 0 | 77000 | 43000 | 0 | 0 | 35000 | 0 | 45000 | 1112024.6500000001 | 964000 | 0 | 964615.1699999999 | 1111409.48 | 637900 | | 507375 Water | | 86190.23000000001 | | 86190.23000000001 | | -2000 | 112000 | | | | | | 0 | 0 | | | | 80000 | | | | | 116190.23000000001 | 80000 | | 39822.46 | 156367.77000000002 | 0 | | 25000 Sewer | | 204411.4 | | 204411.4 | | -2000 | 87000 | | | | | | 0 | 0 | | | | 0 | 0 | | | | 289411.4 | 0 | | | 289411.4 | 27000 Sanitation | | 31500 | | 31500 | | | | | | | | | | | | | | | | | | | 31500 | 0 | | | 31500 | 0 | | 22500 Total Enterprise Funds | | 322101.63 | 0 | 322101.63 | 0 | -4000 | 199000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80000 | 0 | 0 | 0 | 0 | 437101.63 | 80000 | 0 | 39822.46 | 477279.17000000004 | 27000 | | 47500 Information Systems | | 33193 | | 33193 | | | 4000 | | | | | | | | | | | | | | | | 37193 | 0 | | | 37193 Total Internal Service Fund | | 33193 | 0 | 33193 | 0 | 0 | 4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37193 | 0 | 0 | 0 | 37193 | 0 | 0 | 0 Total City Funds | | 1272964.42 | 505332.86 | 1778297.2800000003 | 213215 | -183904 | 822711 | 138000 | 0 | 0 | 515000 | 71000 | 40000 | 0 | 0 | 77000 | 43000 | 80000 | 0 | 35000 | 0 | 45000 | 1586319.2800000003 | 1044000 | 0 | 1004437.6299999999 | 1625881.65 | 664900 | #VALUE! | 554875 Fire Trucks | | Bond Issue | | | | | 1080000 | | | | 1080000 | | | | | | | | | | | | | 1080000 | | | | 415000 | | | | | | | 1902711 | | | | | | | | | | | | | | | | | 1528000 | | | | | | | | | | | | | | | | | | Prepared: | 2017-02-09 09:27:10.650000 | | | | | Revenues and accumulation | | | | Expenses | Estimated Beginning 2017-2018 | Actual Beginning 2018 Adjustment | Allocate | Other Revenue | Grants | Transfers in from Other Funds | 2018 Approved Budget | 2018 Minor Equip | 2018 Expense Proposed Plan | 2019 Projected Beginning | 2017 Designated Accumulation | 2018 Budgeted Accum Additions | 2018 Designated Accumulation | Actual Beginning 2019 Adjustment | Allocate | Other Revenue | Grants | Transfers in from Other Funds | 2019 Expense | 2020 Projected Beginning General Fund | -508909 | -200000 | 20000 | | 0 | 0 | | | | -688909 | | | 0 | 0 | | | | | | -688909 | | | | | | | | | | 0 | | | 0 Fleet | -80000 | | | | | | 80000 | | 84500 | 0 | -80000 | 80000 | 0 | | | | | | | 0 | | | | | | | | | | 0 | | | 0 Public Safety | | | -20000 | | | | 84000 | | 314000 | 64000 | | -100000 | -100000 | | | | | | 175000 | 39000 | | | | | | | | | | 0 | | | 0 Streets | -265486 | | | 0 | | -116514 | 168000 | 4000 | 426400 | -210000 | -135000 | -75000 | -210000 | | | | | | 263500 | -366500 | | | | | | | | | | 0 | | | 0 Van Pool | -73486 | | 30750 | 0 | 0 | 0 | | | | -42736 | -40595 | | -40595 | | | | | | 32000 | -91926 | | | | | | | | | | 0 | | | 0 MSDCP | -57679 | | | -4011 | | -4011 | | | | -65701 | -57769 | | -57769 | | | | | | | -181239 | | | | | | | | | | 0 | | | 0 Parks & Rec | -114261 | | -34750 | 0 | 0 | 0 | 48000 | 3800 | 211500 | -97211 | 0 | -30750 | -30750 | | | | | | | -158711 | | | | | | | | | | 0 | | | 0 Emergency Vehicles | -12204 | | | 0 | | -350000 | 0 | | 540000 | -362204 | -12204 | -350000 | -362204 | | | | | -350000 | 540000 | -896612 Total Governmental Funds | -1112025 | -200000 | -4000 | -4011 | 0 | -470525 | 380000 | 7800 | 1576400 | -1402761 | -325568 | -475750 | -801318 | 0 | 0 | 0 | 0 | -350000 | 1010500 | -2344897 | | | | | | | | | | | | | 0 | | | | | | | | | | | | | 0 Water | -116190 | | 2000 | 0 | 0 | -75500 | 47000 | 2000 | 151000 | -140690 | -80000 | -24500 | -104500 | | | | | | | -349690 | | | | | | | | | | 0 | | | 0 Sewer | -289411 | 0 | 2000 | 0 | 0 | -59000 | 27000 | | 127000 | -319411 | -120000 | -30000 | -150000 | | | | | | 53300 | -566111 | | | | | | | | | | 0 | | | 0 Sanitation | -31500 | 0 | 0 | 0 | 0 | 0 | | | 0 | -31500 | -31500 | | -31500 | | | | | | | -94500 Total Enterprise Funds | -437101 | 0 | 4000 | 0 | 0 | -134500 | 74000 | 2000 | 278000 | -491601 | -231500 | -54500 | -286000 | 0 | 0 | 0 | 0 | 0 | 53300 | -1010301 | | | | | | | | | | | | | 0 Information Systems | -37193 | | | | | -4000 | | | 0 | -41193 | -37193 | | -37193 | | | | | | | -115579 Total Internal Service Fund | -37193 | 0 | 0 | 0 | 0 | -4000 | 0 | | 0 | -41193 | -37193 | 0 | -37193 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | | | | | | | | | 0 Total City Funds | -1586319 | -200000 | 0 | -4011 | 0 | -609025 | 454000 | 9800 | 1854400 | -1935555 | -594261 | -530250 | -1124511 | 0 | 0 | 0 | 0 | -350000 | 1063800 | -3355198 | | | | | | | | | | | 1400400 2018 Budget Requests | | | | | | | New Accumulation Fleet | 80000 | Shared purchase with Water ($25,000) for a forklift | | | | | Fleet | | 0 | Used accumulation Public Safety | 84000 | Shared purchase with Water ($25,000) for a forklift | | | | | Public Safety | | 100000 | Two police cars Streets | 168000 | Backhoe $100,000, Hydraulic power unit $15,000, supershot melter $53,000 | | | | | Streets | | 75000 | Prior year for excavator Rec & Culture | 48000 | Toolcat | | | | | Rec & Culture | | 30750 | $12,250 for half 1/2 ton pickup, $18,500 for half of 1 ton truck Water | 47000 | Vaccuum unit $22,000, Share of forklift with fleet $25,000 | | | | | Water | | 24500 | 1/2 ton pickup Sewer | 27000 | 3/4 ton pickup | | | | | Sewer | | 30000 | Partial accum for freightliner sludge truck | | | | | | | Emergency | | 350000 | Firetruck Total New Requests | 454000 Fiscal Year | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | | | 2042 | 2043 | 2044 | 2045 Accumulation funded with general fund budgeted transfers and/or year end capital transfers and/or unanticipated fund balance or property tax foregone amount ($269,368). Fire Trucks Accumulation | -527204 | -350000 | -350000 | -367796 | -200000 | -200000 | -200000 | -200000 | -200000 | -200000 | -200000 | -200000 | -200000 | -200000 | -150000 | -150000 | -150000 | -150000 | -150000 | -150000 | -150000 | -150000 | -150000 | -150000 | -200000 | | | -200000 | -200000 | -200000 | -200000 Contributions-U of I | | 0 | | | | | | -600000 | | | 0 | | | | | | | | | | | 0 | 0 | 0 Fire Trucks | 515000 | | 540000 | 540000 | | | 70000 | | 0 | | 1200000 | 0 | 540000 | | | | 650000 | | | | | 650000 | 70000 | 600000 | | | | | | | 1200000 Balance | -12204 | -362204 | -172204 | 0 | -200000 | -400000 | -530000 | -1330000 | -1530000 | -1730000 | -730000 | -930000 | -590000 | -790000 | -940000 | -1090000 | -590000 | -740000 | -890000 | -1040000 | -1190000 | -690000 | -770000 | -320000 | -520000 | | | -720000 | -920000 | -1120000 | -120000 From Long Range Municast Software Tab 12 Fund Balance 2016 | | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 Estimate | | 2018 Plan | 2019 Plan | 2020 Plan | 2021 Plan | 2022 Plan | 2023 Plan | 2024 Plan | 2025 Plan | 2026 Plan | 2027 Plan | 2028 Plan | 2029 Plan | 2030 Plan NET ASSETS IS RESTRICTED | | 585495 | 860368 | 19325 | 27325 | 29193 | 33193 | 37193 | | Remaining Unfunded NET ASSETS GENGOVE RESTRICTED | | 11325 | 15325 | 793919 | 590580.52 | 629684.22 | 524909 | 624909 | | | 175000 | 191500 | 128500 | 49500 | 0 | 99000 | 60000 | | | 60000 NET ASSETS STREETS RESTRICTED | | 317623 | 101832 | 278032 | 186310 | 235401 | 130486 | 313186 | | 210000 | 263500 | 222000 | 245000 | 231500 | 226000 | 214000 | 110000 | 115000 | 140000 NET ASSETS PARKSREC RESTRICTED | | 149394 | 103691 | 203991 | 133380 | 169499 | 159918 | 171940 | | 132750 | 108570 | 110500 | 112875 | 80000 | 47000 | 66000 | | | | 6650 NET ASSETS-VAN POOL | | | | | 35234 | 87594 | 80486 | 73486 | | | 32000 | 32000 NET ASSETS - SANITATION RESTRI | | | | 19862 | 27500 | 31500 | 31500 | 31500 | | 29000 NET ASSETS-WATER RESTRICTED | | | | 31458 | 86089 | 34109 | 86190 | 116190 | | 24500 | 88500 | 50000 | 69500 | 82000 | 96400 | 116000 | 92000 | | | | 5000 NET ASSETS-SEWER RESTRICTED | | | | 119195 | 195128 | 301211 | 204411 | 289411 | | 0 | 53300 | 60000 | 90000 | 95000 | 85000 | 107000 | 85000 | 82000 | 200000 | 154000 EMERGENCY VEHICLES | | | | | | | 527204 | 527204 | | 177796 | 540000 | 540000 | | 20000 | 50000 | | | | 1200000 | | 540000 NET ASSETS - UNRESTRICTED | | 143781 | 0 | 0 | 0 | -73175 | -5676 | | | | | | | 1772621 | 2185019 | | 574046 | 1260870 | 1206000 | 645875 | 558000 | 504400 | 602000 | 347000 | 197000 | 1540000 | 220650 | 545000 | 0 NET ASSETS - UNRESTRICTED WC | | 128394 | 229904 | 249734 | 288720 | 308351 | 333034 Primary revenue 448-01 and 448-02 Fleet Fund | | | | Anticipate an additional $229,000 | | | RECOMMENDATIONS | | | LGIP | | Investments Ending fund Balance 2016 | | 1778297 | | Transfers In for FY2017 | | | Operations Cash Flow | | | 240000 Sep 29,2017 | | | | | | | Capital Outlay 2017 remaining | | | 40000 Cash | | | 70408.8 | Trial Balance | | | Capital Outlay 2018 | | | | | 454000 | recommend investments for6 months LGIP | | | -2424238.88 | Trial Balance | | | Fire Truck 2019 | | | | | 540000 | recommend investments 18 months SUBTOTAL | | | -2353830.08 | | | | Working Capital | | | | | 335000 | recommend investments 3 years OBLIGATIONS | | | | | | | One year depreciation (2016) | | | | | 528743 | recommend investments 2 years Operations Cash Flow | | | 240000 | recommend LGIP Capital Outlay 2017 remaining | | | 40000 | recommend LGIP Capital Outlay 2018 | | | 454000 | recommend investments for one year | | | Cash & Investments | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 Fire Truck 2019 | | | 540000 | recommend investments 1 year | | | Low | 1540176.6300000001 | 1328060.06 | 1586611.19 | 1499179.27 | 1655899.5899999999 | 1832541.06 | 2403769.96 Working Capital | | | 335000 | recommend investments 3 years | | | Average | 1694514.860833333 | 1522827.0824999998 | 1732633.4825000002 | 1782626.0341666664 | 1880516.9591666667 | 2088994.1916666664 | 2780625.5690000006 One year depreciation (2016) | | | 528743 | recommend investments 2 years | | | High | 2033849.2799999998 | 1693733.84 | 1793661.1800000002 | 1925303.24 | 2083407.84 | 2351032.14 | 3020775.56 REMAINING | | | -216087.08000000007 [101 non-empty rows] === Sheet: FY2027 === | | | | | 2018 Fleet Funding Source | | | | | | | | | 2019 Fleet Funding Source | | | | | | | | 2020 Fleet Funding Source | | | | | | | | | 2021 Fleet Funding Source | | | | | | | | | 2022 Fleet Funding Source | | | | | | | 2023 Fleet Funding Source | | | | | | | | | | | | 2024 Fleet Funding Source | | | | | | | 2025 Fleet Funding Source | | | | | | | 2026 Fleet Funding Source | | | | | | | 2027 Fleet Funding Source | Estimated Beginning 2018 for Budgeting | 2017Year End JE Transfers | Adjustment to Actual Expense 2017 | 2018 Actual Beginning | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2018 Fleet Capital | 2018 Fleet Minor Equipment | 2018 Expense Actuals | 2019 Beginning | 2019 Actual Beginning | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2019 Fleet Capital | 2019 Fleet Minor Equipment | 2019 Actual Expenses | 2020 Beginning | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2020 Fleet Capital | 2020 Fleet Capital Actual | 2020 Fleet Minor Equipment | 2020 Fleet Minor Equipment Actual | 2020 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2021 Fleet Capital | 2021 Capital Actual | 2021 Fleet Minor Equipment | 2021 Minor Equipment Actual | 2021 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2022 Fleet Capital | 2022 Fleet Minor Equipment | 2022 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | Actual Other Revenue | Actual Grants | Actual Transfers in from Other Funds | 2023 Fleet Capital | 2023 Fleet Minor Equipment | Actual 2023 Fleet Capital | Actual 2023 Fleet Minor Equipment | Actual 2023 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2024 Fleet Capital | 2024 Fleet Minor Equipment | 2024 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2025 Fleet Capital | 2025 Fleet Minor Equipment | 2025 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2026 Fleet Capital | 2026 Fleet Minor Equipment | 2026 Ending | Reallocate | Other Revenue | Grants | Transfers in from Other Funds | 2027 Fleet Capital | 2027 Fleet Minor Equipment | 2027 Ending General Fund | -508909 | -200000 | -39775 | -1061029.5 | 20000 | | 0 | 184000 | | | | -857029.5 | -857029.5 | 340784 | | | | 42000 | | 28428.36 | -603245.5 | 294100 | | | -200000 | | 12050 | | | -497095.5 | 190278 | | | -20000 | | | | | -326817.5 | | | | -54000 | | | -380817.5 | | | | -40000 | | | -40000 | | | | | -420817.5 | -11832 | | | | | | -1182571.5 | 252500 | | | -21973 | | | -1333532.5 | 90000 | | | | | | -1243532.5 | 446400 | | | | | | -797132.5 Fleet | -80000 | | | -80000 | | | | | 80000 | | 73000 | -7000 | -7000 | -38000 | | | -2500 | 0 | 40500 | 38256.56 | -9243.440000000002 | | | | | | | | | -9243.440000000002 | | | | | | | | | -9243.440000000002 | | | | | | | -9243.440000000002 | | | | -15000 | | | -15000 | | 15000 | | 14774 | -9469.440000000002 | | | | -10000 | | 31600 | -0.4400000000023283 | | | | -10000 | | 7735.93 | -2264.510000000002 | | | | | | | -2264.510000000002 | | | | | | | -2264.510000000002 Emergency Vehicles | -12204 | | | -12311 | | 0 | 0 | -350000 | 545472 | | 515408.51 | 153097.51 | 153097.51 | | | -289000 | -350000 | 565472 | | 636926.76 | 151024.27000000002 | -87000 | | | -288000 | | | | | -223975.72999999998 | | | | -280000 | | | | | -503975.73 | | | | -280000 | | | -783975.73 | | | -335000 | -290000 | | | -290000 | 725000 | | 324031.28 | | -749944.45 | | | -335000 | -310000 | 372160.03 | | -1022784.4199999999 | | -774948 | | -100000 | 1612336.33 | | -285396.08999999985 | | | | -270000 | | | -555396.0899999999 | -320000 | | | | 80000 | | -795396.0899999999 Public Safety | | | | | -20000 | | | -184000 | 84000 | | 33438.44 | -170561.56 | -170561.56 | | | | -162500 | 3500 | | 3295 | -329766.56 | | | | -129500 | 207000 | 85992.22 | | | -373274.33999999997 | | | | -57500 | 225000 | 293769.95 | 2500 | | -137004.38999999996 | | | | -153000 | 41033.4 | 5869 | -243101.98999999996 | | | | -80000 | | | -80000 | 168000 | | 172799.89 | | -150302.09999999998 | -40000 | | | -172000 | 158843.15999999992 | | -203458.94000000006 | | | | -205000 | 186334.5 | | -222124.44000000006 | | | | -273000 | 195000 | 8000 | -292124.44000000006 | | | | -220000 | 260000 | 15000 | -237124.44000000006 Subtotal General Government | -601113 | -200000 | -39775 | -1153340.5 | 0 | 0 | 0 | -350000 | 709472 | 0 | 621846.95 | -881493.55 | -881493.55 | 302784 | 0 | -289000 | -515000 | 610972 | 40500 | 706906.68 | -791231.23 | 207100 | 0 | 0 | -417500 | 207000 | 98042.22 | 0 | 0 | -1103589.0099999998 | 190278 | 0 | 0 | -357500 | 225000 | 293769.95 | 2500 | 0 | -977041.0599999998 | 0 | 0 | 0 | -487000 | 41033.4 | 5869 | -1417138.66 | 0 | 0 | -335000 | -425000 | 0 | 0 | -425000 | 893000 | 15000 | 496831.17000000004 | 14774 | -1330533.4899999998 | -51832 | 0 | -335000 | -492000 | 531003.19 | 31600 | -2408815.3 | 252500 | -774948 | 0 | -336973 | 1798670.83 | 7735.93 | -1843317.54 | 90000 | 0 | 0 | -543000 | 195000 | 8000 | -2093317.54 | 126400 | 0 | 0 | -220000 | 340000 | 15000 | -1831917.54 Streets | -265486 | | -37688 | -303174 | | 0 | | -116514 | 168000 | 4000 | 182078.07 | -237609.93 | -137609.93 | -100000 | | | -137000 | 314500 | | 424192.8 | 49582.869999999995 | -127000 | | | -300000 | 100000 | 76496.65 | 13500 | 1395 | -299525.48 | -86978 | | | | 18000 | 29688.21 | | | -356815.26999999996 | | | | -131428.18 | 147925 | 68869.26 | -271449.18999999994 | | | | -200000 | | | -199208.55 | 50000 | | 59795.62 | | -410862.11999999994 | -208000 | | | -230000 | | | -1166917.1199999999 | | | | -212000 | 752898.17 | | -769986.9499999998 | | | | -100000 | 80000 | | -789986.9499999998 | | | | -135000 | | | -924986.9499999998 Van Pool | -73486 | -7866 | -780 | -82132 | 30750 | 0 | 0 | 0 | | | | -51382 | -51382 | | | | 0 | | | | -51382 | | | | | | | | | -51382 | | | | | | | | | -51382 | | | | | | | -51382 | | | | | | | | | | | | -51382 | 51382 | | | | | | 0 | | | | | | | 0 | | | | | | | 0 | | | | | | | 0 MSDCP | -57679 | | | -57679 | | -4011 | | -4011 | | | | -65701 | -65701 | | -4011 | | -4011 | | | | -73723 | | -4011 | | -4011 | | | | | -81745 | | -4011 | | -4011 | | | | | -89767 | | -4011.6 | | -4011 | | | -97789.6 | | -4011 | | -4011 | -4011 | | -4011 | | | | | -105811.6 | | -4011 | | -4011 | | | -113833.6 | | | | -8022 | | | -150799.6 | | | | -8022 | | | -158821.6 | | | | -17600 | | 17600 | -158821.6 Rec & Culture | -114261 | | -18475 | -132736 | -34750 | 0 | 0 | 0 | 48000 | 3800 | 63980.15 | -103505.85 | -103505.85 | -206784 | | | 0 | 211800 | 5670 | 209920.05 | -100369.79999999999 | -80100 | | | -200000 | 45300 | 40591.08 | 11000 | 11999.35 | -327879.37 | -103300 | | | | 38300 | 43667.55 | 5000 | | -387511.82 | | | | | 37616 | | -349895.82 | | | | -142000 | | | -142000 | 87500 | 47000 | 59901.14 | 46666.08 | -385328.6 | | | | -110000 | 106769.79 | | -388558.81 | -252500 | | | | 48373.68 | 66995.12 | -636157.01 | -90000 | | | | 120000 | | -606157.01 | -126400 | | | | 420000 | 26400 | -286157.01 Total Governmental Funds | -1112025 | -207866 | -96718 | -1729061.5 | -4000 | -4011 | 0 | -470525 | 925472 | 7800 | 867905.17 | -1339692.33 | -1239692.3299999998 | -4000 | -4011 | -289000 | -656011 | 1137272 | 46170 | 1341019.5300000003 | -967123.1599999999 | 0 | -4011 | 0 | -921511 | 352300 | 215129.94999999998 | 24500 | 13394.35 | -1864120.8599999999 | 0 | -4011 | 0 | -361511 | 281300 | 367125.71 | 7500 | 0 | -1862517.1499999997 | 0 | -4011.6 | 0 | -622439.1799999999 | 226574.4 | 74738.26 | -2187655.2699999996 | 0 | -4011 | -335000 | -771011 | -4011 | 0 | -770219.55 | 1030500 | 62000 | 616527.93 | 61440.08 | -2283917.81 | -208450 | -4011 | -335000 | -836011 | 637772.98 | 31600 | -4078124.829999999 | 0 | -774948 | 0 | -556995 | 2599942.6799999997 | 74731.04999999999 | -3400261.0999999996 | 0 | 0 | 0 | -651022 | 395000 | 8000 | -3648283.0999999996 | 0 | 0 | 0 | -372600 | 760000 | 59000 | -3201883.0999999996 Water | -116190 | | | -156369 | 2000 | 0 | 0 | -75500 | 57896 | 2000 | 84395.98999999999 | -145473.01 | -145473.01 | 2000 | | | -105500 | 63500 | 15500 | 77847.3 | -171125.71000000002 | | | | -52000 | 45000 | 73880.47 | | | -149245.24000000002 | | | | | 30000 | | | | -149245.24000000002 | | | | -85000 | 2385 | | -231860.24000000002 | | | | -109000 | | | -109000 | 121400 | | 104615.02 | | -236245.21999999997 | -18500 | | | -200000 | 46847 | | -560813.22 | | | | -281500 | 584194.36 | | -326784.86 | | | | -129000 | 79000 | | -376784.86 | | | | -125000 | 25000 | | -476784.86 Sewer | -289411 | | | -289411 | 2000 | 0 | 0 | -59000 | 27000 | | 26557.1 | -319853.9 | -319853.9 | 2000 | | | -55300 | 16000 | | 14465.7 | -358688.2 | | | | -280000 | 455695 | 448772.05 | 6000 | | -189916.14999999997 | | | | | | | | | -189916.14999999997 | | | | -75000 | | 0 | -264916.14999999997 | | | | -50000 | | | -50000 | | | | | -314916.14999999997 | | | | -132000 | 200000 | 11150.57 | -392102.57999999996 | | | | -100000 | | | -625169.58 | | | | -175000 | 70000 | | -730169.58 | | | | -145000 | | | -875169.58 Storm | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | -500219.69 | -260076 | 498876 | | -261419.68999999994 | | | | -80000 | | | -80000 | 98000 | | 60517.33 | | -280902.3599999999 | 249000 | | | -50000 | 45921 | | -46621.35999999993 | | | | | | | -68153.35999999993 | | | | -50000 | | | -118153.35999999993 | | | | -70000 | | | -188153.35999999993 Sanitation | -31500 | | | -31500 | 0 | 0 | 0 | 0 | | | | -31500 | -31500 | | | | | | | | -31500 | | | | | | | | | -31500 | | | | | | | | | -31500 | | | | | | | -31500 | | | | | | | | | | | | -31500 | | | | | | | -31500 | | | | | | | -38520 | | | | | | | -38520 | | | | | | | -38520 Total Enterprise Funds | -437101 | 0 | 0 | -477280 | 4000 | 0 | 0 | -134500 | 84896 | 2000 | 110953.09 | -496826.91000000003 | -496826.91000000003 | 4000 | 0 | 0 | -160800 | 79500 | 15500 | 92313 | -561313.91 | 0 | 0 | 0 | -332000 | 500695 | 522652.52 | 6000 | 0 | -370661.39 | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 0 | -370661.39 | 0 | 0 | -500219.69 | -420076 | 501261 | 0 | -789696.08 | 0 | 0 | 0 | -239000 | 0 | 0 | -239000 | 219400 | 0 | 165132.35 | 0 | -863563.7299999997 | 230500 | 0 | 0 | -382000 | 292768 | 11150.57 | -1031037.1599999999 | 0 | 0 | 0 | -381500 | 584194.36 | 0 | -1058627.7999999998 | 0 | 0 | 0 | -354000 | 149000 | 0 | -1263627.7999999998 | 0 | 0 | 0 | -340000 | 25000 | 0 | -1578627.7999999998 Information Systems | -37193 | | | -37193 | | | | -4000 | | | | -41193 | -41193 | | | | -4000 | | | | -45193 | | | | -4000 | | | | | -49193 | | | | | 25000 | | | | -49193 | | | | -4000 | | | -53193 | | | | -4000 | | | -4000 | 34000 | | | | -57193 | | | | -5000 | 29810 | 0 | -32383 | | | | -5000 | 0 | 0 | -46828 | | | | -5000 | 0 | 0 | -51828 | | | | | 0 | 0 | -51828 Total Internal Service Fund | -37193 | 0 | 0 | -37193 | 0 | 0 | 0 | -4000 | 0 | 0 | 0 | -41193 | -41193 | 0 | 0 | 0 | -4000 | 0 | 0 | 0 | -45193 | 0 | 0 | 0 | -4000 | 0 | | 0 | 0 | -49193 | 0 | 0 | 0 | 0 | 25000 | 0 | 0 | 0 | -49193 | 0 | 0 | 0 | -4000 | 0 | 0 | -53193 | 0 | 0 | 0 | -4000 | 0 | 0 | -4000 | 34000 | 0 | 0 | 0 | -57193 | 0 | 0 | 0 | -5000 | 29810 | 0 | -32383 | 0 | 0 | 0 | -5000 | 0 | 0 | -46828 | 0 | 0 | 0 | -5000 | 0 | 0 | -51828 | 0 | 0 | 0 | 0 | 0 | 0 | -51828 Total City Funds - Fleet | -1586319 | -207866 | -96718 | -2243534.5 | 0 | -4011 | 0 | -609025 | 1010368 | 9800 | 978858.26 | -1877712.2400000002 | -1777712.2399999998 | 0 | -4011 | -289000 | -820811 | 1216772 | 61670 | 1433332.5300000003 | -1573630.0699999998 | 0 | -4011 | 0 | -1257511 | 852995 | 737782.47 | 30500 | 13394.35 | -2283975.25 | 0 | -4011 | 0 | -361511 | 336300 | 367125.71 | 7500 | 0 | -2282371.5399999996 | 0 | -4011.6 | -500219.69 | -1046515.1799999999 | 727835.4 | 74738.26 | -3030544.3499999996 | 0 | -4011 | -335000 | -1014011 | -4011 | 0 | -1013219.55 | 1283900 | 62000 | 781660.28 | 61440.08 | -3204674.54 | 22050 | -4011 | -335000 | -1223011 | 960350.98 | 42750.57 | -5141544.989999999 | 0 | -774948 | 0 | -943495 | 3184137.0399999996 | 74731.04999999999 | -4505716.899999999 | 0 | 0 | 0 | -1010022 | 544000 | 8000 | -4963738.899999999 | 0 | 0 | 0 | -712600 | 785000 | 59000 | -4832338.899999999 | | | | | | | | | | | | | | | | | | | | | | | | | -1261522 | | | | 751176.82 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 3258868.0899999994 | Fund Balance GL to Spreadsheet 2017 TB | Actual Beginning for 2018 | | | | | | | | | | Capital | -2843806.22 | Fund Balance | | | 6510411.54 | | Gen Govt | 1153340.49 | | -1061029.5 | Gen Govt | WC | 368352.6 | Less Invest in Assets | | | -3554993.39 | | IS | 37193 | | -80000 | Fleet | Prepaids | 545472 | Equals Restricted for Future Purchases | | | 2955418.15 | | Streets | 303174 | | -12311 | Emergency | PERSI FB | -102243 | Still needs to be adjusted for FY18 | | | | | | MSDCP | 57679 | | -1153340.5 | | | -2032224.62 | Less : | | | | | P&R | 132736 | | | | | -2037812 | Prepaid Fire Truck | | | -514893 | | Van Pool | 82132 | | | | | 5587.379999999888 | Less PERSI FB | | | 102233 | | Sanitation | 31500 | | 1153340.49 | Less Working Capital | | | -299223.66 | | Water | 156369 | | -1153340.5 | Less Partial Depreciation short | | | 0 | | Sewer | 289411 | | 0.01000000024214387 | Unallocated | Total available FB for 2019 budget | | | 2243534.4899999998 | | | 2243534.49 | | 2.3283064365386963e-10 | spreadsheet FB | | | -2243534.5 | difference provided by operations cash flow | | UNALLOCATED | -0.01000000024214387 | not allocated | Estimated Beginning for 2018 budget Prep | Estimated Ending 2017 Balance | | | 2182318.98 | Less Estimated Prepaid Expense for Fire Truck in 2017 | | | -515000 | Less Estimated Cost for Roller purchased in 2017 | | | -45000 | Less Estimated cost for PD generator in 2017 | | | -36000 | Total Estimated Beginning for 2018 budget Prep | | | 1586318.98 | See B23 [42 non-empty rows]