Loading...
HomeMy WebLinkAbout10082015 City Council Work Session Notes - Budget 1/ o c l WORK SESSION NOTES ON ,(60,01 }1'7 -�,;�ei 'p- CV <<r724A4c ' pi,&) 4A /v jvleaIC,A14_,,,‘411.7%Z �*616er -1/' 24 lo Present:,j d4i,,� G� /yt :S/c� Council Members Present CRAW �v►s v✓D/Gt / /� 90640 ;�5/ ve 4v15 ax-, �' cX5; fa.-oa firw''r' ' U �P 3a CIGc e_ (A) t'c e v i re4 l evo-j ) / �� 3aA l2q Nblivi i��,5 �1.--se-a! Called by: o � 3 Time: m Date: /0/8// 5 v � P f *****************_ _ :*_ ********************************* �s (.-011 — ��p 0 -eci v'3'/o7d`i 1- .06 i- "1-0 ;-p Y�d v vU Ku G1 /j -'(iL S vo ',,.e Lt>)r...--e-aA e a-1,-,GL. pyo tO4 Uri t iici-L, a_. C.t. o spd.. to /-.e__0( ,t._ \13 et4 d otA A on iklA Ant") 4:::kr...11_,4 lei 44, -40 fi-)1/1-id r-OvtGL-;1,1,5 6 i (,71-rvi 44 S M ► c aai`D , u n i , ' , , j a 0 /4" tik12 CJ, 44.2 tAn 'L�t.td-eo- c.vt 4'1/1A;4' ° lc:'-m" D (I fi/° C 1/-,c-re ► c r A-6 vvb (/J),, (N`, `0 a v.,c,1 a cype0Sol r r, `., ^ , e a a.- \� c (!L -(‘ .R ( v'1 1-(J,v.y,,' 'j ((,,..e4 Oka tV,.F ` 4C Cv1 !:: i a , 1 V tA1 ��\ V ft 0)o z_ c " r �, 0, .f/ n11-1,3 /.'ham^vv, ,l Yh CJ`i a - f 31 a 6 � �� �r Q , ,i) -1-ZM.v o ri,,,,, 00/2e? p,, ,_ L/y' t-, V\J IC v• cLe- nQ_An Sed za_cQ. kAJLa \.,� ;-1 t.\ 05A-c,r-k-e ‘' CA k--A, ( g \ vo-m Shp VPS v,/, ,,A ) .SAIP- s � 2 irsit/ mackrut., as-0,w ci.; ikr)v+trA yvus-Aexio-d-__ /0/2 (6- W HOSPITAL ENTERPRISE FUND Budgeted Statement of Revenues and Expenses and Changes in Net Position For 20I6 and 20I7 2014 2015 2016 2017 Actual* Budget Budget Budget Revenues(investment earnings): $0 $5,000 $5,000 $5,000 Operating Expenses: Hospital contributions for capital needs 242,795 462,794 200,000 200,000 Health Facility Expansion I55,889 26I,379 Community Health Center 850,000 (a; 500,000 500,000 400,000 Purchased services 38,350 Depreciation 242,672 203,953 203,953 203,953 Total operating expenses $1,373,817 $1,166,747 $1,059,842 $1,065,332 Non-operating revenues(expense) Gain(loss)on sales of assets 0 0 0 0 Debt service interest (6I,807) (6I,807) (57,979) (53,95I) Capital equipment and other - - - - Total non-operating revenue(expense ($6I,807) ($6I,807) ($57,979) ($53,95I) Earnings(loss)before transfers ($1,435,624) ($1,223,554) ($1,112,821) ($1,114,283) Operating transfers from other funds I,I36,752 I,092,500 I,072,500 I,092,500 Operating transfers to other funds 0 0 0 0 Change in net position ($298,872) ($I3I,054) ($40,32I) ($2I,783) (a) Clinic space remodel- $I50K;CHC start-up costs- $700,000K "Does not tie to CAFR since City budgets Hospital and LTC separately,and does not budget for PSMCC operations. The CAFR however,aggregates the City's hospital enterprise fund,LTC enterprise fund,and PSMCC financial statements into one fund,since PSMCC operational surpluses or deficits accrue to taxpayers. CITY OF SEWARD HOSPITAL ENTERPRISE FUND Budgeted Statement of Cash Flow For 2016 and 2017 2015 2016 2017 Budget Budget Budget Beginning Cash Balance at 1/1/15: $600,058 Cash is provided by(used for): Change in net position (131,054) (40,321) (21,783) Add expense items not affecting cash Depreciation 203,953 203,953 2()3,953 Net cash provided by operations $72,899 $163,632 $182,170 Other sources (uses) of cash Debt principal ($72,899) ($69262) ($72,899) Net increase (decrease) in cash 0 94,370 109,271 Estimated ending cash balance S600,058 S694,428 $803,699 CITY OF SEWARD HOSPITAL ENTERPRISE FUND 2016 and 2017 Debt Service Schedule Balance 2016 Budget Balance Description Interest Rate @ 1/01/16 Principal Interest Total @ 12/31/16 Term Hospital PERS loan - F03000 5.25% 808,172 56,148 42,429 98,577 752,024 2007- 2026 Hospital PERS loan - F15001 5.25% 296,195 20,578 15,550 36,128 275,617 2007- 2026 Totals: $1,104,367 $76,726 $57,979 $134,705 $1,027,641 Balance 2017 Budget Balance • Description Interest Rate @ 1/01/17 Principal Interest Total @ 12/31/17 Term Hospital PERS loan - F03000 5.25% 752,024 59,095 39,481 98,576 692,929 2007- 2026 Hospital PERS loan - F15001 5.25% 275,617 21,658 14,470 36,128 253,959 2007- 2026 Totals: _ $1,027,641 $80,753 $53,951 $134,704 $946,888 . FINANCIAL PLAN FOR UTILIZATION OF 1%HEALTHCARE SALES TAX Assumptions: (a)SMH census will be inadequate to cover LTC Bond debt service costs in the future;census will come in at 33 rather than 34. Prior to 2015,shortfall is$548,972;recover over remaining 19 years, plus recover annual shortfall due to if census 33. (b)Hospital Enterprise Fund owes Motor Pool Fund$808,172 for SGH PERS Loan;5.25%,matures 1/1/2026 (c)Sales tax revenues increase 1/2 of 1%(0.005%)each year. Projected Sales SMH PSMC Seward CHC Cumulative Cumulative Tax Bond Capital PERS Loan Facility Operating Facility Annual Facility Expansion addtl Bond Revenue(c) Reserve(a) Budget Repay(b) Expansion Budget Expansion Balance Reserve Reserve (548,972.00) 2015 1,092,500 462,794 134,705 500,000 (4,999) 2016 1,097,963 107,368 200,000 134,705 155,889 500,000 - 0 155,889 107,368 2017 1,103,452 107,368 200,000 134,705 161,379 400,000 100,000 0 417,268 214,737 2018 1,108,970 107,368 200,000 134,705 166,897 300,000 200,000 (0) 784,165 322,105 2019 1,114,514 107,368 200,000 134,705 172,441 200,000 300,000 0 1,256,606 429,473 2020 1,120,087 96,418 200,000 134,705 638,964 50,000 (0) 1,895,570 525,891 2021 1,125,687 96,418 200,000 134,705 644,564 50,000 0 2,540,134 622,310 2022 1,131,316 96,418 200,000 134,705 650,193 50,000 (0) 3,190,327 718,728 2023 1,136,972 96,418 200,000 134,705 655,849 50,000 0 3,846,176 815,146 2024 1,142,657 79,993 200,000 134,705 677,959 50,000 0 4,524,135 895,139 2025 1,148,371 79,993 200,000 134,705 683,673 50,000 (0) 5,207,808 975,133 2026 1,154,112 79,993 200,000 134,705 689,414 50,000 0 5,897,222 1,055,126 2027 1,159,883 79,993 200,000 829,890 50,000 (0) 6,727,112 1,135,119 2028 1,165,682 61,743 200,000 853,939 50,000 0 7,581,051 1,196,862 2029 1,171,511 61,743 200,000 859,768 50,000 (0) 8,440,819 1,258,606 2030 1,177,368 61,743 200,000 865,625 50,000 0 9,306,444 1,320,349 2031 1,183,255 61,743 200,000 871,512 50,000 (0) 10,177,956 1,382,092 2032 1,189,172 47,143 200,000 892,028 50,000 0 11,069,984 1,429,235 2033 1,195,117 47,143 200,000 897,974 50,000 0 11,967,958 1,476,379 2034 1,201,093 33,631 200,000 917,462 50,000 (0) 12,885,420 1,510,010 12,885,420 C:\Excel Data\Hospital\1%sales tax plan with PSMC_Cash_Flow_Projections FINANCIAL PLAN FOR UTILIZATION OF 1%HEALTHCARE SALES TAX Scenario: Optimistic Assumptions: (a)SMH census will be inadequate to cover LTC Bond debt service costs in the future;census will come in at 33 rather than 34. Prior to 2015,shortfall is$548,972;recover over remaining 19 years,plus recover annual shortfall due to if census 33. (b)Hospital Enterprise Fund owes Motor Pool Fund$808,172 for SGH PERS Loan;5.25%,matures 1/1/2026 (c)Sales tax revenues increase 1%each year. Projected Sales SMH PSMC Seward CHC Cumulative Cumulative Tax Bond Capital PERS Loan Facility Operating Facility Annual Facility Expansion addtl Bond Revenue(c) Reserve(a) Budget Repay(b) Expansion Budget Expansion Balance Reserve Reserve (548,972.00) 2015 1,092,500 462,794 134,705 500,000 (4,999) 2016 1,103,425 107,368 200,000 134,705 161,352 300,000 200,000 - 361,352 107,368 2017 1,114,459 107,368 200,000 134,705 172,386 100,000 400,000 - 933,738 214,737 2018 1,125,604 107,368 200,000 134,705 183,531 - 500,000 - 1,617,269 322,105 2019 1,136,860 107,368 200,000 134,705 194,787 - 500,000 - 2,312,056 429,473 2020 1,148,228 96,418 200,000 134,705 667,105 - 50,000 - 3,029,161 525,891 2021 1,159,711 96,418 200,000 134,705 678,588 - 50,000 - 3,757,749 622,310 2022 1,171,308 96,418 200,000 134,705 690,185 - 50,000 - 4,497,934 718,728 2023 1,183,021 96,418 200,000 134,705 701,898 - 50,000 - 5,249,832 815,146 2024 1,194,851 79,993 200,000 134,705 730,153 - 50,000 - 6,029,985 895,139 2025 1,206,800 79,993 200,000 134,705 742,102 - 50,000 - 6,822,086 975,133 2026 1,218,868 79,993 200,000 134,705 754,170 - 50,000 - 7,626,256 1,055,126 2027 1,231,056 79,993 200,000 901,063 - 50,000 - 8,577,319 1,135,119 2028 1,243,367 61,743 200,000 931,624 - 50,000 - 9,558,943 1,196,862 2029 1,255,801 61,743 200,000 944,057 - 50,000 - 10,553,000 1,258,606 2030 1,268,359 61,743 200,000 956,615 - 50,000 - 11,559,615 1,320,349 2031 1,281,042 61,743 200,000 969,299 - 50,000 - 12,578,914 1,382,092 2032 1,293,853 47,143 200,000 996,709 - 50,000 - 13,625,623 1,429,235 2033 1,306,791 47,143 200,000 1,009,648 - 50,000 - 14,685,271 1,476,379 2034 1,319,859 33,631 200,000 1,036,228 - 50,000 - 15,771,499 1,510,010 $ 15,771,499 C:\Excel Data\Hospital\1%sales tax plan with PSMC_Cash_Flow_Projections SCHC FINANCIAL OVERVIEW Avg. Monthly Net Patient Annual City Redirected to BASELINE ASSUMPTIONS Visits Revenue per Allocation 1%Reserve Based on May-August 2015 Experience Month Fund* Avg. Monthly Cash Exp. $ 190,000 Alb X 1.04(4% margin) x 1.04 690 $138,000 Above BE i, $500,000 Monthly Cash Rev.Target $ 197,600 _ 609 Al $0 Less Monthly 330 Draw $ (75,800) Less Monthly City Allocation $ (41,667) Monthly Net Pt. Rev.Target $ 80,133 500 $100,000 $260,000 111114 Avg. Net Rev./Visit -$200 $240,000 MI -------A-----u- Avg. Monthly Visits to BEv.c1:^1' = 400->4,800 2.5 Visits/Patient/Year 1,920 pts. %of Service Area Population 35% 450 1• $90,000 $380,000 $120,000 2019 Projected Volume/ Productivity MK -----A--- Visits/Day 15 x4 days/week 60 x46 weeks/year 2,760 400 \, $80,000 $500,000 2015 Baseline x3 providers 8,280 NM . , 12 months 690 BE Annual Patients 3,312 % of Service Area 60% Cash on Hand Goal Updated 9/17/15 SCHC"Primary Reserve" Adjusted for visitors(10%) 54% /S/`5 SEWARD MOUNTAIN HAVEN ENTERPRISE FUND Budgeted Statement of Revenues and Expenses and Changes in Net Position For 2016 and 20I7 2014 2015 2016 2017 Actual * Budget Budget Budget Revenues: Interest earnings I04 0 0 0 LTC capital cost reimbursement 2,874,118 1,950,788 I,948,538 I,953,7I3 Total revenues $2,874,222 $1,950,788 $1,948,538 $1,953,713 Expenses: Debt service interest and other costs I,217,620 I,I25,788 I,083,538 I,043,7I3 Depreciation 2,042,958 I,653,02I I,648,022 I,630,244 Total expenses $3,260,578 $2,778,809 $2,731,560 $2,673,957 Excess(deficit)of revenues over expenditures (386,356) (828,021) (783,022) (720,244) Operating transfers from other funds 0 0 0 0 Operating transfers to other funds 0 0 0 0 Change in net position (386,356) (828,021) (783,022) (720,244) # Does not tie to annual Comprehensive Annual Financial Report since that report also includes operations from PSMC. This schedule includes only City's enterprise fund data. CITY OF SEWARD SEWARD MOUNTAIN HAVEN ENTERPRISE FUND Budgeted Statement of Cash Flow For 2016 and 20I7 2015 2016 2017 Budget Budget Budget Beginning Cash Balance at 1/1/15: $1,025,189 Cash is provided by(used for): Change in net position (828,021) (783,022) (720,244) Add expense items not affecting cash Depreciation I,653,02I I,648,022 I,630,244 Net cash provided by operations $825,000 $865,000 $910,000 Other sources(uses) of cash Debt principal (825,000) (865,000) (9I0,000) Capital outlay Net increase(decrease) in cash $0 $0 $0 Estimated ending cash balance $1,025,189 $1,025,189 $1,025,189 (a) Seward Mountain Haven revenue bonds. CITY OF SEWARD SEWARD MOUNTAIN HAVEN ENTERPRISE FUND 2016 and 2017 Debt Service Schedule Balance 2016 Budget _ Balance Description Interest Rate @ 1/01/16 Principal Interest Total @ 12/31/16 (Term Seward Mountain Haven Bond 4.00%- 5.10% 23,250,000 865,000 1,083,538 1,948,538 22,385,000 2008 - 2033 Balance 2017 Budget Balance Description Interest Rate @ 1/01/17 Principal Interest Total @ 12/31/17 Terre Seward Mountain Haven Bond 4.00%- 5.10% 22,385,000 910,000 1,043,713 1,953,713 21,475,000 2001 - 2033 WO 5 WS (SMALL BOAT , ' ' BOR ENTERPRISE FUND :u•gete s "tatement of Revenues and Expenses and Change in Net Position For Fiscal Year 20I6 and 20I7 2014 2015 2016 2017 Actual Budget Budget Budget Operating revenue: Moorage I,622,680 I,637,350 I,645,000 I,7I0,52I Wharfage 30,232 48,000 48,000 48,000 Boat Lift Fees 110,659 112,000 90,000 117,325 Power Sales 390,587 400,000 360,000 365,000 Passenger Transit Fee 604,800 617,96I 625,000 630,000 Launch Fees 70,237 50,000 53,000 54,2I0 Rents and Leases 318,711 345,500 335,623 335,623 Miscellaneous 64,526 56,250 49,I00 49,7I7 Total operating revenue $3,212,432 $3267,061 $3,205,723 $3,310,396 Operating expense before depreciation: Salaries&Benefits I,I42,100 I,092,403 I,142,250 I,I45,250 Purchased Services 486,873 397,112 35I,600 386,700 Power for Resale 239,239 359,000 300,000 307,000 Supplies and Maintenance I24,I86 I48,000 I43,500 15I,000 General and Administrative 366,22I 260,558 233,699 239,208 Total operating expense: $2,358,619 $2,257,073 $2,17I,049 $2,229,158 Operating income before depreciation 853,813 1,009,988 I,034,674 1,081,238 Depreciation I,243,632(a; I,577,7I4 (b) I,277,537 (c) I,238,462 (d) Operating loss -$389,819 -$567,726 -$242,863 -$157,224 Non-operating revenue(expense) Interest,grants&other income I,I63,9I2 20,000 30,000 30,000 Interest&other expense -207,946 -268,823 -263,955 -250,987 Total non-operating revenue(expense) 955,966 -248,823 -233,955 -220,987 Income(loss)before transfers $566,I47 -$8I6,549 -$476,8I8 -$378211 Transfers in 24I,272 520,000 70,980 70,980 Capital contributions and special items 11,707,114 0 0 0 Transfers out -725,370 373,8I4 -365,340 -371,142 Change in net position $11,789,I63 $77,265 -$771,178 -$678,373 Beginning net position 23,367,302 35,I56,465 35,233,730 34,462,552 Ending net position $35,156,465 * $35233,730 $34,462,552 $33,784,179 * Ties to annual Comprehensive Annual Financial Report Of total depreciation expense, the following amounts were attributable to capital assets funded with capital contributions: (a) 622,174 or 58%;(b)$772,174 or 49%;(c)$954,484 or 60%;( d)$954,484 or 6I% 1 CITY OF SEWARD SMALL BOAT HARBOR ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 20I6 and 20I7 2015 2016 20I7 Budget Budget Budget Beginning Cash Balance at I/I/I5*: $I,08I,669 Cash is provided by(used for): Change in net position 77,265 -77I,I78 -678,373 Add expense items not affecting cash Depreciation I,577,7I4 I,277,537 I,238,462 Net cash provided by operations $I,654,979 $506,359 $560,089 Other sources (uses)of cash Debt principal payments -511,859 -522,052 (a) -501,I87 (b) Capital outlay -57,8I0 -I79,669 (c) -I94,603 (d) Net increase(decrease)in cash $I,085,310 -$195,362 -$135,701 Estimated ending cash balance: $2,166,979 $I,97I,6I7 $I,835,9I6 ° Ties to CAFR and includes only Harbor Enterprise Fund;excludes related capital projects (a)$522K=2000 Bond-$I90K;2005 Float Extension-$65K;2006 South Harbor Bond- $2I5K;USACE Loan- $24K and$27,698 is Travelift loan reimbursement to motor pool fund,maturing on January I,20I6. (b)$50I,I87K=2000 Bond-$200K;2005 Float Extension-$70K;2006 South Harbor Bond- $2I0K;USACE Loan- $2IK. (c) $62,200 Motor Pool contributions. $0 to MRRF.No equipment. (d)$56,500 Motor Pool contributions. $0 to MRRF.No equipment. Note:Capital Renew/Replace Fee estimated at$I00,000 in 20I6 and 20I7; directly to Harbor MRRF for capital. Z City of Seward 10/08/2015 at 11:51 AM Harbor Enterprise Fund Page: 1 Revenue Detail by Line Item For 9/30/2015 2016 2017 2013 2014 2015 Budget 2015-16 Budget 2016-17 Actual Actual Budget Request %Chg Request %Chg Revenues Land Rents&Leases 400,443 380,711 408,000 397,623 (2.54) 397,623 0.00 Land Lease Credits (62,887) (62,000) (62,500) (62,000) (0.80) (62,000) 0.00 Transient Moorage 564,711 603,812 574,350 585,000 1.85 570,160 (2.54) Moorage 1,016,836 1,018,868 1,063,000 1,060,000 (0.28) 1,140,361 7.58 Wharfage 66,540 30,232 48,000 48,000 0.00 48,000 0.00 Boat Lift Fees 107,198 110,659 112,000 90,000 (19.64) 117,325 30.36 Harbor Power Sales 330,574 320,767 400,000 360,000 (10.00) 365,000 1.39 Shower Fees 11,721 15,028 12,000 12,000 0.00 12,000 0.00 Fuel Pumping Fee 21,869 20,413 20,500 20,500 0.00 20,836 1.64 Waiting List Fees 8,411 7,497 7,000 7,700 10.00 7,885 2.40 Towing Fees 1,470 1,365 2,000 900 (55.00) 900 0.00 Pumping Boats 252 378 250 300 20.02 300 0.00 North Harbor Launch Fee 32,580 33,206 35,000 33,000 (5.71) 33,750 2.27 South Harbor Launch Fee 17,038 37,031 15,000 20,000 33.33 20,460 2.30 Labor&Services 4,069 8,038 11,500 5,500 (52.17) 5,596 1.75 Collection of Doubtful Accounts 1,587 10,988 1,000 1,200 20.00 1,200 0.00 Miscellaneous Revenue 1,155 819 2,000 1,000 (50.00) 1,000 0.00 EF Investment Interest 24,698 28,694 15,000 20,000 33.33 20,000 0.00 EF Penalties and Interest 10,666 10,206 5,000 10,000 100.00 10,000 0.00 Unrealized Gain on FV of Investments (24,266) 0 0 0 0.00 0 0.00 PERS On-behalf paid by SOA 83,767 158,044 0 0 0.00 0 0.00 State Grant Funds 8,271 0 0 0 0.00 0 0.00 Amortization of Contributions-in-Aid 841,066 0 1,237,484 945,240 (23.62) 945,240 0.00 Amortization of Bond Premiums 8,375 47,429 8,375 8,375 0.00 8,375 0.00 Total Revenues $3,476,144 $2,782,185 $3,914,959 $3,564,338 $ (1.23) $ 3,664,011 $ 47.15 3 City of Seward .un:10/08/2015 at 2:08 PM 11000 Harbor Enterprise Fund Page: 1 Expense Summary by Line Item For 9/30/2015 2016 2017 2013 2014 2015 Budget 2015-16 Budget 2016-17 Actual Actual Budget Request %Chg Request %Chg Expenditures/Expenses 11000 6000 Salaries 464,331 473,983 526,986 550,831 4.52 563,234 2.25 11000 6001 Overtime 20,396 23,137 42,519 43,555 2.44 44,601 2.40 11000 6002 Standby Time 12,570 13,269 12,116 12,430 2.59 12,729 2.41 11000 6100 Medicare 8,566 8,954 10,191 10,206 0.15 10,842 6.23 11000 6101 Unemployment Insurance 1,067 940 0 800 0.00 500 Q(37.50) 11000 6102 Workers'Compensation 29,536 34,222 32,683 33,626 2.89 32,641 (2.93) 11000 6200 Leave Time 59,399 56,928 62,345 66,720 7.02 70,122 5.10 11000 6201 Retirement Benefits 208,275 290,061 143,229 148,838 3.92 153,954 3.44 11000 6202 Health Insurance 196,416 240,606 262,334 275,244 4.92 286,240 4.00 11000 7001 Communications 8,723 11,536 12,000 12,000 0.00 12,000 0.00 11000 7002 Postage and Freight 6,377 4,201 10,750 10,500 (2.33) 10,500 0.00 11000 7003 Bank and Credit Card Fees 44,980 41,997 50,000 50,000 0.00 54,000 d 8.00 110007004 Insurance 76,769 79,040 53,500 51,600 (3.55) 82,700 60.27 11000 7006 Legal 8,820 15,045 10,000 10,000 0.00 10,0000.00 11000 7009 Contracted Services 82,420 85,099 135,862 118,000 (13.15) 119,000 a 0.85 11000 7011 Testing 0 857 0 0 0.00 1,000 0.00 11000 7015 Utilities 121,001 112,408 115,000 127,840 11.17 130,771 G 2.29 11000 7016 Heating Fuel 9,373 11,221 10,000 10,000 0.00 10,000 0.00 11000 7100 General Power for Resale 271,895 239,239 359,000 300,000 (16.43) 307,000 2.33 11000 7211 Gas&Lube 20,468 18,270 29,000 23,500 (18.97) 27,500 17.02 11000 7213 Safety Equipment 5,053 6,649 7,500 7,500 0.00 7,500 0.00 11000 7214 Janitorial Supplies 7,542 8,339 8,500 8,500 0.00 9,500 11.76 11000 7215 Operating Supplies 25,743 30,673 34,000 35,000 2.94 36,000 2.86 11000 7216 Maintenance&Repair 34,433 37,158 52,000 52,000 0.00 53,000 1.92 11000 7217 Small Tools&Equipment• 13,954 9,109-- - 17,000 17,000 0.00 17,500 2.94 11000 7300 Advertising 2,959 2,495 5,000 5,000 0.00 5,000 0.00 11000 7301 Subscriptions&Dues 903 1,025 1,500 1,500 0.00 1,500 0.00 11000 7302 Travel&Subsistence 11,577 9,393 10,000 10,000 0.00 10,000 0.00 11000 7303 Education&Training 2,555 1,019 4,000 4,000 0.00 4,000 0.00 11000 7304 Equipment Rent 0 690 500 0 (100.00) 0 0.00 11000 7321 Harbor General Indirect Costs 352,834 412,133 419,852 424,294 1.06 408,600 (3.70) 11000 7322 Harbor Admin Indirect Costs-'" -- -- 202,058'---274,203 280,707 438,081 56.06 449,972 2.71 11000 7323 SMIC General Indirect Costs 37,783 43,995 0 0 0.00 0 0.00 11000 7324 Gen Fund Indirect Costs 324,795 331,291 332,948 340,605 2.30 348,780 2.40 11000 7325 Harbor Internal Cost Allocation (591,241)- -__(770,499) (807,449) (1,006,581) 24.66 (1,002,144) (0.44) 11000 7330 P.I.L.T. 174,804 176,649 182,848 179,608 (1.77) 185,410 3.23 11000 7331 Reclass PILT to Transfer-Out (174,804) (176,649) (182,848) (179,608) (1.77) (185,410) 3.23 11000 7801 Contributions 0 87 0 0 0.00 0 0.00 11000 7808 Bad Debt Expense 36,095 12,034 10,000 13,300 33.00 10,000 (24.81) 11000 7810 Miscellaneous Expense 994 1,867 3,500 3,500 0.00 3,500 0.00 11000 7900 Depreciation Expense 1,392,277 0 1,577,714 1,277,537 (19.03) 1,238,462 (3.06) 11000 8011 Bonding Expense 0 48,369 0 0 0.00 0 0.00 11000 8012 Debt Service Interest Expense 287,762 131,114 268,823 263,955 (1.81) 250,987 (4.91) 11000 8014 Amortization of Bond Issue Costs 0 0 0 0 (100.00) 0 0.00 11000 8101 Infrastructure 0 0 0 0 0.00 0 0.00 11000 8104 Motor Pool Rent 57,810 60,477 57,810 62,200 7.59 55,500 (10.77) 11000 8300 Debt Service Principal 0 294,885 511,859 522,052 1.99 501,187 (4.00) Total Expenditures/Expenses $ 3,857,268 $ 2,707,519 $ 4,673,279 $ 4,335,133 $(109.59) 4,348,178 $ 55.52 t : 624eStt pawl• q0 R.td t1 #2q,lr13 w 2014- 0 4.td,000 anit,,, "1't,000 Daoi4- d3 t14,140 20141 ; 23,&s° �oI- g irl't,20� u:� ao 1 b '� J ,,000 %.. ?01/' il Run:10/08/2015 at 3:35 PM City of Seward Revenue and Expenses by Department Harbor Enterprise Fund Harbor-General For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 11000 2000 5000 Land Rents&Leases 0 276,443 287,711 282,000 273,623 0.03 273,623 11000 2000 5001 Land Lease Credits 0 (887) 0 (2,128) 0 1.00 0 11000 2000 5150 Shower Fees 0 11,721 15,028 12,000 12,000 0.00 12,000 11000 2000 5157 North Harbor Launch Fee 0 32,580 33,206 35,000 33,000 0.06 33,750 11000 2000 5158 South Harbor Launch Fee 0 17,038 37,031 15,000 20,000 (0.33) 20,460 11000 2000 5800 Labor&Services 0 735 2,577 1,000 1,000 0.00 1,000 11000 2000 5899 Miscellaneous Revenue 0 1,155 789 2,000 1,000 0.50 1,000 11000 2000 5901 EF Investment Interest 0 24,698 22,107 15,000 20,000 (0.33) 20,000 11000 2000 5905 EF Penalties and Interest 0 230 0 0 0 0.00 0 11000 2000 5911 Unrealized Gain on FV of Investments 0 (24,266) 0 0 0 0.00 0 11000 2000 5920 PERS On-behalf paid by SOA 0 83,767 158,044 149,070 0 1.00 0 11000 2000 5922 State Grant Funds 0 8,271 0 0 0 0.00 0 11000 2000 5940 Amortization of Contributions-in-Aid 0 577 0 577 0 1.00 0 Total Revenues $ 0 $ 432,062 $ 556,493 $ 509,519 $ 360,623 $ 0.29 $ 361,833 Expenditures Personnel Costs: 11000 2000 6000 Salaries 0 98,849 123,701 78,684 82,281 0.05 84,250 11000 2000 6001 Overtime 0 7,093 4,092 6,480 6,298 (0.03) 6,449 11000 2000 6002 Standby Time 0 9,849 12,434 3,264 7,223 1.21 7,397 11000 2000 6100 Medicare 0 2,370 2,889 1,776 2,058 0.16 2,108 11000 2000 6101 Unemployment Insurance 0 1,067 142 0 0 0.00 0 11000 2000 6102 Workers'Compensation 0 7,542 12,542 4,548 8,180 0.80 8,987 11000 2000 6200 Leave Time 0 41,575 39,448 40,188 38,767 (0.04) 39,695 11000 2000 6201 Retirement Benefits 0 22,016 37,036 17,991 7,371 (0.59) 7,548 11000 2000 6202 Health Insurance 0 49,505 74,210 96,859 59,755 (0.38) 62,139 Total Personnel Costs: $ 0 $ 239,866 $ 306,494 $ 249,790 $ 211,933 $ (0.15) $ 218,573 Non-Personnel Costs: 11000 2000 7001 Communications 0 0 665 0 0 0.00 0 11000 2000 7002 Postage and Freight 0 3,552 3,102 6,000 6,000 0.00 6,000 11000 2000 7003 Bank and Credit Card Fees 0 0 (3,252) 0 0 0.00 0 11000 2000 7004 Insurance 0 4,078 6,178 5,000 6,300 0.26 7,600 11000 2000 7009 Contracted Services 0 44,949 59,309 43,000 70,000 0.63 70,000 11000 2000 7011 Testing 0 0 857 0 0 0.00 1,000 11000 2000 7015 Utilities 0 55,084 62,854 72,500 74,200 0.02 76,000 11000 2000 7016 Heating Fuel 0 9,373 11,221 10,000 10,000 0.00 10,000 11000 2000 7211 Gas&Lube 0 16,247 15,526 22,000 18,000 (0.18) 22,000 11000 2000 7213 Safety Equipment 0 5,053 6,451 7,500 7,500 0.00 7,500 11000 2000 7214 Janitorial Supplies 0 7,542 8,339 8,500 8,500 0.00 9,500 11000 2000 7215 Operating Supplies 0 4,558 11,831 12,000 12,000 0.00 12,000 11000 2000 7216 Maintenance&Repair 0 15,891 17,402 17,000 17,000 0.00 18,000 11000 2000 7217 Small Tools&Equipment 0 5,616 4,027 7,000 7,000 0.00 7,000 11000 2000 7300 Advertising 0 420 1,131 3,000 3,000 0.00 3,000 11000 2000 7302 Travel&Subsistence 0 0 2,049 0 0 0.00 0 11000 2000 7303 Education&Training 0 0 56 0 0 0.00 0 11000 2000 7325 Harbor Internal Cost Allocation 0 (376,969) (462,673) (475,015) (495,245) 0.04 (476,927) 11000 2000 7330 P.I.L.T. 0 5,056 7,090 5,200 5,360 0.03 5,456 11000 2000 7331 Reclass PILT to Transfer-Out 0 (5,056) (7,090) (5,200) (5,360) 0.03 (5,456) 11000 2000 7810 Miscellaneous Expense 0 1,238 1,715 2,000 2,000 0.00 2,000 11000 2000 7900 Depreciation Expense 0 27,588 0 27,588 27,588 0.00 0 11000 2000 8011 Bonding Expense 0 0 1 0 0 0.00 0 11000 2000 8104 Motor Pool Rent 0 20,210 23,343 20,210 24,000 0.19 23,000 Total Non-Personnel Costs: $ 0 $ (155,570) $ (229,868) $ (211,717) $ (202,157) $ (0.05) $ (202,327) Total Expenditures $ 0 $ 84,296 $ 76,626 $ 38,073 $ 9,776 $ (0.74) $ 16,246 5 Run:10/08/2015 at 3:35 PM City of Seward - Revenue and Expenses by Department Harbor Enterprise Fund Harbor•Administration For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 11000 2001 5901 EF Investment Interest 0 0 - 6,587 0 0 0.00 0 11000 2001 5940 Amortization of Contributions-in-Aid 0 0 0 8,667 0 1.00 0 Total Revenues $ 0 $ 0 $ 6,587 $ 8,667 $ 0 $ 1.00 $ 0 Expenditures Personnel Costs: 11000 2001 6000 Salaries 0 108,469 122,482 67,248 202,830 2.02 206,905 11000 2001 6001 Overtime 0 4,790 7,897 16,140 23,289 0.44 23,850 11000 2001 6100 Medicare 0 1,935 2,097 1,680 3,428 1.04 3,522 11000 2001 6101 Unemployment Insurance 0 0 798 0 800 0.00 500 11000 2001 6102 Workers'Compensation 0 1,369 1,721 1,524 1,786 0.17 1,830 11000 2001 6200 Leave Time 0 17,824 17,480 19,800 22,016 0.11 24,227 11000 2001 6201 Retirement Benefits 0 20,227 15,602 15,004 12,523 (0.17) 12,823 11000 2001 6202 Health Insurance 0 45,080 59,530 79,619 106,624 0.34 110,889 Total Personnel Costs: $ 0 $ 199,694 $ 227,607 $ 201,015 $ 373,296 $ 0.86 $ 384,546 Non-Personnel Costs: 11000 2001 7001 Communications 0 8,723 10,871 12,000 12,000 0.00 12,000 11000 2001 7002 Postage and Freight 0 598 296 1,300 1,300 0.00 1,300 11000 2001 7003 Bank and Credit Card Fees 0 44,980 45,248 49,000 50,000 0.02 54,000 11000 2001 7004 Insurance 0 2,137 3,680 5,000 3,800 (0.24) 3,800 11000 2001 7006 Legal 0 8,820 15,045 10,000 10,000 0.00 10,000 11000 2001 7009 Contracted Services 0 5,606 4,577 5,000 20,000 3.00 20,000 11000 2001 7211 Gas&Lube 0 1,598 850 4,000 3,000 (0.25) 3,000 11000 2001 7213 Safety Equipment 0 0 198 0 0 0.00 0 11000 2001 7215 Operating Supplies 0 12,283 11,174 9,000 10,000 0.11 11,000 11000 2001 7216 Maintenance&Repair 0 544 472 500 500 0.00 500 11000 2001 7217 Small Tools&Equipment 0 2,592 1,513 3,500 3,500 0.00 3,500 11000 2001 7300 Advertising 0 2,539 1,364 2,000 2,000 0.00 2,000 11000 2001 7301 Subscriptions&Dues 0 903 1,025 1,500 1,500 0.00 1,500 11000 2001 7302 Travel&Subsistence 0 11,516 7,344 10,000 10,000 0.00 10,000 11000 2001 7303 Education&Training 0 2,555 963 4,000 4,000 0.00 4,000 11000 2001 7304 Equipment Rent 0 0 690 500 0 (1.00) 0 11000 2001 7325 Harbor Internal Cost Allocation 0 (214,272) (307,826) (316,029) (511,336) 0.62 (525,217) 11000 2001 7801 Contributions 0 0 87 0 0 0.00 0 11000 2001 7810 Miscellaneous Expense 0 404 312 1,500 1,500 0.00 1,500 11000 2001 7900 Depreciation Expense 0 2,821 0 11,487 11,487 0.00 0 11000 2001 8104 Motor Pool Rent 0 5,600 5,133 5,600 5,700 0.02 0 Total Non-Personnel Costs: $ 0 $ (100,053) $ (196,984) $ (180,142) $ (361,049) $ 1.00 $ (387,117) Total Expenditures $ 0 $ 99,641 $ 30,623 $ 20,873 $ 12,247 $ (0.41) $ (2,571) c Run:10/08/2015 at 3:35 PM City of Seward Revenue and Expenses by Department Harbor Enterprise Fund Harbor-Float System For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 11000 2002 5100 Transient Moorage 0 366,113 352,801 358,000 370,000 (0.03) 350,000 11000 2002 5101 Moorage 0 1,016,836 1,018,868 1,036,000 1,060,000 (0.02) 1,140,361 11000 2002 5153 Fuel Pumping Fee 0 16,363 14,818 14,000 14,000 0.00 14,336 11000 2002 5154 Waiting List Fees 0 8,411 7,497 7,000 7,700 (0.10) 7,885 11000 2002 5155 Towing Fees 0 420 893 2,000 500 0.75 500 11000 2002 5156 Pumping Boats 0 252 347 250 300 (0.20) 300 11000 2002 5800 Labor&Services 0 1,995 3,934 10,000 4,000 0.60 4,096 11000 2002 5905 EF Penalties and Interest 0 10,436 10,206 5,000 10,000 (1.00) 10,000 11000 2002 5940 Amortization of Contributions-in-Aid 0 519,903 0 624,653 624,653 0.00 624,653 Total Revenues $ 0 $ 1,940,729 $ 1,409,364 $2,056,903 $2,091,153 $ (0.02) $2,152,131 Expenditures Personnel Costs: 11000 2002 6000 Salaries 0 166,155 144,657 250,272 176,490 (0.29) 180,714 11000 2002 6001 Overtime 0 5,702 7,401 13,848 9,968 (0.28) 10,207 11000 2002 6002 Standby Time 0 2,721 835 8,316 5,207 (0.37) 5,332 11000 2002 6100 Medicare 0 2,802 2,429 4,428 3,403 (0.23) 3,484 11000 2002 6102 Workers'Compensation 0 14,796 13,256 17,976 16,770 (0.07) 14,250 11000 2002 6200 Leave Time 0 0 0 0 4,128 0.00 4,226 11000 2002 6201 Retirement Benefits 0 23,666 14,830 19,924 9,447 (0.53) 9,673 11000 2002 6202 Health Insurance 0 63,396 69,158 57,896 70,225 0.21 73,028 Total Personnel Costs: $ 0 $ 279,238 $ 252,566 $ 372,660 $ 295,638 $ (0.21) $ 300,914 Non-Personnel Costs: 11000 2002 7002 Postage and Freight 0 1,582 155 1,500 1,250 (0.17) 1,250 11000 2002 7004 Insurance 0 60,845 59,138 25,000 30,000 0.20 60,000 11000 2002 7009 Contracted Services 0 7,146 12,067 10,000 10,000 0.00 11,000 11000 2002 7015 Utilities 0 58,912 42,939 36,000 47,140 0.31 48,271 11000 2002 7215 Operating Supplies 0 3,823 2,442 6,000 6,000 0.00 6,000 11000 2002 7216 Maintenance&Repair 0 15,345 6,691 15,000 15,000 0.00 15,000 11000 2002 7217 Small Tools&Equipment 0 2,026 1,648 5,000 5,000 0.00 5,000 11000 2002 7321 Harbor General Indirect Costs 0 246,013 280,409 280,409 280,804 0.00 270,418 11000 2002 7322 Harbor Admin Indirect Costs 0 140,885 186,557 186,557 289,928 0.55 297,798 11000 2002 7324 Gen Fund Indirect Costs 0 197,411 201,359 201,359 207,021 0.03 211,990 11000 2002 7330 P.I.L.T. 0 112,831 111,933 114,180 116,520 0.02 119,228 11000 2002 7331 Reclass PILT to Transfer-Out 0 (112,831) (111,933) (114,180) (116,520) 0.02 (119,228) 11000 2002 7808 Bad Debt Expense 0 31,295 10,098 8,000 11,000 0.38 8,000 11000 2002 7900 Depreciation Expense 0 926,784 0 1,093,295 1,200,000 0.10 1,200,000 Total Non-Personnel Costs: $ 0 $ 1,692,067 $ 803,503 $ 1,868,120 $2,103,143 $ 0.13 $2,134,727 Total Expenditures $ 0 $1,971,305 $1,056,069 $2,240,780 $2,398,781 $ 0.07 $2,435,641 Run:10/08/2015 at 3:35 PM City of Seward , Revenue and Expenses by Department Harbor Enterprise Fund Harbor-Wharves&Docks For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 11000 2003 5000 Land Rents&Leases 0 124,000 93,000 124,000 124,000 0.00 124,000 11000 2003 5001 Land Lease Credits 0 (62,000) (62,000) (62,000) (62,000) 0.00 (62,000) 11000 2003 5100 Transient Moorage 0 198,598 251,011 207,350 215,000 (0.04) 220,160 11000 2003 5102 Wharfage 0 66,540 30,232 48,000 48,000 0.00 48,000 11000 2003 5153 Fuel Pumping Fee 0 5,506 5,595 6,500 6,500 0.00 6,500 11000 2003 5155 Towing Fees 0 158 0 0 0 0.00 0 11000 2003 5890 Collection of Doubtful Accounts 0 1,587 10,988 1,000 1,200 (0.20) 1,200 11000 2003 5940 Amortization of Contributions-in-Aid 0 308,200 0 308,200 308,200 0.00 308,200 11000 2003 5941 Amortization of Bond Premiums 0 8,375 47,429 8,375 8,375 0.00 8,375 Total Revenues $ 0 $ 650,964 $ 376,255 $ 641,425 $ 649,275 $ (0.01) $ 654,435 Expenditures Personnel Costs: 11000 2003 6000 Salaries 0 14,870 15,139 27,552 18,584 (0.33) 19,029 11000 2003 6001 Overtime 0 408 471 780 750 (0.04) 767 11000 2003 6100 Medicare 0 225 370 444 0 (1.00) 414 11000 2003 6102 Workers'Compensation 0 563 969 1,692 1,220 (0.28) 1,344 11000 2003 6200 Leave Time 0 0 0 0 462 0.00 473 11000 2003 6201 Retirement Benefits 0 1,959 1,622 2,224 939 (0.58) 961 11000 2003 6202 Health Insurance 0 6,668 6,138 7,166 7,451 0.04 7,749 Total Personnel Costs: $ 0 $ 24,693 $ 24,709 $ 39,858 $ 29,406 $ (0.26) $ 30,737 Non-Personnel Costs: 11000 2003 7002 Postage and Freight 0 0 48 250 250 0.00 250 11000 2003 7004 Insurance 0 4,649 4,879 5,000 5,200 0.04 5,000 11000 2003 7009 Contracted Services 0 9,060 1,000 1,000 1,000 0.00 1,000 11000 2003 7015 Utilities 0 7,005 6,615 6,500 6,500 0.00 6,500 11000 2003 7215 Operating Supplies 0 0 617 1,000 1,000 0.00 1,000 11000 2003 7216 Maintenance&Repair 0 659 4,060 7,500 7,500 0.00 7,500 11000 2003 7217 Small Tools&Equipment 0 0 749 1,000 1,000 0.00 1,000 11000 2003 7321 Harbor General Indirect Costs 0 38,844 52,830 52,830 57,150 0.08 55,036 11000 2003 7322 Harbor Admin Indirect Costs 0 22,245 35,158 35,158 59,007 0.68 60,609 11000 2003 7324 Gen Fund Indirect Costs 0 67,297 68,643 68,643 70,573 0.03 72,267 11000 2003 7330 P.I.L.T. 0 21,664 22,947 19,588 21,656 0.11 22,068 11000 2003 7331 Reclass PILT to Transfer-Out 0 (21,664) (22,947) (19,588) (21,656) 0.11 (22,068) 11000 2003 7808 Bad Debt Expense 0 2,397 1,936 2,000 2,300 0.15 2,000 11000 2003 7900 Depreciation Expense 0 408,219 0 408,219 0 (1.00) 0 Total Non-Personnel Costs: $ 0 $ 560,375 $ 176,535 $ 589,100 $ 211,480 $ (0.64) $ 212,162 Total Expenditures $ 0 $ 585,068 $ 201,244 $ 628,958 $ 240,886 $ (0.62) $ 242,899 g Run:10/08/2015 at 3:35 PM City of Seward Revenue and Expenses by Department Harbor Enterprise Fund Harbor-50-Ton Boat Lift For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 11000 2004 5103 Boat Lift Fees 0 107,198 110,659 112,000 90,000 0.20 117,325 11000 2004 5155 Towing Fees 0 893 473 0 400 0.00 400 11000 2004 5156 Pumping Boats 0 0 32 0 0 0.00 0 11000 2004 5800 Labor&Services 0 1,208 1,412 500 500 0.00 500 Total Revenues $ 0 $ 109,299 $ 112,576 $ 112,500 $ 90,900 $ 0.19 $ 118,225 Expenditures Personnel Costs: 11000 2004 6000 Salaries 0 38,491 29,487 34,668 30,036 (0.13) 30,755 11000 2004 6001 Overtime 0 517 1,697 1,584 1,364 (0.14) 1,397 11000 2004 6100 Medicare 0 566 464 564 508 (0.10) 507 11000 2004 6102 Workers'Compensation 0 3,498 3,454 3,084 3,320 0.08 3,649 11000 2004 6200 Leave Time 0 0 0 0 495 0.00 629 11000 2004 6201 Retirement Benefits 0 5,398 2,916 3,202 1,549 (0.52) 1,533 11000 2004 6202 Health Insurance 0 15,475 13,504 10,794 13,280 0.23 13,810 Total Personnel Costs: $ 0 $ 63,945 $ 51,522 $ 53,896 $ 50,552 $ (0.06) $ 52,280 Non-Personnel Costs: 11000 2004 7002 Postage and Freight 0 473 516 1,200 1,200 0.00 1,200 11000 2004 7004 Insurance 0 4,031 4,226 4,300 4,300 0.00 4,300 11000 2004 7009 Contracted Services 0 2,362 1,780 2,000 2,000 0.00 2,000 11000 2004 7211 Gas&Lube 0 2,623 1,895 3,000 2,500 (0.17) 2,500 11000 2004 7215 Operating Supplies 0 33 348 1,000 1,000 0.00 1,000 11000 2004 7216 Maintenance&Repair 0 1,855 2,569 8,500 8,500 0.00 8,500 11000 2004 7217 Small Tools&Equipment 0 0 600 500 500 0.00 500 11000 2004 7302 Travel&Subsistence 0 61 0 0 0 0.00 0 11000 2004 7321 Harbor General Indirect Costs 0 21,580 18,514 18,514 22,430 0.21 21,600 11000 2004 7322 Harbor Admin Indirect Costs 0 12,358 12,317 12,317 23,159 0.88 23,787 11000 2004 7324 Gen Fund Indirect Costs 0 24,360 24,847 24,847 25,545 0.03 26,158 11000 2004 7330 P.I.L.T. 0 8,744 9,006 9,000 7,272 (0.19) 9,458 11000 2004 7331 Reclass PILT to Transfer-Out 0 (8,744) (9,006) (9,000) (7,272) (0.19) (9,458) 11000 2004 7900 Depreciation Expense 0 13,196 0 13,196 13,196 0.00 13,196 11000 2004 8104 Motor Pool Rent 0 32,000 32,000 32,000 32,500 0.02 32,500 Total Non-Personnel Costs: $ 0 $ 114,932 $ 99,612 $ 121,374 $ 136,830 $ 0.13 $ 137,241 Total Expenditures $ 0 $ 178,877 $ 151,134 $ 175,270 $ 187,382 $ 0.07 $ 189,521 q Run:10/08/2015 at 3:35 PM City of Seward . Revenue and Expenses by Department Harbor Enterprise Fund Harbor-Electrical System For 12/3112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 11000 2005 5105 Harbor Power Sales 0 330,574 320,767 360,000 360,000 0.00 365,000 11000 2005 5800 Labor&Services 0 131 115 0 0 0.00 0 11000 2005 5899 Miscellaneous Revenue 0 0 30 0 0 0.00 0 11000 2005 5940 Amortization of Contributions-in-Aid 0 12,387 0 12,387 12,387 0.00 12,387 Total Revenues $ 0 $ 343,092 $ 320,912 $ 372,387 $ 372,387 $ 0.00 $ 377,387 Expenditures Personnel Costs: 11000 2005 6000 Salaries 0 37,496 38,516 56,184 40,610 (0.28) 41,581 11000 2005 6001 Overtime 0 1,885 1,579 1,848 1,886 0.02 1,931 11000 2005 6100 Medicare 0 670 706 924 809 (0.12) 807 11000 2005 6102 Workers'Compensation 0 1,768 2,281 2,604 2,350 (0.10) 2,581 11000 2005 6200 Leave Time 0 0 0 0 852 0.00 872 11000 2005 6201 Retirement Benefits 0 5,003 4,038 4,575 2,005 (0.56) 2,054 11000 2005 6202 Health Insurance 0 16,291 18,065 12,531 17,909 0.43 18,625 Total Personnel Costs: $ 0 $ 63,113 $ 65,185 $ 78,666 $ 66,421 $ (0.16) $ 68,451 Non-Personnel Costs: 11000 2005 7002 Postage and Freight 0 172 84 500 500 0.00 500 11000 2005 7004 Insurance 0 1,028 938 2,000 2,000 0.00 2,000 11000 2005 7009 Contracted Services 0 13,297 6,366 15,000 15,000 0.00 15,000 11000 2005 7100 General Power for Resale 0 271,895 239,239 349,000 300,000 (0.14) 307,000 11000 2005 7215 Operating Supplies 0 5,046 4,261 5,000 5,000 0.00 5,000 11000 2005 7216 Maintenance&Repair 0 139 5,964 3,500 3,500 0.00 3,500 11000 2005 7217 Small Tools&Equipment 0 3,719 572 0 0 0.00 500 11000 2005 7321 Harbor General Indirect Costs 0 46,397 60,380 60,380 63,910 0.06 61,546 11000 2005 7322 Harbor Admin Indirect Costs 0 26,570 40,171 40,171 65,987 0.64 67,778 11000 2005 7323 SMIC General Indirect Costs 0 37,783 43,995 43,995 0 (1.00) 0 11000 2005 7324 Gen Fund Indirect Costs 0 35,727 36,442 36,442 37,466 0.03 38,365 11000 2005 7330 P.I.L.T. 0 26,508 25,673 28,800 28,800 0.00 29,200 11000 2005 7331 Reclass PILI to Transfer-Out 0 (26,508) (25,673) (28,800) (28,800) 0.00 (29,200) 11000 2005 7808 Bad Debt Expense 0 2,403 0 0 0 0.00 0 11000 2005 7810 Miscellaneous Expense 0 (648) (160) 0 0 0.00 0 11000 2005 7900 Depreciation Expense 0 13,669 0 25,266 25,266 0.00 25,266 Total Non-Personnel Costs: $ 0 $ 457,197 $ 438,252 $ 581,254 $ 518,629 $ (0.11) $ 526,455 Total Expenditures $ 0 $ 520,310 $ 503,437 $ 659,920 $ 585,050 $ (0.11) $ 594,906 la Run:10/08/2015 at 3:35 PM City of Seward Revenue and Expenses by Department Harbor Enterprise Fund Harbor- Debt Service For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues Total Revenues $ 0 $ 0 $ 0 $ 0 $ 0 $ 0.00 $ 0 Expenditures Personnel Costs: 11000 2090 6201 Retirement Benefits 0 130,007 214,018 225,026 115,004 (0.49) 119,362 Total Personnel Costs: $ 0 $ 130,007 $ 214,018 $ 225,026 $ 115,004 $ (0.49) $ 119,362 Non-Personnel Costs: 11000 2090 8011 Bonding Expense 0 0 48,369 0 0 0.00 0 11000 2090 8012 Debt Service Interest Expense 0 287,762 131,114 262,201 263,955 0.01 250,987 11000 2090 8014 Amortization of Bond Issue Costs 0 0 0 5,929 0 (1.00) 0 11000 2090 8300 Debt Service Principal 0 0 294,885 469,885 522,052 0.11 501,187 Total Non-Personnel Costs: $ 0 $ 287,762 $ 474,368 $ 738,015 $ 786,007 $ 0.07 $ 752,174 Total Expenditures $ 0 $ 417,769 $ 688,386 $ 963,041 $ 901,011 $ (0.06) $ 871,536 If CITY OF SEWARD SMALL BOAT HARBOR ENTERPRISE FUND Budgeted Interfund Transfers Fiscal Year 2016 and 2017 2016 2017 Transfers- Transfers- Transfers- Transfers- In Out In Out CPV Fund for USACE Loan 70,980 70,980 General Fund: One-half of land rents and leases 167,812 167,812 Federal and state lobbying 17,920 17,920 Payments-in-Lieu-of-Tax 179,608 185,410 $70,980 $365,340 $70,980 $371,142 No transfers to MRRF in 2016 and 2017. 11 CITY OF SEWARD SMALL BOAT HARBOR ENTERPRISE FUND -- 2016 and 2017 Debt Service Schedule Balance 2016 Budget Balance Description Interest Rate @ 1/01/16 Principal Interest Retirement Total @ 12/31/16 Term 2007 Ref 2000 [-Float&Cleaning Stations Bond 4.85%-5.5% 1,265,000 190,000 55,794 245,794 1,075,000 2000- 10/2021 2014 Ref 2005 Float Extension Bond-Step 1 1.25%-5.00% 830,000 65,000 37,613 102,613 765,000 2005- 12/2025 Motor Pool 50-Ton Lift Loan 5.50% 27,698 27,698 1,523 29,221 0 2006-01/2016 2014 Ref 2006 South Harbor Bond 3.00%-4.00% 2,790,000 215,000 122,400 337,400 2,575,000 2006-06/2026 US Army Corps Breakwater Loan (estimated) 4.25% 1,201,196 24,354 46,625 70,980 1,176,842 2016-2045 PERS Past Service Cost n/a n/a n/a 115,004 115,004 n/a 2039 Totals: $6,113,894 $522,052 $263,955 $115,004 $901,011 $4,415,000 Balance 2017 Budget Balance Description Interest Rate @ 1/01/17 Principal Interest Retirement Total @ 12/31/17 Term 2007 Ref 2000 E-Float&Cleaning Stations Bond 4.85%-5.5% 1,075,000 200,000 46,294 246,294 875,000 2000- 10/2021 2014 Ref 2005 Float Extension Bond-Step 1 1.25%-5.00% 765,000 70,000 36,800 106,800 695,000 2005-12/2025 2014 Ref 2006 South Harbor Bond 3.00%-4.00% 2,575,000 210,000 118,100 328,100 2,365,000 2006-06/2026 US Army Corps Breakwater Loan (estimated) 4.25% 1,176,842 21,187 49,793 70,980 1,155,655 2016 2045-) PERS Past Service Cost n/a n/a n/a 119,362 119,362 n/a 2039 Totals: $5,591,842 $501,187 $250,987 $119,362 $871,536 $3,935,000 SMIC ENTERPRISE FUND Budgeted Statement of Revenues and Expenses and Change in Net Position For Fiscal Year 20I6 and 20I7 20I4 20I5 2016 20I7 Actual* Budget Budget Budget Operating revenue: Moorage 6,763 3,000 3,000 3,000 Wharfage 5,995 4,250 6,250 6,250 Boat Lift Fees I33,949 I00,000 I40,000 I40,000 Power Sales 45,864 36,000 40,000 40,960 Storage I07,481 110,000 115,000 I I5,000 Rents and Leases 156,I95 113,000 I56,950 152,707 Miscellaneous 13,546 9,000 12,000 12,I90 Total operating revenue: $469,793 $375,250 $473200 $470,I07 Operating expense before depreciation: Salaries&Benefits 110,734 94,469 81,569 75,429 Purchased Services 106,219 I30,000 9I,900 I I2,524 Supplies and Maintenance 65,748 53,500 56,500 53,500 General and Administrative I28,589 177,148 199,227 200,933 Total operating expense: $411,290 $455,117 $429,I96 $442,386 Operating income before depreciation 58,503 (79,867) 44,004 27,721 Depreciation 602,368 (a) I,I40,259 (b) 1,140,259 (c) 1,140,259 (d) Operating loss (543,865) (1,220,126) (1,096,255) (I,I12,538) Non-operating revenue(expense) Investment income and other 7,145 0 0 0 Interest expense 0 0 0 0 Total non-operating revenue(expense) 7,145 0 0 0 Income(loss)before contributions&transfers (536,720) (I,220,126) (I,096,255) (1,1I2,538) Transfers in 350,000 27,520 206,783 231,037 Capital contributions 1,73I,339 0 0 0 Transfers out (IO2,562) (94,580) (I03,775) (10I,746) Change in net position $1,442,057 ($1,287,I86) ($993,247) ($983,247) Beginning net position $26,I25,284 $27,567,34I $26,280,I55 $25,286,908 Ending net position $27,567,34I * $26,280,I55 $25,286,908 $24,303,662 * Ties to annual Comprehensive Annual Financial Report Ili • CITY OF SEWARD SMIC ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 20I6 and 20I7 20I5 20I6 20I7 Budget Budget Budget Beginning Cash Balance at I/I/I5 *: $I38,956 Cash is provided by (used for): Change in Net Position (I,287,I86) (993,247) (983,247) Other Uses - Debt Principal -I47,0I2 -I47,0I2 Add expense items not affecting cash Depreciation 1,140,259 1,140,259 1,140,259 Net increase(decrease) in cash (I46,927) - I0,000 Estimated ending cash balance: -$7,97I -$7,97I $2,029 ° Ties to CAFR City of Seward is 10/08/2015 at 11:51 AM SMIC Enterprise Fund Page: 2 Revenue Detail by Line Item For 9/30/2015 2016 2017 2013 2014 2015 Budget 2015-16 Budget 2016-17 Actual Actual Budget Request %Chg Request %Chg Revenues Insurance Recovery 0 5,520 0 0 0.00 0 0.00 Land Rents&Leases 142,883 156,195 113,000 156,950 38.89 152,707 (2.70) Land Lease Credits 0 0 0 0 0.00 0 0.00 Moorage 995 6,763 3,000 3,000 0.00 3,000 0.00 Wharfage 10,975 5,995 4,250 6,250 47.06 6,250 0.00 Boat Lift Fees 105,453 133,949 100,000 140,000 40.00 140,000 0.00 Storage Fees 91,128 107,481 110,000 115,000 4.55 115,000 0.00 SMIC Power Sales 36,892 45,864 36,000 40,000 11.11 40,960 2.40 Washdown Pad Fees 0 7,956 5,000 8,000 60.00 8,190 2.38 Fuel Pumping Fee 2,506 4,698 3,000 3,000 0.00 3,000 0.00 Labor&Services 1,122 892 1,000 1,000 0.00 1,000 0.00 EF Investment Interest 1,158 1,497 0 0 0.00 0 0.00 EF Penalties and Interest 109 128 0 0 0.00 0 0.00 Gain on Sale of Fixed Assets 0 282,970 0 0 0.00 0 0.00 Unrealized Gain on FV of Investments (1,066) 0 0 0 0.00 0 0.00 Amortization of Contributions-in-Aid 482,529 0 1,053,048 1,017,529 (3.37) 1,020,529 0.29 Total Revenues $ 874,684 $ 759,908 $ 1,428,298 $ 1,490,729 $ 198.24 $ 1,490,636 $ 2.37 1(o City of Seward .un:10/08/2015 at 4:01 PM 12000-SMIC Enterprise Fund Page: 1 Expense Summary by Line Item For 12/31/2014 2016 2017 2013 2014 2015 Budget 2015-16 Budget 2016-17 Actual Actual Budget Request %Chg Request %Chg Expenditures/Expenses 12000 6000 Salaries 0 54,443 61,176 52,299 (14.51) 53,772 2.82 12000 6001 Overtime 0 2,716 3,168 3,278 3.47 3,357 2.41 12000 6002 Standby Time 0 59 0 0 0.00 0 0.00 12000 6100 Medicare 0 854 996 891 (10.54) 904 1.46 12000 6102 Workers'Compensation 0 5,105 4,860 5,430 11.73 4,167 (23.26) 12000 6201 Retirement Benefits 0 4,965 2,268 1,795 (20.86) 1,272 (29.14) 12000 6202 Health Insurance 0 22,590 11,496 17,876 55.50 11,954 (33.13) 12000 7001 Communications 0 0 500 500 0.00 500 0.00 12000 7002 Postage and Freight 0 1,630 5,500 5,500 0.00 5,500 0.00 12000 7004 Insurance 0 6,559 8,400 8,900 5.95 14,400 61.80 12000 7006 Legal 0 6,326 0 0 0.00 10,000 0.00 12000 7009 Contracted Services 0 15,607 50,000 30,000 (40.00) 30,000 0.00 12000 7015 Utilities 0 13,666 15,000 15,000 0.00 15,000 0.00 12000 7016 Heating Fuel 0 3,524 6,000 6,000 0.00 5,000 (16.67) 12000 7100 General Power for Resale 0 22,283 22,000 26,000 18.18 26,624 2.40 12000 7102 Power Fuel Costs 0 0 0 0 0.00 2,500 0.00 12000 7211 Gas&Lube 0 11,575 10,000 10,000 0.00 10,000 0.00 12000 7215 Operating Supplies 0 2,867 6,000 6,000 0.00 6,000 0.00 12000 7216 Maintenance&Repair 0 20,908 36,000 36,000 0.00 36,000 0.00 12000 7217 Small Tools&Equipment 0 3,043 1,500 1,500 0.00 1,500 0.00 12000 7300 Advertising 0 3,135 4,000 3,000 (25.00) 3,000 0.00 12000 7302 Travel&Subsistence 0 0 100 0 (100.00) 0 0.00 12000 7321 Harbor General Indirect Costs 0 24,135 50,540 53,291 5.44 51,321 (3.70) 12000 7322 Harbor Admin Indirect Costs 0 12,214 33,623 55,024 63.65 56,517 2.71 12000 7323 SMIC General Indirect Costs 0 70,322 81,884 111,978 36.75 136,749 22.12 12000 7324 Gen Fund Indirect Costs 0 86,688 88,421 90,912 2.82 93,095 2.40 12000 7325 Harbor Internal Cost Allocation 0 (108,105) (125,878) (111,978) (11.04) (136,749) 22.12 12000 7330 P.I.L.T. 0 19,926 20,420 25,300 23.90 25,392 0.36 12000 7331 Reclass PILT to Transfer-Out 0 (19,926) (20,420) (25,300) 23.90 (25,392) 0.36 12000 7808 Bad Debt Expense 0 10,050 4,000 0 (100.00) 0 0.00 12000 7810 Miscellaneous Expense 0 350 0 0 0.00 0 0.00 12000 7900 Depreciation Expense 0 601,831 1,141,364 1,140,259 (0.10) 1,140,259 0.00 12000 8103 Capital Equipment 0 0 1,441,087 0 (100.00) 0 0.00 12000 8300 Debt Service Principal 0 0 0 147,012 0.00 147,012 0.00 Total Expenditures/Expenses $ 0 $ 899,340 $ 2,964,005 $ 1,716,467 $(170.76 1,729,654 $ 15.06 • I �' Run:10/08/2015 at 4:01 PM City of Seward Revenue and Expenses by Department • SMIC Enterprise Fund SMIC-General For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 12000 2500 5000 Land Rents&Leases 0 32,149 44,221 0 44,243 0.00 40,000 12000 2500 5106 SMIC Power Sales 0 36,892 45,864 34,000 40,000 (0.18) 40,960 12000 2500 5800 Labor&Services 0 125 262 0 0 0.00 0 12000 2500 5901 EF Investment Interest 0 1,158 1,497 0 0 0.00 0 12000 2500 5905 EF Penalties and Interest 0 109 128 0 0 0.00 0 12000 2500 5911 Unrealized Gain on FV of Investments 0 (1,066) 0 0 0 0.00 0 12000 2500 5940 Amortization of Contributions-in-Aid 0 0 0 530,000 535,000 (0.01) 535,000 Total Revenues $ 0 $ 69,367 $ 91,972 $ 564,000 $ 619,243 $ (0.10) $ 615,960 Expenditures Personnel Costs: 12000 2500 6000 Salaries 0 21,210 28,568 18,720 18,057 (0.04) 18,489 12000 2500 6001 Overtime 0 155 1,129 96 550 4.73 563 12000 2500 6002 Standby Time 0 59 0 0 0 0.00 0 12000 2500 6100 Medicare 0 335 444 288 310 0.08 309 12000 2500 6102 Workers'Compensation 0 1,952 2,738 1,524 1,870 0.23 252 12000 2500 6201 Retirement Benefits 0 1,775 1,750 708 547 (0.23) 0 12000 2500 6202 Health Insurance 0 8,181 12,202 3,444 7,017 1.04 561 Total Personnel Costs: $ 0 $ 33,667 $ 46,831 $ 24,780 $ 28,351 $ 0.14 $ 20,174 Non-Personnel Costs: 12000 2500 7001 Communications 0 0 0 500 500 0.00 500 12000 2500 7002 Postage and Freight 0 65 915 500 500 0.00 500 12000 2500 7004 Insurance 0 842 5,185 1,600 2,000 0.25 5,300 12000 2500 7006 Legal 0 6,326 22,065 0 0 0.00 10,000 12000 2500 7009 Contracted Services 0 12,457 15,910 40,000 20,000 (0.50) 20,000 12000 2500 7015 Utilities 0 13,666 16,499 15,000 15,000 0.00 15,000 12000 2500 7016 Heating Fuel 0 3,524 3,338 6,000 6,000 0.00 5,000 12000 2500 7100 General Power for Resale 0 22,283 26,292 22,000 26,000 0.18 26,624 12000 2500 7102 Power Fuel Costs 0 0 0 0 0 0.00 2,500 12000 2500 7211 Gas&Lube 0 9,256 4,777 7,000 7,000 0.00 7,000 12000 2500 7215 Operating Supplies 0 1,379 2,387 3,500 3,500 0.00 3,500 12000 2500 7216 Maintenance&Repair 0 4,294 13,150 8,000 8,000 0.00 8,000 12000 2500 7217 Small Tools&Equipment 0 3,043 2,815 1,500 1,500 0.00 1,500 12000 2500 7300 Advertising 0 3,135 369 4,000 3,000 (0.25) 3,000 12000 2500 7302 Travel&Subsistence 0 0 0 100 0 (1.00) 0 12000 2500 7325 Harbor Internal Cost Allocation 0 (108,105) (125,879) (125,878) (111,978) (0.11) (136,749) 12000 2500 7330 P.I.L.T. 0 2,961 3,690 2,720 3,200 0.18 3,277 12000 2500 7331 Reclass PILT to Transfer-Out 0 (2,961) (3,690) (2,720) (3,200) 0.18 (3,277) 12000 2500 7810 Miscellaneous Expense 0 350 0 0 0 0.00 0 12000 2500 7900 Depreciation Expense 0 1,105 0 501,105 500,000 0.00 500,000 Total Non-Personnel Costs: $ 0 $ (26,380) $ (12,177) $ 484,927 $ 481,022 $ (0.01) $ 471,675 Total Expenditures $ 0 $ 7,287 $ 34,654 $ 509,707 $ 509,373 $ 0.00 $ 491,849 Ig Run:10/08/2015 at 4:01 PM City of Seward • Revenue and Expenses by Department SMIC Enterprise Fund SMIC-North SMIC Dock For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 12000 2502 5101 Moorage 0 215 4,502 2,000 2,000 0.00 2,000 12000 2502 5102 Wharfage 0 142 440 1,250 1,250 0.00 1,250 12000 2502 5153 Fuel Pumping Fee 0 2,506 4,698 3,000 3,000 0.00 3,000 12000 2502 5800 Labor&Services 0 0 158 0 0 0.00 0 Total Revenues $ 0 $ 2,863 $ 9,798 $ 6,250 $ 6,250 $ 0.00 $ 6,250 Expenditures Personnel Costs: 12000 2502 6000 Salaries 0 1,700 2,070 5,112 3,390 (0.34) 3,471 12000 2502 6001 Overtime 0 42 126 132 112 (0.15) 115 12000 2502 6100 Medicare 0 25 32 36 55 0.53 56 12000 2502 6102 Workers'Compensation 0 173 194 216 230 0.06 252 12000 2502 6201 Retirement Benefits 0 126 101 84 158 0.88 156 12000 2502 6202 Health Insurance 0 656 737 420 731 0.74 760 Total Personnel Costs: $ 0 $ 2,722 $ 3,260 $ 6,000 $ 4,676 $ (0.22) $ 4,810 Non-Personnel Costs: 12000 2502 7004 Insurance 0 2,051 2,161 2,500 2,600 0.04 2,600 12000 2502 7009 Contracted Services 0 0 1,203 5,000 5,000 0.00 5,000 12000 2502 7216 Maintenance&Repair 0 0 9,813 3,000 3,000 0.00 3,000 12000 2502 7321 Harbor General Indirect Costs 0 661 2,484 2,484 1,952 (0.21) 1,880 12000 2502 7322 Harbor Admin Indirect Costs 0 335 1,652 1,652 2,016 0.22 2,070 12000 2502 7323 SMIC General Indirect Costs 0 22,032 25,654 25,654 4,102 (0.84) 5,009 12000 2502 7324 Gen Fund Indirect Costs 0 27,255 27,800 27,800 28,439 0.02 29,122 12000 2502 7330 P.I.L.T. 0 229 784 500 500 0.00 500 12000 2502 7331 Reclass PILT to Transfer-Out 0 (229) (784) (500) (500) 0.00 (500) 12000 2502 7900 Depreciation Expense 0 47,645 0 47,645 47,645 0.00 47,645 Total Non-Personnel Costs: $ 0 $ 99,979 $ 70,767 $ 115,735 $ 94,754 $ (0.18) $ 96,326 Total Expenditures $ 0 $ 102,701 $ 74,027 $ 121,735 $ 99,430 $ (0.18) $ 101,136 19 Run:10/08/2015 at 4:01 PM City of Seward Revenue and Expenses by Department • SMIC Enterprise Fund SMIC-East SMIC Dock For 12131/2014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 12000 2503 5000 Land Rents&Leases 0 46,734 47,975 48,000 48,707 (0.01) 48,707 12000 2503 5101 Moorage 0 780 2,261 1,000 1,000 0.00 1,000 12000 2503 5102 Wharfage 0 10,834 5,555 3,000 5,000 (0.67) 5,000 Total Revenues $ 0 $ 58,348 $ 55,791 $ 52,000 $ 54,707 $ (0.05) $ 54,707 Expenditures Personnel Costs: Total Personnel Costs: $ 0 $ 0 $ 0 $ 0 $ 0 $ 0.00 $ 0 Non-Personnel Costs: 12000 2503 7004 Insurance 0 716 829 1,300 1,300 0.00 1,300 12000 2503 7321 Harbor General Indirect Costs 0 992 1,784 1,784 1,557 (0.13) 1,500 12000 2503 7322 Harbor Admin Indirect Costs 0 502 1,187 1,187 1,608 0.35 1,652 12000 2503 7323 SMIC General Indirect Costs 0 15,556 18,114 18,114 3,272 (0.82) 3,996 12000 2503 7324 Gen Fund Indirect Costs 0 19,210 19,594 19,594 20,045 0.02 20,526 12000 2503 7330 P.I.L.T. 0 929 625 320 480 0.50 480 12000 2503 7331 Reclass PILT to Transfer-Out 0 (929) (625) (320j (480) 0.50 (480) Total Non-Personnel Costs: $ 0 $ 36,976 $ 41,508 $ 41,979 $ 27,782 $ (0.34) $ 28,974 Total Expenditures $ 0 $ 36,976 $ 41,508 $ 41,979 $ 27,782 $ (0.34) $ 28,974 Run:10/08/2015 at 4:01 PM City of Seward Revenue and Expenses by Department SMIC Enterprise Fund SMIC•330 Ton Lift For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 12000 2504 5103 Boat Lift Fees 0 105,453 133,949 100,000 140,000 (0.40) 140,000 12000 2504 5104 Storage Fees 0 91,128 107,481 110,000 115,000 (0.05) 115,000 12000 2504 5109 Washdown Pad Fees 0 0 7,956 0 8,000 0.00 8,190 12000 2504 5800 Labor&Services 0 997 473 1,000 1,000 0.00 1,000 12000 2504 5910 Gain on Sale of Fixed Assets 0 0 282,970 0 0 0.00 0 12000 2504 5940 Amortization of Contributions-in-Aid 0 0 0 35,519 0 1.00 0 Total Revenues $ 0 $ 197,578 $ 532,829 $ 246,519 $ 264,000 $ (0.07) $ 264,190 Expenditures Personnel Costs: 12000 2504 6000 Salaries 0 31,534 35,232 37,344 30,852 (0.17) 31,590 12000 2504 6001 Overtime 0 2,519 2,403 2,940 2,616 (0.11) 2,679 12000 2504 6100 Medicare 0 494 578 672 526 (0.22) 539 12000 2504 6102 Workers'Compensation 0 2,980 3,594 3,120 3,330 0.07 3,663 12000 2504 6201 Retirement Benefits 0 3,064 1,724 1,476 1,090 (0.26) 1,116 12000 2504 6202 Health Insurance 0 13,754 15,681 7,632 10,128 0.33 10,532 Total Personnel Costs: $ 0 $ 54,345 $ 59,212 $ 53,184 $ 48,542 $ (0.09) $ 50,119 Non-Personnel Costs: 12000 2504 7002 Postage and Freight 0 1,565 465 5,000 5,000 0.00 5,000 12000 2504 7004 Insurance 0 2,950 2,622 3,000 3,000 0.00 5,200 12000 2504 7009 Contracted Services 0 3,150 0 5,000 5,000 0.00 5,000 12000 2504 7211 Gas&Lube 0 2,319 3,583 3,000 3,000 0.00 3,000 12000 2504 7215 Operating Supplies 0 1,489 786 2,500 2,500 0.00 2,500 12000 2504 7216 Maintenance&Repair 0 16,615 22,862 25,000 25,000 0.00 25,000 12000 2504 7217 Small Tools&Equipment 0 0 21 0 0 0.00 0 12000 2504 7321 Harbor General Indirect Costs 0 21,490 44,994 44,994 49,782 0.11 47,941 12000 2504 7322 Harbor Admin Indirect Costs 0 10,875 29,934 29,934 51,400 0.72 52,795 12000 2504 7323 SMIC General Indirect Costs 0 31,523 36,706 36,706 104,604 1.85 127,744 12000 2504 7324 Gen Fund Indirect Costs 0 38,923 39,701 39,701 41,072 0.03 42,058 12000 2504 7330 P.I.L.T. 0 15,806 19,989 16,880 21,120 0.25 21,135 12000 2504 7331 Reclass PILT to Transfer-Out 0 (15,806) (19,989) (16,880) (21,120) 0.25 (21,135) 12000 2504 7808 Bad Debt Expense 0 10,050 0 4,000 0 (1.00) 0 12000 2504 7900 Depreciation Expense 0 28,552 0 68,085 68,085 0.00 68,085 12000 2504 8103 Capital Equipment 0 0 0 1,441,087 0 (1.00) 0 Total Non-Personnel Costs: $ 0 $ 169,501 $ 181,674 $ 1,708,007 $ 358,443 $ (0.79) $ 384,323 Total Expenditures $ 0 $ 223,846 $ 240,886 $1,761,191 $ 406,985 $ (0.77) $ 434,442 21 Run:10/08/2015 at 4:01 PM City of Seward Revenue and Expenses by Department • SMIC Enterprise Fund SMIC-Syncrolift Operations For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 12000 2505 4632 Insurance Recovery 0 0 5,520 0 0 0.00 0 12000 2505 5000 Land Rents&Leases 0 64,000 64,000 64,000 64,000 0.00 64,000 Total Revenues $ 0 $ 64,000 $ 69,520 $ 64,000 $ 64,000 $ 0.00 $ 64,000 Expenditures Personnel Costs: 12000 2505 6000 Salaries 0 0 892 0 0 0.00 222 12000 2505 6100 Medicare 0 0 12 0 0 0.00 0 12000 2505 6102 Workers'Compensation 0 0 97 0 0 0.00 0 12000 2505 6201 Retirement Benefits 0 0 63 0 0 0.00 0 12000 2505 6202 Health Insurance 0 0 366 0 0 0.00 101 Total Personnel Costs: $ 0 $ 0 $ 1,430 $ 0 $ 0 $ 0.00 $ 323 Non-Personnel Costs: 12000 2505 7002 Postage and Freight 0 0 10 0 0 0.00 0 12000 2505 7004 Insurance 0 0 8,355 0 0 0.00 0 12000 2505 7216 Maintenance&Repair 0 0 5,552 0 0 0.00 0 12000 2505 7321 Harbor General Indirect Costs 0 992 1,278 1,278 0 (1.00) 0 12000 2505 7322 Harbor Admin Indirect Costs 0 502 850 850 0 (1.00) 0 12000 2505 7323 SMIC General Indirect Costs 0 1,211 1,410 1,410 0 (1.00) 0 12000 2505 7324 Gen Fund Indirect Costs 0 1,300 1,326 1,326 1,356 0.02 1,389 Total Non-Personnel Costs: $ 0 $ 4,005 $ 18,781 $ 4,864 $ 1,356 $ (0.72) $ 1,389 Total Expenditures $ 0 $ 4,005 $ 20,211 $ 4,864 $ 1,356 $ (0.72) $ 1,712 22 Run:10/08/2015 at 4:01 PM City of Seward Revenue and Expenses by Department SMIC Enterprise Fund SMIC-Syncrolift Complex For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues 12000 2506 5940 Amortization of Contributions-in-Aid 0 482,529 0 482,529 482,529 0.00 485,529 Total Revenues $ 0 $ 482,529 $ 0 $ 482,529 $ 482,529 $ 0.00 $ 485,529 Expenditures Personnel Costs: Total Personnel Costs: $ 0 $ 0 $ 0 $ 0 $ 0 $ 0.00 $ 0 Non-Personnel Costs: 12000 2506 7900 Depreciation Expense 0 524,529 0 524,529 524,529 0.00 524,529 Total Non-Personnel Costs: $ 0 $ 524,529 $ 0 $ 524,529 $ 524,529 $ 0.00 $ 524,529 Total Expenditures $ 0 $ 524,529 $ 0 $ 524,529 $ 524,529 $ 0.00 $ 524,529 23 Run:10/08/2015 at 4:01 PM City of Seward Revenue and Expenses by Department SMIC Enterprise Fund SMIC Debt Service For 1213112014 2013 2014 Y-T-D 2015 2016 2015-16 2017 Actual Actual Actual Budget Budget %Change Budget Revenues Total Revenues $ 0 $ 0 $ 0 $ 0 $ 0 $ 0.00 $ 0 Expenditures Personnel Costs: Total Personnel Costs: $ 0 $ 0 $ 0 $ 0 $ 0 $ 0.00 $ 0 Non-Personnel Costs: 12000 2590 8300 Debt Service Principal 0 0 0 0 147,012 0.00 147,012 Total Non-Personnel Costs: $ 0 $ 0 $ 0 $ 0 $ 147,012 $ 0.00 $ 147,012 Total Expenditures $ 0 $ 0 $ 0 $ 0 $ 147,012 $ 0.00 $ 147,012 2I. CITY OF SEWARD SEWARD MARINE INDUSTRIAL CENTER ENTERPRISE FUND 2016 and 2017 Debt Service Schedule Balance 2016 Budget Balance Description Interest Rate @ 1/01/16 Principal Interest Retirement Total @ 12/31/16 Term 2015 330-Ton Boatlift Loan 0% 882,075 147,012 147,012 735,062 2015-2021 Totals: $882,075 $147,012 $0 $0 $147,012 $735,062 Balance 2017 Budget Balance Description Interest Rate @ 1/01/17 Principal Interest Retirement Total @ 12/31/17 Term 2015 330-Ton Boatlift Loan 0 735,062 147,012 147,012 588,050 2015-2021 Totals: $735,062 $147,012 $0 $0 $147,012 $588,050 CITY OF SEWARD S.M.I.C. ENTERPRISE FUND Budgeted Interfund Transfers Fiscal Year 2016 and 2017 2016 2017 Transfers- Transfers- Transfers- Transfers- In Out In Out General Fund -to cover SMIC deficit 206,783 231,037 General Fund: One-half of land rents and leases 78,475 76,354 Payments-in-Lieu-of-Tax 25,300 25,392 $206,783 $103,775 $231,037 $101,746 2(e ELEC I RIC ENTERPRISE FUND Budgeted Statement of Revenues and Expenses And Change in Net Position For Fiscal Years 20I6 and 20I7 2014 20I5 20I6 2017 Actual# Budget Budget Budget Operating revenue: Sales: Residential 3,233,8I2 3,329,56I 3,406,141 3,466,449 Small General Service I,800,254 I,893,594 1,9I0,000 I,9I0,000 Large General Service 4,575,343 4,832,455 4,70I,349 4,812,600 Harbor Power Sales 300,446 310,958 384,605 320,503 Industrial Sales/Special Contracts I,028,669 93I,573 I,I52,089 I,258,587 Street&Yard Lights 74,222 70,000 7I,610 73,000 Miscellaneous 84,299 73,000 74,679 69,700 Total operating revenue: $11,097,045 $II,44I,14I $11,700,473 $II,9I0,839 Operating expense: Before depreciation: Salaries I,000,65I I,060,049 I,034,933 I,135,271 Work order charges(salaries) (208,I30) (297,763) (I00,000) (100,000) Employee benefits 599,15I 587,696 568,223 676,47I Purchased services 757,789 553,422 557,444 553,422 Power for resale 4,916,494 4,99I,000 5,I00,000 5,I00,000 Supplies &maintenance 363,720 503,000 437,500 4I5,500 Work order charges(supplies) -117,416 -50,000 -50,000 -50,000 General&Administrative I,I06,4I7 I,1I2,458 I,I I1,535 I,I20,860 Total operating expense: $8,418,676 $8,459,862 $8,659,635 $8,85I,524 Operating income before depreciation 2,678,369 2,981279 3,040,838 3,059,3I5 Depreciation I,758,I35 I,777,308 I,777,228 1,777,228 Earnings from operations $920234 $1,203,97I $I,263,6I0 $1,282,087 Non-operating revenue(expense) Interest income 278,300 72,000 89,000 90,000 Interest expense (286,592) (28I,686) (262,486) (257,119) Other revenue(expense) 519,984 I,000 I,I39 1,139 Total non-operating revenues(expenses) 5I1,692 (208,686) (172,347) (I65,980) Earnings before contributions and transfers $1,431,926 $995,285 $I,091,263 $1,1 16,107 Capital contributions and special items I,055,462 0 0 0 Transfers (to)/from other funds (I,119,3I3) (I,255,6I0) (I,270,628) (1,293,319) Change in net position 1,368,075 (260,325) (I79,365) (1772I2) Beginning net position $22,978,62I $24,346,696 $24,086,371 $23,907,006 Ending net position $24,346,696 * $24,086,37I $23,907,006 $23,729,794 v I ies to annual Comprehensive Annual Financial Report 2,q" CITY OF SEWARD ELEC 'RIC ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2OI6 and 2OI7 20I5 20I6 20I7 Budget Budget Budget Beginning Cash Balance at I/I/I5 (*): $3,I29,380 Cash is provided by(used for): Change in net position (260,325) (I79,365) (I77,2I2) Add expense items not affecting cash Depreciation I,777,308 I,777,228 I,777,228 Net cash provided by operations $1,516,983 $I,597,863 $1,600,016 Other sources(uses) of cash Loan repayment from General Fund 110,784 119,184 (a) I27,584 (a) Debt principal payments (345,000) (I30,000) (b) (I35,000) (c) Capital outlay (489,678) (89I,600) (d) (785,000) (e) Net increase(decrease)in cash $793,089 $695,447 $807,600 Estimated ending cash balance $3,922,469 $4,6I7,9I6 $5,425,5I6 (a)From General Fund to recover payments made to subsidize SMIC enterprise fund over I5 years. (b) $I30K represents Electric generator bond (c) $I35K represents Electric generator bond (d)$89I,600 represents Infrastructure$440K;Motor pool$29I,600;Work orders $I50,000;Equipment$IOK. (e)$785,000 represents Infrastructure $440K;Motor pool$I75,000;Work orders $I50,000;Equipment$20K. # Ties to CAFR 2$ City of Seward 1:.10/08/2015 at 11:51 AM Electric Enterprise Fund Page: 4 Revenue Detail by Line Item For 9/30/2015 2016 2017 2013 2014 2015 Budget 2015-16 Budget 2016-17 Actual Actual Budget Request %Chg Request %Chg Revenues Residential 1,800,370 1,848,857 1,958,151 2,003,188 2.30 2,043,252 2.00 Residential fuel factor 933,940 923,942 873,245 893,330 2.30 911,197 2.00 Residential customer charge 447,504 461,013 498,165 509,623 2.30 512,000 0.47 SG Service 1,116,385 1,112,570 1,191,005 1,200,000 0.76 1,200,000 0.00 SG fuel factor 503,726 486,393 460,223 470,000 2.12 470,000 0.00 SG Customer Charge 198,234 201,291 242,366 240,000 (0.98) 240,000 0.00 LG Service 1,815,985 1,810,905 2,030,049 1,972,903 (2.82) 2,020,000 2.39 LG fuel factor 1,390,656 1,332,135 1,262,780 1,227,233 (2.81) 1,257,000 2.43 LG customer charge 40,437 41,356 45,851 44,560 (2.82) 45,600 2.33 LG demand charge 1,290,783 1,391,821 1,497,426 1,455,273 (2.82) 1,490,000 2.39 Electric KVAR rate 0 0 5,000 5,115 2.30 0 (100.00) Altemate Energy (3,146) (874) (3,651) (3,735) 2.30 0 (100.00) Spec.Contract Energy 102,906 117,751 108,339 131,881 21.73 144,080 9.25 Special Contract fuel factor 563,637 523,408 496,173 586,220 18.15 640,445 9.25 Spec.Contract customer charge 913 939 966 988 2.28 1,012 2.43 Special Contract Demand 362,478 386,570 326,095 433,000 32.78 473,050 9.25 Harbor Fund Power Sales 226,005 212,862 216,221 221,194 2.30 226,503 2.40 Harbor power fuel factor 95,820 87,583 89,737 91,801 2.30 94,000 2.40 Street&Yard 65,552 68,363 70,000 71,610 2.30 73,000 1.94 Yard Light Fuel 5,468 5,860 0 0 0.00 6,000 0.00 Turn on Fees 14,559 17,270 15,000 15,345 2.30 15,700 2.31 Equipment Rental 18,735 16,973 26,000 26,598 2.30 18,000 (32.33) Joint Pole Use 10,008 9,984 10,000 10,230 2.30 10,000 (2.25) Work Order Revenue 12,629 40,073 20,000 20,460 2.30 20,000 (2.25) Chugach Coop Divid. 0 0 0 0 0.00 0 0.00 Collection of Doubtful Accounts 224 4,988 0 0 0.00 0 0.00 Miscellaneous Revenue 26,501 0 2,000 2,046 2.30 0 (100.00) EF Investment Interest 18,361 51,511 12,000 19,000 58.33 20,000 5.26 EF Penalties and Interest 80,725 71,046 60,000 70,000 16.67 70,000 0.00 Unrealized gain on FV of Investments (17,833) 0 0 0 0.00 0 0.00 PERS On-Behalf paid by SOA 39,084 174,276 0 0 0.00 0 0.00 Assessment Interest 708 530 1,000 0 (100.00) 0 0.00 Amort.of CIA-General 947,011 0 1,030,760 1,030,000 (0.07) 1,030,000 0.00 Amort.Bond Premium 8,366 8,366 8,366 1,139 (86.39) 1,139 0.00 Surplus Sales 300 0 0 0 0.00 0 0.00 Total Revenues $12,117,031 $11,407,762 $12,553,267 $12,749,002 $ (15.99) $13,031,978 $(278.33) 211 City of Seward .un:10/08/2015 at 5:13 PM 15000-Electric Enterprise Fund Page: 1 - Expense Summary by Line Item For 12/31/2014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Expenditures/Expenses 15000 6000 Salaries 835,716 885,276 947,592 7.04 973,762 2.76 15000 6001 Overtime 74,829 62,988 67,152 6.61 69,085 2.88 15000 6002 Standby Time 90,106 86,688 89,727 3.51 92,424 3.01 15000 6100 Medicare 19,743 15,696 17,021 8.44 17,473 2.66 15000 6101 Unemployment Insurance 325 3,000 0 (100.00) 0 0.00 15000 6102 Workers'Compensation 48,712 43,464 53,556 23.22 55,331 3.31 15000 6200 Leave Time 88,238 92,256 104,872 13.67 113,499 8.23 15000 6201 Retirement Benefits 192,021 330,899 186,866 (43.53) 193,722 3.67 15000 6202 Health Insurance 219,729 227,018 261,490 15.18 273,496 4.59 15000 6204 Meal Allowance 2,207 13,752 3,150 (77.09) 2,700 (14.29) 15000 6205 Electric Union Benefits 28,176 20,004 20,100 0.48 20,250 0.75 15000 7001 Communications 18,280 19,500 25,000 28.21 25,000 0.00 15000 7002 Postage and Freight 22,596 24,000 32,500 35.42 22,000 (32.31) 15000 7003 Bank and Credit Card Fees 48,422 48,000 55,000 14.58 55,500 0.91 15000 7004 Insurance 55,751 62,000 65,000 4.84 65,000 0.00 15000 7006 Legal 55,182 62,000 50,000 (19.35) 50,000 0.00 15000 7009 Contracted Services 416,817 265,444 321,000 20.93 321,000 0.00 15000 7010 Engineering 0 0 26,000 0.00 26,000 0.00 15000 7011 Testing 0 0 0 0.00 0 0.00 15000 7012 Other Special Services 11,198 15,000 20,000 33.33 15,000 (25.00) 15000 7015 Utilities 76,790 94,000 89,500 (4.79) 89,500 0.00 15000 7016 Heating Fuel 18,357 33,000 26,000 (21.21) 26,000 0.00 15000 7017 Rents&Leases 34,395 17,000 23,000 35.29 23,000 0.00 15000 7101 Chugach Power Purchases 1,805,400 1,690,000 2,000,000 18.34 2,000,000 0.00 15000 7102 Power Fuel Costs 3,012,013 2,920,000 3,000,000 2.74 3,000,000 0.00 15000 7103 Fuel for Generators 99,081 150,000 100,000 (33.33) 100,000 0.00 15000 7210 Vehicle Supplies 2,059 7,000 5,000 (28.57) 3,000 (40.00) 15000 7211 Gas&Lube 34,892 43,000 50,500 17.44 40,500 (19.80) 15000 7213 Safety Equipment 705 5,000 5,000 0.00 5,000 0.00 15000 7215 Operating Supplies 193,019 222,000 242,000 9.01 237,000 (2.07) 15000 7216 Maintenance&Repair 128,367 120,000 105,000 (12.50) 105,000 0.00 15000 7217 Small Tools&Equipment 4,677 50,000 30,000 (40.00) 25,000 (16.67) 15000 7300 Advertising 1,491 8,000 11,000 37.50 6,000 (45.45) 15000 7301 Subscriptions&Dues 27,547 10,000 82,000 720.00 82,000 0.00 15000 7302 Travel&Subsistence 8,566 30,000 30,000 0.00 28,000 (6.67) 15000 7303 Education&Training 8,640 45,000 30,000 (33.33) 28,000 (6.67) 15000 7304 Equipment Rent 11,138 23,000 24,000 4.35 27,000 12.50 15000 7307 GF Administrative Fee 847,291 864,237 888,535 2.81 909,860 2.40 15000 7330 P.I.L.T. 883,025 898,987 930,309 3.48 953,000 2.44 15000 7331 Reclass PILI to Transfer-Out (883,025) (898,987) (930,309) 3.48 (953,000) 2.44 15000 7808 Bad Debt Expense 20,572 30,000 35,000 16.67 30,000 (14.29) 15000 7810 Miscellaneous Expense 6,172 13,000 11,000 (15.38) 10,000 (9.09) 15000 7900 Depreciation Expense 1,758,135 1,821,082 1,777,228 (2.41) 1,777,228 0.00 15000 8010 Utility Deposit Interest 1,135 1,400 1,200 (14.29) 1,200 0.00 15000 8012 Debt Service Interest Expense 306,915 291,536 261,286 (10.38) 255,919 (2.05) 15000 8014 Amortization of Bond Issue Costs 4,904 8,425 0 (100.00) 0 0.00 15000 8101 Infrastructure 0 350,000 440,000 25.71 440,000 0.00 15000 8103 Capital Equipment 0 50,000 10,000 (80.00) 20,000 100.00 15000 8104 Motor Pool Rent 175,000 175,000 291,600 66.63 175,000 (39.99) 15000 8105 Improvements other than Buildings 0 0 0 0.00 0 0.00 15000 8200 Work Order Sal/Benefit credits (103,216) (29,364) (100,000) 240.55 (100,000) 0.00 15000 8201 Work Order Operating Supply credits (117,416) (50,000) (50,000) 0.00 (50,000) 0.00 15000 8300 Debt Service Principal 0 380,000 130,000 (65.79) 135,000 3.85 Total Expenditures/Expenses $ 10,594,677 $ 11,649,301 $ 11,894,875 $ 717.51$ 11,820,449 $(117.95) Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-General Operations For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 327,229 343,416 362,976 5.70 373,887 3.01 150006001 Overtime 844 3,888 2,142 (44.91) 2,207 3.03 15000 6002 Standby Time 0 0 2,466 0.00 2,540 3.00 15000 6100 Medicare 7,196 5,616 6,096 8.55 6,280 3.02 15000 6101 Unemployment Insurance 325 3,000 0 (100.00) 0 0.00 15000 6102 Workers'Compensation 22,820 21,216 27,899 31.50 28,737 3.00 15000 6200 Leave Time 59,775 64,176 71,634 11.62 73,788 3.01 15000 6201 Retirement Benefits 99,687 133,365 111,372 (16.49) 115,827 4.00 15000 6202 Health Insurance 148,054 138,945 142,310 2.42 149,425 5.00 15000 6204 Electric Meal Allowance 114 2,040 300 (85.29) 1,500 400.00 15000 6205 Electric Union Benefits 28,176 20,004 20,000 (0.02) 20,000 0.00 Total Personnel Costs: $ 694,220 $ 735,666 $ 747,195 $(186.92) $ 774,191 $ 427.07 Non-Personnel Costs: 15000 7001 Communications 8,411 9,000 10,000 11.11 10,000 0.00 15000 7002 Postage and Freight 16,030 20,000 25,000 25.00 15,000 (40.00) 15000 7003 Bank and Credit Card Fees 48,422 48,000 55,000 14.58 55,500 0.91 15000 7004 Insurance 55,751 62,000 65,000 4.84 65,000 0.00 15000 7006 Legal 55,182 62,000 35,000 (43.55) 35,000 0.00 15000 7009 Contracted Services 226,144 96,000 70,000 (27.08) 70,000 0.00 15000 7010 Engineering 0 0 26,000 0.00 26,000 0.00 15000 7011 Testing 0 0 0 0.00 0 0.00 15000 7012 Other Special Services 0 0 5,000 0.00 0 (100.00) 15000 7015 Utilities 2,105 4,000 4,500 12.50 4,500 0.00 15000 7016 Heating Fuel 342 6,000 6,000 0.00 6,000 0.00 15000 7017 Rents&Leases 5,760 2,000 3,000 50.00 3,000 0.00 15000 7210 Vehicle Supplies 2,059 5,000 5,000 0.00 3,000 (40.00) 15000 7211 Gas&Lube 25,657 40,000 40,000 0.00 30,000 (25.00) 15000 7213 Safety Equipment 705 5,000 5,000 0.00 5,000 0.00 15000 7215 Operating Supplies 114,182 80,000 100,000 25.00 95,000 (5.00) 15000 7216 Maintenance&Repair 41,925 50,000 50,000 0.00 50,000 0.00 15000 7217 Small Tools&Equipment 4,677 20,000 20,000 0.00 15,000 (25.00) 15000 7300 Advertising 1,333 5,000 10,000 100.00 5,000 (50.00) 15000 7301 Subscriptions&Dues 2,585 2,000 2,000 0.00 2,000 0.00 15000 7302 Travel&Subsistence 2,337 10,000 10,000 0.00 8,000 (20.00) 15000 7303 Education&Training 6,020 10,000 10,000 0.00 8,000 (20.00) 15000 7304 Equipment Rent 0 5,000 5,000 0.00 5,000 0.00 15000 7307 GF Administrative Fee 847,291 864,237 888,535 2.81 909,860 2.40 15000 7330 P.I.L.T. 883,025 898,987 930,309 3.48 953,000 2.44 15000 7331 Reclass PILT to Transfer-Out (883,025) (898,987) (930,309) 3.48 (953,000) 2.44 15000 7808 Bad Debt Expense 20,572 30,000 35,000 16.67 30,000 (14.29) 15000 7810 Miscellaneous Expense 5,572 10,000 10,000 0.00 10,000 0.00 15000 7900 Depreciation Expense 1,732,885 1,817,802 1,774,028 (2.41) 1,774,028 0.00 15000 8010 Utility Deposit Interest 1,135 1,400 1,200 (14.29) 1,200 0.00 15000 8101 Infrastructure 0 100,000 20,000 (80.00) 320,000 1,500.00 15000 8103 Capital Equipment 0 30,000 0 (100.00) 0 0.00 15000 8104 Motor Pool Rent 90,000 90,000 97,200 8.00 90,000 (7.41) 15000 8105 Improvements other than Buildings 0 0 0 0.00 0 0.00 15000 8201 Work Order Operating Supply credits 0 0 0 0.00 0 0.00 Total Non-Personnel Costs: $ 3,317,082 $ 3,484,439 $ 3,387,463 $ 10.14 $ 3,651,088 $,161.49 Total Expenditures $ 4,011,302 $ 4,220,105 $ 4,134,658 $(176.78) $ 4,425,279 $,588.56 3( Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Administration For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 192,048 264,696 288,882 9.14 295,059 2.14 15000 6001 Overtime 349 756 750 (0.79) 750 0.00 15000 6100 Medicare 2,968 4,056 4,634 14.25 4,739 2.27 15000 6102 Workers'Compensation 1,473 5,232 1,780 (65.98) 2,000 12.36 15000 6200 Leave Time 28,463 28,080 33,238 18.37 35,372 6.42 15000 6201 Retirement Benefits 29,186 25,555 16,005 (37.37) 16,338 2.08 15000 6202 Health Insurance 65,740 88,073 106,624 21.06 110,889 4.00 Total Personnel Costs: $ 320,227 $ 416,448 $ 451,913 $ (41.32) $ 465,147 $ 29.27 Non-Personnel Costs: 15000 7001 Communications 6,635 7,000 10,000 42.86 10,000 0.00 15000 7002 Postage and Freight 297 1,000 1,000 0.01 1,000 0.00 15000 7004 Insurance 0 0 0 0.00 0 0.00 15000 7006 Legal 0 0 15,000 0.00 15,000 0.00 15000 7009 Contracted Services 705 100,000 30,000 (70.00) 30,000 0.00 15000 7012 Other Special Services 11,198 15,000 15,000 0.00 15,000 0.00 15000 7015 Utilities 7,384 10,000 0 (100.00) 0 0.00 15000 7016 Heating Fuel 14,926 17,000 0 (100.00) 0 0.00 15000 7210 Vehicle Supplies 0 2,000 0 (100.00) 0 0.00 15000 7211 Gas&Lube 4,147 3,000 3,000 0.00 3,000 0.00 15000 7215 Operating Supplies 12,927 10,000 10,000 0.00 10,000 0.00 15000 7216 Maintenance&Repair 16 0 0 0.00 0 0.00 15000 7217 Small Tools&Equipment 0 20,000 10,000 (50.00) 10,000 0.00 15000 7300 Advertising 159 3,000 1,000 (66.67) 1,000 0.00 15000 7301 Subscriptions&Dues 24,961 8,000 80,000 900.00 80,000 0.00 15000 7302 Travel&Subsistence 6,229 20,000 20,000 0.00 20,000 0.00 15000 7303 Education&Training 2,620 25,000 15,000 (40.00) 15,000 0.00 15000 7304 Equipment Rent 2,128 0 0 0.00 3,000 0.00 15000 7810 Miscellaneous Expense 0 0 0 0.00 0 0.00 15000 7900 Depreciation Expense 25,250 3,280 3,200 (2.44) 3,200 0.00 15000 8103 Capital Equipment 0 20,000 10,000 (50.00) 10,000 0.00 15000 8104 Motor Pool Rent 85,000 85,000 194,400 128.71 85,000 (56.28) Total Non-Personnel Costs: $ 204,582 $ 349,280 $ 417,600 $ 492.47 $ 311,200 $ (56.28) Total Expenditures $ 524,809 $ 765,728 $ 869,513 $451.15 $ 776,347 $ (27.01) 3Z Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Standby Generation For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 3,034 1,080 4,536 320.00 4,672 3.00 150006001 Overtime 6,839 4,524 3,343 (26.11) 3,444 3.02 15000 6100 Medicare 146 84 104 23.81 107 2.88 15000 6102 Workers'Compensation 555 216 497 130.09 512 3.02 15000 6201 Retirement Benefits 0 83 57 (31.36) 59 3.51 15000 6202 Health Insurance 0 0 94 0.00 100 6.38 15000 6204 Electric Meal Allowance 212 1,188 200 (83.16) 100 (50.00) Total Personnel Costs: $ 10,786 $ 7,175 $ 8,831 $ 333.27 $ 8,994 $ (28.19) Non-Personnel Costs: 15000 7002 Postage and Freight 1,905 500 1,500 199.95 1,000 (33.33) 15000 7009 Contracted Services 0 5,000 0 (100.00) 0 0.00 15000 7015 Utilities 15,204 20,000 20,000 0.00 20,000 0.00 15000 7016 Heating Fuel 3,089 3,000 15,000 400.00 15,000 0.00 15000 7103 Fuel for Generators 49,713 50,000 50,000 0.00 50,000 0.00 15000 7211 Gas&Lube 5,088 0 7,500 0.00 7,500 0.00 15000 7215 Operating Supplies 527 10,000 5,000 (50.00) 5,000 0.00 15000 7216 Maintenance&Repair 22,565 40,000 30,000 (25.00) 30,000 0.00 15000 7217 Small Tools&Equipment 0 5,000 0 (100.00) 0 0.00 15000 7303 Education&Training 0 10,000 5,000 (50.00) 5,000 0.00 Total Non-Personnel Costs: $ 98,091 $ 143,500 $ 134,000 $ 274.95 $ 133,500 $ (33.33) Total Expenditures $ 108,877 $ 150,675 $ 142,831 $ 608.22 $ 142,494 $ (61.52) 33 Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric•Substation Operations For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 158,956 93,204 119,463 28.17 123,054 3.01 150006001 Overtime 535 8,868 1,365 (84.61) 1,406 3.00 15000 6100 Medicare 2,313 108 1,501 1,289.81 1,546 3.00 15000 6102 Workers'Compensation 13,447 276 9,549 3,359.78 9,836 3.01 15000 6200 Leave Time 0 0 0 0.00 1,040 0.00 15000 6201 Retirement Benefits 0 1,258 849 (32.49) 883 4.00 15000 6202 Health Insurance 0 0 1,480 0.00 1,554 5.00 15000 6204 Electric Meal Allowance 0 216 150 (30.56) 0 (100.00) 15000 6205 Electric Union Benefits 0 0 0 0.00 50 0.00 Total Personnel Costs: $ 175,251 $ 103,930 $ 134,357 11,530.10 $ 139,369 $ (78.98) Non-Personnel Costs: 15000 7001 Communications 3,234 3,500 5,000 42.85 5,000 0.00 15000 7002 Postage and Freight 156 1,000 5,000 400.04 5,000 0.00 15000 7009 Contracted Services 20,408 5,000 15,000 200.00 15,000 0.00 15000 7015 Utilities 52,098 60,000 65,000 8.33 65,000 0.00 15000 7016 Heating Fuel 0 7,000 5,000 (28.57) 5,000 0.00 15000 7103 Fuel for Generators 49,368 100,000 50,000 (50.00) 50,000 0.00 15000 7215 Operating Supplies 927 15,000 20,000 33.33 20,000 0.00 15000 7216 Maintenance&Repair 60,652 20,000 20,000 0.00 20,000 0.00 15000 7217 Small Tools&Equipment 0 5,000 0 (100.00) 0 0.00 15000 7300 Advertising 0 0 0 0.00 0 0.00 15000 7304 Equipment Rent 0 1,000 3,000 200.02 3,000 0.00 Total Non-Personnel Costs: $ 186,843 $ 217,500 $ 188,000 $ 706.00 $ 188,000 $ 0.00 Total Expenditures $ 362,094 $ 321,430 $ 322,357 1236.10 $ 327,369 $ (78.98) l Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Transmission OP&Maint For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 17,379 19,980 20,622 3.21 21,242 3.01 15000 6001 Overtime 10,241 936 2,957 215.92 3,046 3.01 15000 6100 Medicare 854 144 290 101.39 298 2.76 15000 6102 Workers'Compensation 2,014 612 1,127 84.15 1,161 3.02 15000 6200 Leave Time 0 0 0 0.00 76 0.00 15000 6201 Retirement Benefits 0 44 30 (31.76) 31 3.33 15000 6202 Health Insurance 0 0 73 0.00 73 0.00 15000 6204 Electric Meal Allowance 0 1,056 0 (100.00) 0 0.00 15000 6205 Electric Union Benefits 0 0 0 0.00 0 0.00 Total Personnel Costs: $ 30,488 $ 22,772 $ 25,099 $ 272.91 $ 25,927 $ 15.13 Non-Personnel Costs: 15000 7002 Postage and Freight 3,738 0 0 0.00 0 0.00 15000 7009 Contracted Services 13,997 10,000 150,000 1,400.00 150,000 0.00 15000 7017 Rents&Leases 28,635 15,000 20,000 33.33 20,000 0.00 15000 7215 Operating Supplies 0 2,000 2,000 0.00 2,000 0.00 15000 7216 Maintenance&Repair 3,208 10,000 5,000 (50.00) 5,000 0.00 15000 7304 Equipment Rent 0 12,000 12,000 0.00 12,000 0.00 Total Non-Personnel Costs: $ 49,578 $ 49,000 $ 189,000 $,383.33 $ 189,000 $ 0.00 Total Expenditures $ 80,066 $ 71,772 $ 214,099 $,656.24 $ 214,927 $ 15.13 Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Distribution OP&Maint For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 39,878 18,108 30,563 68.78 31,481 3.00 15000 6001 Overtime 40,847 29,160 38,845 33.21 40,012 3.00 15000 6002 Standby Time 1,283 0 1,044 0.00 1,075 2.97 15000 6100 Medicare 1,118 684 862 26.02 888 3.02 15000 6102 Workers'Compensation 2,626 2,400 3,567 48.63 3,674 3.00 15000 6200 Leave Time 0 0 0 0.00 271 0.00 15000 6201 Retirement Benefits 0 723 486 (32.81) 506 4.12 15000 6202 Health Insurance 0 0 735 0.00 771 4.90 15000 6204 Electric Meal Allowance 906 3,864 1,500 (61.18) 800 (46.67) 15000 6205 Electric Union Benefits 0 0 0 0.00 0 0.00 Total Personnel Costs: $ 86,658 $ 54,939 $ 77,602 $ 82.65 $ 79,478 $ (22.66) Non-Personnel Costs: 15000 7009 Contracted Services 38,638 0 0 0.00 0 0.00 15000 7215 Operating Supplies 11,077 3,000 0 (100.00) 0 0.00 15000 7304 Equipment Rent 9,010 5,000 4,000 (20.00) 4,000 0.00 15000 8101 Infrastructure 0 250,000 300,000 20.00 0 (100.00) 15000 8103 Capital Equipment 0 0 0 0.00 10,000 0.00 Total Non-Personnel Costs: $ 58,725 $ 258,000 $ 304,000 $(100.00) $ 14,000 $(100.00) Total Expenditures $ 145,383 $ 312,939 $ 381,602 $ (17.35) $ 93,478 $(122.66) A2 Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Wholesale Power Costs For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: Total Personnel Costs: $ 0 $ 0 $ 0 $ 0.00 $ 0 $ 0.00 Non-Personnel Costs: 15000 7101 Chugach Power Purchases 1,805,400 1,690,000 2,000,000 18.34 2,000,000 0.00 15000 7102 Power Fuel Costs 3,012,013 2,920,000 3,000,000 2.74 3,000,000 0.00 Total Non-Personnel Costs: $ 4,817,413 $ 4,610,000 $ 5,000,000 $ 21.08 $ 5,000,000 $ 0.00 Total Expenditures $ 4,817,413 $ 4,610,000 $ 5,000,000 $ 21.08 $ 5,000,000 $ 0.00 Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Work Orders For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 75,602 109,164 87,118 (20.20) 89,737 3.01 15000 6001 Overtime 14,991 14,676 14,978 2.06 15,429 3.01 15000 6100 Medicare 2,494 3,444 1,637 (52.47) 1,686 2.99 15000 6102 Workers'Compensation 4,101 11,544 5,691 (50.70) 5,862 3.00 15000 6200 Leave Time 0 0 0 0.00 2,120 0.00 15000 6201 Retirement Benefits 1,707 2,393 5,439 127.32 5,657 4.01 15000 6202 Health Insurance 5,935 0 8,589 0.00 9,019 5.01 15000 6204 Electric Meal Allowance 974 5,388 1,000 (81.44) 300 (70.00) 15000 6205 Electric Union Benefits 0 0 100 0.00 100 0.00 Total Personnel Costs: $ 105,804 $ 146,609 $ 124,552 $ (75.43) $ 129,910 $ (48.97) Non-Personnel Costs: 15000 7002 Postage and Freight 470 1,500 0 (100.00) 0 0.00 15000 7009 Contracted Services 62,125 0 0 0.00 0 0.00 15000 7215 Operating Supplies 53,381 100,000 100,000 0.00 100,000 0.00 15000 7810 Miscellaneous Expense 600 3,000 1,000 (66.67) 0 (100.00) 15000 8200 Work Order Sal/Benefit credits (103,216) (29,364) (100,000) 240.55 (100,000) 0.00 15000 8201 Work Order Operating Supply credits (117,416) (50,000) (50,000) 0.00 (50,000) 0.00 Total Non-Personnel Costs: $ (104,056) $ 25,136 $ (49,000) $ 73.88 $ (50,000) $(100.00) Total Expenditures $ 1,748 $ 171,745 $ 75,552 $ (1.55) $ 79,910 $(148.97) Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Standby For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 0 0 0 0.00 193 0.00 15000 6001 Overtime 0 0 2,551 0.00 2,628 3.02 15000 6002 Standby Time 88,822 86,688 86,217 (0.54) 88,809 3.01 15000 6100 Medicare 2,130 1,092 1,432 31.14 1,476 3.07 15000 6102 Workers'Compensation 0 24 692 2,783.33 713 3.03 15000 6201 Retirement Benefits 0 1,959 1,295 (33.89) 1,347 4.02 150006202 Health Insurance 0 0 1,254 0.00 1,317 5.02 15000 6205 Electric Union Benefits 0 0 0 0.00 100 0.00 Total Personnel Costs: $ 90,952 $ 89,763 $ 93,441 2,780.04 $ 96,583 $ 21.17 Non-Personnel Costs: _ Total Non-Personnel Costs: $ 0 $ 0 $ 0 $ 0.00 $ 0 $ 0.00 Total Expenditures $ 90,952 $ 89,763 $ 93,441 2,780.04 $ 96,583 $ 21.17 Run:10/08/2015 at 5:13 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Meter Service For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 21,589 35,628 29,973 (15.87) 30,874 3.01 15000 6001 Overtime 183 180 121 (32.78) 124 2.48 15000 6100 Medicare 524 468 440 (5.98) 453 2.95 15000 6102 Workers'Compensation 1,676 1,944 2,734 40.64 2,816 3.00 15000 6200 Leave Time 0 0 0 0.00 832 0.00 15000 6201 Retirement Benefits 0 188 128 (31.93) 133 3.91 15000 6202 Health Insurance 0 0 262 0.00 275 4.96 15000 6205 Electric Union Benefits 0 0 0 0.00 0 0.00 Total Personnel Costs: $ 23,972 $ 38,408 $ 33,658 $ (45.92) $ 35,507 $ 20.31 Non-Personnel Costs: 15000 7002 Postage and Freight 0 0 0 0.00 0 0.00 15000 7009 Contracted Services 54,800 49,444 56,000 13.26 56,000 0.00 15000 7213 Safety Equipment 0 0 0 0.00 0 0.00 15000 7215 Operating Supplies 0 2,000 5,000 149.99 5,000 0.00 Total Non-Personnel Costs: $ 54,800 $ 51,444 $ 61,000 $ 163.25 $ 61,000 $ 0.00 Total Expenditures $ 78,772 $ 89,852 $ 94,658 $ 117.33 $ 96,507 $ 20.31 L1 O Run:10/08/2015 at 5:14 PM Expenditure Detail by Department Electric Enterprise Fund Electric-System Improvements For 1213112014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 0 0 3,459 0.00 3,563 3.01 15000 6001 Overtime 0 0 100 0.00 39 (61.00) 15000 6100 Medicare 0 0 25 0.00 0 (100.00) 15000 6102 Workers'Compensation 0 0 20 0.00 20 0.00 15000 6201 Retirement Benefits 0 65 44 (32.78) 46 4.55 15000 6202 Health Insurance 0 0 69 0.00 73 5.80 15000 6205 Electric Union Benefits 0 0 0 0.00 0 0.00 Total Personnel Costs: $ 0 $ 65 $ 3,717 $ (32.78) $ 3,741 $(147.64) Non-Personnel Costs: 15000 7215 Operating Supplies 0 0 0 0.00 0 0.00 15000 8101 Infrastructure 0 0 120,000 0.00 120,000 0.00 Total Non-Personnel Costs: $ 0 $ 0 $ 120,000 $ 0.00 $ 120,000 $ 0.00 Total Expenditures $ 0 $ 65 $ 123,717 $ (32.78) $ 123,741 $(147.64) Run:10/08/2015 at 5:14 PM Expenditure Detail by Department Electric Enterprise Fund Electric Debt Service For 12131/2014 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 0 0 0 0.00 0 0.00 15000 6100 Medicare 0 0 0 0.00 0 0.00 15000 6102 Workers'Compensation 0 0 0 0.00 0 0.00 15000 6201 Retirement Benefits 61,441 165,266 51,161 (69.04) 52,895 3.39 Total Personnel Costs: $ 61,441 $ 165,266 $ 51,161 $ (69.04) $ 52,895 $ 3.39 Non-Personnel Costs: 15000 8012 Debt Service Interest Expense 306,915 291,536 261,286 (10.38) 255,919 (2.05) 15000 8014 Amortization of Bond Issue Costs 4,904 8,425 0 (100.00) 0 0.00 15000 8300 Debt Service Principal 0 380,000 130,000 (65.79) 135,000 3.85 Total Non-Personnel Costs: $ 311,819 $ 679,961 $ 391,286 $(176.17) $ 390,919 $ 1.80 Total Expenditures $ 373,260 $ 845,227 $ 442,447 $(245.21) $ 443,814 $ 5.19 142 CITY OF SEWARD .-- --- ELECTRIC ENTERPRISE FUND 2016 and 2017 Debt Service Schedule Balance 2016 Budget Balance Description Interest Rate @ 1/01/16 Principal Interest Retirement Total @ 12/31/16 T rm 2008 Replacement Generators Bond 4.77% 5,245,000 130,000 261,286 391,286 5,115,000 200 12/2038 PERS Past Service Cost n/a n/a n/a 51,161 51,161 -- Totals: $5,245,000 $130,000 $261,286 $51,161 $442,447 $5,115,000 Balance 2017 Budget Balance Description Interest Rate @ 1/01/17 Principal Interest Retirement Total @ 12/31/17erm 2008 Replacement Generators Bond 4.77% 5,115,000 135,000 255,919 390,919 4,980,000 200 12/2038 PERS Past Service Cost n/a n/a n/a 52,895 52,895 '\----..______, Totals: $5,115,000 $135,000 $255,919 $52,895 $443,814 $4,980,000 CITY OF SEWARD ELECTRIC ENTERPRISE FUND Budgeted Interfund Transfers Fiscal Year 2016 and 2017 2016 2017 Transfers- Transfers- Transfers- Transfers- In Out In Out TRANSFERS FROM OTHER FUNDS: General Fund -SMIC deficit loan repayment 110,784 110,784 General Fund for ASLC Utility Bill 8,400 16,800 TRANSFERS TO OTHER FUNDS: General Fund: Electric system permit fee $300,000 $300,000 Federal and state lobbying 40,319 40,319 Payments-i n-Lieu-of-Tax 930,309 953,000 $119,184 $1,270,628 $127,584 $1,293,319 LH I°1?fl5 HOSPITAL ENTERPRISE FUND j Budgeted Statement of Revenues and Expenses and Changes in Net Position For 20I6 and 20I7 2014 2015 2016 2017 Actual* Budget Budget Budget Revenues(investment earnings): $0 $5,000 $5,000 $5,000 Operating Expenses: Hospital contributions for capital needs 242,795 462,794 200,000 200,000 Health Facility Expansion I55,889 26I,379 Community Health Center 850,000 (a; 500,000 500,000 400,000 Purchased services 38,350 Depreciation 242,672 203,953 203,953 203,953 Total operating expenses $1,373,817 $1,166,747 $1,059,842 $1,065,332 Non-operating revenues(expense) Gain(loss)on sales of assets 0 0 0 0 Debt service interest (6I,807) (6I,807) (57,979) (53,951) Capital equipment and other _ - Total non-operating revenue(expense ($6I,807) ($6I,807) ($57,979) ($53,95I) Earnings(loss)before transfers ($1,435,624) ($1,223,554) ($1,112,821) ($1,114,283) Operating transfers from other funds I,I36,752 I,092,500 I,072,500 I,092,500 Operating transfers to other funds 0 0 0 0 Change in net position ($298,872) ($I3I,054) ($40,32I) ($2I,783) (a) Clinic space remodel- $I50K;CHC start-up costs- $700,000K °Does not tie to CAFR since City budgets Hospital and LTC separately,and does not budget for PSMCC operations. The CAFR however,aggregates the City's hospital enterprise fund,LTC enterprise fund,and PSMCC financial statements into one fund,since PSMCC operational surpluses or deficits accrue to taxpayers. CITY OF SEWARD HOSPITAL ENTERPRISE FUND Budgeted Statement of Cash Flow For 20I6 and 20I7 2015 2016 2017 Budget Budget Budget Beginning Cash Balance at 1/1/15: $600,058 Cash is provided by(used for): Change in net position (131,054) (40,321) (21,783) Add expense items not affecting cash Depreciation 203,953 203,953 203,953 Net cash provided by operations $72,899 $163,632 $182,170 Other sources (uses) of cash Debt principal ($72,899) ($69,262) ($72,899) Net increase (decrease) in cash 0 94,370 109,271 Estimated ending cash balance $600,058 $694,428 $803,699 CITY OF SEWARD HOSPITAL ENTERPRISE FUND 2016 and 2017 Debt Service Schedule Balance 2016 Budget Balance Description Interest Rate @ 1/01/16 Principal Interest Total @ 12/31/16 Term Hospital PERS loan - F03000 5.25% 808,172 56,148 42,429 98,577 752,024 2007- 2026 Hospital PERS loan - F15001 5.25% 296,195 20,578 15,550 36,128 275,617 2007- 2026 Totals: $1,104,367 $76,726 $57,979 $134,705 $1,027,641 Balance 2017 Budget Balance Description Interest Rate @ 1/01/17 Principal Interest Total @ 12/31/17 Term Hospital PERS loan - F03000 5.25% 752,024 59,095 39,481 98,576 692,929 2007- 2026 Hospital PERS loan - F15001 5.25% 275,617 21,658 14,470 36,128 253,959 2007- 2026 Totals: $1,027,641 $80,753 $53,951 $134,704 $946,888 FINANCIAL PLAN FOR UTILIZATION OF 1%HEALTHCARE SALES TAX Assumptions: (a)SMH census will be inadequate to cover LTC Bond debt service costs in the future;census will come in at 33 rather than 34. Prior to 2015,shortfall is$548,972;recover over remaining 19 years, plus recover annual shortfall due to if census 33. (b) Hospital Enterprise Fund owes Motor Pool Fund$808,172 for SGH PERS Loan;5.25%, matures 1/1/2026 (c)Sales tax revenues increase 1/2 of 1%(0.005%)each year. Projected Sales SMH PSMC Seward CHC Cumulative Cumulative Tax Bond Capital PERS Loan Facility Operating Facility Annual Facility Expansion addtl Bond Revenue(c) Reserve(a) Budget Repay(b) Expansion Budget Expansion Balance Reserve Reserve (548,972.00) 2015 1,092,500 462,794 134,705 500,000 (4,999) 2016 1,097,963 107,368 200,000 134,705 155,889 500,000 - 0 155,889 107,368 2017 1,103,452 107,368 200,000 134,705 161,379 400,000 100,000 0 417,268 214,737 2018 1,108,970 107,368 200,000 134,705 166,897 300,000 200,000 (0) 784,165 322,105 2019 1,114,514 107,368 200,000 134,705 172,441 200,000 300,000 0 1,256,606 429,473 2020 1,120,087 96,418 200,000 134,705 638,964 50,000 (0) 1,895,570 525,891 2021 1,125,687 96,418 200,000 134,705 644,564 50,000 0 2,540,134 622,310 2022 1,131,316 96,418 200,000 134,705 650,193 50,000 (0) 3,190,327 718,728 2023 1,136,972 96,418 200,000 134,705 655,849 50,000 0 3,846,176 815,146 2024 1,142,657 79,993 200,000 134,705 677,959 50,000 0 4,524,135 895,139 2025 1,148,371 79,993 200,000 134,705 683,673 50,000 (0) 5,207,808 975,133 2026 1,154,112 79,993 200,000 134,705 689,414 50,000 0 5,897,222 1,055,126 2027 1,159,883 79,993 200,000 829,890 50,000 (0) 6,727,112 1,135,119 2028 1,165,682 61,743 200,000 853,939 50,000 0 7,581,051 1,196,862 2029 1,171,511 61,743 200,000 859,768 50,000 (0) 8,440,819 1,258,606 2030 1,177,368 61,743 200,000 865,625 50,000 0 9,306,444 1,320,349 2031 1,183,255 61,743 200,000 871,512 50,000 (0) 10,177,956 1,382,092 2032 1,189,172 47,143 200,000 892,028 50,000 0 11,069,984 1,429,235 2033 1,195,117 47,143 200,000 897,974 50,000 0 11,967,958 1,476,379 2034 1,201,093 33,631 200,000 917,462 50,000 (0) 12,885,420 1,510,010 12,885,420 C:\Excel Data\Hospital\1%sales tax plan with PSMC_Cash_Flow_Projections FINANCIAL PLAN FOR UTILIZATION OF 1%HEALTHCARE SALES TAX Scenario: Optimistic Assumptions: (a)SMH census will be inadequate to cover LTC Bond debt service costs in the future;census will come in at 33 rather than 34. Prior to 2015,shortfall is$548,972;recover over remaining 19 years,plus recover annual shortfall due to if census 33. (b)Hospital Enterprise Fund owes Motor Pool Fund$808,172 for SGH PERS Loan;5.25%,matures 1/1/2026 (c)Sales tax revenues increase 1%each year. Projected Sales SMH PSMC Seward CHC Cumulative Cumulative Tax Bond Capital PERS Loan Facility Operating Facility Annual Facility Expansion addtl Bond Revenue(c) Reserve(a) Budget Repay(b) Expansion Budget Expansion Balance Reserve Reserve (548,972.00) 2015 1,092,500 462,794 134,705 500,000 (4,999) 2016 1,103,425 107,368 200,000 134,705 161,352 300,000 200,000 - 361,352 107,368 2017 1,114,459 107,368 200,000 134,705 172,386 100,000 400,000 - 933,738 214,737 2018 1,125,604 107,368 200,000 134,705 183,531 - 500,000 - 1,617,269 322,105 2019 1,136,860 107,368 200,000 134,705 194,787 - 500,000 - 2,312,056 429,473 2020 1,148,228 96,418 200,000 134,705 667,105 - 50,000 - 3,029,161 525,891 2021 1,159,711 96,418 200,000 134,705 678,588 - 50,000 - 3,757,749 622,310 2022 1,171,308 96,418 200,000 134,705 690,185 - 50,000 - 4,497,934 718,728 2023 1,183,021 96,418 200,000 134,705 701,898 - 50,000 - 5,249,832 815,146 2024 1,194,851 79,993 200,000 134,705 730,153 - 50,000 - 6,029,985 895,139 2025 1,206,800 79,993 200,000 134,705 742,102 - 50,000 - 6,822,086 975,133 2026 1,218,868 79,993 200,000 134,705 754,170 - 50,000 - 7,626,256 1,055,126 2027 1,231,056 79,993 200,000 901,063 - 50,000 - 8,577,319 1,135,119 2028 1,243,367 61,743 200,000 931,624 - 50,000 - 9,558,943 1,196,862 2029 1,255,801 61,743 200,000 944,057 - 50,000 - 10,553,000 1,258,606 2030 1,268,359 61,743 200,000 956,615 - 50,000 - 11,559,615 1,320,349 2031 1,281,042 61,743 200,000 969,299 - 50,000 - 12,578,914 1,382,092 2032 1,293,853 47,143 200,000 996,709 - 50,000 - 13,625,623 1,429,235 2033 1,306,791 47,143 200,000 1,009,648 - 50,000 - 14,685,271 1,476,379 2034 1,319,859 33,631 200,000 1,036,228 - 50,000 - 15,771,499 1,510,010 $ 15,771,499 C:\Excel Data\Hospital\1%sales tax plan with PSMC_Cash_Flow_Projections SCHC FINANCIAL OVERVIEW Avg. Monthly Net Patient Annual City Redirected to BASELINE ASSUMPTIONS Visits Revenue per Allocation 1%Reserve Based on May-August 2015 Experience Month Fund* Avg. Monthly Cash Exp. $ 190,000 46 X 1.04(4% margin) x 1.04 690 $138,000 Above BE IIIM $500,000 Monthly Cash Rev.Target $ 197,600 _ 609 _ ` $0 1 Less Monthly 330 Draw $ (75,800) Less Monthly City Allocation $ (41,667) Monthly Net Pt. Rev.Target $ 80,133 500 $100,000 $260,000 im* -A-- $240,000 Avg. Net Rev./Visit _$200 Avg. Monthly Visits to BE -z 400->4,800 2.5 Visits/Patient/Year 1,920 pts. %of Service Area Population 35% 450 $90,000 $380,000 II* $120,000 2019 Projected Volume/ Productivity Visits/Day 15 ---A- x4 days/week 60 x46 weeks/year 2,760 400 2015 Baseline $80,000 $500,000 x3 providers 8,280 12 months 690 Annual Patients 3,312 of Service Area 60% Cash on Hand Goal Updated 9/17/15 SCHC"Primary Reserve" Adjusted for visitors (10%) 54%