WS - F - Budget Worksheet - EXPENSES

Budget Worksheet For Fiscal: 2024-2025 Period Ending: 02/28/2025 Defined Budgets 2022-2023 2022-2023 2023-2024 2023-2024 2024-2025 2024-2025 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 110-240-6417 TRAFFIC SIGNALS MAINTENAN… 0.00 0.00 0.00 0.00 5,000.00 0.00 Expense Total: 532,526.00 492,835.22 695,082.00 624,364.14 713,130.00 0.00 Fund: 110 - Road Use Tax Total: 532,526.00 492,835.22 695,082.00 624,364.14 713,130.00 0.00 Fund: 112 - Employee Benefit Expense 112-150-6110 FICA 2,678.00 7,194.65 10,079.00 8,817.76 11,475.00 0.00 112-150-6130 IPERS - FIRE 3,304.00 4,333.32 7,069.00 9,208.65 14,160.00 0.00 112-150-6150 GROUP INSURANCE - FIRE 0.00 6.93 11,966.00 3,421.30 11,044.00 0.00 112-170-6110 FICA 18,454.00 14,130.78 20,241.00 11,658.71 23,442.00 0.00 112-170-6130 IPERS - BUILDING 22,774.00 17,633.85 24,977.00 15,765.28 28,927.00 0.00 112-170-6150 GROUP INSURANCE - BUILDING 35,902.00 22,848.33 42,697.00 20,625.06 38,654.00 0.00 112-210-6110 FICA 15,323.00 15,910.52 15,573.00 10,328.31 20,194.00 0.00 112-210-6130 IPERS - STREETS 18,907.00 18,209.91 19,216.00 14,556.57 24,917.00 0.00 112-210-6150 GROUP INSURANCE - STREETS 39,765.00 31,746.27 35,080.00 26,890.20 52,459.00 0.00 112-410-6110 FICA - LIBRARY 0.00 0.00 0.00 0.00 4,208.00 0.00 112-410-6130 IPERS - LIBRARY 0.00 0.00 0.00 0.00 5,192.00 0.00 112-410-6150 GROUP INSURANCE - LIBRARY 0.00 0.00 0.00 0.00 5,522.00 0.00 112-430-6110 FICA 13,839.00 16,209.44 14,146.00 11,163.94 18,569.00 0.00 112-430-6130 IPERS - PARKS 17,077.00 14,995.60 17,458.00 12,449.48 22,912.00 0.00 112-430-6150 GROUP INSURANCE - PARKS 40,886.00 8,800.55 36,777.00 6,925.30 11,044.00 0.00 112-540-6110 FICA 161.00 48.96 161.00 47.43 161.00 0.00 112-610-6110 FICA 5,444.00 5,368.32 5,774.00 3,710.04 9,754.00 0.00 112-610-6130 IPERS - ADMIN/COUNCIL 5,443.00 5,453.36 5,851.00 3,626.69 10,762.00 0.00 112-610-6150 GROUP INSURANCE - CITY ADM… 9,356.00 11,983.11 10,267.00 10,799.65 22,088.00 0.00 112-620-6110 FICA 5,431.00 5,196.34 5,788.00 3,463.38 6,308.00 0.00 112-620-6130 IPERS - CLERK/TREASURER 6,702.00 6,724.04 7,143.00 5,164.88 7,783.00 0.00 112-620-6150 GROUP INSURANCE - CLERK 16,235.00 8,735.56 19,731.00 7,603.21 13,805.00 0.00 112-910-6910 TRANSFER OUT - EMPLOYEE B… 54,497.00 0.00 0.00 0.00 0.00 0.00 Expense Total: 332,178.00 215,529.84 309,994.00 186,225.84 363,380.00 0.00 Fund: 112 - Employee Benefit Total: 332,178.00 215,529.84 309,994.00 186,225.84 363,380.00 0.00 2/5/2024 3:12:44 PM Page 8 of 18