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 11 18 14 Oct Financials
City of Lake Elmo 1 1/18/2014 2014 By Month Budget to Actual Comparative For the month ending October 31,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(S) Variance(%) 2014 %to date Month Month Month Month YTD YTD YTD YTD REVENUE Total Revenue 3,303,535.00 56.64% 29,400.00 86,939.77 57,539.77 195.71% 1,864,770.58 1,924,617.62 59,847.04 3.21% EXPENSE Total Mayor&Council 45,269.32 46.75% 75.00 500.00 (425.00) -566.67% 30,966.66 21,162.34 9,804.32 31.66% Total Administration 396,538.62 89.00% 37,105.35 36,721.29 384.06 1,04% 335,403.24 352,911.76 (17,508.52) -5.22% Total Elections 13,350.00 41.59% 3,000.00 0.00 3,000.00 100.00% 10,325.00 5,552.01 4,772.99 46.23% Total Communications 79,129.53 97.60% 6,665.20 8,472.52 (1,807.32) -27.12% 65,697.59 77,232.64 (11,535.05) -17.56% Total Finance 156,285.12 87.04% 14,081.86 13,053.90 1,027.96 7.30% 136,564.64 136,029.54 535.10 0.39% Total Planning&Zoning 273,059.23 77.50% 30,862.60 29,433.80 1,428.80 4.63% 229,342.43 211,613.20 17,729.23 7.73% Total Engineering Services 48,000.00 68.93% 4,000.00 1,342.38 2,657.62 66.44% 40,000.00 33,086.02 6,913.98 17.28% Total City Hall 27,133.16 81.00% 2,283.32 2,937.12 (653.80) -28.63% 22,616.52 21,977.68 638.84 2.82% Total General Government 1,038,764.98 82.75% 98,073.33 92,461.01 5,612.32 5.72% 870,916.08 859,565.19 11,350.89 1.30% DEPT 420-PUBLIC SAFETY Total Police 500,000.00 51.19% 0.00 473.75 (473.75) -100.00% 250,000.00 255,946.53 (5,946.53) -2.38% Total Prosecution 51,000.0() 79.98% 4,250.00 4,512.50 (262.50) -6.18% 42,500.00 40,788.75 1,711.25 4.03% Total Fire 399,655.82 83.94% 40,876.20 27,343.23 13,532.97 33.11% 340,323.13 335,466.09 4,857.04 1.43% Total Fire Relief 37,323.50 143.20% 37,323.50 53,446.01 (16,122.51) 43.20% 37,323.50 53,446.01 (16,122.51) 43.20% Total Building Inspections 157,601.95 83.45% 17,045.34 14,747.12 2,298.22 13.48% 133,833.87 131,515.09 2,318.78 1.73% 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% 550.00 575.00 (25.00) 4.55% 5,232.08 5,679.00 (446.92) -8.54% Total Public Safety 1,157,663.35 71.37% 100,045.04 101,097.61 (1,052.57) -1.05% 815,012.58 826,214,55 (11,201.97) -1.37% Summary_S MONTH YTD BUDGET ACTUAL Variance($) 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% 37,240.25 35,106.58 2,133.67 5.73% 330,901.80 334,328.10 (3,426.30) -1.04% Total Streets 16,800.00 252.57% 1,300.00 1,062.90 237.10 18.24% 13,900.00 42,432.01 (28,532.01) -205.27% Total Ice&Snow Removal 96,000.00 65.60% 2,000.00 4,045.35 (2,045.35) -102.27% 66,000.00 62,977.86 3,022.14 4.58% Total Street Lighting 28,800.00 64.25% 2,400.00 2,022.09 377.91 15.75% 24,000.00 18,505.27 5,494.73 22.89% 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% 42,940.25 42,236.92 703.33 1.64% 448,451.80 468,817.67 (20,365.87) 4.54% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 206,836.63 85.26% 21,982.72 I7,972.95 4,009.77 18.24% 184,241.85 176,340.36 7,901.49 4.29% GRAND TOTAL ALL EXPENSES 2,943,535.00 79.19% 263,041.34 253,768.49 9272.85 3.53% 2,318,622.31 2,330,937.77 (12,315.46) -0.53% SUB TOTAL NET INC OVER EXP 360,000.00 -112.87% (233,641.34) (166,828.72) 48,266.92 20.66% (453,851.73) (406,320.15) 47,531.58 -15.90% 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 ALL DEPTS 3,303,535.00 70.56% 263,041.34 253,768.49 9,272.85 3.53% 2,318,622.31 2,330,937.77 (12,315.46) -0.53% Net Income over Expenses 0.00 0.00% (233,641.34) (166,828.72) 66,812.62 28.60% (453,851.73) (406,320.15) 47,531.58 10.47% Summary-2 City of Lake Elmo 11/18/2014 2014 By Month Budget to Actual Compgrative For the month ending October 31.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 date 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 Cry 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% 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 66.47% 500.00 300.00 (200.00) 40.00% 5,650.00 4,420.00 (1,230.00) -21.77% 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 97.92% 15,000.00 9,453.40 (5,546.60) -36.98% 140,500.00 166,958.45 26,458.45 18.83% 1 new home start Building Re-inspect Fees 0.00 100,00% 0.00 100.00 100.00 100.00% 0.00 600.00 600.00 100.00% Heating Permits 15,600.00 125.15% 1,300.00 2,220.00 920.00 70.77% 13,000.00 19,523.72 6,523.72 50.18% Plumbing Permits 91000.00 180.30% 500.00 2,585.00 2,085.00 417.00% 8,000.00 16,227.19 8,227.19 102.84% 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 124.99% 50.00 60.00 10.00 20.00% 1,891.00 2,488.50 597.50 31.60% Utility Permits(ROW) 11,000.00 209.10% 1,000.00 4,198.20 3,198.20 319.82% 8,000.00 23,001.50 15,001.50 187.52% Due to 1-94 expansion,ROW Burning Permit 3,350.00 40.45% 150.00 45.00 (105.00) -70.00% 3,050.00 1,355.00 (1,695.00) -55.57% Massage Therapy Licenses 150.00 116.67% 0.00 175.00 175.00 100.00% 150.00 175.00 25.00 16.67% Electrical Permit 0.00 100.00% 0.00 471.61 471.61 100.00% 0.00 4,107.04 4,107.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 53,446.01 53,446.01 100.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 I,150.00 655.92% 0.00 1,757.66 1,757.66 100.00% 1,150.00 7,543.13 6,393.13 555.92% DNR trail grooming 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 Ist Zoning&Subdivision Fees 1,250.00 1539.28% 0.00 3,605.00 3,605.00 100.00% 1,000.00 19,240.95 18,240.95 1824.10% Developer zoning exceptions;Conditional Use Permits Plan Check Fees 82,000.00 122.75% 7,000.00 5,383.23 (1,616.77) -23.10% 70,000.00 100,656.96 30,656.96 43.80% Due to commercial activity in September not budgeted Sale of Copies,Books,Maps 206.00 137.74% 0.00 8.25 8.25 100.00% 206.10 283.75 77.65 37,68% Assessment Searches 1,285.00 75.88% 100.00 210.00 110.00 110.00% 1,085.00 975.00 (110.00) -10.14% 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 78.31% 3,500.00 2,860.53 (639.47) -18.27% 41,000.00 37,589.97 (3,410.03) -8.32% Miscellaneous Permits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 8,133.02 8,133.02 100.00% August includes$7,500 for fuel tank permit(Kwik Trip) Miscellaneous Revenue 2,400.00 186.01% 200.00 28.88 (171.12) -85.56% 2,000.00 4,464.35 2,464.35 123.22% Internal Charges 1,600.00 47.88% 100.00 32.00 (68.00) -68.00% 1,400.00 766.00 (634.00) 45.29% 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 58.26% 299400.00 86,939.77 57,.539.77 195.71% 1,864,770.58 1,924,617.62 59,847.04 3.21% Detail-1 Full Year MONTH YTD EXPENSE BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL. Variance(S) Variance 1110-Mayor&Council 2014 %to date Month Month Month Month YTD YTD YTD YTD PT Salaries 25,690.00 50.00% 0.00 0.00 0.00 0.00% 12,845.00 12,845.00 0.00 0.00% FICA Contributions 1,592.78 50.00% 0.00 0.00 0.00 0.00% 796.39 796.39 0.00 0.00% Medicare Contributions 372.54 50.00% 0.00 0.00 0.00 0.00% 186.27 186.27 0.00 0.00% Workers Compensation 300.00 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% 575.00 0.00 575.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 500.00 (500,00) -100.00% 10,514.00 6,574.68 3,939.32 37.47% Includes Memberships;annual LMC paid in September Conferences&Training 1,000.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% 75.00 500.00 (425.00) -566.67% 30,966.66 21,162.34 9,80432 31.66% 1320-Administration FT Salaries 176,384.00 79.50% 20,352.00 19,287.09 1,064.91 5.23% 149,248.00 140,231.16 9,016.84 6.04% PERA Contributions 12,505.02 81.29% 1,334.11 1,398.32 (64.21) -4.81% 10,537.66 10,165.03 372.63 3.54% ICMA Contributions 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 d.00 0.00 0.00% FICA Contributions 10,603.92 77.89% 1,095.88 1,135.56 (39.68) -3.62% 8,92IA9 8,259.67 661.82 7.42% Medicare Contributions 2,479.96 77.89% 256.30 265.57 (9.27) -3.62% 2,086.49 1,931.66 154.83 7.42% Health/DentalInsurance 47,636.00 79.79% 5,430.00 5,430.00 0.00 0.00% 40,204.00 38,010.00 2,194.00 5.46% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 1,000.00 95.38% 0.00 0.00 0.00 0.00% 1,000.00 953.77 46.23 4.62% Office Supplies 6,000.00 90.59% 500.00 458.92 41.08 8,22% 5,000.00 5,435.61 (435.61) -8.71% 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 52.33% 5,000.00 2,837.50 2,162.50 43.25% 50,000.00 31,399.25 18,600.75 37.20% Under budget due to City Clerk ability to cover some activity Newsietter/Website 0.00 100.00% 0.00 0.00 0.00 0.0011/0 0.00 2,224.60 (2,224.60) -100.00% Assessing Services 30,500.00 98.15% 2,000.00 2,500.00 (500.00) -25.00% 21,500.00 29,935.39 (8,435.39) -39.23% Information Technology 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 1,322.02 (1,322.02) -100.00% Comp upgrades appr by CC Contract Services 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 33,923.05 (33,923.05) -100.00% Leg Lobbyist appr by CC&Temp svcs effective August Software Programs 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 2,058.00 (2,058.00) -100.00% Upgrades required;appr by CC Telephone 4,044.72 24.52% 337.06 118.07 218.99 64.97% 3,370.60 991.67 2,378,93 70.58% Postage 4,000.00 67.15% 500.00 500.00 0.00 0.00% 3,000.00 2,686.17 313.83 10.46% Mileage 600.00 37.47% 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,000.00 4,35I A5 (2,351.45) -117.57% 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 258.02% 50.00 138.27 (88,27) -176.54% 500.00 1,548.14 (1,048.14) -209.63% Rent 0.00 100.00% 0.00 2,461.00 (2,461.00) -100.00% 0.00 2,461.00 (2,461.00) -100.00% Dues&Subscriptions 600.00 158.69% 50.00 190.99 (140.99) -281.98% 500.00 952.15 (452.15) -90.43% 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 89.00% 37,10535 36,721.29 384.06 1.04% 335,403.24 352,911.76 (17,508.52) -5.22% 1410-Elections PT Salaries 10,000.00 38.05% 2,500.00 0.00 2,500.00 100.00% 7,500.00 3,804.50 3,695.50 49.27% 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% 375.00 0.00 375.00 100.00% than budgeted Legal Publications/Notification 500.00 0.00% 125.00 0.00 125.00 100.00% 375.00 0.00 375.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% 100.00 0.00 100.00 100.00% 325.00 0.00 325.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 291.25% 150.00 0.00 150.00 100.00% 450.00 1,747.51 (1,297.51) -288,34% WA Cty Ann Elect Mach Calibr Total Elections I3,350.00 41.59% 3,000.00 0.00 3,000.00 100.00% 10,325.00 5,552.01 4,772.99 46.23% Not budgeted since no election scheduled;had to recalibrate machines for special school election. Detail 2 Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 1450-Communications 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 13,390.00 125.56% 1,545.00 2,317.85 (772.85) -50.02% 11,330.00 16,812.87 (5,482.87) 48.39% PERA Contributions 970.78 125.56% 112.01 168.04 (56.03) -50.02% 821.43 1,218.92 (397.49) 48.39% FICA Contributions 830.18 121.80% 95.79 139.45 (43.66) 45.58% 702.46 11011.15 (308.69) 43.94% Medicare Contributions 194.16 121.80% 22.40 32.63 (10.23) 45.67% 164.29 236.48 (72.19) -43.94% Health/DemalInsurance 3,120.00 91.54% 360.00 408.00 (48.00) -13.33% 2,640.00 2,856.00 (216.00) -8.18% Workers Compensation 110.00 101.61% 0.00 0.00 0.00 -100.00% 110.00 111.77 (1.77) -1.61% Newsletter 81000.00 85.06% 0.00 1,716.75 (1,716.75) 100.00% 6,000.00 6,804.81 (804.81) -13.41% Due to timing of newsletters Office Supplies 304AI 402.85% 50.00 456.00 (406.00) -812.00% 254.41 1,226.32 (971.91) -382.03% Info Technology/Web 42,000.00 88.18% 3,500.00 2,635.58 864.42 24.70% 35,000.00 37,035.87 (2,035.87) -5.82% Primarily due to Laserfiche upgrade approved by CC Telephone 1,560.00 44.21% 130.00 69.01 60.99 46.92% 1,300.00 689.74 610.26 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 81.40 218.60 72.87% 3,600.00 4,543.00 (943.00) -26.19% Cable Operations 3,600.00 100.94% 300.00 282.81 17.19 5.73% 3,000.00 3,633.75 (633.75) -21.13% Will be reimb by cable comet; filed quarterly for reimb Conferences 800.00 114.38% 250.00 165.00 85.00 34.00% 500.00 915.00 (415.00) -83.00% Repair/Maint Equipment 50.00 200.00% 0.00 0.00 0.00 0.00% 200.00 100.00 100.00 50.00% Total Communications 79,129.53 97.60% 6,665.20 8,472.52 (1,807.32) -27.12% 65,697.59 77,232.64 (11,535.05) -17.56% 1520-Finance FT Salaries 87,890.00 81.69% 10,140.00 9,387.20 752.80 7.42% 74,360.00 71,792.78 2,567.22 3.45% Due to PTO payout to accounting clerk PERA Contributions 6,37130 79.91% 735.15 680.58 54.57 7.42% 5,391.10 5,084.80 306.30 5.68% FICA Contributions 5,44856 75.79% 628.68 549A9 79.19 12.60% 4,610.32 4,129.26 481.06 10.43% Medicare Contributions 1,274.26 75.78% 147.03 128.52 18.51 12.59% 1,078.22 965.68 112.54 10.44% Health/Dental Insurance 19,936.00 50.75% 2,256.00 1,305.60 950.40 42.13% 16,800.00 10,118.40 6,681.60 39.77% Due to contractor cost savings Unemployment Benefits 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 3,400.45 (3,400.45) -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% 250.00 155.57 94.43 37.77% 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 212.06% 0.00 975.01 (975.01) -100,00% 4,000.00 9,542.85 (5,542.85) -138.57% 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 22.92% 100.00 27.50 72.50 72.50% 1,000.00 275.00 725.00 72.50% Mileage 50.00 0.00% 0.00 0.00 0.00 0.00% 50.00 0.00 50.00 100.00% Miscellaneous 1,000.00 2.53% 50.00 0.00 50.00 100.00% 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% 0.00 0.00 0.00 0.00% 325.00 460.85 (135.85) -41.80% Ehlers conf recommended by City Admin Zuleger Total Finance 156,285.12 87.04% 14,081.86 13,053.90 1,027.96 730% 136,564.64 136,029.54 535.10 0.39% 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 96.09% 18,447.00 21,693.71 (3,246.71) -17.60% 135,278.00 153,627.99 (18,349.99) -13.56% Costs for intern to assist with workload PERA Contributions 11,590.87 88.57% 1,337.41 1,430.34 (92.93) -6.95% 9,807.66 10,266.21 (458.55) -4.68% FICA Contributions 9,912.19 88.05% 1,143.71 1,274.61 (130.90) -11.45% 9,387.24 8,727.74 (340.50) 4.06% Medicare Contributions 2,318.17 88.05% 267.48 298.10 (30.62) -11.45% 1,961.53 2,041.19 (79.66) 4.06% Health/DentalInsurance 34,814.00 80.77% 4,017.00 4,017.00 0.00 0.00% 29,458.00 28,119.00 1,339.00 4.55% 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 (29.75) 29.75 100.00% 0.00 (13,449.72) 13,449.72 100.00% To break out offset costs per the request of the Finance Comm Office Supplies 2,000.00 63.33% 200.00 10.22 189.78 94.89% 1,600.00 1,266.50 333.50 20.84% Printed Forms 750.00 130.13% 0.00 92.00 (92.00) -100.00% 500.00 976.00 (476.00) -95.20% Engineering Services 36,000.00 46.94% 3,000.00 191.10 2,808.90 93.63% 30,000.00 16,899.82 13,100.18 43.67% 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 40.69% 100.00 52.83 47.17 47.17% 1,000.00 488.26 511.74 51.17% Postage 200.00 67.64% 0.00 0.00 0.00 0.00% 150.00 135.28 14.72 9.81% Mileage 200.00 0.00% 200.00 0.00 200.00 100.00% 200.00 0.00 200.00 100.00% Miscellaneous 500.00 55.69% 50.00 0.00 50.00 100.00% 400.00 278.43 121.57 30.39% Dues&Subscriptions 600.00 39.83% 0.00 0.00 0.00 0.00% 0.00 239.00 (239.00) -100.00% Books 300.00 0.00% 100.00 0.00 100.00 100.00% 300.00 0.00 300.00 100.00% Conferences&Training 2,000.00 50.68% 2,000.00 403.64 1,596,36 79.82% 2,000.00 1,013.64 986.36 49.32% Total Planning&Zoning 273,059.23 77.S0% 30,862.60 29,433.80 1,428.80 4.63% 229,342A3 211,613.20 17,729.23 7.73% 1930-Engineering Services Engineering Services 489000.00 68.93% 4,000.00 1,342.38 2,657.62 66.44% 40,000.00 33,086.02 6,913.98 17.28% Total Engineering Services 489000.00 68.93% 4,000.00 1,342.38 2,657.62 66,44% 40,000.00 33,086.02 6,913.98 17.28% 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 111.37 (86.37) -345A8% 150.00 359.97 (209.97) -139.98% Telephone 2,400.00 37.52% 200.00 78.95 121.05 60.53% 2,000.00 900A1 1,099.59 54.98% Utilities 13,200.00 65.68% 1,100.00 588.12 511.88 46.53% 11,000.00 8,669.20 2,330.80 21.19% Refine 1,408.16 70.23% 108.32 109.78 (1.46) -1.35% 1,191.52 988.92 202.60 17.00% Repairs/Maint Contractual Bldg 7,200.00 66.61% 600.00 1,252.25 (652.25) -108.71% 6,000.00 4,795.93 1,204.07 20.07% Repairs/MaintContractual Equip 2,400.00 24331% 200.00 745.94 (545.94) -272.97% 2,000.00 5,839.32 (3,839.32) -191.97% Annex repairs-Yale Mech Miscellaneous 300.00 141,31% 50.00 50.71 (0.71) -1.42% 250.00 423.93 (173.93) -69.57% Total City Hall 27,133.16 81.00% 2,283.32 2,937.12 (653.80) -28.63% 22,616.52 219977.68 638.84 2,82% Total General Government 1,038,764.98 82.75%1 98,073.33 92,461.01 5,612.32 5.72% 870,916.08 859,565.19 11,350.89 1.30% Detail 4 DEP7 420-PUBLIC SAFETY Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) 2100-Police 2014 %to date Month Month Month Month YTD YTD YTD YTD Law Enforcement Contract 500,000.00 51.19% 0.00 473.75 (473.75) -100.00% 250,000.00 255,946.53 (5,946.53) -2.38% Total Police 500,000.00 51,19% 0.00 473.7.5 (473.75) -100.00% 250,000.00 255,946.53 (5,946.53) -2.38% 2150-Prosecution Attorney Criminal 51000.00 79.98% 4,250.00 4,512.50 (262.50) -6.18% 42,500.00 40,788.75 I,711.25 4.03% Total Prosecution 51,000.00 79.98% 4,250.00 4,512.50 (262.50) -6.18% 42,500.00 40,788.75 1,711.25 4.03% 2220-Fire FT Salaries 74,119.04 84.75% 8,552.22 8,569.49 (17.27) -0.20% 62,716.12 62,819.59 (103A7) -0.16% PT Salaries 109,455.98 76.03% 11,427.69 7,641.02 3,786.67 33.14% 94,219.06 83,222.48 10,996.58 11.67% PERA Contributions 11,785.11 95.70% 949.39 1,532.83 (583.44) -61.45% 9,886.33 11,278.09 (1,391.76) -14.08% Due to FF rate change effective 1/1/2014 FICA Contributions 11,381.65 40.30% 1,238.75 393.72 845.03 68.22% 9,729.98 4,586.50 5,143.48 52.86% FF budgeted at normal 6.2%;Full time fire FF rate is zero Medicare Contributions 2,661.84 76.51% 289.71 223.76 65.95 22.76% 2,275.56 2,036.70 238,86 10.50% Health/DentalInsurance 15,990.00 74.99% 1,845.00 1,713.00 132.00 7.15% 13,530.00 11,991.00 1,539.00 11.37% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 9,000.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 14.74 35.26 70.52% 400.00 982.04 (582.04) -145.51% EMS Supplies 4,900.00 4.66% 1,500.00 0.00 1,500.00 100.00% 4,900.00 228.37 4,671.63 95.34% Fire Prevention 3,000.00 1.70% 250.00 50.92 199.08 79.63% 2,500.00 50.92 2,449.08 97.96% Fuel,Oil&Fluids 14,000.00 79.33% 1,100.00 762.05 337.95 30.72% 11,800.00 11,105,98 694.02 5.88% Small Tools&Equip 22,500.00 35.49% 1,800.00 0.00 1,800.00 100.00% 18,900.00 7,984.58 10,915A2 57.75% YTD includes Themal Imaging camera from Jan Physicals 6,900.00 68.19% 575,00 0.00 575.00 100.00% 5,750.00 4,704.87 1,045.13 18.18% 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 87.84% 350.00 310.97 39.03 11.15% 3,500.00 3,689.16 (189.16) -5.40% Radio 16,203.04 77.87% 3,800.76 0.00 3,800.76 100.00% 12,402.28 12,616.63 (214.35) -1.73% Timing issue;budgeted payment the month after QE Mileage 350.00 81A1% 50.00 104.72 (54.72) -109.44% 250.00 284.92 (34.92) -13.97% Insurance 5,237.00 98.86% 0.00 61.21 (61.21) -100.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 49.15% 1,800.00 605.21 1,194.79 66.38% 18,000.00 10,617.03 7,382.97 41.02% Refuse 572.16 268.20% 47.68 258.93 (211.25) -443.06% 476.80 1,534.55 (1,057,75) -221.84% Repair/MaintBldg 12,000.00 48.21% 1,000.00 0.00 1,000.00 100.00% 10,000.00 5,785.75 4,214.25 42.14% Repair/Maint Equip 41,000.00 171.07% 3,400.00 3,849.71 (449.71) -13.23% 34,000.00 70,138.98 (36,138.98) -106.29% Month-Equipment annual inspections;spread out in budget Uniforms 3,000.00 60.85% 250.00 0.00 250.00 100.00% 2,500.00 1,825.40 674.60 26.98% (YTD-Emergency ladder repair bill-$11,500) Miscellaneous 900.00 19352% 100.00 139.45 (39.45) -39A5% I,000.00 1,741.70 (741.70) -74.17% Dues&Subscriptions 2,200.00 121.99% 0.00 0,00 0.00 0.00% 2,200.00 2,683.80 (483,80) -21.99% Books 200.00 51.00% 0.00 0.00 0.00 0.00% 150.00 102.00 48.00 32.00% Conferences&Training 6,000.00 134.06% 500.00 1,111.50 (611.50) -122.30% 5,000.00 8,043,40 (3,043.40) -60.87% Conferences&Training(Reimb) 0.00 -100.00% 0.00 0.00 0.00 0.00% 0.00 (2,526.38) 29526.38 100.00% Reimb segregated out for better tracking Total Fire I 399,655.82 93.94% 40,876.20 27,343.23 I3,532.97 33.11% 340,323.13 335,466.09 4,857.04 1.43% 2250-Fire Relief Fire State Aid 37,323.50 143.20% 37,323.50 53,446.01 (16,122.51) 43.20% 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 379323.50 143.20% 37,323.50 53,446.01 (16,122.51) -43.20% 37,323.50 53,446.01 (16,122.51) -43.20% Detail 5 Full Year MONTH YTD 2400-Building Inspection BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance(S) Variance(%) 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 95,992.00 78.56% 11,076.00 10,339.38 736.62 6.65% 81,224.00 75,414.35 5,809.65 7.15% PERA Contributions 6,959.42 78.56% 803.01 749.60 53.41 6.65% 5,888.74 5,467A5 421.29 7.15% FICA Contributions 5,95150 73.82% 686.71 602.46 84.25 12.27% 5,035.89 4,393.40 642.49 12.76% Medicare Contributions 1,391.88 73.81% 160.60 140.88 19.72 12.28% 1,177.75 1,027.39 150.36 12.77% Health/DentalInsurance 24,102.00 61.60% 2,727.00 2,121.00 606.00 22.22% 20,310.00 14,847.00 5,463.00 26.90% 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 ° Office Supplies 1,447.44 14.34% 100.00 16.92 83.08 83.08% 1,247.44 207.62 1,039.82 83.36% 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% 362.84 245.95 116.89 32.22% Engineering 10,000.00 78.27% 750.00 247.50 502.50 67.00% 8,500.00 7,826.60 673.40 7.92% Surcharge Pmts 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0,00 0.00 0.00% Inspector Contract Services 3,281.50 119.36% 300.00 420.50 (120.50) -40.17% 2,381.50 3,916.82 (1,535.32) -64.47% Information Technology 4,180.00 348.98% 0.00 0.00 0.00 0.00% 4,180.00 14,597.16 (10,407.16) -249,98% Permit Works Software Programs 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 547.92 105.11% 45.66 57.36 (11.70) -25.62% 456.60 575,90 (119.30) -26.13% Mileage 600.00 50.88% 50.00 51.52 (1.52) -3.04% 500.00 305.30 194.70 38.94% 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% 100.00 0.00 100.00 100.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 .400.00 33.96% 0.00 0.00 0.00 0.00% 400.00 169.78 230.22 57.56% 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% 100.00 0.00 100.00 100.00% 308.24 346.71 (38.47) -12.48% Conferences&Training 690.00 95.58% 95.00 0.00 95.00 100.00% 690.00 659.53 30.47 4.42% Total Building Inspections 157,601.95 83.45% 17,045.34 14,747.12 2498.22 13.48% 133,833.87 131,515.09 2,318.78 1.73% 2500-Emergency Communications Contract Services 51800.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 58.16% 0.00 0.00 0.00 0.00% 5,800.00 3,373.08 2,426.92 41.84% 2700-Animal Control Printed Forms 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Contract Services 5,842.08 77.03% 500.00 500.00 0.00 0.00% 4,842.08 4,500.00 342.08 7.06% Miscellaneous(Impounding) 440.00 267.95% 50.00 75.00 (25.00) -50.00% 390.00 1,179.00 (789,00) -202.31% Animal impound fees;recovering funds where possible Total Animal Control 6,282,08 90.40% 550.00 575.00 (25.00) 4.55% 5,232,08 5,679.00 (446.92) -8.54% Total Public Safety 1,157,663.35 71.37% 100,045.04 101,097.61 (1,052.57) -1.05% 815,012.58 826,214.55 (11,201.97) -1.37% Detail 6 DEPT 430-PUBLIC WORKS Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 3100-Public Works 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 178,568.00 78.58% 20,604.00 18,003.64 2,600.36 12.62% 151,096.00 140,317.88 10,778.12 7.13% PT Salaries 0.00 100.00% 0.00 1,075.50 (1,075.50) -100.00% 0.00 18,701.97 (18,701.97) -100.00% Extra staff for snow removal PERA Contributions 12,946.18 86.87% 1,493.79 1,383.23 110.56 7A0% 10,954.46 11,246.35 (291.89) -2.66% FICA Contributions 11,071.00 84.74% 1,277.45 1,114.91 162.54 12.72% 9,367.95 9,381.78 (13.83) -0.15% Medicare Contributions 2,589.24 84.74% 298.76 260.77 37.99 12.72% 2,190.89 2,194.07 (3.18) -0.15% Health/DentalInsurance 42,640.00 71.39% 4,920.00 4,348.50 571.50 11.62% 36,080.00 30,439.50 5,640.50 15.63% 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 467.35% 25.00 18.22 6.78 27.12% 250.00 1,402.05 (1,152.05) 460.82% Shop Materials 600.00 302.33% 50.00 83.76 (33.76) -67.52% 500.00 1,814.00 (1,314.00) -262.80% Building Repair Supplies 300.00 151.08% 25.00 0.00 25.00 100.00% 250.00 453.24 (203.24) -81.30% Small Tools and Minor Equip 2,400.00 55.34% 200.00 119.98 80.02 40,01% 2,000.00 1,32821 671.79 33.59% Engineering Services 9,000.00 152.45% 750.00 2,982.50 (2232.50) -297.67% 7,500.00 13,720.50 (6,220.50) -82.94% Primarily ROW work;majority recovered by ROW fees Contract Services 1,200.00 143.93% 100.00 304.70 (204,70) -204.70% 1,000.00 1,727.10 (727.10) -72.71% 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 73.05% 638.43 582.06 56.37 8.83% 6,384.30 5,596.72 787.58 12.34% Radio 1,500.00 101.33% 0.00 300.03 (300.03) -100.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% Firehall#2 Ins charged to PW in error;reclassed in June Electric Utility 249000.00 72.37% 2,000.00 682.44 1,317.56 65.88% 20,000.00 17,369.10 2,630.90 13.15% Refuse 2,493.84 76.09% 207.82 210.63 (2.81) -1.35% 2,078.20 1,897.53 180.67 8.69% Fuel,Oil,Fluids(ALL depts) 48,000.00 72.73% 4,000.00 (67.91) 4,067.91 101.70% 40,000.00 34,910.88 5,089.12 12.72% Repair/Maint Bldg 1,200.00 321.83% 100.00 0.00 100.00 100.00% 1,000.00 3,862.00 (2,862.00) -286.20% Repair/Maint NOT Bldg 600.00 124.05% 50.00 96.41 (46.41) -92.82% 500.00 744.31 (244.31) 48.86% Repair/Maint Equip(out) 3,600.00 11.76% 300.00 0.00 300.00 100.00% 3,000.00 423.47 2,576.53 85.88% Equipment Parts 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 344.40 (344.40) -100.00% Uniforms 1,200.00 127.25% 100.00 420.21 (320.21) -320.21% 1,000.00 1,527.05 (527.05) -52.71% Miscellaneous 600.00 116.96% 50.00 0.00 50.00 100.00% 500.00 701.73 (201.73) -40.35% Landscaping Material 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 300.00 61.67% 50.00 0.00 50.00 100,00% 250.00 185.00 65.00 26.00% Conferences&Training 500.00 637.40% 0.00 3,187.00 (3,187.00) -100.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 86.55% 37,240.25 35,106.58 2,133.67 5.73% 330,901.80 334,328.10 (3,426.30) -1.04% 3120-Streets Equipment Parts 1,200.00 250.42% 100.00 0.00 100.00 100.00% 1,000.00 3,005.05 (2,005.05) -200.51% Street Maintenance Materials 12,000.00 116.80% 1,000.00 1,062.90 (62.90) -6.29% 10,000.00 14,015.55 (4,015.55) -40.16% Sign Repair Materials 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 8,440,40 (8,440.40) -100.00% General road sign upgrades needed but not budgeted Contract Services 1,200.00 1407.73% 0.00 0.00 0.00 0.00% 900.00 16,892.76 (15,992.76) -1776.97% YTD-Curbs for tapestry($4k),Spray patcher($9k) Repairs/Maint Equipment 2,400.00 3.26% 200.00 0.00 200.00 100.00% 2,000.00 78.25 1,921.75 96.09% and WA Cty Street striping(S3k) Total Streets 16,800.00 252.57% 1,300.00 1,062.90 237.10 18.24% 13,900.00 42,432.01 (28„532.01) -205.27% Detail 7 Full Year MONTH YTD 3125-Ice&Snow Removal BUDGET BUDGET ACTUAL Variance{$) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 2014 %to date Month Month Month Month YTD YTD YTD YTD Landscaping Material 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 11.09 (11.09) -100.00% Sand/Salt 70,000.00 64.88% 0.00 0.00 0.00 0.00% 55,000.00 45,416.16 9,583.84 17.43% Contract Services 20,000.00 50.46% 1,500.00 0.00 1,500.00 100.00% 6,000.00 10,092.50 (4,092.50) -68.21% Mo-equipment repairs in preparation for winter season Repairs/Maint Equipment 6,000.00 124.30% 500.00 4,045.35 (3,545.35) -709.07% 5,000.00 7,458.11 (2,458.11) -49.16% Total Ice&Snow Removal 96,000.00 65.60% 2,000.00 4,045.35 (2,045.35) -102.27% 66,000.00 62,977.86 3,022.14 4.58% 3160-Street Lighting Street Lighting 28,800.00 64.25% 2,400.00 2,022.09 377.91 15.75% 24,000.00 18.505.27 5,494.73 22.89% Total Street Lighting 28,800.00 64.25% 2,400.00 2,022.09 377.91 15.75% 24,000.00 18,505.27 5,494.73 22.89% 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 front"raise") 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 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% 42,940.25 42,236.92 703.33 1.64% 448,451.80 468,817.67 (20,365.87) -4.54% Detail 8 DEPT 450-CULTURE,RECREATIO Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 5200-Parks&Recreation 2014 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 135,250.62 68.56% 13,225.00 12,323.57 901A3 6.82% 116,350.00 92,734.51 23,615.49 20.30% PT Salaries 0.00 100.00% 0.00 1,707.75 (1,707.75) -I00.00% 0,00 20,270.55 (20,270.55) -100.00% Extra part time help PERA Contributions 9,906.38 68.77% 958.81 893.44 65.37 6.82% 8,435.38 6,812.48 1,622.90 19.24% FICA Contributions 8,472.90 79.82% 819.95 836.48 (16.53) -2.02% 7,213.70 6,763.45 450.25 6.24% Medicare Contributions 1,981.28 79.83% 191.76 195.63 (3.87) -2.02% 1,687,08 1,581.66 105.42 6.25% Health/DentalInsurance 14,376.00 21.19% 2,324.00 435.24 1,888.76 81.27% 16,944.00 3,046,68 13,897.32 82.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 4,500.00 96.990/a 0.00 0.00 0.00 0.00% 4,500.00 4,364.61 135.39 3.01% Shop Materials 1,000.00 37.74% 0.00 115.03 (115.03) -100.00% 1,000.00 377.43 622.57 62.26% Chemicals 0.00 0.00% 1,000.00 0.00 1,000.00 100.00% 1,000.00 262.11 737.89 0.00% Equipment Parts 2,023.50 222.30% 1,000.00 0.00 1,000.00 100.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 (814.89) -100.00% Landscaping Materials 3,000.00 216.82% 1,000.00 0.00 1,000.00 -100.00% 3,000.00 6,504,53 (3,504.53) -116.82% Small Tools and Minor Equip 1,888.10 89.77% 39.87 505.86 (465.99) -1168.77% 1,808.36 1,695.01 113.35 6.27% Telephone 1,597.51 53.44% 180.86 85.12 95.74 52,94% 1,235.79 853.63 382.16 30.92% 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 Cry vehicle Electric Utility 9,839.82 61.22% 617.83 314.84 302.99 49.04% 8,000.54 6,024.23 1,976.31 24.70% Refuse 2,500.00 33.75% 207.82 0.00 207.82 100.00% 2,084.36 843.76 1,240.60 59.52% Repair/Maint Bldg 1,723.75 23,65% 0.00 0.00 0.00 0.00% 1,231.25 407.64 823.61 66.89% Repair/Maint NOT Bldg 274.39 2074.67% 41.82 9.99 31.83 76.11% 219.89 5,692.68 (5,472.79) -2488.88% 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,000.00 5,156.34 (2,156.34) -71.88% Miscellaneous 1,220.00 103.00% 75.00 550.00 (475.00) -633.33% 825.00 1,256.65 (431.65) -52.32% Total Parks&Recreation F 206,837.25 85.26% 21,982.72 17,972.95 4,009.77 18.24% 184,241.85 176,340.36 7,901.49 4.29% Grand Total all Expenses 2,943,535.00 79.19% 263,041.34 253,768.49 9,272.85 3.53% 2,318,622.31 2,330,937.77 (12,315.46) -0.53% Subtotal Net Income over Expenses 360,000.00 -112.87% (233,641.34) (166,828.72) 48,266.92 -20.66% (453,851.73) (406,320.15) 47,531.58 -10.47% 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 70.56% 263,041.34 253,768.49 9,272.85 3.53% 2,318,622.31 2,330,937.77 (12,315.46) -0.53% Net Income over Expenses 0.00 0.00% 233,641.34 (166,828,72) 66,812.62 28.60% (453,851.73) (406,320.15) 47,531.58 10.47% Detail 9 City of Lake Elmo Budget to Actual 2014 By Month As of October 31,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 Cry July and December Rental Income 11,400.00 81.15% 950.00 1,350.00 400.00 9,500.00 9,251.61 (248.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 0.00 0.00 0.00 305.00 305.00 Donations 0.00 100.00% 0.00 0.00 0.00 0.00 2,436.17 2,436.17 Total Revenue 268,357.00 52.34% 950.00 1,350.00 400.00 137,978.50 140,471.28 2,492.78 EXPENSE (Over)/ (Over)/ under under PT Salaries 23,000.00 0.00% 1,916.67 0.00 1,916.67 19,166.70 0.00 19,166.70 No part-time employees hired to date FT Salaries 35,200.00 82.58% 2,933.33 5,191.20 (2,257.87) 29,333.30 29,069.13 264.17 3 pay periods in Oct;budget reflected consistent Monthly amts P ERA Contributions 2,552.00 81.340/a 212.67 376.35 (163.68) 2,126.67 2,075.83 50.84 FICA Contributions 3,608.40 45.21% 300.70 312.17 (11,47) 3,007.00 1,631.31 1,375.69 Medicare Contributions 843.60 45.22% 70,30 73.01 (2.71) 703.00 381.48 321.52 Health/Dental Insurance 13,605.00 67.98% 1,133.75 1,632.00 (498.25) 11,337.50 9,248.00 2,089.50 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 833.30 0.00 833.30 Library secs supplies 0.00 0.000/0 0.00 0.00 0.00 0.00 0.00 0.00 Office Supplies 5,000.00 55.17% 416.67 0.00 416.67 4,166.70 2,758.71 1,407.99 Library Collection Maintenance 20,000.00 100.60% 1,666.67 200.00 1,466.67 16,666.70 20,120.74 (3,454.04) Legal Services 500.00 91.00% 0.00 104,00 (104.00) 375.00 455.00 (80.00) Contract Services 4,000.00 4.50% 333.33 0.00 333.33 3,333.30 180.00 3,153.30 Telephone 1,400.00 92.92% 116.67 I26.99 (10.32) 1,166.70 1,300.82 (134.12) Internet 600.00 57.66% 50.00 38.44 11.56 500.00 345.96 154.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.000/0 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 83.13% 583.33 543.72 39.61 5,833.33 5,819.31 14.02 Refuse 800.00 54.92% 66.67 48.67 18.00 666.70 439.39 227.31 Repair/Maint Bldg 8,000.00 216.96% 666.67 315.00 351.67 6,666.70 17,357.07 (10,690.37) JTR roofing$8,545 Repair/Maint NOT Bldg 52,748.00 0.67% 229.00 0.00 229.00 52,290.00 355.00 51,935.00 Repair/Maint Equip(out-LH Iml 2,500.00 0.00% 208.33 0.00 208.33 2,083.30 0.00 2,083.30 Library Card Reimbursements 39,000.00 55.12% 1,500.00 1.260.00 240.00 36,000.00 21,494.95 14,505.05 Miscellaneous 30,000.00 1.65% 2,500.00 0.00 2,500.00 25,000.00 493.57 24,506.43 Building Purchase Repmt 0.00 0.000/0 0.00 0.00 0.00 0.00 0.00 0.00 Building-Property Tax 0.00 100.00% 0.00 1,263.00 (1,263.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 0.00 0.00 0.00 0.00 0.00 Contingency Monies 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 Internal charges 1,500.00 47.20% 125.00 32.00 93.00 1,250.00 708.00 542.00 $2 per card processing fee plus billable City resources Total Library 268,357.00 46.59% 15,113.09 11,516.55 3,596.54 234,755.90 125,030.64 109,725.26 (No City resources billed to date) Net Income/(Expense) 0.00 (14,163.09) (10,166.55) 3,996.54 (96,777.40) 15,440.64 112,218,04 12/31/13 Cash Balance 85,190.43 Net Income/(Expense) 15,440.64 Ending Cash 10/31/14 100,631.07