Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item 5 - CC 9 16 14 August Financials (2)
City of Lake Elmo 9/16/2014 2014 By Month Budget to Actual Comparative For the month ending August 31,2014 101-General Fund Summarx By Denarnnent MONTH YTD DEPT 410-GEN'L GOV'T BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($} Variance(%) Month Month Month Month YTD YTD YTD YTD REVENUE Total Revenue 32,950.00 66,768.09 33,818.09 102.63% 1,763,92058 1,744,192.93 (19,727.65) -1.12% EXPENSE Total Mavor&Counc0 75.00 0.00 75.00 100.00% 30,566.66 17,952.56 12,6]4.111 41.27% Total Administration 27,442.70 28,425.84 (983.14) -3.58% 270,605.19 287,086.82 (16,481.63) -6.09% Total Elections 2,625.00 3,928.91 (1,303.91) 49.67% 7,325.00 4,900.94 2,424.06 33.09% Total Communications 5,753.48 5,478.98 274.50 4.77% 51,353.91 61,998.46 (10,644.55) -20.73% Total Finance 9,510.24 12,070.33 (2,560.09) -26.92% 112,522.54 114,056.44 (1,533.90) -1.36% Total Planning&Zoning 20,108.41 18,912.11 1.196.30 5.95% 175,521.42 159,275.58 16,245.84 9.26% Total Engineering Services 4,000.00 3,990.47 9.53 0.24% 32,000.00 26,956.18 5,043.82 15.76% Total City Hall 2,283.32 2,022.29 261.03 11.43% 18,099.88 16,286.93 1,812.95 10.02% Total General Government 71,798.15 74,828.93 (3,030.78) 4.22% 697,994.60 688,513.91 9,480.69 1.36% DEPT 420-PUBLIC SAFETY Total Police 0.00 254,161.06 (254,161.06) -100.00% 2.50,000.00 255,472.78 (5,472.78) -2.19% Total Prosecution 4,250.00 4,242.50 7.50 0.18% 34,000.00 31,503.75 2,496.25 7.34% Total Fire 29,540.97 25,613.24 3,927.73 13.30% 271,555.96 250,494.29 21,061.67 7.76% Total Fire Relief 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Building Inspections 11,927.24 10,467.19 1,460.05 12.24% 104,861.29 103,635.66 1,225.63 1.17% Total Emergency Communications 0.00 0.00 0.00 0.00% 5,800.00 3,373.08 2,426.92 41.84% Total Animal Control 550.00 635.00 (85.00) -15.45% 4,182.08 4,394.00 (211.92) -5,07% Total Public Safety W,268.21 295,118.99 (248,8 00.78) -537.84% 670,399.33 648,873.56 21,525.77 3.21% Summary_I MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) DEPT 430-PUBLIC WORKS Month Month Month Month YTD YTD YTD YTD Total Public Works 27,708.91 23,314.35 4,394.56 15.86% 266,002.64 263,662.59 2„140.05 0.88% Total Streets 1,600.00 15,633.14 (14,033.14) -877.07% 11,300.00 35,578.08 (24,278,08) -214.85% Total Ice&Snow Removal 500.00 0.00 500.00 100.00% 63.500.00 58,353.25 5,146.75 8.11% Total Street Lighting 2,400.00 2,061.28 338.72 14.11% 19,200.00 14,462.00 4,738.00 24.68% Total Recycling 0.00 0.00 0.00 0.00% 7,400.00 5,083.09 2,316.91 31.31% Total Tree Program 0.00 4,400.00 (4,400.00) -100.00% 5,000.00 5,350.00 (350.00) -7.00% Total Public Works 32,208.91 45.408.77 (13,199.86) -40.98% 372,402.64 382,489.01 (10,086.37) -2.71% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 17,443.37 18,934.66 (1,491.29) -855% 146,271.64 139,096.09 7,175.55 4.91% DEPT 460-COMP ADJ 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% DEPT 490-CONTINGENCY FUND 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% DEPT 493-OTH FINANCING 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% GRAND TOTAL ALL DEPTS 167,718.64 434,291.35 (266,572.71) -158.94% 1,887,068.21 1,858.972.57 28,095.64 1.49% Net Income over Expenses (134,768.64) (367,523.26) (232,754.62) -172.71% (123,147.63) (114,779.64) 8,367.99 6.80% Summary_2 Citv of Lake Elmo 9/16/2014 2014 By Month Budget to Actual Comparative For the month ending August 31,2014 101-General Fund Detail By Deoartment Full Year MONTH YTD DEPT 410-GEN'L GOV'T BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) REVENUE 2014 %to date Month Month Month Month YTD YTD YTD YTD YTD variance notes Current Ad Valorem Taxes 2,565,000.00 45.46% 0.00 0.00 0.00 0.00% 1,282,500.00 1,165,956.51 (116,543.49) -9.09% Based on actual amounts collected by WA Cty Delinquent Ad Valorem Taxes 20,000.00 37.76% 0.00 0.00 0.00 0.00% 10,000.00 7,551.53 (2,448.47) -24.48% Mobile Home Tax 81000.00 71.92% 0.00 0.00 0.00 0.00% 4,000.00 5,753.84 1,753.84 43.85% Fiscal Disparities 120,000.00 75.37% 0.00 0.00 0,00 0.00% 60,000.00 90,444.17 30,444.17 50.74% Penalty&Interest on Taxes 5,180.00 7.23% 0.00 0.00 0.00 0.000/0 2,590.00 374.52 (2,215.48) -85.54% Liquor License 3,000.00 0.00% 0.00 0.00 0.00 0.00% 3,000.00 0.00 (3,000.00) -100.00% Prepaid in 2013 rather than early 2014 Wastehauler License 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 1,080.00 1,080.00 100.00% General Contractor License 165.00 30.30% 0.00 0.00 0.00 0.00% 165.00 50.00 (115.00) -69.70% Heating Contractor License 6,650.00 55.04% 500.00 250.00 (250.00) -50.00% 4,650.00 3,660.00 (990.00) -21.29% Blacktopping Contractor License 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Permits 170,500.00 69.20% 17,500.00 17,OO1.60 (498.40) -2.85% 108,000.00 117,989.85 9,989.85 9.25% 1 new home start and 1 new commercial start Building Re-inspect Fees 0.00 100.00% 0.00 100.00 100.00 100.00% 0.00 450.00 450.00 100.00% Heating Permits 15,600.00 80.34% 1,300.00 2,977.50 1,677.50 129.04% 10,400.00 12,532.50 2,132.50 20.50% Plumbing Permits 9,000.00 111.28% 500.00 I,490.00 990.00 198.00% 7,000.00 10,015.00 3,015.00 43.07% Sewer Permits 485.00 0.00% 0.00 0.00 0.00 0.00% 485.00 0.00 (485.00) -100.00% Animal License 1,991.00 116.70% 100.00 0.00 (100.00) -100.00% 1,741.00 2,323.50 582.50 33.46% Utility Pemmts(ROW) 11,000.00 118.35% 1,000.00 (4,107.80) (5,107.80) -510.78% 6,000.00 13,018.00 7,018.00 116.97% Due to I-94 expansion;ROW correction for July in Aug Burning Permit 3,350.00 31.64% 150.00 (40.00) (190.00) -126.67% 2,750.00 1,060.00 (1,690.00) -61.45% Massage Therapy Licenses 150.00 0.00% 0.00 0.00 0.00 0.00% 150.00 0.00 (150.00) -100.00% Electrical Permit 0.00 100.00% 0.00 1,047.47 1,047.47 100.00% 0.00 3,890.68 3,890.68 100.00% City share only(25%) Homestead Credit Aid 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% MSA-Maintenance 98,022.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.000/0 State Fire Aid 41,500.00 0.00% 0.00 0.00 0.00 0.00% 3,000.00 0.00 (3,000.00) -100.00% Budgeted in error;funds rec`d in 2013;sent on to fire relief assn PERA Aid 2,749.00 50.00% 0.00 0.00 0.00 0.00% 1,374.50 1,374.50 0.00 0.00% Gravel Tax 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Recycling Grant 15,500.00 100.00% 0.00 15,500.00 15,500.00 100.00% 15,500.00 15,500.00 0.00 0.00% Grant funds received 8/15/14 Misc State Grant/Surcharge Rev 1,150.00 9055.04% 0.00 4,064.00 4,064.00 100.00% 99,172.00 104,132.94 4,960.94 5.00% DNR trail grooming funds of$4k Cable Franchise Revenue 42,852.00 97.08% 0.00 0.00 0.00 0.00% 42,951.98 41,601.71 (1,250.27) -2.92% Cable franchise revenue received May I st Zoning&Subdivision Fees 1,250.00 1150.88% 0.00 6,710.95 6,710.95 100.000/0 500.00 14,385.95 13,885.95 2777.19% Developer zoning exceptions;Conditional Use Permits Plan Check Fees 82,000.00 88.99% 7,000.00 8,698.91 1,698.91 24.27% 56,000.00 72,974.60 16,974.60 30.31% Sale of Copies,Books,Maps 206.00 120.87% 0.00 20.00 20.00 100.00% 206.10 249.00 42.90 20,82% Assessment Searches 1,285.00 51.36% 100.00 90.00 (10.00) -10.000/0 885.00 660.00 (225.00) -25.42% Clean Up Days 3,000.00 75.93% 0.00 0.00 0.00 0.000/0 3,000.00 2,278.00 (722.00) -100.00% Cable Operation Reimbursement 1,950.00 39.68% 0.00 0.00 0.00 0.00% 1,200.00 773.75 (426.25) 100.00% Fines 48,000.00 63.29% 4,500.00 4,629.74 129.74 2.88% 34,000.00 30,378.03 (3,621.97) -10.65% Miscellaneous Permits 0.00 0.00% 0.00 7,500.00 7,500.00 100.00% 0.00 7,500.00 7,500.00 100.00% August includes$7,500 for fuel tank permit(Kwik Trip) Miscellaneous Revenue 2,400.00 186.01% 200.00 771.72 571.72 285.86% 1,600.00 4,464.35 2,864.35 179.02% Internal Charges 1,600.00 41.88% 100.00 64.00 (36.00) -36.00% 1,200.00 670.00 (530.00) -44.17% Fewer library card reimb than budgeted Interest Earnings 20,000.00 0.00% 0.00 0.00 0.00 0.000/0 0.00 0.00 0.00 0.00% Donations 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 11,100.00 11,100.00 100.00% Donation from LE Jaycees(Belong in event fund??) Total Revenue 3,303,535.00 52.80% 32,950.00 66,768.09 33,818.09 102.63% 1,763,920.58 1,744,192.93 (19,727.65) -1.12% Detail-I Full Year MONTH YTD EXPENSE BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 1110-Mayor&Council 2014 %to date Month Month Month Month YTD YTD YTD YTD PT Salaries 25,690.00 50.00% 0.00 0.00 0.00 0.00% 12,845.00 12,845.00 0.00 0.00% FICA Contributions 1,592.78 50.00% 0.00 0.00 0.00 0.00% 796.39 796.39 0.00 0.00% Medicare Contributions 372.54 50.00% 0.00 0.00 0.00 0.00% 186.27 186.27 0.00 0.00% Workers Compensation 300.00 0.00% 0.00 0.00 0.00 0.00% 300.00 0.00 300.00 100.00% Mileage 800.00 0.00% 75.00 0.00 75.00 100.00% 425.00 0.00 425.00 100.00% Miscellaneous 5,000.00 14.56% 0.00 0.00 0.00 0.000/0 5,000.00 727.90 4,272.10 85.44% Dues&Subscriptions 10,514.00 32.31% 0.00 0.00 0.00 0.00% 10,514.00 3,397.00 7,117.00 67.69% Includes Memberships;annual LMC to be paid in September Conferences&Training 1,000.00 0.00% 0.00 0.00 0.00 0.00% 500.00 0.00 500.00 100.00% Total Mayor&Council 45,269.32 39.66% 75.00 0.00 75.00 100.00% 30,566.66 17,952.56 12,614.10 41.27% 1320-Administration FT Salaries 176,384.00 62.45% 13,568.00 11,035.49 2,532.51 18.67% 115,328.00 110,152.61 5,175.39 4.49% PERA Contributions 12,505.02 63.85% 983.68 800.08 183.60 18.66% 8,219.87 7,984.35 235.52 2.87% ICMA Contributions 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 10,603.92 61.10% 841.22 659.85 181.37 21.56% 6,984.39 6,479.39 505.00 7.23% Medicare Contributions 2,479.96 61.10% 196.74 154.32 42.42 21,56% 1,633.45 1,515.30 118.15 7.23% Health/DentalInsurance 47,636.00 60.79% 3,716.00 3,620.00 96.00 2.58% 31,058.00 28,960.00 2,098.00 6.76% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 1,000.00 13.94% 0.00 0.00 0.00 0.00% 1,000.00 139.37 860.63 86.06% Office Supplies 6,000.00 67.31% 500.00 67.92 432.08 86.42% 4,000.00 4,038.64 (38.64) -0.97% Printed Forms 0.00 100.00% 0.00 138.00 (138.00) -100.00% 0.00 138.00 (138.00) 0.00% Legal Services 60,000.00 44.54% 5,000.00 3,214.50 1,785.50 35.71% 40,000.00 26,722.25 13,277.75 33.19% Newsletter/Website 0.00 100.00% 0.00 1,101.73 (1,101.73) -100.00% 0.00 1,661.60 (1,661.60) -100.00% Assessing Services 30,500.00 81.76% 2,000.00 2,500.00 (500.00) -25.00% 17,500.00 24,935.39 (7,435.39) 42.49% Information Technology 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 1,322.02 (1,322.02) -100.00% Comp upgrades appr by CC Contract Services 0.00 100.00% 0.00 3,507.60 (3,507.60) -100.00% 0.00 28,507.60 (28,507.60) -100.001/o Leg Lobbyist appr by CC&Temp svcs effective August Software Programs 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 2,058.00 (2,058.00) -100.00% Upgrades required;appr by CC Telephone 4,044.72 19.08% 337.06 87.10 249.96 74.16% 2,696.48 771.55 1,924.93 71.39% Postage 4,000.00 47.15% 0.00 500.00 (500.00) -100.000/0 2,500.00 1,886.17 613.83 24.55% Mileage 600.00 16.75% 0.00 0.00 0.00 0.00% 600.00 100.51 499.49 83.25% Legal Publishing 2,400.00 180.76% 200.00 714.58 (514.58) -257.29% 1,600.00 4,338.25 (2,738.25) -171.14% Due to notice increases due to development activities Insurance 35,000.00 71.49% 0.00 214.67 (214.67) -100.00% 35,000.00 25,022.67 9,977.33 28.51% Annual ins prem;budgeted in May Cable Operation Expense 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 600.00 195.41% 50.00 110.00 (60.00) -120.00% 400.00 1,172.47 (772.47) -193.12% Dues&Subscriptions 600.00 88.86% 50.00 0.00 50.00 100.00% 400.00 533.18 °(I33.18) -33.30% Books 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 42.28 (42.28) -100.00% Conferences&Training 2,185.00 393.83% 0.00 0.00 0.00 0.00% 1,685.00 8,605.22 (6,920.22) -410.70% Predictive Index;CC approved Staff Development 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Administration 396,538.62 72.40% 27,442.70 28,425.84 (983.14) -3.58% 270,605.19 287,086.82 (16,481.63) -6.09% 1410-Elections PT Salaries 10,000.00 38.05% 2,500.00 3,804.50 (1,304.50) -52,18% 5,000.00 3,804.50 1,195.50 23.91% Budget split out payments;full year cost anticipated to be less Office Supplies 500.00 0.00% 125.00 0.00 125.00 100.00% 250.00 0.00 250.00 100.00% than budgeted Legal Publications/Notification 500.00 0.00% 0.00 0.00 0.00 0.00% 250.00 0.00 250.00 100.00% Election Equipment 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Equipment Repair 450.00 0.00% 0.00 0.00 0.00 0.00% 225.00 0.00 225.00 100.00% County Election Fees 950.00 0.00% 0.00 0.00 0.00 0.00% 950.00 0.00 950.00 100.00% Printed Forms 350.00 0.00% 0.00 0.00 0.00 0.00% 350.00 0.00 350.00 100.000/0 Miscellaneous 600.00 182.74% 0.00 124.41 (124.41) -100.00% 300.00 1,096.44 (796.44) -265.48% WA Cry Ann Elect Mach Calibr Total Elections r 13,350.00 36.71% 2,625.00 3,928.91 (1,303.91) 49.67% 7,325.00 4,900.94 2,424.06 33.09% Not budgeted since no election scheduled;had to recalibrate machines for special school election. Detail-2 Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) 1450-Communications 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 13,390.00 96.71% 1,030.00 1,545.20 (515.20) -50,02% 8,755.00 12,949.80 (4,194.80) -47.91% PERA Contributions 970.78 96.71% 74.68 112.01 (37.33) -49.99% 634.74 938.85 (304.11) 47.91% FICA Contributions 830.18 93.80% 63.86 92.97 (29.11) -45.58% 542.81 778.73 (235.92) 43.46% Medicare Contributions 194.16 93.80% 14.94 21.75 (6.81) -45.58% 126.95 182.12 (55.17) 43.46% Health/DentalInsurance 3,120.00 69.74% 240.00 272.00 (32.00) -13.33% 2,040.00 2,176.00 (136.00) -6.67% Workers Compensation 110.00 14.90% 0.00 0.00 0.00 0.00% 110.00 16.39 93.61 85.10% Newsletter 8,000.00 63.60% 0.00 0.00 0.00 0.00% 4,000.00 5,088.06 (1,088.06) -27.20% Due to timing of newsletters Office Supplies 304.41 201.63% 50.00 0.00 50.00 100.00% 204.41 613.77 (409.36) -200.26% Info Technology/Web 42,000.00 75.63% 3,500.00 2,635.58 864.42 24.70% 28,000.00 31,764.71 (3,764.71) -13.45% Primarily due to Laserfiche upgrade approved by CC Telephone 1,560.00 35.38% 130.00 62.07 67.93 52.25% 1,040.00 551.85 488.15 46.94% Mileage 0.00 100.00% 0.00 0.00 0.00 0.00% 50.00 36.96 13.04 26.08% Public Notices 4,200.00 76.44% 300.00 547.40 (247.40) -82.47% 3,000.00 3,210.60 (210.60) -7.02% Cable Operations 3,600.00 80.02% 300.00 190.00 110.00 36.67% 2,400.00 2,880.62 (480.62) -20.03% Will be reimb by cable comm; filed quarterly for reimb Conferences 800.00 101.25% 0.00 0.00 0.00 0.00% 250.00 810.00 (560.00) -224.00% Repair/Maint Equipment 50.00 0.00% 50.00 0.00 50.00 100.00% 200.00 0.00 200.00 100.00% Total Communications 79,129.53 78.35% 5,753A8 5,478.98 274.50 4.77% 51,353.91 61.998.46 (10,644.55) -20.73% 1520-Finance FT Salaries 87,880.00 63.89% 6,760.00 6,258.10 501.90 7.42% 57,460.00 56,147.45 1,312.55 2.28% Due to PTO payout to accounting clerk PERA Contributions 6,371.30 62.00% 490.10 453.72 36.38 7.42% 4,165.85 3,950.50 215.35 5.17% FICA Contributions 5,448.56 58.98% 419.12 366.34 52.78 12.59% 3,562.52 3,213.43 349.09 9.80% Medicare Contributions 1,274.26 58.97% 98.02 85.68 12.34 12.59% 833.17 751.48 81.69 9.80% Health/Dental Insurance 19,936.00 39.84% 1,568.00 870.40 697.60 44.49% 12,976.00 7,942.40 5,033.60 38.79% Due to contractor cost savings Unemployment Benefits 0.00 100.00% 0.00 2,943.59 (2,943.59) -100.000/0 0.00 3,400.45 (3,400.45) -100.00% 100%allocation to GF vs primarily to Enterprise Funds Workers Compensation 600.00 12.93% 0.00 0.00 0.00 0.000/0 600.00 77.56 522.44 87.07% Office Supplies 300.00 51.86% 25.00 0.00 25.00 100.00% 200.00 155.57 44.43 22,22% Printed Forms 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 433A7 (433.47) -100.00% Audit Services 27,000.00 100.00% 0.00 0.00 0.00 0.00% 27,000.00 27,000.00 0.00 0.00% Installment pmt Contract Services 4,500.00 174.74% 0.00 1,065.00 (1,065.00) -100.00% 3,500.00 7,863A6 (4,363.46) -124.67% Offset salary and benefit savings above Software Programs 150.00 1249.69% 0.00 0.00 0.00 0.00% 150,00 1,874.54 (1,724.54) -1149.69% Upgrades required;appr by CC Telephone 1,200.00 18.33% 100.00 27.50 72.50 72.50% 800.00 220.00 580.00 72.50% Mileage 50.00 0.00% 0.00 0.00 0.00 0.00% 50.00 0.00 50.00 100.00% Miscellaneous 1,000.00 2.53% 50.00 0.00 50.00 100.00% 900.00 25.28 874.72 97.19% Dues&Subscriptions 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 540.00 (540.00) -100.00% Conferences R Training 575.00 80.15% 0.00 0.00 0.00 0.00% 325.00 460.85 (135.85) 41.80% Ehlers conf recommended by City Admin Zuleger Total Finance 156,285.12 72.98% 9,510.24 12,070.33 (2,560.09) -26.92% 112,522.54 114,056.44 (1,533.90) -1.36% Detail 3 Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) 1910-Planning&Zoning 2014 %to date Month Month Month Month YTD YTD YTD YTD YTD variance notes FT Salaries I59,874.00 65.11% 12,298.00 12,731.09 (433.09) -3.52% 104,533.00 104,094.17 438.83 0.42% PERA Contributions 11,590.87 68.00% 891.61 867.48 24.13 2.71% 7,578.64 7,882.30 (303.66) 4.01% FICA Contributions 9,912.19 66.63% 762.48 775.03 (12.55) -1.65% 6,481.05 6,604.79 (123.74) -1.91% Medicare Contributions 2,318.17 66.63% 178.32 181.25 (2.93) -1.64% 1,515.73 1,544.69 (28.96) -1.91% Health/DentalInsurance 34,814.00 61.54% 2,678.00 2,678.00 0.00 0.00% 22,763.00 21,424.00 1,339.00 5.88% Workers Compensation 800.00 17.97% 0.00 0.00 0.00 0.00% 800.00 143.78 656.22 82.03% Office Supplies 2,000.00 55.89% 150.00 41.15 108.85 72.57% 1,200.00 1,117.88 82.12 6.84% Printed Forms 750.00 111.73% 0.00 382.00 (382.00) -100.00% 250.00 838.00 (588.00) -235.20% Engineering Services 36,000.00 41.14% 3,000.00 1,191.38 1,808.62 60.29% 24,000.00 14,810.72 9,189.28 38.29% Contract Services 10,000.00 0.00% 0.00 0.00 0.00 0.000/0 5,000.00 0.00 5,000.00 100.00% Information Technology 0.00 0.00% 0.00 0.00 0.00 0.000/0 0.00 0.00 0.00 0.00% Telephone 1,200.00 31.89% 100.00 64.73 35.27 35.27% 800.00 382.63 417.37 52.17% Postage 200.00 6134% 0.00 0.00 0.00 0.00% 100.00 122.68 (22,68) -22.68% Mileage 200.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 500.00 14.19% 50.00 0.00 50.00 100.00% 300.00 70.94 229.06 76.35% Dues&Subscriptions 600.00 39.83% 0.00 0.00 0.00 0.00% 0.00 239.00 (239.00) -100.00% Books 300.00 0.00% 0.00 0.00 0.00 0.00% 200.00 0.00 200.00 100.00% Conferences&Training 2,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Planning&Zoning 273,059.23 58.33% 20,108.41 18,912.11 1,196.30 5.95% 175,521A2 159,275.58 16,245.84 9.26% 1930-Engineering Services Engineering Services 48,000.00 56.16% 4,000.00 3,990.47 9.53 0.24% 32,000.00 26,956.18 5,043.82 15.76% Total Engineering Services 48,000.00 56.16% 4,000.00 3,990.47 9.53 0.24% 32,000.00 26,956.18 5,043.82 15.76% 1940-City Hall Cleaning Supplies 25.00 0.00% 0.00 0.00 0.00 0.000/0 25.00 0.00 25.00 100.00% Building Repair Supplies 200.00 81.99% 25.00 0.00 25.00 100.000/0 100.00 163.97 (63.97) -63.97% Telephone 2,400.00 31.41% 200.00 58.35 141.65 70.83% 1,600.00 753.86 846.14 52.88% Utilities 13,200.00 55.81% 1,100.00 780.53 319.47 29.04% 8,800.00 7,367.26 1,432.74 16.28% Refuse 1,408.16 54.64% 108.32 109.78 (1.46) -1.35% 974.88 769.36 205.52 21.08% Repairs/Maint Contractual Bldg 7,200.00 40.57% 600.00 188.00 412.00 68,67% 4,800.00 2,921.29 1,878.71 39.14% Repairs/Maint Contractual Equip 2,400.00 165.19% 200.00 774.96 (574.96) -287.48% 1,600.00 3,964.58 (2,364.58) -147.79% Annex repairs-Yale Mech Miscellaneous 300.00 115.54% 50.00 110.67 (60.67) -121.34% 200.00 346.61 (146.61) -73.31% Total City Hall 27,133.16 60.03% 2,283.32 2,022.29 261.03 11.43% 18,099.88 16,286.93 1,812.95 10.02% Total General Government 1,038,764.98 66.28% 71,798.15 74,828.93 (3,030.78) 4.22% 697,994.60 688,513.91 9,480.69 1.36% Detail 4 DEPT 420-PUBLIC SAFETY Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 2100-Police 2014 %to date Month Month Month Month YTD YTD YTD YTD Law Enforcement Contract 500,000.00 51.09% 0.00 254,161.06 (254,161.06) -100.00% 250,000.00 255,472.78 (5,472.78) -2.19% Total Police 500,000.00 51.09% 0.00 254,161.06 (254,161.06) -100.00% 250,000.00 255,472.78 (5,472.78) -2.19% 2150-Prosecution Attorney Criminal 51,000.00 61.77% 4,250.00 4,242.50 7.50 0.18% 34,000.00 31,503.75 2,496.25 7.34% Total Prosecution 51,000.00 61.77% 4,250.00 4,242.50 7.50 0.18% 34,000.00 31,503.75 2,496.25 7.34% 2220-Fire FT Salaries 74,119.04 65.49% 5,701 A6 5,712.85 (11.39) -0.20% 48,462.44 48,537.15 (74.71) -0.15% PT Salaries 109,455.98 63.41% 7,618.46 7,261.87 356.59 4.68% 75,172.91 69,403.99 5,768.92 7.67% PERA Contributions 1I,785.11 73.91% 949.39 976.19 (26.80) -2.82% 7,987.55 8,710.33 (722.78) -9.05% Due to FF rate change effective 1/1/2014 FICA Contributions 11,381.65 33.94% 825.84 396.85 428.99 51.95% 7,665.39 3,863.14 3,802.25 49.60% FF budgeted at normal 6 2%;Full time fire FF rate is zero Medicare Contributions 2,661.84 61.91% 193.14 180.61 12.53 6.49% 1,792.71 1,648.07 144.64 8.07% Health/Dental insurance 15,990.00 57.14% 1,230.00 1,142.00 88.00 7.15% 10,455.00 9,136.00 1,319.00 12.62% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.000/0 0.00 0.00 0.00 0.00% Workers Compensation 9,000.00 17.11% 0.00 0.00 0.00 0.00% 9,000.00 1,539.45 7,460.55 82.90% Office Supplies 500.00 142.80% 50.00 0.00 50.00 100.00% 300.00 714.02 (414.02) -138.01% EMS Supplies 4,900.00 4.66% 1,500.00 0.00 1,500.00 100.00% 3,400.00 228.37 3,171.63 93.28% Fire Prevention 3,000.00 0.00% 250.00 0.00 250.00 100.00% 2,000.00 0.00 2,000.00 100.00% Fuel,Oil&Fluids 14,000.00 64.59% 1,200.00 806.25 393.75 32.81% 9,600.00 9,042.98 557.02 5.80% Small Tools&Equip 22,500.00 35.49% 1,900.00 0.00 1,900.00 100.00% 15,200.00 7,984.58 7,215.42 47.470/a YTD includes Themal Imaging camera from Jan Physicals 6,900.00 33.76% 575.00 1,255.22 (680.22) -118.30% 4,600.00 2,329.22 2,270.78 49.36% Information Technology 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 661.01 ° Telephone 4,200.00 73.04% 350.00 283.24 66.76 19.07% 2,800.00 3,067.64 (267.64) -9.56% Radio 16,203.04 53.75% 0.00 0.00 0.00 0.00% 8,601.52 8,708.87 (107.35) -1.25% Mileage 350.00 0.00% 50.00 0.00 50.00 100.00% 150.00 0,00 150.00 0.000/0 Insurance 5,237.00 97.69% 0.00 0.00 0.00 0.00% 5.237.00 5,116.00 121.00 2.31% Fireball#2 charged to PW in error;reclassed in June Electric Utility 21,600.00 42.29% 1,800.00 649.83 1,150.17 63.90% 14,400.00 9,133.91 5,266.09 36.57% Refuse 572.16 177.69% 47.68 304.53 (256.85) -538.70% 38IA4 1,016.69 (635.25) -166.54% Repair/Maint Bldg 12,000.00 35.01% 1,000.00 280.50 719.50 71.95% 8,000.00 4,200.71 3,799.29 47.49% Repair/Maint Equip 41,000.00 116.41% 3,400.00 5,567.38 (2,167.38) -63.75% 27,200.00 47,726.21 (20,526.21) -75.46% Month-Equipment annual inspections;spread out in budget Uniforms 3,000.00 60.31% 250.00 119.20 130.80 52.32% 2,000.00 1,809.40 190.60 9.53% (YTD-Emergency ladder repair bill-$1I,500) Miscellaneous 900.00 155.93% 100.00 23.82 76.18 76.18% 800.00 1,403.35 (603.35) -75.42% Dues&Subscriptions 2,200.00 114.91% 0.00 0.00 0.00 0.00% 2,200.00 2,528.00 (328.00) -14.91% Books 200.00 51.00% 50.00 0.00 50.00 100.00% 150.00 102.00 48.00 32.00% Conferences&Training 6,000.00 73.49% 500.00 652.90 (152.90) -30.58% 4,000.00 4,409.58 (409.58) -10.24% Conferences&Training(Reimb) 0.00 -100.00% 0.00 0.00 0.00 0.00% 0.00 (2,526.38) 2,526.38 100.00% Reimb segregated out for better tracking Total Fire 399,655.82 62.68% 29,540.97 25,613.24 3,927.73 13.30% 271,555.96 250,494.29 21,061.67 7.76% 2250-Fire Relief Fire State Aid 37,323.50 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Fire Relief 37,323.50 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% Detail 5 Full Year MONTH YTD 2400-Building Inspection BUDGET BUDGET ACTUAL Variance($) Variance(%} BUDGET ACTUAL Variance($) Variance(%) 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 95,992.00 60.61% 7,384.00 6,892.92 491.08 6.65% 62,764.00 58,182.08 4,581.92 7.30% PERA Contributions 6,959.42 60.61% 535.34 499.72 35.62 6.65% 4,550.39 4,218.12 332.27 7.30% FICA Contributions 5,951.50 56.95% 457.81 401.64 56.17 12.27% 3,891.37 3,389.29 502.08 12.90% Medicare Contributions 1,391.88 56.94% 107.07 93.92 13.15 12.28% 910.08 792.59 117.49 12.91% Health/DentalInsurance 24,102.00 46.93% 1,896.00 1,414.00 482.00 25.42% 15,687.00 11,312.00 4,375.00 27,89% Unemployment Benefits 0-00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 397.88 19.12% 0.00 0.00 0.00 0.00% 397.88 76.07 321.81 80.88% Office Supplies 1,447.44 11.43% 100.00 11.68 88.32 88.32% 1,047.44 165.41 882.03 84.21% Printed Forms 146.61 0.00% 0.00 0.00 0.00 0.00% 146.61 0.00 146.61 100.00% Fuel,Oil&Fluids 465.56 23.50% 51.36 0.00 51.36 100.00% 260.12 109.42 150.70 57.93% Engineering 10,000.00 60.21% 1,000.00 978.75 21.25 2.13% 6,750.00 6,021.10 728.90 10.80% Surcharge Pmts 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Inspector Contract Services 3,281.50 65.23% 200.00 0.00 200.00 100.00% 1,781.50 2,140.50 (359.00) -20.15% Information Technology 4,180.00 348.98% 0.00 0.00 0.00 0.00% 4,180.00 14,587.16 (10,407.16) -248.98% Permit Works Software Programs 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 547.92 84.19% 45.66 53.04 (7.38) -16.16% 365.28 461.27 ° Mileage 600.00 42.30% 50.00 121.52 (71.52) -143.04% 400.00 253.78 146.22 36.56% Insurance 340.00 72.94% 0.00 0.00 0.00 0.00% 340.00 248.00 92.00 27.06% Repairs/Maint Equip 300.00 71.09% 0.00 0.00 0.00 0.00% 100.00 213.28 (113.28) -113.28% Uniforms 0.00 0.00% 0.00 0.00 0.00 0.00% 86.38 121.98 (35.60) -41.21% Miscellaneous 500.00 23.47% 100.00 0.00 100.00 100.00% 400.00 117.37 282.63 70.66% Dues&Subscriptions 0.00 100.00% 0.00 0.00 0.00 0.000/0 0.00 220.00 (220.00) -100.00% Books 308.24 112.48% 0.00 0.00 0.00 0.000/0 208.24 346.71 (138.47) -66.50% Conferences&Training 690.00 95.58% 0.00 0.00 0.00 0.000/0 595.00 659.53 (64.53) -10.85% Erosion control conf Total Building Inspections 157,601.95 65.76% 11,927.24 10,467.19 1,460.05 12.24% 104,861.29 103,635.66 1,225.63 1.17% 2500-Emergency Communications Contract Services 5,800.00 58.16% 0.00 0.00 0.00 0.00% 5,800.00 3,373.08 2,426.92 41.84% Budect vs actual timing issue Total Emergency Communications 5,800.00 58.16% 0.00 0.00 0.00 0.00% 5,800.00 3,373.08 2,426.92 41.84% 2700-Animal Control Printed Forms 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Contract Services 5,842.08 59.91% 500.00 500.00 0.00 0.00% 3,842.08 3,500.00 342.08 8.90% Miscellaneous(impounding) 440.00 203.18% 50.00 135.00 (85.00) -170.00% 340.00 894.00 (554.00) -162.94% Animal impound fees;recovering funds where possible Total Animal Control 6,282.08 69.94% 550.00 635.00 (85.00) -15.45% 4,182.08 4,394.00 (211.92) -5.07% Total Public Safety 1,157,663.35 56.050/. 46,268.21 295,i18.99 (248,850.78) -537.84% 670,399.33 648,873.56 21,525.77 3.21% Detail 6 DEPT 430-PUBLIC WORKS Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) 3100-Public Works 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 178,568.00 61.78% 13,736.00 11,972.34 1,763.66 12.84% 116,756.00 110,326.99 6,429.01 5.51% PT Salaries 0.00 100.00% 0.00 3,024.25 (3,024.25) -100.00% 0.00 15,793.67 (15,793.67) -100.00% Extra staff for snow removal PERA Contributions 12,946.18 68.64% 995.86 999,41 (3.55) -0.36% 8,464.81 8,886.64 (421.83) -4.98% FICA Contributions 11,071.00 67.32% 851.63 891.35 (39.72) -4.66% 7,238.87 7,453A7 (214.60) -2.96% Medicare Contributions 2,589.24 67.32% 199.17 208.41 (9.24) -4.64% 1,692.96 1,743.07 (50.11) -2.96% Health/DentalInsurance 42,640.00 54.39% 3,280.00 2,899.00 381.00 11.62% 27,880.00 23,192.00 4,688.00 16.81% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 8,000.00 17,71% 0.00 0.00 0.00 0.00% 8,000.00 1,416.59 6,583.41 82.29% Represents prior year audit balance due;2014 to hit in Sept Office Supplies 300.00 445.21% 25.00 0.00 25.00 100.00% 200.00 1,335.64 (1,135.64) -567.82% Shop Materials 600.00 259.78% 50.00 42.13 7.87 15.74% 400.00 1,558.65 (1,158.65) -289.66% Building Repair Supplies 300.00 151.08% 25.00 0.00 25.00 100.00% 200.00 453.24 (253.24) -126.62% Small Tools and Minor Equip 2,400.00 28,89% 200.00 0.00 200.00 100.00% 1,600.00 693.29 906.71 56.67% Engineering Services 9,000.00 91.08% 750.00 804.36 (54.36) -7.25% 6,000.00 8,197.50 (2,197.50) -36.63% Primarily ROW.work;majority recovered by ROW fees Contract Services 1,200.00 98.71% 100.00 287.30 (187.30) -187.30% 800.00 1,184.50 (384.50) -48.06% Information Technology 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 661.01 (661.01) 0.000/0 Telephone 7,661.16 57.91% 638.43 457.74 180.69 28.30% 5,107.44 4,436.22 671.22 13.14% Radio 1,500.00 81.33% 0.00 0.00 0.00 0.00% 1,500.00 1,219.94 280.06 18.67% Mileage 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 20,000.00 76.18% 0.00 0.00 0.00 0.00% 20,000.00 15,235.00 4,765.00 23.83% Firehall#2 Ins charged to PW in error;reclassed in June Electric Utility 24,000.00 67.05% 2,000.00 651.36 1,348.64 67A3% 16,000.00 16,092.50 (92.50) -0.58% Refuse 2,493.84 59.20% 207.82 210.63 (2.81) -1.35% 1,662.56 1,476.27 186.29 11.21% Fuel,Oil,Fluids(ALL depts) 48,000.00 66.33% 4,000.00 699.69 3,300.31 82.51% 32,000.00 31,839.07 160.93 0.50% Repair/Maint Bldg 1,200.00 286.36% 100.00 10.00 90.00 90.00% 800.00 3,436.36 (2,636.36) -329.55% Repair/Maint NOT Bldg 600.00 107.98% 50.00 0.00 50.00 100.00% 400.00 647.90 (247.90) -61.98% Repair/Maint Equip(out) 3,600.00 0.97% 300.00 0.00 300.00 100.00% 2,400.00 34.96 2,365.04 98.54% Equipment Parts 0.00 100,00% 0.00 0.00 0.00 0,000/0 0.00 155.24 (155.24) -100.00% Uniforms 1,200.00 92.24% 100.00 156.38 (56.38) -56.38% 800.00 1,106.84 (306.84) -38.36% Miscellaneous 600.00 112.79% 50.00 0.00 50.00 100.00% 400.00 676.73 (276.73) -69.18% Landscaping Material 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 300.00 61.67% 50.00 0.00 50.00 100.00% 200.00 185.00 15.00 7.50% Conferences&Training 500.00 0.00% 0.00 0.00 0.00 0.00% 500.00 0.00 500.00 100.00% Clean up Days 5,000.00 84.49% 0.00 0.00 0.00 0.00% 5,000.00 4,224.30 775.70 15.51% June clean up days;budgeted in July since paid later last year Total Public Works 386,269A2 68.26% 27,708.91 23,314.35 4,394.56 15.86% 266,002.64 263,662.59 2,340.05 0,88% 3120-Streets Equipment Parts 1,200.00 123.35% 100.00 615.00 (515.00) -515.00% 800.00 1,480.17 (680.17) -85.02% Street Maintenance Materials 12,000.00 98.03% 1,000.00 3,557.29 (2,557.29) -255.73% 8,000.00 11,763.33 (3,763.33) -47.04% Sign Repair Materials 0.00 100.00% 0.00 6,960.85 (6,960.85) -100.00% 0.00 8,440.40 (8,440.40) -100.00% General road sign upgrades needed but not budgeted Contract Services 1,200.00 1151.33% 300.00 4,500.00 (4,200.00) -100.00% 900.00 13,815.93 (12,915.93) -1435.10% YTD-Curbs for tapestry;water drainage issues Repairs/Maint Equipment 2,400.00 3.26% 200.00 0.00 200.00 100.00% 1,600.00 78.25 1,521.75 95.11% Total Streets 16,800.00 211.77% 1,600.00 15,633.14 (14,033.14) -877.07% 11,300.00 35,578.08 (24,278.08) -214.85% Detail 7 Full Year MONTH YTD 3125-Ice&Snow Removal BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) 2014 %to date Month Month Month Month YTD YTD YTD YTD Landscaping Material 0.00 100.00% 0.00 0.00 0.00 0.000/0 0.00 11.09 (11.09) -100.00% Sand/Salt 70,000.00 64.88% 0.00 0.00 0.00 0.000/0 55,000.00 45,416.16 9,583.84 17.43% Contract Services 20,000.00 50.46% 0.00 0.00 0.00 0.000/c. 4,500.00 10,092.50 (5,592.50) -124.28% Repairs/Maint Equipment 6,000.00 47.23% 500.00 0.00 500.00 100.000/0 4,000.00 2,833.50 1,166.50 29.16% Total Ice&Snow Removal F 96,000.00 60.78% 500.00 0.00 500.00 100.00% 63,500.00 58,353.25 5,146.75 8.11% 3160-Street Lighting Street Lighting 28,800.00 50.22% 2.400.00 2,061.28 338.72 14.11% 19,200.00 14,462.00 4,738.00 24.68% Total Street Lighting 28,800.00 50.22% 2,400.00 2,061.28 338.72 14.11% 19,200.00 14,462.00 4,738.00 24.68% 3200-Recycling Recycling Supplies 3,400.00 149.50% 0.00 0.00 0.00 0.00% 3,400.00 5,083.09 (1,683.09) 49.50% CFL bulbs for residents(coding correction from"misc") Newsletter 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 4,000.00 0.00% 0.00 0.00 0.00 0.00% 4,000.00 0.00 4,000.00 100.00% Total Recycling 7,400.00 68.69% 0.00 0.00 0.00 0.00% 7,400.00 5,083.09 2,316.91 31.31% 3250-Tree Program Contract Services 5,000.00 107,00% 0.00 4,400.00 (4,400.00) -100.00% 5,000.00 5,350.00 (350.00) -7.00% Total Tree Program 5,000.00 107.00% 0.00 4,400.00 (4,400.00) -100.00% 5,000.00 5,350.00 (350.00) -7.00% Total Public Works 540.269.42 70.80% 32,208.91 45.408.77 (13,199.86) -40.98% 372.402.64 382,489.01 (10,086.37) -2.71% Detail 8 DEPT 450-CULTURE,RECREATI4 Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 5200-Parks&Recreation 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 135,250.00 53.45% 11,500.00 8,128.79 3,371.21 29.31% 92,975.00 72,291.66 20,683.34 22.25% PT Salaries 0.00 100.00% 0.00 5,140.25 (5,140.25) -100.00% 0.00 16,713.55 (16,713.55) -100.00% Extra part time help PERA Contributions 9,906.38 53.81% 833.75 589.39 244.36 29.31% 6,740.69 5,330.37 1,410.32 20.92% FICA Contributions 8,472.90 62.92% 713.00 800.52 (87.52) -12,27% 5,764.45 5,331.08 433.37 7.52% Medicare Contributions 1,981.28 62.92% 166.75 187.21 (20A6) -12.27% 1,348.14 1,246.67 101.47 7.53% Health/DentalInsurance 14,376.00 16.15% 2,216.00 290.16 1,925.84 86.91% 12,404.00 2,321.28 10,082.72 81.29% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 4,500.00 17.47% 0.00 0.00 0.00 0.00% 4,500.00 786.07 3,713.93 82.53% Shop Materials 1,000.00 26.24% 0.00 155.44 (155.44) -100.00% 1,000.00 262.40 737.60 73.76% Chemicals 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 211.37 (211.37) 0.00% Equipment Parts 2,023.50 222.30% 0.00 1,164.83 (1,164.83) -100.00% 1,023.50 4,498.24 (3,474.74) -339.50% 480D radiator repair/service Building Repair Supplies 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 814.89 (814.89) -100.00% Landscaping Materials 3,000.00 195.03% 0.00 1,438.83 (1,438.83) -100.00% 2,000.00 5,851.02 (3,851.02) -192.55% Small Tools and Minor Equip 1,888.10 56.90% 39.87 80.90 (41.03) -102.91% 1,728.62 1,074.35 654.27 37.85%, Telephone 1,597.51 42.80% 180.86 74.37 106.49 58.88% 874.07 683.67 190.40 21.78% Mileage 0.00 0.00% 0.00 0.00 0.00 0.000/0 0.00 0.00 0.00 0.00% Insurance 3,683.00 86.10% 0.00 0.00 0.00 0.000/0 3,683.00 3,171.00 512.00 13.90% Annual ins prem;budgeted in May Electric Utility 9,839.82 53.49% 919.64 734.37 185.27 20.15% 6,463.07 5,263.45 1,199.62 18.56% Refuse 2,500.00 33.75% 250.00 0.00 250.00 100.00% 1,581.28 843.76 737.52 46.64% Repair/Mainz Bldg 1,723.75 23.65% 246.25 10.00 236.25 95.94% 985.00 407.64 577.36 58.62% Repair/Maint NOT Bldg 274.39 2041.21% 27.25 139.60 (112.35) -412.29% 150.82 5,600.87 (5,450.05) -3613.61% Light repairs at Lions field,trail grooming at Sunfish Lake Park Repair/Maint Equip 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 2,298.66 (2,298.66) -100.00% Unforeseen repairs on 98 GMC Rental Buildings 3,600.00 95.68% 300.00 0.00 300.00 100.00% 2,400.00 3,444.34 (1,044.34) -43.51% Miscellaneous 1,220.00 53.26% 50.00 0.00 50.00 100.00% 650.00 649.75 0.25 0.04% Total Parks&Recreation 206,836.63 67.25% 17,443.37 18,934.66 (1,491.29) -8.55% 146,271.64 139,096.09 7,175.55 4.91% DEPT 460-COMP ADJ 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% DEPT 490-CONTINGENCY FUND 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Transfer to CIO,Projects(Streets) 160.000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% To cover levy debt svc increase 21.632.00 0.00% 0.00 0.00 0.00 0.000/0 0.00 0.00 0.00 0.00% DEPT 493-OTH FINANCING 200,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% GRAND TOTAL ALL DEPTS 3,325,166.38 55,91% 167,718.64 434,291.35 (266,572,71) -158.94% 1,887,068.21 1,858,972.57 28,095.64 1.49% Net Income over Expenses 1 (21,631.38) (134,768.64) (367,523.26) (232,754.62) -172.71% (123.147.63) (114,779.64) 8,367.99 6.80% Detail 9