B08 Attachment 0005 - Cost-Price Matrix 11Feb2025.xlsx

XLSX spreadsheet 37 KB Posted

Attached to
EAGLE Dugway Proving Ground, UT: W519TC-25-R-0008
Solicitation number
W519TC25R0008
Issued by

About this file

Written by GovTribe AI ·

This is a Cost-Price Matrix template spreadsheet for a maintenance, supply, and transportation services contract at Dugway Proving Ground, Utah. The spreadsheet contains three main tabs: a cost-price abstract, allocation breakdown, and teaming matrix.

The contract includes FFP CLINs for Transition In (0001), Project Management Office (0002), Installation Supply Division (0004), Installation Transportation Division (0005), and a CPFF CLIN for Installation Maintenance Division (0003). The template shows ODCs totaling $2,158,163.71 across the base year and four option years, with annual increases of approximately 3%. The total proposed price including the 52.217-8 six-month extension option is $2,386,923.38. The allocation tab breaks down funding across various organizations including ASC, ATEC, NEC, CBC, and Garrison elements. The teaming matrix requires details on the prime contractor, joint venture members (if applicable), and up to 6 subcontractors, including their CAGE codes, roles, functional areas, and security clearance requirements. Critical performance tasks include Ammunition Supply Point (ASP) operations.

View the file

Other files

File Type Posted
E01 W519TC-25-R-0008 Amendment 0003.pdf PDF
E01 W519TC25R0008 Amendment 0002.pdf PDF
E01 W519TC25R0008 Amendment 0001.pdf PDF
W519TC25R0008.pdf PDF
B08 Attachment 0011 - Contract References Spreadsheet (01.23.2024).xlsx XLSX spreadsheet
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Accounting System SF 1408.pdf PDF
B08 Attachment 0007 - Dept of Labor Wage Determ 2015-5489 REV25.pdf PDF
B08 Attachment 0019 - PWS Annex C - Transportation PRS.docx DOCX document
B08 Attachment 0010 - Blocked File Extensions.pdf PDF
B08 Attachment 0018 - PWS Annex B - Supply PRS.docx DOCX document
B08 Attachment 0001 - Performance Work Statement (PWS) DPG 15JAN25.pdf PDF
B08 Attachment 0020 - PWS Annex D Environmental Requirements.docx DOCX document
B08 Attachment 0021 - PWS Annex E Definitions Acronyms and Abbreviations.docx DOCX document
B08 Attachment 0015 - Subcontractor Cost Information Submission.pdf PDF
B08 Attachment 0017 - PWS Annex A - Maintenance PRS.docx DOCX document
B08 Attachment 0003 - Performance Questionnaire.pdf PDF
B08 Attachment 0022 - PWS Annex F Publications and Forms.docx DOCX document
B08 Attachment 0013 - Mission Essential Contractor Services DPG.pdf PDF
B08 Attachment 0002 - Staffing and Labor Mix.xlsx XLSX spreadsheet
B08 Attachment 0009 - Purchasing Invoicing Guide DPG.pdf PDF
B08 Attachment 0004 - Letter of Consent.pdf PDF
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.

Cost_Price_Abstract_Tab_1a

OFFEROR:0CAGE CODE:0
Dugway Proving Ground, UT (DPG)
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

FFP Transition In 0001 $0 $0 $0 $0 $0 $0

FFP Project Management Office (PMO) 0002 $0 $0 $0 $0 $0 $0

