The URL can be used to link to this page

Home My WebLink About10222024 City Council Work Session Laydown - Hospital FundCouncil Work Session 10/22/24 HOSPITAL ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2023 ,2024 2025 and 2026 Beginning Cash Balance at I/I/24*: Cash is provided by (used for): Change in net position Add expense items not affecting cash Depreciation Net cash provided by operations Other sources (uses) of cash Debt principal Net increase (decrease) in cash (b) Estimated ending cash balance ° Ties to December 3I, 2023 cash and investment balance per ACFR SGH PERS loan PMYT owed to Motor Pool Fund loan matures in 2026. 2023 2024 2025 2026 Budget Budget Budget Budget $2,380,164 417,711 407,161 (119,048) (120,477) 370,762 385,750 396,63I 402,977 $788,473 $792,911 $277,583 $282,500 ($80,33I) ($84,549) ($88,988) ($93,659) 708,142 708,362 188,595 188,841 $3,088,306 $3,796,668 $3,985,263 $4,174,104 1 CITY OF SEWARD HOSPITAL ENTERPRISE FUND Budgeted Revenue and Expenditures For Fiscal Year 2023, 2024 ,2025 and 2026 Revenue 2023 2024 2025 2026 19100-0000 General Operations $ - $ $ - $ - Total: $ - $ - $ - $ - Non -operating revenue: $ 15,000 $ 15,000 $ 20,000 $ 20,000 $ 15,000 $ 15,000 $ 20,000 $ 20,000 Transfers In: $ 1,625,000 $ 1,625,000 $ 812,500 $ 812,500 Total Revenues: $ 1,640,000 $ 1,640,000 $ 832,500 $ 832,500 Expenditures 19100-0000 General Operations $ 1,058,262 $ 1,073,250 $ 796,631 $ 802,977 19100-0000 Debt Service Interest $ 14,027 $ 9,589 $ 4,917 $ Total: $ 1,072,289 $ 1,082,839 $ 801,548 $ 802,977 Transfers Out $ 150,000 $ 150,000 $ 150,000 $ 150,000 Total Expenditures $ 1,222,289 $ 1,232,839 $ 951,548 $ 952,977 Revenue over expenses: $ 417,711 $ 407,161 $ (119,048) $ (120,477) Depreciation Expense: $ Depreciation Expense: $ Revenue over Expenditures (less depreciation): $ SGH PERS loan PMYT owed to Motor Pool Fund loan matures in 2026. 370,762 $ 385,750 $ 396,631 $ 385,750 370,762 $ 385,750 $ 396,631 $ 385,750 788,473 $ 792,911 $ 277,583 $ 265,273 2 Healthcare Enterprise (19100-0000) Revenue & Expense Budget Revenues: Non -Operating Revenue: 5899 Miscellaneous Revenue 5901 EF Investment Interest 5940 Amort. Of CIA - General Total Non -Operating Revenue: Total Revenue: Expenditures: Non -Personnel Costs: 7009 Contracted Services 7809 Pass-Thru Payments* 7810 Miscellaneous Expense 7900 Depreciation Expense 8001 Unrealized Loss on Investments 8012 Debt Service Interest Expense 8300 Debt Service Principal** Total Non -Personnel Costs: Total Expenditures: 2021 2022 2023 Actual Actual Actual 2024 YTD Actuals (6/30) 2024 Budget Proposed 2025 Budget Proposed 2026 Budget 0 16,549 0 0 79,883 0 0 545,397 0 0 104,608 15,000 20,000 0 20,000 $16,549 $79,883 $545,397 $104,608 $16,549 $79,883 $545,397 $104,608 $15,000 $15,000 $20,000 $20,000 $20,000 $20,000 0 0 0 687,500 687,500 687,500 0 0 0 348,959 360,706 392,704 54,124 232,704 51,242 22,252 18,245 14,028 72,517 76,324 80,331 $1,185,352 $1,375,479 $1,225,805 $1,185,352 $1,375,479 $1,225,805 0 0 0 0 21,901 0 0 $21,901 $21,901 0 687,500 0 385,750 0 9,589 84,549 $1,167,388 $1,167,388 400,000 400,000 396,631 402,977 4,917 - 88,988 93,659 $890,536 $896,636 $890,536 $896,636 * Calculation based on the depreciation of the hospital's assets in 2023. No new addition reported to the City. **SGH PERS loan PMYT owed to Motorpool Fund loan matures in 2026. 3 CITY OF SEWARD SEWARD MOUNTAIN HAVEN ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2023 ,2024, 2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Beginning Cash Balance at I/I/24*: Cash - Legally Required Bond Reserves (a) $1,392,950 Cash - Reserved for Bond Payments (a) $12,765,731 $ 14,158,681.00 Cash is provided by (used for): Change in net position Add expense items not affecting cash Depreciation Net cash provided by operations Other sources (uses) of cash Debt principal Net increase (decrease) in cash Estimated ending cash balance ° Ties to December 3I, 2023 cash and investment balance per ACFR (a) Seward Mountain Haven revenue bonds; matures 2033 1,785,865 1,930,000 (1,283,756) (1,221,756) I,068,745 I,070,000 I,065,000 I,070,000 $2,854,610 $3,000,000 ($218,756) ($151,756) (1,000,000) (1,045,000) (1,100,000) (1,045,000) $1,854,610 $1,955,000 ($1,318,756) ($1,196,756) $16,013,291 $17,968,291 $16,649,535 $15,452,779 4 Revenue 19200-0000 General Operations For Fiscal Year 2023, 2024 2025 and 2026 Seward Mountain Haven - Revenue & Expenditures Total: Non -operating revenue: $ $ $ 2023 2024 2025 2026 3,179,672 $ 3,275,062 3,179,672 $ - $ 3,275,062 $ - $ $ $ 3,179,672 $ 3,275,062 $ - $ Transfers In: $ 150,000 $ 150,000 $ 150,000 $ 150,000 Total Revenues: $ 3,329,672 $ 3,425,062 $ 150,000 $ 150,000 Expenditures 19200-0000 General Operations $ 1,068,745 $ 1,070,000 $ 1,065,000 $ 1,058,000 19200-0000 Debt Service Interest $ 475,062 $ 425,062 $ 368,756 $ 313,756 Total: $ 1,543,807 $ 1,495,062 $ 1,433,756 $ 1,371,756 Total Expenditures $ 1,543,807 $ 1,495,062 $ 1,433,756 $ 1,371,756 Revenue over expenses: $ 1,785,865 $ 1,930,000 $ (1,283,756) $ (1,221,756) Depreciation Expense: $ Total Depreciation Expense: $ Revenue over Expenditures (less depreciation expense): $ 1,068,745 $ 1,070,000 $ 1,065,000 $ 1,058,000 1,068,745 $ 1,070,000 $ 1,065,000 $ 1,058,000 2,854,610 $ 3,000,000 $ (218,756) $ (163,756) 5 Seward Mountain Haven (19200-0000) Revenue and Expense Budget Revenues: Operating Revenues: ### SMH Patient Revenue for Capital Total Operating Revenue: Non -Operating Revenues: ### EF Investment Interest ### Amort. Bond Premium Total Non -Operating Revenue: Total Revenue: Expenditures: Non -Personnel Costs: 7900 Depreciation Expense 8012 Debt Service Interest 8013 Amort Deffered Loss on Bonds 8300 Debt Service Principal Total Non -Personnel Costs: Total Expenditures 2024 YTD 2021 2022 2023 Actuals Actual Actual Actual (6/30) 3,087,060 3,246,707 3,403,472 2024 Budget 666,066 3,275,062 2025 Budget 2026 Budget 3,087,060 3,246,707 3,403,472 666,066 3,275,062 94,140 94,140 94,140 94,140 94,140 94,140 94,140 3,181,200 94,140 94,140 3,340,847 3,497,613 666,066 94,140 94,140 94,140 3,369,202 94,140 94,140 1,071,165 545,006 98,196 910,000 1,068,744 498,755 98,196 950,000 1,064,766 450,173 98,196 1,000,000 421,026 1,045,000 1,070,000 421,006 98,196 1,045,000 1,065,000 368,756 98,196 1,100,000 1,058,000 313,756 98,196 1,150,000 2,624,367 2,615,695 2,613,134 1,466,026 $ 2,624,367 $ 2,615,695 $ 2,613,134 $1,466,026 2,634,202 2,631,952 2,619,952 $ 2,634,202 $ 2,631,952 $ 2,619,952 * Calculation based on the depreciation of the hospital's assets in 2023. No new addition reported to the City. SEWARD MEDICAL CENTER Income Statement (000s) For the period ending September 30, 2024 Gross Service Revenues - Service Gross Service Revenues Deductions From Revenue Prior 3.mo Jun2024 JuI2024 Aug2024 Trend 4,400 4,718 5,059 4,726 1,194 2,443 2,038 1,892 Actual Budget Act vs Bud Sep2024 Sep2024 $Var %Var %Var 3,917 3,697 221 6.0% 0.0% 1,700 1,336 (364) (27.2%) 0.0% Actual vs. PM $Var %Var (1,142) (22.6%) 338 16.6% Act vs Trend $Var %Var (808) (17.1%) 192 10.1% Year•to-Date YTD Actual YTD Budget $ Var % Var Prior Year 38,147 33,137 5,010 15.1% 34,489 14,421 11,871 (2,551) -21.5% 12,682 Net Service Revenue 3,205 2,275 3,021 2,834 2,217 2,360 (143) (6.1%) 0.0% (804) (26.6%) (617) (21.8%) 23,726 21,267 2,459 11.6% 21,807 Other Operating Revenue Capitation Revenue 0.0% 0.0% 0.0% 0.0% 0.0% Premium Revenue - 0.0% 0.0% 0.0% 0.0% - 0.0% - Other Operating Revenue 39 26 8 24 17 22 (6) (26.3%) 0.0% 8 105.0% (8) (31.9%) 195 205 (10) -5.0% 184 Total Other Operating Revenue 39 26 8 24 17 22 (6) (26.3%) 0.0% 8 105.0% (8) (31.9%) 195 205 (10) -5.0% 184 Net Operating Revenue 3,244 2,301 3,030 2,858 2,234 2,383 (149) (6.2%) 0.0% (796) (26.3%) (624) (21.8%) 23,921 21,472 2,449 11.4% 21,991 Purchased Healthcare Expenses - - - - - 1 1 100.0% 0.2% - 0.0% - 0.0% Salaries And Wages 1,279 1,390 1,375 1,348 1,333 1,288 (46) (3.5%) 0.0% 42 3.0% 15 1.1% Employee Benefits 271 258 278 269 273 294 21 7.0% 0.0% 5 1.6% (4) (1.5%) Professional Fees Expense 1 1 0 1 4 5 1 23.0% 0.0% (4) (11117.3%) (3) (475.7%) Supplies 80 128 127 111 110 92 (18) (19.3%) 0.0% 17 13.3% 2 1.5% Purchased Services Expense 260 224 385 290 378 296 (81) (27.3%) 0.0% 7 1.9% (88) (30.3%) Depreciation Expense 8 8 8 8 8 9 1 15.5% 0.0% (0) (0.4%) 0 2.9% Interest And Amortization 0 0 0 0 0 (0) (1) 170.2% (0.3%) 0 7.9% 0 20.4% Bad Debts Expense - - - - - - - 0.0% 0.0% 0.0% - 0.0% Other Expenses 111 104 117 111 96 107 11 10.2% 0.0% 21 17.7% 15 13.1% Total Operating Expenses 2,010 2,114 2,289 2,138 2,201 2,091 (111) (5.3%) 0.0% 88 3.8% (64) (3.0%) Net Operating Income 1,234 188 741 721 33 292 (259) (88.8%) 0.0% (708) (95.6%) (688) (95.5%) Non Operating Gains (Loss) - - - - - - - 0.0% 0.0% 0.0% - 0.0% Excess of Revenue Over Expenses from Operations 1,234 188 741 721 33 292 (259) (88.8%) 0.0% (708) (95.6%) (688) (95.5%) System Cost Allocations - - 0.0% 0.0% 0.0% 0.0% Operating EBIDA 1,243 196 748 729 41 301 (260) (86.5%) 0.0% - 5 5 100.0% 3 12,191 11,747 (444) -3.8% 11,626 2,339 2,640 301 11.4% 2,590 16 45 29 64.7% 31 1,052 832 (220) -26.4% 1,005 2,767 2,707 (60) -2.2% 2,334 65 81 17 20.7% 16 3 (4) (7) 183.9% 4 0.0% - 1,137 979 (158) -16.2% 884 19,570 19,033 (537) -2.8% 18,494 4,351 2,439 1,911 78.4% 3,497 - - - 0.0% 0 4,351 2,439 1,911 78.4% 3,497 (708) (94.6%) (688) (94.4%) 4,418 2,517 1,901 0.0% 75.5% 3,516 C:\Users\sjusinorAppData\Local\Microsoft\Windows\INetCache\Content.Outlook\ZDRCOF7Y\PSMC Q3 2024 Fin Stmt.xlsx 7 1000 Seward Page 1 of 1 Operating Metrics Acuted Adjusted Admissions 179 493 174 282 Acute Admits 6 10 8 8 Acute Patient Days 32 22 29 28 Acute Length of Stay 5.33 2.20 3.63 3.72 Case -Mix Adjusted Admissions (CMAA) 207 354 188 250 Net Service Revenue per CMAA 15,469 6,433 16,037 11,336 Salaries per CMAA 6,171 3,930 7,298 5,391 Supplies per CMAA 385 362 672 446 Total Operating Expense per CMAA 9,702 5,976 12,149 8,551 Observations 16 11 4 10 Emergency Room Visits 215 301 283 266 Inpatient ER Visits 2 2 5 3 Outpatient ER Visits 213 299 278 263 Surgeries and Procedures Inpatient Surgery Cases Outpatient Surgery Cases Inpatient Procedures Outpatient Procedures Acute Outpatient Visits 1,414 1,621 1,444 1,493 Outpatient ER Visits 213 299 278 263 Other Outpatient Visits 1,201 1,322 1,166 1,230 Labor Metrics Hours (000s) Paid Hours 24 25 26 25 %Agency 12.0% 19.6% 22.3% 18.1% Salaries as a % of GSR 29.1% 29.5% 27.2% 28.5% Salaries, net PTO & Agency as a % of GSR 23.1% 21.8% 20.0% 21.6% Salaries as a % of NOR 39.4% 60.4% 45.4% 47.2% Salaries, net PTO & Agency as a % of NOR 31.4% 44.7% 33.4% 35.7% FTE's 143 144 147 144 Supply Metrics % Pharmacy Supplies 19.7% 8.7% 25.5% 17.7% % Medical Supplies 44.4% 50.0% 34.8% 42.9% Supplies as a % of GSR 1.8% 2.7% 2.5% 2.4% Supplies as a % of NOR 2.5% 5.6% 4.2% 3.9% Physician Services Outpatient Surgeries And Procedures Primary & Specialty Visits Worked RVUs 261 5 12 2.40 256 8,650 5,200 428 8,587 3 227 3 224 1,297 224 1,073 24 19.3% 34.0% 25.3% 59.7% 44.4% 141 12.8% 27.6% 2.8% 4.9% 219 42 19.0% 0.5% 86 49.5% (21) (7.6%) 261 219 42 19.0% 114 6 (1) (22.1%) 15.6% (3) (37.5%) (3) (37.5%) 62 57 5 8.4% 48 21 (9) (41.8%) 4.8% (17) (58.6%) (16) (57.1%) 239 184 55 29.9% 143 3.22 (0.82) (25.4%) 31.1% (1.23) (33.8%) (1.32) (35.5%) 2.40 3.22 (0.82) -25.4% 2.67 197 59 30.2% 0.5% 68 36.1% 6 2.5% 1,868 1,763 105 6.0% 1,868 11,984 (3,334) (27.8%) 0.0% (7,387) (46.1%) (2,686) (23.7%) 12,699 12,063 636 5.3% 11,672 6,537 1,337 20.5% 0.0% 2,098 28.7% 191 3.5% 6,525 6,663 138 2.1% 6,223 467 39 8.4% 0.2% 244 36.3% 18 4.0% 563 472 (91) -19.3% 538 10,612 2,025 19.1% 0.0% 3,562 29.3% (36) (0.4%) 10,475 10,793 318 2.9% 9,897 10 (7) (70.9%) 9.7% (1) (25.0%) (7) (70.0%) 71 92 (21) -22.7% 95 187 40 21.6% 0.5% (56) (19.8%) (39) (14.7%) 1,811 1,665 146 8.8% 1,915 1 2 119.6% 73.2% (2) (40.0%) - 0.0% 29 12 17 138.1% 15 185 39 20.9% 0.5% (54) (19.4%) (39) (14.8%) 1,782 1,653 129 7.8% 1,900 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1,190 107 9.0% 0.1% (147) (10.2%) (196) (13.1%) 11,183 10,617 566 5.3% 9,339 185 39 20.9% 0.5% (54) (19.4%) (39) (14.8%) 1,782 1,653 129 7.8% 1,900 1,005 68 6.8% 0.1% (93) (8.0%) (157) (12.8%) 9,401 8,964 437 4.9% 7,439 26 2 8.3% 0.0% 2 7.3% 1 4.8% 223 245 22 8.9% 223 21.2% 1.9% 9.0% 473.7% 3.0% 13.5% -1.2% (6.6%) 22.1% 22.0% -0.1% -0.5% 26.2% 34.8% 0.8% 2.3% 287.5% -6.8% (25.0%) -5.5% (19.3%) 32.0% 35.5% 3.5% 9.9% 33.7% 24.9% -0.4% (1.6%) 400.0% -5.3% (26.5%) -3.7% (17.1%) 23.0% 25.1% 2.1% 8.4% 23.0% 54.0% -5.7% (10.6%) 186.0% -14.3% (31.5%) -12.5% (26.5%) 51.0% 54.7% 3.7% 6.8% 52.9% 38.6% -5.8% (15.0%) 258.6% -11.0% (32.9%) -8.7% (24.4%) 36.6% 38.7% 2.1% 5.4% 36.0% 153 13 8.3% 0.6% 6 4.2% 3 2.3% 143 157 14 8.9% 132 14.4% 1.6% 11.1% 693.8% 12.7% 49.8% 4.9% 27.7% 15.7% 14.3% -1.4% -9.8% 22.0% 34.5% 6.9% 20.0% 289.9% 7.2% 20.7% 15.3% 35.7% 39.7% 34.1% -5.6% -16.4% 38.2% 2.5% -0.3% (12.0%) 4000.0% -0.3% (12.0%) -0.4% (16.7%) 2.8% 2.5% -0.3% -12.0% 2.9% 3.9% -1.0% (25.6%) 2560.0% -0.7% (16.7%) -1.0% (25.6%) 4.4% 3.9% -0.5% -12.8% 4.6% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% C:\Users\sjusinoLNppData\Local\Microsoft\Windows\INetCache\Content.Outlook\ZDRCOF7Y\PSMC Q3 2024 Fin Stmt.xlsx 8 1000 Seward Page 1 of1