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
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
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 Dollars | Option Year 1 (1-Year) | Total CLIN Dollars | Option Year 2 (1-Year) | Total CLIN Dollars | Total Value |
| CLIN 0001 Labor | $ - 0 | CLIN 1001 Labor | $ - 0 | CLIN 2001 Labor | $ - 0 | $0 |
| CLIN 0002 Surge Labor | $ - 0 | CLIN 1002 Surge | $ - 0 | CLIN 2002 Surge | $ - 0 | $0 |
| CLIN 0003 Material | $ 8,162,144.00 | CLIN 1003 Material | $ 1,443,242.88 | CLIN 2003 Material | $ 1,472,107.74 | $11,077,495 |
| CLIN 0004 ODC | $ 2,040,536.00 | CLIN 1004 ODC | $ 360,810.72 | CLIN 2004 ODC | $ 368,026.93 | $2,769,374 |
| CLIN 0005 Travel | $ 128,536.80 | CLIN 1005 Travel | $ 44,570.74 | CLIN 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 Category | Total DPPHs | Composite FBLRs | Total Labor Dollars | Total DPPHs | Composite FBLRs | Total Labor Dollars | Total DPPHs | Composite FBLRs | Total Labor Dollars | |
| (labor rates are composite of prime & subcontractor FBLRs) | ||||||||||
| 1.0 Project Manager | 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 |
| 3.0 Network Admin/Analyst I | 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 |
| 5.0 System Admin/Analyst Lead | 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 |
| 7.0 System Admin/Analyst II | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 8.0 Security Lead | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 9.0 Security Clerk | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 10.0 Security Asst | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 11.0 Program Analyst | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 12.0 Property Admin | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 13.0 Admin Asst | 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 |
| 15.0 SME | 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 |
| Total Prime Hours & Labor Dollars | 0 | $0 | 0 | $0 | 0 | $0 | 0 | |||
| 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 CLINs | CLIN 0001 - Base Year (3-Years) | CLIN 1001 - Option Year 1 (1-Year) | CLIN 2001 - Option Year 2 (1-Year) | Overall Total DPPHs | ||||||
| Labor Category | Total DPPHs | Composite FBLRs | Total Labor Dollars | Total DPPHs | Composite FBLRs | Total Labor Dollars | Total DPPHs | Composite FBLRs | Total Labor Dollars | |
| (labor rates are composite of prime & subcontractor FBLRs) | ||||||||||
| 1.0 Project Manager | 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 |
| 3.0 Network Admin/Analyst I | 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 |
| 5.0 System Admin/Analyst Lead | 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 |
| 7.0 System Admin/Analyst II | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 8.0 Security Lead | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 9.0 Security Clerk | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 10.0 Security Asst | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 11.0 Program Analyst | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 12.0 Property Admin | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 13.0 Admin Asst | 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 |
| 15.0 SME | 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 |
| Total Hours & Labor Dollars | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| 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 CLINs | CLIN 0002 - Base Year (3-Years) | CLIN 1002 - Option Year 1 (1-Year) | CLIN 2002 - Option Year 2 (1-Year) | Overall Total DPPHs | ||||||
| Labor Category | Total DPPHs | Composite FBLRs | Total Labor Dollars | Total DPPHs | Composite FBLRs | Total Labor Dollars | Total DPPHs | Composite FBLRs | Total Labor Dollars | |
| (labor rates are composite of prime & subcontractor FBLRs) | ||||||||||
| 1.0 Project Manager | 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 |
| 3.0 Network Admin/Analyst I | 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 |
| 5.0 System Admin/Analyst Lead | 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 |
| 7.0 System Admin/Analyst II | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 8.0 Security Lead | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 9.0 Security Clerk | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 10.0 Security Asst | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 11.0 Program Analyst | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 12.0 Property Admin | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 |
| 13.0 Admin Asst | 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 |
| 15.0 SME | 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 |
| Total Hours & Labor Dollars | 0 | $0 | 0 | $0 | 0 | $0 | 0 | |||
| 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 Category | Base Labor Rate | Fringe Benefits | Govt Site OH | Loaded Labor thru OH | G&A | Loaded Rate thru G&A | CLIN 0001 | CLIN 1001 | CLIN 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 Business | Minor Subs Small Business | % of | Fee | Loaded Labor Rate thru Fee | Minor Subs Non-Small Business | Minor Subs Small Business | % of | Fee | Loaded Labor Rate thru Fee | Minor Subs Non-Small Business | Minor Subs Small Business | % of | Fee | Loaded Labor Rate thru Fee | RFP Specified Total DPPHs | Verification that proposed Base Labor Total Annual DDPH Equals the Specified Total Level of Effort to operate and maintain the SimCtr | ||||||||||||||||||
| Total | FBLR | % of N | Total | Total | FBLR | % of W | (W)+(X) | Total | Total | FBLR | % of AF | Total | |||||||||||||||||||||||||||
| Insert Fringe Rate ↓ | Insert OH Rate ↓ | Insert G&A Rate ↓ | Prime | Total | Labor Hr | Esc. Rate** | Insert Fee Rate ↓ | (N)+(O) | Labor | Prime | Total | Labor Hr | Esc. Rate** | Insert Fee Rate ↓ | Labor | Prime | Total | Labor Hr | Esc. Rate** | Insert Fee Rate ↓ | (AF)+(AG) | Labor | Base | Option 1 | Option 2 | Total | |||||||||||||
| FTE* | Insert Rate ↓ | 0.00% | 0.00% | 0.00% | DPPHs * | DPPHs * | DPPHs * | DPPHs | Mix | 0.00% | 0.00% | Dollars | DPPHs * | DPPHs * | DPPHs * | DPPHs | Mix | 0.00% | 0.00% | Dollars | DPPHs * | DPPHs * | DPPHs * | DPPHs | Mix | 0.00% | 0.00% | Dollars | 213,200.0 | $0 | $0 | $0 | $0 | ||||||
| 1.0 Project Manager | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 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 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | 0.0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||
| Total Estimated Hours | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0% | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0% | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.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 Category | Fully Burdened Labor Rate (FBLR) | CLIN 0002 | CLIN 1002 | CLIN 2002 | ||||||||||||||||||||||||||||||
| Base Year (3-Years) | Option Year 1 (1-Year) | Option Year 2 (1-Year) | ||||||||||||||||||||||||||||||||
| Minor Subs Non-Small Business | Minor Subs Small Business | % of | Fee | Loaded Labor Rate thru Fee | Minor Subs Non-Small Business | Minor Subs Small Business | % of | Fee | Loaded Labor Rate thru Fee | Minor Subs Non-Small Business | Minor Subs Small Business | % of | Fee | Loaded Labor Rate thru Fee | ||||||||||||||||||||
| Total | FBLR w/ Esc. | % of H | Total | Total | FBLR | % of Q | Total | Total | FBLR | % of Z | Total | RFP Specified Total DPPHs | Verification that proposed Surge Labor mix and total annual Surge DDPH equals the specified surge values | |||||||||||||||||||||
| Esc. Rate | Prime | Total | Labor Hr | Insert Fee Rate ↓ | (H)+(I) | Labor | Prime | Total | Labor Hr | Esc. Rate | Insert Fee Rate ↓ | (Q)+(R) | Labor | Prime | Total | Labor Hr | Esc. Rate | Insert Fee Rate ↓ | (Z)+(AA) | Labor | Base | Option 1 | Option 2 | Total | ||||||||||
| 3.00% | DPPHs * | DPPHs * | DPPHs * | DPPHs | Mix | 4.80% | Dollars | DPPHs * | DPPHs * | DPPHs * | DPPHs | Mix | 3.00% | 4.80% | Dollars | DPPHs * | DPPHs * | DPPHs * | DPPHs | Mix | 3.00% | 4.80% | Dollars | |||||||||||
| 1.0 Project Manager | $50.00 | 1,200.0 | 56.0 | 800.0 | 2,056.0 | 1.6% | $50.00 | $2.40 | $52.40 | $ 107,734.40 | 1,200.0 | 56.0 | 800.0 | 2,056.0 | 1.6% | $51.50 | $2.47 | $53.97 | $ 110,966.43 | 1,200.0 | 56.0 | 800.0 | 2,056.0 | 1.6% | $53.05 | $2.55 | $55.59 | $ 114,295.42 | 1.0 Project Manager | 0.0 | 2,056.0 | 2,056.0 | 2,056.0 | 6,168.0 |
| 2.0 Network Admin/Analyst Lead | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 2.0 Network Admin/Analyst Lead | 10,400.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 3.0 Network Admin/Analyst I | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 3.0 Network Admin/Analyst I | 20,800.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 4.0 Network Admin/Analyst II | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 4.0 Network Admin/Analyst II | 15,600.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 5.0 System Admin/Analyst Lead | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 5.0 System Admin/Analyst Lead | 10,400.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 6.0 System Admin/Analyst I | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 6.0 System Admin/Analyst I | 20,800.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 7.0 System Admin/Analyst II | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 7.0 System Admin/Analyst II | 20,800.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 8.0 Security Lead | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 8.0 Security Lead | 10,400.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 9.0 Security Clerk | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 9.0 Security Clerk | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 10.0 Security Asst | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 10.0 Security Asst | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 11.0 Program Analyst | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 11.0 Program Analyst | 5,200.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 12.0 Property Admin | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 12.0 Property Admin | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 13.0 Admin Asst | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 13.0 Admin Asst | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 14.0 Media Librarian/Document Control Specialist | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 14.0 Media Librarian/Document Control Specialist | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 15.0 SME | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 15.0 SME | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| 16.0 Military Operations Specialist | $0.00 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 0.0 | 0.0 | 0.0% | $0.00 | $0.00 | $0.00 | $ - 0 | 16.0 Military Operations Specialist | 10,400.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||||
| Total Estimated Hours | 1,200.0 | 56.0 | 800.0 | 2,056.0 | 1.6% | 107,734.4 | 1,200.0 | 56.0 | 800.0 | 2,056.0 | 1.6% | 110,966.4 | 1,200.0 | 56.0 | 800.0 | 2,056.0 | 1.6% | 114,295.4 | Total Estimated Hours | 124,800.0 | 2,056.0 | 2,056.0 | 2,056.0 | 6,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 Period | RFP Specified Material Costs | G&A | Total 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 Period | RFP Specified ODC Costs | G&A | Total 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 CLIN | IGE Bryson Check | IGE Bryson Check DBA Ins. | AS/AP Table 7 Bryson Check | IGE Bryson Check Travel/DBA Ins. | ||||
| Performance Period | RFP Specified Travel Cost | G&A | Total 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 Category | Base Year (3-Years) | Option Year 1 (1-Year) | Option Year 2 (1-Year) | |||||||||||||||
| Sub XX's | Prime Add-On Rate 1 | Prime Add-On Rate 2 | Prime Fee | Total Sub Rate w/ Prime Add-Ons | Sub XX's | Prime Add-On Rate 1 | Prime Add-On Rate 2 | Prime Fee | Total Sub Rate w/ Prime Add-Ons | Sub XX's | Prime Add-On Rate 1 | Prime Add-On Rate 2 | Prime Fee | Total Sub Rate w/ Prime Add-Ons | ||||
| Subtotal | Subtotal | Subtotal | ||||||||||||||||
| FBLR | 0.00% | 0.00% | 0.00% | FBLR | 0.00% | 0.00% | 0.00% | FBLR | 0.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 Category | Base Year (3-Years) | Option Year 1 (1-Year) | Option Year 2 (1-Year) | |||||||||||||||
| Sub YY's | Prime Add-On Rate 1 | Prime Add-On Rate 2 | Prime Fee | Total Sub Rate w/ Prime Add-Ons | Sub YY's | Prime Add-On Rate 1 | Prime Add-On Rate 2 | Prime Fee | Total Sub Rate w/ Prime Add-Ons | Sub YY's | Prime Add-On Rate 1 | Prime Add-On Rate 2 | Prime Fee | Total Sub Rate w/ Prime Add-Ons | ||||
| Subtotal | Subtotal | Subtotal | ||||||||||||||||
| FBLR | 0.00% | 0.00% | 0.00% | FBLR | 0.00% | 0.00% | 0.00% | FBLR | 0.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 Category | Base 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 .