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

Inpatient - Medical |  |  |  |  |  |  |  |  |  |  | -1 |  | -1 |  | 2 |  | -3 | -2 | 2 | 1 | -2 | 0 | 2 | 0 | 1 | 1 | 1 | 1
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 45 | 36 | 47 | 46 | 44 | 53
Medicare Mgd Care | 22 | 30 | 37 | 32 | 20 | 29
Medical Assistance | 0 | 0 | 1 | 2 | 0 | 0
MA Mgd Care | 5 | 3 | 3 | 5 | 9 | 10
Capital Blue Cross | 0 | 3 | 1 | 2 | 1 | 3
Capital Blue Cross Indemnity | 1 | -1 | 1 | -1 | 1 | 1
Capital Blue Cross Mgd Care | 0 | 0 | 2 | 0 | 1 | 0
HighMark BS | 4 | 4 | 3 | 3 | 2 | 4
HighMark Flex Blue | 2 | 1 | 1 | 0 | 0 | 3
Independence BC | 0 | 1 | 0 | 0 | 0 | 0
Valley Preferred | 2 | 1 | 0 | 4 | 3 | 4
Aetna VP | 1 | 0 | 1 | 1 | 0 | 0
Geisinger VP | 0 | 0 | 1 | 0 | 0 | 1
Self Pay | 0 | 1 | 1 | 2 | 0 | 1
LVHN Health Plan | 4 | 0 | 0 | 3 | 2 | 5
Auto | 1 | 3 | 2 | 2 | 1 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
Total | 87 | 82 | 101 | 101 | 84 | 114
 |  |  |  |  |  | **Check**
Inpatient - Surgical |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | -20 |  | -1 | -1 | -2 | -2 | -1 | -2 | -2 | -1 | -2 | -2 | -2 | -2
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 1 | 0 | 3 | 2 | 4 | 3
Medicare Mgd Care | 0 | 1 | 2 | 2 | 1 | 1 |  |  | 0.21875 |  |  |  | 15 |  | 15
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
MA Mgd Care | 1 | 0 | 0 | 0 | 2 | 1 |  |  | 0.125 |  |  |  | 9 |  | 9
Capital Blue Cross | 0 | 0 | 0 | 0 | 2 | 0 |  |  | 0.0625 |  |  |  | 4 |  | 4
Capital Blue Cross Indemnity | 1 | 0 | 0 | 0 | 0 | 0 |  |  | 0.03125 |  |  |  | 2 |  | 2
Capital Blue Cross Mgd Care | 1 | 0 | 0 | 0 | 0 | 0 |  |  | 0.03125 |  |  |  | 2 |  | 2
HighMark BS | 0 | 0 | 0 | 3 | -1 | 0 |  |  | 0.0625 |  |  |  | 4 |  | 4
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
Valley Preferred | 0 | 0 | 0 | 1 | 1 | 0 |  |  | 0.0625 |  |  |  | 4 |  | 4
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 6 | 5 | 6 | 6 | 7 | 6 | 6 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 8 | 4 | 6 | 4 | 6 | 8 | 6 | 8 | 4 | 4
 |  |  |  |  |  | **Check** |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | -2 | 1 | -2 | 0 | 1 | 0 | 2 | -2 | -2
Inpatient - Rehab |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
Inpatient - Psych |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
Inpatient - Skilled Nursing |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
Ambulatory Overnight |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | -2 |  | 0 | -1 | 0 | -1 | -1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 1 | 0 | 1 | 1 | 2
Medicare Mgd Care | 0 | 2 | 1 | 0 | 1 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 1 | 0 | 0 | 0
HighMark BS | 0 | 1 | 1 | 0 | 2 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 4 | 3 | 1 | 4 | 2
 |  |  |  |  |  | **Check**
