CTR077154_Pricing.xlsx

XLSX spreadsheet 37 KB Posted

Attached to
Master Agreement AZ|CTR077154
Contract number
CTR077154
Issued by
Arizona

About this file

I apologize, but I cannot provide a summary of the document as no actual file content was uploaded in the message. The text provided only shows a GovTribe ID and a filename (CTR077154_Pricing.xlsx), but does not include the actual document contents. Without being able to read the specific details of the contract, pricing, or scope of work, I cannot generate an accurate professional summary. If you would like me to analyze the document, please upload or paste the full text or contents of the Excel spreadsheet.

View the file

Other files

Show all 13

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

Instructions (READ FIRST) Instructions for the Offer Response Form for Automotive Parts and Repair for Light Duty Vehicles attachment:

The Offer Response Form for Automotive Parts and Repair for Light Duty Vehicles is made up of the following sections: General Information, OEM Parts, OEM Labor and Repair, Labor and Repair with non-OEM parts which coincide with the tabs listed below. All Contractors placing a Bid Submittal shall at a minimum Complete the General Information Tab and any and all tabs for the categories being offered. Extended Amounts for each evaluation section must be entered into the items tab in the Arizona Procurement Portal.

Category One: OEM Parts
Category Two: OEM Labor and Repair
Category Three: Labor and Repair with non-OEM parts

General Information

Offer Response Form for Automotive Parts and Repair for Light Duty Vehicles
Automotive Parts and Repair for Light Duty Vehicles - BPM006653

General Information

Instructions: The Contractor shall complete the sections of the General Information tab below to include 1.1 thru 1.8 to be considered for an award per section 4 of the Scope of Work.

1.1 The Contractor may provide goods/services described in any or all of the categories listed below. The Contractor shall indicate the categories with an (X) that are being offered:
XCategory One: OEM Parts
XCategory Two: OEM Labor and Repair
Category Three: Vehicle Labor and Repair with non-OEM parts
1.2 If offering category One and or Two, complete the following:
Are you a current authorized dealer?Are you an authorized distributer?What Manufacturer are you offering?
YESYESFORD/MOTORCRAFT
1.3 If offering category Two and/or Three, provide the following information for all repair locations:
Name of ContractorPhysical AddressAdditional Information
Don Sanderson Ford6400 N 51st Avenue Glendale, AZ 85301
1.4 Does the Contractor offer statewide coverage for categories two and/or three, OEM Labor and Repair and Automotive Labor and repair with non-OEM parts
XYes
No
1.5 If the contractor offers coverage area for categories two and or three, OEM Labor and Repair and Automotive Labor and repair with non-OEM parts by county, they may indicate with an (X) next to the applicable counties
Apache
Cochise
Coconino
Gila
Graham
Greenlee
La Paz
Maricopa
Mohave
Navajo
Pima
Pinal
Santa Cruz
Yavapai
Yuma
X(X) Statewide Coverage
1.6 Does the Contractor offer Towing service? If yes, note towing charges for the service area indicated. (Paragraph 4.2.10 and 4.3.9 in the Scope of Work)
Yes
XNo

Towing Flat Rate fee for the first 30 miles Towing Flat Rate fee for Increments of 15 Miles thereafter

Notes
N/AN/A
1.7 The Offeror must explain their minimum warranties that are included for all products and repairs per paragraph 5.2 of the Scope of Work for all three categories:
All Ford & Motorcraft parts carry a minimum of 24-months/unlimited mileage part warranty, with extended coverages for certain products
OEM parts installed at the OEM Provider, customer paid 24 months/unlimited Mileage
1.8 The Offeror must list any Purchasing Card surcharges associated with payment of parts or services by the agency (Paragraph 5.3 in the Scope of Work).
Not applicable

1. OEM Parts

Offer Response Form for Automotive Parts and Repair for Light Duty Vehicles
Automotive Parts and Repair for Light Duty Vehicles - BPM006653

