Atch 9 - Price Proposal Workbook.xlsx

XLSX spreadsheet 60 KB Posted

Attached to
AFSOC - MC-12 - Tactical System Operators (TSO) Training Support Services Federal contract opportunity
Solicitation number
FA002122R0008
Issued by
Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

This document provides a price proposal workbook template and instructions for a firm-fixed-price contract to provide MC-12 Tactical Systems Operators training support services to the Air Force Special Operations Command. Offerors are required to complete the workbook with fully burdened labor rates and other direct costs for the base year and four option years. Labor categories include pilot, sensor operator, opposing force/mission rehearsal trainer, registrar, and scheduler. The contractor must provide all required personnel, supervision, transportation, and other items and services to successfully perform the requirements outlined in the performance work statement. The place of performance is Will Rogers National Guard Base in Oklahoma City, Oklahoma. The solicitation number for this opportunity is FA002122R0008 and the contracting agency is the Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency.

View the file

Other files for this federal contract opportunity

Show all 18

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

Instructions

PRICE PROPOSAL WORKBOOK INSTRUCTIONS
MC-12 TACTICAL SYSTEMS OPERATORS (TSO) TRAINING SUPPORT SERVICES
AFICC / 765 ESF
Missing or incomplete cost/pricing data may result in proposal rejection.
YEAR 1 THROUGH YEAR 5 PRICE TAB INSTRUCTIONS:
1. Offerors shall complete and submit one (1) Price Proposal Workbook. The calculated firm-fixed prices shall include all costs to provide all required personnel, supervision, transportation, and all other items and services necessary to successfully perform the requirements of the Performance Work Statement.
2. The Offeror shall identify the following under the direct labor fields; base rate, fringe, OH, G&A, profit/fee, person hours, quantity, and notes (as applicable) for each labor category in the fields identified as fillable and highlighted in pink. The worksheet will automatically calculate the proposed firm-fixed price for direct labor.
3. The Offeror shall identify any other direct costs associated with performance of the requirement. These costs will automatically be included in your total firm-fixed price for each year.
4. All unit and extended prices provided shall be rounded to no more than two positions after the decimal point.
TOTAL EVALUATED PRICE (TEP) Summary
1. Offerors are not required to make edits to this tab unless necessary to match the offerors pricing strategy and annotate it accordingly.

TEP Summary

TABLE COLOR CODECLIN DESCRIPTIONCLIN TYPEBASE YEAROPTION YR 1OPTION YR 2OPTION YR 3OPTION YR 4OPTION FAR 52.217-8 (6 MOS)
Auto Calculated Field(s)
Fill-in Field(s)X001 - MC-12 TSO TRAINING SUPPORT SVSFFP$0.00$0.00$0.00$0.00$0.00$0.00
X001 - MC-12 TSO TRAINING SUPPORT SVS (MONTHLY RATE)FFP$0.00$0.00$0.00$0.00$0.00$0.00

TOTAL EVALUATED PRICE (TEP) (INCLUDES OPTION FAR 52.217-8) $0.00

Year 1

