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