Attch 02A_Prime_Cost_Price_Matrix_01 Apr 2021.xls

XLS spreadsheet 239 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 appears to be a template for a cost proposal in response to solicitation number W9113m for Simulation Center support services. The solicitation seeks proposals to provide facility resources, system administration, security controls, hardware and software procurement and configuration, and shipping support for multiple laboratories housed in a Simulation Center. The laboratories support exercises and wargames for various CONUS and OCONUS locations. The template includes tables for fully burdened labor rates by labor category for base and surge support, material costs, other direct costs including travel, and composite labor rates. Offerors are instructed to populate the template with their proposed costs and to include all formulas and links. The period of performance is a three-year base period with two one-year option periods.

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 02B_rev1_Sub_Cost_Pricing_Matrix_28 May 2021.xls XLS spreadsheet
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 Conformed Copy.pdf PDF
W9113M-21-R-0060 Amendment 2.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 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
RFP W9113M-21-R-0060.pdf PDF
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
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

Prime Instructions

Simulation Center (SimCtr)

&CPage &P of &N&RAttachment_02A_Prime_Cost-Pricing_Matrix_30_Sept_2014.xls &A &C&"Arial,Bold"&12Distribution A, Approved for Public Release: Distribution Unlimited.

This workbook shall be used per Section J - Attachment 02A and 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 by CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
Base Year (3-Years)Total CLIN DollarsOption Year 1 (1-Year)Total CLIN DollarsOption Year 2 (1-Year)Total CLIN DollarsTotal Value
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.88CLIN 2003 Material$ 1,472,107.74$11,077,495
CLIN 0004 ODC$ 2,040,536.00CLIN 1004 ODC$ 360,810.72CLIN 2004 ODC$ 368,026.93$2,769,374
CLIN 0005 Travel$ 128,536.80CLIN 1005 Travel$ 44,570.74CLIN 2005 Travel$ 45,462.15$218,570
Total by CLIN by Ordering Period$ 10,331,216.80$ 1,848,624.34$ 1,885,596.82$14,065,438
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.

&CPage &P of &N &C&F &A

Total Rollup (Base & Surge)

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
Total Rollup of Hours & Labor Rates (Base & Surge)Base Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)Overall Total DPPHs
Labor CategoryTotal DPPHsComposite FBLRsTotal Labor DollarsTotal DPPHsComposite FBLRsTotal Labor DollarsTotal DPPHsComposite FBLRsTotal Labor Dollars
(labor rates are composite of prime & subcontractor FBLRs)
1.0 Project Manager0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
2.0 Network Admin/Analyst Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
3.0 Network Admin/Analyst I0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
4.0 Network Admin/Analyst II0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
5.0 System Admin/Analyst Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
6.0 System Admin/Analyst I0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
7.0 System Admin/Analyst II0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
8.0 Security Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
9.0 Security Clerk0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
10.0 Security Asst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
11.0 Program Analyst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
12.0 Property Admin0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
13.0 Admin Asst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
14.0 Media Librarian/Document Control Specialist0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
15.0 SME0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
16.0 Military Operations Specialist0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
Total Prime Hours & Labor Dollars0$00$00$00
Overall Total Labor Dollars - Base & Surge Labor CLINs
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 (hardcopies and electronic) shall be cross-referenced to supporting files.

&CPage &P of &N &C&F &A

Rollup of Hrs & Rates - Base

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
Rollup of Hours & Labor Rates - Base Labor CLINsCLIN 0001 - Base Year (3-Years)CLIN 1001 - Option Year 1 (1-Year)CLIN 2001 - Option Year 2 (1-Year)Overall Total DPPHs
Labor CategoryTotal DPPHsComposite FBLRsTotal Labor DollarsTotal DPPHsComposite FBLRsTotal Labor DollarsTotal DPPHsComposite FBLRsTotal Labor Dollars
(labor rates are composite of prime & subcontractor FBLRs)
1.0 Project Manager0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
2.0 Network Admin/Analyst Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
3.0 Network Admin/Analyst I0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
4.0 Network Admin/Analyst II0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
5.0 System Admin/Analyst Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
6.0 System Admin/Analyst I0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
7.0 System Admin/Analyst II0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
8.0 Security Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
9.0 Security Clerk0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
10.0 Security Asst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
11.0 Program Analyst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
12.0 Property Admin0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
13.0 Admin Asst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
14.0 Media Librarian/Document Control Specialist0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
15.0 SME0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
16.0 Military Operations Specialist0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
Total Hours & Labor Dollars0000000
Overall Total Labor Dollars - Base Labor CLINs
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 (hardcopies and electronic) shall be cross-referenced to supporting files.

