Loading...
HomeMy WebLinkAbout07-18-2023 Council Meeting Agenda PacketIn compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the City Clerk at (509) 886-6103 (TTY 711). Notification 72 hours prior to the meeting will enable the City to make reasonable arrangements to ensure accessibility to the meeting (28 CFR 35.102-35.104 ADA Title 1.) 07/18/2023 Council Meeting Agenda Page 1 of 1 East Wenatchee City Council Meeting Tuesday, July 18, 2023 East Wenatchee City Hall 271 9th Street NE East Wenatchee, WA 98802 This meeting will be in person or via zoom: https://us02web.zoom.us/j/89586055471 Phone-in option for the meeting: 253 215 8782, Meeting ID: 895 8605 5471 AGENDA 6:00 p.m. Regular Meeting Call to Order, Roll Call and Pledge of Allegiance. 1.Consent Items: Vouchers: a.Date: 07-18-2023, Checks: 58807-58888, in the amount of $998,173.67. b.Payroll Certification for June 2023. Minutes: c.07-05-2023 Council Meeting Minutes. Motion by City Council to approve agenda, vouchers, and minutes from previous meetings. 2.Citizen Requests/Comments. The Citizen Comments” period is to provide the opportunity for members of the public to address the Council. The Mayor will ask if there are any citizens wishing to address the Council. When recognized, please step up to the microphone, give your name and mailing address, and state the matter of your interest. Citizen comments will be limited to three minutes. 3. Presentations. a.Introduction and Recognition of the 2023 Misawa Delegation. – Mayor Crawford. b.Douglas County PUD Presentation. – Gary Ivory, General Manager. 4.Department Report. a.May 2023 Financial Report. – Josh Delay, Finance Director. b.2023 Community Development Building Grant Program Annual Action Plan. – Curtis Lillquist, Community Development Director. 5.Mayor’s Report. 6.Council Reports & Announcements. a.Reports/New Business of Council Committees. 7. Adjournment. pg. 2 pg. 45 pg. 47 pg. 49 pg. 61 07-18-2023 City Council Agenda Packet Page 1 of 88 CHECKS: 58807-58888 VOIDED CHECKS: DEPARTMENT/FUND AMOUNT General Fund 001 $248,645.17 Rainy Day Fund 002 $0.00 Street Fund 101 $6,466.37 Community Dev Grants Funds 102 $0.00 Affordable Housing Tax Fund 103 $0.00 Housing & Related Services Fund 104 $0.00 Transportation Benefit District Fund 105 $0.00 SWAT Fund 107 $655.22 Library Fund 112 $220.15 Hotel/Motel Tax Fund 113 $5,062.00 Drug Fund 114 $0.00 Criminal Justice Fund 116 $0.00 Events Board Fund 117 $17,803.59 Bond Redemption Fund 202 $0.00 Street Improvements Fund 301 $635,789.64 Capital Improvements Fund 314 $39,162.22 Stormwater Fund 401 $29,674.81 Equipment R&R Fund 501 $4,084.55 Cafeteria Plan 634 $0.00 Custodial Activities 635 $10,609.95 Grand Total All Funds $998,173.67 CITY OF EAST WENATCHEE CHECK REGISTER July 18th, 2023 Payables 07-18-2023 City Council Agenda Packet Page 2 of 88 Fund Number Description Amount 001 General Fund $248,645.17 101 Street Fund $6,466.37 107 SWAT Fund $655.22 112 Library Fund $220.15 113 Hotel/Motel Tax Fund $5,062.00 117 Events Board Fund $17,803.59 301 Street Improvements Fund $635,789.64 314 Capital Improvements Fund $39,162.22 401 Stormwater Fund $29,674.81 501 Equipment Purchase, Repair & Replacement Fund $4,084.55 635 Custodial Activities Fund $10,609.95 Count: 11 $998,173.67 Fund Transaction Summary Transaction Type: Invoice Fiscal: 2023 - July 2023 - July 2023 2nd Council Printed by COEW\DSanchez on 7/12/2023 1:39:13 PM Page 1 of 1 East Wenatchee - Fund Transaction Summary 07-18-2023 City Council Agenda Packet Page 3 of 88 Vendor Number Reference Account Number Description Amount AAR Testing Laboratory 58809 2023 - July 2023 - July 2023 2nd Council 105388 Public Works Building 314-000-000-594-18-60-00 Maintenance Facilities Construction $340.50 Total 105388 $340.50 Total 58809 $340.50 Total AAR Testing Laboratory $340.50 Ag Supply Company - 233955 58810 2023 - July 2023 - July 2023 2nd Council Invoice - 7/3/2023 9:25:03 AM 06/2023 acct 233955 001-000-210-521-10-32-00 Fuel Consumed $5,054.73 Total Invoice - 7/3/2023 9:25:03 AM $5,054.73 Total 58810 $5,054.73 Total Ag Supply Company - 233955 $5,054.73 AG Supply Company - 234034 58811 2023 - July 2023 - July 2023 2nd Council Invoice - 7/6/2023 8:05:12 AM 06/2023 remittance 234034 001-000-180-518-30-35-00 Small Tools & Equipment $31.00 001-000-210-521-10-35-00 Small Tools & Equipment $9.32 101-000-420-542-30-30-00 Supplies - Roadway $3.90 101-000-420-542-30-30-00 Supplies - Roadway $14.80 101-000-420-542-75-30-00 Supplies - City Parks $13.01 101-000-420-542-75-30-00 Supplies - City Parks $18.43 101-000-420-542-75-30-00 Supplies - City Parks $36.87 101-000-420-542-75-30-00 Supplies - City Parks $46.62 101-000-420-542-75-30-00 Supplies - City Parks $18.43 101-000-420-542-75-30-00 Supplies - City Parks $34.71 101-000-430-543-30-30-00 Supplies - General Services $0.05 101-000-430-543-30-30-01 Fuel $2,439.72 Voucher Directory Fiscal: : 2023 - July 2023 Council Date: : 2023 - July 2023 - July 2023 2nd Council Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 1 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 4 of 88 Vendor Number Reference Account Number Description Amount 501-000-000-548-30-30-25 Street Vehicle Repair Supplies $81.71 Total Invoice - 7/6/2023 8:05:12 AM $2,748.57 Total 58811 $2,748.57 Total AG Supply Company - 234034 $2,748.57 Ag Supply Company - 4953 58812 2023 - July 2023 - July 2023 2nd Council Invoice - 7/7/2023 7:38:35 AM 06/2023 remittance 4953 401-000-008-531-00-30-07 Fuel $66.46 Total Invoice - 7/7/2023 7:38:35 AM $66.46 Total 58812 $66.46 Total Ag Supply Company - 4953 $66.46 Alignment Pros and Express Lube 58813 2023 - July 2023 - July 2023 2nd Council 40243 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $67.81 Total 40243 $67.81 41275 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $67.81 Total 41275 $67.81 42698 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $67.81 Total 42698 $67.81 43325 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $74.96 Total 43325 $74.96 43571 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $67.81 Total 43571 $67.81 48148 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $126.51 Total 48148 $126.51 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 2 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 5 of 88 Vendor Number Reference Account Number Description Amount 48160 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $126.07 Total 48160 $126.07 48465 Police repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $111.04 Total 48465 $111.04 Total 58813 $709.82 Total Alignment Pros and Express Lube $709.82 American Building Maintenance CO 58814 2023 - July 2023 - July 2023 2nd Council 18306586 Janitorial Services 001-000-180-518-30-41-00 Professional Services $2,523.81 Total 18306586 $2,523.81 Total 58814 $2,523.81 Total American Building Maintenance CO $2,523.81 ARC Architects, Inc. 58815 2023 - July 2023 - July 2023 2nd Council 0000000036 East Wenatchee Public Works Buidling 314-000-000-594-18-60-00 Maintenance Facilities Construction $6,406.80 Total 0000000036 $6,406.80 Invoice - 7/3/2023 9:28:36 AM East Wenatchee Public Works Buidling 314-000-000-594-18-60-00 Maintenance Facilities Construction $8,074.00 Total Invoice - 7/3/2023 9:28:36 AM $8,074.00 Total 58815 $14,480.80 Total ARC Architects, Inc.$14,480.80 Barbara Andre Van Lit 58816 2023 - July 2023 - July 2023 2nd Council 368 Catering 117-000-620-557-30-40-00 PFOF Professional Services $3,982.84 Total 368 $3,982.84 Total 58816 $3,982.84 Total Barbara Andre Van Lit $3,982.84 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 3 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 6 of 88 Vendor Number Reference Account Number Description Amount Bear Signs & Embroidery LLC 58817 2023 - July 2023 - July 2023 2nd Council 7648 117-000-620-557-30-30-00 PFOF Marketing Materials $5,024.66 Total 7648 $5,024.66 Total 58817 $5,024.66 Total Bear Signs & Embroidery LLC $5,024.66 Cascade Quality Water 58818 2023 - July 2023 - July 2023 2nd Council Invoice - 7/6/2023 8:08:50 AM Water 001-000-001-518-91-30-00 Wellness $49.37 Total Invoice - 7/6/2023 8:08:50 AM $49.37 Total 58818 $49.37 Total Cascade Quality Water $49.37 Cdw Government, Inc 58819 2023 - July 2023 - July 2023 2nd Council KJ29296 001-000-145-514-20-30-01 Non-Capital - PC Software Admin $258.32 Total KJ29296 $258.32 Total 58819 $258.32 Total Cdw Government, Inc $258.32 Chelan County Treasurer 58820 2023 - July 2023 - July 2023 2nd Council 150001-01851 Medical care - prisoners 001-000-230-523-60-20-00 Medical Care - Prisoners $81.09 Total 150001-01851 $81.09 Total 58820 $81.09 Total Chelan County Treasurer $81.09 Chelan Douglas Regional Port Authority 58821 2023 - July 2023 - July 2023 2nd Council Invoice - 7/7/2023 9:29:36 AM Contributions 001-000-001-558-70-40-00 Contributions - Region $10,000.00 Total Invoice - 7/7/2023 9:29:36 AM $10,000.00 Total 58821 $10,000.00 Total Chelan Douglas Regional Port Authority $10,000.00 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 4 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 7 of 88 Vendor Number Reference Account Number Description Amount Ci Support LLC, dba: Ci Information Management 58822 2023 - July 2023 - July 2023 2nd Council 0152943 Onsite Destruction 001-000-120-594-12-60-00 Capital Outlay $31.67 Total 0152943 $31.67 Total 58822 $31.67 Total Ci Support LLC, dba: Ci Information Management $31.67 Cintas Corporation 607 58823 2023 - July 2023 - July 2023 2nd Council 4159874714 Supplies 001-000-210-521-10-48-00 Repairs & Maintenance $16.63 101-000-430-543-30-30-00 Supplies - General Services $41.70 Total 4159874714 $58.33 4160635480 Supplies 001-000-180-518-30-41-00 Professional Services $105.53 112-000-000-572-50-47-00 Facilities - Utilities $105.53 Total 4160635480 $211.06 4160635501 Supplies 001-000-210-521-10-48-00 Repairs & Maintenance $16.65 101-000-430-543-30-30-00 Supplies - General Services $41.68 Total 4160635501 $58.33 Total 58823 $327.72 Total Cintas Corporation 607 $327.72 Classic One East 58824 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 9:09:54 AM Hampton - dry cleaning 001-000-210-521-10-49-02 Dry Cleaning Services $62.82 Total Invoice - 7/12/2023 9:09:54 AM $62.82 Total 58824 $62.82 Total Classic One East $62.82 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 5 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 8 of 88 Vendor Number Reference Account Number Description Amount Column Software PBC 58825 2023 - July 2023 - July 2023 2nd Council CD251047-0001 Amendments to East Wenatchee Area Comprehensive Plan 001-000-580-558-60-44-00 Advertising $153.44 Total CD251047-0001 $153.44 Total 58825 $153.44 Total Column Software PBC $153.44 Consolidated Electrical Distributors Inc 58826 2023 - July 2023 - July 2023 2nd Council 9360-1059343 Police Sign 314-000-000-594-21-60-01 Simon St. Improvements $1,089.57 Total 9360-1059343 $1,089.57 Total 58826 $1,089.57 Total Consolidated Electrical Distributors Inc $1,089.57 Darling Productions LLC 58827 2023 - July 2023 - July 2023 2nd Council 000147 Festival of Flights Marketing 117-000-620-557-30-40-01 PFOF Advertising $500.00 Total 000147 $500.00 000148 Pangborn Festival Emcee 117-000-620-557-30-40-02 PFOF Entertainment $1,000.00 Total 000148 $1,000.00 Total 58827 $1,500.00 Total Darling Productions LLC $1,500.00 David Kelts 58828 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:40:40 PM 2023 Trip to Misawa 001-000-110-511-60-43-01 Travel - Misawa $2,350.00 Total Invoice - 6/29/2023 1:40:40 PM $2,350.00 Total 58828 $2,350.00 Total David Kelts $2,350.00 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 6 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 9 of 88 Vendor Number Reference Account Number Description Amount DeVries Business Records Management Inc 58829 2023 - July 2023 - July 2023 2nd Council 0166929 On Site Record Destruction 001-000-210-521-10-41-00 Professional Services $70.99 Total 0166929 $70.99 Total 58829 $70.99 Total DeVries Business Records Management Inc $70.99 Douglas County Auditor-Recording 58830 2023 - July 2023 - July 2023 2nd Council 115077 Recording 001-000-110-511-60-41-00 Professional Services $212.50 Total 115077 $212.50 115117 Recording 001-000-110-511-60-41-00 Professional Services $207.50 Total 115117 $207.50 115170 Recording 001-000-110-511-60-41-00 Professional Services $211.50 Total 115170 $211.50 Total 58830 $631.50 Total Douglas County Auditor-Recording $631.50 Douglas County PUD 58831 2023 - July 2023 - July 2023 2nd Council 70 05/22/23-06/21/23 Utilities 001-000-180-518-30-47-01 Utilities - Simon St.$475.00 101-000-420-542-63-47-00 Utilities - Street Lighting $1,493.00 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $174.00 Total 70 05/22/23-06/21/23 $2,142.00 Total 58831 $2,142.00 Total Douglas County PUD $2,142.00 Douglas County Treasurer 58832 2023 - July 2023 - July 2023 2nd Council Invoice - 7/10/2023 10:40:29 AM Stormwater taxes 001-000-001-531-00-40-00 Annual SWU Charge $164,340.00 Total Invoice - 7/10/2023 10:40:29 AM $164,340.00 Total 58832 $164,340.00 Total Douglas County Treasurer $164,340.00 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 7 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 10 of 88 Vendor Number Reference Account Number Description Amount Erika Rodriguez 58833 2023 - July 2023 - July 2023 2nd Council Invoice - 7/6/2023 8:13:40 AM 06/16/23, 06/28/23 & 06/30/23 interpreting 001-000-120-512-51-40-04 Interpreting $240.00 Total Invoice - 7/6/2023 8:13:40 AM $240.00 Total 58833 $240.00 Total Erika Rodriguez $240.00 Fisher's Landscape and Construction LLC 58834 2023 - July 2023 - July 2023 2nd Council 2941 Simon 06/2023 landscape 001-000-180-518-30-49-01 Landscaping $390.60 Total 2941 $390.60 2942 06/2023 landscape 001-000-180-518-30-49-01 Landscaping $151.90 Total 2942 $151.90 2914 Simon 03/2023-05/2023 landscape 001-000-180-518-30-49-01 Landscaping $1,171.80 Total 2914 $1,171.80 2915 03/2023-05/2023 landscape 001-000-180-518-30-49-01 Landscaping $1,019.90 Total 2915 $1,019.90 Total 58834 $2,734.20 Total Fisher's Landscape and Construction LLC $2,734.20 Forte Architects Inc 58835 2023 - July 2023 - July 2023 2nd Council 3865 Police Station 314-000-000-594-21-60-01 Simon St. Improvements $15,387.24 Total 3865 $15,387.24 Total 58835 $15,387.24 Total Forte Architects Inc $15,387.24 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 8 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 11 of 88 Vendor Number Reference Account Number Description Amount Full Compass Systems 58836 2023 - July 2023 - July 2023 2nd Council INC02370908 Speakers 117-000-100-594-58-64-00 EWEB Capital Outlay $4,045.97 Total INC02370908 $4,045.97 Total 58836 $4,045.97 Total Full Compass Systems $4,045.97 Gary Anderson DBA Dynamic Tents 58837 2023 - July 2023 - July 2023 2nd Council Invoice - 7/10/2023 9:17:40 AM 117-000-620-557-30-40-02 PFOF Entertainment $1,746.85 Total Invoice - 7/10/2023 9:17:40 AM $1,746.85 Total 58837 $1,746.85 Total Gary Anderson DBA Dynamic Tents $1,746.85 GO Usa/Hamilton & Assoc 58838 2023 - July 2023 - July 2023 2nd Council 72041-1 Shirts 001-000-210-521-10-20-01 Clothing Allowance $14.13 Total 72041-1 $14.13 Total 58838 $14.13 Total GO Usa/Hamilton & Assoc $14.13 Haglund's Trophies 58839 2023 - July 2023 - July 2023 2nd Council 70899 Retirement Plate 001-000-210-521-10-35-00 Small Tools & Equipment $64.08 Total 70899 $64.08 71127 Name Plates 001-000-210-521-10-35-00 Small Tools & Equipment $11.79 Total 71127 $11.79 Total 58839 $75.87 Total Haglund's Trophies $75.87 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 9 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 12 of 88 Vendor Number Reference Account Number Description Amount iland Internet Solutions Corp. 58840 2023 - July 2023 - July 2023 2nd Council INV-122361 iCloud backup 001-000-145-514-20-40-05 Disaster Backup System Support $1,378.17 Total INV-122361 $1,378.17 Total 58840 $1,378.17 Total iland Internet Solutions Corp.$1,378.17 Interstate Autobody Truck 58841 2023 - July 2023 - July 2023 2nd Council 403 Swat unit vehicle repair 107-000-000-521-10-30-00 Supplies & Equipment $655.22 Total 403 $655.22 Total 58841 $655.22 Total Interstate Autobody Truck $655.22 Ironclad Company 58842 2023 - July 2023 - July 2023 2nd Council 16539 Gutter Broom 401-000-008-531-00-30-05 Supplies - NPDES PPGH $4,603.45 Total 16539 $4,603.45 Total 58842 $4,603.45 Total Ironclad Company $4,603.45 JDSA Law Firm 58843 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 9:11:08 AM 06/2023 legal services 001-000-151-515-41-40-00 Legal Services $1,896.00 Total Invoice - 7/12/2023 9:11:08 AM $1,896.00 Total 58843 $1,896.00 Total JDSA Law Firm $1,896.00 Jet Pro Express Auto Wash, LLC 58844 2023 - July 2023 - July 2023 2nd Council 1314 Car Wash Tokens 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $650.40 Total 1314 $650.40 Total 58844 $650.40 Total Jet Pro Express Auto Wash, LLC $650.40 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 10 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 13 of 88 Vendor Number Reference Account Number Description Amount Jonathan Knuston 58845 2023 - July 2023 - July 2023 2nd Council Invoice - 7/6/2023 8:23:36 AM 06/19/23-06/23/23 travel reimbursement 001-000-210-521-10-43-00 Travel $775.44 Total Invoice - 7/6/2023 8:23:36 AM $775.44 Invoice - 7/6/2023 8:24:14 AM 07/03/23 travel reimbursement 001-000-210-521-10-43-00 Travel $55.50 Total Invoice - 7/6/2023 8:24:14 AM $55.50 Total 58845 $830.94 Total Jonathan Knuston $830.94 Kamryn Davis 58846 2023 - July 2023 - July 2023 2nd Council Invoice - 7/6/2023 8:24:45 AM National Night Out 001-000-210-521-30-01-00 Kids'night Out $450.00 Total Invoice - 7/6/2023 8:24:45 AM $450.00 Total 58846 $450.00 Total Kamryn Davis $450.00 Kelley Connect 58847 2023 - July 2023 - July 2023 2nd Council 34295570 Copier 001-000-120-594-12-60-00 Capital Outlay $248.40 Total 34295570 $248.40 34366921 Copier 001-000-141-591-18-70-01 Copy Machine Lease $319.51 Total 34366921 $319.51 Total 58847 $567.91 Total Kelley Connect $567.91 Kottkamp, Yedinak, & Esworthy PLLC 58848 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:46:16 PM 07/2023 per contract 001-000-110-511-60-21-50 Public Defender $6,624.48 Total Invoice - 6/29/2023 1:46:16 PM $6,624.48 Total 58848 $6,624.48 Total Kottkamp, Yedinak, & Esworthy PLLC $6,624.48 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 11 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 14 of 88 Vendor Number Reference Account Number Description Amount Krake Law PLLC 58849 2023 - July 2023 - July 2023 2nd Council 9-2022 Brian Figueroa - 3A0343932 001-000-110-511-60-30-00 Public Defender Conflicts $459.00 Total 9-2022 $459.00 Total 58849 $459.00 Total Krake Law PLLC $459.00 Language Line Services, Inc 58850 2023 - July 2023 - July 2023 2nd Council 11047228 Over the phone interpretation 001-000-210-521-10-42-01 Telephone $66.06 Total 11047228 $66.06 Total 58850 $66.06 Total Language Line Services, Inc $66.06 Les Schwab Tire Center Inc 58851 2023 - July 2023 - July 2023 2nd Council 34301402617 Police Repairs 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $108.46 Total 34301402617 $108.46 Total 58851 $108.46 Total Les Schwab Tire Center Inc $108.46 Let's Color Art Studio 58852 2023 - July 2023 - July 2023 2nd Council Invoice - 7/10/2023 10:30:22 AM National Night Out 001-000-210-521-30-01-00 Kids'night Out $336.35 Total Invoice - 7/10/2023 10:30:22 AM $336.35 Total 58852 $336.35 Total Let's Color Art Studio $336.35 Lexipol, LLC 58853 2023 - July 2023 - July 2023 2nd Council INVPRA117523 PoliceOne Academy Annual 001-000-110-511-60-41-00 Professional Services $1,506.89 Total INVPRA117523 $1,506.89 Total 58853 $1,506.89 Total Lexipol, LLC $1,506.89 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 12 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 15 of 88 Vendor Number Reference Account Number Description Amount Localtel Communications 58854 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 9:12:43 AM Utilities 001-000-180-518-30-47-00 Utilities $432.14 Total Invoice - 7/12/2023 9:12:43 AM $432.14 Total 58854 $432.14 Total Localtel Communications $432.14 Madison Martin 58855 2023 - July 2023 - July 2023 2nd Council Invoice - 7/6/2023 8:30:11 AM 001-000-151-515-31-49-00 Miscellaneous $318.06 Total Invoice - 7/6/2023 8:30:11 AM $318.06 Total 58855 $318.06 Total Madison Martin $318.06 Moon Security 58856 2023 - July 2023 - July 2023 2nd Council 1194323 Security 001-000-210-521-10-41-00 Professional Services $27.19 Total 1194323 $27.19 1195460 Security 001-000-210-521-10-41-00 Professional Services $76.93 Total 1195460 $76.93 Total 58856 $104.12 Total Moon Security $104.12 North Cascades Heating & Air Conditioning, Inc 58857 2023 - July 2023 - July 2023 2nd Council 32212 Repairs 314-000-000-594-21-60-01 Simon St. Improvements $3,508.40 Total 32212 $3,508.40 Total 58857 $3,508.40 Total North Cascades Heating & Air Conditioning, Inc $3,508.40 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 13 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 16 of 88 Vendor Number Reference Account Number Description Amount Northwest Classic Auto Mall 58858 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:39:03 PM Havana Nights Advertising 117-000-621-557-30-40-02 Havana Nights Advertising $80.00 Total Invoice - 6/29/2023 1:39:03 PM $80.00 Total 58858 $80.00 Total Northwest Classic Auto Mall $80.00 Numerica Credit Union 58859 2023 - July 2023 - July 2023 2nd Council 06/2023 CC payment 001-000-001-518-91-30-00 Wellness $57.06 FredMeyer 001-000-001-518-91-30-00 Wellness $36.78 Safeway 001-000-001-518-91-30-00 Wellness $308.46 Costco 001-000-001-518-91-30-00 Wellness $22.74 FredMeyer 001-000-001-518-91-30-00 Wellness $220.12 San Francisco Sourdough 001-000-001-518-91-30-00 Wellness $31.98 Safeway 001-000-001-518-91-30-00 Wellness $81.32 Marshalls 001-000-110-511-60-47-00 Background Check Costs $11.00 WSP 001-000-111-513-10-40-06 Miscellaneous $8.63 Market Place 001-000-139-518-10-40-07 Pre-Employment Services $1.25 Clearing House 001-000-139-518-10-40-08 Professional Services $43.35 Embark 001-000-140-514-20-31-00 Office Supplies $11.94 Office Depot 001-000-140-514-20-31-01 Central Stores $111.74 Costco 001-000-142-514-20-31-00 Office Supplies $35.85 Target 001-000-142-514-20-40-02 Bank Charges & Fees $35.00 Anuual Fee 001-000-145-514-20-30-02 Non-Capital - PC Hardware Admin $336.63 Amazon 001-000-145-514-20-31-00 Supplies $29.28 Amazon Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 14 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 17 of 88 Vendor Number Reference Account Number Description Amount 001-000-145-514-20-31-00 Supplies $26.85 Platt 001-000-145-514-20-40-01 Memberships $75.00 EEM Creative 001-000-145-594-14-60-20 Capital - PC Software Admin $1,216.29 Zoho 001-000-180-518-30-35-00 Small Tools & Equipment $7.22 Amazon 001-000-210-521-10-31-00 Office Supplies $57.43 Peavey 001-000-210-521-10-31-00 Office Supplies $65.22 Office Depot 001-000-210-521-10-31-00 Office Supplies $16.70 Amazon 001-000-210-521-10-31-00 Office Supplies $21.72 Amazon 001-000-210-521-10-31-00 Office Supplies $8.44 Amazon 001-000-210-521-10-31-00 Office Supplies $40.82 Office Depot 001-000-210-521-10-31-00 Office Supplies $600.35 Amazon 001-000-210-521-10-31-00 Office Supplies $47.18 Amazon 001-000-210-521-10-31-00 Office Supplies $24.89 Office Depot 001-000-210-521-10-31-00 Office Supplies $77.50 Amazon 001-000-210-521-10-32-00 Fuel Consumed $54.19 Exxon 001-000-210-521-10-32-00 Fuel Consumed $19.23 Shell 001-000-210-521-10-32-00 Fuel Consumed $88.66 Shell 001-000-210-521-10-35-00 Small Tools & Equipment $326.25 Amazon 001-000-210-521-10-35-00 Small Tools & Equipment $151.85 Amazon 001-000-210-521-10-35-00 Small Tools & Equipment $14.11 Safeway 001-000-210-521-10-35-00 Small Tools & Equipment $54.94 Ag Supply 001-000-210-521-10-35-00 Small Tools & Equipment $153.70 Amazon 001-000-210-521-10-41-00 Professional Services $12.99 Canva Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 15 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 18 of 88 Vendor Number Reference Account Number Description Amount 001-000-210-521-10-42-01 Telephone $9.99 Browning Strike Force 001-000-210-521-10-42-03 Postage $5.43 UPS 001-000-210-521-10-48-00 Repairs & Maintenance $441.75 The Custom Shop 001-000-210-521-10-48-00 Repairs & Maintenance $135.57 Harbor Freight 001-000-210-521-10-48-00 Repairs & Maintenance $247.66 MidwayUSA 001-000-210-521-10-48-00 Repairs & Maintenance $425.95 Big Tex 001-000-210-521-10-49-00 Miscellaneous ($92.17) Amazon 001-000-210-521-10-49-00 Miscellaneous $80.16 Blue Flame 001-000-210-521-10-49-00 Miscellaneous $183.79 Canvas People 001-000-210-521-10-49-00 Miscellaneous $271.75 Lynette Smith 001-000-210-521-10-49-00 Miscellaneous $97.60 Amazon 001-000-210-521-10-49-00 Miscellaneous $92.17 Amazon 001-000-210-521-30-01-00 Kids'night Out $606.59 Quality Logo 001-000-210-521-40-40-01 Training - Officers $55.00 CPS 001-000-210-594-21-60-00 Capital Outlay $606.06 Amazon 001-000-315-542-10-48-00 Repairs & Maintenance ($1,329.12) AllData 001-000-580-558-60-40-00 Training $280.00 APA 101-000-420-542-30-30-00 Supplies - Roadway $271.45 Shepherds Oil 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $139.44 Traffic Safety 101-000-420-542-75-30-00 Supplies - City Parks $2.79 WA St Dept Agr 101-000-420-542-75-30-00 Supplies - City Parks $74.87 Lowe's 101-000-420-542-75-30-00 Supplies - City Parks $93.00 WA St Dept Agr 101-000-430-543-30-30-00 Supplies - General Services $21.69 Coastal Farm Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 16 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 19 of 88 Vendor Number Reference Account Number Description Amount 101-000-430-543-30-30-00 Supplies - General Services $111.68 Costco 101-000-430-543-30-30-00 Supplies - General Services $103.01 Costco 101-000-430-543-30-30-00 Supplies - General Services $16.84 ThreeLakes 101-000-430-543-30-30-01 Fuel $149.97 Shpherd's Oil 117-000-620-557-30-30-01 PFOF Supplies & Equipment $10.84 Amazon 117-000-620-557-30-30-01 PFOF Supplies & Equipment $14.06 Amazon 117-000-620-557-30-30-01 PFOF Supplies & Equipment $69.38 Marshalls 117-000-620-557-30-30-01 PFOF Supplies & Equipment $44.53 Personalization 117-000-620-557-30-30-02 PFOF Aviation Expenses $9.76 Goodwill 117-000-620-557-30-30-02 PFOF Aviation Expenses $10.81 Goodwill 117-000-620-557-30-30-02 PFOF Aviation Expenses $9.73 Hobby Lobby 117-000-620-557-30-40-01 PFOF Advertising $37.56 Meta 117-000-620-557-30-40-01 PFOF Advertising $37.07 Meta 117-000-620-557-30-40-01 PFOF Advertising $50.00 Meta 117-000-621-557-30-40-02 Havana Nights Advertising $12.93 Meta 314-000-000-594-18-60-00 Maintenance Facilities Construction ($1,649.20) Lowe's 314-000-000-594-18-60-00 Maintenance Facilities Construction $162.74 Costco 314-000-000-594-18-60-00 Maintenance Facilities Construction $1,843.42 Lowe's 314-000-000-594-18-60-00 Maintenance Facilities Construction $2,584.75 Lowe's 314-000-000-594-21-60-01 Simon St. Improvements $1,414.00 American AED 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $34.72 Amazon 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $275.00 Shine Mobile Detailing 501-000-000-548-30-48-20 Street Vehicle Repairs & Maintenance $449.95 Govt Trans Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 17 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 20 of 88 Vendor Number Reference Account Number Description Amount Total 06/2023 CC payment $13,069.63 Total 58859 $13,069.63 Total Numerica Credit Union $13,069.63 Office Depot Credit Plan 58860 2023 - July 2023 - July 2023 2nd Council 316143521001 Office Supplies 001-000-140-514-20-31-01 Central Stores $19.65 Total 316143521001 $19.65 317478384001 Office Supplies 001-000-140-514-20-31-01 Central Stores $23.84 Total 317478384001 $23.84 Total 58860 $43.49 Total Office Depot Credit Plan $43.49 One Call Concepts, Inc 58861 2023 - July 2023 - July 2023 2nd Council 3069070 Excavation 101-000-420-542-63-47-00 Utilities - Street Lighting $23.54 401-000-008-531-00-40-06 Utilities $23.54 Total 3069070 $47.08 Total 58861 $47.08 Total One Call Concepts, Inc $47.08 OneBridge Benefits 58862 2023 - July 2023 - July 2023 2nd Council INV-1866 07/23 admin fees 001-000-142-514-20-40-01 FSA Administrative Fee $50.00 Total INV-1866 $50.00 Total 58862 $50.00 Total OneBridge Benefits $50.00 Pacific Engineering & Design, PLLC 58863 2023 - July 2023 - July 2023 2nd Council 5488 19th Cascade Stormwater 401-000-011-594-31-60-04 19th Stormwater Facility Design $24,981.36 Total 5488 $24,981.36 Total 58863 $24,981.36 Total Pacific Engineering & Design, PLLC $24,981.36 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 18 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 21 of 88 Vendor Number Reference Account Number Description Amount Parker Corporation Services, INC DBA Merchant Patrol Security 58864 2023 - July 2023 - July 2023 2nd Council 47176 06/23 armed guard 001-000-120-512-51-40-08 Security $523.80 Total 47176 $523.80 Total 58864 $523.80 Total Parker Corporation Services, INC DBA Merchant Patrol Security $523.80 Pederson Law PLLC 58865 2023 - July 2023 - July 2023 2nd Council 1 Veronica Garcia 2A0471837 001-000-110-511-60-30-00 Public Defender Conflicts $504.00 Total 1 $504.00 Total 58865 $504.00 Total Pederson Law PLLC $504.00 Perteet Engineering, Inc 58866 2023 - July 2023 - July 2023 2nd Council 20210312.0001-5 3rd St SE & Rock Island Intersection 301-000-000-595-30-60-12 Construction - TIB 3rd/RI Road Signal $25,284.21 Total 20210312.0001-5 $25,284.21 Total 58866 $25,284.21 Total Perteet Engineering, Inc $25,284.21 Public Safety Testing 58867 2023 - July 2023 - July 2023 2nd Council 2023-669 Q2 2023 fees 001-000-210-521-10-41-00 Professional Services $444.00 Total 2023-669 $444.00 Total 58867 $444.00 Total Public Safety Testing $444.00 Randy's Auto Parts & Towing 58868 2023 - July 2023 - July 2023 2nd Council 17956 Towing 001-000-210-521-10-41-00 Professional Services $194.94 Total 17956 $194.94 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 19 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 22 of 88 Vendor Number Reference Account Number Description Amount 17967 Towing 001-000-210-521-10-41-00 Professional Services $194.94 Total 17967 $194.94 Total 58868 $389.88 Total Randy's Auto Parts & Towing $389.88 Rh2 Engineering, Inc. 58869 2023 - July 2023 - July 2023 2nd Council 91336 General Eng Services 001-000-315-544-20-45-00 Engineering Support Services $437.42 Total 91336 $437.42 91340 9th/VMP Intersection 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $7,519.72 Total 91340 $7,519.72 91342 2023 TIB Complete Streets 301-000-000-595-61-60-03 TIB 2022 Complete Streets $1,169.01 Total 91342 $1,169.01 Total 58869 $9,126.15 Total Rh2 Engineering, Inc.$9,126.15 Rivercom 58870 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 9:15:59 AM 001-000-001-528-70-40-00 River Com $14,670.17 Total Invoice - 7/12/2023 9:15:59 AM $14,670.17 Total 58870 $14,670.17 Total Rivercom $14,670.17 Selland Construction, Inc 58871 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 9:33:01 AM 05/30-07/07/2023 3rd & Rock Island Rd 301-000-000-595-30-60-12 Construction - TIB 3rd/RI Road Signal $601,049.58 Total Invoice - 7/12/2023 9:33:01 AM $601,049.58 Total 58871 $601,049.58 Total Selland Construction, Inc $601,049.58 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 20 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 23 of 88 Vendor Number Reference Account Number Description Amount Stan's Merry Mart 58872 2023 - July 2023 - July 2023 2nd Council Invoice - 7/5/2023 10:14:13 AM 06/2023 remittance 101-000-420-542-75-30-00 Supplies - City Parks $206.50 Total Invoice - 7/5/2023 10:14:13 AM $206.50 Total 58872 $206.50 Total Stan's Merry Mart $206.50 Summa Lux Eletric Co 58873 2023 - July 2023 - July 2023 2nd Council 466 501-000-000-594-21-60-00 Capital - Police Vehicles $907.15 Total 466 $907.15 Total 58873 $907.15 Total Summa Lux Eletric Co $907.15 Terex Services 58874 2023 - July 2023 - July 2023 2nd Council 7333189 Repairs 501-000-000-548-30-48-20 Street Vehicle Repairs & Maintenance $867.34 Total 7333189 $867.34 Total 58874 $867.34 Total Terex Services $867.34 Thompson Towing 58875 2023 - July 2023 - July 2023 2nd Council 10698 Towing 001-000-210-521-10-41-00 Professional Services $351.98 Total 10698 $351.98 Total 58875 $351.98 Total Thompson Towing $351.98 Tony Ditommaso PS 58876 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:46:49 PM 07/2023 per contract 001-000-110-511-60-21-50 Public Defender $6,624.48 Total Invoice - 6/29/2023 1:46:49 PM $6,624.48 Total 58876 $6,624.48 Total Tony Ditommaso PS $6,624.48 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 21 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 24 of 88 Vendor Number Reference Account Number Description Amount Trina Elmes 58807 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:39:44 PM Pangborns Festival of Flight Start Up Cash 117-000-620-557-30-30-01 PFOF Supplies & Equipment $400.00 Total Invoice - 6/29/2023 1:39:44 PM $400.00 Total 58807 $400.00 Total Trina Elmes $400.00 Uline 58877 2023 - July 2023 - July 2023 2nd Council 165319484 001-000-210-521-10-31-00 Office Supplies $112.29 Total 165319484 $112.29 Total 58877 $112.29 Total Uline $112.29 Washington State Department of Licensing 58878 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 10:46:01 AM CPL's 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003115 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003114 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003116 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003117 635-000-000-589-30-00-03 Gun Permit State Remittance $21.00 EWP003110 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003111 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003113 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003112 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003119 Total Invoice - 7/12/2023 10:46:01 AM $165.00 Invoice - 7/12/2023 10:47:53 AM CPL'S 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003131 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003130 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 22 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 25 of 88 Vendor Number Reference Account Number Description Amount 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003126 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003124 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003123 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003118 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003128 635-000-000-589-30-00-03 Gun Permit State Remittance $18.00 EWP003125 Total Invoice - 7/12/2023 10:47:53 AM $144.00 Total 58878 $309.00 Total Washington State Department of Licensing $309.00 Washington State Department of Transportation 58879 2023 - July 2023 - July 2023 2nd Council RE 42 JB2234 L208 Traffic Signal Maintenance 101-000-420-542-63-47-00 Utilities - Street Lighting $659.43 Total RE 42 JB2234 L208 $659.43 RE-3113-ATB301613123 9th/VMP Intersection 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $767.12 Total RE-3113-ATB301613123 $767.12 Total 58879 $1,426.55 Total Washington State Department of Transportation $1,426.55 Washington State Patrol 58880 2023 - July 2023 - July 2023 2nd Council I23007724 Gun Permits 635-000-000-589-30-00-03 Gun Permit State Remittance $148.00 Total I23007724 $148.00 Total 58880 $148.00 Total Washington State Patrol $148.00 Washington State Treasurer 58881 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:48:41 PM 05/2023 cash receipts 635-000-000-586-00-00-01 Court Remittance $9,958.45 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 23 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 26 of 88 Vendor Number Reference Account Number Description Amount 635-000-000-589-30-00-02 Building Code Remittance $194.50 Total Invoice - 6/29/2023 1:48:41 PM $10,152.95 Total 58881 $10,152.95 Total Washington State Treasurer $10,152.95 Waxie Sanitary Supply 58882 2023 - July 2023 - July 2023 2nd Council 81814427 Cleaning Supplies 001-000-180-518-30-31-07 Cleaning Supplies - Simon St.$178.59 Total 81814427 $178.59 81817510 Cleaning Supplies 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $202.73 Total 81817510 $202.73 81818258 Cleaning Supplies 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $98.33 Total 81818258 $98.33 Total 58882 $479.65 Total Waxie Sanitary Supply $479.65 Wenatchee Big Band 58883 2023 - July 2023 - July 2023 2nd Council Invoice - 7/10/2023 9:18:17 AM 117-000-620-557-30-40-02 PFOF Entertainment $500.00 Total Invoice - 7/10/2023 9:18:17 AM $500.00 Total 58883 $500.00 Total Wenatchee Big Band $500.00 Wenatchee Valley Humane Society 58884 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:47:10 PM 07/2023 per contract 001-000-001-539-30-40-00 Animal Control $7,401.66 Total Invoice - 6/29/2023 1:47:10 PM $7,401.66 Total 58884 $7,401.66 Total Wenatchee Valley Humane Society $7,401.66 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 24 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 27 of 88 Vendor Number Reference Account Number Description Amount Wenatchee Valley Museum & Cultural Center 58885 2023 - July 2023 - July 2023 2nd Council Invoice - 6/29/2023 1:47:33 PM 07/2023 per contract 001-000-001-558-70-41-15 Wenatchee Valley Museum $5,062.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 Total Invoice - 6/29/2023 1:47:33 PM $10,124.00 Total 58885 $10,124.00 Total Wenatchee Valley Museum & Cultural Center $10,124.00 William Isenhart 58886 2023 - July 2023 - July 2023 2nd Council Invoice - 7/11/2023 9:21:06 AM Sunglasses Reimbursement 001-000-000-369-91-50-00 Miscellaneous Revenue $301.20 Total Invoice - 7/11/2023 9:21:06 AM $301.20 Total 58886 $301.20 Total William Isenhart $301.20 Woods, Brangwin, & Bratton, PLLC 58887 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 12:27:00 PM Public Defender Coflicts 001-000-110-511-60-30-00 Public Defender Conflicts $175.50 Total Invoice - 7/12/2023 12:27:00 PM $175.50 Total 58887 $175.50 Total Woods, Brangwin, & Bratton, PLLC $175.50 Zero Handicap 58808 2023 - July 2023 - July 2023 2nd Council 4537 Golf Car Rentals 117-000-620-557-30-40-00 PFOF Professional Services $216.60 Total 4537 $216.60 Total 58808 $216.60 Total Zero Handicap $216.60 Ziply Fiber 58888 2023 - July 2023 - July 2023 2nd Council Invoice - 7/12/2023 9:17:40 AM 509-884-5236-041394-5 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $74.27 Total Invoice - 7/12/2023 9:17:40 AM $74.27 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 25 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 28 of 88 Vendor Number Reference Account Number Description Amount Invoice - 7/12/2023 9:25:20 AM 509-884-3132-110891-5 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $62.27 Total Invoice - 7/12/2023 9:25:20 AM $62.27 Invoice - 7/12/2023 9:26:00 AM 509-884-5308-041394-5 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $78.70 Total Invoice - 7/12/2023 9:26:00 AM $78.70 Invoice - 7/12/2023 9:26:36 AM 509-884-0489-090294-5 001-000-180-518-30-47-00 Utilities $114.62 112-000-000-572-50-47-00 Facilities - Utilities $114.62 Total Invoice - 7/12/2023 9:26:36 AM $229.24 Total 58888 $444.48 Total Ziply Fiber $444.48 Grand Total Vendor Count 82 $998,173.67 Printed by COEW\DSanchez on 7/12/2023 1:38:17 PM Page 26 of 26 East Wenatchee - Voucher Directory 07-18-2023 City Council Agenda Packet Page 29 of 88 07-18-2023 City Council Agenda Packet Page 30 of 88 07-18-2023 City Council Agenda Packet Page 31 of 88 07-18-2023 City Council Agenda Packet Page 32 of 88 07-18-2023 City Council Agenda Packet Page 33 of 88 07-18-2023 City Council Agenda Packet Page 34 of 88 07-18-2023 City Council Agenda Packet Page 35 of 88 07-18-2023 City Council Agenda Packet Page 36 of 88 07-18-2023 City Council Agenda Packet Page 37 of 88 07-18-2023 City Council Agenda Packet Page 38 of 88 07-18-2023 City Council Agenda Packet Page 39 of 88 07-18-2023 City Council Agenda Packet Page 40 of 88 07-18-2023 City Council Agenda Packet Page 41 of 88 07-18-2023 City Council Agenda Packet Page 42 of 88 07-18-2023 City Council Agenda Packet Page 43 of 88 07-18-2023 City Council Agenda Packet Page 44 of 88 07-18-2023 City Council Agenda Packet Page 45 of 88 07-18-2023 City Council Agenda Packet Page 46 of 88 In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the City Clerk at (509) 886-6103 (TTY 711). Notification 72 hours prior to the meeting will enable the City to make reasonable arrangements to ensure accessibility to the meeting (28 CFR 35.102-35.104 ADA Title 1.) 07-05-2023 City Council Meeting Minutes Page 1 of 2 East Wenatchee City Council Meeting Wednesday, July 05, 2023 East Wenatchee City Hall 271 9th Street NE East Wenatchee, WA 98802 Minutes In attendance: Staff in attendance: Mayor Jerrilea Crawford Sean Lewis, Assistant City Attorney Councilmember John Sterk Curtis Lillquist, Community Development Director Councilmember Harry Raab Trina Elmes, Event Director / PIO Councilmember Sasha Sleiman Josh DeLay, Finance Director Councilmember Christine Johnson Garren Melton, Public Works Manager Councilmember Matthew Hepner Anna Laura Leon, City Clerk 6:00 p.m. Regular Meeting. 1. Call to Order, Roll Call and Pledge of Allegiance. Motion by Councilmember Johnson to excuse Councilmember Magdoff from the meeting. Councilmember Hepner seconded the motion. Motion carried (5-0). 2. Consent Items: Motion to approve agenda, vouchers, and minutes from previous meetings. Vouchers: a. Date: 07-05-2023, Checks: 58758-58803, in the amount of $476,876.32. Minutes: b. 06-15-20323 Council Meeting Minutes. c. 06-20-2023 City Council Meeting Minutes. Motion by Councilmember Sleiman to approve consent items as presented. Councilmember Johnson seconded the motion. Motion carried (5-0). 3. Citizen Requests/Comments. None. 4. Action Items. a. Public Works Manager Garren Melton presented Resolution 2023-40, Interlocal Agreement with Douglas County for a joint application to the Safe Streets for All grant program. Comments provided by Councilmember Johnson. 07-18-2023 City Council Agenda Packet Page 47 of 88 In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the City Clerk at (509) 886-6103 (TTY 711). Notification 72 hours prior to the meeting will enable the City to make reasonable arrangements to ensure accessibility to the meeting (28 CFR 35.102-35.104 ADA Title 1.) 07-05-2023 City Council Meeting Minutes Page 2 of 2 Motion by Councilmember Hepner to approve Resolution 2023-40, authorizing Mayor Crawford to execute an Interlocal Agreement with Douglas County for a joint application to the Safe Streets for All grant program. Councilmember Sleiman seconded the motion. Motion carried (5-0). b. Public Works Manger Garren Melton presented Resolution 2023-41, granting a utility easement to the Douglas County PUD to maintain transmission lines crossing City Hall property. Motion by Councilmember Sleiman to approve Resolution 2023-41, authorizing Mayor Crawford to execute an easement agreement with Douglas County PUD. Councilmember Johnson seconded the motion. Motion carried (5-0). 5. Mayor’s Report. a. Mayor Crawford provided data on the calls received by the East Wenatchee Police Department regarding fireworks (leading up to and during the 4th of July). She noted education on the topic was strongly pushed by the department as this was the first- year fireworks were banned within city limits. Mayor Crawford indicated six brushfires were reported in the valley due to fireworks, one of which was within city limits. b. Mayor Crawford provided an update on the light that was installed at the intersection of 9th Street and Valley Mall Parkway. She noted that due to the amount of change, Public Works Manager Garren Melton hosted an Open House to provide local business owners with the opportunity to dialogue with staff members and keep them updated with projects in that area. c. Mayor Crawford invited the public and City Council to attend Pangborn’s Festival of Flight taking place on Saturday July 8th at Pangborn Airport. 6. Council Reports & Announcements. a. Councilmember Johnson suggested the display of American flags on 9th street in observance of Independence Day. Comments were provided by Mayor Crawford. 7. Adjournment. With no further business, the meeting was adjourned at 6:17 p.m. Jerrilea Crawford, Mayor Attest: Anna Laura Leon, City Clerk 07-18-2023 City Council Agenda Packet Page 48 of 88 David Bierschbach Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 49 of 88 Tamara Bierschbach Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 50 of 88 Amanda Bierschbach Jerrilea Crawford Mayor Herby recognizes and commends 2023 Student Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 51 of 88 Sarah Bierschbach Jerrilea Crawford Mayor Herby recognizes and commends 2023 Student Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 52 of 88 Ella Crawford Jerrilea Crawford Mayor Herby recognizes and commends 2023 Student Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 53 of 88 Peter Hauck Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 54 of 88 Jean Hauck Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 55 of 88 Dean Pope Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 56 of 88 Monica Pope Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 57 of 88 Chris O'Hearn Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 58 of 88 Robin O'Hearn Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 59 of 88 Sara Pritchard Jerrilea Crawford Mayor Herby recognizes and commends 2023 Adult Ambassador Wenatchee Valley Sister - City Delegation CITY OF EAST WENTACHEE Dated this 18th day of July 2023 07-18-2023 City Council Agenda Packet Page 60 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Date: July 18, 2023 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: May 2023 Financial Report This report provides a summary of the City’s overall financial operations through May 31, 2023. It offers a comparison of total overall revenues and expenditures between the current fiscal year and the same point in time as the last fiscal year. For the purposes of this report, operating funds are funds that receive general local tax support and/or expend wages and other steady expenses to support the day-to-day operations of the City. Non-operating funds are funds that are supported through special revenues and/or include non-wage and varying expenses (i.e., capital, grant projects, etc.). Table 1 below shows the City’s revenue collections through May 31, 2023, compared to revenue collections through May 31, 2022, along with the respective dollar and percentage variances for its operating funds. Table 1 May 31, 2023 May 31, 2022 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 3,350,756 3,093,469 257,287 8.32% Rainy Day Fund - 002 486 - 486 - Street Fund - 101 1,161,448 1,159,239 2,209 0.19% Events Board Fund - 117 160,600 73,739 86,861 117.79% Equipment R&R Fund - 501 273,880 211,486 62,394 29.50% Total Revenues - Operating Funds 4,947,171 4,537,934 409,237 9.02% Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-6101 * F: (509) 884-6233 Email: jdelay@eastwenatcheewa.gov 07-18-2023 City Council Agenda Packet Page 61 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Chart 1 is a graphical representation of year over year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through May 31, 2023, compared to revenue collections through May 31, 2022, along with the respective dollar and percentage variances for its non-operating funds. 07-18-2023 City Council Agenda Packet Page 62 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Table 2 May 31, 2023 May 31, 2022 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 262,852 76,136 186,716 245.24% Affordable Housing Tax Fund - 103 10,875 11,009 (134) (1.22%) Housing & Related Services Fund - 104 235,598 227,943 7,655 3.36% Trans Benefit District Fund - 105 151,760 99,785 51,975 52.09% SWAT Fund - 107 58,521 58,500 21 0.04% Library Fund - 112 16 17 (1) (6.34%) Hotel/Motel Tax Fund - 113 138,776 135,032 3,744 2.77% Drug Fund - 114 8 11 (3) (24.38%) Criminal Justice Fund - 116 11,258 10,755 503 4.68% Bond Redemption Fund - 202 31 501 (470) (93.75%) Street Improvements Fund - 301 572,229 418,272 153,958 36.81% Capital Improvements Fund - 314 153,090 202,833 (49,743) (24.52%) Storm Water Fund - 401 309,436 528,622 (219,185) (41.46%) Total Revenues - Non-Operating Funds 1,904,450 1,769,417 135,034 7.63% Revenues - Non-Operating Funds Chart 2 is a graphical representation of year-over-year revenue comparisons for the City’s non- operating funds. Chart 2 07-18-2023 City Council Agenda Packet Page 63 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Revenue Highlights: General Fund revenues are up $257,287, or 8.32%, year over year primarily due to a:  $116,355 increase in interest earnings; a  $105,748 increase in sales tax collections; and a  $43,544 increase in reimbursements from the Eastmont School District for the School Resource Officers. The above increases are slightly offset by decreases in phone/cellular utility tax ($58,334) and criminal justice sales tax ($55,612) Events Fund revenues are up $86,861, or 117.79%, year over year due to the timing of transfers from the Hotel/Motel Fund as well as a $7,200 increase in sponsorships for Classy Chassis. Equipment R&R Fund revenues are up $62,394, or 29.50%, year over year due to the timing of rental rate transfers received from the departments paying into this fund. Community Development Grants Fund revenues are up $186,716, or 245.24%, year over year due to reimbursements related to the Hamilton St. project. Transportation Benefit District Fund revenues are up $51,975, or 52.09%, year over year because the City now receives a .1% sales tax revenue instead of the car tab fee revenue. Street Improvements Fund revenues are up $153,958, or 36.81%, year over year due to the timing of grant reimbursements, and the size of projects planned in 2023. Capital Improvements Fund revenues are down $49,743, or 24.52%, year over year because real estate excise tax (REET) collections are lower presumably due to less real estate sales. Storm Water Fund revenues are down $219,185, or 41.46%, year over year due to funds received for the Stormwater Comp Plan Ecology grant in 2022 that the City is not receiving in 2023, and less stormwater fees collected now versus 2022. 07-18-2023 City Council Agenda Packet Page 64 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Table 3 below shows the City’s expenditures through May 31, 2023, compared to expenditures through May 31, 2022, along with respective dollar and percentage variances for its operating funds. Table 3 May 31, 2023 May 31, 2022 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 3,488,508 3,339,415 149,094 4.46% Rainy Day Fund - 002 - - - - Street Fund - 101 550,254 613,677 (63,423) (10.33%) Events Board Fund - 117 67,052 45,019 22,033 48.94% Equipment R&R Fund - 501 92,007 472,393 (380,386) (80.52%) Total Expenditures - Operating Funds 4,197,821 4,470,503 (272,683) (6.10%) Expenditures - Operating Funds Chart 3 is a graphical representation of year over year expenditure comparisons for the City’s operating funds. Chart 3 07-18-2023 City Council Agenda Packet Page 65 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Table 4 below shows the City’s expenditures through May 31, 2023, compared to expenditures through May 31, 2022, along with respective dollar and percentage variances for its non-operating funds. Table 4 May 31, 2023 May 31, 2022 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 476 - 476 - Affordable Housing Tax Fund - 103 - - - - Housing & Related Services Fund - 104 - - - - Trans Benefit District Fund - 105 182 - 182 - SWAT Fund - 107 1,080 12,800 (11,720) - Library Fund - 112 2,356 598 1,758 293.86% Hotel/Motel Tax Fund - 113 189,310 108,310 81,000 74.79% Drug Fund - 114 229 221 8 3.59% Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 5,857 130,000 (124,143) - Street Improvements Fund - 301 200,105 274,721 (74,616) (27.16%) Capital Improvements Fund - 314 2,178,494 119,031 2,059,464 1730.19% Storm Water Fund - 401 296,420 169,331 127,089 75.05% Total Expenditures - Non-Operating Funds 2,874,510 815,012 2,059,498 252.70% Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year-over-year expenditure comparisons for the City’s non- operating funds. Chart 4 07-18-2023 City Council Agenda Packet Page 66 of 88 City of East Wenatchee May 2023 Financial Report July 18, 2023, City Council Meeting Expenditure Highlights: General Fund expenditures are up $149,094, or 4.46%, year over year for a variety of reasons, but mainly due to salary and benefit increases. Street Fund expenditures are down $63,423, or 10.33%, year over year primarily due to the timing of the invoice related to the City’s stormwater fees. Events Board Fund expenditures are up $22,033, or 48.94%, year over year due to the purchase of two picnic tables for Gateway Park, increased expenses for Classy Chassis, and salary/benefit increases. Equipment R&R Fund expenditures are down $380,386, or 80.52%, year over year due to the timing of police and street vehicle purchases. Hotel/Motel Tax Fund expenditures are up $81,000, or 74.79%, year over year due to the timing of transfers made to the Events Fund as approved by the East Wenatchee Events Board. Street Improvements Fund expenditures are down $74,616, or 27.16%, year over year due to normal timing and project size variations typically associated with this fund. Capital Improvements Fund expenditures are up $2,059,464, or 1,730.19%, year over year due to the new maintenance facilities construction. Storm Water Fund expenditures are up $127,089, or 75.05%, year over year primarily because of the timing of interfund transfers for vehicle/equipment rental rates in addition to expenses related to various grant funded projects. The reports presented in the following pages represent accounting system generated line-item details of revenues, expenditures, budgets, and cash balances for each fund through May 31, 2023. 07-18-2023 City Council Agenda Packet Page 67 of 88 Account Number Title Period Fiscal Budget % of Total Balance General Fund         Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $245,015.70 $470,504.00 $1,340,000.00 35.11 %$869,496.00 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $411,954.55 $1,471,811.28 $4,200,000.00 35.04 %$2,728,188.72 001-000-000-313-71-00-00 Criminal Justice Sales Tax $35,519.63 $171,046.49 $450,000.00 38.01 %$278,953.51 001-000-000-316-40-00-00 Electric Utility Tax $32,218.58 $204,087.73 $370,000.00 55.16 %$165,912.27 001-000-000-316-45-00-00 Natural Gas Utility Tax $5,018.32 $46,223.40 $45,000.00 102.72 %($1,223.40) 001-000-000-316-84-00-00 Gambling Tax $75,188.59 $283,829.49 $500,000.00 56.77 %$216,170.51 Total Taxes $804,915.37 $2,647,502.39 $6,905,000.00 38.34 %$4,257,497.61 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $100.00 $0.00 ($100.00) 001-000-000-321-60-00-00 Taxicab Licenses & Permits $0.00 $286.00 $1,000.00 28.60 %$714.00 001-000-000-321-91-00-50 Franchise Fees - Cable $21,384.08 $43,512.35 $85,000.00 51.19 %$41,487.65 001-000-000-321-91-00-60 Franchise Fees - Fiber Optics $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-000-321-99-00-00 Business Licenses & Permits $15,829.19 $72,092.04 $165,000.00 43.69 %$92,907.96 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $0.00 $660.00 0.00 %$660.00 001-000-000-322-10-00-00 Building & Structure Permits $6,719.05 $27,134.50 $100,000.00 27.13 %$72,865.50 001-000-000-322-90-01-00 Gun Permits $558.25 $2,980.50 $6,000.00 49.68 %$3,019.50 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $125.00 0.00 %$125.00 Total Licenses and Permits $44,490.57 $146,105.39 $361,785.00 40.38 %$215,679.61 Intergovernmental Revenues 001-000-000-334-01-20-00 WaState Court Equip Reimb $0.00 $20,000.00 $18,000.00 111.11 %($2,000.00) 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $2,839.73 $2,839.73 $3,000.00 94.66 %$160.27 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $724.48 $3,000.00 24.15 %$2,275.52 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $0.00 $0.00 $11,000.00 0.00 %$11,000.00 001-000-000-335-00-91-00 PUD Privilege Tax $47,521.26 $47,521.26 $44,000.00 108.00 %($3,521.26) 001-000-000-336-00-98-03 City Assistance $0.00 $19,371.60 $120,000.00 16.14 %$100,628.40 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $11,364.19 $30,000.00 37.88 %$18,635.81 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $34.64 $2,000.00 1.73 %$1,965.36 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $49,699.53 $97,000.00 51.24 %$47,300.47 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $27,102.69 $108,000.00 25.10 %$80,897.31 001-000-000-337-00-00-01 ESD SRO Reimbursement $0.00 $43,544.29 $160,000.00 27.22 %$116,455.71 001-000-000-338-21-01-00 Eastmont School District - Sro $0.00 $2,839.00 $0.00 ($2,839.00)         Total Intergovernmental Revenues $50,360.99 $225,041.41 $597,000.00 37.70 %$371,958.59         Charges for Goods and Services Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-00-00-05 Stormwater - Fleet Maintenance Rentals Period: 2023 - May 2023 07-18-2023 City Council Agenda Packet Page 68 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $90.00 0.00 %$90.00 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $0.00 $0.00 $70.00 0.00 %$70.00 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $60.00 0.00 %$60.00 001-000-000-341-35-35-00 Waste Management Admin fee $7,957.23 $38,679.24 $80,000.00 48.35 %$41,320.76 001-000-000-342-10-00-00 Patrol Reimbursement $0.00 $3,157.08 $0.00 ($3,157.08) 001-000-000-342-33-00-00 Adult Probation Services $0.00 $13,455.87 $35,000.00 38.45 %$21,544.13 001-000-000-342-36-00-00 Housing of Prisoners $0.00 $1,142.29 $4,000.00 28.56 %$2,857.71 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $246.00 $3,000.00 8.20 %$2,754.00 001-000-000-345-83-00-00 Plan Checking Fees $0.00 $1,038.93 $45,000.00 2.31 %$43,961.07 001-000-000-345-83-41-00 Engineering Review Fees $4,254.61 $13,970.76 $1,000.00 1,397.08 %($12,970.76) 001-000-000-345-86-00-00 Sepa Permits $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-000-345-89-00-00 Planning & Development Fees $282.00 $1,062.00 $10,000.00 10.62 %$8,938.00 001-000-000-345-89-00-01 Re-Inspection Fee $0.00 $750.00 $0.00 ($750.00)         Total Charges for Goods and Services $12,493.84 $73,502.17 $179,520.00 40.94 %$106,017.83         Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $0.00 $44,576.53 $70,000.00 63.68 %$25,423.47 001-000-000-357-33-00-00 Public Defender Costs $0.00 $3,206.93 $6,500.00 49.34 %$3,293.07 001-000-000-357-35-00-00 Restitution $0.00 $0.00 $400.00 0.00 %$400.00 Total Fines and Penalties $0.00 $47,783.46 $76,900.00 62.14 %$29,116.54 Miscellaneous Revenues 001-000-000-361-10-00-00 Interest Earnings $26,716.69 $126,564.91 $55,000.00 230.12 %($71,564.91) 001-000-000-361-40-00-00 Sales Tax Interest $1,090.76 $5,581.85 $4,000.00 139.55 %($1,581.85) 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $2,841.95 $3,943.17 $12,000.00 32.86 %$8,056.83 001-000-000-362-00-00-01 Rental Income - 50 Simon Street $0.00 $750.00 $48,000.00 1.56 %$47,250.00 001-000-000-362-00-00-03 Rental Income - Chelan County CRDTF / 50 Simon Street $0.00 $18,750.00 $0.00 ($18,750.00) 001-000-000-367-00-00-00 Contributions from Nongovernmental Sources $0.00 $16,394.84 $0.00 ($16,394.84) 001-000-000-369-10-00-00 Sales of Surplus Property $0.00 $184.72 $0.00 ($184.72) 001-000-000-369-40-00-00 Opiod Settlement $0.00 $12,813.73 $0.00 ($12,813.73) 001-000-000-369-91-50-00 Miscellaneous Revenue $1,856.70 $12,238.42 $7,000.00 174.83 %($5,238.42)         Total Miscellaneous Revenues $32,506.10 $197,221.64 $126,000.00 156.53 %($71,221.64)         Other Increases in Fund Resources 001-000-000-389-30-40-00 Engineering Reimbursements $0.00 $31.50 $0.00 ($31.50)         Total Other Increases in Fund Resources $0.00 $31.50 $0.00 ($31.50)         Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-398-10-00-00 Insurance Recoveries $0.00 $13,567.98 $0.00 ($13,567.98) Total Other Financing Sources $0.00 $13,567.98 $1,100.00 1,233.45 %($12,467.98) Total General Fund $944,766.87 $3,350,755.94 $8,247,305.00 40.63 %$4,896,549.06 Rainy Day Fund 002-000-000-361-10-00-00 Interest Earnings $0.00 $486.23 $0.00 ($486.23) 07-18-2023 City Council Agenda Packet Page 69 of 88 Account Number Title Period Fiscal Budget % of Total Balance 002-000-000-397-00-00-00 Transfer In - General Fund $0.00 $0.00 $50,000.00 0.00 %$50,000.00 Total Rainy Day Fund $0.00 $486.23 $50,000.00 0.97 %$49,513.77 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $500,000.00 $500,000.00 $500,000.00 100.00 %$0.00 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $550,000.00 $550,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $0.00 $500.00 $2,000.00 25.00 %$1,500.00 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $4,602.72 $18,000.00 25.57 %$13,397.28 101-000-000-336-00-87-00 Gas Tax $21,434.09 $95,154.11 $258,000.00 36.88 %$162,845.89 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $4,027.42 $16,000.00 25.17 %$11,972.58 101-000-000-361-10-00-00 Interest Earnings $0.00 $201.93 $300.00 67.31 %$98.07 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $0.00 $500.00 0.00 %$500.00 101-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $6,962.06 $0.00 ($6,962.06) Total Street Fund $521,434.09 $1,161,448.24 $1,344,800.00 86.37 %$183,351.76 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $262,775.12 $180,589.00 145.51 %($82,186.12) 102-000-000-361-10-00-00 Interest Earnings $0.00 $77.08 $0.00 ($77.08) Total Community Development Grants Fund $0.00 $262,852.20 $180,589.00 145.55 %($82,263.20) Affordable Housing Sales Tax Fund 103-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $0.00 $10,817.05 $32,000.00 33.80 %$21,182.95 103-000-000-361-10-00-00 Interest Earnings $0.00 $57.67 $100.00 57.67 %$42.33 Total Affordable Housing Sales Tax Fund $0.00 $10,874.72 $32,100.00 33.88 %$21,225.28 Housing & Related Services Fund 104-000-000-313-25-00-00 Housing & Related Services Sales/Use Tax $48,655.22 $235,591.48 $440,000.00 53.54 %$204,408.52 104-000-000-361-10-00-00 Interest Earnings $0.00 $6.49 $0.00 ($6.49) Total Housing & Related Services Fund $48,655.22 $235,597.97 $440,000.00 53.54 %$204,402.03 Transportation Benefit District Fund 105-000-000-313-21-00-00 Transportation Benefit District Sales Tax $47,767.27 $127,615.14 $400,000.00 31.90 %$272,384.86 105-000-000-317-60-00-00 Car Tab Fees $1,207.80 $23,779.80 $0.00 ($23,779.80) 105-000-000-361-10-00-00 Interest Earnings $0.00 $364.89 $1,000.00 36.49 %$635.11 Total Transportation Benefit District Fund $48,975.07 $151,759.83 $401,000.00 37.85 %$249,240.17 SWAT Fund 107-000-000-337-00-00-01 CCSO SWAT Fee $0.00 $15,000.00 $15,000.00 100.00 %$0.00 107-000-000-337-00-00-02 City of Wenatchee SWAT Fee $0.00 $15,000.00 $15,000.00 100.00 %$0.00 107-000-000-337-00-00-03 DCSO SWAT Fee $0.00 $15,000.00 $15,000.00 100.00 %$0.00 107-000-000-361-10-00-00 Interest Earnings $0.00 $20.50 $0.00 ($20.50) 107-000-000-397-00-00-00 Transfer-In - General Fund EWPD SWAT Fee $0.00 $13,500.00 $13,500.00 100.00 %$0.00 Total SWAT Fund $0.00 $58,520.50 $58,500.00 100.04 %($20.50) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $7,500.00 0.00 %$7,500.00 112-000-000-361-10-00-00 Interest Earnings $0.00 $16.11 $25.00 64.44 %$8.89 Total Library Fund $0.00 $16.11 $7,525.00 0.21 %$7,508.89 07-18-2023 City Council Agenda Packet Page 70 of 88 Account Number Title Period Fiscal Budget % of Total Balance Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $28,855.80 $138,469.71 $300,000.00 46.16 %$161,530.29 113-000-000-361-10-00-00 Interest Earnings $0.00 $306.22 $500.00 61.24 %$193.78 Total Hotel/Motel Tax Fund $28,855.80 $138,775.93 $300,500.00 46.18 %$161,724.07 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.00 $6.39 $100.00 6.39 %$93.61 114-000-000-361-10-00-00 Interest Earnings $0.00 $1.55 $0.00 ($1.55) Total Drug Fund $0.00 $7.94 $100.00 7.94 %$92.06 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $2,480.27 $4,500.00 55.12 %$2,019.73 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $8,774.36 $16,000.00 54.84 %$7,225.64 116-000-000-361-10-00-00 Interest Earnings $0.00 $3.73 $0.00 ($3.73) Total Criminal Justice Fund $0.00 $11,258.36 $20,500.00 54.92 %$9,241.64 Events Board Fund 117-000-100-361-10-00-00 Interest Earnings $0.00 $16.34 $0.00 ($16.34) 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $136,000.00 $136,000.00 100.00 %$0.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $5,792.69 $12,787.69 $9,000.00 142.09 %($3,787.69) 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $500.00 $750.00 $150.00 500.00 %($600.00) 117-000-300-347-90-00-12 Classy Chassis Sponsorships $1,600.00 $8,800.00 $7,600.00 115.79 %($1,200.00) 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $2,245.81 $2,245.81 $500.00 449.16 %($1,745.81) 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-620-367-00-00-00 PFOF Sponsorships $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Events Board Fund $10,138.50 $160,599.84 $156,750.00 102.46 %($3,849.84) Bond Redemption Fund 202-000-000-361-10-00-00 Interest Earnings $0.00 $31.31 $1,000.00 3.13 %$968.69 202-000-000-397-00-00-01 Transfer-In - Fund 314 $0.00 $0.00 $680,000.00 0.00 %$680,000.00 202-000-000-397-00-00-02 Transfer-In - Fund 001 $0.00 $0.00 $80,000.00 0.00 %$80,000.00 Total Bond Redemption Fund $0.00 $31.31 $761,000.00 0.00 %$760,968.69 Street Improvements Fund 301-000-000-330-00-00-04 County Sales/Use Tax - Hamilton St. Improvements $0.00 $228,000.00 $0.00 ($228,000.00) 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $118,470.20 $100,000.00 118.47 %($18,470.20) 301-000-000-333-20-00-19 EWWD VMP Grant to 9th Overlay $0.00 $153,061.88 $0.00 ($153,061.88) 301-000-000-333-20-00-22 SRTS - 5th St NE: Sterling $0.00 $0.00 $2,847,000.00 0.00 %$2,847,000.00 301-000-000-333-20-00-23 SRTS - 5th St NE: Kenroy $0.00 $0.00 $3,058,000.00 0.00 %$3,058,000.00 301-000-000-333-20-00-24 NHS - Grant Rd. Overlay Grover to Kentucky $0.00 $13,274.23 $256,000.00 5.19 %$242,725.77 301-000-000-333-20-00-25 NHS - Grant/Highline PCCP Intersection $0.00 $33,192.39 $1,325,000.00 2.51 %$1,291,807.61 301-000-000-333-20-00-26 NHFP Grant Road Overlay $0.00 $6,625.58 $0.00 ($6,625.58) 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $16,344.22 $714,000.00 2.29 %$697,655.78 301-000-000-334-03-80-23 TIB Grant Rd. Overlay Eastmont to Grover $0.00 $0.00 $758,500.00 0.00 %$758,500.00 301-000-000-334-03-80-26 TIB APP Overlay - RI Road $0.00 $0.00 $445,000.00 0.00 %$445,000.00 301-000-000-337-00-00-03 EWWD - Hamilton St. Improvements $0.00 $1,084.00 $0.00 ($1,084.00) 301-000-000-337-00-00-04 DCSD - Hamilton St. Improvements $0.00 $2,168.00 $0.00 ($2,168.00) 07-18-2023 City Council Agenda Packet Page 71 of 88 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-361-10-00-00 Interest Earnings $0.00 $8.97 $0.00 ($8.97) 301-000-000-397-00-00-00 Transfer-In - Fund 401 $0.00 $0.00 $200,000.00 0.00 %$200,000.00 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $600,000.00 0.00 %$600,000.00 Total Street Improvements Fund $0.00 $572,229.47 $10,303,500.00 5.55 %$9,731,270.53 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $16,690.46 $150,320.68 $600,000.00 25.05 %$449,679.32 314-000-000-361-10-00-00 Interest Earnings $0.00 $2,768.96 $1,500.00 184.60 %($1,268.96) Total Capital Improvements Fund $16,690.46 $153,089.64 $601,500.00 25.45 %$448,410.36 Stormwater Fund 401-000-000-330-00-00-00 19th St. Douglas Co. Match $0.00 $0.00 $290,000.00 0.00 %$290,000.00 401-000-000-334-03-10-00 Dept. of Ecology Capacity Grant $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $0.00 $2,118,288.00 0.00 %$2,118,288.00 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $9,556.10 $0.00 ($9,556.10) 401-000-000-334-03-10-03 Pace Pond Ecology Grant $0.00 $0.00 $808,500.00 0.00 %$808,500.00 401-000-000-334-03-80-00 19th St. TIB Grant $0.00 $0.00 $2,000,000.00 0.00 %$2,000,000.00 401-000-000-343-10-00-00 SWU Fee $157,221.00 $280,710.00 $525,000.00 53.47 %$244,290.00 401-000-000-361-10-00-00 Interest Earnings $48.96 $867.78 $0.00 ($867.78) 401-000-000-369-91-00-00 Miscellaneous Revenue $0.00 $17,414.03 $0.00 ($17,414.03) 401-000-000-382-30-00-00 Non-Fiduciary Collections $0.00 $888.54 $0.00 ($888.54) Total Stormwater Fund $157,269.96 $309,436.45 $5,791,788.00 5.34 %$5,482,351.55 Equipment Purchase, Repair & Replacement Fund 501-000-000-361-10-00-00 Interest Earnings $0.00 $364.94 $0.00 ($364.94) 501-000-000-369-10-00-01 Surplus Vehicle Sales - Street $0.00 $13,400.00 $0.00 ($13,400.00) 501-000-000-395-20-00-00 Insurance Recoveries - Police $0.00 $3,223.42 $0.00 ($3,223.42) 501-000-000-397-00-00-00 Transfer In - General Fund $0.00 $0.00 $300,000.00 0.00 %$300,000.00 501-000-000-397-00-00-02 Transfer-In - Criminal Justice Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 501-000-000-397-00-00-03 Police - Fleet Maintenance Rentals $0.00 $100,000.00 $100,000.00 100.00 %$0.00 501-000-000-397-00-00-04 Street - Fleet Maintenance Rentals $0.00 $100,000.00 $100,000.00 100.00 %$0.00 501-000-000-397-00-00-05 Stormwater - Fleet Maintenance Rentals $0.00 $56,892.12 $57,000.00 99.81 %$107.88 Total Equipment Purchase, Repair & Replacement Fund $0.00 $273,880.48 $577,000.00 47.47 %$303,119.52 Grand Totals $1,776,785.97 $6,851,621.16 $29,274,457.00 23.40 %$22,422,835.84 07-18-2023 City Council Agenda Packet Page 72 of 88 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $944,766.87 $3,350,755.94 $8,247,305.00 40.63 %$4,896,549.06 002-000-000-000-00-00-00 Rainy Day Fund $0.00 $486.23 $50,000.00 0.97 %$49,513.77 101-000-000-000-00-00-00 Street Fund $521,434.09 $1,161,448.24 $1,344,800.00 86.37 %$183,351.76 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $262,852.20 $180,589.00 145.55 %($82,263.20) 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $0.00 $10,874.72 $32,100.00 33.88 %$21,225.28 104-000-000-000-00-00-00 Housing & Related Services Fund $48,655.22 $235,597.97 $440,000.00 53.54 %$204,402.03 105-000-000-000-00-00-00 Transportation Benefit District Fund $48,975.07 $151,759.83 $401,000.00 37.85 %$249,240.17 107-000-000-000-00-00-00 SWAT Fund $0.00 $58,520.50 $58,500.00 100.04 %($20.50) 112-000-000-000-00-00-00 Library Fund $0.00 $16.11 $7,525.00 0.21 %$7,508.89 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $28,855.80 $138,775.93 $300,500.00 46.18 %$161,724.07 114-000-000-000-00-00-00 Drug Fund $0.00 $7.94 $100.00 7.94 %$92.06 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $11,258.36 $20,500.00 54.92 %$9,241.64 117-000-000-000-00-00-00 Events Board Fund $10,138.50 $160,599.84 $156,750.00 102.46 %($3,849.84) 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $31.31 $761,000.00 0.00 %$760,968.69 301-000-000-000-00-00-00 Street Improvements Fund $0.00 $572,229.47 $10,303,500.00 5.55 %$9,731,270.53 314-000-000-000-00-00-00 Capital Improvements Fund $16,690.46 $153,089.64 $601,500.00 25.45 %$448,410.36 401-000-000-000-00-00-00 Stormwater Fund $157,269.96 $309,436.45 $5,791,788.00 5.34 %$5,482,351.55 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $273,880.48 $577,000.00 47.47 %$303,119.52 Grand Totals $1,776,785.97 $6,851,621.16 $29,274,457.00 23.40 %$22,422,835.84 07-18-2023 City Council Agenda Packet Page 73 of 88 Account Number Title Period Fiscal Budget % of Total Balance General Fund     General Government 001-000-001-518-63-40-00 Flywheel Conference $0.00 $5,000.00 $5,000.00 100.00 %$0.00 001-000-001-518-90-40-00 GWATA Membership $0.00 $0.00 $315.00 0.00 %$315.00 001-000-001-518-91-30-00 Wellness $296.62 $817.88 $3,000.00 27.26 %$2,182.12 001-000-001-518-93-49-00 City Theme $0.00 $0.00 $750.00 0.00 %$750.00 001-000-001-521-10-29-00 LEOFF 1 Insurance Premiums $4,455.00 $11,137.50 $27,000.00 41.25 %$15,862.50 001-000-001-521-10-41-01 Emergency Management Contract $0.00 $11,191.59 $44,000.00 25.44 %$32,808.41 001-000-001-528-70-40-00 River Com $14,670.17 $73,350.85 $261,251.00 28.08 %$187,900.15 001-000-001-531-00-40-00 Annual SWU Charge $0.00 $4,632.52 $87,000.00 5.32 %$82,367.48 001-000-001-539-30-40-00 Animal Control $7,401.66 $37,008.30 $89,000.00 41.58 %$51,991.70 001-000-001-553-70-40-00 Douglas County Solid Waste Removal $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $17,552.00 $17,000.00 103.25 %($552.00) 001-000-001-558-70-40-00 Contributions - Region $0.00 $40,000.00 $40,000.00 100.00 %$0.00 001-000-001-558-70-41-00 NCW Economic Development District $0.00 $3,000.00 $1,250.00 240.00 %($1,750.00) 001-000-001-558-70-41-05 NCWEDD Chelan/Douglas Trends $0.00 $1,600.00 $0.00 ($1,600.00) 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $900.00 $900.00 100.00 %$0.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $5,062.00 $25,310.00 $61,000.00 41.49 %$35,690.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$1,012.01 $2,099.41 $3,600.00 58.32 %$1,500.59 001-000-001-597-00-00-01 Transfer-Out - ER&R Fund $0.00 $0.00 $300,000.00 0.00 %$300,000.00 001-000-001-597-00-00-02 Transfer-Out - Rainy Day Fund $0.00 $0.00 $50,000.00 0.00 %$50,000.00 001-000-001-597-00-00-03 Transfer-Out - 202 Fund $0.00 $0.00 $80,000.00 0.00 %$80,000.00 Total General Government $32,897.46 $233,600.05 $1,094,066.00 21.35 %$860,465.95 Legislative 001-000-110-511-60-10-00 Salaries $4,801.86 $24,093.72 $58,000.00 41.54 %$33,906.28 001-000-110-511-60-20-00 Benefits $369.53 $1,847.65 $4,500.00 41.06 %$2,652.35 001-000-110-511-60-21-50 Public Defender $13,630.94 $66,626.78 $158,000.00 42.17 %$91,373.22 001-000-110-511-60-30-00 Public Defender Conflicts $0.00 $594.00 $2,000.00 29.70 %$1,406.00 001-000-110-511-60-31-00 Office Supplies $84.93 $315.35 $650.00 48.52 %$334.65 001-000-110-511-60-40-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-110-511-60-41-00 Professional Services $0.00 $13,548.91 $12,000.00 112.91 %($1,548.91) 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $11,084.00 $10,613.00 104.44 %($471.00) 001-000-110-511-60-43-00 Travel $0.00 $0.00 $1,250.00 0.00 %$1,250.00 001-000-110-511-60-43-01 Travel - Misawa $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-110-511-60-44-00 Advertising $101.35 $715.42 $1,000.00 71.54 %$284.58 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $24,066.02 $25,000.00 96.26 %$933.98 001-000-110-511-60-46-00 Insurance $34.56 $70.92 $11,563.00 0.61 %$11,492.08 Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-51-00-00 Assigned Cash and Investments - Ending Period: 2023 - May 2023 07-18-2023 City Council Agenda Packet Page 74 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-47-00 Background Check Costs $0.00 $37.34 $200.00 18.67 %$162.66 001-000-110-511-60-49-00 Miscellaneous $0.00 $0.00 $2,500.00 0.00 %$2,500.00 Total Legislative $19,023.17 $143,000.11 $293,776.00 48.68 %$150,775.89 Mayor's Office 001-000-111-513-10-10-00 Salaries $8,831.62 $43,933.84 $108,000.00 40.68 %$64,066.16 001-000-111-513-10-20-00 Benefits $3,993.88 $19,581.66 $34,000.00 57.59 %$14,418.34 001-000-111-513-10-30-00 Office Supplies $0.00 $16.29 $250.00 6.52 %$233.71 001-000-111-513-10-40-00 Publications $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-111-513-10-40-01 Training $0.00 $321.49 $2,000.00 16.07 %$1,678.51 001-000-111-513-10-40-02 Professional Services $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-111-513-10-40-03 Cell Phone $0.00 $123.83 $550.00 22.51 %$426.17 001-000-111-513-10-40-04 Travel $0.00 $564.19 $1,000.00 56.42 %$435.81 001-000-111-513-10-40-05 Insurance $34.56 $822.49 $10,500.00 7.83 %$9,677.51 001-000-111-513-10-40-06 Miscellaneous $28.00 $107.25 $250.00 42.90 %$142.75 Total Mayor's Office $12,888.06 $65,471.04 $181,550.00 36.06 %$116,078.96 Municipal Court 001-000-120-512-50-20-00 Benefits $0.00 $3,252.44 $0.00 ($3,252.44) 001-000-120-512-50-31-00 Office Supplies $0.00 $43.89 $0.00 ($43.89) 001-000-120-512-51-10-00 Salaries $25,926.05 $125,393.10 $303,000.00 41.38 %$177,606.90 001-000-120-512-51-10-01 Salaries - Probation $5,998.70 $27,787.90 $67,000.00 41.47 %$39,212.10 001-000-120-512-51-20-00 Benefits $15,104.65 $49,075.67 $118,000.00 41.59 %$68,924.33 001-000-120-512-51-20-01 Benefits - Probation $5,580.41 $16,636.55 $41,000.00 40.58 %$24,363.45 001-000-120-512-51-30-00 Supplies $38.15 $4,115.28 $4,500.00 91.45 %$384.72 001-000-120-512-51-40-00 Training $0.00 $175.00 $1,500.00 11.67 %$1,325.00 001-000-120-512-51-40-01 IT Services $0.00 $0.00 $2,705.00 0.00 %$2,705.00 001-000-120-512-51-40-02 Insurance $57.61 $869.78 $19,000.00 4.58 %$18,130.22 001-000-120-512-51-40-03 Miscellaneous $89.26 $89.26 $500.00 17.85 %$410.74 001-000-120-512-51-40-04 Interpreting $0.00 $720.00 $5,000.00 14.40 %$4,280.00 001-000-120-512-51-40-05 Judge Protems $300.00 $1,575.00 $6,000.00 26.25 %$4,425.00 001-000-120-512-51-40-06 Witness Fees $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-120-512-51-40-07 Juror Fees $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-120-512-51-40-08 Security $698.41 $1,383.48 $6,000.00 23.06 %$4,616.52 001-000-120-512-51-40-09 Travel $595.97 $595.97 $6,000.00 9.93 %$5,404.03 001-000-120-591-12-70-00 Copy Machine Lease $0.00 $620.05 $0.00 ($620.05) 001-000-120-594-12-60-00 Capital Outlay $0.00 $943.58 $5,000.00 18.87 %$4,056.42 Total Municipal Court $54,389.21 $233,276.95 $588,705.00 39.63 %$355,428.05 Human Resources 001-000-139-518-10-10-00 Salaries $3,826.89 $16,684.25 $50,000.00 33.37 %$33,315.75 001-000-139-518-10-20-00 Benefits $1,279.15 $6,009.38 $21,000.00 28.62 %$14,990.62 001-000-139-518-10-30-00 Office Supplies $0.00 $82.86 $500.00 16.57 %$417.14 001-000-139-518-10-40-00 Training $0.00 $425.00 $1,300.00 32.69 %$875.00 001-000-139-518-10-40-01 Membership Dues & Publications $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-02 Travel $134.50 $134.50 $1,000.00 13.45 %$865.50 001-000-139-518-10-40-03 Advertising $0.00 $779.71 $5,000.00 15.59 %$4,220.29 001-000-139-518-10-40-04 Insurance $11.52 $23.64 $5,000.00 0.47 %$4,976.36 07-18-2023 City Council Agenda Packet Page 75 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-139-518-10-40-05 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-139-518-10-40-06 Miscellaneous $0.00 $0.00 $250.00 0.00 %$250.00 001-000-139-518-10-40-07 Pre-Employment Services $37.05 $151.81 $700.00 21.69 %$548.19 001-000-139-518-10-40-08 Professional Services $0.00 $212.22 $1,000.00 21.22 %$787.78 Total Human Resources $5,289.11 $24,503.37 $87,000.00 28.16 %$62,496.63 City Clerk 001-000-140-514-20-10-00 Salaries $6,075.86 $30,494.08 $109,000.00 27.98 %$78,505.92 001-000-140-514-20-20-00 Benefits $3,237.01 $17,210.25 $44,000.00 39.11 %$26,789.75 001-000-140-514-20-31-00 Office Supplies $632.02 $1,629.75 $3,000.00 54.33 %$1,370.25 001-000-140-514-20-31-01 Central Stores $887.30 $2,540.81 $7,500.00 33.88 %$4,959.19 001-000-140-514-20-40-00 Training $0.00 $675.00 $4,000.00 16.88 %$3,325.00 001-000-140-514-20-40-01 Records Services $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-140-514-20-40-02 Codification $0.00 $903.81 $10,000.00 9.04 %$9,096.19 001-000-140-514-20-41-00 Membership Dues & Publications $100.00 $285.00 $1,200.00 23.75 %$915.00 001-000-140-514-20-42-01 Telephone $0.00 $104.50 $0.00 ($104.50) 001-000-140-514-20-43-00 Travel $0.00 $1,333.48 $3,500.00 38.10 %$2,166.52 001-000-140-514-20-44-00 Advertising $0.00 $649.76 $2,000.00 32.49 %$1,350.24 001-000-140-514-20-45-00 Professional Services $210.50 $210.50 $20,000.00 1.05 %$19,789.50 001-000-140-514-20-46-00 Insurance $28.80 $810.67 $9,000.00 9.01 %$8,189.33 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-48-01 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $67.00 $500.00 13.40 %$433.00 001-000-140-514-26-40-00 Public Records Requests $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-81-40-00 Taxi License Background Fee $0.00 $0.00 $300.00 0.00 %$300.00 001-000-140-582-10-40-00 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 001-000-140-594-20-60-00 Gov QA - Public Records $0.00 $9,195.38 $9,000.00 102.17 %($195.38) Total City Clerk $11,171.49 $66,109.99 $231,300.00 28.58 %$165,190.01 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $0.00 $1,039.32 $12,500.00 8.31 %$11,460.68 001-000-141-514-20-42-01 Telephone Line Charges $2,227.42 $15,673.25 $20,000.00 78.37 %$4,326.75 001-000-141-514-20-42-03 Postage $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-141-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-141-591-18-70-00 Postage Meter Lease $23,464.92 $24,358.40 $0.00 ($24,358.40) 001-000-141-591-18-70-01 Copy Machine Lease $319.51 $319.51 $0.00 ($319.51) Total Internal Services $26,011.85 $41,390.48 $42,500.00 97.39 %$1,109.52 Finance 001-000-142-514-20-10-00 Salaries $17,085.91 $85,496.38 $205,000.00 41.71 %$119,503.62 001-000-142-514-20-20-00 Benefits $6,510.50 $27,403.42 $67,000.00 40.90 %$39,596.58 001-000-142-514-20-31-00 Office Supplies $700.55 $1,355.66 $1,600.00 84.73 %$244.34 001-000-142-514-20-40-00 State Audit $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-142-514-20-40-01 FSA Administrative Fee $50.00 $250.00 $600.00 41.67 %$350.00 001-000-142-514-20-40-02 Bank Charges & Fees $694.87 $2,326.50 $5,500.00 42.30 %$3,173.50 001-000-142-514-20-40-03 Training $0.00 $140.00 $1,500.00 9.33 %$1,360.00 001-000-142-514-20-43-00 Travel $37.73 $37.73 $500.00 7.55 %$462.27 001-000-142-514-20-46-00 Insurance $46.08 $1,596.64 $15,000.00 10.64 %$13,403.36 07-18-2023 City Council Agenda Packet Page 76 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-594-14-60-00 Capital Outlay $0.00 $0.00 $19,450.00 0.00 %$19,450.00 Total Finance $25,125.64 $118,606.33 $346,150.00 34.26 %$227,543.67 Information Technology 001-000-145-514-20-10-00 Salaries $9,766.84 $46,796.84 $122,000.00 38.36 %$75,203.16 001-000-145-514-20-20-00 Benefits $6,315.03 $23,325.57 $50,000.00 46.65 %$26,674.43 001-000-145-514-20-30-01 Non-Capital - PC Software Admin $313.03 $2,702.75 $8,200.00 32.96 %$5,497.25 001-000-145-514-20-30-02 Non-Capital - PC Hardware Admin $994.68 $4,059.81 $4,000.00 101.50 %($59.81) 001-000-145-514-20-31-00 Supplies $72.88 $249.62 $1,000.00 24.96 %$750.38 001-000-145-514-20-40-01 Memberships $0.00 $0.00 $100.00 0.00 %$100.00 001-000-145-514-20-40-05 Disaster Backup System Support $7,041.91 $9,062.49 $17,500.00 51.79 %$8,437.51 001-000-145-514-20-40-10 Annual Fee - GIS Systems $0.00 $2,095.14 $6,500.00 32.23 %$4,404.86 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $571.27 $4,265.61 $31,500.00 13.54 %$27,234.39 001-000-145-514-20-40-21 Annual License - HR Software $0.00 $1,261.75 $5,300.00 23.81 %$4,038.25 001-000-145-514-20-40-25 Annual License - Municipal Court $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $0.00 $7,000.00 0.00 %$7,000.00 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $19,929.89 $26,500.00 75.21 %$6,570.11 001-000-145-514-20-40-40 Annual Subscription - Website $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $800.00 0.00 %$800.00 001-000-145-514-20-40-51 Annual License - Electronic Archive (Smarsh & Archive Social) $0.00 $4,670.22 $7,500.00 62.27 %$2,829.78 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $10,220.70 $10,220.70 $10,500.00 97.34 %$279.30 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $0.00 $8,000.00 0.00 %$8,000.00 001-000-145-514-20-41-00 Professional Services $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-145-514-20-42-00 Cell Phone $0.00 $185.99 $850.00 21.88 %$664.01 001-000-145-514-20-43-00 Training $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-514-20-44-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-145-514-20-45-00 Insurance $11.52 $775.21 $5,375.00 14.42 %$4,599.79 001-000-145-594-14-60-20 Capital - PC Software Admin $3,775.48 $14,678.43 $32,700.00 44.89 %$18,021.57 001-000-145-594-14-60-25 Capital - PC Hardware Admin $0.00 $1,950.14 $33,000.00 5.91 %$31,049.86 Total Information Technology $39,083.34 $146,230.16 $399,325.00 36.62 %$253,094.84 Legal 001-000-151-515-31-10-00 Salaries $8,502.26 $42,660.64 $103,000.00 41.42 %$60,339.36 001-000-151-515-31-20-00 Benefits $3,935.09 $14,880.24 $37,000.00 40.22 %$22,119.76 001-000-151-515-31-31-00 Office Supplies $0.00 $0.00 $200.00 0.00 %$200.00 001-000-151-515-31-40-01 Legal Research $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-151-515-31-40-02 Membership Dues $0.00 $30.00 $100.00 30.00 %$70.00 001-000-151-515-31-40-03 Licensing $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-31-40-10 Training $0.00 $260.00 $2,000.00 13.00 %$1,740.00 001-000-151-515-31-42-01 Cell Phone $0.00 $52.01 $600.00 8.67 %$547.99 001-000-151-515-31-43-00 Travel $703.53 $703.53 $1,000.00 70.35 %$296.47 001-000-151-515-31-46-00 Insurance $57.61 $118.21 $15,000.00 0.79 %$14,881.79 001-000-151-515-31-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 07-18-2023 City Council Agenda Packet Page 77 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-151-515-41-40-00 Legal Services $5,793.20 $23,874.92 $100,000.00 23.87 %$76,125.08 001-000-151-515-45-40-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $18,991.69 $82,579.55 $289,900.00 28.49 %$207,320.45 Civil Service 001-000-160-521-10-10-00 Salaries $425.00 $2,125.00 $5,600.00 37.95 %$3,475.00 001-000-160-521-10-46-00 Insurance $23.04 $47.28 $11,000.00 0.43 %$10,952.72 Total Civil Service $448.04 $2,172.28 $16,600.00 13.09 %$14,427.72 Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $61.50 $493.99 $3,000.00 16.47 %$2,506.01 001-000-180-518-30-31-07 Cleaning Supplies - Simon St.$241.62 $370.75 $0.00 ($370.75) 001-000-180-518-30-35-00 Small Tools & Equipment $457.63 $684.76 $7,000.00 9.78 %$6,315.24 001-000-180-518-30-41-00 Professional Services $211.06 $6,555.07 $15,000.00 43.70 %$8,444.93 001-000-180-518-30-41-01 Contracted Custodial Services $0.00 $7,571.43 $36,000.00 21.03 %$28,428.57 001-000-180-518-30-46-00 Insurance $201.62 $413.73 $61,000.00 0.68 %$60,586.27 001-000-180-518-30-47-00 Utilities $1,329.70 $8,609.18 $30,000.00 28.70 %$21,390.82 001-000-180-518-30-47-01 Utilities - Simon St.$1,357.36 $4,623.62 $8,000.00 57.80 %$3,376.38 001-000-180-518-30-48-00 Repairs & Maintenance $2,779.64 $5,289.51 $15,000.00 35.26 %$9,710.49 001-000-180-518-30-49-00 Miscellaneous $50.41 ($176.92)$1,000.00 -17.69 %$1,176.92 001-000-180-518-30-49-01 Landscaping $179.34 $179.34 $4,000.00 4.48 %$3,820.66 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$1,743.06 $14,633.76 $9,000.00 162.60 %($5,633.76) 001-000-180-594-18-60-00 Capital Outlay $0.00 $6,861.49 $5,000.00 137.23 %($1,861.49) Total Central Services $8,612.94 $56,109.71 $194,000.00 28.92 %$137,890.29 Law Enforcement 001-000-210-521-10-10-00 Salaries $221,597.14 $1,085,463.69 $2,600,000.00 41.75 %$1,514,536.31 001-000-210-521-10-10-02 Overtime - Shift Coverage $21,719.39 $84,323.26 $275,000.00 30.66 %$190,676.74 001-000-210-521-10-20-00 Benefits $110,106.56 $400,449.06 $950,000.00 42.15 %$549,550.94 001-000-210-521-10-20-01 Clothing Allowance $3,566.01 $8,711.45 $17,500.00 49.78 %$8,788.55 001-000-210-521-10-25-00 Tuition Reimbursement $350.00 $350.00 $0.00 ($350.00) 001-000-210-521-10-31-00 Office Supplies $1,742.45 $3,259.11 $8,500.00 38.34 %$5,240.89 001-000-210-521-10-31-01 Central Stores $18.46 $18.46 $0.00 ($18.46) 001-000-210-521-10-31-02 SWAT - Uniforms & Clothing $0.00 $54.24 $2,000.00 2.71 %$1,945.76 001-000-210-521-10-31-03 SWAT - Operating Supplies $0.00 $336.35 $2,000.00 16.82 %$1,663.65 001-000-210-521-10-31-05 Office Machine Costs $660.99 $1,602.90 $5,000.00 32.06 %$3,397.10 001-000-210-521-10-32-00 Fuel Consumed $5,760.10 $19,831.42 $55,000.00 36.06 %$35,168.58 001-000-210-521-10-35-00 Small Tools & Equipment $3,915.78 $15,164.23 $23,250.00 65.22 %$8,085.77 001-000-210-521-10-35-05 Bulletproof Vests $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-210-521-10-35-06 US Marshall Fugitive Task Force $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-41-00 Professional Services $1,772.02 $20,850.63 $17,500.00 119.15 %($3,350.63) 001-000-210-521-10-41-02 Membership Dues $0.00 $635.00 $600.00 105.83 %($35.00) 001-000-210-521-10-41-03 SWAT - Registration & Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-210-521-10-41-04 SWAT - Mileage/Per Diem/Lodging $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-210-521-10-42-01 Telephone $3,382.81 $6,010.05 $30,000.00 20.03 %$23,989.95 001-000-210-521-10-42-03 Postage $0.00 $0.00 $1,175.00 0.00 %$1,175.00 001-000-210-521-10-43-00 Travel $0.00 $1,977.19 $10,000.00 19.77 %$8,022.81 001-000-210-521-10-46-00 Insurance $241.96 $1,247.56 $81,000.00 1.54 %$79,752.44 07-18-2023 City Council Agenda Packet Page 78 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-10-48-00 Repairs & Maintenance $1,123.78 $3,222.62 $9,500.00 33.92 %$6,277.38 001-000-210-521-10-49-00 Miscellaneous $761.57 $1,016.79 $2,500.00 40.67 %$1,483.21 001-000-210-521-10-49-02 Dry Cleaning Services $109.60 $258.09 $1,200.00 21.51 %$941.91 001-000-210-521-30-40-00 Crime Prevention $0.00 $29.25 $850.00 3.44 %$820.75 001-000-210-521-40-40-00 Training - Police Chief $0.00 $22.46 $2,000.00 1.12 %$1,977.54 001-000-210-521-40-40-01 Training - Officers $0.00 $2,830.00 $4,500.00 62.89 %$1,670.00 001-000-210-521-40-40-02 Training - Office Staff $0.00 $0.00 $500.00 0.00 %$500.00 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $388.76 $2,400.00 16.20 %$2,011.24 001-000-210-594-21-60-00 Capital Outlay $13,298.34 $21,079.35 $33,000.00 63.88 %$11,920.65 001-000-210-597-00-00-00 Transfer-Out - SWAT Fund $0.00 $13,500.00 $13,500.00 100.00 %$0.00 001-000-210-597-00-00-01 Fleet Rentals - Police $0.00 $100,000.00 $100,000.00 100.00 %$0.00 Total Law Enforcement $390,126.96 $1,792,631.92 $4,257,975.00 42.10 %$2,465,343.08 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $83,842.96 $209,607.40 $503,100.00 41.66 %$293,492.60 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $0.00 $4,500.00 0.00 %$4,500.00 001-000-230-527-60-30-00 Juvenile Detention $0.00 $4,625.00 $6,000.00 77.08 %$1,375.00 Total Jail Services $83,842.96 $214,232.40 $513,600.00 41.71 %$299,367.60 Public Works 001-000-315-542-10-10-00 Salaries $8,817.48 $46,203.36 $107,000.00 43.18 %$60,796.64 001-000-315-542-10-20-00 Benefits $3,988.31 $15,860.19 $37,000.00 42.87 %$21,139.81 001-000-315-542-10-31-00 Office Supplies $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-542-10-40-00 Cell Phone $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-46-00 Insurance $46.08 $94.56 $16,000.00 0.59 %$15,905.44 001-000-315-542-10-48-00 Repairs & Maintenance $1,627.50 $1,627.50 $0.00 ($1,627.50) 001-000-315-542-10-49-00 Training $0.00 $400.00 $2,000.00 20.00 %$1,600.00 001-000-315-542-10-49-01 Miscellaneous $0.00 $1,360.00 $1,000.00 136.00 %($360.00) 001-000-315-542-10-49-10 Memberships $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-544-20-45-00 Engineering Support Services $1,139.29 $1,139.29 $20,000.00 5.70 %$18,860.71 Total Public Works $15,618.66 $66,684.90 $186,500.00 35.76 %$119,815.10 Planning 001-000-580-558-60-10-00 Salaries $18,181.04 $88,875.82 $214,000.00 41.53 %$125,124.18 001-000-580-558-60-20-00 Benefits $10,274.06 $34,565.65 $78,000.00 44.31 %$43,434.35 001-000-580-558-60-31-00 Office Supplies $0.00 $16.14 $1,500.00 1.08 %$1,483.86 001-000-580-558-60-32-00 Fuel Consumed $0.00 $0.00 $300.00 0.00 %$300.00 001-000-580-558-60-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-580-558-60-40-00 Training $0.00 $300.00 $2,000.00 15.00 %$1,700.00 001-000-580-558-60-40-01 Dues & Subscriptions $0.00 $818.00 $1,700.00 48.12 %$882.00 001-000-580-558-60-41-00 Professional Services $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $600.00 $1,200.00 50.00 %$600.00 001-000-580-558-60-41-02 Engineer/Architect Services $0.00 $300.00 $3,000.00 10.00 %$2,700.00 001-000-580-558-60-43-00 Travel $315.42 $315.42 $3,500.00 9.01 %$3,184.58 001-000-580-558-60-44-00 Advertising $0.00 $386.76 $3,500.00 11.05 %$3,113.24 07-18-2023 City Council Agenda Packet Page 79 of 88 Account Number Title Period Fiscal Budget % of Total Balance 001-000-580-558-60-46-00 Insurance $46.08 $94.56 $17,120.00 0.55 %$17,025.44 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $35.97 $1,000.00 3.60 %$964.03 001-000-580-558-60-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total Planning $28,816.60 $126,308.32 $353,320.00 35.75 %$227,011.68 Building Department 001-000-590-558-50-10-00 Salaries $2,399.92 $11,999.60 $116,000.00 10.34 %$104,000.40 001-000-590-558-50-20-00 Benefits $1,625.63 $5,751.36 $55,000.00 10.46 %$49,248.64 001-000-590-558-50-31-00 Office Supplies $0.00 $17.89 $2,500.00 0.72 %$2,482.11 001-000-590-558-50-32-00 Fuel Consumed $0.00 $46.00 $750.00 6.13 %$704.00 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $0.00 $900.00 0.00 %$900.00 001-000-590-558-50-40-00 Training $290.00 $1,085.00 $5,000.00 21.70 %$3,915.00 001-000-590-558-50-40-01 Dues & Subscriptions $0.00 $194.00 $500.00 38.80 %$306.00 001-000-590-558-50-41-00 Professional Services $4,495.08 $49,236.48 $100,000.00 49.24 %$50,763.52 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $6,317.04 $25,000.00 25.27 %$18,682.96 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-590-558-50-42-01 Cell Phone $0.00 $0.00 $800.00 0.00 %$800.00 001-000-590-558-50-43-00 Travel $870.75 $870.75 $4,500.00 19.35 %$3,629.25 001-000-590-558-50-46-00 Insurance $40.32 $82.74 $14,000.00 0.59 %$13,917.26 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $0.00 $500.00 0.00 %$500.00 001-000-590-558-50-49-00 Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.00 Total Building Department $9,721.70 $75,600.86 $340,750.00 22.19 %$265,149.14 001-001-000-582-10-00-01 Fireworks - Deposit Refund $0.00 $0.00 $2,500.00 0.00 %$2,500.00 Other Expenditures 001-001-000-589-00-00-02 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 Total Other Expenditures $0.00 $0.00 $250.00 0.00 %$250.00 Total General Fund $782,058.88 $3,488,508.42 $9,419,767.00 37.03 %$5,931,258.58 Street Fund     Storm Water Utility Charge 101-000-315-531-00-40-00 Annual SWU Charge $0.00 $1,888.76 $84,500.00 2.24 %$82,611.24     Total Storm Water Utility Charge $0.00 $1,888.76 $84,500.00 2.24 %$82,611.24 101-000-420-542-30-10-00 Salaries - Roadway $2,196.37 $18,563.05 $60,000.00 30.94 %$41,436.95 101-000-420-542-30-20-00 Benefits - Roadway $1,604.18 $9,928.77 $30,000.00 33.10 %$20,071.23 101-000-420-542-30-30-00 Supplies - Roadway $0.00 $8,041.77 $35,000.00 22.98 %$26,958.23 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $57.65 $4,500.00 1.28 %$4,442.35 101-000-420-542-61-20-00 Benefits - Sidewalks $0.00 $10.40 $2,400.00 0.43 %$2,389.60 101-000-420-542-61-30-00 Supplies - Sidewalks $0.00 $43.46 $2,000.00 2.17 %$1,956.54 101-000-420-542-61-48-00 Repairs & Maintenance - Sidewalks $0.00 $33.15 $3,000.00 1.11 %$2,966.85 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $0.00 $0.00 $2,500.00 0.00 %$2,500.00 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-63-10-00 Salaries - Street Lighting $362.50 $482.33 $4,000.00 12.06 %$3,517.67 101-000-420-542-63-20-00 Benefits - Street Lighting $144.27 $237.35 $3,000.00 7.91 %$2,762.65 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $0.00 $2,000.00 0.00 %$2,000.00 07-18-2023 City Council Agenda Packet Page 80 of 88 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-63-47-00 Utilities - Street Lighting $3,034.39 $8,551.87 $56,000.00 15.27 %$47,448.13 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $6,170.57 $12,000.00 51.42 %$5,829.43 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $9,239.62 $26,479.63 $45,000.00 58.84 %$18,520.37 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $8,740.37 $14,164.12 $22,500.00 62.95 %$8,335.88 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $213.65 $30,934.86 $32,500.00 95.18 %$1,565.14 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $481.66 $3,119.85 $9,000.00 34.67 %$5,880.15 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $10,341.66 $12,703.42 $14,000.00 90.74 %$1,296.58 101-000-420-542-65-10-00 Salaries - Parking Facilities $327.61 $327.61 $2,000.00 16.38 %$1,672.39 101-000-420-542-65-20-00 Benefits - Parking Facilities $59.10 $59.10 $1,000.00 5.91 %$940.90 101-000-420-542-65-47-00 Utilities - Parking Facilities $0.00 $0.00 $700.00 0.00 %$700.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $0.00 $9,881.52 $70,000.00 14.12 %$60,118.48 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $0.00 $3,117.63 $40,000.00 7.79 %$36,882.37 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $0.00 $40,992.81 $85,000.00 48.23 %$44,007.19 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $0.00 $3,569.85 $5,000.00 71.40 %$1,430.15 101-000-420-542-69-10-00 Salaries - Flags/Banners $768.01 $1,879.64 $5,000.00 37.59 %$3,120.36 101-000-420-542-69-20-00 Benefits - Flags/Banners $138.55 $840.32 $2,000.00 42.02 %$1,159.68 101-000-420-542-69-30-00 Supplies - Flags/Banners $170.42 $1,243.37 $2,000.00 62.17 %$756.63 101-000-420-542-70-10-00 Salaries - Roadside $19,071.85 $110,587.71 $250,000.00 44.24 %$139,412.29 101-000-420-542-70-20-00 Benefits - Roadside $9,986.46 $51,421.74 $136,500.00 37.67 %$85,078.26 101-000-420-542-70-30-00 Supplies - Roadside $98.57 $110.49 $5,000.00 2.21 %$4,889.51 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-70-47-00 Utilities - Roadside $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $0.00 $38.50 $1,000.00 3.85 %$961.50 101-000-420-542-75-10-00 Salaries - City Parks $4,373.52 $13,198.52 $55,000.00 24.00 %$41,801.48 101-000-420-542-75-20-00 Benefits - City Parks $3,073.57 $6,345.10 $23,000.00 27.59 %$16,654.90 101-000-420-542-75-30-00 Supplies - City Parks $713.33 $1,017.03 $14,500.00 7.01 %$13,482.97 101-000-420-542-75-47-00 Utilities - City Parks $347.00 $772.52 $5,000.00 15.45 %$4,227.48 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $90.92 $3,380.82 $4,000.00 84.52 %$619.18 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $3,000.00 $12,000.00 25.00 %$9,000.00 101-000-420-542-90-20-00 Benefits - Maintenance Admin $0.00 $1,125.49 $0.00 ($1,125.49) 101-000-430-543-30-10-00 Salaries - General Services $1,199.90 $6,955.66 $10,000.00 69.56 %$3,044.34 101-000-430-543-30-20-00 Benefits - General Services $812.76 $3,311.68 $6,800.00 48.70 %$3,488.32 101-000-430-543-30-30-00 Supplies - General Services $629.23 $2,747.12 $10,000.00 27.47 %$7,252.88 101-000-430-543-30-30-01 Fuel $1,237.83 $6,552.16 $27,500.00 23.83 %$20,947.84 101-000-430-543-30-46-00 Insurance $195.86 $401.91 $65,500.00 0.61 %$65,098.09 101-000-430-543-30-49-00 Miscellaneous - General Services $0.00 $955.00 $3,000.00 31.83 %$2,045.00 101-000-430-543-50-10-00 Salaries - Facilities $1,320.89 $14,110.10 $4,000.00 352.75 %($10,110.10) 101-000-430-543-50-20-00 Benefits - Facilities $1,485.25 $6,929.54 $1,800.00 384.97 %($5,129.54) 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-430-543-50-42-01 Cell Phone $0.00 $155.99 $750.00 20.80 %$594.01 101-000-430-543-50-47-00 Utilities - Facilities $189.94 $4,896.15 $6,500.00 75.33 %$1,603.85 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $854.44 $854.44 $2,500.00 34.18 %$1,645.56 101-000-430-544-90-10-00 Salaries - Training $0.00 $4,023.12 $10,500.00 38.32 %$6,476.88 101-000-430-544-90-20-00 Benefits - Training $305.75 $2,467.36 $3,500.00 70.50 %$1,032.64 07-18-2023 City Council Agenda Packet Page 81 of 88 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-544-90-30-00 Supplies - Training $0.00 $0.00 $500.00 0.00 %$500.00 101-000-430-544-90-35-00 Travel $0.00 $0.00 $4,000.00 0.00 %$4,000.00 101-000-430-544-90-49-01 Training $37.25 $1,572.63 $10,000.00 15.73 %$8,427.37 101-000-430-597-00-00-00 Fleet Rentals - Streets $0.00 $100,000.00 $100,000.00 100.00 %$0.00 Total Street Fund $83,846.68 $550,253.64 $1,426,450.00 38.58 %$876,196.36 Community Development Grants Fund 102-000-000-518-63-40-00 CDBG Micro Enterprise Grant $0.00 $0.00 $83,927.00 0.00 %$83,927.00 102-000-000-518-63-40-02 CDBG Emergency Income Payments Program $0.00 $0.00 $94,862.00 0.00 %$94,862.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $476.06 $1,800.00 26.45 %$1,323.94 Total Community Development Grants Fund $0.00 $476.06 $180,589.00 0.26 %$180,112.94 Affordable Housing Sales Tax Fund 103-000-000-551-00-40-00 Homeless Shelter Assistance $0.00 $0.00 $45,000.00 0.00 %$45,000.00 Total Affordable Housing Sales Tax Fund $0.00 $0.00 $45,000.00 0.00 %$45,000.00 Housing & Related Services Fund 104-000-000-551-00-40-00 Transfer to City of Wenatchee - CRHTF $0.00 $0.00 $440,000.00 0.00 %$440,000.00 Total Housing & Related Services Fund $0.00 $0.00 $440,000.00 0.00 %$440,000.00 Transportation Benefit District Fund 105-000-000-543-10-40-00 TBD Advertising $0.00 $182.43 $0.00 ($182.43) 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $600,000.00 0.00 %$600,000.00 Total Transportation Benefit District Fund $0.00 $182.43 $600,000.00 0.03 %$599,817.57 SWAT Fund 107-000-000-521-10-30-00 Supplies & Equipment $110.00 $1,007.48 $15,000.00 6.72 %$13,992.52 107-000-000-521-10-30-01 Fuel $0.00 $72.34 $0.00 ($72.34) 107-000-000-521-40-40-00 Training $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total SWAT Fund $110.00 $1,079.82 $30,000.00 3.60 %$28,920.18 Library Fund 112-000-000-572-50-47-00 Facilities - Utilities $877.00 $2,355.70 $6,500.00 36.24 %$4,144.30 Total Library Fund $877.00 $2,355.70 $6,500.00 36.24 %$4,144.30 Hotel/Motel Tax Fund 113-000-000-557-30-41-01 EMPD Winter Classic AAU Tournament $8,000.00 $8,000.00 $0.00 ($8,000.00) 113-000-000-557-30-41-05 Wenatchee Valley Chamber $0.00 $0.00 $45,000.00 0.00 %$45,000.00 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $20,000.00 $50,000.00 40.00 %$30,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 $25,310.00 $61,000.00 41.49 %$35,690.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $136,000.00 $136,000.00 100.00 %$0.00 Total Hotel/Motel Tax Fund $13,062.00 $189,310.00 $292,000.00 64.83 %$102,690.00 Drug Fund 114-000-000-521-10-35-00 Small Tools & Equipment $0.00 $229.25 $0.00 ($229.25) Total Drug Fund $0.00 $229.25 $0.00 ($229.25) Criminal Justice Fund 116-000-000-597-21-00-20 Transfer Out - ER&R Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Criminal Justice Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Events Board Fund 07-18-2023 City Council Agenda Packet Page 82 of 88 Account Number Title Period Fiscal Budget % of Total Balance 117-000-050-557-30-10-00 Salaries $8,877.30 $32,468.85 $62,000.00 52.37 %$29,531.15 117-000-050-557-30-20-00 Benefits $3,796.15 $13,368.79 $28,000.00 47.75 %$14,631.21 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $171.75 $3,000.00 5.73 %$2,828.25 117-000-100-557-30-32-00 Fuel $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-40-00 Training $0.00 $1,077.12 $2,000.00 53.86 %$922.88 117-000-100-557-30-41-00 Professional Services $0.00 $539.40 $10,600.00 5.09 %$10,060.60 117-000-100-557-30-42-00 Cell Phone $0.00 $155.99 $760.00 20.53 %$604.01 117-000-100-557-30-43-00 Travel $0.00 $983.51 $1,000.00 98.35 %$16.49 117-000-100-557-30-44-00 Advertising $0.00 $0.00 $5,000.00 0.00 %$5,000.00 117-000-100-594-58-64-00 EWEB Capital Outlay $0.00 $4,070.35 $5,000.00 81.41 %$929.65 117-000-105-557-30-40-00 Insurance $40.32 $82.74 $12,000.00 0.69 %$11,917.26 117-000-115-557-30-31-05 Office Supplies $43.69 $54.54 $500.00 10.91 %$445.46 117-000-300-557-30-31-12 Classy Chassis Office Supplies $31.83 $46.84 $2,000.00 2.34 %$1,953.16 117-000-300-557-30-34-11 Classy Chassis Event Merch For Resale $3,608.28 $3,608.28 $2,500.00 144.33 %($1,108.28) 117-000-300-557-30-41-12 CC - Professional Services $3,000.00 $4,177.23 $5,000.00 83.54 %$822.77 117-000-300-557-30-42-14 CC - Postage $0.00 $884.66 $825.00 107.23 %($59.66) 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-44-12 CC - Advertising $2,045.44 $2,411.72 $3,000.00 80.39 %$588.28 117-000-300-557-30-49-12 CC - Miscellaneous $1,250.00 $1,250.00 $500.00 250.00 %($750.00) 117-000-500-557-30-31-01 Christmas Office Supplies $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-557-30-40-05 Christmas - Events & Decorations $0.00 $0.00 $5,000.00 0.00 %$5,000.00 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $156.24 $300.00 52.08 %$143.76 117-000-500-557-30-44-01 Christmas - Advertising $0.00 $171.75 $750.00 22.90 %$578.25 117-000-500-557-30-49-01 Christmas - Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 117-000-620-557-30-30-00 PFOF Marketing Materials $0.00 $0.00 $500.00 0.00 %$500.00 117-000-620-557-30-30-01 PFOF Supplies & Equipment $0.00 $0.00 $850.00 0.00 %$850.00 117-000-620-557-30-40-00 PFOF Professional Services $0.00 $1,200.00 $3,000.00 40.00 %$1,800.00 117-000-620-557-30-40-01 PFOF Advertising $0.00 $171.75 $700.00 24.54 %$528.25 117-000-620-557-30-40-02 PFOF Entertainment $0.00 $0.00 $2,500.00 0.00 %$2,500.00 Total Events Board Fund $22,693.01 $67,051.51 $159,985.00 41.91 %$92,933.49 Bond Redemption Fund 202-000-000-591-18-70-00 Principal - 2021 LTGO Bond $0.00 $0.00 $515,000.00 0.00 %$515,000.00 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $0.00 $30,000.00 0.00 %$30,000.00 202-000-000-592-14-80-00 Interest - 2021 LTGO Bond $0.00 $0.00 $230,000.00 0.00 %$230,000.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $5,856.84 $5,856.84 $8,000.00 73.21 %$2,143.16 Total Bond Redemption Fund $5,856.84 $5,856.84 $783,000.00 0.75 %$777,143.16 Street Improvements Fund 301-000-000-595-10-40-01 Design 2020 TBD Paving $0.00 $164.08 $0.00 ($164.08) 301-000-000-595-10-40-04 Design - Grant Rd/Highline Dr Intersection Improvements $20,201.60 $36,175.29 $25,000.00 144.70 %($11,175.29) 301-000-000-595-10-40-13 Design - TIB Grant Road/Eastmont Ave Intersection $0.00 $0.00 $27,500.00 0.00 %$27,500.00 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $741.60 $1,175.60 $0.00 ($1,175.60) 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $2,482.75 $35,493.80 $0.00 ($35,493.80) 301-000-000-595-10-60-00 Design - NHS Overlay Grover to Kentucky $9,361.56 $12,591.59 $29,000.00 43.42 %$16,408.41 07-18-2023 City Council Agenda Packet Page 83 of 88 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-10-60-01 NHFP Grant Road Overlay - VMP to Grover $3,682.00 $17,254.92 $0.00 ($17,254.92) 301-000-000-595-20-60-02 ROW - SRTS - 5th St. Kenroy $0.00 $3,922.65 $0.00 ($3,922.65) 301-000-000-595-20-60-03 ROW - SRTS - 5th St. Sterling $0.00 $5,812.10 $0.00 ($5,812.10) 301-000-000-595-20-60-04 ROW - NHS PCCP Intersection $0.00 $0.00 $25,000.00 0.00 %$25,000.00 301-000-000-595-20-60-05 ROW - NHS Grant Rd. Overlay $0.00 $0.00 $227,000.00 0.00 %$227,000.00 301-000-000-595-30-60-08 Construction - Hamilton St. Rebuild $0.00 $19,589.26 $0.00 ($19,589.26) 301-000-000-595-30-60-10 Construction - NHFP Grant Road Overlay $0.00 $0.00 $850,000.00 0.00 %$850,000.00 301-000-000-595-30-60-11 Construction - NHS PCCP Intersection $0.00 $22,741.69 $1,275,000.00 1.78 %$1,252,258.31 301-000-000-595-30-60-12 Construction - TIB 3rd/RI Road Signal $2,810.82 $13,257.86 $870,000.00 1.52 %$856,742.14 301-000-000-595-30-60-13 TIB APP Overlay - RI Road $0.00 $0.00 $525,000.00 0.00 %$525,000.00 301-000-000-595-61-60-03 TIB 2022 Complete Streets $0.00 $0.00 $280,000.00 0.00 %$280,000.00 301-000-000-595-61-60-04 Construction - SRTS Kenroy $0.00 $0.00 $3,521,000.00 0.00 %$3,521,000.00 301-000-000-595-61-60-05 Construction - SRTS Sterling $0.00 $0.00 $3,277,000.00 0.00 %$3,277,000.00 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $6,821.62 $12,954.30 $14,000.00 92.53 %$1,045.70 301-000-000-595-64-60-01 Construction - 9th/VMP Intersection $0.00 $18,636.98 $130,000.00 14.34 %$111,363.02 301-000-000-595-64-60-02 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $334.99 $10,000.00 3.35 %$9,665.01 301-000-000-595-90-10-00 Street Improvements Staff Salaries $0.00 $0.00 $22,300.00 0.00 %$22,300.00 301-000-000-595-90-20-00 Street Improvements Staff Benefits $0.00 $0.00 $11,000.00 0.00 %$11,000.00 Total Street Improvements Fund $46,101.95 $200,105.11 $11,118,800.00 1.80 %$10,918,694.89 Capital Improvements Fund 314-000-000-594-18-60-00 Maintenance Facilities Construction $448,831.31 $2,031,260.29 $3,150,000.00 64.48 %$1,118,739.71 314-000-000-594-21-60-01 Simon St. Improvements $34,013.93 $147,234.15 $0.00 ($147,234.15) 314-001-000-597-00-00-02 Transfer-Out to 202 Fund $0.00 $0.00 $680,000.00 0.00 %$680,000.00 Total Capital Improvements Fund $482,845.24 $2,178,494.44 $3,830,000.00 56.88 %$1,651,505.56 Stormwater Fund 401-000-000-597-00-00-00 Transfer-Out - Fund 301 $0.00 $0.00 $200,000.00 0.00 %$200,000.00 Stormwater Utility Admin 401-000-001-522-10-40-00 B&O Tax on SWU Revenue $0.00 $0.00 $20,000.00 0.00 %$20,000.00 401-000-001-531-00-10-00 Salaries - Stormwater Admin $2,897.92 $14,284.08 $30,000.00 47.61 %$15,715.92 401-000-001-531-00-20-00 Benefits - Stormwater Admin $1,462.33 $4,819.30 $13,200.00 36.51 %$8,380.70 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $9.19 $500.00 1.84 %$490.81 401-000-001-531-00-30-01 Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-00 Cell Phone $0.00 $312.76 $750.00 41.70 %$437.24 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $7,508.97 $8,500.00 88.34 %$991.03 401-000-001-531-00-40-02 Insurance $34.56 $70.92 $7,312.50 0.97 %$7,241.58 401-000-001-531-00-40-04 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-40-05 Training - Stormwater Admin $140.00 $140.00 $1,000.00 14.00 %$860.00 401-000-001-531-00-40-06 Travel - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-582-30-00-00 Non-Fiduciary Remittance $115.56 $1,998.56 $2,000.00 99.93 %$1.44 401-000-001-597-00-00-00 Fleet Rentals - Stormwater $0.00 $56,892.12 $70,000.00 81.27 %$13,107.88 Total Stormwater Utility Admin $4,650.37 $86,035.90 $155,262.50 55.41 %$69,226.60 NPDES Admin 07-18-2023 City Council Agenda Packet Page 84 of 88 Account Number Title Period Fiscal Budget % of Total Balance 401-000-002-531-00-10-01 Salaries - NPDES Admin $2,897.98 $12,004.41 $25,000.00 48.02 %$12,995.59 401-000-002-531-00-20-01 Benefits - NPDES Admin $1,462.36 $3,957.11 $11,000.00 35.97 %$7,042.89 401-000-002-531-00-40-00 Training - NPDES Admin $434.00 $434.00 $500.00 86.80 %$66.00 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-002-531-00-40-03 Aerial Pictometry - NPDES Admin $0.00 $0.00 $4,000.00 0.00 %$4,000.00 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $0.00 $2,689.61 $8,000.00 33.62 %$5,310.39 Total NPDES Admin $4,794.34 $19,085.13 $49,500.00 38.56 %$30,414.87 NPDES Outreach 401-000-003-531-00-10-02 Salaries - NPDES Outreach $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-003-531-00-20-02 Benefits - NPDES Outreach $0.00 $0.00 $600.00 0.00 %$600.00 401-000-003-531-00-30-02 Supplies - NPDES Outreach $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $66.87 $500.00 13.37 %$433.13 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $12.86 $200.00 6.43 %$187.14 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $8,000.00 0.00 %$8,000.00 Total NPDES Public Involvement $0.00 $79.73 $8,700.00 0.92 %$8,620.27 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $0.00 $3,000.00 0.00 %$3,000.00 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-005-531-00-30-04 Supplies - NPDES IDDE $0.00 $0.00 $4,000.00 0.00 %$4,000.00 401-000-005-531-00-40-00 Training - NPDES IDDE $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total NPDES IDDE $0.00 $0.00 $10,000.00 0.00 %$10,000.00 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-006-531-00-20-05 Benefits - NPDES Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Post Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $1,668.66 $9,449.06 $73,000.00 12.94 %$63,550.94 401-000-008-531-00-10-08 Salaries - Sweeping $2,017.43 $10,313.85 $22,000.00 46.88 %$11,686.15 401-000-008-531-00-20-07 Benefits - NPDES PPGH $1,102.01 $4,538.45 $29,200.00 15.54 %$24,661.55 401-000-008-531-00-20-08 Benefits - Sweeping $1,480.52 $4,539.37 $11,000.00 41.27 %$6,460.63 401-000-008-531-00-30-05 Supplies - NPDES PPGH $411.55 $454.11 $20,000.00 2.27 %$19,545.89 401-000-008-531-00-30-06 Irrigation Supplies $0.00 $0.00 $3,000.00 0.00 %$3,000.00 401-000-008-531-00-30-07 Fuel $1,615.12 $2,051.29 $7,000.00 29.30 %$4,948.71 401-000-008-531-00-40-02 Training - NPDES PPGH $217.00 $217.00 $0.00 ($217.00) 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $0.00 $1,635.17 $5,000.00 32.70 %$3,364.83 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $25,000.00 0.00 %$25,000.00 401-000-008-531-00-40-06 Utilities $769.73 $1,388.23 $5,000.00 27.76 %$3,611.77 401-000-008-531-00-40-07 Decant Facility Tipping Fee $2,880.00 $3,174.65 $75,000.00 4.23 %$71,825.35 07-18-2023 City Council Agenda Packet Page 85 of 88 Account Number Title Period Fiscal Budget % of Total Balance 401-000-008-591-31-70-00 Decant Facility Admin. Charge $2,400.00 $2,400.00 $2,400.00 100.00 %$0.00 Total NPDES PPGH $14,562.02 $40,161.18 $277,600.00 14.47 %$237,438.82 NPDES Monitoring 401-000-009-531-00-10-09 Salaries - NPDES Monitoring $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-009-531-00-20-09 Benefits - NPDES Monitoring $0.00 $0.00 $400.00 0.00 %$400.00 401-000-009-531-00-30-06 Supplies - NPDES Monitoring $0.00 $0.00 $100.00 0.00 %$100.00 Total NPDES Monitoring $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Capital Outlay 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Capital Outlay $0.00 $0.00 $10,000.00 0.00 %$10,000.00 401-000-011-594-31-60-04 19th Stormwater Facility Design $17,814.09 $74,479.89 $100,000.00 74.48 %$25,520.11 401-000-011-594-31-60-05 Construction - 19th St. Stormwater $0.00 $0.00 $4,712,635.00 0.00 %$4,712,635.00 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $5,451.97 $25,000.00 21.81 %$19,548.03 401-000-013-531-00-40-08 Payment to Douglas Co. for PWTFL $0.00 $0.00 $76,000.00 0.00 %$76,000.00 401-000-014-531-00-40-07 Stormwater Comp Plan Update $0.00 $18,111.35 $0.00 ($18,111.35) 401-000-016-594-31-60-00 Design - Pace Pond Ecology Grant $26,536.32 $53,015.01 $75,000.00 70.69 %$21,984.99 401-000-016-594-31-60-01 Construction - Pace Pond Ecology Grant $0.00 $0.00 $870,000.00 0.00 %$870,000.00 Total Stormwater Fund $68,357.14 $296,420.16 $6,578,497.50 4.51 %$6,282,077.34 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $609.15 $2,566.54 $7,500.00 34.22 %$4,933.46 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $370.01 $841.65 $4,500.00 18.70 %$3,658.35 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $11,677.37 $21,909.56 $35,000.00 62.60 %$13,090.44 501-000-000-548-30-10-00 Street Vehicle Repair Labor $2,516.16 $9,191.80 $24,000.00 38.30 %$14,808.20 501-000-000-548-30-20-00 Street Vehicle Repair Benefits $1,920.38 $6,936.84 $12,000.00 57.81 %$5,063.16 501-000-000-548-30-30-25 Street Vehicle Repair Supplies $58.46 $1,010.09 $5,000.00 20.20 %$3,989.91 501-000-000-548-30-48-20 Street Vehicle Repairs & Maintenance $524.47 $5,021.44 $23,000.00 21.83 %$17,978.56 501-000-000-548-30-48-30 Street Equipment Repairs $485.45 $828.00 $1,500.00 55.20 %$672.00 501-000-000-548-60-10-00 Stormwater Vehicle R & M Labor $0.00 $0.00 $2,000.00 0.00 %$2,000.00 501-000-000-548-60-20-00 Stormwater Vehicle R & M Benefits $0.00 $0.00 $1,000.00 0.00 %$1,000.00 501-000-000-548-60-30-00 Stormwater Vehicle R & M $0.00 $0.00 $1,500.00 0.00 %$1,500.00 501-000-000-594-21-60-00 Capital - Police Vehicles $2,027.16 $43,701.16 $140,000.00 31.22 %$96,298.84 501-000-000-594-44-60-20 Capital Outlay - Admin Vehicles $0.00 $0.00 $50,000.00 0.00 %$50,000.00 501-000-000-594-48-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $140,000.00 0.00 %$140,000.00 Total Equipment Purchase, Repair & Replacement Fund $20,188.61 $92,007.08 $447,000.00 20.58 %$354,992.92 Grand Totals $1,525,997.35 $7,072,330.46 $35,377,588.50 19.99 %$28,305,258.04 07-18-2023 City Council Agenda Packet Page 86 of 88 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $782,058.88 $3,488,508.42 $9,419,767.00 37.03 %$5,931,258.58 101-000-000-000-00-00-00 Street Fund $83,846.68 $550,253.64 $1,426,450.00 38.58 %$876,196.36 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $476.06 $180,589.00 0.26 %$180,112.94 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $0.00 $0.00 $45,000.00 0.00 %$45,000.00 104-000-000-000-00-00-00 Housing & Related Services Fund $0.00 $0.00 $440,000.00 0.00 %$440,000.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $182.43 $600,000.00 0.03 %$599,817.57 107-000-000-000-00-00-00 SWAT Fund $110.00 $1,079.82 $30,000.00 3.60 %$28,920.18 112-000-000-000-00-00-00 Library Fund $877.00 $2,355.70 $6,500.00 36.24 %$4,144.30 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $13,062.00 $189,310.00 $292,000.00 64.83 %$102,690.00 114-000-000-000-00-00-00 Drug Fund $0.00 $229.25 $0.00 ($229.25) 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 117-000-000-000-00-00-00 Events Board Fund $22,693.01 $67,051.51 $159,985.00 41.91 %$92,933.49 202-000-000-000-00-00-00 Bond Redemption Fund $5,856.84 $5,856.84 $783,000.00 0.75 %$777,143.16 301-000-000-000-00-00-00 Street Improvements Fund $46,101.95 $200,105.11 $11,118,800.00 1.80 %$10,918,694.89 314-000-000-000-00-00-00 Capital Improvements Fund $482,845.24 $2,178,494.44 $3,830,000.00 56.88 %$1,651,505.56 401-000-000-000-00-00-00 Stormwater Fund $68,357.14 $296,420.16 $6,578,497.50 4.51 %$6,282,077.34 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $20,188.61 $92,007.08 $447,000.00 20.58 %$354,992.92 Grand Totals $1,525,997.35 $7,072,330.46 $35,377,588.50 19.99 %$28,305,258.04 07-18-2023 City Council Agenda Packet Page 87 of 88 Beginning ActivityEnding May 2022 VarianceCashInCash Ending Cash (Decrease)/Increase001$5,243,874.00 $3,350,755.94$5,106,121.52 $4,636,887.96$469,233.56002$750,000.00$486.23$750,486.23$0.00$750,486.23101$290,870.00 $1,161,448.24$902,064.60 $784,309.00$117,755.60102$118,902.00 $262,852.20$381,278.14 $194,819.41$186,458.73103$88,963.00 $10,874.72$99,837.72 $66,500.62$33,337.10104$10,019.00 $235,597.97$245,616.97 $237,942.99$7,673.98105$562,833.00 $151,759.83$714,410.40 $606,720.04$107,690.36107$31,597.00 $58,520.50$89,037.68 $45,700.00$43,337.68112$24,847.00$16.11$22,507.41 $18,848.03$3,659.38113$472,334.00 $138,775.93$421,799.93 $344,903.99$76,895.94114$2,394.00$7.94$2,172.69 $1,623.75$548.94116$5,749.00 $11,258.36$17,007.36 $14,343.44$2,663.92117$22,751.00 $160,599.84$116,299.33 $49,697.73$66,601.60202$48,297.00$31.31$42,471.47 $436,872.37($394,400.90)301$13,838.00 $572,229.47$385,962.36 $321,529.07$64,433.29314$4,198,147.00 $153,089.64$2,172,742.20 $1,489,421.09$683,321.11401$1,093,433.00 $309,860.89$1,106,449.29 $1,695,152.53($588,703.24)501$562,648.00 $273,880.48$744,521.40 $55,238.74$689,282.66$13,541,496.00 $6,852,045.60 $20,393,541.60 $13,320,786.70 $11,000,510.76$2,320,275.94$5,856.84$67,051.51$2,178,494.44$200,105.11$92,007.08$296,844.60$1,079.82$182.43$189,310.00$2,355.70$0.00$229.25$0.00$476.06$550,253.64$0.00$0.00Stormwater FundEquipment Purchase, Repair & Replacement FundStreet Improvements FundCapital Improvements FundEvents Board FundBond Redemption FundDrug FundCriminal Justice FundLibrary FundHotel/Motel Tax FundTransportation Benefit District FundSWAT FundAffordable Housing Sales Tax FundHousing & Related Services FundStreet FundCommunity Development Grants FundRainy Day FundCash and Investment Activity$3,488,508.42OutGeneral FundPeriod: 2023 - May 2023 Fiscal TotalsFund Activity07-18-2023 City Council Agenda Packet Page 88 of 88