36C10G24R0038 Attachment F1 - Deliverables Schedule Table.pdf

338 KB Posted

Attached to
R408--Actuarial Support Services
Solicitation number
36C10G24R0038
Issued by

About this file

Written by GovTribe AI ·

The document is a Deliverables Schedule Table for a Health Care Actuarial Support Services Contract (Contract Number 36C10G24R0038) with the Department of Veterans Affairs. The comprehensive table details 18 pages of recurring annual deliverables across multiple task categories, including model documentation, enrollment projections, strategic planning, workforce analysis, and specialized projections for areas like CHAMPVA, PCAFC, newborn care, and mental health services.

The deliverables are organized by task number, specific deliverable name, file format, description, delivery timeframe, and estimated quantities. Most deliverables are due annually in October, with some having different due dates ranging from January to August. The files include a mix of Excel spreadsheets, Word documents, PDF reports, databases, and presentation slides covering detailed actuarial analyses, enrollment projections, workload data, cost factors, utilization graphs, and strategic planning materials. The contract appears to require extensive data analysis and reporting across various VA healthcare system dimensions, with a focus on providing comprehensive actuarial support and projection modeling.

View the file

Other files

File Type Posted
36C10G24R0038 0004.pdf PDF
RFP 36C10G24R0038 Amendment 0003.pdf PDF
RFP 36C10G24R0038 Amendment 0002.pdf PDF
36C10G24R0038 0001.pdf PDF
36C10G24R0038_2 1.pdf PDF
Document 1 - VHA National BAA Template.pdf PDF
36C10G24R0038 Attachment L - Cost Breakdown.xlsx XLSX spreadsheet
36C10G24R0038 Attachment C - VA Enrollee Health Care Project Model and Advanced Appropriation Timeline.pdf PDF
36C10G24R0038 Attachment A - Sample Report Writer.pdf PDF
36C10G24R0038 Attachment I - Historical Labor Mix.pdf PDF
36C10G24R0038 Attachment H - Past Performance Questionairre.docx DOCX document
36C10G24R0038.docx DOCX document
36C10G24R0038 Attachment J - Contractor Rules of Behavior from 6500 Appendix D.pdf PDF
36C10G24R0038 Attachment G - Model Update Flow Chart.pdf PDF
36C10G24R0038 Attachment B - Sample Budget Impact.pdf PDF
36C10G24R0038.pdf PDF
36C10G24R0038 Attachment M - CLINs and SubCLINS.docx DOCX document
36C10G24R0038 Attachment K - Labor Mix Proposed by Vendor.xlsx XLSX spreadsheet
36C10G24R0038 Attachment F2 - Example of Previous Years Deliverables that were Unknown at time of Award.pdf PDF
36C10G24R0038 Attachment E - 2023 BY22 Model Documentation and Analysis Report.pdf PDF
36C10G24R0038 Attachment D - Actuarial Responsibilities Grid.xlsx XLSX spreadsheet
Show all 21

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

