B08 Attachment 0005 - Cost Price Matrix-FHAZ.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
EAGLE Fort Huachuca, AZ W519TC-24-R-0027
Solicitation number
W519TC24R0027
Issued by

About this file

Written by GovTribe AI ·

This is a cost/price matrix spreadsheet template for Fort Huachuca maintenance, supply, and transportation services. The template includes sections for pricing CLINs across a base year and four option years, with a total contract value ceiling of $1,182,289.30. The primary CLINs cover Transition In (0001), Project Management Office Labor (0002), Installation Maintenance Division (0003), Installation Supply Division (0004), Installation Transportation Division (0005), and Other Direct Costs (ODCs) (0006/0007).

The ODCs are the only pre-populated costs, totaling $1,068,980.21 across the performance period, with specific allocations for various maintenance, supply, and transportation requirements including BASOPS maintenance parts ($743,279.01), CIF Supply ($71,992.20), and other operational costs. The template includes a teaming matrix requiring details on the prime contractor and subcontractors, their CAGE codes, roles, functional areas, and security clearance requirements. All labor participants must have SECRET facility clearance, and there are specific requirements for Ammunition Supply Point (ASP) performance.

View the file

Other files

File Type Posted
B08 Attachment 0038 - FHAZ Q and A Responses Round 2.xlsx XLSX spreadsheet
B08 Attachment 0005 - Cost Price Matrix-FHAZ-V4.xlsx XLSX spreadsheet
B08 Attachment 0007 - Wage Determination 15-5719 REV 24.pdf PDF
B08 - W519TC24R0027-0004.pdf PDF
B08 Attachment 0005 - Cost Price Matrix-FHAZ-V3.xlsx XLSX spreadsheet
W519TC24R0027-0003.pdf PDF
B08 Attachment 0024 - PWS Appendix B - Non-ASC Direct Funded Customer USAICoE 111th V2.pdf PDF
B08 - Exhibit B - Contract Data Requirements List Listing V2.xlsx XLSX spreadsheet
B08 Attachment 0037 - FHAZ Q and A Responses Round 1.xlsx XLSX spreadsheet
B08 - W519TC24R0027-0002.pdf PDF
B08 Attachment 0005 - Cost Price Matrix-FHAZ-V2.xlsx XLSX spreadsheet
B08 - W519TC24R0027-0001.pdf PDF
B08 Attachment 0021 - PWS Annex E - Definitions_Acronyms_ Abbreviations.pdf PDF
B08 Attachment 0010 - Blocked File Extensions-with updated DoDAAC.pdf PDF
B08 - Exhibit B - Contract Data Requirements List Listing.xlsx XLSX spreadsheet
B08 Attachment 0011 - Contract References Spreadsheet_FHAZ.xlsx XLSX spreadsheet
B08 Attachment 0017 - PWS Annex A - Maintenance PRS.pdf PDF
B08 Attachment 0024 - PWS Appendix B - Non-ASC Direct Funded Customer USAICoE 111th.pdf PDF
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Accounting System SF 1408.pdf PDF
B08 Attachment 0020 - PWS Annex D - Environmental Requirements.pdf PDF
B08 Attachment 0001 - Performance Work Statement (PWS).pdf PDF
B08 Attachment 0009 - Purchasing Invoicing Guide (PIG) FHAZ.pdf PDF
B08 Attachment 0033 - FHAZ Industry Question Template.xlsx XLSX spreadsheet
B08 Attachment 0007 - Wage Determination 15-5719 REV 23.pdf PDF
B08 - Exhibit J - PM-12 KTR Accident Reporting Format.xlsx XLSX spreadsheet
B08 Attachment 0023 - PWS Appendix A - Non-ASC Direct Funded Customer IMCOM.pdf PDF
B08 - Exhibit D - ITD-01 Transportation Report Format.xlsx XLSX spreadsheet
B08 Attachment 0003 - Performance Questionnaire-FHAZ.pdf PDF
B08 Attachment 0013 - NOT APPLICABLE.pdf PDF
B08 - Exhibit G - PM-08 Scheduled Government Furnished Property Format.xlsx XLSX spreadsheet
W519TC24R0027.pdf PDF
B08 Attachment 0015 - Subcontractor Cost Information Submission.pdf PDF
B08 - Exhibit H - PM-09 Performance Management Review Format (version 5-01-23).pptx PPTX presentation
B08 Attachment 0002 - Staffing and Labor Mix.xlsx XLSX spreadsheet
B08 Attachment 0018 - PWS Annex B - Supply PRS.pdf PDF
B08 - Exhibit K - SS-01 Supply and Services Report Format.xlsx XLSX spreadsheet
B08 - Exhibit E - MMD-01 Maintenance Report Format.xlsx XLSX spreadsheet
B08 - Exhibit A - DD Form 1423-1 Contract Data Requirements List.pdf PDF
B08 Attachment 0014 - NOT APPLICABLE.pdf PDF
B08 Attachment 0004 - Letter of Consent-FHAZ.pdf PDF
B08 Attachment 0025 - PWS Appendix C - Non-ASC Direct Funded Customer EPG.pdf PDF
B08 - Exhibit F - PM-01 Contractor Employee Information Format.xlsx XLSX spreadsheet
B08 Attachment 0019 - PWS Annex C - Transportation PRS.pdf PDF
B08 Attachment 0022 - PWS Annex F - Publications and Forms.pdf PDF
B08 - Exhibit C - CD-02 Burn Rate Report Format.xlsx XLSX spreadsheet
Show all 45

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

