Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item 4 - CC 12.16.14 Nov Financials
City of Lake Elmo 12/16/2014 2014 By Month Budget to Actual Comparative For the month ending November 30,2014 101-General Fund Summary By Department Full Year MONTH YTD DEPT 410-GEN'L GOV'T BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 2014 %to date Month Month Month Month YTD YTD YTD YTD REVENUE Total Revenue 3,303,535.00 56.64% 28,400.00 199,880.31 171,480.31 603.80% 1,893,170,58 2,124,497.93 231,327.35 12.22% EXPENSE Total Mayor&Council 45,269.32 46.75% 13,902.66 0.00 13,902.66 100.00% 44,869.32 21,162.34 23,706.98 52.84% Total Administration 396,538.62 89.00% 27,442.70 34,097.75 (6,655.05) -24.25% 362,845.86 387,009.51 (24,163.65) -6.66% Total Elections 13,350.00 41.59% 3,025.00 3,868.19 (843.19) -27.87% 13,350.00 9,420.20 3,929.80 29.44% Total Communications 79,129.53 97.60% 5,703.45 5,048.56 654.89 11.48% 71,401.05 82,281.20 (10,880.15) -15.24% Total Finance 156,285.12 87.04% 9,710.24 11 501.06 (1,790.82) -18.44% (1,255,72) -0.86% , , ( , ) 146,274.88 147,530.60 Total Planning&Zoning 273,059.23 77.50% 20,158.41 19,153.07 1,005.34 4.99% 249,500.82 230,766.27 18,734.55 7.51% Total Engineering Services 48,000.00 68.93% 4.000.00 3,500.00 500.00 12.50% 44,000.00 36,586.02 7,413.98 16.85% Total City Hall 27,133.16 81.00% 2,233.32 2,277.99 (44.67) -2.00% 24,849.84 24,255.67 594.17 2.39% Total General Government 1,038,764.98 82.75% 86,175.78 79,446.62 6,729.16 7.81% 957,091.77 939,011.81 18,079.96 1.89% DEPT 420-PUBLIC SAFETY Total Police 500,000.00 51.19% 0.00 0.00 0.00 0.00% 250,000.00 255,946.53 (5,946.53) -2.38% Total Prosecution 51,000.00 79.98% 4,250.00 4,512.50 (262.50) -6.18% 46,750.00 45,301.25 1,448.75 3.10% Total Fire 399,655.82 83.94% 27,940.97 21,584.25 6,356.72 22.75% 368,264.10 356,550.34 11,713.76 3.18% Total Fire Relief 37,323.50 143.20% 0.00 0.00 0.00 0.00% 37,323.50 53,446.01 (16,122.51) 43.20% Total Building Inspections 157,601.95 83,45% 11,877.24 10,798.75 1,078.49 9.08% 145,711.11 142,313.84 3,397.27 2.33% 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% Total Animal Control 6,282.08 90.40% 500.00 833.21 (333.21) -66.64% 5,732.08 6,512.21 (780.13) -13.61% Total Public Safety- 1,157,663.35 71.37% 44,568.21 37,728.71 6,839.50 15.35% 859,580.79 863,443.26 (3,862.47) -0.45% Summary_1 MONTH YTD BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) DEPT 430-PUBLIC WORKS Month Month Month Month YTD YTD YTD YTD Total Public Works 386,269,42 86.55% 27,658.91 23,169.17 4,489.74 16.23% 358,560.71 357,497.27 1,063.44 0.30% Total Streets 16,800.00 252.57% 1,600.00 11,327.91 (9,727,91) -607.99% 15,50(l.(I(1 53,759.92 (38,259.92) -246.84% Total Ice&Snow Removal 96,000.00 65.60% 13,500.00 515.27 12,984.73 96.18% 79,500.00 63,493.13 16,006.87 20.13% Total Street Lighting 28,800.00 64.25% 2,400.00 2,040.29 359.71 14.99% 26,400.00 20,545.56 5,854.44 22.18% Total Recycling 7,400.00 70.60% 0.00 0.00 0.00 0.00% 7,400.00 5,224.43 2,175.57 29.40% Total Tree Program 5,000.00 107.00% 0.00 0.00 0.00 0.00% 6,250.00 5,350.00 900.00 14.40% Total Public Works 540,269.42 86.77% 45,158.91 37,052.64 8,106.27 17.95% 493,610,71 505,870.31 (12,259.60) -2.48% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 206,836.63 85.26% 15,875-05 12,771.78 3,103.27 19.55% 200,116.88 189,112.14 11,004.74 5.50% GRAND TOTAL ALL EXPENSES 2,943,535.00 79.19% 191,777.95 166,999.75 24,778.20 12.92% 2,510,400.15 2,497,437.52 12,962.63 52.00% SUB TOTAL NET INC OVER EXP 360,000.00 -112.87% (163,377.95) 32.880.56 146,702.11 -89.79% (617,229.57) (372,939.59) 244,289.98 -39.58% 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% TRANS TO CITY PROJ FUND(STREETS) 160,000.00 0.00% 0.00 0.00 0.00 0,00% 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 ALI.DEPTS 3,303,535.00 70.56% 191,777.95 166,999.75 24,778,20 12.920/. 2,510,400.15 2,497,437.52 12.962.63 0.52% Net Income over Expenses 0.00 0.00% (163,377.95) 32,880.56 196,258.51 120.13% (617,229.57) (372.939.59) 244,289.98 39.58% Summary_2 City of Lake Elmo 12/16/2014 2014 By Month Budget to Actual Comparative For the month endine November 30,2014 101-General Fund Detail By Department Full Year MONTH YTD DEPT 410-GEN'L GOV'T BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 2014 %to dale Month Month Month Month YTD YTD YTD YTD YTD variance notes REVENUE 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 8,000.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.00% 2,590.00 374.52 °(2,215.48) -85.54/o 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 as budgeted 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 60.61% 0.00 0.00 0.00 0.00% 165.00 100.00 (65.00) -39.39% Heating Contractor License 6,650.00 115.34% 500.00 3,250.00 2.750.00 550.00% 6,150.00 7,670.00 1,520.00 24.72% 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 115.15% 15,000.00 29,379.85 14,379.85 95.87% 155,500.00 196,338.30 40,838.30 26.26% Mo-10 new home starts;YTD-31 Building Re-inspect Fees 0.00 100,00% 0.00 0.00 0.00 0.00% 0.00 600.00 600.00 100.00% Heating Permits 1.5,600.00 132.08% 1,300.00 1,080.00 (220.00) -16.92% 14,300.00 20,603.72 6,303.72 44.08% Plumbing Permits 9,000.00 185.64% 500.00 480.00 (20.00) -4.00% 8,500.00 16.707.19 8,207,19 96.56% 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 129.01% 50.00 80.00 30.00 60.00% 1,941.00 2,568.50 627.50 32.33% Utility Permits(ROW) 11,000.00 256.66% 1,000.00 5,231.60 4,231.60 423,16% 9,000.00 28,233.10 19,233.10 213.70% Due to 1-94 expansion;ROW Burning Permit 3,350.00 49.25% 150.00 295.00 145.00 96.67% 3,200.00 1,650.00 (1,550.00) -48.44% Massage Therapy Licenses 150.00 13333% 0.00 25.00 25.00 100.00% 150.00 200.00 50.00 33.33% Electrical Permit 0.00 100.00% 0.00 399.00 399.00 100.00% 0.00 4,506.04 4,506.04 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 100.00% 0.00 0.00 0.00 0.00% 98,022.00 98,022.00 0.00 0.00% State Fire Aid 41,500.00 128.79% 0.00 0.00 0.00 0.00% 41,500.00 53,446.01 11,946.01 28.79% Rec'd supplemental aid in addition to base state fire aid 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 0.00 0.00 0.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 1404.10% 0.00 10,000.00 10,000.00 100.00% 1,150.00 16,147.13 14,997.13 1304.10% Mo-$IOk AUAR grant,YTD-also DNR trail groorning funds of$4k Cable Franchise Revenue 42,852.00 97.08% 0.00 0.00 0.00 0.00% 42,851.98 41,601.71 (1,250.27) -2.92% Cable franchise revenue received May 1st Zoning&Subdivision Fees 1,250.00 1879.28% 0.00 4,250.00 4,250.00 100.00% 1,000.00 23,490.95 22,490.95 2249.10% Developer zoning exceptions;Conditional Use Permits Plan Check Fees 82,000.00 144.64% 6,000.00 17,951.45 11,951.45 199.19% 76,000.00 118,608.41 42,608.41 56.06% Due to commercial activity in September not budgeted Sale of Copies,Books,Maps 206.00 137.74% 0.00 0.00 0.00 0.00% 206.10 283.75 77.65 37.68% Assessment Searches 1,285.00 82.88% 100.00 90.00 (10.00) -10.00% 1,185.00 1,065.00 (120.00) -10.13% Clean Up Days 3,000.00 75.93% 0.00 0.00 0.00 0.00% 3,000.00 2,278.00 (722.00) -24.07% Cable Operation Reimbursement 1,950.00 39.68% 0.00 0.00 0.00 0.00% 1,700.00 773.75 (926.25) -54.49% Fines 48,000.00 87.43% 3,500.00 4,375.66 975.66 25.02% 44,500.00 41,965.63 (2,534.37) -5.70% Miscellaneous Permits 0.00 0.00% 0.00 40.00 40.00 0.00% 0.00 8,173.02 8,173.02 100.00% August includes$7,500 for fuel tank permit(Kwik Trip) Fire Billable Revenue 0.00 0.00% 0.00 8,922.75 8,922.75 100.00% 0.00 10,422.75 10,422.75 100.00% Fire billings to Northern Nat'l gas($8.1k)and Res for$850 Miscellaneous Revenue 2,400.00 4931.68% 200.00 114,000.00 113,800.00 56900.00% 2,200.00 118,360.35 116,160.35 5280.02% Koch Pipeline easement revenue($I l4k) Internal Charges 1,600.00 49.75% 100.00 30.00 (70.00) -70.00% 1,500.00 796.00 (704.00) 46.93% Fewer library card reimb than budgeted Interest Earnings 20,000.00 53.76% 0.00 0.00 0.00 0.00% 0.00 10,751.55 10,751.55 100.00% Month equals YTD interest accrual per FC request Donations 0.00 100.00%1 0.00 0.00 0.00 0.00% 0.00 11,100.00 11,100.00 100.00% Donation from LE Jaycees(For"Community Improvements") Total Revenue 3,303,535.00 6431% 28,400.00 199,88031 171,480.31 603.80% 1,893,170.58 2,124,497.93 231,32735 12.22% Detail 1 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% 12,845.00 0.00 12,845.00 100.00% 25,690.00 12,845.00 12,845.00 50.00% FICA Contributions 1,592.78 50.00% 796.39 0.00 796.39 100.00% 1,592.78 796.39 796.39 50.00% Medicare Contributions 372.54 50.00% 186.27 0.00 186.27 100.00% 372.54 186.27 186.27 50.00% Workers Compensation 300.00 10.70% 0.00 0.00 0.00 0.00% 300.00 32.10 267.90 89.30% Mileage 800.00 0.00% 75.00 0.00 75.00 100,00% 650.00 0.00 650.00 100.00% Miscellaneous 5,000.00 14.56% 0.00 0.00 0.00 0.00% 5,000.00 727.90 4,272.10 85.44% Dues&Subscriptions 10,514.00 62.53% 0.00 0.00 0.00 0.00% 10,514.00 6,574.68 3,939.32 37.47% Includes Memberships;annual LMC paid in September Conferences&Training 19000.00 0.00% 0.00 0.00 0.00 0.00% 750.00 0.00 750.00 100.00% Total Mayor&Council 45,269.32 46.75% 13,902.66 0.00 13,902.66 100.00% 44,869.32 21,162.34 23,706.98 52.84% 1320-Administration FT Salaries 176,384.00 87.03% 13,568.00 13,271.40 296.60 2.19% 162,816.00 153,502.56 9,313.44 5.72% PERA Contributions 12„505.02 98.98% 983.68 962.16 21.52 2.19% 11,521.34 11,127.19 394.15 3.42% 1CMA 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 85.24% 841.22 779.60 61.62 7.33% 9,762.70 9,039.27 723.43 7.41% Medicare Contributions 2,479.96 85.24% 196.74 182.34 14AO 7.32% 2,283.22 2,114.00 169.22 7.41% Health/DentalInsurance 47,636.00 87.39% 3,716.00 3,620.00 96.00 2.58% 43,920.00 41,630.00 2,290.00 5.21% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0,00 0.00 0.00 0.00% Workers Compensation 11000.00 95.38% 0.00 0.00 0.00 0.00% 1,000,00 953.77 46.23 4.62% Office Supplies 6,000.00 91.81% 500.00 72.79 427.22 85A4% 5,500.00 5,508,39 (8.39) -0.15% Printed Forms 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 138.00 (138.00) -100.00% Legal Services 60,000.00 56.29% 5,000.00 2,376.50 2,623.50 52.47% 55,000.00 33,775.75 21,224.25 38.59% Under budget due to City Clerk ability to cover some activity Newsletter/Website 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 2,224.60 (2,224.60) -100.00% Assessing Services 30,500.00 106.35% 2,000.00 2,500.00 (500.00) -25.00% 23,500.00 32,435.39 (8,935.39) -38,02% Information Technology 0.00 100.00% 0.00 7,728,13 (7,728.13) 0.00% 0.00 9,050.15 (9,050.15) -100.00% Nov=Fiber Optics to new space Contract Services 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 33,923.05 (33,923.05) -100,00% Leg Lobbyist appr by CC&Temp secs 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 26.67% 337.06 87.10 249.96 74.16% 3,707.60 1,078.77 2,628.83 70.90% Postage 4,000.00 67.15% 0.00 0.00 0.00 0.00% 3,000.00 2,686.17 313.83 10.46% Mileage 600.00 37A7% 0.00 0.00 0.00 0.00% 600.00 224.81 375.19 62.53% Legal Publishing 2,400.00 181.31% 200.00 0.00 200.00 100.00% 2,200.00 4,351.45 (2,151 A5) -97.79% Due to notice increases due to development activities Insurance 35,000.00 71.49% 0.00 0.00 0.00 0.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 267.48% 50.00 56.74 (6.74) -13.48% 550.00 1,604.88 (1,054.88) -191,80% Rent 0.00 100.00% 0.00 2,461.00 (2,461.00) -100.00% 0.00 4,922.00 (4,922.00) -100.00% Dues&Subscriptions 600.00 158.69% 50.00 0.00 50.00 100.00% 550.00 952.15 (402.15) -73.12% Books 0.00 100.00% 0.00 0.00 0.00 0,00% 0.00 81.27 (81.27) -100.00% Conferences&Training 2,185.00 393.83% 0.00 0.00 0.00 0.00% 1,935.00 8,605.22 (6,670.22) -344.71% 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 97.60% 27,442.70 34,097.75 (6,655.05) -24.25% 362,845.86 387,009.51 (24,163.65) -6.66% 1410-Elections PT Salaries 10,000.00 76.47% 2,500.00 3,842.50 (1,342.50) -53.70% 10,000.00 7,647.00 2,353.00 23.53% 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% 500.00 0.00 500.00 100.00% than budgeted Legal Publications/Notification 500.00 0.00% 125.00 0,00 125.00 100.00% 500.00 0.00 500.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% 125.00 0.00 125.00 100.00% 450.00 0.00 450.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.00% Miscellaneous 600.00 295.53%1 150.00 25.69 124.31 82.87% 600.00 1,773.20 (1,173.20) -195.53% WA Cty Ann Elect Mach Calibr Total Elections 13,350.00 70.56%1 3,025.00 3,868.19 (843.19) -27.87% 13,350.00 9,420.20 3,929.80 29A4% Not budgeted since no election scheduled;had to Detail 2 recalibrate machines for special school election. Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance Variance(%) BUDGET ACTUAL. Variance(S) Variance(%) 1450-Communications 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 13,390.00 137.10% 1,030.00 1,54523 (515.23) -50.02% 12,360.00 18,358.10 (5,998.10) -48.53% PERA Contributions 970.78 137.10% 74.65 112.03 (37.38) -50.07% 896.10 1,330.95 (434.85) -48.53% FICA Contributions 830.18 133.00% 63.86 92.96 (29.10) -45.57% 766.32 1,104.11 ° Medicare Contributions 194.16 132.99% 14.94 21.73 (6.79) -45.45% 179.22 258.21 (78.99) -44.07% Health/DentalInsurance 3,120.00 100.26% 240.00 272.00 (32.00) -13.33% 2,880.00 3,128.00 (248.00) -8.61% Workers Compensation 110.00 101.61% 0.00 0.00 0.00 0.00% 110.00 111.77 (1.77) -1.61% Newsletter 8,000.00 85.06% 0.00 0.00 0.00 0.00% 6,000,00 6,804.81 (804.81) -13.41% Due to timing ofnewsletters Office Supplies 304A1 402.85% 0.00 0.00 0.00 0.00% 254.41 1,226.32 ° Info Technology/Web 42,000.00 94.46% 3,500.00 2,635.58 864.42 24.70% 38,500.00 39,671.45 (1,171.45) -3.04% Primarily due 10 L.aserfiche upgrade approved by CC Telephone 1,560.00 48.64% 130.00 69.03 60.97 46.90% 1,430.00 758.77 671.23 46.94% Mileage 0.00 100.00% 0.00 0.00 0.00 0.00% 75.00 36.96 38.04 50.72% Public Notices 4,200.00 108.17% 300.00 0.00 300.00 100.00% 3,900.00 4,543.00 (643.00) -16.49% Cable Operations 3,600.00 109.27% 300.00 300.00 0.00 0.00% 3,300.00 3,933.75 (633.75) -19,20% Will be rennb by cable comet; filed quarterly for reimb Conferences 800.00 114.38% 0.00 0.00 0.00 0.00% 500.00 915.00 (415.00) -83.00% Repair/Mainz Equipment 50.00 200.00% 50.00 0.00 50.00 100.00% 250.00 100.00 150.00 60.00% Total Communications 79,129.53 103.98% 5,703.45 5,048.56 654.89 11.48% 71,401.05 82,281.20 (10,880.15) -15.24% 1520-Finance FT Salaries 87,880.00 88.82% 6,760.00 6,258.08 501.92 7.42% 81,120.00 78,050.86 3,069.14 3.78% Due to PTO payout to accounting clerk PERA Contributions 6,371.30 86.93% 490.10 453.72 36.38 7.42% 5,881.20 5,538.52 342.68 5.83% FICA Contributions 5,448-% 82.51% 419.12 366.34 52.78 12,59% 5,029.44 4,495.60 533.84 10.61% Medicare Contributions 1,274.26 82.51% 98.02 85.68 12.34 12.59% 1,176.24 1.051.36 124.88 10.62% Health/Dental Insurance 19,936.00 55.12% 1,568.00 870.40 697.60 44.49% 18,368.00 10,988.80 7,379.20 40.17% Due to contractor cost savings Unemployment Benefits 0.00 100.00% 0.00 2,15.5.28 (2,155.28) -100.00% 0.00 5,555.73 (5,555.73) -100.00% 100%allocation to GF vs primarily to Enterprise Funds Workers Compensation 600.00 38.44% 0.00 0.00 0.00 0.00% 600.00 230.61 369.39 61.57% Office Supplies 300.00 51.86% 25.00 0.00 25.00 100.00% 275.00 155.57 119,43 43.43% Printed Forms 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 433.47 (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 240.60% 0.00 1,284.06 (1,284.06) -100.00% 4,000.00 10,826.91 (6,826.91) -170.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 25.21% 100.00 27.50 72.50 72.50% 1,100.00 302.50 797.50 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% 0.00 0.00 0.00 0.00% 950.00 25.28 924.72 97.34% Dues&Subscriptions 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 540.00 (540.00) -100.00% Conferences&Training 575.00 80.15% 250.00 0.00 250.00 100.00% 575.00 460.85 114,15 19.85% Ehlers confrecommended by City Adnun Zuleger Total Finance F 1-56,285.12 94.40% 9,710.24 11,501.06 (1,790.82) -18.44% 146,274.88 147,530.60 (1,255.72) -0.86% 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 159,874.00 105.28% 12,298.00 12,889.29 (591.29) -4.81% 147,576.00 168,319.31 (20,743.31) -14.06% Costs for intern to assist with workload PERA Contributions 11,590.87 95.82% 891.61 839.86 51.75 5.80% 10,699.26 11,106,07 (406.81) -3.80% FICA Contributions 9,912.19 95.65% 762.48 753.43 9.05 1.19% 9,149.71 9,481.17 (331.46) -3.62% Medicare Contributions 2,318.17 95.65% 178.32 176.19 2.13 1.19% 2,139.85 2,217.38 (77.53) -3.62% Health/Dental Insurance 34,814.00 88.46% 2,678.00 2,678.00 0.00 0.00% 32,136.00 30,797.00 1,339.00 4.17% Workers Compensation 800.00 122.98% 0.00 0.00 0.00 0.00% 800.00 983.86 (183.86) -22.98% Developer escrow offset cost recovery 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 (15,251.75) 15.251.75 100.00% To break out offset costs per the request of the Finance Comm Office Supplies 2,000.00 63.33% 200.00 0.00 200.00 100.00% 1,800.00 1,266.50 533.50 29.64% Printed Forms 750.00 142.40% 0.00 92.00 (92.00) -100.00% 500.00 1,068.00 (568.00) -113.60% Engineering Services 36,000.00 51.11% 3,000.00 1,500.00 1,500.00 50.00% 33,000.00 18,399.82 14,600.18 44.24% Contract Services 10,000.00 0.00% 0.00 0.00 0.00 0.00% 7,500.00 0.00 7,500.00 100.00% Information Technology 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 1,200.00 46.24% 100.00 66.60 33.40 33.40% 1,100.00 554.86 545.14 49.56% Postage 200.00 67.64% 0.00 0.00 0.00 0.00% 150.00 135.28 14.72 9.81% Mileage 200.00 17.85% 0.00 35.70 (35.70) -100.00% 200.00 35.70 164.30 100.00% Miscellaneous 500.00 55.69% 50.00 0.00 50.00 100.00% 450.00 278.43 171.57 38.13% Dues&Subscriptions 600.00 60.17% 0.00 122.00 (122.00) -100.00% 0.00 361.00 (361.00) -100.00% Books 300.00 0.00% 0.00 0.00 0.00 0.00% 300.00 0.00 300.00 100.00% Conferences&Training 2,000.00 50.68% 0.00 0.00 0.00 0.00% 2,000.00 1,013.64 986.36 49.32% Total Planning&Zoning 273,059.23 84,51% 20,158.41 19,153.07 1,005.34 4.99% 249,500.82 230,766.27 18,734.55 7.51% 1930-Engineering Services Engineering Services 48,000.00 76.22% 4,000.00 3,500.00 500.00 12.50% 44,000.00 36,586.02 7,413.98 16.85% Total Engineering Services 48,000.00 76.22% 4,000.00 3,500.00 500.00 12.50% 44,000.00 36,586.02 7,413.98 16.85% 1940-City Hall Cleaning Supplies 25.00 0.00% 0.00 0.00 0.00 0.00% 25.00 0.00 25.00 100.00% Building Repair Supplies 200.00 179.99% 25.00 0.00 25.00 100.00% 175.00 359.97 (184.97) -105.70% Telephone 2,400.00 40.12% 200.00 62A9 137.51 68.76% 2,200.00 962.90 1,237.10 56.23% Utilities 13,200.00 70.9.5% 1,100.00 696.22 403.78 36.71% 12,100.00 9,365.42 2,734.58 22.60% Refuse 1,408.16 78.02% 108.32 109.78 (1.46) -1,35% 1,299.84 1,098.70 201.14 15.47% Repairs/Maint Contractual Bldg 7,200.00 77.54% 600.00 787.00 (187.00) -31.17% 6,600.00 5,582.93 1,017.07 15.41% Repairs/Maint Contractual Equip 2,400.00 269.24% 200.00 622.50 (422.50) -211.25% 2,200.00 6,461.82 (4,261.82) -193.72% Annex repairs-Yale Mech Miscellaneous 300.00 14131% 0.00 0.00 0.00 0.00% 250.00 423.93 (173.93) -69.57% Total City Hall 27,133.16 8939% 2,233.32 2,277.99 (44.67) -2.00% 24,849.84 24,255.67 594.17 2.39% Total General Government 1 )38,764.98 90.40% 86,175.78 79,446.62 6,729.16 7.81% 957,091.77 939,011.81 18,079.96 1.89% 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.19% 0.00 0.00 0.00 0.00% 250,000.00 255,946.53 (5,946.53) -2.38% Total Police 500,000.00 51.19% 0.00 0.00 0.00 0.00% 250,000.00 255,946.53 (5,946.53) -2.38% 2150-Prosecution Attorney Criminal 51,000.00 88.83% 4,250,00 4,512.50 (262.50) -6.18% 46,750.00 45,301.25 1,448.75 3.10% Total Prosecution 51,000.00 88.83% 4,250.00 4,512.50 (262.50) -6.18% 46,750.00 45,301.25 1,448.75 3.10% 2220-Fire FT Salaries 74,119.04 92.46% 5,701.46 5,712.98 (11.52) -0.20% 68,417.58 68,532.57 (114.99) -0.17% PT Salaries 109,455.98 83.09% 7,618,46 7,719.67 (101.21) -1.33% 101,837.52 90,942.15 10,895.37 10.70% PERA Contributions 119785.11 104.31% 949.39 1,015.35 (65.96) -6,95% 10,835.72 12,293.44 (1,457.72) -13.45% Due to FF rate change effective 1/1/2014 FICA Contributions 11,381.65 44.03% 825.84 425.27 400.57 48.50% 10,555.82 5,011.77 5,544.05 52.52% FF budgeted at normal 6.2%;Full time fire FF rate is zero Medicare Contributions 2,661.84 83.55% 193.14 187.24 5.90 3,05% 2,468.70 2,223.94 244.76 9.91% Health/DentalInsurance 15,990.00 82.13% 1,230,00 1,142.00 88.00 7.15% 14,760.00 13,133.00 1,627.00 11.02% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 91000.00 134.44% 0.00 0.00 0.00 0.00% 9,000.00 12,099.81 (3,099.81) -34.44% Actual rate increase greater than budgeted Office Supplies 500.00 196.41% 50.00 0.00 50.00 100.00% 450.00 982.04 (532.04) -118.23% EMS Supplies 4,900.00 4.66% 0.00 0.00 0.00 0.00% 4,900.00 228.37 4,671.63 95.34% Fire Prevention 3,000.00 1.70% 250.00 0.00 250.00 100.00% 2,750.00 50.92 2,699.08 98.15% Fuel,Oil&Fluids 14,000.00 98.26% 1,100.00 1,251.08 (151.08) -13.73% 12,900.00 12,357.06 542.94 4.21% Small Tools&Equip 22,500.00 36.07% 1,800.00 130.56 1,669.44 92.75% 20,700.00 8,115,14 12,584.86 60.80% YTD includes Themal Imaging camera from Jan Physicals 6,900.00 68.19% 575.00 0.00 575.00 100.00% 6,325.00 4,704.87 1,620.13 25.61% Information Technology 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 661.01 (661.01) -100.00% Telephone 4,200.00 95,24% 350.00 311.03 38.97 11,13% 3,850.00 4,OOO.19 ° Radio 16,203.04 77.87% 0,00 0.00 0.00 0.00% 12,402.28 12,616.63 (214.35) -1.73% Tinning issue;budgeted payment the month after QE Mileage 350.00 8IA1% 50.00 0.00 50.00 100.00% 300.00 284.92 15.08 5.03% Insurance 5,237.00 98.86% 0.00 0.00 0.00 0.00% 5,237.00 5,177.21 59.79 1.14% Fireball#2 charged to PW in error;reclassed in June Electric Utility 21,600.00 52.07% 1,800.00 629.04 1,170.96 65.05% 19,800.00 11,246.07 8,553.93 43.20% Refusc .572.16 313.46% 47.68 258.93 (211,25) -443.06% 524.48 1,793.48 (1,269.00) -241.95% Repair/MaintBldg 12,000.00 1.91.09% 1,000.00 345.04 654.96 65.50% 11,000.00 6,130.79 4,869.21 44.27% Repair/Maint Equip 41,000.00 175.27% 3,500.00 1,723.04 1,776.96 50.77% 37,500.00 71,862.02 (34,362,02) -91.63% Month-Equipment annual inspections;spread out in budget Uniforms 3,000.00 60.85% 250.00 0.00 250.00 100.00% 2,750.00 1,825.40 924.60 33.62% (YTD-Emergency ladder repair bill-$1 I.500) Miscellaneous 900.00 202.75% 100.00 83.02 16.98 16.98% 1,100.00 1,824.72 (724.72) -65.88% Dues&Subscriptions 2,200.00 151.54% 0.00 650.00 (650.00) -100.00% 2,200.00 3,333.80 (1,133.80) -51.54% Books 200.00 51.00% 50.00 0.00 50.00 100.00% 200.00 102.00 98.00 49.00% Conferences&Training 6,000.00 125.72% 500.00 0.00 500.00 100.00% 5,500.00 7,543.40 (2,043.40) -37.15% 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 I 399,655.82 89.21% 27,940.97 21,584.25 6,356.72 22.75% 368,264.10 356,550.34 11,713.76 3,18% 2250-Fire Relief Fire State Aid 37,323.50 143.20% 0.00 0.00 0.00 0.00% 37,323.50 53,446.01 (16,122.51) -43.20% Rec'd supplemental fire aid from state in addition to annual aid Total Fire Relief 37,32350 143.20% 0.00 0.00 0.00 0.00% 37,323.50 53,446.01 (16,122.51) -43.20% 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 85.74% 7,384.00 6,892.91 491.09 6.65% 88,608.00 82,307.26 6.300.74 7.11% PERA Contributions 6,959.42 85.74% 535.34 499.74 35.60 6.65% 6,424.08 5,967.19 456.89 7.11% FICA Contributions 5,951.50 80.57% 457.81 401.65 56.16 12.27% 5,493.70 4,795.05 698.65 12.72% Medicare Contributions 1,391.88 80.56% 107.07 93.92 13,15 12.28% 1,284.82 1,121.31 163.51 12.73% Health/DentalInsurance 24,102.00 67.47% 1,896.00 1,414.00 482.00 25.42% 22,206.00 16,261.00 5,945.00 26.77% 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 181.18% 0.00 0.00 0.00 0.00% 397.88 720.87 (322.99) -81.18% Office Supplies 1,447.44 17.61% 100.00 47.22 52.78 52.78% 1,347.44 254.84 1,092.60 81.09% 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 52.83% 51.36 0.00 51.36 100,00% 414.20 245.95 168.25 40.62% Engineering 10,000.00 78.27% 750.00 0.00 750.00 100.00% 9,250.00 7,826.60 1,423.40 15.39% 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,28I.50 150.95% 400.00 1,036.75 (636.75) -159.19% 2,781.50 4,953.57 (2,172.07) -78.09% Information Technology 4,180.00 353.26% 0.00 179.00 (179.00) -100.00% 4,180.00 14,766.16 (10,586.16) -253.26% 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 115.85% 45.66 58.84 (13.18) -28.87% 502.26 634.74 (132.48) -26.38% Mileage 600.00 80.00% 50.00 174.72 (124.72) -249A4% 550.00 480.02 69.98 12.72% 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% 200.00 213.28 (13.28) -6.64% Uniforms 0.00 0.00% 0.00 0.00 0.00 0.00% 86.38 121.98 (35.60) -41.21% Miscellaneous 500.00 33.96% 100.00 0.00 100,00 100.00% 500.00 169.78 330.22 66.04% Dues&Subscriptions 0.00 100.00% 0.00 0.00 0,00 0.00% 0.00 220.00 (220.00) -100,00% Books 308.24 112.48% 0.00 0.00 0.00 0.00% 308.24 346.71 (38.47) -12.48% Conferences&Training 690.00 95.58% 0.00 0.00 0.00 0.00% 690.00 659.53 30.47 4.42% Total Building Inspections F 157,601.95 90.30% 11,877.24 10,798.75 1,078.49 9.08% 145,711.11 142,313.84 3,397.27 233% 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% Budget vs actual timing issue Total Emergency Communications 5,800.00 59.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 8559% 500.00 500.00 0.00 0.00% 5,342.08 5,000.00 342.08 6.40% Miscellaneous(Impounding) 440.00 343.68% 0.00 333.21 (333.21) -100,00% 390.00 1,512.21 (1,122.21) -287.75% Animal impound fees;recovering funds where possible Total Animal Control 6,282.08 103.66% 500.00 833.21 (333.21) -66.64% 5,732.08 6,512.21 (780.13) -13.61% Total Public Safety 1,157,663.35 74.59% 44,568.21 37,728.71 6,839.50 1535% 859,580.79 863,443.26 (3,862.47) -0.45% 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 86.35% 13,736.00 13,876.37 (140.37) -1.02% 164,832.00 154,194.25 10,637.73 6.45% PT Salaries 0.00 100.00% 0.00 67.50 (67.50) -100.00% 0.00 18,769.47 (18,769.47) -100.00% Extra stall'for snow removal PERA Contributions 12,946.18 94.64% 995.86 1,006.03 (10.17) -1.02% 11,950.32 12,252.38 (302.06) -2.53% FICA Contributions 11,071.00 92.16% 851.63 820.96 30.67 3.60% 10,219.58 10,202.74 16.84 0.16% Medicare Contributions 2,589.24 92.15% 199.17 192.02 7.15 3.59% 2,390.06 2,386.09 3.97 0.17% Heahh/DentalInsurance 42,640.00 78.19% 3,280.00 2,899.00 381.00 11.62% 39,360.00 33,338.50 6,021.50 15.30% 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 115.15% 0.00 0.00 0.00 0.00% 8,000.00 9,211.98 (1,211.98) -15,15% Represents prior year audit balance due;2014 to hit in Sept Office Supplies 300.00 511.34% 25.00 131.98 (106.98) -427.92% 275.00 1,534.03 (1,259.03) 457.83% Shop Materials 600.00 302.33% 50.00 0.00 50.00 100.00% 550.00 1,814.00 (1,264.00) -229.82% Building Repair Supplies 300.00 151.08% 25.00 0.00 25.00 100.00% 275.00 453.24 (178.24) -64.81% Small Tools and Minor Equip 2,400.00 55.34% 200.00 0.00 200.00 100.00% 2,200.00 1,328.21 871.79 39.63% Engineering Services 9,000.00 158.01% 750.00 500.00 250.00 33.33% 8,250.00 14,220.50 (5,970,50) -72.37% Primarily ROW work;majority recovered by ROW fees Contract Services 1,200.00 164.95% 100.00 252.30 (152.30) -152.30% 1,100.00 1,979.40 (879.40) -79.95% Information Technology 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 661.01 (661.01) 0.00% Telephone 7,661.16 82.67% 638.43 736.58 (98.15) -15.37% 7,022.73 6,333.30 689.43 9.82% Radio 1500.00 101.33% 0.00 0.00 0.00 0.00% 1,500.00 1,519.97 ° 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% Fireball#2 Ins charged to PW in error;reclassed in June Electric Utility 24,000.00 74.51% 2,000.00 512.44 1,487.56 74.38% 22,000.00 17,881.54 4,118.46 18.72% Refuse 2,493.84 84.53% 207.82 210.63 (2.81) -1.35% 2286.02 2,108.16 177.86 7.78% Fuel,Oil,Fluids(ALL depts) 48,000.00 75.72% 4,000.00 1,435.85 2,564.15 64.10% 44,000.00 36,346.73 7,653.27 17,39% Repair/Maint Bldg 1,200.00 321.83% 100.00 0.00 100.00 100.00% 1,100,00 3,862.00 (2,762.00) -251.09% Repair/Maint NOT Bldg 600.00 124.05% 50.00 0.00 50.00 100.00% 550.00 744.31 °(194.31) -35.33/0 Repair/Maint Equip(out) 3,600.00 11.76% 300.00 0.00 300.00 100.00% 3,300.00 423.47 2,876.53 87,17% Equipment Parts 0.00 100.00% 0.00 250.00 (250.00) -100.00% 0.00 594.40 (594.40) -100.00% Uniforms 1,200.00 150.38% I00.00 277.51 (177.51) -177.51% 1,100.00 1,804.56 (704.56) -64.05% Miscellaneous 600.00 116.96% 50.00 0.00 50.00 100.00% 550.00 701.73 (151.73) -27.59% 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% 0.00 0.00 0.00 0.00% 250,00 185.00 65.00 26.00% Conferences&Training 500.00 637.40% 0.00 0.00 0.00 0.00% 500.00 3,187.00 (2,687,00) -537.40% 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,269.42 92.55% 27,658.91 23,169.17 4,489.74 16.23% 358,560.71 357,497.27 I,063A4 0.30% 3120-Streets Equipment Parts 1,200.00 250.42% 100.00 0.00 100.00 100.00% 1,100.00 3,005.05 (1,905.05) -173.19% Street Maintenance Materials 12,000.00 178.15% 1,000.00 7,362.88 (6,362.88) -636.29% 11,000.00 21,378.43 (10,378.43) -94.35% Nov=Asphalt purchased for street repair initiative Sign Repair Materials 0.00 100.00% 0.00 23.58 (23.58) -100.00% 0.00 8,463.98 (8,463.98) -100.00% General road sign upgrades needed but not budgeted Contract Services 1,200.00 1701.15% 300.00 3,521.00 (3,221.00) -1073.67% 1,200.00 20,413.76 (19,213.76) -1601.15% YTD-Curbs for tapestry;water drainage issues Repairs/Maint Equipment 2,400.00 20.78% 200.00 420.45 (220.45) -110.23% 2,200.00 498.70 1,701.30 77.33% Total Streets 16,800.00 320.00% 1,600.00 11,327.91 (9,727,91) -607.99% 15,500.00 53,759.92 (38,259.92) -246.84% Detail 7 Full Year MONTH YTD 3125-Ice&Snow Removal BUDGET BUDGET ACTUAL Variance(S) 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 312.11 (312.11) -100.00% 0.00 323.20 (323.20) -100.00% Sand/Salt 70,000.00 64.88% 10,000.00 0.00 10,000.00 100.00% 65,000.00 45,416.16 19,583.84 30.13% Contract Services 20,000.00 50.46% 3,000.00 0.00 3,000.00 100.00% 9,000.00 10,092.50 (1,092.50) -12.14% Repairs/Maint Equipment 6,000.00 127.69% 500.00 203.16 296.84 59.37% 5,500.00 7,661.27 (2,161.27) -39.30% Total let&Snow Removal F 96,000.00 66.14% 13,500.00 515.27 12,984.73 96.18% 79,500.00 63,493.13 16,006.87 20.13% 3160-Street Lighting Street Lighting 28,800.00 71.34% 2,400.00 2,040.29 359.71 14.99% 26,4K00 20,545.56 5,854.44 22.18% Total Street Lighting 28,800.00 71.34%11 2,400.00 2,040.29 359.71 14.99% 26,400.00 20,545.56 5,854.44 22.18% 3200,Recycling Recycling Supplies 3,400.00 153.66% 0.00 0.00 0.00 0.00% 3,400.00 5,224.43 (1,824.43) -53.66% CFL bulbs for residents(coding correction from"mist") 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 70.60% 0.00 0.00 0.00 0.00% 7,400.00 5,224.43 2,175.57 29.40% 3250-Tree Program Contract Services 5,000.00 107.00% 0.00 0.00 0.00 0.00% 6,250.00 5,350.00 900.00 14.40% Total Tree Program 51000.00 107.00% 0.00 0.00 0.00 0.00% 6,250.00 5,350.00 900.00 14.40% Total Public Works 540.269.42 93.63% 45,158.91 37,052.64 8,106.27 17,95% 493,610.71 505,870.31 (12,259.60) -2,48% Detail 8 DEPT 450-CULTURE,RECREATiO Full Ycar MONTH Y7'D 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.62 75.15% 10,150.00 8,901.54 1,248.46 12.30% 126,500.00 101,636.05 24,863.95 19.66% PT Salaries 0.00 100.00% 0.00 1,419.25 (1,419.25) -100,00% 0.00 21,689.80 (21,689.80) -100.00% Extra part time help PERA Contributions 9,906.38 75.28% 735.88 645.36 90.52 12.30% 9,171.25 7,457.84 1,713.41 18.68% FICA Contributions 8,472.90 87.12% 629.30 618.00 11.30 1.80% 7,843.00 7,381.45 461.55 5.88% Medicare Contributions 1,981.28 87.13% 147.18 144.54 2.64 1.79% 1,834.25 1,726.20 108.05 5.89% Heahh/DentalInsurance 14,376.00 23.21% 2,216.00 290.16 1,925.84 86.91% 19,160.00 3,336.84 15,823.16 82.58% 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 96.99% 0.00 0.00 0.00 0.00% 4,500.00 4,364.61 135.39 3.01% Shop Materials 1,000.00 47.12% 0.00 93.81 (93.81) -100.00% 1,000.00 471.24 528.76 52.88% Chemicals 0.00 0.00% 0.00 0.00 0.00 0.00% 1,000.00 262.11 737.89 0.00% Equipment Parts 2,023.50 222.30% 0.00 0.00 0.00 0.00% 2,023.50 4,498.24 (2,474.74) -122.30% 480D radiator repair/service Building Repair Supplies 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 814.89 ° Landscaping Materials 3,000.00 222.02% 0.00 156.00 (156.00) -100.00% 3,000.00 6,660.53 (3,660.53) -122.02% Small Tools and Minor Equip 1,888.10 89.77% 39.87 0.00 39.87 100.00% 1,848.23 1,695.01 153.22 8.29% Telephone 1,597.51 58.77% 180.86 85.16 95.70 52.91% 1,416.65 938.79 477.96 33.73% Mileage 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 74.37 (74.37) 0.00% Insurance 3,683.00 99.67% 0.00 0.00 0.00 0.00% 3,683.00 3,671.00 12.00 0.33% Mo=$500 deductible;tree limb dropped on Cty vehicle Electric Utility 9,839.82 65.08% 919.64 379.45 540.19 58.74% 8,920.18 6,403.68 2,516.50 28,21% Refuse 2,500.00 33.75% 207.82 0.00 207.82 100,00% 2,292.18 843.76 1,448.42 63.19% Repair/Mainl Bldg 1,723.75 25.88% 246.25 38.51 207.74 84.36% 1,477.50 446.15 1,031.35 69.80% Repair/Maint NOT Bldg 274.39 2074.67% 27.25 0.00 27.25 100.00% 247.14 5,692.68 (5,445.54) -2203.42% 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,633.91 (2,633.91) -100.00% Unforeseen repairs on 98 GMC Rental Buildings 3,600.00 143.23% 300.00 0.00 300.00 100.00% 3,300.00 5,156.34 (1,856.34) -56.25% Miscellaneous 1,220.00 103.00% 75.00 0.00 75.00 100.00% 900.00 1,256.65 (356.65) -39.63% Total Parks&Recreation 206,837.25 91.43% 15,875.05 12,771.78 3,103.27 19.55% 200,116.88 189,112.14 11,004.74 5.50% Grand Total all Expenses 2,943,535.00 94.94% 191 777.95 166,999.75 24,778.20 12.92% 2,510,400.15 2,497,437.52 12,962.63 0.52% Subtotal Net Income over Expenses 360,000.00 -103.59% (163,377.95) 32,880.56 146,702.11 -89.79% (617,229.57) (372,939.59) 244,289.98 -39.58% 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 City Projects(Streets) 160,000.00 0.00% 0.00 0.00 0.00 0.00% 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 EXP ALL DEPTS 3,303,535.00 75.60%1 191,777.95 166,999.75 24,778.20 12.92% 2,510,400.15 2,497,437.52 12,962.63 0.52% Net Income over Expenses 0.00 0.00% 163.377.95) 32,880.56 196,258.51 120.13% (617,229.57) (372,939.59) 244,289.98 39,58% Detail 9 City of Lake Elmo Budeet to Actual 2014 By Month As of November 30,2014 206-Library Fund By Department Full Year Month YTD BUDGET 2014 2014 Over/ 2014 2014 Over/ 2014 %to date BUDGET ACTUALS (under) BUDGET ACTUALS (under) Notes REVENUE Current Ad Valorem Taxes 256,957.00 50.00% 0.00 0.00 0.00 128,478.50 128,478.50 0.00 Funds received from WA Cly July and December Rental income 11,400.00 85.98% 550.00 950.00 400.00 10,450.00 9,801.61 (648.39) Interest Earnings 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 Miscellaneous Revenue 0.00 100.00% 0.00 45.00 45.00 0.00 350.00 350.00 Donations 0.00 100.000/0 0.00 130.00 130.00 0.00 2,566.17 2,566.17 Total Revenue 268,357.00 52.62% 550.00 1,125.00 575.00 138,928.50 141,196.28 2,267.78 EXPENSE (Over)/ (Over)/ under under PT Salaries 23,000.00 0.00% 1,916.67 0.00 1,916.67 21,083.37 0.00 21,083.37 No part-time employees hired to date FT Salaries 35,200.00 92.41% 2,933.33 3,460.87 (527.54) 32,266.63 32,530.00 (263.37) 3 pay periods in Oct;budget reflected consistent Monthly amts PERA Contributions 2,552.00 91.17% 212.67 250.91 (38.24) 2,339.33 2,326.74 12.59 FICA Contributions 3,608.40 50,88% 300.70 204.50 96.20 3,307.70 1,835.81 1,471.89 Medicare Contributions 843.60 50.89% 70.30 47.82 22.48 773,30 429.30 344.00 Health/Dental Insurance 13,605.00 75.97% 1,133.75 1,088.00 45.75 12,471.25 10,336.00 2,135.25 Variance due to 3 pay periods in Oct 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% 83.33 0.00 83.33 916.63 0.00 916.63 Library Svcs supplies 0.00 0.000/n 0.00 0.00 0.00 0.00 0.00 0.00 Office Supplies 5,000.00 55.85% 416.67 33.65 383.02 4,583.37 2,792.36 1,791.01 Library Collection Maintenance 20,000.00 118.92% 1,666.67 3,662.60 (1,995.93) 18,333.37 23,783.34 (5,449.97) Legal Services 500.00 91.00% 0.00 0.00 0.00 375.00 455.00 (80.00) Contract Services 4,000.00 4.50% 333.33 0.00 333.33 3,666.63 180.00 3,486.63 Telephone 1t400.00 92.92% 116.67 0.00 116.67 1,283.37 1,300.82 (17AS) Internet 600.00 57.66% 50.00 0.00 50.00 550.00 345.96 204.04 Information Technology(Equino 13,000.00 43.75% 0.00 0.00 0.00 9,750.00 5,687.16 4,062.84 Timing issue;budgeted later in year as paid later in 2013;no cost increase Software 0.00 100.00% 0.00 0.00 0.00 0.00 144.00 (144,00) Insurance 2,500.00 75.11% 0.00 0.00 0.00 2,500.00 1,877.66 622.34 Electric Utility 7,000.00 89.79% 583.33 466.05 117.28 6,416.63 6,285.36 131.27 Refuse 800.00 61.01% 66.67 48.67 18.00 733.37 488.06 245.31 Repair/Maint Bldg 8,000.00 229.18% 666.67 977.07 (310.40) 7,333.37 18,334.14 (11,000.77) JTR roofing$8,545 Repair/Maint NOT Bldg 52,748.00 0.67% 229.00 0.00 229.00 52,519.00 355.00 52,164.00 Repair/Maint Equip(out-LH Iml 2,500.00 0.00% 208.33 0.00 208.33 2,291.63 0.00 2,291.63 Library Card Reimbursements 39,000.00 56.65% 1,500.()0 600.00 900,00 37,500,00 22,094.95 15,405.05 Miscellaneous 30,000.00 2.43% 2,500.00 226.03 2,273.97 27,500.00 729.60 26,770.40 Building Purchase Repmt 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 Building-Property Tax 0.00 100.001/0 0.00 0.00 0.00 0.00 2,526.00 (2,526.00) Other Equipment 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 Subscriptions 0.00 100.00% 0.00 0.00 0.00 0.00 561,55 (561.55) Conferences&Training 0.00 0.000/0 0.00 300.00 (300.00) 0.00 300.00 (300.00) Contingency Monies 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 Internal charges 1,500.00 49.20% 125.00 30.00 95.00 1,375.00 738.00 637.00 $2 per card processing fee plus billable City resources Total Library 268,357.00 50,84% 15,113.09 11,396.17 3,716.92 249,868.95 136,436.81 113,432.14 (No City resources billed to date) Net Income/(Expense) 0.00 14,563.09) (10,271.17) 4,291.92 (110,940.45) 4,759.47 115,699.92 12/31/13 Cash Balance 85,190.43 Net Income/(Expense) 4,759.47 Accrued AP 2,290.83 Ending Cash 11/30/14 92,240.73