Observation |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | -2 |  | -1 | -1 | -1 | 0 | 0 | -1 | 0 | 0 | 1 | 0 | 1 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 2 | 13 | 6 | 4 | 9 | 11
Medicare Mgd Care | 10 | 8 | 10 | 6 | 11 | 14
Medical Assistance | 0 | 0 | 1 | 1 | 1 | 1
MA Mgd Care | 8 | 5 | 1 | 4 | 7 | 9
Capital Blue Cross | 5 | 1 | 2 | 1 | 0 | 2
Capital Blue Cross Indemnity | 0 | 1 | 0 | 3 | 0 | 3
Capital Blue Cross Mgd Care | 0 | 1 | 0 | 0 | 0 | 1
HighMark BS | 5 | 5 | 5 | 1 | 2 | 4
HighMark Flex Blue | 1 | 3 | 1 | 4 | 1 | 0
Independence BC | 0 | 0 | 0 | 1 | 0 | 0
Valley Preferred | 0 | 1 | 1 | 1 | 1 | 0
Aetna VP | 1 | 1 | 1 | 0 | 0 | 0
Geisinger VP | 0 | 1 | 0 | 1 | 0 | 0
Self Pay | 0 | 2 | 0 | 0 | 0 | 0
LVHN Health Plan | 1 | 0 | 2 | 2 | 0 | 2
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 3 | 2 | 0 | 1 | 2 | 3
 | 36 | 44 | 30 | 30 | 34 | 50
 |  |  |  |  |  | **Check**
Outpatient |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 750 | 820 | 821 | 1029 | 916 | 850
Medicare Mgd Care | 581 | 599 | 542 | 656 | 609 | 558
Medical Assistance | 14 | 12 | 18 | 20 | 18 | 14
MA Mgd Care | 501 | 532 | 549 | 561 | 530 | 502
Capital Blue Cross | 219 | 260 | 251 | 296 | 265 | 282
Capital Blue Cross Indemnity | 97 | 114 | 98 | 140 | 147 | 138
Capital Blue Cross Mgd Care | 48 | 62 | 43 | 69 | 87 | 93
HighMark BS | 305 | 311 | 267 | 309 | 345 | 375
HighMark Flex Blue | 65 | 82 | 88 | 82 | 109 | 103
Independence BC | 55 | 30 | 44 | 49 | 60 | 51
Valley Preferred | 112 | 103 | 100 | 112 | 124 | 124
Aetna VP | 74 | 85 | 84 | 82 | 90 | 59
Geisinger VP | 38 | 36 | 28 | 43 | 37 | 38
Self Pay | 60 | 67 | 59 | 57 | 67 | 80
LVHN Health Plan | 175 | 190 | 180 | 216 | 236 | 208
Auto | 24 | 16 | 27 | 17 | 17 | 36
Workers Comp | 38 | 30 | 34 | 42 | 34 | 36
All Other | 101 | 92 | 100 | 113 | 128 | 127
 | 3257 | 3441 | 3333 | 3893 | 3819 | 3674
 |  |  |  |  |  | **Check**
Advanced Imaging |  |  |  |  |  |  |  |  |  |  | 0.4406263796299754 |  | 0.4406263796299754 |  | 2.822966398205608 |  | -1.14583513386799 | -0.4875223473760002 | -1.811100739022038 | 1.046699586861052 | 1.125499907768017 | 1.499742759133994 | 1.222787935938982 | -2.362056678058991 | -0.1697678105169871 | 1.216543415787953 | 1.810165591926022 | 0.8778099096329584
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 105 | 111 | 102 | 139 | 135 | 113
Medicare Mgd Care | 70 | 70 | 73 | 93 | 75 | 77
Medical Assistance | 0 | 0 | 0 | 0 | 1 | 1
MA Mgd Care | 30 | 37 | 39 | 31 | 38 | 30
Capital Blue Cross | 26 | 27 | 35 | 39 | 38 | 26
Capital Blue Cross Indemnity | 5 | 18 | 13 | 17 | 16 | 13
Capital Blue Cross Mgd Care | 9 | 13 | 3 | 9 | 11 | 14
HighMark BS | 41 | 36 | 30 | 41 | 36 | 38
HighMark Flex Blue | 7 | 7 | 10 | 14 | 12 | 13
Independence BC | 3 | 4 | 2 | 9 | 5 | 4
Valley Preferred | 11 | 9 | 5 | 11 | 9 | 14
Aetna VP | 8 | 9 | 10 | 9 | 11 | 4
Geisinger VP | 2 | 7 | 0 | 5 | 3 | 1
Self Pay | 0 | 3 | 5 | 3 | 4 | 4
LVHN Health Plan | 17 | 11 | 22 | 21 | 17 | 23
Auto | 0 | 2 | 2 | 2 | 0 | 4
Workers Comp | 11 | 3 | 5 | 9 | 1 | 3
All Other | 8 | 10 | 11 | 12 | 8 | 9
 | 353 | 377 | 367 | 464 | 420 | 391
 |  |  |  |  |  | **Check**
