|
Exhibit C
<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 /> WATER 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 $ 1,526,244 $ 572,129 $ 562,261 $ (9,868) 98.3 %
<br /> Connection charges 2,000 600 1,700 1,100 283.3
<br /> Other 10,000 12,006 13,050 1,044 108.7
<br /> Interest earnings 2,000 - - - N/A
<br /> TOTAL REVENUES 1,540,244 584,735 577,011 (7,724) 98.7
<br /> EXPENSES
<br /> Personnel expenses 561,390 230,477 249,146 (18,669) 108.1
<br /> Supplies and materials 92,752 36,594 41,110 (4,516) 112.3
<br /> Other services and charges 415,557 188,154 248,879 (60,725) 132.3
<br /> Water purchases - - - N/A
<br /> Depreciation 200,000 - - N/A
<br /> Capital expenses 615,000 28,801 704,563 (675,762) 2446.3
<br /> Debt service 434,148 393,361 397,044 (3,683) 100.9
<br /> TOTAL EXPENSES 2,318,847 877,387 1,640,741 (763,354) 187.0
<br /> Bond Proceeds - - - N/A
<br /> Transfers in - N/A
<br /> Transfers out 183,258 N/A
<br /> EXCESS(DEFICIT)REVENUES OVER EXPENSES $ (961,861) $ (292,652) $ (1,063,730) $ (771,078) 363.5 %
<br /> Water Sales Comparison
<br /> $1.60
<br /> c
<br /> 0
<br /> $1.40
<br /> $1.20
<br /> $1.00
<br /> $0.80
<br /> $0.60
<br /> $0.40
<br /> $0.20
<br /> $- Q1 Q2 Q3 Q4
<br /> P2022 280,465.17 534,094.59 873,641.22 1,388,104.32
<br /> 2023 305,786.46 572,129.18 987,857.87 1,428,487.42
<br /> 2024 274,254.09 562,261.32
<br />
|