The file's text, extracted by GovTribe without its formatting.
Instructions
| Prime Contractor Price Summary - N00421-22-R-0178 |
| Instructions |
| Offeror Name: |
| Offeror Abbreviation: |
| The Offeror (i.e., Prime Contractor) shall provide its name in cell C3 above. |
| The Government will provide the Offeror Abbreviation in cell C4 above. |
General Instructions:
| The Offeror shall NOT change the order of the Government provided tabs. | |
| The Offeror may include additional tabs to this workbook after the purple "IR" tab. |
| The Offeror shall NOT change Government provided formulas or number formats. | |
| Some formulas are specifically calculating as a whole number or greater than 2-digit decimal. |
| Esception: An Offeror may alter a Government summation formula only to include additional rows in the SUM formula. |
| All Offeror inputed dollar amounts or formulas shall be 2-digit decimals format only. | |
| Where necessary, the Offeror shall use the MS Excel "ROUND" functions to achieve this format. |
| Exceptions are provided within the "Definitions" for specific columns. |
| Specific Instructions for each tab are provided below. | |
| Exceptions to a specific instruction are listed directly underneath an instruction. |
| Definitions Tab | | |
| The Government has provided a "Definitions" tab for each of the Government column headings in the blue BP1 through OP3 tabs. | |
| | The Offeror shall define each of the column headings in the blue BP1 through OP3 tabs in the Offeror's V5 Price narrative. |
| The Government has provided formatting instructions for each Government defined column on the "Definitions" tab. | |
| Example Tab | | |
| The Government has provided an example for a FFP CLIN and LH CLIN. | |
| | The example does not represent a fully priced CLIN, but how the Offeror may show the buildup of its price. |
| | The percentages in row 9 are to show the calculations used in the sample formulas. The Offeror shall not show the percentages on the blue BP1 through OP3 tabs, but link to the percentages to the purple "IR" tab or other support tabs in the buildup of the Offeror's price. |
| Information Tab | | |
| The Offeror shall provide its Point of Contract (POC), address, and phone number in rows 7-10. | |
| The Offeror shall provide its DCMA/DCAA POC, address, and phone number in rows 12-14. | |
| The Offeror shall complete the Other Entity Table with the Other Entity's Name and Other Entity's Total Cost amount for all Other Entity's identified as performing work on blue BP1 through OP3 tabs in this workbook. | |
| | The Government has linked the "Offeror Total Proposed Cost" (D19:D24) to the Offeror's Total Proposed Cost (N22) on the "TC" tab. |
| | The Offeror may add additional rows to the Other Entity Table as necessary. |
| | The Offeror's Total Cost (before PROFIT) amount is for blue BP1 through OP3; the Option to Extend Services is not included. |
| The Offeror shall provide the name of the Other Entity, the Other Entity POC, the Other Entity address, the Other Entity phone number and the Other Entity's DCMA/DCAA's information below the Other Entity Table. | |
| | The Offeror may add additional entries as necessary. |
| ENs Tab | |
| The Evaluation Notices (ENs) tab shall be completed by the Offeror should the Government send an Evaluation Notice to the Offeror, which impact this attachment. |
| The Offeror shall input the Total Estimated Proposed Price amount (TEPP, row 26) for each period of performance from the original submission in row 9. |
| The Offeror shall input the updated Total Estimated Proposed Price Amount (TEPP, row 26) for each period of performance as each EN is incorporated into the model. This shall be done in numerical order of the ENs. |
| The Offeror shall provide a description of changes for the corresponding EN in column L. |
| The Offeror shall copy and paste additional EN # TEPP Total and EN # Delta rows as need, so that all ENs are represented on the ENs tab. |
| The EN # Delta row will autocalculate the difference from the last EN # TEPP Total and the previous EN # TEPP Total for each EN. | |
| For example, the autocalculation for EN 1 Delta is the difference from EN 1 TEPP Total (ENs, row 11) and TEPP Total (ENs, row 9). |
If the Offeror updates its proposed price which is not as a result of an EN, then the Offeror shall describe the reason for the change and show the corresponding delta as if in response to an EN.
| Red Tabs | | |
| The Offeror shall NOT input or make changes to the Red tabs. | |
| | The links to the blue BP1 through OP3 tabs, or other tabs, are automatically updated as rows and columns are added to the blue BP1 through OP3 tabs. |
| The Offeror may link to the information in the Red tabs to the Offeror's additional tabs, as necessary. | |
| EST QTY | |
| The "EST QTY" tab is locked for changes; however, the Offeror may click on the cells. |
| This provides the Offeror with the Government's Estimated Quantity (EST QTY) for each CLIN for each Period of Performance. |
| The Government has linked the EST QTY to the appropriate cells on the blue BP1 through OP3 tabs. | |
| The Government has linked the EST QTY to the formulas in the red "TEPP" tab. | |
| The Government has included the Option to Extend Services amounts for purposes of calculating the Total Estimated Proposed Price (TEPP) on the red "TEPP" tab. |
| TEPP | | |
| The "TEPP" tab is locked for changes; however, the Offeror may click on the cells. | |
| This is the Offeror's Proposed Price, including the Option to Extend Services, for this Contract. | |
| | For Firm Fixed Price (FFP) and Labor Hour (LH) CLINs, the proposed price is the SECTION B (BUP) * EST QTY. |
| | For Cost Reimbursable (CR) CLINs, the proposed priced is the Government Estimated Cost (CR-Gov) * (1+ the SECTION B Unit Percentage (BUP)) * EST QTY. |
| | The following CLINs are not included in the TEPP: 0X12-0X13. |
| For Firm Fixed Price (FFP) and Labor Hour (LH) CLINs, the Option to Extend Services calculation uses the Option Period 3 proposed SECTION B Unit Prices, from the "BUP" tab, for its calculation. | |
| For Cost Reimbursable (CR) CLINs, the Option to Extend Services calculation uses the Option Period 1 proposed SECTION B Unit Percentages, from the "BUP" tab, for its calculation. | |
| BUP | |
| The BUP tab is locked for changes; however, the Offeror may click on the cells. |
| For the FFP CLINs, the Unit Price is the Offeror's proposed SECTION B Unit Price (Vol 5 Att L-8 PCPS, column BH) from the blue BP1 through OP3 tabs. |
| For the LH CLINs, the Unit Price is the Offeror's proposed SECTION B Unit Price (Vol 5 Att L-8 PCPS, column BH) from the blue BP1 through OP3 tabs. |
| For the CR CLINs, the Unit Percentage is the Offeror's proposed percentage in the yellow "CR-Table" tab. |
| For the NSP CLINs 0X12-0X13, the Unit Price is $0.00 and is blank for each period of performance. |
| The following CLINs do not have a price: 0101-0701, 0104-0704, 0110-0410 & 0610-0710, and 0111-0411 & 0611-0711. |
| TC | |
| The TC (Total Cost) tab is locked for changes; however, the Offeror may click on the cells. |
| This is the Offeror Proposed Total Cost (Vol 5 Att L-8 PCPS, column AY) before PROFIT for the CLINs from the blue BP1 through OP3 tabs. |
| The Government has linked the "Offeror Total Proposed Cost" (D19:D24) in the Other Entity's Table on the "Information" tab to the "Offeror Total Proposed Cost" (N22). |
| The Option to Extend Services is not included in the Total Cost. |
| Profit | |
| The Profit tab is locked for changes; however, the Offeror may click on the cells. |
| This is the Offeror proposed Profit for the CLINs from the blue BP1 through OP3 tabs. |
| The Option to Extend Services is not included in the "Profit" tab. |
| Hours | | |
| The "Hours" tab is locked for changes; however, the Offeror may click on the cells. | |
| This is the Offeror Proposed Regular and Overtime labor hours for the CLINs from the blue BP1 through OP3 tabs. | |
| | The Government has calculated the Total Proposed Hours as the summation of the Regular labor hours and the Overtime labor hours in the "Hours" tab. |
| The Option to Extend Services is not included in the "Hours" tab. | |
| Yellow Tabs | |
| CR-Gov | |
| The CR-Gov tab is locked for changes; however, the Offeror may click on the cells. |
| This is the Government's Estimated Annual Amount for each of the Cost Reimbursable CLINs and used in calculating the TEPP. |
| CR-Table | | |
| The Offeror shall input its proposed percentage in the yellow shaded cells for each Cost Reimbursable CLIN for all periods of performance. | |
| The percentages shall be a hard-coded, value only with a maximum of 2 decimal places. | |
| | The Offeror shall show the build up of the percentage, when utilizing more than one indirect rate percentage, on either the purple "IR" tab or an additional "<Company Name> CR-Rate" tab in the workbook. |
| The Offeror may propose IAW the Offeror's DCMA or DCAA rates. | |
| | If the Offeror does NOT propose IAW the Offeror's DCMA or DCAA rates, then the Offeror shall propose an H-clause to identify the special term and condition. |
| The Government has linked the Offeror's proposed unit percentage in the yellow "CR-Table" tab to the red "BUP" tab. | |
| Blue Tabs | | |
| BP1 through OP3 | | |
| The Offeror shall use these tabs to build up its proposed price. | |
| | The "Definitions" tab provides instructions for each Government provided column in the blue BP1 through OP3 tabs. |
| The Offeror shall update the column headings in row 11 to accurately reflect the information in that column, as necessary. | |
| The Offeror may add additional columns as necessary. |
| The Offeror shall add, delete, or move columns from the INDIRECT COSTS section through the PROFIT section to represent the buildup of the Total Sell Price (V5 Att L-8 PCPS, column BC) working from left to right. |
| The column headings shall remain consistent and in the same order for all of the blue BP1 through OP3 tabs. |
| The Offeror shall provide the algebraic formula for each column in row 12 to represent the calculation below it (see the "Example" tab). | |
| For a text or hard-coded value, the Offeror shall place the letter of the column in row 12. |
| The Offeor shall NOT change the Government provided formula in the "Gov't Formula" columns (V5 Att L-8 PCPS, columns BD, BE, BF, and BI). |
| The CLIN Heading rows are shaded in Green. | | |
| The summation formulas shall include all of the white cells in the rows directly below it for each CLIN. | |
| The Offeror shall add rows (white cells) as necessary to include all costs for the buildup of the CLIN price. | |
| | The Offeror shall NOT add a row to account for a rounding variance. |
| The Offeror shall update the summation formulas to include the additional rows (white cells), so that all rows are included in the proposed amount. | |
| The Offeror shall NOT change the links (established by the Government) to the Red tabs from the Green CLIN Heading row columns. | |
The Offeror shall delete any blank rows, so that the Government may filter on each of the columns from row 11 to the last row of price information for the last CLIN.
| The Offeror shall NOT change the Government formulas in the CLIN Heading rows for Gov't EST QTY, Extended Unit Price, Rounding Variance, and SECTION B Sell Price. | |
| The Government has linked these cells to other tabs within this workbook, as necessary. |
| The Offeror shall NOT propose a Rounding Variance as it is automatically calculated. |
| The Offeror shall input its proposed price for each CLIN in the SECTION B Unit Price cell within the CLIN Heading row. | |
| The Offeror's proposed price shall be a hard-coded, value only amount with a maximum of 2 decimal places. |
| The Offeror shall NOT link or reference this cell to any other cell in any workbook, including this workbook. |
| The Offeror shall NOT change the precedent or dependent links (established by the Government) with the SECTION B Sell Price or the "BUP" tab that reference the SECTION B Unit Price cell. |
| Purple Tabs | | | |
| BLR | | | |
| The Government has provided Facility Location Heading rows shaded in Green. | | |
| The Offeror shall provide the Base Labor Rate for each labor category listed on the blue BP1 through OP3 tabs by site for each period of performance. | | |
| | The Offeror shall list each labor category by site only once as long as the Base Labor Rate remains the same. | |
| | This shall be a 2-digit decimal dollar amount. | |
| | This shall be a hard-coded, value only entry for AWD and CBA employees. | |
| | | The Offeror may link this entry to an additional tab for an Exempt employee whose annual salary requires a calculation for an hourly rate. |
| The Offeror shall list each Labor Category (e.g., AWD, CBA, Exempt) proposed in the buildup of its price. | | |
| The Offeror shall link by labor category the Base Labor Rate column (V5 Att L-8 PCPS, column U) on the blue BP1 through OP3 tabs to the Base Labor Rate on the purple "BLR" tab. | | |
| IR | | |
| The Offeror shall list and provide the indirect rates to be used in buildup of its price in the Proposed Indirect Rates section. | |
| | The Offeror may normalize its calendar rates to align with the period of performance for the Proposed Indirect Rates section. |
| | The Offeror may add additional rates, as necessary. |
| The Offeror shall provide its FPRA/FPRR/DCAA Audit rates as shown in DCMA or DCAA documentation. | |
| The Offeror shall provide the date in which this information is in effect and signed by the corresponding DCMA or DCAA POC. |
| The Offeror shall include the calendar years for this information and extend the last year for the length of the contract. |
| The Government will NOT accept proposed rates to DCMA or DCAA (e.g., FPRP), since those rates have not been reviewed by DCMA or DCAA nor resulted in a DCMA FPRA, DCMA FPRR, or DCAA Audit Rate recommendation by the date of proposal submission. |
The Offeror may show the buildup of its rates on this tab or other tabs added to this workbook.
Throughout the workbook, the indirect rates shall link back to the Offeror's rates on the purple "IR" tab.
| Additional Other Entity Tabs | | |
| The Offeror may include additional tabs within the workbook, as necessary. | |
| The Offeror shall include a description of the additional tab in the Offeror's Price narrative (V5 Price). | |
| These tabs should be used to show the buildup of a value that is used once or multiple times within the buildup of the Offeror's Total Sell Price. | |
| | The Offeror shall link the appropriate cell in the blue BP1 through OP3 tabs to the appropriate cell in the additional tab. |
&F &A
Definitions
| Prime Contractor Price Summary - N00421-22-R-0178 | |
| BP1 through OP6 Definitions | |
| Offeror Name: | 0 |
| ERROR:#VALUE! | |
| General Instructions | |
| These are the instructions for completing the blue BP1 through OP3 tabs. |
| For each priced CLIN, the Offeror shall incorporate from the Other Entity's V5 Att L-9 OECS (1) the Other Entity's information contained below the MANNING/LABOR section header (shown in row 10) and (2) the Other Entity's "Total Sell Cost" (V5 Att L-9 OECS, column BC) contained below the TOTAL COST section header (shown in row 10) into the Offeror's V5 Att L-8 PCPS. |
| Period of Performance | | | |
| The Government has linked the start and end dates to the start and end dates in the blue BP1 through OP3 tabs and purple "IR" tab. | | |
| The Offeror shall NOT change this formula. | | |
| | Start Date | End Date |
| BP1 | 8/1/23 | 7/31/24 |
| BP2 | 8/1/24 | 7/31/25 |
| BP3 | 8/1/25 | 7/31/26 |
| BP4 | 8/1/26 | 7/31/27 |
| BP5 | 8/1/27 | 7/31/28 |
| OP1 | 8/1/28 | 7/31/29 |
| OP2 | 8/1/29 | 7/31/30 |
| OP3 | 8/1/30 | 7/31/31 |
| MANNING/LABOR | | |
| TMS | | |
| This is the type, model, series, and location of the work for the CLIN that is being priced. | |
| This is identified by the Government as part of the CLIN title and used for calculating totals on multiple Red tab. | |
| | F-16 Fallon - F-16 at NAS Fallon, NV |
| | F-16 Lemoore - F-16 at NAS Lemoore, CA |
| | F-16 - F-16 across all sites |
| CLIN Type | | |
| Contract Line Item Number Type | |
| The Government has identified the CLIN Type. | |
| The is the type of work and defines how the Section B Unit Price is to be paid. | |
| The following CLIN Types are on the blue BP1 through OP3 tabs and subsequent CLIN numbers have been included from the blue BP1 through OP3 tabs. | |
| | FFP - Firm Fixed Price; the Section B Unit Price is fixed and will be paid IAW the EST QTY. |
| | LH - Labor Hour; the Section B Unit Price is a composite labor rate that will be paid as the labor hours are executed. |
| | All FFP and LH CLINs in which the buildup of the price is required and shown are on the blue BP1 through OP3 tabs. |
| The following CLIN Types are not on the blue BP1 through OP3 tabs and subsequent CLIN numbers have been deleted from the blue BP1 through OP3 tabs. | |
| COST - Cost Reimbursable CLINs; these are in the yellow CR-Gov and CR-Table tabs; Information for these CLINs is in the Instructions tab |
| NSP - Not Separately Price; CLINs 0X12 and 0X13; the Offeror shall not propose a price for this CLIN |
| Blank CLINs: 0101-0701, 0104-0704, 0110-0410 & 0610-0710, and 0111-0411 & 0611-0711; the Offeror shall not propose a price for these CLINs. |
| CLIN | | |
| Contract Line Item Number | |
| The Government has identified the CLIN Number, which is linked to the CLIN number in the "EST QTY" tab. | |
| The CLINs correspond with the CLIN numbering in the RFP. | |
| | CLINs with a zero (0) EST QTY for a specific period of performance have been deleted from the specific blue BP1 through OP3 tabs. |
| CLIN Title | |
| The Government has included the CLIN Title in the green shaded CLIN Heading Line under the Work Center category and it is linked to the CLIN Title in the "EST QTY" tab. |
| This row will also contain the summations for each column of all the white rows immediately below it until the next green shaded CLIN Heading Line or the black line under the last CLIN for each period of performance. |
| Gov't Skill Type | | |
| The Government's labor name for the person doing the work. | |
| For CLINs 0X02-0X03 and 0X05-0X07, the Gov't Skill Type shall correspond with the "Skill Type" (column A) identified in V4 Att L-6 Manning. | |
| | The Offeror shall ensure that any "Skill Type" proposed by the Other Entity in V5 Att L-9 OECS are identified in V4 Att L-6 Manning. |
| For all CLINs, this shall be linked to the BLR tab "Gov't Skill Type" (column C) or a hard-coded, value only entry for an Other Entity. | |
| Offeror Labor Category Title | | |
| The Offeror's labor category name for the person doing the work. | |
| For CLINs 0X02-0X03 and 0X05-0X07, the Offeror Labor Category Title shall correspond with the "Offerors Proposed Labor Category" (column D) identified in V4 Att L-6 Manning. | |
| | All labor categories identified in V4 Att L-6 Manning, column D, shall also be listed in CLINs 0X02-0X03 and 0X05-0X07. |
| | If multiple labor categories are proposed in column D of V4 Att L-6 Manning, the Offeror shall list each of these different labor categories in a separate row of the BP1 through OP3 tabs in CLINs 0X02-0X03 and 0X05-0X07. |
| For all CLINs: | |
| | The Offeror's Labor Category Title shall be linked to the "BLR" tab "Offeror Labor Category Title" (column D). |
| | The Offeror may use this column with a hard-coded, value only entry to identify additional costs such as Liability Insurance, etc. |
| When an Other Entity is performing the work: | | |
| The Offeror shall list the Other Entity's labor categories from V5 Att L-9 OECS. | |
| If an Other Entity proposes to perform work on CLINs 0X02-0X03 and 0X05-0X07, the Offeror shall include the Other Entity's labor categories in the Offeror's V4 Att L-6 Manning. | |
| If V5 Att L-9 OECS is not provided to the Offeror and only a vendor quote is received, then the Offeror shall list the Other Entity's name. | |
| | The Other Entity's quote must be provided as substantiating documentation with the Offeror's Price Narrative (V5 Price). |
| For all CLINs, this shall be a hard-coded, value only entry or linked to an additional tab for an Other Entity. | |
| The Offeror may use this column to identify additional costs such as Liability Insurance, etc. | | |
| Labor Rate Source | | |
| The referenced document for the Base Labor Rate (V5 Att L-8 PCPS, column U) or OT Labor Rate (V5 Att L-8 PCPS, column AB). | |
| The Offeror may provide additional references, but the Government has provided the list below for CBA and AWD employees. | |
| | CBA: Collective Bargaining Agreement - These have been provided by the Government as Section J Attachment 5. |
| | AWD: Area Wage Determination - The Offeror shall provide if not already provided by the Government in Section J Attachments 6-7. |
| | Exempt: The Offeror's employees not covered by a CBA or AWD. |
| This shall be linked to the "BLR" tab "Labor Rate Source" (column E). | |
| Company Name | | |
| The name of the company completing the work. | |
| | Any identified Other Entity in the Company Name column shall also be listed on the "Information" tab. |
| This shall be linked to the "BLR" tab "Company" (column A) for an identified labor category or a hard-coded, value only entry for an Other Entity. | |
| Location | |
| The physical location of the Offeror Labor Category Title completing the work. |
| The physical location of the Offeror Labor Category Title shall also correspond with the Labor Rate Source for the Base Labor Rate and OT Labor Rate determination. |
| Examples for Location include: Base Name, City and State, Country, etc. |
| This shall be a hard-coded, value only entry. |
| Maintenance (O, I, D) | |
| The Offeror shall identify the type of Maintenance being performed as "O" for Organizational Level, "I" for Intermediate Level, or "D" for Depot Level work. |
| This shall be a hard-coded, value only entry. |
| Offeror's Proposed Number of Whole Heads | |
| This is the number of physical bodies assigned to do the work. |
| The Offeror shall NOT propose the Number of Whole Heads for LH CLINs. |
| For CLIN 0001, the Offeror shall propose a whole number for the Number of Whole Heads (i.e., Whole Body). | |
| These heads shall not be included in V4 Att L-6 Manning. |
| For CLIN 0001, the FTEs associated with the "Offeror's Proposed Number of Whole Heads" may be allocated for a maximum of 2 months or less, so long as the Offeror provides this information as part of its Price Narrative (V5 Price). |
| In this case, the hard-coded value entered for the Whole Head should be rounded up when there is an FTE (e.g., 1 whole head for 0.15 FTE). |
| For CLINs 0X02-0X03 and 0X05-0X07, the "Offeror's Proposed Number of Whole Heads", including any Other Entity's Whole Heads, in V5 Att L-8 PCPS shall equal the "Offeror's Proposed Number of Employees (Whole Heads)", including all Other Entity's Whole Heads, in V4 Att L-6 Manning column D for an identified Skill Type and Labor Category. | |
| For every one (1) "Offeror's Proposed Number of Whole Heads" in V5 Att L-8 PCPS shall be equal to and priced as one (1.00) FTE. |
| If a Skill Type or Labor Category is listed on multiple rows in V5 Att L-8 PCPS, then the Government will sum those rows in its price realism comparison with V4 Att L-6 Manning. |
| This shall be a hard-coded, value only WHOLE NUMBER entry. | |
| The Offeror shall NOT link this to another cell or workbook. |
| The sum of the Whole Heads in the CLIN Heading row shall be a WHOLE NUMBER. |
| FTEs | |
| Full Time Equivalents |
| The Offeror shall propose FTEs for each FFP CLIN. |
| The Offeror shall NOT propose FTEs for LH CLINs. |
| For FFP CLIN 0001: | |
| For CLIN 0001, the FTEs associated with the "Offeror's Proposed Number of Whole Heads" may be allocated for a maximum of 2 months or less, so long as the Offeror provides this information as part of its Price Narrative (V5 Price). |
| The Offeror shall propose an FTE which is 0 ≤ FTE ≤ "Offeror’s Proposed Number of Whole Heads" for each labor category within the FFP CLIN 0001. |
| The sum of the FTEs may not be more than the sum of the "Offeror's Proposed Number of Whole Heads" for each Labor Category for each CLIN. |
| FFP CLINs 0X02-0X03 and 0X05-0X07: | |
| The Offeror shall propose and price a whole (#.00) FTE in CLINs 0X02-0X03 and 0X05-0X07 in V5 Att L5 PCPS that is equal to the "Offeror Proposed Manning for 30 F-16" identified by Skill Type and Labor Category in V4 Att L-6 Manning, which should also account for information proposed by the Other Entity. |
| As part of the price realism analysis, the sum of the FTEs for a Skill Type and Labor Category listed on multiple rows in V5 Att L-8 PCPS will be compared with the "Offeror's Proposed Number of Whole Heads" in V5 Att L-8 PCPS and the "Offeror Proposed Manning for 30 F-16" in V4 Att L-6 Manning. |
| This shall be a hard-coded, 2-digit decimal value only entry. | |
| The sum of the FTEs in the CLIN Heading row shall be a 2-digit decimal. |
| Direct Labor Hours per Manyear | | |
| The total number of labor hours that a single Whole Head is available to work for a full labor year. | |
| The Offeror shall provide and describe the calculation for the Direct Labor Hours per Manyear as part of the Offeror's Price Narrative (V5 Price). | |
| | For example: Annual Work Year less holiday, sick/personal days, etc. |
| The Offeror shall link the Direct Labor Hours per Manyear in the blue BP1 through OP3 tabs to the appropriate cell in an additional tab. | |
| Regular Labor Hours | | |
| Regular Labor Hours = FTEs * Direct Labor Hours per Manyear | |
| FFP CLINs | |
| | The sum of the Regular Labor Hours for each labor category shall not exceed the maximum Direct Labor Hours per Manyear for that labor category. |
| | For CLINs 0X02-0X03 and 0X05-0X07, the Offeror shall propose one (1) full Direct Labor Hours per Manyear for each single FTE/Whole Head. |
| LH CLINs | |
| | The sum of the Offeror's (and Other Entity's, if applicable) Regular Labor Hours and OT Labor Hours shall equal the Government EST QTY of labor hours for that LH CLIN. |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated number of Regular Labor Hours does not exceed a 2-digit decimal. | |
| The sum of the Regular Labor Hours in the CLIN Heading row shall be a 2-digit decimal. |
| OT Hour Percentage | |
| The Offeror proposed percentage of overtime hours a labor category is expected to work in a year. |
| This shall be a hard-coded, value only maximum 2-digit decimal entry. |
| OT Labor Hours | | |
| OT Labor Hours = Regular Labor Hours * OT Hour Percentage | |
| FFP CLINs | |
| | The Offeror shall price OT Labor Hours when the maximum Direct Labor Hours per Manyear is exceeded for a given labor category. |
| LH CLINs | |
| | The sum of the Offeror's (and Other Entity's, if applicable) Regular Labor Hours and OT Labor Hours shall equal the Government EST QTY of labor hours for that LH CLIN. |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated number of OT Labor Hours does not exceed a 2-digit decimal. | |
| The sum of the OT Labor Hours in the CLIN Heading row shall be a 2-digit decimal. |
| Shift | |
| The Offeror shall propose the normal shift a labor category is to be working. |
| This shall be a hard-coded, value only entry (e.g., 1, 2, 3). |
| Adder 1 | |
| This is a description of the additional pay as described in the labor agreement (e.g., Lead, CDI, etc.) |
| The Adder description is applied to all Whole Heads/FTEs in that row. |
| This shall be a hard-coded, value only entry. |
| ** The Offeror shall add additional columns as necessary. Only one Adder # shall be listed in each column. ** |
| Adder 2 | |
| This is a description of the additional pay as described in the labor agreement (e.g., Lead, CDI, etc.) |
| The Adder description is applied to all Whole Heads/FTEs in a row. |
| This shall be a hard-coded, value only entry. |
| ** The Offeror shall add additional columns as necessary. Only one Adder # shall be listed in each column. ** |
| DIRECT LABOR COST | |
| Base Labor Rate | |
| The starting hourly labor rate for a Work Center, Skill Type, Labor Category. |
| The Offeror shall link the Base Labor Rate in the blue BP1 through OP3 tabs to the purple "BLR" tab for the corresponding Work Center, Skill Type, Labor Category and period of performance. |
| This shall be a 2-digit decimal dollar amount. |
| Shift Differential | | |
| The additional dollar amount for working other than the first (1st) shift as described by the labor agreement. | |
| | This shall correspond to the shift proposed by the Offeror in the Shift column (V5 Att L-8 PCPS, column Q). |
| The Offeror shall link the Shift Differential in the blue BP1 through OP3 tabs to the appropriate cell in an additional tab. | |
| This shall be a 2-digit decimal dollar amount. | |
| Adder 1 | |
| This is the additional dollar amount corresponding with the Adder # description in the MANNING/LABOR section and the additional pay for the Adder # description in the CBA. |
| The Adder Pay shall applied to all identified Whole Heads/FTEs in that row. |
| The Offeror shall NOT combine multiple Adder Pay amounts for a single dollar amount into a single cell. |
| The Offeror shall link the Adder Pay in the blue BP1 through OP3 tabs to the appropriate cell in an additional tab. |
| This shall be a 2-digit decimal dollar amount. |
| ** The Offeror shall add additional columns as necessary. Only one Adder # shall be listed in each column. ** |
| Adder 2 | |
| This is the additional dollar amount corresponding with the Adder # description in the MANNING/LABOR section and the additional pay for the Adder # description in the CBA. |
| The Adder Pay shall applied to all identified Whole Heads/FTEs in that row. |
| The Offeror shall NOT combine multiple Adder Pay amounts for a single dollar amount into a single cell. |
| The Offeror shall link the Adder Pay in the blue BP1 through OP3 tabs to the appropriate cell in an additional tab. |
| This shall be a 2-digit decimal dollar amount. |
| ** The Offeror shall add additional columns as necessary. Only one Adder # shall be listed in each column. ** |
| Regular Labor Rate | |
| Regular Labor Rate = Base Labor Rate + Shift Differential + Adder Pay |
| This is a calculated 2-digit decimal dollar amount. |
| Regular Labor Cost | | |
| Regular Labor Cost = Regular Labor Hours * Regular Labor Rate | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated Regular Labor Cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the Regular Labor Cost in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| OT Rate Percentage | | |
| The Offeror proposed overtime percentage increase to be applied to the Regular Labor Rate. | |
| | For example: time and a half is 150%. |
| This shall be a percentage, with a maximum 2 decimal places. | |
| OT Labor Rate | |
| OT Labor Rate = Regular Labor Rate * OT Rate Percentage |
| The Offeror proposed labor rate to be paid when working additional hours that exceed the maximum Direct Labor Hours per Manyear. |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated OT Labor Rate does not exceed a 2-digit decimal dollar amount. |
| OT Labor Cost | | |
| OT Labor Cost = OT Labor Hours * OT Labor Rate | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated OT Labor Cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the OT Labor Cost in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| TOTAL DIRECT LABOR COST | | |
| TOTAL DIRECT LABOR COST = Regular Labor Cost + OT Labor Cost | |
| The Offeror proposed Direct Labor Cost for Regular and OT hours. | |
| This is a calculated 2-digit decimal dollar amount. | |
| | The sum of the TOTAL DIRECT LABOR COST in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| INDIRECT COSTS | | |
| Fringe | | |
| The Offeror's Fringe cost proposed IAW the Offeror's DCMA FPRA or FPRR, DCAA rates, or Management approved and signed rates | |
| | If the Offeror does not have DCMA or DCAA approved F-16 Fringe rate, then the Offeror shall show the buildup of the Fringe rate in either the purple "IR" tab or an additional "FRINGE" tab in V5 Att L-8 PCPS. |
| The Fringe rate used in the calculation for the Fringe cost shall be linked to the Offeror's Fringe rate in the table on the purple "IR" tab. | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated Fringe Cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the Fringe in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| Overhead | | |
| The Offeror's Overhead cost proposed IAW the Offeror's DCMA FPRA or FPRR, DCAA rates, or Management approved and signed rates | |
| The Overhead rate used in the calculation for the Overhead cost shall be linked to the Offeror's Overhead rate on the purple "IR" tab. | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated Overhead Cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the Overhead in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| *Additional Indirect Costs* | | | |
| The Offeror shall add additional columns for any additional Offeror proposed Indirect Costs. | | |
| | The Offeror shall provide an explanation of the additional Offeror proposed Indirect Costs. | |
| | | The Offeror's additional Indirect Costs shall be proposed IAW the Offeror's DCMA FPRA or FPRR, DCAA rates, or Management approved and signed rates. |
| | | The additional Indirect rate used in the calculation for the additional Indirect cost shall be linked to the Offeror's additional Indirect rate on the purple "IR" tab. |
| | | The same overarching definitions for Fringe and Overhead will also apply to any additional Offeror proposed Indirect Costs. |
| The Offeror shall use the MS Excel" ROUND" function to ensure that the calculated additional Offeror proposed Indirect Cost does not exceed a 2-digit decimal dollar amount. | | |
| | The sum of each additional Offeror proposed Indirect Cost in the green CLIN Heading row shall be a 2-digit decimal dollar amount. | |
| TOTAL INDIRECT LABOR COST | | | |
| TOTAL INDIRECT LABOR COST = Fringe + Overhead + any additional Indirect Costs | | |
| The sum of the TOTAL INDIRECT LABOR COST in the CLIN Heading row shall be a 2-digit decimal dollar amount. | | |
| TOTAL LABOR COST | | | |
| TOTAL LABOR COST = TOTAL DIRECT LABOR COST + TOTAL INDIRECT LABOR COST | | |
| This is a calculated 2-digit decimal dollar amount. | | |
| | The sum of the TOTAL LABOR COST in the CLIN Heading row shall be a 2-digit decimal dollar amount. | |
| OTHER DIRECT COSTS | | | |
| ODC | | | |
| Other Direct Costs | | |
| Offeror proposed costs associated with performing the work for the specific CLIN. | | |
| | The Offeror shall insert and label additional columns as necessary to identify different types of ODCs. | |
| | The Offeror shall provide an explanation of the additional Offeror proposed Other Direct Costs. | |
| | The same overarching definitions for ODC, Material, and Material Handling Fee will also apply to any additional Offeror proposed Other Direct Costs. | |
| | | The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated additional Offeror proposed Other Direct Cost does not exceed a 2-digit decimal dollar amount. |
| The Offeror may roll-up annual expenses (e.g., uniforms, shoes, etc.) as one ODC either by CLIN or labor category. | | |
| | The Offeror shall show the buildup for the ODC in a separate additional tab. | |
| This shall be a 2-digit decimal dollar amount. | | |
| | The Offeror shall link the ODC in the blue BP1 through OP3 tabs to the appropriate cell in either the purple "IR" tab or an additional "ODC" tab. | |
| | The sum of the ODC in the CLIN Heading row shall be a 2-digit decimal dollar amount. | |
| Material | | |
| Material costs associated with the CLIN that are not accounted for in a Cost Reimbursable Material CLIN 0X10. | |
| The Offeror shall provide the buildup of the material costs in a separate "MATERIAL" tab and/or substantiating documentation in V5 Price. | |
| This shall be a 2-digit decimal dollar amount. | |
| | The Offeror shall link the Material in the blue BP1 through OP3 tabs to the appropriate cell in an additional "MATERIAL" tab. |
| | The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated Material cost does not exceed a 2-digit decimal dollar amount. |
| | The sum of the Material in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| Material Handling Fee | | |
| The Material Handling Fee associated with the Material costs proposed. | |
| The Offeror's Material Handling Fee cost proposed IAW the Offeror's DCMA FPRA or FPRR, DCAA rates, or Management approved and signed rates. | |
| The Material Handling Fee rate used in the calculation for the Material Handling Fee cost shall be linked to the Offeror's Material Handling Fee rate on the purple "IR" tab. | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated Material Handling Fee cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the Material Handling Fee in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| TOTAL OTHER DIRECT COST | | |
| TOTAL OTHER DIRECT COST = ODC (including those added by the Offeror) + Material + Material Handling Fee | |
| | The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated additional Offeror proposed Other Direct Cost does not exceed a 2-digit decimal dollar amount. |
| The sum of the TOTAL OTHER DIRECT LABOR COST in the CLIN Heading row shall be a 2-digit decimal dollar amount. | |
| OTHER ENTITY | | |
| Other Entity Cost | | |
| The dollar amount for an Other Entity to perform work for a specific CLIN. | |
| For CLINs 0X02-0X03 and 0X05-0X07: | |
| | The Offeror proposed amount shall trace to V5 Att L-9 OECS Total Sell Cost for each Other Entity proposed labor category or cost. |
| | The Offeror shall propose each Other Entity's labor caterogies as a separate line item in CLINs 0X02-0X03 and 0X05-0X07 (if applicable). |
| For all CLINs (excluding 0X02-0X03 and 0X05-0X07): | | |
| The Offeror proposed amount shall trace to V5 Att L-9 OECS (Other Entity Cost Summary) or to the Other Entity's substantiating documentation as provided in the Offeror's Price narrative (V5 Price). | |
| | The Offeror shall propose each Other Entity as a separate line item in a specific CLIN. |
| This shall be a 2-digit decimal dollar amount. | |
| The Offeror shall link the Other Entity's amount in the blue BP1 through OP3 tabs to the appropriate cell in an additional "OE-<Company Name>" tab. |
| The sum of the Other Entity Cost in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| Other Entity Handling Fee | | |
| The Other Entity Handling Fee associated with the Other Entity costs proposed. | |
| The Offeror's Other Entity Handling Fee cost proposed IAW the Offeror's DCMA FPRA or FPRR, DCAA rates, or Management approved and signed rates | |
| The Other Entity Handling Fee rate used in the calculation for the Other Entity Handling Fee cost shall be linked to the Offeror's Other Entity Handling Fee rate on the purple "IR" tab. | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated Other Entity Handling Fee Cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the Other Entity Handling Fee in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| TOTAL OTHER ENTITY COST | | |
| TOTAL OTHER ENTITY COST = Other Entity Cost + Other Entity Handling Fee | |
| This is a calculated 2-digit decimal dollar amount. | |
| | The sum of the TOTAL OTHER ENTITY COST in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| SUBTOTAL | | |
| SUBTOTAL = TOTAL LABOR COSTS + TOTAL OTHER DIRECT COST + TOTAL OTHER ENTITY COST | |
| This is a calculated 2-digit decimal dollar amount. | |
| | The sum of the SUBTOTAL in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| G&A | | |
| The Offeror's G&A cost proposed IAW the Offeror's DCMA FPRA or FPRR, DCAA rates, or Management approved and signed rates | |
| The G&A rate used in the calculation for the G&A cost shall be linked to the Offeror's G&A rate on the purple "IR" tab. | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated G&A Cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the G&A in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| TOTAL COST | | |
| TOTAL COST = SUBTOTAL + G&A | |
| This is a calculated 2-digit decimal dollar amount. | |
| | The sum of the TOTAL COST in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| PROFIT | | |
| The Offeror's proposed PROFIT amount. | |
| The Offeror shall not proposed a PROFIT percentage of less than 2% for any CLIN in the blue BP1 through OP3 tabs. | |
| The PROFIT rate used in the calculation for the PROFIT cost shall be linked to the Offeror's PROFIT rate on the purple "IR" tab. | |
| The Offeror shall use the MS Excel "ROUND" function to ensure that the calculated PROFIT cost does not exceed a 2-digit decimal dollar amount. | |
| | The sum of the PROFIT in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| TOTAL PRICE | | |
| Total Sell Price | | |
| Total Sell Price = TOTAL COST + PROFIT | |
| This is a calculated 2-digit decimal dollar amount. | |
| | The sum of the Total Sell Price in the CLIN Heading row shall be a 2-digit decimal dollar amount. |
| Gov't EST QTY | |
| This is the predefined Government Estimated Quantity for each CLIN. |
| This amount is linked to the red "EST QTY" tab. |
| The Offeror shall NOT change this link or amount. |
| Extended Unit Price | |
| Extended Unit Price = Total Sell Price/Gov't EST QTY |
| This is a Government predefined formula that is NOT rounded. |
| The resultant Extended Unit Price may be more than a 2-digit decimal. |
| The Offeror shall NOT change this formula. |
| Rounding Variance | | |
| Rounding Variance = TO Sell Price - Total Sell Price | |
| The absolute value of the Rounding Variance shall NOT be more than the Gov't EST QTY. | |
| This is a Government predefined formula that is NOT rounded. | |
| The Offeror shall NOT change this formula. | |
| OFFEROR PROPOSED PRICE | | |
| SECTION B Unit Price | | |
| This is the Offeror's proposed price for a single unit. | |
| This amount will become the SECTION B Unit Price of the Task Order. | |
| The Offeror shall propose a hard-coded, 2-digit decimal dollar amount for each CLIN in the blue BP1 through OP3 tabs. | |
| | If the Offeror does not intend to price a CLIN, then the Offeror shall propose $0.00 and provide the rationale in its Price narrative (V5 Price). |
| | The Offeror shall NOT link or reference this cell to any other cell in any workbook, including this workbook. |
| The Government has linked the SECTION B Unit Price in the blue BP1 through OP3 tabs to the red "BUP" tab. | |
| SECTION B Sell Price | |
| SECTION B Sell Price = Gov't EST QTY * SECTION B Unit Price |
| This is a Government predefined formula. |
| The Offeror shall NOT change this formula. |
| This formula is used to calculate the Rounding Variance. |
&A
Example
| Prime Contractor Price Summary - N00421-22-R-0178 | |
| BP/OP Example | |
| Offeror Name: | 0 |
| ERROR:#VALUE! | |
| PoP Start Date: | 8/1/23 |
| PoP End Date: | 7/31/24 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 45% | 15% | | | | | | | | | | | | 5% | | | 6% | | |
| MANNING/LABOR | | | | | | | | | | | | | | | | | | | | DIRECT LABOR COST | | | | | | | | | INDIRECT COSTS | | | | | OTHER DIRECT COSTS | | | OTHER ENTITY | | | | | G&A | | TOTAL COST | FIXED FEE | TOTAL PRICE | OFFEROR PROPOSED PRICE |
| TMS | CLIN TYPE | CLIN | CLIN Title | Gov't Skill Type | Offeror Labor Category Title | Labor Rate Source | Company Name | Location | Maintenance | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| (O, I, D) | Offeror's Proposed Number of Whole Heads | FTEs | Direct Labor Hours per Manyear | Regular Labor Hours | OT Hour Percentage | OT Labor Hours | Shift | Adder 1 | Adder 2 | | Base Labor Rate | Shift Differential | Adder 1 | Adder 2 | Regular Labor Rate | Regular Labor Cost | OT Rate Percentage | OT Labor Rate | OT Labor Cost | TOTAL DIRECT LABOR COST | | Fringe | Overhead | TOTAL INDIRECT LABOR COST | TOTAL LABOR COSTS | ODC | Material | Material Handling Fee | TOTAL OTHER DIRECT COST | | Other Entity Cost | OE Handing Fee | TOTAL OTHER ENTITY COST | SUBTOTAL | | G&A | TOTAL COST | Fixed Fee | Total Sell Price | Gov't EST QTY | Extended Unit Price | Rounding Variance | | Section B | | | | |
| Unit Price | Section B | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Sell Price
| A | B | C | D | E | F | G | H | I | J | K | L | M | N=L*M | O | P=N*O | Q | R | S | U | V | W | X | Y=sum(U:X) | Z=N*Y | AA | AB=Y*AA | AC=P*AB | AD=Z+AB | AF=AD*Fringe | AG=AD*Overhead | AH=AF+AG | AJ=AD+AH | AL | AM | AN=AM*MatHanFee | AO=sum(AL:AN) | AQ | AR=AQ*OEHanFee | AS=AQ+AR | AU=AJ+AO+AS | AW=AU*G&A | AY=AU+AW | BA=AY*FixedFee | BC=AY+BA | Gov't Formula | Gov't Formula | Gov't Formula | BH | Gov't Formula |
| FFP Example | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| F-16 | FFP | 0002 | VMG O&I Maintenance | | | | | | | 4 | 4.00 | | 6,960.00 | | 174.00 | | | | | | | | | $ 283,550.40 | | | $ 10,634.01 | $ 294,184.41 | $ 132,382.99 | $ 44,127.67 | $ 176,510.66 | $ 470,695.07 | $ 300.00 | $ - 0 | $ - 0 | $ 300.00 | $ - 0 | $ - 0 | $ - 0 | $ 470,995.07 | $ 23,549.75 | $ 494,544.82 | $ 29,672.69 | $ 524,217.51 | 12 | $ 43,684.7925 | $ (0.03) | $ 43,684.79 | $ 524,217.48 |
| F-16 | | 0002 | | Aircraft Mech. - Airframe Structures | Aircraft Mechanic | CBA | Prime | NAS Fallon | O | 1 | 1.00 | 1740 | 1740.00 | 2.50% | 43.50 | 1 | | | $ 40.49 | | | | $ 40.49 | $ 70,452.60 | 150% | $ 60.74 | $ 2,642.19 | $ 73,094.79 | $ 32,892.66 | $ 10,964.22 | $ 43,856.88 | $ 116,951.67 | $ 75.00 | | | $ 75.00 | | | $ - 0 | $ 117,026.67 | $ 5,851.33 | $ 122,878.00 | $ 7,372.68 | $ 130,250.68 | | | | | |
| F-16 | | 0002 | | Aircraft Mech. - Corrosion Control | Aircraft Mechanic | CBA | Prime | NAS Fallon | O | 1 | 1.00 | 1740 | 1740.00 | 2.50% | 43.50 | 1 | Lead | | $ 40.49 | | $ 1.00 | | $ 41.49 | $ 72,192.60 | 150% | $ 62.24 | $ 2,707.44 | $ 74,900.04 | $ 33,705.02 | $ 11,235.01 | $ 44,940.03 | $ 119,840.07 | $ 75.00 | | | $ 75.00 | | | $ - 0 | $ 119,915.07 | $ 5,995.75 | $ 125,910.82 | $ 7,554.65 | $ 133,465.47 | | | | | |
| F-16 | | 0002 | | Aircraft Mech. - Corrosion Control | Aircraft Mechanic | CBA | Prime | NAS Fallon | O | 2 | 2.00 | 1740 | 3480.00 | 2.50% | 87.00 | 1 | | | $ 40.49 | | | | $ 40.49 | $ 140,905.20 | 150% | $ 60.74 | $ 5,284.38 | $ 146,189.58 | $ 65,785.31 | $ 21,928.44 | $ 87,713.75 | $ 233,903.33 | $ 150.00 | | | $ 150.00 | | | $ - 0 | $ 234,053.33 | $ 11,702.67 | $ 245,756.00 | $ 14,745.36 | $ 260,501.36 | | | | | |
| LH Example | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| F-16 | LH | 0008 | F-16 Aircraft Maintenance (O&A) | | | | | 0 | 0.00 | 0.00 | 250.00 | | | | | | $ - 0 | | | $ 14,257.50 | $ 14,257.50 | $ 6,415.88 | $ 2,138.63 | $ 8,554.51 | $ 22,812.01 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 22,812.01 | $ 1,140.60 | $ 23,952.61 | $ 1,437.16 | $ 25,389.77 | 250 | $ 101.5591 | $ 0.23 | $ 101.56 | $ 25,390.00 |
| F-16 | | 0008 | | Aircraft Mechanic II - Lead | CBA | Prime | NAS Fallon | | | | 75.00 | 1 | Lead | $ 37.72 | $ 1.00 | $ 38.72 | $ - 0 | 150% | $ 58.08 | $ 4,356.00 | $ 4,356.00 | $ 1,960.20 | $ 653.40 | $ 2,613.60 | $ 6,969.60 | | | | $ - 0 | | | $ - 0 | $ 6,969.60 | $ 348.48 | $ 7,318.08 | $ 439.08 | $ 7,757.16 | | | | | |
| F-16 | | 0008 | | Aircraft Mechanic II | CBA | Prime | NAS Fallon | | | | 75.00 | 1 | | $ 37.72 | | $ 37.72 | $ - 0 | 150% | $ 56.58 | $ 4,243.50 | $ 4,243.50 | $ 1,909.58 | $ 636.53 | $ 2,546.11 | $ 6,789.61 | | | | $ - 0 | | | $ - 0 | $ 6,789.61 | $ 339.48 | $ 7,129.09 | $ 427.75 | $ 7,556.84 | | | | | |
| F-16 | | 0008 | | Aircraft Mechanic I | CBA | Prime | NAS Fallon | | | | 100.00 | 1 | | $ 37.72 | | $ 37.72 | $ - 0 | 150% | $ 56.58 | $ 5,658.00 | $ 5,658.00 | $ 2,546.10 | $ 848.70 | $ 3,394.80 | $ 9,052.80 | | | | $ - 0 | | | $ - 0 | $ 9,052.80 | $ 452.64 | $ 9,505.44 | $ 570.33 | $ 10,075.77 | | | | | |
&A
Information
| Prime Contractor Price Summary - N00421-22-R-0178 | | | | |
| Offeror's Information | | | | |
| Offeror Name: | | 0 | | |
| ERROR:#VALUE! | | | | |
| Prime Contractor POC | | | | |
| Address | | | | |
| Phone | | | | |
| CAGE Code: | | | | |
| DCMA POC: | | | | |
| Address | | | | |
| Phone | | | | |
| Other Entity Summary | | | | |
| Other Entity | Other Entity Total Cost | Offeror Total Proposed Cost | Other Entity Cost Percentage |
| | | $ - 0 | ERROR:#DIV/0! |
| | | $ - 0 | ERROR:#DIV/0! |
| | | $ - 0 | ERROR:#DIV/0! |
| | | $ - 0 | ERROR:#DIV/0! |
| | | $ - 0 | ERROR:#DIV/0! |
| | | $ - 0 | ERROR:#DIV/0! |
| Other Entity Name: | | | | |
| OE POC | | | | |
| Address | | | | |
| Phone | | | | |
| DCMA/DCAA POC: | | | | |
| Address | | | | |
| Phone | | | | |
| Other Entity Name: | | | | |
| OE POC | | | | |
| Address | | | | |
| Phone | | | | |
| DCMA/DCAA POC: | | | | |
| Address | | | | |
| Phone | | | | |
&A
ENs
| Prime Contractor Price Summary - N00421-22-R-0178 | | | | | | | | | | | |
| Evaluation Notices | | | | | | | | | | | |
| Offeror Name: | | 0 | | | | | | | | | |
| ERROR:#VALUE! | | | | | | | | | | | |
| BP1 | BP2 | BP3 | BP4 | BP5 | OP1 | OP2 | OP3 | Extended Services | Total PMB | EN Description |
| TEPP Total | | | | | | | | | | $ - 0 | |
| EN 1 TEPP Total | | | | | | | | | $ - 0 |
| EN 1 Delta | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| EN 2 TEPP Total | | | | | | | | | $ - 0 |
| EN 2 Delta | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| EN 3 TEPP Total | | | | | | | | | $ - 0 |
| EN 3 Delta | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
&A
EST QTY
| Prime Contractor Price Summary - N00421-22-R-0178 | | | | | | | | | | | | | |
| Government Estimated Quantity | | | | | | | | | | | | | |
| Offeror Name: | | 0 | | | | | | | | | | | |
| ERROR:#VALUE! | | | | | | | | | | | | | |
| Government Populated - DO NOT FILL IN | | | | | BP1 | BP2 | BP3 | BP4 | BP5 | OP1 | OP2 | OP3 | Extended Services |
| TMS | CLIN | DESCRIPTION | CLIN Type | Unit | EST QTY | EST QTY | EST QTY | EST QTY | EST QTY | EST QTY | EST QTY | EST QTY | EST QTY |
| F-16 | 001X | Transition Phase-In | FFP | Months | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| F-16 | 002X | VMG O&I Maintenance | FFP | Months | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 6 |
| F-16 Fallon | 003X | Fallon F-16 Additional A/C | FFP | Each | 348 | 348 | 348 | 348 | 348 | 348 | 348 | 348 | 174 |
| F-16 Lemoore | 004X | NAS Lemoore Standup | COST | Lot | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| F-16 Lemoore | 005X | NAS Lemoore Permanent Detachment | FFP | Months | 6 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 6 |
| F-16 Lemoore | 006X | NAS Lemoore Full Site | FFP | Months | 6 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 6 |
| F-16 Lemoore | 007X | Lemoore F-16 Additional A/C | FFP | Each | 30 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 30 |
| F-16 | 008X | F-16 Aircraft Maintenance (O&A) | LH | Hours | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 2000 |
| F-16 | 009X | A/C Maintenance Overtime/Weekend/Holiday | LH | Hours | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 2000 |
| F-16 | 010X | F-16 Direct Parts/Materials | COST | Lot | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.5 |
| F-16 | 011X | F-16 Travel | COST | Lot | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.5 |
| F-16 | 012X | Technical Data | FFP | NSP | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 |
| F-16 | 013X | Transition Phase-Out | FFP | NSP | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 |
&A
TEPP
| Prime Contractor Price Summary - N00421-22-R-0178 | | | | | | | | | | | | | |
| Total Estimated Proposed Price | | | | | | | | | | | | | |
| Offeror Name: | | 0 | | | | | | | | | | | |
| ERROR:#VALUE! | | | | | | | | | | | | | |
| Auto-Populated - DO NOT FILL IN | | | BP1 | BP2 | BP3 | BP4 | BP5 | OP1 | OP2 | OP3 | | Extended Services | |
| TMS | CLIN | DESCRIPTION | Estimated Amount | Estimated Amount | Estimated Amount | Estimated Amount | Estimated Amount | Estimated Amount | Estimated Amount | Estimated Amount | Offeror Proposed Price | Estimated Amount | Total Estimated Proposed Price (TEPP) |
| F-16 | 001X | Transition Phase-In | $ - 0 | | | | | | | | $ - 0 | | $ - 0 |
| F-16 | 002X | VMG O&I Maintenance | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 Fallon | 003X | Fallon F-16 Additional A/C | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 Lemoore | 004X | NAS Lemoore Standup | $ 3,311,846.00 | | | | | | | | $ 3,311,846.00 | $ - 0 | $ 3,311,846.00 |
| F-16 Lemoore | 005X | NAS Lemoore Permanent Detachment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 Lemoore | 006X | NAS Lemoore Full Site | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 Lemoore | 007X | Lemoore F-16 Additional A/C | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 | 008X | F-16 Aircraft Maintenance (O&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 | 009X | A/C Maintenance Overtime/Weekend/Holiday | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 | 010X | F-16 Direct Parts/Materials | $ 52,300,000.00 | | | | | $ 35,400,000.00 | | | $ 87,700,000.00 | $ 5,900,000.00 | $ 93,600,000.00 |
| F-16 | 011X | F-16 Travel | $ 38,600,000.00 | | | | | $ 26,000,000.00 | | | $ 64,600,000.00 | $ 4,333,333.33 | $ 68,933,333.33 |
| F-16 | 012X | Technical Data | | | | | | | | | | | |
| F-16 | 013X | Transition Phase-Out | | | | | | | | | | | |
| F-16 Fallon | F-16 Fallon Proposed Price Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| F-16 Lemoore | F-16 Lemoore Proposed Price Total | $ 3,311,846.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 3,311,846.00 | $ - 0 | $ 3,311,846.00 |
| F-16 | F-16 Proposed Price Total | $ 90,900,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 61,400,000.00 | $ - 0 | $ - 0 | $ 152,300,000.00 | $ 10,233,333.33 | $ 162,533,333.33 |
| 0 | 0 TOTAL ESTIMATED PROPOSED PRICE AMOUNT | $ 94,211,846.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 61,400,000.00 | $ - 0 | $ - 0 | $ 155,611,846.00 | $ 10,233,333.33 | $ 165,845,179.33 |
This is the start of the file's text. The full file is on GovTribe.
