Attachment 1 Pricing Matrix Template.xlsx
XLSX spreadsheet 304 KB Posted
- Attached to
- Solicitation Amendment 0003 for Defense Center for Public Health Operational and Manpower Support Services
- Solicitation number
- W81K0426RA019
- Issued by
-
Department of the Army Medical Command
About this file
This is a Pricing Matrix Template for a federal contract opportunity to provide Public Health Operational and Manpower Support Services to the Defense Centers for Public Health (DCPH) under Solicitation Number W81K0425RA019. The template is controlled by the U.S. Army Health Care Activity (USAHCA) and is designated for Federal Use Only, with Point of Contact David J. Libby at 210-221-4808.
The contract has a Period of Performance from 19 September 2026 through 18 May 2031, structured across five ordering periods plus a six-month option to extend under FAR 52.217-8. The pricing matrix consists of two primary cost elements: Direct Labor and Travel Costs. The Direct Labor section includes 40 labor categories requiring a total of 134 Full-Time Equivalents (FTEs) across ordering periods, spanning positions such as Epidemiologists (32 FTEs), Biostatisticians II (12 FTEs), Data Scientists Engineers (6 FTEs), and various specialized technical and administrative roles. Travel costs are broken down into five categories: Core Funded Travel ($43,709.08 per ordering period), Travel for Toxicology ($16,390.91), Travel for Program Evaluation ($5,463.64), Travel for MWD Trauma Registry ($26,000.00), and Travel for Red Hill ($21,854.54), with an additional $50,000 Phase-In Period cost in the first ordering period. The template shows a Total Evaluated Price of $673,799.94 across all periods, with a cumulative total of 1,345,092 labor hours. Offerors are instructed to complete only the cells highlighted in green within the "Labor Build-Up" tab and must not make any changes to the "Summary" tab.
View the file
Other files
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
INSTRUCTIONS
| CUI | |
| INSTRUCTIONS TO OFFERORS: | |
| Tab "Summary" - Offeror are to not make any changes to this tab. FOR GOVERNMENT USE ONLY |
Tab "Labor Buid-Up" - Offerors are to complete cells highlighted in green.
| Controlled by: USAHCA | |
| CUI Category: Source Selection | |
| Distribution/Dissemination Control: | |
| FED ONLY | |
| POC: David J. Libby, 210-221-4808 | |
| CUI |
Summary
CUI
| Solicitation Number: W81K0425RA019 |
| Period of Performance: 19 September 2026 - 18 May 2031 |
| Description of Cost Elements | Ordering Period 1 | ||||||
| Ordering Period 2 | |||||||
| Ordering Period 3 | |||||||
| Ordering Period 4 | |||||||
| Ordering Period 5 | |||||||
| FAR 52.217-8 (6 months) | Totals | ||||||
| Direct Labor: | |||||||
| Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total Direct Labor Cost | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Travel Costs | |||||||
| Core Funded Travel | $43,709.08 | $43,709.08 | $43,709.08 | $43,709.08 | $43,709.08 | $21,854.54 | $240,399.94 |
| Travel (Toxicology) | $16,390.91 | $16,390.91 | $16,390.91 | $16,390.91 | $16,390.91 | $8,195.46 | $90,150.01 |
| Travel (Program Evaluation) | $5,463.64 | $5,463.64 | $5,463.64 | $5,463.64 | $5,463.64 | $2,731.82 | $30,050.02 |
| Travel (MWD Trauma Registry) | $26,000.00 | $26,000.00 | $26,000.00 | $26,000.00 | $26,000.00 | $13,000.00 | $143,000.00 |
| Travel (Red Hill) | $21,854.54 | $21,854.54 | $21,854.54 | $21,854.54 | $21,854.54 | $10,927.27 | $120,199.97 |
| 30 Day Phase-In Period | $50,000.00 | $50,000.00 |
Total Travel Costs $163,418.17 $113,418.17 $113,418.17 $113,418.17 $113,418.17 $56,709.09 $673,799.94
Total Evaluated Price $163,418.17 $113,418.17 $113,418.17 $113,418.17 $113,418.17 $56,709.09 $673,799.94
Total Evaluated Price (includes 52.217-8) $673,799.94
| Controlled by: USAHCA |
| CUI Category: Source Selection |
| Distribution/Dissemination Control: |
| FED ONLY |
| POC: David J. Libby, 210-221-4808 |
CUI
Labor Build-Up
| CUI | ||
| Labor Category | Ordering Period 1 |
Ordering Period 2
Ordering Period 3
Ordering Period 4
Ordering Period 5
FAR 52.217-8
6-Mo Option to Extend
| FTE | Hrs | FBLR | Ext. Price | FTE | Hrs | FBLR | Ext. Price | FTE | Hrs | FBLR | Ext. Price | FTE | Hrs | FBLR | Ext. Price | FTE | Hrs | FBLR | Ext. Price | FTE | Hrs | FBLR | Ext. Price | ||
| 1 | Administrative Assistant III | 6 | 8,604 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 5,736 | $ - 0 | $ - 0 |
| 2 | Animal Caretaker I | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 3 | Biological Sciences Technician | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 4 | Biomedical Equipment Technician | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 5 | Biostatistician II | 12 | 17,208 | $ - 0 | $ - 0 | 12 | 22,944 | $ - 0 | $ - 0 | 12 | 22,944 | $ - 0 | $ - 0 | 12 | 22,944 | $ - 0 | $ - 0 | 12 | 22,944 | $ - 0 | $ - 0 | 12 | 11,472 | $ - 0 | $ - 0 |
| 6 | Chemist | 5 | 7,170 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 4,780 | $ - 0 | $ - 0 |
| 7 | Crystal Reports Writer | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 8 | Data Analyst I | 4 | 5,736 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 3,824 | $ - 0 | $ - 0 |
| 9 | Data Scientist Engineer | 6 | 8,604 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 11,472 | $ - 0 | $ - 0 | 6 | 5,736 | $ - 0 | $ - 0 |
| 10 | Data Technician I | 4 | 5,736 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 3,824 | $ - 0 | $ - 0 |
| 11 | Epidemiologist | 32 | 45,888 | $ - 0 | $ - 0 | 32 | 61,184 | $ - 0 | $ - 0 | 32 | 61,184 | $ - 0 | $ - 0 | 32 | 61,184 | $ - 0 | $ - 0 | 32 | 61,184 | $ - 0 | $ - 0 | 32 | 30,592 | $ - 0 | $ - 0 |
| 12 | Geographic Info System (GIS) Spec. | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 13 | Graphics Design Specialist | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 14 | Graphics Designer | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 15 | Health Educator | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 16 | Health Outreach Coordinator | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 17 | Laboratory Systems Officer | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 18 | Laboratory Technician | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 19 | Managing Editor | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 20 | Mechanical Engineer | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 21 | MSMR Consultant | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 22 | MSMR Editor Sr Medical Advisor | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 23 | MWD Casualty Care Coordinator | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 24 | MWD Trauma Registry Data Abstractor | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 | |
| 25 | Operations Coordinator | 5 | 7,170 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 9,560 | $ - 0 | $ - 0 | 5 | 4,780 | $ - 0 | $ - 0 |
| 26 | Operations Security Coordinator | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 27 | Program Evaluator II | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 28 | Program Evaluator III | 4 | 5,736 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 7,648 | $ - 0 | $ - 0 | 4 | 3,824 | $ - 0 | $ - 0 |
| 29 | Project Manager I | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 30 | Project Manager II | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 31 | Records Management Specialist I | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 32 | Security Specialist I | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 33 | Sr Media Public Relations Spec. | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 34 | Senior Security Manager | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 35 | Senior Technical Writer | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 36 | Sr. Vector Surveillance Specialist (Entomologist) | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| 37 | Technical Writer_Editor | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 38 | Toxicologist | 3 | 4,302 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 5,736 | $ - 0 | $ - 0 | 3 | 2,868 | $ - 0 | $ - 0 |
| 39 | VBD Bioinformatics Lead Scient | 2 | 2,868 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 3,824 | $ - 0 | $ - 0 | 2 | 1,912 | $ - 0 | $ - 0 |
| 40 | Videographer | 1 | 1,434 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 1,912 | $ - 0 | $ - 0 | 1 | 956 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | - 0 | $ - 0 | $ - 0 | |||||||||||||
| Total Direct Labor | 134 | 192,156 | $ - 0 | $ - 0 | 134 | 256,208 | $ - 0 | $ - 0 | 134 | 256,208 | $ - 0 | $ - 0 | 134 | 256,208 | $ - 0 | $ - 0 | 134 | 256,208 | $ - 0 | $ - 0 | 134 | 128,104 | $ - 0 | $ - 0 |
| Travel | $ - 0 | ||||||
| 41 | Core Funded Travel | $ 43,709.08 | $ 43,709.08 | $ 43,709.08 | $ 43,709.08 | $ 43,709.08 | $ 21,854.54 |
| 42 | Travel (Toxicology) | $ 16,390.91 | $ 16,390.91 | $ 16,390.91 | $ 16,390.91 | $ 16,390.91 | $ 8,195.46 |
| 43 | Travel (Program Evaluation) | $ 5,463.64 | $ 5,463.64 | $ 5,463.64 | $ 5,463.64 | $ 5,463.64 | $ 2,731.82 |
| 44 | Travel (MWD Trauma Registry) | $ 26,000.00 | $ 26,000.00 | $ 26,000.00 | $ 26,000.00 | $ 26,000.00 | $ 13,000.00 |
| 45 | Travel (Red Hill) | $ 21,854.54 | $ 21,854.54 | $ 21,854.54 | $ 21,854.54 | $ 21,854.54 | $ 10,927.27 |
| 47 | 30-Day Phase-In Period | $ 50,000.00 |
Total Travel $ 163,418.17 $ 113,418.17 $ 113,418.17 $ 113,418.17 $ 113,418.17 $ 56,709.09
TOTAL PROPOSED PRICE $ 163,418.17 $ 113,418.17 $ 113,418.17 $ 113,418.17 $ 113,418.17 $ 56,709.09
| TOTALS | |||
| 192,156 | $ 163,418.17 | Ordering Period 1 | |
| 256,208 | $ 113,418.17 | Ordering Period 2 | |
| 256,208 | $ 113,418.17 | Ordering Period 3 | |
| 256,208 | $ 113,418.17 | Ordering Period 4 | |
| 256,208 | $ 113,418.17 | Ordering Period 5 | |
| 128,104 | $ 56,709.09 | FAR 52.217-8 (6-mo ext.) | |
| TOTAL EVALUATED PRICE | 1,345,092 | $ 673,799.94 |
| Controlled by: USAHCA | |
| CUI Category: Source Selection | |
| Distribution/Dissemination Control: | |
| FED ONLY | |
| POC: David J. Libby, 210-221-4808 | |
| CUI |
Sheet1
File details come from the government source that posted it. Updated .