Loading...
HomeMy WebLinkAbout10142021 City Council Work Session Laydown - SMIC Budget CL offt.k.) SMIC - Revenue & Expenditures Revenue 12000-2500 Operating Revenue $ 67,175.00 12000-2500 Non-operating Revenue $ 968,216.00 12000-2501 SMIC Basin $ 88,277.00 12000-2504 SMIC 330-ton lift $ 404,100.00 12000-2505 SMIC Syncrolift $ 547,429.00 Total: $ 2,075,197.00 Expenditures 12000-0900 Debt Service $ - 12000-2500 Operating $ 1,035,689.33 12000-2501 SMIC Basin $ 183,191.81 12000-2504 SMIC 330-ton lift $ 632,137.00 12000-2505 SMIC Syncrolift $ 526,025.96 Total: $ 2,377,044.10 Transfers Out: $ 117,009.00 Total Expenditures: $ 2,494,053.10 Revenue over expenses: $ (418,856.10) Depreciation Expense: $ 1,650,183.21 Total Expenditures Less Depreciation: $ 843,869.89 Revenue over Expenditures (less depreciation expense): $ 1,231,327.11 IC Basin 2016 2017 2018 2019 2020 2021 Amended 2021 YTD ILL and Expense Budget I Actual Actual Actual Actual Actual Budget Actuals 2022 Proposed Revenues: Operating Revenue: 5101 Moorage 23,573 15,566 8,430 47,659 50,197 14,000 43,495 46,775 5102 Wharfage 10,996 7,832 2,666 7,638 725 6,000 23,470 9,550 5106 SMIC Power Sales $0 $0 $0 $6,330 $2,552 0 905 4,450 5110 Crane Fees 0 0 0 1,040 468 1,500 2,024 1,000 5153 Fuel Pumping Fee 3,908 0 173 0 0 1,000 0 700 5800 Labor&Services 0 0 0 0 105 500 0 100 5802 Equipment Rental 0 0 0 0 0 500 0 1 Total Operating Revenue: $38,478 $23,397 $11,269 $62,668 $54,047 $23,500 $69,894 $62,576 Non-Operating Revenue: 5000 Land Rents and Leases 33,113 44,234 44,349 45,133 46,128 44,224 24,451 25,701 Total Non-Operating Revenue: $33,113 $44,234 $44,349 $45,133 $46,128 $44,224 $24,451 $25,701 Total Revenue: $71,590 $67,632 $55,619 $107,801 $100,175 $67,724 $94,345 $88,277 Expenditures: Personnel Costs: 6000 Salaries 2,981 2,351 639 3,143 677 1,954 907 4,027 6001 Overtime 212 0 78 195 0 286 79 100 6100 Medicare 46 38 12 47 10 33 16 60 6102 Workers'Compensation 418 256 68 305 55 256 84 267 6201 Retirement Benefits 0 207 -849 479 149 150 238 899 6202 Health Insurance 1,549 0 571 1,838 502 785 48 4,704 Total Personnel Costs: $5,207 $2,852 $520 $6,007 $1,394 $3,464 $1,372 $10,057 Non-Personnel Costs: 7002 Postage and Freight 0 0 0 10 0 0 1,983 2,001 7004 Insurance 3,162 3,183 3,365 4,131 5,187 2,448 6,369 6,225 7009 Contracted Services 1,858 4,283 1,274 1,850 2,865 5,100 0 3,000 7015 Utilities 0 0 0 0 0 0 175 300 7213 Safety Equipment 0 0 0 0 0 0 996 500 7215 Operating Supplies 0 0 15 24 0 0 0 0 7216 Maintenance&Repair 29 0 90 598 65 3,060 1,202 1,850 7302 Travel&Subsistence 0 0 0 532 0 0 0 100 7321 Harbor General Indirect Costs 3,639 3,966 8,344 7,882 2,289 2,332 2,332 2,360 7322 Harbor Admin Indirect Costs 3,758 3,242 8,204 8,989 2,784 2,239 2,739 2,266 7323 SMIC General Indirect Costs 7,374 9,005 21,288 17,262 4,923 4,935 4,935 4,994 7324 Gen Fund Indirect Costs 48,485 49,648 51,640 52,466 53,093 53,733 53,733 54,378 7330 P.I.L.T. 3,079 1,872 902 5,013 4,324 1,520 3,293 5,344 7331 Reclass PILT to Transfer-Out -3,079 -1,872 -902 -5,013 -4,324 -1,520 -3,293 -5,344 7900 Depreciation Expense 47,645 47,646 47,646 47,646 47,755 47,645 0 47,646 Total Non-Personnel Costs: $115,950 $120,972 $141,865 $141,389 $118,960 $121,492 $74,464 $125,620 Total Expenditures: $121,157 $123,824 $142,385 $147,396 $120,354 $124,956 $75,836 $135,677 • SMIC East Dock- Not Combined SMIC East Dock(12000-2503) 2016 2017 2018 2019 2020 2021 Amended 2021 YTD Revenue and Expense Budget Actual Actual Actual Actual Actual Budget Actuals 2022 Proposed Revenues: Operating Revenue: 5101 Moorage 8,544 1,366 6,083 7,449 1,695 1,000 397 4,275 5102 Wharfage 0 4,932 2,666 5,414 0 5,000 0 2,175 Total Operating Revenue: $8,544 $6,299 $8,749 $12,863 $1,695 $6,000 $397 $6,450 Non-Operating Revenue: 5000 Land Rents and Leases 33,113 44,234 44,349 45,133 46,128 44,224 24,451 25,700 Total Non-Operating Revenue: $33,113 $44,234 $44,349 $45,133 $46,128 $44,224 $24,451 $25,700 Total Revenue: $41,657 $50,533 $53,098 $57,996 $47,824 $50,224 $24,847 $32,150 Expenditures: Personnel Costs: Total Personnel Costs: $0 $0 $0 $0 $0 $0 $0 $0 Non-Personnel Costs: 7004 Insurance 883 883 923 1,217 1,589 0 878 1,907 7321 Harbor General Indirect 1,615 1,760 1,853 1,750 1,717 1,749 1,749 1,770 7322 Harbor Admin Indirect C 1,667 1,439 1,822 1,996 2,088 1,679 2,054 1,699 7323 SMIC General Indirect Ci 3,272 3,996 4,727 3,833 3,829 3,838 3,838 3,884 7324 Gen Fund Indirect Costs 20,046 20,526 20,963 21,298 21,554 21,812 21,812 22,074 7330 P.I.L.T. 684 504 700 1,029 136 480 32 516 7331 Reclass PILT to Transfer- -684 . -504 -700 -1,029 -136 -480 -32 -516 Total Non-Personnel Costs: $27,483 $28,604 $30,289 $30,093 $30,776 $29,078 $30,331 $31,334 Total Expenditures: $27,483 $28,604 $30,289 $30,093 $30,776 $29,078 $30,331 $31,334 SMIC North Dock-Not Combined SMIC North Dock(12000-2502) 2016 2017 2018 2019 2020 2021 Amended 2021 YTD Revenue and Expense Budget Actual Actual Actual Actual Actual Budget Actuals 2022 Proposed Revenues: Operating Revenue: 5101 Moorage 15,029 14,200 2,347 16,361 20,981 13,000 15,154 14,500 5102 Wharfage 10,996 2,900 0 2,224 725 1,000 23,470 7,375 5110 Crane Fees 0 0 0 1,040 468 1,500 2,024 1,000 5153 Fuel Pumping Fee 3,908 0 173 0 0 1,000 0 700 5800 Labor&Services 0 0 0 0 0 500 0 0 5802 Equipment Rental 0 0 0 0 0 500 0 0 Total Operating Revenue: $29,934 $17,099 $2,520 $19,626 $22,174 $17,500 $40,648 $23,575 Non-Operating Revenue: Total Non-Operating Revenue: $0 $0 $0 $0 $0 $0 $0 $0 Total Revenue: $29,934 $17,099 $2,520 $19,626 $22,174 $17,500 $40,648 $23,575 Expenditures: Personnel Costs: 6000 Salaries 2,981 2,351 639 3,143 677 1,954 907 4,027 6001 Overtime 212 0 78 195 0 286 79 100 6100 Medicare 46 38 12 47 10 33 16 60 6102 Workers'Compensation 418 256 68 305 55 256 84 267 6201 Retirement Benefits 0 207 -849 479 149 150 238 899 6202 Health Insurance 1,549 0 571 1,838 502 785 48 4,704 Total Personnel Costs: $5,207 $2,852 $520 $6,007 $1,394 $3,464 $1,372 $10,057 Non-Personnel Costs: 7002 Postage and Freight 0 0 0 10 0 0 1,983 2,000 7004 Insurance 2,279 2,300 2,442 2,914 3,598 2,448 5,491 4,318 7009 Contracted Services 1,858 4,283 1,274 1,850 2,865 5,100 0 3,000 7015 Utilities 0 0 0 0 0 0 175 300 7213 Safety Equipment 0 0 0 0 0 0 996 500 7215 Operating Supplies 0 0 15 24 0 0 0 0 7216 Maintenance& Repair 29 0 90 598 65 3,060 1,202 1,850 7302 Travel&Subsistence 0 0 0 532 0 0 0 100 7321 Harbor General Indirect Co 2,024 2,206 6,491 6,132 572 583 583 590 7322 Harbor Admin Indirect Cos 2,091 1,803 6,382 6,993 696 560 685 567 7323 SMIC General Indirect Cost 4,102 5,009 16,561 13,429 1,094 1,097 1,097 1,110 7324 Gen Fund Indirect Costs 28,439 29,122 30,677 31,168 31,542 31,921 31,921 32,304 7330 P.I.L.T. 2,395 1,368 202 1,570 1,774 1,040 1,351 1,886 7331 Reclass PILT to Transfer-Oi -2,395 -1,368 -202 -1,570 -1,774 -1,040 -1,351 -1,886 7900 Depreciation Expense 47,645 47,646 47,646 47,646 47,755 47,645 0 47,645 Total Non-Personnel Costs: $88,467 $92,368 $111,577 $111,295 $88,186 $92,414 $44,133 $94,284 Total Expenditures: $93,674 $95,220 $112,097 $117,302 $89,580 $95,878 $45,505 $104,341 SMIC Fisherman's Float-Not Combined SMIC Fisherman's Float(12000- 2016 2017 2018 2019 2020 2021 Amended 2021 YTD 2501)Expense Budget Actual Actual Actual Actual Actual Budget Actuals 2022 Proposed Operating Revenue: 5101 Moorage $0 $0 $0 $23,849 $27,521 0 27,944 28,000 5106 SMIC Power Sales $0 $0 $0 $6,330 $2,552 0 905 4,450 5800 Labor&Services $0 $0 $0 $0 $105 0 0 100 Total Operating Revenues: $0 $0 $0 $30,180 $30,178 $0 $28,849 $32,550 Total Revenues: $0 $0 $0 $30,180 $30,178 $0 $28,849 $32,550 Expenditures: Non-Personnel Costs: 7330 P.I.L.T. 0 0 0 2,414 2,414 0 1,910 2,556 7331 Reclass PILT to Transfer-Out 0 0 0 -2,414 -2,414 0 -1,910 -2,556 Total Non-Personnel Costs: $0 $0 $0 $0 $0 $0 $0 $0 Total Expenditures: $0 $0 $0 $0 $0 $0 $0 $0