Attch 4 - Pricing Workbook.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- CONTRACTOR-OPERATED PARTS STORE (COPARS)
- Solicitation number
- M0068126R0005
- Issued by
-
United States Marine Corps
About this file
This is a Pricing Workbook template for RFP M00681-26-R-0005, a Contractor-Operated Parts Store (COPARS) requirement supporting the United States Marine Corps Southwest Region Fleet Transportation division across seven sites in California and Arizona. The workbook is designed for offerors to submit pricing proposals across four Contract Line Items (CLINs): CLIN 0001 (FFP Operations at a monthly rate), CLIN 0002 (Price-Listed Parts on a Time & Materials basis), CLIN 0003 (Non-Price-Listed Parts on a T&M basis with Government-provided ceiling amounts), and CLIN 0004 (Delivery Driver services at a fixed hourly rate). The total evaluated price across the five-year period plus six-month extension is $18,607,430.75, with annual costs escalating from $3,031,390.26 in Year 1 to $3,689,740.42 in Year 5.
Offerors must complete pricing for common parts (filtration and maintenance items), price-listed batteries (Groups 24, 31, 31P, and specialty voltages), OEM parts (Ford, GM, and heavy equipment components), and delivery driver labor hours (3,240 hours annually, 1,620 hours for the six-month extension). All pricing proposals require a single discount percentage applied uniformly across each category rather than individual part discounts. Per FAR 52.216-31, offerors must specify fixed hourly rates for delivery drivers that include wages, overhead, general and administrative expenses, and profit, and must identify whether labor is performed by the offeror, subcontractors, or affiliated entities. The workbook includes auto-calculation features to ensure accuracy and compliance with two decimal place requirements. CLIN 0003 values are Government-provided for evaluation purposes only and may differ from the actual awarded ceiling price.
View the file
Other files
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
1-CLIN Totals
| RFP M00681-26-R-0005 Attachment 4 - Pricing Workbook |
| Offeror Name: |
| Instructions: |
| 1. The Offeror shall fill out required information on Tabs 2 - 6. The amounts from those tabs will auto-populate here on the 'CLIN Totals' tab. Follow instructions on each Tab accordingly. |
| 2. For CLIN 0002, the 'Grand Totals' for Tabs 3-5 will be added together and will auto-populate into this tab to be the proposed value for CLIN 0002. Please note that prices you provide in this worksheet for CLIN 0002 are for price analysis purposes only and may differ from the awarded CLIN ceiling price. |
| 3. Offeror shall ensure calculations are accurate and that provided amounts do not go past two decimal points (e.g. .01) |
| 4. Offerors shall not adjust values for the 52.217-8 Option to Extend Services; these values will auto-populate (for evaluation purposes only). |
| 5. Offerors shall not adjust the values for CLIN 0003. These are Government provided amounts used to establish a total evaluated price (TEP) for price analysis purposes only, and may differ from the awarded CLIN ceiling price. |
| 6. On Tab 6, Offerors must address the content required by RFO 52.216-31 (see Tab 6 for instructions). |
| POP | CLIN 0001: Operations (FFP) | CLIN 0002: Price Listed (PL) Parts (T&M) | CLIN 0003: Non-Price Listed (NLP) Parts (T&M) | CLIN 0004: Delivery Driver (LH) | Total |
| Year 1 | $0.00 | $0.00 | $3,031,390.26 | $0.00 | $3,031,390.26 |
| Year 2 | $0.00 | $0.00 | $3,184,093.78 | $0.00 | $3,184,093.78 |
| Year 3 | $0.00 | $0.00 | $3,344,460.80 | $0.00 | $3,344,460.80 |
| Year 4 | $0.00 | $0.00 | $3,512,875.26 | $0.00 | $3,512,875.26 |
| Year 5 | $0.00 | $0.00 | $3,689,740.42 | $0.00 | $3,689,740.42 |
| 6-month extension | $0.00 | $0.00 | $1,844,870.23 | $0.00 | $1,844,870.23 |
| TOTAL | $0.00 | $0.00 | $18,607,430.75 | $0.00 | $18,607,430.75 |
TOTAL EVALUATED PRICE: $18,607,430.75
2-FFP Operations
| RFP M00681-26-R-0005 Attachment 4 - Pricing Workbook |
| Offeror Name: |
Instructions: Fill out the Unit Price (Column D) with the FFP Monthly amount being proposed for each Year of the Ordering Period. The amount for the 6-month extension will auto-calculate.
| CLIN 0001: FFP Operations | ||||
| POP | Unit Quanity | Unit of Issue | Unit Price | Total |
| Year 1 | 12 | Months | $0.00 | |
| Year 2 | 12 | Months | $0.00 | |
| Year 3 | 12 | Months | $0.00 | |
| Year 4 | 12 | Months | $0.00 | |
| Year 5 | 12 | Months | $0.00 | |
| 6-month extension | 6 | Months | $0.00 | $0.00 |
| TOTAL | $0.00 |
3-Common Parts
| RFP M00681-26-R-0005 Attachment 4 - Pricing Workbook |
| Offeror Name: |
Instructions: Fill out columns C, E, F and I (if applicable). Columns G & H will auto-populate. Offeror shall propose the same Discount % for ALL 'Common Parts' (not a separate discount per individual part).
| Common Parts | ||||||||
| Item Description | Applied to | Supplier | Estimated Yearly Quantity | Unit List Price | Discount % | Unit Discounted Price | Total Amount Discounted Price | Notes |
| NAPA 7151 - Filter, Oil | Nynamax, Ford | 74 | $0.00 | $0.00 | ||||
| NAPA 9902 - Filter, Air | Blue Bird, Ford | 68 | $0.00 | $0.00 | ||||
| NAPA 3026 - Fuel Additive, Diesel | Various | 116 | $0.00 | $0.00 | ||||
| NAPA 7669 - Filter, Oil | International, Freightliner, Kenworth | 31 | $0.00 | $0.00 | ||||
| NAPA 4466 - Filter, Cabin Air | International | 29 | $0.00 | $0.00 | ||||
| NAPA 6022 - Wiper Blades | Various | 317 | $0.00 | $0.00 | ||||
| NAPA 6489 - Filter, Air | John Deere | 55 | $0.00 | $0.00 | ||||
| NAPA 7182 - Filter, Oil | International, Freightliner | 36 | $0.00 | $0.00 | ||||
| NAPA 9518 - Filter, Air | Carrier Transicold Refrigeration | 29 | $0.00 | $0.00 | ||||
| NAPA 1748XD - Filter, Oil | International, Pierce | 45 | $0.00 | $0.00 | ||||
| Grand Total | $0.00 |
4-Price-Listed Batteries
| RFP M00681-26-R-0005 Attachment 4 - Pricing Workbook |
| Offeror Name: |
Instructions: Fill out columns C, E, F and I (if applicable). Columns G & H will auto-populate. Offeror shall propose the same Discount % for ALL 'Price-listed Batteries' (not a separate discount per individual part).
| Price-Listed Batteries | ||||||||
| Item Description | Applied to | Supplier | Estimated Yearly Quantity | Unit List Price | Discount % | Unit Discounted Price | Total Amount Discounted Price | Notes |
| Battery, Group 31 - Top Mount Stud | Various | 213 | $0.00 | $0.00 | ||||
| Battery, Group 31P - Top Mount Stud | Various | 108 | $0.00 | $0.00 | ||||
| Battery, Group 24 - Top Mount Stud | Various | 49 | $0.00 | $0.00 | ||||
| 6 Volt AGM | Low Speed Vehicles | 48 | $0.00 | $0.00 | ||||
| 12 Volt Gel-Cell | Low Speed Vehicles | 36 | $0.00 | $0.00 | ||||
| Grand Total | $0.00 |
5-OEM Parts
| RFP M00681-26-R-0005 Attachment 4 - Pricing Workbook |
| Offeror Name: |
Instructions: Fill out columns C, E, F and I (if applicable). Columns G & H will auto-populate. Offeror shall propose the same Discount % for ALL 'OEM parts' (not a separate discount per individual part).
| OEM Parts | ||||||||
| Item Description | Applied to | Supplier | Estimated Yearly Quantity | Unit List Price | Discount % | Unit Discounted Price | Total Amount Discounted Price | Notes |
| 3C2Z8678CB - Pulley | Ford | 3 | $0.00 | $0.00 | ||||
| 4164147C - Shock Absorber | HD Commercial | 3 | $0.00 | $0.00 | ||||
| 6C2Z10346EARM2 - Alternator | Ford | 3 | $0.00 | $0.00 | ||||
| 12663047 - Tensioner | GM | 2 | $0.00 | $0.00 | ||||
| 23855501 - Latch | HD Truck | 2 | $0.00 | $0.00 | ||||
| Grand Total | $0.00 |
6-Delivery Driver
| RFP M00681-26-R-0005 Attachment 4 - Pricing Workbook |
| Offeror Name: |
| Instructions: Fill out column E. Column F will auto-populate. |
| Per RFO 52.216-31, the Offeror must specify fixed hourly rates that include wages, overhead, general and administrative expenses, and profit. The Offeror must specify whether the fixed hourly rate for each labor category applies to labor performed by: (1) the Offeror; (2) Subcontractors; and/or (3) Divisions, subsidiaries, or affiliates of the Offeror under a common control. |
| CLIN 0004: Delivery Driver (LH) | ||||
| POP | Unit Quanity | Unit of Issue | Unit Price | Total |
| Year 1 | 3240 | Hours | $0.00 | |
| Year 2 | 3240 | Hours | $0.00 | |
| Year 3 | 3240 | Hours | $0.00 | |
| Year 4 | 3240 | Hours | $0.00 | |
| Year 5 | 3240 | Hours | $0.00 | |
| 6-month extension | 1620 | Hours | $0.00 | $0.00 |
| TOTAL | $0.00 |
File details come from the government source that posted it. Updated .