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

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 ElementsOrdering 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 CategoryOrdering Period 1

Ordering Period 2

Ordering Period 3

Ordering Period 4

Ordering Period 5

FAR 52.217-8

6-Mo Option to Extend

FTEHrsFBLRExt. PriceFTEHrsFBLRExt. PriceFTEHrsFBLRExt. PriceFTEHrsFBLRExt. PriceFTEHrsFBLRExt. PriceFTEHrsFBLRExt. Price
1Administrative Assistant III68,604$ - 0$ - 0611,472$ - 0$ - 0611,472$ - 0$ - 0611,472$ - 0$ - 0611,472$ - 0$ - 065,736$ - 0$ - 0
2Animal Caretaker I22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
3Biological Sciences Technician11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
4Biomedical Equipment Technician22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
5Biostatistician II1217,208$ - 0$ - 01222,944$ - 0$ - 01222,944$ - 0$ - 01222,944$ - 0$ - 01222,944$ - 0$ - 01211,472$ - 0$ - 0
6Chemist57,170$ - 0$ - 059,560$ - 0$ - 059,560$ - 0$ - 059,560$ - 0$ - 059,560$ - 0$ - 054,780$ - 0$ - 0
7Crystal Reports Writer22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
8Data Analyst I45,736$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 043,824$ - 0$ - 0
9Data Scientist Engineer68,604$ - 0$ - 0611,472$ - 0$ - 0611,472$ - 0$ - 0611,472$ - 0$ - 0611,472$ - 0$ - 065,736$ - 0$ - 0
10Data Technician I45,736$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 043,824$ - 0$ - 0
11Epidemiologist3245,888$ - 0$ - 03261,184$ - 0$ - 03261,184$ - 0$ - 03261,184$ - 0$ - 03261,184$ - 0$ - 03230,592$ - 0$ - 0
12Geographic Info System (GIS) Spec.22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
13Graphics Design Specialist34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
14Graphics Designer34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
15Health Educator34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
16Health Outreach Coordinator11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
17Laboratory Systems Officer11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
18Laboratory Technician34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
19Managing Editor11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
20Mechanical Engineer11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
21MSMR Consultant11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
22MSMR Editor Sr Medical Advisor11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
23MWD Casualty Care Coordinator11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
24MWD Trauma Registry Data Abstractor22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
25Operations Coordinator57,170$ - 0$ - 059,560$ - 0$ - 059,560$ - 0$ - 059,560$ - 0$ - 059,560$ - 0$ - 054,780$ - 0$ - 0
26Operations Security Coordinator11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
27Program Evaluator II22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
28Program Evaluator III45,736$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 047,648$ - 0$ - 043,824$ - 0$ - 0
29Project Manager I34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
30Project Manager II34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
31Records Management Specialist I22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
32Security Specialist I22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
33Sr Media Public Relations Spec.11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
34Senior Security Manager11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
35Senior Technical Writer22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
36Sr. Vector Surveillance Specialist (Entomologist)11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 0$ - 0
37Technical Writer_Editor22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
38Toxicologist34,302$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 035,736$ - 0$ - 032,868$ - 0$ - 0
39VBD Bioinformatics Lead Scient22,868$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 023,824$ - 0$ - 021,912$ - 0$ - 0
40Videographer11,434$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 011,912$ - 0$ - 01956$ - 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 Labor134192,156$ - 0$ - 0134256,208$ - 0$ - 0134256,208$ - 0$ - 0134256,208$ - 0$ - 0134256,208$ - 0$ - 0134128,104$ - 0$ - 0
Travel$ - 0
41Core Funded Travel$ 43,709.08$ 43,709.08$ 43,709.08$ 43,709.08$ 43,709.08$ 21,854.54
42Travel (Toxicology)$ 16,390.91$ 16,390.91$ 16,390.91$ 16,390.91$ 16,390.91$ 8,195.46
43Travel (Program Evaluation)$ 5,463.64$ 5,463.64$ 5,463.64$ 5,463.64$ 5,463.64$ 2,731.82
44Travel (MWD Trauma Registry)$ 26,000.00$ 26,000.00$ 26,000.00$ 26,000.00$ 26,000.00$ 13,000.00
45Travel (Red Hill)$ 21,854.54$ 21,854.54$ 21,854.54$ 21,854.54$ 21,854.54$ 10,927.27
4730-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.17Ordering Period 1
256,208$ 113,418.17Ordering Period 2
256,208$ 113,418.17Ordering Period 3
256,208$ 113,418.17Ordering Period 4
256,208$ 113,418.17Ordering Period 5
128,104$ 56,709.09FAR 52.217-8 (6-mo ext.)
TOTAL EVALUATED PRICE1,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 .