Basic Imaging |  |  |  |  |  |  |  |  |  |  | -0.6457597496191738 |  | -0.6457597496191738 |  | -6.196247222309466 |  | -1.121539862527015 | -1.372894627559958 | -0.1505539166889776 | 0.1292176566919352 | -0.6695841351819354 | 0.06274041135998232 | 0.6059628696970094 | -0.7553775892579324 | 0.3092733620750323 | -1.117315294022887 | -0.2822793591659547 | -1.833896737727969
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 178 | 220 | 191 | 272 | 266 | 220
Medicare Mgd Care | 136 | 159 | 140 | 170 | 149 | 117
Medical Assistance | 1 | 0 | 0 | 1 | 0 | 3
MA Mgd Care | 65 | 70 | 77 | 84 | 72 | 55
Capital Blue Cross | 56 | 68 | 60 | 99 | 88 | 96
Capital Blue Cross Indemnity | 32 | 40 | 31 | 58 | 62 | 52
Capital Blue Cross Mgd Care | 14 | 25 | 17 | 24 | 30 | 36
HighMark BS | 89 | 113 | 83 | 109 | 146 | 122
HighMark Flex Blue | 23 | 34 | 22 | 30 | 39 | 28
Independence BC | 18 | 3 | 14 | 12 | 22 | 15
Valley Preferred | 37 | 26 | 36 | 34 | 46 | 47
Aetna VP | 21 | 25 | 25 | 27 | 32 | 31
Geisinger VP | 5 | 9 | 8 | 9 | 9 | 11
Self Pay | 9 | 7 | 2 | 1 | 2 | 8
LVHN Health Plan | 47 | 49 | 47 | 72 | 88 | 64
Auto | 1 | 0 | 0 | 1 | 2 | 3
Workers Comp | 1 | 0 | 0 | 3 | 1 | 3
All Other | 20 | 21 | 15 | 34 | 40 | 30
 | 753 | 869 | 768 | 1040 | 1094 | 941
 |  |  |  |  |  | **Check**
Cardiac Dx |  |  |  |  |  |  |  |  |  |  | 0 |  | -1 |  | 3 |  | -1 | 0 | -1 | 2 | -1 | 1 | 2 | -1 | 1 | 1 | 2 | -2
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 48 | 69 | 59 | 100 | 74 | 71
Medicare Mgd Care | 45 | 46 | 55 | 46 | 57 | 53
Medical Assistance | 1 | 0 | 1 | 0 | 2 | 0
MA Mgd Care | 13 | 16 | 17 | 27 | 26 | 17
Capital Blue Cross | 14 | 14 | 13 | 16 | 9 | 10
Capital Blue Cross Indemnity | 4 | 5 | 12 | 7 | 3 | 5
Capital Blue Cross Mgd Care | 1 | 1 | 0 | 4 | 11 | 1
HighMark BS | 22 | 21 | 14 | 15 | 14 | 28
HighMark Flex Blue | 3 | 6 | 5 | 7 | 8 | 3
Independence BC | 4 | 3 | 4 | 1 | 2 | 3
Valley Preferred | 9 | 12 | 7 | 6 | 7 | 9
Aetna VP | 6 | 8 | 5 | 2 | 6 | 3
Geisinger VP | 3 | 5 | 2 | 3 | 1 | 1
Self Pay | 0 | 2 | 2 | 2 | 1 | 1
LVHN Health Plan | 9 | 17 | 12 | 9 | 12 | 5
Auto | 0 | 1 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 1 | 1 | 0 | 0
All Other | 7 | 6 | 4 | 3 | 7 | 8
 | 189 | 232 | 213 | 249 | 240 | 218
 |  |  |  |  |  | **Check**