36C10G24R0038 Attachment F1: DELIVERABLES SCHEDULE TABLE Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX CBO Request - Enrollment Items 20XX CBO Request - Enrollment Items A5-A6-A8 20XX1101.xlsx Report October Annually C.8.2 CBO Data Request - Enrollment Items 20XX CBO Data Request Enrollment Items 20XX0916.xlsx Report October Annually C.4.3 Historical GTRVUs by VISN BYXX BAA2 Historical GTRVUs by VISN 20XX0814.xlsb Analysis August Annually C.8.2 BYXX EHCPM Relative Cost Factors BYXX FY20XX EHCPM Relative Cost Factors 20XX0316.xlsb Report October Annually C.4.3 BYXX HSC Changes Summary & Listings BYXX HSC Changes Summary & Listings 20XX1119.xlsb Documentation April 30 Annually C.8.1 HSPC to VA Treating Specialty Crosswalk Tool BYXX VA Treating Specialty to HSPC Crosswalk by Facility v1 20XX1116.xlsb Tool July Annually C.8.1 BYXX Historical VA Facility and Community Care Growth BYXX Historical Workload Growth by VISN 20XX0725.xlsb Report July Annually C.8.1 BYXX Historical VA Facility and Community Care Growth BYXX Historical Workload Growth 20XX0725.xlsb Report July Annually C.8.2 BYXX Expenditures by Age BYXX Expenditures by Age BAB1 20XX0914.xlsb Briefing Material April 30 Annually C.8.2 BRD0 P911 Enrollees-Patients by Priority BRD0 P911 Enrollees-Patients by Priority 20XX0729.xlsx Briefing Material April 30 Annually C.8.2 20XX CBO Request - Reliance BYXX Reliance Dashboard v19.0 by Priority Age Submarket 20XX1120.xlsb Report October Annually C.8.1 BYXX Reliance Deliverables BYXX BBA2 Reliance Dashboard v22.0 - Pri Age4 MISSION 20XX1222.xlsb Tool December Annually C.8.1 BYXX Reliance Deliverables BYXX BBA2 Reliance Dashboard v22.0 - Pri Submarket 20XX1222.xlsb Tool December Annually C.5.2 BYXX Reliance Deliverables BYXX Full vs Partial Reliance Analysis - 20XX1222.xlsb Analysis December Annually C.8.1 BYXX Reliance Deliverables BYXX FY20XX BYXX Reliance Summary by Priority 20XX1222.xlsb Tool December Annually C.8.1 BYXX Reliance Deliverables BYXX FY20XX Estimated Reliance Summary by Service Group 20XX1222.xlsb Tool December Annually C.5.2 BYXX Reliance Deliverables BYXX BBA2 100Pct Reliance and 100 Pct Enrollment 20XX1222.docx Report December Annually C.8.2 20XX CBO Request - Reliance BYXX Historical Reliance 2011-2019 20XX1011.xlsb Report October Annually C.3.8 BYXX BRD0 Projection Results and Supplemental Materials BYXX EHCPM Scenario BRD0 Assumptions 20XX0XX8.docx Documentation N/A With Each Scenario C.8.2 20XX Model (BYXX) Documentation Report BYXX Model Report Sections - Zip File Contents.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report _EHCPM Glossary (BYXX).docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report A1 (BYXX) Executive Summary.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K1 (BYXX) Overview - Policies Populations Events and Initiatives.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K2 (BYXX) Mental Health Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K3 (BYXX) Regional and Facility Reviews and Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K4 (BYXX) Trend Rate Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K5 (BYXX) Enrollment Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K6 (BYXX) Women's Health Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K7 (BYXX) Impact of Economic Forecasts.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K8 (BYXX) Inpatient Efficiency Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K9 (BYXX) Outpatient Efficiency Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K10 (BYXX) Pharmacy Efficiency Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K11 (BYXX) Pipeline Drug Impact Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K12 (BYXX) Homeless Program Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K13 (BYXX) Long-Term Services and Supports Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K14 (BYXX) Civilian Wage Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K15 (BYXX) Patient Aligned Care Team (PACT) Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K16 (BYXX) Telehealth Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K17 (BYXX) Community Care Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K18 (BYXX) Hepatitis C Drug Impact Policy Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K19 (BYXX) Dialysis and Related Services Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K20 (BYXX) Pharmacy Tiered Copayment Assumptions.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K21 (BYXX) COVID-19 Pandemic Modeling.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K22 (BYXX) Post-911 Era Combat Veteran Enrollee Assumptions.docx Report October Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report K23 (BYXX) PACT Act.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L1 (BYXX) Projections to Support Planning and Special Analyses.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L2 (BYXX) EHCPM Global Relative Value Units.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L3 (BYXX) Health Systems Planning Category Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L4 (BYXX) Ambulatory Health Systems Planning Category Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L5 (BYXX) Parent Facility Allocation Methodology.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report M1 (BYXX) 20XX Model (BYXX) Data Sources.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N1 (BYXX) CHAMPVA Cost Projection.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N2 (BYXX) PCAFC Projection Model.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report _EHCPM Glossary (BYXX).pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report A1 (BYXX) Executive Summary.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B1 (BYXX) Overview of the Enrollee Health Care Projection Model.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B3 (BYXX) EHCPM Tutorial - Private Sector-Based Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B4 (BYXX) EHCPM Tutorial - VA Experience-Based Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B5 (BYXX) 20XX EHCPM Updates.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B6 (BYXX) Overview of Modeling for Community Care Services.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B7 (BYXX) Overview of BYXX Modeling Approach.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C3 (BYXX) Veteran Population Proxy Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C4 (BYXX) Enrollment Rates.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C5 (BYXX) County Consolidation Methodology.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C7 (BYXX) Geographic Migration.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C8 (BYXX) Mortality Rates.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C9 (BYXX) Patient Projection Analysis.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D1 (BYXX) Private Sector-Based Service Benchmarks.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D2 (BYXX) Covered Benefits Package and Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D3 (BYXX) Copay Levels and Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D4 (BYXX) Geographic Area Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D5 (BYXX) Age and Gender Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D6 (BYXX) Inpatient Efficiency Analysis.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D7 (BYXX) Inpatient Hospital Under- and Over-Coding Analysis.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report E1 (BYXX) Modeling Methodology for VA Experience-Based Service Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report E2 (BYXX) Special Modeling Adjustments for VA Experience-Based Service Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G5 (BYXX) Enrollee Reliance Analyses - Ages 65 and Over.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G6 (BYXX) Enrollee Reliance Analyses - Under Age 65.pdf Report October Annually C.3.8 Draft BYXX BRD0 Assumptions Documents BYXX Scenario Description, Details, and Assumptions.xlsb Documentation N/A With Each Scenario C.3.8 Draft BYXX BRD0 Assumptions Documents BYXX EHCPM Scenario BRD0 Assumptions - Edits 20XX0XX5.docx Documentation N/A With Each Scenario C.8.2 BYXX Utilization Graphs by Duration BYXX CBO Utilization Graphs by Durations - 20XX1020.xlsb Report October Annually C.8.1 BYXX Regional Utilization by Age Tool BYXX Regional Utilization by Age Tool 20XX0819.xlsb Tool August Annually C.8.2 20XX Model (BYXX) Documentation Report G9 (BYXX) Enrollment Duration Utilization Adjustment.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G11 (BYXX) Enrollee Reliance Generational Shift.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H1 (BYXX) VA Inpatient Workload Data.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H2 (BYXX) VA Inpatient Encounter Workload Data.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H3 (BYXX) VA Ambulatory Workload Data.pdf Report October Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report H4 (BYXX) VA Prosthetics Workload Data.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H5 (BYXX) VA Pharmacy Workload Data.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H6 (BYXX) VA Dental Workload Data.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I1 (BYXX) VA Base Year Unit Cost Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I2 (BYXX) VA Inpatient Base Year Unit Cost Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I3 (BYXX) VA Ambulatory Base Year Unit Cost Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I4 (BYXX) VA Pharmacy Base Year Unit Cost Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I5 (BYXX) VA Unit Cost Age & Gender Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J1 (BYXX) Actual-to-Expected Utilization Adjustment.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J2 (BYXX) Unit Cost Reconciliation Methodology.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K1 (BYXX) Overview - Policies Populations Events and Initiatives.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K2 (BYXX) Mental Health Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K3 (BYXX) Regional and Facility Reviews and Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K4 (BYXX) Trend Rate Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K5 (BYXX) Enrollment Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K6 (BYXX) Women's Health Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K7 (BYXX) Impact of Economic Forecasts.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K8 (BYXX) Inpatient Efficiency Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K9 (BYXX) Outpatient Efficiency Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K10 (BYXX) Pharmacy Efficiency Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K11 (BYXX) Pipeline Drug Impact Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K12 (BYXX) Homeless Program Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K13 (BYXX) Long-Term Services and Supports Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K14 (BYXX) Civilian Wage Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K15 (BYXX) Patient Aligned Care Team (PACT) Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K16 (BYXX) Telehealth Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K17 (BYXX) Community Care Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K18 (BYXX) Hepatitis C Drug Impact Policy Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K19 (BYXX) Dialysis and Related Services Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K20 (BYXX) Pharmacy Tiered Copayment Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K21 (BYXX) COVID-19 Pandemic Modeling.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K22 (BYXX) Post-911 Era Combat Veteran Enrollee Assumptions.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K23 (BYXX) PACT Act.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L1 (BYXX) Projections to Support Planning and Special Analyses.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L2 (BYXX) EHCPM Global Relative Value Units.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L3 (BYXX) Health Systems Planning Category Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L4 (BYXX) Ambulatory Health Systems Planning Category Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L5 (BYXX) Parent Facility Allocation Methodology.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report M1 (BYXX) 20XX Model (BYXX) Data Sources.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N1 (BYXX) CHAMPVA Cost Projection.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N2 (BYXX) PCAFC Projection Model.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N3 (BYXX) Newborn Care Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N4 (BYXX) Fertility Services Projections.pdf Report October Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report N5 (BYXX) Registrant and Other than Honorable Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N6 (BYXX) MH RRTP 3D Model.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N7 (BYXX) Readjustment Counseling Service Projection Model.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report 20XX (BYXX) EHCPM Documentation Report.pdf Report October Annually C.7.1 BYXX Trend Briefing BYXX Trend Briefing 20XX0802.pptx Briefing Material August Annually C.8.2 20XX Model (BYXX) Documentation Report B1 (BYXX) Overview of the Enrollee Health Care Projection Model.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B3 (BYXX) EHCPM Tutorial - Private Sector-Based Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B4 (BYXX) EHCPM Tutorial - VA Experience-Based Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B5 (BYXX) 20XX EHCPM Updates.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B6 (BYXX) Overview of Modeling for Community Care Services.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B7 (BYXX) Overview of BYXX Modeling Approach.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G5 (BYXX) Enrollee Reliance Analyses Exhibits G5-2 through G5-3.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J1 (BYXX) Actual-to-Expected Utilization Adjustment.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C1 (BYXX) Enrollment Projection Methodology.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C2 (BYXX) Creation of the Master Enrollment File.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C3 (BYXX) Veteran Population Proxy Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C4 (BYXX) Enrollment Rates.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C5 (BYXX) County Consolidation Methodology.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C6 (BYXX) Priority and Morbidity Class Transition.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C7 (BYXX) Geographic Migration.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C8 (BYXX) Mortality Rates.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C9 (BYXX) Patient Projection Analysis.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C10 (BYXX) Enrollment and VetPop Proxy County Allocations.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D1 (BYXX) Private Sector-Based Service Benchmarks.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D2 (BYXX) Covered Benefits Package and Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D3 (BYXX) Copay Levels and Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D3 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D4 (BYXX) Geographic Area Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D5 (BYXX) Age and Gender Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D6 (BYXX) Inpatient Efficiency Analysis.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D7 (BYXX) Inpatient Hospital Under- and Over-Coding Analysis.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report E1 (BYXX) Modeling Methodology for VA Experience-Based Service Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report E2 (BYXX) Special Modeling Adjustments for VA Experience-Based Service Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G1 (BYXX) Overview of Reliance and Morbidity Modeling.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G2 (BYXX) Morbidity Risk Weight Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G3 (BYXX) Enrollee Morbidity Analyses - Ages 65 and Over.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G4 (BYXX) Enrollee Morbidity Analyses - Under Age 65.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G5 (BYXX) Enrollee Reliance Analyses - Ages 65 and Over.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G6 (BYXX) Enrollee Reliance Analyses - Under Age 65.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G7 (BYXX) Morbidity Birth Year Cohorts.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G8 (BYXX) Morbidity and Reliance Drift Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G9 (BYXX) Enrollment Duration Utilization Adjustment.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G10 (BYXX) Condition-Based Morbidity Adjustments.docx Report October Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report G11 (BYXX) Enrollee Reliance Generational Shift.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H1 (BYXX) VA Inpatient Workload Data.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H2 (BYXX) VA Inpatient Encounter Workload Data.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H3 (BYXX) VA Ambulatory Workload Data.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H4 (BYXX) VA Prosthetics Workload Data.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H5 (BYXX) VA Pharmacy Workload Data.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H6 (BYXX) VA Dental Workload Data.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H7 (BYXX) FY 20XX Baseline Database Construction.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I1 (BYXX) VA Base Year Unit Cost Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I2 (BYXX) VA Inpatient Base Year Unit Cost Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I3 (BYXX) VA Ambulatory Base Year Unit Cost Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I4 (BYXX) VA Pharmacy Base Year Unit Cost Development.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I5 (BYXX) VA Unit Cost Age & Gender Adjustments.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J2 (BYXX) Unit Cost Reconciliation Methodology.docx Report October Annually C.4.3 20XX CBO Request - Reliance BYXX VA EHCPM Global Total RVUs Growth 20XX1011.xlsb Analysis November Annually C.4.3 BAB1 Community Care Cost Estimate with Admin Breakout by VISN BYXX Projected RVU Growth by VISN & Facility 20XX0715.xlsb Analysis April 30 Annually C.4.3 BYXX Baseline Data Request BYXX Baseline Data Request 20XX1012.xlsb Analysis April 30 Annually C.4.3 BYXX BRD0 CC Cost Estimate with Admin Breakout BYXX Scenario BRD0 Community Care Cost Estimate with Admin Breakout 20XX0XX5.xlsx Analysis April 30 Annually C.5.1 Scenario BAA1 BYXX BAA1 MISSION Documentation 20XX0527.xlsb Documentation April 30 Annually C.3.8 Scenario BAA1 BYXX EHCPM Scenario BAA1 Assumptions 20XX0527.docx Documentation N/A With Each Scenario C.5.1 Scenario BAA1 BYXX RW 20XX Model (BYXX) Scenario BAA1 FY and CC 20XX0527.xlsx Analysis April 30 Annually C.5.1 Scenario BAA1 BYXX Scenario BAA1 Projection Supplement 20XX0527.xlsb Documentation April 30 Annually C.8.2 20XX Model (BYXX) Documentation Report B4-1 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B4-2 (BYXX) Exhibits.docx Report October Annually C.3.8 BAB1 CCN Regions 1-5 Workbook BYXX EHCPM Scenario BAB1 Assumptions 20XX0701.pdf Documentation N/A With Each Scenario C.5.1 BAB1 CCN Regions 1-5 Workbook BYXX Scenario BAB1 CCNC Regions 1-5 Projections 20XX0701.xlsb Analysis July Annually C.7.1 BYXX BRD0 Briefing Slides 20XX-20XX Budget BRD0 Briefing 20XX0325 HAC SAC Edits 20XX0328.pptx Briefing Material March Annually C.7.1 BYXX BRD0 Briefing Slides 20XX-20XX Budget BRD0 Briefing 20XX0325 HAC SAC Edits.pptx Briefing Material March Annually C.7.1 BYXX Scenario BAB1 Briefing Slides BYXX Briefing Slides - Scenario BAB1 DRAFT 20XX0804.pptx Briefing Material August Annually C.8.2 FYXX EHCPM Relative Cost Factors BYXX FY20XX EHCPM Relative Cost Factors 20XX1102.xlsb Analysis October Annually C.8.1 BRD0 Unique Enrollee & Patient Counts BYXX FYXX-23 Unique Enrollee & Patient Counts - Scenario BRD0 20XX0427.xlsb Report April 30 Annually C.8.1 BRD0 Unique Enrollee & Patient Counts BYXX Unique Enrollee & Patient Counts - Scenario BRD0 20XX0427.xlsb Report April 30 Annually C.8.1 BYXX Projected Veterans, Enrollees, and Patients by Gender BYXX Veterans-Enrollees-Patients by Gender 20XX1012.xlsx Briefing Material April 30 Annually C.7.1 BYXX Enrollment Projections Briefing BYXX Enrollment Projections Briefing 20XX1004.pptx Briefing Material April 30 Annually C.4.4 FYXX-XX Enrollment Rate Gender Relativities FYXX-XX Enrollment Rate Gender Relativities 20XX0406.xlsx Report March Annually C.8.1 Proxy County Enrollment Projections County Allocated Projections for Special Case Areas 20XX0110.xlsx Tool January Annually C.8.1 BRD0 Enrollment and Patients Exhibits BRD0 FYXX-24 Enrollment-Patients Age-Gender-Pri 20XX0225.xlsx Briefing Material April 30 Annually C.8.2 BYXX Model Factor Analysis for CBO Budget Scenario BAA9 BYXX Model Factor Analysis for CBO Budget Scenario BAA9 20XX1028.xlsb Analysis October Annually C.4.4 BYXX Mental Health Workgroup File Mental Health BYXX Projection Reports-BRD0 20XX0311.xlsb Report March Annually C.8.1 BYXX Expenditures by Age Graphs BYXX Expenditures by Age BBA2 20XX1019.xlsb Briefing Material October Annually C.7.1 BYXX Long-Term Trend Briefing BYXX Long-Term Trend Briefing 20XX0422.pptx Briefing Material April Annually C.3.8 BAA2 & BBA2 Deliverable List BAA2 & BBA2 Deliverable List 20XX0719.xlsx Documentation N/A With Each Scenario C.4.3 BYXX Reliance Deliverables BYXX Reliance and Morbidity BBA2 20XX1222.xlsb Analysis December Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report B1 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B2 (BYXX) EHCPM Tutorial - Enrollment Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B2 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B3-1 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B3-2 (BYXX) Exhibits.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D5 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D6 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report E1 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G5 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G9 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G11-1 (BYXX) Exhibits.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G11-2 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H1 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H2 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H3 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H4 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H5 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H6 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H7 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I1 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I2 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I3 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I4 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J1 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J2 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K2 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K6 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K22 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L2 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L3 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L4 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L5 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report M1 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N1 (BYXX) Exhibits.xlsx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N2 (BYXX) Exhibits.xlsb Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B2 (BYXX) EHCPM Tutorial - Enrollment Projections.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B3-1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B3-2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B4-1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report B4-2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C1 (BYXX) Enrollment Projection Methodology.pdf Report October Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report C2 (BYXX) Creation of the Master Enrollment File.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C6 (BYXX) Priority and Morbidity Class Transition.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report C10 (BYXX) Enrollment and VetPop Proxy County Allocations.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D3 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D5 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report D6 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report E1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G1 (BYXX) Overview of Reliance and Morbidity Modeling.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G2 (BYXX) Morbidity Risk Weight Development.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G3 (BYXX) Enrollee Morbidity Analyses - Ages 65 and Over.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G4 (BYXX) Enrollee Morbidity Analyses - Under Age 65.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G5 (BYXX) Enrollee Reliance Analyses Exhibits G5-2 through G5-3.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G5 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G7 (BYXX) Morbidity Birth Year Cohorts.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G8 (BYXX) Morbidity and Reliance Drift Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G9 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G10 (BYXX) Condition-Based Morbidity Adjustments.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G11-1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report G11-2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H3 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H4 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H5 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H6 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H7 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report H7 (BYXX) FY 20XX Baseline Database Construction.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I3 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report I4 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report J2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K6 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report K22 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L2 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L3 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L4 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report L5 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report M1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N1 (BYXX) Exhibits.pdf Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N2 (BYXX) Exhibits.pdf Report October Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.8.2 20XX Model (BYXX) Documentation Report N3 (BYXX) Newborn Care Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N4 (BYXX) Fertility Services Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N5 (BYXX) Registrant and Other than Honorable Projections.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N6 (BYXX) MH RRTP 3D Model.docx Report October Annually C.8.2 20XX Model (BYXX) Documentation Report N7 (BYXX) Readjustment Counseling Service Projection Model.docx Report October Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_23.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_National.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_01.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_02.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_04.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_05.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_06.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_07.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_08.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_09.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_10.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_12.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_15.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_16.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_17.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_19.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_20.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_21.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Key_Driver_Gender_BYXX-BYXX_V1_VISN_22.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_23.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_National.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_01.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_02.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_04.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_05.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_06.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_07.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_08.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_09.xlsx Tool July Annually C.8.1 BYXX Enrollment Tools Enrl_Local_IncDec-BYXX_V1_VISN_10.xlsx Tool July Annually C.8.1 BYXX County-Allocated and Veteran Projections enrollment_BYXXv1_fips_log.ldf Database September Annually C.3.1 BYXX EHCPM Update Flow Chart BYXX Model Update Flow Chart 20XX0501.xlsb Documentation N/A As needed C.4.4 BYXX Dialysis Reliance Assumption Workbook BYXX Dialysis Reliance Assumption Workbook.xlsb Report March Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2041.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_20XX.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_20XX.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_20XX.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2024.sas7bdat Database April 30 Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2025.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2026.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2027.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2028.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2029.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2030.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2031.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2032.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2033.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2034.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2035.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2036.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2037.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2038.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2039.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets bab1e300b000b0aa0_hsc_t_2040.sas7bdat Database April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets BYXX RW Scenario BAB1 Standard Detail Live GTRVU 20XX0805.xlsb Report April 30 Annually C.5.1 BAB1 Live RW and HSC Datasets BYXX Data Dictionary & BAB1 Control Totals.xlsx Documentation April 30 Annually C.5.1 BABI Portion of Community Care by VISN BYXX BAB1 Portion of Community Care by VISN 20XX0705.xlsb Analysis April 30 Annually C.4.3 BYXX Projected RVU Growth by VISN and Facility BYXX Projected RVU Growth by VISN & Facility 20XX0304.xlsb Analysis April 30 Annually C.5.1 Scenario BAA1 BYXX Budget Impact Scenario BAA1 20XX0527.xlsb Report April 30 Annually C.5.1 Scenario BAA1 BYXX BAA1 Portion of Community Care 20XX0527.xlsb Analysis April 30 Annually C.4.3 Scenario BAA1 BYXX Scenario BAA1 Community Care Cost Estimate with Admin Breakout 20XX0527.xlsx Analysis April 30 Annually C.4.1 AI/AN PUMS Review AI-AN PUMS Review 20XX0301.docx Analysis April 30 Annually C.4.1 BYXX Survey of Enrollee Analysis - Gender BYXX SOE Analysis - Gender 20XX1030.xlsb Analysis October Annually C.4.1 BYXX Survey of Enrollee Analysis - Post-911 BYXX SOE Analysis - Post-911 20XX1030.xlsb Analysis October Annually C.8.1 BYXX County-Allocated and Veteran Projections vp_proxy_BYXXv1_fips.sas7bdat Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections elig_veterans_BYXXv1_fips.sas7bdat Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections enrollment_BYXXv1_fips.sas7bdat Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections sc_vpp_BYXXv1_fips_lim.sas7bdat Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections vp_proxy_BYXXv1_fips_log.ldf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections elig_veterans_BYXXv1_fips.mdf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections elig_veterans_BYXXv1_fips_log.ldf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections enrollment_BYXXv1_fips.mdf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections sc_vpp_BYXXv1_fips_lim.mdf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections sc_vpp_BYXXv1_fips_lim_log.ldf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections vp_proxy_BYXXv1_fips.mdf Database September Annually C.8.1 BYXX County-Allocated and Veteran Projections County-Allocated Data Dictionary & Control Totals 20XX0701.xlsx Documentation September Annually C.8.1 BYXX County-Allocated and Veteran Projections County Allocated Enrollment Dashboard 20XX0701.xlsx Tool September Annually C.8.1 BYXX County-Allocated and Veteran Projections County Allocation Special Cases 20XX0701.xlsx Tool September Annually C.8.1 BYXX VetPop Proxy vp_eoy_BYXXv1_g10v10.sas7bdat Database September Annually C.4.1 BYXX Master Enrollment File mefva_2109_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Master Enrollment File Master Enrollment File Summary & Specifications 20XX0419.xlsx Report April 30 Annually

