B08 Attachment 0005 - Cost Price Matrix.xlsx

XLSX spreadsheet 42 KB Posted

Attached to
EAGLE Fort McCoy, WI - W519TC-23-R-0119
Solicitation number
W519TC23R0119
Issued by

About this file

This document appears to be a Cost Price Matrix Excel file related to a federal contract opportunity for maintenance, supply, and transportation services at Fort McCoy, Wisconsin. The file includes detailed pricing information across various contract line item numbers (CLINs) for different service categories such as Transition In, Project Management Office, Installation Maintenance Division, Installation Supply Division, and Installation Transportation Division. The pricing is provided for the base year and four option years. The file also includes a Teaming Matrix tab that outlines the proposed subcontractors and their roles and functional areas. The related federal contract opportunity is Solicitation Number W519TC-23-R-0119, issued by the Department of the Army Materiel Command Contracting Command Rock Island Arsenal, for maintenance, supply, and transportation services at Fort McCoy, Wisconsin.

View the file

Other files

File Type Posted
W519TC-23-R-0119 - 0008.pdf PDF
W519TC-23-R-0119 - 0007.pdf PDF
W519TC-23-R-0119 - 0006.pdf PDF
W519TC-23-R-0119 - 0005.pdf PDF
W519TC-23-R-0119 - 0004.pdf PDF
B08 Attachment 0001 - PWS v2.pdf PDF
W519TC-23-R-0119 - 0003.pdf PDF
W519TC-23-R-0119 - 0002.pdf PDF
W519TC-23-R-0119 - 0001.pdf PDF
B08 Attachment 0014 - NOT APPLICABLE.pdf PDF
B08 Attachment 0024 - Appendix B - 181st MFTB.docx DOCX document
B08 Attachment 0002 - Staffing and Labor Mix.xlsx XLSX spreadsheet
B08 Attachment 0018 - PWS Annex B - Supply PRS.pdf PDF
B08 Attachment 0012 - NOT APPLICABLE.pdf PDF
B08 Attachment 0015 - Subcontractor Cost Information Submission.pdf PDF
B08 Solicitation - W519TC23R0119.pdf PDF
B08 Attachment 0021 - PWS Annex E - Definitions Acronyms and Abbreviations.docx DOCX document
B08 Attachment 0003 - Performance Questionnaire.pdf PDF
B08 Attachment 0023 - Appendix A - 88th RD.docx DOCX document
B08 Attachment 0009 - Purchasing Invoicing Guide (PIG).docx DOCX document
B08 Attachment 0025 - Appendix C - Garrison Support.docx DOCX document
B08 Attachment 0020 - PWS Annex D - Environmental Requirements.docx DOCX document
B08 Attachment 0007 - Department of Labor Wage Determinations 2015-4929-26.pdf PDF
B08 Attachment 0010 - Blocked File Extensions.pdf PDF
B08 Attachment 0017 - PWS Annex A - Maintenance PRS.pdf PDF
B08 Attachment 0022 - PWS Annex F - Publications and Forms.docx DOCX document
B08 Attachment 0001 - PWS.pdf PDF
B08 Attachment 0026 - Appendix D - 94th TD.docx DOCX document
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Acctng System SF 1408.pdf PDF
B08 Attachment 0013 - Mission Essential Contractor Services.pdf PDF
B08 Attachment 0032 - FMWI Industry Question Template.xlsx XLSX spreadsheet
B08 Attachment 0004 - Letter of Consent.pdf PDF
B08 Attachment 0011 - Contract References Spreadsheet.xlsx XLSX spreadsheet
B08 Attachment 0019 - PWS Annex C - Transportation PRS.pdf PDF
Show all 34

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

Cost_Price_Abstract_Tab_1a