Clinic |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
ED |  |  |  |  |  |  |  |  |  |  | 0.4893514036793931 |  | -0.5106485963224259 |  | 0.8044530493698403 |  | -0.7952565343659899 | 1.680058083253016 | 1.097773475314966 | -0.6098741529530116 | 0.2962245885770471 | 2.040174249758024 | -2.179090029041959 | -1.306873184897995 | 2.324782187801929 | -1.722168441433041 | -0.07986447241103178 | 0.05856727976788534
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 131 | 123 | 128 | 160 | 116 | 143
Medicare Mgd Care | 140 | 117 | 108 | 127 | 108 | 115
Medical Assistance | 9 | 9 | 14 | 15 | 9 | 7
MA Mgd Care | 294 | 286 | 304 | 298 | 269 | 306
Capital Blue Cross | 70 | 85 | 80 | 69 | 65 | 72
Capital Blue Cross Indemnity | 27 | 26 | 20 | 33 | 38 | 30
Capital Blue Cross Mgd Care | 15 | 11 | 14 | 17 | 19 | 28
HighMark BS | 98 | 71 | 76 | 83 | 80 | 113
HighMark Flex Blue | 19 | 19 | 24 | 18 | 21 | 22
Independence BC | 19 | 9 | 12 | 19 | 20 | 17
Valley Preferred | 30 | 31 | 30 | 38 | 37 | 39
Aetna VP | 16 | 20 | 18 | 19 | 16 | 7
Geisinger VP | 14 | 5 | 10 | 11 | 13 | 11
Self Pay | 47 | 44 | 43 | 42 | 55 | 59
LVHN Health Plan | 38 | 36 | 37 | 38 | 45 | 42
Auto | 15 | 7 | 13 | 10 | 7 | 18
Workers Comp | 13 | 12 | 13 | 15 | 9 | 7
All Other | 37 | 23 | 35 | 33 | 40 | 37
 | 1032 | 934 | 979 | 1045 | 967 | 1073
 |  |  |  |  |  | **Check**
EP/Cath |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
Home Health |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
Infusion |  |  |  |  |  |  |  |  |  |  | 0.4576706003099389 |  | 0.4576706003094841 |  | -11.75141097998994 |  | -2.14289379168801 | -0.315546434069006 | -0.7637249871729921 | -1.69497178040001 | -0.5569522832219889 | -0.005130836326003418 | -1.143150333503996 | -0.6600820933809928 | -1.384556182658002 | -0.315546434069006 | -0.6603386351980021 | -2.108517188301988
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 110 | 132 | 114 | 110 | 94 | 110
Medicare Mgd Care | 63 | 61 | 48 | 52 | 68 | 51
Medical Assistance | 0 | 1 | 0 | 0 | 0 | 1
MA Mgd Care | 23 | 22 | 19 | 24 | 31 | 22
Capital Blue Cross | 10 | 16 | 9 | 17 | 13 | 26
Capital Blue Cross Indemnity | 5 | 4 | 7 | 7 | 4 | 4
Capital Blue Cross Mgd Care | 0 | 2 | 3 | 3 | 6 | 1
HighMark BS | 8 | 14 | 6 | 10 | 7 | 12
HighMark Flex Blue | 3 | 0 | 4 | 0 | 4 | 4
Independence BC | 1 | 4 | 4 | 2 | 4 | 4
Valley Preferred | 9 | 5 | 6 | 5 | 3 | 1
Aetna VP | 1 | 3 | 3 | 9 | 6 | 5
Geisinger VP | 6 | 8 | 5 | 9 | 4 | 3
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 12 | 18 | 13 | 20 | 13 | 9
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 8 | 9 | 11 | 12 | 7 | 6
 | 259 | 299 | 252 | 280 | 264 | 259
 |  |  |  |  |  | **Check**
