ATTACHMENT L-3 - PRICE COST SUMMARY - R2 A2 -10.25.2022.xlsx

XLSX spreadsheet 1 MB Posted

Attached to
Fleet Readiness Center Southeast (FRCSE) - Support Equipment Maintenance Follow-On
Solicitation number
N6852022R0042
Issued by

About this file

Written by GovTribe AI ·

This document includes an Excel pricing template and instructions for a firm fixed price solicitation seeking aviation support equipment maintenance services. The Naval Air Systems Command is soliciting proposals for a follow-on contract to maintain all aviation support equipment assigned to the Fleet Readiness Center Southeast in Jacksonville, Florida. The scope of work includes intermediate, operational, and depot-level repairs over a five-year ordering period. The solicitation is set aside for small businesses under NAICS code 488190 with a size standard of $35 million. Electronic proposals are due by the date and time specified in the RFP. Offerors must complete the pricing template and include rates for labor categories, overhead, G&A, and fixed fee. Subcontractor costs must also be included if applicable.

View the file

Other files

File Type Posted
N6852022R0042 - RFP - 09.30.2022.pdf PDF
N6852022R0042 - AMENDMENT 005 - 11.15.2022.pdf PDF
N6852022R0042 - Amendment 004 - 11.04.2022.pdf PDF
SECTION L - Version 1.9 - R2 A4 - 11.04.2022.pdf PDF
ATTACHMENT L-3 - PRICE COST SUMMARY - R3 A4 - 11.04.2022.xlsx XLSX spreadsheet
ATTACHMENT 01 - PWS R3 A4 - 11.04.2022.pdf PDF
N6852022R0042 - AMENDMENT 003 - 11.02.2022.docx.pdf PDF
N6852022R0042 - RFP - Q_A - A3 - 11.02.2022.pdf PDF
ATTACHMENT 01 - PWS R2 A2 - 10.25.2022.pdf PDF
ATTACHMENT 04 - MANNING MATRIX R1 A2 - 10-25-2022.xlsx XLSX spreadsheet
N6852022R0042 - RFP - AMENDMENT 002 - 10.25.2022.pdf PDF
ATTACHMENT 05 - WD 2022-0141 R1 A2 - 10.25.2022.pdf PDF
N6852022R0042 - RFP - Q_A - A2 - 10.25.2022.pdf PDF
ATTACHMENT 01 - PWS R1 - 10.21.2022.pdf PDF
ATTACHMENT L-1 PP DATA SHEET R1 - 10.20.2022.xlsx XLSX spreadsheet
ATTACHMENT L-3 PRICE COST SUMMARY R1 - 10.20.2022.xlsx XLSX spreadsheet
N6852022R0042 - RFP - AMENDMENT 001 - 10.21.2022.pdf PDF
N6852022R0042 RFP Q_A - 10.21.2022.pdf PDF
N6852022R0042_RFP QUESTIONS_ANSWERS.docx DOCX document
ATTACHMENT 05 - WD - 2022-0141(Rev1)-06.30.2022.docx DOCX document
ATTACHMENT 04 - MANNING MATRIX.xlsx XLSX spreadsheet
N6852022R0042 - RFP - FRCSE ASE MRO - 09.30.2022 - SAMs.pdf PDF
ATTACHMENT 01 - PWS.pdf PDF
ATTACHMENT L-1 - PP DATA SHEET.xlsx XLSX spreadsheet
EXHIBIT A - Contract Data Requirement List - CDRLs - A001-A003.pdf PDF
ATTACHMENT L-2 - PP QUESTIONNAIRE.docx DOCX document
ATTACHMENT L-3 - PRICE COST SUMMARY.xlsx XLSX spreadsheet
ATTACHMENT 02 - QUALITY PROGRAM PLAN.docx DOCX document
ATTACHMENT 03 - GFP.xlsx XLSX spreadsheet
Show all 29

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