CPFFInstallation Maintenance Division (IMD)0003$0$0$0$0$0$0
Installation Maintenance Division - Labor$0$0$0$0$0
Installation Maintenance Division - Fee$0$0$0$0$0
FFPInstallation Supply Division (ISD)0004$0$0$0$0$0$0
Installation Supply Division - Labor$0$0$0$0$0
FFPInstallation Transportation Division (ITD)0005$0$0$0$0$0$0
Installation Transportation Division - Labor$0$0$0$0$0
Subtotal - Proposed Labor / Fee$0.00$0.00$0.00$0.00$0.00$0.00
**COMPLIANCE WARNING** If CELL I22 (Subtotal-Proposed Labor/Fee on Cost Price Matrix Tab 1a) does not equal CELL F12 (Total Proposed Labor/Fee on Teaming Matrix Tab 2) then per L.5.1.7(a), the Offeror's proposal will be non-compliant.
CostOther Direct Costs (ODC)0006/0007$ 406,500.00$ 418,695.00$ 431,255.85$ 444,193.53$ 457,519.33$ 2,158,163.71
NSPContractor Manpower Reporting Requirement0009
NSPContract Data item list (CDRLS)0010
Option to Extend Service IAW clause 52.217-8$228,759.67
Total Proposed Price$ 406,500.00$ 418,695.00$ 431,255.85$ 444,193.53$ 457,519.33$ 2,386,923.38

Allocation Tab 1b

OFFEROR:CAGE CODE:
Dugway Proving Ground, UT (DPG)
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

FFP Transition In 0001 $0 $0 $0 $0 $0

FFPProject Management Office (PMO)0002$0
ASC MAINTENANCE (SAG 131) PMO0002AAPMO allocation will be applied at award by the Government.
ASC SUPPLY (SAG 131) PMO0002BA
ASC TRANSPORTATION (SAG 131) PMO0002CA
NON-ASC ATEC PMO0002DA
NON-ASC NEC PMO0002EA
NON-ASC CBC PMO0002FA
NON-ASC GARRISON PMO0002GA
NON-ASC YUMA PMO0002HA
CPFFInstallation Maintenance Division (IMD)0003$0$0$0$0$0$0
ASC BASOPS Maintenance0003AA
ASC BASOPS Maintenance Fee0003AA
Non-ASC ATEC MAINTENANCE SUPPORT0003BA
Non-ASC ATEC MAINTENANCE SUPPORT Fee0003BA
Non-ASC ATEC MAINTENANCE WEAPONS REPAIR0003CA
Non-ASC ATEC MAINTENANCE WEAPONS REPAIR Fee0003CA
Non-ASC NEC MAINTENANCE SUPPORT0003DA
Non-ASC NEC MAINTENANCE SUPPORT Fee0003DA
Non-ASC CBC MAINTENANCE SUPPORT0003EA
Non-ASC CBC MAINTENANCE SUPPORT Fee0003EA
Non-ASC GARRISON TRANSPORTATION MAINTENANCE-GSA0003FA
Non-ASC GARRISON TRANSPORTATION MAINTENANCE-GSA Fee0003FA
Non-ASC YUMA WEAPONS MAINTENANCE REPAIR0003GA
Non-ASC YUMA WEAPONS MAINTENANCE REPAIR Fee0003GA
FFPInstallation Supply Division (ISD)0004$0$0$0$0$0$0
ASC SUPPLY SUPPORT ACTIVITY (SSA)0004AA
ASC HMSO SUPPORT ACTIVITY0004BA
Non-ASC ATEC SUPPLY SUPPORT ACTIVITY (SSA)0004CA
Non-ASC NEC SUPPLY SUPPORT ACTIVITY (SSA)0004DA
FFPInstallation Transportation Division (ITD)0005$0$0$0$0$0$0
ASC FLEET MANAGEMENT0005AA
Non-ASC ATEC TRANSPORTATION0005BA
Non-ASC NEC TRANSPORTATION0005CA
Non-ASC CBC TRANSPORTATION0005DA
CostOther Direct Costs (ODC)0006/0007$ 406,500.00$ 418,695.00$ 431,255.85$ 444,193.53$ 457,519.33$ 2,158,163.71
ASC Maintenance ODC0006AA$ 150,000.00$ 154,500.00$ 159,135.00$ 163,909.05$ 168,826.32
ATEC ODC0007AA$ 230,000.00$ 236,900.00$ 244,007.00$ 251,327.21$ 258,867.03
NEC ODC0007BA$ 15,000.00$ 15,450.00$ 15,913.50$ 16,390.91$ 16,882.63
CBC ODC0007CA$ 1,500.00$ 1,545.00$ 1,591.35$ 1,639.09$ 1,688.26
YUMA ODC0007DA$ 10,000.00$ 10,300.00$ 10,609.00$ 10,927.27$ 11,255.09
NSPContractor Manpower Reporting Requirement0009
NSPContract Data item list (CDRLS)0010
Option to Extend Service IAW clause 52.217-8$228,759.67
Total Proposed Price$406,500.00$418,695.00$431,255.85$444,193.53$457,519.33$2,386,923.38
$2,386,923.38