BASE YEAR (YEAR 1) - FIRM-FIXED PRICEDIRECT LABOR
Direct Labor$ - 0NOTE: 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/Cost Analysis.
Other Direct Costs$ - 0
Total FFP (CLIN 0001)$ - 0RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT
Monthly FFP$ - 0BASE YEAR (YEAR 1)
ABCDEFGHIJK
#Labor CategoryBase RateFringeOHG & AProfit or FeeFCCOMFBLRQuantityPerson HoursProposed PriceNOTES
TABLE COLOR CODEA * BSum(A:B)*CSum(A:C)*DSum(A:D)*ESum(A:E)*FSum(A:F)(# of CME)
Auto Calculated Field(s)Identify Fringe, OH, G&A, Profit Rates
Fill-in Field(s)1PILOT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0A
2SENSOR OPERATOR/CSO$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0B
3OPFOR/MRT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4REGISTRAR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5SCHEDULER$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PROPOSED TOTAL$ - 0
Notes to Fully Burdened Labor Rates
AEnter 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

E

OTHER DIRECT COSTS
BASE YEAR (YEAR 1)
ABCD
#Other Direct CostsUnit CostUnitsProposed CostNOTES
A*B
1$ - 0A
2$ - 0B
3$ - 0
4$ - 0
5$ - 0
6$ - 0
7$ - 0
8$ - 0
9$ - 0
10$ - 0
11$ - 0
12$ - 0
13$ - 0
14$ - 0
15$ - 0
16$ - 0
17$ - 0
18$ - 0
19$ - 0
20$ - 0
PROPOSED TOTAL$ - 0
Notes to Other Direct Costs
AEnter 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

E

FA0021-16-R-0040

Attachment 3 7 September 2016

&P of &N

Year 2

OPTION 1 (YEAR 2) - FIRM-FIXED PRICEDIRECT LABOR
Direct Labor$ - 0NOTE: 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/Cost Analysis.
Other Direct Costs$ - 0
Total FFP (CLIN 1001)$ - 0RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT
Monthly FFP$ - 0OPTION 1 (YEAR 2)
ABCDEFGHIJK
#Labor CategoryBase RateFringeOHG & AProfit or FeeFCCOMFBLRQuantityPerson HoursProposed PriceNOTES
TABLE COLOR CODEA * BSum(A:B)*CSum(A:C)*DSum(A:D)*ESum(A:E)*FSum(A:F)(# of CME)
Auto Calculated Field(s)Identify Fringe, OH, G&A, Profit Rates
Fill-in Field(s)1PILOT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0A
2SENSOR OPERATOR/CSO$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0B
3OPFOR/MRT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4REGISTRAR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5SCHEDULER$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PROPOSED TOTAL$ - 0
Notes to Fully Burdened Labor Rates
AEnter 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

E

OTHER DIRECT COSTS
BASE YEAR (YEAR 1)
ABCD
#Other Direct CostsUnit CostUnitsProposed CostNOTES
A*B
1$ - 0A
2$ - 0B
3$ - 0
4$ - 0
5$ - 0
6$ - 0
7$ - 0
8$ - 0
9$ - 0
10$ - 0
11$ - 0
12$ - 0
13$ - 0
14$ - 0
15$ - 0
16$ - 0
17$ - 0
18$ - 0
19$ - 0
20$ - 0
PROPOSED TOTAL$ - 0
Notes to Other Direct Costs
AEnter 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

E

&P of &N

Year 3

OPTION 2 (YEAR 3) - FIRM-FIXED PRICEDIRECT LABOR
Direct Labor$ - 0NOTE: 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/Cost Analysis.
Other Direct Costs$ - 0
Total FFP (CLIN 2001)$ - 0RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT
Monthly FFP$ - 0OPTION 2 (YEAR 3)
ABCDEFGHIJK
#Labor CategoryBase RateFringeOHG & AProfit or FeeFCCOMFBLRQuantityPerson HoursProposed PriceNOTES
TABLE COLOR CODEA * BSum(A:B)*CSum(A:C)*DSum(A:D)*ESum(A:E)*FSum(A:F)(# of CME)
Auto Calculated Field(s)Identify Fringe, OH, G&A, Profit Rates
Fill-in Field(s)1PILOT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0A
2SENSOR OPERATOR/CSO$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0B
3OPFOR/MRT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4REGISTRAR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5SCHEDULER$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PROPOSED TOTAL$ - 0
Notes to Fully Burdened Labor Rates
AEnter 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

E

OTHER DIRECT COSTS
BASE YEAR (YEAR 1)
ABCD
#Other Direct CostsUnit CostUnitsProposed CostNOTES
A*B
1$ - 0A
2$ - 0B
3$ - 0
4$ - 0
5$ - 0
6$ - 0
7$ - 0
8$ - 0
9$ - 0
10$ - 0
11$ - 0
12$ - 0
13$ - 0
14$ - 0
15$ - 0
16$ - 0
17$ - 0
18$ - 0
19$ - 0
20$ - 0
PROPOSED TOTAL$ - 0
Notes to Other Direct Costs
AEnter 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

E

&P of &N

Year 4

OPTION 3 (YEAR 4) - FIRM-FIXED PRICEDIRECT LABOR
Direct Labor$ - 0NOTE: 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/Cost Analysis.
Other Direct Costs$ - 0
Total FFP (CLIN 3001)$ - 0RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT
Monthly FFP$ - 0OPTION 3 (YEAR 4)
ABCDEFGHIJK
#Labor CategoryBase RateFringeOHG & AProfit or FeeFCCOMFBLRQuantityPerson HoursProposed PriceNOTES
TABLE COLOR CODEA * BSum(A:B)*CSum(A:C)*DSum(A:D)*ESum(A:E)*FSum(A:F)(# of CME)
Auto Calculated Field(s)Identify Fringe, OH, G&A, Profit Rates
Fill-in Field(s)1PILOT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0A
2SENSOR OPERATOR/CSO$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0B
3OPFOR/MRT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4REGISTRAR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5SCHEDULER$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PROPOSED TOTAL$ - 0
Notes to Fully Burdened Labor Rates
AEnter 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

E

OTHER DIRECT COSTS
BASE YEAR (YEAR 1)
ABCD
#Other Direct CostsUnit CostUnitsProposed CostNOTES
A*B
1$ - 0A
2$ - 0B
3$ - 0
4$ - 0
5$ - 0
6$ - 0
7$ - 0
8$ - 0
9$ - 0
10$ - 0
11$ - 0
12$ - 0
13$ - 0
14$ - 0
15$ - 0
16$ - 0
17$ - 0
18$ - 0
19$ - 0
20$ - 0
PROPOSED TOTAL$ - 0
Notes to Other Direct Costs
AEnter 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

E

&P of &N

Year 5

OPTION 4 (YEAR 5) - FIRM-FIXED PRICEDIRECT LABOR
Direct Labor$ - 0NOTE: 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/Cost Analysis.
Other Direct Costs$ - 0
Total FFP (CLIN 4001)$ - 0RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT
Monthly FFP$ - 0OPTION 4 (YEAR 5)
ABCDEFGHIJK
#Labor CategoryBase RateFringeOHG & AProfit or FeeFCCOMFBLRQuantityPerson HoursProposed PriceNOTES
TABLE COLOR CODEA * BSum(A:B)*CSum(A:C)*DSum(A:D)*ESum(A:E)*FSum(A:F)(# of CME)
Auto Calculated Field(s)Identify Fringe, OH, G&A, Profit Rates
Fill-in Field(s)1PILOT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0A
2SENSOR OPERATOR/CSO$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0B
3OPFOR/MRT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4REGISTRAR$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5SCHEDULER$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
PROPOSED TOTAL$ - 0
Notes to Fully Burdened Labor Rates
AEnter 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

E

OTHER DIRECT COSTS
BASE YEAR (YEAR 1)
ABCD
#Other Direct CostsUnit CostUnitsProposed CostNOTES
A*B
1$ - 0A
2$ - 0B
3$ - 0
4$ - 0
5$ - 0
6$ - 0
7$ - 0
8$ - 0
9$ - 0
10$ - 0
11$ - 0
12$ - 0
13$ - 0
14$ - 0
15$ - 0
16$ - 0
17$ - 0
18$ - 0
19$ - 0
20$ - 0
PROPOSED TOTAL$ - 0
Notes to Other Direct Costs
AEnter 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

E

&P of &N

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