Attachment P1 - Cost Summary Sheet Amd1.xlsx

XLSX spreadsheet 51 KB Posted

Attached to
Rapid Operations Material Management (ROMM) RFP Federal contract opportunity
Solicitation number
N0042124R0041
Issued by
Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

This document appears to be a Cost Summary Spreadsheet (LOE) related to a federal contract opportunity. It provides detailed instructions for prime contractors and subcontractors to complete the cost proposal, including guidelines for entering labor categories, rates, hours, and indirect costs. The spreadsheet template includes rows for various labor categories with government-provided minimum direct labor rates and places of performance. Prime contractors and subcontractors are instructed to fill in their proposed labor rates, hours, and total costs by period of performance. The document also outlines requirements for calculating other direct costs, fixed fees, and CLIN summaries. This cost spreadsheet is related to Solicitation N0042124R0041 for the Rapid Operations Material Management (ROMM) RFP, which is due by September 9, 2024.

View the file

Other files for this federal contract opportunity

Other files attached to Rapid Operations Material Management (ROMM) RFP, newest first.
File Type Posted
Amendment 0001 RFP Q and A.pdf PDF
N0042124R0041 AMD 2 CONFORMED.pdf PDF
N0042124R0041 AMD 2.pdf PDF
N0042124R0041 Amendment 1 03Sept2024.pdf PDF
Attachment P2 - Annual Fully Burnened Rates Amd1.xlsx XLSX spreadsheet
RFP Questions and Answers.pdf PDF
N0042124R004 Amd1 conformed.pdf PDF
Exhibit A_CDRLs Amd1.pdf PDF
Base Access Form.pdf PDF
ROMM_Registration Form.docx DOCX document
Solicitation N0042124R0041.pdf PDF
Attachment 7 - Wage Determination 2015-5635.pdf PDF
Attachment 1 - DD 254 BID.pdf PDF
Attachment 5 - Locator Form.pdf PDF
Attachment P2 - Annual Fully Burnened Rates.xlsx XLSX spreadsheet
Attachment 3 -Data Item Transmittal Form.docx DOCX document
Attachment P1 - Cost Summary Sheet.xlsx XLSX spreadsheet
Attachment 4 - OCI List.docx DOCX document
Attachment 2 - CSP.docx DOCX document
Exhibit A - CDRLS.docx DOCX document
Attachment 9 - Wage Determination 2015-4341.pdf PDF
Attachment 8 - Wage Determination 2015-4377.pdf PDF
Attachment 6 - Wage Determination 2015-4279.pdf PDF
Show all 23

On GovTribe

Work with this file on GovTribe

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

Text version

Instructions

Instructions for Prime Contractor:
1Enter Prime offeror name into cell B3.
2Enter all prime employee names in Column C (starting at row 10) If necessary, insert additional rows--but ensure integrity of formulas.
3Enter Current, Contingent, or Prospective in Column D (starting at row 10)
4Labor 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.
5Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
6The 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.
7All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
8All dollar figures shall be carried out no further than two decimal places.
9In Column E, the Government has listed whether the labor category falls under Regular Work or Overtime.
10In Column F, the Government has listed the BLS Code applicable to that Labor Category.
11In Column G, the Government has listed the SCA Code applicable to that Labor Category.
12In column H, 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.
13In column I, the Government has listed the place of performance applicable to that Labor Category.
14In Columns J, N, R, V, and Z, the Government has listed the Minimum Direct Labor Rate applicable to that Labor Category. If the Labor Category falls under SCA, the Government used the minimum direct labor rate per the SCA Code listed in Column G as seen in the applicable WD. If the Labor Category does not fall under SCA, the Government used a minimum direct labor rate per the BLS Code listed in Column F.
15In Columns K, O, S, W, and AA, insert the proposed direct labor rate applicable to that Labor Category.
16Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
17For each subcontractor, enter the subcontractor name, labor category the subcontractor will be performing, total hours, and total amount for each period of performance.
18Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
19The prime should insert the subcontractor handling charge, if any.
20The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
21The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
22Under Other Direct Costs, the prime contractor should separate by Travel, Material, and Field Services as applicable.
23Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
24On 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
25When submitting this file, the instructions may be deleted.
Instructions for Subcontractors:
1Enter Prime offeror name into cell B3.
Enter Subcontractor offeror name into cell B4.
2Replace Prime Contractor with Subcontractor in cells B7, and any other applicable cells.
3Enter all subcontractor employee names in Column C (starting at row 10) If necessary, insert additional rows--but ensure integrity of formulas.
4Enter Current, Contingent, or Prospective in Column D (starting at row 10)
5Enter all subcontractor labor categories in Column B (starting at row 10). If necessary, insert additional rows--but ensure integrity of formulas. Remove any labor categories in Column B that the Subcontractor is not performing. 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.
6Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
7The 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.
8All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
9All dollar figures shall be carried out no further than two decimal places.
10In Column E, the Government has listed whether the labor category falls under Regular Work or Overtime.
11In Column F, the Government has listed the BLS Code applicable to that Labor Category.
12In Column G, the Government has listed the SCA Code applicable to that Labor Category.
13In column H, 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.
14In column I, the Government has listed the place of performance applicable to that Labor Category.
15In Columns J, N, R, V, and Z, the Government has listed the Minimum Direct Labor Rate applicable to that Labor Category. If the Labor Category falls under SCA, the Government used the minimum direct labor rate per the SCA Code listed in Column G as seen in the applicable WD. If the Labor Category does not fall under SCA, the Government used a minimum direct labor rate per the BLS Code listed in Column F.
16In Columns K, O, S, W, and AA, insert the proposed direct labor rate applicable to that Labor Category.
17Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
18For subcontractor cost summary sheets, please delete Rows 72-115 as well as any unused labor category rows.
19When submitting this file, the instructions may be deleted.

