Page 59 - Report

Budget Worksheet Condensed For Fiscal: 2022-2023 Period Ending: 08/31/2023

2020-2021 2021-2022 2022-2023 2022-2023 2023-2024
Total Activity Total Activity Total Budget YTD Activity 2023-2024

2023-2024 W2 tax forms 1.00 100.00 100.00

100-300-6511-00 Dental Insurance - City Pay 149.30 0.00 0.00 0.00 0.00

100-300-6514-00 Life, STD, LTD - City Paid 208.54 0.00 1,260.00 0.00 0.00

100-300-6515-00 Medical Insurance - City Paid 8,133.10 8,547.19 18,899.40 8,495.39 16,074.00

Budget Detail
Budget Code Description Units Price Amount
2023-2024 CIty paid portion of EE medical ins (2.5 EEs) 1,211.50 12.00 14,538.00
2023-2024 Teledoc (per employee/mo) 12.00 128.00 1,536.00

100-300-6516-00 Tx Municipal Retirement System 3,067.90 5,064.21 8,629.89 7,191.95 11,186.00

Budget Detail
Budget Code Description Units Price Amount
2023-2024 3 staff, 30% 1 staff 1.00 11,000.00 11,000.00
2023-2024 Overtime 1.00 32.00 32.00
2023-2024 Vehicle allowance 1.00 154.00 154.00

100-300-6518-00 AFLAC Insurance 43.80 0.00 0.00 0.00 0.00

100-300-6560-00 Payroll Taxes 8,664.99 8,403.87 11,285.87 10,675.77 13,423.00

8/4/2023 11:06:01 AM Page 21 of 116
9/18 FY 2024 Adopted Budget