INSTRUCTIONS
Contractor:
1All cells colored "blue" contains a formula and should not be edited.
2All dollar figures shall be carried out no further than two decimal places.
3Fill out rows 2-7
4In Column A rows 11-16, for the prime contractor P6 submittal, the Government Labor Categories are listed by location (Green lines), if the contractor needs to propose more labor categories for the prime please include below row 16, but ensure integrity of the formulas. For each subcontractor (yellow lines), enter the Government Labor category by for Jacksonville. If subcontractor P6 submittal, please change cell A25 to subcontractor name. If the contractor needs to propose more labor categories for subcontractors please include below row 31, but ensure integrity of the formulas.
5In Cell B7 enter the period of performance on each worksheet.
6In column D: enter the proposed number of employees for each labor category.
7In column E: identify for each individual proposed whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
8In column F: identify for each labor category the FFP Regular Labor Hours Per Year.
9In column G: populates total number of FFP Regular Labor Hours Per Year.
10In column H: enter the unburdened labor rate for each individual
11In column I: populates proposed rates * proposed hours.
12Cell H18: Insert the full-time fringe rate, if it is not included in its overhead rate.
13Cell H19: the part-time fringe rate, if it is not included in its overhead rate.
14Cell H22: Insert the overhead rate for work performed at the Government's facility.
15Cell H23: Insert the G&A rate being applied.
16Cell G26, the prime shall enter the fully burdened labor rates for all individuals proposed by subcontractors. The fully burdened labor rate includes fixed fee, per labor CLIN/Appropriation. NOTE: If Joint Ventures (JV) are included, and the JV member cost details are proprietary, the Prime Contractor shall identify each JV member fully-burdened cost in the Subcontractors section (yellow) of the ATTACHMENT L3 – PRICE COST SUMMARY. Then, each JV member is responsible for submitting their own cost build-up details, if proprietary, via a separate L-3 directly to the Government.
17Cell H33: Insert the prime's subcontractor handling charge, if any.
18Cell H36: Insert the prime's fixed fee rate applied to its labor cost excluding subcontractor labor.
19Cell H37: Insert the prime's fixed fee rate applied to the subcontractor labor, if any.
20Cell J40-41: formulate cost build-up
21Column "L" automatically calculated the total hours.
22Column "M" is a summation of the costs.
23Cell M44: is Total Services & Cost.
24If there is not going to be any data entry in a row or group of rows, hide the rows. Do not delete any rows or columns.
25The summary sheet calculates by pulling in data from the specified corresponding cells in each worksheet, ensure that the labor categories rows are consistent on each worksheet and with the Summary Sheet.
26When submitting this file, the instructions may be deleted.
27Note: Cell and row numbering above may change if more rows are added in prime contractor and/or subcontractor sections.

Summary SOLICITATION N68520-22-R-0042 SOLICICITATION TYPE: Firm Fixed Price (FFP)

IGCETotal Labor (Prime & Sub)Total Fee & Profit PoolTotal Labor and Subcontractor CostTotal Cost
BASE YEAR0$ - 0$ - 0$ - 0
OPTION YEAR 10$ - 0$ - 0$ - 0
OPTION YEAR 20$ - 0$ - 0$ - 0
OPTION YEAR 30$ - 0$ - 0$ - 0
OPTION YEAR 40$ - 0$ - 0$ - 0
CONTRACT TOTAL0000

BP

SOLICITATIONN68520-22-R-0042SOLICICITATION TYPE: Firm Fixed Price (FFP)
Offeror/Company Name
Offerors/Company Address
Point of Contact & Phone Number
Cage Code
Base Year 1 (BP1)CLIN 0001
Period of Performance25 January 2023 - 24 January 2024
SERVICES - PRIME CONTRACTOR
LABOR CATEGORIES (* = key)Gov't Skill TypeOfferor's Proposed Number of Whole Heads FFP (FTEs)Full Time (F) or Part Time (P)FFP Regular Labor Hours Per YearTotal Labor HoursRateRate * Labor HoursSubtotalSUMTotal
2,080.00
***Program / Operations Manager11-1021N/A12,080.002,080$ - 0$ - 0$ - 02,080.0$ - 0
Ground Support Equipment (GSE) MechanicN/A2338002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Ground Support Equipment (GSE) WorkerN/A2338202,080.000$ - 0$ - 0$ - 0- 0$ - 0
Material Coordinator (Hazard / Non Hazard)43-50612103002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Production Control ClerkN/A127002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Supply Technician43-5061141002,080.000$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
Subtotal12,480.00$ 2,080.00$ - 0$ - 0$ 2,080.00$ - 0
Indirect Cost - Fringe Fulltime0.00%$ - 0$ - 0$ - 0
Indirect Cost - Fringe Part Time0.00%$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0
Base
Overhead0.00%$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0
SUB CONTRACTOR
Labor Categories- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
Subtotal- 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prime Subcontractor Handling0.00%$ - 0$ - 0
Total Labor Sub$ - 0$ - 0
Fee/Profit - prime0.00%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.00%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor (Prime & Sub)$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor Cost & Profit2,080.0$ - 02,080.0$ - 0

