Red Hook WatchIndependent Community Resource

Water Fund Proposed Budget 24/25

↑Meetings/Document history/chain_1443
1 versions2024-03-11working document

Versions

  1. 12024-03-11
    Water Fund Proposed Budget 24/25
    working document

Document

Original file not available online (local: data/sources/village_docs/dc_1207_water_fund_24_25_proposed_budget_3_11_24.pdf)View version history →Meeting on 2024-03-11 →

VILLAGE OF RED HOOK

WATER FUND

| Income | ADOPTED 4-10-23 | - | CURRENT | - | 21/22 Actual | - | 20/21 Actual | | EW2140 · Metered Water Sales | 23/24 Budget | - | 22/23 Budget | - | - | - | - | | EW2142 · Water Finals | - | - | - | - | - | - | - | | EW2144 · Water Service Charge | - | - | - | - | - | - | - | | 2144.a · Water Tapping Fee | - | - | - | - | - | - | - | | EW2144 · Water Service Charge - Other | - | - | - | - | - | - | - | | Total EW2144 · Water Service Charge | - | - | - | - | - | - | - | | EW2148 · Interest & Penalties - Wat Rent | - | - | - | - | - | - | - | | EW2401 · Interest and Earnings | - | - | - | - | - | - | - | | Total Income | - | - | - | - | - | - | - | | Gross Profit | - | - | - | - | - | - | - | | Expense | - | - | - | - | - | - | - | | E1320.4 - Auditor | - | - | - | - | - | - | - | | EW8321 · Depreciation | - | - | - | - | - | - | - | | E1910.4 · Unallocated Insurance - Con Exp | - | - | - | - | - | - | - | | E1989.1 - General Gov't Support (Admin) | - | - | - | - | - | - | - | | E8310.1 · Water Admin - Per Srv | - | - | - | - | - | - | - | | 8310.1a · Highway Water Maintenance | - | - | - | - | - | - | - | | 8310.1b · Clerk- Administration | - | - | - | - | - | - | - | | 8310.1c - Treasurer | - | - | - | - | - | - | - | | Total E8310.1 · Water Admin - Per Srv | - | - | - | - | - | - | - | | E8310.4 · Water Admin - Contr Exp | - | - | - | - | - | - | - | | 8310.41 - Contract | - | - | - | - | - | - | - | | 8310.42 - Contract Extras | - | - | - | - | - | - | - | | Total E8310.4 - Water Admin - Contr Exp | - | - | - | - | - | - | - | | E8320.2 - Capital Outlay | - | - | - | - | - | - | - | | E8320.4 · Srce Supply Pwr&Pmp - Contr Exp | - | - | - | - | - | - | - | | 8320.41 · Water Tapping | - | - | - | - | - | - | - | | 8320.42 · Fuel | - | - | - | - | - | - | - | | 8320.43 · Generator Contractual Fuel | - | - | - | - | - | - | - | | 8320.44 · Central Hudson | - | - | - | - | - | - | - | ||545,000.00 1,000.00

5,000.00 -||#REF! #REF! #REF! #REF!||550,563.19 1,600.00 2,500.00 -||530,939.29 2,252.67 21,607.98| ||5,000.00 5,000.00 100.00||#REF! #REF! #REF!||2,500.00 2,249.06 48.09||21,607.98 3,856.43 170.14| ||556,100.00||#REF!||556,960.34||558,826.51| ||556,100.00||#REF!||556,960.34||558,826.51| | 5,950.00 | - | #REF! | - | 313,472.00 | - | 313,472.00 | | - | - | #REF! | - | 25,500.00 | - | 24,800.00 | | 27,500.00 | - | #REF! | - | 14,469.11 | - | 7,860.09 | | 4,830.00 | - | #REF! | - | 38,847.91 | - | 36,975.62 | | 20,000.00 | - | #REF! | - | 71.33 | - | - | | 35,000.00 | - | #REF! | - | - | - | - | | 12,000.00 | - | #REF! | - | - | - | - | ||67,000.00||#REF!||53,388.35||44,835.71| ||23,700.00 11,750.00||#REF! #REF!||32,563.31||18,167.40| ||35,450.00||#REF!||32,563.31||18,167.40| ||16,550.00 3,000.00 1,000.00 1,000.00 18,900.00||#REF! #REF! #REF! 900.00 #REF!||-

661.85 814.31 19,186.05||-

