|
Exhibit D
<br /> CITY OF MOUNDS VIEW,MINNESOTA
<br /> STATEMENT OF REVENUES AND EXPENSES
<br /> BUDGET AND ACTUAL
<br /> FOR THE SIX MONTHS ENDED JUNE 30
<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 06/30/23 06/30/24 (Unfavorable) 06/30/24
<br /> REVENUES
<br /> User charges $ 2,101,806 $ 995,588 $ 1,018,855 $ 23,267 102.3 %
<br /> Connection charges - 5,200 4,300 (900) 82.7
<br /> Other 14,000 23,261 20,568 (2,693) 88.4
<br /> Interest earnings 20,000 - - - N/A
<br /> TOTAL REVENUES 2,135,806 1,024,049 1,043,724 19,674 101.9
<br /> EXPENSES
<br /> Personnel expenses 529,970 209,322 221,333 (12,011) 105.7
<br /> Supplies and materials 37,422 8,661 15,449 (6,789) 178.4
<br /> Other services and charges 1,395,930 712,856 788,872 (76,016) 110.7
<br /> Wastewater charges - - - N/A
<br /> Depreciation 120,000 - - N/A
<br /> Capital expenses 545,000 12,400 123,591 (111,191) 996.7
<br /> Debt service - - - N/A
<br /> TOTAL EXPENSES 2,628,322 943,239 1,149,244 (206,006) 121.8
<br /> Bond Proceeds - - - N/A
<br /> Transfers in - N/A
<br /> Transfers out 153,258 N/A
<br /> EXCESS(DEFICIT)REVENUES OVER EXPENSES $ (645,774) $ 80,811 $ (105,521) $ (186,331) -130.6%
<br /> Sewer Sales Comparison
<br /> $2.50
<br /> 0
<br /> $2.00
<br /> $1.50
<br /> $1.00
<br /> $0.50
<br /> $- Q1 Q2 Q3 Q4
<br /> P2022 489,174.40 953,910.18 1,449,641.73 1,940,359.21
<br /> 2023 490,244.68 995,588.27 1,479,681.97 1,966,065.34
<br /> 2024 488,026.04 1,018,855.26
<br />
|