ATTACHMENT L-3 PRICE COST SUMMARY R1 - 10.20.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

This document package includes a solicitation for Fleet Readiness Center Southeast (FRCSE) support equipment maintenance services and a price cost summary template.

The solicitation seeks competitive proposals for a firm-fixed price contract to provide maintenance and repair services for all aviation support equipment assigned to FRCSE. The scope includes intermediate, operational, and depot-level repairs over a five-year ordering period. The award will be made by the Commander, Fleet Readiness Centers procurement group to a single successful small business offeror. The NAICS code is 488190 with a $35 million size standard. Questions are due by October 14th and proposals must be submitted electronically through PIEE by the date specified in the SF33.

The price cost summary template provides instructions for offerors to populate labor categories, rates, and pricing for the prime contractor and any subcontractors proposed. Cells are pre-formatted with formulas to automatically calculate pricing details.

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 L-3 - PRICE COST SUMMARY - R2 A2 -10.25.2022.xlsx XLSX spreadsheet
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
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

Text version

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.
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.

&"Times New Roman,Bold"N6852022R0042 ATTACHMENT L-3 - PRICE COST SUMMARY - Rev1

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

IGCETotal Labor PrimeTotal Labor SubTotal Fee & Profit PoolTotal Labor and Subcontractor CostTotal Service & Cost
BASE YEAR0$ - 0$ - 0$ - 0$ - 0
OPTION YEAR 10$ - 0$ - 0$ - 0$ - 0
OPTION YEAR 20$ - 0$ - 0$ - 0ERROR:#REF!
OPTION YEAR 30$ - 0$ - 0$ - 0$ - 0
OPTION YEAR 40$ - 0$ - 0$ - 0$ - 0
TOTAL0000ERROR:#REF!

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
1,920.00
***Program / Operations Manager11-1021N/A11,920.001,920$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) MechanicN/A233801,920.000$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) WorkerN/A233821,920.000$ - 0$ - 0$ - 01,920.0$ - 0
Material Coordinator (Hazard / Non Hazard)43-5061210301,920.000$ - 0$ - 0$ - 01,920.0$ - 0
Production Control ClerkN/A12701,920.000$ - 0$ - 0$ - 01,920.0$ - 0
Supply Technician43-506114101,920.000$ - 0$ - 0$ - 01,920.0$ - 0
Subtotal11,520.00$ 1,920.00$ 11,520.00$ - 0$ 11,520.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
Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 01,920.0$ - 0

Total Services & 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 0003
Period of Performance
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
1920
***Program / Operations Manager11-1021N/A11,9201,920$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) MechanicN/A233801,9200$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) WorkerN/A233821,9200$ - 0$ - 0$ - 01,920.0$ - 0
Material Coordinator (Hazard / Non Hazard)43-5061210301,9200$ - 0$ - 0$ - 01,920.0$ - 0
Production Control ClerkN/A12701,9200$ - 0$ - 0$ - 01,920.0$ - 0
Supply Technician43-506114101,9200$ - 0$ - 0$ - 01,920.0$ - 0
Subtotal11,520$ 1,920.00$ 11,520.00$ - 0$ 11,520.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 Categories00$ - 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
Subtotal0$ - 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
Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 01,920.0$ - 0

Total Services & 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 0005
Period of Performance
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
1920
***Program / Operations Manager11-1021N/A11,9201,920$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) MechanicN/A233801,9200$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) WorkerN/A233821,9200$ - 0$ - 0$ - 01,920.0$ - 0
Material Coordinator (Hazard / Non Hazard)43-5061210301,9200$ - 0$ - 0$ - 01,920.0$ - 0
Production Control ClerkN/A12701,9200$ - 0$ - 0$ - 01,920.0$ - 0
Supply Technician43-506114101,9200$ - 0$ - 0$ - 01,920.0$ - 0
Subtotal11,520$ 1,920.00$ 11,520.00$ - 0$ 11,520.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 Categories00$ - 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
Subtotal0$ - 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
Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 01,920.0$ - 0

Total Services & 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 0007
Period of Performance
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
1920
***Program / Operations Manager11-1021N/A11,9201,920$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) MechanicN/A233801,9200$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) WorkerN/A233821,9200$ - 0$ - 0$ - 01,920.0$ - 0
Material Coordinator (Hazard / Non Hazard)43-5061210301,9200$ - 0$ - 0$ - 01,920.0$ - 0
Production Control ClerkN/A12701,9200$ - 0$ - 0$ - 01,920.0$ - 0
Supply Technician43-506114101,9200$ - 0$ - 0$ - 01,920.0$ - 0
Subtotal11,520$ 1,920.00$ 11,520.00$ - 0$ 11,520.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 Categories00$ - 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
Subtotal0$ - 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
Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 01,920.0$ - 0

Total Services & 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 0009
Period of Performance
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
1920
***Program / Operations Manager11-1021N/A11,9201,920$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) MechanicN/A233801,9200$ - 0$ - 0$ - 01,920.0$ - 0
Ground Support Equipment (GSE) WorkerN/A233821,9200$ - 0$ - 0$ - 01,920.0$ - 0
Material Coordinator (Hazard / Non Hazard)43-5061210301,9200$ - 0$ - 0$ - 01,920.0$ - 0
Production Control ClerkN/A12701,9200$ - 0$ - 0$ - 01,920.0$ - 0
Supply Technician43-506114101,9200$ - 0$ - 0$ - 01,920.0$ - 0
Subtotal11,520$ 1,920.00$ 11,520.00$ - 0$ 11,520.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 Categories00$ - 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
Subtotal0$ - 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
Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 01,920.0$ - 0

Total Services & 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 .