&CPage &P of &N &C&F &A

Rollup of Hrs & Rates - Surge

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
Rollup of Hours & Labor Rates - Surge Labor CLINsCLIN 0002 - Base Year (3-Years)CLIN 1002 - Option Year 1 (1-Year)CLIN 2002 - Option Year 2 (1-Year)Overall Total DPPHs
Labor CategoryTotal DPPHsComposite FBLRsTotal Labor DollarsTotal DPPHsComposite FBLRsTotal Labor DollarsTotal DPPHsComposite FBLRsTotal Labor Dollars
(labor rates are composite of prime & subcontractor FBLRs)
1.0 Project Manager0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
2.0 Network Admin/Analyst Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
3.0 Network Admin/Analyst I0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
4.0 Network Admin/Analyst II0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
5.0 System Admin/Analyst Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
6.0 System Admin/Analyst I0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
7.0 System Admin/Analyst II0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
8.0 Security Lead0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
9.0 Security Clerk0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
10.0 Security Asst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
11.0 Program Analyst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
12.0 Property Admin0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
13.0 Admin Asst0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
14.0 Media Librarian/Document Control Specialist0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
15.0 SME0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
16.0 Military Operations Specialist0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00
Total Hours & Labor Dollars0$00$00$00
Overall Total Labor Dollars - Surge Labor CLINs
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.

&CPage &P of &N &C&F &A

Base Labor CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
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 C% of C(C)+(D)+(E)% of F(F)+(G)Minor Subs Non-Small BusinessMinor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMinor Subs Non-Small BusinessMinor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMinor Subs Non-Small BusinessMinor Subs Small Business% ofFeeLoaded Labor Rate thru FeeRFP Specified Total DPPHsVerification that proposed Base Labor Total Annual DDPH Equals the Specified Total Level of Effort to operate and maintain the SimCtr
TotalFBLR% of NTotalTotalFBLR% of W(W)+(X)TotalTotalFBLR% of AFTotal
Insert Fringe Rate ↓Insert OH Rate ↓Insert G&A Rate ↓PrimeTotalLabor HrEsc. Rate**Insert Fee Rate ↓(N)+(O)LaborPrimeTotalLabor HrEsc. Rate**Insert Fee Rate ↓LaborPrimeTotalLabor HrEsc. Rate**Insert Fee Rate ↓(AF)+(AG)LaborBaseOption 1Option 2Total
FTE*Insert Rate ↓0.00%0.00%0.00%DPPHs *DPPHs *DPPHs *DPPHsMix0.00%0.00%DollarsDPPHs *DPPHs *DPPHs *DPPHsMix0.00%0.00%DollarsDPPHs *DPPHs *DPPHs *DPPHsMix0.00%0.00%Dollars213,200.0$0$0$0$0
1.0 Project Manager0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
2.0 Network Admin/Analyst Lead0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
3.0 Network Admin/Analyst I0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
4.0 Network Admin/Analyst II0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
5.0 System Admin/Analyst Lead0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
6.0 System Admin/Analyst I0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
7.0 System Admin/Analyst II0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
8.0 Security Lead0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
9.0 Security Clerk0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
10.0 Security Asst0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
11.0 Program Analyst0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
12.0 Property Admin0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
13.0 Admin Asst0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
14.0 Media Librarian/Document Control Specialist0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
15.0 SME0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
16.0 Military Operations Specialist0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 00.00.0%$ - 0$ - 0$ - 0$ - 0
Total Estimated Hours00.00.00.00.00.0%0.00.00.00.00.00.0%0.00.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. While the labor mix may deviate from the historical/estimated labor resource mix provided in the table found in Section L-2 (2) Volume II – Technical, (a) TAB 2: Technical Approach, (ii) Section 2, Labor Resource Mix; the total annual hours proposed must equal the total Level of Effort in said table. In other words, the Contractor must propose exactly 338,000 DPPHs, using a mix from whichever of the above GLCs that the contractor elects to propose. The offeror must ensure that its allocation is both consistent with the proposed technical solutions and sufficient for accomplishing the overall PWS requirements. If the offeror proposes 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 solicitation), 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 calculations: 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. Describe the basis used for man-years (e.g., 1980, 2040, 2080, etc) and enter that amount below to be used to calculate Full Time Equivalent (FTEs) in Column B above.
Total hours available to work a year-------------------------------------->2080 is generically a common number used as this equal 52 weeks x 40 hours a week.
Less total hours for vacation, holiday, sick------------------------------>Detail the break out for how many hours are for vacation, holiday, sick.
*Calculate the basis for one full man-year------------------------------>0
**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.

