|
Exhibit F
<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 /> SURFACE WATER MANAGEMENT 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 $ 446,969 $ 207,274 $ 221,305 $ 14,031 106.8%
<br /> Other 2,000 5,428 20,268 14,840 373.4
<br /> Interest earnings 16,000 - - - N/A
<br /> TOTAL REVENUES 464,969 212,702 241,573 28,871 113.6
<br /> EXPENSES
<br /> Personnel expenses 194,920 68,306 88,765 (20,458) 130.0
<br /> Supplies and materials 26,164 6,882 18,367 (11,485) 266.9
<br /> Other services and charges 145,676 66,941 43,286 23,655 64.7
<br /> Depreciation 35,000 - - - N/A
<br /> Capital expenses 290,000 - 97,160 (97,160) N/A
<br /> TOTAL EXPENSES 691,760 142,130 247,578 (105,448) 174.2
<br /> Transfers in 45,000 - - N/A
<br /> Transfers out 59,632 - N/A
<br /> EXCESS(DEFICIT)REVENUES OVER EXPENSES $ (241,423) $ 70,572 $ (6,005) $ (76,578) -8.5 %
<br /> Surface Water Fees Comparison
<br /> $500
<br /> 6 $450
<br /> 0
<br /> $400
<br /> $350
<br /> $300
<br /> $250
<br /> $200
<br /> $150
<br /> $100
<br /> $50
<br /> Q1 Q2 Q3 Q4
<br /> g0-2022 94,627.81 192,841.05 292,575.27 394,307.64
<br /> 23 99,873.56 207,274.08 314,384.93 428,852.94
<br /> 24 107,184.78 221,304.74
<br />
|