N00421-21-R-0161

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET (LOE)

Prime Offeror Name:
Subcontractor(s) Name (if applicable):
Period 1Period 2Period 3Period 4Period 5Total
PositionGovernment Labor CategoryEmployee NameCurrent/ Contingent/ ProspectiveRG/OTBLS CodeSCA CodeF/PSiteMinimum Direct RateRateHoursAmountMinimum Direct RateRateHoursAmountMinimum Direct RateRateHoursAmountMinimum Direct RateRateHoursAmountMinimum Direct RateRateHoursAmountHoursAmount
Prime Contractor Labor CostK = Contractor
G = Government
R = Remote
1Administrative AssistantEmployee Name 1RG43-601401020K - St. Inigoes, MD$ 36.1200.0036.6900.0037.2800.0037.8719200.0038.4719200.0038400.00
2Budget Analysts, JourneymanEtc.RG13-2051N/AK - St. Inigoes, MD$ 51.449600.0053.509600.0055.649600.0057.869600.0060.189600.0048000.00
3Data Entry Operator IEtc.RG43-902101051G - St. Inigoes, MD$ 17.2019200.0017.4719200.0017.7519200.0018.0319200.0018.3219200.0096000.00
4Data Entry Operator IIEtc.RG43-902101052G - St. Inigoes, MD$ 17.7119200.0017.9919200.0018.2819200.0018.5719200.0018.8619200.0096000.00
5General and Operations Managers (Program Manager), Senior *Etc.RG11-1021N/AG - St. Inigoes, MD$ 81.1719200.0084.4219200.0087.8019200.0091.3119200.0094.9619200.0096000.00
6General and Operations Managers (Logistics Manager), SeniorEtc.RG11-1021N/AK - St. Inigoes, MD$ 81.1700.0084.428350.0087.808350.0091.318350.0094.968350.0033400.00
7General and Operations Managers (Logistics Manager), SeniorEtc.RG11-1021N/AG - St. Inigoes, MD$ 81.1719200.0084.4238400.0087.8038400.0091.3138400.0094.9638400.00172800.00
8General Clerk IEtc.RG43-601101111G - St. Inigoes, MD$ 17.369600.0017.6428800.0017.9228800.0018.2028800.0018.4938400.00134400.00
9General Clerk IIEtc.RG43-601101112K - St. Inigoes, MD$ 18.9400.0019.2410470.0019.5510470.0019.8610470.0020.1710470.0041880.00
10General Clerk IIEtc.RG43-507101112K - San Diego, CA$ 19.3100.0019.622500.0019.932500.0020.252500.0020.572500.0010000.00
11General Clerk IIEtc.RG43-601101112G - St. Inigoes, MD$ 18.9400.0019.2417800.0019.5517800.0019.8617800.0020.1735600.0089000.00
12General Clerk IIIEtc.RG43-601101113K- St. Inigoes, MD$ 21.2500.0021.5929260.0021.9329260.0022.2829260.0022.6329260.00117040.00
13General Clerk IIIEtc.RG43-601101113G - St. Inigoes, MD$ 21.2538400.0021.59105600.0021.93105600.0022.28105600.0022.63144400.00499600.00
14Logisticians, JuniorEtc.RG13-1081N/AG - St. Inigoes, MD$ 50.0817800.0052.0862510.0054.1662510.0056.3362510.0058.5862510.00267840.00
15Logisticians, JuniorEtc.RG13-1081N/AK - St. Inigoes, MD$ 50.0800.0052.0838400.0054.1638400.0056.3338400.0058.5852420.00167620.00
16Logisticians, JourneymanEtc.RG13-1081N/AG - St. Inigoes, MD$ 62.0957600.0064.58134400.0067.16134400.0069.85134400.0072.64134400.00595200.00
17Logisticians, JourneymanEtc.RG13-1081N/AK - San Diego, CA$ 45.2300.0047.0400.0048.9200.0050.8800.0052.9228090.0028090.00
18Logisticians, JourneymanEtc.RG13-1081N/AK - St. Inigoes, MD$ 62.096000.0064.5834800.0067.1634800.0069.8534800.0072.6462890.00173290.00
19Logisticians, JourneymanEtc.RG13-1081N/AG - San Diego, CA$ 45.2300.0047.0400.0048.9200.0050.8819200.0052.9219200.0038400.00
20Logisticians, Senior *Etc.RG13-1081N/AG - LSTF (PAX)$ 70.3619200.0073.1719200.0076.1019200.0079.1419200.0082.3119200.0096000.00
22Logisticians, SeniorEtc.RG1301081N/AG-LSTF (PAX)$ 70.3600.0073.1700.0076.1000.0079.14576082.3157600.00115200.00
23Logisticians, SeniorEtc.RG13-1081N/AG - St. Inigoes, MD$ 70.3643680.0073.1743680.0076.1043680.0079.1443680.0082.3143680.00218400.00
24Logisticians, SeniorEtc.RG13-1081N/AK - St. Inigoes, MD$ 70.3600.0073.1716320.0076.1016320.0079.1416320.0082.3144410.0093370.00
25Management Analysts, JourneymanEtc.RG13-1111N/AG - St. Inigoes, MD$ 62.7157600.0065.2257600.0067.8357600.0070.5457600.0073.3657600.00288000.00
26Material CoordinatorEtc.RG43-506121030G - St. Inigoes, MD$ 29.2796000.0029.74122880.0030.21122880.0030.69122880.0031.18143970.00608610.00
27Material CoordinatorEtc.RG43-506121030G - LSTF (PAX)$ 29.2700.0029.7400.0030.2100.0030.6900.0031.1814020.0014020.00
28Material CoordinatorEtc.RG43-506121030K - St. Inigoes, MD$ 29.2700.0029.7425800.0030.2125800.0030.6925800.0031.18111000.00188400.00
29Material CoordinatorEtc.RG43-506121030K - San Diego, CA$ 30.3100.0030.792500.0031.282500.0031.782500.0032.282500.0010000.00
30Material Coordinator - OTEtc.OT43-506121030K - St. Inigoes, MD$ 29.2700.0029.745760.0030.213840.0030.693840.0031.183840.0017280.00
31Material Coordinator - OTEtc.OT43-506121030G - St. Inigoes, MD$ 29.2700.0029.745280.0030.215280.0030.695280.0031.185280.0021120.00
32Service Order DispatcherEtc.RG43-503201320G - St. Inigoes, MD$ 20.1219200.0020.4419200.0020.7619200.0021.1019200.0021.4319200.0096000.00
33Shipping/Receiving ClerkEtc.RG43-507121130G - St. Inigoes, MD$ 21.43211200.0021.77211200.0022.12211200.0022.47326400.0022.83326400.001286400.00
34Shipping/Receiving ClerkEtc.RG43-507121130G - LSTF (PAX)$ 21.4319200.0021.7719200.0022.1219200.0022.4719200.0022.8319200.0096000.00
35Shipping/Receiving ClerkEtc.RG43-507121130K - Fayetteville, NC$ 17.2000.0017.4700.0017.7500.0018.0357600.0018.3257600.00115200.00
36Shipping/Receiving ClerkEtc.RG43-507121130K - St. Inigoes, MD$ 21.436000.0021.776000.0022.126000.0022.4763600.0022.8363600.00145200.00
37Stock ClerkEtc.RG53-706521150G - St. Inigoes, MD$ 22.417680.00.0022.777680.00.0023.137680.00.0023.507680.00.0023.877680.00.00384000.00
38Supply TechnicianEtc.RG43-506101410G - St. Inigoes, MD$ 36.12153600.0036.69207740.0037.28207740.0037.87207740.0038.47256940.001033760.00
39Supply TechnicianEtc.RG43-506101410G - LSTF (PAX)$ 36.1200.0036.6900.0037.2800.0037.8700.0038.477020.007020.00
40Supply TechnicianEtc.RG43-506101410K - Fayetteville, NC$ 28.6300.0029.0900.0029.5500.0030.0257600.0030.4957600.00115200.00
41Supply TechnicianEtc.RG43-506101410K - St. Inigoes, MD$ 36.1225200.0036.6956800.0037.2856800.0037.87133600.0038.47161690.00434090.00
42Supply Technician - OTEtc.OT43-506101410G - St. Inigoes, MD$ 36.1200.0036.695760.0037.285760.0037.875760.0038.475760.0023040.00
43Supply Technician - OTEtc.OT43-506101410K - St. Inigoes, MD$ 36.1200.0036.693840.0037.283840.0037.873840.0038.473840.0015360.00
44Technical Writer IIIEtc.RG27-304230463K - St. Inigoes, MD$ 42.722400.0043.402400.0044.092400.0044.792400.0045.502400.0012000.00
45Transportation, Storage, and Distribution Managers, Senior *Etc.RG11-3071N/AG - St. Inigoes, MD$ 68.8319200.0071.5919200.0074.4519200.0077.4319200.0080.5219200.0096000.00
45Transportation, Storage, and Distribution Managers, SeniorEtc.RG11-3071N/AG - St. Inigoes, MD$ 68.8319200.0071.5919200.0074.4519200.0077.4319200.0080.5219200.0096000.00
46Truckdriver, HeavyEtc.RG53-303231363G - St. Inigoes, MD$ 24.4238400.0024.8138400.0025.2038400.0025.6038400.0026.0138400.00192000.00
47Warehouse SpecialistEtc.RG53-706521410G - St. Inigoes, MD$ 20.8196000.0021.14134280.0021.48134280.0021.82307080.0022.17356280.001027920.00
48Warehouse SpecialistEtc.RG53-706521410G - LSTF (PAX)$ 20.8100.0021.1400.0021.4800.0021.8200.0022.1717800.0017800.00
49Warehouse SpecialistEtc.RG53-706521410K - Fayetteville, NC$ 20.7200.0021.0500.0021.3800.0021.7276800.0022.0776800.00153600.00
50Warehouse SpecialistEtc.RG53-706521410K - St. Inigoes, MD$ 20.8119200.0021.1471230.0021.4871230.0021.82205630.0022.17232630.00599920.00
51Warehouse SpecialistEtc.RG53-706521410K - Norfolk, VA$ 21.744800.0022.094800.0022.444800.0022.794800.0023.164800.0024000.00
52Warehouse Specialist - OTEtc.OT53-706521410G - St. Inigoes, MD$ 20.8100.0021.145760.0021.485760.0021.825760.0022.175760.0023040.00
53Warehouse Specialist - OTEtc.OT53-706521410K - St. Inigoes, MD$ 20.8100.0021.144560.0021.484560.0021.824560.0022.174560.0018240.00
54Warehouse Specialist -OTEtc.OT53-706521410K - Norfolk, VA$ 21.7400.0022.09240.0022.44240.0022.79240.0023.16240.00960.00
Total Direct Labor Cost114,268.000.00178,4120.00178,2200.00262,7000.00309,0110.001,042,611.000.00
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost
COM
Total Prime Contractor Labor Cost
Subcontractor Labor Cost
Subcontractor proposed cost and fee
<Insert Subcontractor Name>
52<Insert Labor Category >Employee Name 1
53Employee Name 2
54Etc.
55Etc.
56Etc.
57Etc.
58Etc.
59Etc.
60Etc.
61Etc.
<Insert Subcontractor Name>
62<Insert Labor Category >Employee Name 1
63Employee Name 2
64Etc.
65Etc.
66Etc.
67Etc.
68Etc.
69Etc.
70Etc.
71Etc.
<Insert Subcontractor Name>
72<Insert Labor Category >Employee Name 1
73Employee Name 2
74Etc.
75Etc.
76Etc.
77Etc.
78Etc.
79Etc.
80Etc.
81Etc.
Total proposed subcontractor labor cost and fee
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through

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)

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)

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All YearsAmountPercent
Subcontractor proposed cost and fee
Pass Through Amount (not including fee)
Prime Contractor Fee for Subcontractor Labor *
Total Pass Through Amount (including fee)ERROR:#DIV/0!
Fee Analysis - Total for All YearsAmountPercent
Prime Contractor Labor Cost
Fixed Fee for Labor Performed by Prime ContractorERROR:#DIV/0!

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

N0042123R0070 P1 Cost Summary

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