Lab |  |  |  |  |  |  |  |  |  |  | 0.8455056179800522 |  | -0.1544943820208573 |  | -14.10546475995898 |  | -0.8106060606060055 | -1.487997957098997 | -1.503745318352003 | -2.041879468845991 | -1.912070139598029 | 0.07218249914899388 | -1.057626830098997 | 0.7527238678920014 | -2.624106230848014 | -2.203183520598998 | -1.636704119850009 | 0.347548518897014
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 55 | 50 | 81 | 97 | 82 | 82
Medicare Mgd Care | 44 | 59 | 48 | 71 | 58 | 61
Medical Assistance | 0 | 0 | 0 | 1 | 2 | 1
MA Mgd Care | 33 | 41 | 32 | 44 | 43 | 26
Capital Blue Cross | 10 | 17 | 25 | 28 | 19 | 14
Capital Blue Cross Indemnity | 10 | 7 | 4 | 3 | 8 | 9
Capital Blue Cross Mgd Care | 4 | 3 | 1 | 4 | 5 | 2
HighMark BS | 10 | 13 | 16 | 17 | 20 | 17
HighMark Flex Blue | 5 | 2 | 7 | 6 | 8 | 13
Independence BC | 2 | 2 | 4 | 2 | 1 | 4
Valley Preferred | 7 | 6 | 5 | 6 | 12 | 5
Aetna VP | 10 | 8 | 8 | 4 | 5 | 1
Geisinger VP | 4 | 0 | 1 | 2 | 2 | 3
Self Pay | 1 | 3 | 3 | 1 | 0 | 1
LVHN Health Plan | 25 | 32 | 23 | 32 | 30 | 28
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 1 | 0 | 1 | 0 | 1 | 0
All Other | 9 | 9 | 13 | 9 | 15 | 13
 | 230 | 252 | 272 | 327 | 311 | 280
 |  |  |  |  |  | **Check**
[NAME] |  |  |  |  |  |  |  |  |  |  | 0.5835159022385596 |  | 0.5835159022390144 |  | -0.0101356979830598 |  | -2.468957732869313 | 0.18469794911951 | -0.7832747446815915 | 1.922767105942484 | -0.09759175649290341 | -0.1983364710193882 | 0.592118854439093 | 0.09562167835650826 | 0.07992561184869373 | 0.4146014860974958 | 0.05956674941219831 | 0.1887255718637846
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 71 | 70 | 87 | 84 | 83 | 66
Medicare Mgd Care | 39 | 47 | 31 | 44 | 50 | 47
Medical Assistance | 0 | 0 | 3 | 2 | 3 | 1
MA Mgd Care | 29 | 27 | 27 | 21 | 27 | 22
Capital Blue Cross | 20 | 19 | 13 | 16 | 19 | 17
Capital Blue Cross Indemnity | 8 | 9 | 7 | 7 | 10 | 15
Capital Blue Cross Mgd Care | 4 | 3 | 3 | 5 | 4 | 5
HighMark BS | 19 | 21 | 21 | 20 | 22 | 30
HighMark Flex Blue | 2 | 6 | 4 | 3 | 9 | 13
Independence BC | 2 | 1 | 0 | 1 | 2 | 2
Valley Preferred | 7 | 9 | 9 | 6 | 4 | 4
Aetna VP | 4 | 8 | 7 | 5 | 4 | 6
Geisinger VP | 1 | 2 | 1 | 4 | 3 | 4
Self Pay | 3 | 5 | 3 | 7 | 5 | 7
LVHN Health Plan | 16 | 20 | 17 | 16 | 21 | 24
Auto | 6 | 5 | 8 | 4 | 6 | 9
Workers Comp | 11 | 11 | 10 | 11 | 14 | 19
All Other | 7 | 7 | 5 | 5 | 7 | 15
 | 249 | 270 | 256 | 261 | 293 | 306
 |  |  |  |  |  | **Check**
OR |  |  |  |  |  |  |  |  |  |  | 2.185430463579905 |  | 2.185430463579678 |  | 2.296357615893157 |  | 1.104304635761991 | 0.38907284768203 | -0.09271523178799157 | 1.031456953641992 | -0.4503311258280007 | -0.9321192052979939 | -0.4503311258280007 | -0.2168874172189987 | -0.289735099338003 | 0.38907284768203 | 1.228476821192004 | 0.586092715232013
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 40 | 33 | 41 | 48 | 53 | 34
Medicare Mgd Care | 36 | 31 | 30 | 41 | 36 | 31
Medical Assistance | 1 | 1 | 0 | 1 | 0 | 0
MA Mgd Care | 11 | 27 | 31 | 25 | 19 | 17
Capital Blue Cross | 10 | 8 | 10 | 7 | 11 | 16
Capital Blue Cross Indemnity | 6 | 3 | 2 | 6 | 4 | 6
Capital Blue Cross Mgd Care | 1 | 4 | 2 | 3 | 1 | 3
HighMark BS | 18 | 22 | 20 | 14 | 19 | 15
HighMark Flex Blue | 3 | 5 | 5 | 3 | 6 | 6
Independence BC | 3 | 3 | 2 | 2 | 4 | 2
Valley Preferred | 2 | 3 | 2 | 5 | 4 | 4
Aetna VP | 5 | 4 | 7 | 6 | 9 | 2
Geisinger VP | 3 | 0 | 1 | 0 | 2 | 4
Self Pay | 0 | 2 | 1 | 1 | 0 | 0
LVHN Health Plan | 6 | 5 | 8 | 6 | 10 | 10
Auto | 2 | 1 | 4 | 0 | 2 | 2
Workers Comp | 1 | 4 | 4 | 3 | 8 | 4
All Other | 2 | 3 | 4 | 5 | 3 | 8
 | 150 | 159 | 174 | 176 | 191 | 164
 |  |  |  |  |  | **Check**