Fort Huachuca, AZ (FHAZ)
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

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

FFP Project Management Office (PMO) Labor 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 Maintanance Division - Fee$0$0$0$0$0
CPFFInstallation Supply Division (ISD)0004$0$0$0$0$0$0
Installation Supply Division - Labor$0$0$0$0$0
Installation Supply Division - Fee$0$0$0$0$0
CPFFInstallation Transportation Division (ITD)0005$0$0$0$0$0$0
Installation Transportation Division - Labor$0$0$0$0$0
Installation Transportation Division - Fee$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 F9 (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$201,347$207,388$213,609$220,018$226,618$1,068,980
NSPContractor Manpower Reporting Requirement0009
NSPContract Data item list (CDRLS)0010
Option to Extend Service IAW clause 52.217-8$113,309.09
Total Proposed Price$201,347.31$207,387.73$213,609.36$220,017.64$226,618.17$1,182,289.30

Allocation Tab 1b

Fort Huachuca, AZ (FHAZ)
CLIN
TypeDescriptionCLINBase YearOY1OY2OY3OY4Grand Total

FFP ASC Transition In 0001 $0.00 $0.00 $0.00 $0.00 $0.00

FFPProject Management Office (PMO) Labor0002$0.00
ASC MAINTENANCE (SAG 131) PMO0002AA
ASC SUPPLY SUPPORT (SAG 131) PMO0002BA
ASC ASP (SAG 121) PMO0002CA
NON-ASC IMCOM PMO0002DA
ASC TRANSPORTATION (SAG 131) PMO0002EA
0002FA
0002GA
0002HA
0002JA
0002KA
0002LA
0002MA
0002NA
0002PA
0002QA
0002RA
0002SA
CPFFInstallation Maintenance Division (IMD)0003$0.00$0.00$0.00$0.00$0.00$0.00
ASC BASOPS MAINTENANCE0003AA
ASC BASOPS MAINTENANCE Fee0003AA
ASC FSE EQUIPMENT0003BA
ASC FSE EQUIPMENT Fee0003BA
NON-ASC - EPG0003CA
NON-ASC - EPG Fee0003CA
NON-ASC ISEC0003DA
NON-ASC ISEC Fee0003DA
0003EA
0003EA
CPFFInstallation Supply Division (ISD)0004$0.00$0.00$0.00$0.00$0.00$0.00
ASC CIF Supply0004AA
ASC CIF Supply Fee0004AA
ASC Consolidated Installation Property Book Office (CIPBO) Supply0004BA
ASC Consolidated Installation Property Book Office (CIPBO) Supply Fee0004BA
ASC Hazardous Material (HAZMAT) Supply0004CA
ASC Hazardous Material (HAZMAT) Supply Fee0004CA
ASC Ammunition Supply Point (ASP) Supply0004DA
ASC Ammunition Supply Point (ASP) Supply Fee0004DA
ASC Retail Supply/SSA0004EA
ASC Retail Supply/SSA Fee0004EA
ASC Wholesale Fuel Supply0004FA
ASC Wholesale Fuel Supply Fee0004FA
Non-ASC IMCOM POL Fuel Labor0004GA
Non-ASC IMCOM POL Fuel Labor Fee0004GA
0004HA
0004HA
0004JA
0004JA
0004KA
0004KA

CPFF Installation Transportation Division (ITD) 0005 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

ASC Fleet Management Operation 0005AA

ASC Fleet Management Operation Fee0005AA
ASC Freight / Cargo Movement0005BA
ASC Freight / Cargo Movement Fee0005BA
ASC Personnel Movements and Travel Services0005CA
ASC Personnel Movements and Travel Services Fee0005CA
ASC Personal Property Office0005DA
ASC Personal Property Office Fee0005DA
NON-ASC 111TH MI BDE0005EA
NON-ASC 111TH MI BDE Fee0005EA
0005FA
0005FA
0005GA
0005GA
0005HA
0005HA
0005JA
0005JA
0005KA
0005KA
0005LA
0005LA
0005MA
0005MA
0005NA
0005NA
0005PA
0005PA
0005QA
0005QA
Other Direct Costs (ODC)0006/0007$201,347.31$207,387.73$213,609.36$220,017.64$226,618.17$1,068,980.21
ASC BASOPS Maintenance-Repair Parts ODC0006AA$140,000.00$144,200.00$148,526.00$152,981.78$157,571.23
ASC- BASOPS Maintenance-ODC0006BA$1,000.00$1,030.00$1,060.90$1,092.73$1,125.51
ASC-CIF Supply ODC0006CA$13,560.06$13,966.86$14,385.87$14,817.44$15,261.97
ASC- Retail/SSA Supply ODC0006DA$15,138.52$15,592.68$16,060.46$16,542.27$17,038.54
ASC-CIPBO Supply-ODC0006EA$2,739.28$2,821.46$2,906.10$2,993.29$3,083.08
ASC Whole Sale Fuel Supply-ODC0006FA$5,533.24$5,699.24$5,870.21$6,046.32$6,227.71
ASC-ASP Supply- ODC0006GA$9,468.40$9,752.45$10,045.03$10,346.38$10,656.77
ASC-HAZMART Supply ODC0006HA$2,322.81$2,392.49$2,464.27$2,538.20$2,614.34
ASC- Fleet Management Operation-ODC0006JA$425.00$437.75$450.88$464.41$478.34
ASCPersonal Property Office- ODC0006KA$850.00$875.50$901.77$928.82$956.68
ASC-Freight/Cargo Movement-ODC0006LA$170.00$175.10$180.35$185.76$191.34
ASC-Personnal Movments & Travel-ODC0006MA$255.00$262.65$270.53$278.65$287.00
ASC-POI Transportation- ODC0006NA$6,685.00$6,885.55$7,092.12$7,304.88$7,524.03
Non-ASC-IMCOM DEFUEL SUPPLY ODC0007AA$2,000.00$2,060.00$2,121.80$2,185.45$2,251.02
Non-ASC-111th MI BDE - ODC0007BA$1,200.00$1,236.00$1,273.08$1,311.27$1,350.61
0006SA
0007AA
0007BA
0007CA
0007DA
0007EA
0007FA
0007GA
0007HA
0007JA
0007KA
0007LA
0007MA
0007NA
Contractor Manpower Reporting Requirement0009
Contract Data item list (CDRLS)0010
Option to Extend Service IAW clause 52.217-8$113,309.09
Total Proposed Price$201,347.31$207,387.73$213,609.36$220,017.64$226,618.17$1,182,289.30
$1,182,289.30

PMO allocation will be applied at award by the Government.

Teaming_Matrix_Tab_2

Company NameCage CodeRoleFunctional area(s) to performProposed Labor / FeePercentage of participationCost Information Submittal MethodSECRET Facility ClearancePerforming ASP
1BOA HolderPDIRYES
2Subcontractor 1
3Subcontractor 2
4Subcontractor 3
5Subcontractor 4
6Subcontractor 5
7Subcontractor 6
*Total:$0.00100%
Subtotal Proposed Labor/Fee$0** COMPLIANCE WARNING If CELL F9 (Total - Proposed Labor / Fee on Teaming Matrix Tab 2) does not equal 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.

(C) CAGE Code: list the corresponding CAGE code for the Offeror and all proposed subcontractors. 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
(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
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.

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