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 4 15 14 March FS
Citv of Lake Elmo 4/9/2014 2014 By Month Budget to Actual Comparative For the month ending March 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 30,536.75 55,005.13 24,468.38 80.13% 133,292.25 137,980.26 4,688.01, 3.526/. EXPENSE Total Mayor&Council 5,550.00 20.00 5,530.00 99.64% 12,667.00 4,116.23 8,550.77 67.50% Total Administration 28,381.70 58,748.24 (30,366.54) -106.99% 84,725.08 118,110.82 (33,385.74) -39.40% Total Elections 0.00 940.00 (940.00) 0.00% 0.00 940.00 (940.00) 0.00% Not budgeted since no election scheduled;had to recalibrate machines for special school election. Total Communications 7988.48 5,270.59 2,717.89 34.02% 19,793.28 15,980.71 3,812.57 19.26% Total Finance 23,086.24 19,622.68 3,463.56 15.00% 41,913.42 41,654.75 258.67 0.62% Total Planning&Zoning 23,658.41 20,377.76 3,280.65 13.87% 63,875.21 58,581.11 5,294.10 8.29% Total Engineering Services 4,000.00 4,299.09 (299.09) -7.48% 12,000.00 11,454.96 545.04 4.54% Total City hall 2,208.32 2,397.24 (18892) -8.55% 6,674.96 6,728.23 (53.27) -0.80% Total General Government 94,873.15 111,675.60 (16,802.45) 717.71% 241,648.95 257,566.81 (15,917.86) -6.59% DEPT 420-PUBLIC SAFETY Total Police 0.00 0.00 0.00 0.00% 0.00 634.22 (634.22) 0.00% Total Prosecution 4,250.00 4,512.50 (262.50) -6.18% 12,760.50 8,842.50 3,918.00 30.70% Total Fire 36,901.99 32,582.23 4,319.76 11.71% 107,511.38 94,564.99 12,946.39 12.04% Total Fire Relief 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Building Inspections 11,815.02 10,129.61 1,685.41 14.26% 38,959.96 30,359.29 8,600.67 22.08% Total Emergency Communications 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Animal Control 500.00 530.00 (30.00) -6.00% 1,030.00 1,165.00 (135.00) -13.11% Total Public Safety 53,467.01 47,754.34 5,712.67 10.68% 160,261.84 1-15,566.00 24,695.84 15.41% 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 36,158.91 52,106.30 (15,947.39) -44.10% 91,526.75 115,144.19 (23,617.44) -25.80% Total Streets 1,300.00 1,903.43 (603.43) 46.42% 4,200.00 6,236.09 (2,036.09) -48.48% Total Ice&Snow Removal 25,500.00 17,357.67 8,142.33 3193% 61,000.00 56,261.15 4,738.85 7.77% Total Street Lighting 2,400.00 2,149.73 250.27 10.43% 7,200.00 4,336.09 2,863.91 39.78% Total Recycling 0.00 0.00 0.00 0.00% 0.00 1,541.01 (1,541.01) -100.00% Total Tree Program 3,750.00 0.00 3,750.00 100.00% 3,750.00 0.00 3,750.00 100.00% Total Public Works 69,108.91 73,517.1.3 (4,408.22) -6.38% 167,676.75 183,518.53 (15,841.78) -9.45% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 20,456.94 15,212.25 5,244.69 25.64% 48,336.25 42,788.04 5,548.21 11.48% DEPT 460-COMP ADJ 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% DEPT 490-CONTINGENCE'FUND 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00°/o DEPT 493-OTH FINANCING 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00°/� GRAND TOTAL ALL DEPTS 237,906.01 248,159.32 (10,253.31) 4.31% 617,923.79 619,439.38 (1,515.59) Net Income over Expenses (207,369.26) (193,154.20) 14,215.07 6.85% (484,631.54) (481,459.12} 3,172.42 0.650/. Summary_2 Citv of Lake Elmo 4/9/2014 2014 By Month Budget to Actual Comparative For the month ending March 31,2014 10]-General Fund Detail 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 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% 1,500.00 0.00 (1,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 165.00 0.00 (165.00) -100.00% 165.00 0.00 (165.00) -100.00% Heating Contractor License 710.00 400.00 (310.00) -43.66% 2,400.00 1,300.00 (I,100.00) -45.83% Blacktopping Contractor License 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Permits 12,000.00 28,368.35 16,368.35 136.40% 34,000.00 41,480.10 7,480.10 22.00% March was very busy;4 new home starts Heating Permits 1,000.00 1,140.00 140.00 14.00% 3,000.00 3,320.00 320.00 10.67% � Plumbing Pen-nits 500.00 1,320.00 820.00 164.00% 2,500.00 2,880.00 380.00 15.20% Sewer Permits 185.00 0.00 (185.00) -100.00% 365.00 0.00 (365.00) -100.00% Animal License 140.00 221.00 81.00 57.86% 1,120.00 1,838.50 718.50 64.15% Utility Permits(ROW) 0.00 1,357.00 1,357.00 100.00% 750.00 2,904.60 2,154.60 287.28% Due to I-94 expansion Burning Permit 200.00 180.00 (20.00) -1 0.00% 600.00 180.00 (420.00) -70.00% Massage Therapy Licenses 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Electrical Permit 0.00 264.98 264.98 100.00% 0.00 264.98 264.98 100.00%Rep 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 3,000.00 0.00 (3,000.00) -100.00% 3,000.00 0.00 (3,000.00) -100.00% Based on funds reed in 2013;sub;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% Misc State Grant/Surcharge Rev 0.00 0.00 0.00 0.00% 49,011.00 50,848.00 1,837.00 3.75% Cable Franchise Revenue 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Zoning&Subdivision Fees 250.00 0.00 (250.00) -100.00% 250.00 0.00 (250.00) -100.00% Plan Check Fees 7,000.00 16,181.00 9,181.00 131.16% 21,000.00 22,754.49 1,754.49 8.35% March was very busy;4 new home starts Sale of Copies,Books,Maps 11.75 88.00 76.25 648.94% 91.25 110.75 19.50 21.37% Assessment Searches 75.00 60.00 (15.00) -20.00% 240.00 105.00 (135.00) -56.25% 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,500.00 4,841.80 341.80 7.60% 12,000.00 7,950.11 (4,049.89) -33.75% Miscellaneous Revenue 200.00 525.00 325.00 162.50% 600.00 955.73 355.73 59.29% CUP permits Internal Charges 100.00 58.00 (42.00) -42.00% 700.00 248.00 (452.00) -64.57% 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 30,536.75 55,005.13 24,468.38 80.13% 133,292.25 137,980.26 4688.01 3.52% 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 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 300.00 0.00 300.00 100.00% 300.00 0.00 300.00 100.00% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 5,000.00 20.00 4,980.00 99.60% 5,000.00 719.23 4,280.77 85.62% Dues&Subscriptions 0.00 0.00 0.00 0.00% 7,117.00 3,397.00 3,720.00 52.27% Conferences&Training 250.00 0.00 250.00 100.00% 250.00 0.00 250.00 100.00% Total Mayor&Council 5,550.00 20.00 5,530.00 99.64% 12,667.00 4,116.23 8,550.77 67.50% 1320-administration FT Salaries 13,568.00 13,271.46 296.54 2.19% 40,704.00 39,395.69 1,308.31 3.21% PERA Contributions 983.68 962.17 21.51 2.19% 2,951.04 2,854.49 96.55 3.27% ICMA Contributions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 841.22 779.60 61.62 7.33% 2,523.65 2,311.44 212.21 8.41% Medicare Contributions 196.74 182.34 14.40 7.32% 590.21 540.56 49.65 8.41% Health/Dental Insurance 3,620.00 3,620.00 0.00 0.00% 10,860.00 10,860.00 0.00 0.000/0 Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 1,000.00 0.00 1,000.00 100.00% 1,000.00 0.00 1,000.00 100.00% 0 0 Office Supplies 500.00 270.62 229.38 45.88/0 1,500.00 1,463.34 36.66 2.44/o Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Legal Services 5,000.00 3,184.00 1,816.00 36.32% 15,000.00 5,891.75 9,108.25 60.72% Newsletter/Website 0.00 557.35 (557.35) -100.00% 0.00 557.35 (557.35) -100.00% Assessingb Services 2,000.00 2,000.00 0.00 0.00% 6,000.00 2,000.00 4,000.00 66.67% p 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 15,000.00 (15,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% 337.06 87.10 249.96 74.16% 1,011.18 276.25 734.93 72.68% Telephone o Postage 0.00 0.00 0.00 0.00% 500.00 799.40 (299.40) -59.88/o Mileage 0.00 33.50 (33.50) -100.00% 0.00 33.50 (33.50) -100.00% Legal Publishing 200.00 420.10 (220.10) -110.05% 600.00 634.77 (34.77) -5.80% Insurance 0.00 24,808.00 (24,808.00) -100.00% 0.00 24,808.00 (24,809.00) -100.00% 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 472.00 (422.00) -844.00% 150.00 677.27 (527.27) -351.51% Dues&Subscriptions 50.00 0.00 50.00 100.00% 150.00 26.99 123.01 82.01% Books 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 35.00 3,100.00 (3,065.00) -8757.14% 1,185.00 6,779.00 (5,594.00) -472.07%Predictive Index;CC approved Staff Development 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total administration 28,381.70 58,748.24 (30,366.54) 106.99% 84,725.08 118,110.82 (33,385.74) 39.40% 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 0.00 0.00 0.00 0.00% 0,00 0.00 0,00 0.00% Miscellaneous 0.00 940.00 (940.00) -100.00% 0.00 940.00 (940.00) -100.00%WA Cty Ann Elect Mach Calibr Total Elections 0.00 940.00 (940.00) -100.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% 3,090.00 4,451.08 (1,361.08) -44.05% PERA Contributions 74.68 112.03 (37.35) -50.01% 224.03 322.70 (98.67) 44.04% FICA Contributions 63,86 92.96 (29.10) -45.57% 191.58 267.43 (75.85) -39.59% Medicare Contributions 14.94 21.73 (6.79) -45.45% 44.81 62.54 (IT73) -39.57% Health/DentalInsurance 240,00 272.00 (32.00) -13.33% 720.00 816.00 (96.00) -13.33% Workers Compensation 110.00 0.00 110.00 100.00% 110.00 0.00 110.00 100.00% Newsletter 2,000,00 0.00 2,000.00 100.00% 2,000.00 0.00 2,000.00 100.00% ° 0 Office Supplies 0.00 0.00 0.00 0.00% 47.86 0.00 47.86 100.00/o Into Technology/Web 3,500.00 2,635.58 864.42 24.70% 10,500.00 8,020.71 2,479.29 23.61%Reflects cable comet reimb for equipment Telephone 130.00 13.75 116.25 89.42% 390.00 151.69 238.31 61 J I% Mileage 25,00 0.00 25.00 100.00% 25.00 36.96 (11.96) _-47.84% Public Notices 500.00 162.00 339.00 67.60% 1,500.00 543.80 956.20 63.75% Cable Operations 300.00 415.31 (115.31) -38.44% 900.00 1,307.80 (407.80) -45.31% 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/Maim Equipment 0.00 0.00 0.00 0.00% 50.00 0.00 50.00 100.00% Total Communications 7,988.48 5,270.59 2,717.89 34.02`y° 19,793.28 1.5,980.71 3,812.57 19.26% 1520-Finance FT Salaries 6,760.00 6,734.63 25.37 0.38% 20,280.00 21,727.80 (1,447.$0) 7.14% Due to PTO payout to accounting clerk PERA Contributions 490.10 453.71 36.39 7.43% 1,470.00 1,455.07 14.93 1.02% FICA Contributions 419.12 393.55 25.57 6.10% 1,257.36 1.198.51 59.85 4.69% Medicare Contributions 98.02 92.03 5,99 6.11% 294.06 280.26 13.80 4.69% Health/Dental Insurance 1,504.00 1,088.00 416.00 27.66% 4,512.00 3,264.00 1,248.00 27.66% 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 600.00 0.00 600,00 100.00% 600.00 0.00 600.00 100.00% Office Supplies 25.00 63.26 (38.26) -153.04% 75.00 108.69 (33.69) -44.92% Printed Forms 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% Audit Services 9,000.00 9,775.00 (775.00) -8.61% 9,000.00 9,775.00 (775.00) -8.61% Installment pmt Contract Services 3,000.00 925.00 2,075.00 69.17% 3,000.00 1,189.69 1,810.31 60.34% See note above Software Programs 150.00 0.00 150.00 100.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% 300.00 82.50 217.50 72.50% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 750.00 70.00 680.00 90.67% 750.00 428.69 321.31 42.84% Dues&Subscriptions 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 190.00 0.00 190.00 100.00% 225.00 270.00 (45.00) -20.00% Ehlers conf recommended by City Admin Zuleger Total Finance 23,086.24- 19,622.68 3,463.56 15.00% 41,911.42 41,654.75 258.67 0.62% Detail_3 MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD 1910-Planning&Zoning I FT Salaries 12,298.00 13,152.65 (854.65) -6.95% 36,894.00 36,622.53 271.47 0.74% PERA Contributions 891.61 953.56 (61.95) -6.95% 2,674.82 2,829.28 (154.46) -5.77% FICA Contributions 762.48 769.73 (7.25) -0.95% 2,287.43 2,284.10 3.33 0.15% Medicare Contributions 178.32 180.01 (1.69) -0.95% 534.96 534.18 0.78 0.15% Health/Dental Insurance 2,678.00 2,678.00 0.00 0.00% 8,034.00 8,034.00 0.00 0.00% Workers Compensation 800.00 0.00 800.00 100.00% 800.00 0.00 800.00 100.00% Office Supplies 150.00 159.84 (9.84) -6.56% 450.00 216.40 233.60 51.91% Printed Forms 250.00 364.00 (114.00) -45.60% 250.00 410.00 (160.00) -64.00% Engineering Services 3,000.00 2,054.82 945.18 31.51% 9,000.00 7,346.07 1,653.93 18.38% Contract Services 2,500.00 0.00 2,500.00 100.00% 2,500.00 0.00 2,500.00 100.00% Infonnation Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 100.00 38.15 61.85 61.85% 300.00 89.16 210.84 70.28% Postage 50.00 0.00 50.00 100.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 0.00 25.00 (25.00) -100.00% 100.00 25.75 74.25 74.25% Dues&Subscriptions 0.00 0.00 0.00 0.00% 0.00 135.00 (135.00) -100.00% Books 0.00 2.00 (2.00) -100.00% 0.00 0.00 0.00 0.00% Conferences&Training 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 _ 0.00% Total Planning&Zoning 23,658.41 20,377.76 3,280.65 13.87% 63,875.21 58,581.11 5,294.10 8.29% 1930-Engineering Services Engineering Services 4,000.00 _ 4,299.09 (299.09) -7.48% 12,000.00 11,454.96 545.04 4.54% Total Engineering Services 4,000.00 4,299.09 (299.09) -7.48% 12,000.00 11,454.96 545.04 4.54% 1940-City Hall Cleaning Supplies 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Repair Supplies 0.00 0.00 0.00 0.00% 0.00 163.97 (163.97) -100.00% Telephone 200.00 13.75 186.25 93.13% 600.00 299.30 300.70 50.12% Utilities 1,100.00 1,576.23 (476.23) -43.29% 3,300.00 3,253.38 46.62 1.41% Refuse 108.32 109.93 (1.61) -1.49% 324.96 219.86 105.10 32.34% Repairs/Maint Contractual Bldg 600.00 230.00 370.00 61.67% 1,800.00 1,813.29 (13.29) -0.74% Repairs/Maint Contractual Equip 200.00 397.65 (197.65) -98.83% 600.00 888.89 (28&89) -48.15% Annex repairs-Yale Mech Miscellaneous 0.00 69.68 (69.68) -100.00% 50.00 89.54 (39.54) -79.08% - - - - otal City Hall2,208.32 2,397.24 (188.92) -8.55% 6,674.96 6,728.23 (53.27) -0.80% Total General Government94,873.15 111,675.60 (16,802.45) 17.71% 241,64895 257,566.81 (15,917.86) -6.59% 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,512.50 (262.50) -6.18% 12,760.50 8,842.50 3,918.00 30.70% Total Prosecution 4,250.00 4,512.50 (262.50) -6.18% 12,760.50 8,842.50 3,918.00 30.70% 2220-Fire FT Salaries 5,701,46 5,712.96 (11.50) -0.20% 17,104.38 17,115.91 (11.53) -0.07% PT Salaries 7,618.46 7,003.98 614.48 8.07% 33,271.38 29,914.43 3,356.95 10.09% PERA Contributions 960.41 1,034.95 (74.54) -7.76% 2,773.83 3,124.60 (350.77) -12.65% FICA Contributions 825.84 380.90 444.94 53.88% 3,123.30 1,691.16 1,432.14 45.85% Medicare Contributions 193.14 176.85 16.29 8.43% 730.45 659.99 70.46 9.65% Health/Dental Insurance 1,230.00 1,142.00 88.00 7.15% 3,690.00 3,426.00 264.00 7.15% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0A0 0.00% Workers Compensation 9,000.00 0.00 9,000.00 100.00% 9,000.00 0.00 9,000.00 100.00% Office Supplies 0.00 38.00 (38.00) -100.00% 50.00 268.74 (218.74) -437.48% EMS Supplies 0.00 124.87 (124.87) -100.00% 400.00 224.37 175.63 43.91% Returned some EMS gear Fire Prevention 250,00 0.00 250.00 100.00% 750.00 0.00 750.00 100.00% Fuel,Oil&Fluids 1,200,00 1,317.03 (117.03) -9.75% 3,600.00 2,708.68 891.32 24.76% Small Tools&Equip 1,900.00 81.82 1,818.18 95.69% 5,700.00 6,996,67 (1,296.67) -22.75% YTD includes Thernal Imaging camera,from Jan Physicals 575.00 0.00 575.00 100.00% 1,725.00 0.00 1,725.00 100.00% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 350.00 133.15 216.85 61.96% 1,050.00 1,121.32 (71.32) -6.79% Radio 0.00 3,800.76 (3,800.76) -100.00% 1,000.00 4,197.11 (3,197.11) -319.71% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Vehicle Insurance 0.00 4,266.00 (4,266.00) -100�00% 0.00 4,266.00 (4,266.00) -100.00% Annual ins prom;budgeted in May Electric Utility 1,800.00 2,186.06 (386.06) -21.45% 5,400.00 41488.57 911.43 16.88% Refuse 47.68 48.38 (0.70) -1.47% 143.04 96.76 46.28 32.35% Repair/Maint Bldg 1,000.00 854.04 145.96 14.60% 3,000.00 2,468.44 531.56 17.72% Repair/Maint Equip 3,400.00 3,181.53 218.47 6.43% 10,200.00 8,504.16 1,695.84 16.63% Uniforms 250.00 0.00 250.00 100.00% 750.00 0.00 750.00 100.00% Miscellaneous 100.00 51795 (417.95) -41795% 300.00 741.46 (441.46) -147.15% .0 -1.59% 581.00 581.00 -100.00% 2 200.00 2 235.00 35 0 Dues&Subscriptions 0.00 ( ) Books 0.00 0.00 0.00 0.00% 50.00 102.00 (52.00) -104.00% Conferences&Training 500.00 0.00 500.00 100.00% 1,500.00 400.00 1,100.00 73.33% � Conferences&Training(Reinib) 0.00 0.00 0.00 0.00% 0.00 (186.38) 196.38 100.00%To better track training reimb Total Fire 36,901.99 32,582.23 4,319.76 11.71% L07,511.38 94,564.99 12,946.39 12.04% 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.U0 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 7,384.00 6,892.91 491.09 6,657/o 22,152.00 20,271.04 1,880.96 8.49% PERA Contributions 535.34 499.72 35.62 6.65% 1,606.02 1,469.66 136.36 8.49% FICA Contributions 457.81 401.65 56.16 12.27% 1,373,42 1,180.25 193.17 14.06% Medicare Contributions 107.07 93.93 13.14 12.27% 321,20 276.02 45.18 14.07% Health/DentalInsurance 1,818.00 1,414.00 404.00 22.22% 5,454.00 4,242.00 1,212,00 22.22% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 485.00 0.00 485.00 100.00% 485.00 0.00 485.00 100.00% Office Supplies 31.64 492 26.72 84.45% 193.78 60.06 133.72 69.01% Printed Forms 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Fuel,Oil&Fluids 0.00 0.00 0.00 0.00% 54.68 0.00 54.68 100.00% Engineering 750.00 438.75 311.25 41.50% 2,250.00 1,479:00 771.00 34.27% 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 0.00 0.00 0.00% Software Programs 150.50 0.00 150.50 100.00% 4,416.50 0.00 4,416.50 100.00% Telephone 45.66 13.75 31.91 69.89% 136.98 128.42 8.56 6.25% Mileage 50.00 0.00 50.00 100.00% 150.00 74.58 75.42 50.28% Insurance 0.00 248.00 (248.00) -100.00% 0.00 248,00 (248.00) -100.00% 0 o 12epairslMaint Equip 0.00 0.00 0.00 0.00% 0.00 213.28 (213.28) -100.00/o Uniforms 0,00 121.98 (121.98) -100.000/3 86.38 12198 (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 0.00 0.00 0.00% 0.00 125.00 (125.00) -100.00% Books 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% 280.00 200.00 80.00 28.57% Erosion control conf Total Building Inspections 11,815.02 10,129.61 1,685.41 14.26% 38,959.96 30,359.29 81600.67 22.08% 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,000.00 L000.00 0.00 0 00°io Miscellaneous 0.00 30.00 (30.00) -100.00% 30.00 165.00 (135.00) -450 00% 'Total Animal Control 500.00 530.00 (30.00) -6.00% 1,030.00 1,165.00 (135.00) 13.11% Total Public Safety 53,467.01 -47,754.34 5,712.67 10.68% 160,261.84 135,566.00 24,695.84 15.41°la 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 13,736.00 14,742.07 (1,006.07) -7.32% 41,208.00 43,868.98 (2,660.98) 6.46% PT Salaries 0.00 1,270.88 (1,270.88) -100.00% 0.00 4,287.26 (4,287.26) -100.00% Extra staff for snow removal PERA Contributions 995.86 1,160.90 (165.04) -16.57% 2,987.58 3,489.04 (501.46) -16.78% FIC A Contribution o s 851.63 949.29 (97.(i6) -11.47/0 2,554.90 2,856.42 (301.52) -11.80% Medicare Contributions 199.17 222.01 (22.84) -11.47% 597.52 668.00 (70.48) -11.80% Health/Dental Insurance 3,280.00 2,899.00 381.00 11.62% 9,840.00 8,697.00 1,143.00 11.62% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 8,000.00 0.00 8,000.00 100.00% 8,000.00 0.00 8,000.00 100.00% Office Supplies 25.00 941.25 (916.25) -3665.00% 75.00 941.25 (866.25) -1155.00% Shop Materials 50.00 75.51 (25.51) -51.02% 150.00 520.19 (370.19) -246.79% Building Repair Supplies 25.00 0.00 25.00 100.00% 75.00 0.00 75.00 100.00% Small Tools and Minor Equip 200.00 0.00 200.00 100.00% 600.00 368.10 231.90 38.65% Engineering Services 750.00 1,186.50 (436.50) -58.20% 2,250.00 1,917.75 332.25 14.77% Contract Services 100.00 42.05 57.95 57.95% 300.00 93.00 207.00 69.00% Information Technology 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 638.43 490.32 148.11 23.20% 1,915.29 1,712.70 202.59 10.58% Radio 0.00 309.06 (309.06) -100.00% 0.00 919.88 (919.88) -100.00% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 0.00 16,085.00 16,085.00 -100.00% ( ) 0.00 16,085.00 (16,085.00) -100.00% Annual ins preen;budgeted in May Electric Utility 2,000.00 3,720.15 (1,720.15) -86.01% 6,000.00 7,052.42 (1,052.42) -17.54% Refuse 207.82 210.94 (3.12) -1.50% 623.46 421.88 201.58 32.33% Fuel,Oil,Fluids(ALL depts) 4,000.00 7,072.51 (3,072.51) -76.81% 12,000.00 18,208.45 (6,208.45) -51.74% Repair/Maint Bldg 100.00 40.I4 59.86 59.86% 300.00 1,304.82 (1,004.82) -334.94% Repair/Maint NOT Bldg 50.00 0.00 50.00 100.00% 150.00 448.00 (298.00) -198.67% Repair/Maint Equip(out) 300.00 0.00 300.00 100.00% 900.00 0.00 900.00 100.00% Equipment Parts 0.00 78.84 (78.84) -100.00% 0.00 78.84 (78.84) -100.00% Uniforms 100.00 24.88 75.12 75.12% 300.00 225.81 74.19 24.73% Miscellaneous 50.00 0.00 50.00 100.00% 150.00 294.40 (144.40) -96.27% Landscaping Material 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 0.00 85.00 (85.00) -100.00% 50.00 185.00 (135.00) -270.00% Conferences&Training 500.00 0.00 500.00 100.00% 500.00 0.00 500.00 100.00% Clean up Days 0.00 500.00 (500.00) -100.00% 0.00 500.00 (500.00) -100.00% Total Public Forks 36,158.91 52,106.30 (15,947.39) -44.10% 91,526.75 1.15,144.19 (23,617.44) -25.50% 3120-Streets Equipment Parts 100.00 233.90 (133.90) -133.90% 300.00 800.22 (500.22) -166.74% Street Maintenance Materials 1,000.00 0.00 1,000.00 100.00% 3,000.00 3,766.34 (766.34) -25.54% Sign Repair Materials 0.00 968.60 (968.60) -100.00% 0.00 968.60 (968.60) -100.00% Contract Services 0.00 700.93 (700.93) -100.00% 300.00 700.93 (400.93) -133.64% Repairs/Maint Equipment 200.00 0.00 200.00 100.00% 600.00 0.00 600.00 100.00% Total Streets 1,300.00 _ 1,903.43 (603.43) -46.42% 4,200.00 - 6,236.09 (2,036.09) -48.48% Detail 7 MONTH YTD 3125-lee&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 0.00 0.00 0.00% Sand/Salt 25,000.00 13,377.30 11,622.70 46.49% 55,000.00 45,416.16 9,583.84 17.43% Contract Services 0.00 3,565.00 (3,565.00) -100.00% 4,500.00 8,912.50 (4,412.50) -98.06% Repairs/Maint Equipment 500.00 415.37 84.63 16.93% 1,500.00 1,932.49 (432.49) -28.83% Total lee&Snow Removal 25,500.00 17,357.67 8,142.33 31.93% 61,000.00 56,261.15 4,738.85 7.77% 3160-Street Lighting Street Lighting 2,400.00 2,149.73 250.27 10.43% 7,200.00 4,336.09 2,863.91 39.78% Total Street Lighting 2,400.00 2,149.73 250.27 10.43% 7,200.00 4,336.09 2,863.91 39.78% 3200-Recycling Recycling Supplies 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.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 0.00 0.00 0.00% 0.00 1,541.01 (1,541.01) -100.00% 3250-Tree Program Contract Services 3,750.00 0.00 3,750.00 100.00% 3,750.00 0.00 3,750.00 100.00% Total Tree Program 3,750.00 0.00 3,750.00 100.00% 3,750.00 0.00 3,750.00 100.00% Total Public Works69,108.91 73,517.13 (4,408.22) -6.38% 1.67,676.75 183,518.53 (15,841.78) -9.45% 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 10,150.00 9,103.40 1,046.60 10.31% 30,450.00 27,111.80 3,338.20 10.96% PT Salaries 0.00 91.42 (91.42) -100.00% 0.00 1,406.30 (1,406.30) -100.00% PERA Contributions 735.88 666.65 69.23 9.41% 2,207.63 2,054.79 152.84 6.92% FICA Contributions 629.30 548.13 81.17 12.90% 1,887.50 1,702.77 184.73 9.79% Medicare Contributions 147.18 128.19 18.99 12.90% 441.53 °.5. 398.24 43.29 9.80/o Health/Dental Insurance 1,108.00 290.16 817.84 73.81% 3,324.00 870.48 2,453.52 73.81% Unemployment Benefits 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 4,500.00 0.00 4,500.00 100.00% 4,500.00 0.00 4,500.00 100.00% Shop Materials 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Chemicals 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Equipment Parts 0.00 27.02 (27.02) -100.00% 23.50 27.02 (3.52) -14.98% 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 1,569.14 0.00 1,569.14 100.00% 1,569.14 0.00 1,569.14 100.00% Telephone 75.26 74.49 0.77 1.02% 150.63 170.07 (19.44) -12.91% Mileage 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 0.00 3,171.00 (3,171.00) -100.00% 0.00 3,171.00 (3,171.00) -100.00%Annual ins prem;budgeted in May Electric Utility 934.36 900.85 33.51 3.59% 2,166.68 1,944.16 222.52 10.27% Refuse 207.82 210.94 (312) -1.50% 415.64 421.88 (6.24) -1.50% Repair/1vlaint Bldg 0.00 0.00 0.00 0.00% 0.00 27.64 (27.64) -100.00% Repair/Maint NOT Bldg 0.00 0.00 0.00 0.00% 0.00 653.94 (653.94) -100.00% Light repairs at Lions field Repair/Maint Equip 0.00 0.00 0.00 0.00% 0.00 2,178.20 (2,178.20) -100.00% Unforeseen repairs on 98 GMC Rental Buildings 300.00 0.00 300.00 100.00% 900.00 0.00 900.00 100.00% Miscellaneous 100.00 0.00 100.00 100.00% 300.00 649.75 (349.75) -116.58% Total Parks&Recreation 20,456.94 15,212.25 5,244.69 25.64% 48,336.25 42,788.04 5,548.21 11.48% 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 237,906.01 240,1.59.32 (10,253.31) -4.31% 617,923.79 619,439.38 (1,515.59) -0.25% Net Income over Expenses (207,369.26) (193,154.20) 14,215.07 6.850/. (484,631.54) (481,459.12) 3,172.42 0.650/o Detail 9