M-3 - FY 2023-2024 - Expense

Budget Worksheet <table> <tr> <th></th> <th>2021-2022 Total Budget</th> <th>2021-2022 Total Activity</th> <th>2022-2023 Total Budget</th> <th>2022-2023 Total Activity</th> <th>2023-2024 Total Budget</th> <th>2023-2024 YTD Activity</th> </tr> <tr> <th colspan="7">Fund: 110 - Road Use Tax Expense</th> </tr> <tr> <td>110-210-6010 WAGES - FULL TIME - RUT STRE</td> <td>153,263.00</td> <td>169,736.14</td> <td>200,276.00</td> <td>125,616.66</td> <td>203,564.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6020 WAGES - PART TIME - RUT STRE</td> <td>30,000.00</td> <td>16,174.12</td> <td>5,250.00</td> <td>15,277.46</td> <td>10,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6181 UNIFORM ALLOWANCE - RUT S</td> <td>2,500.00</td> <td>1,802.11</td> <td>2,500.00</td> <td>1,740.34</td> <td>2,500.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6310 BUILDING REPAIR/MAINT - RUT</td> <td>1,000.00</td> <td>1,818.66</td> <td>2,000.00</td> <td>1,057.11</td> <td>2,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6331 VEHICLE OPERATIONS - RUT STR</td> <td>10,000.00</td> <td>10,341.60</td> <td>10,000.00</td> <td>5,050.09</td> <td>10,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6332 VEHICLE REPAIRS - RUT STREET</td> <td>27,000.00</td> <td>29,414.96</td> <td>15,000.00</td> <td>24,693.50</td> <td>15,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6350 OPER EQUIP REPAIR - RUT STRE</td> <td>1,000.00</td> <td>663.36</td> <td>1,000.00</td> <td>47.92</td> <td>1,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6371 UTILITIES - RUT STREETS</td> <td>16,000.00</td> <td>13,761.28</td> <td>15,000.00</td> <td>3,480.36</td> <td>10,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6373 TELEPHONE/COMMUNICATION</td> <td>2,000.00</td> <td>1,971.38</td> <td>2,000.00</td> <td>1,470.26</td> <td>3,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6417 STREET MAINTENANCE - RUT</td> <td>70,000.00</td> <td>66,122.45</td> <td>25,000.00</td> <td>14,409.79</td> <td>30,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6499 OTHER CONTRACTUAL SERV</td> <td>0.00</td> <td>0.00</td> <td>8,000.00</td> <td>0.00</td> <td>8,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6501 CHEMICALS - RUT STREETS</td> <td>50,000.00</td> <td>41,340.00</td> <td>50,000.00</td> <td>47,526.08</td> <td>60,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6504 MINOR EQUIPMENT - RUT STR</td> <td>0.00</td> <td>3,159.95</td> <td>3,500.00</td> <td>2,932.85</td> <td>4,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6505 OTHER EQUIPMENT - RUT STRE</td> <td>207,750.00</td> <td>221,744.20</td> <td>0.00</td> <td>115.06</td> <td>218,518.00</td> <td>0.00</td> <td><i>Equipment replacement</i></td> </tr> <tr> <td>110-210-6506 OFFICE SUPPLIES - RUT STREET</td> <td>0.00</td> <td>40.68</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6507 OPERATING SUPPLIES - RUT STR</td> <td>7,500.00</td> <td>8,323.30</td> <td>17,500.00</td> <td>3,552.26</td> <td>10,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6509 POSTS/SIGNS - RUT STREETS</td> <td>10,000.00</td> <td>5,492.05</td> <td>7,500.00</td> <td>16,371.89</td> <td>15,000.00</td> <td>0.00</td> <td><i>Radar speed signs</i></td> </tr> <tr> <td>110-210-6512 VEHICLE/EQUIPMENT FUEL</td> <td>7,000.00</td> <td>10,661.40</td> <td>7,500.00</td> <td>9,375.90</td> <td>15,000.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6519 OPERATING EQUIPMENT-STREE</td> <td>1,500.00</td> <td>498.99</td> <td>1,500.00</td> <td>0.00</td> <td>1,500.00</td> <td>0.00</td> </tr> <tr> <td>110-210-6599 OTHER SUPPLIES-RUT STREETS</td> <td>2,000.00</td> <td>3,173.03</td> <td>1,500.00</td> <td>218.94</td> <td>1,500.00</td> <td>0.00</td> </tr> <tr> <td>110-230-6371 STREET LIGHTS - UTILITY</td> <td>60,000.00</td> <td>66,092.84</td> <td>65,000.00</td> <td>32,933.98</td> <td>67,000.00</td> <td>0.00</td> </tr> <tr> <td>110-240-6371 UTILITIES-TRAFFIC SIGNALS</td> <td>2,000.00</td> <td>2,135.17</td> <td>2,000.00</td> <td>1,307.10</td> <td>2,500.00</td> <td>0.00</td> </tr> <tr> <td>Expense Total:</td> <td>660,513.00</td> <td>674,467.67</td> <td>442,026.00</td> <td>307,177.55</td> <td>690,082.00</td> <td>0.00</td> </tr> <tr> <td>Fund: 110 - Road Use Tax Total:</td> <td>660,513.00</td> <td>674,467.67</td> <td>442,026.00</td> <td>307,177.55</td> <td>690,082.00</td> <td>0.00</td> </tr> </table> <table> <tr> <th></th> <th>2021-2022 Total Budget</th> <th>2021-2022 Total Activity</th> <th>2022-2023 Total Budget</th> <th>2022-2023 Total Activity</th> <th>2023-2024 Total Budget</th> <th>2023-2024 YTD Activity</th> </tr> <tr> <th colspan="7">Fund: 112 - Employee Benefit Expense</th> </tr> <tr> <td>112-150-6110 FICA</td> <td>0.00</td> <td>1,819.05</td> <td>2,678.00</td> <td>4,391.67</td> <td>10,079.00</td> <td>0.00</td> </tr> <tr> <td>112-150-6130 IPERS</td> <td>0.00</td> <td>53.84</td> <td>3,304.00</td> <td>1,950.93</td> <td>7,069.00</td> <td>0.00</td> </tr> <tr> <td>112-150-6150 GROUP INSURANCE - FIRE</td> <td>0.00</td> <td>5.48</td> <td>0.00</td> <td>5.88</td> <td>11,966.00</td> <td>0.00</td> </tr> <tr> <td>112-170-6110 FICA</td> <td>12,981.00</td> <td>8,935.96</td> <td>18,454.00</td> <td>7,563.96</td> <td>20,241.00</td> <td>0.00</td> </tr> </table>