Loading...
HomeMy WebLinkAbout20200928 UC PacketAGENDA Utility Commission Regular Meeting Monday, September 28, 2020 5:30 p.m. Virtual Meeting via Zoom 1. CALLTOORDER (5:30) 2. ADDITIONS ORCORRECTIONS TOAGENDA (5:30) 3. AUDIENCE INPUT (5:32) 4. APPROVAL OFMINUTES (5:35) a. August 24, 2020 Meeting 5. PUBLIC HEARINGS (5:40) 6. OLDBUSINESS (5:40) a. Water Efficiency & Stormwater Rebate Update (5:40) 7. NEWBUSINESS (5:50) a. Utility Rate Model Review (5:50) b. 2021 Utility Budgets (6:10) 8. EXECUTIVE DIRECTOR’SREPORT (6:40) a. City Project Update b. Well Pumping Report c. Action Item / Issues list i. MET Council Well Assessment ii. Smart Meter Update iii. Tour of aWater Tower d. Set Next Meeting Agenda for October 26, 2020 9. ADJOURNMENT (6:45) UTILITY COMMISSION REGULAR MEETING MINUTES August 24, 2020 CALL TO ORDER Pursuant to due call and notice thereof the regular Utility Commission meeting of the City of Rosemount was called toorder on August 24, 2020, at 5:32 p.m. virtually via Zoom. Commissioner Cahn called meeting to order with Commissioners Demuth and Rome, Mayor Droste, City Administrator Martin, Public Works Director/City Engineer Erickson, and Recording Secretary Paque. ADDITIONS OR CORRECTIONS TO AGENDA Commissioner Cahn requested anew section, Action Items/Issues List, be added under the Executive Director’sReport with the following items; MET Council Well Assessment, Smart Meter Update, Tour of a Water Tower, and 5-Year Pond Plan. Public Works Director/City Engineer Erickson added. 6.a. to update the commissioners on the Utility Commission ordinance. AUDIENCE INPUT None APPROVAL OF MINUTES Motion by Rome Second by Demuth Motion to approve the minutes of the June 22, 2020 Utility Commission meeting. Ayes: 3 Nays: 0. Motion carried. PUBLIC HEARINGS None OLD BUSINESS 6.a. Utility Commission Ordinance Update Erickson updated the commission on the changes that were made to the statutes and the streetlight systems. Language about the commission reviewing new developments was changed to only include updates to the existing comprehensive plans. Commissioner Cahn questioned part of the ordinance that was proposed to be removed regarding cable company’sperformance. City Administrator Martin and Mayor Droste discussed the city’srole with cable companies and that the city does not have control of the companies and the services they provide. Motion by Rome Second by Demuth Motion to recommend City Council approval of the first reading of the Utility Commission Ordinance. Ayes: 3 Nays: 0. Motion carried. NEW BUSINESS 7.a. MCES Water Efficiency Rebate Update Erickson provided an update to the commission on the rebates. Commissioners requested that updates on the rebates be provided quarterly. Another update will beprovided at the September meeting to align with Metropolitan Council quarterly reporting deadlines. City savings on the smart meters and stormwater rebates will be included with this item going forward. The commission briefly discussed ways topromote the rebates for the upcoming fall and winter months. 7.b. Stormwater Pond Maintenance Erickson presented anoverview on the ponds scheduled for maintenance. Staff has received estimated costs for the work associated with the maintenance, including dredging. The Public Works Director/City Engineer and the Stormwater Specialist will evaluate the ponds to see which ones will be included in the 2021 budget. At the September Utility Commission, the commission and staff will discuss the utility budgets and will review the 5-year plan. EXECUTIVE DIRECTOR’S REPORT 8.a. City Project Update Public Works Director/City Engineer Erickson provided the Commission with a memo regarding ongoing projects. 8.b. Well Pumping Report Public Works Director/City Engineer Erickson presented the current well pumping records. 8.c. Action Item / Issues List i. MET Council Well Assessment ii. Smart Meter Update iii. Tour of a Water Tower iv. 5-Year Pond Plan Updates on these items will be provided at the September Utility Commission meeting. 8.d. Set Meeting Agenda for September 28, 2020 ADJOURNMENT Commissioner Cahn adjourned the meeting at 6:17 p.m. Respectfully submitted, Jessie Paque Recording Secretary EXECUTIVE SUMMARY Utility Commission Meeting: September 28, 2020 AGENDA ITEM: Water Efficiency & Stormwater Rebate AGENDA SECTION: Update Old Business PREPARED BY: Jessie Paque, Deputy Clerk/Office Specialist AGENDA NO. 6.a. Jane Byron, Stormwater Specialist ATTACHMENTS: None APPROVED BY: BLE RECOMMENDED ACTION: None Quarterly WaterEfficiency RebateUpdate: The City ofRosemount was awarded a Water Efficiency Grant from the Metropolitan Council (MCES) in the amount of $11,300. The city is required to match $3,770 and that has been funded from the Water Fund. As part ofthis program, the following rebate amounts are allowed: 50 for Water Sense Toilets 150 for Energy Star Washers 150 for Water Sense Irrigation Controllers 200 for Irrigation system audits Table 1 provides a summary of the entire rebate program activity, along with the city-funded rebate programs that were in place prior to the MCES Water Efficiency Grant in January 2020. 2020Table1201820191/1/20-9/25/20) Gallons of Water Saved Annually (est) 316,800 105,600 335,400 Total Rebate $4,853.82 $1,434.93 $4,185.17 Municipality Contribution (25%) $4,853.82 $1,434.93 $1,046.29 Irrigation Controllers Replaced: 31 12 29 Toilets Replaced: 3 0 6 Washers Replaced: 2 0 7 Audits: 0 0 0 C:\\Users\\jab\\AppData\\Local\\Temp\\6.a. Water Efficiency and Stormwater Rebate Update_614885\\6.a. Water Efficiency and Stormwater Rebate Update.docx Quarterly Stormwater RebateUpdate: In May of 2019, the Utility Commission recommended City Council adopt a rebate program for residents to install projects on their property to improve stormwater quality and reduce runoff volume. In March 2020, City Council approved the Stormwater Rebate Policy and established a maximum amount of $5,000 for 2020. Table 2 provides a summary of the entire rebate program activity. Table 2 2020 Total Rebate $0 Rain Barrels: $0 Cisterns & Rainwater Harvesting: $0 Raingardens: $0 Native Plantings: $0 Buffers: $0 Stormwater Reuse: $0 Permeable Pavers & Pavements $0 Please note, only one application has been received for this program. The project was not approved because itwas located in an easement next toa storm drain. However, further investigation shows that four residents are taking advantage of the SWCD Landscaping for Clean Water $250 installation grant. Landscaping for Clean Water grant recipients are provided with information on the Rosemount Stormwater Rebate. It appears as though residents are taking advantage of other complementary programs in 2020. Staff will continue topublicize these programs via social media, city newsletters, staff updates and additional methods. 2 EXECUTIVE SUMMARY Utility Commission Meeting: September 28, 2020 AGENDA SECTION: AGENDA ITEM: Utility Rate Model Review New Business PREPARED BY: Brian Erickson, P.E. Director ofPublic AGENDA NO. 7.a. Works/City Engineer APPROVED BY: ATTACHMENTS: Rate Models; Sample BLE RECOMMENDED ACTION: Motion to Recommend City Council Approval of Water and Sewer Rate Changes for 2021 BACKGROUND WATER UTILITY RATES Staff has completed itsannual review ofthe Water Utility Fund activity and adjusted the model to reflect the proposed changes for 2021 and beyond. Based on this review, staff isproposing changes that will result in a net decrease of 2.7% to the water portion of the utility bill for the average residential water customer, as shown in the attached sample. The attached water rate model includes the following items of note: LINES 7-16: Reduced the fixed rate for the third year of the three-year phase out. Fixed charges are now eliminated. Usage rates will increase 5% to make up the difference in revenue. Future rate increases are expected to be 5% or less for the next 10+ years. LINES 17-20: Includes 0.5% annual increase to surcharge which began in 2017 to increase revenue in the Capital Investment Fund (had not been adjusted for many years prior to that). The CIF is programmed to contribute 20% towards the annual debt service beginning in 2022, or sooner if needed. LINES 21-23: Includes 5% annual increase to the meter maintenance fee for ¾” meters (which is 86% of all meters), and a 0.5% annual increase to all other meters. Ideally, revenue from meter maintenance fees (Lines 35-38) should offset the cost of meter replacements (LINE 44). LINE 41: Includes funding for amaintenance FTE in 2022 for a water treatment plant operator 100% funded by Water). LINE 50: Includes water tower painting, new generators, etc. as scheduled in the Long-Term Plan LINE 51: Reflects planned utility equipment purchases to match Capital Improvement Plan (CIP). LINE 56: Starting in 2023, water treatment plant costs will be shared 75% from Utility fund, 25% from Core/CIF funds LINE 64: Connection cost for a ¾” meter was $2300 for 2017, $2400 for 2018, and will include a 25 annual increase thereafter (had not been adjusted for many years prior to 2017) C:\\Users\\jab\\AppData\\Local\\Temp\\7.a. Utility Rate Model Review_614886\\7.a. Utility Rate Model Review.docx LINE 72: Starting in 2023, add $679,000/year toexisting debt tocover a portion of the water treatment plant debt Although it isnot shown on the printed spreadsheet, the model is extended through 2035 to ensure that the Water Utility Fund remains viable through the duration of all of the anticipated debt payments. The year-end balance in 2035 is estimated to be $5.02 million. The year with the lowest year-end balance is expected to be 2030 ($3.1 million). SEWER UTILITY RATES Staff has completed its annual review of the Sewer Utility Fund activity and adjusted the model to reflect the proposed changes for 2021 and beyond. Based on this review, staff is proposing changes that will result in a net decrease of 5.9% to the sewer portion of the utility bill for the average residential water customer, as shown inthe attached sample. The attached sewer rate model includes the following items of note: LINE 7: Reduced the fixed rate for the third year of the three-year phase out. Fixed charges are now eliminated. LINE 9: Usage rates increased in 2020 with the elimination of the irrigation meters to maintain the revenue into the Sewer Fund. The 2021 rate has been increased 4% as the result of eliminating the fixed rate. Future rate increases are expected to be 4% orless for the next 10+ years. LINE 25: Includes funding in 2021 for SCADA upgrades and new control cabinets at two lift stations. STORMWATER UTILITY RATES Staff has completed its annual review of the Stormwater Utility Fund activity and adjusted the model to reflect the proposed changes for 2020 and beyond. The annual increase was 5% from 2002 through 2016, 4% in 2017 and 3% in 2018-2019. Based on staff review, no rate increase is needed at this time. The current rates should be sufficient to maintain a viable year-end balance for next 10 years and beyond, assuming no major unplanned expenditures are needed. Staff is working to develop a stormwater system maintenance plan to identify high-priority stormwater improvement projects. With a projected year-end balance of $5.5 million, there isenough funding atthis time to begin these projects, but rates may need to be adjusted in the future depending on the timing and the cost of the projects that are identified in the plan. There is currently $200,000 per year in Line 32 dedicated tothese improvements (starting in 2020). The maintenance plan will discussed with the Utility Commission ata future date. STREET LIGHT UTILITY RATES As part of the 2020 budgets, Council added the Street Light Utility. This enterprise fund will be examined as part of future rate models and corrected as historical data is added. For the 2021 rates staff is not recommending any changes. These current rates should be sufficient to maintain aviable year-end balance for the next 10 years and beyond assuming there are no unplanned expenditures. C:\\Users\\jab\\AppData\\Local\\Temp\\7.a. Utility Rate Model Review_614886\\7.a. Utility Rate Model Review.docx Utility Bill ComparisonAverageTotalUtility2021Change2020 % Change % Change 2019 Actual2020 ActualBillChargesProposedto2021 2020 to20212019 to2021quarterly) Low User$ 272.24$ 317.96$ 288.56$ (7.35) -9.2%6.0% Average User$ 519.24$ 531.28$ 511.56$ (4.93) -3.7%-1.5% High User$ 906.25$ 786.16$ 778.62$ (1.88) -1.0%-14.1% Com / Ind / 2,095.32$ 2,861.32$ 2,926.62$ 16.322.3%39.7% InstAveageUserSUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed water and sewer rate changes. These changes will result inan overall net decrease of 3.7% for the average residential customer (see the impact to other customers in the table below). If that is the recommendation from the Commission, the changes will be reflected in the 2021 Fee Resolution that is presented to City Council for approval in December. C:\\Users\\jab\\AppData\\Local\\Temp\\7.a. Utility Rate Model Review_614886\\7.a. Utility Rate Model Review.docx 2019: usage charges + $6.50 fixed charge + $8.93 surcharge + $1.02 maintenance fee 2020: usage charges + $3.00 fixed charge + $8.97 surcharge + $1.15 maintenance fee 2021: usage charges + no fixed charge + $9.02 surcharge + $1.21 maintenance fee Usage (1000s) 2019 Actual 2020 Actual 2021 Proposed Q1 5 $23.45 $20.82 $18.33 Q2 5 $23.45 $20.82 $18.33 Q3 5 $23.45 $20.82 $18.33 Q4 5 $23.45 $20.82 $18.33 20 $93.80 $83.28 $73.32 2019: $2.80 usage charge + $12.25 fixed charge 2020: $4.76 usage charge + $6.00 fixed charge (minimum 6 usage) 2021: $4.95 usage charge + $0 fixed charge (minimum 6 usage) 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $26.25 $34.56 $29.70 Quarter 2 $26.25 $34.56 $29.70 Quarter 3 $26.25 $34.56 $29.70 Quarter 4 $26.25 $34.56 $29.70 Total $105.00 $138.24 $118.80 2019: Includes $18.36 stormwater fees 2020: Includes $18.36 stormwater fees + $5.75 street light fee 2021: Includes $18.36 stormwater fees + $5.75 street light fee 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $68.06 $79.49 $72.14 Quarter 2 $68.06 $79.49 $72.14 Quarter 3 $68.06 $79.49 $72.14 Quarter 4 $68.06 $79.49 $72.14 Total $272.24 $317.96 $288.56 16.8% -9.2% 6.0% Utility Bill Comparison 2019 - 2021 LOW User) Water Rates Sewer Rates Total Proposed Utility Bill I:\Chris\RATE MODELS\Utility Rate Estimator 2020 v. 2021 Comparison 2019: usage charges + $6.50 fixed charge + $8.93 surcharge + $1.02 maintenance fee 2020: usage charges + $3.00 fixed charge + $8.97 surcharge + $1.15 maintenance fee 2021: usage charges + $0.00 fixed charge + $9.02 surcharge + $1.21 maintenance fee Usage (1000s) 2019 Actual 2020 Actual 2021 Proposed Q1 12 $33.25 $31.60 $29.67 Q2 21 $49.09 $48.97 $47.94 Q3 28 $63.13 $64.40 $64.15 Q4 15 $38.53 $37.39 $35.76 76 $184.00 $182.36 $177.52 2019: $2.80 usage charge + $12.25 fixed charge 2020: $4.76 usage charge + $6.00 fixed charge (minimum 6 usage) 2021: $4.95 usage charge + $0.00 fixed charge (minimum 6 usage) 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $45.85 $63.12 $59.40 Quarter 2 $71.05 $63.12 $59.40 Quarter 3 $90.65 $63.12 $59.40 Quarter 4 $54.25 $63.12 $59.40 Total $261.80 $252.48 $237.60 2019: Includes $18.36 stormwater fees 2020: Includes $18.36 stormwater fees + $5.75 street light fee 2021: Includes $18.36 stormwater fees + $5.75 street light fee 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $97.46 $118.83 $113.18 Quarter 2 $138.50 $136.20 $131.45 Quarter 3 $172.14 $151.63 $147.66 Quarter 4 $111.14 $124.62 $119.27 Total $519.24 $531.28 $511.56 2.3% -3.7% 1.5% Sewer Rates Total Proposed Utility Bill Water Rates Utility Bill Comparison 2019 - 2021 AVERAGE User) I:\Chris\RATE MODELS\Utility Rate Estimator 2020 v. 2021 Comparison 2019: usage charges + $6.50 fixed charge + $8.93 surcharge + $1.02 maintenance fee 2020: usage charges + $3.00 fixed charge + $8.97 surcharge + $1.15 maintenance fee 2021: usage charges + $0.00 fixed charge + $9.02 surcharge + $1.21 maintenance fee Usage (1000s) 2019 Actual 2020 Actual 2021 Proposed Q1 15 $38.53 $37.39 $35.76 Q2 40 $89.41 $93.32 $94.51 Q3 70 $179.31 $192.24 $198.35 Q4 25 $56.56 $57.17 $56.56 150 $363.81 $380.12 $385.18 2019: $2.80 usage charge + $12.25 fixed charge 2020: $4.76 usage charge + $6.00 fixed charge (uses Q1 usage for sewer calc) 2021: $4.95 usage charge + $0.00 fixed charge (uses Q1 usage for sewer calc) 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $54.25 $77.40 $74.25 Quarter 2 $124.25 $77.40 $74.25 Quarter 3 $208.25 $77.40 $74.25 Quarter 4 $82.25 $77.40 $74.25 Total $469.00 $309.60 $297.00 2019: Includes $18.36 stormwater fees 2020: Includes $18.36 stormwater fees + $5.75 street light fee 2021: Includes $18.36 stormwater fees + $5.75 street light fee 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $111.14 $138.90 $134.12 Quarter 2 $232.02 $194.83 $192.87 Quarter 3 $405.92 $293.75 $296.71 Quarter 4 $157.17 $158.68 $154.92 Total $906.25 $786.16 $778.62 13.3% -1.0% 14.1% Utility Bill Comparison 2019 - 2021 HIGH User) Water Rates Sewer Rates Total Proposed Utility Bill I:\Chris\RATE MODELS\Utility Rate Estimator 2020 v. 2021 Comparison 2019: usage charges + $6.50 fixed charge + $13.71 surcharge + $6.34 maintenance fee (1-inch meter) 2020: usage charges + $3.00 fixed charge + $13.77 surcharge + $6.37 maintenance fee (1-inch meter) 2021: usage charges + $0.00 fixed charge + $13.84 surcharge + $6.41 maintenance fee (1-inch meter) Usage (1000s) 2019 Actual 2020 Actual 2021 Proposed Q1 72 $143.91 $152.02 $155.61 Q2 90 $177.35 $188.74 $194.15 Q3 115 $228.35 $244.74 $252.90 Q4 80 $156.95 $166.34 $170.65 357 $706.56 $751.84 $773.31 2019: $2.80 usage charge + $12.50 fixed charge 2020: $4.76 usage charge + $6.00 fixed charge 2020: $4.95 usage charge + $0.00 fixed charge 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $213.85 $348.72 $356.40 Quarter 2 $264.25 $434.40 $445.50 Quarter 3 $334.25 $553.40 $569.25 Quarter 4 $236.25 $386.80 $396.00 Total $1,048.60 $1,723.32 $1,767.15 2019: Includes $85.04 stormwater fees (1 acre) + $11.50 street light fee 2020: Includes $85.04 stormwater fees (1 acre) + $11.50 street light fee 2021: Includes $85.04 stormwater fees (1 acre) + $11.50 street light fee 2019 Actual 2020 Actual 2021 Proposed Quarter 1 $442.80 $597.28 $608.55 Quarter 2 $526.64 $719.68 $736.19 Quarter 3 $647.64 $894.68 $918.69 Quarter 4 $478.24 $649.68 $663.19 Total $2,095.32 $2,861.32 $2,926.62 36.6% 2.3% 39.7% Utility Bill Comparison 2019 - 2021 Com / Ind / Inst AVG User) Water Rates Sewer Rates Total Proposed Utility Bill I:\Chris\RATE MODELS\Utility Rate Estimator 2020 v. 2021 Comparison Table 12021ProposedFund2020BudgetChangeBudget Water Utility$ 1,679,800.00$ 1,662,800.00-1.0% Sewer Utility$ 2,627,300.00$ 2,629,300.000.1% Storm Utility$ 1,322,700.00$ 1,433,400.008.4% Street Light Utility$ 220,000.00$ 220,000.000.0% TOTAL$ 5,849,800.00$ 5,945,500.001.6% EXECUTIVE SUMMARY Utility Commission Meeting: September 28, 2020 AGENDA SECTION: AGENDA ITEM: 2021 Utility Budgets New Business PREPARED BY: Brian Erickson, P.E. Director of Public AGENDA NO. 7.b. Works/City Engineer ATTACHMENTS: Proposed 2021 Utility Budgets APPROVED BY: BLE RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2021 Utility Budgets BACKGROUND Attached for the commission’sconsideration are the proposed 2021 budgets for water, sanitary sewer, and storm water. Public Works staff has worked to develop a proposed budget that meets the goals of the City Council while maintaining the expected service levels of the Quality Standards. Table 1 provides an overview ofthe changes to the three enterprise funds. The Water Utility budget is primarily flat for 2021. Funding was added to the Sewer Utility budget to begin a sanitary manhole maintenance program in 2019. This will bea multi-year project costing an estimated $450,000. The 2020 budget also includes 200,000 for communication upgrades and new electrical/control cabinets attwo lift stations. There was also a decrease in the proposed Metropolitan Council Environmental Services charges for 2021. The increase to the Storm Utility budget is primarily due to adding $140,000 for communication upgrades and new electrical/control cabinets at two lift stations as well as the stormwater pond maintenance program. A final staff review is scheduled for the end of September and may result in some additional changes to the budgets. These changes are anticipated to be relatively small and as aresult will likely not be returned to the Commission for review. Staff will be available at the meeting to answer any questions or concerns. SUMMARY Staff is requesting Utility Commission recommend the City Council approve the proposed 2021 Utility Budgets. C:\\Users\\jab\\AppData\\Local\\Temp\\7.b. 2021 Utility Budgets_614892\\7.b. 2021 Utility Budgets.docx Page One 2021 BUDGET WORKSHEETS WATER UTILITY REVENUES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 33130.00 Federal Grants - CDBG $75,280 $24,956 $0 $0 $0 MCES Water Efficiency Grant 601 33425.00 Other State Grants & Aids 6,762 33,455 720 4,500 4,500 ______________________________ 601 33620.00 Other County Grants & Aids 2,000 0 0 0 0 ______________________________ 601 34107.00 Assessment Fees 0 1,280 21,497 0 0 ______________________________ 601 34108.00 Administrative Fees-Other Funds 5,069 11,796 9,327 6,300 6,300 5% of 5% Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 18,050 15,984 17,261 0 0 ______________________________ 601 36101.00 Principal - Special Assessments 55,401 77,288 53,808 55,000 55,000 ______________________________ 601 36102.00 Penalties & Interest - S/A 627 655 719 0 0 ______________________________ 601 36210.00 Interest Earnings - Investments 92,126 149,982 177,969 90,000 90,000 ______________________________ 601 36214.00 Net Change in FV-Investments (3,227)(12,063)39,042 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 787 1,244 3,358 500 500 ______________________________ 601 36220.00 Rents & Royalties 148,434 154,610 161,211 168,500 168,500 Antenna Leases 601 36260.00 Other Revenues 0 117 0 0 0 ______________________________ 601 36265.00 Use of Reserve Funds 0 0 0 0 0 ______________________________ 601 37110.00 Residential Water Revenues 1,363,923 1,426,360 1,274,288 1,500,000 1,500,000 ______________________________ 601 37120.00 Apartment Water Revenues 108,265 113,851 121,359 120,000 120,000 ______________________________ 601 37125.00 Institutional Water Revenues 84,046 66,183 83,160 70,000 70,000 ______________________________ 601 37130.00 Commercial Water Revenues 90,872 94,093 95,413 100,000 100,000 ______________________________ 601 37140.00 Industrial Water Revenues 139,554 122,071 135,704 130,000 130,000 ______________________________ 601 37160.00 Penalties - Water Revenues 12,286 12,848 12,012 10,000 10,000 ______________________________ 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 ______________________________ 601 37170.00 Other Water Revenues 0 0 (29,682)0 0 2nd Meter Refunds 601 37180.00 Water Meter Sales Revenue 58,045 87,294 96,658 80,000 80,000 ______________________________ 601 39103.00 Gain or Loss from F/A Disposal (9,885)(426)0 0 0 ______________________________ 601 39203.00 Transfer From______________0 0 0 0 0 ______________________________ FUND TOTALS $2,248,416 $2,381,577 $2,273,824 $2,334,800 $2,334,800 Page One 2021 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $562,000 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 129,584 205,824 162,236 155,500 181,500 ______________________________ 601 49400 78 101.00 Technical/Clerical 146,843 155,870 169,268 177,900 192,000 ______________________________ 601 49400 79 101.00 Maintenance 171,054 180,248 183,174 230,600 188,500 ______________________________ 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 601 49400 102.00 Full-Time Overtime 10,140 13,549 16,444 8,000 8,000 ______________________________ 601 49400 103.00 Part-Time Salaries & Benefits 5,779 6,916 7,975 8,700 8,700 ______________________________ 601 49400 99 103.xx Utility Commission Wages (1/3)700 ______________________________ 601 49400 99 103.xx Maintenance Labor 8,000 Seasonal Employees and Interns 601 49400 01 203.00 Printed Forms & Paper 504 1,092 70 100 100 Outsource Bill Printing (313.00) 601 49400 01 205.00 Plotter Ink & Paper 0 0 0 400 400 ______________________________ 601 49400 01 209.00 Other Office Supplies 114 362 134 200 200 ______________________________ 601 49400 01 212.00 Motor Fuels 5,600 5,100 3,912 3,900 3,900 2.5% Covered by Water Utility 601 49400 01 216.00 Chemicals & Chemical Products 55,588 43,035 60,654 75,000 75,000 Chlorine/Flouride/Poly 601 49400 01 219.00 Other Operating Supplies 415 2,053 1,174 500 500 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 150,000 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 57,467 71,822 78,315 75,000 75,000 Match Rate Model (Incl. Recycling) 601 49400 01 220.02 For New Homes 42,572 47,296 52,209 75,000 75,000 Match Rate Model, Newland Dev. 601 49400 01 224.00 Street Maintenance Materials 329 1,261 4,769 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 323 360 108 1,000 1,000 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 0 222 105 0 0 ______________________________ 601 49400 01 229.00 Other Maintenance Supplies 17,000 ______________________________ 601 49400 01 229.01 Supplies for Hydrants 8,968 8,476 6,939 10,000 10,000 ______________________________ 601 49400 01 229.02 Curb Shutoffs 0 855 0 1,000 1,000 ______________________________ 601 49400 01 229.03 GV Repair/Replacement 934 0 13,526 2,000 2,000 ______________________________ 601 49400 01 229.04 Miscellaneous Supplies 3,247 3,350 685 4,000 4,000 ______________________________ 601 49400 01 240.00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc. 601 49400 01 241.00 Small Tools 1,099 2,140 1,782 2,500 2,500 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 11,622 8,371 6,052 17,000 17,000 2 MXU Readers in 2020 601 49400 01 303.00 Engineering Fees 26,000 ______________________________ 601 49400 01 303.01 WHPP 0 0 21,302 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 2,476 78 0 1,000 1,000 $5,000 Split 5 Ways 601 49400 01 303.03 Rate Study 0 14,459 19,172 5,000 5,000 ______________________________ 601 49400 01 303.04 Miscellaneous Fees 17,602 2,574 2,745 15,000 15,000 Future Water Facility Study 601 49400 01 304.00 Legal Fees 105 0 1,226 1,000 1,000 ______________________________ 601 49400 01 310.00 Testing Services 83,500 ______________________________ 601 49400 01 310.01 Bacteria & Water Quality 2,269 2,625 3,572 3,500 3,500 Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 45,928 47,381 49,186 80,000 80,000 53% Increase in Per Connection 601 49400 01 312.00 Gopher State One-Call 1,683 1,436 1,794 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 313.00 Outsource Bill Printing/Mailing 0 2,201 6,618 8,300 8,300 ______________________________ 601 49400 01 318.00 Contract Engineer 22,602 0 0 0 0 ______________________________ 601 49400 01 319.00 Other Professional Services 47,500 ______________________________ 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc.0 0 0 1,500 1,500 ______________________________ 601 49400 01 319.02 Supervisory Controls 3,435 0 2,053 5,000 5,000 ______________________________ 601 49400 01 319.03 Hazardous Chemical Permits 725 700 800 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 8,265 11,172 9,212 11,000 11,000 ______________________________ 601 49400 01 319.07 Antenna Expenses 3,577 9,209 3,842 20,000 20,000 Offset by Revenue 601-36220.00 601 49400 01 319.08 Buxton Project 0 9 0 0 0 ______________________________ 601 49400 01 319.09 HVAC Maintenance Contract 3,304 0 1,702 4,000 4,000 Annual Insp/Maint, All Wells 601 49400 01 319.10 Landscape Maintenance 0 0 2,655 4,000 4,000 ______________________________ 601 49400 01 319.11 Pest Control 0 0 539 1,000 1,000 ______________________________ 601 49400 01 320.00 Credit Card Activity Fees 6,299 7,767 9,409 8,500 8,500 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 3,230 4,734 4,134 5,000 5,000 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 3,767 2,920 369 400 400 Outsource Mailing (313.00) 601 49400 01 323.00 Radio Units 5,777 6,082 6,282 7,100 7,100 (24x$300)($28,000)(Split 5 Ways) 601 49400 01 352.00 General Notices & Public Info 0 0 36 0 0 ______________________________ 601 49400 01 365.00 Workers Comp Insurance 12,311 13,635 13,863 12,000 12,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,507 6,793 7,249 7,000 7,000 Water's Share of Premiums 601 49400 01 391.00 P.C. Maintenance 2,900 ______________________________ 601 49400 01 391.01 U/B Software Maintenance 2,177 2,159 2,372 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 631 650 650 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 108 0 33 200 200 ______________________________ 601 49400 01 393.00 P.C. Hardware Purchases 589 1,967 361 3,000 3,000 $1,100 Intern GPS ($3,300 Shared) 601 49400 01 394.00 P.C. Software Purchases 11,000 ______________________________ 601 49400 01 394.01 Licensing & Maintenance 10,129 8,954 9,715 10,500 10,500 ESRI, Cartegraph, DataLink 601 49400 01 394.02 Online Subscriptions 234 234 0 300 300 Pictometry 601 49400 01 394.03 New Software Purchases 46 0 983 200 200 ______________________________ PAGE TOTALS 815,958 905,941 951,406 1,077,200 1,075,200 Page Two 2021 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R & M - Other Impr 24,873 82,681 52,829 80,000 80,000 Main Breaks, Gate Valves, Etc. 601 49400 01 433.00 Dues & Subscriptions 0 327 250 500 500 Suburban Utility Supt Assn, MRWA 601 49400 01 435.00 Books & Pamphlets 0 0 0 200 200 Reference Materials 601 49400 01 437.00 Conferences & Seminars 6,500 ______________________________ 601 49400 01 437.01 MDH Training (Water School)2,173 1,026 2,066 3,000 3,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 1,899 0 2,000 2,000 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS 139 607 0 500 500 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 62 20 458 1,000 1,000 ______________________________ 601 49400 01 439.00 Other Miscellaneous Charges 15,328 12,674 11,878 20,000 20,000 DNR Annual Water Use 601 49400 01 450.00 Sales Tax on Purchases 0 0 0 0 0 ______________________________ 601 49400 01 521.00 Building & Structure Purchases 0 0 0 0 0 ______________________________ 601 49400 01 530.00 Improvements Other Than Bldgs 201,000 ______________________________ 601 49400 01 530.01 Well Inspections 0 800 0 1,000 1,000 ______________________________ 601 49400 01 530.02 Miscellaneous Improvements 75,280 81,548 13,156 50,000 50,000 Seal Wells 1 & 2 (2018) 601 49400 01 530.03 CRP of Watermain 0 0 0 50,000 50,000 PMP Water Imp. When Needed 601 49400 01 530.04 Inspection & Maintenance 85,845 12,835 601,050 100,000 100,000 From Long-Term Plan(Chip in 2019) 601 49400 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 Equipment Purchases - Match CIP 601 49400 01 548.00 Lease Program-P.W. Vehicles 0 16,984 6,740 0 0 ______________________________ 601 49400 01 550.00 Motor Vehicle Purchases 11,436 0 43,080 13,100 13,100 Vehicle Leases 601 49400 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 601 49400 01 580.00 Other Equipment Purchases 0 24,754 0 0 0 ______________________________ 601 49400 01 611.00 Interest on Lease Payments 930 476 824 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 0 0 57,500 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 1,032,023 1,142,571 1,741,235 1,399,000 1,397,000 601 49406 01 221.00 Equipment Parts 0 0 379 200 200 SCADA Upgrades 601 49406 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49406 01 319.00 Other Professional Services 5,585 0 0 1,000 1,000 ______________________________ 601 49406 01 381.00 Electric Utilities 1,573 409 1,846 1,300 1,300 Pumping & Lighting TOTAL - PRV 7,158 409 2,225 2,700 2,700 601 49407 01 221.00 Equipment Parts 2,120 3,664 196 1,500 1,500 ______________________________ 601 49407 01 223.00 Building Repair Supplies 32 0 0 200 200 ______________________________ 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 ______________________________ 601 49407 01 381.00 Electric Utilities 25,303 25,629 16,267 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 3,665 2,044 4,715 2,000 2,000 ______________________________ 601 49407 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 3,323 9,184 1,853 2,000 2,000 Standby Generator in 2019 TOTAL - WELL #7 34,654 40,733 23,241 39,100 39,100 601 49408 01 221.00 Equipment Parts 1,662 1,139 0 1,500 1,500 ______________________________ 601 49408 01 223.00 Building Repair Supplies 5 0 0 200 200 ______________________________ 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49408 01 381.00 Electric Utilities 19,484 21,238 19,796 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 397 469 365 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 324 6,959 2,005 2,000 2,000 ______________________________ 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL - WELL #8 21,872 29,804 22,166 29,400 29,400 601 49409 01 221.00 Equipment Parts 10 29 196 1,500 1,500 ______________________________ 601 49409 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49409 01 381.00 Electric Utilities 31,776 29,288 28,305 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 616 766 664 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 3,341 2,347 1,719 4,000 4,000 Paint Generator in 2020 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ______________________________ TOTAL - WELL #9 35,742 32,430 30,884 39,300 39,300 Page Three 2021 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 ______________________________ 601 49410 01 221.00 Equipment Parts 1,926 1,576 6,557 1,000 1,000 ______________________________ 601 49410 01 223.00 Building Repair Supplies 0 18 0 200 200 ______________________________ 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 ______________________________ 601 49410 01 381.00 Electric Utilities 19,551 15,985 14,345 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 67,275 24,817 403 2,000 2,000 ______________________________ 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ______________________________ TOTAL - WELL #10 89,517 43,162 22,069 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 0 0 0 0 ______________________________ 601 49411 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 ______________________________ TOTAL - WELL #11 0 0 0 0 0 Rural Water System (#2) 601 49412 01 221.00 Equipment Parts 27 0 434 1,500 1,500 ______________________________ 601 49412 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49412 01 381.00 Electric Utilities 26,035 28,566 24,403 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 18,163 478 8,680 2,000 2,000 ______________________________ 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL - WELL #12 44,225 29,044 33,516 31,800 31,800 601 49414 01 221.00 Equipment Parts 1,348 466 0 1,500 1,500 ______________________________ 601 49414 01 223.00 Building Repair Supplies 0 200 0 200 200 ______________________________ 601 49414 01 319.00 Other Professional Services 0 0 0 1,000 1,000 ______________________________ 601 49414 01 381.00 Electric Utilities 25,708 29,869 19,012 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 666 622 27,476 2,000 2,000 ______________________________ 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL - WELL #14 27,722 31,157 46,488 32,800 32,800 601 49425 01 221.00 Equipment Parts 0 564 559 1,500 1,500 ______________________________ 601 49425 01 223.00 Building Repair Supplies 0 200 28 200 200 ______________________________ 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49425 01 381.00 Electric Utilities 35,410 28,224 17,999 30,000 30,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 0 7,333 1,742 2,000 2,000 ______________________________ 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL - WELL #15 35,410 36,321 20,327 34,300 34,300 601 49426 01 221.00 Equipment Parts 0 726 260 1,500 1,500 ______________________________ 601 49426 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49426 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49426 01 381.00 Electric Utilities 0 5,368 22,821 28,000 28,000 Pumping & Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 0 0 ______________________________ 601 49426 01 409.00 Other Contracted Repairs & Maint 0 0 978 1,000 1,000 ______________________________ 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL - WELL #16 0 6,094 24,059 31,300 31,300 Page Four 2021 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 601 49415 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49415 01 409.00 Other Contracted Repairs & Maint 149 130 7,390 500 500 ______________________________ 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL - WATER TOWER #1 149 130 7,390 1,200 1,200 Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 0 114 10 500 500 ______________________________ 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49416 01 381.00 Electric Utilities 2,274 1,770 2,675 4,500 4,500 ______________________________ 601 49416 01 409.00 Other Contracted Repairs & Maint 303 0 4,884 500 500 ______________________________ 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL - WATER TOWER #2 2,577 1,884 7,569 5,700 5,700 Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 0 10 500 500 ______________________________ 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49417 01 381.00 Electric Utilities 2,999 2,822 1,881 6,000 6,000 ______________________________ 601 49417 01 409.00 Other Contracted Repairs & Maint 0 285 1,052 500 500 ______________________________ 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL - WATER TOWER #4 2,999 3,107 2,943 7,200 7,200 Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 103 164 0 500 500 ______________________________ 601 49418 01 319.00 Other Professional Services 2,800 0 0 0 0 ______________________________ 601 49418 01 381.00 Electric Utilities 2,496 1,989 1,867 4,000 4,000 ______________________________ 601 49418 01 409.00 Other Contracted Repairs & Maint 553 0 0 500 500 ______________________________ 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL - WATER TOWER #3 5,952 2,153 1,867 5,200 5,200 East Side Water Tower) GRAND TOTAL - ALL DEPTS.$1,340,000 $1,398,998 $1,985,978 $1,679,800 $1,677,800 Page One 2021 BUDGET WORKSHEETS SEWER UTILITY REVENUES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 602 33425.00 Other State Grants & Aids $0 $0 $712 $0 $0 ______________________________ 602 34108.00 Administrative Fees-Other Funds 5,069 11,796 9,327 6,300 6,300 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 75,330 75,927 74,262 80,000 75,000 ______________________________ 602 36102.00 Penalties & Interest - S/A 723 133 976 0 0 ______________________________ 602 36210.00 Interest Earnings - Investments 21,939 21,667 35,973 18,000 20,000 ______________________________ 602 36214.00 Net Change in FV-Investments (8,755) (2,081) 9,532 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 411 1,074 2,454 200 1,000 ______________________________ 602 36260.00 Other Revenues 0 58 0 0 0 ______________________________ 602 36265.00 Use of Reserve Funds 0 0 0 528,800 417,300 ______________________________ 602 37210.00 Residential Sewer Revenues 1,520,830 1,527,302 1,462,480 1,600,000 1,600,000 ______________________________ 602 37220.00 Apartment Sewer Revenues 134,668 145,502 185,515 150,000 190,000 ______________________________ 602 37225.00 Institutional Sewer Revenues 27,594 27,319 30,960 30,000 35,000 ______________________________ 602 37230.00 Commercial Sewer Revenues 76,385 86,942 104,954 90,000 110,000 ______________________________ 602 37240.00 Industrial Sewer Revenues 88,461 100,300 153,486 110,000 160,000 ______________________________ 602 37260.00 Penalties - Sewer Revenues 13,768 15,175 15,648 14,000 15,000 ______________________________ 602 39103.00 Gain or Loss from F/A Disposal (4,159) 0 0 0 0 ______________________________ 602 39203.00 Transfer From_______________0000 0______________________________ FUND TOTALS $1,952,265 $2,011,115 $2,086,280 $2,627,300 $2,629,600 Page One 2021 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $541,500 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 129,578 202,742 154,976 149,900 175,400 ______________________________ 602 49450 78 101.00 Technical/Clerical 146,843 155,870 169,268 177,900 198,800 Added P/T GIS Technician 602 49450 79 101.00 Maintenance 171,054 180,248 183,175 230,600 167,300 ______________________________ 602 49450 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 602 49450 102.00 Full-Time Overtime 10,140 13,549 16,444 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 7,346 7,803 8,479 8,700 8,700 ______________________________ 602 49450 99 103.xx Utility Commission Wages (1/3) 700 ______________________________ 602 49450 99 103.xx Maintenance Labor 8,000 Seasonal Employees and Interns 602 49450 01 203.00 Printed Forms & Paper 504 1,092 0 100 100 Outsource Bill Printing (313.00) 602 49450 01 205.00 Plotter Ink & Paper 0 0 0 400 400 ______________________________ 602 49450 01 209.00 Other Office Supplies 114 198 25 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 5,200 5,100 3,100 3,100 3,100 2% Covered by Sewer Utility 602 49450 01 216.00 Chemicals & Chemical Products 0 98 0 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 418 147 549 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 1,743 2,010 2,113 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 2,132 1,443 1,894 5,000 5,000 MH Castings Stock 602 49450 01 240.00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc. 602 49450 01 241.00 Small Tools 701 486 635 1,000 1,000 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,551 3,758 2,741 3,000 4,000 Locator in 2021 602 49450 01 303.00 Engineering Fees 6,000 ______________________________ 602 49450 01 303.01 GIS 2,476 78 0 1,000 1,000 $5,000 Split 5 Ways 602 49450 01 303.02 Rate Study 0 7,074 34,043 5,000 0 ______________________________ 602 49450 01 303.04 Miscellaneous 143 13,523 13,569 5,000 5,000 ______________________________ 602 49450 01 312.00 Gopher State One-Call 1,683 1,436 1,794 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 313.00 Outsource Bill Printing/Mailing 0 2,201 6,618 8,300 8,300 ______________________________ 602 49450 01 318.00 Contract Engineer 22,602 0 0 0 0 ______________________________ 602 49450 01 319.00 Other Professional Services 65,000 ______________________________ 602 49450 01 319.01 Televising 0 51,859 56,634 53,000 53,000 3-Year Citywide Televising Program 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 ______________________________ 602 49450 01 319.03 Supervisory Controls(Maint Cont) 0 0 818 5,000 5,000 SCADA System 602 49450 01 319.04 Lift Station Inspection 00003,500 Pump Inspection at All Lift Stations 602 49450 01 319.05 Landscape Maintenance 0 0 0 1,500 1,500 At Lift Stations 602 49450 01 320.00 Credit Card Activity Fees 6,064 7,767 9,409 8,500 9,500 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,085 3,540 3,819 5,000 5,000 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,002 2,881 310 400 400 Outsource Mailing (313.00) 602 49450 01 323.00 Radio Units 5,777 6,082 6,282 7,100 1,000 ______________________________ 602 49450 01 365.00 Workers Comp Insurance 12,175 13,482 13,717 12,000 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 13,858 12,322 11,006 17,000 17,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 2,900 ______________________________ 602 49450 01 391.01 U/B Software Maintenance 2,177 2,159 2,372 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 631 650 650 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C. Accessories & Supplies 0 0 0 200 200 ______________________________ 602 49450 01 393.00 P.C. Hardware Purchases 0 1,967 361 3,000 3,000 $1,100 Intern GPS ($3,300 shared) 602 49450 01 394.00 P.C. Software Purchases 11,000 ______________________________ 602 49450 01 394.01 Licensing & Maintenance 10,129 8,954 9,715 10,500 10,500 ESRI, Cartegraph, DataLink 602 49450 01 394.02 Online Subscriptions 234 234 0 300 300 Pictometry 602 49450 01 394.03 New Software Purchases 0 0 983 200 200 ______________________________ 602 49450 01 395.00 P.C. Repairs 0000 0______________________________ 602 49450 01 403.00 Contracted R & M - Other Impr 28,476 32,014 11,769 70,000 70,000 MH Castings Replacement Program 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 ______________________________ 602 49450 01 416.00 Machinery Rental 1,428 400 518 2,000 2,000 ______________________________ 602 49450 01 433.00 Dues & Subscriptions 0 49 127 300 300 SUSA Split w/603 602 49450 01 435.00 Books & Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences & Seminars 4,000 ______________________________ 602 49450 01 437.01 MPCA Training (Sewer School) 920 1,193 803 2,500 2,500 Operator Licensure $400 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS 131 607 0 500 500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 160 400 496 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 106 85 126 300 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0000 0FinalPayment in 2018 602 49450 01 530.00 Improvements Other Than Bldgs 450,000 ______________________________ 602 49450 01 530.01 Miscellaneous Improvements 0 0 7,695 200,000 300,000 SCADA, PCL's, 2 L/S Cabinets,Birge 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 PMP Sewer Imp. When Needed 602 49450 01 540.00 Heavy Machinery Purchases 0 0 4,538 0 0 Jetter (Split with 603) 602 49450 01 550.00 Motor Vehicle Purchases 11,436 0 43,090 4,700 4,700 Vehicle Leases 602 49450 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 ______________________________ 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 0 24,754 0 0 0 Portable Generator (Split 3 Ways) PAGE TOTALS 606,017 770,255 784,663 1,174,700 1,252,200 Page Two 2021 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 1,284,544 1,300,125 1,303,112 1,390,000 1,311,700 MWCC Chgs (Matches Rate Model) 602 49450 01 611.00 Interest on Lease Payments 930 476 0 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 0 65,000 0 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,891,491 2,135,856 2,087,775 2,564,700 2,563,900 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 3,200 Second Bubbler 602 49451 01 221.00 Equipment Parts 0 0 760 800 800 ______________________________ 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49451 01 303.00 Engineering Fees 0000 0______________________________ 602 49451 01 381.00 Electric Utilities (0) 1,500 2,750 3,000 3,000 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 53,524 0 0 2,000 2,000 ______________________________ 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 ______________________________ City Hall) TOTAL - LIFT STATION #1 53,524 1,500 3,510 6,200 9,300 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 2,024 0 3,361 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49452 01 381.00 Electric Utilities 508 540 417 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 0 412 471 2,000 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Bloomfield 5th) TOTAL - LIFT STATION #7 2,531 952 4,249 3,900 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 2,439 0 3,694 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 3,464 3,393 3,572 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 0 13,482 27,983 2,000 2,000 Safety Improvements in 2018 602 49453 01 439.00 Other Miscellaneous Charges 0 0 568 100 100 Contingencies Shannon Pond) TOTAL - LIFT STATION #3 5,903 16,874 35,817 7,200 7,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49454 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49454 01 381.00 Electric Utilities 5,632 5,583 5,612 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 0 0 142 2,000 2,000 ______________________________ 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Hawkins) TOTAL - LIFT STATION #4 5,632 5,583 5,754 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 376 2,611 0 800 800 ______________________________ 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49455 01 303.00 Engineering Fees 0000 0______________________________ 602 49455 01 310.00 Testing Services 0000 0______________________________ 602 49455 01 381.00 Electric Utilities 5,225 5,418 5,062 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 398 3,109 2,658 2,000 2,000 ______________________________ 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies LeForet Add'n) TOTAL - LIFT STATION #5 5,998 11,139 7,720 9,200 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49456 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49456 01 381.00 Electric Utilities 6,170 4,710 6,360 6,000 6,000 ______________________________ 602 49456 01 403.00 Contracted R & M - Other Impr 0 0 415 2,000 2,000 ______________________________ 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Drumcliffe) TOTAL - LIFT STATION #6 6,170 4,710 6,775 9,200 9,200 Page Three 2021 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 602 49457 01 219.00 Other Operating Supplies 0 3,170 0 100 100 Bubbler in 2018 602 49457 01 221.00 Equipment Parts 628 2,707 12 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 1,350 1,427 1,371 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 0 1,605 5,410 2,000 2,000 ______________________________ 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Glendalough 5th) TOTAL - LIFT STATION #9 1,979 8,909 6,793 4,100 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 1,395 0 0 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 460 461 421 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 1,414 0 0 2,000 2,000 ______________________________ 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Meadows of ) TOTAL - LIFT STATION #8 3,270 461 421 3,700 3,700 Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49460 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 266 325 339 400 400 ______________________________ 602 49460 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Glen Rose) TOTAL - LIFT STATION #10 266 325 339 3,300 3,300 602 49461 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49461 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49461 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49461 01 381.00 Electric Utilities 0 0 0 400 400 ______________________________ 602 49461 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49461 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Meadow Ridge-Temp) TOTAL - LIFT STATION #11 0 0 0 3,300 3,300 602 49462 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49462 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49462 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49462 01 381.00 Electric Utilities 0 0 0 400 400 ______________________________ 602 49462 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49462 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Bella Vista 6th-Temp) TOTAL - LIFT STATION #12 0 0 0 3,300 3,300 GRAND TOTAL - ALL DEPTS. $1,976,766 $2,186,309 $2,159,154 $2,627,300 $2,629,600 Page One 2021 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 603 33400.00 State Grants & Aids $0 $0 $596 $0 $0 ______________________________ 603 33425.00 Other State Grants & Aids 0000 0______________________________ 603 33620.00 Other County Grants & Aids 0 0 125 0 0 ______________________________ 603 34108.00 Administrative Fees-Other Funds 5,069 11,796 9,327 6,300 6,300 5% of 5% Fees-Const Projects 603-34115.00 Buffer Monumentation 0 0 1,800 3,000 3,000 ______________________________ 603 36101.00 Principal - Special Assessments 28,871 25,339 23,418 25,000 25,000 ______________________________ 603 36102.00 Penalties & Interest - S/A 155 157 366 0 0 ______________________________ 603 36210.00 Interest Earnings - Investments 46,134 77,293 126,227 35,000 35,000 ______________________________ 603 36214.00 Net Change in FV-Investments (3,777) (2,708) (2,944) 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 309 857 3,826 300 300 ______________________________ 603 36260.00 Other Revenues 0 29 0 0 0 ______________________________ 603 36262.00 Special Settlements 0000 0______________________________ 603 36265.00 Use of Reserve Funds 0000 0______________________________ 603 37300.00 Storm Water Utility Revenues 1,289,374 1,267,924 1,295,790 1,500,000 1,500,000 4% Annual Rate Incr. (Rate Model) 603 37360.00 Penalties - Storm Water Utility 10,471 11,627 6,272 7,000 7,000 ______________________________ 603 39103.00 Gain or Loss from F/A Disposal 0000 0______________________________ 603 39203.00 Transfer From______________ 0 0 492,427 0 0 ______________________________ FUND TOTALS $1,376,605 $1,392,314 $1,957,229 $1,576,600 $1,576,600 Page One 2021 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $518,300 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 21,966 77,299 153,628 136,400 174,900 ______________________________ 603 49500 78 101.00 Technical/Clerical 84,524 89,040 196,702 229,800 224,800 1 Additional Finance Position 603 49500 79 101.00 Maintenance 98,552 107,093 110,285 157,500 118,600 New Position for 2019 603 49500 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 603 49500 102.00 Full-Time Overtime 5,114 7,705 9,574 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 7,207 8,345 7,596 8,700 8,700 ______________________________ 603 49500 99 103.xx Utility Commission Wages (1/3) 700 ______________________________ 603 49500 99 103.xx Maintenance Labor 8,000 Seasonal Employees and Interns 603 49500 01 203.00 Printed Forms & Paper 504 1,092 0 100 100 Outsource Bill Printint (313.00) 603 49500 01 205.00 Plotter Ink & Paper 0 0 0 400 400 ______________________________ 603 49500 01 208.00 Miscellaneous Supplies 350 86 0 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 6,200 6,000 4,700 4,700 4,700 3% Covered by Storm Utility 603 49500 01 224.00 Street Maintenance Materials 2,140 5,241 1,775 3,000 3,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 4,000 ______________________________ 603 49500 01 225.01 Rip-Rap, Matting, Rock, etc. 1,553 973 765 3,000 3,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc. 900 945 240 1,000 1,000 ______________________________ 603 49500 01 226.00 Sign Repair Materials 257 160 4,443 3,000 3,000 Wetland Buffer Signs 603 49500 01 230.00 Repair Materials & Supplies 1,359 1,418 1,368 3,000 3,000 Culverts, Catch Basins, Structures 603 49500 01 240.00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc. 603 49500 01 241.00 Small Tools 176 1,211 923 1,500 1,500 ______________________________ 603 49500 01 242.00 Minor Equipment 2,238 1,286 2,972 7,500 7,500 2 Hose Docks in 2020 603 49500 01 303.00 Engineering Fees 23,000 ______________________________ 603 49500 01 303.01 Problem Area Investigations 0 0 0 5,000 5,000 ______________________________ 603 49500 01 303.02 NPDES Phase II 7,377 8,202 14,197 5,000 5,000 ______________________________ 603 49500 01 303.03 CSMP Update 0 69,832 12,965 2,000 2,000 ______________________________ 603 49500 01 303.04 Miscellaneous 10,921 34,730 45,435 10,000 10,000 ______________________________ 603 49500 01 303.05 GIS 1,651 52 0 1,000 1,000 $5,000 Split 5 Ways 603 49500 01 304.00 Legal Fees 0 1,886 34 2,000 2,000 ______________________________ 603 49500 01 310.00 Testing Services 0000 0WaterQuality Tests (M) 603 49500 01 312.00 Gopher State One-Call 1,684 1,436 1,794 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 313.00 Outsource Bill Printing/Mailing 0 2,201 6,618 8,300 8,300 ______________________________ 603 49500 01 315.00 Special Programs 5,867 6,437 4,500 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 26,927 0 0 0 0 ______________________________ 603 49500 01 319.00 Other Professional Services 6,500 ______________________________ 603 49500 01 319.01 SCADA 0 0 4,223 5,000 5,000 ______________________________ 603 49500 01 319.03 Landscape Maintenance 0 0 0 1,500 1,500 At Lift Stations At Lift Stations 603 49500 01 320.00 Credit Card Activity Fees 6,064 7,767 9,409 8,500 8,500 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 3,086 3,541 4,266 5,000 5,000 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,002 2,853 310 400 400 Outsource Mailing (313.00) 603 49500 01 323.00 Radio Units 5,777 6,082 6,282 7,100 7,100 (24x$300) ($28,000) (Split 5 Ways) 603 49500 01 352.00 General Notices & Public Info 35 0 0 1,000 1,000 ______________________________ 603 49500 01 365.00 Workers Comp Insurance 6,287 7,647 10,255 6,000 6,000 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,734 1,746 1,814 2,500 2,500 Storm Water's Share of Premiums 603 49500 01 391.00 P.C. Maintenance 2,900 ______________________________ 603 49500 01 391.01 U/B Software Maintenance 2,177 2,159 2,372 2,200 2,200 ______________________________ 603 49500 01 391.02 Auto Read Software Support 631 650 650 700 700 ______________________________ 603 49500 01 393.00 P.C. Hardware Purchases 0 1,967 361 3,000 3,000 $1,100 Intern GPS ($3,300 shared) 603 49500 01 394.00 P.C. Software Purchases 11,000 ______________________________ 603 49500 01 394.01 Licensing & Maintenance 10,119 8,954 9,714 10,500 10,500 ESRI, Cartegraph, DataLink 603 49500 01 394.02 Online Subscriptions 234 234 0 300 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 983 200 200 ______________________________ 603 49500 01 403.00 Contracted R & M - Other Impr 130,000 ______________________________ 603 49500 01 403.01 Ditching 12,609 1,008 0 10,000 10,000 ______________________________ 603 49500 01 403.02 Catch Basins, Manholes, Etc. 111,199 43,322 93,304 120,000 120,000 ______________________________ 603 49500 01 403.03 Pond Inspection & Maintenance 00000 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 110,000 ______________________________ 603 49500 01 405.01 Engineering Fees 38,365 31,594 43,408 45,000 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 7,149 0 72,789 20,000 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc. 786 0 607 5,000 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 3,973 3,030 59,671 40,000 40,000 Brush Clearing, Dredging 603 49500 01 416.00 Machinery Rental 2,416 0 0 2,500 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 280 49 994 1,500 1,500 SUSA Split w/602, MN SW Coalition 603 49500 01 435.00 Books & Pamphlets 0 0 81 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,700 ______________________________ 603 49500 01 437.01 Storm Water Management 0 0 737 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.04 Cartegraph, ESRI, GIS 131 607 0 500 500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 0 430 583 2,000 2,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 106 360 421 300 300 ______________________________ PAGE TOTALS 504,625 556,668 903,747 909,800 904,400 Page Two 2021 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 530.00 Improvements Other Than Bldgs 200,000 ______________________________ 603 49500 01 530.01 CRP of Storm Sewer 3,704 0 0 60,000 60,000 ______________________________ 603 49500 01 530.02 Stormwater System Improvements 0 0 0 140,000 140,000 ______________________________ 603 49500 01 540.00 Heavy Machinery Purchases 99,350 31,714 4,538 170,500 170,500 Side Flail Mower, Sweeper 603 49500 01 550.00 Motor Vehicle Purchases 20,226 0 43,070 4,700 4,700 Vehicle Leases 603 49500 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 ______________________________ 603 49500 01 580.00 Other Equipment Purchases 0 24,754 0 12,000 12,000 Hose Trailer in 2020 603 49500 01 586.00 Computer Equipment Purchases 0 81 0 500 500 ______________________________ 603 49500 01 710.00 Transfers 0 ______________________________ 603 49500 01 710.06 1/2 of 2018 P & I Payments(2010A) 32,000 0 0 0 0 Final Payment 2/1/18 603 49500 01 710.10 Projects 381,317 43,887 296,254 0 0 ______________________________ 603-49500-01 TOTALS 1,041,222 657,105 1,247,609 1,298,000 1,292,600 603 49511 01 221.00 Equipment Parts 477 0 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 252 270 312 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 202 0 1,197 1,000 1,000 ______________________________ Copper Pond) TOTAL - LIFT STATION #1 931 270 1,508 2,000 2,000 603 49512 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49512 01 403.00 Contracted Repair & Maintenance 0 1,868 140 1,000 1,000 ______________________________ Schwarz Pond) TOTAL - LIFT STATION #2 0 1,868 140 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 49 9 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 5,786 6,577 8,784 7,200 7,200 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 0 1,477 1,000 1,000 ______________________________ Birger Pond) TOTAL - LIFT STATION #3 5,786 6,626 10,269 8,700 8,700 603 49514 01 221.00 Equipment Parts 0 65 0 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 1,542 1,178 2,008 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 0 488 817 1,000 1,000 ______________________________ Marcotte Pond) TOTAL - LIFT STATION #4 1,542 1,731 2,824 4,000 4,000 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49515 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ Hawkins Pond) TOTAL - LIFT STATION #5 0 0 0 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 144 500 500 ______________________________ 603 49516 01 381.00 Electric Utilities 511 416 468 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 0 0 507 1,000 1,000 ______________________________ Glendalough 7th) TOTAL - LIFT STATION #6 511 416 1,119 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49517 01 381.00 Electric Utilities 753 551 992 500 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 0 160 1,000 1,000 ______________________________ Horseshoe Lake) TOTAL - LIFT STATION #7 753 551 1,152 2,000 2,000 603 49518 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49518 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49518 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ Dunmore) TOTAL - LIFT STATION #8 0 0 0 2,000 2,000 GRAND TOTAL - ALL DEPTS. $1,050,746 $668,566 $1,264,622 $1,322,700 $1,317,300 Page One 2021 BUDGET WORKSHEETS STREET LIGHT UTILITY REVENUES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 608-31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 608-31020.00 Tax Increments 0 0 0 0 0 __________________________ 608-34306.00 Other Highway & Street Revenue 0 0 0 0 0 __________________________ 608-36101.00 State Grants & Aids 0 0 0 0 0 __________________________ 608-36102.00 Other State Grants & Aids 0 0 0 0 0 __________________________ 608-36210.00 Interest Earnings - Investments 0 0 0 0 0 __________________________ 608-36215.00 Interest Earnings 0 0 0 0 0 __________________________ 608-36220.00 Rents & Royalties 0 0 0 0 0 __________________________ 608-36260.00 Other Revenue 0 0 0 0 0 __________________________ 608-36265.00 Use of Reserve Funds 0 0 0 0 0 __________________________ 608-36270.00 Capital Contributions 0 0 0 0 0 __________________________ 608-37400.00 Street Light Revenues 0 0 0 220,000 220,000 __________________________ 608-37460.00 Penalties - Street Light Revenues 0 0 0 0 0 __________________________ 608-37470.00 Other Street Light Revenues 0 0 0 0 0 __________________________ 608-39201.00 Transfer from General Fund 0 0 0 0 0 __________________________ 608-39202.00 Contribution from Enterprises 0 0 0 0 0 __________________________ 608-39203.00 Transfer from________________ 0 0 0 0 0 __________________________ FUND TOTALS $0 $0 $0 $220,000 $220,000 EXPENDITURES - 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 608 49508 01 219.00 Other Operating Supplies $0 $0 $0 $0 $0 __________________________ 608 49508 01 221.00 Equipment Parts 0 0 0 0 0 __________________________ 608 49508 01 304.00 Legal Fees 0 0 0 0 0 __________________________ 608 49508 01 317.00 General Fund Admin Fees 0 0 0 0 0 __________________________ 608 49508 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 608 49508 01 352.00 General Notices & Public Info 0 0 0 0 0 __________________________ 608 49508 01 381.00 Electric Utilities 0 0 0 185,000 185,000 __________________________ 608 49508 01 409.00 Other Contracted Repair & Maint. 0 0 0 15,000 15,000 __________________________ 608 49508 01 421.00 Depreciation Expense 0 0 0 0 0 __________________________ 608 49508 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 __________________________ 608 49508 01 530.00 Improvements Other Than Buildings 0 0 0 20,000 20,000 __________________________ 608 49508 01 710.00 Transfers 0 0 0 0 0 __________________________ 608 49508 01 720.00 Transfers 0 0 0 0 0 __________________________ FUND TOTALS $0 $0 $0 $220,000 $220,000 EXECUTIVE SUMMARY Utility Commission Meeting: September 28, 2020 AGENDA SECTION: AGENDA ITEM: City Project Update Executive Director’s Report PREPARED BY: Brian Erickson, P.E. Director of Public Works AGENDA NO. 8.a. City Engineer ATTACHMENTS: None APPROVED BY: BLE RECOMMENDED ACTION: None, informational only BACKGROUND The 2020 construction season is beginning to wrap up for the season and this year has seen a significant amount ofconstruction throughout the city. The following list is the current and planned City of Rosemount projects. There are additional developments that are in early stages ofthe process and those will be added as appropriate. Changes since the last report are shown as strike out for deletions and underlined for additions as well as a bar along the left margin to indicate the changes. 132ndStreetImprovements – Scope includes construction of utilities and paving between MN Hwy 3 and Dodd Boulevard. Wear course has been completed and this project isinto the close out phase. This will be the last report on this project.will be installed in 2020 with exact dates tobe established. Addition of a small retaining wall near an existing power pole is complete. 145thStreetSidewalkImprovements – Scope includes constructing sidewalk and thpedestrianrampsalongthenorthsideof145 Street to the east of Brazil Ave. The final sections of sidewalk have been completed and this area is open for pedestrian traffic. Some restoration work remains.There is a portion of sidewalk across the Union Pacific Railroad that has not been done as the crossing material was removed for rail maintenance. Union Pacific has finally completed this work. 2019StreetImprovement Project – Scope includes mill and overlay of Connemara Trail between Diamond Path and Shannon Parkway and restriping toa three-lane section with some minor storm sewer improvements. Work started on May 14, 2020. Work is nearly complete with boulevard restoration as the primary remaining item. The scope includes mill and overlay or reclamation of: Chippendale Avenue from 145th Street W to 160th Street W Dodd Boulevard from Shannon Parkway to Chippendale Avenue 151st Street W from Shannon Parkway to Chippendale Avenue Crestone Ave, Claret Ave and Cimarron Ave from CSAH 42 to 151st Street W 2021StreetImprovement Project – Scope includes mill and overlay or reclaim of: C:\\Users\\jab\\AppData\\Local\\Temp\\8.a. Project Update_614898\\8.a. Project Update.docxG:\\MEETINGS\\UTILITY COMMISSION\\UC Items and Packets\\2020\\20200928\\8.a. Project Update.docx Covington Avenue Colorado Avenue thUpper149 Street W from Crandall Avenue to Colorado Avenue Darling Path from Danbury Avenue to the southern curve th156 Street W from Darling Path toShannon Parkway thUpper156 Street W from Darling Path to Danville Avenue th156 Court W. Dapple Court Dapple Circle th157 Court W. th157 Street W. ththDanvilleAvenuefrom156StreetW.to 156 Court W. Cumberland Avenue Crocus Avenue Crocus Court Crystal Path from Danville Avenue to Shannon Parkway Crystal Court Initial planning is underway and aneighborhood meeting isscheduled for October 8. Construction isplanned for 2021. AdalynAvenue – Scope includes construction ofutilities and paving between Addison Avenue and Connemara Trail. Wear course installed and project is inthe close out phase. This will be the last report on this project. will be installed in 2020 with exact dates to be established. stAddisonAve – Scope includes construction ofutilities and paving between 141 Street East and a temporary cul-de-sac to the east. Project was completed except for wear course in 2018 and because of additional 2019 construction in the area, the removal of the cul-de-sac and road extension to the east this summer. Final wear installed and project is in the close out phase. This will be the last report on this project.course will be done in 2020 with exact dates to be established. Autumn Path – Scope includes construction of utilities and paving from Bonaire Path north approximately 2,500 feet. Construction is planned to restart in August October with utility installation complete this year. Road paving will be completed in 2021 due; thhowever, there will be gravel to allow access to the Bella Vista 7 subdivision. substantial completion this year. Start date was delayed due to a delay in sanitary sewer permitting as well as a recent retaining wall easement problem. Biscayne Ave – Scope includes construction of utilities and paving between Boulder thTrailand160 Street (CSAH 46). Extension of sanitary sewer will provide service to the Biscayne Business Park on the southern end of the project. This project is currently nearly completed for the season. Final grading and work on stormwater features remains and will be completed prior to winter. Final bituminous wear course will be done in2021. No truck traffic will be allowed until the final bituminous course is place. Bonaire Path – Scope includes construction of utilities and paving between Akron Avenue and Anderson Drive. Additionally, the installation of crossing arms at the 2 Union Pacific Railroad intersection are in the scope of the project and planned for 2020. Ultimately, the city will request that this intersection become a quiet zone (i.e. no train horns). Wear course and construction is anticipated to be completed in 2021; however, that will hinge on Union Pacific completing the necessary crossing work. Final design for rail improvements was approved by City Council at the February 4 meeting. The next step in this process requires that Union Pacific complete an agreement document so that all costs are documented and then the work can be put forward for scheduling. Staff received notice that a draft agreement isin process; however, because of the lengthy delay by UP the cost estimates expired and are being updated. Once the agreement is received staff will bring to Council for approval. Actual construction work by UP remains unscheduled atthis time. Because ofthe significant delays by Union Pacific no work is anticipated in 2020. Additional communication with both MnDOT and other Union Pacific staff is being done as well. Staff has been in contact with the Federal Railroad Administration regarding application for a quiet zone (QZ). Because of the design, the QZ application is expected to be approved. Connemara TrailExtension – Scope includes construction of utilities and paving from Akron Avenue east approximately 1,300 feet. Contract was awarded and work is being planned for 2021 due to the significant workload. Some additional work is being coordinated with the parcel to the east toassist with future development. Deepwoods Court – Scope includes pavement reclamation and minor curb repair from McAndrews Road south approximately 1,900 feet. Paving of base course was completed on August 19. Final wear course is completed and restoration is under way.schedule is being coordinated. This project will be completed in 2020. Ribbon curb will be installed and the residents have agree to pay for the additional cost. Dunmore StormLiftStation – Scope includes the construction of a stormwater lift station inthe Dunmore subdivision and connection to existing force main. Construction is completed. Initial startup and control programming has been performed. Restoration is underway. Shannon PondOutletFeasibility Study – Scope includes reviewing potential routes for stormwater outlet at Shannon Pond. Because of the land locked location outlet will be a significant undertaking. Initial study work is anticipated in February 2020was received this summer. Information from this study will be used toestablish future improvements necessary to reduce the potential for structure flooding. Staff plans a future presentation to the Utility Commission regarding this work. Thefollowing lististhecurrent andplanned developer projects. BellaVista6 – Scope includes construction of utilities and paving from Aulden Avenue to the cul-de-sac approximately 850’ north east as well as 19 single family residential (SFR) lots of a planned total 158. In addition, there isa temporary sanitary sewer lift station that will be installed until trunk sewer is extended at a future date. Utilities and base course are in place and the lift station construction is complete with minor punch list items tobe corrected. Wear course is planned for 2020 with exact dates to be established. 3 BellaVista7 – Scope will include construction of utilities and paving from a temporary connection to the Autumn Path extension (see above) west approximately 1500 feet as well as 26 SFR lots of a planned total 158. This is the final phase of this development. Construction ofutilities is complete and the developer is working on roadway construction. Actual construction cannot occur until Autumn Path is construction to allow access as this portion of Bella Vista is currently ‘land locked’. With the award of Autumn Path, work has started on this project. Biscayne Business Park – Scope includes construction of utilities and paving from Biscayne Avenue to the cul-de-sac approximately 750’ west as well as 8 commercial lots. Temporary Metropolitan Council Environmental Services connect has been removed. One building is under construction. Paving will be done in 2020. Caramore Crossing – Scope includes construction of utilities and paving from Akron Avenue and from Bonaire Path as well as 82 SFR lots of a planned total 177. This project is in the initial construction stage. Developer has installed utilities from Akron and is currently working on site grading.Currently, the developer is preparing toinstall a deep sanitary sewer manhole in the Akron right of way. This work is being expedited so that itwill minimize the impact to the paving of Akron by Dakota County. Dunmore 2 – Scope includes construction of utilities and paving from Caffery Court as well as 25 SFR lots of a planned total 87. Wear course will be installed in 2020 with exact dates to be established. Contractor will be required to make repairs to the stormwater ponds due to poor dewatering practices. Greystone 7 – Scope includes construction of utilities and paving as well as 46 SFR lots of aplanned total 287. Wear course is installed and project isin the close out phase. This will be the last report on this project.will be installed in 2020 with exact dates to be established. Greystone 8 – Scope includes construction of utilities and paving as well as 56 SFR lots of aplanned total 287. This is the final phase of this development. Wear course will be installed in 2020 with exact dates to be established. ndHarmonyParkview2 – Scope includes construction of utilities and paving as well as 26 townhomes. Utilities will be city owned and the streets are private. This project will also fill temporary stormwater ponding on the east side of MN Hwy 3. Filling of the temporary ponding is nearly complete. Utility construction has been completed and townhome construction is underway.begun. Harmony Villas2 – Scope includes construction of utilities and paving as well as 26 townhomes. Utilities are city owned and the streets are private. Utility construction is complete. Site corrections and building construction is underway. ndMeadowRidge2 – Scope includes construction of utilities and paving as well as 29 SFR lots of a planned total 154. Wear course is installed and project is in the close out phase. This will be the last report on this project.will be installed in 2020 with exact dates to be established. 4 rdMeadowRidge3 – Scope includes construction of utilities, paving and a temporary sanitary sewer lift station as well as 28 SFR lots of a planned total 154. This project is nearly complete for the season. Lift station will be coming on line before home construction can be started.planned for 2020 construction. Morrison (Downtown redevelopment) – Scope includes redevelopment of the area west of TH 3 in proximity to Shenanigans. Mixed commercial and apartments are planned for this area. Utility connections and minor corrections being performed.Demolition ofShenanigans and the mall are complete. Foundation work is underway. Utility connections have been made. Prestwick 17 – Scope includes construction of utilities and paving, including the completion of Addison Avenue to a temporary dead end to the east as well as 26 townhomes. Utilities will be city owned and the streets are private. Wear course will be installed in 2020 with exact dates tobe established. Prestwick 18 – Scope includes construction of utilities and paving as well as 40 townhomes. Utilities will be city owned and the streets are private. Utilities have been installed. Wear course will be installed in 2020 with exact dates to be established. Prestwick 19 – Scope includes construction of utilities and paving as well as 35 SFR lots. Wear course is installed and project is in the close out phase. This will be the last report on this project. will be installed in 2020 with exact dates to be established. Prestwick 20 – Scope includes construction of utilities and paving as well as 27 SFR lots. This is the final phase ofthis development on the west side ofAkron Avenue. Construction is underway and planned for completion this year, with wear course planned for 2021. Prestwick 21 – Scope includes construction of utilities and paving as well as 24 townhomes. Utilities will be city owned and the streets are private. Construction is underway and planned for completion this year. Prestwick 22 – Scope includes construction of utilities and paving as well as 64 townhomes. Utilities will be city owned and the streets are private. Construction is underway and planned for completion this year. Rosemount Woods Expansion – Scope includes construction of39 additional manufactured home sites as well as construction of private utility extensions for those sites. This project is currently under construction. Preparation for improving the northern section of Brazil Avenue is underway.in the initial stages of construction. Wexford Place – Scope includes redevelopment ofa multifamily residence at the intersection of Chippendale Ave and CSAH 46 with an apartment building. Project is currently under construction with a planned completion in 2020. This will be the last report on this project. Thefollowing isthelistofDakota County andMnDOT projects. CR73 (Akron Ave) – Scope includes the reconstruction of Akron Avenue from 5 Bonaire Path to the Rosemount city limit. It also includes the construction of a trail under pass near Flint Hills Soccer Complex. Finally, itincludes pavement thstrehabilitationfor124Courtand121 Street. The southern end ofAkron Avenue thbetweenBiscayneand127 St has been paved. Work has now shifted to the northern end of the project.Work is currently underway with the southern section being closed stthtotraffic. Final paving on 121 Street and 124 Court was completed. Due to construction access tothis area will start to transition to the south. Greenway trail underpass is nearing completion. Roundabout Connemara Trail/DiamondPath – Scope preliminary engineering for the construction of a roundabout at this intersection. This project is planned for construction in2022. Preliminary design work continuesnearing completion. CSAH42/CR73 (AkronAve) Signal – Scope calls for installation of a traffic signal at the intersection of CSAH 42 and CR 73 (Akron Ave) to address the increase in traffic at this intersection. This project is planned for construction in 2021. Final design work is nearly complete and Dakota County intends to bid this project by the end of 2020. Design will include an extension of water main south to service possible future development.Preliminary design work is in process along with right of way determinations. City ofRosemount, Dakota County, Dakota County Technical College and the University of Minnesota continue to work in partnership to complete this project. A proposal to extend the water main has been approved. CSAH42Visioning Study – This is a study that will look at nearly the entire length of CSAS 42 starting at the western county line (Burnsville) and ending at MN Trunk Highway 52. Future open houses and public engagement opportunities will be promulgated as they are established. At this time most public engagement will be via on-line comments and updates. CSAH46CorridorStudy andPreliminary Engineering – This is a study that will look at the section of CSAH 46 from Minnesota Trunk Highway 3 to CSAH 48 in Coates. The scope of work anticipated is right of way acquisition to support expanding the highway toa divided four-lane. This isa high priority project for Dakota County and since a portion of this is within Rosemount city limits a portion of the cost would be carried by the city. This study will assist with quantifying those costs. Initial survey work is underway. TH55SafetyImprovements – Scope includes improvements along Minnesota Trunk Highway 55 (TH 55) by adding a left turn lane to Doyle Path. The Toward Zero Deaths TZD) program is leading aworking group for this project. 6 2019 Well 7 Well 8 Well 9 Well 12 Well 14 Well 15 Well 16 Rural 1 Rural 2 2020 Total 2019 Total % Change 2019 2020 DiffJan 8,700 10,600 12,148,300 17,982,600 5,906,400 13,400 19,000 2,470,200 2,817,100 41,376,300 47,443,500 -12.8% 0.45 0.97 0.52Feb 0 6,263,900 1,123,500 2,228,500 18,490,900 298,100 8,132,000 2,280,600 2,308,100 41,125,600 43,128,500 -4.6% 2.57 0.58 -1.99Mar 0 2,238,400 11,390,400 0 11,448,200 3,176,800 8,894,000 2,384,800 2,716,000 42,248,600 37,209,200 13.5% 2.00 2.41 0.41Q1 Total 8,700 8,512,900 24,662,200 20,211,100 35,845,500 3,488,300 17,045,000 7,135,600 7,841,200 124,750,500 127,781,200-2.4%5.02 3.96-1.06Apr 0 24,815,900 0 21,800 0 22,004,400 0 2,692,000 2,919,90052,454,00047,245,000 11.0% 3.91 1.80 -2.11May05,037,000 31,405,400 0 32,666,200 3,694,100 1,261,000 2,369,200 2,633,10079,066,00062,650,200 26.2% 6.68 4.85 -1.83Jun0 8,176,300 2,077,700 49,034,100 2,453,400 39,669,200 14,054,000 2,020,900 2,556,700 120,042,30096,501,900 24.4% 2.72 6.72 4.00Q2 Total 0 38,029,200 33,483,100 49,055,900 35,119,600 65,367,700 15,315,000 7,082,100 8,109,700 251,562,300 206,397,10021.9%13.31 13.370.06Jul12,500 11,846,700 25,731,000 27,445,400 36,012,100 24,489,000 13,224,000 2,169,900 2,211,600 143,142,200111,123,700 28.8% 6.48 3.19 -3.29Aug4,900 5,257,300 6,324,700 39,268,200 28,077,100 36,361,300 21,880,0002,304,100 2,273,600 141,751,200118,502,700 19.6% 6.28 3.98 -2.30Sep089,200,600 -100.0% 3.92 -3.92Q3 Total 17,400 17,104,000 32,055,700 66,713,600 64,089,200 60,850,300 35,104,000 4,474,000 4,485,200 284,893,400 318,827,000-10.6%16.68 7.17-9.51Oct042,647,000 -100.0% 4.05 -4.05Nov038,993,100 -100.0% 2.28 -2.28Dec045,152,900 -100.0% 1.83 -1.83Q4 Total 0 0 0 000000 0126,793,000-100.0%8.16 0.00-8.16Total 26,100 63,646,100 90,201,000 135,980,600 135,054,300 129,706,300 67,464,000 18,691,700 20,436,100 661,206,200 779,798,300-15.2%43.17 24.50-18.67Average/Mo3,263 7,955,763 11,275,125 16,997,575 16,881,788 16,213,288 8,433,0002,336,463 2,554,513 82,650,775 64,983,192 27.2%Average/Day842 2,053,100 2,909,710 4,386,471 4,356,590 4,184,074 2,176,258 602,958 659,229 21,329,232 2,136,434 898.4%661,206,200 563,804,700 17.3% 43.17 24.50 -18.672020 Well Pumping RecordYear To-Date EXECUTIVE SUMMARY Utility Commission Meeting: September 28, 2020 AGENDA SECTION: AGENDA ITEM: Action Items / Issues List Executive Director’s Report PREPARED BY: Brian Erickson, P.E. Director of Public Works AGENDA NO. 8.c. City Engineer ATTACHMENTS: None APPROVED BY: BLE RECOMMENDED ACTION: None, informational only BACKGROUND Utility Commissioners requested that staff provide updates on the following items for meetings going forward. METCouncil WellAssessment SmartMeterUpdate TourofaWaterTower FiveYearPondMaintenance Plan Water/Stormwater Rebate Update (quarterly) See item 6.a. C:\\Users\\jab\\AppData\\Local\\Temp\\8.c. Action Items & Issues List_614899\\8.c. Action Items & Issues List.docx