Attachment P1 Cost Summary Spreadsheet.xlsx

46 KB Posted

Attached to
NAWCAD WOLF - Engineering Products & Technical Services Q&A
Solicitation number
N00421-20-R-0119
Issued by

About this file

Written by GovTribe AI ·

This document contains a cost summary spreadsheet template and instructions for a federal contract opportunity to provide engineering products and technical services to the Naval Air Warfare Center-Aircraft Division.

The cost summary spreadsheet template includes instructions for prime contractors and subcontractors to populate labor categories, rates, and hours by year for direct labor costs, indirect costs, fixed fee rates, subcontractor information, and other direct costs. The summary tab is to break out costs by contract line item number to match the requirements in Section B.

The related federal contract opportunity is solicitation number N00421-20-R-0119 to provide fleet support, supply support, technical support, systems improvement, development, test and evaluation, software services, and overhaul support for Air Traffic Control and Landing Systems to the Naval Air Warfare Center in Patuxent River, Maryland. The follow-on contract has a NAICS code of 541330 for engineering services and a small business size standard of $41.5M. The product service code is for maintenance, repair and rebuild of communication and detection equipment. The estimated release date for the solicitation is on SAM.gov.

View the file

Other files

File Type Posted
Q and A Solicitation N0042120R0119.docx DOCX document
Attachment P4 PPIF.pdf PDF
Attachment 5 Locator Form.pdf PDF
Attachment P2 Annual Fully Burdened Rates.xlsx XLSX spreadsheet
Attachment 2 CSP.pdf PDF
Attachment 3 OCI List.pdf PDF
Attachment 6 List of WD.pdf PDF
Exhibit A CDRLs .pdf PDF
Attachment 1 DD254.pdf PDF
Attachment 4 Data Transmittal Form.pdf PDF
Attachment P5 CPAQ Instructions.pdf PDF
EPTS FO Solicitation N0042120R0119.docx DOCX document
Attachment P3 CPAQ.pdf PDF
Show all 13

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 for Prime Contractor:
1Enter Prime offeror name into cell A3.
2Enter all prime employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3Enter all prime labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
5The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7All dollar figures shall be carried out no further than two decimal places.
8In column E, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
9Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
10For each subcontractor, enter the subcontractor name, total hours, and total amount for each period of performance.
11Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
12The prime should insert the subcontractor handling charge, if any.
13The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
14The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
15Under Other Direct Costs, the prime contractor should separate by Travel, Material and Field Services as applicable.
16Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
17On the Summary tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the Cost Summary Spreadsheet
18When submitting this file, the instructions may be deleted.
Instructions for Subcontractors:
1Enter Prime offeror name into cell A3.
Replace Prime Contractor with Subcontractor in A7, A8, A45, and A52.
2Enter all subcontractor employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3Enter all subcontractor labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
5The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7All dollar figures shall be carried out no further than two decimal places.
8In column D, f identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
9In column E, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
10Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
11For subcontractor cost summary sheets, delete Rows 54-97.
12When submitting this file, the instructions may be deleted.

N00421-20-R-0119

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET (LOE)