Teaming_Matrix_Tab_2

Company NameCage CodeRoleFunctional area(s) to performProposed Labor / FeePercentage of participationCost Information Submittal MethodSECRET Facility ClearancePerforming ASP
1BOA HolderPERROR:#DIV/0!DIR
Joint Venture Member (if applicable)ERROR:#DIV/0!
Joint Venture Member (if applicable)ERROR:#DIV/0!
Joint Venture Member (if applicable)ERROR:#DIV/0!
2Subcontractor 1ERROR:#DIV/0!
3Subcontractor 2ERROR:#DIV/0!
4Subcontractor 3ERROR:#DIV/0!
5Subcontractor 4ERROR:#DIV/0!
6Subcontractor 5ERROR:#DIV/0!
7Subcontractor 6ERROR:#DIV/0!
*Total:$0ERROR:#DIV/0!
Subtotal Proposed Labor/Fee$0** COMPLIANCE WARNING ** If CELL F12 (Total Proposed Labor/Fee on Teaming Matrix Tab 2) does not equal yellow CELL I22 (Subtotal-Proposed Labor/Fee on Cost Price Matrix Tab 1a), then per L.5.1.7(a), the Offeror's proposal will be non-compliant.
(A) Offeror may NOT add or delete rows to accommodate the total number of participants.

(B) Company Name: list the name of the Offeror and all proposed subcontractors and Joint Venture members (as applicable) See L.5.1.8.

(C) CAGE Code: list the corresponding CAGE code for the Offeror and all proposed subcontractors and Joint Venture members as applicable (See L.5.1.8). The listed CAGE Code shall remain consistent throughout the Offeror’s entire proposal.

(D) Role: fill in with either: P, S or an O (defined below) for each participant.
P - Offeror (Defaut for BOA Holder)
S - Major Subcontractor performing 20% or more for the total value of the contract.
O - Other Subcontractor performing less than 20% for the total value of the contract.
(E) Offeror to identify which functional area(s) will be performed for each participant as follows:
M - Maintenance
S - Supply
T - Transportation
MS - Maintenance and Supply
ST - Supply and Transportation
MT - Maintenance and Transportation
MST - Maintenance, Supply and Transportation
(F) Proposed Labor / Fee for each participant for the entire Period of Performance (excluding ODCs and the option to extend.)
* Formatting is set to only allow for whole dollars (no cents (i.e. decimals) are allowed)
* The Tab 2 Total in column F is a locked cell with a SUM formula of the values entered in the column F blue cells.
(G) Percentage of participation for each participant for the entire Period of Performance. The total in this column should equal 100%.
* Formatting is set to only allow for whole percentages
(H) Offeror to identify cost information Submittal Method each Subcontractor as follows:
D I R - Subcontractor submitting independently, Default for BOA Holder.
W I O S - Subcontractor submitting cost information within Offeror’s submission
Note: Columns D-H are not applicable to Joint Venture members
(I) Offeror to identify each participant performing contract requirements which necessitate SECRET facility clearance as follows:
YES - Offeror/Subcontractor will perform contract requirements that necessitiate SECRET facility clearance. NOTE: All Joint Venture members shall possess a SECRET Clearance regardless of the work the member will be performing (See L.5.1.8)
NO - Offeror/Subcontractor will NOT perform contract requirements that necessitiate SECRET facility clearance
(J) Offeror to identify which participants will perform critical performance task Ammunition Supply Point (ASP).
YES - Offeror/Subcontractor will perform ASP tasks.
NO - Offeror/Subcontractor will NOT perform ASP tasks.
Note: Column J is not applicable to Joint Venture members.

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