M-3 - FY 2023-2024 - Expense

Budget Worksheet <table> <tr> <th>Budget Notes</th> <th>Budget Code</th> <th>Subject</th> <th>Description</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> <td rowspan="2">600-810-6710</td> <td rowspan="2">2023-2024</td> <td>CAP OUTLAY</td> <td>MASTER METER FIXED BASE, TRUCK</td> <td>22,000.00</td> <td>20,620.42</td> <td>0.00</td> <td>0.00</td> <td>40,000.00</td> <td>0.00</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td rowspan="2">600-810-6780</td> <td rowspan="2"></td> <td>WATER METERS</td> <td>MASTER METER FIXED BASE, TRUCK</td> <td>90,000.00</td> <td>126,678.49</td> <td>100,000.00</td> <td>65,774.07</td> <td>175,000.00</td> <td>0.00</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td rowspan="2">600-910-6910</td> <td rowspan="2"></td> <td>TRANSFER OUT-WATER</td> <td></td> <td>22,880.00</td> <td>25,168.00</td> <td>22,440.00</td> <td>12,342.00</td> <td>113,400.00</td> <td>0.00</td> </tr> <tr> <td>Expense Total:</td> <td></td> <td>866,159.00</td> <td>956,969.78</td> <td>766,864.00</td> <td>516,034.32</td> <td>1,091,143.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 600 - Water Total:</td> <td></td> <td></td> <td>866,159.00</td> <td>956,969.78</td> <td>766,864.00</td> <td>516,034.32</td> <td>1,091,143.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 601 - Water Sinking Expense</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>601-810-6801</td> <td></td> <td>PRINCIPAL - 2004 REV BONDS</td> <td></td> <td>22,000.00</td> <td>22,000.00</td> <td>22,000.00</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> </tr> <tr> <td>601-810-6851</td> <td></td> <td>INTEREST - 2004 REV BONDS</td> <td></td> <td>770.00</td> <td>770.00</td> <td>385.00</td> <td>192.50</td> <td>0.00</td> <td>0.00</td> </tr> <tr> <td>601-810-6899</td> <td></td> <td>BOND REGISTRATION FEES</td> <td></td> <td>110.00</td> <td>110.00</td> <td>55.00</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> </tr> <tr> <td>Expense Total:</td> <td></td> <td></td> <td></td> <td>22,880.00</td> <td>22,880.00</td> <td>22,440.00</td> <td>192.50</td> <td>0.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 601 - Water Sinking Total:</td> <td></td> <td></td> <td>22,880.00</td> <td>22,880.00</td> <td>22,440.00</td> <td>192.50</td> <td>0.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 607 - Second Well Expense</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>607-810-6407</td> <td></td> <td>ENGINEERING- THIRD WELL</td> <td></td> <td>50,000.00</td> <td>37,936.63</td> <td>8,000.00</td> <td>7,484.00</td> <td>15,000.00</td> <td>0.00</td> </tr> <tr> <td>607-810-6499</td> <td></td> <td>CONTRACTUAL- THIRD WELL</td> <td></td> <td>156,964.00</td> <td>131,812.95</td> <td>50,000.00</td> <td>182,757.10</td> <td>25,000.00</td> <td>0.00</td> </tr> <tr> <td>Expense Total:</td> <td></td> <td></td> <td></td> <td>206,964.00</td> <td>169,749.58</td> <td>58,000.00</td> <td>190,241.10</td> <td>40,000.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 607 - Second Well Total:</td> <td></td> <td></td> <td>206,964.00</td> <td>169,749.58</td> <td>58,000.00</td> <td>190,241.10</td> <td>40,000.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 608 - WATER TREATMENT PLANT Expense</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>608-810-6407</td> <td></td> <td>ENGINEERING - WATER TREAT</td> <td></td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>400,000.00</td> <td>0.00</td> </tr> <tr> <td>Expense Total:</td> <td></td> <td></td> <td></td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>400,000.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 608 - WATER TREATMENT PLANT Total:</td> <td></td> <td></td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>0.00</td> <td>400,000.00</td> <td>0.00</td> </tr> <tr> <td colspan="2">Fund: 610 - Sewer Expense</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>610-815-6010</td> <td></td> <td>WAGES - FULL TIME - SEWER</td> <td></td> <td>156,026.00</td> <td>171,854.22</td> <td>176,780.00</td> <td>101,165.22</td> <td>204,436.00</td> <td>0.00</td> </tr> <tr> <td>610-815-6110</td> <td></td> <td>FICA - SEWER</td> <td></td> <td>11,936.00</td> <td>5,854.00</td> <td>12,602.00</td> <td>7,565.13</td> <td>15,639.00</td> <td>0.00</td> </tr> <tr> <td>610-815-6130</td> <td></td> <td>IPERS - SEWER</td> <td></td> <td>14,727.00</td> <td>7,362.92</td> <td>16,734.00</td> <td>9,533.91</td> <td>19,298.00</td> <td>0.00</td> </tr> <tr> <td>610-815-6150</td> <td></td> <td>GROUP INSURANCE - SEWER</td> <td></td> <td>29,244.00</td> <td>35,854.58</td> <td>30,775.00</td> <td>22,180.75</td> <td>35,936.00</td> <td>0.00</td> </tr> <tr> <td>610-815-6160</td> <td></td> <td>INSURANCE-WORKERS COMP</td> <td></td> <td>3,200.00</td> <td>6,573.00</td> <td>3,680.00</td> <td>2,727.25</td> <td>7,230.00</td> <td>0.00</td> </tr> </table> Additional employee - 1/2 wages