Loading...
2017-08-07 Budget Workshop Agenda Packet Council Workshop Agenda Monday, August 7, 2017 City Council Chambers 6:30 p.m. NOTE: City Council Regular Meeting at 7:00 p.m. 1.Call to Order 2.Capital Improvement Plan Presentation by ABDO (Andy Berg) 3.2018 Preliminary Budget Presentation (Attached) 4.Adjournment Agenda Page 1 2017 FINAL BUDGET SUMMARY COMPARISON GENERAL FUND DifferenceDifference 17 2017 Budget 2018 Budget 17 to 18 $to 18 % General Fund Revenue: 31010Current Ad Valorem Taxes1,876,7612,018,939$142,1787.58% 32100Licenses & Permits27,00027,000$00.00% 32110Liquor Licenses29,50033,000$3,50011.86% 321203.2 Liquor Licenses7575$00.00% 32150Sign Permits1,2001,300$1008.33% 32210Building Permits85,917115,000$29,08333.85% 32240Animal Licenses700700$00.00% 33401LGA Revenue expected92,181111,024$18,84320.44% 33405Police Aid33,00040,000$7,00021.21% 33406Fire Aid61,00061,000$00.00% 33422Other State Aid Grants11,00011,500$5004.55% 34000Charges for Services3,0004,000$1,00033.33% 34005Engineering As Built Fee3,0003,000$00.00% 34101Leases - City Property00$00.00% 34103Zoning & Subdivision Fees2,0002,500$50025.00% 34104Plan Check Fee40,00050,000$10,00025.00% 34107Title Searches3,0003,600$60020.00% 34113Franchise Fee - Cable72,00074,000$2,0002.78% 34202Fire Protection Contract Charges274,646294,620$19,9747.27% 34780Rental Fees10,00012,000$2,00020.00% 34950Other Revenues8,00011,000$3,00037.50% 34110Arena12,69213,074$3823.01% 34112Electric Franchise Fee115,000115,000$00.00% 36210Interest Earnings20,00020,000$00.00% 102Capital Levy986,4281,022,750$36,3223.68% Total Revenues3,768,1004,045,082$276,9827.35% DifferenceDifference 17 General Fund Department Expenditures:2017 Budget 2018 Budget 17 to 18 $to 18 % 41000General Government30,00030,000$00.00% 41100Council40,58840,588$00.00% 41300Combined Administrator/Engineer100,848104,106$3,2593.23% 41400City Clerk102,049112,891$10,84210.62% 41440Elections15,50020,000$4,50029.03% 41500Finance 121,522147,111$25,58921.06% 41550City Assessor29,87029,870$00.00% 41600City Attorney40,00040,000$00.00% 41700City Engineer20,00025,000$5,00025.00% 41800Economic Development6,0006,000$00.00% 41910Planning & Zoning41,50746,507$5,00012.05% 41940City Hall150,128158,114$7,9855.32% 42000Fire Department468,877493,323$24,4465.21% 42110Police710,290731,599$21,3093.00% 42400Building Inspection171,344224,312$52,96830.91% 42700Animal Control6,0007,000$1,00016.67% 43100Public Works - Streets294,578326,121$31,54310.71% 45000Culture & Recreation71,81175,211$3,4004.73% 45100Parks & Recreation278,331318,646$40,31514.48% 43160Electric street lights83,43085,933$2,5033.00% 102Capital 102985,4291,022,750$37,3223.79% Total Expenditures3,768,1004,045,082276,9827.35% Page 1 Agenda Page 2 Difference 17 Levy20172018to 18 % eneraun,,,,. GlFd&EDA18767612018939758% Capital Levy986,4281,022,7503.68% Total Tax Levy (Oper. Levy)2,863,1893,041,6896.23% 357GO Improvement Bond 03276,677273,963 354Bonds 03 PF Lease Rev76,6420 359City Hall 05263,959261,478 360Go Imp 2012A CSAH 1926,15726,157 358PW Facility 04103,449100,651 361Go Imp 2012A Lach31,60031,600 362Go Imp 2012A Ind Park84,56184,561 468I-9453,00053,000 Total Debt Service Levy916,045831,410Debt Lev y-9.24% Total Levy3,779,2343,873,099Total Levy2.48% Page 2 Agenda Page 3 Annual LevPayable 2017Payable 2018 y Increase/Decrease Total Lev$3,779,23$3,873,099 y4 $93,865 $2,863,189$3,041,689 GF Levy $178,500 Debt Lev$916,045$831,410 y -$84,635 Tax Rate 0.51590.5287 Based on 2017 taxes payable and tax capacit y Total Levyimpact on $150,000 home$774$793$192.48% Impact on $200,000 home$1,032$1,057$262.48% Impact on $300,000 home$1,548$1,586$382.48% Based on 2017 taxes payable and tax capacity Albertville Portion Total Levyimpact on Htl$21,556$22,091$5352.48% impact on PC$4,871$4,992$1212.48% impact on BP$6,963$7,136$1732.48% impact on SL$18,727$19,192$4652.48% impact on Clvr$10,250$10,505$2552.48% Impact on DB$8,658$8,873$2152.48% Impact on JLC$8,961$9,183$2232.48% impact on AAB$1,264$1,296$312.48% impact on VC$5,877$6,023$1462.48% impact on 152$3,347$3,430$832.48% impact on SM$3,342$3,425$832.48% Golf Course$6,838$7,007$1702.48% Levy Impact based on $200,000 home (approx. $7 per $25,000) $25,000$7 $50,000$14 $75,000$20 $100,000$27 $200,000$55 Agenda Page 4 vepros, rental, misc lic peddlers lmc credits sign 72,003.003,500.00100.0029,083.0018,843.007,000.00500.001,000.00500.0010,000.00600.002,000.00380.7919,974.112,000.003,000.00170,483.90 --------- 2017-2018 ange Ch $ $4,032,628.45 2,018,939.001,010,297.00 27,000.0033,000.0075.001,300.00115,000.00700.00111,024.0040,000.0061,000.0011,500.004,000.003,000.002,500.0050,000.003,600.0074,000.0013,073.64115,000.00294,619.8112,000.0011,000.0020,000.00 ge 2018 t d u B $1,448,704.01 977,391.2320,066.6133,326.00315.00100,698.27350.005,632.502,365.253,150.002,300.0047,279.611,960.0037,420.798,461.9043,325.26137,322.8411,213.5015,871.41253.84 ------ 8/1/17 2017 l ua t c A $3,862,144.55 2,018,939.00938,294.0027,000.0029,500.0075.001,200.0085,917.00700.0092,181.0033,000.0061,000.0011,000.003,000.003,000.002,000.0040,000.003,000.0072,000.0012,692.85115,000.00274,645.7010,000.008,000.0 020,000.00 - ge 2017 t d u B $3,221,443.45$3,719,006.31 937,465.00 1,793,766.14 40,185.8432,812.4830.001,370.0099,062.45 1,468.4390,462.0040,080.4063,314.8811,504.009,682.362,550.002,875.001,700.0046,081.953,680.0074,346.9612,278.28113,818.5 9253,304.4414,001.6550,838.2722,327.19 12/31/16 2016 Page 5 l ua t c A Agenda 1,668,879.45 864,161.0023,271.2429,960.38116.251,825.47141,976.41730.3487,096.0033,406.9461,481.5011,504.004,529.732,850.003,940.002,500.0070,943.464,660.0055,722.1711,964.23139,924.882 25,710.009,914.2036,722.3219,329.15 12/31/15 2015 l ua t c A #REF! 2,397,983.0022,000.0029,150.00150.001,500.0055,000.00400.0079,651.0028,000.0042,000.008,200.002,000.001,500.001,500.0025,000.001,000.0065,000.0011,615.76115,000.00160,533.006,000.009,000.0025,000.00 - ge 2014 t d u B $2,967,899.87 102Capital Levy209.00 2,372,979.3430,530.0029,207.0030.001,260.00105,716.13840.0079,651.0031,602.6637,795.0710,409.006,552.823,600.001,440.001,200.0051,836.543,325.0072,768.1211,686.00115,262.19160,533.0010,569.9830,222.3 353,187.50 12/31/14 2014 l ua t c A #REF! 2,423,781.00250.00 20,000.0029,150.00150.001,500.0035,000.0028,000.0030,000.008,200.002,000.00750.001,500.0015,000.00546.0065,000.0011,388.00154,416.595,000.006,000.0025,000.00 - ge 2013 t d u B 101-00000-34202Fire Protection Contract Charges 101-00000-34101Lease Payments - City Property 101-00000-34103Zoning & Subdivision Fees 34005Engineering As Built Fee 101-0000034112Electric Franchise Fees 101-00000-33422Other State Aid Grants 101-00000-33401Local Government Aid101-0000034113Franchise Fee - Cable Description 101-00000-34000Charges for Services 101-00000-321203.2 Liquor Licenses GENERAL FUND TOTAL: 101-00000-32100Licenses & Permits nimal Licenses 101-00000-32210Building Permits 101-00000-34104Plan Check Fee 101-00000-32110Liquor Licenses101-00000-36210Interest Earning 101-00000-34950Other Revenue 101-00000-34107Title Searches s s 101-00000-32150Sign Permits 101-00000-34780Rental Fees 101-00000-33405Police Aid 101-00000-31010Tax Lev 101-00000-33406Fire Aid y rena AA Code101-00000-32240 34110 FUND 101-00000-101-00000- GENERAL 0.00start increasing for 2018 and 2020 0.000.000.000.000.000.001,800.0036.000.000.000.000.000.002,250.00206.2555.006,080.000.0035.000.000.005.3810,842.01 0.000.000.000.00135.00137.701,150.000.000.003,258.70500.000.00210.381,500.000.000.000.000.00 2017-201 $ chang 8 e 104,106.20112,890.63 1,468.80500.00500.003,605.00500.00250.0040,588.005,010.005,110.201,336.009,250.00100.005,000.001,000.005,000.002,000.00500.003,000.001,500.000.003,729.38975.008,000.001,500.003,000.000.00500.001,500. 00250.00300.0020,000.00 19,200.014,564.266,800.03,656.216,000.012,550.0 30,000.047,250.012,180.0 Budge 000005000 2018 t 20,745.522,666.910.0020,365.33762.450.00454.04365.000.0051,285.1825,833.41425.960.000.000.0020.0049,658.26 856.800.002,830.69539.432,271.502,860.194,374.06416.241,506.011,210.001,081.230.002,312.62639.153,367.762,748.026,403.98120.474,123.91185.001,584.15 11,200.036,633.42,703.72,396.7 ctual 8/1/1 0455 7 2017 A 500.00500.0040,588.004,972.50100.001,000.002,000.00500.00100,847.50920.001,500.003,000.000.001,500.00250.00102,048.6215,500.00 1,468.80500.003,605.00250.004,875.001,300.008,100.005,000.005,000.003,000.001,000.000.003,450.003,519.006,100.006,500.00500.00300.00 30,000.019,200.014,564.265,000.045,000.015,965.012,544.6 Budge 0000002 2017 t 829.563,635.570.00335.0239,236.2346,384.240.0042.79864.002,231.34365.0094.4175,291.5388,134.8658,443.82616.69320.008,543.749,695.3096,956.51108,563.17 1,468.801,468.80765.00355.003,387.103,668.31200.37389.144,197.904,683.431,119.481,248.585,739.836,709.432,586.102,150.574,832.195,121.730.003.981,159.001,557.213,920.503,718.184,699.033,549.264,578.2 74,461.625,110.418,386.087,493.2244.7437.65419.88174.95717.63122.720.000.004.260.00190.00254.000.0017,568.50 0.000.00 ctual 12/31/1 85,137.919,200.017,332.460,166.812,460.2 4,039.524,522.7991.561,253.0 6 7005555 Page 6 2016 A Agenda ctual 12/31/118,853.219,200.013,385.449,676.11,871.348,522.815,232.7 4006588 5 2015 A 34,418.80113,434.00 1,468.80500.00500.003,000.00500.00250.009,000.004,350.004,590.00600.008,600.00140.005,000.001,000.003,000.001,000.00500.003,000.0095,630.001,000.000.004,060.004,284.00560.007,000.006,500.001,000.003, 000.000.00500.001,000.001,000.00250.0015,500.00 30,000.019,200.063,850.055,000.014,000.014,280.0 000000 Budge 201 t 4 38,773.5312,894.11101,429.44 1,468.80545.000.003,582.940.0045.795,470.515,436.171,416.084,886.1731.812,151.41839.12134.50253.58852.2085,809.891,262.883,948.163,923.96959.466,366.676,814.24315.00545.05780.45125.470.00413.909,280. 16244.0018,928.95 ctual 12/31/1 18,885.619,200.013,931.059,402.74,935.551,302.12,253.7 4 5009585 2014 A 33,418.80118,582.57 1,468.80500.00500.003,000.00500.00250.008,000.005,969.68140.006,850.001,000.003,000.001,000.000.003,000.000.000.003,795.014,004.396,000.006,500.001,000.006,000.003,000.000.00500.001,000.00250.00250.0 099,167.859,000.00 55,000.078,035.05,657.5780.313,150.052,345.0523.414,000.0 19,200.0 000450050 Budge 2013 t 131Employer Health/Dental/Life I131Employer Health/Dental/Life I nn 370Mayors Contingency Fun 413Office Rental Equipmen d 433Dues and Subscription433Dues and Subscription433Dues and Subscription 101-41410-300Professional Services t 300Professional Service300Professional Service sss 208Training & Instructio208Training & Instructio208Training & Instructio 101Full Time Employee101Full Time Employee Total Administrator ss 323Nextel Radio Unit 100Wages & Salariesnnn ss 331Travel Expense331Travel Expense331Travel Expense s 321Telephone/Cel 200Office Supplie200Office Supplie Total Council sss 399Miscellaneou399Miscellaneou 351Legal Notice ss l ss Total Clerk s 103Part Time 102Overtime 335Educatio335Educatio 322Postage nn 127HCS127HCS 121PER121PER 399Mis 122FIC122FIC122FIC AA AA AAA c General Governmen City Clerk/UB Cler cct t City Administrato k r A 101-41100101-41100101-41100101-41100101-41100101-41100101-41100101-41100101-41300101-41300101-41300101-41300101-41300101-41300101-41300101-41300101-41300101-41300101-41300101-41300101-41400101-414001 01-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400101-41400 Elections 101-4100 Council ------------------------------------- 0 DEPT 41000 DEPT 4110DEPT 4130DEPT 4140DEPT 4141 P FUND 101 0000 Admin 0.00plan (2-3) PC's plus server software annual renw a 0.00GASB, 5 yr plan, Budget award, CAF R 802.04pd with elec franchis e (1,000.00)(1,500.00)(330.00) (12,600.00269.009,575.00357.420.000.000.005,000.000.005,000.005,000.00200.0015.0015.300.00600.000.000.007,985.50 1,028.932,400.000.000.000.004.00460.00137.765,581.390.00 1,008.7 26,050.025,589.0 2017-201 ) 059 $ chang 8 e 24,116.51 0.006,162.081,611.006,200.001,000.005,000.001,000.003,500.00500.00700.006,000.001,400.00107.10500.00840.00856.80224.003,560.004,729.811,500.0011,000.002,500.0038,300.00 80,550.06,041.222,575.0147,110.629,870.040,000.025,000.046,507.111,200.020,600.027,536.710,650.0158,113.8 12,271.345,000.0 Budge 050250000000204 2018 t 600.12506.58370.00552.110.00440.0033.6631,311.42184.77121.14413.59394.4513,249.63 0.002,250.241,948.175,686.86898.507,383.98513.44280.007,697.502,856.005,931.23454.76418.391,725.060.00250.009,593.573,122.121,662.93 30,004.450,994.428,820.518,844.041,507.114,559.352,080.9 ctual 8/1/1 0000048 7 2017 A 1,342.002,000.005,000.0011,913.911,000.002,000.00825.00841.50220.003,100.001,500.0011,330.002,500.0038,300.00 5,032.506,200.001,100.00700.006,000.001,400.00107.10 121,521.5150,128.3 54,500.012,600.05,133.113,000.029,870.040,000.020,000.040,000.041,507.111,000.04,592.020,000.018,535.126,734.610,650.0 Budge 00506000000502805 2017 t 6,988.995,314.37947.721,003.818,460.518,723.54487.01385.51678.97499.255,496.005,274.00841.65996.428,313.156,815.979,239.347,644.8235,420.3034,684.23 4,078.794,168.663,824.023,851.263,150.562,417.931,913.213,579.44371.250.00540.00345.001,360.00920.00104.0470.381,867.802,847.441,489.530.00 ctual 12/31/1 50,407.37,176.6212,027.195,738.928,615.520,485.048,950.570,955.455,316.3271,945.720,002.323,414.024,417.9120,823.2 4,623.863,015.7 6 0579000084934 Page 7 2016 A Agenda 118,934.6 ctual 12/31/146,658.189,899.628,825.525,978.514,915.053,852.219,570.220,903.421,289.1 4500088667 5 2015 A 8,772.509,256.501,210.006,200.002,000.005,000.001,000.001,000.001,000.00600.001,400.00107.103,605.001,000.0010,000.002,000.0027,000.00 106,000.015,000.022,000.013,000.0192,039.029,355.040,000.020,000.018,000.037,000.038,507.118,500.041,000.022,500.010,000.0135,605.0 0000000000000000 Budge 201 t 4 15,535.5157,259.5252,835.3121,677.0191.24155,173.61 8,786.518,488.971,968.898,390.03679.704,119.788,396.48775.57594.00560.59600.0045.901,171.041,988.7711,058.6434,743.08 ctual 12/31/1 107,280.214,657.81,094.9181,329.128,491.024,547.54,752.558,777.059,422.917,684.113,924.3 4 96530058857 2014 A 16,250.92 8,764.093,000.002,000.003,000.00700.001,000.00500.00600.001,400.00107.107,823.547,638.401,720.333,605.001,000.009,000.0014,000.001,000.007,000.0017,000.00 105,884.09,247.61,208.818,250.013,000.0182,154.528,500.035,000.020,200.018,000.030,000.031,507.189,800.550,000.018,250.0120,855.0 15,000.0 00340060000008000 Budge 2013 t 131Employer Health/Dental/Life I130Employer Health/Dental/Life I 404Repair/Maint Machinery/Equi 207Computer Supplies/softwar nn p e uditing & Acc't Service 433Dues and Subscription 101-41940-405Repair/Maint Buildings s 300Professional Service300Professional Service s 208Training & Instructio 101Full Time Employee101Full Time Employee 151Workers Comp Ins ss 321Telephone/interne n100Wages & Salaries210Operating Supplie ss 303Engineering Fee s 331Travel Expense361General Liabilit t s 381Electric UtilitieTotal City Hal s 306Planning Fee 399Miscellaneou Total Plannin y Total Financ s101-41940-383Gas Utilities 511Property Ta sg s l e 304Legal Fee x 103Part Time323Cell Phon 102Overtime 335Educatio s e n 127hcsa 127HCS 121PER121PER 122FIC122FIC122FIC A AA AAA A DEPT 41910Planning & Zoning cct 301 A Engineering 101-41500101-41500101-41500101-41500101-41500101-41500101-41500101-41500101-41500101-41400101-41500101-41500101-41500101-41500101-41550101-41600101-41700101-41910101-41910101-41910101-41940101-419401 01-41940101-41940101-41940101-41940101-41940101-41940 City Hall 101-4180101-4194101-4194101-4194101-4194101-4194 Assesso ---------------------------- 000000 Financ r Legal e Dept 41800 ED A DEPT 4150DEPT 4155DEPT 4160DEPT 4170DEPT 4194 FUND 101 00000 Admin (8,400.00) 768.068,860.000.0046.350.000.0052,968.21 1,000.00753.00200.800.000.000.000.000.00 21,308.718,440.032,300.0 2017-201 000 $ chang 8 e 224,312.11 7,000.004,098.001,092.80500.00350.00500.00250.00500.00100.00150.00 731,598.754,640.04,179.921,360.01,591.3135,000.0 Budge 006050 2018 t 414,335.81 110.000.00853.41123.05445.0040.00 3,618.000.001,197.63418.616,885.360.00630.230.00 20,928.51,569.652,606.485,807.9 ctual 8/1/1 5565 7 2017 A 500.00500.00250.00500.00150.00 6,000.008,400.003,345.003,411.90892.00350.001,545.00100.00 710,290.0102,700.0 36,200.012,500.0171,343.9 Budge 00000 2017 t 0.00155.00155,066.01 6,846.006,950.002,750.222,557.001,947.422,797.031,999.102,263.24449.52692.07147.450.00278.00284.000.000.001,464.621,363.8624.360.000.000.00 234.650.00 ctual 12/31/1 686,616.034,870.699,574.0 6,958.7610,509.1 6 0038 Page 8 2016 A Agenda 612,105.0146,015.2 ctual 12/31/130,008.699,752.5 0336 5 2015 A 4,080.005,000.001,885.001,989.00260.007,000.00500.00350.00500.001,500.00250.00500.00250.00150.00 547,500.021,000.095,400.095,400.0231,934.0 00000 Budge 201 t 4 5,859.002,218.791,619.211,568.46369.615,449.360.00258.000.001,562.02220.000.0047.450.00 ctual 12/31/1 547,500.020,265.795,300.095,300.0224,178.7 4 09447 2014 A 4,000.005,000.001,853.611,955.88255.67700.00350.00700.00100.00500.001,000.00500.00300.00 530,000.020,567.013,440.093,843.093,843.0234,908.1 000006 Budge 2013 t 130Employer Health/Dental/Life I n nimal Control Contrac 302Contracted Bldg Offica433Dues and Subscription t 300Professional Service s 103Part Time Employee 208Training & Instructiol 101Full Time Employee 307Police Contract Fee s sTotal Building Dep n s s t 331Travel Expense 203Printed Forms 200Office Supplie s 399Miscellaneou s s 335Educatio n udi 127HCS 121PER 122FIC A A A t AA cct 309301 Animal Control A Building Dep t 101-42110101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400101-42400 101-4270101-4240101-4240 --------------- 000 Police DEPT 4211DEPT 4270DEPT 4240 FUND 101 000 Admin 580.21Annual Audit and Fire Releif Audit, plus 990's for fire relief and pmts 0.00what is not spend transfers to Captal Comments (974.87) 373.643,922.00914.723,003.85501.500.000.00185.400.000.000.000.000.001,000.000.000.000.000.00169.95152.960.00500.00500.000.000.0024,445.92 78.447,460.002,238.692,500.001,339.43 $ change 2017-2018 15,319.34132,580.0037,503.5119,000.0010,455.0018,121.5061,000.0031,060.0024,625.646,365.401,545.0019,920.418,200.003,000.00500.004,500.002,000.00500.00250.00250.0014,733.7625,000.00 9,155.132,651.603,500.007,000.005,000.005,834.955,251.466,500.002,500.006,500.003,000.00493,322.70 Budget 2018 Actual 8//17 8,400.0075,491.5426,636.4110,343.161,349.1210,250.520.000.002,294.741,232.201,998.002,941.02108.452,260.251,551.82200.000.000.0011,308.95 5,747.011,509.979,351.121,243.772,120.007,818.342,761.9296.802,241.821,769.683,103.911,946.792,635.001,699.25200,411.56 Page 9 2017 Agenda 14,945.70128,658.0036,588.7915,996.1510,455.0017,620.0010,130.0061,000.0023,600.0022,386.956,180.001,545.0019,340.218,200.003,000.00500.003,500.002,000.00500.00250.00250.0013,394.3325,000.00 2,573.163,500.004,500.005,000.005,665.005,098.506,000.002,000.006,500.003,000.00468,876.78 Budget 2017 Actual 12/31/15BudgetActual 12/31/16 101-42000-100Wages & Salaries10,617.8114,581.1710,186.20101-42000-101Wages City Staff /Fire Chief32,722.40122,030.31121,301.12101-42000-106Wages - Fire Calls32,738.5035,696.3834,938.97101-42000-107Fi re/Medical Training20,770.2015,606.0018,407.46101-42000-111Fire Code Official/Fire admin7,867.2410,200.009,188.26101-42000-121PERA4,527.5616,924.9716,665.10101-42000-122FICA6,732.149,616.558,314.4310 1-42000-124Fire Pension Contribution61,481.5058,000.0063,314.88101-42000-127HCSA1,855.582,440.612,423.29101-42000131Insurance full time city staff/chief7,666.1015,046.1713,919.41101-42000-150Workers Comp14,568.8421,734.9019,909.63101-42000-200Office Supplies3,396.583,500.004,541.88101-42000-208Training & Instruction3,906.204,500.009,050.00101-42000-212Motor Fuels5,587.976,000.006,122.30101-4200 0-230Medical Supplies2,373.111,500.001,957.15101-42000-301Auditing & Acct'g Services19,316.2618,776.9017,534.86101-42000-305Physicals7,461.168,200.007,010.50101-42000-310Professional Services3,167.832,500.005,183.15416.23500.00417.14856.352,000.00481.34417.22500.00150.0011,822.0013,004.2013,275.52101-42000-404Repair/Maint Machinery/Equip24,095.5425,000.0020,706.16101-42000-420Tr aining & Maintenance 800 MHZ4,997.506,500.002,504.50315,238.31442,808.16438,758.87 3,757.745,000.005,010.324,514.793,500.006,258.8684.00250.00385.9314.92250.00407.614,771.085,500.004,906.923,327.914,950.002,535.354,935.126,000.006,557.701,592.701,000.003,094.902,878.232,000.002,098 .03 201520162016 Total FD Operating & Captial Exp 721,322.70 101-42000-352General Publications, Pub Info 101-42000-312First Responder Training 101-42000-433Dues and Subscriptions 101-42000-405Repair/Maint Buildings 101-42000-361General Liability Ins 101-42000-351Legal Publications Total FD Operating Exp 101-42000-331Travel Expenses 101-42000-417Uniform Rentals 101-42000-381Electric Utilities 101-42000-383Gas Utilities 101-42000-321Telephone 101-42000335Education 314Meals Total FD Budget DEPT 42000 Fire 101-42000- (517.06)(431.00)(864.50) 0.00 16,875.000.000.000.000.000.000.000.000.0064.000.000.000.0031,543.24 1,265.631,290.94337.508,350.00300.001,500.00800.00400.001,172.741,000.002,502.90 2017-2018 $ change 123,875.0015,000.0010,865.6311,082.9435,350.0019,000.0020,000.0012,000.0012,000.0085,932.90 6,000.002,597.50800.006,000.008,500.008,000.002,800.001,500.001,000.00150.00500.007,300.007,500.006,500.001,300.004,000.002,000.00500.00326,121.06 Budget 2018 ctual 8/1/17 59,915.000.000.000.000.000.000.00 1,196.7111,119.405,257.814,985.111,213.6212,934.6413.873,355.481,061.463,628.121,637.72936.792,647.57318.45718.477,350.156,760.401,536.481,136.8435.50127,759.5935,191.75 2017 A 107,000.006,000.0015,000.0027,000.0019,517.0620,000.0012,000.0012,000.003,000.0083,430.00 9,600.009,792.002,260.00500.004,500.008,500.008,000.002,000.001,100.001,000.00150.00500.006,127.267,931.007,364.501,236.002,000.00500.00294,577.82 Budget 2017 10 Page ctual 12/31/16 19,784.2125,917.90 101-43100-101Full Time Employees100,018.59116,230.51101-43100-102Overtime1,212.842,639.14101-43100-104Temporary Employees26,535.3222,459.769,099.8410,564.238,746.8910,025.55101-43100-127hcsa1,989.502 ,365.98101-43100-151Workers Comp Insurance12,701.0414,955.15101-43100-208Training & Instruction670.21815.00101-43100-212Motor Fuels10,702.037,235.70101-43100-215Shop Supplies4,845.955,966.53101-43100 -221Ice Removal8,317.197,012.80101-43100-227Street Sweeping8,049.757,903.13101-43100-321Telephone1,811.842,694.50101-43100-323Cell Phones1,102.031,309.57101-43100-329Civil Defense Siren0.000.00101-43 100-331Travel Expenses188.490.00101-43100-335Education23.000.00101-43100-361General Liability Ins5,408.006,637.76101-43100-381Electric Utilities4,856.145,573.95101-43100-383Gas Utilities4,717.783,319 .34101-43100-384Refuse/Garbage Disposal1,041.301,153.79101-43100-400Repair/Maint. Streets14,528.349,742.418,690.2810,247.24101-43100-405Repair/Maint. Buildings3,935.574,007.52101-43100-417Uniform Rentals1,836.481,827.21101-43100-433Dues and Subscriptions410.0024.50261,222.61280,629.17101-43160381Electric Utilities78,333.6181,298.66 20152016 Agenda A ctual 12/31/15 A 101-43100-130Employer Health/Dental/Lif Bu d101-43100-404Repair/Maint. Machinery/E eq A 101-43100-121PER A 101-43100-122FIC W Total P DEPT 43160 Street Lighting DEPT 43100 Public Works 3,400.00SC 24k LB 12.1k FYCC 27k Inter 1100 229.47pd with elec franchise 0.00Donation to FCD $ change$ change 0.000.000.003,400.000.000.001,333.131,359.79355.508,800.000.00500.000.007,993.230.00400.000.000.000.000.000.00 17,775.001,253.960.000.00315.4340,315.50 2017-2018 2017-2018 800.0061.204,250.007,000.0063,100.0075,211.20137,775.006,000.0025,000.0012,658.13$12,911.29$2,875.5039,800.004,698.281,200.004,435.43400.001,500.00200.0027,092.217,878.562,121.802,000.007,500.002,000 .005,500.002,000.00100.00318,646.19 13,000.00 BudgetBudget 20182018 Actual 8/1/17Actual 8/1/17 520.000.000.001,381.495,513.56217.46936.690.000.004,158.81485.811,086.892,962.50153.074,625.00819.83137,409.47 39.7441,326.2141,885.9566,721.0017,231.31$5,761.00$1,360.6115,035.820.00800.006,809.181,313.9435.50 20172017 11 Page 800.0061.204,250.007,000.0059,700.0071,811.20120,000.006,000.0025,000.0011,325.00$11,551.50$2,520.0031,000.003,444.321,200.004,120.00400.001,000.00200.0019,098.987,649.092,121.801,600.007,500.002,000 .005,500.002,000.00100.00278,330.69 13,000.00 BudgetBudget 20172017 Agenda Actual 12/31/15Actual 12/31/16Actual 12/31/15Actual 12/31/16 60,628.4156,848.9818,752.9423,149.54$8,483.47$9,725.84$1,988.69$2,365.00 101-45000-103Employee - committee950.00825.00101-45000-122FICA72.6463.05101-45000-596Friendly City Days4,250.000.00101-45000598Transportation0.000.00101-45000-598Pledges & Contrib.55,355.7755,960.931 00,009.21116,193.99949.362,639.148,014.409,469.67101-45100-130Employer Health/Dental/Life Ins19,859.5326,186.271,867.804,271.16101-45100-208Training and Instruction1,065.601,009.97101-45100-210Operat ing Supplies (General)13,032.1512,837.40101-45100-212Motor Fuels1,413.194,306.24101-45100-321Telephone369.74374.17101-45100-323Cell Phones951.681,309.57101-45100-331Travel Expenses16.450.00101-45100- 361General Liability Ins16,857.0024,629.28101-45100-381Electric Utilities6,447.376,210.07101-45100-383Gas Utilities769.02638.93101-45100-384Refuse/Garbage Disposal1,440.511,943.19101-45100-404Repairs /Maint Machinery/Equip4,408.435,154.99101-45100-405Repairs/Maint Buildings1,378.411,024.38101-45100-415Other Equipment Rentals3,762.504,755.00101-45100-417Uniform Rentals1,747.402,128.60101-45100-433 Dues & Subscriptions33.001,251.70213,617.85261,574.10 201520162016 2015 101-45100-151Worker's Comp Insurance Pre m 101-45100-102Full-Time Employees OT 101-45100-104Temporary Employees 101-45100-101Full-Time Employees Total Culture & Recreation DEPT 45000 Culture and Recreation 101-45100-127HCSA 101-45100-121PERA 101-45100-122FICA Total Parks DEPT 45100 Parks 10,500.0037,321.93 110.25426.0031.50181.501,000.000.000.000.000.000.000.000.000.000.000.000.000.000.0013,387.50262.50525.00315.00131.25525.00945.00210.00262.5031.50131.25905.63157.50315.00525.005,000.000.000.000.000.00 0.001,443.050.00 2016-2017 $ Change 11,000.0019,018.1311,025.0040,000.0015,000.0060,000.0044,000.0016,500.00 3,785.2514,626.001,081.506,231.505,000.001,000.002,500.005,000.0018,500.0011,000.003,000.002,500.003,500.0020,000.00128,000.0016,500.00500.00281,137.505,512.5011,025.006,615.002,756.2511,025.0019,845 .004,410.005,512.50661.502,756.253,307.506,615.005,000.009,500.00157,500.001,022,750.43 30,304.0 5 Budget 2018 26,852.7813,333.3612,926.96 1,636.660.000.000.004,945.003,420.000.000.007,589.630.004,104.150.000.001,527.000.000.000.004,700.00213,040.23689.390.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00111,955.444 06,720.60 Actual 8/1/17 2017 11,000.0018,112.5010,500.0035,000.0015,000.0060,000.0044,000.0028,861.00 3,675.0014,200.001,050.006,050.004,000.001,000.002,500.005,000.0018,500.0011,000.003,000.002,500.003,500.0020,000.00128,000.0016,500.00500.00267,750.005,250.0010,500.006,300.002,625.0010,500.0018,900 .004,200.005,250.00630.002,625.003,150.006,300.005,000.009,500.006,000.00157,500.00985,428.50 Budget 2017 12 Page Actual 12/31/15Actual 12/31/1631,036.51361.0015,000.0015,000.0010,120.597,131.55102-49300660SAC/Prairie Run Loans payback44,000.0044,000.00 0.00828.75397.50102-41940580Other Equipment0.005,474.002,393.2225,567.470.0058,973.371,203.50515.663,811.1022,422.003,636.656,780.734,283.4578,512.209,732.356,849.055,822.168,584.000.00913.2324,156.0 00.000.000.000.003,398.36548,933.84157,208.6412,122.2514,690.0011,218.27201.530.000.004,000.000.0041,707.6017,405.000.0031,089.9712,198.0020,186.980.0026,809.0776,338.820.000.0031,089.970.001,600.003 9,850.000.000.0017,842.1222,027.04847,827.23724,266.29 102-41940560Office Equipment & Furnishings3,193.86369.4586.00 102-49300665Capital Projects Transportation0.000.00 Agenda 2016 0.000.000.0039,505.290.001,515.420.000.000.000.000.000.00 2015 102-49300660Arena Roof Funding 5 year payba 102-41940530Improvements other than building sc 102-41940520Buildings & Structures/reserves 102-42000551Capital payback/future trucks 102-41800310Econ Development/Lobbying 102-42000593C/O Thermal Image Camera 102-43100541C/O Tractor/Loader/Bobcat 102-45100589C/O Park/Trail Construction 102-43100403Repair/Maint. Catch BasinsLibrary\\Senior Center Debt 102-42000584C/O Turnout Gear/Helmets 102-43100224Street Maint/improvement102-43100522C/O Public Works Building 102-49300650Working Capital Reserves 102-43100402Repair/Maint. Sidewalks 102-49300660Capital Reserves IT/AV 102-42000586C/O Pagers/800 radios 102-42000560Furniture and Fixtures102-41800599TIF Local Contribution 102-45100588C/O Park Mach/Equip 102-43100226Sign Repair Materails 102-42000591C/O Air Compressor 102-45100530Park Improvements 102-45100523C/O Park Buildings 102-43100582C/O Miscellaneous 102-49300650Ice Arena Funding 102-42000575Pension Reserve 102-42000551C/O Fire Trucks 102-43100542C/O Snow Plow 102-42000585C/O Air Packs 102-42000521C/O Fire Hall 102-42000670Depreciation 102-45100552C/O Pick-up 552C/O Pick-up 102-43100581C/O Mower 102-42000587C/O Tools 102-42000583C/O Hose 102-42000582Other Total Capital DEPT 49300 Capital Projects DEPT 42000 Fire Departmen DEPT 43100Public Works t 102 102-43100 DEPT 41940City Hall DEPT 45100 Parks 102 Capital Reserve s DEPT 41800 TIF