2019.11.04 CC Packet - Laserfiche WebLink

Home

2020 Water and Sewer Business Pro -Forma ACCOUNT DESCRIPTION WATER REVENUES: Water Billings: • Residential Multi Family 2019 1 Adopted L Budget $ 848,484.00 $ 124,980.00 2019 J 1 2020 Proposed Budget Notes Projected Projected $ 747,541.42 $ 790,379.16 $ 127,D00.12 $ 219,457.90 $ (24,575.68) $ 28,596.69 $ 13,906.13 $ 2,527.95 j_ $ 1,157,292.2L 1 $ Base Fees = $ 491,520 (depreciation = $497,248) Usage Fees = $ 665,772 Total Fees = $1,157,292 I Small adjustments to accounts receivable $ 124,756.46 Irrigation j $ 280,753.00 $ 219,457.90 - Less City Irrigation Accounts $ (31,295.00)7 $ (24,575.68) - Commercial $ 28,457.00 $ 27,570.26 -Industrial $ 13,138.00 $ 13,594.13 - Educational $ 2,656.00 $ 2,503.95 Water Billings (Revenue Requirement) $ 1,267,173.00 $ 1,110,848.44 Account Adjustments $ - $ (194.69) Hydrant Water Sales $ 600.00 $ 1,836.00 $ 1,800.00 Truck loads of unmetered hydrant water Water Penalties $ 15,598.00 $ 25,000.00 $ 1,308,371.00 i _ $ 14,593.00 $ 25,252.40 . $ 1,152,335.15 $ 15,045.00 1 $ 16,000.00 $ 1,190,137.26 Budget Approximately 1.3%of water billings $320 x 50 new homes (net of sales tax) Water Meters TOTAL WATER REVENUES WATER EXPENSES: Operation & Maintenance Wages: Budget Projected_ _ Public Works Director - Anderson $ 38,290.00 $ 38,290.00 $ 39,439.00 '33% of Pay Grade 10 Maximum Compensated Absences -Anderson Maintenance Worker - Smith Compensated Absences - Smith Maintenance Worker - Pettee Compensated Absences - Pettee In Lieu of Health Insurance Standby Pay Overtime (104 hours at overtime rate) - Smith Overtime (104 hours at overtime rate) - Pettee Fringe Benefits: $ 1,000.00 $ 31,873.00 . $ 1,000.00 ! $ 26,717.00 $ 1,000.00 $ 2,880.00 $ 8,060.00 $ 4,781.00 $ 4,008.00 $ 119,609.00 _ $ 1,000.00 $ 31,873.00 $ 1,000.00 $ 26,717.00 $ 1,000.00 $ 2,880.00 $ 8,060.00 $ 4,781.00 $ 4,008.00 $ 119,609.00 . _ $ 1,000.00 $ 32,829.00 $ 1,000.00 $ 28,757.00 $ _ 1,000.00 $ 2,880.00 $ 8,320.00 $ 4,924.OD $ 4,314.00 $ 124,463.00 _ 1 133%of increase in PTO Bank 50%of Pay Grade 5 Maximum 50%of increase in PTO Bank 50%of Pay Grade 5 Step 3 50%of increase in PTO Bank . $240/month for waived coverage 50%of $320/week 104 hours (10%) @overtime rate 104 hours (10%) @ overtime rate Pera- Anderson $ 2,872.00 $ 2,872.00: $ 2,958.00 17.5%of Salary Pera - Smith $ 2,749.00.1 $ 2,749.00 : $ 2,831.00 $ 2,480.00 $ 624.00 7.5%of Salary & Overtime Pere - Pettee $ 2,304.00 $ 2,304.00 7.5%of Salary & Overtime 7.5%of Standby Pay Para - Standby Pay $ 605.00 $ 605.00 Fica- Anderson $ 2,374.00 $ 2,374.00 _ $ 2,445.00 6.2%of5alary _ Fica - Smith $ 2,273.00 . $ 2,273.00 2,341.00 . 6.2%of Salary & Overtime Fica - Pettee $ 1,905.00 $ 500.00 $ 555.00 $ $ $ 1,905.00 500.00 555.00 i _$ $ 2,050.00 $ 516.00 1 $ 572.00 6_.2%of Salary & Overtime 6.2%of Standby Pay 1.45%of Salary 1.45%of Salary & Overtime 1.45%of Salary&Overtime _ 1.45%of Standby Pay Fica - Standby Pay Medicare -Anderson Medicare - Smith $ 531.00 $ 531.00 $ 547.00 Medicare -Pettee Medicare -Standby Pay Health Insurance -Anderson Health Insurance- Pettee Dental Insurance -Anderson Dental Insurance -Smith Dental Insurance -Pettee Worker's Compensation - Anderson Worker's Compensation -Smith Worker's Compensation -Pettee Worker's Compensation - Standby Pay Supplies: Cleaning Supplies $ 446.00 $ 117.00 $ 8,480.00 $ 5,077.00 $ 470.00 $ 705.00 $ 267.00 $ 3,703.00 $ 3,544.00 $ 2,971.00 $ - $ 42,448.00 _ $ 1,940.00 $ 446.00 $ 117.00 $ 8,347.00 $ 4,717.00 $ 470.00 $ 705.00 $ 267.00 $ 2,481.00 $ 2,241.00 $ 2,248.00 $ - $ 38,707.00 $ 2,200.00 _ $ 480.00 $ 121.OD $ 9,198.00 $ 5,077.00 $ 470.00 $ 705.00 $ 267.00 _ $ 3,814.00 $ 3,651.00 $ 3,198.00 $ - $ 44,345.00 $ 2,460.00 33%of Health Partners High -Deductible Plan 50%of Health Partners High -Deductible Plan 33%of Delta Dental Plan 50% of Delta Dental Plan 50% of Delta Dental Plan $39,439/100-$9.67 $37,753/100•$9.67 $33,071/100'$9.67 Exempt from work comp 1 Catchall accountfor rags, firstaid supplies.... Chemicals $ 40,000.00 $ 30,000.00 $ 30,000.00 $ 99.00 $ 3,200.00 $ 50,000.00 $ 1,200.01 $ 16,250.00 $ 50,000.00 $ 113,209.00 $ 35,O00.00 $ 24,000.00 $ 20,000.00 $ 6,400.00 $ - $ 3,000.00 $ 1,000.00 }]Performed Added at 5 wells (chlorine, fluouride...) This is an absolutely ridiculous fee Water Department's shareof bulkfuel purchases Shop tools, shelving, cold -weather gear... $100/month Purchase and sell 350 at discount to home owners 1,175 existing meters to convert to radio reads Lubricants, shop supplies, vehicle maim 3 watermain breaks @ $8,000 Contingency budget if well pump fails Non-specific building repairs Hoping this won't happen again] $250/month Public works site and water towers - Hazardous Waste Generators License $ 120.00 $ 99.00 Motor Fuels $ 2,656.00 $ 2,565.00 Small Tools & Equipment $ 50,000.00 $ 10,000.00 Uniforms $ 2,040.00 Smart Controllers (far irrigation systems) $ 10,000.00 Water Meters $ 100,000.00 $ 166,756.00 Repairs & Maintenance: Repairs & Maintenance $ 30,000.00 - Watermain Breaks $ 32,000.00 Well Pump Repairs $ 25,000.00 Building Repair & Maintenance $ 5,000.00 $ 1,140.00 $ - $ 65,000.00 .....$ $ 111,004.00 35,000.00 $ 24,000.00 $ 20,000.00 $ 6,400.00 Vandalism Repairs - Well No. 3 (net of insurance) -Septic System Pumping _ Weed Control HVAC Repairs _ $ $ (1,955.00) f $ 3,000.OD $ 867.00 $ 4,400.00 $ _ 3,000.00 $ 850.00 $ 4,400.00 ' $ 4,400.00 by NAC Mechanical $$ 300,250.00 $ 91,712.00 $ 93,800.00 Page 1