Loading...
HomeMy WebLinkAbout#3 CC 9.1.15 July Financials_GF and LIBCity of Lake Elmo 2015 By Month Buckle( to Actual Comparative For the month endive July 3 I, 2015 101-General Fund Summary By Department DEPT 410 - GEN'L GON"T REVENUE Total Revenue Full Year BUDGET 2015 3,798,334.00 'Xi to date 5I.23% E XPEN SE Total Nlavor & Council 40,955.00 69,33% Total Administration 407,316.00 72.04% Total Elections 1,050.00 206.76% Total Communications 70,842.00 37.81% Total Finance 134,647.00 58.09% Total Planning & Zoning 224,218.00 60.76% Total Engineering, Services 54,800.00 49.64% Total City Hall 50,235.00 75.74% Total General Government 984,063.00 64.07% DEPT 420 - PUBLIC SAFETY Total Police 517,799.00 50.92% Total Prosecution 50,000.00 64.23% Total Fire 385,312.00 52.27% Total Fire Relief 37,323,00 0.00% Total Building Inspections 323,558.00 30.99% Total Emergency Communications 7,000.00 53.50% Total Animal Control 6,800.00 64.56"/0 Total Public Safety 1,327,792.00 45.61% 8/18/2015 MONTH YTD BUDGET ACTUAL Variance (S) Variance (%) BUDGET ACTUAL Variance (S) Variance 0/0 Month Month Month Month YTD YTD YTD YTD 1,432,806.75 1,445,636,59 12,829.84 0.90% 1,960,877.25 1,945,933.1(1 (14,944.15) -0.76% 14,827.66 697.02 14,130.64 95.30% 21,877.66 28,393.77 (6,516.11) -29.78% 28,937,37 40,275.84 (11,338.47) -39.18% 249,492,87 293,428.76 (43,935.89) -17.61% 0.00 0.00 0.00 0.00% 1,000.00 2,171.03 (1,171.03) -117.10% 4,887.77 2,228.88 2,658.89 54.40% 40,383.27 26,785.62 13,597.65 33.67% 7,858.23 8,350.63 (492.40) -6.27% 89,776.73 78,219.79 11,556.94 12.87% 17,555.63 19,079.84 (1,524.21) -8.68% 130,174.62 136,244.57 (6,069,95) -4.66% 4,600.00 2,837.85 1,762.15 38.31% 31,800.00 27,204.10 4,595.90 14.45% 4,161.00 4,771.82 (610.82) -14.68% 29,455.00 38,046.25 (8,591.25) -29.17% 82,827.66 78,241.88 4,585.78 5.54% 593,960.15 630,493.89 (36,533,74) -6.15% 0.00 0.00 0.00 0.00% 258,899.50 263,645.09 (4,745.59) 4,200.00 4,512.50 (312.50) -7.44% 29,300.00 32,112.50 (2,812.50) -9.60% 27,250.47 28,085.85 (835.38) -3.07% 228,679.97 201,412.66 27,267.31 11.92°/0 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% 48,199.08 13,140.28 35,058.80 72.74% 192,525.58 100,262.20 92,263.38 47.92% 0.00 0.00 0.00 0.00% 3,500.00 3,745.00 (245.00) 565.00 550.00 15.00 2.65% 3,955.00 4,390.00 (435.00) -11.00% 80,214.55 46,288.63 . 33,925.92 42.29% 716,860.05 605,567.45 111,292.60 15.53% Summary_ MONTH YTD BUDGET ACTUAL Variance (S) Variance 0/0 BUDGET ACTUAL Variance (S) Variance (%) DEPT 430 - PUBLIC WORKS Month Month Month Month YTD YTD YTD YTD Total Public Works 380,195.00 52.84% 25,907.69 20,691.93 5,215.76 20.13% 230,365.19 200,910.67 29,454.52 12.79% Total Streets 222,578.00 83.17% 5,760.00 150,173.30 (144,413.30) -2507.18% 210,398.0(1 185,127.111 25,270,99 12,01"/0 Total Ice & Snow Removal 95,500.00 35.15% 1,350.00 0.00 1,350.00 100.00% 53,950.00 33,564.47 20,385.53 37.79% Total Street Lighting 28,000.00 47.35% 2,350.00 2,019.88 330.12 14.05% 16,450.00 13,257.55 3,192.45 19.41% Total Recycling 9,500.00 5.98% 500.00 0.00 500.00 100.00% 5,250.00 568.03 4,681.97 89.18"/e Total Tree Program 6,000.00 0.00% 500.00 0.00 500.00 100.00% 3,500.00 0.00 3,500.00 100.00% Total Public Works 741,773.00 58.43% 36,367.69 172,885.11 (136,517.42) -375.38°/it 519,913.19 433,427.73 86,485.46 16.63`)/0 DEPT 450 - CULTURE, RECREATION Total Parks & Recreation 153,028.00 91,27°/0 IT & Telephone 109,560.00 43.08% GRAND TOTAL ALL EXPENSES 3,316,216.00 55.98% SUB TOTAL NET INC OVER EXP 482,118.00 18.58% DEPT 460 - CONIP ADJ 35,000.00 0.00% DEPT 490 - CONTINGENCY FUND 0.00 0.00% Debt Service increase 247,118.00 0.00% DEPT 493 - OTH FINANCING 200,000.00 0.00% GRAND TOTAL ALL DEPTS 3,798,334.00 48.87% Net Income over Expenses 0.00 0.00% 11,310.74 20,864.47 (9,553.73) -84.47% 91,304.70 139,668.27 (48,363.57) -52.97% 6,388.00 7,829.43 (1,441.43) -22.56% 69,166.00 14,198.24 21,967.76 31.76% 217,108.64 326,109.52 (109,000.88) -50.21"/0 1,991,204.09 1,856,355.58 134,848.51 6.77% 1,215,698.11 1,119,527.07 (96,171.04) 7.91% (30,326.84) 89,577.52 119,904.36 _ 395.37% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% 0.00 0,00 0.00 0,00% 0.00 0,00 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% 217,108.64 326,109.52 (109,000.88) -50.21% 1,991,204.09 1,856,355.58 134,848.- 51 6.77% _ 1,215,698.11 1,119,527.07 (96,171.04). 7.91(1/0 (30,326.84) 89,577,52 119,904.36 395.37% S umm a ry_2 Cite of Lake Elmo 21)15 By Month Budeet to Actual Conmarative For the month ending July 31, 2015 101-General Fund Detail I3v Department DEPT 410 - GEN' L GOV'T REV EN UE Current Ad Valorem Taxes Delinquent Ad Valorem Taxes Mobile Florae Tax Fiscal Disparities Penally & Interest on Taxes Liquor License Wastchauler License General Contractor License Heating Contractor License Blaektopping Contractor License Building Permits Building Re -inspect Fees Heating Permits Plumbing Permits Sewer Permits Animal License Utility Permits (ROW) Burning Permit Massage •therapy Licenses Electrical Permit Homestead Credit Aid MSA-Maintenance State Fire Aid PERA Aid Gravel Tax Recycline. Gran( Misc State Grant/Surcharge Rev Cable Franchise Revenue Zoning & Subdivision Fees Plan Check Fees Sale of Copies. Books, Maps Assessment Searches Clean Up Days Cable Operation Reimbursement Fines Miscellaneous Permits Fire Billable Revenue Miscellaneous Revenue Internal Charges Interest Earnings Donations Tutal Revenue Full Year BUDGE 1 2015 2,531,080.00 15,000.110 11,400.00 160,000.00 700.00 8,350.00 1,680,00 0.00 2,5(10.00 0.00 517,600.01.1 1,001400 29,040.00 29,040.00 10,560.00 2,500.00 5,000.00 2,250.00 150.00 6,051 .00 0.00 101,696.00 41,500.00 2,749.00 0,00 15,500,00 500.00 45,000.00 7,500.00 181,923.00 175,00 750,00 2,000.00 2,500.00 48.000.00 0.00 500.00 3,500,00 640.00 10,000.00 0.00 3,798,334,00 BUDGET o 10 dale Month 45,80% 168,99% 56-33% 69.25% 160.65% 97.60"/o 28.57% 0.00% 96.00% 0.00% 39.11"/o 0.00% 56.40% 68.60"/o 0.00% 77.04% 443.42% 56.44"/o 16.67% 84.49% 0,00% 117.47% 0.00% 50.00% 0.00% 0.00% 136.96% 151.40% 273.87% 62.79% 35.71% 170.0no 180.7.5"/o 32.03% 54..58% 0.00% 100.00% 157.41% 63.44% 0.00% 0.00°/o 1.265,540.00 7,50(1.00 5.700.00 80,000.00 350.00 MOO 0.00 0.00 200.00 0.00 43,130.00 100.00 2,420.00 2,420.00 880,00 4(1.00 1,000,00 500,00 0.00 500,00 0,00 0.00 0.00 1,374.50 0.00 0.00 0.00 0,00 1,500.00 15.160.25 20.00 150.00 0.00 0.00 4,000.00 0,00 0,0(1 300,01) 22,00 0.00 0.00 5 f.7.3% 1,432,8116.75 8/13/2015 MONT1-1 ACTUAL Valiance (8) Month Month 1.'ariance (0,) BUDGET Month YID VT D ACTUAL Variance (S) Variance (°1,) YTD YTD 1,159,178.20 (106.361.301 -8.40% 1.265,540.00 1,159,178.2(1 (1)16,361.8(1) 25,347.86 17,847.36 237,970;0 7,500.00 25,347.86 17,847,86 6,421.42 721.42 12.66% 5.700,00 6,121.42 721.42 110,796,92 30.796.92 38.50% 80,000.00 110,796.92 30.796,92 1.124.58 774.53 221.3106 350.00 1.124.53 774.58 0,00 0.00 0.00% 5,350,00 S.150.00 2,300.00 0.00 0,00 0.00% 840.00 480.00 (36)1,00 (1.00 0.00 0.0056 0,00 0.00 0.00 200.00 0.00 0.00% 1,500.00 2,400,00 900.00 0,00 0.00 0.00% 0.00 1600 0.00 38,883.35 (4,246.65) -9.85% 301,910.00 202,446.41 (99,463.59) 0.00 (100.00) -100,0096 60(1,00 0,00 (600.0))) 1,320,00 (1.100,00) -45.45% 16,940.00 16,377,45 (562.55) 4,440,00 2.020.00 83.47,0 16,940,00 19,922.00 2.982.00 0.00 (830.00) -100,00% 6.160,00 0.00 (6,160.00) 20.00 (20.00) -50.00% 2,300.00 1,926,1)0 (374.00) 3,648.60 2,643.60 264.86% 3,000.00 22.171.00 19,171.00 45,00 (455.00) -91,00% 1,000.00 1,270,00 270.00 0.00 0.00 0.006o 75,00 25.00 (50.00) 1,374.61 874,61 174.92% 3,500.00 5,112,37 1,612,37 0.00 0,00 0,00% 0.00 0.00 0,00 59,732,00 59,732.00 100.0050 50,343.00 119,464.00 68.616,00 0.00 0.00 0,00% 0.00 0.00 0.00 1,374,50 0.00 0.00% 1,374,50 1,374.50 0,00 0.00 0,00 0.0050 0,00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 380.36 330.36 100,0086 250.00 684,80 434.80 0.00 0.00 0.0056 45,000,00 63,129.10 23,129.10 5,050.00 3,550,00 236.67°,0 3,750.00 20,540.00 16,790.00 20.778.37 5,613,12 37.06°, 106,121.75 1(4,224,33 8302.53 0.00 (20,00) -100.00% 75.00 62.51) (12.5))) 330,00 130.00 120,00% 465.00 1.275.00 810.00 0.00 0.00 0,0056 2,000.00 3,615.00 1,615,00 300.63 800,63 100.005,-0 1.250,00 800.63 (449.37) 4,373.69 373.69 9.34% 23.000,00 26,198.53 ((,801,42) 2.50 2.50 100,00% 0.00 0,00 0,00 0.00 0.00 0,00% 0.00 500,00 500.00 0.00 (300.00) -100.00% 2,000,00 5,509.45 3.509.45 14.00 (8,00) -36.36% 533.00 406.00 1(32,00) 0.00 0.00 0,00% 0,00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 1.445,636.59 12, 9114 41,911% 1,96(1,877.25 1,945,933.19 (14,9-14.15) YTD variance notes 237,97% 12.66°0 38.50% 221.31% 52.34°,) -47.86% 0.00% 60.006 0.00% -32.941-0 13 new home permits in July: YTD at 58 new homes (8 Open space) -100.00% -3.32% 17,60% -100.00% -16.26% 639.0350 Driven by development activity 27,00% 46.07% 0.00°-.0 134.945'0 MSA funding increase for 2015: 2nd prat budgeted Aug. rce'd July 0.00°/() 0.00°, 0.1)011, 173.929'. Represents quarterly surcharge timely tiling credit 51,40% 447.73% Very few zoning pennits budgeted in 2015 7.64% -16.67% 174,19% 80.75% -35.95°-,) -6.43% Fines below average but rx-pically increase in the 51)60001001er 0.00% 100.00% 175.47°0 -24.54% 0.00% 0.00% Detaill Full Year MONTH YT10 F.X PENNE BUDGET BUDGET ACTUAL Variancc (S) Variance (%) BIJDGET ACTUAL \/ariance (),) Variatic0 (%) 1110 - "Muyor & Council 2015 % to date Month Month Month Month YID vrD yip 111 D P1 Salaries 25,690.00 50.00% 12.845.00 0.00 12.345,00 100.00° ii 12.845.0(1 I ',845.00 0.00 11.00% FICA Contributions 1,593.011 49.99% 796.39 0.00 796.39 100.00% 796,39 796.39 0.00 0.00% Medicare Contributions 372,00 50.07% 136.27 0.00 186.27 100.00% 186.27 136,27 0,00 0,00°n Workers Compensation 300.00 29.66% 0.011 0.00 0.00 0.000i, 300.00 33,97 211.03 70.34°0 Mileage 500.00 33.83% 0.00 77.60 (27.60) -1(10.00% 250.01) 169.16 80.3.4 32.34% Miscellaneous 0.00 100.01101/0 0.00 7_50 (7 .,511) -I 00 .001 ii 0.00 211.54 (211.54) -1(10.00% Dues 8: Subscriptions 11,500.00 113.88% 1.000.00 661.92 333,03 33.8 I'0, 7,000.00 13,096.44 (6.096,44) -37.09°6 2015 share of INC annual Pint made in Sept 2014 plus Conferences & Training 1,000.00 100.00%. 0.00 0.00 0.00 0.00°'s 500,00 1.000.00 (50)),00) -1011.00% annual YSB payment Total 11 luyur & Cl)(11161 40,955.00 6933% 14,827.66 697.02 14.130,64 95.30% 21,877.66 28,393.77 (6,516.11) -29,78V,, 1320 - Administration FT Salaries 198,125.1)0 61.55% 15.240.33 24,135.83 (8.945.45) -53.70% 114,307.88 121,949.15 (7,646.20) -6.690i, Variance is a resultof PTO payouts to prior employee's PERA Contributions 14,364.00 57.56% 1,104,92 362.6S 242,24 21.92% 8,286,92 3.267.43 19.49 0.24% ICN.LA Coutributions 0.00 0.00% 0.00 0.00 0,00 0.0000 0.00 0,00 0,00 0.00'0 FICA Contributions 12,284.00 59.80% 944.92 1.479.83 (534.96) -56,61% 7,086.92 7,345.46 (2)8,54) -3,65% Medicare Contribuiions 2,873.00 59.80% 221.00 346.10 (125.10) -56.010ii 1.657.50 1.717.96 (60.46) -3.65% Health/Dental Insurance 44,865.011 55.66% 3,451.15 2,532.00 919.15 26.63% 25.383.65 24.974.00 909.65 3.5100 Unemployinent Benefits 0.00 0.00°A 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 (1.00% Workers Compensation 1,000.00 106.24% 0,00 0.00 0.00 0,0(010 1,000.00 1,062.37 (62.37) -6.24% Office Supplies 5,500.00 65.34% 450.00 648.47 ((93.47) -44.10°A 3,150,00 3,593,62 (443,62) -14.03% Printed Forms 0,00 100.00% 0.00 1.058,00 (1,053,00) .100,000,, 0,00 1.620.00 (1.620.00) -100.00% Legal Services 45,1100.00 125.55% 3,750.00 6.035.71) (2,285.7(1) -60.95% 26.250.00 56.498,04 (30,248.04) -115.23% Newsletter/Website 0.00 0.00% 0.00 0.00 0.00 0,00',, 0.00 0.00 0.00 0,000-0 Assessing SeniCC5 32,00(1.00 73.41%, 2.500.00 2.500,00 0.00 0.0000 17.500.00 23,490.88 (5,990.38) -34.23% May expense includes WA assessor fees budgeted later in the year Contract Services 0.111) 0.00% 0,00 0.00 0.00 0,00°a 0.00 0.00 0,00 0.00% Postage 2,000.00 104,22% 0.00 0.00 0.00 0,00% 1.000,00 2,034.36 (1,084,36) -108.445; Timing issue Mileage 500.00 14.10% 50.00 0,00 50.00 100.0000 300.00 70.49 229.51 76,50% Legal Publishing 5.0110.00 75.34% 500.00 416,63 83.37 16.67°0 3,000.00 3,767.12 (767,12) -25.57% Insurance 35,000.00 93.10% 0.00 11.101 0,00 0.01)0, 35,000,110 32.586.00 2.414.00 6,9090 ('able Operation Expense 0.00 0.00°/0 0.00 (1.00 0,00 0.000, 0.00 0.00 0.011 0,0000 Miscellancous 6110.00 60.01% 50.00 90,55 (4)),55) -81,10% 350,00 360.03 (10.)13) Dues & Subscriptions 2,105.00 73.58% 175.00 120.00 55.00 31.43% 1.225.00 1,548.96 (323.96) -26.45% Books 0.00 100.00% 0.00 0,00 0.00 0,00% 0.00 131.39 ((31,89) .100.00$0 Conferences & Traininti. 6,100.00 38.70% 500,00 0.00 500.00 100.00% 3,500.00 2.361,00 1.139.00 30.540-0 Staff Development 0.00 0.00% 0.00 0.00 0.00 (1.00% 0.00 0.00 0.00 0.0011'0 Total Administration 4)17,316.00 72.04°/0 28,937.37 40,275.84 (11,338.47) -39.18% 249,492,87 293,428,76 (43,935.89) -17.610/o 1410 - Elections PT Salaries 0.00 100.00% 0.00 0.00 0.00 0.00% 0.00 1,280,00 (1,230.00) -100.00% Office Supplies 0.00 0.00% 0.00 0.110 0.00 0,00', 0,00 0.00 0.00 0.00°0 Legal Publications/Notification 0.011 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% Equipment Repair 0.00 100,00% 0.00 0.00 0.00 0.00% 0.00 600.00 (600.00) -100.00°,0 County Election Fees 950.00 0.011/0 0,00 0,00 0.00 0.000, 950,00 0,00 950.00 100.00% Printed Forms 0.00 0.00% 0,00 0.00 0.00 0,000, 0.00 0,00 0.00 0.00% Miscellaneous 100.00 291.03%. 0.00 0.00 0.00 0.00% 50.00 291,03 (241,03) -43.2.0600 Total Elections 1,050.00 206.76% 0.00 0.00 0.011 0.00°/,, 1,0011.00 2,171,03 (1,171.03) -117.10% Detail_2 Full Year MONTH YTD BUDGET 1311DGET AcTuAL Variance (S) Variance 001 BUDGET ACTUAL Variance(S) Variance (%) 1450 - Communications 21115 % to date Month Month Month Month YID YTD YTD YTD vr Salaries 35,876.00 32.72% 7,759.69 0.00 2,759,69 100.00% 21).697,69 11.739,09 8,958.60 43.280o PERA Contributions 2,601.00 27.11% 2011.08 0.00 200.08 100.009b 1,,500.58 705.10 795,4S 53.019-6 FICA Contributions 2,224.00 32.07% 171,08 0.00 171.08 100.00% 1.283.08 713.13 569.95 44.420.fs Medicare Contributions 520,00 32.08% 40.00 0.00 40.00 100,00°-i, 300,00 166.80 133.20 44.40% Health/Dental Insurance 9,970.011 36.83% 766.92 0.00 766.92 1 oomno ',,, 5,751.92 3.672.00 2.079.92 36.16% Workers Compensation 0.011 100.00% 0,00 0,00 0.00 0,009 o 0.00 177.91 (177.9)) -100.00°0 Newsletter 8,1100,00 66.1.2`Ya 0.00 1.853.88 (1,853.88) -100.00% 4.000.00 5,289.83 (1.289.83) Office Supplies 561.00 8.65% 50,00 0.00 50.00 100.00' /, 350,00 48.50 301.50 86.14% Mileage 100.00 0.00% 0.00 0.00 0.00 0.00% 50.00 37.27 (7.27) •14.54% Public Notices 5,040.00 31.48% 500,00 0.00 500.00 100,00% 2,850.00 1.586,84 1.263,16 44.32% Cable Operation, 4,800.00 47.27% 400,00 375.00 25.00 6.25% 2.800.00 2.269.15 530.85 18.9Vs Conferences 700.00 31.43% 0.00 0.00 0.00 0.00% 350,00 360.00 (10,00) -2.86% RepairThlaint Equipment 450,00 0.00% 0.00 0.00 0.00 0.00%, 450.00 0.00 450.00 100.00% Total Communications 70,842.00 37.81% 4.887.77 2,228.88 2,658.89 54,40°/ 40,383.27 26,785.62 13,597.65 33.67'14 1520 - Finance FT Salaries 66,863.00 52.57°/ 5.143.31 4,632.32 510,99 9,94°,6 38,574.81 35,152.87 3.421.94 8.870) PT Salaries 3,600.00 0.00% 276.92 0.00 276.92 100.000.0 2,076,92 0.00 2,076,92 100.00°i, PERA Contributions 4,848.00 54.38% 372,92 347.43 25.49 6.84% 2,796,92 2,636.49 160.43 5.740. FICA Contributions 4,369.00 47.07% 336.08 272.09 63.99 19.04% 2.520,58 2,056,70 463,88 18.400. Medicare Contributions 1,1122.00 47.06% 78.62 63.62 15.00 19.080.) 589.62 480.92 108,70 18.44% Health/Dental Insurance 14,955.0(1 43.65% 1,150.38 870.40 279.98 24,349) 9627.8S 6,528.00 2.099,83 24,34% Unemployment Benefits 3,000.00 0.00% OA 0,00 0,00 I M00% 3.000.00 0.00 3,000.00 100.000.) Workers Compensation 5(1(1.00 81.52% 0.00 0.00 0.00 0.00% 250.00 407.61 ((57.61) -63.04rfs Office Supplies 500.00 176.90% 0,0)) 65.OS (65,08) -100,00% 250.00 884.52 (634.52) -253.81% Annual check stock re -order Printed Forms 500.00 11.0110/ 0,00 0,00 0.00 0.000.) 250.00 0.00 250.00 100,00% Audit Services 27,000,00 94.24% 0.00 1,320.00 11,320.001 -100.00% 27,000.00 25,445.00 1,555.00 5.769.6 Fieldwork completed and billed earlier than anticipated in budget Contract Services 6,000.00 70.02% 500.00 779.69 (279.69) -55.94% 3,500.00 4.201.12 (701.12) -20.030.o Will decrease now that audit substantially completed Mileage 50.00 0.00"/0 0.00 0.00 0.00 0.009-, 0.00 0.00 0,00 0,000.) Miscellaneous 200.00 128,28% 0.00 0.00 0.00 0.000 100.00 256.56 ((56.56) -)56.569.0 Dues & Subscriptions 740.00 22.97% 0.110 0.00 0,00 0.00% 240.00 17(1.00 70.00 29.1790 Conferences & Training 500.00 0,00°/o 0.00 0.00 0.00 0.008 0,00 0.00 0.00 0,009 Total Finance 134,647.00 5-8.09% 7,858.23 8,350.63 (492.40) -6.27% 89,776.73 78,219.79 11,556.94 12.87% Detail_3 1910- Planning & Zoning FT Salaries PT Salaries I'LRA Contributions FICA Contributions Medicare Contributions HealthiDental Insurance Workers Compensarion Developer escrow offset cost recovery Office Supplies Printed Font's Engineering Seri -ices Contract Services Posiage Mileage Miscellaneous Dues & Subscriptions Books ConEerenccs & Training Total Planning & Zoning 1930 - Engineering Services Engineering Services Total Engineering Services 1940 - City Hall Cleaning Supplies Building Repair Supplies Utilities Refuse Repairs/main Contractual Bldg Repairs/10aint Contractual Equip Facility Lease Miscellaneous Tutal City Will Total General Government Full Year NioN-ril BU13GET BUDGET AC.-1-1.1A( Variance (S) Variance (%) BUDGET 2015 ..0 to date Month Month Month Month YTD 152,354.00 65.80% 11,825.31 13,780.44 ( I .95.5.13) -16.53°, 88,002.31 3,600.00 0.00% 276,92 0,00 276.92 100.00% 2,076.92 9,849,00 68,37% 757,62 1,280.90 (523.28) -69.07% 5,682.1 2 8,646,00 59,02% 665.09 714,34 (49.25) -.7.4 I'l0 4.988.08 2,022.00 58.03% 155.54 167.08 (11.54) -7.42.40 1.166.54 32,047,01) 62.674 2.465,15 2,678.00 (212.85) -8.63% 18,488.65 800.00 1110.76% 0.00 0.00 1301) 0.000 800,00 (16,500.00) 76.41% ( 1.375.00) ( 4551.55) 176.55 -12.84% (9,625.00) 1,800.00 37.011/0 150.00 85.96 64,04 42,69°0 1,050.00 750,00 122.67% 0.00 0.00 0,00 0,00% 500,00 20,000.00 64.16°/o 2.500.00 1,891,55 608.45 24.3490 12,500,00 5,000.00 0.00% 0.00 0.00 0,00 0.00°i, 2.500.00 200,00 3.35% 0.00 0.00 0.00 0.00°0 100.00 250.00 21.62% 2(1.00 33.12 (13,12) -65.60% 140.00 500.00 0.00°/0 40,00 0.00 40.00 100.00'6 280.00 600.00 (1.00"/o 50.00 0110 50,00 100.00% 350,00 300.00 0.1)(11/0 25.00 0.00 25.00 100.0090 175,00 2,000.00 11.25% 0.00 0.00 0.00 0.0000 1,000.00 224,218.00 611.76% 17.555.63 19,079.84 (1,524.21) -8,68% 130,174.62 54,800.00 49.64% 54,800.00 49.64% 50.00 0.00% 300.00 126.02% 6,000.00 86,53% 353.00 230.15% 6,000.00 97.75"/0 7,700.00 90.02% 29,532.00 58.33% 300.00 546.78% 50,235.00 75,74% 984,063.00 64.07%. 4.6110.00 2,337.85 1,762.15 38,31°0 31,800,00 4,600.1)0 2,837.85 1,762.15 38.31% 31,800.00 0.00 0.00 0.00 0,000.t0 25,00 0,00 25.00 1(10.00% 500.00 3)6.98 133.02 36.60°,0 0.00 112,94 (1(2.94) -100.000.'a 501).00 326.00 174,00 34.800, 650.00 954.12 (304.(2) -46.79% 2.461.00 2.461,00 0.00 0.00% 25.00 600,78 (575.78) -2303.12% 4,161.011 4,771.82 (610.82) -14.68% 82,827.66 78,241.88 4,585,78 5.54% YTD ACTUAL Variance IS) \JD 1110.249.39 0.00 6.733.34 5.102.77 1,173.33 20.085.00 806.07 ()2.608.38) 666,05 920.00 12,531.25 0.00 6.70 54.03 0,00 0.00 0.00 225.00 136.244.57 yin (12,247.08) 2,076.9) (1,051.22) 0(4.69) (6,79) (1,596.35) (6,07) 2,983.38 383,95 (420.(10) (331.251 2,500.00 93,311 85.95 280,00 350.00 175.00 775.00 (6,069.95) Variance 1°. d VID 100,00% -18.50% -2.30°0 -053% -8,63"b -31.00°,0 36.57% -84.00°4 -2.65% 100.00°0 93.309-'0 61,39% 100.00% 100.00% 100.00% 77.50% -4.66% 27,204.10 4,595.90 27,204.10 4,595.90 14.45% YT variance notes 25,00 0.00 73,00 100,00% 175.00 378,06 (203.06) -116.03% 3,50(1.00 5,191,64 (1,691.64) -48,33% Budget assumed annex sale in 2014 353.00 812.42 (459.42) -130.1.5% 3,500.00 5,865.13 (2,365.13) -67,58% \JD: Electrical wiring needed in ncw rental office space (S.2.7k ) 4,500.00 6.931.66 (2,431.66) -54.04% New copier lease and usage overage fees 17,227.00 17,227.00 0.00 0.00% 175,00 1,640.34 (1.465.34) -837.34% 29,455.00 38,046.25 (8,591.25) -29.17% 593,960.15 63(1,493.89 (36,533.74) -6.15% Detail_4 DEPT 420 - PUBLIC SAFETY 211)0 - Police Law Enforcement Contract Total Police 2150 - Prosecution Attorney Criminal Total Prosecution Full Year MONTH YTO BUDGET BUDGET ACTUAL Variance (8) Variance (%) lit IDGET ACTUAL Variance (8) Variance (0s) 7015 % to date Month islonth Month Month YTD YTD N'TD '(ID517,799.00 50.92%- 0.)0 0,00 0,00 0,00"s 258,899.50 263,645.09 (4.745,59) -1.8390 517,799.00 541.92% 0.00 0.00 0,00 0.00% 258,899.50 263,645.09 (4,745.59) -1,83% 50,000.00 64.23% 4,200.00 4,512,50 (312 50) -7 44% 29.300,00 32.112 50 (2,312,50) 50,0110.110 64.23% 4,200.110 4.512.50 (312,50) -7.44% 29,300.00 32,112.50 (2,8(2.50) -9,60°/0 222)) - Fire FT Salaries 68,614.00 59.06% 5,273.00 5.409.69 (131.69) -2.50% 39.585.00 411.520,26 (935.26) -2.36% PT Salaries 123,121.00 44.37% 9,470,85 8.012.03 1,453.82 15.40°), 71,031.35 54.626.66 16,404,69 3.09' YID correction for accrual back to 2014 for POC FF PERA Contributions 12,116.00 66.98% 932,00 1,089.58 (157.5S) -16.91°s 6,990,00 8,115.38 (1,125.331 FICA Contributions 7.633.00 44.39°/0 587.15 398.89 183.26 32.06% 4,403.65 3,387.93 1,015.72 23.075 Medicare Contributions 2,780.00 53.00°/0 213.35 137.99 25,36 12.0950 1,603.85 1,473.46 130.39 8.13% Health/Dental Insurance 14,243.00 60.13% 1,095.62 1,142.00 (46.38) -4.23% 8,217.12 8.565.00 (347.88) -4,23°0 Unemployment Benefits 0.00 0.00% (3,00 0.00 0.00 0.00% 0.00 0.01) 0.00 0.00% Workers Compensation 9,000.00 I95.48% 0.00 0,00 0.00 0,00°i, 9,000,00 17.592.38 (8.592.88) -95.48%) Due to IS% rate increase Office Supplies 850.00 34.73% 7(1.00 0.00 70,00 100.00°) 490.00 295,19 194,81 39.76% EMS Supplies 3,400.00 13.330/o 280.00 323.49 (43A9) -15.53% 1.960.00 453.13 1.506,82 76.33%, Fire Prevention 3.000.00 0,00% 250,00 0.00 250.00 100.00% 1.750.00 0.00 1,750.00 100.009 Fuel. Oil & Fluids 13.0(1(1.00 40.33% 1.075310 829.12 245.SS 22.87% 7,525,00 5,243,20 2,231,80 30.3290 Small Tools & Equip 20,892.00 32.38% 1,750.00 4,378.95 (2,628,95) -150.23% 12,250.00 6,764.26 5.485.74 44,73% Physicals 3,181.00 47A7% 265.00 0245.00 (980.00) -369.315o 1,855,00 1,510,00 345.00 18.609, Radio 21,562.00 56.08"/0 0.00 3,914.76 (3.9)4.76) - 100.00% 10,731.00 12,093.04 (1,312,04) -12.17% Mileaec 250.00 I61.92% 20.00 0,00 20.00 100.00% 150.00 404,8(1 (254.80) -169.8700i Insurance 8,307.00 87.02% 11,00 0.00 0.00 0.000,0 8,307.00 7,229,00 1.078.00 12.98% Annual premiums billed April Electric Utility 17,000.00 54.62% 1,300,00 636.80 613.20 47.17°i° 9.900.00 9.285,00 615.00 6.219,) Refuse 1,000.00 185.72% 85.00 266,38 (131.38) -213,399 595.00 1,357.21 (1,262.21) -212.149., Repair/Maint. Bldg 2,000.00 231.92% 165,00 0,00 165,00 100.00% 1,155.00 4.633.36 (3,433.36) -301,590', Repair/Maint Equip 33,260.00 25.32% 2.770.00 174.91 2,595.09 93.699) 19.390,00 8.422. l I 10.967.89 56.569) Uniforms 2,500.00 24.51% 208.00 0.00 203.00 100.00% 1,456.110 612.70 843.30 57,929, Miscellaneous 1,500.00 141.16% 125.00 157,26 (32.26) -25.81% 875.00 2,117,35 ((,242.35) -141,939 Dues S: Subscriptions 3,508.1)0 66,14% 290.00 0,00 290.00 100.00% 2,030.00 2,320.04 (290.04) -14,29% Rooks 220.00 0.00% 203)0 0.00 20.00 100.0090 130.00 0.00 130.00 100,009a Conferences & Trainin4 12,375.00 31.40% 1.000.00 (131.00) 1.131.00 113,109 7.250.00 3,335,65 3,364,35 46.40% Conferences & Training (Reimb) 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0,00 0.00 0.00°, Total Fire 385,312.00 52.27%. 27,250.47 28,085.85 (835.38) -3.07% 228,679.97 201,412.66 27,267.31 11.92% 2250 - Fire Relief Fire Slate Aid Total Fire Relief 37,323.011 0.00% 0.00 0.00 0.00 0.00°0 0.00 0,00 0.00 0.0050 37,323.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Detail_5 full Year I MONTH YTD 2400 - Building Inspection BUDGET BUDGET Acrum. Variance (S) Variance rid 1311DGET ACTUAL. Variance (81 2015 °0 to date Nlonth . Month Month Month 00, YTD YTD YTD Ft Salaries 149,606.00 33.830/o 11,508.15 6,089.53 5,418.62 47.09°0 86,311.15 50.617.55 35,693.60 ['ERA Contributions 10,846.00 35,00% 834.31 456.71 377.60 45.2.6°,, 6,257.31 3,796.29 2,461.02 FICA Contributions 9,276.00 31.84% 713.54 354.49 359,05 50.32% 5,35 I .54 2.953,78 2.397.76 Medicare Contributions 2,169.00 31.83% 166,85 82,90 83,95 50.31% 1,251.35 690.43 56(1.87 I lea 1th/Dental Insurance 28,486.00 37.23% 2,191,23 1,414.11(1 777.23 35.47°- 16,434.23 10,605.00 5,829.23 Unemployment Benefits 0.00 0.00% 0,00 0.00 0,00 0.00% 0.00 0,00 0,00 Workers Compensation 1,000.00 232.40% 0,00 0.00 0.00 0 Alil% 1,000.00 2,323.96 (1,323.961 Office Supplies 2,100.00 7.46°/ 175.00 0.00 175.00 100,00°.i, 1,225.00 156.65 1.068,35 Printed Forms 700.00 16.58°/0 0.00 0.00 0.00 0.00% 350.00 116,09 233.91 ritel, Oil & Fluids 5,500.00 8.22% 500.00 43.15 456,85 91.37% 3,250.00 452.03 2.797.97 Engineering 9,000.00 47.71% 750.00 749,50 0.50 0.07% 5.250.00 4,293,95 956.05 Inspector Contraci Services 67,200.00 27.96% 7,000.00 3.500,00 3,500,00 50.00°-0 34.000,00 18,787.49 15,212.51 Mileage 3,500.00 65.27% 400.00 450,00 (50,00) -12.500 1.800.00 2,284.37 (484,37) Insurance 900.00 20.00% 75.00 0.00 75.00 100.00% 525,00 180.00 345,00 Repairs/Maint Equip 2,300.00 11.11% 200.00 0.00 200.0(1 100.000s 1,325.00 255.43 I ,069,57 LI ni fomis 850.00 10.59% 70,00 0.00 70,00 100.00% 49)1.00 39.93 400.02 Miscellaneous 650.00 18,73% 55.00 0.00 55,00 100.0005 385.00 121.76 263.24 Dues & Subscriptions 700.00 55.00% 60.00 0,00 60,00 100.0011,/, 420.00 355.00 35.00 Books 3,000.00 56.41% 500.00 0,00 500,00 100.00% 2,500.00 1.692,39 807.61 New Truck 23,000.00 0.00% 23.000.00 0.00 23,000.00 100.004, 23,000,00 0,00 23,000.00 Conferences & Training 2,775,00 16.58% 0.00 0.00 0,00 0.0055 1,400.00 460.00 940,00 Total Building Inspections 323,558.00 30.99% 48,199.08 13,140.28 35,058.80 72.74% 192,525.58 100,262.20 92,263.38 2500 - Emergency Communications Contract Services 'Fula! Emergency Communications 2701) - Animal Control Printed Forms Contract Services Miscellaneous (Impounding) Total Animal Control Total Public Safey 7,000.00 53.50% 0.00 0.00 0.00 7,000.00 53.50% 0.00 0.00 0.110 0.00 11.00% 0.00 0,00 0,00 6,000.00 62.08% 500.00 500.00 0,00 800.00 83.13%. 65.00 50,00 15.00 6,800.00 64.5.6°A, 565.00 550,00 15.00 1,327,792.00 °A, 80,214.55 46,288.63 33,925.92 Valiance (%) YID 41,35% 39.33°,0 44.81°-0 44.82% 35.47% 0,00% -132.40% 87.21% 66,83°.'0 86.09% 13.21°.0 44,74°1, -26.91% 65,71".1, Annual premiums billed April 80.72% 81.64% 68,371-0 8,33% 32.30% 0.00% 67.14% 47.92% 0,00° O 3.500,00 1745.00 (245.00) 0.00% 3,500.00 3,745.00 (245.00) -T00% 0,00°S 0,00 (1.00 0,00 0,00)5 3,500.00 3,72.5.00 (225.00) -6 43% 23,08% 455.00 665.00 (2)1.1,00) -46.15% 2.65% 3,955.00 4,390.110 (435.00) -11.00% 42.29% 716,860.05 605,567.45 111,292.60 15.53% Detail_6 DEPT 430 - PUTILIC WORKS Full Year MONT11 1711.3 BUDGET BUDGET ACTUAL Valiance ($1 Variance (%) BUDGET ACTUAL Variance (S) Variance (%) 3100 - Public % 21)15 °I, to date Month Month Month _ Month `r ID YTD Y-TD YTD FT Salaries 153,314.00 49.98°/0 11,793.38 9,42(1.64 2,372.74 20.12% 88,450..38 76,630.83 11,819.55 13.36% Use of more FT VS PT, ON erall cost very close to budget PT Salaries 23,460.110 5.90% 1,804.62 507.00 1.297.62 71.91% 13,534.62 1,385,00 12.149.62 89.77% PERA Contributions 11,115.00 53.82% 855.00 941.37 (86.37) -10.10% 6.412.50 5.982,17 430.33 6,710. FICA Contributions 10,960.110 41.78% 843.1)8 582,71 260.37 30.88% 6„323.08 4,579,60 1.743.48 77.57% Medicare Contributions 2,563.00 41.79% 197,15 136.29 60.86 30.37% 1,478.65 1.071.04 407.61 27,57% I lealthiDental Insurance 34,183.00 63,61"/. 2.629.4b 2,599.00 (269,54) -10.25°-0 19.720.96 21.742.50 (2.021.54) -10.25% Unemployment Benefits 0.00 0.00"/() 0.00 0.00 0,00 0,00% 0.00 0.01) 0.00 0.011°() Workers Compensation 6,000.00 264.59°/. 500.00 0.00 500,00 100.00% 3.500.00 15,875,53 (12,373.53) -353.59% Expense spread out in the budgol. 18% raw increase in 2015 Office Supplies 2,000.00 2.08% 165.00 41,50 123.50 74,85% 1,155.00 41.511 1,113.50 96.41% Shop Ma (erials 1,500.00 61.04% 125.00 0,00 125110 100.00% 875.00 915,61 (40.6)1 -4.64° s Building Repair Supplies 500.00 17.35% 40.00 0,00 40.00 100.00°. 2811,00 86.75 193.25 69,02" Small Tools and Minor Equip 1,200,00 114.92% 100.00 68.15 31.85 31,85% 700.00 1,379.05 (679.05) -97.01", Engineering Senices 9,01)0.00 86.66% 750,00 337.50 412.511 55.00", 5.150.0(1 7,799,00 (2,549,0(1) 048.55% Contract Services 4,000.00 36.38"/, 0.00 363,95 (363,95) -100,00% 2,000,00 1,455,33 544.62 27.23% Radio 1,300.00 47.55% 0.00 309.06 (309,06) -100.000 650.00 618.12 31.88 4,90% Mileage 0.00 0.00°./. 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.000, Insurance 20,000.00 78,74% 0.00 0.00 0.00 0.00% 20,000.00 15.748.00 4.252.00 21,26% Electric Utility 28,0110.00 55.46"/. 1,5110,00 596,60 903.40 60.23% 16,000.00 15,528,30 471.20 2.9500 Refuse 2,400.00 62.94% 200.00 216,67 (16.67) -8.33'-0 1,400.00 1,510.65 (1)0.651 Fuel, Oil, Fluids (ALL depts) 42,000,00 36.69°/a 2,500.00 3.820,43 (1,320.43) -52.82% 25,000.00 15,410,35 9,589,65 38.36". RepairiNiaint Bldg 3,51)0.00 78.03% 300.00 17.48 232.52 94,17% 2,000,00 2.731.22 (731.22) -36.56% Repair/Mainl NO'l Bldg 500.00 0.000/, 40.00 0,00 40.00 100.00". ',, 230.00 0.00 280.00 I 00.00% Repair/Nlaint Equip (out) 5,000.00 9A0% 500.00 2E2,54 287.46 57.49% 3,000.00 470.04 2,529.96 84,33% Equipment Parts 7,500.00 30.07°/. 625.00 0.00 625.00 100.00% 4,375.00 2,255,09 2.119.91 48A6% Uniforms 2,000.00 71.010/, 165.00 221,04 (56.)141 -33.96% 1,155,00 1,420.19 (265.19) -22.960, Nliscellaneous 1,000.00 71.04% 150.00 0.00 150.00 100.00% 600.00 710.43 (110.431 -I 8.410, Landscaping Material 500,00 0.00% 125.00 0,00 125.00 100.00°. 375100 0.00 375.00 100.000, Dues & Subscriptions 200.00 0.00% 0.00 0.00 0.00 0.0000 100.00 0,00 100.00 100,00", ConWrence.s & Training 1,500.00 0.00% 0,00 0.00 0.00 0,00°, 750.00 0.00 750.00 100.00°. Clean kip Days 5,000,00 111.2855, 0.00 0,00 0.00 0.00% 5.000.00 5.563.S2 (563.82) -11.281, Total Public Works 380,195.00 52.84% 25,907.69 20,691.93 5,215.76 20.13% 230,365.19 200,910,67 29,454.52 12.790/, 3120 - Streets Equipment Pans 3,000.00 47.07% 250,00 189.99 60.01 24.00% 1,750.00 Street Maintenance Material, 21),(100.00 46.1555, 3,000.00 4,940.37 (1.940.37) -64.68% 13.000,00 Seal Coating/Crack Filling 186,578.00 90.66% 0,00 140,800.44 ()40,800.441 100.00% 186,578.00 Sign Repair Materials 2,500.00 15.12% 300,00 0.00 300.00 100.00% 1,600.00 Contract Serkiees 8,000.00 59,33"/0 2,000.00 4,032.50 12,032.5(1) -101,63% 6.000.00 Repairs/Maint Equipment 2,500.00 8.40% 210.00 210.00 0.00 0.00'-i, 1,470.00 Total Streets 222,578.00 83.17% 5,760,00 150,173.30 (144,413.3(1) -2507.18% 210,398.01) 1,412.18 337.82 9.230.26 3,769.74 169,15(1.44 17.427.56 378.09 1,221.91 4.746.04 1,253,96 210.00 1.260.00 185,1.27.01 25,270.99 19,30% 29.00% 9.34°, Entire project budgeted in June 76,37% 20,90% 85.71% 12.01% Detail_7 Full Year MONT11 YTD 3125 - Ice & Snow Removal BUDGET BUDGET ACTUAL Variance (5) Variance i'd 131.1DGET ACTT I.AL, Variance 6 Valiance(%) 2015 °r, to date Mon(h Month Month Month YTD YTD YTD YTD Landscaping Material 0.00 100.00°A 0.00 0,00 (1.)0 0.00'1-n 0.00 794.14 (704.14) -100.00% Sand/Salt 811,000.00 29,66% 0,00 (1,00 0.00 0,00°0 45,000,00 23,724,41 21,275,59 47,7812 Contract Scniecs 6,000.00 0.00"/0 500.00 0.00 500,00 100.00% 3,500.00 0.00 3.500,00 I 00.00°.-O Repairs/Mini Equipment 9,500.00 95.22% 850,00 0.00 850.00 100.00% 5,450.00 9,045.92 (3.595.92) -65,98"0 Includes S7,200 Mr snmv plow blades Tulal lee & Snuw Removal 95,500.00 35.15% 1,350,00 0.00 1,350.00 100.00% 53,950.00 33,564.47 20,385.53 37.79% 3160 - Street Lighting Street Lighting Total Street Lighting 28,11011.00 47,35% 2,350.00 28,000.00 4735"A, 2,350.00 2,019.8S 2,1119.88 330.12 14.05% 330.12 14,05% 16,450.00 13,257.55 16,450.00 13,257.55 3.192.45 19.41% 3,192.45 19.41% 3200 - Recycling Recycling Supplies 3,500.11(1 0.00% 0,00 0.00 0.00 0.0012 1,750,00 0,00 1,750.00 100.00o Miscellaneous 6,000.00 9.47°/u 500.00 0.00 500.00 100.0000 3,500.00 568.03 2,931.97 83.770 Total Recycling 9,500.00 5.914"A, 500.00 0.00 509.00 100.00% 5,250.00 568.03 4,681.97 89.18% 3250 - Tree Program Contract Services Total Tree Program. Total Public Works 6,000.00 0.00% 500,00 6,000.00 9.09% 500,00 0.00 500.00 100.00% 0.00 500.00 100.00"A, 741,773.00 58.43% 36,367.69 172,885,11 (136,517.42) -375.38% 3,500.00 3,500.00 0 00 3.500,00 100,0010 0.00 3,500.00 100.011% 519,913.19 433,427.73 86,485.46 16.63% Oetail_8 5200 - Parks & Recreation FT Salaries l'T Salaries ['ERA Contributions FICA Contributions Medicare Contributions I lealthiDental Insurance Uncmplo)tnent Benefits Workers Compensation Shop Materials Chemicals Equipment Parts Building Repair Supplies Landscaping Ma1L'6aIs Small Tools and Minor Equip Mileage Insurance Electric Utility Refuse Repair/Main' Rldg Repair/Main( NOT Bldg RepairtMaint Equip Rental Buildings Nliscellaneous Total Parks & Recreation 11' & Telephone IT-Harck•are lf-Sorovare IT -Support Services IT -Networking 1NET Contingency Telephone Total IT & Telephone Grand Total all Expenses Suhtolal Net Income over Expenses DEPT 460 - COMP AD,I Debt Service increase Transfer to City Projects (Streets) DEPT 493 - OTII FINANCING GRAND IOTA 1- EX P ALI DEPTS Net Income over Expenses DEPT 450 - CULTURE, RECREATIO Full Year BUDGFF 2015 % to dam 77,847.00 1111.46% 6,820,00 157,18% BUDGET Month 5,988.23 11,026.83 524.62 4,367.00 5,644.11(1 101.83% 434.15 725.63 5,249.00 101.71% 403,77 922,16 1,228.00 101.67"/. 94.46 215,65 19.940.00 54,56% 1.533.35 1,450.80 0.00 0.00"/. 0.00 0,00 4,0110.0(1 1 14.27% 0.00 0,00 500.00 142.52% 40.00 61.50 750.00 64.96% 62.50 0.00 2,000.00 70.17°/. I 65.00 0,00 500.00 15.26% 40.00 0,00 3,000.00 54,70% 250.00 242,80 1,000.00 156.46% 85.00 106,43 0,00 0.00% 0.00 0.00 3,200.00 95.03% 0.00 0.00 8,500,00 69.68% 600,00 738.12 2,500.00 0.00% 208.33 0.00 1,000.00 128.41"/. 85.00 0.00 2,500.00 46.21% 225.00 43.50 1,500.00 0.00% 125,00 117.75 4,600.00 84.95°/. 383.33 846.00 75(1.00 114.950/o 62,50 0.00 153,028.00 9127"/ 11,310.74 20,864.47 9,100,00 55.53% 0,00 0.00 16,000.00 46.93% 1,333,00 0.00 36,000.110 65.59% 3,000.00 5.902,84 7,800.00 0.00% 0.00 0.00 16,000.00 0.00% 0.00 0.00 24,660.00 44.710/ 2,055.00 1.926.59 109,560.00 43.08"/. 6,388.00 7,829.43 MONTH ACTUAL Variance (S) Month NIonth Variance P01 1313D13ET Month YTD (5.038.60i -34,14% 44,911.73 (3,842.33) -732.410. 3,934.62 (29).43) -67.140 3.256.15 (518.39) -128.39% 3.023.27 (121.19) -123.3000 703.46 33.05 5.4100 11,503,35 0.011 0.00% 0.00 0.00 (TOW o 4.0(1(1.00 (21,30) -54,50% 230.00 62.50 100.00% 437.50 165.00 100,00% 1,155.00 4(300 100.000. 280.00 7,20 2.33% 1.750.00 121.431 -25,21% 590.00 0.00 0.000-. 0,011 0.01 0.00°% 3.200.00 ((33.12) -23.020. 4,75)).00 205.33 100.00% 1.453,31 35.00 100.00% 590.00 181.50 30.67°. 1,475.011 7.25 10130000 875.00 (462.67) -120.7006 2„633.31 62.50 100.00% 437.50 (9,553.73) -84.47/0 91,304.70 YTD ACTUAL Valiance (S) 5 ID YTD 78,987.35 10,719.63 5,747,43 5,338.66 1.248.51 10,330.20 0.00 4.570.91 712.61 487.13 1,403,43 76.32 1.641.02 1.564.60 0,00 3,04 1,00 5,922.49 0.00 1,2343)7 1,155,23 117.75 3,907.73 362.10 (39,668.27 134,075.62) 16,785,011 (2,491.23) (2,3(0,39) (540.05) 623.65 0,00 (570.9)1 (4)2.61) (49.63) (243.43) 203,63 103.93 (974,60) 0.00 I 59,00 (1,(72.49) 1,458.31 (694,07) 319.77 757.25 (1,224.47) (424,60) (48,363.57) 0.00 0.00.:,', 4.550.00 5,052.98 (502,981 1,333.00 100,0000 9.331.00 7,503.00 1,823.00 (2,902.84) -96.76% 21.000.110 23,611.36 (2,611,30) 0.00 0.0000 3.900.00 0.00 3.900,00 0.00 0.00% 16,000.00 0,00 16.000.00 123.41 6.250o 14,385.00 11.025.90 3.359.10 (1,44(.43) -22.56°/0 69,166.00 47,198.24 21,967.76 Variance' (00 YTD -75.37% Position switch from new employee at loner rate to long tom co -172.44°0 -76.519/. -76.29% -76.23% 5.42% 0.00% -14,27% -154.5011'n -11.36% -21.51". 72.74". -165,19". 0.0096 4.97% 1011.00% -117.64% 21.68% 36.54% -97.05% -52.97% -11.05% 19.54% -12.44% 100.00% 100,00% 23.35% 31,76% 3,316,216.00 55.9110/. 217,108.64 326,109,52 (109,000.88) -50,21"/0 1,991,204.09 1,856,355.58 134,848.51 6.77% 482,118.00 18.58"/:, ,215,698.11 1,119,527,117 (96,171.04) 7.91% (30,326.84) 89,577.52 119,904.36 395.37% 35,000.00 0.00% 0.00 (1.00 0 01) 0.00°. 0.00 13011 0,00 247,118,00 0.00% 0.00 0.00 0.00 0.0000 0,00 0.00 0.00 0.00% 0.00 0.00% 0100 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% 200,000.00 0.00% 0,00 0.00 0.00 0,0000 0,00 0,00 0,00 0.00% 3,798,334.00 48.870/o 217,108,64 326,109.52 (109,000.88) -50.21% 1,991,204.09 1,856,355.58 134,848.51 6.77"/. 0,00 0.00% 1,215.698.11 1,119,527.07 _ (96,171,04) 7.91% (30,326.84) 89,577.52 119,904.36 395.37% Detail_9 CIO: of Lake [lino Budget to Actual 2015 By Month As of.hilv,31. 2015 206..Library Fund By Denartment [till Year NIonth YID BUDGET 2015 201.5 Over: 2015 2015 Over. 2015 % to date BUDGET AC-WATS (wider) . BUDGET AC ID (under) Notes REVENUE Crin-etu Ad Valorem Taxes 231,261.00 50.00% I I 5,630.50 115,630.50 0.00 115,630.50 115,630.50 0.00 Funds receiver! from \VA CI>, July and December Rental Income 11,400.00 180.26% 950.00 400.00 (550.001 6.650.00 20,550,00 13,900.00 Includes S I fik delinquent rent from prior tennant Interest Earnings 0.0)1 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 Miscellaneous Revenue 0,00 0.000o 0.00 0.00 0.00 0.00 200.55 200,55 Revenue from use of copier Donations 0,00 100.00% 0.00 25.00 25.00 0.00 1,23.5.00 1,235.00 Total Revenue 242.661.00 56.710u 116.580.50 116,055.50 (525.001 122,280,50 137.616.05 15:435.55 EXPENSE (OverE (Oval` under under FT Salaries 45,000.00 58,17% 3.750.00 3,460.86 289.14 26,250.00 26,176,32 73,68 PT Salaries 16,000,00 20.34"/o 1,333.33 1,015,0(1 3)8,33 9.333,33 3,255.00 6.078.33 PERA C'ontr16u6ons 4,422.50 49.54% 368.54 335.69 32.85 2,579.79 2.190.84 388.95 FICA Contributions 3,782,00 44,87% 315,17 261,91 53.26 2,2(16.17 1,696.93 509.24 Medicare Contributions 884.50 44.87% 73.71 61.26 12.45 515.96 396,80 119,07 Health/Dental Insurance 11,987.00 68.07% 998.92 1,088.00 (89.08) 6,992,42 8,160.00 (1.167.58) Budget. showed consistent monthly cost; not impact LInonployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 of multiple pay period months \Yorkers Compensation 350.00 0.00% 0.00 0,00 0.00 350.00 0.00 350,00 Library svcs supplies 1,100.00 0.00% 91.67 0.00 91,67 641.68 0,00 641.68 Office Supplies 4,100,00 2.8906 341.67 0.00 341.67 2,391,69 118.67 2,273,02 Library' Collection Maintenance 40,700.00 26.940/6 4,141,67 923.75 3,217.92 28,991.67 1,3.387,78 15.603.89 Legal Soy ices 2,000.00 63.035' 0,00 0.00 0.00 I ,000.00 1.260.50 (260.50) Cost to recover delinquent rent from prior teanain Contract Services 3.000.00 3,45% 25(1.00 0.00 250,00 1.750.00 103.50 1.646.50 Snow Plowing Telephone 1,600.00 56.32% 133.33 128,46 4.87 933.31 901.05 32.26 Internet 1,000.00 38,63% 83.33 115.00 (31.67) 583.33 386.29 197,04 Information Technology (Equine) 3.220.00 96,27% 0.00 0.00 0,00 3,220.00 3.)00.00 120.00 Software. 0.00 0.00% 0.00 0.00 0,00 OM() 0.00 0.00 Insurance 2.700.00 69,74% 0.00 0.00 0.00 1,35(1,00 1.883.00 (533,00) Utilities 7.550,00 56.19°4 666.66 641.25 2541 4.416,62 4.242.69 173.93 Refuse 550,00 63,27% 45,83 49.89 (4,06) 320,81 348.01 (27.20) Repair;Maint Bldg 14.000.00 128.20% 1.166.67 455.00 711,67 8,166.67 17,947.50 19,780.83) YTD includes Roof repairs Repair/Mint NO'r Bldg 0,00 0.00% 0.00 0.00 0.00 0.00 0.00 0,00 Repair/Maim Equip (out-L11 Imp 0.00 100.003/4 0.00 0.00 0.00 0.00 420.00 (420.001 I rbrary Card Reimbursements 24,000.00 67,97% 2,000.00 3,255,00 11,255.001 18,000.00 16.312.34 1.687.66 Library card reimb are processed by County elf 51 i15 Miscellaneous 2.000.00 14.68% 166.66 0.00 166.66 1,166.62 293.62 873.00 Building Purchase Repint 0,00 0.00% 0.00 0.00 0.00 0.00 0.00 0.0(1 Building -Property Tax 2.600.00 44.88% 0.00 0.00 0.00 1.300,00 1,167.00 133.00 Other Equipment 0.00 100.00% 0.00 738.00 (738.00) 0.00 738.00 17314.001 Subscriptions 0.00 0.00% 0,00 0.00 0.00 0,00 0.00 0.00 Conferences & Training 2,500.00 0.00% 0.00 000 0.00 0.00 0,00 0.00 Programs 7.500,00 0.00% 625.00 0.00 625.00 4,375.00 0,00 4,375.00 Internal charges 1,600,00 25.38% 130.00 14.00 116.00 950.00 406.00 544.00 $2 per card processing fee plus billable City resources Total Library 213,146.00 49.21%. 16.682.16 12,543,07 4,139.09 127,785,07 104,891.93 22,893.14 Net Income/(Expense) 12131/14 Cash Balance Net IncomellExpensel Accrued AP CII' (self 'boded) Contingencies 2014 AP accrual reversal Ending Cash Balance 29,515.00 99,898.34 103,512.43 3,614,09 (5,504.57) 37.774,12 38.228.69 3.62% -694,49% 172,205.10 206.407.26 29,515.00 32,724.12 (3..703.87i (70,000.00) 0.00 131,720.10 235.427.31