|
City of Lino Lakes
<br />Water Fund Budet to Actual (Unaudited)
<br />For the Quarter Ended June 30, 2021
<br />Budget Actuals Prior Year Variance -
<br />Annual Thru Thru Thru Favorable
<br />Budget 06/30/2021 06/30/2021 06/30/2020 (Unfavorable)
<br />Revenues
<br />Water Hook Up Charge 36,500$ 18,250$ 41,750$ 15,750$ 26,000 (1)
<br />Water Meter Sales 50,000 25,000 77,917 25,727 52,189 (1)
<br />Irrigation Controller Sales - - 4,750 - 4,750
<br />Interest On Investments 50,000 25,000 (6,677) - (6,677)
<br />Miscellaneous Revenue 2,500 1,250 1,085 106 979
<br />Water Sales 1,080,000 540,000 342,169 367,391 (25,222) (2)
<br />Penalty 22,000 11,000 7,796 3,760 4,036
<br />Sale of Fixed Assets - - 13,750 - 13,750
<br /> Total Revenues 1,241,000 620,500 482,540 412,735 69,805
<br />Expenditures
<br />Personal Services 312,737 156,369 141,433 139,586 (1,847)
<br />Supplies 240,000 120,000 108,007 84,504 (23,502) (3)
<br />Services & Charges 300,181 150,091 94,960 108,661 13,701
<br />Contractual Services 11,000 5,500 6,227 (4,489) (10,716)
<br />Depreciation*605,000 302,500 - - -
<br />Capital Outlay 55,000 27,500 67,273 135,966 68,693 (4)
<br /> Total Expenditures 1,523,918 761,959 417,899 464,228 46,328
<br />Revenues Over
<br />(Under) Expenditures (282,918)$ (141,459)$ 64,640$ (51,493)$ 116,133$
<br />*Depreciation is factored out of contractual services. Depreciation is a non-cash expense calculated at year end.
<br />Item Explanation of items with variance greater than $20,000
<br />(1) Roughly 167 new customers YTD in 2021 compared to 63 in 2020.
<br />(2) More water sales in 2020 due to the COVID-19 Pandemic with more people at home. In addition, the prison needed a
<br />large amount of water ($16,380) in 2020. These factors are offsetting an increase from new customers in 2021.
<br />(3) Variance from prior year due to level of water meter inventory. More needed in 2021 due to the number of new customers.
<br />(4) Variance due to capital equipment purchased and capital projects in progress:
<br />2021 - Smart Radio Reader, 50% Utilities Vehicle, 50% Lawn Mower, Well House No. 1 Rehabilitation
<br />2020 - Smart Irrigation Meters, 50% Utilities Vehicle, Well House No. 1 Rehabilitation
<br />5
|