Other |  |  |  |  |  |  |  |  |  |  | 0.4884775217227006 |  | 0.4884775217226984 |  | -7.415187004155648 |  | -0.56290139780884 | -0.549678881752928 | -0.653570079335096 | -0.700793350963355 | -0.663014733660748 | 0.149981110691349 | -0.78390630902909 | -0.833018511522478 | -0.72912731394031 | -0.710238005289006 | -0.695126558367964 | -0.683792973177182
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 1
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 1
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 2 | 0 | 0 | 1 | 0
 | 0 | 2 | 0 | 0 | 1 | 2
 |  |  |  |  |  | **Check**
Other Dx |  |  |  |  |  |  |  |  |  |  | -1.285714285714249 |  | -1.285714285714221 |  | -0.02857142857158124 |  | -0.8571428571428612 | 0.1428571428571388 | 0.1428571428571388 | -0.8571428571428612 | 0.1428571428571388 | 0.1428571428571388 | 0.1428571428571388 | 0.1428571428571388 | 0.1428571428571388 | 0.1428571428571388 | 0.1428571428571388 | 0.3999999999999986
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 12 | 12 | 18 | 19 | 13 | 11
Medicare Mgd Care | 8 | 9 | 9 | 12 | 8 | 5
Medical Assistance | 2 | 1 | 0 | 0 | 1 | 0
MA Mgd Care | 3 | 6 | 3 | 7 | 5 | 6
Capital Blue Cross | 3 | 6 | 6 | 5 | 3 | 5
Capital Blue Cross Indemnity | 0 | 2 | 2 | 2 | 2 | 4
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 3
HighMark BS | 0 | 0 | 1 | 0 | 1 | 0
HighMark Flex Blue | 0 | 3 | 7 | 1 | 2 | 1
Independence BC | 3 | 1 | 2 | 1 | 0 | 0
Valley Preferred | 0 | 2 | 0 | 1 | 2 | 1
Aetna VP | 3 | 0 | 1 | 1 | 1 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 1 | 0 | 0 | 0 | 0
LVHN Health Plan | 5 | 2 | 1 | 2 | 0 | 3
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 3 | 2 | 2 | 0 | 0 | 1
 | 42 | 47 | 52 | 51 | 38 | 40
 |  |  |  |  |  | **Check**
Other Procedures |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**
RadOnc |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Payor Mix |  | Last 6 of FY24 |  | Total Projected FY24 |  | Total Budget FY25 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Payor Grouping | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Total |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
Medicare | 0 | 0 | 0 | 0 | 0 | 0
Medicare Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Medical Assistance | 0 | 0 | 0 | 0 | 0 | 0
MA Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Indemnity | 0 | 0 | 0 | 0 | 0 | 0
Capital Blue Cross Mgd Care | 0 | 0 | 0 | 0 | 0 | 0
HighMark BS | 0 | 0 | 0 | 0 | 0 | 0
HighMark Flex Blue | 0 | 0 | 0 | 0 | 0 | 0
Independence BC | 0 | 0 | 0 | 0 | 0 | 0
Valley Preferred | 0 | 0 | 0 | 0 | 0 | 0
Aetna VP | 0 | 0 | 0 | 0 | 0 | 0
Geisinger VP | 0 | 0 | 0 | 0 | 0 | 0
Self Pay | 0 | 0 | 0 | 0 | 0 | 0
LVHN Health Plan | 0 | 0 | 0 | 0 | 0 | 0
Auto | 0 | 0 | 0 | 0 | 0 | 0
Workers Comp | 0 | 0 | 0 | 0 | 0 | 0
All Other | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | **Check**