Prime Offeror Name:
Subcontractor(s) Name (if applicable):
Year 1Year 2Year 3Year 4Year 5Total
PositionGovernment Labor CategoryEmployee NameSCA CodeF/PSiteRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountHoursAmount
Prime Contractor Labor Cost
1General and Operations Managers (Program Manager)* SeniorEmployee Name 1GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
2General and Operations Managers (Project Manager)* JourneymanEmployee Name 2GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
3Electrical Engineers (Engineer/Scientist III) * SeniorEtc.GOVT5760.005760.00.05760.00.05760.00.05760.0028800.00.0
4Electrical Engineers (Engineer/Scientist II) * JourneymanEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
5Electrical Engineers (Engineer/Scientist I) JuniorEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
6Mechanical Engineers (Mechanical Engineer II) JourneymanEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
7Mechanical Engineers (Mechanical Engineer I) JuniorEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
8Management Analysts (Program Analyst) SeniorEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
9Management Analysts (Program Analyst) JourneymanEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
10Management Analysts (Program Analyst) JuniorEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
11Management Analysts (System Analyst) SeniorEtc.GOVT960.00960.00.0960.00.0960.00.0960.004800.00.0
12Management Analysts (System Analyst) SeniorEtc.KTR site (Norfolk)960.00960.00.0960.00.0960.00.0960.000.0
13Management Analysts (System Analyst) JourneymanEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
14Information Security Analysts (Informational Management and Technology Analyst) JourneymanEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
15Network and Computer Systems Administrators (System Administrator) SeniorEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
16Network and Computer Systems Administrators (System Administrator) JourneymanEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
17Network and Computer Systems Administrators (System Administrator) JuniorEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
18General and Operations Managers (On-Site Logistics Lead)* SeniorEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
19Management Analysts (Logistics Analyst) SeniorEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
20Management Analysts (Logistics Analyst) JourneymanEtc.GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
21Management Analysts (Logistics Analyst) JuniorEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
22Budget Analysts (Cost Analyst) JourneymanEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
23First-Line Supervisors of Helpers, Labors, and Material Movers, Hand JourneymanEtc.GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
24Engineering Technician VI*Etc.30086GOVT8640.008640.00.08640.00.08640.00.08640.0043200.00.0
25Engineering Technician VI*Etc.30086GOVT960.00960.00.0960.00.0960.00.0960.004800.00.0
26Engineering Technician V*Etc.30085GOVT3456.003456.00.03456.00.03456.00.03456.0017280.00.0
27Engineering Technician V*Etc.30085KTR site (Norfolk)1728.001728.00.01728.00.01728.00.01728.008640.00.0
28Engineering Technician V*Etc.30085GOVT384.00384.00.0384.00.0384.00.0384.001920.00.0
29Engineering Technician V* (OT)Etc.30085KTR site (Norfolk)192.00192.00.0192.00.0192.00.0192.00960.00.0
30Engineering Technician IVEtc.30084GOVT10368.0010368.00.010368.00.010368.00.010368.0051840.00.0
31Engineering Technician IVEtc.30084KTR site (San Diego)1728.001728.00.01728.00.01728.00.01728.008640.00.0
32Engineering Technician IVEtc.30084GOVT1152.001152.00.01152.00.01152.00.01152.005760.00.0
33Engineering Technician IV (OT)Etc.30084KTR site (San Diego)192.00192.00.0192.00.0192.00.0192.00960.00.0
34Engineering Technician IV (Electronic-Mechanic Quality, IV)Etc.30084GOVT960.00960.00.0960.00.0960.00.0960.004800.00.0
35Engineering Technician IV (Electronic-Mechanic Quality, IV)Etc.30084KTR site (San Diego)2880.002880.00.02880.00.02880.00.02880.0014400.00.0
36Engineering Technician IV (Electronic-Mechanic Assembler, IV)Etc.30084GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
37Engineering Technician III (Electronic-Mechanic Assembler III)Etc.30083GOVT5760.005760.00.05760.00.05760.00.05760.0028800.00.0
38Engineering Technician II (Electronic-Mechanic Assembler II)Etc.30082GOVT5760.005760.00.05760.00.05760.00.05760.0028800.00.0
39Engineering Technician I (Electronic-Mechanic Assembler I)Etc.30081GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
40Engineering Technician IIIEtc.30083GOVT6912.006912.00.06912.00.06912.00.06912.0034560.00.0
41Engineering Technician IIIEtc.30083GOVT768.00768.00.0768.00.0768.00.0768.003840.00.0
42Electronics Technician Maintenance IIIEtc.23183GOVT6144.006144.00.06144.00.06144.00.06144.0030720.00.0
43Electronics Technician Maintenance IIIEtc.23183KTR site (Norfolk)960.00960.00.0960.00.0960.00.0960.004800.00.0
44Electronics Technician Maintenance IIIEtc.23183GOVT768.00768.00.0768.00.0768.00.0768.003840.00.0
45Electronics Technician Maintenance III (OT)Etc.23183KTR site (Norfolk)192.00192.00.0192.00.0192.00.0192.00960.00.0
46Electronics Technician Maintenance IIEtc.23182GOVT3456.003456.00.03456.00.03456.00.03456.0017280.00.0
47Electronics Technician Maintenance IIEtc.23182GOVT384.00384.00.0384.00.0384.00.0384.001920.00.0
48Electronics Technician Maintenance IEtc.23181GOVT3456.003456.00.03456.00.03456.00.03456.0017280.00.0
49Electronics Technician Maintenance IEtc.23181GOVT384.00384.00.0384.00.0384.00.0384.001920.00.0
50Administrative AssistantEtc.01020GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
51Drafter/CAD Operator IVEtc.30064GOVT3840.003840.00.03840.00.03840.00.03840.0019200.00.0
52Drafter/CAD Operator III**Etc.30063GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
53Supply TechnicianEtc.01410GOVT2688.002688.00.02688.00.02688.00.02688.0013440.00.0
54Supply TechnicianEtc.01410KTR site (St Mary's County)960.00960.00.0960.00.0960.00.0960.004800.00.0
55Supply Technician01410GOVT384.00384.00.0384.00.0384.00.0384.001920.00.0
56Supply Technician (OT)01410KTR site (St Mary's County)192.00192.00.0192.00.0192.00.0192.00960.00.0
57Material Coordinator21030GOVT2688.002688.00.02688.00.02688.00.02688.0013440.00.0
58Material Coordinator21030KTR site (St Mary's County)2688.002688.00.02688.00.02688.00.02688.0013440.00.0
59Material Coordinator21030GOVT384.00384.00.0384.00.0384.00.0384.001920.00.0
60Material Coordinator (OT)21030KTR site (St Mary's County)384.00384.00.0384.00.0384.00.0384.001920.00.0
61Warehouse Specialist/Warehouse Worker21410GOVT2688.002688.00.02688.00.02688.00.02688.0013440.00.0
62Warehouse Specialist/Warehouse Worker21410KTR site (St Mary's County)2688.002688.00.02688.00.02688.00.02688.0013440.00.0
63Warehouse Specialist/Warehouse WorkerEtc.21410GOVT384.00384.00.0384.00.0384.00.0384.001920.00.0
64Warehouse Specialist/Warehouse Worker (OT)Etc.21410KTR site (St Mary's County)384.00384.00.0384.00.0384.00.0384.001920.00.0
65General Clerk IIIEtc.01113GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
66General Clerk IIEtc.01112GOVT960.00960.00.0960.00.0960.00.0960.004800.00.0
67General Clerk IIEtc.01112KTR site (San Diego)960.00960.00.0960.00.0960.00.0960.004800.00.0
68General Clerk IEtc.01111GOVT1920.001920.00.01920.00.01920.00.01920.009600.00.0
Total Direct Labor Cost164736.00.00.0164736.00.00.0164736.00.00.0164736.00.00.0164736.00823680.00.0
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost00000ERROR:#REF!
Total Direct and Indirect Labor cost00000ERROR:#REF!
COM
Total Prime Contractor Labor Cost00000ERROR:#REF!
Subcontractor Labor Cost
Subcontractor proposed cost and fee
1Subcontractor Name 100000ERROR:#REF!ERROR:#REF!
2Subcontractor Name 200000ERROR:#REF!ERROR:#REF!
3Etc.00000ERROR:#REF!ERROR:#REF!
4Etc.00000ERROR:#REF!ERROR:#REF!
5Etc.00000ERROR:#REF!ERROR:#REF!
6Etc.00000ERROR:#REF!ERROR:#REF!
7Etc.00000ERROR:#REF!ERROR:#REF!
8Etc.00000ERROR:#REF!ERROR:#REF!
9Etc.00000ERROR:#REF!ERROR:#REF!
10Etc.00000ERROR:#REF!ERROR:#REF!
11Etc.00000ERROR:#REF!ERROR:#REF!
12Etc.00000ERROR:#REF!ERROR:#REF!
13Etc.00000ERROR:#REF!ERROR:#REF!
14Etc.00000ERROR:#REF!ERROR:#REF!
15Etc.00000ERROR:#REF!ERROR:#REF!
16Etc.00000ERROR:#REF!ERROR:#REF!
17Etc.00000ERROR:#REF!ERROR:#REF!
18Etc.00000ERROR:#REF!ERROR:#REF!
19Etc.00000ERROR:#REF!ERROR:#REF!
20Etc.00000ERROR:#REF!ERROR:#REF!
21Etc.00000ERROR:#REF!ERROR:#REF!
22Etc.00000ERROR:#REF!ERROR:#REF!
23Etc.00000ERROR:#REF!ERROR:#REF!
24Etc.00000ERROR:#REF!ERROR:#REF!
25Etc.00000ERROR:#REF!ERROR:#REF!
26Etc.00000ERROR:#REF!ERROR:#REF!
27Etc.00000ERROR:#REF!ERROR:#REF!
28Etc.00000ERROR:#REF!ERROR:#REF!
29Etc.00000ERROR:#REF!ERROR:#REF!
30Etc.00000ERROR:#REF!ERROR:#REF!
31Etc.00000ERROR:#REF!ERROR:#REF!
32Etc.00000ERROR:#REF!ERROR:#REF!
33Etc.00000ERROR:#REF!ERROR:#REF!
34Etc.00000ERROR:#REF!ERROR:#REF!
35Etc.00000ERROR:#REF!ERROR:#REF!
36Etc.00000ERROR:#REF!ERROR:#REF!
37Etc.00000ERROR:#REF!ERROR:#REF!
38Etc.00000ERROR:#REF!ERROR:#REF!
39Etc.00000ERROR:#REF!ERROR:#REF!
40Etc.00000ERROR:#REF!ERROR:#REF!
41Etc.00000ERROR:#REF!ERROR:#REF!
42Etc.00000ERROR:#REF!ERROR:#REF!
43Etc.00000ERROR:#REF!ERROR:#REF!
44Etc.00000ERROR:#REF!ERROR:#REF!
45Etc.00000ERROR:#REF!ERROR:#REF!
46Etc.00000ERROR:#REF!ERROR:#REF!
47Etc.00000ERROR:#REF!ERROR:#REF!
48Etc.00000ERROR:#REF!ERROR:#REF!
49Etc.00000ERROR:#REF!ERROR:#REF!
50Etc.00000ERROR:#REF!ERROR:#REF!
Total proposed subcontractor labor cost and fee00000ERROR:#REF!ERROR:#REF!
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass throughERROR:#REF!

Total Labor Cost (Prime and Subcontractor Labor)

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor
Prime Contractor Fee for Subcontractor Labor *
Total Fee (for Prime and Subcontractor Labor)

Total Labor Cost Plus Fixed Fee (CPFF) ERROR:#REF!

Other Direct Costs
Other Direct Costs (ODCs)
Any adders to ODCs such as G&A (cost only - no fee)
Total ODCs

Total CPFF all CLINs (Labor and ODCs) ERROR:#REF!

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All YearsAmountPercent
Subcontractor proposed cost and feeERROR:#REF!
Pass Through Amount (not including fee)$0
Prime Contractor Fee for Subcontractor Labor *$0
Total Pass Through Amount (including fee)$0ERROR:#REF!
Fee Analysis - Total for All YearsAmountPercent
Prime Contractor Labor CostERROR:#REF!
Fixed Fee for Labor Performed by Prime Contractor$0ERROR:#REF!

Solicitation N00421-20-R-0119 Page &P &F

KTR: (name) Source Selection Information - See: FAR 2.101 and 3.104 RFP:

Summary CLIN Summary Sheet

CLINS CLIN Description Total Hours Total Cost Total Fixed Fee Total Value $

Total

N00421-20-R-0119 P1 Cost Summary

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