36C10G24R0038 Attachment A - Sample Report Writer.pdf
PDF 220 KB Posted
- Attached to
- R408--Actuarial Support Services
- Solicitation number
- 36C10G24R0038
About this file
This document is a Sample Report Writer attachment for a VA Enrollee Health Care Projection Model, presenting projected healthcare services data for fiscal year 20XX. The report provides comprehensive national-level projections for community care services across multiple healthcare categories, including ambulatory services, diagnostics, therapies, long-term services, mental health, and pharmacy prescriptions. Key statistical highlights include:
Enrollment and Service Projections:
- Total end-of-year enrollment: 8,640,365 unique enrollees
- Unique enrolled patients: 6,474,434 (with 2,330,022 community care patients)
- Total projected annual expenditures: $37,016,462,643
- Total projected annual services: 624,561,921 services
- Major service categories include ambulatory professional services and procedures ($5.6B), therapies ($4.1B), and diagnostic services ($3.4B)
The document is part of solicitation 36C10G24R0038 for Actuarial Support Services issued by the Department of Veterans Affairs Headquarters, providing detailed healthcare utilization and cost projections across various medical service types.
View the file
Other files
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
Text version
36C10G24R0038
ATTACHMENT A: SAMPLE REPORT WRITER
20XX Model (BYXX) VA Enrollee Health Care Projection Model (Base Year 20XX)
Projected Enrollment, Utilization, RVUs, and VA Costs for Fiscal Year 20XX Healthcare Services Category Projections
Ages: XX-XX, Priorities: PX-X, All Enrollee Types National - Community Care
Enrollees/ Projected Projected Projected Projected Average
Unique Annual Annual EHCPM Global Annual Length Daily Type of Service Patients Expenditures Utilization Total RVUs Admissions of Stay Census
Projected Services Summary
AMB PC & SC - DIAGNOSTICS $3,440,093,884 48,517,114
AMB PC & SC - E&M SVCS $1,399,900,501 25,113,324
AMB PC & SC - PROF SVCS AND PROCS $5,603,628,741 96,859,992
AMB PC & SC - THERAPIES $4,155,111,815 74,506,210
LTSS - FACILITY BASED SVCS $1,835,681,809 49,986,846
LTSS - HOME AND COMMUNITY BASED SVCS $3,527,089,248 44,785,584
MH & HOMELESS - AMBULATORY $445,452,859 8,901,702
MH & HOMELESS - INPATIENT $771,398,602 9,349,225
MH & HOMELESS - INPATIENT PROF SVCS $0 45,396
PHARMACY - OUTPATIENT PRESCRIPTIONS $41,274,719 1,648,469
PROSTHETICS $0 0
REHABILITATIVE CARE $0 0
ALL MODELED BENEFITS TOTAL $37,016,462,643 624,561,921
Enrollment and Patient Summary
Details for Projected Services Summarized Above
18,574,392 services 7,600,449 services 4,811,742 services 15,914,138 services
4,678,808 days
52,255,031 services 2,148,069 services 368,277 days
11,245 services 2,446,012 scripts
0 units 0 days
DENTAL
INPATIENT MEDICINE AND SURGERY
INPATIENT ENCOUNTERS - FACILITY SERVICES
INPATIENT ENCOUNTERS - PROFESSIONAL SERVICES
$971,309,321
$14,825,521,143
$0
2,064,692 proced
3,085,940 days
45,711 services 5,655,222 services
9,066,236
237,041,982
379,534
18,360,305
ENROLLMENT
End of Year Enrollment Unique Enrollment
8,640,365 8,942,741
ENROLLED PATIENTS
Unique Enrolled Patients Total Unique Enrolled CC Patients
6,474,434 2,330,022
AMB PC & SC - DIAGNOSTICS
AMD_01 Cardiovascular AMD_02 Colonoscopy AMD_03 Dermatology Services and Diagnostic Exams AMD_04 Hearing/Speech Exams AMD_05 Miscellaneous Medical Services and Diagnostics AMD_06 Non-Invasive Vascular Studies AMD_07 Ophthalmology Services and Diagnostic Exams AMD_08 Pathology AMD_09 Pulmonology Svcs, Diag Exams, Ventilator Mgmt AMD_10 Radiology - CT AMD_11 Radiology - General AMD_12 Radiology - Mammography Diagnostic AMD_13 Radiology - Mammography Screening AMD_14 Radiology - MRI AMD_15 Radiology - Nuclear Medicine AMD_16 Radiology - PET & PET/CT AMD_17 Radiology - Radiation Oncology AMD_18 Radiology - Ultrasound AMD_19 Vision Exams
Subtotal
$306,506,754 196,714,751
9,813,982 15,466,146
286,534,338 48,220,428 73,484,127
453,483,172 41,112,580
373,691,898 190,923,652
9,166,869 23,508,086
249,780,177 128,289,959 142,857,049 721,194,426
57,199,133 112,146,358
$3,440,093,884
1,302,976 proced 159,014 proced
63,858 proced 103,207 exams 714,034 proced 149,583 proced 939,499 proced
9,852,893 proced 335,792 proced 881,447 proced
1,535,984 proced 35,115 proced
128,743 proced 375,258 proced
88,801 proced 41,898 proced
999,696 proced 324,372 proced
542,221 exams 18,574,392 services
4,808,815 4,436,578
205,808 243,557
4,964,663 746,047
1,041,210 5,745,251
372,049 4,047,191 1,723,773
149,855 438,518
3,096,985 1,177,037 1,657,629
10,701,970 812,178
2,148,003 48,517,114
AMB PC & SC - E&M SVCS
AME_01 Case Management - Rehabilitation Therapists AME_02 Compensation & Pension Exams AME_03 Medication Therapy Management AME_04 Office Visits/Urgent Care/Physical Exams - Non MH AME_06 Telephone E&M Services - Primary and Specialty Care
39,807 1,399,757,203
103,491 $1,399,900,501
0 proced 0 visits
114 proced 7,598,640 visits
1,695 proced 7,600,449 services
25,111,032
2,205 25,113,324
AMB PC & SC - PROF SVCS AND PROCS
AMP_01 Ambulance AMP_02 Ambulatory Surgery - ASC Setting AMP_03 Ambulatory Surgery - Office Setting AMP_04 Ambulatory Surgery - Outpatient
Setting AMP_05 Emergency Room Visits AMP_06 Eye Glasses Services AMP_07 Hearing Aid Services AMP_08 Maternity AMP_09 Nutritional Counseling AMP_10 Observation Care AMP_11 Prosthetic and Orthotic Services
S bt t l
$589,242,702 609,756,680 651,640,436
2,758,758,781 859,979,843
1,310,572 69,210,243
5,573,878 1,597,224
56,233,186 325,197
$5,603,628,741
208,878 runs 554,947 proced
1,999,583 proced 888,652 proced 641,051 visits
20,510 visits 141,912 visits
9,823 proced 10,359 visits
332,684 hours 3,343 visits
4,811,742 services
3,815,331 15,943,936 12,048,894 52,805,912 11,287,010
22,294 239,095 112,319
20,543 558,775
5,883 96,859,992
AMB PC & SC - THERAPIES
AMT_01 Allergy Immunotherapy AMT_02 Allergy Testing AMT_03 Chiropractic AMT_04 Dialysis and Related Services AMT_05 Immunizations AMT_06 Nephrology - ESRD Services AMT_07 Office Administered Drugs
AMT_08 PT/OT/SLP
AMT_09 Recreational Therapy
$32,560,022 11,469,349
127,622,445 1,156,481,291
11,978,716 33,493,944
1,776,466,720 1,005,039,329
$4,155,111,815
377,075 visits 39,682 proced
1,710,608 visits 2,597,925 proced
158,905 proced 82,163 months
4,056,804 proced 6,890,975 visits
0 stops 15,914,138 services
645,545 209,128
2,234,555 20,024,284
182,853 800,725
32,393,448 18,015,673
74,506,210
36C10G24R0038
ATTACHMENT A: SAMPLE REPORT WRITER
File details come from the government source that posted it. Updated .