Attachment P1 - Cost Summary Sheet.xlsx
XLSX spreadsheet 52 KB Posted
- Attached to
- Rapid Operations Material Management (ROMM) RFP Federal contract opportunity
- Solicitation number
- N0042124R0041
About this file
This document is a Cost Spreadsheet (LOE) for a federal contract opportunity. It provides detailed instructions for completing the cost spreadsheet, both for the prime contractor and any subcontractors. The spreadsheet includes labor categories, hours, direct labor rates, indirect rates, and other direct costs for the entire period of performance of the contract. It requires the prime contractor and any subcontractors to provide their cost information broken out by Contract Line Item Number (CLIN). The overall contract opportunity is for Rapid Operations Material Management (ROMM), solicitation number N0042124R0041, issued by the Department of the Navy Naval Air Systems Command Naval Air Warfare Center. Proposals are due by 9 September 2024 at 14:00 PM EST.
View the file
Other files for this federal contract opportunity
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: | |
| 1 | Enter Prime offeror name into cell B3. |
| 2 | Enter all prime employee names in Column C (starting at row 10) If necessary, insert additional rows--but ensure integrity of formulas. |
| 3 | Enter Current, Contingent, or Prospective in Column D (starting at row 10) |
| 4 | 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. |
| 5 | Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor) |
| 6 | The 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. |
| 7 | All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations. |
| 8 | All dollar figures shall be carried out no further than two decimal places. |
| 9 | In Column E, the Government has listed whether the labor category falls under Regular Work or Overtime. |
| 10 | In Column F, the Government has listed the BLS Code applicable to that Labor Category. |
| 11 | In Column G, the Government has listed the SCA Code applicable to that Labor Category. |
| 12 | In 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. |
| 13 | In column I, the Government has listed the place of performance applicable to that Labor Category. |
| 14 | In 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. |
| 15 | In Columns K, O, S, W, and AA, insert the proposed direct labor rate applicable to that Labor Category. |
| 16 | Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly. |
| 17 | For each subcontractor, enter the subcontractor name, labor category the subcontractor will be performing, total hours, and total amount for each period of performance. |
| 18 | Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas. |
| 19 | The prime should insert the subcontractor handling charge, if any. |
| 20 | The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor. |
| 21 | The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any. |
| 22 | Under Other Direct Costs, the prime contractor should separate by Travel, Material, and Field Services as applicable. |
| 23 | Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions. |
| 24 | On 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 |
| 25 | When submitting this file, the instructions may be deleted. |
| Instructions for Subcontractors: | |
| 1 | Enter Prime offeror name into cell B3. |
| Enter Subcontractor offeror name into cell B4. | |
| 2 | Replace Prime Contractor with Subcontractor in cells B7, and any other applicable cells. |
| 3 | Enter all subcontractor employee names in Column C (starting at row 10) If necessary, insert additional rows--but ensure integrity of formulas. |
| 4 | Enter Current, Contingent, or Prospective in Column D (starting at row 10) |
| 5 | Enter 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. |
| 6 | Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor) |
| 7 | The 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. |
| 8 | All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations. |
| 9 | All dollar figures shall be carried out no further than two decimal places. |
| 10 | In Column E, the Government has listed whether the labor category falls under Regular Work or Overtime. |
| 11 | In Column F, the Government has listed the BLS Code applicable to that Labor Category. |
| 12 | In Column G, the Government has listed the SCA Code applicable to that Labor Category. |
| 13 | In 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. |
| 14 | In column I, the Government has listed the place of performance applicable to that Labor Category. |
| 15 | In 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. |
| 16 | In Columns K, O, S, W, and AA, insert the proposed direct labor rate applicable to that Labor Category. |
| 17 | Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly. |
| 18 | For subcontractor cost summary sheets, please delete Rows 72-115 as well as any unused labor category rows. |
| 19 | When 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 1 | Period 2 | Period 3 | Period 4 | Period 5 | Total | |||||||||||||||||||||||||
| Position | Government Labor Category | Employee Name | Current/ Contingent/ Prospective | RG/OT | BLS Code | SCA Code | F/P | Site | Minimum Direct Rate | Rate | Hours | Amount | Minimum Direct Rate | Rate | Hours | Amount | Minimum Direct Rate | Rate | Hours | Amount | Minimum Direct Rate | Rate | Hours | Amount | Minimum Direct Rate | Rate | Hours | Amount | Hours | Amount |
| Prime Contractor Labor Cost | K = Contractor | |||||||||||||||||||||||||||||
| G = Government | ||||||||||||||||||||||||||||||
| R = Remote | ||||||||||||||||||||||||||||||
| 1 | Administrative Assistant | Employee Name 1 | RG | 43-6014 | 01020 | K - St. Inigoes, MD | $ 35.73 | 0 | 0.00 | 36.30 | 0 | 0.00 | 36.88 | 0 | 0.00 | 37.46 | 1920 | 0.00 | 38.06 | 1920 | 0.00 | 3840 | 0.00 | |||||||
| 2 | Budget Analysts, Journeyman | Etc. | RG | 13-2051 | N/A | K - St. Inigoes, MD | $ 51.44 | 960 | 0.00 | 53.50 | 960 | 0.00 | 55.64 | 960 | 0.00 | 57.86 | 960 | 0.00 | 60.18 | 960 | 0.00 | 4800 | 0.00 | |||||||
| 3 | Data Entry Operator I | Etc. | RG | 43-9021 | 01051 | G - St. Inigoes, MD | $ 15.74 | 1920 | 0.00 | 15.99 | 1920 | 0.00 | 16.24 | 1920 | 0.00 | 16.50 | 1920 | 0.00 | 16.77 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 4 | Data Entry Operator II | Etc. | RG | 43-9021 | 01052 | G - St. Inigoes, MD | $ 17.17 | 1920 | 0.00 | 17.44 | 1920 | 0.00 | 17.72 | 1920 | 0.00 | 18.00 | 1920 | 0.00 | 18.29 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 5 | General and Operations Managers (Program Manager), Senior * | Etc. | RG | 11-1021 | N/A | G - St. Inigoes, MD | $ 81.17 | 1920 | 0.00 | 84.42 | 1920 | 0.00 | 87.80 | 1920 | 0.00 | 91.31 | 1920 | 0.00 | 94.96 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 6 | General and Operations Managers (ProgramManager) Senior * | Etc. | RG | 11-1021 | N/A | K - Norfolk, VA | $ 70.19 | 480 | 0.00 | 72.99 | 480 | 0.00 | 75.91 | 480 | 0.00 | 78.95 | 480 | 0.00 | 82.11 | 480 | 0.00 | 2400 | 0.00 | |||||||
| 7 | General and Operations Managers (Logistics Manager), Senior | Etc. | RG | 11-1021 | N/A | K - St. Inigoes, MD | $ 81.17 | 0 | 0.00 | 84.42 | 835 | 0.00 | 87.80 | 835 | 0.00 | 91.31 | 835 | 0.00 | 94.96 | 835 | 0.00 | 3340 | 0.00 | |||||||
| 8 | General and Operations Managers (Logistics Manager), Senior | Etc. | RG | 11-1021 | N/A | G - St. Inigoes, MD | $ 81.17 | 1920 | 0.00 | 84.42 | 3840 | 0.00 | 87.80 | 3840 | 0.00 | 91.31 | 3840 | 0.00 | 94.96 | 3840 | 0.00 | 17280 | 0.00 | |||||||
| 9 | General Clerk I | Etc. | RG | 43-6011 | 01111 | G - St. Inigoes, MD | $ 15.95 | 960 | 0.00 | 16.20 | 2880 | 0.00 | 16.46 | 2880 | 0.00 | 16.72 | 2880 | 0.00 | 16.99 | 3840 | 0.00 | 13440 | 0.00 | |||||||
| 10 | General Clerk II | Etc. | RG | 43-6011 | 01112 | K - St. Inigoes, MD | $ 17.41 | 0 | 0.00 | 17.69 | 1047 | 0.00 | 17.97 | 1047 | 0.00 | 18.25 | 1047 | 0.00 | 18.54 | 1047 | 0.00 | 4188 | 0.00 | |||||||
| 11 | General Clerk II | Etc. | RG | 43-5071 | 01112 | K - San Diego, CA | $ 17.55 | 0 | 0.00 | 17.83 | 250 | 0.00 | 18.11 | 250 | 0.00 | 18.40 | 250 | 0.00 | 18.69 | 250 | 0.00 | 1000 | 0.00 | |||||||
| 12 | General Clerk II | Etc. | RG | 43-6011 | 01112 | G - St. Inigoes, MD | $ 17.41 | 0 | 0.00 | 17.69 | 1780 | 0.00 | 17.97 | 1780 | 0.00 | 18.25 | 1780 | 0.00 | 18.54 | 3560 | 0.00 | 8900 | 0.00 | |||||||
| 13 | General Clerk III | Etc. | RG | 43-6011 | 01113 | K- St. Inigoes, MD | $ 19.55 | 0 | 0.00 | 19.86 | 2926 | 0.00 | 20.18 | 2926 | 0.00 | 20.50 | 2926 | 0.00 | 20.82 | 2926 | 0.00 | 11704 | 0.00 | |||||||
| 14 | General Clerk III | Etc. | RG | 43-6011 | 01113 | G - St. Inigoes, MD | $ 19.55 | 3840 | 0.00 | 19.86 | 10560 | 0.00 | 20.18 | 10560 | 0.00 | 20.50 | 10560 | 0.00 | 20.82 | 14440 | 0.00 | 49960 | 0.00 | |||||||
| 15 | Logisticians, Junior | Etc. | RG | 13-1081 | N/A | G - St. Inigoes, MD | $ 50.08 | 1780 | 0.00 | 52.08 | 6251 | 0.00 | 54.16 | 6251 | 0.00 | 56.33 | 6251 | 0.00 | 58.58 | 6251 | 0.00 | 26784 | 0.00 | |||||||
| 16 | Logisticians, Junior | Etc. | RG | 13-1081 | N/A | K - St. Inigoes, MD | $ 50.08 | 0 | 0.00 | 52.08 | 3840 | 0.00 | 54.16 | 3840 | 0.00 | 56.33 | 3840 | 0.00 | 58.58 | 5242 | 0.00 | 16762 | 0.00 | |||||||
| 17 | Logisticians, Journeyman | Etc. | RG | 13-1081 | N/A | G - St. Inigoes, MD | $ 62.09 | 5760 | 0.00 | 64.58 | 13440 | 0.00 | 67.16 | 13440 | 0.00 | 69.85 | 13440 | 0.00 | 72.64 | 13440 | 0.00 | 59520 | 0.00 | |||||||
| 18 | Logisticians, Journeyman | Etc. | RG | 13-1081 | N/A | K - San Diego, CA | $ 45.23 | 0 | 0.00 | 47.04 | 0 | 0.00 | 48.92 | 0 | 0.00 | 50.88 | 0 | 0.00 | 52.92 | 2809 | 0.00 | 2809 | 0.00 | |||||||
| 19 | Logisticians, Journeyman | Etc. | RG | 13-1081 | N/A | K - St. Inigoes, MD | $ 62.09 | 600 | 0.00 | 64.58 | 3480 | 0.00 | 67.16 | 3480 | 0.00 | 69.85 | 3480 | 0.00 | 72.64 | 6289 | 0.00 | 17329 | 0.00 | |||||||
| 20 | Logisticians, Journeyman | Etc. | RG | 13-1081 | N/A | G - San Diego, CA | $ 45.23 | 0 | 0.00 | 47.04 | 0 | 0.00 | 48.92 | 0 | 0.00 | 50.88 | 1920 | 0.00 | 52.92 | 1920 | 0.00 | 3840 | 0.00 | |||||||
| 21 | Logisticians, Senior * | Etc. | RG | 13-1081 | N/A | G - LSTF (PAX) | $ 70.36 | 1920 | 0.00 | 73.17 | 1920 | 0.00 | 76.10 | 1920 | 0.00 | 79.14 | 7680 | 0.00 | 82.31 | 7680 | 0.00 | 21120 | 0.00 | |||||||
| 22 | Logisticians, Senior | Etc. | RG | 13-1081 | N/A | G - St. Inigoes, MD | $ 70.36 | 4368 | 0.00 | 73.17 | 4368 | 0.00 | 76.10 | 4368 | 0.00 | 79.14 | 4368 | 0.00 | 82.31 | 4368 | 0.00 | 21840 | 0.00 | |||||||
| 23 | Logisticians, Senior | Etc. | RG | 13-1081 | N/A | K - St. Inigoes, MD | $ 70.36 | 0 | 0.00 | 73.17 | 1632 | 0.00 | 76.10 | 1632 | 0.00 | 79.14 | 1632 | 0.00 | 82.31 | 4441 | 0.00 | 9337 | 0.00 | |||||||
| 24 | Management Analysts, Journeyman | Etc. | RG | 13-1111 | N/A | G - St. Inigoes, MD | $ 62.71 | 5760 | 0.00 | 65.22 | 5760 | 0.00 | 67.83 | 5760 | 0.00 | 70.54 | 5760 | 0.00 | 73.36 | 5760 | 0.00 | 28800 | 0.00 | |||||||
| 25 | Material Coordinator | Etc. | RG | 43-5061 | 21030 | G - St. Inigoes, MD | $ 29.27 | 9600 | 0.00 | 29.74 | 12288 | 0.00 | 30.21 | 12288 | 0.00 | 30.69 | 12288 | 0.00 | 31.18 | 14397 | 0.00 | 60861 | 0.00 | |||||||
| 26 | Material Coordinator | Etc. | RG | 43-5061 | 21030 | G - LSTF (PAX) | $ 29.27 | 0 | 0.00 | 29.74 | 0 | 0.00 | 30.21 | 0 | 0.00 | 30.69 | 0 | 0.00 | 31.18 | 1402 | 0.00 | 1402 | 0.00 | |||||||
| 27 | Material Coordinator | Etc. | RG | 43-5061 | 21030 | K - St. Inigoes, MD | $ 29.27 | 0 | 0.00 | 29.74 | 2580 | 0.00 | 30.21 | 2580 | 0.00 | 30.69 | 2580 | 0.00 | 31.18 | 11100 | 0.00 | 18840 | 0.00 | |||||||
| 28 | Material Coordinator | Etc. | RG | 43-5061 | 21030 | K - San Diego, CA | $ 28.60 | 0 | 0.00 | 29.05 | 250 | 0.00 | 29.52 | 250 | 0.00 | 29.99 | 250 | 0.00 | 30.46 | 250 | 0.00 | 1000 | 0.00 | |||||||
| 29 | Material Coordinator - OT | Etc. | OT | 43-5061 | 21030 | K - St. Inigoes, MD | $ 29.27 | 0 | 0.00 | 29.74 | 576 | 0.00 | 30.21 | 384 | 0.00 | 30.69 | 384 | 0.00 | 31.18 | 384 | 0.00 | 1728 | 0.00 | |||||||
| 30 | Material Coordinator - OT | Etc. | OT | 43-5061 | 21030 | G - St. Inigoes, MD | $ 29.27 | 0 | 0.00 | 29.74 | 528 | 0.00 | 30.21 | 528 | 0.00 | 30.69 | 528 | 0.00 | 31.18 | 528 | 0.00 | 2112 | 0.00 | |||||||
| 31 | Service Order Dispatcher | Etc. | OT | 43-5032 | 01320 | G - St. Inigoes, MD | $ 19.83 | 1920 | 0.00 | 20.15 | 1920 | 0.00 | 20.47 | 1920 | 0.00 | 20.79 | 1920 | 0.00 | 21.12 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 32 | Shipping/Receiving Clerk | Etc. | RG | 43-5071 | 21130 | G - St. Inigoes, MD | $ 20.09 | 21120 | 0.00 | 20.41 | 21120 | 0.00 | 20.73 | 21120 | 0.00 | 21.06 | 32640 | 0.00 | 21.40 | 32640 | 0.00 | 128640 | 0.00 | |||||||
| 33 | Shipping/Receiving Clerk | Etc. | RG | 43-5071 | 21130 | G - LSTF (PAX) | $ 20.09 | 1920 | 0.00 | 20.41 | 1920 | 0.00 | 20.73 | 1920 | 0.00 | 21.06 | 1920 | 0.00 | 21.40 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 34 | Shipping/Receiving Clerk | Etc. | RG | 43-5071 | 21130 | K - Fayetteville, NC | $ 16.58 | 0 | 0.00 | 16.84 | 0 | 0.00 | 17.11 | 0 | 0.00 | 17.38 | 5760 | 0.00 | 17.66 | 5760 | 0.00 | 11520 | 0.00 | |||||||
| 35 | Shipping/Receiving Clerk | Etc. | RG | 43-5071 | 21130 | K - St. Inigoes, MD | $ 20.09 | 600 | 0.00 | 20.41 | 600 | 0.00 | 20.73 | 600 | 0.00 | 21.06 | 6360 | 0.00 | 21.40 | 6360 | 0.00 | 14520 | 0.00 | |||||||
| 36 | Stock Clerk | Etc. | RG | 53-7065 | 21150 | G - St. Inigoes, MD | $ 21.28 | 7680.0 | 0.00 | 21.62 | 7680.0 | 0.00 | 21.96 | 7680.0 | 0.00 | 22.31 | 7680.0 | 0.00 | 22.67 | 7680.0 | 0.00 | 38400 | 0.00 | |||||||
| 37 | Supply Technician | Etc. | RG | 43-5061 | 01410 | G - St. Inigoes, MD | $ 35.73 | 15360 | 0.00 | 36.30 | 20774 | 0.00 | 36.88 | 20774 | 0.00 | 37.46 | 20774 | 0.00 | 38.06 | 25694 | 0.00 | 103376 | 0.00 | |||||||
| 38 | Supply Technician | Etc. | RG | 43-5061 | 01410 | G - LSTF (PAX) | $ 35.73 | 0 | 0.00 | 36.30 | 0 | 0.00 | 36.88 | 0 | 0.00 | 37.46 | 0 | 0.00 | 38.06 | 702 | 0.00 | 702 | 0.00 | |||||||
| 39 | Supply Technician | Etc. | RG | 43-5061 | 01410 | K - Fayetteville, NC | $ 28.63 | 0 | 0.00 | 29.09 | 0 | 0.00 | 29.55 | 0 | 0.00 | 30.02 | 5760 | 0.00 | 30.49 | 5760 | 0.00 | 11520 | 0.00 | |||||||
| 40 | Supply Technician | Etc. | RG | 43-5061 | 01410 | K - St. Inigoes, MD | $ 35.73 | 2520 | 0.00 | 36.30 | 5680 | 0.00 | 36.88 | 5680 | 0.00 | 37.46 | 13360 | 0.00 | 38.06 | 16169 | 0.00 | 43409 | 0.00 | |||||||
| 41 | Supply Technician - OT | Etc. | OT | 43-5061 | 01410 | G - St. Inigoes, MD | $ 35.73 | 0 | 0.00 | 36.30 | 576 | 0.00 | 36.88 | 576 | 0.00 | 37.46 | 576 | 0.00 | 38.06 | 576 | 0.00 | 2304 | 0.00 | |||||||
| 42 | Supply Technician - OT | Etc. | OT | 43-5061 | 01410 | K - St. Inigoes, MD | $ 35.73 | 0 | 0.00 | 36.30 | 384 | 0.00 | 36.88 | 384 | 0.00 | 37.46 | 384 | 0.00 | 38.06 | 384 | 0.00 | 1536 | 0.00 | |||||||
| 43 | Technical Writer III | Etc. | RG | 27-3042 | 30463 | K - St. Inigoes, MD | $ 42.45 | 240 | 0.00 | 43.12 | 240 | 0.00 | 43.81 | 240 | 0.00 | 44.51 | 240 | 0.00 | 45.21 | 240 | 0.00 | 1200 | 0.00 | |||||||
| 44 | Transportation, Storage, and Distribution Managers, Senior * | Etc. | RG | 11-3071 | N/A | G - St. Inigoes, MD | $ 68.83 | 1920 | 0.00 | 71.59 | 1920 | 0.00 | 74.45 | 1920 | 0.00 | 77.43 | 1920 | 0.00 | 80.52 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 45 | Transportation, Storage, and Distribution Managers, Senior * | Etc. | RG | 11-3071 | N/A | G - St. Inigoes, MD | $ 68.83 | 1920 | 0.00 | 71.59 | 1920 | 0.00 | 74.45 | 1920 | 0.00 | 77.43 | 1920 | 0.00 | 80.52 | 1920 | 0.00 | 9600 | 0.00 | |||||||
| 46 | Truckdriver, Heavy | Etc. | RG | 53-3032 | 31363 | G - St. Inigoes, MD | $ 24.15 | 3840 | 0.00 | 24.53 | 3840 | 0.00 | 24.92 | 3840 | 0.00 | 25.32 | 3840 | 0.00 | 25.72 | 3840 | 0.00 | 19200 | 0.00 | |||||||
| 47 | Warehouse Specialist | Etc. | RG | 53-7065 | 21410 | G - St. Inigoes, MD | $ 18.92 | 9600 | 0.00 | 19.22 | 13428 | 0.00 | 19.53 | 13428 | 0.00 | 19.84 | 30708 | 0.00 | 20.15 | 35628 | 0.00 | 102792 | 0.00 | |||||||
| 48 | Warehouse Specialist | Etc. | RG | 53-7065 | 21410 | G - LSTF (PAX) | $ 18.92 | 0 | 0.00 | 19.22 | 0 | 0.00 | 19.53 | 0 | 0.00 | 19.84 | 0 | 0.00 | 20.15 | 1780 | 0.00 | 1780 | 0.00 | |||||||
| 49 | Warehouse Specialist | Etc. | RG | 53-7065 | 21410 | K - Fayetteville, NC | $ 18.84 | 0 | 0.00 | 19.14 | 0 | 0.00 | 19.44 | 0 | 0.00 | 19.75 | 7680 | 0.00 | 20.07 | 7680 | 0.00 | 15360 | 0.00 | |||||||
| 50 | Warehouse Specialist | Etc. | RG | 53-7065 | 21410 | K - St. Inigoes, MD | $ 18.92 | 1920 | 0.00 | 19.22 | 7123 | 0.00 | 19.53 | 7123 | 0.00 | 19.84 | 20563 | 0.00 | 20.15 | 23263 | 0.00 | 59992 | 0.00 | |||||||
| 51 | Warehouse Specialist | Etc. | RG | 53-7065 | 21410 | K - Norfolk, VA | $ 21.42 | 480 | 0.00 | 21.76 | 480 | 0.00 | 22.11 | 480 | 0.00 | 22.46 | 480 | 0.00 | 22.82 | 480 | 0.00 | 2400 | 0.00 | |||||||
| 52 | Warehouse Specialist - OT | Etc. | OT | 53-7065 | 21410 | G - St. Inigoes, MD | $ 18.92 | 0 | 0.00 | 19.22 | 576 | 0.00 | 19.53 | 576 | 0.00 | 19.84 | 576 | 0.00 | 20.15 | 576 | 0.00 | 2304 | 0.00 | |||||||
| 53 | Warehouse Specialist - OT | Etc. | OT | 53-7065 | 21410 | K - St. Inigoes, MD | $ 18.92 | 0 | 0.00 | 19.22 | 456 | 0.00 | 19.53 | 456 | 0.00 | 19.84 | 456 | 0.00 | 20.15 | 456 | 0.00 | 1824 | 0.00 | |||||||
| 54 | Warehouse Specialist -OT | Etc. | OT | 53-7065 | 21410 | K - Norfolk, VA | $ 21.42 | 0 | 0.00 | 21.76 | 24 | 0.00 | 22.11 | 24 | 0.00 | 22.46 | 24 | 0.00 | 22.82 | 24 | 0.00 | 96 | 0.00 |
| Total Direct Labor Cost | 114,748.00 | 0.00 | 178,892 | 0.00 | 178,700 | 0.00 | 263,180 | 0.00 | 309,491 | 0.00 | 1,045,011.00 | 0.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 |
| 53 | Employee Name 2 | |
| 54 | Etc. | |
| 55 | Etc. | |
| 56 | Etc. | |
| 57 | Etc. | |
| 58 | Etc. | |
| 59 | Etc. | |
| 60 | Etc. | |
| 61 | Etc. | |
| <Insert Subcontractor Name> | ||
| 62 | <Insert Labor Category > | Employee Name 1 |
| 63 | Employee Name 2 | |
| 64 | Etc. | |
| 65 | Etc. | |
| 66 | Etc. | |
| 67 | Etc. | |
| 68 | Etc. | |
| 69 | Etc. | |
| 70 | Etc. | |
| 71 | Etc. | |
| <Insert Subcontractor Name> | ||
| 72 | <Insert Labor Category > | Employee Name 1 |
| 73 | Employee Name 2 | |
| 74 | Etc. | |
| 75 | Etc. | |
| 76 | Etc. | |
| 77 | Etc. | |
| 78 | Etc. | |
| 79 | Etc. | |
| 80 | Etc. | |
| 81 | Etc. | |
| 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 Years | Amount | Percent |
| 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 Years | Amount | Percent |
| Prime Contractor Labor Cost | ||
| Fixed Fee for Labor Performed by Prime Contractor | ERROR:#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 .