&CPage &P of &N &C&F &A

Surge Labor CLINs

PRIME CONTRACTOR:___________________________________
Labor CategoryFully Burdened Labor Rate (FBLR)CLIN 0002CLIN 1002CLIN 2002
Base Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)
Minor Subs Non-Small BusinessMinor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMinor Subs Non-Small BusinessMinor Subs Small Business% ofFeeLoaded Labor Rate thru FeeMinor Subs Non-Small BusinessMinor Subs Small Business% ofFeeLoaded Labor Rate thru Fee
TotalFBLR w/ Esc.% of HTotalTotalFBLR% of QTotalTotalFBLR% of ZTotalRFP Specified Total DPPHsVerification that proposed Surge Labor mix and total annual Surge DDPH equals the specified surge values
Esc. RatePrimeTotalLabor HrInsert Fee Rate ↓(H)+(I)LaborPrimeTotalLabor HrEsc. RateInsert Fee Rate ↓(Q)+(R)LaborPrimeTotalLabor HrEsc. RateInsert Fee Rate ↓(Z)+(AA)LaborBaseOption 1Option 2Total
3.00%DPPHs *DPPHs *DPPHs *DPPHsMix4.80%DollarsDPPHs *DPPHs *DPPHs *DPPHsMix3.00%4.80%DollarsDPPHs *DPPHs *DPPHs *DPPHsMix3.00%4.80%Dollars
1.0 Project Manager$50.001,200.056.0800.02,056.01.6%$50.00$2.40$52.40$ 107,734.401,200.056.0800.02,056.01.6%$51.50$2.47$53.97$ 110,966.431,200.056.0800.02,056.01.6%$53.05$2.55$55.59$ 114,295.421.0 Project Manager0.02,056.02,056.02,056.06,168.0
2.0 Network Admin/Analyst Lead$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 02.0 Network Admin/Analyst Lead10,400.00.00.00.00.0
3.0 Network Admin/Analyst I$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 03.0 Network Admin/Analyst I20,800.00.00.00.00.0
4.0 Network Admin/Analyst II$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 04.0 Network Admin/Analyst II15,600.00.00.00.00.0
5.0 System Admin/Analyst Lead$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 05.0 System Admin/Analyst Lead10,400.00.00.00.00.0
6.0 System Admin/Analyst I$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 06.0 System Admin/Analyst I20,800.00.00.00.00.0
7.0 System Admin/Analyst II$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 07.0 System Admin/Analyst II20,800.00.00.00.00.0
8.0 Security Lead$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 08.0 Security Lead10,400.00.00.00.00.0
9.0 Security Clerk$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 09.0 Security Clerk0.00.00.00.00.0
10.0 Security Asst$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 010.0 Security Asst0.00.00.00.00.0
11.0 Program Analyst$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 011.0 Program Analyst5,200.00.00.00.00.0
12.0 Property Admin$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 012.0 Property Admin0.00.00.00.00.0
13.0 Admin Asst$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 013.0 Admin Asst0.00.00.00.00.0
14.0 Media Librarian/Document Control Specialist$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 014.0 Media Librarian/Document Control Specialist0.00.00.00.00.0
15.0 SME$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 015.0 SME0.00.00.00.00.0
16.0 Military Operations Specialist$0.000.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 00.00.00.0%$0.00$0.00$0.00$ - 016.0 Military Operations Specialist10,400.00.00.00.00.0
Total Estimated Hours1,200.056.0800.02,056.01.6%107,734.41,200.056.0800.02,056.01.6%110,966.41,200.056.0800.02,056.01.6%114,295.4Total Estimated Hours124,800.02,056.02,056.02,056.06,168.0
Note: This template is provided in the event additional hours above and beyond the amounts project by the contractor are needed, the Government may fund Surge Labor CLINs. Labor costs for these CLINs are not for normal operation of the SimCtr. 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.
*The offeror shall show the number of Direct Person Production Hours (DPPH) in a proposed year. [Show proposed DPPH calculations: 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. While you may not deviate from the above GLC mix, the total hours by GLC may be spread among the major/minor subcontractors.
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, 2) The proposed allocation of labor hours among labor GLCs for the surge support options (CLINs 0002, 1002, and 2002) shall not deviate from the labor hour allocation and annual labour hour total Level of Effort specified in column AJ. The prime shall ensure total Surge DPPHs entered above (i.e., prime and minor subcontractors) combined with proposed major subcontractors Surge DPPHs equal the total prescribed DPPHs shown above. The offeror shall provide a cross walk for any 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 solicitation), the proposal shall identify the category titles and their qualification requirements (i.e., duties/responsibilities, education levels, clearance requirements and years of experience). These hours (using a 2080 hour man-year basis) were estimated using a using historical information, taking into shifts in requirements. Overall, approximately 40% (with variations among individual labor categories) of the base Labor and Option CLINs is the anticipated level of hours needed to accommodate the surge CLIN. 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.
*Reference Column AJ, RFP Specified Total DPPHs by labor category for Surge Labor CLINs distributed amoung prime & major/minor subs