Total Cost - 0 $ - 0

Attachment_P6_CLIN_Breakout_Spreadsheet (RFP# N6852022R0001 &A

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104 RFP:N00421-17-R-0031

OP1

SOLICITATIONN68520-22-R-0042SOLICICITATION TYPE: Firm Fixed Price (FFP)
Offeror/Company Name
Offerors/Company Address
Point of Contact & Phone Number
Cage Code
Base Year 1 (BP1)CLIN 0001
Period of Performance25 January 2023 - 24 January 2024
SERVICES - PRIME CONTRACTOR
LABOR CATEGORIES (* = key)Gov't Skill TypeOfferor's Proposed Number of Whole Heads FFP (FTEs)Full Time (F) or Part Time (P)FFP Regular Labor Hours Per YearTotal Labor HoursRateRate * Labor HoursSubtotalSUMTotal
2,080.00
***Program / Operations Manager11-1021N/A12,080.002,080$ - 0$ - 0$ - 02,080.0$ - 0
Ground Support Equipment (GSE) MechanicN/A2338002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Ground Support Equipment (GSE) WorkerN/A2338202,080.000$ - 0$ - 0$ - 0- 0$ - 0
Material Coordinator (Hazard / Non Hazard)43-50612103002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Production Control ClerkN/A127002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Supply Technician43-5061141002,080.000$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
Subtotal12,480.00$ 2,080.00$ - 0$ - 0$ 2,080.00$ - 0
Indirect Cost - Fringe Fulltime0.00%$ - 0$ - 0$ - 0
Indirect Cost - Fringe Part Time0.00%$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0
Base
Overhead0.00%$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0
SUB CONTRACTOR
Labor Categories- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
Subtotal- 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prime Subcontractor Handling0.00%$ - 0$ - 0
Total Labor Sub$ - 0$ - 0
Fee/Profit - prime0.00%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.00%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor (Prime & Sub)$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor Cost & Profit2,080.0$ - 02,080.0$ - 0

Total Cost - 0 $ - 0

Attachment_P6_CLIN_Breakout_Spreadsheet (RFP# N6852022R0001

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104 RFP:N00421-17-R-0031

OP2

SOLICITATIONN68520-22-R-0042SOLICICITATION TYPE: Firm Fixed Price (FFP)
Offeror/Company Name
Offerors/Company Address
Point of Contact & Phone Number
Cage Code
Base Year 1 (BP1)CLIN 0001
Period of Performance25 January 2023 - 24 January 2024
SERVICES - PRIME CONTRACTOR
LABOR CATEGORIES (* = key)Gov't Skill TypeOfferor's Proposed Number of Whole Heads FFP (FTEs)Full Time (F) or Part Time (P)FFP Regular Labor Hours Per YearTotal Labor HoursRateRate * Labor HoursSubtotalSUMTotal
2,080.00
***Program / Operations Manager11-1021N/A12,080.002,080$ - 0$ - 0$ - 02,080.0$ - 0
Ground Support Equipment (GSE) MechanicN/A2338002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Ground Support Equipment (GSE) WorkerN/A2338202,080.000$ - 0$ - 0$ - 0- 0$ - 0
Material Coordinator (Hazard / Non Hazard)43-50612103002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Production Control ClerkN/A127002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Supply Technician43-5061141002,080.000$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
Subtotal12,480.00$ 2,080.00$ - 0$ - 0$ 2,080.00$ - 0
Indirect Cost - Fringe Fulltime0.00%$ - 0$ - 0$ - 0
Indirect Cost - Fringe Part Time0.00%$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0
Base
Overhead0.00%$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0
SUB CONTRACTOR
Labor Categories- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
Subtotal- 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prime Subcontractor Handling0.00%$ - 0$ - 0
Total Labor Sub$ - 0$ - 0
Fee/Profit - prime0.00%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.00%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor (Prime & Sub)$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor Cost & Profit2,080.0$ - 02,080.0$ - 0

Total Cost - 0 $ - 0

Attachment_P6_CLIN_Breakout_Spreadsheet (RFP# N6852022R0001

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104 RFP:N00421-17-R-0031

OP3

SOLICITATIONN68520-22-R-0042SOLICICITATION TYPE: Firm Fixed Price (FFP)
Offeror/Company Name
Offerors/Company Address
Point of Contact & Phone Number
Cage Code
Base Year 1 (BP1)CLIN 0001
Period of Performance25 January 2023 - 24 January 2024
SERVICES - PRIME CONTRACTOR
LABOR CATEGORIES (* = key)Gov't Skill TypeOfferor's Proposed Number of Whole Heads FFP (FTEs)Full Time (F) or Part Time (P)FFP Regular Labor Hours Per YearTotal Labor HoursRateRate * Labor HoursSubtotalSUMTotal
2,080.00
***Program / Operations Manager11-1021N/A12,080.002,080$ - 0$ - 0$ - 02,080.0$ - 0
Ground Support Equipment (GSE) MechanicN/A2338002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Ground Support Equipment (GSE) WorkerN/A2338202,080.000$ - 0$ - 0$ - 0- 0$ - 0
Material Coordinator (Hazard / Non Hazard)43-50612103002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Production Control ClerkN/A127002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Supply Technician43-5061141002,080.000$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
Subtotal12,480.00$ 2,080.00$ - 0$ - 0$ 2,080.00$ - 0
Indirect Cost - Fringe Fulltime0.00%$ - 0$ - 0$ - 0
Indirect Cost - Fringe Part Time0.00%$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0
Base
Overhead0.00%$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0
SUB CONTRACTOR
Labor Categories- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
Subtotal- 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prime Subcontractor Handling0.00%$ - 0$ - 0
Total Labor Sub$ - 0$ - 0
Fee/Profit - prime0.00%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.00%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor (Prime & Sub)$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor Cost & Profit2,080.0$ - 02,080.0$ - 0

Total Cost - 0 $ - 0

Attachment_P6_CLIN_Breakout_Spreadsheet (RFP# N6852022R0001

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104 RFP:N00421-17-R-0031

OP4

SOLICITATIONN68520-22-R-0042SOLICICITATION TYPE: Firm Fixed Price (FFP)
Offeror/Company Name
Offerors/Company Address
Point of Contact & Phone Number
Cage Code
Base Year 1 (BP1)CLIN 0001
Period of Performance25 January 2023 - 24 January 2024
SERVICES - PRIME CONTRACTOR
LABOR CATEGORIES (* = key)Gov't Skill TypeOfferor's Proposed Number of Whole Heads FFP (FTEs)Full Time (F) or Part Time (P)FFP Regular Labor Hours Per YearTotal Labor HoursRateRate * Labor HoursSubtotalSUMTotal
2,080.00
***Program / Operations Manager11-1021N/A12,080.002,080$ - 0$ - 0$ - 02,080.0$ - 0
Ground Support Equipment (GSE) MechanicN/A2338002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Ground Support Equipment (GSE) WorkerN/A2338202,080.000$ - 0$ - 0$ - 0- 0$ - 0
Material Coordinator (Hazard / Non Hazard)43-50612103002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Production Control ClerkN/A127002,080.000$ - 0$ - 0$ - 0- 0$ - 0
Supply Technician43-5061141002,080.000$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0- 0$ - 0
Subtotal12,480.00$ 2,080.00$ - 0$ - 0$ 2,080.00$ - 0
Indirect Cost - Fringe Fulltime0.00%$ - 0$ - 0$ - 0
Indirect Cost - Fringe Part Time0.00%$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0
Base
Overhead0.00%$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0
SUB CONTRACTOR
Labor Categories- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
- 00$ - 0$ - 0$ - 0- 0$ - 0
Subtotal- 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prime Subcontractor Handling0.00%$ - 0$ - 0
Total Labor Sub$ - 0$ - 0
Fee/Profit - prime0.00%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.00%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor (Prime & Sub)$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor Cost & Profit2,080.0$ - 02,080.0$ - 0

Total Cost - 0 $ - 0

Attachment_P6_CLIN_Breakout_Spreadsheet (RFP# N6852022R0001

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104 RFP:N00421-17-R-0031

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