Attachment_3_-_Price_Proposal_Workbook_(rev_01).xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- Melrose Air Force Range Support Services Solicitation Federal contract opportunity
- Solicitation number
- FA4855-17-R-0008
About this file
This is the revised Attachment 3 - Price Proposal Workbook which clarifies and corrects the Government's price evaluation methods.
View the file
Other files for this federal contract opportunity
Show all 27
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
| Total Evaluated Price | |||||||||||||||||||
| MAFR OM&S Services | |||||||||||||||||||
| AFSOC/27 SOCONS | |||||||||||||||||||
| PWS/CBA LABOR CATEGORY | Start Date | BASE PERIOD (YEAR 1) | OPTION 1 (YEAR 2) | OPTION 2 (YEAR 3) | OPTION 3 (YEAR 4) | FAR 52.217-8 Option | % Subcontracted | ||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | 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 | # of CMEs | FBLR or Rate | Proposed Price | TOTAL | |||
| A*B*C | AX*E*F | AX*H*I | AX*K*L | (AX/2)*K*L | Sum (D,G,J,M,P) | ||||||||||||||
| X001 Air and Ground Operations Support | |||||||||||||||||||
| Site Manager | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Deputy Site Manager | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Quality Control Inspector | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Supply Technician | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Grounds Operation Foreman | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Range Control Officer (RCO) | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Heavy Equipment Operator (HEO) | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| General Maintenance Worker | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| X001 Labor Subtotal | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | ||||||||
| X001 Equipment Price (IAW Vehicle and Heavy/Agricultural Equipment Management Plan) | $ - 0 | $0.00 | |||||||||||||||||
| TOTAL CLIN X001 PRICE (FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X002 EW and Electronic Systems Support | |||||||||||||||||||
| Electronic Technician I | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Electronic Technician II | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Electronic Technician III | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| X002 Labor Subtotal | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | ||||||||
| TOTAL CLIN X002 PRICE (FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X003 Wildland Fire Management | |||||||||||||||||||
| Wildland Fire Manager Chief (CBA Lieutenant) | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Senior Wildland Fire Manager (CBA Senior Firefighter) | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| Wildland Fire Manager (CBA Firefighter) | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| X003 Labor Subtotal | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | ||||||||
| TOTAL CLIN X003 PRICE (FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X004 Scheduler Support | |||||||||||||||||||
| Scheduler | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| X004 Labor Subtotal | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | ||||||||
| TOTAL CLIN X004 PRICE (FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X005 Air and Ground Operations Support AOH | |||||||||||||||||||
| Range Control Officer (RCO) | 1-Dec-17 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | $ - 0 | ||
| Heavy Equipment Operator (HEO) | 1-Dec-17 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | $ - 0 | ||
| X005 Labor Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| TOTAL CLIN X005 PRICE (NTE FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X006 Electronic Warfare and Electronic Systems Support AOH | |||||||||||||||||||
| Electronic Technician I | 1-Dec-17 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | $ - 0 | ||
| Electronic Technician II | 1-Dec-17 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | 20 | $0.00 | $ - 0 | $ - 0 | ||
| Electronic Technician III | 1-Dec-17 | 10 | $0.00 | $ - 0 | 10 | $0.00 | $ - 0 | 10 | $0.00 | $ - 0 | 10 | $0.00 | $ - 0 | 10 | $0.00 | $ - 0 | $ - 0 | ||
| X006 Labor Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| TOTAL CLIN X006 PRICE(NTE FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X007 Wildland Fire Management AOH | |||||||||||||||||||
| Wildland Fire Manager Chief (CBA Lieutenant) | 1-Dec-17 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | 320 | $0.00 | $ - 0 | $ - 0 | ||
| Senior Wildland Fire Manager (CBA Senior Firefighter) | 1-Dec-17 | 640 | $0.00 | $ - 0 | 640 | $0.00 | $ - 0 | 640 | $0.00 | $ - 0 | 640 | $0.00 | $ - 0 | 640 | $0.00 | $ - 0 | $ - 0 | ||
| Wildland Fire Manager (CBA Firefighter) | 1-Dec-17 | 2,560 | $0.00 | $ - 0 | 2560 | $0.00 | $ - 0 | 2560 | $0.00 | $ - 0 | 2560 | $0.00 | $ - 0 | 2560 | $0.00 | $ - 0 | $ - 0 | ||
| X007 Labor Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| TOTAL CLIN X007 PRICE(NTE FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X008 Paramedic Services Support | |||||||||||||||||||
| Paramedic | 1-Dec-17 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | 0 | $0.00 | $ - 0 | $ - 0 | |||
| X008 Labor Subtotal | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | ||||||||
| TOTAL CLIN X008 PRICE (NTE FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X009 Paramedic Services Support AOH | |||||||||||||||||||
| Paramedic | 1-Dec-17 | 1,920 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | $ - 0 | ||
| X009 Labor Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| TOTAL CLIN X009 PRICE (NTE FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X010 SITFOR | |||||||||||||||||||
| SITFOR | 1-Dec-17 | 5,000 | $0.00 | $ - 0 | 5000 | $0.00 | $ - 0 | 5000 | $0.00 | $ - 0 | 5000 | $0.00 | $ - 0 | 5000 | $0.00 | $ - 0 | $ - 0 | ||
| X010 Labor Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| TOTAL CLIN X010 PRICE (NTE FFP) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| X011 Travel | |||||||||||||||||||
| Travel (NTE) | 1-Dec-17 | 4,500.00 | 4,500.00 | 4,500.00 | 4,500.00 | 2,250.00 | $ 20,250.00 | ||||||||||||
| TOTAL CLIN X011 PRICE (NTE FFP) | $ 4,500.00 | $ 4,500.00 | $ 4,500.00 | $ 4,500.00 | $ 2,250.00 | $ 20,250.00 |
| TOTAL EVALUATED PRICE | $ 4,500.00 | $ 4,500.00 | $ 4,500.00 | $ 4,500.00 | $ 2,250.00 | $ 20,250.00 | |
| Total Award Price | $ 18,000.00 | ||||||
| Note(s) and Instruction(s): | This table is for evaluation purposes only and will be used to rank and evaluate 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)
FA4855-17-R-0008-0003
Attachment 3 12 June 2017
&P of &N
Summary
| Fully Burdened Labor Rates and AOH Rates | |||
| MAFR OM&S Services | |||
| AFSOC/27 SOCONS | |||
| SUMMARY | |||
| **The summary page(s) will be incorporated into the resulting contract** | |||
| RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT. | |||
| # | Labor Categories | Base Period | |
| Year 1 | Option 1 | ||
| Year 2 | Option 2 | ||
| Year 3 | Option 3 |
Year 4
| 1 | Site Manager |
| 2 | Deputy Site Manager |
| 3 | Quality Control Inspector |
| 4 | Supply Technician |
| 5 | Grounds Operations Foreman |
| 6 | Range Control Officer (RCO) |
| 7 | Heavy Equipment Operator (HCO) |
| 8 | General Maintenance Worker |
| 9 | Electronic Technician I |
| 10 | Electronic Technician II |
| 11 | Electronic Technician III |
| 12 | Wildland Fire Manager Chief (CBA Lieutenant) |
| 13 | Senior Wildland Fire Manager (CBA Senior Firefighter) |
| 14 | Wildland Fire Manager (CBA Firefighter) |
| 15 | Scheduler |
| 16 | Paramedic |
| 17 | SITFOR |
| 18 | Range Control Officer (RCO) AOH |
| 19 | Heavy Equipment Operator (HCO) AOH |
| 20 | Electronic Technician I AOH |
| 21 | Electronic Technician II AOH |
| 22 | Electronic Technician III AOH |
| 23 | Wildland Fire Manager Chief (CBA Lieutenant) AOH |
| 24 | Senior Wildland Fire Manager (CBA Senior Firefighter) AOH |
| 25 | Wildland Fire Manager (CBA Firefighter) AOH |
| 26 | Paramedic AOH |
FA4855-17-R-0008-0003
Attachment 3
&P of &N
Instructions
| Instructions |
| MAFR OM&S Services |
| AFSOC/27 SOCONS |
| 1. Provide Labor Category Pricing: Use the "Summary" sheet to insert the fully burdened labor rates (FBLR) and AOH rates for the labor categories listed (column B) that are supported by the offeror's technical proposal. If the offeror's technical proposal includes labor categories outside of those listed, the offeror shall insert those labor categories (in column B) and include the FBLR for those labor categories as well. FBLR and AOH rates shall be provided for the base and all option periods. The FBLR shall be calculated with consideration to the current collective bargaining agreement, Attachment 12 - CBA 2015, the Attachment 10 - Wage Determination 2015-5457 and include all applicable fees, overhead, profit, and taxes, including the New Mexico Gross Receipts Tax rate for Roosevelt County (Melrose). |
| 2. Provide productive hours and number of Contractor Manpower Equivalents: Use the "TEP" sheet to insert the amount of productive hours and number of CMEs proposed to meet the service requirements of CLIN X001, X002, X003, X004, and X008. The number of CMEs indicated on this attachment shall be fully supported by the offeror's technical proposal. |
| 3. Provide equipment and materials pricing: Use the "TEP" sheet to insert the pricing for equipment and materials needed to perform the service requirements of CLIN X001. The equipment and materials pricing indicated on this attachment shall be fully supported by the offeror's technical proposal. Equipment and materials pricing shall be provided for the base and all option periods, as applicable. |
| 4. Provide any additional pricing, if applicable: Use the "TEP" sheet to insert any additional pricing that is applicable to the offeror's proposal. This may include additional labor categories if inserted in the "Summary" sheet or additional equipment/material pricing not already associated with CLIN X001. All additional pricing shall be fully supported by the offeror's technical proposal. Additional pricing shall be inserted as separate lines within the CLIN that it is associated with. Additional pricing shall be provided for the base and all option periods, as applicable. |
| 5. Provide Subcontract Percentages: Use the "TEP" sheet to indicate any percentages of subcontracted efforts. Subcontract percentages shall be fully supported by the offeror's technical proposal. |
| 6. Offerors are cautioned to follow the instructions listed in the instruction worksheet to complete Attachment 3 properly. Offerors are responsible for ensuring that the FBLR and AOH rates inserted in the "Summary" sheet properly flow to the "TEP" sheet. The pricing indicated on the TEP sheet will be used to evaluate Total Evaluated Price. This will be done in accordance with the addendums to 52.212-1 and 52.212-2 in the solicitation and will include an evaluation of FAR 52.217-8. The offeror is requested not to provide pricing for the possible extension under FAR 52.217-8 which will be calculated by the Government using one half of the offeror's Option 3 pricing. |
FA4855-17-R-0008-0003
Attachment 3
File details come from the government source that posted it. Updated .