Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item 3 - CC 5 20 14 Financials
City of Lake Elmo 5/20/2014 2014 By Month Budget to Actual Cona a�rative For the month ending April 30,2014 101-General Fund Summary By Department MONTH YTD DEPT 410-GEN'L GOV'T BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance($} Variance(%) Month Month Month Month YTD YTD YTD YTD YTD Commentary REVENUE Total Revenue 72,781.98 18,918.03 (53,863.95) -74.01% 206,074.23 156,609.56 (49,464.67) -24.00% EXPENSE Total Mayor&Council 75.00 3.19 71.81 95.75% 12,742.00 4,119.42 8,622.58 67.67% Total Administration 29,146.70 39,052.52 (9,905.82) -3399% 113,871.76 156,606.00 (42,734.24) -37.53% Total Elections 0.00 0.00 0.00 0.00% 0.00 940.00 (940.00) -100.00% Not budgeted since no election scheduled;had to recalibrate machines for special school election. Total Communications 5,703.48 16,229.04 (10,525.56) -184,55% 25,496.74 36,290.35 (10,793.61) -42.33% Total Finance 9,446.24 19,576.34 (10,130.10) -107.24% 51,359.96 52,831.09 (1,471.13) -2.86% Total Planning&Zoning 20,208.41 18,486.89 1,721.52 8.52% 84,083.60 75,976.05 8,107.55 9.64% Total Engineering Services 4,000.00 2,389.81 1,610.19 40.25% 16,000.00 13,844.77 2,155.23 13.47% Total City Hall 2,391.64 2,235.06 156.58 6.55% 9,066.60 8,963.29 103.31 1.14% Total General Government 70,971.47 97,972.85 (27,001.38) -38.05%° 312,620.66 349,570.97 (36,950.31) -1L82% DEPT 420-PUBLIC SAFETY Total Police 0.00 0.00 0.00 0.00% 0.00 634.22 (634.22) -100.00% Total Prosecution 4,250.00 4,737.25 (487.25) -11.46% 17,000.00 13,579.75 3,420.25 20.12% Total Fire 31,791.73 29,755.11 2,036.62 6.41% 139,303.10 124,320.10 14,983.00 10.76% Total Fire Relief 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Building Inspections 12,468.67 25,215.04 (12,746.37) -102.23% 51,428.63 55,574.33 (4,145.70) -8.06% Total Emergency Communications 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Animal Control 710.00 695.00 15.00 2.11% 1,740.00 1,860.00 (120.00) -6.90% Toil Public Safety 49 220.40 60 402.40 (11,182.00) 722.72% 209,471.73 195,968.40 13,503.33 6.45% Summary-1 MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) DEPT 430-PUBLIC WORKS Month Month Month Month YTD YTD YTD YTD YTD Commentary Total Public Works 29,208.91 28,078.09 1,130.82 3.87% 120,735.66 143,222.28 (22,486.62) -18.62% Total Streets 1,300.00 223.62 1,076.38 82.80% 5,500.00 6,459.71 (959.71) -17.45% Total Ice&Snow Removal 500.00 1,080.34 (580.34) -116.07% 61,500.00 57,341.49 4,158.51 6.76% Total Street Lighting 2,400.00 2,125.80 274.20 11.43% 9,600.00 6,461.89 3,138.11 32.69% Total Recycling 0.00 2,132.45 (2,132.45) -100.00% 0.00 3,673.46 (3,673.46) -100.00% Total Tree Program 0.00 950.00 (950.00) -100.00% 3,750.00 950.00 2,800.00 74.67% Total Public Works 33,408.91 34,590.30 (1,181.39) -3.54% 20I,085.66 218,108.83 (17,023.17) -8.47% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 15,891.05 15,101.61 789.44 4.97% 64,227.68 57,889.65 6,338.03 9.87% DEPT 460-COMP AD,I 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 169,491.83 208,067.16 (38,575.33) -22.76% 787,405.73 821,537.85 (34,132.12) -4.33% Net Income over Expenses (96,709.85) (189,149.13) (92,439.28) -95.58% (581,331.50) (664,928.29) (83,596.79) -14.38% Summary_2 it�of Lake Elmo 5t20/2014 C 2014 By Month Budget to Actual Comparative For the month endinAnril 30,2014 101-General Fund Detail By Department MONTH YTD DEPT 410-GEN'L GOV'T BUDGET ACTUAL Variance M Variance{%) BUDGET ACTUAL Variance($} Variance Month Month Month Month YTD YTD YTD YTD YTD Commentary REVENUE - - Current Ad Valorem Taxes 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Delinquent Ad Valorem Taxes 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Mobile Home Tax 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Fiscal Disparities 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Penalty&Interest on Taxes 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Liquor License 500.00 0.00 (500.00) -100.00% 2,000.00 0.00 (2,000.00) -100.00% Prepaid in 2013 rather than early 2014 Wastehauler License 0.00 0.00 0.00 0.00% 0.00 840.00 840.00 100.00% General Contractor License 0.00 0.00 0.00 0.00% 165.00 0.00 (165.00) -100.00% Heating Contractor License 550.00 300.00 (250.00) -45.45% 2,950.00 1,600.00 (1,350.00) -45.76% Blacktopping Contractor License 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Permits 14,000.00 6,708.15 (7,291.85) -52.08% 48,000.00 48,188.25 188.25 0.39% March was very busy;activity offset slower months Heating Permits 1,500.00 720.00 (780.00) -52.00% 4,500.00 4,040.00 (460.00) -10,22% Plumbing Permits 1,500.00 1,745.00 245.00 16.33% 4,000.00 4,625.00 625.00 15.63% Sewer Permits 120.00 0.00 (120.00) -100.00% 485.00 0.00 (485.00) -100.00% Animal License 141.00 100.00 (41.00) -29.08% 1,261.00 1,938.50 677.50 53.73% Utility Permits(ROW) 1,000.00 1,488.20 488.20 48.82% 1,750.00 4,392.80 2,642.80 151.02% Due to I-94 expansion Burning Permit 500.00 420.00 (80.00) -16.00% 1,100.00 600.00 (500.00) -45.45% Massage Therapy Licenses 0.00 (38.50) (38.50) -100.00% 0.00 (38.50) (38.50) -100.00% Permit refund Electrical Permit 0.00 321.35 321.35 100.00% 0.00 586.33 586.33 100.00% City share of revenue only(25%) Homestead Credit Aid 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% MSA-Maintenance 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% State Fire Aid 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% PERA Aid 0.00 0.00 0.00 0.00% 3,000.00 0.00 (3,000.00) -100.00% Based on funds ree'd in 2013;snh;relief related Gravel Tax 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Recycling Grant 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Mise State Grant/Surcharge Rev 1,150.00 106.68 (1,043.32) -90.72°% 50,161.00 50,954.68 793.68 1.58% Cable Franchise Revenue 39,851.98 0.00 (39,851.98) -100.00% 39,85198 0.00 (39,851.98) -100.00% Cable franchise revenue received May I st Zoning&Subdivision Fees 0.00 0.00 0.00 0.00% 250.00 0.00 (250.00) -100.00% Plan Check Fees 7,000.00 2,768.76 (4,231.24) -60.45% 28,000.00 25,523.25 (2,476.75) -8.85% Sale of Copies,Books,Maps 19.00 26.00 7.00 36.84% 110.25 136.75 26.50 24.04% Assessment Searches 150.00 75.00 (75.00) -50.00% 390.00 180.00 (210.00) -53.85% Clean Up Days 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% 0 Cable Operation Reimbursement 0.00 0.00 0.00 0.00% 0.00 0.00 0. 00 0.00% Fines 4,500.00 3,855.26 (644.74) -14.33% 16,500.00 11,805.37 (4,694.63) -28.45% Miscellaneous Revenue 200.00 264.13 64.13 32.07% 800.00 789.13 (10.87) -1.36% CUP permits Internal Charges 100.00 58.00 (42.00) -42.00% 800.00 448.00 (352.00) -44.00% Fewer library card reimb than budgeted Interest Earnings 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Donations 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Revenue Revenue 72,7131.95 1�,915.03 (53,863.95) -74.01% 206,074.23 156,609.56 (49,464,67} -24.00% Detail-1 MONTH YTD EXPENSE BUDGET ACTUAL Variance($} Variance(%} BUDGET ACTUAL Variance($) Variance(%) 1110-Mayor&Council Month Month Month Month YTD YTD YTD YTD YTD Commentary PT Salaries 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Medicare Contributions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 300.00 0.00 300.00 100.00% Mileage 75.00 0.00 75.00 100.00% 75.00 0.00 75.00 100.00% Miscellaneous 0.00 3.19 (3.19) -100.00% 5,000.00 722.42 4,277.58 85.55% Dues&Subscriptions 0.00 0.00 0.00 0.00% 7,117.00 3,397.00 3,720.00 52.27% Conferences&Training 0.00 0.00 0.00 0.00% 250.00 0.00 250.00 100.00% Total Mayor&Council 75.00 3.19 71.81 95.75% 12,742.00 4,119.42 8,622.58 67.67% 1320-Administration FT Salaries 13,568.00 13,271.37 296.63 2.19% 54,272.00 52,667.06 1,604.94 .3 PERA Contributions 983.68 962.17 21.51 2.19% 3,934.72 3,816.67 118.05 .00% % ICMA Contributions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 841.22 779.61 61.61 7.32% 3,364.86 3,091.05 273.81 8.14% Medicare Contributions 196.74 182.32 14.42 7.33% 786.94 722.88 64.06 8.14% Health/Dental Insurance 3,620.00 3,620.00 0.00 0.00% 14,480.00 14,480.00 0.00 0.00% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 1,000.00 0.00 1,000.00 100.00% Office Supplies 500.00 917.52 (417.52) -83.50% 2,000.00 2,380.86 (380.86) -19.04% Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Legal Services 5,000.00 4,412.50 587.50 11.75% 20,000.00 10,304.25 9,695.75 48.48% Newsletter/Website 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Assessing Services 2,000,00 7,500.00 (5,500.00) -275.00% 8,000.00 9,500.00 (1,500.00) -18.75% Information Technology 0.00 0.00 0.00 0.00% 0.00 3,201.02 (3,201.02) -100.00°lo Comp upgrades appr by CC Contract Services 0.00 5,000.00 (5,000.00) -100.00% 0.00 20,000.00 (20,000.00) -100.00% Leg Lobbyist appr by CC Software Programs 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 33T06 87.10 249.96 74.16% 1,348.24 363.35 984.89 73.05% Postage 1,500.00 86.77 1,413.23 94.22% 2,000.00 886.17 1,113.83 55.69% Mileage 300.00 67.01 232.99 77.66% 300.00 100.51 199.49 66.50% Legal Publishing 200.00 114.40 85.60 42.80% 900.00 749.17 50.83 6.35% Insurance 0.00 0.00 0.00 0.00% 0.00 24,808.00 (24,808.00) -100.00% Annual ins prem;budgeted in May o Cable Operation Expense 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 50.00 116.55 (66.55) -13310% 200.00 793.82 (593.82) -29691% Dues&Subscriptions 50.00 178.98 (128.98) -257.96% 200.00 205.97 (5.97) •-2.99% Books 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 0.00 1,756.22 (1,756.22) -100.00% 1,185.00 8,535.22 (7,350.22) -620.27% Predictive Index;CC approved Staff Development 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Administration 29,146.70 39,052.52 (9,905.82) -33.99% 113,871.76 156,606.00 (42,734.24) -37.53% Detail 2 MONTH YTD 1410-Elections BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD YTD Commentary PT Salaries 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Office Supplies 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Legal Publications/Notification 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Election Equipment 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Equipment Repair 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% County Election Fees 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 0.00 0.00 0.00 0.00% __ 0.00 940.00 (940.00) -100.00% WA Cty Ann Elect Mach Calibr Total Elections 0.00 0.00 0.00 0.00% 0.00 940.00 (940.00) -100.00% Not budgeted since no election scheduled;had to recalibrate machines for special school election. 1450-Communications FT Salaries 1,030.00 1,545.23 (515.23) -50.02% 4,120.00 5,996.31 (1,876.31) -45.54% PERA Contributions 74.68 112.03 (37.35) -50.01% 298.70 434.73 (136.03) -45.54% FICA Contributions 63.86 92.95 (29.09) - 45.55/ 255.44 360.38 (104.94) _41.08/ Medicare Contributions 14.94 21.74 (6.80) -45.52% 59.74 84.28 (24.54) -41.08% Health/Dental Insurance 240.00 272.00 (32.00) -13.33% 960.00 1,088.00 (128.00) -13.33% Workers Compensation 0.00 0.00 0.00 0.00% 110.00 0.00 110.00 100.00% Newsletter 0.00 3,272.56 (3,272.56) -100.00% 2,000.00 3,830.06 (1,830.06) -91.50% Winter and Spring Newsletters;timing issue Office Supplies 0.00 560.69 (560.69) -100.00% 47.86 560.69 (512.83) -1071.52% Info Technology/Web 3,500.00 9,678.58 (6,178.58) 176.53% 14,000.00 21,222.39 (7,222.39) -51.59% Primarily due to Laserfiche upgrade;approved by CC Telephone 130.00 131.08 (1.08) -0.83% 520.00 282.77 237.23 45.62% Mileage 0.00 0.00 0.00 0.00% 25.00 3696 (11.96) -47.84% Public Notices 300.00 267.80 32.20 10.73% 1,800.00 811.60 988.40 54.91% Cable Operations 300.00 274.38 25.62 8.54% 1,200.00 1,582.18 (382.18) -31.85% Will be reimb by cable comet; Conferences 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% filed quarterly for reimb Repair/Maint Equipment 50.00 0.00 50.00 100.00% 100.00 0.00 100.00 100.00% Total Communications 5,703.48 16,229.04 (10,525.56) -184.55% 25,496.74 36,290.35 (10,793.61) -42.33% 1520-Finance FT Salaries 6,760.00 6,258.12 501.88 7.42% 27,040.00 27,985.92 (945.92) -3.50% Due to PTO payout to accounting clerk PERA Contributions 490.10 453.71 36.39 7.43% 1,960.40 1,908.78 51.62 2.63% FICA Contributions 419.12 366.36 52.76 12.59% 1,676.48 1,564.87 111.61 6.66% Medicare Contributions 98.02 85.69 12.33 12.58% 392.08 365.95 26.13 6.66% Health/Dental Insurance 1,504.00 1,088.00 416.00 27.66% 6,016.00 4,896.00 1,120.00 18.62% Due to contractor cost savings Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 600.00 0.00 600.00 100.00% Office Supplies 25.00 10.72 14.28 57.12% 100.00 119.41 (19.41) -19.41% Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Audit Services 0.00 9,775.00 (9,775.00) -100.00% 9,000.00 9,775.00 (775,00) -8.61% Installment pmt Contract Services 0.00 1,375.01 (1,375.01) -100.00% 3,000.00 3,754.39 (754.39) -25.15% See note above Software Programs 0.00 0.00 0.00 0.00% 150.00 1,874.54 (1,724.54) -1149.69% Upgrades required;appr by CC Telephone 100.00 27.50 72.50 72.50% 400.00 110.00 290.00 72.50% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 50.00 (54.62) 104.62 209.24% 800.00 15.38 784.62 98.08% Dues&Subscriptions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 0.00 190.85 (190.85) -100.00% 225.00 460.85 (235.85) -104.82% Ehlers conf recommended by City Admin Zuleger Total Finance 9,446.24 19,576.34 (10,130.10) -107.24% 51,359.96 52,831.09 (1,471.13) -2.86% Detail 3 MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTDYTD YTD Commentary 1910-Planning&Zoning FT Salaries 12,298.00 11,839.75 458.25 3.73% 49,192.00 47,370.33 1,821.67 3.70% PERA Contributions 891.61 95356 (61.95) -6.95% 3,566.42 3,782.84 (216.42) -6.07% FICA Contributions 762.48 769.74 (7.26) -0.95/0 3,049.90 3,053.84 (3.94) -0.13% Medicare Contributions 178.32 180.02 (1.70) -0.95% 713.28 714.20 (0.92) -0.13% Health/Dentallnsurance 2,678.00 2,678.00 0.00 0.00% 10,712.00 10,712.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 800.00 0.00 800.00 100.00% Office Supplies ies 150.00 00 55.69 94.31 62.87% 600.00 272.09 327.91 54.65% Printed Forms 0.00 46.00 (46.00) -100.00% 250.00 456.00 (206,00) -82.40% Engineering Services 3,000.00 1,776.88 1,223.12 40.77% 12,000,00 9,122.95 2,877.05 23.98% Contract Services 0.00 0.00 0.00 0.00% 2,500.00 0.00 2,500.00 100.00% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 100.00 69.33 30.67 30.67% 400.00 158.49 241.51 60.38% Postage 0.00 0.00 0.00 0.00% 50.00 54.64 (4.64) -9.28% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 50.00 13.92 36.08 72.16% 150.00 39.67 110.33 73.55% Dues&Subscriptions 0.00 104.00 (104.00) -100.00% 0.00 239.00 (239.00) -100.00% Books 100.00 0.00 100.00 100.00% 100.00 0.00 100.00 100.00% Conferences&Training 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Planning&Zoning 20,208.41 18,486.89 1,721.52 8.52% 84,083.60 75,976.05 8,107.55 9.64% 1930-Engineering Services Engineering Services 4,000.00 2,389.81 1,610.19 40.25% 16,000.00 13,844,77 2,155.23 13.47% Total Engineering Services 4,000.00 2,389.81 1,610.19 40.25% 16,000.00 13,844.77 2,155.23 13.47% 1940-City Hall Cleaning Supplies 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Repair Supplies 25.00 0.00 25.00 0.00% 25.00 163.97 (138.97) -555.88% Telephone 200.00 152.03 47.97 23.99% 800.00 451.33 348.67 43.58% Utilities 1,100.00 1,314.41 (214AI) -19.49% 4,400.00 4,567.79 (167.79) -3.81% Refuse 216.64 109.93 106.71 49.26% 541.60 329.79 211.81 39,11% Repairs/Maint Contractual Bldg 600.00 230.00 370.00 61.67% 2,400.00 2,043.29 356.71 14.86% 200.00 419.81 219.81 -109.91% 800.00 1,308.70 (508.70) -63.59% Annex repairs-Yale Mech e irslMaint Contractua l Equip ( ) R a 9 P P Miscellaneous 50.00 8.88 41.12 82.24% 100.00 98.42 1.58_ 1.58% ,391.64 2,235.06 156.58 6.55% 9,066.60 8,963.29 103.31 Total City mall 2 1.14% Total General Government 70,971.47 97,972.85 (27,001.38} -38.05% 312,620 66 349,570.97 (36,950.31) -11.82% Detail 4 DEPT 420-PUBLIC SAFETY MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 2100-Police Month Month Month Month YTD YTD YTD YTD YTD Commentary Law Enforcement Contract 0.00 0.00 0.00 0.00% 0.00 634.22 (634.22) -100.00% Total Police 0.00 0.00 0.00 0.00% 0.00 634.22 (634.22) -100.00% 2150-Prosecution Attorney Criminal 4,250.00 4,737.25 (487.25) -11.46% 17,000.00 13,579.75 3,420.25 20.12% Total Prosecution 4,250.00 4,737.25 (487.25) -11.46% 17,000.00 13,579.75 3,420.25 20.12% 2220-Fire FT Salaries 5,701.46 5,713.07 (11.61) -0.20% 22,905.94 22,828.98 (23.14) -0.10% PT Salaries 7,618.46 6,512.15 1,106.31 14.52% 40,889.84 36,426.58 4,463.26 10.92% PERA Contributions 949.39 1,034.96 (85.57) -9.01% 3,723.22 4,159.56 (436.34) -11.72% FICA Contributions 825.84 356.10 469.74 56.88% 3,949.13 2,047.26 1.901.87 48.16% Medicare Contribut ions ions 19 3.14 14 171.07 22.07 11.43% 923.59 831.06 92.53 10.02% Health/Dental Insurance 1,230.00 1,142.00 88.00 7.15% 4,920.00 4,568.00 352.00 7.15% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 9,000.00 0.00 9,000.00 100.00% Office Supplies 50.00 436.32 (386.32) -772.64% 100.00 705,06 (605,06) -605.06% EMS Supplies 0.00 4.00 (4.00) -100.00% 400.00 228.37 171.63 42.91% Returned some EMS gear Fire Prevention 250.00 0.00 250.00 100.00% 1,000.00 0.00 1,000.00 100.00% Fuel,Oil&Fluids 1,200.00 932.70 267.30 22.28% 4,800.00 3,641.38 1,158.62 24.14% Small Tools&Equip 1,900.00 822.38 1,077.62 '56.72% 7,600.00 7,819.05 (219.05) -2.88% YTD includes Themal Imaging camera from Jan Physicals 575.00 358.00 217.00 37.74% 2,300.00 358.00 1,942.00 84.43% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 350.00 653.53 (303.53) -86.72% 1,400.00 1,774.85 (374.85) -26.78% Radio 3,800,76 82.00 3,718.76 97.84% 4,800.76 4,279,11 521.65 10.87% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Vehicle Insurance 0.00 0.00 0.00 0.00% 0.00 4,266.00 (4,266.00) -100.00% Annual ins prem;budgeted in May Electric Utility 1,800,00 2,002.70 (202.70) -11.26% 7,200.00 6,491.27 708.73 9.84% Refuse 4T68 48.38 (0.70) -1.47% 190.72 145.14 45.58 23.90% Repair/Maint Bldg 1,000,00 857.05 142.95 14.30% 4,000.00 3,325.49 674.51 16.86% Repair/Maint Equip 3,400.00 6,065.03 (2,665.03) -78.38% 13,600.00 14,569.19 (969.19) -7.13% Uniforms 250.00 14.85 235.15 94.06% 1,000.00 14.85 985.15 98.52% Miscellaneous 100.00 195.22 (95.22) -95,22% 400,00 936.68 (536.68) -134.17% Dues&Subscriptions 0.00 0.00 0.00 0.00% 2,200.00 2,235.00 (35.00) -1.59% Books 50.00 0.00 50.00 0.00% 100.00 102.00 (2.00) -2.00% Conferences&Training 500.00 2,353.60 (1,853.60) -370.72% 2,000.00 2,753.60 (753.60) -37.68% Conferences&Training(Reimb) 0,00 0.00 0.00 0.00% 0.00 (I 86.38) 186.38 100.00% To better track training reimb Total Fite 31,791.73 29,755.11 2,036.62 6.41% 139,303.10 124,320.10 14,983.00 10.76% 2250-Fire Relief Fire State Aid 0,00 0.00 0.00 0.00% 0.00 0 00 0.00 0.00% Total Fire Belief 0.00 0<00 0.00 0.00% 0.00 0.00 0.00 0.00% Detail 5 MONTH YTD 2400-Building Inspection BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD YTD Commentary FT Salaries 7,384.00 6,892.91 491.09 6.65% 29,536.00 27,163.95 2,372.05 8.03% PERA Contributions 535.34 499.71 35.63 6.66% 2,141.36 1,969.37 171.99 8.03% 0 FICA Contributions 457.81 401.64 56.17 12.27% 1,831.23 1,581.89 249.34 13.62/0 0 ° Medicare Contributions 107.07 93.92 13.15 12.28/o 428.27 369.94 58.33 13.62/o 01,616.00 22.22% Health/Dental Insurance 1,818.00 1,414.00 404.00 22.22/o 7 272.00 5 656.00 Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation (87.12) 0.00 (87.12) -100.00% 397.88 0.00 397.88 100.00% Office Supplies 420.02 23.70 396.32 94.36% 613.80 83.76 530.04 86.35% 0 0 4 Printed Forms 1146.6161 0.00 146.61 100.00% 61 0 I 6. . 0 146.61 100.00% Fuel,Oil&Fluids 0.00 51.66 (51.66) -100.00% 54.68 51.66 3.02 5.52% Engineering 750.00 579.05 170.95 22.79% 3,000.00 2,058.05 941.95 31.40% Surcharge Pmts 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Inspector Contract Services 0.00 0.00 0.00 0.00% 0.00 270.00 (270,00) -100.00% Information Technology 0.00 14,587.16 (14,587.16) -100.00% 0.00 14,587.16 (14,587.16) -100.00% Software Programs 645.00 0.00 645.00 100.00% 5,061.50 0.00 5,061.50 100.00% Telephone 45.66 106.35 (60.69) -132.92% 182.64 234.77 (52.13) -28.54% Mileage 50.00 0.00 50.00 100.00% 200.00 74.58 125.42 62.71% Insurance 0.00 0.00 0.00 0.00% 0,00 248.00 (248.00) -100.00% Repairs/Maint Equip 0.00 0.00 0.00 0.00% 0.00 213.28 (213,28) -100.00% Uniforms 0.00 0.00 0.00 0.00% 86.38 121.98 (35.60) -41.21% Miscellaneous 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 0.00 95.00 (95.00) -100.00% 0.00 220.00 (220,00) -100.00% Books 101.28 249.94 (148.66) -146.78% 101.28 24994 (148.66) 0.00% Conferences&Training 95.00 220.00 (125.00) -131.58% 375.00 420.00 (45.00) -12.00% Erosion control conf Total Building Inspections 12,468.67 25,215.04 (12,746.37) -102.23% 51,428.63 55,574.33 (4,145.70) -8.06% 2500-Emergency Communications Contract Services 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Emergency Communications 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% 2700-Animal Control Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Contract Services 500.00 500.00 0.00 0.00% 1,500.00 1,500.00 0.00 0.00% Miscellaneous 210.00 195.00 15.00 -100.00% 240.00 360.00 (120.00) -50.00% Total Animal Control 710.00 695.00 15.00 2.11% 1,740.00 1,860.00 (120.00) -6.90% Total Public Safety 49,220.40 60,402.40 (11,182.00) -22.72% 209,471.73 195,968.40 13,503.33 6.45% Detail 6 DEPT 430-PUBLIC WORKS MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 3100-Public Forks Month Month Month Month YTD YTD YTD YTD YTD Commentary FT Salaries 13,736.00 12,152.72 1,583.28 11.53% 54,944.00 56,021.70 (1,077.70) -1.96% PT Salaries 0.00 400.33 (400.33) -100.00% 0.00 4,687.59 (4,687.59) -100.00% Extra staff for snow removal PERA Contributions 995.86 910.10 85.76 8.61% 3,983.44 4,399.14 (415,70) -10.44% FICA Contributions 851.63 734.80 116.83 13.72% 3,406.53 3,591.22 (184.69) -5.42% Medicare Contributions 199.17 171.87 27.30 13.71% 796.69 839.87 (43.18) -5.42% Health/Dental Insurance 3,280.00 2,899.00 381.00 11.62% 13,120.00 11,596.00 1,524.00 11.62% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 8,000.00 0.00 8,000.00 100.00% Office Supplies 25.00 237.71 (212.71) -850.84% 100.00 1,178.96 (1,078.96) -1078.96% Shop Materials 50.00 459.56 (409.56) -819.12% 200.00 979.75 (779.75) -389.88% Building Repair Supplies 25.00 0.00 25.00 100.00% 100.00 0.00 100.00 100.00% Small Tools and Minor Equip 200.00 23.52 176.48 88.24% 800.00 391.62 408.38 51.05% Engineering Services 750.00 1,761.25 (1,011.25) -134.83% 3,000.00 3,679.00 (679.00) -22.63% Contract Services 100.00 39.25 60.75 60.75% 400.00 132.25 267.75 66.94% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 638.43 617.84 20.59 3.23% 2,553.72 2,330.54 223.18 8.74% Radio 1,500.00 0.00 1,500.00 100.00% 1,500.00 919.88 580.12 38.67% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 0.00 0.00 0.00 0.00% 0.00 16,085.00 (16,085.00) -100.00% Annual ins prem.-budgeted in May Electric Utility 2,000.00 4,181.30 (2,181.30) -109.07% 8,000.00 11,233.72 (3,233.72) -40.42% Refuse 207.82 210.94 (3.12) -1.50% 831.28 632.82 198.46 23.87% Fuel,Oil,Fluids(ALL depts) 4,000.00 2,627.08 1,372.92 34.32% 16,000.00 20,835.53 (4,835.53) -30.22% Repair/Maint Bldg 100.00 302.58 (202.58) -202.58% 400.00 1,607.40 (1,207.40) -301.85% Repair/Maint NOT Bldg 50.00 0.00 50.00 100.00% 200.00 448.00 (248.00) -124.00% Repair/Maint Equip(out) 300.00 0.00 300.00 100.00% 1,200.00 0.00 1,200.00 100.00% Equipment Parts 0.00 75.36 (75.36) -100.00% 0.00 154.20 (154.20) -100.00% Uniforms 100.00 272.88 (172.88) -172.88% 400.00 498.69 (98.69) -24.67% Miscellaneous 50.00 0.00 50.00 100.00% 200.00 294.40 (94.40) -47.20% Landscaping Material 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 50.00 0.00 50.00 100.00% 100.00 185.00 (85.00) -85.00% Conferences&Training 0.00 0.00 0.00 0.00% 500.00 0.00 500.00 100.00% Clean up Days 0.00 0.00 0.00 0.00% 0.00 500.00 (500.00) -100.00% Total Public Works 29,208.91 28,078.09 1,130.82 3.87% 120,735.66 143,222.28 (22,486.62) -18.6206 3120-Streets Equipment Parts 100.00 64.95 35.05 35.05% 400.00 865.17 (465.17) -116.29% Street Maintenance Materials 1,000.00 5.42 994.58 99.46% 4,000.00 3,771.76 228.24 5.71% Sign Repair Materials 0.00 0.00 0.00 0.00% 0.00 968.60 (968.60) -100.00% Contract Services 0.00 75.00 (75.00) -100.00% 300.00 775.93 (475.93) -158.64% Repairs/Maint Equipment 200.00 78.25 121.75 60.88% 800.00 78.25 721.75 90.22% Total Streets 1,300.00 223.62 1,076.38 82.80% 5,500.00 6,459.71 (959.71) -17.45% Deta i 17 MONTH YTD 3125-Ice c&Snow Removal BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD YTD Commentary Landscaping Material 0.00 11.09 (11.09) 100.00% 0.00 11.09 (11.09) 100.00% Sand/Salt 0.00 0.00 0.00 0.00% 55,000.00 45,416.16 9,583.84 17.43% Contract Services 0.00 747.50 (747.50) -100.00% 4,500.00 9,660.00 (5,160.00) -114.67% Repairs/Maint Equipment 500.00 321.75 178.25 35.65% 2,000.00 2,254.24 (254.24) -12.71% Total Yee&Snow Removal 500.00 1,080.34 (580.34) -11G.07% 61,500.00 57,341.49 4,158.51 6.76% 3160-Street Lighting Street Lighting 2,400.00 2,125.80 274.20 11.43% 9,600.00 6,461.89 3,138.11 32.69% Total Street Lighting 2,400.00 2,125.80 274.20 11.43% 9,600.00 6,461.89 3,138.11 32.69% 3200-Recycling Recycling Supplies 0.00 2,132.45 (2,132.45) -100.00% 0.00 2,132.45 (2,132.45) -100.00% Newsletter 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 0.00 0.00 0.00 0.00% 0.00 1,541.01 (1,541.01) -100.00% CFL bulbs for residents Total Recycling 0.00 2,132.45 (2,132.45) -100.00% 0.00 3,673.46 (3,673.46) -100.00% 3250-Tree Program Contract Services 0.00 950.00 (950.00) -100.00% 3,750.00 950.00 2,800.00 74.67% Total Tree Program 0.00 950.00 (950.00) -100.00% 3,750.00 950.00 2,800.00 74.67% Total Public Forks 33,408.91 34,590.30 (1,181.39) -3.54% 201,085.66 218,108.83 (17,023.17) -8.47% Detail 8 DEPT 450-CULTURE,RECREATION MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 5200-Parks&Recreation Month Month Month Month YTD YTD YTD YTD YTD Commentary FT Salaries 11,150.00 8,219.39 2,930.61 26.28% 41,600.00 35,331.19 6,268.81 15.07% PT Salaries 0.00 0.00 0.00 0.00% 0.00 1,406.30 (1,406.30) -100.00% Extra part time help PERA Contributions 808.38 595.88 212.50 26.29% 3,016.00 2,650.67 365.33 12.11% FICA Contributions 691.30 487.57 203.73 29.47% 2,579.20 2,190.34 388.86 15.08% Medicare Contributions 161.68 114.00 47.68 29.49% 603.20 512.24 90.96 15.08% Health/Dental Insurance 1,108.00 290.16 817.84 73.81% 4,432.00 1,160.64 3,271.36 73.81% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 0.00 0.00 0.00 0.00% 4,500.00 0.00 4,500.00 100.00% Shop Materials 0.00 24.99 (24.99) -100.00% 0.00 24.99 (24.99) -100.00% Chemicals 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Equipment Parts 0.00 2,532.94 (2,532.94) -100.00% 23.50 2,559.96 (2,536,46) -10793.45% 480D radiator repair/service Building Repair Supplies 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Landscaping Materials 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Small Tools and Minor Equip 39.87 554.14 (514.27) -1289.87% 1,609.01 554.14 1,054.87 65.56% Telephone 180.86 180.73 0.13 0.07% 331.49 350.80 (19.31) -5.83% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 0.00 0.00 0.00 0.00% 0.00 3,171.00 (3,171.00) -100.00% Annual ins prem;budgeted in May Electric Utility 919.64 725.71 193.93 21.09% 3,086.32 2,669.87 416.45 13.49% Refuse 207.82 210.94 (3.12) -1.50% 623.46 632.82 (9.36) -1.50% Repair/Maint Bldg 246.25 0.00 246.25 100.00% 246.25 27.64 218.61 88.78% Repair/Maint NOT Bldg 27.25 1,116.17 (1,088.92) -3996.04% 27.25 1,770.11 (1,742.86) -6395.82% Light repairs at Lions field,trail grooming at Sunfish Lake Park Repair/Maint Equip 0.00 16.15 (16.15) -100.00% 0.00 2,194.35 (2,194.35) -100.00% Unforeseen repairs on 98 GMC Rental Buildings 300.00 32.84 267.16 89.05% 1,200.00 32.84 1,167.16 97.26% Miscellaneous 50.00 0.00 50.00 100.00% 350.00 649.75 (299.75) -85.64% Total Parks&Recreation 15,891.05 15,101.61 789.44 4.97% 64,227.68 57,889.65 6,338.03 9.87% 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 169,491.83 208,067.16 (38,575.33) -22.76% 787,405.73 821,537.85 (34,132.12) -4.33% Net Income over Expenses (96,709.85) =(189,149.13) (92,439.28} -95.58% (581,331.50) (664,928.29) (83,596.79) -14.38% Detail 9