&CPage &P of &N &C&F &A

Material CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
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,243$0$1,443,243
CLIN 2003$1,472,108$0$1,472,108
Total NTE Material$11,077,495
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. The offeror's proposed Material shall reflect the annual NTE amounts. No fee is allowed on Material.

&CPage &P of &N &C&F &A

ODC CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
Total ODC Costs by CLIN
Performance PeriodRFP Specified ODC CostsG&ATotal ODC
CLIN 0004$2,040,536$0$2,040,536
CLIN 1004$360,811$0$360,811
CLIN 2004$368,027$0$368,027
Total ODC$2,769,374
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. The offeror's proposed ODC shall reflect the annual NTE amounts. No fee is allowed on ODC.

&CPage &P of &N &C&F &A

TravelDBA CLINs

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:___________________________________
Total Travel/DBA Insurance Costs by CLINIGE Bryson CheckIGE Bryson Check DBA Ins.AS/AP Table 7 Bryson CheckIGE Bryson Check Travel/DBA Ins.
Performance PeriodRFP Specified Travel CostG&ATotal Travel
CLIN 0005$128,537$0$128,537$122,416$6,121$128,537
CLIN 1005$44,571$0$44,571$42,448$2,122$44,571
CLIN 2005$45,462$0$45,462$43,297$2,165$45,462
Total Travel$218,570$208,162$10,408$218,570$218,570
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. The offeror's proposed Travel/DBA Insurance shall reflect the annual NTE amounts. No fee is allowed on travel.

&CPage &P of &N &C&F &A

