Spreadsheet: 864277d1711496859-allocation-of-patient-volumes-creating-a-spread-issue-due-to-rounding-volume-spread-test
Sheet: Budget Team Volumes

 | Hospital Budgets
 | Southern Region - Key Hospital Volumes
 | FY2024 Projection / FY2025 Budget
 | DRAFT as of 02/12/2024
 | Budget A |  | Actuals (July '23 through December '23) |  |  |  |  |  | Projection (January '24 through June '24)
 |  | FY2024 Actual/Projected | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total | Percentage %  FY24 vs FY25
Total Acute Admissions |  | Inpatient
Psych Admissions (included in Acute above) |  | Inpatient Medical
Deliveries |  | Inpatient Surgical |  |  |  |  |  |  |  |  |  |  |  |  | 1035
NICU Admissions (included in Acute above) |  | Inpatient Psych |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Inpatient Skilled Nursing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Acute Less Psych and NICU |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 294
Newborns |  | Total Inpatient |  | 427 | 411 | 431 | 417 | 446 | 448 | 439 | 456 | 398 | 395 | 400 | 5090
TSU Admissions |  | Ambulatory Overnight
Rehab |  | Observation
OBV
AO |  | Outpatient | 24 | 25 | 26 | 27 | 28 | 29 | 30
Total OP Registrations |  | Advanced Imaging
ED Visits |  | Basic Imaging |  |  |  |  |  |  |  |  |  |  |  |  | 21581 |  | 14637
Homecare |  | Cardiac Dx |  |  |  |  |  |  |  |  |  |  |  |  | 6474.000000000001 |  | 4480
 |  | Clinic |  |  |  |  |  |  |  |  |  |  |  |  | 6335.000000000001 |  | 4356
 |  | ED |  |  |  |  |  |  |  |  |  |  |  |  | 25396.99999999999 |  | 17529
