ATTACHMENT L-3 - PRICE COST SUMMARY.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 price cost summary template and related federal contract opportunity notice for fleet readiness center support services. The price cost summary template provides instructions for offerors to submit fixed-price proposals for aviation support equipment maintenance and repair labor categories over a five year ordering period. Labor categories include a program manager, mechanics, workers, coordinators and technicians. The contract will be awarded on a 100% small business 8(a) set-aside basis. Offerors must submit all proposal volumes electronically by the deadline of October 28, 2022 specified in the solicitation. The federal contract opportunity is solicitation number N6852022R0042 seeking proposals for Fleet Readiness Center Southeast support equipment maintenance and repair services awarded on a firm-fixed price basis by the Command Fleet Readiness Centers procurement group.

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
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 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:
1Any cell colored "blue" contains a formula and should not be edited.
2All dollar figures shall be carried out no further than two decimal places.
3All dollar figures shall be carried out no further than two decimal places.
4In Column A, for the prime contractor P6 submittal, the Government Labor Categories are listed by location (Green lines). For each subcontractor (yellow lines), enter the Government Labor category by location. If subcontractor P6 submittal, please change cell A25 to subcontractor name
5In Cell B7 enter the period of performance on each worksheet.
6In Column D, for the prime (or subcontractor's direct P6 submittal) own workforce, the field is colored "green" indicating no input needed. (This reflects that the prime contractor is proposing its own employees, contingency hires-, or prospective hires - it does not include any subcontractors.) The subcontractors fields are in yellow and are prenumbered. Please note if more subcontractors are needed, the contractor may add additional Sections and rows to accommodate them, but ensure integrity of the formulas.
7In column F, 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 I (prime P6 or subcontractor direct P6 submittal to formulate cost build-up):
9(a) enter the unburdened labor rate for each individual
10(b)Insert the full-time fringe rate, if it is not included in its overhead rate.
11(c) Insert the part-time fringe rate, if it is not included in its overhead rate.
12(d) Insert the overhead rate for work performed at the Government's facility.
13(e) Insert the G&A rate being applied.
14(f) Beginning with Cell 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.
15(g) Insert the prime's subcontractor handling charge, if any.
16(h) Insert the prime's fixed fee rate applied to its labor cost excluding subcontractor labor.
17(i) Insert the prime's fixed fee rate applied to the subcontractor labor, if any.
18(j) Insert the prime's material handling and G&A rates, respectively, that will be applied to the Material CLIN. If not applying a material handling or G&A, these cells should be left blank.
19(k) Insert the prime's G&A rate that will be applied to the Travel CLIN. If not applying a G&A rate, the cell should be left blank.
20In column K (prime P6 or subcontractor direct P6 submittal to formulate cost build-up):
21(a) Enter the hours proposed for each individual labor category for column H
22(b) Insert the "labor base" to apply the full-time fringe rate, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
23(c) Insert the "labor base" to apply the part-time fringe rate, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
24(d) Insert the "labor base" to apply the contractor's facility overhead rate.
25(e) Insert the "labor base" to apply the Client/Gov't site overhead rate.
26(f) Insert the "labor base" to apply the G&A rate.
27(g) Insert the "labor base" to the fixed fee rate for prime P6 submittal or subcontractor direct P6 submittal (if prime P6 submittal, this shall exclude subcontractor labor).
28(h) Insert the prime contractor's subcontractor "labor base" to apply its fixed fee rate, if any.
29Column "M" automatically calculated the total hours.
30Column "N" is a summation of the costs.
31If 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.
32The 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.
33When submitting this file, the instructions may be deleted.
34Note: 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)

IGCELabor Hours (Prime)Labor Cost (Prime)Total FringeTotal OverheadTotal G&ATotal Labor (Prime)Labor Hours (Sub)Fee/ProfitTotal Labor and SubTotal Cost
BASE YEAR1,920$ 11,520.00$ - 0$ - 0$ - 0$ 11,520.000$ - 0$ - 0$ - 0
OPTION YEAR 11,920$ 11,520.00$ - 0$ - 0$ - 0$ 11,520.000$ - 0$ - 0$ - 0
OPTION YEAR 21,920$ 11,520.00$ - 0$ - 0$ - 0$ 11,520.000$ - 0$ - 0$ - 0
OPTION YEAR 31,920$ 11,520.00$ - 0$ - 0$ - 0$ 11,520.000$ - 0$ - 0$ - 0
OPTION YEAR 41,920$ 11,520.00$ - 0$ - 0$ - 0$ 11,520.000$ - 0$ - 0$ - 0
TOTAL9,60057,60000057,600000$ - 0

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 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
Total Subcontractors- 0- 0- 0- 0- 0
Subcontractor Handling0.00%$ - 0$ - 0
Subtotal$ - 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 Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 0-0$ - 0

Grand 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
Option Period 1 (OP1)CLIN 0002
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 HoursSUMTotal
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
Total Subcontractors- 0- 0- 0- 0- 0
Subcontractor Handling0.00%$ - 0$ - 0
Subtotal$ - 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 Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 0-0$ - 0

Grand Total Services & ODCs - 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
Option Period 2 (BP2)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 HoursSUMTotal
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
Total Subcontractors- 0- 0- 0- 0- 0
Subcontractor Handling0.00%$ - 0$ - 0
Subtotal$ - 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 Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 0-0$ - 0

Grand Total Services & ODCs - 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
Option Period 2 (BP2)CLIN 0004
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 HoursSUMTotal
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
Total Subcontractors- 0- 0- 0- 0- 0
Subcontractor Handling0.00%$ - 0$ - 0
Subtotal$ - 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 Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 0-0$ - 0

Grand Total Services & ODCs - 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
Option Period 2 (BP2)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 HoursSUMTotal
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
Total Subcontractors- 0- 0- 0- 0- 0
Subcontractor Handling0.00%$ - 0$ - 0
Subtotal$ - 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 Cost$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0
Total Labor and Subcontractor1,920.0$ - 0-0$ - 0

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