Attachment_3_-_Price_Proposal_Workbook.xlsx
XLSX spreadsheet 34 KB Posted
- Attached to
- Special Tactics Air Traffic Control (STATC) Training Support Federal contract opportunity
- Solicitation number
- FA0021-16-R-0040
About this file
Attachment 3 - Price Proposal Workbook
View the file
Other files for this federal contract opportunity
Show all 30
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
TEP Sheet
| SPECIAL TACTICS AIR TRAFFIC CONTROL (STATC) TRAINING |
| AFICA/765 SCONF |
| TOTAL EVALUATED PRICE WORKSHEET |
Note(s) and Instruction(s): This table is for evaluation purposes only and will be used to rank offers IAW FAR 52.212-2, Evaluation - Commercial Items, and its addendum detailed in SF 1449. Information presented here are automatically filled based on information provided in the "Summary" sheet/tab. Offeror is to complete the fill-in fields on this sheet.
This table is color coded as defined below
- Fill-in Field(s) - Pre-determined value.
- Auto-calculated Field(s) - Total Evaluated Price (Auto-calculated Field)
| # | PWS LABOR CATEGORY | Start Date | BASE YEAR (YEAR 1) | OPTION 1 (YEAR 2) | OPTION 2 (YEAR 3) | FAR 52.215-8 Option | % Subcontracted | ||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | Q | ||||
| HRS or QTY | # of CMEs | FBLR or Rate | Proposed Price | # of CMEs | FBLR or Rate | Proposed Price | # of CMEs | FBLR or Rate | Proposed Price | # of CMEs | FBLR or Rate | Proposed Price | TOTAL | ||||
| A*B*C | AX*E*F | AX*H*I | (AX/2)*K*L | Sum (D,G,J,M,P) | |||||||||||||
| X | FULL YEAR HOURS | 1,880 | |||||||||||||||
| 1 | ATC Instructor at 21 STS, JB-Pope-Bragg, NC | 1-Dec-16 | 1,567 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | $ - 0 | |
| 2 | ATC Instructor at 22 STS, McChord AFB, WA | 1-Dec-16 | 1,567 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | $ - 0 | |
| 3 | ATC Instructor at 23 STS, Hurlburt Field, FL | 1-Dec-16 | 1,567 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | 1 | $0.00 | $ - 0 | $ - 0 | |
| 4 | ATC Instructor at STTS, Hurlburt Field, FL | 1-Dec-16 | 1,567 | 2 | $0.00 | $ - 0 | 2 | $0.00 | $ - 0 | 2 | $0.00 | $ - 0 | 2 | $0.00 | $ - 0 | $ - 0 | |
| 45 | X001 Labor Cost Firm Fixed Price | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | $ - 0 | 0.00% | ||||||
| 46 | X002 Travel Cost Firm Fixe Price | 1-Jan-16 | $40,000 | 0.00% | $ 40,000.00 | 0.00% | $ 40,000.00 | 0.00% | $ 40,000.00 | 0% | $ 20,000.00 | $ 140,000.00 | |||||
| 55 | TOTAL EVALUATED PRICE | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | $ 20,000.00 | $ 140,000.00 |
FA0021-16-R-0040
Attachment 3 7 September 2016
&P of &N
SUMMARY
| Fully Burdened Labor Rates and Premium Rates |
| Special Tactics Air Traffic Control (STATC) Training |
| AFICA / 765 SCONF |
| Negotiated FBLR and Premium Pay |
| SUMMARY |
**The summary page(s) will be incorporated into the resulting contract**
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
- Auto Calculated Field(s)
| # | Labor Category | Year 1 | Year 2 | Year 3 |
| 1 | ATC Instructor at Hurlburt Field, FL | $ - 0 | $ - 0 | $ - 0 |
| 2 | ATC Instructor at JB-Pope Bragg, NC | $ - 0 | $ - 0 | $ - 0 |
| 3 | ATC Instructor at McChord AFB, WA | $ - 0 | $ - 0 | $ - 0 |
| 5 | CLIN 0002, 1002, 2002 Travel Processing Fee | 0.00% | 0.00% | 0.00% |
&P of &N
Year 1
| Fully Burdened Labor Rates and Premium Rates |
| Special Tactics Air Traffic Control (STATC) Training |
| AFICA / 765 SCONF |
| BASE YEAR (YEAR 1) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| BASE YEAR (YEAR 1) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| 1 | Identify Fringe, G&A, Profit Rates | ||||||||
| 2 | ATC Instructor at Hurlburt Field, FL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 3 | ATC Instructor at JB-Pope Bragg, NC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 4 | ATC Instructor at McChord AFB, WA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | Travel Processing Fee (NTE 3%) | 0.00% |
| Notes to Fully Burdened Labor Rates and Premium Rates for Base Year (Year 1) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
Year 2
| Fully Burdened Labor Rates and Premium Rates |
| Special Tactics Air Traffic Control (STATC) Training |
| AFICA / 765 SCONF |
| OPTION 1 (YEAR 2) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| OPTION 1 (YEAR 2) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| 1 | Identify Fringe, G&A, Profit Rates | ||||||||
| 2 | ATC Instructor at Hurlburt Field, FL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 3 | ATC Instructor at JB-Pope Bragg, NC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4 | ATC Instructor at McChord AFB, WA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | Travel Processing Fee (NTE 3%) | 0.0% | 0.00% |
| Notes to Fully Burdened Labor Rates and Premium Rates for Option 1 (Year 1) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
Year 3
| Fully Burdened Labor Rates and Premium Rates |
| Special Tactics Air Traffic Control (STATC) Training |
| AFICA / 765 SCONF |
| OPTION 2 (YEAR 3) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| OPTION 2 (YEAR 3) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| 1 | Identify Fringe, G&A, Profit Rates | ||||||||
| 2 | ATC Instructor at Hurlburt Field, FL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 3 | ATC Instructor at JB-Pope Bragg, NC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4 | ATC Instructor at McChord AFB, WA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | Travel Processing Fee (NTE 3%) | 0.0% | 0.00% |
| Notes to Fully Burdened Labor Rates and Premium Rates for Option 2 (Year 3) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
File details come from the government source that posted it. Updated .