Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2024 Sewer Budgets
City of Scandia 2024 Proposed Budget 1-Oct 2020 2021 2022 3-Yr Avg 2023 Budget 2023 BUDGET 2023 2023 Budget 2024 Actual Actual Actual Actual Proposed AMENDED YTD Actual Projected Budget BIG MARINE SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal -$ 2,887$ 962$ 2,065.94$ 602-43210-31952 SA Penalties & Interest 3,575$ 624$ 579$ 1,593$ 600$ 257.92$ 600$ 602-43210-33422 Other State Grants & Aids 47,163$ 25$ 74$ 15,754$ 602-43210-34401 Sewer User Fees 74,387$ 98,531$ 106,717$ 93,212$ 140,700$ 72,340.60$ 172,775$ 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ 8,000.00$ -$ 602-43210-36100 Special Assessments -$ -$ 602.43210.36102 Penalties and I 68.03$ 602-43210-36210 Interest Income -$ 181$ 301$ 161$ 400$ 300$ 602-43210-36250 Misc. Refund 550$ 183$ 602-43210-39200 Interfund Tranfers In -$ -$ Total Big Marine Sewer Fund Revenues 125,676$ 107,361$ 118,557$ 117,198$ 141,700$ -$ 82,732.49$ 173,675$ Expenditures BIG MARINE SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 18,626$ 11,014$ 21,714$ 17,118$ 22,500$ 15,321.76$ 23,303$ 602-43210-102 OT Regular Wages 106$ 35$ -$ 602-43210-120 Pension Expense -$ (1,438)$ (693)$ (710)$ -$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,404$ 806$ 1,629$ 1,280$ 1,700$ 1,146.93$ 1,748$ 602-43210-122 FICA Employer Contribution 1,090$ 684$ 1,284$ 1,019$ 1,400$ 892.98$ 1,445$ 602-43210-126 MEDICARE Employer Contribution 260$ 156$ 299$ 238$ 300$ 223.34$ 340$ 602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 602-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 602-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 602-43210-151 Worker s Comp Insurance Prem 854$ 422$ 1,215$ 830$ 700$ 736.40$ 750$ 602-43210-200 Office Supplies -$ 109$ 128$ 79$ 200$ -$ 130$ 602-43210-210 Operating Supplies 752$ 558$ 680$ 664$ 2,500$ 1,485.64$ 1,000$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 113$ -$ 217$ 110$ 600$ -$ 600$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 12,082$ 13,277$ (1,538)$ 7,940$ 10,500$ 61,200.25$ 11,025$ 5% increase 602-43210-304 Legal Services -$ -$ 6,000$ 2,000$ 18.00$ -$ 602-43210-308 Other Professional Services 2,651$ 3,376$ 5,814$ 3,947$ 2,500$ 4,798.00$ 5,000$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 716$ 716$ 756$ 729$ 1,300$ -$ 1,300$ SCADA 602-43210-317 Employee Training 508$ 868$ 925$ 767$ 1,400$ -$ 1,400$ Wastewater training 602-43210-321 Telephone 2,061$ 2,413$ 1,751$ 2,075$ 2,400$ 2,016.55$ 2,500$ SCADA dialers 602-43210-322 Postage 247$ -$ 200$ 149$ 600$ -$ 600$ 602-43210-331 Travel Expenses -$ 8$ 158$ 55$ 200$ 632.55$ 750$ 602-43210-334 Licenses & Permits 754$ 1,180$ 824$ 919$ 1,600$ 729.00$ 2,000$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,052$ 1,039$ 1,003$ 1,031$ 3,000$ 3,449.06$ 3,622$ 5% increase 602-43210-381 Utilities-Electric & Gas 1,620$ 1,862$ 3,473$ 2,318$ 2,500$ (4,268.96)$ 5,000$ 3,000$ 602-43210-385 Sewer Pumping & Maintenance 10,000$ 5,364$ 11,410$ 8,925$ 15,000$ 3,770.22$ 20,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,627$ 1,574$ 2,888$ 2,363$ 5,000$ 2,139.00$ 5,000$ 602-43210-404 Repair Machinery/Equipment 16,180$ 4,375$ 5,857$ 8,804$ 16,000$ 12,100.90$ 16,000$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ -$ -$ -$ 400$ 1,000$ 602-43210-420 Depreciation Expense -$ 48,667$ 50,174$ 32,947$ 54,300$ 58,000$ approximate 602-43210-438 Misc. Contractual 7,410$ 3,775$ 2,550$ 4,578$ 10,000$ 280.00$ 10,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 103,000$ 3,278$ 35,426$ 9,800$ 9,900$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ Total Big Marine Sewer Fund Expenditures 184,113$ 100,803$ 121,995$ 135,637$ 166,400$ -$ 106,671.62$ 180,412$ Revenues / Expenses (58,437.79)$ 6,558.70$ (3,437.59)$ (18,438.90)$ (24,700.00)$ -$ (23,939.13)$ -$ (6,737.44)$ UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 12$ -$ 612-43210-34401 Sewer User Fees 6,460$ 15,132$ 17,442$ 13,012$ 22,300$ 10,408.64$ 27,873.00$ 25% increase over 2023 612-43210-34402 Sewer Connection Fee -$ -$ 612-43210-36210 Interest Income 64$ 55$ 40$ 200$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ Total Uptown Sewer Fund Revenues 6,460$ 15,203$ 17,526$ 13,063$ 22,500$ -$ 10,408.64$ 27,923.00$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,020$ 3,673$ 9,282$ 5,991$ 9,700$ 6,442.64$ 10,037$ 612-43210-102 OT Regular Wages -$ -$ -$ -$ 612-43210-120 Pension Expense -$ (630)$ 1,164$ 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 377$ 259$ 697$ 444$ 700$ 482.40$ 753$ 612-43210-122 FICA Employer Contribution 290$ 219$ 550$ 353$ 600$ 375.33$ 622$ 612-43210-126 MEDICARE Employer Contribution 70$ 50$ 126$ 82$ 100$ 97.79$ 146$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 95$ 218$ 304$ 205$ 200$ 315.60$ 300$ 612-43210-200 Office Supplies -$ 4$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ -$ 500$ 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 139$ -$ -$ 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 600$ 7,272$ -$ 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 519$ 192$ 884$ 531$ 500$ 733.00$ 1,400$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 80$ 84$ 81$ -$ 84$ 612-43210-317 Employee Training 114$ 275$ -$ 130$ -$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ -$ 1,500$ 612-43210-322 Postage -$ 18$ -$ 6$ -$ 612-43210-334 Licenses & Permits 259$ 209$ 217$ 228$ 224.00$ 300$ 612-43210-361 Liability/Property Ins 320$ 283$ 334$ 312$ 400$ 477.82$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 482$ 522$ 697$ 567$ 1,700$ 579.08$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance -$ (260)$ 327$ 22$ 1,500$ 1,500.00$ 1,500$ 612-43210-386 Operation & Maintenance -$ -$ 462$ 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment -$ 767$ 465$ 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense -$ 4,876$ 4,877$ 3,251$ 5,100$ -$ 4,900$ 612-43210-438 Misc. Contractual -$ 100$ 548$ 216$ 1,300$ 140.00$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs -$ 1,456$ -$ 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ 2,640$ Reimbursement to 401 for 2013 loan Total Uptown Sewer Fund Expenditures 8,363$ 19,582$ 21,516$ 16,487$ 30,700$ -$ 11,367.66$ 42,284$ Revenues / Expenses (1,903.21)$ (4,379.01)$ (3,990.23)$ (3,424.15)$ (8,200.00)$ -$ (959.02)$ -$ (14,360.69)$ City of Scandia 2024 Proposed Budget 75% Depreciation 1-Oct 2020 2021 2022 3-Yr Avg 2023 Budget 2023 BUDGET 2023 2023 Budget 2024 Actual Actual Actual Actual Proposed AMENDED YTD Actual Projected Budget BIG MARINE SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal -$ 2,887$ 962$ 2,065.94$ -$ 602-43210-31952 SA Penalties & Interest 3,575$ 624$ 579$ 1,593$ 600$ 257.92$ 600$ 602-43210-33422 Other State Grants & Aids 47,163$ 25$ 74$ 15,754$ -$ 602-43210-34401 Sewer User Fees 74,387$ 98,531$ 106,717$ 93,212$ 140,700$ 72,340.60$ 172,775$ 25% increase over 2023 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ 8,000.00$ -$ 602-43210-36100 Special Assessments -$ -$ -$ 602.43210.36102 Penalties and I 68.03$ -$ 602-43210-36210 Interest Income -$ 181$ 301$ 161$ 400$ 300$ 602-43210-36250 Misc. Refund 550$ 183$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ Total Big Marine Sewer Fund Revenues 125,676$ 107,361$ 118,557$ 117,198$ 141,700$ -$ 82,732.49$ 173,675$ Expenditures BIG MARINE SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 18,626$ 11,014$ 21,714$ 17,118$ 22,500$ 15,321.76$ 23,303$ 602-43210-102 OT Regular Wages 106$ 35$ -$ 602-43210-120 Pension Expense -$ (1,438)$ (693)$ (710)$ -$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,404$ 806$ 1,629$ 1,280$ 1,700$ 1,146.93$ 1,748$ 602-43210-122 FICA Employer Contribution 1,090$ 684$ 1,284$ 1,019$ 1,400$ 892.98$ 1,445$ 602-43210-126 MEDICARE Employer Contribution 260$ 156$ 299$ 238$ 300$ 223.34$ 340$ 602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 602-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 602-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 602-43210-151 Worker s Comp Insurance Prem 854$ 422$ 1,215$ 830$ 700$ 736.40$ 750$ 602-43210-200 Office Supplies -$ 109$ 128$ 79$ 200$ -$ 130$ 602-43210-210 Operating Supplies 752$ 558$ 680$ 664$ 2,500$ 1,485.64$ 1,000$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 113$ -$ 217$ 110$ 600$ -$ 600$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 12,082$ 13,277$ (1,538)$ 7,940$ 10,500$ 61,200.25$ 11,025$ 5% increase 602-43210-304 Legal Services -$ -$ 6,000$ 2,000$ 18.00$ -$ 602-43210-308 Other Professional Services 2,651$ 3,376$ 5,814$ 3,947$ 2,500$ 4,798.00$ 5,000$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 716$ 716$ 756$ 729$ 1,300$ -$ 1,300$ SCADA 602-43210-317 Employee Training 508$ 868$ 925$ 767$ 1,400$ -$ 1,400$ Wastewater training 602-43210-321 Telephone 2,061$ 2,413$ 1,751$ 2,075$ 2,400$ 2,016.55$ 2,500$ SCADA dialers 602-43210-322 Postage 247$ -$ 200$ 149$ 600$ -$ 600$ 602-43210-331 Travel Expenses -$ 8$ 158$ 55$ 200$ 632.55$ 750$ 602-43210-334 Licenses & Permits 754$ 1,180$ 824$ 919$ 1,600$ 729.00$ 2,000$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,052$ 1,039$ 1,003$ 1,031$ 3,000$ 3,449.06$ 3,622$ 5% increase 602-43210-381 Utilities-Electric & Gas 1,620$ 1,862$ 3,473$ 2,318$ 2,500$ (4,268.96)$ 5,000$ 3,000$ 602-43210-385 Sewer Pumping & Maintenance 10,000$ 5,364$ 11,410$ 8,925$ 15,000$ 3,770.22$ 20,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,627$ 1,574$ 2,888$ 2,363$ 5,000$ 2,139.00$ 5,000$ 602-43210-404 Repair Machinery/Equipment 16,180$ 4,375$ 5,857$ 8,804$ 16,000$ 12,100.90$ 16,000$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ -$ -$ -$ 400$ 1,000$ 602-43210-420 Depreciation Expense -$ 48,667$ 50,174$ 32,947$ 54,300$ 43,500$ approximate 602-43210-438 Misc. Contractual 7,410$ 3,775$ 2,550$ 4,578$ 10,000$ 280.00$ 10,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 103,000$ 3,278$ 35,426$ 9,800$ 9,900$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ -$ Total Big Marine Sewer Fund Expenditures 184,113$ 100,803$ 121,995$ 135,637$ 166,400$ -$ 106,671.62$ 165,912$ Revenues / Expenses (58,437.79)$ 6,558.70$ (3,437.59)$ (18,438.90)$ (24,700.00)$ -$ (23,939.13)$ -$ 7,762.56$ UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 12$ -$ 612-43210-34401 Sewer User Fees 6,460$ 15,132$ 17,442$ 13,012$ 22,300$ 10,408.64$ 27,873.00$ 25% increase over 2023 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 40$ 200$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 6,460$ 15,203$ 17,526$ 13,063$ 22,500$ -$ 10,408.64$ 27,923.00$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,020$ 3,673$ 9,282$ 5,991$ 9,700$ 6,442.64$ 10,037$ 612-43210-102 OT Regular Wages -$ -$ -$ -$ 612-43210-120 Pension Expense -$ (630)$ 1,164$ 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 377$ 259$ 697$ 444$ 700$ 482.40$ 753$ 612-43210-122 FICA Employer Contribution 290$ 219$ 550$ 353$ 600$ 375.33$ 622$ 612-43210-126 MEDICARE Employer Contribution 70$ 50$ 126$ 82$ 100$ 97.79$ 146$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 95$ 218$ 304$ 205$ 200$ 315.60$ 300$ 612-43210-200 Office Supplies -$ 4$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ -$ 500$ 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 139$ -$ -$ 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 600$ 7,272$ -$ 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 519$ 192$ 884$ 531$ 500$ 733.00$ 1,400$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 80$ 84$ 81$ -$ 84$ 612-43210-317 Employee Training 114$ 275$ -$ 130$ -$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ -$ 1,500$ 612-43210-322 Postage -$ 18$ -$ 6$ -$ -$ 612-43210-334 Licenses & Permits 259$ 209$ 217$ 228$ 224.00$ 300$ 612-43210-361 Liability/Property Ins 320$ 283$ 334$ 312$ 400$ 477.82$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 482$ 522$ 697$ 567$ 1,700$ 579.08$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance -$ (260)$ 327$ 22$ 1,500$ 1,500.00$ 1,500$ 612-43210-386 Operation & Maintenance -$ -$ 462$ 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment -$ 767$ 465$ 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense -$ 4,876$ 4,877$ 3,251$ 5,100$ -$ 3,675$ 612-43210-438 Misc. Contractual -$ 100$ 548$ 216$ 1,300$ 140.00$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs -$ 1,456$ -$ 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ 2,640$ Reimbursement to 401 for 2013 loan Total Uptown Sewer Fund Expenditures 8,363$ 19,582$ 21,516$ 16,487$ 30,700$ -$ 11,367.66$ 41,059$ Revenues / Expenses (1,903.21)$ (4,379.01)$ (3,990.23)$ (3,424.15)$ (8,200.00)$ -$ (959.02)$ -$ (13,135.69)$ City of Scandia 2024 Proposed Budget 50% Depreciation 1-Oct 2020 2021 2022 3-Yr Avg 2023 Budget 2023 BUDGET 2023 2023 Budget 2024 Actual Actual Actual Actual Proposed AMENDED YTD Actual Projected Budget BIG MARINE SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal -$ 2,887$ 962$ 2,065.94$ -$ 602-43210-31952 SA Penalties & Interest 3,575$ 624$ 579$ 1,593$ 600$ 257.92$ 600$ 602-43210-33422 Other State Grants & Aids 47,163$ 25$ 74$ 15,754$ -$ 602-43210-34401 Sewer User Fees 74,387$ 98,531$ 106,717$ 93,212$ 140,700$ 72,340.60$ 172,775$ 25% increase over 2023 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ 8,000.00$ -$ 602-43210-36100 Special Assessments -$ -$ -$ 602.43210.36102 Penalties and I 68.03$ -$ 602-43210-36210 Interest Income -$ 181$ 301$ 161$ 400$ 300$ 602-43210-36250 Misc. Refund 550$ 183$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ Total Big Marine Sewer Fund Revenues 125,676$ 107,361$ 118,557$ 117,198$ 141,700$ -$ 82,732.49$ 173,675$ Expenditures BIG MARINE SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 18,626$ 11,014$ 21,714$ 17,118$ 22,500$ 15,321.76$ 23,303$ 602-43210-102 OT Regular Wages 106$ 35$ -$ 602-43210-120 Pension Expense -$ (1,438)$ (693)$ (710)$ -$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,404$ 806$ 1,629$ 1,280$ 1,700$ 1,146.93$ 1,748$ 602-43210-122 FICA Employer Contribution 1,090$ 684$ 1,284$ 1,019$ 1,400$ 892.98$ 1,445$ 602-43210-126 MEDICARE Employer Contribution 260$ 156$ 299$ 238$ 300$ 223.34$ 340$ 602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 602-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 602-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 602-43210-151 Worker s Comp Insurance Prem 854$ 422$ 1,215$ 830$ 700$ 736.40$ 750$ 602-43210-200 Office Supplies -$ 109$ 128$ 79$ 200$ -$ 130$ 602-43210-210 Operating Supplies 752$ 558$ 680$ 664$ 2,500$ 1,485.64$ 1,000$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 113$ -$ 217$ 110$ 600$ -$ 600$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 12,082$ 13,277$ (1,538)$ 7,940$ 10,500$ 61,200.25$ 11,025$ 5% increase 602-43210-304 Legal Services -$ -$ 6,000$ 2,000$ 18.00$ -$ 602-43210-308 Other Professional Services 2,651$ 3,376$ 5,814$ 3,947$ 2,500$ 4,798.00$ 5,000$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 716$ 716$ 756$ 729$ 1,300$ -$ 1,300$ SCADA 602-43210-317 Employee Training 508$ 868$ 925$ 767$ 1,400$ -$ 1,400$ Wastewater training 602-43210-321 Telephone 2,061$ 2,413$ 1,751$ 2,075$ 2,400$ 2,016.55$ 2,500$ SCADA dialers 602-43210-322 Postage 247$ -$ 200$ 149$ 600$ -$ 600$ 602-43210-331 Travel Expenses -$ 8$ 158$ 55$ 200$ 632.55$ 750$ 602-43210-334 Licenses & Permits 754$ 1,180$ 824$ 919$ 1,600$ 729.00$ 2,000$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,052$ 1,039$ 1,003$ 1,031$ 3,000$ 3,449.06$ 3,622$ 5% increase 602-43210-381 Utilities-Electric & Gas 1,620$ 1,862$ 3,473$ 2,318$ 2,500$ (4,268.96)$ 5,000$ 3,000$ 602-43210-385 Sewer Pumping & Maintenance 10,000$ 5,364$ 11,410$ 8,925$ 15,000$ 3,770.22$ 20,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,627$ 1,574$ 2,888$ 2,363$ 5,000$ 2,139.00$ 5,000$ 602-43210-404 Repair Machinery/Equipment 16,180$ 4,375$ 5,857$ 8,804$ 16,000$ 12,100.90$ 16,000$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ -$ -$ -$ 400$ 1,000$ 602-43210-420 Depreciation Expense -$ 48,667$ 50,174$ 32,947$ 54,300$ 29,000$ approximate 602-43210-438 Misc. Contractual 7,410$ 3,775$ 2,550$ 4,578$ 10,000$ 280.00$ 10,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 103,000$ 3,278$ 35,426$ 9,800$ 9,900$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ -$ Total Big Marine Sewer Fund Expenditures 184,113$ 100,803$ 121,995$ 135,637$ 166,400$ -$ 106,671.62$ 151,412$ Revenues / Expenses (58,437.79)$ 6,558.70$ (3,437.59)$ (18,438.90)$ (24,700.00)$ -$ (23,939.13)$ -$ 22,262.56$ UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 12$ -$ -$ 612-43210-34401 Sewer User Fees 6,460$ 15,132$ 17,442$ 13,012$ 22,300$ 10,408.64$ 27,873.00$ 25% increase over 2023 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 40$ 200$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 6,460$ 15,203$ 17,526$ 13,063$ 22,500$ -$ 10,408.64$ 27,923.00$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,020$ 3,673$ 9,282$ 5,991$ 9,700$ 6,442.64$ 10,037$ 612-43210-102 OT Regular Wages -$ -$ -$ -$ 612-43210-120 Pension Expense -$ (630)$ 1,164$ 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 377$ 259$ 697$ 444$ 700$ 482.40$ 753$ 612-43210-122 FICA Employer Contribution 290$ 219$ 550$ 353$ 600$ 375.33$ 622$ 612-43210-126 MEDICARE Employer Contribution 70$ 50$ 126$ 82$ 100$ 97.79$ 146$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 95$ 218$ 304$ 205$ 200$ 315.60$ 300$ 612-43210-200 Office Supplies -$ 4$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ -$ 500$ 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 139$ -$ -$ 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 600$ 7,272$ -$ 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 519$ 192$ 884$ 531$ 500$ 733.00$ 1,400$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 80$ 84$ 81$ -$ 84$ 612-43210-317 Employee Training 114$ 275$ -$ 130$ -$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ -$ 1,500$ 612-43210-322 Postage -$ 18$ -$ 6$ -$ -$ 612-43210-334 Licenses & Permits 259$ 209$ 217$ 228$ 224.00$ 300$ 612-43210-361 Liability/Property Ins 320$ 283$ 334$ 312$ 400$ 477.82$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 482$ 522$ 697$ 567$ 1,700$ 579.08$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance -$ (260)$ 327$ 22$ 1,500$ 1,500.00$ 1,500$ 612-43210-386 Operation & Maintenance -$ -$ 462$ 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment -$ 767$ 465$ 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense -$ 4,876$ 4,877$ 3,251$ 5,100$ -$ 2,450$ 612-43210-438 Misc. Contractual -$ 100$ 548$ 216$ 1,300$ 140.00$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs -$ 1,456$ -$ 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ 2,640$ Reimbursement to 401 for 2013 loan Total Uptown Sewer Fund Expenditures 8,363$ 19,582$ 21,516$ 16,487$ 30,700$ -$ 11,367.66$ 39,834$ Revenues / Expenses (1,903.21)$ (4,379.01)$ (3,990.23)$ (3,424.15)$ (8,200.00)$ -$ (959.02)$ -$ (11,910.69)$ City of Scandia 2024 Proposed Budget 25% Depreciation 1-Oct 2020 2021 2022 3-Yr Avg 2023 Budget 2023 BUDGET 2023 2023 Budget 2024 Actual Actual Actual Actual Proposed AMENDED YTD Actual Projected Budget BIG MARINE SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal -$ 2,887$ 962$ 2,065.94$ -$ 602-43210-31952 SA Penalties & Interest 3,575$ 624$ 579$ 1,593$ 600$ 257.92$ 600$ 602-43210-33422 Other State Grants & Aids 47,163$ 25$ 74$ 15,754$ -$ 602-43210-34401 Sewer User Fees 74,387$ 98,531$ 106,717$ 93,212$ 140,700$ 72,340.60$ 172,775$ 25% increase over 2023 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ 8,000.00$ -$ 602-43210-36100 Special Assessments -$ -$ -$ 602.43210.36102 Penalties and I 68.03$ -$ 602-43210-36210 Interest Income -$ 181$ 301$ 161$ 400$ 300$ 602-43210-36250 Misc. Refund 550$ 183$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ Total Big Marine Sewer Fund Revenues 125,676$ 107,361$ 118,557$ 117,198$ 141,700$ -$ 82,732.49$ 173,675$ Expenditures BIG MARINE SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 18,626$ 11,014$ 21,714$ 17,118$ 22,500$ 15,321.76$ 23,303$ 602-43210-102 OT Regular Wages 106$ 35$ -$ 602-43210-120 Pension Expense -$ (1,438)$ (693)$ (710)$ -$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,404$ 806$ 1,629$ 1,280$ 1,700$ 1,146.93$ 1,748$ 602-43210-122 FICA Employer Contribution 1,090$ 684$ 1,284$ 1,019$ 1,400$ 892.98$ 1,445$ 602-43210-126 MEDICARE Employer Contribution 260$ 156$ 299$ 238$ 300$ 223.34$ 340$ 602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 602-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 602-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 602-43210-151 Worker s Comp Insurance Prem 854$ 422$ 1,215$ 830$ 700$ 736.40$ 750$ 602-43210-200 Office Supplies -$ 109$ 128$ 79$ 200$ -$ 130$ 602-43210-210 Operating Supplies 752$ 558$ 680$ 664$ 2,500$ 1,485.64$ 1,000$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 113$ -$ 217$ 110$ 600$ -$ 600$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 12,082$ 13,277$ (1,538)$ 7,940$ 10,500$ 61,200.25$ 11,025$ 5% increase 602-43210-304 Legal Services -$ -$ 6,000$ 2,000$ 18.00$ -$ 602-43210-308 Other Professional Services 2,651$ 3,376$ 5,814$ 3,947$ 2,500$ 4,798.00$ 5,000$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 716$ 716$ 756$ 729$ 1,300$ -$ 1,300$ SCADA 602-43210-317 Employee Training 508$ 868$ 925$ 767$ 1,400$ -$ 1,400$ Wastewater training 602-43210-321 Telephone 2,061$ 2,413$ 1,751$ 2,075$ 2,400$ 2,016.55$ 2,500$ SCADA dialers 602-43210-322 Postage 247$ -$ 200$ 149$ 600$ -$ 600$ 602-43210-331 Travel Expenses -$ 8$ 158$ 55$ 200$ 632.55$ 750$ 602-43210-334 Licenses & Permits 754$ 1,180$ 824$ 919$ 1,600$ 729.00$ 2,000$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,052$ 1,039$ 1,003$ 1,031$ 3,000$ 3,449.06$ 3,622$ 5% increase 602-43210-381 Utilities-Electric & Gas 1,620$ 1,862$ 3,473$ 2,318$ 2,500$ (4,268.96)$ 5,000$ 3,000$ 602-43210-385 Sewer Pumping & Maintenance 10,000$ 5,364$ 11,410$ 8,925$ 15,000$ 3,770.22$ 20,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,627$ 1,574$ 2,888$ 2,363$ 5,000$ 2,139.00$ 5,000$ 602-43210-404 Repair Machinery/Equipment 16,180$ 4,375$ 5,857$ 8,804$ 16,000$ 12,100.90$ 16,000$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ -$ -$ -$ 400$ 1,000$ 602-43210-420 Depreciation Expense -$ 48,667$ 50,174$ 32,947$ 54,300$ 14,500$ approximate 602-43210-438 Misc. Contractual 7,410$ 3,775$ 2,550$ 4,578$ 10,000$ 280.00$ 10,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 103,000$ 3,278$ 35,426$ 9,800$ 9,900$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ -$ Total Big Marine Sewer Fund Expenditures 184,113$ 100,803$ 121,995$ 135,637$ 166,400$ -$ 106,671.62$ 136,912$ Revenues / Expenses (58,437.79)$ 6,558.70$ (3,437.59)$ (18,438.90)$ (24,700.00)$ -$ (23,939.13)$ -$ 36,762.56$ UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 12$ -$ -$ 612-43210-34401 Sewer User Fees 6,460$ 15,132$ 17,442$ 13,012$ 22,300$ 10,408.64$ 27,873.00$ 25% increase over 2023 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 40$ 200$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 6,460$ 15,203$ 17,526$ 13,063$ 22,500$ -$ 10,408.64$ 27,923.00$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,020$ 3,673$ 9,282$ 5,991$ 9,700$ 6,442.64$ 10,037$ 612-43210-102 OT Regular Wages -$ -$ -$ -$ 612-43210-120 Pension Expense -$ (630)$ 1,164$ 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 377$ 259$ 697$ 444$ 700$ 482.40$ 753$ 612-43210-122 FICA Employer Contribution 290$ 219$ 550$ 353$ 600$ 375.33$ 622$ 612-43210-126 MEDICARE Employer Contribution 70$ 50$ 126$ 82$ 100$ 97.79$ 146$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 95$ 218$ 304$ 205$ 200$ 315.60$ 300$ 612-43210-200 Office Supplies -$ 4$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ -$ 500$ 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 139$ -$ -$ 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 600$ 7,272$ -$ 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 519$ 192$ 884$ 531$ 500$ 733.00$ 1,400$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 80$ 84$ 81$ -$ 84$ 612-43210-317 Employee Training 114$ 275$ -$ 130$ -$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ -$ 1,500$ 612-43210-322 Postage -$ 18$ -$ 6$ -$ -$ 612-43210-334 Licenses & Permits 259$ 209$ 217$ 228$ 224.00$ 300$ 612-43210-361 Liability/Property Ins 320$ 283$ 334$ 312$ 400$ 477.82$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 482$ 522$ 697$ 567$ 1,700$ 579.08$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance -$ (260)$ 327$ 22$ 1,500$ 1,500.00$ 1,500$ 612-43210-386 Operation & Maintenance -$ -$ 462$ 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment -$ 767$ 465$ 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense -$ 4,876$ 4,877$ 3,251$ 5,100$ -$ 1,225$ 612-43210-438 Misc. Contractual -$ 100$ 548$ 216$ 1,300$ 140.00$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs -$ 1,456$ -$ 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ 2,640$ Reimbursement to 401 for 2013 loan Total Uptown Sewer Fund Expenditures 8,363$ 19,582$ 21,516$ 16,487$ 30,700$ -$ 11,367.66$ 38,609$ Revenues / Expenses (1,903.21)$ (4,379.01)$ (3,990.23)$ (3,424.15)$ (8,200.00)$ -$ (959.02)$ -$ (10,685.69)$ City of Scandia 2024 Proposed Budget 0% Depreciation 1-Oct 2020 2021 2022 3-Yr Avg 2023 Budget 2023 BUDGET 2023 2023 Budget 2024 Actual Actual Actual Actual Actual AMENDED YTD Actual Projected Budget BIG MARINE SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal -$ 2,887$ 962$ 2,065.94$ -$ 602-43210-31952 SA Penalties & Interest 3,575$ 624$ 579$ 1,593$ 600$ 257.92$ 600$ 602-43210-33422 Other State Grants & Aids 47,163$ 25$ 74$ 15,754$ -$ 602-43210-34401 Sewer User Fees 74,387$ 98,531$ 106,717$ 93,212$ 140,700$ 72,340.60$ 172,775$ 25% increase over 2023 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ 8,000.00$ -$ 602-43210-36100 Special Assessments -$ -$ -$ 602.43210.36102 Penalties and I 68.03$ -$ 602-43210-36210 Interest Income -$ 181$ 301$ 161$ 400$ 300$ 602-43210-36250 Misc. Refund 550$ 183$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ Total Big Marine Sewer Fund Revenues 125,676$ 107,361$ 118,557$ 117,198$ 141,700$ -$ 82,732.49$ 173,675$ Expenditures BIG MARINE SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 18,626$ 11,014$ 21,714$ 17,118$ 22,500$ 15,321.76$ 23,303$ 602-43210-102 OT Regular Wages 106$ 35$ -$ 602-43210-120 Pension Expense -$ (1,438)$ (693)$ (710)$ -$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,404$ 806$ 1,629$ 1,280$ 1,700$ 1,146.93$ 1,748$ 602-43210-122 FICA Employer Contribution 1,090$ 684$ 1,284$ 1,019$ 1,400$ 892.98$ 1,445$ 602-43210-126 MEDICARE Employer Contribution 260$ 156$ 299$ 238$ 300$ 223.34$ 340$ 602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 602-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 602-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 602-43210-151 Worker s Comp Insurance Prem 854$ 422$ 1,215$ 830$ 700$ 736.40$ 750$ 602-43210-200 Office Supplies -$ 109$ 128$ 79$ 200$ -$ 130$ 602-43210-210 Operating Supplies 752$ 558$ 680$ 664$ 2,500$ 1,485.64$ 1,000$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 113$ -$ 217$ 110$ 600$ -$ 600$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 12,082$ 13,277$ (1,538)$ 7,940$ 10,500$ 61,200.25$ 11,025$ 5% increase 602-43210-304 Legal Services -$ -$ 6,000$ 2,000$ 18.00$ -$ 602-43210-308 Other Professional Services 2,651$ 3,376$ 5,814$ 3,947$ 2,500$ 4,798.00$ 5,000$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 716$ 716$ 756$ 729$ 1,300$ -$ 1,300$ SCADA 602-43210-317 Employee Training 508$ 868$ 925$ 767$ 1,400$ -$ 1,400$ Wastewater training 602-43210-321 Telephone 2,061$ 2,413$ 1,751$ 2,075$ 2,400$ 2,016.55$ 2,500$ SCADA dialers 602-43210-322 Postage 247$ -$ 200$ 149$ 600$ -$ 600$ 602-43210-331 Travel Expenses -$ 8$ 158$ 55$ 200$ 632.55$ 750$ 602-43210-334 Licenses & Permits 754$ 1,180$ 824$ 919$ 1,600$ 729.00$ 2,000$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,052$ 1,039$ 1,003$ 1,031$ 3,000$ 3,449.06$ 3,622$ 5% increase 602-43210-381 Utilities-Electric & Gas 1,620$ 1,862$ 3,473$ 2,318$ 2,500$ (4,268.96)$ 5,000$ 3,000$ 602-43210-385 Sewer Pumping & Maintenance 10,000$ 5,364$ 11,410$ 8,925$ 15,000$ 3,770.22$ 20,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,627$ 1,574$ 2,888$ 2,363$ 5,000$ 2,139.00$ 5,000$ 602-43210-404 Repair Machinery/Equipment 16,180$ 4,375$ 5,857$ 8,804$ 16,000$ 12,100.90$ 16,000$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ -$ -$ -$ 400$ 1,000$ 602-43210-420 Depreciation Expense -$ 48,667$ 50,174$ 32,947$ 54,300$ -$ approximate 602-43210-438 Misc. Contractual 7,410$ 3,775$ 2,550$ 4,578$ 10,000$ 280.00$ 10,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 103,000$ 3,278$ 35,426$ 9,800$ 9,900$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ -$ Total Big Marine Sewer Fund Expenditures 184,113$ 100,803$ 121,995$ 135,637$ 166,400$ -$ 106,671.62$ 122,412$ Revenues / Expenses (58,437.79)$ 6,558.70$ (3,437.59)$ (18,438.90)$ (24,700.00)$ -$ (23,939.13)$ -$ 51,262.56$ UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 12$ -$ -$ 612-43210-34401 Sewer User Fees 6,460$ 15,132$ 17,442$ 13,012$ 22,300$ 10,408.64$ 27,873.00$ 25% increase over 2023 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 40$ 200$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 6,460$ 15,203$ 17,526$ 13,063$ 22,500$ -$ 10,408.64$ 27,923.00$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,020$ 3,673$ 9,282$ 5,991$ 9,700$ 6,442.64$ 10,037$ 612-43210-102 OT Regular Wages -$ -$ -$ -$ 612-43210-120 Pension Expense -$ (630)$ 1,164$ 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 377$ 259$ 697$ 444$ 700$ 482.40$ 753$ 612-43210-122 FICA Employer Contribution 290$ 219$ 550$ 353$ 600$ 375.33$ 622$ 612-43210-126 MEDICARE Employer Contribution 70$ 50$ 126$ 82$ 100$ 97.79$ 146$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 95$ 218$ 304$ 205$ 200$ 315.60$ 300$ 612-43210-200 Office Supplies -$ 4$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ -$ 500$ 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 139$ -$ -$ 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 600$ 7,272$ -$ 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 519$ 192$ 884$ 531$ 500$ 733.00$ 1,400$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 80$ 84$ 81$ -$ 84$ 612-43210-317 Employee Training 114$ 275$ -$ 130$ -$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ -$ 1,500$ 612-43210-322 Postage -$ 18$ -$ 6$ -$ -$ 612-43210-334 Licenses & Permits 259$ 209$ 217$ 228$ 224.00$ 300$ 612-43210-361 Liability/Property Ins 320$ 283$ 334$ 312$ 400$ 477.82$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 482$ 522$ 697$ 567$ 1,700$ 579.08$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance -$ (260)$ 327$ 22$ 1,500$ 1,500.00$ 1,500$ 612-43210-386 Operation & Maintenance -$ -$ 462$ 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment -$ 767$ 465$ 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense -$ 4,876$ 4,877$ 3,251$ 5,100$ -$ -$ 612-43210-438 Misc. Contractual -$ 100$ 548$ 216$ 1,300$ 140.00$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs -$ 1,456$ -$ 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ 2,640$ Reimbursement to 401 for 2013 loan Total Uptown Sewer Fund Expenditures 8,363$ 19,582$ 21,516$ 16,487$ 30,700$ -$ 11,367.66$ 37,384$ Revenues / Expenses (1,903.21)$ (4,379.01)$ (3,990.23)$ (3,424.15)$ (8,200.00)$ -$ (959.02)$ -$ (9,460.69)$ Big Marine Sewer District 100%75%50%25%0% Revenues 173,674.56$ 173,674.56$ 173,674.56$ 173,674.56$ 173,674.56$ Expenses 180,412.00$ 165,912.00$ 151,412.00$ 136,912.00$ 122,412.00$ Total (6,737.44)$ 7,762.56$ 22,262.56$ 36,762.56$ 51,262.56$ Uptown Sewer System 100%75%50%25%0% Revenues 27,923.00$ 27,923.00$ 27,923.00$ 27,923.00$ 27,923.00$ Expenses 42,283.69$ 41,058.69$ 39,833.69$ 38,608.69$ 37,383.69$ Total (14,360.69)$ (13,135.69)$ (11,910.69)$ (10,685.69)$ (9,460.69)$ % of Depreciation Covered % of Depreciation Covered