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 - May Financials
City of Lake Elmo 6/17/2014 2014 By Month Budget to Actual Comparative For the month ending May 31 2014 101-General Fund Summary By Department 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 43,270.85 94,844.54 51,573.69 119.19% 249,345.08 251,454.90 2,109.82 0.85% EXPENSE Total:Mayor&Council 17,299.66 13,827.66 3,472.00 20.07% 30,041.66 17,947.08 12,094.58 40.26% Total Administration 73,655.35 39,787.67 33,867.68 45.98% 187,527.11 196,393.67 (8,866.56) -4.73% Total Elections 350.00 0.00 350.00 100.00% 350.00 940.00 (590.00) -168.57% Total Communications 6,421.75 6,932.83 (511.08) -7.96% 31,918.50 43,223.18 (11,304.68) -35.42% Total Finance 23,081.83 13,522.11 9,559.75 41.42% 74,441.82 66,353.20 8,088.62 10.87% Total Planning&Zoning 28,512.60 27,136.76 1,375.84 4.83% 112,596.22 103,112.81 9,483.41 8.42% Total Engineering Services 4,000.00 3,542.38 457.62 11.44% 20,000.00 17,387.15 2,612.85 13.06% Total City hall 2,233.32 1,815.49 417.83 18.71% 11,299.92 10,778.78 521.14 4.61% Total General Government 155,554.51 106,564.90 48,989.64 31.49% 468,175.23 456,135.87 12,039.36 2.57% 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,581.50 (331.50) -7.80% 21,250.00 18,161.25 3,088.75 14.54% Total Fire 41,429.15 24,823.71 16,605.44 40.08% 180,732.32 149,143.81 31,588.51 17.48% Total Fire Relief 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Building Inspections 17,255.94 14,177.80 3,078.14 17.84% 68,684.57 69,752.13 (1,067.56) -1.55% Total Emergency Communications 0.00 3,745.00 (3,745.00) -100.00% 0.00 3,373.08 (3,373.08) -100.00% Total animal Control 842.08 464.00 378.08 44.90% 2,582.08 2,324.00 258.08 10.00% Total Public Safety b3,777.17 47,792.01 15,985.16 25.06% 273,248.97 243,388.49 29,860.48 10.93% Summary_1 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 57,190.25 34,275.48 22,914.77 40.07% 177,925.91 177,497.76 428.15 0.24% Total Streets 1,600.00 1,418.06 181.94 11.37% 7,100.00 7,877.77 (777.77) -10.95% Total Ice&Snow Removal 500.00 0.00 500.00 100.00% 62,000.00 57,341.49 4,658.51 7.51% Total Street Lighting 2,400.00 2,060.27 339.73 14.16% 12,000.00 8,522.16 3,477.84 28.98% Total Recycling 3,400.00 1,158.40 2,241.60 65.93% 3,400.00 4,831.86 (1,431.86) -42.11% Total Tree Program 0.00 0.00 0.00 0.00% 3,750.00 950.00 2,800.00 74.67% Total Public Works 65,090.25 38,912.21 26,178.04 40.22% 266,175.91 257,021.04 9,154.87 3.44% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 25,767.99 22,083.85 3,684.14 14.30% 89,995.67 79,973.50 10,022.17 11.14% 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 310,189.92 2I5,352.97 94,836.98 30.57% 1,097,599. 8 —1,036,518.90 61,076.88 5.56% Net Income over Expenses (266,919.07) (120,508.43) 146,410.64 54.85% (848,250.70) (785,064.00) 63,186. 0 —7.450/. Summary_2 City of Lake Elmo 6I17/2014 2014 By Month Budget to Actual Comparative For the month ending May 31.2014 101-General Fund Detail 131 Department MONTI YTD DEFT 410-GEN'L GOV'T BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD YTD variance notes 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,500.00 0.00 (2,500.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 200.00 610.00 410.00 205.00% 3,150.00 2,210.00 (940.00) -29.84% Blacktopping Contractor License 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Permits 10,000.00 15,235.00 5,235.00 52.35% 58,000.00 63,424.05 5,424.05 9.35% March was very busy;4 new home starts Heating Permits 2,000.00 2,395.00 395.00 19.75% 6,500.00 6.435.00 (65.00) -1.00% Plumbing Permits 1,500.00 720.00 (780.00) -52.00% 5,500.00 5,345.00 (155.00) -2.82% Sewer Permits 0.00 0.00 0.00 0.00% 485.00 0.00 (485.00) -100.00% Animal License 80.00 120.00 40.00 50.00% 1,341.00 2,058.50 717.50 53.50% Utility Permits(ROW) 1,250.00 3,520.00 2,270.00 181.60% 3,000.00 7,912.80 4,912.80 163.76% Due to 1-94 expansion Burning Permit 500.00 180.00 (320.00) -64.00% 1,600.00 780.00 (820.00) -51.25% Massage Therapy Licenses 150.00 0.00 (150.00) -100.00% 150.00 (38.50) (188.50) -100.00% Permit refund Electrical Permit 0.00 424.55 424.55 100.00% 0.00 1,010.88 1,010.88 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% 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% Budgeted based on funds rec'd in 2013 for the fire relief assn Gravel Tax 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Recycling Grant 15,500.00 0.00 (15,500.00) -100.00% 15,500.00 0.00 (15,500.00) -100.00% Misc State Grant/Surcharge Rev 0.00 4,064.00 4,064.00 100.00% 50,161.00 55,018.68 4,857.68 9.68% DNR trail grooming funds of�4k Cable Franchise Revenue 0.00 39,323.71 39,323.71 100.00% 39,851.98 39,323.71 (528.27) -1.33% Cable franchise revenue received May lst 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 13,098.44 6,098.44 87.12% 35,000.00 38,621.69 3,621.69 10.35% Sale of Copies,Books,Maps 95.85 24.50 (71.35) -74.44% 206.10 161.25 (44.85) -21.76% Assessment Searches 195.00 105.00 (90.00) -46.15% 585.00 285.00 (300.00) -51.28% Clean Up Days 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Cable Operation Reimbursement 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Fines 4,000.00 4,612.34 612.34 15.31% 20,500.00 16,417.71 (4,082.29) -19.91% Miscellaneous Revenue 200.00 350.00 150.00 75.00% 1.000.00 1,139.13 139.13 13.91% CUP permits Internal Charges 100.00 62.00 (38.00) -38.00% 900.00 510.00 (390.00) -43.33% 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 10,000.00 10,000.00 100.00% 0.00 10.000.00 10,000.00 100.00% Donation from LE Jaycees Total Revenue 43,270.85 94,844.54 51,573.69 99.19% � 249,345.08 251,454 90' _ 1109.82'' 0.85°f Detail-1 MONTH YTD EXPENSE BUDGET ACTUAL Variance($} Variance(%) BUDGET ACTUAL Variance($} Variance(%) 1110-Mayor&Council Month Month Month Month YTD YTD YTD YTD PT Salaries 12,845.00 12,845.00 0.00 0.00% 12,845.00 12,845.00 0.00 0.00% FICA Contributions 796.39 796.39 0.00 0.00% 796.39 796.39 0.00 0.00% Medicare Contributions 186.27 186.27 0.00 0.00% 186.27 186.27 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% 150.00 0.00 150.00 100.00% Miscellaneous 0.00 0.00 0.00 0.00% 5,000.00 722.42 4,277.58 85.55% Dues&Subscriptions 3,397.00 0.00 3,397.00 100.00% 10,514.00 3,397.00 7,117.00 67.69% Includes Memberships Conferences&Training 0.00 0.00 0.00 0.00% 250.00 0.00 250.00 100.00% Total Mayor&Council 17,299.66 13,827.66 3,472.00 20.07% 30,041.66 17,947.08 12,094.58 40.26% 1320-Administration FT Salaries 20,352.00 19,907.19 444.81 2.19% 74,624.00 72,574.25 2,049.75 2.75% PERA Contributions 1,334.11 1,443.27 (109.16) -8.18% 5,268.83 5,259.94 8.89 0.17% ICMA Contributions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 1,095.88 1,169.28 (73.40) -6.70% 4,460.74 4,260.33 200.41 4.49% Medicare Contributions 256.30 273.46 (17.16) -6.70% 1,043.24 996.34 46.90 4.50% Health/Dental Insurance 5,430.00 3,620.00 1,810.00 33.33% 19,910.00 18,100.00 1,810.00 9.09% 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 652.66 (152.66) -30.53% 2,500.00 3,033.52 (533.52) 21.34% Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Legal Services 5,000.00 4,977.50 22.50 0.45% 25,000.00 15,281.75 9,718.25 38.87% Newsletter/W eb site 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Assessing Services 3,500.00 0.00 3,500.00 100.00% 11,500.00 9,500.00 2,000.00 17.39% Information Technology 0.00 0.00 0.00 0.00% 0.00 3,201.02 (3,201.02) -100.00% Comp upgrades appr by CC Contract Services 0.00 5,000.00 (5,000.00) -100.00% 0.00 25,000.00 (25,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 337.06 117.00 220.06 65.29% 1,685.30 480.35 1,20495 71.50% Postage 0.00 0.00 0.00 0.00% 2,000.00 886.17 1,113.83 55.69% Mileage 300.00 0.00 300.00 100.00% 600.00 100.51 499.49 83.25% Legal Publishing 200.00 2,399.30 (2,199.30) -1099.65% 1,000.00 3,148.47 (2,148.47) -214.85% Due to notice increases due to development activities Insurance 35,000.00 0.00 35,000.00 100.00% 35,000.00 24,808.00 10,192.00 29.12% 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% Miscellaneous 50.00 88.74 (38.74) -77.48% 250.00 882.56 (632.56) -253.02% Dues&Subscriptions 50.00 2699 23.01 46.02% 250.00 232.96 17.04 6.82% Books 0.00 42.28 (42.28) -100.00% 0.00 42.28 (42.28) -100.00% Conferences&Training 250.00 70.00 180.00 72.00% 1,435.00 8,605.22 (7,170.22) -499.67% Predictive Index;CC approved Staff Development 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Administration 73,655.35 39,787.67 33,867.68 45.98% 187,527.11 196,393.67 (8,866.56) -4.73% Detail 2 MONTH YTD 1410-Elections BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD 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 350.00 0.00 350.00 100.00% 350.00 0.00 350.00 100.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 350.00 0.00 350.00 100.00% 350.00 940.00 (590.00) -168.57%° Not budgeted since no election scheduled;had to recalibrate machines for special school election. 1450-Communications FT Salaries 1,545.00 2,317.85 (772.85) -50.02% 5,665.00 8,314.16 (2,649.16) -46.76% PERA Contributions 112.01 168.02 (56.01) -50.00% 410.71 602.75 (192.04) -46.76% FICA Contributions 95.79 139.45 (43.66) -45.58% 351.23 499.83 (148.60) -42.31% Medicare Contributions 22.40 32.62 (10.22) -45.63% 82.14 116.90 (34.76) -42.32% I-lealth/DentalInsurance 360.00 272.00 88.00 24.44% 1,320.00 1,360.00 (40.00) -3.03% Workers Compensation 0.00 0.00 0.00 0.00% 110.00 0.00 110.00 100.00% Newsletter 0.00 0.00 0.00 0.00% 2,000.00 3,830.06 (1,830.06) -91.50% Due to timing of newsletters Office Supplies 56.55 0.00 56.55 100.00% 104.42 560.69 (456.27) -43696% Info Technology/Web 3,500.00 2,635.58 864.42 24.70% 17,500.00 23,857.97 (6,357.97) -36.33% Primarily due to Laserfiche upgrade approved by CC Telephone 130.00 62.13 67.87 52.21% 650.00 344.90 305.10 46.94% Mileage 0.00 0.00 0.00 0.00% 25.00 3696 (11.96) -47.84% Public Notices 300.00 820.80 (520.80) -173.60% 2,100.00 1,632.40 467.60 22.27% Cable Operations 300.00 384.38 (84.38) -28.13% 1,500.00 1,966.56 (466.56) -31.10% Will be reimb by cable comm; Conferences 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% filed quarterly for reimb Repair/Maint Equipment 0.00 100.00 (100.00) -100.00% 100.00 100.00 0.00 0.00% Total Communications 6,421.75 6,932.83 (511.01 -7.96% 31,918.50 43,223.18 (11,304.68) -35.42% 1520-Finance FT Salaries 10,140.00 9,387.17 752.83 7.42% 37,180.00 37,373.09 (193.09) -0.52% Due to PTO payout to accounting clerk PERA Contributions 735.15 680.57 54.58 7.42% 2,695.55 2,589.35 106.20 394% FICA Contributions 628.68 549.53 79.15 12.59% 2,305.16 2,114.40 190.76 8.28% Medicare Contributions 147.03 128.51 18.52 12.60% 539.11 494.46 44.65 8.28% Health/Dental Insurance 2,256.00 1,088.00 1,168.00 51.77% 8,272.00 5,984.00 2,288.00 27.66% Due to contractor cost savings Unemployment Benefits 0.00 456.86 (456.86) -100.00% 0.00 456.86 (456.86) -100.00% Workers Compensation 0.00 0.00 0.00 0.00% 600.00 0.00 600.00 100.00% Office Supplies 25.00 36.16 (11.16) -44.64% 125.00 155.57 (30.57) -24.46% Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Audit Services 9,000.00 0.00 9,000.00 100.00% 18,000.00 9,775.00 8,225.00 45.69% Installment pmt Contract Services 0.00 1,167.81 (1,167.81) -100.00% 3,000.00 4,922.20 (1,922.20) -64.07% See note above Software Programs 0.00 {1.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% 500.00 137.50 362.50 72.50% Mileage 50.00 0.00 50.00 100.00% 50.00 0.00 50.00 100.00% Miscellaneous 0.00 0.00 0.00 0.00% 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 0.00 0.00 0.00% 225.00 460.85 (235.85) -104.82% Ehlers conf recommended by City Admin Zuleger 66,353.20 8,088.62 10.87% Detail 3 Total Finance 23,081.86 13,522.11 9,559.75 41.42% 74,441.82 MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD 1910-Planning&Zoning FT Salaries 18,447.00 19,542.16 (1,095.16) -5.94% 67,639.00 66,912.49 726.51 1.07% PERA Contributions 1,337.41 1,430.34 (92.93) -6.95% 4,903.83 5,213.18 (309.35) -6.31% FICA Contributions 1,143.71 1.174.45 (30.74) -2.69% 4,193.62 4,228.29 (34.67) -0.83% Medicare Contributions 267.48 274.67 (7.19) -2.69% 980.77 988.87 (8.10) -0.83% Health/DentalInsurance 4,017.00 2,678.00 1,339.00 33.33% 14,729.00 13,390.00 1,339.00 9.09% Workers Compensation 0.00 0.00 0.00 0.00% 800.00 0.00 800.00 100.00% Office Supplies 150.00 378.24 (228.24) -152.16% 750.00 650.33 99.67 13.29% Printed Forms 0.00 0.00 0.00 0.00% 250.00 456.00 (206.00) -82.40% Engineering Services 3,000.00 1,607.13 1,392.87 46.43% 15,000.00 10,730.08 4,269.92 28.47% 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 51.02 48.98 48.98% 500.00 209.51 290.49 58.10% 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 0.75 49.25 98.50% 200.00 40.42 159.58 79.79% Dues&Subscriptions 0.00 0.00 0.00 0.00% 0.00 239.00 (239.00) -100.00% Books 0.00 0.00 0.00 0.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 28,512.60 27,136.76 1,375.84 4.83% 112,596.22 103,112.81 9,483.41 8.42% 1930-Engineering Services Engineering Services 4,000.00 3,542.38 457.62 11.44% 20.000.00 17,387.15 2,612.85 13.06% Total Engineering Services 4,000.00 3,542.38 457.62 11.44% 20,000.00 17,387.15 2,612.85 13.06% 1940-City Hall Cleaning Supplies 25.00 0.00 25.00 100.00% 25.00 0.00 25.00 100.00% Building Repair Supplies 0.00 0.00 0.00 0.00% 25.00 163.97 (138.97) -555.88% Telephone 200.00 73.90 126.10 63.05% L000.00 525.23 474.77 47.48% Utilities 1,100.00 836.01 263.99 24.00% 5,500.00 5,403.80 96.20 1.75% Refuse 108.32 109.93 (1.61) -1.49% 649.92 439.72 210.20 32.34% Repairs/Maint Contractual Bldg 600.00 230.00 370.00 61.67% 3,000.00 2,273.29 726.71 24.22% Repairs/Maint Contractual Equip 200.00 532.87 (332.87) -166.44% 1,000.00 1,841.57 (841.57) -84.16% Annex repairs-Yale Mech Miscellaneous 0.00 32.78 (32.78) -100.00% 100.00 131.20 (31.20) -31.20% Total City Hall 2,233.32 1,815.49 417.83 18.71% 11,299.92 10,778.78 521.14 4.61% Total General Government 155,554.54 fl06,564.90 48,989.64 31.49% 468,175.23 456,135.87 12,039.36 2.57% 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 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,581.50 (331.50) -7.80% 21,250.00 18,161.25 3,088.75 14.54% Total Prosecution 4,250.00 4,581.50 (331.50) -7.80% 21,250.00 18,161.25 3,088.75 14.54% 2220-Fire FT Salaries 8,552.22 8,569.43 (17.21) -0.20% 31,358.06 31,398.41 (40.35) -0.13% PT Salaries 11,427.69 10,537.37 890.32 7.79% 52,317.53 46,963.95 5,353.58 10.23% PERA Contributions 1,416.10 1,513.25 (97.15) -6.86% 5,139.38 5,672.81 (533.43) -10,38% Due to FF rate change effective 1/1/2014 FICA Contributions 1,238.75 589.16 649.59 52.44% 5,187.89 2,636.42 2,551.47 49.18% FF budgeted at normal 6.2%;Full time fire FF rate is zero Medicare o d care Contributions 289.71 265.73 23.98 8.28/0 1,213.30 1,096.79 116.51 9.60% Health/Dental Insurance 1,845.00 1,142.00 703.00 38.10% 6,765.00 5,710.00 1,055.00 15.59% 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 8.96 41.04 82.08% 150.00 714.02 (564.02) -376.01% EMS Supplies 0.00 0.00 0.00 0.00% 400.00 228.37 171.63 42.91% Fire Prevention 250.00 0.00 250.00 100.00% 1.250.00 0.00 1,250.00 100.00% Fuel,Oil&Fluids 1,200.00 1,475.16 (275.16) -22.93% 6,000.00 5,116.54 883.46 14.72% Small Tools&Equip 1,900.00 (38.87) 1,938.87 102.05% 9,500.00 7,780.18 1,719.82 18.10% YTD includes Themal Imaging camera from Jan Physicals 575.00 358.00 21700 37.74/ 2,875.00 716.00 2,159.00 75.10% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 350.00 379.20 (29.20) -8.34% 1,750.00 2,154.05 (404.05) -23.09% Radio 0.00 82.00 (82.00) -100.00% 4,800.76 4,361.11 439.65 9.16% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Vehicle Insurance 5,237.00 0.00 5,237.00 100.00% 5,237.00 4,266.00 971.00 18.54% Annual ins prem;budgeted in May Electric Utility 1,800.00 887.08 912.92 50.72% 9,000.00 7,378.35 1,621.65 18.02% Refuse 47.68 48.38 (0.70) -1.47% 238.40 193.52 44.88 18.83% Repair/Maine Bldg 1,000.00 143.62 856.38 85.64% 5,000.00 3,469.11 1,530.89 30.62% Repair/MaintEquip 3,400.00 (420.06) 3,820.06 112.35% 17,000.00 14,149.13 2,850.87 16.77% Uniforms 250.00 116.50 133.50 53.40% 1,250.00 131.35 1,118.65 89.49% Miscellaneous 100.00 181.80 (81.80) -81.80% 500.00 1,118.48 (618.48) -123.70% Dues&Subscriptions 0.00 0.00 0.00 0.00% 2,200.00 2,235.00 (35.00) -1.59% Books °0o cs ° 0.00 0.00 0.00 0.00/0 100.00 102.00 (2.00} -2.00/° Conferences&Training 500.00 825.00 (325.00) -65.00% 2,500.00 3,578.60 (1,078.60) 43.14% Conferences&Training(Reimb) 0.00 (1,840.00) 1,840.00 100.00% 0.00 (2,026.38) 2,026.38 100.00% Reimb segregated out for better tracking Total Fire 41,429.15 24,823.71 16,605.44 40.08% 180,732.32 149,143.81 31,588.51 17.48% 2250-Fire Relief Fire State Aid 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Fire Relief 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 FT Salaries 11,076.00 10,339.38 736.62 6.65% 40,612.00 37,503.33 3,108.67 7.65% PERA Contributions 803.01 749.58 53.43 6.65% 2,944.37 2,718.95 225.42 7.66% FICA Contributions 686.71 602.46 84.25 12.27% 2,517.94 2,184.35 333.59 13.25% Medicare Contributions 160.60 140.88 19.72 12.28% 588.87 510.82 78.05 13.25% Health/Dental Insurance 2,727.00 1,414.00 1,313.00 48.15% 9,999.00 7,070.00 2,929.00 29.29% 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% 397.88 0.00 397.88 100.000/0 Office Supplies 133.64 11.04 122.60 91.74% 747.44 94.80 652.64 87.32% Printed Forms 0.00 0.00 0.00 0.00% 146.61 0.00 146.61 100.00% Fuel,Oil&Fluids 51.36 5T76 (6.40) -100.00% 106.04 109.42 (3.38) -3.19% Engineering 750.00 605.00 145.00 19.33% 3,750.00 2,663.05 1,086.95 28.99% Surcharge Pints 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 0.00 0.00 0.00% 0.00 14,587.16 (14,587.16) -100.00% Software Programs 0.00 0.00 0.00 0.00% 5,061.50 0.00 5,061.50 100.00% Telephone 45.66 51.93 (6.27) -13.73% 228.30 286.70 (58.40) -25.58% Mileage 50.00 0.00 50.00 100.00% 250.00 74.58 175.42 70.17% Insurance 340.00 0.00 340.00 100.00% 340.00 248.00 92.00 27.06% Repairs/Maint Equip 0.00 0.00 0.00 0.00% 0.00 213.28 (213.28) -100.00% Uniforrns 0.00 0.00 0.00 0.00% 86.38 121.98 (35.60) -41.21% Miscellaneous 300.00 0.00 300.00 100.00% 300.00 0.00 300.00 100.00% Dues&Subscriptions 0.00 0.00 0.00 0.00% 0.00 220.00 (220.00) -100.00% Books 6.96 96.77 (89.81) -1290.37% 108.24 346.71 (238.47) -220.32% Conferences&Training 125.00 109.00 16.00 12.80% 500.00 529.00 (29.00) -5.80% Erosion control conf Total Building Inspections 17,255.94 14,177.80 3,078.14 17.84% 68,684.57 69,752.13 (1,067.56) -1.55% 2500-Emergency Communications Contract Services 0.00 3,745.00 (3,745.00) -100.00% 0.00 3,373.08 (3,373.08) -100.00% Budget vs actual timing issue Total Emergency Communications 0.00 3,745.00 (3,745.00) -100.00% 0.00 3,373.08 (3,373.08) -100.00% 2700-Animal Control Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Contract Services 842.08 500.00 342.08 40.62% 2,342.08 2,000.00 342.08 14.61% Miscellaneous 0.00 (36.00) 36.00 100.00% 240.00 324.00 (84.00) -35.00% Animal impound fees;recovering funds where possible Total Animal Control 842.08 464.00 378.08 44.90% 2,582.08 2,324.00 258.08 10.00% Total Public Safety 63,777.17 47,792.01 15,985.16 25.06% 273,248.97 243,388.49 29,860.48 10.93% Detail 6 DEPT 430-PUBLIC WORKS MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 3100-Public Works Month Month Month Month YTD YTD YTD YTD FT Salaries 20,604.00 18,040.77 2,563.23 12.44% 75,548.00 74,062.47 1,485.53 1.97% PT Salaries 0.00 2,587.18 (2,587.18) -100.00% 0.00 7,274.77 (7,274.77) -100.00% Extra staff for snow removal PERA Contributions 1,493.79 1,495.53 (1.74) -0.12% 5,477.23 5,894.67 (417.44) -7.62% FICA Contributions 1,277.45 1,210.99 66.46 5.20% 4,683.98 4,802.21 (118.23) -2.52% Medicare Contributions 298.76 283.22 15.54 5.20% 1.095.45 1,123.09 (27.64) -2.52% Health/Dental insurance 4,920.00 2,899.00 2,021.00 41.08% 18,040.00 14,495.00 3,545.00 19.65% Unemployment Benefits o 0.00 0.00 0.00 0.00/0 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 135.30 (110.30) -441.20% 125.00 1,314.26 (1,189.26) -951.41% Shop Materials 50.00 0.00 50.00 100.00% 250.00 979.75 (729.75) -291.90% Building Repair Supplies 25.00 453.24 (428.24) -1712.96% 125.00 453.24 (328.24) -262.59% Small Tools and Minor Equip 200.00 301.67 (101.67) -50.84% 1,000.00 693.29 306.71 30.67% Engineering Services 750.00 890.50 (140.50) -18.73% 3,750.00 4,569.50 (819.50) -21.85% Contract Services 100.00 186.20 (86.20) -86.20% 500.00 318.45 181.55 36.31% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 638.43 581.01 57.42 8.99% 3,192.15 2,911.55 280.60 8.79% Radio 0.00 0.00 0.00 0.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 20,000.00 0.00 20,000.00 100.00% 20.000.00 16,085.00 3.915.00 19.58% Annual ins prem;budgeted in May Electric Utility 2,000.00 2,457.30 (457.30) -22.87% 10,000.00 13,691.02 (3,691.02) -36.91% Refuse 207.82 210.94 (3.12) -1.50% 1,039.10 843.76 195.34 18.80% Fuel,Oil,Fluids(ALL depts) 4,000.00 2,047.23 1,952.77 48.82% 20,000.00 22,882.76 (2,882.76) -14.41% Repair/Maint Bldg 100.00 319.37 (219.37) -219.37% 500.00 1,926.77 (1,426.77) -285.35% Repair/MaintNOT Bldg 50.00 0.00 50.00 100.00% 250.00 448.00 (198.00) -79.20% Repair/Maint Equip(out) 300.00 0.00 300.00 100.00% 1,500.00 0.00 1,500.00 100.00% Equipment Parts 0.00 1.04 (1.04) -100.00% 0.00 155.24 (155.24) -100.00% Uniforms 100.00 174.99 (74.99) -74.99% 500.00 673.68 (173.68) -34.74% Miscellaneous 50.00 0.00 50.00 100.00% 250.00 294.40 (44.40) -17.76% Landscaping Material 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 0.00 0.00 0.00 0.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 57,190.25 34,275.48 22,914.77 40.07% 177,925.91 177,497.76 428.15 0.24% 3120-Streets Equipment Parts 100.00 0.00 100.00 100.00% 500.00 865.17 (365.17) -73.03% Street Maintenance Materials 1,000.00 1,418.06 (418.06) -41.81% 5,000.00 5,189.82 (189.82) -3.80% Sign Repair Materials 0.00 0.00 0.00 0.00% 0.00 968.60 (968.60) -100.00% Contract Services 300.00 0.00 300.00 100.00% 600.00 775.93 (175.93) -29.32% Repairs/Maint Equipment 200.00 0.00 200.00 100.00% 1,000.00 78.25 921.75 92.18% Total Streets 1,600.00 1,418.06 181.94 11.37% 7,100.00 7,877.77 (777.77) -10.95% Detail 7 MONTH YTD 3125-Ice 8z Snow Removal BUDGET ACTUAL Variance Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD Landscaping Material 0.00 0.00 0.00 0.00% 0.00 ll.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 0.00 0.00 0.00% 4,500.00 9,660.00 (5,160.00) -114.67% Repairs/Maint Equipment 500.00 0.00 500.00 100.00% 2,500.00 2.254.24 245.76 9.83% Total Ice&Snow Removal 500.00 0.00 500.00 100.00% 62,000.00 57,341.49 4,658.51 7.51% 3160-Street Lighting Street Lighting 2,400.00 2,060.27 339.73 14.16% 12,000.00 8,522.16 3,477.84 28.98% Total Street Lighting 2,400.00 2,060.27 339.73 14.16% 12,000.00 8,522.16 3,477.84 28.98% 3200-Recycling Recycling Supplies 3,400.00 1,158.40 2,241.60 6593% 3,400.00 3,290.85 109.15 3.21% 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 3,400.00 1,158.40 2,241.60 65.93% 3,400.00 4,831.86 (1,431.86) -42.11% 3250-Tree Program Contract Services 0.00 0.00 0.00 0.00% 3.750.00 450.00 2,800.00 74.67% Total Tree Program 0.00 0.00 0.00 0.00% 3,750.00 950.00 2,800.00 74.67% Total Public Works 65,090.25 38,912.21 26,178.04 40.22% 266,175.91 257,021.04 9,154.87 3.44% 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 FT Salaries 13,225.00 12,376.25 848.75 6.42% 54,825.00 47,707.44 7,117.56 12.98% PT Salaries 0.00 1,762.00 (1,762,00) -100.00% 0.00 3,168.30 (3,168.30) -100.00% Extra part time help PERA Contributions 1,103.81 897.29 206.52 18.71% 4,119.81 3,547.96 571.85 13.88% FICA Contributions 943.95 843.09 100.86 10.68% 3,523.15 3,033.43 489.72 13.90% Medicare Contributions 220.76 197.15 23.61 10.69% 823.96 709.39 114.57 13.90% Health/Dental Insurance 1,324.00 290.16 1,033.84 78.08% 5,756.00 1,450.80 4,305.20 74.79% 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 1,000.00 0.00 1,000.00 100.00% 1,000.00 24.99 975.01 97.50% Chemicals 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Equipment Parts 1,000.00 353.32 646.68 64.67% 1,023.50 2,913.28 (1,889.78) -184.64% 480D radiator repair/service Building Repair Supplies 0.00 814.89 (814.89) -100.00% 0.00 814.89 (814.89) -100.00% Landscaping Materials 2,000.00 1,413.99 586.01 29.30% 2,000.00 1,413.99 586.01 29.30% Small Tools and Minor Equip 0.00 249.73 (249.73) -100.00% 1,609.01 803.87 805.14 50.04% Telephone 0.00 74.55 (74.55) -100.00% 331.49 425.35 (93.86) -28.31% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 3,683.00 0.00 3,683.00 100.00% 3,683.00 3,171.00 512.00 13.90% Annual ins prem;budgeted in May Electric Utility 617.83 614.03 3.80 0.62% 3,704.15 3,283.90 420.25 11.35% Refuse 207.82 210.94 (3.12) -1.50% 831.28 843.76 (12.48) -1.50% Repair/Maint Bldg 0.00 370.00 (370.00) -100.00% 246.25 397.64 (151.39) -61.48% Repair/Maint NOT Bldg 41.82 667.96 (626.14) -1497.23% 69.07 2,438.07 (2,369.00) -3429.85% Light repairs at Lions field,trail grooming at Sunfish Lake Park Repair/Maint Equip 0.00 0.00 0.00 0.00% 0.00 2,194.35 (2,194.35) -100.00% Unforeseen repairs on 98 GMC Rental Buildings 300.00 948.50 (648.50) -216.17% 1,500.00 981.34 518.66 34.58% Miscellaneous 100.00 0.00 100.00 100.00% 450.00 649.75 (199.75) -44.39% Total Parks&Recreation 25,767.99 22,083.85 3,684.14 14.30% 89,995.67 79,973.50 10,022.17 11.14% 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 310,189.95 215,352.97 94,$36.98 30.57% 1,097,595.78 1,036,518.90 61,076.88 5.56% Net Income over Expenses (266,919.10) (120,508.43) 146,410.67 54.85% (848,250.70} (785,064.00) 63,186.70 7.45% Detail 9