Total Acute Admissions |  | EP/Cath | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Psych Admissions (included in Acute above) |  | Home Health |  |  |  |  |  |  |  |  |  |  |  |  | 999.0000000000002 |  | 578
Deliveries |  | Infusion |  |  |  |  |  |  |  |  |  |  |  |  | 4737 |  | 3257
NICU Admissions (included in Acute above) |  | Lab |  |  |  |  |  |  |  |  |  |  |  |  | 28419 |  | 19560
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 12149.09792376821 |  | 8199
Acute Less Psych and NICU |  | OR |  |  |  |  |  |  |  |  |  |  |  |  | 2043 |  | 1401
Newborns |  | Other |  |  |  |  |  |  |  |  |  |  |  |  | 1162 |  | 713
TSU Admissions |  | Other Dx |  |  |  |  |  |  |  |  |  |  |  |  | 808 |  | 563
Rehab |  | Other Procedures | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
OBV |  | RadOnc |  |  |  |  |  |  |  |  |  |  |  |  | 2680 |  | 2110
 |  | Total Outpatient Registrations |  | 12025 | 11062 | 12698 | 12344 | 12086 | 12483 | 7661.219584753641 | 7661.219584753641 | 7661.219584753641 | 7661.219584753641 | 7661.219584753641 | 121809.0979237682
 |  | FY2025 Budget
 |  | Inpatient | FY2025 Budget
 |  | Inpatient Medical
 |  | Inpatient Surgical
 |  | Inpatient Psych | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Inpatient Skilled Nursing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME]
 |  | Total Inpatient
 |  | Ambulatory Overnight
 |  | Observation
 |  | Outpatient | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  | Advanced Imaging
 |  | Basic Imaging
 |  | Cardiac Dx
 |  | Clinic
 |  | ED
 |  | EP/Cath | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Home Health
 |  | Infusion
 |  | Lab
 |  | [NAME]
 |  | OR
 |  | Other
 |  | Other Dx
 |  | Other Procedures | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | RadOnc
 |  | Total Outpatient Registrations
 | Budget B |  | Actuals (July '23 through December '23) |  |  |  |  |  | Projection (January '24 through June '24)
 |  | FY2024 Actual/Projected | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total | Percentage %  FY24 vs FY25
 |  | Inpatient
 |  | Inpatient Medical
 |  | Inpatient Surgical
 |  | Inpatient Psych
 |  | Inpatient Skilled Nursing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME]
 |  | Total Inpatient
 |  | Ambulatory Overnight
 |  | Observation
 |  | Outpatient | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  | Advanced Imaging
 |  | Basic Imaging
 |  | Cardiac Dx
 |  | Clinic
 |  | ED
 |  | EP/Cath
 |  | Home Health
 |  | Infusion
 |  | Lab
 |  | [NAME]
 |  | OR
 |  | Other
 |  | Other Dx
 |  | Other Procedures
 |  | RadOnc
 |  | Total Outpatient Registrations
 |  | FY2025 Budget
 |  | Inpatient | FY2025 Budget
 |  | Inpatient Medical
 |  | Inpatient Surgical
 |  | Inpatient Psych
 |  | Inpatient Skilled Nursing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME]
 |  | Total Inpatient
 |  | Ambulatory Overnight
 |  | Observation
 |  | Outpatient | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  | Advanced Imaging
 |  | Basic Imaging
 |  | Cardiac Dx
 |  | Clinic
 |  | ED
 |  | EP/Cath
 |  | Home Health
 |  | Infusion
 |  | Lab
 |  | [NAME]
 |  | OR
 |  | Other
 |  | Other Dx
 |  | Other Procedures
 |  | RadOnc
 |  | Total Outpatient Registrations
 | Budget C |  | Actuals (July '23 through December '23) |  |  |  |  |  | Projection (January '24 through June '24)
 |  | FY2024 Actual/Projected | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total | Percentage %  FY24 vs FY25
 |  | Inpatient
 |  | Inpatient Medical
 |  | Inpatient Surgical
 |  | Inpatient Psych | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Inpatient Skilled Nursing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Inpatient
 |  | Ambulatory Overnight
 |  | Observation
 |  | Outpatient | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  | Advanced Imaging
 |  | Basic Imaging
 |  | Cardiac Dx
 |  | Clinic
 |  | ED
 |  | EP/Cath
 |  | Home Health
 |  | Infusion
 |  | Lab
 |  | [NAME]
 |  | OR
 |  | Other
 |  | Other Dx
 |  | Other Procedures
 |  | RadOnc
 |  | Total Outpatient Registrations
 |  | FY2025 Budget
 |  | Inpatient | FY2025 Budget
 |  | Inpatient Medical
 |  | Inpatient Surgical
 |  | Inpatient Psych | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Inpatient Skilled Nursing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Inpatient
 |  | Ambulatory Overnight
 |  | Observation
 |  | Outpatient | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  | Advanced Imaging
 |  | Basic Imaging |  |  |  |  |  |  |  |  |  |  |  |  | 9787.19624722231
 |  | Cardiac Dx |  |  |  |  |  |  |  |  |  |  |  |  | 2398
 |  | Clinic |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | ED |  |  |  |  |  |  |  |  |  |  |  |  | 10376.19554695063
 |  | EP/Cath |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Home Health |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Infusion |  |  |  |  |  |  |  |  |  |  |  |  | 2888.75141097999
Deliveries |  | Lab |  |  |  |  |  |  |  |  |  |  |  |  | 2996.105464759959
NICU Admissions (included in Acute above) |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2928.010135697983
 |  | OR |  |  |  |  |  |  |  |  |  |  |  |  | 1825.703642384107
Acute Less Psych and NICU |  | Other |  |  |  |  |  |  |  |  |  |  |  |  | 8.415187004155648
TSU Admissions |  | Other Dx |  |  |  |  |  |  |  |  |  |  |  |  | 483.0285714285716
Rehab |  | Other Procedures |  |  |  |  |  |  |  |  |  |  |  |  | 0
OBV |  | RadOnc |  |  |  |  |  |  |  |  |  |  |  |  | 0
AO |  | Total Outpatient Registrations |  | 3100.816954224945 | 3099.518054398869 | 3239.774520307167 | 3132.784962534782 | 3228.167908339694 | 3218.05037782457 | 2993.143092785231 | 3262.340454332719 | 3210.905376802988 | 3193.113246839605 | 3114.167462903813 | 37887.58324002949