Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10.18.16_Sept Financials
City of Lake Elmo Buthlet to Actual Comparative For the month ending September 30. 2016 101-General Fund Summary By Department DEPT 410 - GEN'L GOV'T REVENUE Total Revenue Full Year BUDGET 2016 3,485,514.32 to date 10/18/2016 MONTH YTD BUDGET ACTUAL Variance (S) Variance (%) BUDGET ACTUAL Variance (S) Variance (%) Month Month Month Month YTD YTD YTD YTD 79.15% 110,315.00 229,814.01 119,499.01 108.33°/u 2,105,677.31 2,758,905.12 653,227.81 31.02°/0 EXPENSE Total Mayor & Council 45,935.32 51.88% 1,375.00 736.58 638.42 46.43% 29,252.66 23,840.02 5,412.64 18.50% Total Administration 360,997.50 150.80% 27,468.66 79,864.12 (52,395.46) -190,75% 274,429.73 544,387.36 (269,957.63) -98.37% Total Elections 15,800.00 32.38% 14,850.00 19.26 14,830.74 99.87% 15,800.00 5,116.16 10,683.84 67.62% Total Finance 124,835,30 81.89% 7,498.28 10,755.55 (3,257.27) -43.44% 96,158.63 102,231.15 (6,072.52) -6.32% Total Planning & Zoning 284,682.35 68.26% 32,406.72 26,106.79 6,299.93 19.44% 211,871.33 194,332.51 17,538.82 8.28% Total Engineering Services 48,000.00 57.29% 4,000.00 1,160.00 2,840.00 71.00% 36,000.00 27,496.82 8,503.18 23.62% Total City Hall 55,082.00 78.83% 4,461.00 4,987.02 (526.02) -11.79% 40,924.00 43,423.60 (2,499.60) -6.11% Total General Government 935,352.47 100.59% 92,059.66 123,629.32 (31,569.66) -34.29% 704,436.35 , 940,827.62 (236,391.27) -33.56% DEPT 420 - PUBLIC SAFETY Total Police 527,060.47 48.12% 0.00 0.00 0.00 0.00% 263,530.24 253,612.02 9,918.22 3.76"/0 Total Prosecution 54,700.00 60.84% 4,600.00 3,505.81 1,094.19 23.79% 40,900.00 33,277.51 7,622.49 I8.64% Total Fire 377,231.71 68.06% 32,746.45 32,766.12 (19.67) -0.06% 287,581.44 256,750.51 30,830.93 10.72°4 Total Fire Relief 37,323.00 0.00% 0.00 0,00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Building Inspections 260,765,91 63.06% 20,485.08 25,123.74 (4,638.66) -22.64% 191,160.66 164,430.01 26,730.65 13.98% Total Emergenc3, Communications 7,400.00 50.61% 1,850.00 0.00 1,850.00 100.00°4 5,550.00 3,745.00 1,805.00 32.52% Total Animal Control 7,550.00 91.32% 650.00 770.00 (120.00) -18.46% 5,600.00 6,895.00 (1,295.00) -23,13% Total Public Safety 1,272,031.09 56.50% 60,331.53 62,165.67 (1,834.14) -3.04°/0 794,322.34 718,710.05 75,612.29 9.52% Summary_ DEPT 430 - PUBLIC WORKS Total Public Works Total Streets Total Ice & Snow Removal Total Street Lighting Total Recycling Total Tree Program Total Public Works MONTH YTD BUDGET ACTUAL Variance (S) Valiance I%) BUDGET ACTUAL Variance (5) Variance ("ii,) Month Month Month Month YTD YTD YTD YTD 411,284,53 87.12% 28,876.50 46,760.69 (17,884.19) -61.931/4, 309,664.26 358.312.24 (48,647.98) -15.71% 413,000.00 67.08"/0 4,660,00 545.07 4,114.93 88.30% 408,240.00 277,024.72 131,215.28 32,14% 87,250.00 38.65% 1,500.00 5,412.81 (3,912.81) -260.85% 47,250.0U 33,723.82 13,526.18 28.63 % 26,400,110 72.89% 2,200.00 2,260.85 (60.85) -2.77% 19,800,00 19,243.44 556.56 2.81% 5,900.00 0.00°43 200.00 0.00 200.0(1 100.00% 3,550.00 0.00 3,550.00 I 00.00°/0 1,000.00 61,45% 0.00 0.00 0.00 0.00% 1,000.00 614.50 385.5(1 38.55% 944,834.53 72.91% 37,436.50 54,979.42 (17,542.92) -46.86% 789,5(14.26 688,918,72 100,585.54 12.74% DEPT 450 - CULTURE, RECREATION Total Parks & Recreation 231,320.23 IT & Telephone 81,976.00 GRAND TOTAL ALL EXPENSES 3,465,51432 SUB TOTAL NET INC OVER EXP 20,000.00 DEPT 460 - COMP ADJ 20,000.00 DEPT 490 - CONTINGENCY FUND 0,00 Debt Service increase 0.00 DEPT 493 - OTH FINANCING 0.00 GRAND TOTAL ALL DEPTS 3,485,514.32 Net Income over Expenses 63.07°A 73.40% 71.98% 213,026.78 1322.76% I (102,71(.78) 0.00"/0 0.00"/0 0.00% 0.00% 71.56% 0.00 0.00°A,, 17,299.09 17,830.76 (531.67) -3.07% 171,573.40 145,895.81 25,677.59 14.97% 5,900.00 7,082.89 (1,182.89) -20.05% 62,756.00 60,172,98 2,583.02 4.12% 265,688,06 (52,661.28) -24.72% 2,522,592.35 2,494,352.20 34,515.85 1.370/0 (35,874.05) 66,837.73 65.07% (416,915.04) 264,552.92 687,743.66 164.96% 0.00 0.00 0,00 0,00% 20,000.00 0,00 20,000.00 1 00.00° 'o 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% 213,026.78 265,688.06 - (52,661.28) -24.72% 2,542,592.35 2,494,352.20 54,515.85 2.14% (102,71(.78) (35,874.05) 66,837.73 65.071/4, (436,9)5.04) 264,552.92 701,467.96 160.55% Summary__ Cite of Lake Elmo Budget to Actual Comparative Fouhe month ending September 30, 2016 101-General Fund Detail By Department DEPT 4111 - GENII. GOV'T REVENUE Current Ad Valorem Taxes Delinquent Ad Valorem Taxes Mobile Home Tax Fiscal Disparities Penalty & Interest on Taxes Liquor License Wastehauler License General Contractor License Healing Contractor License Building Permits Building Re-inspeci Fees Heating Permits Plumbing Permits Animal License Utility Permits (ROW) Burning Pemlit Massage Therapy Licenses MSA-Nlaintenance State Fire Aid PERA Aid Recycling (iran( Mist: State Grant./Sureharge Rev Cable Franchise Revenue Zoning & SubiliGsion 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 Interest Earnings Donations 'Total Revenue 10/1 Si2016 YTD Full Year NIONTH BUDGETIX BUIET ACTUAL Variance (5) Valiance I%) BUDGET ACTUAL Variance (S) Variance (%) 2016 ° o to date Month Month Month Month YTD YTD YTD YTD YTD variance notes 2,033,198.00 15,000,00 12,000.00 157,5118.00 700.00 11,1100.00 1,680.00 0.00 2,500.00 508,200,00 0.00 38,000.00 46,800.00 2,500.00 25,000.00 2,750.00 150.00 101,696,00 41,500.00 2,749.00 15,500,00 5,064.00 45,000.00 27,500.00 278,129.00 175.00 1,215.00 2,000.00 4,000.01) 45,000.00 0.00 500.00 3,500.00 55,000.00 0.00 3,485,514.01) 52.22% 45.96% 21.29% 59.47% 75.80% 62.05% 92.86% I00.00% 116.00"/o 140.41% 0.00"/o 269,8 V/o 143.30% 69.40% 186.97% 61.64% 0.00"/o 60,69% 0.00% 50.00"/o 101.21% 85.84% 218.20/o 100.53% 137.27/o 109.9 V/o 288.89% 0.00% 27.63% 87.118% 0.00% 0.00% 111.24% 0,011% 100.00% 79.15% 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 200,00 45.000.00 0.00 5,000.00 4.500.00 40,00 5,000.00 400.00 0,00 0.00 0,00 0.00 0,00 250.00 0.00 3.000.00 26,000.00 25.00 100.00 (1.00 1.000.00 4.000,00 0,00 500,00 300.00 15,000,00 0,00 111015,0-0 0,00 0.00 0,00 0.00 0.00 0.00 0.00 0,00 300.00 116.092.15 0.00 11,370.00 13.333,00 41).00 1,397.00 45.00 0.00 0.00 0,00 0.00 0,00 0,00 0.00 10.305.00 71,397.65 75,00 510.00 (1,00 0.00 4,449.21 0.00 0.00 0,00 0.00 0,00 229,814.0i 0.00 0,0(1°,, 1,016.598,81 1.061.821.33 45,222.52 4.45°,, YID includes pn0 from WA Cty related to a tax forfeit parcel (1,00 0.00% 7,500,00 6,893.59 (606.4)1 0,00 0.009, 6.000,00 2,554.4) (3.445.51) -57,43v- 0.00 0.00°:o 75,754.00 93,676.57 14.922.87 18.9.59'0 0.011 0.00`% 350,00 530,60 150.60 51 0.00 0.00% 8.000.00 6,825.00 (1,)75.001 -14.69% 0,00 0.009 '. 840.00 1.560,00 720.110 55.71°-6 0.00 0.00`)0 0,00 150,00 150.00 100.00° 100.00 50,01196 1,900.00 2,90(1.00 1,000.01) 52.63°-/, 71.092,15 157.98% 395.000.00 713,568.95 315,568,95 79.29% Reflects fees from 193 new homes and 59 new commercial units 0.00 0,00% 0.00 0.00 0,00 0.0(19', (YTD includes $70k in revenue for ISD 916 not budgeted) 6.370.00 127.400( 31,000,00 102,529,32 71,529.32 230.74% 8,833.00 196.29% 37,200.00 67.066.00 29,866.00 50.2896 0.00 0.009. 2,380.00 1.735.00 (645.(30) -27.)15, (3,61(3.00) -72,069, 24.500.00 46,741.60 27,141.60 90.78% (355,00) -88.75% 2.400.00 1.695.00 (705,0))) -79.35% 0.00 0,0006 75.00 0.00 (75.00) -100.00"-i, 0,00 0.00% 101,696.00 61,716,50 (39.979,50) -39,31% Monthly vanance is just a timing issue on receipt of N1SA funds 0.00 0,00% 0,00 0.00 0.00 0,00% 0.00 0.00% 1.374.50 1,374.50 0,00 0,0006 0.00 0.00% 15,500.00 15.688.1,10 188.00 1,21% (250.00) -100.00% 4,814.00 4,347.01 (466,99) -9.7090 0.00 0.009 45,000,00 98,215.41 53,215.41 115.26% Actual geater than budget due to an increased share of market 7.805.00 260,17% 23,000,00 27.645,00 4.645.00 20.20% 45,397,65 174.61% 215,0(10,00 381,782.83 166.782,83 77.57% Reflec[s fees from 193 new homes and 11 new commercial units 50,00 200.00% 125,00 192.34 67.34 53.87% 410.00 410,00% 1,070.00 3,510,00 2,440,00 2.28.0496 0.00 (1,00')6 2.)00.00 0.00 (2.000.0))) -100,00% (1,0)10.001 -100.00% 3.000,00 1,105.0(1 (1.895.)0) -63.17% 449.21 11.23% 34.500.00 39,154.21 4,684.2 I 13.589, 0.00 0.009. 0.00 0,00 0.00 0.0090 (500.))0) -100.00°,0 500,00 0.00 (5))0.00) .100,005, (300.00) -100.005, 2,600.00 3.893.57 1,293.57 49.75% 115,000.00) -100.008, 40,000.00 0.00 (40,000.00) -100.00% 0,00 0.00% 0.00 10,000.00 10,000.00 100.00' -0 119,499.01 10333% 2,10507731 2,7511,905.12 653,227.01 31,02% Full Year MONT II Y rt) EXPENSE BUDGET BUDGET ACTUAL Variance (5) Variance(%) MIDGET AcTuAL Vanance (S) Variance(%) 1110 - Mayor & Council 2016 "0 to date Month Month Month Month YTD YID YTD YTD PT Salaries 25,690.00 0.000/0 0381 0.00 0381 0,00" -,, 12,845,00 0,00 12.845.00 100381% E105 Contributions 1,592.78 0,00% 0310 0,00 0,00 0310% 796.39 (1381 796.39 100.000(( (Medicare Contributions 372.54 0.00%, 0.00 (1,00 038) 0.00% 186.27 0,00 186.27 100.00% Workers Compensation 300.011 2.63% 0,00 0,00 Olt) 11,00". 300,00 7.90 292.10 97.37% Mileaee 500,00 0.00% 125.00 0,011 125.00 100,00'0 375.00 0,00 37.5.00 100.00% Miscellaneous 5,000.00 185.330/, 0.00 0,00 0.00 1) 00°o 5,000.00 9.266.50 (4,266.50) -85.33% Dues & Subscriptions 11,500.00 126.66% 1,0003)0 736.58 263,42 26.34'3'0 9,000.00 14.565.62 (5,565,62) -61.84°,0 2016 share of LMC annual Pmt made in Sept 2015 plus Nletro Conferences & Training 1,000.110 0,00°/© 250.00 0.011 250.00 100,00% 750,00 0.00 750.00 100.00% Cities annual membership of 53.7k & VS13 for $5k which ‘vas l'otal Mayor & Council 45,955.32 51.88°A,,, 1,375,00 736.58 638.42 46.43% 29,252,66 23,840.02 5,412.64 18.50% budgeted later in the year 1320 - Administration FT Salaries P T Salaries PERA Contributions )CM'\ Contributions FICA Contributions Medicare Contributions Healdt/Dental Insurance Unemployment Benefits Workers Compensation Office Supplies Printed Forms Legal Services NCIA'sletteriWebsite Assessine. Services Contract ServiCe5 Postage Mileage Legal Publishing insurance Cable Operation Expense Miscellaneous Dues & Subscriptions Books Conferences & Training StaffDeelopmern Total Administration 145,01)0.011 0.00 1(1,875.0(1 0.00 8,990.00 2,102.50 30,550.00 0.00 1,140,00 5,800.00 0,00 60,00(1.00 8,000.00 38,000.110 0.00 2,0011.011 550.00 10,040.00 28.0(10.00 4,800.00 600.00 1,200.00 0.00 3,350.00 0.011 360.997,50 100.20% 0.00"/. 102.43°A, 106.01% 105.99% 68. I 1°/0 0,00% 548.44% 69.56"/,, 1011.00% 448.54% 0.00% 75,77°A, OM% 112.04% 52.84% 62.27% 93.29% 56,25% 6,89% 156.44°/0 0.00% 23.25°A, 0.00% 150.80"/i, 11.153,85 0.00 836.54 0,00 691.54 161,73 2,3503)0 0,00 0.00 500,00 0.00 5,000.00 2,000,00 2.500.00 0,00 500.00 75,00 900.00 0,00 400.00 50,00 100.00 0.00 250,00 0.00 27,468.66 19,429.74 549.00 1.803.22 0,00 1A40,68 336.92 2,692,80 0,00 0,0(1 398.32 0,00 50.000.00 0.00 2,500.00 46.00 250,00 0.00 335.72 0.00 0.110 0.00 0,00 0.00 81.72 0,00 79,864.12 (8,275.89) (549.00) (966.68) 0,00 (749.14) ((75,19) (342.80) 0,00 0.00 1(11.68 3300 (45,000.00) 2.000.00 0.00 (46,00) 250.00 75,00 564.2S 0,00 400.00 50.00 100,00 0.00 168.28 0,00 (52,395.46) -(15.56% 0.00' -108.33% -11)8.32°0 -14.59°0 0,00% 0.00% 20.34% 0.0()°;. -900.00% 100.00°0 0.00" (i -100.00% 50.00" 100.00"o 62.70°.'o 0,00". 100.00"---0 100,00° o 100.00% 0.00% 67.31% (IM))% -190.75% 105,961.54 0.00 7,947.12 0.00 6.569,62 1.536,45 22,325.00 0.00 1.140.00 4,300,00 0.00 45.000.00 63100,00 28.500,00 0.00 1,500,00 450.00 7,650.00 28,000.00 3,600.00 450.00 900,00 0,00 2.600.00 0.00 274,429.73 145,286,37 5.613.00 11,139.13 0.00 9,531303 2,228.41 20,80.00 0.00 6.252.24 4,034,29 771.32 269.123.56 0.00 28,792,95 506.00 2.240.75 290.64 6,252.04 26.121.00 2.700.00 41.35 1,877.32 0.00 778.96 0.00 544,387.36 (39,324.83) -37.11°6 15.613.00) -100.00% (3,192.0)1 -40.170o 0,00 0,00" o (2.960.4)) -45.060, (691.96) -45.04% 1.517.00 6.80% 0.00 0.00° (5.112.24) -448,44" 265,71 6,(8% (77).32) •100.00% (224,)23.56) -498,05% 6,0)0.00 101).00% (292.95) -1,03% (506,00) -100,00°6 (74(1.75) -49.38° 159,36 35A1% 1,397,96 18.2700 1,879.00 6.71% 900,00 25.00% 408.65 90.81% (977.32) -108.59% 0.00 0.00% 1.821.04 70,04% 0,00 0.00°0 (269,957.63) -98,37% Intern position reallocated to Admin YTD 3 NI costs of S149.8k Milt Aug. Sept cst is based on Aug actual Delail_2 NION ni YTD 1410 - Elections BUDGET ACTUAI. Variance IS 1 Variance Col BUDGET ACT1 LA I, Variance (S) Variance 1" ol Month Nlonth klontli Month YTD YID N'T D YTD PT Salaries 12,000.00 0.00"4, 12,000.00 0.00 12.000.00 1(10.00"o 11000.00 3,503.50 8.496.50 70,80% Office Supplies 500.00 0.00% 500.00 0.00 500.00 100,00"u 500.00 0.011 500,00 100.0005 Legal Publications/Notification 500.00 (1,00% 500,00 0.00 500.00 I Oft 00?-6 500.00 0.00 500.00 100.000 Equipment Repair 500.00 0.00% 500.00 0.00 500.00 100.00% 500.00 0,00 500.00 100.00"o County Election Fees 950.00 126.32% 0.00 0.00 0.00 0.00% 950.00 1,200.00 1250.0(1) Printed Rims 350.00 0.00% 350.00 0.00 350.00 100.00% 350.00 0.00 350,00 100.000) Miscellaneous 1,1100.00 41.27% 1,000.00 19.20 980.74 98.075-o 1,000.00 412.66 587.34 58,73% Total Elections 15,800.00 32-33% 14,850,00 19.26 14,830.74 99.87°/ 15,800.00 5,116.16 10,683.84 67.62% 1520 - Finance Fr Salaries 60,630.46 79.22% 4.653,35 7,330.59 (2,677,24) -57.53% 44,206.80 43.032.76 (3.325.96) -3.65°o PT Salaries 4,550.00 22637".4 350.00 887.50 (537.50) -153.57% 3,325.00 I 0,299,82 (6.974.82) -209.77% PL2[A Contributions 4,888.53 81.67% 375.25 616.35 (241.10) -64.250) 3,564.33 3,992.45 1427,571 -11.99% FICA Contributions 4,041.19 85.76% 310.21 486.36 (176.65) -56.95% 2,946.97 3.465.65 (513.68) .17.60" Medicare Contributions 945.12 85.76% 72,55 113.83 (41.33) -56.97% 639.21 310.50 (121.29) -17.60% 1 leallh/Dental insurance 10,880.00 80.00°/. 836.92 1„305.60 1468.68) -56.00°o 7.950.77 3.704.00 (753.23) -9.47"-e Unemployinent Benefits 0.00 0.00% 0,00 0.00 0.00 0.008) 0.00 0.00 0,00 0.00% Workers Compensation 550.00 43.12% 0,00 0.00 0.00 0.00% 550.00 237.16 312.84 56.38% Office Supplies 1,000.00 17,15% 175.00 0.00 175.00 I00.00% 1,025.00 171.52 853.48 83.27°.0 Printed Forms 500.00 0.00% 125.00 0.00 125.00 100.00° .0 375.00 0,00 375.00 100.00% Audit Services 28,650.00 91.43% 0.00 0,00 0.00 0.005) 26.15(1,00 26,195.01) (45.110) -0.178) Contract Services 6,700,00 1.238) 550.00 14.77 535,23 97.31% 4,975.00 82.29 4,S92.71 98.35% Mileage 50.00 0,00% 0.00 0.00 0.00 0,00°.b 0.01) 0.00 0,00 0.00% Miscellaneous 200,00 35.00"/o 50.00 0.00 50.00 100.005 150,00 70.00 S0.00 53.33% Dues & Subscriptions 750.00 22.678) 0.00 0.00 0.00 0.00% 250.011 170.00 80.01) 32.00,,, Conferences & Training500,00 0.00% 0,00 0.00 0,00 0.00% 0,00 0.00 0.00 0.00% Total I0f1:111Ce 1 124,835,30 81.898)1 7,498.28 1(1,755.55 (3,257.27) -43.44% 96,158.63 11)2.231.15 (6,072.52) -6.32% Detail_3 Full Year NIONTH YTD ,,,,a:iiasj:70 I( .$0,2 i Varia:1311441.17;0 Vaii(),In;51,5113) Vanallce 00) BUDGET Bt 'DWI BLIDGE'r ACTUAL ACI-U A L. Y T D variance notes 19111- Planning & Zoning 2016 % to date NIontli Month 19,641.13 NIonth Month \I'D YTO )-TD FT Salaries 137,098.00 86.57"/0 10,546,00 11(.1T.11-)87.00 I 18,6,88.02 PT Salaries 4,800,00 130.44% 79(.°11°9t,15 960,00 060.001 (682,121 -86.-14?0 4,800,00 (1.461.00) PERA Contributions 10,282.35 86,60'1,4, 1.473.07 -100,00" -,, 7.514.03 6,261,00 (1.389,98) FICA Contribmions 8.500.08 86.33% 653.85 1.211.44 (( 51( -953 t°77) :: 035) 0(99:: 8,904.01 7.338.44 1,716,21 (1,12.6,85) Medicare Contributions 1,987.92 86.33"/o 152.92 283.3) 2,775.00 .:888565 ::228-17:°L0, 6,211.59 1,452.71 (263.50) Health/Dental Insurance 34,814,00 53.14% 10-ri°31610°2:11O 6,941,00 2,678.00 it , 48 .,,, 57 168_61 ,(61 50 ) 481.91 i- 2.411 9788S ..-,, 7,5: 4(4°,s, on_o:,0,-°a, Workers Compensation 800.00 60.24% 0.00 25.441,00 800.00 318.09 9.766.65 100.00'0 1,283.16 Developer escrow offset cost recovery 0,00 -100.00"/o 0.00 itt(t.)1(0) (1.283.16) 0.00 786.01 Office Supplies 1,800.011 31.33% I 50.00 150.00 Primed Forms 750.00 0.00Vo 33(61.(1.))00 255:0000 100.00% 56199 750.00 58.22'1-) Engineering Services 20,000.00 66.36% 2.50.00 1.500.00 1.164.00 1 07 07 .. (6.1,0) °:00 . 1,350.00 I 5,57(5°T.(())1.?) 0.00 182:4214423(7;595 100.00u o Contract Services 60.000.00 44.26% 15,000.00 50.00 0,00 15.000.00 100.00% 45,000.00 13.272.01 36.553.25 4104,93;r: YTD includes East hien° Strong analysis costs related to potential 113RT line Postage 2011.00 3.23°/0 100,00% 150.00 6,45 ,95s37(3):),, (115.87) Nlilcage 250.00 1.18.35% 70.00 (0) .. ,0) (0) 100.00% 1.20% 0.00 Miscellaneous 500.00 40,00 0,00 20.00 40.00 50,00 1.100,1))(0)00:1) 100.00% 180.00 295.87 6.00 20.00 354.00 Dues & Subscriptions 600.00 3.33% 34 65 l(1) . (ji) t( 1) (TOO4103(3)10°0° -964;3567:: Book 3 300.0(1 40.67% 50.00 25.00225.00 122.00 Conferences ...V. Training 2,000.00 68.50% 500.00 7(0.00 253)0 (210.00) 1,500.01) 194,332.511'37(j1R130.00 45,78% Total Planning & Zoning 284,682.35 68.26% 32,406.72 26,106.79 6,299,93 -42,00% . 19,44% 211,871.3317,538.82 8.67",-0 8.28% 1930 - Engineering Services Engineering Services Total Engineering Services 48,000.00 57.29°/ 4,000.00 48,000.00 57.29% 4,000.00 I I 60.00 2.840.00 7 I 1,160.00 2,840.00 71.00% 36.000,00 36,011)1.09 27,496.82 8,503.18 23.6240 27,496.82 8,503.18 23.62% 1940 - City Hall Cleaning Supplies 50.00 0.00% 0.00 0.00 0.00 0,00`% 25.00 0.00 25.00 Building Repair Supplies 300.00 0,00% 25.00 0.00 25.00 I 00.00°,0 225.1)0 0.00 225.00 ULiliiies 7,500.011 48.95% 500.00 437.28 62.72 12.54% 5,250.00 3.671,60 1,578.40 Refuse 600.00 150.59% 50.00 112.94 (62.94) -1 25,88°,i) 450.00 903.52 (453,52) Repairs/Maint Contractual Bldg Repairs/Maint Contractual Equip Facility Lease Miscellaneous Total City Hall Total General Government 6,000.1)0 116.15Vo 500.00 10,800.00 74.57/0 900.00 29,532.00 75.00% 2.461.00 300,00 559.011°/9 25.00 55,082.00 78.83% 4,461.00 858.51 (358.5)) -71.7000 1,032.41) ((32,40) -14.7Pfo 2.461.0)) 0.00 (1,00% 8439 (59.89) -239,56% 4,987.02 (526.02) -11.79% 935,352.47 1 00.59'11; 92,059.66 123,629.32 (31,569.66) -34.29V,, 4,500,00 8, I 00,00 22.149,00 225.00 40,924.00 71)4,436.35 6,969.15 (2,469.15) 8,053.34 46,66 22,149.00 0,011 1.676.99 (I,451.99) 43,423.60 (2,499.60) 100.00",, 100,0W o 30.06% -100.78°0 YTD updated lo move S.3.2k bill to Capra to Fire Dept : Fire -54.87% Station 01 Sever connection work 0.58% 0.011% -645.33% -6, I 1 "/0 940,827.62 (236,391,27) -33.56% DetaiL4 DEN' 420 - PUBLIC SAFETY Full Year I MONTH YI D HI)[)GET BUDGET ACTUAL Variance t 5) Variance (1/4) BUDGET ACTUAL Variance (5) Variancc 0'01 2100 - Police 2016 'Is to, date Month Month Tooth Month VTD YTD YTD YTD Law Enforcement Contract 527,060.47 48.12% 0,00 0,00 0.00 0.00% 263,530.24 253,612,02 9.915.22 3.767,, Total Police 527,060.47 49.12% 0.00 0.00 0.00 0.000/, 263,530.24 253,612.02 9,918.22 3.76% 2150 - Prosecution Attorney Criminal 54,700.00 60.84% 4.600.00 3,505.81 1.094.19 23.79% 40,901)1)0 33.277.51 7.622.49 18.64" s Total Prosecution 54,700.00 60.84",), 4,60(1.00 3,505.81 1,094,19 23.79% 40,900.00 33,277.51 7,622,49 18.64% 2221) - Fire FT Salaries 70,300.00 77.82% 5,407.69 8,419.59 (3,0)1.9(1) -55.700.s, 51,373.08 54,706.81 (3,333,73) -6.49'. PT Salaries 110,000-00 58.710X, 9,166.67 8.849,43 .317.24 3.46°-. 82,500.00 64,581.10 17.918,90 21.7255 PERA Contributions 11,388.60 91,14% 576.05 1J32.67 (856.62) -97.75% 8.322.44 10,379,43 (2,056.99) -24.7.250 FICA Contributions 7,388.33 60.97% 568.33 548.66 19.67 3.46°-0 5.399.17 4,504.7(1 894,47 16.571/4 Medicare Contributions 2,747.27 65.14% 211.33 239.84 (28.511 -13.490. 2,007.62 1,789.68 217.94 10.861/4 Health/Dental Insurance 14,846.00 73.29% 1,142.00 1,632,0)) (490.)0) 42.91% 10,549.00 10,880.00 (31.00) -0,295o Unemployment Benefits 0.00 0.00% 0,00 0.00 0.00 0.005i 0.00 0.00 0.00 0,00°. Workers Compensation 18,500.00 80.89% 0.00 0.00 0.00 0.00% 18,500,00 14,965.50 3,534.50 19.11% Office Supplies 85(1.1)0 133.611/4 70.00 19.22 50.78 72.54% 630.00 1,135.69 (505,69) -80.270), EMS Supplies 3,400.00 22.241/4 280.00 0.00 280.00 100,000.0 2,520.00 756.08 1,763.92 70.00')',, Fire Prevention 3,000.00 4.35% 250,00 0.00 250.00 100.00% 2,250.00 130.38 2,119.62 94.21% Fuel, Oil & Fluids 13,000.00 37.49% 1,100,00 504,42 595,58 54.14% 9,700.00 4,873.35 4.826.65 49.76% Small Tools & Equip 12,000.00 63.15% 1,000,00 5.114.73 (4.114.73) -411A7% 9.000.00 7,578.17 1,421.83 15.80% Physicals 3,904.00 29.82% 300,00 0.00 300.00 100.00% 3,000.00 1.164.00 1.836.00 61.20% Radio 18,097.51 61.27% 4,524.38 0.00 4.524.38 100.006o 13,573,13 11.087.52 2,455.61 18.31°,0 Mileage 5(1)1.00 162.71% 40,00 169.32 ((29.32) -323.30% 380,0),) 813.54 (433.54) -114.09% Insurance 8,307.00 87.76% 0.00 0.00 0.00 0.00% 8.307,00 7,290)81 1.017,00 12.24% Electric Utility 15,500.00 54.98% 1.200.00 697.06 502,94 41.91"0 11,600.00 5,521.64 3,078.36 26.540,0 Refuse 1,200.00 185.92"/0 100.00 266.38 (166.38) -166,38% 900,00 2,231.04 (1,331,04) -147.59% YTD updated to move 53.2k bill to Capra to Fire Dept from City Repair/Maint Bldg 15,250.00 67.39"/o 1,000.00 125.02 874.95 87.50% 12,000.00 10,276.37 1.723,63 14,36% Hall; Fire Station 01 Sewer conncriion work Repair/IYIaint Equip 25,650.0(1 94,73"/. 2,000.00 2.809,59 (309.59) -40,450.6 19.400,00 24.297.56 (4.897.56) -25.2.50.'. Uniforms 4,100.00 15.71% 450.00 336.1)0 114.00 25.33% 3.150.00 644.25 2,505,75 79.551-o Miscellaneous 2,000.00 94.37% 200,00 72,19 127.81 63.910. 1,500,00 1,887.35 (387.35) -25.825' Dues & Subscriptions 3,863,00 67.69°/0 320.00 0.00 320.00 100.000.8 2,880.00 2,615.00 265.00 9.20% Books 440.00 52.27% 40.00 230,00 (190.0)1 -475.00% 340,00 230.00 110.00 32.35% Conferences & Training 17,000,00 78.89"/0 4,000.00 1,000.00 3,000.00 75,00)8 12,000,00 13,411.35 (1,4)1.351 -11.761/4 Conferences & Training (Reimb) (6,000.00) 0.00% (1.500.00) 0.00 (1,500.00). -100.00°8 (4.500.00) (4,00(1,00) (.500,00) 11.11gs, Total Fire 377,231.71 61).)16% 32,746.45 32,766.12 (19,67) 287,581,44 256,750,51 30,830.93 10,72% 2250 - Firc Relief Fire State Aid 37,323.00 0.00% 0.00 0.00 0,00 0.00". 0.00 0.00 0.00 0.0096 Total Fire Relief 37,323.00 11.110%1 0.00 0.00 0.00 0.00% 0,00 0.00 0.00 0.011% Detail Full YC31MONTH 2400 - Building Inspection BUDGFI 1311DGET ACTUA1. Variance (S) Variance I'd 13111LX3ET 21)16 % to date Nlonth Month Month Month YTD VW FT Salaries 168,171.00 69.70°/. 12.936.23 18.819.18 (",883.05) -45.48°--. 121,894.19 117.218.61 PEPA Contributions 12,612.83 66.05% 9'(L22 1.411.47 (441.25) -45.4896 9,217.06 8_330.73 FICA Coniributions 10,426,60 67.55% 802.05 1.125.75 (323.710 -40.30°0 7.619.44 7.042.86 Medicare Contributions 2,438.48 67.55% 187.58 263.30 (75.72) -40,37% 1.781,97 1,647.13 IlealihiDental Insurance 29,692.00 59.29% 2.'84.00 3.381.00 (1,097.00) -48.03% 21.698,00 17,603,00 I nemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0,00 (1.00 Workers Compensation 5,000.00 29.28% 0.00 0.00 0.00 0.00% 2.500,00 1.463.81 Orlice Supplies 2,1(111.00 54.59"/. 175.00 0.00 I 75.00 I 00,00" 6 1,575.00 1,146.29 Printed Forms 700.00 0,00% 175.00 0.00 I 75.00 100.00°-. 525.00 UM° Fuel. Oil & Fluids 6,500.00 8.010/o 600.00 0,00 600,00 I 00.00°. 5,000.00 520.63 Engineering 14,00(1.00 18.86% 1,300.00 0,00 1.300,00 100.00% I 1,100.00 2,639.75 Inspector Contract Services 0.00 100.00"/. 0.00 0.00 0.00 0.00% 0.00 4,586.41 Mileage 200.00 0.00 % 0.00 0.00 0,00 0,00°. 0.00 0.00 Insurance 900,00 19.78% 0.00 0.00 0.00 0.11000 900.00 178.00 RepairsAlaint Equip 1,800.00 1.99% 150.00 0,00 150.00 100.009-r0 1.350.00 3.5.83 Uniforms 850.00 0.00% 70.00 0.00 70.00 IMMO% 630.00 0.00 Miscellaneous 725.00 47.16% 75,00 12.94 62.06 82.75% 555.00 341.88 Dues & Subscriptions 700.00 26.43% 60.00 0,00 60.00 100,00% 540.00 185,00 Books 725.00 120.111% 0.00 0.00 0,00 0,0000 725.00 870.08 New Truck 0.00 0.00% 0,00 0.00 0.00 0.00"-, 0.00 0.00 Conferences & Training 3,225.01) 19.22% 700,00 I 10.00 590,00 84.29% 2,550.00 620.00 Total Building Inspections 260,765,91 63,06% - 2(1,485,08 25,123.74 (4,638.66) -22.64% 191,160.66 164,430.01 2500 - Emergency Communications Contract Semices Total Emergency Communications 2700 - Animal Control Printed Forms Contract Services Miscellaneous (Impounding) Total Animal Control Total Public Safety 7,400,00 50,61% 1,850.00 0.00 7,400.00 50.61% 1,850.00 0.110 0.00 0.00% 0.00 0.00 7,550,00 91.32% 650.00 770.00 fLOO 0.00% 0.00 0,00 7,550.00 9132% 650.00 770.00 1,850 00 100,00° 1,850.00 100.00% 0.00 0.00% (120.00) -18,460-0 0.00 0.00" o (120.00) -18.46% YTD ACTUAL Valiance (5) YTD 5.675.58 886.33 576,58 134.84 4.095,00 0.00 1,036.19 428.71 525.00 4,479,37 8.460.25 (4.5564)) 0.00 722,00 1,314.17 630.00 213.12 355.00 (145.08) 0.00 1,930.00 26,7311,65 Variance 1'0 YTD 4.62% 9.62% 7.57°o 18.87% 0.00° '0 41,45% 27.22% 100.0(N 89,59% 76.22°o -100.00% 0.00% 97.35% 100,00°. 38.40% 65.74% -.20,01°0 0.00°6 75.69° 13.98% 5.550.00 3,745.00 1.805.00 32.529-0 5,550.00 3,745.00 1,805.00 32.52% 0.00 5,600.00 0.00 5,600.00 0,00 0.00 0.00', 6.895.00 (1,295.001 -23,130, 0.00 0.00 0.00°,0 6,895.00 (1,295.00) -23.13% 1,272,031,09 56.50% 60,331.53 62,165.67 (1,834.14) -3.04% 794,322.34 718,710.05 75,612.29 9.52% Detail_6 DEPT 430 - PUBLIC NVORKS Dull Year MONTI-1 Yr') BUDGET BUDGET :ke'llIAL. Variance (5) Variance ("o) BUDGET ACTUI\L N'ariance (5) Variance (%) 3100 • Public 1Vorks 2016 °0 to date Month Month ___ Mouth klunth Y4D NITD YTD YTD FT Salaries 169,779.011 111.50% 13.059.92 30,002.60 1(6.942.6S) -129,730s 1243)69.27 189.295.3) (65,2263)4) -52.57o YTD reflects payout of prior Director PTO balance 151.2k) YTD budget amount reflects correction: previously reponcd full PT Salaries 7,000.00 0.000 n 1.750.00 0.00 1.750.00 100.00° O 7.000310 0.00 7.000.00 100.00"-o year vs YID PERA Contributions 12,733.11 107.54°/s 979.49 2.250.20 (1.27)),711 129,730 9,305.20 13.693.64 (4.388,44) -47.160o FICA Contributions 10,526.30 I07.04% 809.72 1.772.09 (962,37) -113.85% 7.692,29 11.267.31 (3.575.52) -46,48% Medicare, Contributions 2,461.80 107.05% 189.37 414.47 (225.10) -118.87% 1,799.00 2,635.4)) (830.40) 46.49"o Ili:alai/Dental Insurance 44,759.00 79.07% 3.443.00 5.415,00 0,972.00) -57.26°o 32.708,50 35.389.00 (2,680,50) Unemployment Benefits 0,00 0.00% 0.00 0.00 0.00 0,0000 0.00 0,00 0.00 0.000 Workers Compensation 18,000,00 77.65"/o 0.00 0.00 0.00 0.00'0 18.000.00 13.977,59 4,02141 22,35% Onice Supplies 2,000.00 54.23% 170,00 31.62 138,33 S 1.40% 1,490.00 1,034.54 405.46 27.21% Shop Materials 2,000.00 117.02% 165.00 34,84 130.16 78,88% 1,485,00 2,340,35 (855.35) -57.6090 Building Repair Supplies 500.00 319.49% 40,00 0.00 40.00 100.009-'0 360,00 1.597,47 ((,237,47) -343.74°o Small Tools and Minor Equip 1,200.00 221.67% 100,00 52,99 47.01 47.01% 900.00 2,660.03 ( t.760.03) -195.56% Engineering Services 12,000.00 36.48% 1,000.00 72.00 923.00 92.80% 9,000310 4,377.50 4.622.50 51,36% Contract Services 1,000.00 405.83% 0.00 576.45 (576.45) -100.00% 500.00 4,058.30 (3.558.30) -711.66% Radio 1,300.00 47.55% 325,00 0.00 325,00 100,00% 975,00 618.12 356.88 36.60% !Mileage 0.00 0.00"/0 0.00 0.00 0,00 0.00", 0.00 0.00 0,00 0.00',, Insurance 16,0(10.00 94.41% 0.00 0.00 0.00 0.00°., 16,000.00 15.105,00 895,00 5.59% Electric Utility 28,000.00 49.60"/o 1.500,00 662,43 837,57 55.34°,0 19.000,00 13,887.76 5.112,24 26.91°0 Refuse 2,500.00 77.33"/0 225.00 216,67 3,33 3.70% 1.900.01) (.933.36 (33.36) Fuel, Oil. Fluids (All. dews) 42,000.0)) 37.79°A 2,500.00 397.54 2,102.46 34.10% 30,000.00 15,371.66 14.128,34 47.09° o Repair/Maint Bldg 4,000.00 162.71% 330.00 0.00 330.00 100.00% 2.970,00 6,508.56 (3,538.56) -119.1400 Repair/Maint NO`f Bldg 500.00 33.00% 40.00 0.00 40,00 100,0000 360,00 164.99 195,01 54. I 7"/0 Repair/Mint Equip (in) 2,400.00 185,47% 200,00 1,332.80 (1.182,801 -591.40° ii 1,800.00 4,451.16 12.651.10 -147.29% 11.cpairiMaint Equip tou0 5,000.00 111.38^/0 400.00 0,00 400.00 100.00% 3,800.00 513,33 3.281.17 36.3500 Equipment Parts 8,000.110 4.41% 625.00 0.00 625,00 100.0000 5.925.00 352,52 5.572.43 94.059-0 Uniforms 3,600.00 94,14% 300,00 160.25 139.75 46.53% 2,70030(1 3.383.87 (688.87) -25.5100 Miscellaneous 1.000.00 76.40% 100.00 0,00 100,00 100.00% 350.00 763.95 86,05 10,12% Landscaping. Material 500.00 0.00% 0.00 0,00 0,00 0.00% 500,00 0.00 500,00 100.00% Dues & Subscriptions 21)0.00 72.00% 50,00 45.00 5.00 10,0000 150.00 144,00 6.00 4,00°0 Conference & -Fraining 4,425.00 76.13°/ 375,00 3.273,74 (2.893.74) -773.00% 1.125.0(1 3,363.74 (2,243.74) -199.44".0 Includes 53.1k for annual safety training Personal Protection Equipment 2,400,00 11.00°,4 200„00 0.00 200,00 100.00°, 1,800.00 0.00 1,800.00 100,00% Clean up Days 5,500.00 161.050 0.00 0.00 0.00 0.00°0 5.500.00 8,857,78 (3.357.73) -61,050, Total Public NVorks I 411,284.21 87.12% 28,876.50 46,760,69 (17,884.19) -61.93% 309,664.26 358,312.24 (48,647.98) -15.71% 3120 -Streets Equipment Parts 3,000.00 0.66'/, 250.00 0.00 250.00 100.000 2.250.00 19,94 2.230.06 Street Maintenance Materials 20,000.00 59.93% 2,000.00 0.00 2,000,00 100.00% 1731003)0 11,935.90 5,014.10 Seal Coating/Crack Filling 210,000.00 123.72% 0.00 0.00 0.00 (1,000,0 210,000.00 259,307,25 (49,807.25) Mill and Overlay Program 160,000,110 0.00% 0,00 0.00 0.00 0.000o 160.000.00 0.011 160,000,00 Sign Repair Materials 2,500.00 85.07°A 200,00 0,00 200,00 100.00% 2.100.00 2,126,67 (26.67) Contract Services - General 10,000.00 23.27% 2.000.00 517.50 1,432,50 74,130, 10,000.00 2,327.21 7,672.79 Contract Services - ROW 5,000.00 0.00% 0.00 0.00 0.00 0.00% 5.000.00 0,00 5,000.00 Repairs/MainEquipment 2,5011.00 30.31% 210.00 27.57 182,43 36.870, 1.890.00 757.75 1,132,25 Tutal Streets 413,000,00 67.403% 4,660.00 545.07 4,114.93 88.30% 408,240.00 277,02.4.72 131,215.28 99.11% 29,49% -23.721o. `CM variance is a timing issue 100.00% YTD variance is a timing issue -1.27% 76.73% 100.00% 59.91', 32.14% Detail_7 Full Vear MONTH 3125 - Ice & Slum Removal BUDGET BUDGET ACTUAL Variance (S) Variance t"'01 2016 "-t, to date NIonth NIonth Month Month Landscaping Material 750.00 0.00% 250.00 518.37 (268,371 -107,35110 Sand/Salt 70,000.00 39.82% 0.00 3,117.78 (3.117.780 -100.00"0 C'ontraci.SerViC0 4,000.00 0.00% 0.00 0.00 0,00 0,00% RepairsiNlaint Equipment 12,500.00 39.37/0 1,250.00 1,776.66 (526,66) -42.13% Tutal lee & Snow Removal j 87,250.00 3-8.65% 1,500.00 5,412.81 (3,912,81) -260.85% 3161) - Street Lighting Street Lighting Total Street Lighting 26,4011.00 72.89% 2.200oo 26,400.00 72.89°/. 2,200.00 3200 - Recycling Recycling Supplies 3,5110.110 0.00% 0.00 Miscellaneous 2.400.00 0.00% 200,00 Total Recycling 5,9011.011 0.00% 200.00 3250 - Tree Program Contract Services Total Tree Program Total Public NVorks 1,000,00 61.45% 0 00 1,000.110 61.45% 0.00 l'ID BUDGET ACTUAL Variance (6) Variance (0) yrr) VIP YTD YID 750.00 927,50 ( I 77.501 -23.67°0 35.000.00 27,875.05 7,124.95 20.36"0 2,000.00 0.00 2,000.00 100.00% 9,500,00 4.1/21.27 4,578.73 48.20% 47,250.011 33,723.82 13,526.18 28.63% 2.260,8.5 (60,85) -2,77% 19,000.00 19.243.44 556.56 2,81'0 2,260.85 (60.851 -2.77% 19,800,00 19,243.44 556.56 2.81% 0 00 0 00 0.011 0.00 0.00°i, 1,750.00 0.00 1,750.00 100,00% 200.00 100.000o 1,800.00 0.00 1.800.00 100.000 200.00 100,00°/0 3,550.00 0.00 3,550.00 100.00% 0.00 0 00 0.00o 1,000.00 614.50 385.50 38 55°,, 0.00 0.00 0.00% 1,000.00 614.50 385.50 38.55% 944,834.21 72.9 1°/0 37,436.50 54,979.42 (17,542.92) -46.86% 789,504.26 6 8,918.72 100,585.54 12.74 %_ Required contracted salt dclively Detail_8 DEPT 450 - CULTURE, RECREATIO Full Year BUDGET 52011- Parks & Recreation 2016 Fr Salaries 115,254.00 PT Salaries 32,500.0(1 PERA Contributions 8,644.05 FICA Contributions 9,160.75 Medicare Contributions 2,142.43 Health/Dental Insurance 19,1119.110 Unemployment Benefits 0,00 Workers Compensation 4,700,011 Shop Materials 1,000.00 Chemicals 1.500.00 Equipmem Pans 4,000.0(1 Building Repair Supplies 50(1.00 Landscaping Materials 2,000.00 Small 'fools and Minor Equip 2,000.00 Mileage 0.00 Insurance 3,200.00 Electric Utility 9,500.00 Refuse 1,500.00 Repair/Maint Bldg 1,809,00 RepairiMaint NUT Bldg 3,0011.00 Repair/Maint Equip 1,500.00 Rental Buildiugs 6,0110,00 Personal Protection Equipment 1,200,00 Miscellaneous 1,200.00 Total Parks & Recreation j 231,320.23 1T & Telephone ITT lardware 3,000.1)0 IT -Software 8,156.00 1T-Support Services 50,000.00 1T-Networking 0.00 INET Contimiency 0.00 Telephone 20,820.00 Total IT & Telephone 81,976,00 Grand 'Iota! all Expenses 3,465,514.00 Subtotal Net Income over Expenses 20,000.00 DEFT 460 - COMP AD.1 20,000.00 Dehl Service increase 0.00 Transfer to City Projects (Streets) 0.00 DEPT 493 - OT11 FINANCING 41.410 GRAND TOTAL EXP ALL DEPTS 3,485,514.00 Net Ineonte oer Expense MOO MONTH YTD 13111/GET AC-11;AI. Variance (S) Variance (°o) 1311DGET ACTUAL Variance (S) Variance (%) "0 to date Mom11 ii.lotilli Month Month YID 1"ID Y ED YTD 52.506o 8.565.69 6,331,88 2,533.81 28.58% 84.224.08 60,508.84 23.715.24 28.16°0 88.95%- 2,500.00 6,154.50 (3.654.50) -.146.180o 23,750,00 28.€108.75 (5,158.75) -2),720. 55.55% 664,93 575.74 89.19 13.410o 6,316.81 4.801.37 1.515.44 23.99% 56.32% 704.67 745.42 (4)).751 -5.78% 6.694.39 5,159.05 1,535.34 22.93'. 56.31% 164.80 174.28 (9.48) -5.75'0 1.565,62 1,206.48 359.14 22.94°-. 76.28% 1.463.00 2,176.20 (713.20) ,48,75°.. 13,898.50 14.508.00 (609,50) -4.390 0.011% 0.00 0.00 0.00 0,00°.0 0181 0.00 0.00 0.000-0 92.34% 0.00 0.00 0.00 0.00°0 4,700.00 4.34(1.16 359,84 7.66% 139.85% 78.00 39.9S 35.02 46.690. 775.00 1,398.45 (623.45) -80.45% 70.49% 125.00 0.00 125.00 100.000o 1,125.00 1,057.42 67.58 6.010o 4130"/o 330.0() 96.80 233.20 70.67% 2.970.00 1,652.15 1.317.85 44,370,4 123.77"/o 40.011 0,0(1 40,00 100.00% 360.00 618.86 (258.86) -71.9 1.".-',, 68.95% 166.00 0.00 166,00 100.00% 1,494.00 1378.97 115.03 7.71100 44.480/a 150,0(1 0,00 150.00 100.000o 1.550,00 889.38 660.42 42.610 0.00% 0.00 0.00 0.00 (1.011°. 0,00 0,00 0.00 0.0000 96.22% 0.00 0,00 0,00 0.00% 3,200.00 3,079,00 121.00 3.78% 67.00% 700.00 397.88 302.42 43.16% 6,800.00 6.364.82 435.18 6.670/u 125.00 0.00 125.00 100.00% 1,125.00 100.00 1,025.00 91.11% 10.19% 150,00 19,98 130,02 86.680-.0 1,350.00 183.46 1,166.54 86.410-. 98.38% 250.00 292.10 (42.111) -16.844'" 2,250.00 2.951.37 (7(11.37) -31,170. 139.02% 125,0)) 0.00 115.00 100.009,. 1,125,00 2,085.34 (960.34) -85.36% 72.86% 500.00 826.00 (326.00) -65.2000 4,500,00 4,371.48 128,52 2.860 25.82% 100,00 0.00 100.00 100.0000 900.00 309.84 590.16 65.570.0 1.87% 100.00 0.00 100,00 I Oa , 0 0 % 900.00 22.42 877.58 97.5 P2o 63.07% 17,299.09 17,830.76 (531.67) -3.070/, 171,573,40 145,895.81 25,677.59 14,97u/o 93.33% 62.63% 75.81% 0.00% 0,00% 68.97% 73,40% 71.98% 1322.76% 0.110% 0.00% 0.00°A 0.00% 71.56% 0.00% 0.00 1.335,00 ((,335.00) 0.00 0.00 0.01) 4,165.00 4,211,25 (46.25) 0.00 0.00 0.00 0.00 0.00 0.00 1,735.00 1,536.64 198.36 5,900.00 7,082.89 (1,182.89) 213,026.78 265,688.06 (52,661,28) ((02,711.78) (35,874.05) 66,837.73 0.00 0,00 0.00 0.00 0.00 0.00 0,00 0.00 0,00 0.00 0,00 t1.00 213,026.78 265,688.06 (52,661.28) (102,711,78) ' (35,874,05) 66,837.73 -100.00% 1,500.00 2.800.00 (1.300.00) -86.67% 0,0000 8,156.00 5,107.83 3,048.17 37.370„ -1.110 37.485,00 37,906.75 (421.25) -1,17% 0.00% 0,00 0,00 0,00 0.00°. 0.000, 0.00 0.00 0.01) 0110% I 1.43°-, 15.615.00 14.355.90 1,256.10 8.04°,20 -20.05% 62,756.00 60,172.98 2,583.02 4.12% -24,72% 2,522,592.35 2,494,352.20 34,515.85 1.37% 65.07% (4(6,915.04) 264,552.92 687,743.66 -164.96°/o 0.00° o 20.000.00 0.00 20,000.00 100.110% 0.00% 0.00 0110 0.00 0100.. 0.000,-. 0.00 1).00 0.00 (10000 (1.00°0 0,00 0.00 0.00 (IMO'. -24.72% 2,542,592.35 2,494,352.20 54,515.85 2.I4% 65.07% (436,9(5.04) 264,552.92 701,467.96 160.55% 1.i101.0.1‘171.1.411 .1790 Ilti(b.).21 ro Actual 10'18,2016 2016 Bv Month ;As of September 31), 2016 2061 ihrary Entid Bv Depannient Full Year Month YID B1 DG17:f 2016 2016 Over2016 2016 Over' 2016 '); to dale BUDGE. r Acru,NLS (under) 1.31.11..X7F1, AC-ruAl.s kinder) Notes REVENUE Current Ad Valorem -Faxes 250,357.00 50.00% 0,00 0.00 0.00 128,478.50 128.478.50 0.00 Funds received f roin WA Cty July and December Rental Income 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 lnierest Eamings 0,00 0.00% 0.00 ((.0(1 0.00 0.00 0,00 0.00 Miscellaneous Revenue 0.00 0.00% 0.00 1.75 1,75 0.00 2.50 2.50 Donations 0.00 100.00% 0.00 0,00 0.00 0.00 10,970.00 10,970.00 Includes grant proeeeds of SlOk 114111113renter ('.In Fowl Revenue 256,957.00 5-1.270, 0.00 1.75 1.75 128.478.50 139,451.00 10,072.5(1 EXPENSE: (Owl)), (Over) under under VI Salaries 46311.07 79.98% 3,680,84 5,712.00 (2.03).16) Pi Salaries 26.260.00 70.05% 2,020,00 3.068.67 (1.048,(17) VERA Contributions 4,277.55 97.61% 368.54 658.55 (290.011 FIC:\ Contributions 3,479.51 95,54°,0 315.17 525.54 (2)0.37) Medicare Contributions 813.78 95.54% 73.71 122.92 (49.21) HealilMental Insurance 14,144.00 76.929O LOSS 00 (.632.00 (544.00) Unemployment Benefits 0.00 0.00% 0,00 0.00 0.00 Workers Compensation 0.00 0.00% (1.00 0.01) 0.011 Library SVes supplies 1,100.01 0.00% 91.67 0.00 01.1,7 Office Supplies 3.600.00 61.80% 300,00 397.65 (97.65) Libraty Colleclion Maintenance 42,811.08 120.96% 2,000.00 8,840,41 (6,840.411 Legal Services 1.500.00 223.88% 125,110 0.00 125.00 Contract Services 6,000.00 0.00% 500.00 0.00 500.00 Engineering Services 0.00 0.00`b, 0.00 0.00 0.00 Telephone 1,560.00 95.19% 130.00 (82,89 152.89) Internet 1,800.00 43.20% 150.00 50.64 99.36 Information Technology (Equilic 3,100.00 0,00% 0.00 0.00 0.00 Software 0,00 0.00°/0 0.00 0.00 0.00 Insurance 2,000.00 81.85% 0.00 0,00 0.00 Utilities 7,500.00 60.55% 500.00 699.87 (199.87) Refuse 600,00 117.60% 50.00 86.39 (36.391 Repaio Main( Bldg 12.000.00 157.22% 1,000,00 470.00 530.00 RepairlMo int NOT 1391g 0,00 100.00% 0.00 13,285.76 (13,285.761 Repair/NI:nut Equip ( out-L 13 han 0.00 0.00% 0.00 0.00 0.00 Library Card Reimbursements 12,000_00 211.10% 0,00 3,294,9(1 (3.294,90) WA Cty Svc Fee 9,300.00 0.00% 1,000.00 0.00 1,000.00 Library Service Improvements 46,001)1(0 (1.1100.,” 0,00 0,00 0,00 Miscellaneous 1,80000 20.55% 150.00 0.00 150,00 Building Puraase Remit! 0.00 0.00% 0.00 0.00 (400 Building-Propeny lax 1,000.00 0.00% 0.00 0.00 0.00 Other Equipment 0.00 0.00% 07)0 0.00 0.00 Subscriptions 0.00 0.00% 0.00 0,00 0.00 Conferences ,Sx'' Training 3,500,00 0.00% 1.250.00 0,00 1,250.00 Programs ..4500.00 0.00% 300.00 0.00 300.00 Internal charges 0.00 100.00% 0.00 0,00 0,00 Total Library 256.957.00 79.189), 15.1)92,93 .49,028.19 123,935.261 Net Inconte/iEvperviel 0.00 12,31115 Cash Balance 5.092.93) 139712(1.44) 33,758.18 19.190781 3.112.2S 2.518.59 589,05 10.336.00 0.0(1 0.00 825.03 2.700 00 36.000.00 1,37.5.00 4,500.00 0.00 1.170.00 1.35(1.00 3.100.00 0.00 2,000,00 5.400.00 450.00 9.000.00 0,00 0.00 17,000710 6,000.00 46.000.00 1.330 00 0.00 500.00 0.00 0,00 3.500,00 3.600.00 0.00 210,324.13 (23.033.51) (8).845.631 37,037.30 18.631.48 4.175.10 3.324.'2 777.50 10.880.00 0.00 0.00 1(1)0 2.224.96 55,635.79 3.358.25 0.00 0,00 1,484,91 777.56 0.00 0,00 1,637.00 4,541.56 705.62 18,866.75 13,380.18 0.00 25.3,31.57 0,00 0710 369.94 0.00 0.00 0.00 0.00 314.00 ((00 10.00 2113.463,98 121 558.52 (1,062.9 i I (805.63) 1(88.45) (544.00) 0.00 0.00 825.03 475.04 ((9.635.79) (1.983.251 4,500.00 0.00 (314.911 572.44 3.100.00 0.00 363.00 858.44 (255.(.2) (9,866.75) (13380.181 0.00 (13,331.57) 6,000.00 46.000.00 980.06 0.00 500,00 0.00 0.00 3.186.00 3.600.00 (10,00) 6.860.15 (64.0)2.081 17.832.65 158.371'7,, ..21.79% 232.917,24 260,688,75 Net Income,(Expensel 0.00 Accni(1d AP CI l' (self funded) 130,0(30,00) Contingencies 0.110 2()14 AP accrual rever),a1 (64.012.081 (41.85) Libnny Renovations Parking 1_,A Design \ Vlut Ending Cash Balance 202,917.24 106.633.92