Attachment 0002 - Price Matrix W15QKN-21-R-0041.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- PM MAS Support Services
- Solicitation number
- W15QKN-21-R-0041
About this file
This document contains a price matrix and related attachments for a solicitation seeking contractor program support services. The U.S. Army Contracting Command - New Jersey is soliciting proposals on behalf of the Project Manager for Maneuver Ammunition Systems to provide life cycle management support for multiple ammunition product lines over five one-year ordering periods. Services include production management, operations management, engineering, analytics, program assistance, and administrative support across small, medium, and large caliber ammunition programs. The acquisition will result in an Indefinite Delivery Indefinite Quantity contract utilizing firm-fixed-price and cost-reimbursable CLINs for labor and travel costs. Offerors must fully price labor using fixed hourly rates and GSA schedules where applicable, and must not propose profit on cost-reimbursable travel CLINs. The solicitation number is W15QKN-21-R-0041 and the response is due based on the standard solicitation timeline.
View the file
Other files
Show all 22
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
Summary
| OFFEROR NAME: | = Offeror Must Fill-In Cells |
| = Cells include formulas; DO NOT CHANGE unless accounting for these costs is different | |
| Solicitation No. W15QKN-21-R-0041 | |
| Price Matrix, Attachment 0002 |
Only Input Offeror's Name On This Worksheet. Do Not Change Formulas.
PRICE MATRIX SUMMARY
| CLIN | Description | Total Proposed Value |
| 0001 | PM MAS Support Services / FFP Labor - Ordering Period 1 | $0 |
| 0002 | Contractor Manpower Reporting | $0 |
| 0003 | Contractor Data Requirements List (CDRL) | NSP |
| 0004 | Travel / CR - Ordering Period 1 | $150,000 |
| 0005 | PM MAS Support Services / FFP Labor - Ordering Period 2 | $0 |
| 0006 | Travel / CR - Ordering Period 2 | $150,000 |
| 0007 | PM MAS Support Services / FFP Labor - Ordering Period 3 | $0 |
| 0008 | Travel / CR - Ordering Period 3 | $150,000 |
| 0009 | PM MAS Support Services / FFP Labor - Ordering Period 4 | $0 |
| 0010 | Travel / CR - Ordering Period 4 | $150,000 |
| 0011 | PM MAS Support Services / FFP Labor - Ordering Period 5 | $0 |
| 0012 | Travel / CR - Ordering Period 5 | $150,000 |
| Total FFP Labor | $0 | |
| Total CR Travel | $750,000 | |
| Total Contractor Manpower Reporting | $0 | |
| Total CDRLs | NSP | |
| TOTAL | $750,000 |
FFP Labor OFFEROR NAME: 0 = Offeror Must Fill-In Cells
| Solicitation No. W15QKN-21-R-0041 | = Cells include formulas; DO NOT CHANGE unless accounting for these costs is different |
| Price Matrix, Attachment 0002 | |
| FFP Labor Rates |
| * Select the appropriate option for each labor category from the drop down list (SCLS-Covered or Exempt) |
| ** For labor categories subject to the SCLS, the element of cost breakout for the FFP fully loaded labor rates must be completed on the SCLS Covered Labor worksheet. |
| FIRM FIXED PRICE FULLY LOADED LABOR RATES | |||||||||||||
| Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||
| LABOR CATEGORY** | Government Provided Hours per OP | SCLS Covered or Exempt* | Fully Loaded Hourly Rate | Extended Price | Fully Loaded Hourly Rate | Extended Price | Fully Loaded Hourly Rate | Extended Price | Fully Loaded Hourly Rate | Extended Price | Fully Loaded Hourly Rate | Extended Price | Total FFP Labor |
| Operations Officer | 5760 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Production Manager | 1920 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Senior Engineer | 13440 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Engineer | 8640 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Warfighter Ammunition Information Program (WAIP) | 4992 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Administrative Support | 4992 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Senior Analyst | 4032 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Analyst | 3840 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Item Manager | 19200 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| TOTALS | 66816 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
SCLS Covered Labor
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| = Cells include formulas; DO NOT CHANGE unless accounting for these costs is different | ||
| Solicitation No. W15QKN-21-R-0041 | ||
| Price Matrix, Attachment 0002 | ||
| SCLS (formerly SCA) Covered Labor Categories |
Complete Only for Labor Categories Identified As SCLS Covered on the FFP Labor Worksheet
| * based upon 2080 hours | ** based upon Productive hours | ||||
| Solicitation Labor Category | Mapping to Contractor's Labor Category | Wage Determination | |||
| Number / Revision | SCLS Occupation | ||||
| Title | SCLS |
Occupation
| Code | Hours Per Year | Wage Rate * | Total Wages | Vacation | Holiday | Sick | SCLS Health & Welfare | Total Labor Costs | Overhead | G&A | Profit | Fully Loaded Labor | Fully Loaded Rate ** | |||||||||
| Total | Vacation | Holiday | Sick | Productive Hours | Sick | Fully Loaded Labor | ||||||||||||||||
| For Sample Purposes Only, Morris County was used as the Place of Performance for the Wage Determination Example. | $ 4.22 | 85% | 12% | 10% | ||||||||||||||||||
| SAMPLE ONLY: Administrative Support | SCLS | 2015-4211 / Rev. 14 | General Clerk II | 01112 | 2,080 | 80 | 80 | 56 | 1,864 | $17.49 | $32,601.36 | $1,399.20 | $1,399.20 | $979.44 | $8,777.60 | $45,156.80 | $38,383.28 | $10,024.81 | $9,356.49 | $102,921.38 | $55.22 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 2,080 | 2,080 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Basis For SCLS Benefits:
1. Vacation: Explain Vacation Benefits Paid Reflected In Column K
2. Holiday: Explain Holiday Benefits Paid Reflected In Column L
3. Sick: Explain Sick Leave Benefits Paid Reflected In Column M
4. H&W: Explain H&W Benefits Paid Per Hour Shown In Cell Q11
| SAMPLE ONLY |
| Basis For SCLS Benefits: |
1. Vacation: Explain Vacation Benefits Paid Reflected In Column K Per the Wage Determination, 2 Weeks of Paid Vacation Will Be Paid After 1 Year of Service, 3 Weeks After 5 Years, and 4 Years After 15 Years.
2. Holiday: Explain Holiday Benefits Paid Reflected In Column L Per the Wage Determination, A Minimum of Ten Paid Holidays Per Year Will Be Paid.
3. Sick Leave: Explain Sick Leave Benefits Paid Reflected In Column M Per the Wage Determination, A Minimum of 5 Sick days per Year Will Be Paid When Health & Welfare EO 13706 Applies.
4. H&W: Explain H&W Benefits Paid Per Hour Reflected In Cell O11 Per the Wage Determination, Health & Welfare Benefits of $4.22 Per Hour Will Be Paid When Health & Welfare EO 13706 Establishing Paid Sick Leave for Federal Contractors Applies.
CR Travel
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells | = Government Provided Amounts |
| = Cells include formulas; DO NOT CHANGE unless accounting for these costs is different | |||
| Solicitation No. W15QKN-21-R-0041 | |||
| Price Matrix, Attachment 0002 | |||
| Cost Reimbursable Travel |
| Note: Travel will be reimbursed at cost. Indirect rates applicable to Travel will be reimbursed at cost. No profit/fee shall be proposed. | ||||||||||||
| OP 1 | OP 2 | OP 3 | OP 4 | OP 5 | Total | |||||||
| Description | Application Base | Indirect Rate | Sub-Total | Indirect Rate | Sub-Total | Indirect Rate | Sub-Total | Indirect Rate | Sub-Total | Indirect Rate | Sub-Total | |
| Description | ||||||||||||
| Government Provided Travel Dollars | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | |||||||
| Example: G&A | Total Cost Input | 12.00% | $18,000 | 12.00% | $18,000 | 12.00% | $18,000 | 12.00% | $18,000 | 12.00% | $18,000 | $750,000 |
| Insert Indirect Cost Title | $0 | $0 | $0 | $0 | $0 | |||||||
| Insert Indirect Cost Title | $0 | $0 | $0 | $0 | $0 | |||||||
| TOTAL TRAVEL and APPLICABLE INDIRECT COSTS | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | |||||||
| * INDIRECT RATES SHALL BE THE SAME AS PROPOSED ON THE LABOR RATE DETAIL TAB OF THIS WORKBOOK; OUTYEAR RATES SHALL BE BASED UPON THE SUPPORTING DETAIL PROVIDED FOR THOSE YEARS |
Travel Matrix for TOs
| OFFEROR NAME: | = Offeror Must Fill-In Cells |
| = Cells include formulas; DO NOT CHANGE unless accounting for these costs is different | |
| Solicitation No. W15QKN-21-R-0041 | |
| Price Matrix, Attachment 0002 | |
| Travel Matrix for Task Orders |
Note: Travel and applicable indirect costs are reimbursed at cost. No profit/fee shall be proposed.
| DESCRIPTION OF COST ELEMENTS | ||||||||||||
| Travel Destination | Duration (Days) | Trips/5 Yr | Ppl/Trip | Airfare / Ticket | Car / Day | Lodging/Day | Per Diem/Day | Airfare | Car | Hotel | M&IE | Total Estimated Cost ($) |
| Example:Various locations CONUS | 5 | 250 | 2 | $800.00 | $45.00 | $150.00 | $75.00 | $400,000.00 | $56,250.00 | $300,000.00 | $168,750.00 | $925,000.00 |
| Example: Various locations OCONUS | 5 | 100 | 2 | $1,500.00 | $60.00 | $200.00 | $120.00 | $300,000.00 | $30,000.00 | $160,000.00 | $108,000.00 | $598,000.00 |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| Total Travel Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
*Add more cells if needed.
Template Example
FOR USE WHEN PROPOSING TRAVEL ON FUTURE TASK ORDERS
Contractor Manpower Reporting
| OFFEROR NAME: | 0 | = Offeror Must Fill-In Cells |
| = Cells include formulas; DO NOT CHANGE unless accounting for these costs is different | ||
| Solicitation No. W15QKN-21-R-0041 | ||
| Price Matrix, Attachment 0002 | ||
| Manpower Reporting |
Note: Offeror shall determine whether or not to price or not-separately-price (NSP) Contractor Manpower Reporting (CMR) Costs. If the Offeror recoups CMR costs through their indirect rates, CMR should be proposed as NSP and NSP entered into the highlighted cells for OP1 through OP5 below. If CMR is separately priced, include a price for this requirement for each OP below.
| Manpower Reporting | OP1 | OP2 | OP3 | OP4 | OP5 | TOTAL |
| OP1 | ||||||
| Enter NSP or Pricing per above instruction. | $ - 0 |
File details come from the government source that posted it. Updated .