Regular Council

AGENDA Regular Council Meeting 6:00 PM - Monday, March 18, 2024 Village Council Room Page CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL I. APPROVAL OF THE AGENDA a. II. CONSENT AGENDA All items listed with an asterisk (*) are considered to be routine by the Village Council and shall be enacted by one motion. There will be no separate discussion of these items unless a trustee or citizen requests to do so, in which event the item shall be removed from the General Order of Business and considered in its normal sequence on the agenda. a. III. ADOPTION OF MINUTES 4-7 a. Monday, March 4, 2024 Regular Council Meeting Minutes 03.04.2024 Regular Council Meeting Minutes - UA Page 1 of 34  IV. PUBLIC COMMENT V. UNFINISHED BUSINESS a. Council Wages b. Traffic Study on M-115 VI. NEW BUSINESS 8 - 13 a. Bakertilly Sewer Rate Study Farwell Village - 2024 RD Bonds Sewer Rate Study (Draft) 031224 b. USDA/Sewer Grant Update c. Mill Pond Update d. Master Plan Steering Committee Appointments *Arika Prueter *John Gross 14 e. Point to Point Installation Quote Estimate_1257_from_BLUTECH_DATA 15 f. Village of Farwell Welcome Signs Repainting Estimate_1376_from_Hoggers_Custom_Sign__Design 16 - 20 g. DTE Tree Grant DTE Tree Grant Tree Locations h. Alleyway Repair i. Bertha & Siegle Repair 21 - 28 j. Zero-turn mower Kubota Quote 643736 (Zero Turn) John Deere Quote 30451713 (Zero Turn) 29 k. Aerator Motor Repair Hamilton Electric Quote (Aerator Motor) 30 - 31 l. LeafVac Repair Mtech Quote QUO003743 (Leaf Vac) m. Salt Conveyor VII. ADMINISTRATIVE REPORT Page 2 of 34  a. Building Improvements Update VIII. TREASURER REPORT 32 a. 03.2024 Bank & Fund Report 33 b. 03.2024 Treasurer's Report (02.29.2024) IX. ZONING REPORT X. COMMITTEE REPORT a. Finance b. Parks & Rec 34 c. DPW 03.14.2024 DPW Minutes d. Personnel XI. PRESIDENT DISCUSSION XII. ADDITIONAL REMARKS XIII. EXTENDED PUBLIC COMMENT XIV. ADJOURNMENT NEXT REGULAR COUNCIL MEETING ON MONDAY, APRIL 1, 2024 AT 6:00PM Page 3 of 34  MINUTES Regular Council Meeting 6:00 PM - Monday, March 4, 2024 Village Council Room The Regular Council of the Village of Farwell was called to order on Monday, March 4, 2024, at 6:00 PM in the Village Council Room, with the following members present: PRESENT: President Tracey Jackson, Trustee Amanda Pfruender, Trustee Gina Hamilton, Trustee Jeff Linton, Trustee Victoria Williams, Trustee Shawn Burger, and Trustee Tonya Roe EXCUSED: I. APPROVAL OF THE AGENDA a. Trustee Amanda Pfruender made a motion to approve the agenda with the following addition: under New Business, item j. "Handbook Revision" Trustee Victoria Williams seconded the motion. Motion Carried. II. CONSENT AGENDA All items listed with an asterisk (*) are considered to be routine by the Village Council and shall be enacted by one motion. There will be no separate discussion of these items unless a trustee or citizen requests to do so, in which event the item shall be removed from the General Order of Business and considered in its normal sequence on the agenda. a. Trustee Amanda Pfruender made a motion to approve the consent agenda Trustee Tonya Roe seconded the motion. Motion Carried. III. *ADOPTION OF MINUTES a. *Monday, February 19, 2024 Regular Council Meeting Minutes IV. APPROVAL OF PAYMENT OF BILLS AND PAYROLL FOR FEBRUARY 2024 IN THE AMOUNT OF $155,573.29 a. Trustee Victoria Williams made a motion to approve the payment of bills and payroll for February 2024 in the amount of $155,573.29 Trustee Amanda Pfruender seconded the motion. Roll Call. Yeas: Trustee Victoria Williams, Trustee Amanda Pfruender, Trustee Tonya Roe, Trustee Shawn Burger, Trustee Jeff Linton, and President Tracey Jackson. Nays: None. Absent: Trustee Gina Hamilton. Motion Carried. Motion Carried Page Page41ofof34 V. PUBLIC COMMENT a. None. VI. UNFINISHED BUSINESS a. The Farwell USDA Sewer Recommendation Letter from Fleis & Vandenbrink was reviewed by Council. Trustee Amanda Pfruender made a motion to approve the bid results and contract award recommendations for the Farwell USDA Sewer System Improvements Project as outlined in the letter from Fleis & Vandenbrink, dated February 29,2024 Trustee Tonya Roe seconded the motion. Roll Call. Yeas: Trustee Amanda Pfruender, Trustee Tonya Roe, Trustee Victoria Williams, Trustee Jeff Linton, Trustee Shawn Burger, and President Tracey Jackson. Nays: None. Absent: Trustee Gina Hamilton. Motion Carried. b. Lease #PRD-L-001-2024 between the Village of Farwell and the State of Michigan was reviewed by Council. Trustee Tonya Roe made a motion to approve Lease No. PRD-L-001-2024 between the State of Michigan through its Department of Natural Resources and the Village of Farwell, to allow the Village of Farwell to develop the Mill Pond Park for public recreation on the premises Trustee Amanda Pfruender seconded the motion. Roll Call. Yeas: Trustee Tony Roe, Trustee Amanda Pfruender, Trustee Jeff Linton, Trustee Shawn Burger, and President Tracey Jackson. Nays: Trustee Victoria Williams. Absent: Trustee Gina Hamilton. Motion Carried. 5-1 (opposed: Trustee Victoria Williams). VII. NEW BUSINESS a. Trustee Amanda Pfruender made a motion to adopt Resolution 2024-06, "Resolution to Submit Applications to Close the State Trunk Line M-115 for Parades" Trustee Jeff Linton seconded the motion. Roll Call. Yeas: Trustee Amanda Pfruender, Trustee Jeff Linton, Trustee Tonya Roe, Trustee Shawn Burger, Trustee Victoria Williams, and President Tracey Jackson. Nays: None. Absent: Trustee Gina Hamilton. Motion Carried. b. Trustee Victoria Williams made a motion to adopt Resolution 2024-07, "Resolution to Support Memorial Day Fireworks Within the Village of Farwell" Trustee Jeff Linton seconded the motion. Roll Call. Yeas: Trustee Victoria Williams, Trustee Jeff Linton, Trustee Shawn Burger, Trustee Tonya Roe, Trustee Amanda Pfruender, and President Tracey Jackson. Nays: None. Absent: Trustee Gina Hamilton. Motion Carried. c. Trustee Amanda Pfruender made a motion to adopt Resolution 2024-08, " Resolution to Adopt the Annual Exemption Option as Set Forth in 2011 Public Act 152, The Publicly Funded Health Insurance Contribution Act" Trustee Victoria Williams seconded the motion. Roll Call. Yeas: Trustee Amanda Pfruender, Trustee Victoria Williams, Trustee Tonya Roe, Trustee Jeff Linton, Trustee Shawn Burger, and President Tracey Jackson. Nays: None. Absent: Trustee Gina Hamilton. Motion Carried. Page Page52ofof34  d. Trustee Amanda Pfruender made a motion to adopt Resolution 2024-09, "Rescinding Resolution 2023-12 Approving a Special Land Use" Trustee Tonya Roe seconded the motion. Roll Call. Yeas: Trustee Amanda Pfruender, Trustee Tonya Roe, Trustee Jeff Linton, Trustee Shawn Burger, Trustee Victoria Williams, Trustee Gina Hamilton, and President Tracey Jackson. Nays: None. Motion Carried. e. The MDOT Title VI Plan was reviewed by Council. Trustee Victoria Williams made a motion to adopt the annual Village of Farwell Title VI Non-Discrimination Plan Trustee Gina Hamilton seconded the motion. Roll Call. Yeas: Trustee Victoria Williams, Trustee Gina Hamilton, Trustee Amanda Pfruender, Trustee Tonya Roe, Trustee Jeff Linton, Trustee Shawn Burger, and President Tracey Jackson. Nays: None. Motion Carried. f. President Tracey Jackson appointed Margaret Brewer to a two-year term on the Planning Commission Trustee Victoria Williams made a motion to approve the appointment of Margaret Brewer to a two-year term on the Planning Commission Trustee Gina Hamilton seconded the motion. Motion Carried. g. DPW Summer Employment was discussed. Adrian will place the advertisement online and through Farwell Public Schools, with applications being due on Monday, April 1st. h. The purchase of a flail mower was reviewed by Council. Trustee Amanda Pfruender made a motion to approve the purchase of John Deere 25A Flail Mower with Heavy Duty Roller and 9in Offset, in the amount of $5,815.04 Trustee Shawn Burger seconded the motion. Roll Call. Yeas: Trustee Amanda Pfruender, Trustee Shawn Burger, Trustee Jeff Linton, Trustee Tonya Roe, Trustee Victoria Williams, Trustee Gina Hamilton, and President Tracey Jackson. Nays: None. Motion Carried. i. Review of Council Wages - tabled until the March 18th Council Meeting. j. A revision of the handbook was reviewed. Trustee Victoria Williams made a motion to strike out the following language under Section 2 - Holiday Pay, in the Employee Handbook: "so long as the holiday falls on a day in which the part time employee is scheduled to work" Trustee Amanda Pfruender seconded the motion. Roll Call. Yeas: Trustee Victoria Williams, Trustee Amanda Pfruender, Trustee Gina Hamilton, Trustee Tonya Roe, Trustee Jeff Linton, Trustee Shawn Burger, and President Tracey Jackson. Nays: None. Motion Carried. VIII. ADMINISTRATIVE REPORT a. Adrian asked for permission to waive $12.31 in tax fees for the County balancing, and Council gave permission to do so. IX. ZONING REPORT Page Page63ofof34  a. Zoning Administrator Julie Albright gave a zoning update to the Council. X. COMMITTEE REPORT a. Finance b. Parks & Rec - upcoming meeting on Thursday, March 7th. c. DPW - Adrian informed the Council per an update from Jason that the handrail for the Mill Pond is in the process of being galvanized and then we can schedule for it to be installed. d. Personnel XI. PRESIDENT DISCUSSION a. None. XII. ADDITIONAL REMARKS a. There was a question in regard to repairing torn up sod along some of the sidewalks. XIII. EXTENDED PUBLIC COMMENT a. None. XIV. ADJOURNMENT a. Trustee Victoria Williams made a motion to adjourn the meeting at 6:33pm Trustee Amanda Pfruender seconded the motion. Motion Carried. NEXT REGULAR COUNCIL MEETING ON MONDAY, MARCH 18, 2024 AT 6:00PM Clerk/Treasurer President Page Page74ofof34  VILLAGE OF FARWELL (MICHIGAN) SEWER FUND COMPARATIVE STATEMENT OF NET POSITION As Of 2/29/2020 2/28/2021 2/28/2022 2/28/2023 (----------------------------Per Audit----------------------------) Assets Current Assets: Cash $213,859 $188,401 $166,911 $91,548 Restricted Cash: USDA RRI Reserve - - 135,350 145,900 USDA Bond Reserve - - 44,000 44,000 Restricted Cash 160,307 162,245 - - Accounts Receivable 19,714 22,034 19,374 30,903 Prepaid Expenses 736 1,031 822 1,092 Total Current Assets 394,616 373,711 366,457 313,443 Non-Current Assets: Land 149,844 149,844 149,844 149,844 Construction in Process - - - 172,786 Machinery and Equipment 102,260 102,260 102,260 102,260 Water and Sewer Systems 3,690,283 3,690,283 3,690,283 3,690,283 Less: Accumulated Depreciation (2,056,825) (2,117,813) (2,178,310) (2,238,807) Total Non-Current Assets 1,885,562 1,824,574 1,764,077 1,876,366 Total Assets $2,280,178 $2,198,285 $2,130,534 $2,189,809 Deferred Outflows of Resources Related to Pension 1,746 3,311 822 522 Liabilities Current Liabilities: Accounts Payable $3,470 - $698 $38,246 Accrued Payroll and Liabilities 650 $963 971 $1,503 Accrued Interest 2,242 2,267 2,132 2,075 Current Portion of Long-Term Debt 15,000 16,000 16,000 17,000 Total Current Liabilities 21,362 19,230 19,801 58,824 Non-Current Liabilities: Revenue Bonds 618,000 602,000 586,000 569,000 Net Pension Liability 18,420 20,025 13,762 29,537 Total Non-Current Liabilities 636,420 622,025 599,762 598,537 Total Liabilities 657,782 641,255 619,563 657,361 Deferred Inflows of Resources Related to Pension 4,628 2,745 5,908 12,990 Net Position Net Investment in Capital Assets 1,252,562 1,206,574 1,162,077 1,290,366 Unrestricted 366,952 351,022 343,808 229,614 Total Net Position 1,619,514 1,557,596 1,505,885 1,519,980 Total Liabilities and Net Position $2,277,296 $2,198,851 $2,125,448 $2,177,341 Draft 03/12/2024 1 Page 8 of 34  VILLAGE OF FARWELL (MICHIGAN) SEWER FUND COMPARATIVE STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET POSITION Fiscal Year Ended 2/29/2020 2/28/2021 2/28/2022 2/28/2023 (----------------------------Per Audit---------------------------) Operating Revenues Charges for Services $194,591 $164,240 $165,669 $262,066 Operating Expenses Personnel Services 34,357 40,123 36,421 65,599 Professional Services 8,321 47,671 14,431 5,550 Office Supplies and Expense 1,385 1,110 1,633 1,636 Communications 4,020 5,345 6,896 7,750 Insurance 1,475 1,205 1,685 1,151 Operating Supplies and Expense 65,029 40,766 26,945 29,845 Utilities 36,411 36,928 34,191 39,607 Rental Expense 9,297 11,998 11,632 13,060 Subtotal 160,295 185,146 133,834 164,198 Depreciation 60,038 60,988 60,497 60,497 Total Operating Expenses 220,333 246,134 194,331 224,695 Operating Income (Loss) (25,742) (81,894) (28,662) 37,371 Non-Operating Revenues (Expenses) Interest Income 6,053 4,731 3,081 2,252 Grant Revenues 84,345 42,173 - - Interest Expense (27,449) (26,928) (26,130) (25,528) Total Non-Operating Revenues (Expenses) 62,949 19,976 (23,049) (23,276) Change in Net Position 37,207 (61,918) (51,711) 14,095 Net Position, Beginning of Year 1,582,307 1,619,514 1,557,596 1,505,885 Net Position, End of Year $1,619,514 $1,557,596 $1,505,885 $1,519,980 Draft 03/12/2024 2 Page 9 of 34  VILLAGE OF FARWELL (MICHIGAN) SEWER FUND COMPARATIVE DETAIL OF OPERATING EXPENSES Fiscal Year Ended 2/28/2022 2/28/2023 2/29/2024 2/28/2025 Test Year Multiplier (----------------------------Per Client----------------------------) Dept. 548 - Sewer Department 703.000 Salaries & Wages - Admin. $8,313 $11,844 $17,500 $18,500 $18,500 3.00% 703.001 Salaries & Wages - Maint. 16,103 17,766 25,000 30,000 30,000 3.00% 715.000 Social Security Tax - Admin. 1,871 2,194 2,300 3,200 3,200 3.00% 716.000 Blue Cross - Maint. 6,167 5,133 7,000 9,500 9,500 3.00% 716.001 Dental and Vision Insurance - - - 700 700 717.000 Pension Expense 5,142 3,473 3,700 5,000 5,000 3.00% 720.000 Workman's Comp. Insurance 1,500 1,500 1,500 1,700 1,700 3.00% 727.000 Office Supplies 740 584 1,000 1,200 1,200 3.00% 730.000 Postage 893 1,052 1,250 1,250 1,250 3.00% 740.000 Operating Supplies 2,705 2,938 3,000 3,800 3,800 3.00% 740.002 Operating Expenses - Lab Fees 7,161 10,008 9,500 10,000 10,000 3.00% 756.000 Miscellaneous Expenses 515 466 700 900 900 3.00% 756.002 Training - Sewer 1,526 1,262 1,500 1,500 1,500 3.00% 778.000 Equipment Repairs & Maint. 4,439 5,599 7,500 7,200 7,200 3.00% 779.000 Sewer Repairs & Maint. 1,216 2,476 10,000 9,500 9,500 3.00% 804.000 Legal Fees - 139 - - [1] - 0.00% 808.000 Auditing Services 2,000 2,500 3,750 4,800 4,800 3.00% 818.000 Contracted Services BSA 431 947 1,000 1,000 1,000 3.00% 818.001 Contracted Services 2,000 1,500 3,000 3,000 3,000 3.00% 818.002 Discharge Permit 3,650 3,650 3,800 8,000 8,000 3.00% 818.003 Engineering - Project 10,000 - - - [1] - 0.00% 818.009 Contracted Services - IT - 474 750 1,000 1,000 3.00% 850.000 Communications - Telephone 6,896 7,750 7,000 9,000 9,000 3.00% 900.000 Printing & Publishing 991 2,981 2,000 1,700 1,700 3.00% 910.000 Insurance 1,685 1,421 1,500 1,550 1,550 3.00% 920.000 Utilities 34,191 39,609 37,500 38,000 38,000 4.00% 943.000 Equipment Rental 11,632 13,060 14,000 18,000 18,000 3.00% 958.000 Membership & Dues 300 300 300 400 400 3.00% 968.000 Depreciation Expense - - - - [2] - 0.00% 977.000 Equipment Purchases 4,442 165 6,000 31,000 31,000 3.00% 996.000 Interest on Bonds - WWTP - - - - [3] - 0.00% Total Operating Expenses $136,510 $140,789 $172,050 $221,400 $221,400 [1] Current USDA project expenses are removed as these expenses will be reimbursed by the bond/grant. Page 10 of 34 [2] Depreciation expense is removed from this report as it is done on the cash basis. [3] Bond Interest is removed from this section of the report. These items are accounted for later in the report. Draft 03/12/2024 3  VILLAGE OF FARWELL (MICHIGAN) SEWER FUND SCHEDULE OF AMORTIZATION OF $569,000 PRINCIPAL AMOUNT OUTSTANDING OF 2005 WASTEWATER TREATMENT USDA BONDS Payment Principal Interest Debt Service Fiscal Year Date Balance Rate Principal Interest Total Total (In Dollars) (%) (------------------------------In Dollars------------------------------) 08/01/24 $569,000 $12,091.25 $12,091.25 02/01/25 569,000 4.25 $18,000 12,091.25 30,091.25 $42,182.50 08/01/25 551,000 11,708.75 11,708.75 02/01/26 551,000 4.25 19,000 11,708.75 30,708.75 42,417.50 08/01/26 532,000 11,305.00 11,305.00 02/01/27 532,000 4.25 19,000 11,305.00 30,305.00 41,610.00 08/01/27 513,000 10,901.25 10,901.25 02/01/28 513,000 4.25 20,000 10,901.25 30,901.25 41,802.50 08/01/28 493,000 10,476.25 10,476.25 02/01/29 493,000 4.25 21,000 10,476.25 31,476.25 41,952.50 08/01/29 472,000 10,030.00 10,030.00 02/01/30 472,000 4.25 22,000 10,030.00 32,030.00 42,060.00 08/01/30 450,000 9,562.50 9,562.50 02/01/31 450,000 4.25 23,000 9,562.50 32,562.50 42,125.00 08/01/31 427,000 9,073.75 9,073.75 02/01/32 427,000 4.25 24,000 9,073.75 33,073.75 42,147.50 08/01/32 403,000 8,563.75 8,563.75 02/01/33 403,000 4.25 25,000 8,563.75 33,563.75 42,127.50 08/01/33 378,000 8,032.50 8,032.50 02/01/34 378,000 4.25 26,000 8,032.50 34,032.50 42,065.00 08/01/34 352,000 7,480.00 7,480.00 02/01/35 352,000 4.25 27,000 7,480.00 34,480.00 41,960.00 08/01/35 325,000 6,906.25 6,906.25 02/01/36 325,000 4.25 28,000 6,906.25 34,906.25 41,812.50 08/01/36 297,000 6,311.25 6,311.25 02/01/37 297,000 4.25 30,000 6,311.25 36,311.25 42,622.50 08/01/37 267,000 5,673.75 5,673.75 02/01/38 267,000 4.25 31,000 5,673.75 36,673.75 42,347.50 08/01/38 236,000 5,015.00 5,015.00 02/01/39 236,000 4.25 32,000 5,015.00 37,015.00 42,030.00 08/01/39 204,000 4,335.00 4,335.00 02/01/40 204,000 4.25 34,000 4,335.00 38,335.00 42,670.00 08/01/40 170,000 3,612.50 3,612.50 02/01/41 170,000 4.25 35,000 3,612.50 38,612.50 42,225.00 08/01/41 135,000 2,868.75 2,868.75 02/01/42 135,000 4.25 37,000 2,868.75 39,868.75 42,737.50 08/01/42 98,000 2,082.50 2,082.50 02/01/43 98,000 4.25 38,000 2,082.50 40,082.50 42,165.00 08/01/43 60,000 1,275.00 1,275.00 02/01/44 60,000 4.25 40,000 1,275.00 41,275.00 42,550.00 08/01/44 20,000 425.00 425.00 02/01/45 20,000 4.25 20,000 425.00 20,425.00 20,850.00 Totals $569,000 $295,460.00 $864,460.00 $864,460.00 Note: Bonds are callable at anytime. Draft 03/12/2024 4 Page 11 of 34  VILLAGE OF FARWELL (MICHIGAN) SEWER FUND CASH FLOW ANALYSIS - CURRENT RATE STRUCTURE 2024/25 2025/26 2026/27 2027/28 2028/29 2029/30 Increases Assumptions Per Year Meter Equivalents 525 525 525 525 525 525 Ready-to-Serve Rate (Monthly) $22.89 $1.50 $24.39 $25.89 $27.39 $28.89 $30.39 Billable Flow (1,000 gal) 25,107 25,107 25,107 25,107 25,107 25,107 Consumption Charge (per 1,000 gal) $4.16 $0.50 $4.66 $5.16 $5.66 $6.16 $6.66 Customers Billed 24 24 24 24 24 24 Sewer Only Charge (Monthly) $43.69 $47.69 $51.69 $55.69 $59.69 $63.69 Typical Homeowner's Monthly Bill $43.69 $47.69 $51.69 $55.69 $59.69 $63.69 (assumes 5,000 gallons/month) Revenues Ready-to-Serve Charge Revenue $144,198 $153,648 $163,097 $172,546 $181,996 $191,445 Consumption Revenue 104,446 116,999 129,553 142,107 154,660 167,214 Sewer Only Revenue 12,583 13,735 14,887 16,039 17,191 18,343 Other Revenue 8,500 8,500 8,500 8,500 8,500 8,500 Total Revenue 269,727 292,882 316,037 339,192 362,347 385,502 Less: Total Operating Expenditures (221,400) (227,701) (234,927) (242,386) (250,085) (258,032) Net Operating Revenue 48,327 65,181 81,109 96,806 112,262 127,469 Less: Current Debt Service Payments (42,183) (42,418) (41,610) (41,803) (41,953) (42,060) Estimated Cash Funded RRI Reserve Requirement (15,865) (15,865) (15,865) (15,865) (15,865) (15,865) Estimated Debt Service #1 2024 USDA Bonds [1] (5,000) (27,000) (27,000) (27,000) (27,000) (27,000) Net Cash Flow ($14,721) ($20,102) ($3,366) $12,138 $27,444 $42,544 Cash & Investments [2] $239,452 $224,731 $204,629 $201,264 $213,402 $240,846 $283,390 Less: Debt Service Reserve [3] (44,000) (45,980) (47,960) (49,940) (51,920) (53,900) (55,880) Unrestricted and RRI Cash and Investments $195,452 $178,751 $156,669 $151,324 $161,482 $186,946 $227,510 [1] Estimated debt service payments based on a $794,000 40-year USDA bond issue at the poverty rate of (1.500%). The remaining $2,376,000 of the total project cost is assumed to be funded by a USDA grant, per the Letter of Conditions. [2] Includes unrestricted, RRI and bond reserve fund. Page 12 of 34 [3] Accumulated. Includes 2005 and 2024 bonds. Draft 03/12/2024 5  VILLAGE OF FARWELL (MICHIGAN) SEWER FUND CASH FLOW ANALYSIS - APARTMENTS BY UNIT 2024/25 2025/26 2026/27 2027/28 2028/29 2029/30 Increases Assumptions Per Year Meter Equivalents - Residential 525 502 502 502 502 502 Ready-to-Serve Rate (Monthly) - Residential $22.89 $1.50 $24.39 $25.89 $27.39 $28.89 $30.39 Meter Equivalents - Apartments 64 64 64 64 64 Ready-to-Serve Rate (Monthly) - Apartments $24.39 $25.89 $27.39 $28.89 $30.39 Billable Flow (1,000 gal) 25,107 25,107 25,107 25,107 25,107 25,107 Consumption Charge (per 1,000 gal) $4.16 $0.50 $4.66 $5.16 $5.66 $6.16 $6.66 Customers Billed 24 24 24 24 24 24 Sewer Only Charge (Monthly) $43.69 $47.69 $51.69 $55.69 $59.69 $63.69 Typical Homeowner's Monthly Bill $43.69 $47.69 $51.69 $55.69 $59.69 $63.69 (assumes 5,000 gallons/month) Revenues Ready-to-Serve Charge Revenue - Residential $144,198 $146,925 $155,961 $164,997 $174,033 $183,069 Ready-to-Serve Charge Revenue - Apartments - 18,732 19,884 21,036 22,188 23,340 Consumption Revenue 104,446 116,999 129,553 142,107 154,660 167,214 Sewer Only Revenue 12,583 13,735 14,887 16,039 17,191 18,343 Other Revenue 8,500 8,500 8,500 8,500 8,500 8,500 Total Revenue 269,727 304,891 328,785 352,678 376,572 400,465 Less: Total Operating Expenditures (221,400) (227,701) (234,927) (242,386) (250,085) (258,032) Net Operating Revenue 48,327 77,190 93,857 110,292 126,487 142,433 Less: Current Debt Service Payments (42,183) (42,418) (41,610) (41,803) (41,953) (42,060) Estimated Cash Funded RRI Reserve Requirement (15,865) (15,865) (15,865) (15,865) (15,865) (15,865) Estimated Debt Service #1 2024 USDA Bonds [1] (5,000) (27,000) (27,000) (27,000) (27,000) (27,000) Net Cash Flow ($14,721) ($8,093) $9,382 $25,625 $41,669 $57,508 Cash & Investments [2] $239,452 $224,731 $216,639 $226,021 $251,646 $293,315 $350,823 Less: Debt Service Reserve [3] (44,000) (45,980) (47,960) (49,940) (51,920) (53,900) (55,880) Unrestricted and RRI Cash and Investments $195,452 $178,751 $168,679 $176,081 $199,726 $239,415 $294,943 [1] Estimated debt service payments based on a $794,000 40-year USDA bond issue at the poverty rate of (1.500%). The remaining $2,376,000 of the total project cost is assumed to be funded by a USDA grant, per the Letter of Conditions. [2] Includes unrestricted, RRI and bond reserve fund. Page 13 of 34 [3] Accumulated. Includes 2005 and 2024 bonds. Draft 03/12/2024 6  ESTIMATE BLUTECH DATA sales@blutechdata.com 1839 Marathon Dr. 231.668.9009 Cadillac, MI 49601 www.blutechdata.com Village Of Farwell Bill to Ship to Village Of Farwell Village Of Farwell Adrian Krawczynski Village Of Farwell Adrian Krawczynski Estimate details Estimate no.: 1257 Estimate date: 03/05/2024 Expiration date: 04/30/2024 # Date Product or service SKU Qty Rate Amount 1. PtP 1 $1,500.00 $1,500.00 Ptp - wireless link 60 Ghz - secure encryption 2. misc materials 1 $200.00 $200.00 Misc materials wire management - wire - connectors ect. 3. Tier 1 General labor - 2 men 6 $135.00 $810.00 General labor - 2 men 4. Labor tier 3 - Programming / Configuration - Remote session 2 $125.00 $250.00 Labor tier 3 - Programming / Configuration - Remote session ( per man hour ) Subtotal $2,760.00 Ways to pay Sales tax $12.00 Total $2,772.00 Note to customer Expiry 50% deposit required to secure scheduling and balance due upon 04/30/2024 date completion. This estimate is for a secure connection to the dpw via wireless point to point. Page 14 of 34  ESTIMATE Hogger's Custom Sign & Design drew@hoggerscustoms.com 227 S. Harrison Ave. +1 (989) 539-4029 Harrison, MI 48625 www.hoggerscustoms.com Village of Farwell Bill to Adrian Krawczynski Village of Farwell Estimate details Estimate no.: 1376 Estimate date: 03/14/2024 # Date Product or service SKU Qty Rate Amount 1. SIGN RESTORATION 2 $1,600.00 $3,200.00 FULL SIZE WELCOME TO FARWELL Powerwash, strip, repair, and Repaint existing sandblasted sign using Chromatic brand enamel finishes. REPLACE EXISTING HARDWARE Total $3,200.00 Page 15 of 34 Page 16 of 34 Page 17 of 34 Page 18 of 34 Page 19 of 34 Page 20 of 34 Page 21 of 34 Page 22 of 34 Page 23 of 34 Page 24 of 34 Page 25 of 34 Page 26 of 34 Page 27 of 34 Page 28 of 34 Page 29 of 34 Page 30 of 34 Page 31 of 34 Page 32 of 34  Village of Farwell Treasurer’s Report as of 02/29/2024 ▪ Update on taxes collected as of February 29, 2024 ▪ Original Tax Roll: $286,749.77 ▪ Adjustments BOR: ($-2,588.44) ▪ Adjusted Original: $284,161.33 ▪ Interest added: $ 3,325.15 ▪ Total w/all adj.: $287,486.48 ▪ Collected to date: $241,481.54 ▪ Left to collect: $ 46,004.94 ▪ Percentage collected to Date: 84.0% Village Tax Roll 350,000.00 300,000.00 250,000.00 200,000.00 150,000.00 100,000.00 50,000.00 0.00 Adjusted Tax Roll Collected to Date Left to Collect Redistribution of Taxes from Village Operating Revenue ▪ Downtown Development Authority = $4,244.52 ▪ Local Development Finance Authority = $21,047.39 Page 33 of 34  DPW Committee Meeting Minutes March 14, 2024 5:30pm – Village Hall Council Meeting Room Call meeting to Order: The meeting was called to order at 5:30pm. Pledge of Allegiance. A roll call was conducted. Present: Trustee Shawn Burger and Trustee Amanda Pfruender. Absent: Trustee Jeff Linton. Also present: Clerk/Treasurer Adrian Krawczynski and DPW Supervisor Jason Walters. I. Old Business a. Jason let the committee know that the flail mower has been purchased and we are just waiting on it to arrive. b. Sidewalks were discussed. We are still waiting on the design for the Michigan St. project. c. Alleys were discussed. We are waiting for a quote to come through to present to Council. d. Bertha/Siegle Streets were discussed. We are waiting for a quote to come through to present to Council. II. New Business a. The committee reviewed two quotes for a new zero-turn mower. These will be brought to Council. b. The committee reviewed a quote for the repair of an aerator motor. This will be brought to Council. c. The committee reviewed two quotes for a rental of a dozer. Jason is going to reach out to the CCRC to see if the Village may borrow theirs if they are not using it. This will be brought to Council. d. The committee reviewed a quote for repairing the leaf vac. This will be brought to Council. e. The committee discussed selling an unused salt conveyor. This will be brought to Council. III. Additional Remarks: Adrian informed the committee that the Village has received 2 applications so far for the seasonal DPW position. Adrian is also preparing to apply for the MDOT Category B Grant. Jason informed the committee that Michels is looking to start removing the spoils from the drying site approximately the week of April 15th. He also informed the committee that the handrail is complete and installation will take place here shortly. The committee also discussed winter salt usage and the process of getting the DPW on the same server/drive as the office. IV. Complaints: V. Adjournment: 6:40 pm. VI. Next Meeting: Wednesday, April 10, 2024 at 5:30pm. Page 34 of 34