115.76 958.74 25,941.32|

3/11/2024

VILLAGE OF RED HOOK

WATER FUND

||ADOPTED 4-10-23 23/24 Budget||CURRENT 22/23 Budget||21/22 Actual||**20/21 Actual **|4| |---|---|---|---|---|---|---|---|---| | 8320.45 · Misc | 5,000.00 | - | #REF! | - | 6,429.05 | - | 9,039.30 | | 8320.46 · Communicatins | 2,000.00 | - | #REF! | - | 773.48 | - | 1,001.96 | | 8320.47 · Water Repairs | 50,000.00 | - | #REF! | - | 92,140.71 | - | 67,217.87 | | 8320.48 · Tools | 2,000.00 | - | #REF! | - | 852.31 | - | - | | 8320.49 · Vehicle/Repair Maintenance | 6,000.00 | - | #REF! | - | 4,746.49 | - | 7,538.98 | | 8320410 · Legal | 1,500.00 | - | #REF! | - | - | - | 1,422.40 | | 8320411 · Engineering | 22,750.00 | - | #REF! | - | 33,262.50 | - | 23,669.28 | | 832041a Engineering Extras | 4,300.00 | - | #REF! | - | - | - | - | | 8320412 · Office Supplies | 1,000.00 | - | #REF! | - | - | - | 9,500.00 | | 8320413 · SIngle Audit/A133 | 15,000.00 | - | #REF! | - | - | - | 992.20 | | 8320414 · Postage | 1,839.75 | - | #REF! | - | - | - | 950.00 | | 8320415 · Solar Project (Water) | 500.00 | - | #REF! | - | - | - | - | | Total E8320.4 · Srce Supply Pwr&Pmp - Contr Exp | - | - | - | - | - | - | - | | E8330.4 · Water Purification - Contr Exp | - | - | - | - | - | - | - | | 8330.41 - Software/Hardware updates | - | - | - | - | - | - | - | | E9010.8 · State Retirement - Emp Benef | - | - | - | - | - | - | - | | E9030.8 · Social Security - Emp Benef | - | - | - | - | - | - | - | | E9040.8 · Workers Comp - Emp Benef | - | - | - | - | - | - | - | | E9060.8 · Medical Ins - Emp Benef | - | - | - | - | - | - | - | | E9710.6 · Debt Principal - Serial Bonds | - | - | - | - | - | - | - | | 9710.61 · USDA Principal Phase 1 | - | - | - | - | - | - | - | | 9710.62 · Debt Principal USDA Phase 2 | - | - | - | - | - | - | - | | Total E9710.6 · Debt Principal - Serial Bonds | - | - | - | - | - | - | - | | E9710.7 · Debt Interest - Serial Bonds | - | - | - | - | - | - | - | | EW9710.72 USDA Phase 1 Interest | - | - | - | - | - | - | - | | EW9710.73 USDA Phase 2 Interest | - | - | - | - | - | - | - |

EW9710.71 USDA Interest-------
EW9710.1 - EFC Interest-------
--------
Total E9710.7 · Debt Interest - Serial Bonds-------
E9710.8 · USDA Reserve-------
E8989.4 · Misc Home & Comm Services-------
--------
E9901.9 · Interfund Transfers (Out)-------
--------
135,789.75#REF!158,866.75148,347.81
7,000.00-#REF!-21,698.00-4,844.26
10,000.00-#REF!-6,000.00-5,000.00
8,000.00-#REF!-4,078.76-3,438.71
6,500.00-#REF!-6,000.00-5,400.00
7,000.00-#REF!-40,000.00-37,000.00
63,000.00-#REF!-24,000.00-23,000.00
25,000.00-#REF!-23,500.00-22,500.00
25,000.00-#REF!----
50,000.00#REF!47,500.0045,500.00
19,749.00
41,781.25

-||#REF! #REF! #REF! #REF!||20,660.00 43,105.47

-||19,386.67 43,832.04

-|| ||61,530.25||#REF!||63,765.47||63,218.71|| ||25,000.00

-||#REF! #REF! #REF!||- 7,320.00 -||11,930.00 13,280.00 65,000.00 3/11/202||

VILLAGE OF RED HOOK

WATER FUND

