RFP Attch.3-CLIN_Pricing_Worksheet.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Southwest Region Fleet Transportation - Contractor-Operated Parts Store (COPARS)
Solicitation number
M00681-21-R-0002
Issued by

View the file

Other files

Show all 14

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

CLIN Prices

RFP ATTACHMENT 3 - CLIN PRICING WORKSHEET
Instructions:
1. Fill in amount for each unit price and extended price for CLINs 0001 and 0004 (and associated option CLINs). The 'Total Price' will auto-calculate.
2. Follow instructions on the 'Common Parts', 'OEM Parts', & 'Price-Listed Batteries' tabs for filling out these tabs. The 'Grand Totals' for these 3 tabs will be added together and will auto-populate into this tab to be the proposed value for CLIN 0002 (and associated option CLINS). Please note that prices you provide in this worksheet for CLIN 0002 (and associated option CLINs) 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 (and associated option CLINs). These pre-filled amounts for are provided to establish a total evaluated price (TEP) for price analysis purposes only, and may differ from the awarded CLIN ceiling price.
Base Period
CLINDescriptionTypeUnit DescriptionUnit Quantitiy/MonthsUnit PriceTotal Price
0001OperationsFFPMonth12$0.00$0.00
0002Price-Listed (PL) PartsT&MGroup12$0.00
0003*Non Price-Listed (NPL) PartsT&MGroup12$2,733,000.00
0004Delivery DriverT&MLabor Hour3,192$0.00$0.00
Total Base$2,733,000.00
Option Year One
CLINDescriptionTypeUnitUnit Quantitiy/MonthsUnitPriceExtended Price
1001OperationsFFPMonth12$0.00$0.00
1002Price-Listed (PL) PartsT&MGroup12$0.00
1003*Non Price-Listed (NPL) PartsT&MGroup12$2,733,000.00
1004Delivery DriverT&MLabor Hour3,192$0.00$0.00
Total Opt Yr$2,733,000.00
Option Year Two
CLINDescriptionTypeUnitUnit Quantity/ MonthsUnitPriceExtended Price
2001OperationsFFPMonth12$0.00$0.00
2002Price-Listed (PL) PartsT&MGroup12$0.00
2003*Non Price-Listed (NPL) PartsT&MGroup12$2,814,990.00
2004Delivery DriverT&MLabor Hour3,192$0.00$0.00
Total Opt Yr$2,814,990.00
Option Year Three
CLINDescriptionTypeUnitUnit Quantitiy/MonthsUnitPriceExtended Price
3001OperationsFFPMonth12$0.00$0.00
3002Price-Listed (PL) PartsT&MGroup12$0.00
3003*Non Price-Listed (NPL) PartsT&MGroup12$2,899,439.70
3004Delivery DriverT&MLabor Hour3,192$0.00$0.00
Total Opt Yr$2,899,439.70
Option Year Four
CLINDescriptionTypeUnitUnit Quantitiy/MonthsUnitPriceExtended Price
4001OperationsFFPMonth12$0.00$0.00
4002Price-Listed (PL) PartsT&MGroup12$0.00
4003*Non Price-Listed (NPL) PartsT&MGroup12$0.00$2,986,422.89
4004Delivery DriverT&MLabor Hour3,192$0.00$0.00
Total Opt Yr$2,986,422.89
52.217-8 Option to Extend Services (6 months)
CLINDescriptionTypeUnitUnit Quantitiy/MonthsUnitPriceExtended Price
N/AOperationsFFPMonth6$0.00$0.00
N/APrice-Listed (PL) PartsT&MGroup6$0.00
N/ANon Price-Listed (NPL) PartsT&MGroup6$0.00$1,493,211.45
N/ADelivery DriverT&MLabor Hour532$0.00$0.00
Total Opt Period$1,493,211.45

Total Evaluated Price $15,660,064.04

Common Parts

RFQ PRICE SHEET QUOTESDate:
CONTRACTOR:Base/Option Year:

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 1334 - Filter, OilVarious Forklifts36$0.00$0.00
NAPA 1347 - Filter, OilVarious Forklifts71$0.00$0.00
NAPA 3025 - Fuel Additive, DieselVarious171$0.00$0.00
NAPA 3128 - Filter, FuelVarious Forklifts49$0.00$0.00
NAPA 4316 - Filter, Cabin AirInternational35$0.00$0.00
NAPA 6022 - Wiper BladesVarious256$0.00$0.00
NAPA 6489 - Filter, AirJohn Deere61$0.00$0.00
NAPA 7182 - Filter, OilInternational, Freightliner48$0.00$0.00
NAPA 7701 - Filter, TransmissionInternational, Freightliner, Kenworth68$0.00$0.00
NAPA 1748XD - Filter, OilInternational, Pierce45$0.00$0.00
Grand Total$0.00

OEM Parts

RFQ PRICE SHEET QUOTESDate:
CONTRACTOR:Base/Option Year:

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
15951646 - LensChevrolet24$0.00$0.00
3546619C92 - Door LockInternational5$0.00$0.00
15691885 - HousingChevrolet21$0.00$0.00
2506721C91 - Lock CylinderInternational6$0.00$0.00
3545580C2 - SwitchInternational6$0.00$0.00
Grand Total$0.00

Price-Listed Batteries

RFQ PRICE SHEET QUOTESDate:
CONTRACTOR:Base/Option Year:

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 StudVarious240$0.00$0.00
Battery, Group 31P - Top Mount StudVarious36$0.00$0.00
Battery, Group 24 - Top Mount StudVarious81$0.00$0.00
6 Volt AGMLow Speed Vehicles88$0.00$0.00
12 Volt Gel-CellLow Speed Vehicles72$0.00$0.00
Grand Total$0.00

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