|
Exhibit D
<br /> CITY OF MOUNDS VIEW,MINNESOTA
<br /> STATEMENT OF REVENUES AND EXPENSES
<br /> BUDGET AND ACTUAL
<br /> FOR THE NINE MONTHS ENDED SEPTEMBER 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 09/30/23 09/30/24 (Unfavorable) 09/30/24
<br /> REVENUES
<br /> User charges $ 2,101,806 $ 1,479,682 $ 1,551,354 $ 71,672 104.8%
<br /> Connection charges - 10,885 8,400 (2,485) 77.2
<br /> Other 14,000 40,999 34,578 (6,421) 84.3
<br /> Interest earnings 20,000 - - - N/A
<br /> TOTAL REVENUES 2,135,806 1,531,566 1,594,332 62,765 104.1
<br /> EXPENSES
<br /> Personnel expenses 529,970 314,709 317,221 (2,512) 100.8
<br /> Supplies and materials 37,422 21,767 19,455 2,313 89.4
<br /> Other services and charges 1,395,930 918,556 1,106,660 (188,103) 120.5
<br /> Wastewater charges - - - N/A
<br /> Depreciation 120,000 - - N/A
<br /> Capital expenses 545,000 37,850 123,591 (85,741) 326.5
<br /> Debt service - - - N/A
<br /> TOTAL EXPENSES 2,628,322 1,292,882 1,566,926 (274,043) 121.2
<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) $ 238,684 $ 27,406 $ (211,278) 11.5 %
<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 1,551,353.71
<br />
|