||ADOPTED 4-10-23 23/24 Budget||CURRENT 22/23 Budget||21/22 Actual||**20/21 Actual **| |---|---|---|---|---|---|---|---| |E990191 · Interfund Transfer Sewer Total Expense Net Income Net Income excluding Depreciation|25,000.00||#REF!||23,000.00||25,000.00| ||556,100.00||#REF!||803,152.64||829,234.60| ||-||#REF!||(246,192.30)||(270,408.09)| ||||||||| ||-||||||43,063.91|

3/11/2024

VILLAGE OF RED HOOK

WATER FUND

| Income | APPROVED | | EW2140 · Metered Water Sales | 23/24 Budget | | EW2142 · Water Finals | - | | EW2144 · Water Service Charge | - | | 2144.a · Water Tapping Fee | - | | EW2144 · Water Service Charge - Other | - | | Total EW2144 · Water Service Charge | - | | EW2148 · Interest & Penalties - Wat Rent | - | | EW2401 · Interest and Earnings | - | | Total Income | - | | Gross Profit | - | | Expense | - | | E1320.4 - Auditor | - | | EW8321 · Depreciation | - | | E1910.4 · Unallocated Insurance - Con Exp | - | | E1989.1 - General Gov't Support (Admin) | - | | E8310.1 · Water Admin - Per Srv | - | | 8310.1a · Highway Water Maintenance | - | | 8310.1b · Clerk- Administration | - | | 8310.1c - Treasurer | - | | Total E8310.1 · Water Admin - Per Srv | - | | E8310.4 · Water Admin - Contr Exp | - | | 8310.41 - Contract | - | | 8310.42 - Contract Extras | - | | Total E8310.4 - Water Admin - Contr Exp | - | | E8320.2 - Capital Outlay | - | | E8320.4 · Srce Supply Pwr&Pmp - Contr Exp | - | | 8320.41 · Water Tapping | - | | 8320.42 · Fuel | - | | 8320.43 · Generator Contractual Fuel | - | | 8320.44 · Central Hudson | - | | 8320.45 · Misc | - | | 8320.46 · Communicatins | - | | 8320.47 · Water Repairs | - | | 8320.48 · Tools | - | | 8320.49 · Vehicle/Repair Maintenance | - | | 8320410 · Legal | - | | 8320411 · Engineering | - | | 832041a Engineering Extras | - | | 8320412 · Office Supplies | - | ||545,000.00 1,000.00

5,000.00
5,000.00
100.00
5,950.00

27,500.00 4,830.00 20,000.00 35,000.00 12,000.00

||67,000.00| ||23,700.00 11,750.00| ||35,450.00| 16,550.00 3,000.00 1,000.00 1,000.00 18,900.00 5,000.00 2,000.00 50,000.00 2,000.00 6,000.00 1,500.00 22,750.00 4,300.00 1,000.00

Page 4

3/11/2024

| 8320413 · SIngle Audit/A133 | 15,000.00 | | 8320414 · Postage | 1,839.75 | | 8320415 · Solar Project (Water) | 500.00 | | Total E8320.4 · Srce Supply Pwr&Pmp - Contr Exp | - | | E8330.4 · Water Purification - Contr Exp | - | | 8330.41 - Software/Hardware updates | - | | E9010.8 · State Retirement - Emp Benef | - | | E9030.8 · Social Security - Emp Benef | - | | E9040.8 · Workers Comp - Emp Benef | - | | E9060.8 · Medical Ins - Emp Benef | - | | E9710.6 · Debt Principal - Serial Bonds | - | | 9710.61 · USDA Principal Phase 1 | - | | 9710.62 · Debt Principal USDA Phase 2 | - | | Total E9710.6 · Debt Principal - Serial Bonds | - | | E9710.7 · Debt Interest - Serial Bonds | - | | EW9710.72 USDA Phase 1 Interest | - | | EW9710.73 USDA Phase 2 Interest | - | | EW9710.71 USDA Interest | - | | EW9710.1 - EFC Interest | - | | Total E9710.7 · Debt Interest - Serial Bonds | - | | E9710.8 · USDA Reserve | - | | E8989.4 · Misc Home & Comm Services | - | | E9901.9 · Interfund Transfers (Out) | - | | E990191 · Interfund Transfer Sewer | - | | Total Expense | - | | Net Income | - |

Net Income excluding Depreciation-
135,789.75
7,000.00
10,000.00
8,000.00
6,500.00
7,000.00
63,000.00
25,000.00
25,000.00