Pricing for OEM Parts

Instructions: The Contractor shall complete the sections of the OEM Parts tab below to include 2.1 thru 2.7 to be considered for an award for this category per section 4.1 of the Scope of Work.

2.1 Category 1, OEM Parts Pricing:The Contractor shall provide pricing structures for any and all manufacture parts list being offered in accordance to section 4.1 of the Scope of Work. Additionally the Contractor shall provide evaluation pricing in the table below labeled Evaluation Pricing. The Contractor shall enter the total extended amount in RED below to Line #1 in APP under the line items tab.

Class/Items/Tier/LevelMinimum Percentage (%) Off Discount
FORD (INCLUDES LINCOLN, MERCURY)COST + 15%
MOTORCRAFTCOST + 10%
GENERAL MOTORS (INCLUDES BUICK, CADILLAC, CHEVROLET, GMC, PONTIAC, SAAB, SATURN)LIST - 30%
STELLANTIS (INCLUDES CHRYSLER, JEEP, DODGE, RAM)LIST - 30%
NISSANLIST - 30%
TOYOTALIST - 15%
HONDALIST - 15%
Evalaution Pricing: The contractor shall provide pricing for the listed evaluation parts. The pricing provided for the evaluation parts will be used in evaluation.
Evaluation PartsEstimated Annual QuantityPrice Per Each $Extended $ (Price X QTY)
Air filter for 2021 Chevrolet Impala or equal12$ - 0
Oil filer for 2022 Ford F150 or equal126.49$ 77.88
Total amount to be entered into Line #1 in the APP Line Items tab
$ 77.88
2.2 Delivery for category one, OEM Parts (Paragraph 4.1.4 in the Scope of Work) Indicate with an (X), the counties that delivery of parts is available and the applicable charges associated with:
Mark (X) where applicableCountiesCharges if Applicable
Apache15
Cochise15
Coconino$ 15.00
Gila15
Graham15
Greenlee15
La Paz15
Maricopa0
Mohave15
Navajo15
Pima15
Pinal15
Santa Cruz15
Yavapai15
Yuma15
X(X) here for all of the above Counties
2.3 The contractor may add any additional information regarding delivery of OEM parts:
No charge for deliveries in Maricopa County. $15.00 per invoice charge for deliveries in all other counties
2.4 Is there a cut-off time for same day delivery?2.5 If yes, indicate the cut-off time
XYesAM
No2PM
2.6 Restocking Fees for category one, OEM Parts (Paragraph 4.1.3.4 in the Scope of Work) Indicate any applicable charges:
Restocking fees for Special Order Parts ($)Restocking fees for non-special order parts ($)
Restocking fees for Obsolete Parts returns ($)Notes: i.e. Time from delivery restrictions ($)
20% OF SALE PRICE OF PARTNONE35% OF SALE PRICE OF PARTReturns after 180 days are subject to prior approval
2.7 Core Charge for category one, OEM Parts (Paragraph 4.1.3.3 in the Scope of Work). Indicate if there is a Core charge program. Explain requirements and if any timeframes apply.
YES - Core charge program for all applicable parts
TIMEFRAME - As long as manufacturer still lists core in price tape, part is eligible for full core return value regardless of return date

2. OEM Labor and Repair

Offer Response Form for Automotive Parts and Repair for Light Duty Vehicles
Automotive Parts and Repair for Light Duty Vehicles - BPM006653

Labor for OEM Repair

Instructions: The Contractor shall complete the sections of the OEM Labor and Repair tab below to include 3.1 thru 3.6 to be considered for an award for this category per section 4.2 of the Scope of Work.

3.1 OEM Labor Rates: For category 2, the Contractor shall provide labor rates for any labor levels that may be applicable to the service being offered. This may include Field Service, Emergency After Hours etc. Any additional labor rates shall be listed.The base Labor rate will be used for evaluation purposes. Below indicate all labor rates as required in section 4.2.

