|
Exhibit D
<br />CITY OF MOUNDS VIEW, MINNESOTA
<br />STATEMENT OF REVENUES AND EXPENSES
<br />BUDGET AND ACTUAL
<br />FOR THE THREE MONTHS ENDED MARCH 31
<br />SEWER FUND
<br />Percent
<br />Received or
<br />Expended
<br />Actual Actual Variance - Based on
<br />Annual Thru Thru Favorable Actuals Thru
<br />Budget 03/31/23 03/31/24 (Unfavorable) 03/31/24
<br />REVENUES
<br />User charges
<br />$ 2,101,806 $
<br />490,245 $
<br />488,026 $
<br />(2,219)
<br />99.5 %
<br />Connection charges
<br />-
<br />2,500
<br />1,900
<br />(600)
<br />76.0
<br />Other
<br />14,000
<br />8,661
<br />9,397
<br />735
<br />108.5
<br />Interest earnings
<br />20,000
<br />-
<br />-
<br />-
<br />N/A
<br />TOTAL REVENUES
<br />2,135,806
<br />501,406
<br />499,323
<br />(2,083)
<br />99.6
<br />EXPENSES
<br />Personnel expenses
<br />529,970
<br />95,056
<br />100,743
<br />(5,687)
<br />106.0
<br />Supplies and materials
<br />37,422
<br />3,429
<br />4,159
<br />(730)
<br />121.3
<br />Other services and charges
<br />1,395,930
<br />406,935
<br />444,803
<br />(37,868)
<br />109.3
<br />Wastewater charges
<br />-
<br />-
<br />-
<br />N/A
<br />Depreciation
<br />120,000
<br />N/A
<br />Capital expenses
<br />545,000
<br />N/A
<br />Debt service
<br />-
<br />-
<br />-
<br />N/A
<br />TOTAL EXPENSES
<br />2,628,322
<br />505,420
<br />549,705
<br />(44,285)
<br />108.8
<br />Bond Proceeds
<br />-
<br />-
<br />-
<br />N/A
<br />Transfers in
<br />-
<br />N/A
<br />Transfers out
<br />153,258
<br />N/A
<br />EXCESS (DEFICIT) REVENUES OVER EXPENSES
<br />$ (645,774) $
<br />(4,014) $
<br />(50,382) $
<br />(46,369)
<br />1255.2 %
<br />Sewer Sales Comparison
<br />N $2.50
<br />0
<br />$2.00
<br />$1.50
<br />$1.00
<br />$0.50
<br />Q1
<br />Q2
<br />Q3
<br />Q4
<br />-2022
<br />489,174.40
<br />953,910.18
<br />1,449,641.73
<br />1,940,359.21
<br />-2023
<br />490,244.68
<br />995,588.27
<br />1,479,681.97
<br />1,966,065.34
<br />-2024
<br />488,026.04
<br />
|