||50,000.00| ||19,749.00 41,781.25

-| ||61,530.25| ||25,000.00

25,000.00| ||556,100.00| ||-| ||| ||-|

Page 5

3/11/2024

Village of Red Hook - Draft Water Fund Budget

March 11, 2024

VILLAGE OF RED HOOKWATERFUND
ProposedProjectedPRIOR ACTUALS
Income24/25 BudgetActual 23/2422/23 Actual21/22 Actual20/21 Actual19/20 Actual18/19 Actual17/18 Actual
EW2140·Metered Water Sales550,000.00545,000.00574,205.80550,563.19530,939.29509,466.93467,157.60483,003.25
EW2142·Water Finals1,000.001,000.001,945.651,600.002,252.671,366.712,835.882,219.12
EW2144·Water Service Charge
2144.a·Water Tapping Fee5,000.0012,000.005,000.002,500.002,500.0050.00-
EW2144·Water Service Charge-Other---21,607.98128.288,027.12350.00
Total EW2144·Water Service Charge5,000.0012,000.005,000.002,500.0021,607.982,628.288,077.12350.00
EW2148·Interest & Penalties-Wat Rent3,500.005,000.005,960.712,249.063,856.435,547.833,266.654,254.98
EW2401·Interest and Earnings500.00500.001,478.3348.09170.14734.39250.0221.35
EW2680-Insurance Recoveries-------770.00
EW2690-Other Compensation for Loss-520.00
EW2701-Refund of Prior Year Exp-------3,000.00
EW4989-Other Federal Aid (ARPA)--23,053.00----25.00
Total Income560,000.00564,020.00611,643.49556,960.34558,826.51519,744.14481,587.27493,643.70
GrossProfit560,000.00564,020.00611,643.49556,960.34558,826.51519,744.14481,587.27493,643.70
Expense
E9289.8-Other Employee Benefits3,685.00
E1440.4-Engineer1,500.00
E1320.4-Auditor5,950.005,950.00795.00
EW8321·Depreciation314,545.00313,472.00313,472.00313,322.00313,305.00314,454.00
E1910.4·Unallocated Insurance-Con Exp30,000.0029,500.0026,500.0025,500.0024,800.0023,000.0024,000.0022,500.00
E1989.1-General Gov't Support (Admin)4,830.004,830.00
E8310.1·Water Admin-Per Srv
8310.1a·Highway Water Maintenance21,000.0020,000.0011,370.0614,469.117,860.0910,936.118,934.117,103.77
8310.1b·Clerk-Administration35,875.0035,000.0034,167.0638,847.9136,975.6259,825.8164,947.6765,567.61
8310.1c-Treasurer12,300.0012,000.005,938.5871.33----
Total E8310.1·Water Admin-Per Srv69,175.0067,000.0051,475.7053,388.3544,835.7170,761.9273,881.7872,671.38
E8310.4·Water Admin-Contr Exp
8310.41-Contract25,000.0023,700.0020,959.2032,563.3118,167.4014,685.5113,160.2714,163.75
8310.42-Contract Extras10,000.0015,000.0013,584.69
Total E8310.4-Water Admin-Contr Exp35,000.0038,700.0034,543.8932,563.3118,167.4014,685.5113,160.2714,163.75
E8320.2-Capital Outlay14,930.6316,550.00
E8320.4·Srce Supply Pwr&Pmp-Contr Exp
8320.41·Water Tapping4,000.008,400.002,188.75--1,505.00--
8320.42·Fuel1,500.001,500.00484.20661.85115.76472.98422.75217.22
8320.43·Generator Contractual Fuel900.00850.00826.07814.31958.74-182.38364.52
8320.44·Central Hudson23,000.0023,000.0013,541.7919,186.0525,941.3216,451.0619,007.6017,599.31
8320.45·Misc5,000.005,000.004,360.616,429.059,039.305,102.6110,348.3617,839.63
8320.46·Communications2,000.002,000.001,577.64773.481,001.96893.271,644.101,125.58
8320.47·Water Repairs42,500.0040,000.0031,485.1292,140.7167,217.8787,318.9039,167.8628,947.05
8320.48·Tools3,000.004,000.001,702.72852.31-3,323.42-150.74
8320.49·Vehicle/Repair Maintenance5,000.006,000.004,438.054,746.497,538.98-249.505,104.12
8320410·Legal1,000.00---1,422.4033.006,826.50664.50
8320411·Engineering23,000.0022,750.0022,200.0033,262.5023,669.2826,067.815,697.417,273.50
832041a Engineering Extras5,000.004,300.004,500.00