Prime Add-Ons to Sub Rates

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:_____________________________________________
Labor CategoryBase Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)
Sub XX'sPrime Add-On Rate 1Prime Add-On Rate 2Prime FeeTotal Sub Rate w/ Prime Add-OnsSub XX'sPrime Add-On Rate 1Prime Add-On Rate 2Prime FeeTotal Sub Rate w/ Prime Add-OnsSub XX'sPrime Add-On Rate 1Prime Add-On Rate 2Prime FeeTotal Sub Rate w/ Prime Add-Ons
SubtotalSubtotalSubtotal
FBLR0.00%0.00%0.00%FBLR0.00%0.00%0.00%FBLR0.00%0.00%0.00%
1.0 Project Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2.0 Network Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3.0 Network Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4.0 Network Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5.0 System Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6.0 System Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7.0 System Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8.0 Security Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9.0 Security Clerk$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10.0 Security Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11.0 Program Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12.0 Property Admin$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13.0 Admin Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14.0 Media Librarian/Document Control Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
15.0 SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16.0 Military Operations Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor CategoryBase Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)
Sub YY'sPrime Add-On Rate 1Prime Add-On Rate 2Prime FeeTotal Sub Rate w/ Prime Add-OnsSub YY'sPrime Add-On Rate 1Prime Add-On Rate 2Prime FeeTotal Sub Rate w/ Prime Add-OnsSub YY'sPrime Add-On Rate 1Prime Add-On Rate 2Prime FeeTotal Sub Rate w/ Prime Add-Ons
SubtotalSubtotalSubtotal
FBLR0.00%0.00%0.00%FBLR0.00%0.00%0.00%FBLR0.00%0.00%0.00%
1.0 Project Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2.0 Network Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3.0 Network Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4.0 Network Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5.0 System Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6.0 System Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7.0 System Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8.0 Security Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9.0 Security Clerk$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10.0 Security Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11.0 Program Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12.0 Property Admin$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13.0 Admin Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14.0 Media Librarian/Document Control Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
15.0 SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16.0 Military Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Note: This is a guide template. This worksheet is intended for use by the prime offerors in calculating pass-through costs. The formulas when applying prime add-ons should reflect the prime offerors indirect rate structure (i.e., if indirect structure includes a material handling rate, apply material handling rate and then apply G&A to the computed material handling burden; if no material handling rate, then just apply G&A). Computations MUST be presented in the form of formulas. Do NOT hard code rates into this section.

Sub XX and Sub YY are provide as placeholders for the potential of one or more team members. If a third team member is mathematically necessary, then contractor is responsible for adding an additional column and ensuring are formulas and links are accurate.

&CPage &P of &N &C&F &A

Composite FBLR

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104
FOR OFFICIAL USE ONLY
PRIME CONTRACTOR:_____________________________________________
Labor CategoryBase Year (3-Years)Option Year 1 (1-Year)Option Year 2 (1-Year)
Prime FBLRs *Sub XX's FBLRs including prime add-ons **Sub YY's FBLRs including prime add-ons **Composite FBLRs ***Prime FBLRs *Sub XX's FBLRs including prime add-ons **Sub YY's FBLRs including prime add-ons **Composite FBLRs ***Prime FBLRs *Sub XX's FBLRs including prime add-ons **Sub YY's FBLRs including prime add-ons **Composite FBLRs ***
1.0 Project Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2.0 Network Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3.0 Network Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4.0 Network Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5.0 System Admin/Analyst Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6.0 System Admin/Analyst I$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7.0 System Admin/Analyst II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8.0 Security Lead$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9.0 Security Clerk$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10.0 Security Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11.0 Program Analyst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12.0 Property Admin$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13.0 Admin Asst$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14.0 Media Librarian/Document Control Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
15.0 SME$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
16.0 Military Operations Specialist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Note: This is a guide template. Computations MUST be presented in the form of formulas. Do NOT hard code rates into this section.
* The Prime's FBLRs are populated from the 'Base Labor CLINs' tab.
** Subcontractor's FBLRs are populated from the 'Prime Add-Ons to Sub Rates' tab.
*** The composite Fully Burdened Labor Rate (FBLR) is based upon the respective FBLRs of the Prime Contractor and its subcontractor(s). The offeror's calculation for building its composite FBLR shall be provided above in this worksheet; methodology for buidling the composite FBLRs shall be provided in Section V.

&CPage &P of &N &C&F &A

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