Loading...
RES NO 12-08-2022 CITY OF VAN BUREN,ARKANSAS RESOLUTION NO. JA - 09 -2022 BE IT ENACTED BY THE CITY COUNCIL, FOR THE CITY OF VAN BUREN ARKANSAS,A RESOLUTION TO BE ENTITLED: A RESOLUTION ADOPTING A PROPOSED BUDGET FOR THE FISCAL YEAR ENDING DECEMBER 31,2023. NOW,THEREFORE,BE IT RESOLVED BY THE CITY COUNCIL OF VAN BUREN,ARKANSAS,THAT: SECTION 1: The 2023 Proposed Expenditures of $22,743,162.00 (Twenty-Two Million, Seven Hundred Forty-Three Thousand, One Hundred Sixty-Two Dollars) is hereby appropriated and a copy of said Budget is attached hereto and made a part hereof. SECTION 2: The appropriations made herein include additional pay for Holidays for all agents, servants, and employees of the City of Van Buren including, but not limited to, uniformed employees, as provided for by the laws of the State of Arkansas. IN WITNESS WHEREOF,the City of Van Buren,Arkansas,by its City Council, did pass, approve, and adopt,by a vote of-5 for and-0-_against the foregoing Resolution at its regular meeting held on the 191h day of December 2022. 4a;yo'r P.Hurst ATTESTED: APPRO O FORM: 1 1 Play Pis Thomas ` ( seb-H T1 _ City Clerk/Treasurer City Attorney 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 43,153.73 42,345.69 42,000.00 86,737.22 55,000.00 TAXES 12,701,286.70 13,624,363.38 12,563,000.00 14,527,687.94 13,271,340.00 DONATIONS 28,150.00 97,123.11 26,000.00 64,806.00 41,000.00 REVENUE 5,460.50 13,719.20 7,700.00 17,027.04 17,700.00 COURT 853,994.68 873,320.74 1,010,500.00 703,425.84 1,010,500.00 GRANTS 1,682,080.00 3,599,486.47 649,000.00 1,174,167.92 649,000.00 PERMITS/FEES 431,714.56 45B,402.58 457,500.00 398,459.35 477,500.00 REIMBURSEMENT REVENUE 646,204.25 641,646.11 678,575.00 586,784.58 737,000.00 4651-4699 NOT USED 0.00 0.00 0.00 0.00 0.00 MISCELLANEOUS 140,677.73 509,468.12 429,250.00 77,524.04 333,750.00 TRANSFERS IN 411,921.36 450.169.E 300,000.00 4,906,939.73 3,552,000.00 ** TOTAL REVENUE ** 16,944,643.51 20,310,044.55 16,163,525.00 22,543,559.66 20,144,790.00 EXPENDITURE SUMMARY City Attorney 108,008.40 114,357.59 126,722.00 91,452.93 146,380.00 Administration 941,140.30 3,447,954.23 lr055,331.00 1,139,721.75 1,164,090.00 Police Department 5,133,734.17 5,489,889.13 5,053,290.00 5,430,254.85 5,998,522.00 Fire Department 4,350,642.86 4,722,053.28 4,707,340.00 4,443,778.01 5,583,395.00 District Court 1,121,452.04 1,217,787.93 1,294,571.00 1,151,812.87 1,346,876.00 Library 70,295.11 75,469.90 66,500.00 81•,477.44 76,500.00 Senior Inn 22,065.68 27,631.11 29,500.00 34,126.17 34,500.00 Old Town Merchants Assoc. 4,572.56 6,677.01 7,500.00 5,380.88 7,500.00 Code Enforcement 0.00 0.00 0.00 314,361.85 353,235.00 Building Department 140,693.86 165,568.94 160,545.00 146,957.37 237,552.00 Planning Department 149,483.29 154,841.63 167,760.00 170,923.91 176,335.00 Levee 1,950.00 1,950.00 1,950.00 2,075.00 1,950.00 Parks & Recreation 274,825.71 320,226.79 318,460.00 363,713.13 335,762.00 Property Maintenance 264,242.75 336,227.00 315,230.00 357,595.50 374,555.00 Yard 'Waste 139,291.90 165,085.23 210,040.00 153,816.80 185,310.00 Cemetery 2,259.31 1,999.48 2,250.00 955.62 2,250.00 King Opera House 25,078.88 27,343.96 23,100.00 23,901.15 23,100.00 Capital Improvement 1,278,382.06 2,567,876.33 2,527,000.00 2,499,943.43 4,075,000.00 *** TOTAL EXPENDITURES *** 14,028,118.88 18,842,939.54 16,067,089.00 16,412,248.66 20,122,812.00 ** REVENUE OVER(UNDER) EXPENDITURES ** 2,916,524.63 1,467,105.01 96,436.00 6,131,311.00 21,978.00 ` h 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest Earned 43,153.73 42,345.69 42,000.00 86,737.22 55,000.00 TOTAL INTEREST 43,153.73 42,345.69 42,000.00 86,737.22 55,000.00 TAXES 4100 State General Turnback 338,148.51 371,968.17 360,000.00 323,989.63 360,000.00 4105 Property Tax (CG) 625,073.75 338,625.35 610,000.00 626,134.33 620,000.00 4110 Sales Tax Proceeds 6,976,396.30 7,533,494.56 6,550,000.00 7,599,828.09 6,975,000.00 4111 City Alcohol Tax 28,980.24 44,347.47 38,000.00 49,188.07 48,000.00 4116 Co. Sales Tax PD 379,717.58 430,185.68 390,625.00 696,651.49 416,670.00 4117 'Co. Sales Tax FD 379,717.58 430,185.68 390,625.00 449,857.63 416,670.00 4118 75% County Sales Tax 2,278,305.47 2,581,114.19 2,343,750.00 2,699,145.66 2,500,000.00 4120 Franchise Tax J.694.947,27 1,894,442.28 1,880,000.00 2,082,893.04 1,935,000.00 TOTAL TAXES 12,701,286.70 13,624,363.38 12,563,000.00 14,527,687.94 13,271,340.00 DONATIONS 4211 Donations-PD 0.00 0.00 0.00 0.00 0.00 4212 Fire Prevention Materials 0.00 0.00 1,000.00 0,00 1,000.00 4213 Donation-FD 2,500.00 250.00 0.00 0.00 0.00 4214 Donations- KOH 0.00 0.00 0.00 0.00 0.00 4215 Donation-FOD 0.00 0.00 0.00 0.00 0.00 4216 Donations-Cemetery 0.00 0.00 0.00 0.00 0.00 4217 Donations-Special Events 25,650.00 96,873.11 25,000.00 64,806.00 40,000.00 TOTAL DONATIONS 28,150.00 97,123.11 26,000.00 64,806.00 41,000.00 REVENUE 4253 Field of Dreams-Equip. Acct 10.50 10,719.20 0.00 9,367.04 10,000.00 4256 USSSA Tournament 0.00 0.00 3,000.00 3,105.00 3,000.00 4258 Field Rental 0.00 0.00 0.00 805.00 0.00 4259 Sign Contracts/Levee 2,700.00 0.00 2,700.00 0.00 2,700.00 4260 Lot Sales-Cemetery 2,750.00 3,000.00 2,000.00 3,750.00 2,000.00 TOTAL REVENUE 5,460.50 13,719.20 7,700.00 17,027.04 17,700.00 COURT 4300 Court Fines 278,735.96 258,786.38 330,000.00 197,439.58 330,000.00 4301 Jail Fees 36,451.07 30,341.02 40,000.00 22,024.44 40,000.00 4302 Probation 38,647.74 57,127.31 70,000.00 50,522.94 70,000.00 4303 Sex Offender Fee-Out of Town 0.00 0.00 500.00 1,500.00 500.00 4305 Civil Small Claims 58,590.00 59,220.00 50,000.00 42,980.00 50,000.00 4310 Administrative Justice Fund 421,168.64 447,466.97 500,000.00 377,628.96 500,000.00 4320 Court Automation Fund 20,401.27 20,379.06 20,000.00 11,329.92 20,000.00 4398 LLEBG Grant Revenue 0.00 0.00 0.00 0.00 0.00 TOTAL COURT 853,994.68 873,320.74 1,010,500.00 703,425.84 1,010,500.00 g 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE GRANTS 4401 STEP Grant 55,637.92 36,852.87 80,000.00 0.00 80,000.00 4402 School Resource Officer Progra 400,000.00 400,000.00 400,000.00 375,000.00 400,000.00 4403 DEA Task Force- 0.00 0.00 25,000.00 0.00 25,000.00 4405 Juvenile Transport 0.00 0.00 3,000.00 0.00 3,000.00 4406 Prisoner Transport 0.00 0.00 0.00 0.00 0.00 4407 Vest Grant 1,364.73 7,995.61 6,000.00 3,618.89 6,000.00 4412 Drug Task Force 0.00 0.00 0.00 0.00 0.00 4413 Act 833 113,082.66 119,100.95 110,000.00 130,175.98 110,000.00 4414 Federal Forfeiture Reimburse 0.00 0.00 0.00 0.00 0.00 4415 Homeland Security 0.00 0.00 0.00 0.00 0.00 4416 STOP Violence Against Women 0.00 0.00 0.00 0.00 0.00 4417 ACT 1583 0.00 0.00 0.00 0.00 0.00 4418 FF Assitance Grant 0.00 0.00 0.00 0.00 0.00 4419 ACT 1314 0.00 0.00 0.00 0.00 0.00 4420 District Court Grant-Mediation 0.00 0.00 25,000.00 0.00 25,000.00 4423 Wal-Mart Community Grant 0.00 0.00 0.00 0.00 0.00 4424 ASP Special Assist FF Grant 0.00 0.00 0.00 0.00 0.00 4425 ASP Radio System Grant 0.00 0.00 0.00 0.00 0.00 4428 State Funds 1,111,994.69 114,559.44 0.00 268,062.28 0.00 4431 Federal Funds 0.00 2,920,977.60 0.00 397,310.77 0.00 TOTAL GRANTS 1,682,08.0.00 3,599,486.47 649,000.00 1,174,167.92 649,000.00 PERMITS/FEES 4500 Licenses 144,382.50 130,216.25 120,000.00 75,742.50 120,000.00 4501 Certificate of Appropriateness 80.00 250.00 0.00 590.00 0.00 4502 Review Plat Fees 850.00 530.00 1,000.00 1,095.00 1,000.00 4503 Historic District 0.00 0.00 6,000.00 0.00 6,000.00 4504 Sign Fees-Bldg Dept 535.00 572.50 1,000.00 1,436.50 1,000.00 4505 Inspection Fees 62,309.78 87,177.98 82,500.00 93,834.22 100,000.00 4506 Rezone/Variance/Conditional 1,950.00 2,075.00 2,000.00 2,940.00 2,000.00 4507 Erosion Control 3,075.00 3,350.00 3,000.00 3,225.00 3,000.00 4508 ACIEA Tax-Act 474 2,679.53 6,597.10 4,000.00 9,845.63 6,500.00 4509 Curb/Driveway 0.00 0.00 0.00 0.00 0.00 4510 Pet Licenses 5,006.00 4,634.50 4,500.00 4,33B.00 4,500.00 4511 Cleaning Fees-KOH 500.00 0.00 0.00 ( 50.00) 0.00 4512 Rent-KOH 900.00 0.00 0.00 0.00 0.00 4513 Lighting-KOH 250.00 0.00 0.00 0.00 0.00 4514 Ticket Sales - KOH 0.00 0.00 0.00 0.00 0.00 4515 Garage Sales 2,860.00 3,775.00 5,000.00 4,012.50 5,000.00 4516 Bonds-Subdivison 450.00 300.00 500.00 200.00 500.00 4517 Bond Fees 2,060.00 5,160.00 10,000.00 4,960.00 10,000.00 4518 Pound Fees 0.00 0.00 1,000.00 0.00 1,000.00 4519 Accident/Fingerprint 12,732.00 9,795.00 14,000.00 8,433.00 14,000.00 4533 Yard Waste-Revenue 191,094.75 203,969.25 203,000.00 187,857.00 203,000.00 TOTAL PERMITS/FEES 431,714.56 458,402.58 457,500.00 398,459.35 477,500.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 4 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REIMBURSEMENT REVENUE 4601 Insurance Reimbursement-PD 62,978.88 12,912.65 0.00 25,932.73 20,000.00 4602 Insurance Reimbursement-FD 0.00 1,899.27 0.00 8,812.13 8,000.00 4603 Property Clean Up 316.63 1,991.27 2,000.00 333.41 2,000.00 4606 County Court Reimbursement 270,720.00 320,719.92 337,575.00 309,443.75 337,000.00 4607 Ins. Reimburse-Parks/Rec 0.00 0.00 0.00 0.00 0.00 4610 Cobra Insurance Payment 99,248.74 86,593.00 107,000.00 65,772.56 80,000.00 4611 Employee Portion-Ins 212,940.00 217,530.00 232,000.00 176,490.00 290,000.00 TOTAL REIMBURSEMENT REVENUE 646,204.25 641,646.11 678,575.00 586,784.58 737,000.00 4651-4699 NOT USED 4699 Long & Short-Fund 10 0.00 0.00 0.00 0.00 0.00 TOTAL 4651-4699 NOT USED 0.00 0.00 0.00 0.00 0.00 MISCELLANEOUS 4700 Misc. Admin. 13,525.08 320,142.42 20,000.00 10,098.75 20,000.00 4701 Golf Course Lease 865.81 642.05 1,000.00 124.76 0.00 4702 Goose Harbour Lease 0.00 0.00 0.00 0.0'0 0.00 4703 Bench Lease 0.00 0.00 50.00 0.00 50.00 4704 Warrant Service Fees 3,209.14 1,935.00 2,500.00 648.06 2,500.00 4706 Child Protection Program 385.42 171.47 500.00 75.84 500.00 4707 Interpreter Fee 0.00 6.86 150.00 0.00 150.00 4708 Court Miscellaneous 6,092.38 4,830.00 7,500.00 5,825.92 7,500.00 4710 Oil & Gas Lease 1,589.71 3,005.54 3,000.00 4,025.62 3,500.00 4711 Restitution 3,614.96 7,939.96 5,000.00 80.00 5,000.00 4712 Misc. - P.D. 45,5ll.59 9,907.54 7,500.00 7,259.16 7,500.00 4713 Misc.-F.D. 11,107.39 2,414.19 5,000.00 12,331.79 10,000.00 4714 Misc.-M/C 0.00 0.00 0.00 0.00 0.00 4715 Misc. - Library 0.00 0.00 0.00 0.00 0.00 4716 Overtime PD 160.00 16,023.98 45,000.00 730.00 45,000.00 4717 Overtime FD 0.00 0.00 0.00 0.00 0.00 4718 Misc. - Co. Tax-P.D. 0.00 0.00 0.00 0.00 0.00 4719 Misc.-Co. Tax-F.D. 0.00 0.00 0.00 0.00 0.00 4720 Pop Vending Proceeds 0.00 0.00 750.00 0.00 750.00 4721 Credit Card Processing Fee 964.33 1,627.75 1,500.00 0.00 1,500.00 4722 Haz Mat Tech 9,493.00 9,493.00 9,500.00 9,493.00 9,500.00 4723 Citizens Police Academy-Donati 0.00 0.00 0.00 0.00 0.00 4724 DC-VBSD Expense Recovery 0.00 6,446.45 15,600.00 15,246.21 15,600.00 4728 Marina Repairs 0.00 0.00 0.00 0.00 0.00 4729 Veterans' Memorial Grant 0.00 0.00 0.00 0.00 0.00 4730 GIF 0.00 0.00 0.00 0.00 0.00 4731 Misc.-Parks & Rec. 0.00 4,814.03 0.00 0.00 0.00 4751 Misc.-Cemetery 0.00 0.00 0.00 0.00 0.00 4.760 Reserve 0.00 0.00 0.00 0.00 0.00 4790 Keep Van Buren Beautiful 3,500.00 3,500.00 3,500.00 3,500.00 3,500.00 4791 Misc.-Capital Improvements 39,468.16 115,377.12 300,000.00 6,001.10 200,000.00 4792 VB Housing Authority-Pilot 1,190.76 1,190.76 1,200.00 2,083.83 1,200.00 TOTAL MISCELLANEOUS 140,677.73 509,468.12 429,250.00 77,524.04 333,750.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 5 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE TRANSFERS IN 4801 Transfer In 411,9 1.36 450,169.115 300,000.00 4. 0066_939.73 3,552,000.00 TOTAL TRANSFERS IN 411,921.36 450,169.15 300,000.00 4,906,939,73 3,552,000.00 ** TOTAL REVENUE ** 16,944,643.51 20,310,044.55 16,163,525.00 22,543,559.66 20,144,790.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 6 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund City Attorney DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2.020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-10-4010-00 Salaries 35,721.36 39,369.50 44,200,00 26,619.91 49,000.00 5-10-4015-00 Longevity (LONG) 480.00 0.00 490.00 10.00 490.00 5-10-4017-00 Christmas Bonus 0.00 0.00 100.00 0.00 100.00 5-10-4020-00 FICA Expense 1,987.51 2,329.28 2,750.00 lr900.22 3,040.00 5-10-4021-00 Medicare Expense 464.83 544.85 641.00 444.44 710.00 5-10-4025-00 SUTA 21.00 30.00 60.00 30.00 60.00 5-10-4030-00 Group Insurance 20r679.80 12,006.20 15,000.00 10,842'.00 28,500.00 5-10-4035-00 Retirement 5,409.36 6,302.24 7,756.00 4,314.16 B,730.00 5-10-4040-00 Computer Service & Supply 462.31 0.00 1,000.00 107.13 1,000.00 5-10-4050-00 Car Expense 0.00 0.00 0.00 0.00 0.00 ,5-10-4110-00 Workers Comp 52.36 64.17 75.00 53.28 100.00 5-10-4121-00 Advertising 0.00 0.00 200.00 0.00 200.00 5-10-4122-00 Attorney Fees 39,916.63 48,298.63 50,000.00 31,059.30 50,000.00 5-10-4130-00 Postage 35.80 0.00 100.00 0.00 100.00 5-10-5035-00 Gas - Vehicle 0.00 0.00 0.00 0.00 0.00 5-10-5045-00 Utilities & Telephones 1,353.65 1,280.69 1,350.00 1,476.87 1,350.00 5-10-5048-00 Cellular Telephones 0.00 0.00 0.00 0.00 0.00 5-10-5062-00 Office Supplies 1,423.79 3,147.64 1,500.00 2,595.62 1,500.00 5-10-5063-00 Office Equip.-New 0.00 0.00 500.00 0.00 500.00 5-10-5064-00 Office Equip.-Repairs 0.00 984.39 250.00 0.00 250.00 5-10-5070-00 Miscellaneous 0.00 0.00 250.00 0.00 250.00 5-10-5085-60 ARPA Expense 0.00 0.00 0.00 6,000.00 0.00 5-10-5090-00 Dues & Subscriptions 0.00 0.00 0.00 0.00 0.00 5-10-5095-00 Schools & Training 0.00 0.00 0.00 0.00 0.00 5-10-5200-00 Contract Labor 0.00 0.00 0.00 0.00 0.00 5-10-6000-00 Travel & Convention 0.00 0.00 500.00 0.00 500.00 5-10-9010-00 Fixed Assets 0.00 0.00 0.00 0.00 0.00 TOTAL City Attorney 108,008.40 114,357.59 126,722.00 91,452.93 146,380.00 i 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 7 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Administration DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-11-4010-00 Salaries 273,632.46 283,046.67 298,000.00 268,979.38 340,380.00 5-11-4015-00 Longevity (L2 and LONG) 2,512.50 2,080.00 1,255.00 1,217.50 1,255.00 5-11-4017-00 Christmas Bonus 300.00 600.00 300.00 0.00 300.00 5-11-4020-00 FICA Expense 16,820.43 17,867.48 17,700.00 19,113.53 21,465.00 5-11-4021-00 Medicare Expense 3,933.73 4,178.57 4,140.00 4,469.90 4,140.00 5-11-4025-00 SUTA 63.00 117.14 500.00 174.01 180.00 5-11-4030-00 Group Insurance 2B7,941.22 293,225.58 286,605.00 236,407.03 315,000.00 5-11-4035-00 Retirement 57,659.67 59,395.02 51,781.00 51,800.20 59,800.00 5-11-4040-00 Computer Service, Supply & 48,014.68 65,814.32 50,400.00 79,201.95 50,400.00 5-11-4050-00 Mayor's Car Expenses 7,049.91 7,008.88 10,000.00 7,623.03 10,000.00 5-11-4050-01 City Clerk-Car Expense 3,000.00 3,000.00 3,000.00 2,750.00 3,000.00 5-11-4070-00 Contributions 24,125.00 44,500.00 40,000.00 23,625.00 40,000.00 5-11-4110-00 Worker's Comp Insurance 327.22 313.56 500.00 333.03 300.00 5-11-4111-00 Property Insurance 23,265.97 25,626.98 25,700.00 30,009.31 27,920.00 5-11-4121-00 Advertising S.W. & Courier 8,849.32 5,442.34 5,800.00 12,095.80 5,800.00 5-11-4130-00 Postage 6,252.20 2,723.01 4,000.00 4,371.59 4,000.00 5-11-5035-00 Vehicle Gasoline 27.00 0.00 250.00 0.00 250.00 5-11-5045-00 Utilities & Telephones 29,863.14 31,792.46 31,000.00 27,216.17 31,000.00 5-11-5045-01 Phone System 0.00 0.00 1,000.00 0.00 1,000.00 5-11-5048-00 Cellular Telephones 3,346.71 3,727.50 4,000.00 2,914.41 3,500.00 5-11-5055-02 Property Cleanup 11,370.00 2,907.70 10,000.00 1,908.99 10,000.00 5-11-5055-03 Keep Van Buren Beautiful 10,979.93 11,700.00 10,000.00 10,300.00 10,000.00 5-11-5062-00 Office Supplies 12,915.46 12,337.B6 10,000.00 7,296.53 8,000.00 5-11-5062-01 Record Destruction 0.00 0.00 0.00 0.00 0.00 5-11-5063-00 Office Equipment-New 2,564.37 1,669.03 2,000.00 1,260.67 2,000.00 5-11-5064-00 Office Equipment-Repairs 750.00 0.00 500.00 137.74 500.00 5-11-5070-00 Miscellaneous 22,270.21 34,978.57 20f000.00 42,272.62 20,000.00 5-11-5070-01 Sex Offender Expense 0.00 0.00 0.00 500.00 0.00 5-11-5071-00 Credit Card Processing Fee 1,143.01 1,560.70 1,300.00 1,294.77 1,300.00 5-11-5OB5-60 ARPA Expense 0.00 0.00 0.00 240,000.00 50,000.00 5-11-5090-00 Dues & Subscriptions 53,476.80 55,255.10 56,000.00 51,653.58 58,000.00 5-11-5091-00 Economic Development 21,250.00 21,250.00 100„000.00 0.00 75,000.00 5-11-5095-00 School & Training 37.32 274.76 1,000.00 294.00 1,000.00 5-11-6000-00 Travel & Convention 843.90 183.45 1,000.00 1,323.95 1,000.00 5-11-7002-00 Veteran's 'Park Expense 0.00 0.00 0.00 0.00 0.00 5-11-9010-00 Fixed Assets 0.00 1,907.46 1,000.00 9,177.00 1,000.00 5-11-9020-00 Transfer Out General 6,555.14 2,453,470.09 6,600.00 0.00 6,600.00 TOTAL Administration 941,140.30 3,447,954.23 1,055,331.00 1,139,721.75 1,164,090.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 8 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Police Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-12-4010-00 Salaries 2,641,926.22 2,750,402.18 2,486,500.00 2,600,369.10 2,615,000.00 5-12-4010-18 Salaries 25,000.00 0.00 0.00 0.00 0.00 5-12-4015-GO Longevity (LONG) 34,535.00 33,787.50 35,100.00 27,510.00 30,000.0O 5-12-4017-00 Christmas Bonus 5r700.00 15,900.00 6,500.00 0.00 6,000.00 5-12-4019-00 Incentive Pay 126,383.28 89,900.00 85,000.00 76,962.50 85,000.00 5-12-4020-00 FICA Expense 168,033.44 1'71,279.23 175,0G0.00 181,662.91 175000.00 5-12-4021-00 Medicare Expense 39,298.92 40,057.45 40,620.00 42,485.57 40,170.00 5-12-4024-00 Uniform Allowance 0.00 0.00 0.00 0.00 0.00 5-12-4025-00 SUTA 1,472.42 2,161.57 2,200.00 1,893.51 2,200.00 5-12-4030-00 Group Insurance 630,981.44 646,103.62 610,000.00 457,002.32 590,000.00 5-12-4031-00 Medical Expenses 0.00 13.89 0.00 0.00 0.00 5-12-4035-00 Retirement 582,699.47 604,459.22 585,000.00 533,142.17 620,000.00 5-12-4040-00 Computer Service,Supply & E 52,142.91 89,089.29 140,000.00 116,027.22 140,000.00 5-12-4040-18 Computer Service & Supply 33,885.37 52,598.92 0.00 55,963.14 0.00 5-12-4110-00 Workers Comp. 28,090.90 27,302.67 34,300.00 30,640.56 30,000.00 5-12-4111-00 Property Insurance 0.00 0.00 0.00 0.00 0.00 5-12-4111-18 Property Insurance-PD 6,998.40 9,359.41 9,870.00 9,995.30 11,652.00 5-12-4121-00 Advertising 472.88 533.80 1,000.00 156.57 1,000.00 5-12-4130-00 Postage 1,339.60 978.69 1,500.00 627.98 1,500.00 5-12-4141-00 Sanitation 1,877.11 2,084.70 1,800.00 1,724.80 1,800.00 5-12-5030-00 Vehicle Repairs/Maint. 49,135.28 76,356.52 50,000.00 58,944.04 50,000.00 5-12-5030-18 Vehicles Repairs/Maint. 0.00 2,406.28 0.00 203.75 0.00 5-12-5034-00 Vehicle Tags 51.00 60.50 250.00 11.00 250.00 5-12-5035-00 Vehicle Gasoline 74,184.00 115,004.41 110,000.00 123,764.31 125,000.00 5-12-5035-18 Vehicle Gasoline 0.00 0.00 0.00 0.00 0.00 5-12-5040-00 Vehicle Tires/New 16,190.89 19,223.16 15,000.00 12,862.76 15,000.00 5-12-5041-00 Tire Repair 1,284.52 451.60 1,200.00 660.82 1,200.00 5-12-5042-00 Uniforms & Accessories Expe 34,479.23 25,318.72 20,000.00 35,851.89 10,000.00 5-12-5042-01 2nd Year Plus- Uniform Allo 41,443.84 36,574.77 40,000.00 32,220.16 47,000.00 5-12-5042-18 Uniforms and Accessories 3,897.30 15,348.16 0.00 7,629.67 0.00 5-12-5045-00 Utilities & Telephones 51,144.82 54,990.19 52,000.00 66,828.59 52,000.00 5-12-5045-18 New Phone System PD 0.00 0.00 0.00 0.00 0.00 5-12-5048-00 Cellular Telephones 18,045.70 18,572.86 16,000.00 16,934.47 16,000.00 5-12-5055-00 Building Maintenance 12,176.59 8,687.55 12,000.00 '8,944.00 12,000.00 5-12-5055-18 Building Maintenance 320.00 8,261.00 0.00 17,157.74 0.00 5-12-5056-00 Building Cleaning Supplies 6,464.12 4,409.70 6,000.00 5,861.68 6000.00 5-12-5057-00 Building Janitorial Service 0.00 0.00 0.00 0.00 0.00 5-12-5058-00 Lease/Rentals 0.00 0.00 1,000.00 0.00 1,000.00 5-12-5061-00 Restitution 0.00 0.00 600.00 0.00 600.00 5-12-5062-00 Office Supplies 10,197.98 6,996.14 10,000.00 7,204.68 10,000.00 5-12-5062-03 Uniform & Accessories Expen 0.00 0.00 0.00 0.00 0.00 5-12-5062-18 Office Supplies 0.00 1,409.19 0..00 0.00 0.00 5-12-5063-00 Office Equipment-Purchase 5,365.42 1,767.98 3,000.00 3,248.88 9,000.00 5-12-5063-18 Office Equipment-Repairs 2,558.82 1,910•.75 0.00 2,591.37 0.00 5-12-5064-00 Office Equipment-Repairs 7,406.44 3,130.81 4,000.00 2,972.53 4,000.00 5-12-5070-00 Miscellaneous 12,989.48 12,501.95 10,000.00 19,762.95 10,000.00 5-12-5070-18 Miscellaneous 2,379.15 1,227.56 0.00 0.00 0.00 5-12-5075-00 Vehicle Insurance 132.86 457.12 12,000.00 0.00 12,000.00 5-12-5075-18 Vehicle Insurance 11,628.96 11,820.25 0.00 11,912.33 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 9 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Police Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-12-5080-00 Prisoner Care-Jail 210,080.00 257,920.00 261,000.00 167,530.00 240,000.00 5-12-5080-18 Prisoner Care-Jail 0.00 0.00 0.00 0.00 0.00 5-12-5081-00 Prisoner Care-Medical 0.00 0.00 500.00 0.00 500.00 5-12-5082-00 Crawford County 911 0.00 0.00 88,500.00 88,460.58 63,700.00 5-12-5085-60 ARPA Expense 0.00 0.00 0.00 324,000.00 850,000.00 5-12-5090-00 Dues & Subscription 17,667.02 17,708.10 16,500.00 15,235.50 16,500.00 5-12-5090-18 Dues & Subscriptions 0.00 3,125.10 0.00 0.00 0.00 5-12-5095-00 Schools & Training B,838.48 10,242.58 9,500.00 6,353.00 9,500.00 5-12-5096-18 Tuition Assistance 0.00 0.00 3,500.00 1,467.00 3,500.00 5-12-5170-00 Firing Range 1,493.54 1,796.89 1,000.00 863.32 1,000.00 5-12-5182-00 Child Protection Exp 2,126.56 2,963.40 2,000.00 0.00 2,000.00 5-12-6000-00 Travel & Convention 11,350.67 6,976.23 6,000.00 11,273.16 6,000.00 5-12-6005-00 Chemical Analysis 300.00 170.00 1,000.00 45.00 1,000.00 5-12-6005-18 Chemical Analysis 0.00 0.00 0.00 0.00 0.00 5-12-6009-00 HAZ MAT Expense 0.00 0.00 0.00 0.00 0.00 5-12-6009-18 Hazardous Material 4,746.50 4,746.50 4,800.00 4,746.50 4,800.00 5-12-6010-00 Police Equipment-New 25,012.67 24,668.03 30,000.00 26,979.45 30,000.00 5-12-6010-1B Police Equipment-New 13,311.00 57,755.79 20,000.00 93,948.54 20,000.00 5-12-6010-91 Police Equip New-Fixed Asse 0.00 0.00 0.00 0.00 0.00 5-12-6011-00 Police Equipment-Repair 2,614.58 4,607.49 10,000.00 4,145.72 10,000.00 5-12-6011-18 Police Equipment-Repair 0.00 0.00 0.00 0.00 0.00 5-12-6015-00 Juvenile Transport 0.00 0.00 0.00 0.00 0.00 5-12-6016-00 Prisoner Transport 0.00 0.00 0.00 0.00 0.00 5-12-6021-00 ACO Shelter-Electric 4,117.78 4,790.28 4,400.00 3,092.53 0.00 5-12-6023-00 ACO Shelter-Water 1,108.18 875.35 1,500.00 225.45 0.00 5-12-6024-00 ACO Shelter-Maintenance 1,461.32 1,422.68 5,000.00 113.87 0.00 5-12-6025-00 ACO-Landfill 414.96 701.06 1,000.00 172.82 0.00 5-12-6030-00 Police K-9-Food 622.68 635.82 650.00 64.45 650.00 5-12-6031-00 Police K-9-Medical 0.00 0.00 500.00 0.00 500.00 5-12-6032-00 Police K-9-Miscellaneous 151.99 660.45 1,000.00 0.00 1,000.00 5-12-6033-00 ACO - Adoption 0.00 0.00 0.00 0.00 0.00 5-12-6035-00 Special Response Team 5,506.26 5,018.22 7,500.00 5,983.80 7,500.00 5-12-6037-00 Block Grant Expenditures 0.00 0.00 0.00 0.00 0.00 5-12-6037-04 LLEBG Grant Expense 0-.00 0.00 0.00 0.00 0.00 5-12-9010-00 Fixed Assets-Police 77,084.11 36,975.00 0.00 11,744.38 0.00 5-12-9010-03 Walmart & ASP Grant 0.00 0.00 0.00 0.00 0.00 5-12-9010-18 Fixed Assets Police 3,412.11 83,230.85 0.00 92,078.51 0.00 TOTAL Police Department 5,133,734.17 5,489,889.13 5,053,290.00 5,430,254.85 5,998,522.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 10 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Fire Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-13-4010-00 Salaries 2,474,721.35 2,477,641.23 2,625,000.00 2,340,694.90 2,680,000.00 5-13-4010-01 Firemen-FLSA Overtime 0.00 0.00 0.00 0.00 0.00 5-13-4010-19 Salaries 25,000.00 0.00 0.00 0.00 0.00 5-13-4015-00 Longevity (LONG) 41,197.50 41,835.00 43,240.00 38,022.50 43,240.00 5-13-4016-00 ADIP 0.00 0.00 0.00 0.00 0.00 5-13-4017-00 Christmas Bonus 4,700.00 15,000.00 5,200.00 0.00 5,200.00 5-13-4018-00 Hazmat 18,180.00 17,700.00 19,200.00 19,140.00 21,000.00 5-13-4019-00 Incentive Pay 95,087.50 94,337.50 93,000.00 80,775.00 90,000.00 5-13-4021-00 Medicare Expense 36,586.88 36,461.73 39,400.00 39,320.68 40,700.00 5-13-4023-00 SI - Staff Incentive 0.00 0.00 0.00 0.00 0.00 5-13-4024-00 Uniform Allowance 32,725.00 33,775.00 34,000.00 24,850.00 36,400.00 5-13-4025-00 SUTA 1,116.14 1,632.03 2,000.00 1,641.51 2,000.00 5-13-4030-00 Group Insurance 574,132.72 600,845.68 570,000.00 509,308.96 665,000.00 5-13-4031-00 Medical Expenses 906.34 1,003.04 5,000.00 2,351.06 5,000.00 5-13-4031-19 Medical 0.00 0.00 0.00 0.00 0.00 5-13-4035-00 Retirement-Employers Contr. 625,691.27 661,614.71 757;000.00 645,066.91 757,000.00 5-13-4040-00 Computer Services, Supply & 9,196.90 13,327.11 18,100.00 16,336.22 18,100.00 5-13-4040-19 Computer Services, Supply & 0.00 0.00 0.00 0.00 0.00 5-13-4110-00 Workers Comp. 45,783.93 46,422.50 60,000.00 0.00 50,000.00 5-13-4110-19 Worker's Comp. 0.00 0.00 0.00 0.00 0.00 5-13-4111-00 Property Insurance 0.00 0.00 0.00 51,337.52 0.00 5-13-4111-19 Property Insurance-FD 7,650.31 10,011.32 10,100.00 10,724.75 12,305.00 5-13-4130-00 Postage 30.35 509.99 500.00 1.67 250.00 5-13-4141 00 Sanitation 4,427.13 5,802.80 6,150.00 6,600.60 6,150.00 5-13-5030-00 Vehicle Repairs/Maint. 9,413.24 8,254.76 8,000.00 11,792.92 10,000.00 5-13-5034-00 Vehicle Tag 0.00 0.00 100.00 0.00 100.00 5-13-5035-00 Vehicle Gasoline 18,414.84 27,990.79 28,000.00 42,027.80 40,000.00 5-13-5035-19 Vehicle Gasoline 0.00 0.00 0.00 0.00 0.00 5-13-5040-00 Vehicle Tires/New 9,016.78 3,563.70 8r500.00 2,413.80 8,500.00 5-13-5040-19 Vehicle Tires/New 0.00 0.00 0.00 0.00 0.00 5-13-5041-00 Tire Repair 438.97 398.79 500.00 533.53 500.00 5-13-5042-00 Uniforms & Accessories Expe 5,523.09 711.29 4,000.00 1,746.82 3,500.00 5-13-5045-00 Utilities & Telephones 56,346.24 63,217.52 61,800.00 77,986.46 70,000.00 5-13-5045-19 Uttilities & Telephones 0.00 0.00 0.00 0.00 0.00 5-13-5048-00 Cellular Telephones 7,655.12 7,606.35 9,400.00 6,975.19 8,000.00 5-13-5055-00 Building Maintenance 17,434.71 14,617.46 15,000.00 15,624.03 15,000.00 5-13-5055-19 Building Maintenance 0.00 0.00 0.00 0.00 0.00 5-13-5056-00 Building Cleaning Supplies 5,497.48 4,583.44 5,000.00 4,843.23 5,000.00 5-13-5062-00 Office Supplies 550.29 876.06 2,000.00 1,092.18 2,000.00 5-13-5063-00 Office Equipment-New 2,038.97 874.27 2,000.00 158.41 2,000.00 5-13-5063-19 Equipment/Furnishings 0.00 0.00 0.00 0.00 0.00 5-13-5064-00 Office Equipment-Repairs 0.00 154.00 500.00 0.00 500.00 5-13-5070-00 Miscellaneous 7,533.91 4,552.80 7,000.00 6,086.13 7,000.00 5-13-5070-19 Micellaneous-FD 0.00 0.00 0.00 0.00 0.00 5-13-5075-00 Vehicle Insurance 68.14 0.00 17,500.00 0.00 17,500.00 5-13-5075-19 Vehicle Insurance 17,288.53 17,495.78 0.00 17,495.78 0.00 5-13-5085-60 ARPA Expense 0.00 0.00 0.00 312,000.00 700,000.00 5-13-5090-00 Dues & Subscriptions 0.00 175.00 2,000.00 175.00 2,000.00 5-13-5090-19 Dues & Subscriptions 0.00 0.00 0.00 0.00 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 11 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Fire Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-13-5095-00 Schools/Training 7,330.56 7,924.68 13,000.00 6,185.13 15,000.00 5-13-5095-19 School & Training 0.00 0.00 0.00 0.00 0.00 5-13-5096-19 Tuition Assistance 0.00 0.00 3,500.00 0.00 3,500.00 5-13-6000-00 Travel & Convention 0.00 0.00 3,000.00 0.00 3,000.00 5-13-6009-00 HAZ MAT Expense 0.00 0.00 0.00 0.00 0.00 5-13-6009-19 Hazardous Material 4,746.50 4,746.50 5,000.00 4,746.50 5,000.00 5-13-6010-00 Fire Equip Exp 10,105.59 80,675.50 12,500.00 11,058.28 12,500.00 5-13-6010-19 Fire Equip Exp 3,042.3E 0.00 3,50.0.00 0.00 3,500.00 5-13-6010-91 Fire Equip Exp-CI 0.00 0.00 0.00 0.00 0.00 5-13-6011-00 Fire Equip Repair 6,755.30 7,574.69 7,000.00 8,036.72 7,000.00 5-13-6011-19 Fire Equip Repair 0.00 0.00 0.00 0.00 0.00 5-13-6012-00 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 5-13-6012-19 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 5-13-6013-00 Fire Apparatus Repair 22,631.32 18,468.80 20,000.00 39,014.91 30,000.00 5-13-6013-19 Fire Apparatus Repair 5,249.12 0.00 5,000.00 0.00 5,000.00 5-13-6014-00 Fire Prevention/Inspect/Inv 1,211.84 3,186.16 5,000.00 2,125.93 5,000.00 5-13-6039-19 New Fire Dept Expenses 0.00 0.00 0.00 0.00 0.00 5-13-6191-16 Radio Equip-Grant 0.00 0.00 0.00 0.00 0.00 5-13-6195-00 Radio Equipment Repair 1,083.13 2,164.40 2,200.00 416.40 1,500.00 5-13-6195-19 Radio Equipment Repair 0.00 0.00 0.00 0.00 0.00 5-13-6196-00 Radio Equipment Purchase 6,261.36 6,036.00 6,500.00 6,415.61 6,500.00 5-13-6196-19 Radio Equip Purchase-Co Sal 0.00 0.00 0.00 0.00 0.00 5-13-62.02-00 Fire Safety House 0.00 0.00 350.00 0.00 350.00 5-13-6210-00 Act 833 Expense 15,490.75 19,141.10 110,000.00 27,168.62 11.0,000.00 5-13-6210-01 ACT 1583 0.00 0.00 0.00 0.00 0.00 5-13-6210-02 FF Assitance Grant 0.00 0.00 0.00 0.00 0.00 5-13-6211-00 Loan Payment-Fire Truck 106,400.00 106,562.90 51,600.00 51,486.35 51,600.00 5-13-9010-00 Fixed Assets-FD 5,981.38 252,560.90 0.00 0.00 0.00 5-13-9010-16 Fixed Assets-GIF 0.00 0.00 0.00 0.00 0.00 5-13-9010-19 Fixed Assets 0.00 0.00 0.00 0.00 0.00 TOTAL Fire Department 4,350,642.86 4,722,053.28 4,707,340.00 4,443,778.01 5,583,395.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 12 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund District Court DEPARTMENT. EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-14-4010-00 Salaries 342,405.96 362,125.37 383,418.00 338,768.40 387,000.00 5-14-4010-01 Salaries-Judge 46,326.23 46,326.23 46,326.00 42,465.72 46,326.00 5-14-4010-02 Salary Judge County 0.00 0.00 900.00 0.00 900.00 5-14-4015-00 Longevity (LONG and ML) 2,222.50 2,545.00 3,175.00 2,550.00 3,000.00 5-14-4017-00 Christmas Bonus 800.00 2,400.00 1,100.00 0.00 1,100.00 5-14-4019-00 Incentive Pay 900.00 375.00 900.00 337.50 900.00 5-14-4020-00 FICA Expense 20,739.46 21,985.51 24,100.00 24,011.41 24,100.00 5-14-4021-00 Medicare Expense 4,850.06 5,141.80 5,700.00 5,615.77 5,700.00 5-14-4025-00 SUTA 272.34 420.64 500:00 358.68 500.00 5-14-4030-00 Group Insurance B7,479.48 93,584.52 100,482.00 74,177.08 103,000.00 5-14-4035-00 Retirement 52,732.93 55,620.59 59,400.00 51,264.4B 59,400.00 5-14-4040-00 Computer Service,Suppl,y & E 2,148.33 3,104.52 31,500.00 24,817.23 31,500.00 5-14-4110-00 Workers Comp 196.34 188.13 420.00 199.80 300.00 5-14-4121-00 Advertising 133.45 98.52 150.00 102.45 150.00 5-14-4130-00 Postage 3,807.82 3,654.29 3,600.00 2,868.84 3,600.00 5-14.-5045-00 Utilities & Telephones 13,537.06 36,605.20 36,000.00 47,698.41 40f000.00 5-14-5055-00 Building Improvements 21,073.98 12,568.15 20,000.00 14,080.94 17,000.00 5-14-5062-00 Office Supplies 9,117.95 11,432.10 9,000.00 7,538.52 12,000.00 5-14-5062-01 Court Automation Expense 30,135.99 28,206.98 15,000.00 16,304.64 15,000.00 5-14-5063-00 Office Furniture & Equipmen 752.99 41.42 1,500.00 100.00 2,000.00 5-14-5064-00 Office Equipment-Repairs 278.38 1,000.00 250.00 0.00 250.00 5-14-5070-00 Miscellaneous 0.00 154,.57 250.00 43.47 250.00 5=14-5OB5-60 ARPA Expense 0.00 0.00 0.00 62,532.47 0.00 5-14-5090-00 Dues & Subscriptions 1,400.00 1,481.00 1,600.00 1,500.00 1,600.00 5-14-5200-00 Service Contract 2,427.74 2,364.71 2,800.00 2,416.68 2,800.00 5-14;6000-00 Travel & Convention 1,739.30 5,690.82 7,000.00 4,553.84 7,000.00 5-14-7000-00 Collection Agency-City 0.00 0.00 0.00 0.00 0.00 5-14-7001-00 Collection Agency-County 0.00 0.00 0.00 0.00 0.00 5-14-7'033-00 Mediator-District Court 0.00 0.00 0.00 0.00 0.00 5-14-7034-00 Coordinator-District Court 0.00 0.00 0.00 0.00 0.00 5-14-7035-00 Contract Labor 150.00 0.00 2,000.00 0.00 39,500.00 5-14-7036-00 DWI Court 5,154.39 20,423.67 7,500.00 9,531.42 9,000.00 5-14-7037-00 Probation Court 2,732.28 4,291.63 5,000.00 6,397.75 8,000.00 5-14-7038-00 District Court Grant Expens 0.00 0.00 25,000.00 8,533.98 25,000.00 5-14-7051-00 Printing Supplies 0.00 0.00 0.00 0.00 0.00 5-14-7072-00 Equipment Rental/Computers 0.00 0.00 0.00 0.00 0.00 5-14-7100-00 Administrative Justice Fund 467,937.08 494,318.81 500,000.00 403,043.39 500,000.00 5-14-9010-00 Fixed Assets-District Court 0.00 1,638.75 0.00 0.00 0.00 TOTAL District Court 1,121,452.04 1,217,787.93 1,294,571.00 1,151,812.87 1,346,876.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 13 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Library DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-15-4141-00 Sanitation 0.00 0.00 0.00 0.00 0.00 5-15-5045-01 Utilities & Telephones-Libr 36,333.17 40,020.39 40,000.00 51,286.57 50,000.00 5-15-5055-01 Building Maintenance-Librar 21,014.99 22,235.89 20,000.00 18,034.50 20,000.00 5-15-5056-01 Cleaning Supplies-Library 2,538.61 1,980.12 4,000.00 1,808.94 4,000.00 5-15-5070-00 Misc-Old Library 0.00 0.00 0.00 0.00 0.00 5-15-5070-01 Miscellaneous-Library 408.34 1,233.50 2,500.00 347.43 2,500.00 5-15-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 0.00 5-15-7035-01 Contract Labor 10,000.00 10,000.00 0.00 10,000.00 0.00 TOTAL Library 70,295.11 75,469.90 66,500.00 81,477.44 76,500.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 14 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Senior Inn DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-16-5045-00 Utilities- Senior Inn 19,084.83 24,836.67 25,000.00 28,012.63 30,000.00 5-16-5055-00 Building Maint. Senior Inn 2,473.39 2,504.10 3,000.00 5,998.47 3,000.00 5-16-5062-00 Senior Inn Supplies 507.46 290.34 1,500.00 115.07 1,500.00 5-16-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 0.00 TOTAL Senior Inn 22,065.6B 27,631.11 29,500.00 34,126.17 34,500.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 15 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Old Town Merchants Assoc. DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-17-5045-00 Utilities & Telephone 1,286.64 1,480.39 2,000.00 1,684.27 2,000.00 5-17-5055-00 Building Maintenance-OTM 3,285.92 3,986.92 4,500.00 3,466.08 4,500.00 5-17-5062-00 Supplies 0.00 1,209.70 1,000.00 230.53 1,000.00 5-17-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 0.00 TOTAL Old Town Merchants Assoc. 4,572.56 6,677.01 7,500.00 5,380.88 7,500.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 16 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Code Enforcement DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-24-4010-00 Salaries 0.00 0.00 0.00 159,312.48 205,000.00 5-24-4015-00 Longevity (LONG) 0.00 0.00 0.00 1,780.00 lr900.00 5-24-4017-00 Christmas Bonus 0.00 0.00 0.00 0.00 400.00 5-2414020-00 FICA Expense 0.00 0.00 0.00 11,082.96 14,500.00 5-24-4021-00 Medicare Expense 0.00 0.00 0.00 2,592.06 2,600.00 5-24-4025-00 SUTA 0.00 0.00 0.00 167.06 120.00 5-24-4030-00 Group Insurance 0.00 0.00 0.00 27,296.96 49,100.00 5-24-4035-00 Retirement 0.00 0.00 0.00 29,347.94 34,000.00 5-24-4040-00 Computer Service & Supply 0.00 0.00 0.00 1,073.89 2,600.00 5-24-4110-00 Workers Comp 0.00 0.00 0.00 0.00 1,200.00 5-24-4130-00 Postage 0.00 0.00 0.00 282.95 1,700.00 5-24-5030-00 vehicle Repairs/Maintenance 0.00 0.00 0.00 1,268.57 1,500.00 5-24-5035-00 Vehicle Gasoline 0.00 0.00 0.00 6,290.50 9,500.00 5-24-5040-00 Vehicle Tires/New 0.00 0.00 0.00 1,515.85 2,300.00 5-24-5041-00 Tire Repair 0.00 0.00 0.00 43.16 300.00 5-24-5042-00 Uniforms and Accessories 0.00 0.00 0.00 5,214.65 6,000.00 5-24-5048-00 Cellular Telephones 0.00 0.00 0.00 1,149.20 1,800.00 5-24-5062-00 Office Supplies 0.00 0.00 0.00 2,955.93 1,600.00 5-24-5063-00 Office Equipment-Purchases 0.00 0.00 0.00 294.00 1,200.00 5-24-5064-00 Office Equipment-Repairs 0.00 0.00 0.00 0.00 500.00 5-24-5070-00 Miscellaneous 0.00 0.00 0.00 1,009.00 1,500.00 5-24-5075-00 Vehicle Insurance 0.00 0.00 0.00 665.75 815.00 5-24-5085-60 ARPA Expense 0.00 0.00 0.00 50,850.00 0.00 5-24-6021-00 ACO-Electric 0.00 0.00 0.00 2,688.13 4,800.00 5-24-6023-00 ACO-water 0.00 0.00 0.00 825.61 800.00 5-24-6024-00 ACO Shelter Maintenance 0.00 0.00 0.00 4,276.24 5,000.00 5-24-6026-00 ACO Landfill/Permits 0.00 0.00 0.00 457.03 1,000.00 5-24-6033-00 ACO Adoption 0.00 0.00 0.00 0.00 0.00 5-24-6034-00 ACO-Animal Control Equipmen 0.00 0.00 0.00 1,921.93 1,500.00 5-24-9010-00 Fixed Assets 0.00 0.00 0.00 0.00 0.00 TOTAL Code Enforcement 0.00 0.00 0.00 314,361.85 353,235.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 17 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Building Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-25-4010-00 Salaries 77,166.40 90,849.20 83,000.00 70,550.17 89,610.00 5-25-4015-00 Longevity (LONG and L2) 2,670.00 2,790.00 2,700.00 1,250.00 2,700.00 5-25-4017-00 Christmas Bonus 200.00 600.00 200.00 0.00 200.00 5-25-4020-00 FICA Expense 4,548.06 5,428.64 5,100.00 4,938.55 5,100.00 5-25-4021-00 Medicare Expense 1,063.62 1,269.68 1,200.00 1,155.11 1,302.00 5-25-4025-00 SUTA 42.00 60.00 75.00 60.00 75.00 5-25-4030-00 Group Insurance 26,100.80 25,016.60 26,020.00 10,842.00 14,215.00 5-25-4035-00 Retirement 12,230.90 12,096.18 12,500.00 10,999.75 14,000.00 5-25-4040-00 Computer Service,Supply & E 860.05 2,138.05 750.00 314.53 750.00 5-25-4110-00 Workers Comp 497.70 721.00 1,300.00 913.40 800.00 5-25-4125-00 Act 474 2,551.77 4,386.40 5,000.00 9,220.48 6,500.00 5-25-4126-00 Bldg. Permits Ded. to Sidew 8,312.58 12,449.76 12,000.00 12,718.80 12,000.00 5-25-4130-00 Postage 1.75 2.65 250.00 149.27 250.00 5-25-5030-00 Vehicle Repairs/Mtnce. 267.93 1,288.97 1,000.00 506.22 1,000.00 5-25-5035-00 Vehicle Gasoline 1,553.05 2,663.89 2,850.00 3,661.55 4,200.00 5-25-5040-00 Vehicle Tires/New 343.17 439.48 400.00 809.37 650.00 5-25-5045-00 Utilities & Telephones 0.00 523.09 0.00 619.70 0.00 5-25-5048-00 Cellular Telephones 1,243.06 1,249.53 1,500.00 1,147.08 1,500.00 5-25-5062-00 Office Supplies 133.48 540.80 1,500.00 2,831.59 2,500.00 5-25-5063-00 Office Equipment-New 0.00 0.00 1,000.00 0.00 1,000.00 5-25-5064-00 Office Equipment-Repairs 0.00 0.00 250.00 0.00 250.00 5-25-5070-00 Miscellaneous 145.52 0.00 250.00 779.56 250.00 5-25-5075-00 Vehicle Insurance 433.02 304.50 450.00 304.50 450.00 5-25-5085-60 ARPA Expense 0.00 0.00 0.00 12,000.00 77,000.00 5-25-5090-00 Dues & Subscriptions 329.00 424.00 750.00 692.33 750.00 5-25-6000-00 Travel & Convention 0.00 326.52 500.00 493.41 500.00 5-25-9010-00 Fixed Assets 0.00 0.00 0.00 0.00 0.00 TOTAL Building Department 140,693.86 165,568.94 160,545.00 146,957.37 237,552.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 18 'PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Planning Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-26-4010-00 Salaries 90,169.84 99,030.00 104,475.00 95,316.32 110,600.00 5-26-4015-00 Longevity (L2') 255.00 45.00 175.00 135.00 175.00 5-26-4017-00 Christmas Bonus 100.00 300.00 200.00 0.00 200.00 5-26-4020-00 FICA Expense 5,336.59 6,021.78 6,470.00 6,516.86 6,470.00 5-26-4021-00 Medicare Expense 1,248.01 1,448.02 1,600.00 1,,524.20 1,600.00 5-26-4025-00 SUTA 42.00 61.56 240.00 60.00 240.00 5-26-4030-00 Group Insurance 21,764.00 18,503.28 19,000.00 15,762.80 21,000.00 5-26-4035-00 Retirement 14,404.52 15,729.90 16,000.00 15,167.04 17,000.00 5-26-4040-00 Computer 'Service,Supply & E 1,862.82 2,113.94 1,000.00 551.61 1,000.00 5-26-4045-11 HDC 15-CLG-13 0.00 0.00 0.00 0.00 0..00 5-26-4045-12 16-HPRG-28 0.00 0.00 0.00 0.00 0.00 5-26-4045-13 HDC 16-CLG-15 0.00 0.00 0.00 0.00 0.00 5-26-4045-14 17-CLG-9 0.00 0.00 0.00 0.00 0.00 5-26-4045-15 HDC-18-CLG-11 0.00 0.00 0.00 0.00 0.00 5-26-4045-16 HDC 22-CLG-06 0.00 0.00 0.00 9,783.43 0.00 5-26-4050-01 Vehicle Allowance 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 5-26-4110-00 Workers Comp. 465.60 694.18 1,750.00 883.93 1,200.00 5-26-4121-00 Planning-Advertising 3,355.72 1,929.99 2,500.00 2,074.70 2,500.00 5-26-4130-00 Postage 175.75 225.16 500.00 588.28 500.00 5-26-5035-00 Vehicle Gasoline 0.00 0.00 500.00 0.00 500.00 5-26-5045-00 Utilities & Telephones 424.20 1,555.66 200.00 2,310.56 200.00 5-26-5048-00 Cellular Telephones 600.00 600.00 650.00 550.00 650.00 5-26-5062-00 Office Supplies 3,312.66 1,132.78 1,250.00 2,331.39 1,250.00 5-26-5063-00 Office Equipment-New 1,232.82 255.38 3,000.00 65.54 3,000.00 5-26-5064-00 Office Equipment-Repairs 0.00 0.00 0.00 0.00 0.00 5-26-5070-00 Miscellaneous 248.76 465.00 500.00 15.00 500.00 5-26-5085-60 ARPA Expense 0.00 0.00 0.00 12,000.00 0.00 5-26-5090-00 Dues & Subscriptions 1,485.00 1,730.00 1,500.00 2,287.25 1,500.00 5-26-5095-00 School and Training 0.00 0.00 1,500.00 0.00 1,500.00 5-26-6000-00 Travel & Conventions 0.00 0.00 1,750.00 0.00 1,750.00 TOTAL Planning Department 149,483.29 154,841.63 167,760.00 170,923.91 176,335.00 12-19-2022 02,:10 PM C I T Y O F V A N B U R E N PAGE: 19 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Levee DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-27-5070-00 Miscellaneous - Levee Exp. 0.00 0.00 0.00 0.00 0.00 5-27-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 0.00 5-27-7035-00 Contract Labor 1,950.00 11950.00 1,950.00 2,075.00 1,950.00 TOTAL Levee 1,950.00 1,950.00 1,950.00 2,075.00 1,950.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 20 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Parks & Recreation DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-31-4010-00 Salaries 99,632.38 100,370.96 102,700.00 95,394.65 105,719.00 5-31-4010-01 Salary-Contract Labor P & R 0.00 0.00 0.00 0..00 0;00 5-31-4015-00 Longevity (L2 and LONG) 1,410.00 1,530.00 1,400.00 1,510.00 1,400.00 5-31-4017-00 Christmas Bonus 300.00 900.00 300.00 0.00 300.00 5-31-4020-00 FICA Expense 6,015.43 6,068.70 6,100.00 6,506.52 6,800.00 5-31-4021-00 Medicare Expense 1,406.87 1,419.27 1,520.00 1,521.65 1,600.00 5-31-4025-00 SUTA 42.00 63.39 250.00 61.85 250.00 5-31-4030-00 Group Insurance 41,571.60 39,603.28 39,100.00 32,526.00 42,700.00 5-31-4035-00 Retirement 15,306.49 15,517.02 16,400.00 21,823.40 16,800.00 5-31-4040-01 Computer Service and Equip 547.04 516.04 0.00 1,776.84 0.00 5-31-4110-00 Ins./Surety Bond, W/C 1,510.59 1,552.49 0.00 2,029.80 0.00 5-31-4110-01 Workers Comp. - FOD 0.00 0.00 1,650.00 0.00 1,650.00 5-31-4111-01 Property Insurance-FOD 8,957.20 9,810.58 11,400.00 12,166.35 12,103.00 5-31-4130-01 Postage. 0.00 0.00 40.00 9.01 40.00 5-31-4141-00 Sanitation/Parks 3,117.99 3,461.75 2,500.00 3,750.59 2,500.00 5-31-4141-01 Sanitation/FOD 2,385.30 1,768.44 2,500.00 1,768.71 2,500.00 5-31-5030-00 Vehicle Repairs/Maint. 1,214.57 1,026.45 2,000.00 1,917.47 2,000.00 5-31-5035-00 Vehicle Gasoline 9,865.85 17,797.72 14,500.00 16,132.17 14,500.00 5-31-5040-00 Vehicle Tires/New 1,330.73 874.03 1,600.00 1,487.20 2,600.00 5-31-5041-01 Tire Repair 87.35 57.10 200.00 273.66 200.00 5-31-5042-00 Uniforms & Accessories 444.77 1,147.07 1,300.00 278.55 1,600.00 5-31-5045-00 Utilities&Telephones-CityPa 11,141.60 13,295.58 9,200.00 16,647.24 9,200.00 5-31-5045-01 Utilities & Telephone/FOD 22,911.51 31,016.83 42,000.00 35,914.88 42,000.00 5-31-5045-02 Security - FOD 0.00 98.16 500.00 255.00 500.00 5-31-5045-03 Tennis Utilities 3,070.89 3,303.71 2,750.00 3,165.16 2,750.00 5-31-5045-04 Security - Parks 420.68 1,283.83 750.00 6,000'.30 750.00 5-31-5048-00 Cellular Telephones 962.44 1,714.46 1,000.00 1,932.98 1,000.00 5-31-5055-00 Bldg. & Equip. Maint. - Par 6,051.01 11,271.06 3,000.00 13,022.52 10,000.00 5-31-5055-01 Building & Equip. Maint. - 4,867.35 8,646.15 5,000.00 24,301.29 8,000.00 5-31-5055-03 Tennis Courts-Maintenance 1,131.57 258.17 2,500.00 651.90 2,500.00 5-31-5062-00 Supplies-Parks 8,799.53 6,751.68 17,500.00 6,920.41 12,000.00 5-31-5062-01 Supplies-FOD 4,B83.48 13,206.69 10,000.00 4,175.39 10,000.00 5-31-5062-02 Supplies - Lee Creek Park 0.00 0.00 0.00 0.00 0.00 5-31-5062-03 Tennis Materials & Supplies 822.30 972.85 2,500.00 886.92 2,500.00 5-31-5063-01 Chemicals & Fert. -FOD 4,286.12 2,927.53 5,000.00 4,942.60 8,000.00 5-31-5063-03 Irrigation 0.00 379.90 500.00 0.00 500.00 5-31-5070-00 Miscellaneous 1,269.14 609.68 1,000.00 17,802.94 1,000.00 5-31-5072-01 Storm Damage Repairs 67.25 0.00 0.00 0.00 0.00 5-31-5075-00 Vehicle Insurance 6,200.61 6,200.61 6,300.00 6,366.61 6,300.00 5-31-5085-60 ARPA Expense 0.100 0.00 0.00 12,000.00 0.00 5-31-6010-00 Small Tools 739.07 2,059.63 1,000.00 799.71 1,000.00 5-31-7035-00 Contract Labor 0.00 0.00 0.00 0.00 0.00 5-31-7035-01 Contract Labor-Mowing 2,055.00 2,625.00 2,100.00 6,835.00 2,100.00 5-31-7072-01 Equipment Rental-FOD 0.00 140.15 400.00 157.86 400.00 5-31-9010-00 Fixed Assets-Parks 0.00 4,990.42 0.00 0.00 0.00 5-31-9010-01 Fixed Assets-FOD 0.00 4,990.41 0.00 0.00 0.00 TOTAL Parks & Recreation 274,825.71 320,226.79 318,460.00 363,713.13 335,762.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 21 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Property Maintenance DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-32-4010-00 Salaries 193,687.41 246,178.07 215,000.00 249,588.52 270,000.00 5-32-4010-01 Salary-Contract Labor Facil 0.00 0.00 0.00 0.00 0.00 5-32-4015-00 Longevity (LONG) 232.50 330.00 450.00 410.00 500.00 5-32-4017-00 Christmas Bonus 200.00 300.00 200.00 0.00 400.00 5-32-4020-00 FICA Expense 6,132.70 7,686.47 9,000.00 9,613.99 9,275.00 5=32-4021-00 Medicare Expense 1,434.28 1,797.74 2,100.00 2,248.49 2,200.00 5-32-4025-00 SUTA 69.29 170.40 120.00 139.20 120.00 5-32-4030-00 Group Insurance 10,333.68 13,792.82 17,800.00 14,762.40 19,160.00 5-32-4031-00 Medical Expenses 962.86 955.06 1,000.00 1,067.76 1,000.00 5-32-4035-00 Retirement 15,289.08 19,294.14 22,200.00 20,382.23 23,000.00' 5-32-4040-00 Computer Service, Supply & 0.00 0.00 0.00 394.80 0.00 5-32-4110-00 Workers Comp 240.83 441.91 2,210.00 0.00 1,500.00 5-32-4111-00 Property Insurance 0.00 0.00 0.00 559.84 0.00 5-32-4130-00 Postage 0.00 0.00 0.00 0.00 0.00 5-32-4141-01 Sanitation/Admin 970.11 1,007.39 900.00 891.44 900.00 5-32-4141-03 Sanitation-Annex 941.74 1,120.29 900.00 865.37 900.00 5-32-5030-00 Vehicle Repair/Maint. 501.52 348.38 1,500.00 750.31 1,500.00 5-32-5030-01 Mowing Equipment Maint 0.00 895.79 2,000.00 1,359.83 2,000.00 5-32-5030-02 Lawn Care Supplies 0.00 0.00 0.00 0.00 0.00 5-32-5035-00 Vehicle Gasoline 697.76 3,227.57 3,200.00 4,711.37 4,300.00 5-32-5035-01 Fuel/Lawnmowers/Small Eng 0.00 0.00 500.00 0.00 500.00 5-32-5040-00 Vehicle Tires/New 799.25 1,D29.10 1,000.00 1,439.00 2,000.00 5-32-5041-00 Tire Repair 767.40 1,111.64 200.00 38.28 200.00 5-32-5042-00 Uniforms & Accessories 443.39 696.83 750.00 616:18 900.00 5-32-5042-01 Personal Protective Equip 2,678.96 0.00 500.00 0.00 500.00 5-32-5045-02 Complex Security 673.96 121.84 700.00 645.66 700.00 5-32-5045-03 Utilities & Telephone-Annex 5,281.99 6,073.59 6,000.00 7,131.70 6,000.00 5-32-5048-00 Cellular Telephone 852.83 284.74 1,000.00 0.00 1,000.00 5-32-5055-00 Building Maint.-Annex 2,14B.02 1,662.73 2,000.00 1,811.79 2,000.00 5-32-5055-01 Building Maintenance-Admin 5,588.14 2,751.33 5,200.00 3,669.18 5,200.00 5-32-5055-02 Ground Maintenance-Admin 635.14 3,563.46 2,500.00 1,107.4E 2,500.00 5-32-5055-07 Property Maint. Fencing, et 0.00 0.00 0.00 0.00 0.00 5-32-5055-08 Parks - Cleaning Supplies 0.00 10.93 0.00 0.00 0.00 5-32-5055-09 Building Maint.-Annex 725.85 461.12 500.00 0.00 500.00 5-32-5055-11 Leased Property 'Expenses 217.81 1,157.61 1,500.00 87.88 1,500.00 5-32-5055-12 PM - Recycling Dumpters 4,200.00 4,187.73 4,200.00 3,850.00 4,200.00 5-32-5056-00 Cleaning Supplies-Admin 4,216.98 1,328.24 3,500.00 2,093.93 3,500.00 5-32-5056-01 Cleaning Supplies-Annex 349.70 1,060.92 2,000.00 1,309.13 2,000.00 5-32-5062-00 Office Supplies and Materia 113.61 38.99 250.00 0.00 250.00 5-32-5062-01 Marina Repairs Expense 13.14 0.00 0.00 62.25 0.00 5-32-5063-00 Office Equipment 0.00 0.00 250.00 0.00 250.00 5-32-5063-01 Chemicals & Fert. 0.00 0.00 0.00 0.00 0.00 5-32-5063-02 Materials 0.00 0.00 0.00 0.00 0.00 5-32-5063-03 Irrigation 0.00 108.66 500.00 0.00 500.00 5-32-5070-00 Miscellaneous 2,499.18 1,235.09 2,000.00 1,430.2E 2,000.00 5-32-5075-00 Vehicle Insurance - PM 190.20 190.20 500.00 24.20 500.00 5-32-5085-60 ARPA Expense 0.00 0.00 0.00 24,000.00 0.00 5-32-5090-00 Due & Subscription 0.00 27.54 50.00 0.00 50.00 5-32-5095-00 School & Training 0.00 0.00 0.00 0.00 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 22 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Property Maintenance DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE' 5-32-6000-00 Travel and Convention 0.00 0.00 0.00 0.00 0.00 5-32-6010-00 Small Tools 153.44 701.84 750.00 533.01 750.00 5-32-7035-01 Contract Labor-Library 0.00 0.00 0.00 0.00 0.00 5-32-7035-02 Contract Labor-Mowing 0.00 0.00 300.00 0.00 300.00 5-32-9010-00 Fixed Assets 0.00 10,876.84 0.00 0.00 0.00 TOTAL Property Maintenance 264,242.75 336,227.00 315,230.00 357,595.50 374,555.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 23 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER '30TH, 2022 10 -General Fund Yard Waste DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-33-4010-00 Salaries 78,456.31 98,645.49 105,000.00 80,678.86 95,000.00 5-33-4015-00 Longevity (LONG) 810.00 930.00 1,000.00 960.00 1,000.00 5-33-4017-00 Christmas Bonus 200.00 600.00 300.00 0.00 .300.00 5-33-4020-00 FICA Expense 4,589.60 5,930.65 5,600.00 5,620.35 5,700.00 5-33-4021-00 Medicare Expense 1,073.34 1,387.03 1,500.00 1,314.43 1,400.00 5-33-4025-00 SUTA 42.00 94.09 325.00 60.00 60.00 5-33-4030-00 Group Insurance 26,020.80 23,452.24 25,000.00 15,762.80 21,600.00 5-33-4031-00 Medical Expenses 0.00 0.00 0.00 0.00 0.00 5-33-4035-00 Retirement 12,143.61 15,204.38 15,000.00 12,507.08 14,000.00 5-33-4040-00 Computer Service, Supply 0.00 0.00 0.00 0.00 0.00 5-33-4110-00 Workers Comp 288.99 465.16 1,200.00 589.29 1,000.00 5-33-4111-00 Property Insurance 0.00 0.00 0.00 0.00 0.00 5-33-4130-00 Postage 0.00 0.00 0.00 0.00 0.00 5-33-4141-00 Sanitation 0.00 0.00 0.00 0.00 500.00 5-33-5030-00 Vehicle Repair/Maint 71.01 447.63 2,000.00 3,116.80 2,000.00 5-33-5035-00 Vehicle Fuel 4,982.99 4,862.64 7,000.00 8.,347.02 13,000.00 5-33-5040-00 Vehicle Tires/New 0.00 984.11 2,000.00 1,534.01 2,000.00 5-33-5041-00 Tire Repair 54.88 133.19 100.00 152.04 500.00 5-33-5042-00 Uniforms & Accessories 870.48 1,497.01 1,300.00 606.39 1,300.00 5-33-5042-01 Personal Protective Equip 149.99 531.34 500.00 150.00 300.00 5-33-5045-00 Utilities & Telephone 81.56 0.00 500.00 0.00 500.00 5-33-5048-00 Cellular Telephone 0.00 0.00 0.00 0.00 0.00 5-33-5052-00 Tree Removal 2,450.00 1,575.00 4,265.00 0.00 2,000.00 5-33-5052-01 Compost Site 4,042.24 791.65 5,000.00 3,169.94 5,000.00 5-33-5055-00 Building & Equipment Maint 0.00 0.00 0.00 23.37 0.00 5-33-5056-00 Building Cleaning Supplies 0.00 0.00 0.00 0.00 0.00 5-33-5062-00 Material and Supplies 0.00 0.00 1,000.00 0.00 1,000.00 5-33-5063-00 Office Equipment 0.00 0.00 0.00 0.00 0.00 5-33-5063-01 Chemicals & Fert 0.00 0.00 0.00 0.00 0.00 5-33-5063-02 Materials 0.00 0.00 0.00 0.00 0.00 5-33-5070-00 Miscellaneous 920.79 3,426.48 5,000.00 0.00 3,000.00 5-33-5075-00 Vehicle Insurance 704.25 752.10 1,250.00 349.60 800.00 5-33-5085-60 ARPA Expense 0.00 0.00 0.00 12,000.00 0.00 5-33-5090-00 Due & Subscription 0.00 0.00 200.00 0.00 200.00 5-33-5095-00 School & Training 280.00 929.00 1,500.00 375.00 750.00 5-33-6000-00 Travel and Convention 0.00 0.00 0.00 0.00 0.00 5-33-6010-00 Small Tools 65.65 545.21 500.00 67.35 500.00 5-33-6010-01 Small Tool Repair 0.00 429.71 1,000.00 0.00 400.00 5-33-6010-02 Small Tool-Fuel 0.00 0.00 0.00 0.00 0.00 5-33-6010-03 Truck Rental 0.00 0.00 20,000.00 0.00 7,500.00 5-33-6011-00 Equipment Repair-Compost 993.41 1,471.12 2,000.00 6,432.47 4,000.00 5-33-9010-00 Fixed Assets 0.00 0.00 0.00 0.00 0.00 TOTAL Yard Waste 139,291.90 165,085.23 210,040.00 153,816.80 185,310.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 24 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Cemetery DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-51-5045-00 Utilities & Telephone 459.31 502.45 500.00 593.18 500.00 5-51-5062-00 Materials & Supplies 0.00 250.00 250.00 250.67 250.00 5-51-5070-00 Miscellaneous-Cemetery 1,800.00 1,247.03 1,500.00 111.77 1,500.00 5-51-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 0.00 5-51-5090-00 Historic Preservation 0.00 0.00 0.00 0.00 0.00 TOTAL Cemetery 2,259.31 1,999.48 2,250.00 955.62 2,250.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE.: 25 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund King Opera House DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-54-4040-00 Computer Service and Suppli 0.00 0.00 0.00 0.00 0.00 5-54-4110-00 'Ins./Surety Bond 103.00 103.00 100.00 103.00 100.00 5-54-4141-00 Sanitation 1,097.03 1,244.94 1,000.00 2,280.59 1,000.00 5-54-4160-00 Return/Cleaning Fees 200.00 0.00 1,250.00 0.00 1,250.00 5-54-5045-00 Utilities & Telephone 11,626.85 10,103.29 9,000.00 17,055.96 9,000.00 5-54-5055-00 Building Maint./Repairs 3,348.93 11,344.66 3,000.00 3,239.74 3,000.00 5-54-5055-02 Security System 594.76 480.92 1,000.00 870.30 1,000.00 5-54-5062-00 Supplies 673.31 518.56 1,250.00 351.56 1,250.00 5-54-5070-00 Miscellaneous 0.00 398.59 500.00 0.00 500.00 5-54-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 0.00 5-54-5200-00 Contracts 7,435.00 3,150.00 6,000.00 0.00 6,000.00 5-54-9010-00 Fixed Assets-KOH 0.00 0.00 0.00 0.00 0.00 TOTAL King Opera House 25,078.88 27,343.96 23,100.00 23,901.15 23,100.00 0 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 26 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 10 -General Fund Capital Improvement DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-91-5085-60 ARPA Expense 0.00 0.00 0.00 0.00 1,575,000.00 5-91-5203-10 Capital Improv-City Attorne 0.00 0.00 0.00 0.00 0.00 5-91-5203-11 Capital Imp.-Administration 26,730.34 18,176.55 10,000.00 0.00 30,000.00 5-91-5203-12 Capital Improvement-PD 30,164.00 91,943.51 180,000.00 322,307.17 150,000.00 5-91-5203-13 Capital Imp-Fire Dept. 96,058.40 600,186.51 145,000.00 131,403.95 110,000.00 5-91-5203-18 Capital Imp-Levee ( 1,196.93) 0.00 10,000.00 0.00 10,000.00 5-91-5203-19 C I -Storm Disaster Recover 366,287.39 629,B36.41 0.00 27,311.02 0.00 5-91-5203-20 Capital Imp. Street - Inhou 109,919.75 241,704.65 120,000.00 221,231.92 120,000.00 5-91-5203-21 Capital Imp.-Street & Drain 99,915.55, 526,618.63 1,500,000.00 1,287,340.83 1,525,000.00 5-91-5203-22 Capital Imp.-Water & Sewer 240,000.00 240,000.00 240,000.00 220,142.24 240,000.00 5-91-5203-31 Capital Imp.-Parks & Rec. 211,897.82 133,731.96 85,000.00 205,360.04 75,000.00 5-91-5203-33 Capital Imp.-Senior Inn 655.22 0.00 3,000.00 0.00 2,000.00 5-91-5203-34 Intermodal Port Expenses 20,000.00 18,125.00 19,000.00 18,125.00 21,200.00 5-91-5203-41 Capital Improvements-Librar 4,362.56 0.00 5,000.00 9,310.32 2,000.00 5-91-5203-51 Capital 'Imp. - Cemetery 0.00 0.00 5,000.00 1,158.05 2,800.00 5-91-5203-54 Capital Improvement-KOH 3,003.87 10,000.00 5,.000.00 3,754.02 12,000.00 5-91-5203-55 Capital Improvements-Sidewa 53,167.67 57,553.11 200,000.00 52,498.87 200,000.00 5-91-5203-60 Partnership 17,416.42 0.00 0.00 0.00 0.00 TOTAL Capital Improvement 1,278,382.06 2,567,876.33 2,527,000.00 2,499,943.43 4,075,000.00 *** TOTAL EXPENDITURES *** 14,028,118.88 18,842,939.54 16,067,089.00 16,412,248.66 20,122,812.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 20 -Street Fund FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 21,385.13 18,907.34 25,000.00 30r583.83 25,000.00 TAXES 2,189,314.34 2,141,179.30 2,090,000.00 2,300,346.52 2,165,000.00 PERMITS/FEES 1,900.00 350.00 1,000.00 450.00 1,000.00 REIMBURSEMENT REVENUE 20,988.90 20,350.00 19,000.00 34,036.12 19,000.00 MISCELLANEOUS 19,890.39 12,594.41 5,000.00 45,424.37 5,000.00 TRANSFERS IN 0.00 50.00 0.00 0.00 500,000.00 ** TOTAL REVENUE ** 2,253,478.76 2,193,431.05 2,140,000.00 2,410,840.84 2,715,000.00 EXPENDITURE SUMMARY Street Department 1,379,708.78 1,813,388.90 2,039,100.00 1,688,395.24 2,620,350.00 Street Department 0.00 0.00 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 1,379,708.78 1,813,388.90 2,039,100.00 1,688,395.24 2,620,350.00 ** REVENUE OVER(UNDER) EXPENDITURES ** 873,769.98 380,042.15 100,900.00 722,445.60 94,650.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH', 2022 20 -Street Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest Earned 21,385.13 18,907.34 25,000.00 30,583.83 25,000.00 TOTAL INTEREST 21,385.13 18,907.34 25,000.00 30,583.83 25,000.00 ,TAXES 4100 State Turnback-Street 1,720,508.92 1,887,210.23 1,650,000.00 1,830,748.02 1,725,000.00 4105 Property Tax 468,805.42 253,969.07 440,000.00 469,598.50 440,000.00 TOTAL TAXES 2,189,314.34 2,141,179.30 2,090,000.00 2,300,346.52 2,165,000.00 P MTER ITS/FEES 4507 Street Cut 1,900.00 150.00 11000.00 450.00 11000.00 TOTAL PERMITS/FEES 1,900.00 350.00 1,000.00 450.00 1,000.00 REIMBURSEMENT REVENUE 4601 Insurance-Reimbursement 3,708.90 2,890.00 0.00 17,836.12 0.00 4605 VBMU Engineer Exp. Reimb. 0.00 0.00 0.00 0.00 0.00 4611 Employee Portion-Insurance 17,280.00 17,460.00 19,000.00 16,200.00 19,000.00 TOTAL REIMBURSEMENT REVENUE 20f988.90 20,350.00 19,000.00 34,036.12 19,000.00 MISCELLANEOUS 4711 Restitution 0.00 0.00 0.00 0.00 0.00 4720 Misc. - Street 6,163.39 13,055.36 5,000.00 45,424.37 5,000.00 4721 Street Overlay 0.00 ( 460.95) 0.00 0.00 0.00 4722 Traffic Sign Maint. Rev. 0.00 0.00 0.00 0.00 0.00 4723 Equipment Revenue 13,727.00 0.00 0.00 0.00 0.00 4724 Rena Road 0.00 0.00 0.00 0.00 0.00 4726 Misc Revenue-Engineer 0.00 0.00 0.00 0.00 0.00 4795 Loan Proceeds 0.00 0.00 0.00 0.00 0.00 TOTAL MISCELLANEOUS 19,890.39 12,594.41 5,000.00 45,424.37 5,000.00 TRANSFERS IN 4801 Transfer In 0.00 50.00 0.00 0.00 500,000.00 TOTAL TRANSFERS IN 0.00 50.00 0.00 0.00 500,000.00 ** TOTAL REVENUE ** 2,253,478.76 2,193,431.05 2,140,000.00 2,410,.840.84 2,715,000.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 20 -Street Fund Street Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-21-4010-00 Salaries 428,647.87 484,939.83 525,000.00 454,819.38 580,600.00 5-21-4010-01 Contract Labor 0.00 0.00 0.00 0.00 0.00 5-21-4010-26 Salaries - Eng. 0.00 0.00 35,000.00 0.00 35,000.00 5-21-4015-00 Longevity (L2) 6,435.00 6,105.00 6,620.00 5,937.50 7,500.00 5-21-4015-26 Longevity (1,2) 0.00 0.00 250.00 0.00 250.00 5-21-4017-00 Christmas Bonus 1,100.00 3,000.00 1,400.00 0.00 1,400.00 5-21-4017-26 Christmas Bonus 0.00 0.00 100.00 0.00 100.00 5-21-4019-00 Incentive Pay 900.00 900.00 825.00 825.00 825.00 5-21-4020-00 FICA Expense 25,888.62 28,679.86 31,000.00 31,364.97 34,000.00 5-21-4020-26 FICA-Eng. 0.00 0.00 2,500.00 0.00 0.00 5-21-4021-00 Medicare Expense 6,054.71 6,707.57 7,500.00 7,335.35 8,500.00 5-21-4021-26 Medicare - Eng. 0.00 0.00 1,000.00 0.00 0.00 5-21-4025-00 SUTA 248.79 434.01 360.00 394.73 360.00 5-21-4025-26 SUTA-Eng 0.00 0.00 200.00 0.00 0.00 5-21-4030-00 Group Insurance 117,449.36 122,078.16 135,000.00 108,795.80 140,000.00 5-21-4030-26 Group Insurance-Eng. 0.00 0.00 12,960.00 0.00 0.00 5-21-4031-00 Medical Expenses 40.00 231.00 0.00 203.00 0.00 5-21-4035-00 Retirement 66,792.61 72,138.57 78,000.00 70,465.76 B1,000.00 5-21-4035-26 Retirement-Eng. 0.00 0.00 5,000.00 0.00 5,000.00 5-21-4040-00 Computer Service,Supp & Equ 8,660.05 11,433.12 8,000.00 8,952.12 8,000.00 5-21-4040-26 Computer Serv./Supp/Equip/E 21,161.51 2,580.42 35,000.00 6,297.19 20,000.00 5-21-4110-00 Workers Comp. 13,302.54 11,487.23 20,000.00 14,355.55 15,000.00 5-21-4110-26 Workers Comp. 0.00 0.00 250.00 0.00 0.00 5-21-4111-00 Property Insurance 7,023.27 9,384.28 9,400.00 10,099.07 9,400.00 5-21-4130-00 Postage 11.50 76.03 0.00 0.00 0.00 5-21-4130-26 Postage 0.00 0.00 0.00 0.00 0.00 5-21-4141-00 Sanitation 1,738.64 1,602.64 2,000.00 1,597.64 2,000.00 5-21-5030-00 Vehicle Repairs/Maint. llr037.45 16,798.74 17,000.00 23,365.69 20,000.00 5-21-5030-02 New Truck Accessories 0.00 11,587.43 10,000.00 7,991.46 10,000.00 5-21-5030-26 Vehicle Repair/Maint-Eng. 347.18 0.00 500.00 0.00 500.00 5-21-5034-00 Vehicle Tag Expense 1,019.16 27.50 120.00 49.50 120.00 5-21-5035-00 Vehicle Gasoline 17,611.20 22,038.82 30,000.00 27,833.26 30,000.00 5-21-5035-01 Equipment Fuel 4,946.39 9,654.82 8,000.00 26,663.58 23,000.00 5-21-5035-26 Vehicle Fuel-Engineer 0.00 0.00 1,750.00 0.00 1,750.00 5-21-5036-00 Drain Inlets/Headwalls 2,196.24 6,113.75 5,000.00 2,501.33 5,000.00 5-21-5037-00 Curb Work & Concrete 340.35 4,882.68 4,000.00 3,898.04 4,000.00 5-21-5040-00 Vehicle Tires/New 2,561.25 3,431.26 4,000.00 915.77 4,000.00 5-21-5040-01 Equipment Tires/New 1,689.70 6,213.86 4,000.00 8,006.75 5,000.00 5-21-5040-26 Vehicle Tires/New-Eng. 0.00 0.00 0.00 0.00 0.00 5-21-5041-00 Tire Repair 574.20 3,218.40 2,500.00 1,041.66 2,500.00 5-21-5041-26 Tire Repair-Eng. 0.00 0.00 15.00 0.00 15.00 5-21-5042-00 Uniforms & Accessories 4,404.03 6,064.19 4,000.00 3,977.66 4,000.00 5-21-5042-01 Personal Protective Equip 2,390.17 2,726.80 3,000.00 1,566.86 3,000.00 5-21-5042-26 Uniforms & Accessories 0.00 0.00 0.00 0.00 0.00 5-21-5045-00 Utilities & Telephones 13,7•90.13 21,348.08 14,800.00 20,322.07 14,800.00 5-21-5045-01 Security System 672.12 419.85 750.00 1,228.40 4,750.00 5-21-5045-26 Utilities & Telephones-Eng. 1,625.42 1,256.59 1,300..00 1,838.49 1,300.00 5-21-5046-00 United Way 0.00 0.00 0.00 0.00 0.00 5-21-5048-00 Cellular Telephones 2,889.12 2,438.22 3,000.00 2,227.81 3,000.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 4 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 20 -Street Fund Street Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-21-5048-26 Cellular Phone-Engineer 0.00 0.00 1,600.00 0.00 1,600.00 5-21-5050-00 Street Repairs & Maint. 125,084.74 330,008.24 385,000.00 200,987.66 460,000.00 5-21-5050-01 Snow Removal 26.37 4,172.80 5,000.00 7,753.31 5,000.00 5-21-5050-02 Streets-Rena Road 0.00 0.00 0.00 0.00 0.00 5-21-5050-03 Guard Rails 0.00 0.00 0.00 1,500.00 0.00 5-21-5050-04 Bridges 1,484.81 0.00 5,000.00 839.52 5,000.00 5-21-5050-05 Patching 11,164.96 14,073.51 15,000.00 8,371.25 15,000.00 5-21-5050-06 Railroad Crossing Maintenan 5,000.00 5,000.00 0.00 0.00 0.00 5-21-5051-00 Drainage Maint-Piping 22,642.66 38,935.70 30,000.00 41,809.60 30,000.00 5-21-5052-00 Tree Trim 1,450.00 2,475.00 4,500.00 11,235.00 4,500.00 5-21-5053-00 Sidewalk Maint. 788.01 5,229.04 8,000.00 2,519.30 8,000.00 5-21-5054-00 Street Lights 246,365.36 181,432.03 200,000.00 293,385.10 200,000.00 5-21-5054-01 Traffic Sign Maint. 4,941.16 11,109.13 11,000.00 9,585.33 11,000.00 5-21-5054-02 Traffic Signal Maint. 34,818.62 15,921.74 35,000.00 29,824.33 35,000.00 5-21-5054-03 School Beacons 7,414.63 2,557.09 4,500.00 32,747.78 4,500.00 5-21-5054-04 Street Light Repairs 178.36 1,900.80 2,500.00 1,278.80 2,500.00 5-21-5054-05 Street Markings 14,433.03 3,850.37 15,000.00 2,769.81 15,000.00 5-21-5055-00 Building Maintenance 2,703.71 1,080.47 3,500.00 832.92 3,500.00 5-21-5055-01 Street Maint. Fencing, etc.. 0.00 2,000.00 3,200.00 1,175.00 3,200.00 5-21-5057-00 Building Janitorial Service 0.00 0.00 0.00 0.00 0.00 5-21-5062-00 Office Supplies 1,370.13 587.13 1,200.00 319.64 1,200.00 5-21-5062-01 Shop Supplies & Comsumables 12,165.80 10,890.72 15,000.00 8,799.85 12,000.00 5-21-5062-02 Spray Chemical 14,432.67 10,479.13 12,000.00 10,933.49 12,000.00 5-21-5062-26 Office Supplies - Eng. 19.55 38.48 500.00 16.04 500.00 5-21-5063-00 Office Equipment-New 294.76 0.00 1,000.00 0.00 1,000.00 5-21-5063-26 Office Equip/New-Eng. 0.00 0.00 500.00 0.00 500.00 5-21-5070-00 Miscellaneous 3,580.18 9,802.33 10,000.00 3,020.17 5,000.00 5-21-5070-26 Misc. Engineer 0.00 0.00 0.00 0.00 0.00 5-21-5072-00 Tower Lease 0.00 0.00 0.00 0.00 0.00 5-21-5075-00 Vehicle Insurance 8,718.05 9,266.73 10,000.00 11,602.84 16,000.00 5-21-5075-26 Vehicle Insurance-Eng. 0.00 0.00 0.00 0.00 0.00 5-21-5085-60 ARPA Expense 0.00 0.00 0.00 66,000.00 500,000.00 5-21-5090-00 Dues & Subscriptions 948.75 900.00 500.00 200.00 500.00 5-21-5090-26 Dues/Subscriptions-Eng. 25.00 0.00 380.00 25.00 380.00 5-21-5095-00 School & Training 1,050.4E 541.09 2,000.00 515.00 2,000.00 5-21-5095-26 Schools & Training 1,488.47 25.90 7,500.00 2,061.20 3,000.00 5-21-5200-26 Contract Serv.(Map & Cad)En 0.00 8,197.31 7,500.00 5,098.51 10,000.00 5-21-5201-26 Outside Engineer Srvs. 2,185.00 1,135.00 15,000.00 0.00 0.00 5-21-6000-00 Travel & Convention 0.00 0.00 0.00 0.00 0.00 5-21-6000-26 Travel & Convention-Eng. 0.00 0.00 0.00 0.00 0.00 5-21-6010-00 Small Tools 3,219.42 2,995.96 3,500.00 4,666.35 3,500.00 5-21-6010-01 Equipment Rental 3,196.90 17,343.12 12,500.00 7,259.36 10,000.00 5-21-6010-02 Small Tools-Comsumables 435.73 2,044.79 2,500.00 1,585.81 2,500.00 5-21-6010-03 Small Tools Repair 383.60 764.67 500.00 15.27 300.00 5-21-6011-00 Equipment Repair/Maint.-Par 29,053.48 35,879.91 30,000.00 39,217.79 30,000.00 5-21-6011-01 Equip Repair/Maint-Contract 0.00 0.00 0.00 0.00 0.00 5-21-6025-00 Loan Payment 26,620.00 26,654.63 26,620.00 0.00 0.00 5-21-6195-00 Installation/Lights & Radio 0.00 0.00 500.00 0.00 500.00 5-21-7072-26 Equipment Lease 0.00 0.00 0.00 0.00 0.00 5-21-9010-00 Fixed Assets 18,475.81 166,497.56 120,000.00 25,572.80 120,000.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 5 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 20 -Street Fund Street Department DEPARTMENT EXPENDITURES (----------- 2022 -----------j 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-21-9010-26 Fixed Assets-Eng. 0.00 9,599.81 0.00 0.00 0.00 5-21-9020-00 Transfer Out 0.00 0.00 0.00 0.00 0.00 TOTAL Street Department 1,379,708.78 1,813,388.90 2,039,100.00 1,688,395.24 2,620,350.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 6 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 20 -Street Fund Street Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020, 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-22-5050-00 Street Repairs & Maint. 0.00 0.00 0.00 0.00 0.00 TOTAL Street Department 0.00 0.00 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 1,379,708.78 1,813,388.90 2,039,100.00 1,688,395.24 2,620,350.00 *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 30 -Payroll Fund FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 726.79 496.74 0.00 831.57 0.00 4651-4699 NOT USED 0.00 0.00 0.00 0.02 0.00 MISCELLANEOUS 1,644.96 1,189.64 0.00 1,716.15 0.00 ** TOTAL REVENUE ** 2,371.75 1,686.38 0.00 2,547.74 0.00 EXPENDITURE SUMMARY Transfers 83�.53 1,385.74 0.00 1,338.60 0.00 *** TOTAL EXPENDITURES *** 831.53 1,385.74 0.00 1,338.60 0.00 ** REVENUE OVER(UNDER) EXPENDITURES ** 1,540.22 300.64 0.00 1,209.14 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 30 -Payroll Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest 726.79 496.74 0.00 831.57 0.00 TOTAL INTEREST 726.79 496.74 0.00 831.57 0.00 4651-4699 NOT USED 4699 Cash Long/Short 0.00 0.00 0.00 _ 0.02 0.00 TOTAL 4651-4699 NOT USED 0.00 0.00 0.00 0.02 0.00 MISCELLANEOUS 4730 Misc 1,644.96 1,189.64 0.00 1,716.11 0.00 TOTAL MISCELLANEOUS 1,644.96 1,189.64 0.00 1,716.15 0.00 ** TOTAL REVENUE ** 2,371.75 1,686.38 0.00 2,547.74 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 30 -Payroll Fund Transfers DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-30-5070-00 Miscellaneous-Expense 0.00 1,216.59 0.00 776.19 0.00 5-30-9020-00 Transfer Out 831.53 169.15 0.00 562.41 0.00 TOTAL Transfers 831.53 1,385.74 0.00 1,338.60 0.00 *** TOTAL EXPENDITURES *** 831.53 1,385.74 0.00 1,338.60 0.00 *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 35 -City/Federal Forfeiture FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 128.81 12.45 0.00 12.89 0.00 GRANTS 4,335.00 0.00 0.00 0.00 0.00 TRANSFERS IN. 0.00 0.00 0.00 0.00 0.00 ** TOTAL REVENUE ** 4,463.81 12.45 0.00 12.89 0.00 EXPENDITURE SUMMARY Police Department 34,930.90 727.79 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 34,930.90 727.79 0.00 0.00 0.00 ** REVENUE OVER(UNDER) EXPENDITURES ** ( 30,467.09) ( 715.34) 0.00 12.89 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 35 -City/Federal Forfeiture REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y.-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest 128.81 12.45 0.00 12.89 0.00 TOTAL INTEREST 128.81 12.45 0.00 12.89 0.00 GRANTS 4407 Sign Rental lr500.00 0.00 0.00 0.00 0.00 4408 Forfieture Revenue 2.8'35.00 0.00 0.00 0.00 0.00 TOTAL GRANTS 4,335.00 0.00 0.00 0.00 0.00 TRANSFERS IN 4801 Transfer In 0.00 0.00 0.00 0.00 0.00 TOTAL TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 ** TOTAL REVENUE ** 4,463.81 12.45 0.00 12.89 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 35 -City/Federal Forfeiture Police Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-12-4040-35 Computer Service, Supply & 0.00 0.00 0.00 0.00 0.00 5-12-4040-91 Computer Services, Supp & E 0.00 0.00 0.00 0.00 0.00 5-12-5030-35 Vehicle Repair 0.00 0.00 0.00 0.00 0.00 5-12-5040-35 Vehicle Tires/New 0.00 0,00 0.00 0.00 0.00 5-12-5042-35 Uniforms and Accessories 704.00 0.00 0.00 0.00 0.00 5-12-5048-35 Cellular Telephones 0.00 0.00 0.00 0.00 0.00 5-12-5055-35 Building Maintenance 0.00 0.00 0.00 0.00 0.00 5-12-5062-35 Office Supplies 0.00 0.00 0.00 0.00 0.00 5-12-5063-35 Office Equipment-Purchase 0.00 0.00 0.00 0.00 0.00 5-12-5064-35 Office Equipment-Repairs 0.00 0.00 0.00 0.00 0.00 5-12-5070-35 Miscellaneous 34,226.90 727.79 0.00 0.00 0.00 5-12-5090-35 Dues and Subscriptions 0.00 0.00 0.00 0.00 0.00 5-12-5095-35 Schools and Training 0.00 0.00 0.00 0.00 0.00 5-12-5170-35 Firing Range 0.00 0.00 0.00 0.00 0.00 5-12-6000-35 Travel & Convention 0.00 0.00 0.00 0.00 0.00 5-12-6010-35 Police Equipment New 0.00 0.00 0.00 0.00 0.00 5-12-6010-91 Police Equip.-New-Fixed Ass 0.00 0.00 0.00 0.00 0.00 5-12-6035-35 Special Response Team 0.00 0.00 0.00 0.00 0.00 5-12-6036-00 Fed. Forfieture Expense 0.00 0.00 0.00 0.00 0.00 5-12-6038-35 NYPUM Grant 0.00 0.00 0.00 0.00 0.00 5-12-6039-35 New Police Dept Expenses, 0.00 0.00 0.00 0.00 0.00 5-12-9010-00 Fed. Forfeiture-Fixed Asset 0.00 0.00 0.00 0.00 0.00 5-12-9010-35 Fixed Assets 0.00 0.00 0.00 0.00 0.00 TOTAL Police Department 34,930.90 727.79 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 34,930.90 727.79 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 36 -State Forfeiture FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 74.33 58.17 0.00 66.36 0.00 GRANTS 2,075.00 0.00 0.00 245.00 0.00 ** TOTAL REVENUE ** 2,149.33 58.17 0.00 311.36 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- EXPENDITURE SUMMARY Police Department 0.00 1,576.66 0.00 531.82 0.00 *** TOTAL EXPENDITURES *** 0.00 1,576.66 0.00 531.82 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- ** REVENUE OVER(UNDER) EXPENDITURES ** 2,149.33 ( 1,518.49) 0.00 ( 220.46) 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 36 -State Forfeiture REVENUES (----------- 2022 ----------- 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest 74.33 58.17 0.00 66.36 0.00 TOTAL INTEREST 74.33 58.17 0.00 66.36 0.00 GRANTS 4408 State Forfeiture 2,075.00 0.00 0.00 245.00 0.00 TOTAL GRANTS 2,075.00 0.00 0.00 245.00 0.00 ** TOTAL REVENUE ** 2,149.33 58.17 0.00 311.36 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 36 -State Forfeiture Police Department DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-12-5042-36 Uniforms & Accessories 0.00 0.00 0.00 0.00 0.00 5-12-5048-36 Cell Phone 0.00 0.00 0.00 0.00 0.00 5-12-5055-36 Building Maintenance 0.00 0.00 0.00 0.00 0.00 5-12-5063-36 Office Equipment 0.00 0.00 0.00 0.00 0.00 5-12-5070-36 Miscellaneous 0.00 1,576.66 0.00 531.82 0.00 5-12-5090-00 Dues & Subscriptions 0.00 0.,00 0.00 0.00 0.00 5-12-5090-36 Dues & Subscriptions 0.00 0.00 0.00 0.00 0.00 5-12-6000-36 Travel & Convention 0.00 0.00 0.00 0.00 0.00 5-12-6010-36 Police Equipment-New 0.00 0.00 0.00 0.00 0.00 5-12-6039-36 New Expense Police 0.00 0.00 0.00 0.00 0.00 5-12-9010-36 Fixed Assests-PD 0.00 0.00 0.00 0.00 0.00 TOTAL Police Department 0.00 1,576.66 0.00 531.82 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** TOTAL EXPENDITURES *** 0.00 1,576.66 0.00 531.82 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 55 -Sidewalk Constr. Fund FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 505.39 425.18 0.00 746.41 0.00 MISCELLANEOUS 4,245.00 9,075.00 0.00 15,520.60 0.00 TRANSFERS IN 8,312.58 12,449.76 0.00 12,718.80 0.00 ** TOTAL REVENUE ** 13,062.97 21,949.94 0.00 28,985.81 0.00 EXPENDITURE SUMMARY Sidewalk 0.00 848.88 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 0.00 848.88 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- ** REVENUE OVER(UNDER) EXPENDITURES ** 13,062.97 21,101.06 0.00 28,985.81 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 55 -Sidewalk Constr. Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest Earned 505.39 425.18 0.00 746.41 0.00 TOTAL INTEREST 505.39 425.18 0.00 746.41 0.00 MISCELLANEOUS 4700 Misc-Sidewalk 4,245.00 9,075.00 0.00 15,520.60 0.00 TOTAL MISCELLANEOUS 4,245.00 9,075.00 0.00 15,520.60 0.00 TRANSFERS IN 4801 Transfer In 8,312.58 12,449.76 0.00 12,718.80 0.00 TOTAL TRANSFERS IN 8,312.58 12,449.76 0.00 12,718.80 0.00 ** TOTAL REVENUE ** 13,062.97 21,949.94 0.00 28,985.81 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 55 -Sidewalk Constr. Fund Sidewalk DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-50-5050-00 Contract Construction 0.00 0.00 0.00 0.00 0.00 5-50-5051-00 Sidewalk Constr./Inhouse Pr 0.00 0.00 0.00 0.00 0.00 5-50-5070-00 Misc. Sidewalk 0.00 848.88 0.00 0.00 0.00 TOTAL Sidewalk 0.00 848.88 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** TOTAL EXPENDITURES *** 0.00 848.88 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 60 -LOPFI FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY INTEREST 552.17 662.65 500.00 1,339.66 0.00 REVENUE 1,349,986.86 1,428,169.21 260,549.00 1,249,950.70 0.00 TRANSFERS IN 407.10 501.50 0.00 11,732.20 0.00 ** TOTAL REVENUE ** 1,350,946.13 1,429,333.36 261,049.00 1,263,022.56 0.00 EXPENDITURE SUMMARY LOPFI 1,342,904.66 1,568,405.44 133,487.00 871,703.00 0.00 *** TOTAL EXPENDITURES *** 1,342,904.66 1,568,405.44 133,487.00 871,703.00 0.00 ** REVENUE OVER(UNDER) EXPENDITURES ** 8,041.47 ( 139,072.08) 127,562.00 391,319.56 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 60 -LOPFI REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE INTEREST 4000 Interest 552.17 662.65 500.00 1,339.66 0.00 TOTAL INTEREST 5'52.17 662.65 500.00 1,339.66 0.00 REVENUE 4258 City Share Fire Dept 'Ret. 625,691.27 661,614.71 184,320.00 580,410.95 0.00 4259 City Share Police Dept Ret 462,131.19 496,060.98 0.00 433,739.92 0.00 4260 Empl Contr PD Ret 49,162.79 52,772.02 0.00 46,142.92 0.00 4261 Empl Contr FD Ret 213,001.61 217,721.50 76,229.00 1B9,656.91 0.00 4262 Turnback 0.00 0.00 0.00 0.00 0.00 TOTAL REVENUE 1,349,986.86 1,428,169.21 260,549.00 1,249,950.70 0.00 TRANSFERS IN 4801 Transfer In from General Fund 407.10 501.50 0.00 11,732.20 0.00 TOTAL TRANSFERS IN 407.10 501.50 0.00 11,732.20 0.00 ** TOTAL REVENUE ** 1,350,946.13 1,429,333.36 261,049.00 1,263,022.56 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 60 -LOPFI LOPFI DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-60-4035-00 LOPFI-Retirement 0.00 0.00 8,288.00 0.00 0.00 5-60-4060-00 LOPFI-Retirement-Fire Dept. 615,033.85 724,255.00 125,199.00 572,474.14 0.00 5-60-4061-00 LOPFI-Retirement-PD 316,780.98 394,150.44 0.00 299,228.86 0.00 5-60-9020-00 Transfer Out-LOPFI 411,089.83 450,000.00 0.00 0.00 0.00 TOTAL LOPFI 1,342,904.66 1,568,405.44 133,487.00 871,703.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** TOTAL EXPENDITURES *** 1,342,904.66 1,568,405.44 133,487.00 871,703.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 65 -ACEDP Grant 790-0837-05 FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY TAXES 0.00 0.00 0.00 0.00 0.00 ** TOTAL REVENUE ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- EXPENDITURE SUMMARY ACEDP Grant#790-0837-05 0.00 0.00 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 65 -ACEDP Grant 790-0837-05 REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE TAXES 4100 ACEDP Grant #790-0837-05 0.00 0.00 0.00 0.00 0.00 TOTAL TAXES 0.00 0.00 0.00 0.00 0.00 ** TOTAL REVENUE ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 65 -ACEDP Grant 790-0837-05 ACEDP Grant#790-0837-05 DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-65-5000-00 Experian Consumer Direct-Lo 0.00 0.00 0.00 0.00 0.00 5-65-5000-01 Experian #2 0.00 0.00 0.00 0.00 0.00 TOTAL ACEDP Grant#790-0837-05 0.00 0.00 0.00 0.00 0.00 *** TOTAL EXPENDITURES *** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 77 -VB Boys & Girls Club FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY GRANTS 0.00' 0.00 0.00 0.00 0.00 ** TOTAL REVENUE ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- EXPENDITURE SUMMARY VB Boys & Girls Club 0.00 0.00 0.00 0.00 0.00 *** TOTAL EXPENDITURES ***' 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 77 -VB Boys & Girls Club REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE GRANTS 4431 Federal Funds-Grant 0.00 0.00 0.00 0.00 0.00 TOTAL GRANTS 0.00 0.00 0.00 0.00 0.00 ** TOTAL REVENUE ** 0.00 0.00 0.00 0.00 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 77 -VB Boys & Girls Club VB Boys & Girls Club DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 F 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-77-7035-00 Contract Labor 0.00 0.00 0.00 0.00 0.00 TOTAL VB Boys & Girls Club 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** TOTAL EXPENDITURES *** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- -------------- *** END OF REPORT *** 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 85 -American Rescue Plan Fund FINANCIAL SUMMARY (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE REVENUE SUMMARY GRANTS 0.00 0.00 0.00 0.00 0.00 TRANSFERS IN 0.00 2,453,420.09 0.00 2,453,317.63 0.00 ** TOTAL REVENUE ** 0.00 2,453,420.09 0.00 2,453,317.63 0.00 EXPENDITURE SUMMARY American Rescue Plan .Fund 0.00 0.00 0.00 4,906,410.15 0.00 *** TOTAL EXPENDITURES *** 0.00 0.00 0.00 4,906,410.15 0.00 ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 2,453,420.09 0.00 ( 2,453,092.52) 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 85 -American Rescue Plan Fund REVENUES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE GRANTS 4431 Federal Funds 0.00 0.00 0.00 0.00 0.00 TOTAL GRANTS 0.00 0.00 0.00 0.00 0.00 TRENSFERS IN 4801 Transfer In 0.00 2,453,420.09 0.00 2,453,317.63 0.00 TOTAL TRANSFERS IN 0.00 2,453,420.09 0.00 2,453,317.63 0.00 ** TOTAL REVENUE ** 0.00 2,453,420.09 0.00 2,453,317.63 0.00 12-19-2022 02:10 PM C I T Y O F V A N B U R E N PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 30TH, 2022 85 -American Rescue Plan Fund American Rescue Plan Fund DEPARTMENT EXPENDITURES (----------- 2022 -----------) 2023 2020 2021 CURRENT Y-T-D PROPOSED BUDGET ACTUAL ACTUAL BUDGET ACTUAL BUDGET WORKSPACE 5-85-4010-00 Personnel Bonuses 0.00 0.00 0.00 0.00 0.00 5-85-5062-00 Supplies 0.00 0.00 0.00 0.00 0.00 5-85-7035-00 Construction Contractors 0.00 0.00 0.00 0.00 0.00 5-85-9020-00 Transfer Out 0.00 0.00 0.00 4,906,410.15 0.00 TOTAL American Rescue Plan Fund 0.00 0.00 0.00 4,906,410.15 0.00 *** TOTAL EXPENDITURES *** 0.00 0.00 0.00 4,906,410.,15 0.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT *** ** REVENUE OVER(UNDER) EXPENDITURES ** 0.00 0.00 0.00 0.00 0.00 *** END OF REPORT ***