D:\inetpub\wwwroot\sites\root\PDFConv2tmp5454

6 of 7

3/11/2024

Village of Red Hook - Draft Water Fund Budget

March 11, 2024

VILLAGE OF RED HOOKWATERFUND
ProposedProjectedPRIOR ACTUALS
Income24/25 BudgetActual 23/2422/23 Actual21/22 Actual20/21 Actual19/20 Actual18/19 Actual17/18 Actual
8320412·Office Supplies1,000.001,000.00193.19--564.20225.424,100.00
8320413·SIngle Audit/A13312,000.0015,000.0011,000.00-9,500.007,816.8012,628.6917,607.51
8320414·Postage1,000.00500.001,460.68-992.203,952.95838.991,196.75
8320415·Solar Project (Water)----950.005,718.48--
Total E8320.4·Srce Supply Pwr&Pmp-Contr Exp129,900.00134,300.0099,958.82158,866.75148,347.81159,220.4897,239.56102,190.43
E8330.4·Water Purification-Contr Exp10,000.0015,000.007,001.1821,698.004,844.266,446.437,718.703,395.16
8330.41-Software/Hardware updates4,000.004,000.0036,579.27
E9010.8·State Retirement-Emp Benef9,000.008,000.006,000.006,000.005,000.005,000.005,000.003,441.00
E9030.8·Social Security-Emp Benef7,000.006,500.004,147.564,078.763,438.715,278.705,689.106,537.18
E9040.8·Workers Comp-Emp Benef8,000.007,000.004,700.006,000.005,400.005,400.005,400.002,000.00
E9060.8·Medical Ins-Emp Benef66,000.0063,000.0043,000.0040,000.0037,000.0035,000.0035,000.0026,000.00
E9710.6·Debt Principal-Serial Bonds
9710.61·USDA Principal Phase 125,000.0025,000.0024,000.0024,000.0023,000.00---
9710.62·Debt Principal USDA Phase 226,000.0025,000.0024,000.0023,500.0022,500.00---
Total E9710.6·Debt Principal-Serial Bonds51,000.0050,000.0048,000.0047,500.0045,500.000.000.000.00
E9710.7·Debt Interest-Serial Bonds
EW9710.72 USDA Phase 1 Interest19,230.0019,749.0022,043.3320,660.0019,386.6721,703.3422,043.3322,483.33
EW9710.73 USDA Phase 2 Interest40,984.3741,781.2542,906.2043,105.4743,832.0433,441.3233,785.24-
EW9710.71 USDA Interest-------35.00
EW9710.1-EFC Interest------13,515.3726,948.15
Total E9710.7·Debt Interest-Serial Bonds60,214.3761,530.2564,949.5363,765.4763,218.7155,144.6669,343.9449,466.48
E9710.8·USDA Reserve25,000.0025,000.0025,000.00-11,930.00--420.00
E8989.4·Misc Home & Comm Services14,560.007,320.0013,280.009,760.0012,160.003,350.00
E9901.9·Interfund Transfers (Out)--65,000.0085,000.0085,000.0060,250.00
E990191·Interfund Transfer Sewer30,000.0025,000.0044,468.4523,000.0025,000.00---
TotalExpense560,000.00561,860.25825,429.40803,152.64829,234.60788,019.70746,898.35686,819.38
Net Income-2,159.75(213,785.91)(246,192.30)(270,408.09)(268,275.56)(265,311.08)(193,175.68)
Net Income excluding Depreciation-2,159.75100,759.0967,279.7043,063.9145,046.4447,993.92121,278.32
E6260-WIIA Grant-Bond Antic. Note (Proj 18787)197,500.00
TotalOther Income197,500.00
EW8341.22-Engineering (18787)180,000.00
EW8341.23-Bond Counsel (18787)2,000.00
EW8341.24-Local Counsel (18787)15,000.00
EW8341.26-Misc (18787)500.00
TotalOther Expenses197,500.00
TotalOTHER-

D:\inetpub\wwwroot\sites\root\PDFConv2tmp5454

7 of 7

3/11/2024

References

This document cites or incorporates the following separate documents:

Recurring pattern

These other chains use the same template but are separate decisions: