Attch 02B_rev1_Sub_Cost_Pricing_Matrix_28 May 2021.xls

XLS spreadsheet 98 KB Posted

Attached to
Simulation Center Federal contract opportunity
Solicitation number
W9113m
Issued by
Department of the Army Materiel Command Contracting Command Redstone Arsenal

About this file

This document provides templates for a subcontractor's cost proposal in response to a solicitation from the Department of the Army Materiel Command Contracting Command for simulation center support services. The templates require the subcontractor to provide fully burdened labor rates, direct production hours, material costs, other direct costs including travel, and total contract pricing for the base year and two one-year option periods. Labor categories and hourly rates must be mapped to the government's labor category descriptions. Material, other direct costs, and travel are limited to specified ceiling amounts annually. Subcontractors must coordinate with primes to ensure overall proposed costs do not exceed program totals. Formulas must be shown and maintained in electronic files to calculate rates.

View the file

Other files for this federal contract opportunity

Other files attached to Simulation Center, newest first.
File Type Posted
Attch 02A_rev2_Prime_Cost_Price_Matrix_28 May 2021.xls XLS spreadsheet
W9113M-21-R-0060-03.pdf PDF
W9113M-21-R-0060 Amendment 3 Conform copy.pdf PDF
Attch 02A_Prime_Cost_Price_Matrix_Rev 01 12 May 2021.xls XLS spreadsheet
SimCtr Offeror RFP Questions Final_14May21.pdf PDF
Attch 01 Simulation Center Labor Category Descriptions rev1 Final_12MAY21.pdf PDF
W9113M-21-R-0060 Amendment 2.pdf PDF
W9113M-21-R-0060 Amendment 2 Conformed Copy.pdf PDF
Attch 04 SimCtr Government Furnished Property Inventory List_31Mar2021.xlsx XLSX spreadsheet
Exhibit ADD1423 Contract Data Requirements List.pdf PDF
Attch 02B_Sub_Cost_Pricing_Matrix_01 Apr 2021.xls XLS spreadsheet
RFP W9113M-21-R-0060.pdf PDF
Attch 02A_Prime_Cost_Price_Matrix_01 Apr 2021.xls XLS spreadsheet
Simulation Center Vendor List_06Apr2021.xlsx XLSX spreadsheet
Attch 05 DDForm254Contract Security Classification Specification.pdf PDF
Exhibit B Instructions for Assertions Regarding Data Rights_07Apr2021.pdf PDF
RFP W9113M-21-R-0060 Amendment 1.pdf PDF
Exhibit C-Invention Reporting Instructions_07Apr2021.pdf PDF
Attch 03 Layout of Simulation Center1_09Apr2021.pdf PDF
Attch 01 Simulation Center Labor Category Descriptions.pdf PDF
Attch 06- Contractors DCAA and DCMA Office Information_07Apr2021.pdf PDF
Show all 21

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Subcontractor Instructions

Simulation Center (SimCtr)

This workbook shall be used per Section J - Attachment 02B Pricing Matrices for the proposed pricing format. While this workbook will be supplemented by the offeror's worksheet/workbooks to clearly depict rate build-up/development, the final work product must ultimattely be submitted in the format provided in this workbook. Follow the instructions provided in Section L of the RFP. It will assist the Government in reviewing your proposal more quickly.

The spreadsheets in this file contain links. Deleting or adding to the tables in the spreadsheets can cause the links to break or the formulas to be wrong. Since this is being provided as a guide only, the Contractor is ultimately responsible for proper calculation and verification of ALL FORMULAS AND LINKS in this workbook.

Identify the offeror’s proposed internal labor categories that comprise the GLCs, per Section J Attachment 01 Simulation Center Labor Category Descriptions, and provide a crosswalk that clearly correlates the offeror’s internal labor categories to the GLCs in terms of the duties/responsibilities, education level, and years of experience of the applicable positions. If the offeror proposes internal labor categories that cannot be reasonably mapped to the GLCs, the proposal shall identify the category titles and their qualification requirements (i.e., duties/responsibilities, education levels, clearance level and years of experience.

Do not protect cells; the Government may utilize the spreadsheets to calculate Probable Cost.

This Cost Volume shall be completed for each prime proposed to support the SimCtr contract. The Prime is also responsible for summarizing the total costs of their team described in Section L of the RFP. This workbook may be incorporated into Section J of the resultant contract.

Replace distribution statement in the footer with company's release instructions.

Total Contract

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
SUBCONTRACTOR:___________________________________
Base Year (3-Years)Total DollarsOption Year 1 (1-Year)Total DollarsOption Year 2 (1-Year)Total DollarsTotal Dollars
CLIN 0001 Labor$ - 0CLIN 1001 Labor$ - 0CLIN 2001 Labor$ - 0$ - 0
CLIN 0002 Surge Labor$ - 0CLIN 1002 Surge$ - 0CLIN 2002 Surge$ - 0$ - 0
CLIN 0003 Material$ 8,162,144.00CLIN 1003 Material$ 1,443,242.00CLIN 2003 Material$ 1,472,107.00$ 11,077,493.00
CLIN 0004 Other Direct Costs$ 2,040,536.00CLIN 1004 Other Direct Costs$ 360,810.00CLIN 2004 Other Direct Costs$ 2,401,346.00$ 4,802,692.00
CLIN 0005 Travel$ 128,536.00CLIN 1005 Travel$ 44,570.00CLIN 2005 Travel$ 173,106.00$ 346,212.00
Total by CLIN by Ordering Period$ 10,331,216.00$ 1,848,622.00$ 4,046,559.00$ 16,226,397.00
Overall Total
Note: This is a guide template. All electronic files shall include all links and formulas used to calculate rates and they shall be maintained throughout all revisions. All files (electronic) shall be cross-referenced to supporting files.

Base Labor CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
SUBCONTRACTOR:___________________________________
Labor CategoryBase Labor RateFringe BenefitsGovt Site OHLoaded Labor thru OHG&ALoaded Rate thru G&ACLIN 0001CLIN 1001CLIN 2001
Base Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)
% of B% of B(B)+(C)+(D)% of E(E)+(F)Major Sub Non-Small BusinessMajor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMajor Sub Non-Small BusinessMajor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMajor Sub Non-Small BusinessMajor Subs Small Business% ofFeeLoaded Labor Rate thru Fee
TotalFBLR% of LTotalTotalFBLR% of TTotalTotalFBLR% of ABTotal
Insert Fringe Rate ↓Insert OH Rate ↓Insert G&A Rate ↓TotalLabor HrEsc. Rate**Insert Fee Rate ↓(L)+(M)LaborTotalLabor HrEsc. Rate**Insert Fee Rate ↓(T)+(U)LaborTotalLabor HrEsc. Rate**Insert Fee Rate ↓(AB)+(AC)Labor
Insert Rate ↓0.00%0.00%0.00%DPPHs *DPPHs *DPPHsMiX0.00%0.00%DollarsDPPHs *DPPHs *DPPHsMiX0%0.00%DollarsDPPHs *DPPHs *DPPHsMiX0%0.00%Dollars
1.0 Program Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
2.0 Network Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
3.0 Network Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
4.0 Network Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
5.0 System Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
6.0 System Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
7.0 System Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
8.0 Security Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
9.0 Security Clerk$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
10.0 Security Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
11.0 Program Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
12.0 Property Admin$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
13.0 Admin Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
14.0 Media Librarian/Document Control Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
15.0 SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
16.0 Military Operations Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
Total Estimated Hours0.00.00.00.0%0.00.00.00.00.0%0.00.00.00.00.0%0.0
Note: This is a guide template. The proposed allocation of labor hours among labor GLCs for the base effort (CLIN 0001) and the base support options (CLINs 1001, and 2001) is at the offeror’s discretion; however, the offeror must ensure that its allocation is both consistent with the proposed technical solutions and sufficient for accomplishing the overall PWS requirements. If propoing internal labor categories that cannot be reasonably mapped to the above GLCs (per the Simulation Center Labor Category Descriptions in the Section J Attachment 01 of the solicitaiton), the proposal shall identify the category titles and their qualification requirements (i.e., duties/responsibilities, education levels, clearance requirements and years of experience). If there are other indirects that need to be added or if your system is different from that provided above, the template can be revised as necessary. All electronic files shall include all links and formulas used to calculate rates and they shall be maintained throughout all revisions. All files (electronic) shall be cross-referenced to supporting files.
*The offeror shall show the number of Direct Person Production Hours (DPPH) in a proposed year. [Show proposed DPPH calcuations: e.g. total hours less hours for vacation, less hours for holidays, less hours for sick leave = Total DPPH. If proposing uncompensated overtime, adjust DPPHs to cover the extra hours proposed to be worked.
**Escalation rates columns are used for escalation of labor rates. Offeror's can insert additional columns as needed for varying, projected indirect rates (i.e., fringe, OH, G&A) for the out years, as applicable. NOTE: Offeror's can choose to use the escalation column for factoring in the build-up of the projected indirect rates with labor escalation. Contractors shall show their formula build-up in applying the out year(s) and are ultimately responsible for providing specific narrative description and showing their formulas in the cells.

Surge Labor CLINs

SUBCONTRACTOR:___________________________________
Labor CategoryFully Burdened Labor Rate (FBLR)CLIN 0002CLIN 1002CLIN 2002
Base Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)
Major Sub Non-Small BusinessMajor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMajor Sub Non-Small BusinessMajor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMajor Sub Non-Small BusinessMajor Subs Small Business% ofFeeLoaded Labor Rate thru Fee
TotalFBLR w/ Esc.% of G(G)+(H)TotalTotalFBLR% of O(O)+(P)TotalTotalFBLR% of W(W)+(X)Total
Esc. RateTotalLabor HrInsert Fee Rate ↓LaborTotalLabor HrEsc. RateInsert Fee Rate ↓LaborTotalLabor HrEsc. RateInsert Fee Rate ↓Labor
0.00%DPPHs *DPPHs *DPPHsMix0.00%DollarsDPPHs *DPPHs *DPPHsMix0.00%0.00%DollarsDPPHs *DPPHs *DPPHsMix0.00%0.00%Dollars
1.0 Program Manager$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
2.0 Network Admin/Analyst Lead$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
3.0 Network Admin/Analyst I$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
4.0 Network Admin/Analyst II$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
5.0 System Admin/Analyst Lead$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
6.0 System Admin/Analyst I$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
7.0 System Admin/Analyst II$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
8.0 Security Lead$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
9.0 Security Clerk$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
10.0 Security Asst$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
11.0 Program Analyst$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
12.0 Property Admin$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
13.0 Admin Asst$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
14.0 Media Librarian/Document Control Specialist$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
15.0 SME$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
16.0 Military Operations Specialist$0.000.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 00.00.0%$0.00$0.00$0.00$ - 0
Total Estimated Hours0.00.00.00.0%0.00.00.00.00.0%0.00.00.00.00.0%0.0
Note: This template is provided for 1) additional hours above and beyond the amounts to operate and maintain the SimCtr during normal hours of operation under the Base Labor CLIN and Base Labor Option CLINS. If there are other indirects that need to be added or if your system is different from that provided above, the template can be revised as necessary. All electronic files shall include all links and formulas used to calculate rates and they shall be maintained throughout all revisions. All files (electronic) shall be cross-referenced to supporting files. The prime will be responsible for ensuring overall hours map to the prescribed totals per Section J - Attachment 02A.
*The offeror shall show the number of Direct Person Production Hours (DPPH) in a proposed year. [Show proposed DPPH calcuations: e.g. total hours, less hours for vacation, less hours for holidays, less hours for sick leave = Total DPPH. Describe the basis used for man-years (e.g., 1980, 2040, 2080, etc). If proposing uncompensated overtime, adjust DPPHs to cover the extra hours proposed to be worked.

Material CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
SUBCONTRACTOR:___________________________________
Total Material Costs by CLIN
Performance PeriodRFP Specified Material CostsG&ATotal Material
CLIN 0003$8,162,144$0$8,162,144
CLIN 1003$1,443,242$0$1,443,242
CLIN 2003$1,472,107$0$1,472,107
Total Material$11,077,493
Note: This is a guide template. If there are other indirects that need to be added or if your system is different from that provided above, the template can be revised as necessary. All electronic files shall include all links and formulas used to calculate rates and they shall be maintained throughout all revisions. All files (electronic) shall be cross-referenced to supporting files. As the prime offeror's total proposed Materiasl (when combined with any minor or major subcontractors) shall reflect the above annual NTE amounts, subcontractors should coordinate with primes to ensure the overall proposed Materials do not exceed the above totals. No fee is allowed on Material.

ODC CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
SUBCONTRACTOR:___________________________________
Total ODC Costs by CLIN
Performance PeriodRFP Specified ODC CostsG&ATotal ODC
CLIN 0004$2,040,536$0$2,040,536
CLIN 1004$360,810$0$360,810
CLIN 2004$368,026$0$2,401,346
Total ODC$4,802,692
Note: This is a guide template. If there are other indirects that need to be added or if your system is different from that provided above, the template can be revised as necessary. All electronic files shall include all links and formulas used to calculate rates and they shall be maintained throughout all revisions. All files (electronic) shall be cross-referenced to supporting files. As the prime offeror's total proposed ODCs (when combined with any minor or major subcontractors) shall reflect the above annual NTE amounts, subcontractors should coordinate with primes to ensure the overall proposed ODCs do not exceed the above totals. No fee is allowed on ODC.

TravelDBA CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
SUBCONTRACTOR:___________________________________
Total Travel/DBA Insurance Costs by CLIN
Performance PeriodRFP Specified Travel CostG&ATotal Travel
CLIN 0005$128,536$0$128,536
CLIN 1005$44,570$0$44,570
CLIN 2005$45,462$0$173,106
Total Travel/DBA$346,212
Note: This is a guide template. If there are other indirects that need to be added or if your system is different from that provided above, the template can be revised as necessary. All electronic files shall include all links and formulas used to calculate rates and they shall be maintained throughout all revisions. All files (electronic) shall be cross-referenced to supporting files. As the prime offeror's total proposed Travel/DBA insurance costs (when combined with any minor or major subcontractors) shall reflect the above annual NTE amounts, subcontractors should coordinate with primes to ensure the overall proposed Travel does not exceed the above totals. No fee is allowed on travel.

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