Health Care Actuarial Support Services Contract Known, Recurring Deliverables

Task # Deliverable Deliverable Files / Format Deliverable Description Delivery Timeframe

Estimated Quantities

C.4.1 BYXX Patient HSC Databases PatientHSC Indicator Code BYXX.sas Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2012_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2013_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2014_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2015_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2016_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2017_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2018_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_2019_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_20XX_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases patienthsc_20XX_BYXXv1_2109v1.sas7bdat Database April 30 Annually C.4.1 BYXX Patient HSC Databases Patient HSC Data Dictionary 20XX0624.xlsb Database April 30 Annually C.4.1 BYXX Proposed Mapping and Master Mapping Workbook Proposed Area Mapping Review 20XX1201.xlsx Documentation April 30 Annually C.4.1 BYXX Proposed Mapping and Master Mapping Workbook BYXX Master Area Mapping FIPS to Sector 20XX1201.xlsx Documentation April 30 Annually C.8.1 BYXX VetPop Proxy VetPop Proxy Specifications BYXX 20XX0524.docx Documentation September Annually C.6.2 BYXX Clinic Stop and HSPC Crosswalks BYXX Clinic Stop & HSPC Util Crosswalk - v1.xlsb Report June 30 Annually C.4.1 BYXX Master Area Mapping BYXX Master Area Mapping FIPS to Sector 20XX0816.xlsx Documentation April 30 Annually C.4.1 BYXX MEF Data Requst and Extract Timing MEF Data Request and Extract Timing 20XX0919.xlsx Documentation April 30 Annually C.4.5 BYXX Model Accuracy Exhibit Model Accuracy Slide 20XX0309.xlsx Briefing Material March Annually C.4.1 FYXX Enrollment-Patients-Expenditures File BAA1 FYXX Enrollment-Patients-Expenditures Age-Pri 20XX0624.xlsx Analysis April 30 Annually C.4.1 Veteran Population Estimates Veteran Population Comparison 20XX0703.xlsx Analysis April 30 Annually C.5.1 Budget Impact Scenario BAA1 BYXX Budget Impact Scenario BAA1 Compare Exhibits 20XX0601.xlsb Report April 30 Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2011.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2012.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2013.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2014.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2015.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2016.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2017.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2018.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2019.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard rvu_database_fy_2020.sas7bdat Database May Annually C.4.2 BYXXv1 EHCPM GlobalRVUs Databases and Dashboard BYXXv1 VA EHCPM GlobalRVUs Dashboard 20XX0531.xlsb Database May Annually C.4.1 BRD0 FYXX Enrollment-Patient-Expenditures BRD0 FYXX Enrollment-Patients-Expenditures Age-Pri 20XX0223.xlsx Analysis April 30 Annually C.4.3 BRD0 Priority and Morbidity Class Assumptions BYXX BRD0 Priority and Morbidity Class Assumptions 20XX0926.xlsb Analysis April 30 Annually C.4.3 BYXX BRD0 HSC Parent Files BYXX HSC Facility Data Dictionary & BRD0 Control Totals 20XX0304.xlsx Documentation April 30 Annually C.4.3 BYXX BRD0 HSC Parent Files brd0e300b0d0b0aa0_hsc_pf_gtrvu.sas7bdat Database April 30 Annually C.4.4 BYXX LTSS Projection Reports LTSS BYXX Projection Reports-BRD0 20XX0321.xlsb Report March Annually C.4.4 BYXX Pharmacy Trend Assumption Workbook Pharmacy Trend Assumption Workbook BYXX 20XX0228.xlsb Report March Annually C.4.4 BYXX Prosthetics Trend Assumption Workbook Prosthetics Trend Assumption Workbook BYXX 20XX0228.xlsb Report March Annually C.5.1 BYXX Budget Scenario BAB1 BYXX Budget Impact Scenario BAB1 20XX0706.xlsb Report April 30 Annually C.5.1 BYXX Budget Scenario BAB1 BYXX Budget Impact Scenario BAB1 Compare Exhibits 20XX0706.xlsb Report April…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .