Attch 4 - Pricing Workbook.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
CONTRACTOR-OPERATED PARTS STORE (COPARS)
Solicitation number
M0068126R0005
Issued by

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).
POPCLIN 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
POPUnit QuanityUnit of IssueUnit PriceTotal
Year 112Months$0.00
Year 212Months$0.00
Year 312Months$0.00
Year 412Months$0.00
Year 512Months$0.00
6-month extension6Months$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 DescriptionApplied toSupplierEstimated Yearly QuantityUnit List PriceDiscount %Unit Discounted PriceTotal Amount Discounted PriceNotes
NAPA 7151 - Filter, OilNynamax, Ford74$0.00$0.00
NAPA 9902 - Filter, AirBlue Bird, Ford68$0.00$0.00
NAPA 3026 - Fuel Additive, DieselVarious116$0.00$0.00
NAPA 7669 - Filter, OilInternational, Freightliner, Kenworth31$0.00$0.00
NAPA 4466 - Filter, Cabin AirInternational29$0.00$0.00
NAPA 6022 - Wiper BladesVarious317$0.00$0.00
NAPA 6489 - Filter, AirJohn Deere55$0.00$0.00
NAPA 7182 - Filter, OilInternational, Freightliner36$0.00$0.00
NAPA 9518 - Filter, AirCarrier Transicold Refrigeration29$0.00$0.00
NAPA 1748XD - Filter, OilInternational, Pierce45$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 DescriptionApplied toSupplierEstimated Yearly QuantityUnit List PriceDiscount %Unit Discounted PriceTotal Amount Discounted PriceNotes
Battery, Group 31 - Top Mount StudVarious213$0.00$0.00
Battery, Group 31P - Top Mount StudVarious108$0.00$0.00
Battery, Group 24 - Top Mount StudVarious49$0.00$0.00
6 Volt AGMLow Speed Vehicles48$0.00$0.00
12 Volt Gel-CellLow Speed Vehicles36$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 DescriptionApplied toSupplierEstimated Yearly QuantityUnit List PriceDiscount %Unit Discounted PriceTotal Amount Discounted PriceNotes
3C2Z8678CB - PulleyFord3$0.00$0.00
4164147C - Shock AbsorberHD Commercial3$0.00$0.00
6C2Z10346EARM2 - AlternatorFord3$0.00$0.00
12663047 - TensionerGM2$0.00$0.00
23855501 - LatchHD Truck2$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)
POPUnit QuanityUnit of IssueUnit PriceTotal
Year 13240Hours$0.00
Year 23240Hours$0.00
Year 33240Hours$0.00
Year 43240Hours$0.00
Year 53240Hours$0.00
6-month extension1620Hours$0.00$0.00
TOTAL$0.00

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