Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
#4 CC 9 15 15 August Financials (3)
Ciry of Lake Elmo 2015 By Month Budget to Actual Comparative For the month ending August 3 I. 2015 10I-General Fund Summary By Department. DEPT 410 - GENT, GOV'T REVENUE Total Revenue Full Year BUDGET 2015 3,798,334.00 % to date 53.68% EXPENSE Total Mayor & Council 40,955.00 70.95°/0 Total Administration 407,316.00 80.93% Total Elections 1,050.00 206.76°/0 Total Communications 70,842.00 38.30% Total Finance 134,647.00 63.28% Total Planning & Zoning 224,218.0(1 73.38% Total Engineering Services 54,800.00 52.8511/0 Total City Hall 50,235.00 86.88% Total General Government 984,063.00 72.18% DEPT 420 - PUBLIC SAFETY Total Police 517,799.00 50.92% Total Prosecution 50,000.00 73.25% Total Fire 385,312.00 60.67% Total Fire Relief 37,323.00 0.00% Total Building Inspections 323,558.00 34.95% Total Emergency Communications 7,000.01) 53.50% Total Animal Control 6,800.00 72.06% Total Public Safety 1,327,792.00 49.39% I 56,664.55 9/15/2015 MONTH YTD BUDGET ACTUAL Variance (S) Variance (%) BUDGET ACTUAL Variance(S) Variance CYO Month Month Month Month YTD YTD YTD YTD 138,695.25 93,111.68 (45,583.57) -32.87% 2,099,572.5(1 2,039,064.03 (60,508.47) -2.88°A, 1,000.00 661.88 338.12 33.81% 22,877.66 29,055.65 (6,177.99) -27.00% 28,837.37 36,388.85 (7,551.48) -26.19% 278,330.28 329,637.61 (51,307.33) -18.43% 0.00 0.00 0.00 0.00% 1,000.00 2,171.03 (1,171.03) -117.10% 4,887.77 350.00 4,537.77 92.84% 45,271.03 27,135.62 18,135.41 40.06% 7,858.23 6,978.21 880.02 11.20% 97,634.97 85,198.00 12,436.97 12. 74"/o 16,555.63 28,298.78 (11,743.15) -70.93% 146,730.24 164,543.37 (17,813.13) -12.14% 4,600.00 1,758.00 2,842.00 61.78% 36,400.00 28,962.90 7,437.10 20.43% 4,161.00 5,598.41 (1,437.41) -34.54% 33,616.00 43,644.66 (10,028,66) -29.83% 67,900.00 80,034.13 (12,134.13) -17.87% 661,860.18 710,348.84 (48,488.66) -7.33% 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% 33,50(1.00 36,625.00 (3,125.00) -9.33% 27,250.47 32,322.84 (5,072.37) -18.61% 255,930.42 233,756.30 22,174.12 8.66% 0.00 0,00 0.00 0.00% 0.00 0.00 0.00 0.00% 24,649.08 13,740.04 10,909.04 44.26% 217,174.66 113,099.49 1(14,075.17 47.92% 0.00 0.00 0.00 0.00% 3,500,00 3,745.00 (245.00) -7.00% 565.1)0 510.00 55.00 9.73% 4,520.00 4,900.00 (380.00) -8.41% 51,085.38 5,579.17 9.85% 773,524.58 655,770.88 117,753.70 15.22% Summary_l MONTH YTD BUDGET ACTUAL Variance (S) Variance (%) BUDGET ACTUAL Variance (S) Variance (%) DEPT 430 - PUBLIC WORKS Month Month Month Month YTD YTD YTD YTD Total Public Works 380,195.00 59.27% 25,807.69 24,416.30 1,391.39 5.39% 256,172.88 225,326.82 30,846.06 12.04% Total Streets 222,578.00 84.28% 4,760.00 4,410.88 349.12 7.33% 215,158,00 187,587.99 27,570.0 I 12.8104 Total Ice & Snow Removal 95,500.00 58,09% 1,350.00 21,915.11 (20,565.11) -1523.34% 55,300.00 55,479.58 (179.58) Total Street Lighting 28,000.00 54.65% 2,350.00 2,043.81 306.19 I3.03% 18,800,00 15,301.36 3,498.64 18.61% Total Recycling 9,500.00 5.98% 500.00 0.00 500.00 100.00% 5,750.00 568.03 5,181.97 90.12% Total Tree Program 6,000.00 0.00% 500.00 0.00 500.00 100.00% 4,000.00 0.00 4,000.00 100.00% Total Public Works 741,773.00 65.28% 35,267.69 52,786.10 (17,518.41) -49.67% 555,180.88 484,263.78 70,917.1(1 1177°4 DEPT 450 - CULTURE, RECREATION Total Parks & Recreation 153,028.00 I04.67% 11,310.74 20,500.73 (9,189.99) -8L25% 102,615.43 160,169.00 (57,553.57) -56.09% IT & Telephone 109,560.00 44.03% 6,388.00 1,036.52 5,351.48 83.77% 75,554.00 48,234.76 27,319.24 36.16% GRAND TOTAL ALL EXPENSES 3,316,216.00 62.08% I 177,530.98 205,442.86 (27,911.88) -15.72% 2,168,735.07 2,058,787.26 109,947.81 5.07% SUB TOTAL NET INC OVER EXP 482,118.00 -4.09% I (38,835.73) _ (112,331.18) (73,495.45) -189.22% (69,162.57) (19,723.23) 49,439.34 71.50% DEPT 460 - COMP ADJ 35,000.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% Debt Service increase 247,118.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,798,334.00 54.20% 177,530.98 205,442.86 (27,911.88) -15.72% 2,168,735.07 2,058,787.26 109,947.81 5.07% Net Income over Expenses 0.00 0.00% I (38,835.73) (112,331.18) (73,495.45) -189.25% (69,162.57) (19,723.23). 49,439.34 71.48% Sumniary_2 City of Take Elmo 2015 By Month Budget to Actual Comoarativc For thc month ending August 3 I. 2015 101-General Fund Detail By Department oErr 410 - GENL COV'T 9/15121)15 Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance (5) Variance (%) BUDGET ACTUAL Variance ($) Variance (%( 2015 % to date Month Month Month Month YTD YTD YTD YTD YTD variance notes REVENUE Current Ad Valorem Taxes 2,531,080.00 45.80% (1.00 0,00 0.00 0.00% 1.265.540.00 1,159.178.20 (106,361.80) -8.40% Delinquent Ad Valorem Taxes 15,000,00 168,99°/0 0.00 0.00 0.00 0.00° (-, 7,500.00 25,347.86 17,847.86 237,97% Mobile I tome Tax 11,400,00 56.33% 0.00 0.00 0,00 0.00% 5,700.00 6,421.42 721.42 12.66% Fiscal Disparities 160,000.00 69.25% 0.00 0.00 0.00 0.00% 80,000.00 110,796.92 30,796.92 38.50% Penalty & Interest on Taxes 700.00 160.65% 0,00 0.00 0.00 0.00% 350.00 1,124.58 774,58 221,31% Liquor License 8,350.00 97.60% 0.00 0.00 0.00 0.00% 5,350.00 8.150.00 2,800.00 52,34% Wastehauler License 1,680.00 28.57% 0.00 0.00 0.00 0.00% 840,00 480.00 (360.00) -42.86"(, General Contractor License 0.00 0.00"/o 0.00 (1.00 0.00 0.00% 0.00 0.00 0.00 0.1311;i, Heating Contractor License 2.500,00 108.00% 200.00 300.00 100.00 50.00% 4,700.00 2,700.00 1,000.00 58.82% Blacktopping Contractor License 0.00 ().00% 0.00 0.00 0,00 0,00% 0.00 0.00 0.00 0.00% Building Permits 517,600.00 46,56% 43,130,00 38,531.20 (4,598.80) -10.66% 345,040.00 240,977.61 (104,062,39) -30.16% 16 new home permits in Aug; YTD al 75 new homes (9 Open space) Building Re -inspect Fecs 1,000.00 0.00% 100,00 100,00 0,00 0,00% 700,00 100,00 (600.00) -100,00% Heating Permits 29,040,00 64.04% 2,420.00 2.220.00 (200.00) -8.2690i 19,360.00 18.597.45 (762,55) -3.94% Plumbing Permits 29,040.00 86.16% 2,420.00 5.100,00 2,680.00 110.74% 19,360.00 2.5,022.00 5,662.00 29,25% Sevier Permits 10,560.00 0,00% 880.00 0,00 (880,00) -100.00% 7,040.00 0.00 (7,040.00) -100.00% Animal License 2,500.00 79.84% 40.00 70.00 30.00 75.009', 2.340,00 1,996.00 (344,00) -14.70% Utility Permits (ROW) 5,000.00 726.38% 1,000.00 14,148.00 13.1.48,00 1314.80% 4,000.00 36,319.00 32,319,00 807.983', Driven by development act(‘ (y Burning Permit 2,250.00 60.44% 500.00 90.00 (410.00) -S2.00% 1,500.00 1,360.00 (140.00) Massage Therapy Licenses 150.00 16.67% 0.00 0.00 0.00 0.00% 75.00 25,00 (50.00) -66.67% Electrical Permit 6,051.00 122.54°A 500.00 2,283.03 1,783.03 356,61% 4.000.00 7,414.65 3,414.65 85.37% Homestead Credit Aid 0.00 0,00% 0.00 0.00 0.00 0.00% 0.00 OM 0.00 0.009:0 MSA-Maintenanee 101,696.00 117.47% 50.848.00 0,00 (50,848.00) -100.00% 101,696.00 119,464.00 17.768,00 17,47%, MSA funding increase for 2015; 2nd pm t budgeted Aug, reed July State Fire Aid 41,500.00 0.00% 0.00 0,00 0,00 0.00% 0,00 0.00 0.00 0,00% PERA Aid 2,749.00 50.00% 0,00 0.00 0,00 0.003", 1,374.50 1,374,50 0.00 0.003', Gravel Tax 0,00 0.00% 0.00 0.00 0.00 0,009', 0,00 0,00 0.00 0.00°-'0 Recycling Grant 15,500.00 0.00% 15,500,00 0.00 (15,500,00) -100.00% 15,500.00 0,01) ((5,500.00) -)00.00% Misc State Grant/Surcharge Rev 500.00 I36.96% 0.00 0.00 0,00 0.009'i 250.00 684,80 434.80 173.92% Represents quarterly surcharge timely filing credit Cable Franchise Revenue 45,000.00 15L40% 0.00 0.00 0.00 0.00% 45,000,00 68,129,10 23,129.10 51.40% Rec'd participant distribution of excess tending Zoning & Subdivision Fees 7,500.00 291.80% 1,500.00 1,345.00 (155.00) -10,33% 5.250.00 21,885.00 16,635,00 316.86% Very few zoning permits budgeted in 2015 Plan Check Fees 181,923.00 75.20% 15,160.25 22.580,61 7,420.36 48.953", 121.282.00 136,304.94 15,522,94 12.309, Sale of Copies. Books, Maps 175.00 36.29% 25,00 1.00 (24.00) -96,00% 100.00 63,50 (36.50) -36.5091, Assessment Searches 750.00 200.00% 150,00 225.00 75,00 50,009' 615.00 1,500.00 885.00 I43.90% Clean Up Days 2,000.00 180.75% 0,00 0,00 0.00 0.009', 2,000.00 3,615.00 1,615.00 80,75% Cable Operation Reimbursement 2,500,00 32.039', 0.00 0.00 0,00 0.00% 1,250,00 800.63 (449,37) -35.95% Fines 48,000.00 6731% 4,000,00 6,1(19,84 2,109.84 52,75°/0 32,000.00 32.308.42 308.42 0,969s Fines below average but typically increase in the spring/summer Miscellaneous Permits 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% Eire Billable Revenue 500.00 100,00% 0,00 0,00 0.00 0.0066 0,00 500.00 500.00 100.006) Miscellaneous Revenue 3,500.00 157A Wo 300.00 0,00 (300,00) -100.00% 2,300.00 5,509,45 3,209.45 139,54% Internal Charges 640.00 64.69% 22.00 8.00 ((4.00) -63,64% 560.00 414.00 (146.00) -26.07% Interest Earnings 10,000.00 0,00% OA 0.00 0,00 0,00% 0,00 0.00 0.00 0.00% Donations 0.00 0.00% 0.00 0,00 0.00 0.00% 0,00 0,00 0.00 0.006') Total Revenue 3,798,334.00 .53.68% 1.38,695,25 93,111.68 05,583.57) -32-87"/0 2,099.572.50 2,039,064.03 (60,508.47) Detaili Full Year MONT11 YID EXPENSE BUDGET BUDGET ACTUAL Variance (S) Variance (°) BUDGET ACTUAL Variance (S) Variance (%) 1110 - Mayor & Cnuneil 2015 % to date Math Month Month Month YTD YTD YID YID PT Salaries 25.690.00 50,00% 01)1) 0,00 0.00 0,00% 12,845.00 12,845,00 0.00 0,009S FICA Contributions 1,593.00 49.99% 0.00 0.0(1 0,00 0.00% 796.39 796.39 0.110 0.00% Medicare Conhibutions 372,00 50.078/0 0.110 0.00 0,00 0.00% 186.27 186.27 0.00 0.00% Workers Compensation 300.011 29,66% 0,00 0,00 0,00 0.00% 300.00 88.97 211.03 70,34% Mileage 500.00 33.83% 0.00 0.00 0,00 0.00' ,, 250,00 169,16 80,84 32.34% Miscellaneous 0,1)0 1011.001/0 0.00 0.00 0,00 0,00% 0,00 211.54 (211.54) - I 00.00'.-i, Dues & Subscriptions 11,500.00 119.64%0 1,000.00 661.88 338.12 33.819' 8,0(10,00 13,758.32 15,758,32) -71.98°0 2015 share of LMC annual Prnt made in Sept 2014 plus Conferences & Training 1,000.00 100.00"/0 0.00 0,00 0,00 0.00% 500,00 1,000.00 000.00) -100.005-6 annual YSR payment Total Mayor & Council 411,955.00 70.95% 1,000.011 661.88 338.12 33.81% 22,877,66 29,1155.65 (6,177,99) -27,00% 1320 - Administration Fr Salaries 198,125.00 71.27% 15,240.38 19,248.30 (4,007.92) -26.30% 129,543,27 141,197.45 (11.654.181 -9.00% Variance is a result of PTO payouts to prior employee's PERA Contributions 14,364.00 61.69°/0 1,104.92 593.70 511.22 46.27% 9,391.85 S.861.13 530,72 5.65% 1CMA Contributions 0.00 0.00% 0.00 0,00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 12,284.00 69.36% 944.92 1,174.52 (229.60) -24.3000 8,031.85 8,519.98 (488.13) -6,08% Medicare Contributions 2,873.00 69.36% 221,1)1) 274,69 (53.69) -24,29% 1,878.50 1,992,65 (114.15) -6,08% Health/Dental Insurance 44,865.00 611,910A 3.451,15 2,532.00 919.15 26.6390 29,334.81 27,326.00 2,008.81 Unemployment Benefits 0.00 0.00"/n 0,00 0.00 0.00 0,00% 0.00 0,00 0.00 0,0090 Workers Compensation 1,000.00 106.24% 0.00 0.00 0,00 0.00% 1,000.00 1.062,37 (62,37) -6,24% Office Supplies 5,500.00 67.96% 450.00 143,93 306,07 6S.02% 3,600.00 3,737.55 (137.55) Milted Forms 0.00 100.00% 0,00 230.00 (230,00) -100.0008' 0.00 1,850,00 1(,850,00) -100.00"n Legal Services 45,000.00 144,38°/n 3.750,00 8,472,50 (4.722.50) -125.93%, 30,000.00 64,970,54 (34.970,54) - 116.57% Newsletter/Website 0,00 0.00% 0.00 (1,00 0.00 0.00% 0.00 0.00 0,00 0.0058' Assessing Services 32,000.00 81.22°/n 2,500.00 2,500,00 0,00 0.00% 20,000.00 25,990.88 (5.990,38) -29.95% May expense includes WA assessor fees budgeted later in the year Contract Services 0,00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0,00 0.00% Postage 2,000.00 129.22°A, 0,00 500.00 (500,00) -100,00% 1,000,00 2,584.36 ((,584.36) -158A4% Timing issue Mileage 500.00 14,10% 50.00 0.00 50.00 100.0098' 350.00 70,49 279.51 79.86% Legal Publishing 5,000,00 87.34% 400.00 599.71 (199.71) -49,93% 3,400,00 4,366.83 (966.83) -28.445b Insurance 35,000.00 93.10%, 1400 0.00 0.00 0.0098' 35,000.110 32,586,00 2.414.00 6.9098 Cable Operation Expense 0.00 0.00% 0,00 0.00 0.00 0.00°8' 0.00 0.00 0,00 0,00% Miscellaneous 600.00 60.01°A, 50.00 0.00 50.00 100,0098' 400.00 360.03 39,97 9.9996 Dues & Subscriptions 2,105.00 79.26% 175,00 119.50 55.50 31,719, 1.400,00 1,668.46 (268.46) -19,18% Books 0.00 100.00% 0.00 0.00 0,00 0.00% 0,00 131.89 (1)1,89) -100.00°i, Conferences & Training 6,100.00 38.70"/. 500,00 0,00 500,00 100.00% 4,000,00 2,361.00 1.639.00 40.9,S% StatT Development 0.011 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.000,, Total Administration 407,316,00 80.93% 28,837.37 36,388,85 (7,551.48) -26.19% 278,130.28 329,637.61 (51,307,33) -18.43% 1410 - Elections PT Salaries 0.00 100.00% 0.00 0.00 0.00 0.0058' 0.00 1,280.00 (1,280,00) -100.00% Office Supplies 0.00 0,00% 0.00 0.00 0.00 0.0096 0.00 0.00 0.00 0.00% Legal Publications/Notification 0.00 0.00% 0.00 0.00 0.00 0.00°,, 0.00 0.00 0.00 0.00% Equipment Repair 0.00 100.00% 0,00 0.00 0.00 0.0096 0.00 600.00 (600.00) -100.00°,6 County Election Fees 950.00 0.0096 0.00 0.00 0.00 0.005o 950.00 0.00 950.00 100.00% Printed Forms 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0,00 Miscellaneous 10)1.00 291.03% 0,00 0,00 0.00 0.0058 50.00 291,03 (241.03) -482.0696 Total Elections 1,050,00 206.76°A 0.00 0,00 0.00 0.00% 1,000.00 2,171,03 (1,171,03) -117.10% Oetail_2 Full Year I MONTH VTD 13LIDGET BUDGET ACTUAL Variance (S) Variance Clii I BUDGET ACTUAL Variance (S) Variance (%) 1450 - Communications 2015 % to date Month Month Month Month VTD YTD YTD YTD FT Salaries 35,876.00 32,72% 2,759.69 0,00 2,759.69 100.00% 23,457.38 11,739,09 11,718.29 49.96% PERA Connibutions 2,601.00 27.1156 200.08 0.00 200.08 loomo% 1,700.65 705.10 995.55 5S,54° FICA Contributions 2,224.00 32.0756 171.08 0,00 171.08 100.0056 1,454.15 713.13 741.02 50.96°0 Medicare Contributions 520.00 32.08% 40.00 0,00 40.00 100.00% 340.00 166.80 173.20 50.94% Health/Denial Insurance 9,970.00 36.83% 766.92 11,00 766.92 100,005 6,518.85 3.672.00 2.846,85 43.67% Workers Clompcnsation 0.00 100.00% 0.00 0.00 0,00 0.00% 0.00 177.91 (177.91) -100.00% Newsletter 8,000.00 66.1256 0.00 0.00 0.00 0.00% 4,000.00 5,289.83 (1,289,83) -32.25% Office Supplies 561.00 8.65% 50,0(1 0.00 50.00 100.008o 400.00 48.50 351.50 87.88% Mileage 100.0(1 0.00% 0.00 0,00 0.00 0,0056 50.00 57,27 (7.27) -14.54% Public Notices 5,040.00 31.4856 500.00 0.00 500.00 100.00% 3.350.00 1.586.54 1,763.16 52.63% Cable Operations 4,800.00 54.57% 400.00 350,00 50.00 12.50"6 3,200.00 2,619.15 580.85 18.1556 Conferences 700.00 51.43% 0.00 0.00 0.00 0,0056 350.00 360.00 (10.00) -2.86% Repair/Main) Equipment 450.00 0.00% 0.00 0.00 0.00 0.00% 450.00 0.00 450,00 100.0056 Total Cumniunicatiuns 70,842.00 38.3056 4,887.77 350.00 4,537.77 92.84% 45,271,03 27,135.62 18,135.41 40.0656 1520 - Finance FT Salaries 66,863.00 59.50% PT Salaries 3,600.0(1 0.00%, PERA Cormibulions 4,848.09 61.55% FICA Contributions 4,369.00 53.30% Medicare Contributions 1,022.00 53.28% Health/Dental insurance 14,955.00 49.47% Unemployment Benefits 3,000.00 0.00% Workers Compensation 500.00 81.52% Office Supplies 500.00 176.90% Printed Forms 500.00 0.00% Audit Services 27,1100.00 94.24% Contract Services 6,000.00 83.22% Mileage 50.00 0.00% Miscellaneous 200.00 128.28% Dues & Subscriptions 740.00 22.97% Conferences & Training 5110.110 0,00%, Total Finance 134,647.00 6328% 5,143.31 4.63132 510.99 9.94% 43,718.12 39.785.19 3,932.93 276.92 0.00 276,92 100.00% 135335 0.00 2,353.85 372.92 347,43 2.5.49 6.8456 3,169.85 2,983,92 185.93 336.08 272.09 63.99 19,0456 2,856.65 2,328.79 527.86 78.62 63.62 15.00 19.08% 668.23 544,54 123.69 1,150.38 870.40 279.98 24,3456 9,778.27 7.398,40 2,379.87 0.00 0.00 0.00 0.0056 3,000.00 0.00 3,000.00 0.00 0.00 0.00 0.00% 250.00 407,61 (157.61) 0.00 0.00 0.00 0.0056 250.00 884.52 (634,52) 0.00 0.00 0.00 0.00% 250.00 0-00 250.00 0.00 0.00 0.00 0.00% 27,000.00 25.445.00 1.555.00 500,00 792.35 (292,35) -58.47"f0 4.000.00 4,993.47 (993.47) 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 100.00 256.56 (156.56) 0,00 0.00 0.00 0.00% 240.00 170.00 7(1.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 ...._ 7,858.23 6,978.21 880.02 11.2056 97.634.97 85,198.00 12,436.97 9.00% 100.00% 5.87% 18.4S% 18.51% 24.34°,:o 100.00% -63.04% -253.S156 Annual check stock re -order 100.00% 5.76% Fieldwork cotnpleted and billed earlier than anticipated in budget -24.84% Will decrease now that audit substantially completed 0.00% -156.5656 29.17% 0.00% 12.74% Detail_3 1910 - Planning & Zoning FT So 10 ries PT Salaries ['ERA Contributions FICA Contributions Medicare Contributions Ilealth/Dental Insurance Workers Compensation Developer escrow offset cost recovery Office Supplies Printed Forms Engineering Services Contract. Services Postage Mileage Miscellaneous Dues & Subscriptions Books Conferences & Training Total Planning & Zoning 1930 - Engineering Services Engineering Services Total Engineering, Services 1940 - City Hall ('leaning Supplies Building Repair Supplies Utilities Refuse Repairs/tvlaint Contractual Bldg Repairs/Maint Contractual Equip Facility Lease Miscellaneous Total City Hall Total General Government Full Year BUDGE1 2013 152,354.00 3,600.00 9,849.00 8,646.101 2,022,00 32,047.00 800.00 (16,500.1)11) 1,800.00 750.00 20,000.00 5,000.00 200.00 250.00 5011.00 600.00 300.00 2,000.00 224,218.00 % to date 72.28 % 0,00% 75.35°4 65.62% 64.63% 68.33% 100.76% 76.41"/0 37.00% 124.78% 69.90% 280.80% 3.35% 21.62% 5.00% 0.00"/. 11.00% 11.25% 73-39% 54,800.00 52.85%. 54,800.011 52.85% 50.00 0.00% 300.00 126.02% 6,000.011 92,51% 353.00 262.I4% 6,000.00 129.54% 7,700.00 99.79% 29,532.00 66.67°A, 300.00 548.78% 50,235.00 86.88% MONTH BUDGET ACTUAL Variance (S) Variance(%) BUDGET Month Month Month Month YTD 11,825.31 9,865.64 1,959.67 16.57% 99,827.62 276.92 0.00 276.92 100.00% 2.353.85 757.63 688.)9 69,44 9.179 6.439.73 665.08 570.62 94.46 14.200/ 5,653.15 155,54 133.46 22,08 14.20% 1,322,08 2,465.15 1.812.00 653,15 26,500/ 20,953.81 0.00 0.00 0.00 0.00% 800.00 1(.375.00) 0.00 ((,375.00) -100.00% (11,)00.00) 150,00 0.00 150.00 100.00% 1,200.00 0.00 15.87 (15,87) -100,00% 500,00 1,500.00 1,148.00 352.00 23.478o 14,000,00 0,00 14,040.00 (14.040,00) -100.0006 2,500.00 0.00 0.00 0.00 0.00% 100,00 20,00 0.00 20.00 100.00% 160.00 40,00 25.00 15.00 37.505o 320.00 511,00 0.00 50.00 I 00.00°. 400.01) 25.00 0.00 25.00 100,0054 200.00 0,00 0.00 0,00 0.00% 1,000.00 16,555.63 28,298,78 (11,743.15) -70.930/ 146,730.24 4.600 00 1,75S 00 2,842 00 61,78% 36,400 00 4,600.0)1 1,758.00 2,842.00 61.78% 36,400.00 0.00 0.00 0.00 0.00% 25.00 25.00 0.00 25.00 100.00% 200,00 500.00 358.90 141.10 28.22% 4.000.00 0.00 112.94 (112.94) -100.00% 353.00 500.00 1,907.45 (1,107.45) -281.49% 4,00)1.00 650.00 752.13 0(12.13) -15.7156 5,150,00 2,461.00 2.461,00 0,110 0.00% 19,688,00 25.00 5.99 19.01 76,040/ 200.00 4,161.01) 5,598,41 (1,437,41) -34.54% 33,616.00 984,063.00 72.119% 67,900.00 80,034.13 (12,134.13) -17.87% `CID ACTUAL Variance (S) Variance C.) YTD YID YID YTD variance notes 110,115,03 (10,287.41) -10.31% 0.00 2,353,85 100.000/ 7,421.53 (981.80) -15.25% 5,673.39 (2(1,24 ) -0.36% 1,306.81 15.27 1.150/ 21.897.00 (943.(9) -4.505 S06.07 (6.07) -0.76% (12.608.38) 1,608,38 -14.62% 666.05 533.95 44.5011.0 935.87 (435.87) 13,979,25 20.75 0.15% 14,040.00 (11.540.00) -461,6006 Aug = landscape Architect Svcs: 5th Street 6,7(1 93.30 93,30% 54.05 105.95. 66.22% 25,00 295.00 92.19% 0.00 400,00 100.009' 0.00 200.00 100.0054 225.00 77.5,00 77.50% 164,543.37 (17,813.13) -12,14% 28,962.90 7.437.10 28,962.90 7,437.10 0.00 25,00 378.06 (178.06) 5,550.54 11,550.541 925.36 (57136) 7,772.58 (3,772.58) 7,683.79 (2.533.79) 19,688.00 0.00 1,646,33 (1,446.33) 43,644.66 (10,028.66) 661,860.18 710,348.84 (48,488.66) 20.43°.°0 20.43% 100.00% -89.03% -38.76% Budget assumed annex sale in 2014 -162.14% -94.31% YTD: Electrical wiring needed in new rental office space (S2.7k) -49.20% New copier lease and usage overage tees 0.00% -723.17°. -29.83% -7,33% Detail_4 DEPT 420 - PUBLIC SAFETY 2100 - Police Law Enforcement Contract' Total Police 2150 - Prosecution Attorney Criminal Total Prosecution Full Year I NIONTI 1 YTD BUDGET BUDCIET ACTUAL Variance (S) Valiance (°) BUDGET ACTUAL Variance ($) Variance (%) 2015 °., to date Month Month Month Month YID YTD YTD YTD 517,799.110 50.92% 0.00 0.00 0,00 0.005,, 258.899.50 263,645.09 (4,74.5.59) -1.839. 517,799.00 50.92.4 0.00 0.00 0.00 0.00% 258,899.50 263,645.09 (4,745,59) 50,000.00 73.25% 4.200 00 4.512,50 (312 50) -7 44°,, 33.500 00 36.625.00 (3.125 0(1) -9 33°0 50,000.00 73,25% 4,200.0)) 4,512.50 (312.50) -7.44% 33,500.011 36,625.00 (3,125.00) -9.33% 2220 - Fire FT Salaries 68,614.00 66.94% 5.273.00 5,409.78 (131.78) -2,50% 44,863.00 45.930.04 (1,067.04) -2.38% PT Salaries 123,121.00 .50.61% 9,470.35 7.630.41 1.790.44 13.90% 80,502.19 62,307.07 13.195,12 22.603s YTD correction tbr accrual back to 2014 for POC FF PERA Contributions 12,116.00 75.97% 932.00 1,03.92 ((56.02) -16,84% 7,922.00 9,204.30 (1,282.3(1) -16,1936 10CA Contributions 7.633.00 49,560/u 587.15 394,83 192.32 32.753's 4.990,81 3,732.76 1.203.05 24,21% Medicare Contributions 2,780.00 59.59% 213,85 183,19 30.66 14.3434 1,817.69 1,656.65 161.04 8,86°.0 Health/Donal Insurance 14,243.0(1 68.15% 1,095.62 1,142,0(1 (46,38) -4.239 9,312.73 9.707,00 (394.27) -1.23% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0,00% 0.(10 0.00 0.0(1 Workers Compensation 9,000.01) 195.48% 0.00 0.00 0.00 0.00% 9.000.00 17,592.88 (8,592.88) -95,48°-.0 Due to I 8,h, fate increase Office Supplies 850.00 34.73% 70.00 0.00 70.00 100.00% 560.00 295.19 264.81 47.29% EMS Supplies 3,400.00 13,33% 280.00 0.00 280.00 100.00% 2.240„00 453.18 1,786.82 79.77° Fire Prevention 3,000.00 0.00% 250.00 0.00 250.00 100.003,0 2,000.00 0.00 2,000.00 100.00% Fuel. Oil & Fluids 13,00)1.00 46.64% 1,075.00 319.85 255.15 23.73°,0 8.600,00 6,063.05 2,536.95 29.50% Small 'Tools 8... Equip 20,892.00 32.83% 1,750.00 94,00 1,656,00 94.63% 14.000.00 6,858.26 7.141.74 51.01% Physicals 3,181.00 158.11°4 265.00 3,519.47 (3.254.47) -1223.10% 2.120.00 5,029,47 (2,909,47) -137.240S Radio 21,562.00 57.56% 0.00 318.50 (3)8.50) -1.00.(103.6 10,781,00 12,411.54 (1,630.54) -15.1236 Mileage 250.00 161,92% 20.00 0.00 20.00 100.00% 170,00 404.80 (234.80) -133.12% Insurance 8,307,00 87.023.4 0.00 0.00 0.00 0.0054 8,307,00 7,229.00 1,078.00 12.98% Annual pun RIMS billed April Electric Utility 17,000.00 59.72% 1.300.00 866.04 433.96 33,3854 11,200.0(1 10,151.84 1,048.16 9.3654 Refuse 1,000.1)0 185,72% 35.00 0.00 85.00 100.0096 680,00 1,857.21 (1,177.21) -173.12% Repair/Maint Bldg 2,000.00 274.25% 165.00 346,55 (681.55) -413.06% 1,320,00 5,484.91 (4,164.91) -315.52% R.cpair/Mainr Equip 33,260.00 50.24°A 2.770.00 8.288,06 (5.5)8.06) -199.21% 22,160.00 16,710.17 5,449,83 74.59% Aug is Annual svcg of all lire vehicles Uniforms 2,50(1.00 39.46% 208.00 373.90 (165.90) -79.76% 1,664.00 986.60 677.40 40.71% Miscellaneous 1,500.00 152.58% 125.00 171.34 (46.34) -37.0730 1,000.00 2,288,69 (1,238.69) -128.37% Dues & Subscriptions 3,508.00 74.72% 290.00 301.00 (11.00) -3.79°,0 2.320,00 2,621.04 (301.1)4) -12.98% Books 220.00 9.09% 20,00 0,00 20.00 100.00% 150.00 20.00 130.00 86.67% Conferences & Training 12,375.00 56.09% 1,000.00 825.00 175.00 17.50% 8,250.00 6,941.65 1,303.35 15.86% Conferences & Training (Reinth) 0.00 0.00% 0.00 0.00 0.00 0.0036 0.00 (2,23),001 2,231.00 100.00% Total Fire 385,312.00 60.67% 27,250.47 32,322.84 (5,(72.37) -18.61% 255,930.42 233,756.30 22,174.12 8.66% 2250 - Fire Relief Fire State Aid Total Fire Relief 37,323.00 0.00% 0,00 0.00 0.00 0.0054 0.00 0,00 0.00 0,005 37,323.00 11.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Detail_5 2400 - Building Inspection FT Salaries PERA Contributions FICA Contributions Medicare Contributions Health/Dental Insurance Unemployment Bene tits Workers Compensation 0 Rice Supplies Printed Forms Fuel, Oil & Fluids Engineering Inspector Contract Services Mileage Insurance Repairs/Maint Equip Uni Forms Miscellaneous Dues & Subscription; Books Nov Truck Conferences & Training Total Building Inspections 2500 - Emergency Communications Contract Services Total Emergency Communications 2700 - Animal Control Printed Forms Contract Services Miscellaneous (Impounding) Total Animal Control Total Public Safety Full Year BUDGET 20 15 149,606,00 10,846.00 9,276.00 2,169.00 28,486.00 0.00 1,000.00 2,100.00 700.00 5,500.01) 9,0(81.00 67,200.00 3,500.00 900.00 2,3011,00 850,00 650,00 700.00 3,000,00 23,000.110 2,775.00 323,558.00 0 lo date 38.08% 39.28% 35.84% 35.84% 42.19% 0.00% 232.40% 7.46% 16.58% 9.83% 53.22% 30.99% 68.25% 20.00% 11.11% 10.59% 136.27% 55.00% 56.41% 0.00% 16.58% 34.9.5% BUDGET Month 11,508.15 834.31 713,54 166.85 2,191.23 0,00 0.00 175.00 0,00 450.00 7511.00 7,000.00 401) :10 75.00 200.00 70,00 55.00 60,00 0.00 0.00 0.00 24,649.08 MONTI-I Month 6,358.38 463,94 371,07 86,79 4414.00 0.00 0.00 0.00 0.00 88.36 496.25 2,770.00 277,25 0,00 0.00 0.00 1,414.00 0.00 0.00 0.00 0.00 13,740.04 7,000.00 53.50% 0.00 0,00 7,000.00 53.50% 0.00 0.00 0.00 0.00% 0.00 0.00 6,01)0.00 70.58% 500.00 510,00 800.00 83.13% 65.00 0.00 6,800.00 72.06°A 565.00 510,00 1,327,792.00 49.39%1 56,664.55 51,085,38 Variance (5) Month 5.149.77 370.37 342.47 80.06 777.23 0.00 0,00 175,00 0,00 361.64 253.75 4,230.00 122,75 75.00 200.00 70.00 1.1 ,3594/01 60.00 0.00 0,00 0.00 10,909.04 Variance (%) Month 44.75% 44.39°,4 48,00% 47.98% 35.47% 0,00% 0.00% 100.00% 0,00°0 80.36% 33.83% 60.43% 30.69% 100.00% 100,00°,-0 100,1)00/0 -2470,919/0 100,00% 0,00% 0,00$), 0,00% 44.26% 0,00 0.00% 0.00 0,00 0.00% (10.00) -2,0094 65.00 100.00% 55.00 9.73% 5,579.17 9.85% BUDGET YTD 97,819.31 7,091.62 6,065.08 1,418.19 18,625.46 0.00 1,000.00 1,400,00 350.00 3,700.00 6.000.00 4 1.000,00 2,200.00 600,00 1,525.00 560.00 440.00 480.00 2,500.00 23,000,00 1.400.00 217,174,66 YTD ACTUAL Variance (5) YTD 56,975.93 4,760.23 3,324,85 777.27 12,019.00 0,00 2,323.96 156.65 116.09 540.39 4,790,20 20,827.49 2.388.87 180,00 255.43 89.98 I,535.76 385.00 1.692.39 0.00 460.00 113,099.49 40,843.38 2,831.39 2,740.73 640,92 6.606.46 0.00 ((.323.96) 1.243,35 233.91 3,159,61 1.209.80 20,172,51 (188.87) 420.00 1,269,57 470.02 (1,095,76) 95.00 81)7.61 23,000.00 940.00 104,075.17 Variance (°-o) Y ID 41.75% 39.9.3% 45.18% 45.19% 35,-17% 0.00% -13/.40% 88.8 P!O 66.83% 85.39% 20,16% 49,20% 70.00% Annual premiums billed April 83.25°,6 83.93'?-6 -249.04% Aug is bki Rud Svcs Tor lot line adj: budget exception approved by CC' 19,79% 32.30% 100.00% 67.14% 47,92% 3.500,00 3.745,00 (245.00) -7.0094 3,500.00 3,745.00 (245.00) -7.00% 0,00 0.00 0.00 040004, 4,000.00 4.235.00 (235,00) -5.88% 520.00 665.00 (145,00) -27.880'o 4,520.00 4,900.00 (380.00) -8.410/o 773,524.58 655,770.88 117,753.70 15.22% Detaii_6 DEFT 430 - PUBLIC WORKS Full Year I MONTH YID BUDGET BUDGET ACTUAL Valiance (S) Variance (%) BUDGET ACruAL Variance (S) Vattince (%) 3100 - Public Works 20)5 % to date Month Month Month Month V ID VT D VT D YTD IT Salaries 153,314.00 55.97°A 11,793.38 9,18(131 2,613.07 22,16`00 100,243.77 85.811.14 14,432.63 14.40% Use of more FT vs PT: overall cost very close to budget PT Salaries 23,460.011 7.18% 1,804.62 299,00 1,5115.62 83.439's 15,339.23 1,684.00 13,655.23 89.02% PERA Contributions 11,115.00 60.02% 855.00 688.54 166.46 19,470o 7,267,50 6.670.71 596.79 8.214-0 FICA Contributions 10,960.00 46.85% 843,08 555.43 287,65 34.12% 7.166.15 5,135.03 2,031.12 28.34% !Medicare Contributions 2,563.00 46.86% 197.15 129.88 67.27 34.12% 1.675.81 1,200,92 474,89 28.34% Health/Dental Insurance 34,183.00 72.09% 2,629.46 2,899,00 (269.54) -10.25% 22,350.42 24,641.51) (2,291.08) ..1 0.25% Unemployment Fienetits 0.00 0.00% 0,00 0.00 0.00 0.00°(, 0,00 0.00 0.00 0.009'. Workers Compensation 6,000.00 264.59"/. 500.00 0.00 500.00 100.009,, 4,000,00 15,875.53 (11.875.53) -296,89'1,0 Expense spread out in the budeet: 1 8% rate increase in 2015 Office Supplies 2,000.00 5.299/,, 165,00 64.29 100.71 61,04% 1,320,00 105.76 1,214.24 91.99% Shop Materials 1,500,00 73.030/ 125.00 (79,88 t 54,88) -43.904E 1,000.00 1.095,49 (95.40) -9.5591-, Building Repair Supplies 500.00 17.35% 40.00 0.00 40.00 100.00% 320.00 86,75 233,25 72.89% Small Took and fvfinor Equip 1,200.00 142.54"/,, 100.00 331.43 (231.43) -231.43% 800.00 1,710.48 (910,48) -113.81% Engineering Services 9,000.00 90.279/0 750.00 325.50 424.50 56.60% 6,000.00 8,124.50 (2,124.50) -35.41% Contract Services 4,01)0.00 46.29% 0.00 396.05 (396.05) -100,000o 2.0110.00 1,851,43 148.57 7.430 Radio 1,300.00 47.55% 0.00 0,00 0.00 0.00% 650.00 618.12 31.88 4.90% Mileaee 0.00 0.00% 1),(1(1 0.00 0,00 0.00% 0.00 0,00 0.00 0,00% Insurance 20,000.00 78,74% 0.00 11.00 0.00 0,000o 20.000.00 15,748.00 4,257.00 21,26% Electric Utility 28,000.011 57,61% 1,500.00 602,43 897,57 59,84% 17.500.00 16,131,23 1.368.77 7.8200 Refuse 2,4(10,00 71,97% 200.00 216.67 (16.67) -8.33% 1,600.00 1,727,20 (127.20) -7.95% Fuel, Oil, fluids (ALL dews) 42,000,00 45.10% 2.500.00 3,530,48 (1.030.481 -41.229(, 27,5110.00 18,940.83 8.559.17 31.12"-0 Repair/MainBldg 3,500.00 92.20% 300.00 495.75 (195.75) -65.250o 2,300.00 3,226.97 (926.97) -40.300o Repairtklaint NOT Bldg 500,00 117.93% 40.00 589.64 (549.64) -1374.10% 320.00 589,64 (269.64) -84,26% Repair/Maint Equip (ou)) 5,000.00 77.29"/, 400.00 3,394.52 (2,994,52) -748.6300 3,400.00 3,864,56 (464.56) -13,660n Tire replacements needed tbr tvinter season Equipment Parts 7,50(1.1)0 34.710/o 625,00 347.83 277.17 44.35% 5,000.00 2.60192 2397,08 47.940 (Millions 2,000.00 80.49°/ 165.00 189,67 (24.67) -14.959,0 1,320,00 1,609.86 (289.86) -21.969.i, Miscellaneous 1,000.00 71.04% 150.00 0.00 150.00 100.00% 750.00 710.43 39.57 5.281, Landscaping Material 500.00 0.00% 125.00 0.00 125.00 100.00% 500,00 0,00 500.00 100.00%, Dues & Subscriptions 200.00 0.00% 0.00 0.00 0.00 0.009`e 100.00 0.00 100.00 100,00% Conlercriccs & Training 1,500.00 0.00% 0.00 0,00 0.00 0.00% 750.00 0,00 750,00 100.00% Clean up Days 5,000.00 111.28°/. 0.00 0.00 0.00 0.00°,-O 5,000.00 5,563.82 (563,82) -11.2890 Total Public Works 380.195.00 59.27% 25,807.69 24,416.30 1,391.39 5.39% 256,172.88 225,326.82 30,846.06 12.04% 3120 - Streets Equipment Parts 3,000.00 47.07% 250.00 0.00 250,00 100.000o 2,000,00 1,412.18 537.82 29.390o Street Maintenance Materials 20,000.00 59.54% 2,000.01 2.678.68 (678,68) -33.93% 15,01)0.00 11,908.94 3.091.06 20,61% Seal Coating/Crack Filling 186.578.00 90.66% 0.00 0.00 0.00 0,00% 186,578.00 169,150.44 17,427.56 9,34% Sign Repair Materials 2,5011.00 15,12°A 300.00 0.00 300.00 100.00% 1,91)0.00 378.09 1.521.91 80, 1094, Contract Services 8,1)00.00 46.64% 2,1100.00 935.00 1,065.01.1 53.750o 8,000.00 3,731.04 4,268.96 53,36% Repairs/Maint Equipment 2,500.00 411.29% 210.00 797.20 (587.20) -279.62% 1,680.00 1.007.30 677.70 40,040o Total Streets 222,578.00 84.28% 4,760.1111 4,410,88 349,12 7,33% 215,158.00 187,587.99 27,570.01 12,81% Entire project budgeted in June 0etail_7 3125 - Ice & Snow Removal Landscaping Material Sand/Salt Contract Services Repairs/Nlaint Equipment Total Ice & Snow Removal 3160 - Street Lighting, Street Lighting Total Street Lighting 3200 - Recycling. Recycling Supplies Miscellaneous Total Recycling 3250 - Tree Program Contract Services Total Tree Program Total Public Works Full Year BUDGET BUDGET 2015 % to dale Month 0.00 100.00% 0.00 80,000.00 57.05% 0.00 6,000.00 0.00% 500.00 9.500.110 95.22% 850.00 95,500.00 58.09"/o 1,350.00 28,000.00 54.65% 2.350.00 28,000.00 54.65% 2,350.011 3,500.00 0.011% 0.00 6.000.00 9.47°/0 500.00 9,500.00 5,98% 500.00 6,000.00 0.00% 500 00 6,000.00 0.410% 500.00 741,77390 65.2% 35,267.69 MONT11 ACTUAL Variance (5) Month Month 0.00 0,00 21.915.11 (21,915.11) 0.00 500.00 0.00 350,00 21,915.11 (20,565.11) 2,043,31 2,043.81 Variance (9°) BUDGET Month YTD 0.00°Li 0.00 -100,00% 45,1)01),(1(1 100,00% 4.000,00 100,00% 6,300.00 -1523.34% 55,300.00 306.19 13.03% 306.19 13.03% 18,800,00 18,800.00 0.00 0.00 0.00% 1,750 00 0.00 500.00 I 00.000 4,000.00 0.00 500.00 100.00% 5,750.00 0,00 500.00 100.00% 4,000.00 0.00 500.00 100.00% 4,000.00 52,786.10 (17,518.41) -49.67% 555,180.88 YTD ACTUAL Variance (5) YTD YID 794.14 (794.14) 45,639.52 (639.52) 0.00 4,0181.00 9.045.92 (2,745.92) 55,479.58 (179.58) 15,301.36 15,301.36 0,00 568.03 368,03 Variance (%) YTD -100.00% -1.47% 100,00% -43.59% Includes 87,200 for smwt plow blades 41.32% 3,498,64 18.61% 3,498.64 18.61 1,750.00 100 00% 3,431.97 85.80% 5,181.97 90.12% 0.00 4,000.00 100.00% 0.00 4,000.00 100.00% 484,263.78 70,917.10- 12.77/0 Detail_8 DEPT 450 - CULTURE, RECRE.ATIO Full Year BUDGET BUDGET 5200 - Parks & Recreation 2015 °O m dale Month FT Salaries 77,847.00 114,11% 5.988.23 PT Salaries 6,820.00 210.56% 524,62 l'ERA Contributions 5,644.00 114.92"/o 434.15 FICA Contributions 5,249.00 117.03% 403,77 Medicare Contributions 1,228.00 116.99% 94.46 Health/Dental Insurance 19,940.00 61.84% 1,533.85 Unempluyment Benefits 0.00 0.00°/,, 0.00 Workers Compensation 4,000.011 114,27% 0,00 Shop Materials 500.00 145,93% 40.00 Chemicals 75(1.00 104.99% 62,50 Equipment Parts 2,000,00 71.36% 165,00 Building Repair Supplies 500.00 15,26% 40.00 I A odscaping Materials 3,000.00 54.70% 750.00 Small 1 ools and Minor Equip 1,000.00 I56.46% 85.00 Mileage 0.00 0,00% 0.00 Insurance 3,200,00 95.03% 0,01) Elecnic Utility 8,500.110 77.10% 600.00 Refuse 2,500.00 0.00% 208.33 Repair/Maint Bldg 1,000.00 129.41"4 85,00 Repair/N1aint NOT Bide 2,500.00 1I6.97% 225.00 Repair/Maint Equip 1,500.00 0.00% 125,00 Rctual Buildings 4,600.00 103.34% 383,33 Miscellaneous 750.00 114.95% 62.50 Total Parks & Recreation 153,028.00 104.67% 11,310.74 IT & Telephone IT -Hardware IT -Software 1T-Support Services IT -Networking FNET Contingency Telephone Total IT & Telephone Grand Total all Expenses Subtotal Net Income over Expenses DEPT 460 - COMP ADJ Debt Service increase Transfer to City Projects (Streets) DEPT 493 - OTI1 FINANCING GRAND TOTAL EXP ALL DEPTS Net Income over Expenses 9,100.00 16,000.00 36,000.00 7,800.00 16,000.00 24,660.00 109,560.00 3,316,216.00 482,118.00 35,000.00 247,118.00 0.00 200,000.00 3,798,334.00 0.00 55.53% 46.93% 65,59% 0.00% 0.00% 48.91% 44.03% 62.08% 0.00% 0.00% 0.00% 0.00% 54,20% 0.00% 0.00 1,333.00 3.000.00 0.00 0.00 2,055.00 6,388.00 177,530.98 (38,835.73) 0.00 0.00 0 00 0 00 177,530.98 (38,835,73) MONTH ACTUAL Variance ($) hlonth Month 9,845.81 3,640.50 738.43 804.43 188.16 1,450.80 0.00 0.00 17.05 300.21 23,75 0.00 0.00 0,00 0.00 0.00 630,86 0.00 10.00 I ,769.02 235.71 8-16.00 0.00 20,500.73 (3,857.58) (3,115.88) (304.28) (400.66) (93.70) 83.05 0,00 0.00 22.95 (237.71) 141.75 40,00 250,00 85.00 0.00 0.00 (30.86) 208.33 75,00 (1,544.021 (110.71) (462.67) 62.50 (9,189,99) 0.00 0.00 0,1)0 1,333,00 0,00 3.000.00 0.00 0.00 0.00 0.00 1,036.52 _ 1,018.48 1,036.52 5,351.48 205,442.86 (27,911.88) (112,331.18) (73,495.45) 0.00 0.00 0.00 0 (10 0,00 0.00 0.00 0 00 205,442.86 (27,911.88) (112,331.18) (73,495.45) Variance (%) BUDGET Month YID -64.429) 50,399.96 -593.93") 4,459.23 .70.09% 3.690.31 -99.23% 3,432.04 .99.20% 802.92 5,41% 13,037.69 0,00"0 0.00 0.003; 4,000.00 57.38% 320.00 -380.34% 500,00 85.6100 1.320.00 100,00°.`o 320.00 100.00% 2.000,00 100.0090o 675.00 0.00°0 0.00 0.0096 3,200.00 -5,14% 5,350.00 100.00% 1,666.64 88.24% 675.00 -686,23% 1,700.00 -88.57% 1.000.00 .120.70% 3,066„64 100,00% 500.00 -81.25% 1112,615.43 0.00% 4,550.00 100.00"00 10,664.00 100.00% 24,000.00 0.00% 3,900.00 0.005) 16,000.00 49.569) 16,440.00 83,77% 75,554.00 -15.72% 2,168,735.07 -189.25% (69,16257) 0.0050 0,00 0,00% 0.00 0.000b 0.00 0.009" 0.00 -15.72% -189.25% '0 I'D AC111AL 'Variance (5) YTD 88.833.16 14,360.13 6.485.86 6,143,09 1,436.67 12,331.00 0.00 4,570.91 729.66 787.39 1,427.18 76.32 1,641.02 1,564.60 0,00 3,041.00 6.553.35 0.00 1,294.07 2.924,25 353,46 4,753.78 862.10 160,169.011 5,052.98 7,508.00 23.611,36 0.00 0.00 12,062.42 48,234,76 2,058,787.26 (19,723.23) 0.00 0.00 0.00 0.00 2,168,735.07 2,058,787,26 (69.162.57) (19,723.23) - YID (37.933.20) (9,900.90) (2,79.5.55) (2,711.05) (633.75) 706.69 0.00 (570.91) (409.66) (287.39) (107.1S) 243.68 358.98 (889.60) 0.00 159.00 (1,203.35) 1,666.64 (619.07) (1,224.25) 646.54 (1,687.14) (362,(0) (57,553.57) (502,98) 3,156.00 388.64 3,900.00 16,000.00 4,377.58 27,319.24 109,947.81 49,439.34 0.00 0.00 0.00 0.00 109,947.81_ 49,439.34 Valiance (°')) YTD -74,53'% Position switch from new employee at lower rate to long term ec -222.03"o -75.75% -78.99°'0 -78.93% 5.42% 0.00% -14.27% -128.02% -57.48% 76.15°.-o 17.95% -131,79% 0,00%, 4.97:0 -22A9% 00.009) -91.71% -72,01% 64.65% -55.02% -72.42° o -56.09% -11 05% 29 59% 1 62°Q 100 00% 100 00% 26 63'; 36.16% 5.07% 71A8% 0.00N 0,00% 0.00% 5.07% 71.48%_ Detail_9 Citv of I Ake Elmo Budget to Actual 2015 BY Month As of August 31. 2015 206-library Fund l3v DeLlartMelli Full Year Month YTD BUDGET 2015 2015 Over/ 2015 2015 Over 2015 % to date BUDGET ACTL'ALS (under) BUDGET ACTUALS (under) REVENUE Curren( Ad Valorem Taxes 231.261.00 5000% 0,00 0.00 0.00 115.630,50 115.630.50 0.00 Rental Income 11.400.00 229.95% 950.00 5,664.00 4,714.00 7,600.00 26.214.00 18,614.00 Interest Eantings 0.00 0.001Ya 0.00 0.00 0.00 0.00 0,00 0.00 Al iscellaneons Revenue 0.00 0.00% 0.00 0.00 0.00 0.00 200.55 200.55 Revenue from use occupier Donations 0.00 100.0011'. 0.00 0.00 0.00 0.00 1,235,00 1,235.00 Total Revenue 242.661.00 59.05% 950.00 5,664,00 4,714.00 123,230.50 143,280.05 10.049.55 EXPENSE (Over)/ (Over)! under tinder Notes Funds received from WA Cty July and December Includes $20.6k delinquent rent from prior telmant FT Salaries 45,000,00 65.86% 3,750,00 3,460,80 289.20 30.000,00 29,637,12 362.88 PT Salaries 16,000.00 26,62% 1,333.33 1,004,50 328.83 10,666.67 4.259.50 6,407.17 PERA Comributions 4,422,50 57.11% 368.54 334.90 33.64 2,948.33 2,525.74 422,59 FICA Contributions 3,782.00 51.78% 315.17 261.26 53,91 2.511.33 1.958.19 563.14 Medicare Contributions 884.50 51.78% 73,71 61,11 12,60 589,67 458.00 131.67 Health/Dental Insurance 11,987.00 77.15% 998.92 1.088.00 (89.08) 7,991.33 9,248.00 (1,256.67) Budget showed consistent monthly cost: not impact Unemployment Benefits 0,00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 of multiple pay period months Workers 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 733.35 0.00 733.35 Office Supplies 4,100,00 26.51% 341.67 968.12 (626.45) 1,733,36 1.086.79 1,646.57 Library Collection Maintenance 49,700.00 3438% 4,141.67 3.699,68 441.99 33,133.33 17,087.46 16,045.87 Legal Services 2,000,00 67.70% 0,00 93,50 (93.50) 1.000,00 1,354.00 (354.00) Cost to recover delinquent rent from prior iennant Contracl Services 3,000,00 3,45% 250.00 0.00 250.00 2,000,00 103,50 1,896.50 Snow Plowing Telephone 1,600,00 56.32% 133.33 0.00 133.33 1,066.64 901,05 165.59 Internet 1,000.00 38.63% 83.33 0.00 83,33 666,67 386.29 280.38 InConnation fechnology ( Equ)no 3.220,00 96.27% 0,00 0.00 0.00 3,220,00 3,100.00 120.00 Software 0.00 0.00% 0,00 0.00 0.00 0.00 0.00 0.00 Insurance 2,700.00 69.74% 0.00 0.00 0.00 1,350.00 1.883,(10 (533.00) Utilities 7,550.00 65.17% 616,66 677.94 (61.28) 5.033.28 4,920.63 112.65 Refuse 550.00 72.35%, 45.83 49.89 (4.06) 366.64 397.90 (31.26) Repa ir/Ma int Bldg 14,000.00 130.45% 1.166,67 315.00 851.67 9,333,33 18.262.50 (8,929.17) YTD includes Roof repairs RepairMaint NOT Bldg 0.00 0.00% 500,00 0.00 500.00 500.00 0.00 500.00 RepairiNlaint Equip lout-L11 ling 0.00 100.00'.4, 0.00 0.00 0.00 0,00 420.00 (420.001 Library, Curd Reimbursements 24,000.00 76.32% 1,700,00 2,004.00 (304,00) 19,700,00 18,316.34 1,383.66 Library card reitnb are processed by County rtT 5/11 5 Miscellaneous 2.000.00 14.68% 166.66 0.00 166,66 1,333.18 293.62 1.039.66 Building Purchase Report 0,00 0.00% 0.00 0.00 0.00 0.00 0.00 0.00 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 0.00 0.00 0.00 738.00 (738,00) Subscriptions 0.00 0,00% 0.00 100.00 (100.001 0.00 100.00 (100,00) Conferences & Training 2,500,00 0.00% 0,00 175,00 (175.00) 0.00 175,00 (175.00) Programs 7,500,00 0.00% 625.00 0,00 625,00 5,000,00 0.00 5,000.00 Internal charges 1,600.00 25.88% 130.00 8.00 122.00 1,080.00 414.00 666.00 $2 per card processing fee plus billable Ci(y resources Total Library 213,146.00 55.9214 16.832,16 14,301.70 2,530.46 144,617.21 119,193.63 25,423.58 Net Income/(Expense) 12;31114 Cash Balance Net Income/(Expense) Accrued AP CIP (sell funded) Contingencies 2014 AP twernal reversal Eliding (WI Balance 29.515.11(1 115.882,161 (8.637,70) 7,244.46 (21,386,71) 24,086,42 45,473,13 -45.61% -212.62% 172,205.10 206,407.26 29,515,00 24,086.42 (3,015.87) (70,000.00) 0.00 131.720.10 227:477.81