Board of Finance Regular Meeting Materials (linked)
agenda center agenda
| Board/Commission | Board of Finance |
|---|---|
| Meeting Date | March 16, 2022 |
| Pages | 49 |
| File Size | 2.6 MB |
| OCR Status | Searchable (OCR processed) |
| Source URL | Original |
Document Preview
Full Text (OCR Extracted)
PIFTEEN ROPE FERRY ROAD PHONE: 860-442-0553 WATERFORD, CT 06385-2886 www.waterfordct.org 11 UVa 2202 BOARD OF FINANCE AGENDA 02 38 AY Waterford Town Hall March 16, 2022 Regular Meeting 7:00 p.m. 1. Establishment of a quorum and call to order. 2. Public Comment. 3. Approval and acceptance of minutes from February 9, 2022 4. To consider and act on the following request from Director of Finance, Kimberly Allen, for an Appropriation request for UPS Systems Project from Capital and Non-Recurring from designated, line #20547-57747 (UPS System for Communications) in the amount of $10,915 and forward onto the RTM. 5. To consider and act on the following request from Director of Finance, Kimberly Allen, for an Appropriation request for Switches Project from Capital and Non-Recurring from designated line #20547-57861 (Switches) in the amount of $20,242 and forward onto the RTM. Board of Finance Agenda, March 16, 2022 Page 2 6. To consider and act on the following request from Tax Collector, Alan Wilensky, for an Out of Series transfer as follows pending approval from the Board of Selectmen: Account | Description Approved | Current Account Account Revised Budget Available | Increase | Decrease Available Amount’ | Budget Budget Amount | Amount 10106- | Clerical 82,334 26,955.92 . (900) 26,055.92 51210 Technical 10106- | Postage 6,000 93.08 900 993.08 52020 Total 900 (900) 7. Old Business: 8. New Business: 9. — Liaison Reports 10. Correspondence a. Christine Walters, Director of Human Resources, General Government Staffing Plan. b. Virginia Bielucki, Town Accountant, Periodic Financial Statements FY22 dated _ February 8, 2022. c. Virginia Bielucki, Town Accountant, Status of General Fund Unassigned Balance dated February 11, 2022. d. Virginia Bielucki, Town Accountant, Status of Contingency FY22 dated February 11, 2022. 11. Adjournment Glenn Patterson, Chairman FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 PHONE: 860-442-0553 www.waterfordct.org March 10, 2022 Mr. Glenn Patterson Chairman Board of Finance 15 Rope Ferry Road Waterford, CT 06385 Dear Chairman Patterson, The Board of Selectmen, at the meeting on Tuesday, February 15, 2022 voted to approve the following request for an appropriation request; Information Technology: To consider and act on the following request for an Appropriation request from Director of Finance, Kim Allen for UPS Systems Project from Capital and Non- recurring from designated, line 20547-57747 (UPS System for Communications) in the amount of $10,915 Therefore, I respectfully request that you consider and act on this request. I have attached pertinent back up material from the designated department. Sincerely, Roser Lrule Robert Brule First Selectman ce: Kimberly Allen, Director of Finance FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 PHONE: 860-442-0553 vevwaterfordetorg February 2, 2022 Board of Selectmen Town of Waterford 15 Rope Ferry Road Waterford, CT 06385 Re: FY22 Appropriation Request for the UPS Systems, Project 20547-57747 On behalf of the town’s Information Technology Department, I am requesting an appropriation in the amount of $10,915 from Capital and Non-recurring designated line 20547-57747 - Line Description (UPS System for Communication). The funds will be used to replace 7 UPS devices 9 batteries across town departments. Current quotes for the projects are attached. Regards, Kimberly Alew Kimberly Allen Director of Finance C: Jeff Robillard, IT Manager ee a mye, PY QOSIT-S TV UPS Devices and Battery Replacements. QTY5 APC-SMART-UPS 2200VA devices for the following locations Town Hall Basement Data Room (QTY 2) Community Center Server Rack Youth Center Basement Town Hall 2" Floor Data Room QTY 2 APC-SMART-UPS 1500VA devices for the following locations Town Hall Finance Office Registrar’s Office QTY 2 RBC 118 Batteries Town Hall 2TM Floor Data Closet QTY 5 RBC 117 Batteries Town Hall 2TM Floor Data Closet Safety Complex EOC Room Library Basement Data Room Muni Complex Data Room Community Center Data Rack QTY 2 RBC 110 Batteries IT Department Page 1 of 2 Customer Name: TOWN OF WATERFORD “}- Quote No: 22762229 Quote Name: Quotation Date: 02/01/2¢22 Sales Support Contact: Ed Howard Sales Support Phone: 603-263-3512 Sales Support Email: ehoward@eplus.com Account Executive: Steve Plante Account Executive Phone: 781-615-1322 ePlus . Account Executive Email: splante@eplus.com Customer PO No: Order No: Expiration Date: 04/15/2022 SMT2200RM2UC SCHNEIDER 1,465.05 APC SMART-UPS 2200VA LCD RM 2U 420V WITH SMARTCONNECT 7,325.25} SMC1500C SCHNEIDER SMART UPS CG 1500VA LCD 120V WITH SMARTCONNECT 502.95 1,005.90} Shipping: Packing: Page 1 of 2 Customer Name: TOWN OF WATERFORD Sales Support Contact: Eq Howard Customer PO No: “+. Quote No: 22762084 Sales Support Phone: 603-263-3512 Quote Name: Quotation Date: 02/01/2022 APCRBC 117 SCHNEIDER Sales Support Emait: ehoward@eplus.com Account Executive: Steve Plante Account Executive Phone: 781-615-1322 Account Executive Email: Splante@eplus.com ane Order No: Expiration Date: 04/15/2022 Shipping: Packing: APC REPLACEMENT BATTERY CARTRIDGE NUMBER 117 5 386.70 1,933.50 § 002 APCRBC118 SCHNEIDER REPLACEMENT BATTERY CARTRIDGE NO. 118 2 266.48 532.96 | 003 APCRBCTIG SCHNEIDER UPS REPLACEMENT BATTERY RBC110 117.06 FIFTEEN ROPE FERRY ROAD WATERFORB, CT 06385-2886 PHONE: 860-442-0553 www. waterfordct.org March 10, 2022 Mr. Glenn Patterson Chairman Board of Finance 15 Rope Ferry Road Waterford, CT 06385 Dear Chairman Patterson, The Board of Selectmen, at the meeting on Tuesday, February 15, 2022 voted to approve the following request for an appropriation request; Information Technology: To consider and act on the following request for an Appropriation request from Director of Finance, Kim Allen for Switches Project from Capital and Non- recurring from designated, line 20547-57861 (Switches) in the amount of $20,242. Therefore, | respectfully request that you consider and act on this request. I have attached pertinent back up material from the designated department. Sincerely, - Robert Lrule Robert Brule First Selectman ce: Kimberly Allen, Director of Finance FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 PHONE: 860-442-0553 wwwavaterfordet org February 3, 2022 Board of Selectmen Town. of Waterford 15 Rope Ferry Road Waterford, CT 06385 Re: FY22 Appropriation Request for the Switches, Project 20547-57861 On behalf of the town’s Information Technology Department, I am requesting an appropriation in the amount of $20,242 from Capital and Non-recurting designated line 20547-57861- Line Description (Switches). The funds will be used to replace 4 switches and related software across town departments. Current quotes for the projects are attached. Regards, Kimberly Affen Director of Finance C: Jeff Robillard, IT Manager Page 1 of 2 + Customer Name: TOWN OF WATERFORD Sales Support Contact: Ed Howard Customer PO No: Quote No: 22754092 Sales Support Phone: 603-263-3512 Order No: Quote Name: Sales Support Email: ehoward@eplus.com Expiration Date: 04/15/2022 Quotation Date: 01/14/2022 Account Executive: Steve Plante Account Executive Phone: 781-615-1322 ePlus Account Executive Email: splante@eplus.com External Contract CT-Cisco-18PSX0202 Notes: 001 C9200L-48P-4X-E CISCG CATALYST 9200L 48PT POE 4 X 10G NTWK ESS 4 70.01 2,933.00 11,732.00 002 CON-PSUT-C9200L4X CISCO PRTNR SUP 8X5XNBD CATALYST 9200L 48-PORT 4 30,50 485.81 1,943.24 003 C9200L-NW-E-48 cisco C9200L NETWORK ESSENTIALS, 48-PORT LICENSE 4 0.00 0.00 004 C9200L-DNA-E-48-3Y cisco C9200L DNA ESSENTIALS 48PT 3YR TERM LIC 4 47.20 794.90 3,179.60 005 CAB-TA-NA cIScO NORTH AMERICA AC TYPE A POWER CABLE 4 0.00 0.00 006 PWR-C5-BLANK CISCO © CONFIG 5 POWER SUPPLY BLANK 4 0.00 0.00 007 C9200L-DNA-E-48 cisco C9200L CISCO DNA ESSENTIALS, 48-PORT TERM 4 0.00 0.00 LICENSE 008 C9200L-STACK-KIT CISCO CATALYST $2001 STACK MOD 4 52.00 846.64 3,386.56 009 STACK-T4-50CM CISCO 50CM TYPE 4 STACKING CABLE 4 0.00 0.00 010 NETWORK-PNP-LIC cISCO NETWORK PLUG-N-PLAY CONNECT FOR ZERO- 4 0.00 0.00 TOUCH DEVICE DEPLOYMENT 011 C9200-STACK CISCO CATALYST 9200 STACK MODULE 8 0,00 0.00 Page 2 of 2 FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 PHONE: 860-442-0553 www.waterfordct.org March 10, 2022 Mr. Glenn Patterson Chairman Board of Finance 15 Rope Ferry Road Waterford, CT 06385 Dear Chairman Patterson, Subject toapproval at the Board of Selectmen meeting on Tuesday, March 15, 2022 for the ’ following request for an Out of Series Transfer; Tax Collector: To consider and act on the following request for an Out of Series Transfer from the Tax Collector, Alan Wilensky, in the amount of $900. I respectfully request that you consider and act on this request, subject to the Board of Selectmen’s approval. I have attached pertinent back up material from the designated department. Sincerely, Robert rule Robert Brule First Selectman cc: Kimberly Allen, Director of Finance Tax Collector DEPARTMENT Line No. Org. Code Object Code TOWN OF WATERFORD TRANSFER REQUEST FORM Out of Series Transfer Request Object Description APPROVED Budget Amount CURRENT Available Budget INCREAS ACCOUNT rd Quarter ACCOUNT SREAS REVISED Available Budget 1 10106 51210 Clerical Technical 82,334.00 26,955.92 (900) 26,055.92 10106 52020 Postage 6,000.00 93.08 900 993.08 0.00 0.00 0.00 0.00 0.00 0.00 oOo |SO IN Im ia [BR jo fe 0.00 —_ o 0.00 0.00 0.00 Explanation TOTAL 900 (900) This department utilizes a variety of delinquent statements in order to facilitate our extraordinary collection rate, currently standing at 99.25%. Postage has increased approximately 14% from the inception of this budget. Subsequently, this budget is about to be over-expended. | have additional funds in the Clerical/Technical line item as | did not hire a seasonal part-time employee for the January collection period. Alan Wilensky Depa ment Head Y vat A le a Director of Finance First Selectman Commission/Board Approval 3/8/2022 Date a\alaa. Date Date Date revised 9/9/20 kallen FOR 2022 13 ACCOUNTS FOR: 03/09/2022 09:40 101 GENERAL FUND is YEAR-TO-DATE BUDGET Town of Waterford, CT REPORT REVISED BUDGET P glytdbu ORIGINAL APPROP TRANS /ADJSMTS YTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET % USED 10106 TAX COLLECTOR 10106 51010 ELECTED OFFICIALS 86,286.00 0.00 86,286.00 58,739.57 0.00 27,546.43 68.1% 10106 51210 CLERICAL AND TECHNICAL 82,334.00 0.00 82,334.00 55,378.08 0.00 26,955.92 67.3% 10306 51810 OVERTIME 0.00 0.00 0.00 0.00 0.00 0.00 .0% 10106 51920 F.I.C.A. 12,900.00 0.00 12,900.00 8,259.67 0.00 4,640.33 64.0% 10106 52010 ADVERTISING 700.00 0.00 700.00 680.20 0.00 19.80 97.2% 40106 52020 POSTAGE 6,000.00 0.00 6,000.00 5,906.92 0.00 93.08 98.4% 10106 52030 PROFESSIONAL FEES 22,214.00 0.00 22,214.00 11,856.11 10,275.89 82.00 99.6% 10106 52040 SERVICE CONT. AND REPAIRS 1,178.00 0.00 1,178.00 663.30 432.02 82.68 93.0% 10106 52050 DUES, CONFERENCES & EDUCATION 195.00 0 195.00 140.00 0.00 55.00 71.8% 10106 53010 OFFICE SUPPLIES 35.00 65.00 100.00 78.81 0.00 21.19 78.8% 10106 54060 OFFICE EQUIPMENT 65.00 -65.00 0.00 0.00 0.00 0.00 -0% TOTAL TAX COLLECTOR 211,907.00 0.00 211,907.00 141,702.66 10,707.91 59,496.43 71.9% TOTAL GENERAL FUND 211,907.00 0.00 211,907.00 141,702.66 10,707.91 59,496.43 71.9% TOTAL EXPENSES 211,907.00 0.00 211,907.00 141, 702.66 10,707.91 59,496.43 FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 JO PHONE: 860-442-0553 www.waterfordct.org DATE: February 10, 2022 TO: Robert Brule First Selectman FROM: Christine Walters Cw RE: Director of Human Resources General Government Staffing Plan Enclosed is the Town’s staffing plan for General Government as of December 31, 2021 for the Board of Finance. Included in the packet are three (3) documents: the 5-year Staff Summary, the Staff Summary as of December 2021 and the Authorized Staffing Plan as of December 2021. Significant changes since December 2020 include: Finance Department: Three full-time Information Technology positions were transferred from the Board of Education to the Town and were added to the Finance Department. In addition, the Receptionist position was moved to the Youth & Family Services Department. Human Resources: A full-time Administrative Assistant position was added to the Human Resources Department when the combined Town and Board of Education HR Department split into two separate entities. Library: The full-time Computer Technical Assistant position was replaced with a full- time Information/Reference & Technical Assistant position. Youth & Family Services: Fully funded through “American Rescue Plan Funds”, a temporary full-time position, Human Services Coordinator, was added to the Youth & Family Services Department. In addition, the full-time Receptionist position from the Finance Department was moved to this Department. Please let me know if you would like additional information. Enclosures ce: Kimberly Allen (Finance Director) Board of Finance (8 copies) Town of Waterford 5 Year Staff Summary 2017 - 2021 DEPARTMENT December-17 -_December-18 December-19 December-20 December-21 Full Time| Part Time | Full Time] Part Time | Full Time| Part Time | Full Time] Part Time | Full Time] Part Time Bd of Selectmen 2 2 2 2 2 2 2 2 2 2 Reg of Voters 0 5 0 5 0 5 0 5 ) 4 Board of Finance 0 1 0 0 0 0 0 0 0 0 Assessor 3 2 3 1 3 1 3 1 3 1 Tax Collector (1) 2 1 2 4 2 1 2 1 2 1 Finance Dept. 7 1 7 1 7 4 7 1 9 1 Human Resources 2 1 2 1 2 1 2 1 3 0 Town Clerk 3 0 3 0 3 0 3 0 3 0 Planning & Zoning; Building 10 1 10 1 11 1 10 0 10 0 Economic Dev Comm 0 4 0 1 0 1 0 4 0 1 RTM 0 4 0 0 0 0 0 0 0 0 Flood & Erosion 0 1 0 1 0 1 0 1 0 1 Emergency Mgmt (2) 10 2 10 1 10 0 10 0 10 0 Fire Services (3) 13 1 13 1 15 1 15 1 15 4 Police Dept (4) 54 1 55 0 55 0 55 0 55 0 Public Works (5) 33 0 33 0 33 0 34 0 34 0 Utility Commission (6) 14 0 14 0 14 0 15 0 15 0 Sr Citizens Commission 4 14 4 14 4 12 4 12 4 12 Library (7) 11 10 11 10 11 10 11 10 11 10 Rec & Parks (8) 11 6 11 6 1 6 11 6 11 6 Youth & Family Services (9) 3 0 3 0 3 0 3 0 5 0 Full Time |Part Time |Full Time |Part Time |Full Time |Part Time |Full Time jPart Time |Full Time |Part Time TOTALS: 182 51 183 46 186 43 187 42 192 40 EMPLOYEE TOTALS: 233 229 229 229 232 (1) Seasonal Clerical (2) Part Time Dispatchers Work As Needed (3) Part Time and Volunteer Firefighters Work As Needed (4) Community Service Officers Work As Needed (5) Seasonal Workers (6) Seasonal Workers (7) Library Pages Work As Needed (8) Seasonal Workers & Summer Jobs For Minors (9) Seasonal Works and Camp DASH workers As Needed Board of Selectmen Registrar of Voters Board of Finance - Assessor Board of Assessment Appeals Tax Collector (Seasonal Clerical) Finance Department Human Resources Department Town Clerk Planning & Zoning and Building Department Economic Dev. Commission Flood & Erosion Emergency Management (PT Dispatchers as needed) Fire Services Staff Summary Employees Regularly on Payroll December 31, 2021 (Volunteers and PT Firefighters work as needed) Police Department *(Community Service Officers as needed) 2 Full Time 2 Part Time = 4 4 Part Time = 4 3 Full Time 1 Part Time = 4 (Once a year clerical help Performed by Assessment Aide III on an overtime Basis) 2 Full Time 1 Part Time = 3 9 Full Time 1 Part Time = 10 3 Full Time = 3 3 Full Time = 3 10 Full Time = 10 1 Part Time = 1 1 Part Time = 1 10 Full Time = 10 15 Full Time = 16 1 Part Time 55 Full Time = 55 Public Works Department 34 Full Time = 34 (2 Seasonal Maintenance Workers) Utility Commission 15 Full Time = 15 (3 Seasonal Wastewater Collection System Assts.) Senior Citizens’ Commission 4 Full Time 12 Part Time = 16 Library 11 Full Time **(Library Pages as needed) 10 Part Time = 21 Recreation & Parks 11 Full Time (2 Seasonal Maintenance Workers) 6 Part Time = 17 *** (Recreation Program Workers As Needed) *** (Summer Jobs For Minors As Needed) Youth Services Bureau 5 Full Time = 5 **** (Seasonal Workers and Camp DASH workers As Needed) Total Full Time 192 Total Part Time 40 TOTAL EMPLOYEES: 232 * The number of Community Service Officers varies depending on need, but none ever works more than an average of 19 hours/week. ** The number of Library Pages varies depending on need, but none ever works more than 10 hours in a week. The budget presumes an average of 5 pages working a combined total of 50 hours per week. *** The number of recreation program workers and summer jobs for minors workers varies depending on need. **** The number of seasonal workers and Camp DASH workers varies depending on need. TOWN OF WATERFORD —- GENERAL GOVERNMENT DEPARTMENT Board of Selectmen Registrar of Voters Board of Finance — Assessor Board of Assessment Appeals Tax Collector Finance Department Human Resources AUTHORIZED STAFFING PLAN DECEMBER 31, 2021 K.T. # POSITION P.T. HR/WK 1 Chief Executive FT 40 1 Executive Assistant FT 40 2 Other Selectmen PT 1 Republican PT 1 Democrat PT 2 Deputy Registrars PT 4 Clerical PT 1 Assessor (Vacant) FT 40 1 Assistant Assessor FT 40 1 Assessment Aide III FT 35 1 Assessor Aide I PT 19 (Once a year clerical help performed by the Assessment Aide III on an overtime basis.) 1 Elected FT 40 1 Accounts Receivable Clerk FT 35 1 Accounts Receivable Clerk PT 19 Seasonal Clerical 1 Finance Director FT 40 1 Treasurer PT 1 Purchasing Agent FT 40 1 Accountant FT 40 1 Administrative Assistant [ FT 35 1 Finance Technician FT 40 1 Printer FT 32.5 y | IT Manager FT 40 y | IT Support Engineer FT 40 1 PC Technician FT 40 4 Receptionist EF 35 1 Director of Human Resources FT 40 1 Administrative Assistant FT 40 1 Human Resources Asst. (Vacant) FT 40 4-___Seeretary/Clezk PRB) ________PF 4. DEPARTMENT Town Clerk Planning, Building & Health Economic Dev. Comm. Flood & Erosion Emergency Management Fire Services Police Department Ib — — NO RS Re es Ww UA ~~] lo Re — = SS eS ee Ee POSITION Elected Deputy Town Clerk Administrative Assistant | Planning Director Planner Environmental Planner Zoning Official Office Coordinator I Secretary I Secretary/Clerk Building Official Asst. Building Officials Secretary/Clerk Secretary/Clerk Emerg. Mgmt Supervisor Dispatchers PT Dispatchers Director of Fire Services Fire Marshal . Inspector Office Coordinator Clerk/Typist Firefighters Community Safety Educator Part Time Firefighters Chief of Police Lieutenants Sergeants Detectives Patrol Officers Includes: 2 Youth Officers, 1 Traffic Officer and 1 Court Officer Office Coordinator II Secretary I] Custodian II Accounts Receivable Clerk Secretary I —- Evening Data Technician II E.T. P.T. HR/WK FT 40 FT 35 FT = 35 FT 40 FT 40 FT 40 FT 40 FT = 35 FT 35 FT 35 FT 40 FT 40 PT PT FT = 40 FT 40 FT 40 FT 40 FT 40 FT = 35 FT 35 FT 50 PT 19 FT 40 FT 40 FT = 40 FT = 40 FT 40 FT 35 FT 35 FT 40 FT 35 FT 35 FT 35 Community Service Officers as needed -5- DEPARTMENT Public Works Department Utility Commission Senior Citizens’ Commission tk NN Re We WN FRB UW AWS eee 1 NO Oe NO ME NO ee roy ON Be Re RS eS POSITION Director Assistant Director General Foreman Floor Leader — Mechanics Municipal Facilities Manager Maintainer IV Maintainer II Maintainer IT (2 Vacant) Traffic Control Dev. Tech. Toolkeeper Recycling Route Operator Mechanic Assistant Mechanic Refuse Truck Driver Office Coordinator II Clerk Typist HI Seasonal Maintenance Workers Chief Engineer Assistant Director Assistant Construction Inspector Survey Party Chief Foreman Leadman Maintenance Operator Sewer Maintenance Operator Sewer Technician 2 Sewer Technician 1 Office Coordinator IT Accounts Receivable Clerk Secretary/Clerk F.T. Seasonal Wastewater Collection System Assistants Director of Senior Services Assistant Director Senior Services Assistant Office Support Technician Senior Services Clerk Community Café Manager Driver Meals on Wheels (4 Vacant) Secretary/Clerk (Commission) Enrollment Clerk seasonal as needed Seasonal Instructors as needed P.T. HR/WK FT 40 FT 40 FT 40 FT 40 FT = 40 FT 40 FT 40 FT 40 FT 40 FT = 40 FT 40 FT 40 FT 40 FT 40 FT 35 FT = 35 FT 40 FT 40 FT 40 FT = 40 FT = 40 FT 40 FT = 40 FT 40 FT = 40 FT 35 FT 35 FT = 35 FT = 40 _FT = 40 FT 35 FT = 35 PT 19 PT 19 PT 19 PT PT F.T. DEPARTMENT # POSITION P.T. HR/WK Library 1 Director FT 40 1 Dept. Head — Tech & Circ. Services FT 40 1 Dept. Head — Children’s FT 40 1 Dept. Head — Adult Services FT 40 1 Department Assistant -Adult FT = 40 1 Secretary I FT 35 4—____Computer Technical Assistant _—___E35. 7 | Info/Ref Tech Asst (Vacant) FT 35 3 Technician II FT 35 1 Buildings & Grounds Manager FT 40 2 Info Ref Asst — Adult PT 2 Info Ref Asst - Children (1 Vacant) PT 3 Technician I PT 1 Technician I - Graphics PT 2 Custodian II PT Dept. Assistant, Tech I and Custodian II substitutes as needed. Library Pages as needed. Recreation & Parks 1 Director FT 40 1 Assistant Director FT 40 1 Program Coordinator (Vacant) FT 40 1 Office Coordinator I FT 35 1 Maintainer IV FT 40 2 Maintainer ITI FT 40 3 Maintainer II FT 40 1 Maintainer I FT 40 1 Clerk Typist I PT 19 1 Custodian PT 19 3 Community Center Monitors PT 1 Clerk PT 2 Seasonal Maintenance Workers Recreation Program Workers as needed. Summer Jobs For Minors as needed. Youth & Family Services 1 Youth & Family Services Director FT 40 1 Human Services Coordinator FT 40 1 Program Coordinator FT 40 1 Secretary/Clerk FT 35 1 Receptionist FT 35 Seasonal Workers (after school programs) as needed. Camp D.A.S.H. Workers as needed. Grant funded Seasonal Workers (weekend programs) as needed. Py dns /0 ti FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 PHONE: 860-442-0553 www.waterfordct.org Date: February 8, 2022 To: The Members of the Board of Finance From: |The Town Accountant Subject: Periodic Financial Statements Enclosed are the latest financial statements. If you have any questions, please call. Thank you, Virginié Bielucki — Enclosures: General Fund-Statement of Revenues and Statement of Expenditures Fleet Management-Statement of Revenues and Expenditures Capital and Non-recurring Fund-Statement of Fund Balance Designations and Appropriations Capital Improvement Fund-Expenditures Capital Projects Funds-Expenditures Contributed Gifts Fund-Balances Insurance Administration Fund- Balance Sheet TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 FAVORABLE (UNFAVORABLE) FISCAL FISCAL FISCAL FISCAL YEAR YEAR YEAR YEAR 2021-2022 2021-2022 2021-2022 2020-2021 BUDGET ACTUAL VARIANCE ACTUAL STATE OF CONNECTICUT EDUCATION EQUALIZED COST SHARING $326,444 $163,222 (163,222) $163,222 HEALTH & WELFARE $6,000 $6,659 659 $6,359 SUB TOTAL 332,444 169,881 (162,563) 169,581 GENERAL GOVERNMENT PILOT-STATE-OWNED PROPERTY 143,075 0 (143,075) 143,075 PILOT-DISABLED 1,873 1,879 6 1,919 PILOT-PRIVATE TAX EXEMPT PROPERTY 109,838 0 (109,838) 109,838 TIERED PILOT 0 235,221 235,221 0 TAX RELIEF-VETERANS 8,148 6,570 (1,578) 8,503 COURT FINES 5,000 0 (5,000) 2,297 CIVIL PREPAREDNESS 2,500 40,686 38,186 19,823 TELECOMMUNICATIONS PROPERTY TAX 58,656 0 (58,656) 0 TOWN AID ROADS-IMPROVED 317,277 316,431 (846) 317,277 LOCAL CAPITAL IMPROVEMENT (LOCIP) 0 117,757 117,757 0 SDE STATE GRANT 14,000 7,093 (6,907) 10,642 ENHANCEMENT 911 21,996 18,579 (3,417) 16,612 MISCELLANEOUS STATE REVENUE 0 0 0 0 MUNICIPAL REVENUE SHARE GRANT 0 83,589 83,589 0. GRANTS FOR MUNICIPAL PROJECTS 34,255 0 (34,255) 0 COVID RELIEF FUND REIMBURSEMENT 0 0 0 106,000 TOTAL GENERAL GOVERNMENT 716,618 827,806 111,188 735,986 TOTAL STATE OF CONNECTICUT 1,049,062 997,687 (51,375) 905,567 OTHER SOURCES EDUCATION TUITION 195,680 71,334 (124,346) 110,910 RENT & MISCELLANEOUS 5,910 3,969 (1,941) 0 SUB TOTAL 201,590 75,303 (126,287) 110,910 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 FAVORABLE (UNFAVORABLE) FISCAL FISCAL FISCAL FISCAL YEAR YEAR YEAR YEAR 2021-2022 2021-2022 2021-2022 2020-2021 BUDGET ACTUAL ‘VARIANCE ACTUAL GENERAL GOVERNMENT INTEREST & LIENS 407,280 154,994 (252,286) 160,332 INTEREST ON INVESTMENTS 120,000 56,744 (63,256) 52,081 RECREATION & PARKS 220,000 156,577 (63,423) 46,246 COMMUNITY USE OF SCHOOLS 0 100 100 0 BUILDING INSPECTOR 357,237 323,381 (33,856) 302,690 LICENSE, FEE, PERMIT, FINE 36,727 17,241 (39,486) 18,643 LIBRARY 16,810 0 (16,810) 0 WATER MAIN ASSESSMENTS 1,200 403 (797) 363 SALE OF EQUIPMENT 0 557 557 2,679 SCRRRA REBATE ; 0 2,487 2,487 7,814 NL RADIO COMM. NETWORK USE FEE 81,000 72,221 (8,779) 81,237 ALARM PENALTIES 0 50 50 100 BULKY WASTE FEES 72,851 65,091 (7,760) 61,865 MISCELLANEOUS 69,312 36,030 (33,282) 81,934 CONVEYANCE TAX 200,000 269,683 69,683 259,357 EMS-REG COMM CTR FEES 6,000 1,500 (4,500) 1,500 SEWER ASSESSMENTS 0 555 555 6,309 PLANNING& ZONING, ZBA, CONSRV COMM 40,062 25,181 (14,881) 44,620 TOWN CLERK FEES 200,000 141,638 (58,362) 145,734 LIENS -COLLECTED BY UTILITY COMMISSION 10,000 0 (10,000) 4,240 TIPPING FEES 319,083 134,091 (184,992) 156,342 RECYCLING 35,562 28,507 (7,055) 25,711 COST SHARING PRR 0 83,722 83,722 0 TRANSFERS FROM OTHER FUNDS 0.00 5,814 5,814 0 TRANSFERS IN-PY ENCUMBRANCES 1,000 650 (350) 6,152 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 9,159 (841) 8,587 AMBULANCE OPERATING SUBSIDY 12,000 6,000 (6,000) 7,000 YSB BOE CLERICAL STIPEND 5,000 5,000 0 5,000 RENTAL OF BUILDINGS 105,950 69,409 (36,541) 115,186 SENIOR SERVICES 15,820 22,049 6,229 4,694 VERSA KART/BLUE BOXES 5,370 7,090 1,720 5,140 BOE HUMAN RESOURCES OFFSET 15,119 0 (15,119) 16,119 CIRMA MEMEBERS EQUITY DISTRIBUTION 0 96,057 96,057 37,305 SUB TOTAL 2,383,383 1,791,982 (591,401) 1,664,980 TOTAL OTHER SOURCES 2,584,973 1,867,285 (717,688) — 1,775,890 PROPERTY TAXATION CURRENT PROPERTY TAX 92,787,059 91,419,684 (1,367,375) 88,141,988 PRIOR YEAR TAXES 584,450 16,849 (567,601) 214,739 TOTAL PROPERTY TAXATION 93,371,509 91,436,532 (1,934,977) 88,356,727 TOTAL REVENUES 97,005,544 94,301,504 (2,704,040) 91,038,184 STATE OF CONNECTICUT EDUCATION EQUALIZED COST SHARING HEALTH & WELFARE SUB TOTAL GENERAL GOVERNMENT PILOT-STATE-OWNED PROPERTY PILOT-DISABLED PILOT-PRIVATE TAX EXEMPT PROPERTY TIERED PILOT TAX RELIEF-VETERANS COURT FINES CIVIL PREPAREDNESS TELECOMMUNICATIONS PROPERTY TAX TOWN AID ROADS-IMPROVED LOCAL CAPITAL IMPROVEMENT (LOCIP) SDE STATE GRANT ENHANCEMENT 911 MISCELLANEOUS STATE REVENUE MUNICIPAL REVENUE SHARE GRANT GRANTS FOR MUNICIPAL PROJECTS COVID RELIEF FUND REIMBURSEMENT TOTAL GENERAL GOVERNMENT TOTAL STATE OF CONNECTICUT OTHER SOURCES EDUCATION TUITION RENT & MISCELLANEOUS SUB TOTAL TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2021-2022 YEAR YEAR 2021-2022 2021-2022 PERCENT 2021-2022 2020-2021 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL $326,444 $163,222 50.00% (163,222) $163,222 $6,000 $6,659 110.98% 659 $6,359 332,444 169,881 51.10% (162,563) 169,581 143,075 0 0.00% (143,075) 143,075 1,873 1,879 100.34% 6 1,919 109,838 0 0.00% (109,838) 109,838 0 235,221 #DIV/0! 235,221 0 8,148 6,570 80.63% (1,578) 8,503 5,000 0 0.00% (5,000) 2,297 2,500 40,686 1627.42% 38,186 19,823 58,656 0 0.00% (58,656) 0 317,277 316,431 99.73% (846) 317,277 0 117,757 #DIV/0! 117,757 0 14,000 7,093 50.66% (6,907) 10,642 21,996 18,579 84.47% (3,417) 16,612 0 0 #DIV/0! 0 0 0 83,589 ~#DIV/0! 83,589 0 34,255 0 0.00% (34,255) 0 0 0 #DIV/0! 0 106,000 716,618 827,806 115.52% 111,188 735,986 1,049,062 997,687 95.10% (51,375) 905,567 195,680 71,334 36.45% (124,346) 110,910 5,910 3,969 67.16% (1,941) 0 201,590 75,303 37.35% (126,287) 110,910 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2021-2022 YEAR YEAR 2021-2022 2021-2022 PERCENT 2021-2022 2020-2021 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL GENERAL GOVERNMENT INTEREST & LIENS 407,280 154,994 38.06% (252,286) 160,332 INTEREST ON INVESTMENTS 120,000 56,744 47.29% (63,256) 52,081 RECREATION & PARKS 220,000 156,577 71.17% (63,423) 46,246 COMMUNITY USE OF SCHOOLS 0 100 #DIVv/0! 100 0 BUILDING INSPECTOR 357,237 323,381 90.52% (33,856) 302,690 LICENSE, FEE, PERMIT, FINE 56,727 17,241 30.39% (39,486) 18,643 LIBRARY 16,810 0 0.00% (16,810) 0 WATER MAIN ASSESSMENTS 1,200 403 33.59% (797) 363 SALE OF EQUIPMENT 0 557 #DIV/0! 557 2,679 SCRRRA REBATE 0 2,487 #DIV/0! 2,487 7,814 NL RADIO COMM. NETWORK USE FEE 81,000 72,221 89.16% (8,779) 81,237 ALARM PENALTIES 0 50 #DIV/0! 50 100 BULKY WASTE FEES 72,851 65,091 89.35% (7,760) 61,865 MISCELLANEOUS 69,312 36,030 51.98% (33,282) 81,934 CONVEYANCE TAX 200,000 269,683 134.84% 69,683 259,357 EMS-REG COMM CTR FEES 6,000 1,500 25.00% (4,500) 1,500 SEWER ASSESSMENTS 0 555 #DIV/0! 555 6,309 PLANNING& ZONING, ZBA, CONSRV COMM 40,062 25,181 62.86% (14,881) 44,620 TOWN CLERK FEES 200,000 141,638 70.82% (58,362) 145,734 LIENS -COLLECTED BY UTILITY COMMISSION 10,000 0 0.00% (10,000) 4,240 TIPPING FEES 319,083 134,091 42.02% (184,992) 156,342 RECYCLING 35,562 28,507 80.16% (7,055) 25,711 COST SHARING PRR 0 83,722 #DIV/0! 83,722 0 TRANSFERS FROM OTHER FUNDS 0.00 5,814 #DIV/0! 5,814 0 TRANSFERS IN-PY ENCUMBRANCES 1,000 650 65.00% (350) 6,152 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 9,159 91.59% (841) 8,587 AMBULANCE OPERATING SUBSIDY 12,000 6,000 50.00% (6,000) 7,000 YSB BOE CLERICAL STIPEND 5,000 5,000 100.00% 0 5,000 RENTAL OF BUILDINGS 105,950 69,409 65.51% (36,541) 115,186 SENIOR SERVICES 15,820 22,049 139.37% 6,229 4,694 VERSA KART/BLUE BOXES 5,370 7,090 132.03% 1,720 5,140 BOE HUMAN RESOURCES OFFSET 15,119 0 0.00% (15,119) 16,119 CIRMA MEMEBERS EQUITY DISTRIBUTION 0 96,057 #DIV/0! 96,057 37,305 SUB TOTAL 2,383,383 1,791,982 75.19% (591,401) 1,664,980 TOTAL OTHER SOURCES 2,584,973 1,867,285 72.24% (717,688) 1,775,890 PROPERTY TAXATION CURRENT PROPERTY TAX 92,787,059 91,419,684 98.53% (1,367,375) 88,141,988 PRIOR YEAR TAXES 584,450 16,849 2.88% (567,601) 214,739 TOTAL PROPERTY TAXATION 93,371,509 91,436,532 97.93% (1,934,977) 88,356,727 TOTAL REVENUES 97,003,544 94,301,504 97.21% (2,704,040) 91,038,184 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 FISCAL YEAR2022 FISCAL YEAR2022 FISCAL YEAR2022 VARIANCE FISCAL YEAR FAVORABLE 2020-2021 APPROPRIATED ACTUAL (UNFAVORABLE) ACTUAL GENERAL GOVERNMENT Board of Selectmen $229,313 $138,575 90,738 $112,910 Registrar of Voters $74,508 $49,376 25,132 $45,471 Board of Finance $65,547 $62,890 2,657 $59,316 Assessor $291,847 $237,342 54,505 $160,948 Board of Assessment Appeals $1,620 $375 1,245 $243 Tax Collector $211,907 $130,369 81,538 $125,343 Finance Department $653,894 $442,555 211,339 $379,727 Legal Department $298,000 $140,067 157,933 $132,029 Town Clerk $269,750 $165,063 104,687 $164,629 Planning and Zoning $634,914 $337,376 297,538 $360,500 Building Maintenance $778,870 $435,900 342,970 $119,993 Insurance $4,795,176 $4,650,139 145,037 $1,176,412 Economic Development Commission $10,076 $7,328 2,748 $7,043 Conservation Commission $18,250 $13,216 5,034 $13,130 Zoning Board of Appeals $4,310 2,872 1,438 2,126 Retirement Commission $5,682,906 $3,582,121 2,100,785 $4,104,582 R.T.M. $18,903 $14,619 4,284 $9,286 Building Department $293,008 $132,855 160,153 $132,876 Youth Service Bureau $299,359 $174,438 124,921 $135,665 Social Service Grants/Miscellaneous $82,366 $78,144 4,222 $74,663 Contingency Fund $86,313 0 86,313 0 Emergency Management $1,052,665 $541,686 510,979 $572,257 Fire Services $3,321,034 $2,224,124 1,096,910 $2,075,305 Police Department $6,303,434 $3,544,662 2,758,772 $3,761,523 Public Works Department $4,709,654 $3,048,276 1,661,378 $2,844,455 Conservation of Health $142,282 142,282 0 139,197 Public Health Nursing $27,820 7,917 19,903 | 2,520 Senior Citizens Commission $491,489 $263,191 228,298 $250,410 Waterford Public Library $999,475 $568,066 431,409 $658,443 Page 1 of 2 . GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 Page 2 of 2 FISCAL YEAR2022 VARIANCE FISCAL YEAR FISCAL YEAR2022 FISCAL YEAR2022 FAVORABLE 2020-2021 APPROPRIATED ACTUAL (UNFAVORABLE) ACTUAL Recreation and Parks $1,445,409 $908,607 536,802 $731,730 Flood and Erosion Control Bd. $2,138 394 1,744 146 Ethics Commission $850 156 694 219 Human Resources $265,664 $147,274 118,390 $149,355 Community Use of Schools $0 $0 0 $86,126 Information Technology $930,585 $825,806 104,779 $735,917 Transfer to Waterford Week Activity Fund $4,750 $4,750 0 $4,750 Transfer to Waterford Shellfish Fund $2,000 $2,000 $1,664 Transfer to Capital Improvement Fund $2,964,754 $2,964,754 $2,228,530 Transfer to Capital & Non-Recurring Fund $2,700,600 $2,700,600 $1,401,280 Transfer to Dog Fund $60,000 $60,000 $30,000 Debt Service $7 934,633 $6,597,391 $6,275,576 Total General Government $48,160,073 $35,347,556 $12,812,517 $29,266,295 Board of Education $50,645,471 $28,844,662 $21,722,728 Total General Fund $98,805,544 $64,192,218 $34,613,326 $50,989,023 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 GENERAL GOVERNMENT Board of Selectmen Registrar of Voters Board of Finance Assessor Board of Assessment Appeals Tax Collector Finance Department Legal Department Town Clerk Planning and Zoning Building Maintenance Insurance Economic Development Commission Conservation Commission Zoning Board of Appeals Retirement Commission R.T.M. Building Department Youth Service Bureau Social Service Grants/Miscellaneous Contingency Fund Emergency Management Fire Services Police Department Public Works Department Conservation of Health Public Health Nursing Senior Citizens Commission Waterford Public Library Page 1 of 2 FISCAL YEAR2022 FISCAL YEAR2022 VARIANCE FISCAL YEAR FISCAL YEAR2022 FISCAL YEAR2022 PERCENT FAVORABLE 2020-2021 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL $229,313 $138,575 60.43% 90,738 $112,910 $74,508 $49,376 66.27% 25,132 $45,471 $65,547 $62,890 95.95% 2,657 $59,316 $291,847 $237,342 81.32% 54,505 $160,948 _ $1,620 $375 23.15% 1,245 $243 $211,907 $130,369 61.52% 81,538 $125,343 $653,894 $442,555 67.68% 211,339 $379,727 $298,000 $140,067 47.00% 157,933 $132,029 $269,750 $165,063 61.19% 104,687 $164,629 $634,914 $337,376 53.14% 297,538 $360,500 $778,870 $435,900 55.97% 342,970 $119,993 $4,795,176 $4,650,139 96.98% 145,037 $1,176,412 $10,076 $7,328 72.73% 2,748 $7,043 $18,250 $13,216 72.42% 5,034 $13,130 $4,310 2,872 66.64% 1,438 2,126 $5,682,906 $3,582,121 63.03% 2,100,785 $4,104,582 $18,903 $14,619 77.34% 4,284 $9,286 $293,008 $132,855 45.34% 160,153 $132,876 $299,359 $174,438 58.27% 124,921 $135,665 $82,366 $78,144 94.87% 4,222 $74,663 $86,313 0 0.00% 86,313 0 $1,052,665 $541,686 51.46% 510,979 $572,257 $3,321,034 $2,224,124 66.97% 1,096,910 $2,075,305 $6,303,434 $3,544,662 56.23% 2,758,772 $3,761,523 $4,709,654 $3,048,276 64.72% 1,661,378 $2,844,455 $142,282 142,282 100.00% 0 139,197 $27,820 7,917 28.46% 19,903 2,520 $491,489 $263,191 53.55% 228,298 $250,410 $999,475 $568,066 56.84% 431,409 $658,443 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2021-2022, THROUGH JANUARY 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH JANUARY 31, 2021 FISCAL YEAR2022 FISCAL YEAR2022 VARIANCE FISCAL YEAR FISCAL YEAR2022 FISCAL YEAR2022 PERCENT FAVORABLE 2020-2021 APPROPRIATED ACTUAL EXPENDED (ONFA VORABLE) ACTUAL Recreation and Parks $1,445,409 $908,607 62.86% 536,802 $731,730 Flood and Erosion Contro! Bd. $2,138 394 18.43% 1,744 146 Ethics Commission $850 156 18.35% 694 219 Human Resources $265,664 $147,274 55.44% 118,390 $149,355 Community Use of Schools $0 $0 0.00% 0 $86,126 Information Technology $930,585 $825,806 88.74% 104,779 $735,917 Transfer to Waterford Week Activity Fund $4,750 $4,750 100.00% 0 $4,750 Transfer to Waterford Shellfish Fund $2,000 $2,000 100.00% 0 $1,664 Transfer to Capital Improvement Fund $2,964,754 $2,964,754 100.00% 0 $2,228,530 Transfer to Capital & Non-Recurring Fund $2,700,600 $2,700,600 100.00% 0 $1,401,280 Transfer to Dog Fund $60,000 $60,000 100.00% 0 $30,000 Debt Service $7,934,633 $6,597,391 83.15% 1,337,242 $6,275,576 Total General Government $48,160,073 $35,347,556 73.40% $12,812,517 $29,266,295 Board of Education $50,645,471 $28,844,662 56.95% 21,800,809 $21,722,728 Total General Fund $98,805,544 $64,192,218 64.97% $34,613,326 $50,989,023 Page 2 of 2 TOWN OF WATERFORD STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE FLEET MANAGEMENT FUND AS OF JANUARY 31, 2022 t Revenues: Investment Income Vehicle Rentals Sale of Vehicles Sale of Equipment Total Revenues Expenditures; - Equipment Replacement Vehicle Replacement Total Expenditures Excess (Deficiency) of Revenues Over Expenditures Other Financing Sources (Uses): Transfers from other funds Total Other Financing Sources (Uses) Net Change in Fund Balances Fund Balances - Beginning Fund Balances - Ending 1,857 92,525 39,415 510 134,307 273,197 625,550 898,747 (764,440) 800,000 800,000 35,560 2,650,669 2,686,229 20501-57639 20507-57776 20507-57790 20510-57830 20510-57864 20511-57767 20511-57788 20511-57805 20511-57839 20511-57840 20511-57856 20511-57857 20511-57866 ere 20522-57794 20523-57733 20523-57792 20523-57791 20523-57826 20523-57836 20523-57838 20530-57695 20530-57815 20530-57832 20530-57855 20531-55771 20531-57685 20531-57766 20531-57802 20531-57816 20531-57817 20536-57848 20537-57735 20537-57781 20537-57795 20537-57824 20537-57854 REVALUATION FIBER INSTALL MUNICPAL COMPLEX WIFI TOWN-WIDE WIRING THAMES RIVER MARINA DOCK SYSTEM CRYSTAL MALL REDEVELOPMENT FEASIBLITY STUDY NEVINS COTTAGE STRUCTURAL REPAIRS COMMUNITY CENTER HVAC CONTROL SEPARATION YSB FLOORING TOWN HALL EMERGENCY EGRESS PLAN OF CONSERVATION DEVELOPMENT JORDAN VILLAGE SIDEWALKS CIVIC TRIANGLE UPGRADES TOWN HALL FRONT DOOR Ye) ’ OSWEGATCHIE FIRE BUILDING IMPROVEMENTS OSWEGATCHIE-BUILDING RENOVATIONS erence CAL UPGRADE-JORDA JORDAN-TRAFFIC LIGHT UPGRADE FIRE SERVICES HYDRAULIC EQUIPMENT FIRE SERVICES CARPET REPLACEMENT FIRE SERVICES PRE EMPTION LIGHT REPAIRS MUNICIPAL COMPLEX RENOVATION MUNICIPAL COMPLEX CLEAN UP REDESIGN/RECONSTRUCT GARDINERS WOOD ROAD LED STREETLIGHT CONVERSION BRAMAN ROAD REDESIGN/RECONSTR HARVEY AVENUE PUMP STATION REHAB Ul MITIGATION & CONTROL WASTEWATER SCADA SYSTEM UPGRADE FORCE MAIN AIR RELEASE VALVES-EVALUATE & REPLACE OLD NORWICH/EVERGREEN/HARVEY AVE PUMP STATION REHAB WASTEWATER PS FLOOD PROTECTION LIBRARY HVAC UPGRADE LEARY PARK ROAD /PARKING LOT WATERFORD BEACH PAVILION RESTROOM WBP CAUSEWAY BRIDGE WBP CAUSEWAY BRIDGE FABRICATION WTFD BEACH PARK IMPROVEMENTS : SOUS MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF JANUARY 31, 2022 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL ($24,621.46) $257,700.00 $0.00 $233,078.54 $0.00 $0.00 $14,808.85 $14,808.85 $0.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 $227.75 $227.75 $250,000.00 $0.00 $0.00 $250,000.00 $20,715.00 $100,000.00 $0.00 $120,715.00 $49,800.00 $0.00 $0.00 $49,800.00 $0.00 $0.00 $45,611.44 $45,611.44 $36,700.00 $0.00 $0.00 $36,700.00 $100,000.00 $0.00 $0.00 $100,000.00 $404,000.00 $0.00 $0.00 $404,000.00 $17,820.00 $0.00 $0.00 $17,820.00 $0.00 $0.00 $32,355.00 $500.00 $213,700.00 $1,000,000.00 $1,990,000.00 $40,175.25 $0.00 $25,000.00 $17,622.76 $19,000.00 $0.00 $30,000.00 $0.00 $50,000.00 $321,781.07 $6,100,833.00 pe nee $2,592.07 $0.00 $83,447.00 $0.00 $17,131.80 $0.00 $22,596.67 $0.00 $19,422.12 $0.00 $310,985.86 $0.00 $0.00 $0.00 $0.00 $43,000.00 $5,438.00 $544,000.00 $30.10 $85,000.00 $0.00 $545,600.00 $0.00 $20,000.00 $0.00 $0.00 $0.00 $25,000.00 $0.00 $61,700.00 $0.00 $30,000.00 Page 1 $1,154.55 $0.00 $0.00 $0.00 $32,355.00 iat $740,165.0 $1,000,500.00 $2,203,700.00 $40,175.25 $25,000.00 $36,622.76 $30,000.00 $50,000.00 $6,422,614.07 00, $2,592.07 $83,447.00 $17,131.80 $22,596.67 $19,422.12 $310,985.86 $0.04 $43,000.00 $549,438.00 $85,030.10 $545,600.00 $20,000.00 $1,154.55 $25,000.00 $61,700.00 $30,000.00 20541-57328 20547-57747 20547-57846 20547-57847 20547-57860 20547-57861 ISSUE nan 20560-57822 20560-57823 20560-57828 20560-57833 20560-57841 20560-57842 205-31520 ALEWIFE COVE DREDGING UPS SYSTEM FOR COMMUNICATIONS FIBER UPGRADE TOWN-WIDE CAMERA SYSTEM PHONE SYSTEM UPGRADE SWITCHES IT LEARNING BOARDS -END OF LIFE IT SECURITY DVR CAMERAS QH 10-YR RETRO COMMISSIONING TENNIS COURTS BUS LOT OFFICE SCHOOL SECURITY UNDESIGNATED FUND BALANCE TOTAL TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF JANUARY 31, 2022 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL $0.00 $37,500.00 $0.00 $37,500.00 $0.00 $12,500.00 $0.00 $12,500.00 $0.00 $28,000.00 $0.00 $28,000.00 $0.00 $85,000.00 $0.00 $85,000.00 $0.00 $16,000.00 $0.00 $16,000.00 $0.00 $22,500.00 $22,500.00 $4,590.29 $291,888.88 $0.00 $3.46 $0.00 $0.00 $0.00 $30,000.00 $0.00 $0.00 $52,300.00 $0.00 $0.00 $150,000.00 $0.00 $32,175.00 $0.00 $0.00 $0.00 $0.00 $2,383,114.48 $727,459.99 $3,422,501.88 $4,823,883.11 $296,479.17 $3.46 $30,000.00 $52,300.00 $150,000.00 $32,175.00 $2,383,114.48 $8,973,844.98 Page 2 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE DESIGNATION AND APPROPRIATION JULY 1,2021 TO JUNE 30,2022 AS OF JANUARY 31,2022 BEGINNING FY22 RTM CLOSED AVAILABLE BALANCE XFER IN FISCAL YEAR 2021-2022 BAL(REVERTS INTEREST OTHER TO DATE APPROPRIATIONS DESIGNATED UNDESIGNATED DESIGNATED APPROPRIATED DESIGNATED UNDESIGNATED EXPENDED TO FUND) INC REVENUES ~ APPROPRIATED DESIGNATED UNDESIGNATED 20501-57639 | REVALUATION $255,989.43 $257,700.00 $0.00 $280,610.99 (824,621.46) $257,700.00 $0.00 20501-57788 | COMMUNITY CENTER HVAC CONTROL SEPARATION $0.00 $59,650.00 $0.00 (859,650.00) $0.00 $0.00 $0.00 20507-57776 FIBER INSTALL MUNICPAL COMPLEX $14,808.85 $0.00 30.00 $14,808.85 $0.00 $0.00 $14,808.85 20507-57790 WIFI TOWN-WIDE WIRING $0.00 $25,000.00 $0.00 $0.00 $25,000.00 $0.00 20510-57830 THAMES RIVER MARINA DOCK SYSTEM $227.78 $0.00 $0.00 $227.75 $0.00 $0.00 $227.75 SRN E eS CRYSTAL MALL REDEVELOPMENT FEASIBLITY STUDY $0.00 $0.00 20510-57864 $250,000.00 $250,000.00 $0.00 20511-57767 NEVINS COTTAGE STRUCTURAL REPAIRS $20,715.00 $0.00 $0.00 $100,000.00 $20,715.00 $100,000.00 20511-57788 COMMUNITY CENTER HVAC CONTROL SEPARATION $0.00 $0.00 $0.00 $59,650.00 $9,850.00 $49,800.00 $0.00 20511-57805 YSB FLOORING $45,611.44 $0.00 $0.00 $45,611.44 $0.00 $0.00 $45,611.44 20511-57839 TOWN HALL EMERGENCY EGRESS $0.00 $46,000.00 $0.00 $46,000.00 ($46,000.00) $9,300.00 $36,700.00 : $0.00 $0.00 20511-57840 PLAN OF CONSERVATION DEVELOPMENT $100,000.00 $0.00 $0.00 $100,000.00 $0.00 $0.00 20511-57856 JORDAN VILLAGE SIDEWALKS $0.00 $100,000.00 $0.00 $404,000.00 ($100,000.00) $404,000.00 $0.00 $0.00 20511-57857 CIVIC TRIANGLE UPGRADES $50,000.00 $0.00 $0.00 $32,180.00 $17,820.00 $0.00 $0.00 20511-57859 EUGENE O'NEILL ROOF REPLACEMENT $25,767.64 $0.00 $0.00 $25,767.64 $0.00 $0.00 $0.00 20511-57866 TOWN HALL FRONT DOOR $0.00 $0.00 $0.00 $35,000.00 $2,645.00 $32,355.00 $0.00 $0.00 20522-57794 $0.00 $740,165.00 $0.00 $0.00 $740,165.00 20522-57865 $20,012.19 $0.00 $0.00 $20,012.19 $0.00 $0.00 20523-57733 $500.00 $1,000,000.00 $500.00 $1,000,000.00 20523-57751 $40,175.25 $0.00 $0.00 $40,175.25 $0.00 20523-57791 JORDAN-TRAFFIC LIGHT UPGRADE $0.00 $25,000.00 $0.00 $0.00 $25,000.00 20523-57792 OSWEGATCHIE-BUILDING RENOVATIONS $213,700.00 $1,990,000.00 $0.00 $213,700.00 $1,990,000.00 20523-57826 FIRE SERVICES HYDRAULIC EQUIPMENT $0.00 $50,000.00 $0.00 $181,000.00 ($31,000.00) $163,377.24 $17,622.76 $19,000.00 20523-57836 FIRE SERVICES CARPET REPLACEMENT $0.00 $30,000.00 $0.00 $0.00 $30,000.00 20523-57837 FIRE SERVICES HYDRAULIC EQUIPMENT UPGRADE $0.00 $150,000.00 $0.00 ($150,000.00) $0.00 $0.00 20523-57838 FIRE SERVICES PRE EMPTION LIGHT REPAIRS 30.00 $50,000.00 $0.00 $0.00 $50,000.00 20530-55850 CROSS ROAD DESIGN WORK $5,481.49 $0.00 $0.00 $5,481.49 $0.00 $0.00 20530-57659 OLD MILL ROAD BRIDGE $0.00 $0.00 $0.00 $37,901.45 $37,901.45 $0.00 $0.00 20530-57695 MUNICIPAL COMPLEX RENOVATION $780,386.59 $321,781.07 $6,100,833.00 deste fg Se $6,100,833.00 $0.00 $458,605.52 SES $0.00 20530-57696 MUNICIPAL COMPLEX CLEAN UP $5,957.31 $0.00 $3,365.24 $2,592.07 20530-57815 REDESIGN/RECONSTRUCT GARDINERS WOOD ROAD $101,955.48 $0.00 $0.00 $18,508.48 $83,447.00 $0.00 20530-57832 LED STREETLIGHT CONVERSION $33,554.76 $0.00 $0.00 $16,422.96 $17,131.80 $0.00 20530-57855 BRAMAN ROAD REDESIGN/RECONSTR $280,000.00 $0.00 $0.00 $257,403.33 $22,596.67 $0.00 20531-55771 HARVEY AVENUE PUMP STATION REHAB $19,422.12 $0.00 $0.00 $19,422.12 $0.00 20531-57685 I/E MITIGATION & CONTROL $332,286.86 $0.00 $0.00 $21,301.00 $310,985.86 $0.00 20531-57766 WASTEWATER SCADA SYSTEM UPGRADE $0.04 $0.00 $0.00 $0.04 $0.00 $0.00 20531-57802 FORCE MAIN AIR RELEASE VALVES-EVALUATE & REPLACE $0.00 $43,000.00 $0.00 $0.00 $43,000.00 20531-57816 OLD NORWICH /EVERGREEN/HARVEY AVE PUMP STATION REHAB $506,000.00 $544,000.00 $0.00 $500,562.00 $5,438.00 $544,000.00 20531-57817 WASTEWATER PS FLOOD PROTECTION $30.10 $85,000.00 $0.00 $30.10 $85,000.00 20536-57848 LIBRARY HVAC UPGRADE $0.00 $200,000.00 $0.00 $345,600.00 $0.00 $545,600.00 20537-57735. LEARY PARK ROAD /PARKING LOT $0.00 $20,000.00 $0.00 $0.00 $20,000.00 20537-57781 © WATERFORD BEACH PAVILION RESTROOM $160,758.70 $0,00 $0.00 $159,604.15 $1,154.55 $0.00 $0.00 $1,154.55 20537-57795 WBP CAUSEWAY BRIDGE $0.00 $25,000.00 $0.00 $0.00 $25,000.00 $0.00 20537-57824 WBP CAUSEWAY BRIDGE FABRICATION $0.00 $61,700.00 $0.00 $0.00 $61,700.00 $0.00 Paget TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE DESIGNATION AND APPROPRIATION JULY 1,2021 TO JUNE 30,2022 AS OF JANUARY 31,2022 BEGINNING FY22 RTM CLOSED AVAILABLE BALANCE XFER IN FISCAL YEAR 2021-2022 BAL (REVERTS INTEREST OTHER TO DATE APPROPRIATIONS DESIGNATED INDESIGNATED DESIGNATED APPROPRIATED DESIGNATED UNDESIGNATED EXPENDED TO FUND) INC REVENUES APPROPRIATED DESIGNATED UNDESIGNATED 20537-57854 | WIFD BEACH PARK IMPROVEMENTS $0.00 30.00 $0.00 $30,000.00 $0.00 $30,000.00 $0.00 20541-57328 = ALEWIFE COVE DREDGING $0.00 $37,500.00 $30.00 $0.00 $37,500.00 $0.00 20547-57747, UPS SYSTEM FOR COMMUNICATIONS $0.00 $0.00 $0.00 $12,500.00 $0.00 $12,500.00 $0.00 20547-57846 FIBER UPGRADE $0.00 $14,000.00 $0.00 $14,000.00 $0.00 $28,000.00 $0.00 20547-57847 =TOWN-WIDE CAMERA SYSTEM $0.00 $0.00 $0.00 $85,000.00 $0.00 $85,000.00 $0.00 20547-87860 | PHONE SYSTEM UPGRADE $0.00 $0.00 30,00 $16,000.00 $0.00 $16,000.00 $0.00 20547-57861 SWITCHES $0.00 $0.00 30.00 $22,500.00 30.00 922,500.00 30.00 20560-57808 | REPLACE DVR SECURITY CAMERA $30,000.00 $0.00 $30,000.00 $0.00 $0.00 $0.00 20560-57822 IT LEARNING BOARDS -END OF LIFE $4,590.29 $91,888.88 $0.00 $200,000.00 $4,590.29 $291,888.88 $0.00 20560-57823. IT SECURITY DVR CAMERAS $29,998.71 $0.00 $0.00 $29,995.25 $3.46 $0.00 $0.00 20860-57828 QH 10-YR RETRO COMMISSIONING $0.00 $30,000.00 $0.00 $0.00 $30,000.00 $0.00 20560-57833 TENNIS COURTS $0.00 $52,300.00 $0.00 $0.00 $52,300.00 $0.00 20560-57841 BUS LOT OFFICE $0.00 $75,000.00 $0.00 $75,000.00 $0.00 $150,000.00 $0.00 20560-57842 SCHOOLSECURITY $32,175.00 30.00 $0.00 $32,175.00 $0.00 $0.00 20500-49000 ‘TRANSFERS IN $0.00 $0.00 30.00 $2,104,000.00 $0.00 $0.00 $2,104,000.00 205-31520 UNDESIGNATED FUND BALANCE $0.00 $0.00 $2,755,170.41 ($376,901.45) $4,845.52 $0.00 $0.00 $2,383,114.48 $2,108,605.06 $2,908,551.88 $2,780,(70.44 $900,600.00 $763,551.45 ($386,650.00) ($376,901.45) $2,082,893.83 “$61,802.63 $4,845.52 $2,353,966.00 $727,459.99 $3,422,501.88 $4,823,883.11 Page 2 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JANUARY 31, 2022 EXPENDED/ ACCOUNT DEPT/YEAR DESCRIPTION APPROPRIATED ENCUMBERED BALANCE 30117-55797 SELECTMEN FY17 ADA COMPLIANCE 20,000.00 0.00 20,000.00 30122-55738 SELECTMEN FY22 FLEET MANAGEMENT PLAN 800,000,00 800,000.00 0.00 30716-55793 FINANCE (IT) FY16 FINANCIAL ACCOUNTING SOFTWARE 170,000.00 144,028.53 25,971.47 31117-55803 BLDG MAINT FY17 PARKING LOT -YOUTH SERVICES 300,000.00 7,200.00 292,800.00 31118-55803 BLDG MAINT FY18 PARKING LOT -YSB/POLICE 195,320.00 57,500.00 137,820.00 31120-55851 BLDG MAINT FY20 ADA IMPROVEMENTS YSB/PD 87,000.00 0.00 87,000.00 81120-55852 BLDG MAINT FY20 TOWN HALL BATHROOMS 87,500.00 14,590.00 72,910.00 31120-55853 BLDG MAINT FY20 AUDITORIUM SEATING UPGRADE 12,760.00 0.00 12,760.00 31121-55851 BLDG MAINT FY21 ADA IMPROVEMENTS YSB/PD 80,700.00 18,500.00 62,200.00 31121-55852 BLDG MAINT FY21 TOWN HALL BATHROOMS 25,000.00 0.00 25,000.00 31122-55819 BLDG MAINT FY22 UST REPLACEMENT 250,000.00 24,000.00 226,000.00 31122-55892 BLDG MAINT FY22 AC UNIT REPLACMENT RADIO SITES 60,500.00 0.00 60,500.00 31122-55893 BLDG MAINT FY22 EUGENE O'NEILL ROOF REPLACE 60,767.64 2,350.00 58,417.64 31122-57857 BLDG MAINT FY22 CIVIC TRIANGLE UPGRADES 150,000.00 0.00 150,000.00 32322-55847 FIRE SERVICES FY22 COHANZIE ROOF REPLACEMENT 105,000.00 92,148.99 12,851.01 32322-55881 FIRE SERVICES FY22 GOSHEN A/C 25,000.00 800.00 24,200.00 82920-55846 POLICE DEPT FY20 PD POLICY DIRECTIVES REVAMP 30,000.00 30,000.00 0.00 32920-55859 POLICE DEPT FY20 POLICE BLGD ARCHITECTURAL PLAN 15,000.00 0.00 15,000.00 32921-55837 POLICE DEPT FY21 POLICE INFRARED CAMERAS IN CARS 14,350.00 14,350.00 0.00 32921-55864 POLICE DEPT FY21 POLICE BODY CAMERAS 110,100.00 110,100.00 0,00 32922-55876 POLICE DEPT FY22 CYBER CRIME TASK FORCE EQUIPME 11,000.00 8,962.56 2,037.44 32922-55877 POLICE DEPT FY22 TRAFFIC MESSAGE BOARDS 28,000.00 0.00 28,000.00 32922-55878 POLICE DEPT FY22 IMPO