HomeMy WebLinkAbout7.b. Review 2020 Water RevenueG:\MEETINGS\UTILITY COMMISSION\UC Items and Packets\2021\20210222\7.b. Review 2020 Water Revenue.docx
E X E C U T I V E S U M M A R Y
Utility Commission Meeting: February 22, 2021
AGENDA ITEM: Review 2020 Water Revenue AGENDA SECTION:
New Business
PREPARED BY: Brian Erickson, P.E. Director of Public Works
/ City Engineer AGENDA NO. 7.b.
ATTACHMENTS: 2018 - 2020 Month End Water Revenue
Reports APPROVED BY: BLE
RECOMMENDED ACTION: None, informational only
BACKGROUND
At the January 25, 2021 Utility Commission meeting, the commissioners requested an update
on water revenues for calendar year 2020. Due to the large residential portion of
Rosemount, remote learning for schools and closures of businesses due to the COVID -19
pandemic did result in an increase in water usage in Rosemount.
Annually, the City of Rosemount projects revenues and estimates expenses for the utility
funds. Since these projections are generally based on previous usage with a growth facto r,
any unanticipated change may result in an increase or decrease in the actual revenue. The
following table shows budgeted and actual revenues from month end reporting for 2018 –
2020 for the primary usage categories. There are other revenue categories ; however, those
categories contribute significantly less to the overall fund revenue.
As shown in this table, the difference between budgeted and actual revenues are
approximately equal over the three years shown. Calendar year 2019 was a record setting
year for rain so that likely had an effect on the residential usage.
Residential Apartment Institutional Commercial Industrial Total
Budgeted 1,500,000.00$ 120,000.00$ 70,000.00$ 100,000.00$ 130,000.00$ 1,920,000.00$
Actual 1,598,965.78$ 128,711.31$ 75,527.45$ 103,898.58$ 143,752.75$ 2,050,855.87$
Difference 98,965.78$ 8,711.31$ 5,527.45$ 3,898.58$ 13,752.75$ 130,855.87$
Budgeted 1,400,000.00$ 105,000.00$ 80,000.00$ 85,000.00$ 140,000.00$ 1,810,000.00$
Actual 1,187,190.56$ 121,359.17$ 83,160.28$ 95,413.24$ 135,703.82$ 1,622,827.07$
Difference (212,809.44)$ 16,359.17$ 3,160.28$ 10,413.24$ (4,296.18)$ (187,172.93)$
Budgeted 1,200,000.00$ 100,000.00$ 75,000.00$ 85,000.00$ 150,000.00$ 1,610,000.00$
Actual 1,281,721.24$ 113,850.95$ 66,182.69$ 94,093.41$ 122,071.33$ 1,677,919.62$
Difference 81,721.24$ 13,850.95$ (8,817.31)$ 9,093.41$ (27,928.67)$ 67,919.62$
2020
2019
2018
Water Revenue
2
A brief review of the 2016 and 2017 revenues for the same categories showed that 2017 had
actual revenues of $37,240.88 more than budgeted and 2016 revenues were $193,358.46
less than budgeted.
Ultimately, when the rates are reviewed annually, the revenue surplus and deficit is used
when making recommendations regarding the rates for upcoming years. Upcoming water
system expenses such as the water treatment plant and new municipal wells and towers will
require a substantial fund balance to cover those costs. Thus, the presence of an annual
surplus would be used to save for those future expenses .
RECOMMENDATION
None, provided for information and discussion only.
1-04-2021 11:05 AM CITY OF ROSEMOUNT PAGE: 1
REVENUE & EXPENSE REPORT - UNAUDITED
AS OF: DECEMBER 31ST, 2020
601-WATER UTILITY FUND
CURRENT CURRENT YEAR TO DATE BUDGET % OF
REVENUES BUDGET PERIOD ACTUAL BALANCE BUDGET
________________________________________________________________________________________________________________
GRANTS & AIDS
601-33425.00 OTHER STATE GRANTS & AIDS 4,500.00 0.00 1,995.13 2,504.87 44.34
TOTAL GRANTS & AIDS 4,500.00 0.00 1,995.13 2,504.87 44.34
CHARGES FOR SERVICES
601-34107.00 ASSESSMENT FEES 0.00 718.46 22,003.90 ( 22,003.90) 0.00
601-34108.00 ADMINISTRATIVE FEE-OTHER FUNDS 6,300.00 0.00 11,752.75 ( 5,452.75) 186.55
601-34109.00 OTHER GEN'L GOVT CHGS FOR SERV 0.00 1,509.17 21,709.17 ( 21,709.17) 0.00
TOTAL CHARGES FOR SERVICES 6,300.00 2,227.63 55,465.82 ( 49,165.82) 880.41
SPECIAL ASSESSMENTS
601-36101.00 PRINCIPAL-SPECIAL ASSESSMENTS 55,000.00 1,826.31 54,048.67 951.33 98.27
601-36102.00 PENALTIES & INTEREST - S/A 0.00 23.34 88.09 ( 88.09) 0.00
TOTAL SPECIAL ASSESSMENTS 55,000.00 1,849.65 54,136.76 863.24 98.43
MISCELLANEOUS REVENUES
601-36210.00 INTEREST EARNINGS 90,000.00 1,718.22 134,563.03 ( 44,563.03) 149.51
601-36215.00 INTEREST EARNINGS 500.00 209.04 2,622.60 ( 2,122.60) 524.52
601-36220.00 RENTS & ROYALTIES 168,500.00 1,384.23 163,151.01 5,348.99 96.83
TOTAL MISCELLANEOUS REVENUES 259,000.00 3,311.49 300,336.64 ( 41,336.64) 115.96
WATER REVENUES
601-37110.00 RESIDENTIAL WATER REVENUES 1,500,000.00 203,384.98 1,598,965.78 ( 98,965.78) 106.60
601-37120.00 APARTMENT WATER REVENUES 120,000.00 31,882.38 128,711.31 ( 8,711.31) 107.26
601-37125.00 INSTITUTIONAL WATER REVENUES 70,000.00 20,799.43 75,527.45 ( 5,527.45) 107.90
601-37130.00 COMMERCIAL WATER REVENUES 100,000.00 26,281.48 103,898.58 ( 3,898.58) 103.90
601-37140.00 INDUSTRIAL WATER REVENUES 130,000.00 37,310.99 143,752.75 ( 13,752.75) 110.58
601-37160.00 PENALTIES - WATER REVENUES 10,000.00 1,079.52 8,235.19 1,764.81 82.35
601-37170.00 OTHER WATER REVENUES 0.00 0.00 ( 350.00) 350.00 0.00
601-37180.00 WATER METER SALES REVENUE 80,000.00 9,418.75 117,611.78 ( 37,611.78) 147.01
TOTAL WATER REVENUES 2,010,000.00 330,157.53 2,176,352.84 ( 166,352.84) 108.28
________________________________________________________________________________________________________________
TOTAL REVENUES 2,334,800.00 337,546.30 2,588,287.19 ( 253,487.19) 110.86
============= ============= ============= ============= =======
1-06-2020 09:57 AM CITY OF ROSEMOUNT PAGE: 1
REVENUE & EXPENSE REPORT - UNAUDITED
AS OF: DECEMBER 31ST, 2019
601-WATER UTILITY FUND
CURRENT CURRENT YEAR TO DATE BUDGET % OF
REVENUES BUDGET PERIOD ACTUAL BALANCE BUDGET
________________________________________________________________________________________________________________
GRANTS & AIDS
601-33425.00 OTHER STATE GRANTS & AIDS 4,500.00 0.00 0.00 4,500.00 0.00
TOTAL GRANTS & AIDS 4,500.00 0.00 0.00 4,500.00 0.00
CHARGES FOR SERVICES
601-34107.00 ASSESSMENT FEES 0.00 10,461.72 21,123.78 ( 21,123.78) 0.00
601-34108.00 ADMINISTRATIVE FEE-OTHER FUNDS 6,300.00 0.00 9,327.15 ( 3,027.15) 148.05
601-34109.00 OTHER GEN'L GOVT CHGS FOR SERV 0.00 0.00 17,260.80 ( 17,260.80) 0.00
TOTAL CHARGES FOR SERVICES 6,300.00 10,461.72 47,711.73 ( 41,411.73) 757.33
SPECIAL ASSESSMENTS
601-36101.00 PRINCIPAL-SPECIAL ASSESSMENTS 55,000.00 26,460.10 53,933.89 1,066.11 98.06
601-36102.00 PENALTIES & INTEREST - S/A 0.00 55.89 128.60 ( 128.60) 0.00
TOTAL SPECIAL ASSESSMENTS 55,000.00 26,515.99 54,062.49 937.51 98.30
MISCELLANEOUS REVENUES
601-36210.00 INTEREST EARNINGS 90,000.00 32,130.69 177,441.57 ( 87,441.57) 197.16
601-36215.00 INTEREST EARNINGS 500.00 835.47 3,358.31 ( 2,858.31) 671.66
601-36220.00 RENTS & ROYALTIES 168,500.00 1,343.92 161,211.26 7,288.74 95.67
601-36265.00 USE OF RESERVE FUNDS 281,800.00 0.00 0.00 281,800.00 0.00
TOTAL MISCELLANEOUS REVENUES 540,800.00 34,310.08 342,011.14 198,788.86 63.24
WATER REVENUES
601-37110.00 RESIDENTIAL WATER REVENUES 1,400,000.00 134,361.14 1,187,190.56 212,809.44 84.80
601-37120.00 APARTMENT WATER REVENUES 105,000.00 29,997.09 121,359.17 ( 16,359.17) 115.58
601-37125.00 INSTITUTIONAL WATER REVENUES 80,000.00 14,206.12 83,160.28 ( 3,160.28) 103.95
601-37130.00 COMMERCIAL WATER REVENUES 85,000.00 21,438.42 95,413.24 ( 10,413.24) 112.25
601-37140.00 INDUSTRIAL WATER REVENUES 140,000.00 30,668.57 135,703.82 4,296.18 96.93
601-37160.00 PENALTIES - WATER REVENUES 10,000.00 970.41 12,012.10 ( 2,012.10) 120.12
601-37170.00 OTHER WATER REVENUES 0.00 ( 29,681.75)( 29,681.75) 29,681.75 0.00
601-37180.00 WATER METER SALES REVENUE 55,000.00 5,302.55 96,658.35 ( 41,658.35) 175.74
TOTAL WATER REVENUES 1,875,000.00 207,262.55 1,701,815.77 173,184.23 90.76
________________________________________________________________________________________________________________
TOTAL REVENUES 2,481,600.00 278,550.34 2,145,601.13 335,998.87 86.46
============= ============= ============= ============= =======
1-02-2019 10:54 AM CITY OF ROSEMOUNT PAGE: 1
REVENUE & EXPENSE REPORT - UNAUDITED
AS OF: DECEMBER 31ST, 2018
601-WATER UTILITY FUND
CURRENT CURRENT YEAR TO DATE BUDGET % OF
REVENUES BUDGET PERIOD ACTUAL BALANCE BUDGET
________________________________________________________________________________________________________________
GRANTS & AIDS
601-33425.00 OTHER STATE GRANTS & AIDS 4,500.00 0.00 0.00 4,500.00 0.00
TOTAL GRANTS & AIDS 4,500.00 0.00 0.00 4,500.00 0.00
CHARGES FOR SERVICES
601-34107.00 ASSESSMENT FEES 0.00 474.47 903.98 ( 903.98) 0.00
601-34108.00 ADMINISTRATIVE FEE-OTHER FUNDS 6,300.00 0.00 11,796.30 ( 5,496.30) 187.24
601-34109.00 OTHER GEN'L GOVT CHGS FOR SERV 0.00 93.63 15,983.78 ( 15,983.78) 0.00
TOTAL CHARGES FOR SERVICES 6,300.00 568.10 28,684.06 ( 22,384.06) 455.30
SPECIAL ASSESSMENTS
601-36101.00 PRINCIPAL-SPECIAL ASSESSMENTS 57,000.00 26,459.50 53,681.62 3,318.38 94.18
601-36102.00 PENALTIES & INTEREST - S/A 0.00 78.92 454.83 ( 454.83) 0.00
TOTAL SPECIAL ASSESSMENTS 57,000.00 26,538.42 54,136.45 2,863.55 94.98
MISCELLANEOUS REVENUES
601-36210.00 INTEREST EARNINGS 60,000.00 14,131.19 149,788.21 ( 89,788.21) 249.65
601-36215.00 INTEREST EARNINGS 200.00 313.58 1,243.71 ( 1,043.71) 621.86
601-36220.00 RENTS & ROYALTIES 148,500.00 1,304.77 154,609.88 ( 6,109.88) 104.11
601-36260.00 OTHER REVENUE 0.00 0.10 117.02 ( 117.02) 0.00
601-36265.00 USE OF RESERVE FUNDS 408,700.00 0.00 0.00 408,700.00 0.00
TOTAL MISCELLANEOUS REVENUES 617,400.00 15,749.64 305,758.82 311,641.18 49.52
WATER REVENUES
601-37110.00 RESIDENTIAL WATER REVENUES 1,200,000.00 154,496.88 1,281,721.24 ( 81,721.24) 106.81
601-37120.00 APARTMENT WATER REVENUES 100,000.00 26,640.29 113,850.95 ( 13,850.95) 113.85
601-37125.00 INSTITUTIONAL WATER REVENUES 75,000.00 22,060.82 66,182.69 8,817.31 88.24
601-37130.00 COMMERCIAL WATER REVENUES 85,000.00 22,306.08 94,093.41 ( 9,093.41) 110.70
601-37140.00 INDUSTRIAL WATER REVENUES 150,000.00 30,143.21 122,071.33 27,928.67 81.38
601-37160.00 PENALTIES - WATER REVENUES 9,500.00 1,195.43 12,848.04 ( 3,348.04) 135.24
601-37180.00 WATER METER SALES REVENUE 55,000.00 4,927.40 87,293.70 ( 32,293.70) 158.72
TOTAL WATER REVENUES 1,674,500.00 261,770.11 1,778,061.36 ( 103,561.36) 106.18
________________________________________________________________________________________________________________
TOTAL REVENUES 2,359,700.00 304,626.27 2,166,640.69 193,059.31 91.82
============= ============= ============= ============= =======