Ft. McCoy, WI (FMWI)
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 F11 (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$321,020$330,651$340,570$350,787$361,311$1,704,339
NSPContractor Manpower Reporting Requirement0009
NSPContract Data item list (CDRLS)0010
Option to Extend Service IAW clause 52.217-8$180,655.42
Total Proposed Price$321,020.00$330,650.60$340,570.12$350,787.22$361,310.84$1,884,994.20

Allocation Tab 1b

Ft. McCoy, WI (FMWI)
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 PMO0002AA
ASC Supply PMO0002BA
ASC ASP PMO0002CA
ASC Transportation PMO0002DA
ASC Deployment Readiness PMO0002EA
Non-ASC 88th RD PMO0002FA
Non-ASC 181st MFTB PMO0002GA
Non-ASC Garrison PMO0002HA
Non-ASC 94th TD PMO0002JA
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 Maintenance0003BA
ASC FSE Maintenance Fee0003BA
Non-ASC 88th RD Maintenance0003CA
Non-ASC 88th RD Maintenance Fee0003CA
Non-ASC 181st MFTB Maintenance0003DA
Non-ASC 181st MFTB Maintenance Fee0003DA
CPFFInstallation Supply Division (ISD)0004$0.00$0.00$0.00$0.00$0.00$0.00
ASC Central Issue Facility (CIF)0004AA
ASC Central Issue Facility (CIF) Fee0004AA
ASC Supply Support Activity (SSA)0004BA
ASC Supply Support Activity (SSA) Fee0004BA
ASC Hazardous Material Supply Operations (HMSO)0004CA
ASC Hazardous Material Supply Operations (HMSO) Fee0004CA
ASC Ammunition Supply Point (ASP)0004DA
ASC Ammunition Supply Point (ASP) Fee0004DA
CPFFInstallation Transportation Division (ITD)0005$0.00$0.00$0.00$0.00$0.00$0.00
ASC Personal Property Office (PPO)0005AA
ASC Personal Property Office (PPO) Fee0005AA
ASC Deployment Readiness0005BA
ASC Deployment Readiness Fee0005BA
ASC Locomotive Maintenance0005CA
ASC Locomotive Maintenance Fee0005CA
ASC Rail Operations0005DA
ASC Rail Operations Fee0005DA
Non-ASC Garrison Transportation Support0005EA
Non-ASC Garrison Transportation Support Fee0005EA
Non-ASC 94th TD Transportation Support0005FA
Non-ASC 94th TD Transportation Support Fee0005FA
CostOther Direct Costs (ODC)0006/0007$321,020.00$330,650.60$340,570.12$350,787.22$361,310.84$1,704,338.78
ASC Basops Maintenance ODC0006AA$3,200.00$3,296.00$3,394.88$3,496.73$3,601.63
ASC Basops Maintenance External Parts ODC0006BA$275,000.00$283,250.00$291,747.50$300,499.93$309,514.92
ASC Central Issue Facility (CIF) ODC0006CA$1,100.00$1,133.00$1,166.99$1,202.00$1,238.06
ASC Supply Support Activity (SSA) ODC0006DA$3,000.00$3,090.00$3,182.70$3,278.18$3,376.53
ASC Hazardous Material Supply Operations (HMSO) ODC0006EA$300.00$309.00$318.27$327.82$337.65
ASC FSE Maintenance ODC0006FA$5,000.00$5,150.00$5,304.50$5,463.64$5,627.54
ASC Ammunition Supply Point ODC0006GA$1,100.00$1,133.00$1,166.99$1,202.00$1,238.06
ASC Personal Property Office (PPO) ODC0006HA$300.00$309.00$318.27$327.82$337.65
ASC Deployment Readiness ODC0006JA$220.00$226.60$233.40$240.40$247.61
ASC Locomotive ODC0006KA$200.00$206.00$212.18$218.55$225.10
ASC Rail Operations ODC0006LA$100.00$103.00$106.09$109.27$112.55
Non-ASC 88th RD Maintenance ODC0007AA$5,500.00$5,665.00$5,834.95$6,010.00$6,190.30
Non-ASC 181st MFTB Maintenance ODC0007BA$500.00$515.00$530.45$546.36$562.75
Non-ASC Garrison Transportation Support ODC0007CA$25,000.00$25,750.00$26,522.50$27,318.18$28,137.72
Non-ASC 94th TD Transportation Support ODC0007DA$500.00$515.00$530.45$546.36$562.75
Contractor Manpower Reporting Requirement0009
Contract Data item list (CDRLS)0010
Option to Extend Service IAW clause 52.217-8$180,655.42
Total Proposed Price$321,020.00$330,650.60$340,570.12$350,787.22$361,310.84$1,884,994.20
$1,884,994.20

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 MethodPerforming ASP
1BOA HolderPERROR:#DIV/0!DIR
2Subcontractor 1ERROR:#DIV/0!
3Subcontractor 2ERROR:#DIV/0!
4Subcontractor 3ERROR:#DIV/0!
5Subcontractor 4ERROR:#DIV/0!
6Subcontractor 5ERROR:#DIV/0!
7Subcontractor 6ERROR:#DIV/0!
8Subcontractor 7ERROR:#DIV/0!
9Subcontractor 8ERROR:#DIV/0!
*Total:$0.00ERROR:#DIV/0!
Subtotal Proposed Labor/Fee$0.00** COMPLIANCE WARNING If CELL F11 (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.)
* 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%.
*Cells are locked with a DIV formula, calculating the percentage of the subcontractor costs to the total cost
(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 .