Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
CC 3.15.16 Financials
City of Lake Elmo 3/15/2016 2015 By Month Budget to Actual Com arative For the month ending February 29 2016 101-General Fund Detail By Department Full Year MONTH YTD DEPT 410-GEN'L GOV'T BUDGET BUDGET ACTUAL Variance(S) Variance(/) BUDGET ACTUAL Variance($) VarianceREVENUE (%} 2016 %to date Month Month Month Month YTD YTD YTD YTD YTD variance notes Current Ad Valorem Taxes 2,033,198.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Delinquent Ad Valorem Taxes 15,000.00 14.26% 0.00 2,139.46 2,139.46 100.00% 0.00 2,139.46 2,139.46 100.00% Prot from WA Cty related to a tax form parcel Mobile Home Tax 12,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Fiscal Disparities 157,508.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Penalty&Interest on Taxes 700.00 0.00% 0.00 0.00 0.00 0.00% 0,00 0.00 0.00 0.00% Liquor License 11,000.00 61.82% 0.00 0.00 0.00 0.00% 8,000.00 6,800.00 (1,200.00) -15.00% Wastehauler License 1,680.00 0.00% 0.00 0.00 0.00 0.00% 840,00 0.00 (840.00) -100.00% General Contractor License 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 100.00 100.00 100.00% Heating Contractor License 2,500.00 38.00% 200.00 300.00 100.00 50.00% 500,00 950.00 450.00 90.00% Building Permits 508,200.00 14.31% 25,000.00 38,663,15 13,663.15 54.65% 45,000.00 72,704.10 27,704.10 61.56% Includes$19.6k Commercial permit fees;33 new homes and Building Re-inspect Fees 0.00 0.00% 0.00 0.00 0.00 0.00% 0,00 0.00 0.00 0.00% 11 new commercial rec units through February Heating Permits 38,000.00 23.92% 2,000.00 6,064.00 4,064.00 203.20% 4,000.00 9,088.00 5,088.00 127.20% Plumbing Permits 46,800.00 15.90% 2,900,00 5,160.00 2,260.00 77.93% 5,300.00 7,441.00 2,141.00 40.40% Animal License 2,500.00 37.40% 600.00 340.00 (260.00) -43,33% 2,100.00 935.00 (1,165.00) -55.48% Utility Permits(ROW) 25,000.00 34.36% 0.00 8,591.00 8,591.00 0.00% 0.00 8,591.00 8,591.00 100.00% Burning Permit 2,750.00 19.82% 0.00 170.00 170.00 100.00% 500.00 545.00 45.00 9.00% Massage Therapy Licenses 150.00 0.00% 0,00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% MSA-Maintenance 101,696.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% 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 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Recycling Grant 15,500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Misc State Grant/Surcharge Rev 5,064.00 1283.30% 50,848.00 61,716.50 10,868.50 21.37% 50,848.00 64,986.50 14.138.50 27.81% Cable Franchise Revenue 45,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Zoning&Subdivision fees 27,500.00 8.36% 0.00 2,300.00 2,300.00 100,00% 0.00 2,300.00 2,300.00 100.00% Plan Check Fees 278,129.00 16.01% 18 000.00 23,537.80 5,537.80 30.77% 33,000.00 44,535.52 11,535.52 34,96% Includes S12.7k Commercial Plan review fees;33 new homes Sale of Copies,Books,Maps 175.00 27.14% 5.00 1.49 (3.51) -70.20% 10.00 47.49 37.49 374.90% and 11 new commercial rec units through February Assessment Searches 1,215.00 18.52% 15.00 45.00 30.00 200.00% 45.00 225.00 180.00 400.00% Clean Up Days 2,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Cable Operation Reimbursement 4,000.00 0.00% 0.00 0.00 0.00 0.00% 0,00 0.00 0.00 0.00% Fines 45,000.00 15.51% 3,500.00 3,477.23 (22.77) -0.65% 7,000.00 6,979.46 (20.54) -0.29% Miscellaneous Permits 0.00 0.00% 0.00 31.35 31.35 100.00% 0.00 31.35 31.35 100.00% Fire Billable Revenue 500.00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% Miscellaneous Revenue 3,500.32 0.29% 300.00 10.00 (290.00) -96.67% 600.00 10.00 (590.00) -98.33% Interest Earnings 55,000.00 0.00% 0.00 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.00% Total Revenue F 3,485,514.32 6.55% 103,368.00` 152,546.98 49,178 98 47.58% 157,743.00 228,408,88 70;665.88 44 80% Detail-I Full Year MONTH YTD EXPENSE BUDGET BUDGET ACTUAL Variance($) Variance(°/u) BUDGET ACTUAL Variance($) Variance(%) 1110-Mayor&Council 2016 %to date Month Month Month Month YTD YTD YTD YTD PT Salaries 25,690A0 OAO% 0.04 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 1,592.78 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Medicare Contributions 372.54 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 300.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Mileage 500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 5,000.00 0.00% 0.00 1,173.77 (1,173.77) -100.00% 0.00 2,111.27 (2,111.27) -100.00% Dues&Subscriptions 11,500.00 43.78% 1,000.00 682.58 317.42 31.74% 2,000.00 5.034.16 °(3,034.16) -151.71/0 2076 share of LMC annual Pint made in Sept 2015 plus Metro Conferences&Training 1.000.00 0.00% 0.00 0.00 0.00 0.00% 250.00 0.00 250.00 100.00% Cities annual membership of S3.7k Total Mayor&Council 45,955.32 .15.55% 1,000.0U 1,856.35 (856.35) 85.64% 2,250.00 7,145.43 (4,895.43) 217.57% 1320-Administration FI'Salaries 145,000.00 19.07% 11,153.85 11,216.00 (62.15) -0.56% 22,307.70 27,647.44 (5,339.74) -23.94% PE'RA Contributions 10,875.00 15.47% 836.54 841.20 (4.66) -0.56% 1,673.08 1,682.40 (9.32) -0.56% ICMA Contributions 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% FICA Contributions 8,990.00 18.23% 691.54 657.64 33.90 4.90% 1.383.08 1,638.64 (255.56) -18.48% Medicare Contributions 2,102.50 18.23% 161.73 153.80 7.93 4.90% 323.46 383.22 (59,76) -18.48% Health/Dental hrsurance 30,550.00 14.25% 2,350.00 2,176.00 174.00 7.40% 4,700.00 4,352.00 348.00 7.40% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 1,140.00 62.65% 1,000.00 714.24 285.76 0.00% 1,000.00 714.24 285.76 28.58% Office Supplies 5,800.00 15.85% 475.00 126.36 348.64 73.40% 950.00 919.15 30.85 3.25% Printed Forms 0.00 0.00% 0.00 81.32 (81.32) -100.00% 0.00 81.32 (81.32) 0.00% Legal Services 60,000.00 22.43% 5,000.00 0.00 5,000.00 100.00% 10,000.00 13,456.38 (3,456.38) -34.56% February invoice not yet received from Kennedy and Graven Newsletter/Website 8,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Assessing Services 38,000.00 13.16% 2,500.00 2,500.00 0.00 0.00% 5,000.00 5,000.00 0.00 0.00% 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 41.22% 0.00 213.79 (213.79) -100.00% 0.00 824.40 (824.40) -100.00% Mileage 550.00 0.00% 50.00 0.00 50.00 0.00% 50.00 0.00 50.00 100.00% Legal Publishing 10,040.00 16.41% 800.00 903.70 (103.70) -12.96% 1,550.00 1,647.34 (97.34) -6.28% Insurance 28,000.00 0.00% 0.00 0.00 0.00 0.00% 28,000.00 0.00 28,000,00 -100.00% Annual insurance budgeted in Jan but not billed until late Feb Cable Operation Expense 4,800.00 0.00% 400.00 295.00 105.00 26.25% 800.00 645.00 155.00 19.38% Miscellaneous 600.00 4 98% 50.00 29.87 20.13 40.26% 100.00 29.87 70.13 70.13% Dues&Subscriptions 1,200.00 64.03% 100.00 768.32 (668.32) -668.32% 200.00 768.32 (568.32) -284.16% Books 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 3,350.00 0.00% 250.00 0.00 250.00 100.00% 500.00 0.00 500.00 100.00% Staff Development 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Administration 360,997.50 1y6.56% 25,818.66 20,677.24 5,141.42 19.91% 78,537.32 59,789.72 18,747.60 23.87% Detail 2 MONTH YTD 1410-Elections BUDGET` ACTUAL Variance($) Variance(%) BUDGET' ACTUAL Variance($) Variance(%) Month Month Month Month YTD YTD YTD YTD PT Salaries 12,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Office Supplies 500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Legal Publications/Notification 500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Equipment Repair 500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% County Election Fees 950.00 0.00% 950.00 0.00 950.00 100.00% 950.00 0.00 950.00 100.00% Printed Forms 350.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 1,000.0() 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Elections 15,800.00 0.00% 950.00 0.00 950.00 100.00% 950. 00 0,00 450.00 100.00% 1520-Finance FT Salaries 60,630.46 16.84% 4,663.88 5,055.77 (391.89) -8.40% 9,327.76 10,209,97 (882.21) -9.46% PT Salaries 4,550.00 7.14% 350.00 325.00 25.00 7.14% 700.00 325.00 375.00 53.57% PERA Contributions 4,888.53 16.16% 376.04 403.56 (27.52) -7.32% 752.08 790.13 (38.05) -5.06% FICA Contributions 4,041.19 15.42% 310.86 318.51 (7.65) -2.46% 621.72 622.97 (1.25) -0.20% Medicare Contributions 945.12 15.41% 72.70 74.49 (1.79) -2.46% 145.40 145.69 (0.29) -0.20% Health/DentaIInsurance 10,880.00 16.00% 836.92 870.40 (33.48) -4.00% 1,673.85 1,740.80 (66,95) -4.00% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 550.00 37.11% 0.00 204.09 (204.09) -100.00% 0.00 204.09 (204.09) -100.00% Office Supplies 1,000.00 14.72% 0.00 29.98 (29.98) -100.00% 0.00 147.21 (147.21) -100.00% Printed Forms 500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Audit Services 28,650.00 0.00% 10,000.00 0.00 10,000.00 100.00% 10,000.00 0.00 10,000.00 100.00% Contract Services 6,700.00 0.25% 600.00 16.88 583.12 97.19% 1,200.00 16.88 1,183.12 98.59% Mileage 50.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Miscellaneous 200.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 750.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 500.00 0.O0% 0.00 0.00 0.00 0.00% 0.00 _ 0.00 0.00 0.00% Total Finance 124,835.30 11.38% 17,210.40 _ 7,248.6$ 9,911.72 57.59% 24,4211.$1 14,202.74 10,218.07 41.84% Detail 3 '.. Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance($) Variance(/) BUDGET ACTUAL. Variance($) Variance(%) 1910-Planning&Zoning 2016 %to date Month Month Month Month YTD YTD YTD YTD YTD variance notes FT Salaries 137,098.00 14.33% 10,546.00 9,047.98 1,498.02 14.20% 21,092.00 19,642.13 1,449.87 6.87% PT Salaries 4,800.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% PERA Contributions 10,282.35 12.45% 790.95 678.60 112.35 14.20% 1,581.90 1,279.93 301.97 19.09% FICA Contributions 8,500.08 11.68% 653.85 523.18 130.67 19.98% 1,307.70 992.40 315.30 24.11% Medicare Contributions 1,987.92 11.68% 152.92 122.36 30.56 19.98% 305.83 232.09 73.74 24.11% Health/DentalInsurance 34,814.00 10.63% 2,678.00 1,850.00 828.00 30.92% 5,356.00 3,700.00 1,656.00 30.92% Workers Compensation 800.00 51.84% 800.00 414.71 385.29 0.00% 800.00 414.71 385.29 0.00% Developer escrow offset cost recovery 0.00 -100.00% 0.00 (1,673.23) 1,673.23 100.00% 0.00 (2,676.44) 2,676.44 100.00% Office Supplies 1,800.00 14.22% 150.00 109.37 40.63 27.09% 300.00 255.97 44.03 14.68% Printed Forms 750.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Engineering Services 20,000.00 8.18% 1,500.00 845.00 655.00 43.67% 3,000.00 1,635.00 1.365.00 45.50% Contract Services 60,000.00 17.76% 0.00 1,030.75 (1,030.75) -100.00% 0.00 10,656.35 (10,656.35) -100,00% East Metro Strong analysis costs related to potential BRT line Postage 200.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Mileage 250.00 0.00% 20.00 0.00 20.00 100.00% 40.00 0.00 40.00 100.00% Miscellaneous 500.00 0.00% 40.00 0.00 40.00 100.00% 80.00 0.00 80.00 100.00% Dues&Subscriptions 600.00 0.00% 50.00 0.00 50.00 100.00% 100.00 0.00 100.00 100.00% Books 300.00 0.00% 25.00 0.00 25.00 100.00% 50.00 0.00 .50.00 100.00% Conferences&Training 2,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Planning&Zoning 284,682.35 12.69% 17,406.72 12,948.72 - 4,458.00 - 25 _.61% 34,013.43 36,132.14 (2,118.71} -6.23% 1930-Engineering Services Engineering Services 48,000.00 11.40% L000,00 2,894.16 L105.84 27.65% 8,000.00 5,472.91 2,527.09 31.59% Total Engineering Services 48,000.00 11.40% 4,000.00 2,894.16 1,105.84 27.65% 8,000.00 5,472.91 2,527.09 31.59% 1940-City Hall Cleaning Supplies 50.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Building Repair Supplies 300.00 0.00% 25.00 0.00 25.00 100.00% 50.00 0.00 50.00 100.00% Utilities 7,500.00 14.74% 750.00 355.24 394.76 52.63% 1,500.00 1,105.24 394.76 26.32% Refuse 600.00 18.82% 50.00 112.94 (62.94) -125.88% 100.00 112.94 (12.94) -12.94% Repairs/Maint Contractual Bldg 6,000.00 12.57% 500.00 326.65 173.35 34.67% 1,000.00 754.30 245.70 24.57% Repairs/Maint Contractual Equip 10,800.00 13.36% 900.00 802.56 97.44 10.83% 1,800.00 1,443.37 356.63 19.81% Facility Lease 29,532.00 16.67% 2,461.00 2,461.00 0.00 0.00% 4,922.00 4,922.00 0.00 0.00% Miscellaneous 300.00 0.00% 25.00 0.00 25.00 100.00% 50.00 0.00 50.00 100.00% Total City Hall 4,058.39 652.61 13.85% 9,422.00 8,337.85 - 1,084.15 11.51°/ Total General Government L93;5,352Z.47�,14.01%�71,096.'078 49,733.54 21,363.24 30.05% 157,593.56 131,080.79 26,512.77 16.82% Detail 4 DEPT 420-PUBLIC SAFETY Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance($} Variance(%) 2100-Police 2016 %to date Month Month Month Month YTD_ YTD YTD YTD Law Enforcement Contract 527,060.47 0.12% 0.00 0.00 0.00 0.00% 0,00 634.22 (634.22) 100.00% Total Police 527,060.47 0.12% 0.00 0.00 0.00 0.00% 0.00 634.22 (634.22) -100.00% 2150-Prosecution Attorney Criminal 54,700.00 18,07% 4,600.00 4,948.21 (348.21) -7.57% 9,200.00 9,884.21 (684.21) -7.44% Extra cost to to transition time to new law firms Total Prosecution 54,700.00 18.07% 4,600.00 4,948.21 (348.21) 7.57°/� 9,200.00 9,884.21 (684.21) -7,44% 2220-hire FT Salaries 70,300.00 15.39% 5,407.69 5,409.66 (1.97) -0.04% 10,815.38 10,819.35 (3.97) -0.04% PT Salaries 110,000.00 11.40% 9,166.67 5,456.12 3,710.55 40.48% 18,333.33 12,545.32 5,788.01 31.57% PERA Contributions 11,388.60 16.32% 876.05 876.36 (0.31) -0.04% 1,752.09 1.859.00 (106.91) -6.10% FICA Contributions 7,388.33 17.30% 568.33 338.28 230.05 40.48% 1,136.67 1,278.46 (141.79) -12.47% Medicare Contributions 2,747.27 16.56% 211.33 150.52 60.81 28,77% 422.66 455.02 (32.36) -7.66% Health/DentalInsurance 14,846.00 14.66% 1,142.00 1,088.00 54.00 4.73% 2,284.00 2,176.00 108.00 4.73% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 18,500.00 69.61% 18,500.00 12,87&.61 5,621.39 0.00% 18,500.00 12,878.61 5,621.39 0.00% Office Supplies 850.00 15.37% 70.00 0.00 70.00 100.00% 140.00 130.64 9.36 6.69% EMS Supplies 3,400.00 0.00% 280.00 0.00 280.00 100.001/0 560.00 0.00 560.00 100.00% Fire Prevention 3,000.00 0.00% 250.00 0.00 250.00 100.00% 500.00 0.00 500.00 100.00% Fuel,Oil&Fluids 13,000.00 4.88% 1,075.00 634.01 440.99 41.02% 2,150.00 634.01 1,515.99 70.51% Small Tools&Equip 12.000.00 3.64% 1,000.00 437.12 562.88 56.29% 2,000.00 437.12 1,562.88 78.14% Physicals 3,904.00 0.00% 350.00 0.00 350.00 100.00% 700.00 0.00 700.00 100.00% Radio 18,097.51 17.21% 0.00 3,115.00 (3,115.00) -100.00% 0.00 3,115.00 (3,115.00) -100.00% Mileage 500.00 97.52% 50.00 487.62 (437.62) -875.24% 100.00 487.62 (387.62) -387,62% Insurance 8,307.00 0.00% 8,307.00 0.00 8,307.00 100.00% 8,307.00 0.00 8,307.00 100.00% Electric Utility 15,500.00 18.47% 1,400.00 1,462.18 (62.18) -4.44% 2,800.00 2,862.18 (62.18) -2.22% Refuse 1,200.00 30.53% 100.00 266.38 (166.38) -166,38% 200.00 366.38 (166.38) -83.19% Repair/MaintBldg 15,250.00 0.74% 1,000.00 8,87 991.13 99,11% 2,000.00 112.61 1,887.39 94.37% Repair/Maint Equip 25,650.00 4.64% 2.200.00 644.53 1,555.47 70.70%, 4,400.00 1,191.00 3209.00 72.93% Uniforms 4,100.00 2.68% 300.00 109.90 190.10 63.37% 600.00 109.90 490.10 81.68% Miscellaneous 2,000.00 9.95% 150.00 191.11 (41.11) -27.41% 300.00 199.01 100.99 33.66% Dues&Subscriptions 3,863.00 22.75% 320.00 130.00 190.00 59.38% 640.00 879.00 (239.00) -37.34% Books 440.00 0.00% 40.00 0.00 40.00 100.00% 60.00 0.00 60.00 100.00% Conferences&Training 17,000.00 37.44% 0.00 5,700,46 (5,700.46) -100.00% 0.00 6,364.46 (6,364.46) -100.00% Conferences&Training(Reimb) (6,000.00) 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Tire 377,231.71 15.61% 52,764.07 39,384.73 13,379.34 25.36% 78,701.13 58,900.69 19,800.44 25.16% 2250-Fire Relief Fire State Aid 37,323.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0,00 0.00 0.00% Total Fire Relief 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 MONTH YTD 2400-Building Inspection BUDGET BUDGET ACTUAL Variance($} Variance(%} BUDGET ACTUAL Variance($) Variance(%) 2016 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 168,171.00 11.92% 12,936.23 1O7042.13 2,894.10 22.37% 25,872.46 20,039.04 5,833.42 22.55% PERA Contributions 12,612.83 11.92% 970.22 753.16 217.06 22.37% 1,940.43 1,50293 437.50 22.55% FICA Contributions 10,426.60 11.40% 80105 595.00 207.05 25.82% 1,604.09 1,188.39 415.70 25,92% Medicare Contributions 2,438.48 11.40% 187.58 139,13 48.45 25.83% 375.15 277.90 97.25 25.92% flealth/DentalInsurance 29,692.00 14.66% 2,284.00 2,176.00 108.00 4.73% 4,568.00 4,352.00 216.00 4.73% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 5,000.00 25.19% 2,500.00 1,259.69 1,240.31 0.00% 2,500.00' 1,259.69 1,240.31 0.00% Office Supplies 2,100.00 13.65% 175.00 150,00 25.00 14.29% 350.00 286,55 63.45 18.13% Printed Forms 700.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0,00% Fuel,Oil&Fluids 6,500.00 2.31% 500.00 121.63 378.37 75.67% 1,000.00 150.06 849,94 84.99% Engineering 14,000.00 6.63% 1,000.00 463.75 53625 53.63% 2,000.00 927.50 1,072.50 53.63% Inspector Contract Services 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Mileage 200.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 900.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Repairs/Maint Equip 1,800.00 0.00% 150.00 0.00 150.00 100,00% 300.00 0.00 300.00 100.00% Uniforms 850.00 0.00% 70.00 0.00 70.00 100.00% 140.00 0.00 140.00 100.00% Miscellaneous 725.00 10,48% 55.00 76.00 (21.00) -38.18% 110.00 76.00 34.00 30.91% Dues&Subscriptions 700.00 0.00% 60.00 252.18 (192.18) -320.30% 120.00 252.18 (132.18) -110.15% Books 725.00 0.00% 0.00 0.00 0.00 0.00% 725.00 0.00 725.00 100.00% New Truck 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Conferences&Training 3,225.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 11.62% 21,690.08 16,028.67 5,661.41 26.10% - 41,605.13 30,312.24 11,292.89 27.14% 2500-Emergency Communications Contract Services 7,400.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Emergency Communications 7,400.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00°/u 2700-Animal Control Printed Forms 0.00 0.00% 0,00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Contract Services 7,550.00 15.56% 600.00 575,00 25.00 4.17% 1,200.00 1,175.00 25.00 2.08% Miscellaneous(Impounding) 0.00 0.00% 0.00 0.00 0.00 0,00% 0.00 0.00 0.00 0.00% --- 'I'otal Animal Control 7,550.(10 15.56°La 600.(10 575.00 25.00 417% 1,200.00 1,175.0t} 25.00 2.08% Total Public Safety L122,031.09 7.93% 79,654.15 60,936.62 18,717.54 23.50% 130,706.26 10t},40f.36 29,799,90 22.80°/, Detail 6 '.. DEPT 430-PUBLIC WORKS Full Year MONTH YTD _ BUDGET BUDGET ACTUAL Variance N Variance(%) BUDGET ACTUAL Variance($) Variance(%) 3100-Public Works 2016 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 169,779.00 2131% 13,059.92 17,737.78 {4,677.86) -35.82% 26,119.85 36,183.70 (10,063.85) -38,53% PT Salaries 7,000.00 0.00% 0.00 0.00 0,00 0.00% 0.00 0.00 0.00 0.00% PERA Contributions 12,733.43 21.31% 979.49 1,330.35 (350.86) -35.82% 1,95899 2,713.81 (754.82) -38.53% FICA Contributions 10,526.30 20.61% 809.72 1,062.23 (252,51) -31.18% 1,619.43 2,169.81 (550.38) -33.99% Medicare Contributions 2,461.80 8.43% 189.37 248.46 (59.09) -31.20% 378.74 207.46 171.28 45.22% Health/Dental Insurance 44,759.00 12.95% 3,443.00 2,899.00 544.00 15.80% 6,886.00 5,798.00 1,088.00 15.80% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 18,000.00 66.82% 0,00 12,028.46 (12,028.46) -100.00% 0.00 12,028A6 (12,028.46) -100.00% Office Supplies 2,000.00 0.00% 165.00 0.00 165.00 100.00% 330.00 0.00 330.00 100.00% Shop Materials 2,000.00 23.02% 165.00 361.51 (196.51) -119.10% 330.00 460.32 (130.32) -39.49% Building Repair Supplies 500.00 92.00% 40.00 293.53 (253.53) -633.83% 80.00 459.99 (379.99) -47499% Small Tools and Minor Equip 1,200.00 99.33% 100.00 906.43 (806A3) -806.43% 200.00 1,191.92 (991.92) -495.96% Engineering Services 12,000.00 4.86% 1,000.00 445.00 555.00 55.50% 2,000.00 583.75 1,416.25 70.81% Contract Services 1,000.00 24.36% 250.00 143.55 106.45 42.58% 500.00 243.55 256.45 51.29% Radio 1,300.00 0.00% 0.00 0,00 0.00 0,00% 0,00 0.00 0.00 0.00% Mileage 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 16,000.00 0.00% 16,000,00 0.00 16,000.00 100.00% 16,000.00 0.00 16,000.00 100.00% Electric Utility 28,000.00 20.04% 3,500.00 2,411.27 1,088.73 31.11% 7,000.00 5,611,27 1,388,73 19.84% Refuse 2,500.00 16.67% 200.00 216,67 (16.67) -8.33% 400.00 416.67 (16.67) -4.17% Fuel,Oil,Fluids(ALL depts) 42,000.00 5.87% 6,000.00 1,445.13 4,554.87 75.91% 12,000.00 2,464.53 9,535.47 79.46% Repair/MaintBldg 4,000.00 36.82% 330.00 245.00 85.00 25.76% 660.00 1,472.75 (812.75) -123.14% Repair/Maint NOT Bldg 500.00 33.00% 40.00 164.99 (124.99) -312.48% 80.00 164.99 (84.99) -106.24% Repair/Maint Equip(in) 2,400.00 28.95% 200.00 0.00 200.00 100.00% 400.00 694.84 (294.84) -73.71% Repair/Maint Equip(out) 5,000.00 0.00% 400.00 0.00 400.00 100.00% 800.00 0.00 800.00 100.00% Equipment Parts 8,000.00 0.00% 725.00 0.00 725.00 100.00% 1,3%00 352,52 997.48 73.89% Uniforms 3,600.00 10.34% 300.00 235.55 64.45 21.48% 600.00 372.35 227.65 37.94% Miscellaneous 1,000.00 28.80% 50.00 288.00 (238.00) -476.00% 100.00 288.00 (188.00) -188.00% Landscaping Material 500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Dues&Subscriptions 200.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0,00% Conferences&Training 4,425.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0,00 0.00 0.00% Personal Protection Equipment 2,400.00 0.00% 200.00 0.00 200,00 100.00% 400.00 0.00 400.00 100.00% Clean up Days 5,500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0,00 0.00 0.00% 14 Total Public Works 411,284.53 17.96% 48, 6.50 42,462.91 5,683.59 11.80% 80,193.01 73,878.69 6,314.32 7.87% 3120-Streets Equipment Parts 3,000.00 0.00% 250.00 0.00 250.00 100.00% 500.00 0.00 500.00 100.00% Street Maintenance Materials 20,000.00 0.39% 1,000.00 77.40 922.60 92.26% 1,500.00 77.40 1,422.60 94.84% Seal Coating/Crack Filling 210,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Mill and Overlay Program 160,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Sign Repair Materials 2,.500.00 0.00% 200.00 0.00 200.00 100.00% 300.00 0.00 300.00 100.00% Contract Services-General 10,000.00 7.10% 0.00 710.12 (710.12) -100.00% 0.00 710.12 (710.12) -100.00% Contract Services-ROW 5,000.00 0.00% 0.00 0.00 0.00 0.00% 0,00 0,00 0.00 0.00% Repairs/Maint Equipment 2,500.00 0.00% 210.00 0.00 210.00 100.00% 420.00 0.00 420.00 100.00% Total Streets 413,000.00 0.19°/d 1,660.00 787.52 872.48 52.56% 2,720.00 787.52 1,932.48 71.05% Detail 7 Pull Year MONTH YTD 3125-Ice&Snow Removal BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 2016 %to date Month Month Month Month YTD YTD YTD YTD _ Landscaping Material 750.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Sand/Salt 70,000.00 6.50% 15,000.00 4,550.73 10,449.27 69.66% 30,000.00 4,550.73 25,449.27 84.83% Contract Services 4,000.00 0.00% 1,000.00 0.00 1,000.00 100.00% 2,000.00 0.00 2,000.00 100.00% Repairs/Maint Equipment 12,500.00 15.12% 1,000.00 1,784.44 (784,44) -78.44% 2,000.00 1.889.58 110.42 5.52% Total lee&Snow Removal 87,250.00 7.38% 17,000.00 6,335.17 10,664.83 62.73% 34,000.00 6,440.31 27,559.69 81.06% 3160-Street Lighting Street Lighting 26,400.00 14.05% 2,200.00 1,709.29 490.71 2231% 4.400.00 3,709.29 690.71 15.70% Total Street Lighting 26,400.00 14.05% 2,200.00 1,709.29 490.71 22,31% 4,400.00 3,709.29 690.71 15.70% 3200-Recycling Recycling Supplies 3,500.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0,00% Miscellaneous 2,400.00 0.00% 200.00 0.00 200.00 100.00% 400.00 0.00 400.00 100,00% Total Recycling 5,900.00 0.00"% 200.00 0.00 200.00 100.00% 400.00 0.00 400.00 100.00% 3250-Tree Program Contract Services 1,000.00 0.00% 0.00 0.00 _ 0.00 0.00% 0.00 0.00 0.00 0.00% Total Tree Program 1,00000 0.00% 0.00 0.00 0.00 OAO% 0.00 0.00 0.00 0.00% Total Public Works L944=,834*53=8:989/0 69,206.50 51,294.89 17,911.61 25.88% 121,713.01 84,815.81 36,897.20 30.31% Detail 8 DEPT 450-CULTURE,RECREATIO Full Year MONTH YTD BUDGET BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) 5200-Parks&Recreation 2016 %to date Month Month Month Month YTD YTD YTD YTD FT Salaries 115,254.00 11.32% 8,865.69 6,292.93 2,572.76 29,02% 17,731.38 13,050.28 4,681.10 26.40% PT Salaries 32,500.00 7.97% 2,500.00 L650.00 850.00 34.00% 5,000.00 2,590.00 2,410.00 48.20% PERA Contributions 8,644.05 12.71% 664.93 532.69 132.24 19.89% 1,329.85 1,098.72 231,13 17.38% FICA Contributions 9,160.75 10.15% 704.67 472.67 232.00 32.92% 1,409,35 929.63 479.72 34.04% Medicare Contributions 2,142.43 10.15% 164.80 110.55 54.25 32.92% 329.61 217.45 112.16 34.03% Health/DentalInsurance 19,019.00 15.26% 1,463.00 1,450.80 12.20 0.83% 2.926.00 2,901.60 24.40 0,83% Unemployment Benefits 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Workers Compensation 4,700.00 79.47% 4,700A0 3,734.94 965,06 20.53% 4,700.00 3,734.94 965.06 20.53% Shop Materials 1,000.00 6.50% 100.00 0.00 ]00.00 100.00% 20Q.00 64.96 135.04 67.52% Chemicals 1,500.00 0.00% 125.00 0.00 125.00 100.00% 250.00 0.00 250,00 100.00% Equipment Parts 4,000.00 9.53% 330.00 381.28 (51.28) 45.54% 660.00 381.28 278.72 42.23% Building Repair Supplies 500.00 31.40% 40.00 0,00 40.00 100.00% 80.00 157.01 (77.01) -96.26% Landscaping Materials 2,000.00 8.31% 166.00 54.17 111.83 67.37% 332.00 166.17 165.83 49.95% Small Tools and Minor Equip 2,000.00 15.65% 150.00 31294 (162,94) -108.63% 300.00 312.94 (12.94) -4.31% Mileage 0.00 0,00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Insurance 3,200.00 0.00% 0.00 0.00 0.00 0.00% 3,200.00 0.00 3,200.00 100.00% Electric Utility 9,500.00 18.11% 900.00 820.11 79.89 8.88% 1,850.00 1,720.11 129.89 7.02% Refuse 1,500.00 6.67% 125.00 0,00 125,00 100.00% 250.00 100.00 150.00 60.00% Repair/Maint Bldg 1,800.00 0.00% 150.00 0.00 150.00 100.00% 300.00 0.00 300.00 100.00% Repair/MaintNOTBIdg 3,000.00 0.00% 250.00 0,00 250.00 100.00% 500,00 0.00 500.00 100.00% Repair/Maint Equip 1,500.00 0.00% 125.00 0.00 125.00 I00,00% 250.00 0.00 250.00 100.00% Rental Buildings 6,000.00 0.00% 500.00 0.00 500,00 100.00% 1,000.00 0.00 1,000.00 100.00% Personal Protection Equipment 1,200.00 0.00% 100.00 0.00 100.00 100.00% 200.00 0.00 200.00 100.00% Miscellaneous 1,200.00 0.00% 100.00 0.00 100.00 100.00% 200,00 0.00 200.00 100.00% Total Parks Sa Recreation 231,320.23 11.86% 22,224.09 15,813.08 6,411.01 28.85% 42,998.19 27,425.09 15,573.10 36.22% IT&Telephone IT-Hardware 3,000.00 48.83% 0.00 1,267.99 (1,267.99) -100.00% 0.00 1,465.00 (1,465.00) -100.00% IT-Software 8,156.00 40.22% 0.00 0.00 0.00 0.00% 8,156.00 3,280.00 4,876.00 59.78% IT-Support Services 50,000.00 16.76% 4,165,00 4,211.25 (46.25) -1.11% 8,330.00 8,377.50 (47.50) -0.57% IT-Networking 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% INET Contingency 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Telephone 20,820.00 17.18% 1,735.00 1,998.22 (263.22) -1517% 3,470.00 3,577.48 (107.48) -3.10% Total IT&Telephone 81,976.00 20.37% 5,900.00 7,477.46 (1,577A6) 26.74% 19,956.00 16,699.98 3,256.02 16.32% Grand Total all Expenses 3,465,514.32 9.93% 248,081.52 177,778.12 64,403.40 25.96% 472,967.02 344,228.05 108,782.97 23.00% Subtotal Net Income over Expenses 20,000.00 -579.10% (144,713.52) (25,231.14) 113,582.38 78.49% (315,224.02) (115,8 99.17) 179,448.85 -56.93% DF,PT 460-COMP ADJ 20,000.00 0.00% 20,000.00 0.00 20,000.00 100,00% 20,000.00 0.00 20,000.00 100.00% Debt Service increase 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Transfer to City Projects(Streets) 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% DEPT 493-OTH FLNANCING 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% GRAND TOTAL E}iP ALL DEPTS 3,485,514.32 9.88% 268,081.52 177,778.12 84,403.40 _ 31.48% 492,967.02 344,228.05 128,782.97 2(t.12% Net Income over Expenses 0,00 0.00% (164,713.52) (25,231.14) 139,482.38 84.68% (335,224.02) (115,819.17) 219,404.85 65.45% Detail 9 City of Lane Elmo 3/15/2016 2015 By Month Budeet to Actual Com aranve For the month ending Fehruary 24 2016 101-General Fund Summary By Department Full Year MONTH YTD INEPT 410-GEN'L GOV'T BUDGET BUDGET ACTUAL Variance(S) Variance(%) BUDGET ACTUAL Variance{$) Variance(%} 2016 %to date Month Month Month Month YTD YTD YTD YTD REVENUE Total Revenue 3,485,514.32 6.55% 103,368.00 152,546.98 49,178.98 47.58% 157,743.00 228,408.88 70,665.88 44.80% EXPENSE Total Mayor&Council 45,955.32 15.55% 1,000.00 1,856.35 (856.35) -85.640/o 2,250.00 7,145.43 (4,895.43) -217.57% Total Administration 360,997.50 16.56% 25,818.66 20,677.24 5,141.42 19.91% 78,537.32 59,789.72 18,747.60 23.87% Total Elections 15,800.00 0.00% 950.00 0.00 950.00 100.00% 950.00 0.00 950.00 100.00% Total Finance 124,835.30 11.38% 17,210.40 7,298.68 9,911.72 57.59% 24,420.81 14,202.74 10,218.07 41.84% Total Planning&Zoning 284,682.35 12.69% 17,406.72 12,948.72 4,458.00 25.61% 34,013.43 36,132.14 (2,118.71) -6.23% Total Engineering Services 48,000.00 11.40% 4,000.00 2,894.16 1,105.84 27.65% 8,000.00 5,472.91 2,527.09 31.59% Total City hall 55,082.00 15.14% 4,711.00 4,058.39 652.61 13.85% 9,422.00 8,337.85 1,084.15 11.51% Total General Government 435,352.47 8.260/. 71,096.78 49,733.54 21,363.24 30.050/. 157,593.56 131,080.79 26,512.77 16.82% DEPT 420-PUBLIC SAFETY Total Police 527,060.47 0.12% 0.00 0.00 0.00 0.00% 0.00 634.22 (634.22) -100.00% Total Prosecution 54,700.00 18.07% 4,600.00 4,948.21 (348.21) -7.57% 9,200.00 9,884.21 (684.21) -7.44% Total Fire 377,231.71 15.61% 52,764.07 39,384.73 13,379.34 25.36% 78,701.13 58,900.69 19,800.44 25.16% 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 11.62% 21,690.08 16,028.67 5,661.41 26.10% 41,605.13 30,312.24 11,292.89 27.14% Total Emergency Communications 7,400.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Animal Control 7,550.00 15.56% 600.00 575.00 25.00 4.17% 1,200.00 1,175.00 25.00 2.08% Total Public Safety 1,272,031.04 7.93% 79,654.15 60,936.61 18,717.54 23.50% 130,706.26 100,906.36 29,799.90 22.80% Summary_1 MONTH YTD BUDGET ACTUAL Variance($) Variance(%) BUDGET ACTUAL Variance($) Variance(%) DEPT 430-PUBLIC WORKS Month Month Month Month YTD YTD YTD YTD Total Public Works 411,284.53 17.96% 48,146.50 42,462.91 5,683.59 11.80% 80,193.01 73,878.69 6,314.32 7.87% Total Streets 413,000.00 0.19% 1,660.00 787.52 872.48 52.56% 2,720.00 787.52 1,932.48 71.05% Total Iee&Snow Removal 87,250.00 7.38% 17,000.00 6,335.17 10,664.83 62.73% 34,000.00 6,440.31 27,559.69 81.06% Total Street Lighting 26,400.00 14.05% 2,200.00 1,709.29 490.71 22.31% 4,400.00 3,709.29 690.71 15.70% Total Recycling 5,900.00 0.00% 200.00 0.00 200.00 100.00% 400.00 0.00 400.00 100.00% Total Tree Program 1,000.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Total Public Works 944,834.53 8.98% 69,206.50 51,294.89 17,911.61 25.88°/6 121,713.01 84,815.81 36,897.20 _ 30.31% DEPT 450-CULTURE,RECREATION Total Parks&Recreation 231,320.23 11.86% 22,224.09 15,813.08 6,411.01 28.85% 42,998.19 27,425.09 15,573.10 36.22% IT&Telephone 81,976.00 20.37% 5,900.00 7,477.46 (1,577,46) -26.74% 19,956.00 16,699.98 3,256.02 16.32% GRAND TOTAL ALL EXPENSES 3,465,514.32 9.93% 248,081.52 fl77,778.12 64,403.40 25.960/u 472,967.02 344,228.05 108,782.97 23.000/. SUB TOTAL NET INC OVER EXP 20,000.00 -579.10% (144,713.52) (25,231.14) 113,582.38 -78.49"/0 (315,224.02) (115,819.17) - 179,448.85 -56.93% DEPT 460-COMP ADJ 20,000.00 0.00% 20,000.00 0.00 20,000.00 100.00% 20,000.00 0.00 20,000.00 100.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 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% DEPT 493-OTH 1+INANCING 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% GRAND TOTAL ALL DEPTS 3,485,514.32 9.88"/a 268,081.52 -177,778.12 84,403.40 31.48% 492,967.02 344,228.05 128,782.97 26.12% Net Income over Expenses 0.00 0.00% (164,713.52) (25,231.14) 139,482.38 84.68% (335,224.02) (115,819.17) 2191404.85 65.45% Summary_2