2018.12.17 CC Packet - Laserfiche WebLink

Home

2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION 1213112018 Notes WATER REVENUES: Budget Projected Budget Water Billings: Residential $ 846,651.00 $ 813,693.00 $ 852,081.00 Multi Family $ 120,990.00 $ 125,678.00 $ 127,922.00 Irrigation $ 300,441.00 $ 280,753.00 $ 280,753.00 - Less City Irrigation Accounts $ (31,603.00) $ (31,295.00) $ (31,295.00) - Commercial $ 27,606.00 $ 27,624.00 $ 28,512.00 Industrial $ 13,486.00 $ 22,939.00 $ 13,239.00 - Educational $ 3,203.00 $ 2,632.00 $ 2,656.00 Base Fees = $ 432,388 (depreciation = $421,782) Account Adjustments $ - $ $ _ - Usage Fees = $ 841,480 Water Billings (Revenue Requirement) $ 1,280,774.00 $ 1,232,024.00 $ 1,273,868.00 Total Fees = $1,273,868 Hydrant Water Sales $ 300.00 $ 744.00 $ 600.00 Water Penalties $ 11,875.00 $ 15,598.00 $ 15,598.00 Water Meters $ 25,000.00 $ 38,040.00 $ 25,000.00 $250 x 100 new homes TOTAL WATER REVENUES $ 1,317,949.00 $ 1,286,406.00 $ 1,315,066.00 WATER EXPENSES: Budget Projected Budget Operation & Maintenance Wages: Public Works Director - Anderson $ 37,175.00 $ 37,175.00 $ 38,290.00 33% of Pay Grade 10 Maximum Compensated Absences - Anderson $ 1,000.00 $ 1,000.00 $ 1,000.00 Maintenance Worker - Smith $ 30,944.00 $ 30,944.00 $ 31,873.00 50% of Pay Grade 5 Maximum Compensated Absences - Smith $ 1,000.00 $ 1,000.00 $ 1,000.00 Maintenance Worker- Pettee $ 30,944.00 $ 5,986.00 $ 26,717.00 50%of Pay Grade 5 Step 2 (start 11/12/18) Compensated Absences - Pettee $ 1,000.00 $ $ 1,000.00 In Lieu of Health Insurance $ 2,550.00 $ 2,550.00 $ 2,880.00 $240/month for waived coverage Standby Pay $ 7,800.00 $ 7,800.00 $ 8,060.00 50% of $310/week ris ertime (104 hours at overtime rate) - Smith $ 4,642.00 $ 4,642.00 $ 4,781.00 104 hours (10%) @ overtime rate Overtime (104 hours at overtime rate) - Pettee $ 4,642.00 $ $ 4,008.00 104 hours (10%) @ overtime rate $ 121,697.00 $ 91,097.00 $ 119,609.00 Fringe Benefits: Pera- Anderson $ 2,788.00 $ 2,788.00 $ 2,872.00 7.5%of Salary Pera - Smith $ 2,669.00 $ 2,669.00 $ 2,749.00 7.5%of Salary & Overtime Pera - Pettee $ 2,669.00 _ $ 449.00 $ 2,3D4.00 7.5%of Salary & Overtime Pera - Standby Pay $ 585.00 $ 585.00 $ 605.00 7.5%of Standby Pay Fica- Anderson $ 2,305.00 _ _ $ 2,305.00 $ 2,374.00 6.2%of Salary Fica - Smith $ 2,206.00 $ 2,206.00 $ 2,273.00 6.2%of Salary & Overtime Fica - Pettee $ 2,206.00 $ 371.00 $ 1,905.00 6.2%of Salary & Overtime Fica - Standby Pay $ 484.00 $ 484.00 $ 500.00 6.2%of Standby Pay Medicare -Anderson $ 539.00 $ 539.00 $ 555.00 1.45%of5alary Medicare - Smith $ 516.00 $ 516.00 $ 531.00 1.45%of Salary & Overtime Medicare - Pettee $ 516.00 $ 87.00 $ 446.00 1.45%of Salary & Overtime Medicare -Standby Pay $ 113.00 $ 113.00 $ 117.00 1.45% of Standby Pay Health Insurance -Anderson $ 6,909.00 $ 7,074.00 $ 8,480.00 33%of Health Partners High -Deductible Plan Health Insurance- Pettee $ 10,791.00 $ 815.00 $ 5,077.00 50%of HealthPartners High -Deductible Plan Dental Insurance -Anderson $ 413.00 $ 470.00 $ 470.00 33%of Delta Dental Plan Dental Insurance - Smith $ 470.00 $ 705.00 $ 705.00 50%of Delta Dental Plan Dental Insurance - Pettee $ 705.00 $ 45.00 $ 267.00 50%of Delta Dental Plan Worker's Compensation - Anderson $ 4,140.00 $ 2,424.00 $ 3,703.00 $38,290/100•$9.67 Worker's Compensation - Smith $ 3,305.00 $ 2,485.00 $ 3,544.00 $36,654/100•$9.67 Worker's Compensation - Pettee $ 3,305.00 $ $ 2,971.00 $30,725/100•$9.67 Worker's Compensation - Standby Pay $ - $ (342.00) $ - Exempt from work comp $ 47,634.00 $ 26,788.00 $ 42,448.00 Supplies: Cfraning Supplies $ 1,940.00 $ 1,940.00 $ 1,940.00 Catchall account for rags, first aid supplies.... Chemicals $ 50,000.00 $ 32,440.00 $ 40,000.00 Added at 5 wells (chlorine, fluouride...) - Hazardous Waste Generators License $ 260.00 $ 114.00 $ 120.00 This is absolutely ridiculous Motor Fuels $ 2,000.00 $ 2,145.00 $ 2,656.00 Water Department's share of bulkfuel purchases Small Tools & Equipment $ 10,000.00 $ 6,620.00 $ 10,000.00 Shop tools, shelving, cold -weather gear... Uniforms $ 2,000.00 $ 1,170.00 $ 2,040.00 $170/month Smart Controllers (for irrigation systems) $ $ $ 10,000.00 Purchase and sell at discount to home owners Water Meters $ 100,000.00 $ 100,000.00 $ 100,000.00 New accounts and meter conversions (radio read) $ 166,200.00 $ 144,429.00 $ 166,756.00 Repairs & Maintenance: Repairs & Maintenance $ 39,600.00 $ 30,000.00 $ 30,000.00 Lubricants, shop supplies, vehicle maint... Watermain Breaks $ 15,000.00 $ 30,814.00 $ 32,000.00 4 watermain breaks @ $8,000 Well Pump Repairs $ 25,000.00 $ 25,000.00 $ 25,000.00 One well per year Building Repair & Maintenance $ 8,000.00 $ 3,100.00 $ 5,000.00 Non-specific building repairs Reroof well houses $ $ 24,434.00 $ - Well houses #2, #3, and #4 Septic System Pumping $ 2,780.00 $ 2,930.00 $ 3,000.00 $250/month - Weed Control $ - $ 841.96 $ 850.00 Public works site and water towers - HVAC Repairs $ _ 4,400.00 $ 4,400.00 $ 4,400.00 Performed by NAC Mechanical $ 94,780.00 $ 121,519.96 $ 100,250.00 Professional Services: Page 1