Contractor shall enter the extended total amount in RED to Line #2 in APP under the line items tab.

Labor LevelEstimated Quantity -AnnuallyRate Price per HourExtended Amount (Rate X Estimated Quantity)
Base Labor Rate for OEM Automotive Repair for Light Duty Vehicles1000122.5$ 122,500.00
$_______
$_______
$_______
$_______
$_______
$_______
$_______
$_______
$_______
Total amount to be entered into Line #2 in the APP Line Items tab
$ 122,500.00
3.2 Pickup Delivery Service for OEM Labor and Repair and Automotive Labor and repair (Paragraph 4.2.8 in the Specifications). This should be indicated as a flat rate fee.
Flat Rate fee for the first 30 milesFlat Rate fee for

Increments of 15 Miles thereafter Notes

3.3 Field Service Call for OEM Labor and Repair and Automotive Labor and repair (Paragraph 4.2.11)
Flat Rate fee for the first 30 milesFlat Rate fee for

Increments of 15 Miles thereafter

Labor Rate per hourNotes
$122.5020 mile radius
3.4 Labor Time Calulation: For category two OEM Labor and Repair and Automotive Labor, indicate how labor times are calculated as required in paragraph 4.2.4.1.
All Data
3.5 Auto Body Option: Does the Contractor offer Auto Body Repair including Paint for OEM Labor and Repair?
XYes
No
3.6 If yes, Indicate any and all labor rates for Auto Body Work.
Labor Tier/Level DetailAuto Body Repair Labor Rate Per Hour:
Notes
Body$60.00
Frame$80.00
Mechanical$122.50
Paint$60.00
Paint and Materials$45.00
Aluminum$120.00
Parts15% of MSRP

3. Labor and Repair non OEM

Offer Response Form for Automotive Parts and Repair for Light Duty Vehicles
Automotive Parts and Repair for Light Duty Vehicles - BPM006653

Labor for Non-OEM Repair

Instructions: The Contractor shall complete the sections of the Labor and Repair non OEM tab below to include 4.1 thru 4.6 to be considered for an award for this category per section 4.3 of the Scope of Work.

4.1 Labor for Non-OEM Repair: For category three, the Contractor shall provide labor rates for any labor levels that may be applicable to the service being offered. This may include Field Service, Emergency After Hours etc. Any additional labor rates shall be listed. The base Labor rate will be used for evaluation purposes. Below indicate all labor rates as required in section 4.3.

Contractor shall enter the extended total amount in RED to Line #3 in APP under the line items tab.

Labor LevelEstimated Quantity -AnnuallyRate Price per HourExtended Amount (Rate X Estimated Quantity)
Base Labor Rate Non-OEM Automotive Repair1000$_______ERROR:#VALUE!
$_______
$_______
$_______
$_______
$_______
$_______
$_______
Total amount to be entered into Line #3 in the APP Line Items tab
ERROR:#VALUE!
4.2 Pickup Delivery Service for OEM Labor and Repair and Automotive Labor and repair (Paragraph 4.3.8 in the Specifications). This should be indicated as a flat rate fee.
Flat Rate fee for the first 30 milesFlat Rate fee for

Notes

4.3 Field Service Call for OEM Labor and Repair and Automotive Labor and repair (Paragraph 4.4)
Flat Rate fee for the first 30 milesFlat Rate fee for

Labor Rate per hour Notes

4.4 Labor Time Calulation: For category two OEM Labor and Repair and Automotive Labor, indicate how labor times are calculated as required in paragraph 4.3.4.1.

4.5 Auto Body Option: Does the Contractor offer Auto Body Repair including Paint for OEM Labor and Repair?
Yes
No
4.6 If yes, Indicate any and all labor rates for Auto Body Work.
Labor Tier/Level DetailAuto Body Repair Labor Rate Per Hour:
Notes

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