CTR077170_Pricing.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- Master Agreement AZ|CTR077170
- Contract number
- CTR077170
- Issued by
- Arizona
About this file
I apologize, but no document was actually uploaded with the placeholder tag . Without the specific Excel file (CTR077170_Pricing.xlsx) to review, I cannot generate a summary of its contents. If you would like me to analyze the document, please upload the complete file and I will carefully review and provide a professional summary as requested.
View the file
Other files
Show all 11
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: | |
| X | Category One: OEM Parts |
| Category 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? |
| Yes - Motorcraft (Ford) | AC-Delco (GM) | |
| Yes - AC-Delco (GM) | Motorcraft (Ford) |
| 1.3 If offering category Two and/or Three, provide the following information for all repair locations: | ||
| Name of Contractor | Physical Address | Additional Information |
| 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 | |
| Yes | |
| 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) 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 | |
| No |
Towing Flat Rate fee for the first 30 miles Towing Flat Rate fee for Increments of 15 Miles thereafter Notes
| 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: |
| We offer the manufacturer's warranty which is a minimum of 12 months. |
| 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). |
| none |
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/Level | Minimum Percentage (%) Off Discount |
| AC Delco - Discount off of Parts Authority Catalog "List" Price - column "G" less 62% | 62% |
| Motorcraft - Discount off of Parts Authority Catalog "List" Price - column "G" less 67% | 67% |
| 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 Parts | Estimated Annual Quantity | Price Per Each $ | Extended $ (Price X QTY) |
| Air filter for 2021 Chevrolet Impala or equal | 12 | 4.37 | $ 52.44 |
| Oil filer for 2022 Ford F150 or equal | 12 | 9.16 | $ 109.92 |
| Total amount to be entered into Line #1 in the APP Line Items tab | |
| $ 162.36 |
| 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 applicable | Counties | Charges if Applicable |
| Apache | ||
| Cochise | ||
| Coconino | ||
| Gila | ||
| Graham | ||
| Greenlee | ||
| La Paz | ||
| X | Maricopa | |
| Mohave | ||
| Navajo | ||
| X | Pima | |
| X | Pinal | |
| Santa Cruz | ||
| Yavapai | ||
| X | Yuma | |
| (X) here for all of the above Counties |
2.3 The contractor may add any additional information regarding delivery of OEM parts:
| 2.4 Is there a cut-off time for same day delivery? | 2.5 If yes, indicate the cut-off time | ||
| Yes | 11:59 | AM | |
| No | PM |
| 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 ($) | ||
| $0.00 | $0.00 | $0.00 | 90 days |
| 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. |
| For items with core charges (see attached price files) - credit will be issued for returned cores. Other than batteries, few parts have core charges. |
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 Level | Estimated Quantity -Annually | Rate Price per Hour | Extended Amount (Rate X Estimated Quantity) |
| Base Labor Rate for OEM Automotive Repair for Light Duty Vehicles | 1000 | $_______ | ERROR:#VALUE! |
| $_______ | |||
| $_______ | |||
| $_______ | |||
| $_______ | |||
| $_______ | |||
| $_______ | |||
| $_______ | |||
| $_______ | |||
| $_______ | |||
| Total amount to be entered into Line #2 in the APP Line Items tab | |||
| ERROR:#VALUE! |
| 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 miles | Flat Rate fee for |
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 miles | Flat Rate fee for |
Labor Rate per hour Notes
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.
| 3.5 Auto Body Option: Does the Contractor offer Auto Body Repair including Paint for OEM Labor and Repair? | |
| Yes | |
| No |
| 3.6 If yes, Indicate any and all labor rates for Auto Body Work. | |
| Labor Tier/Level Detail | Auto Body Repair Labor Rate Per Hour: |
| Notes |
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 Level | Estimated Quantity -Annually | Rate Price per Hour | Extended Amount (Rate X Estimated Quantity) |
| Base Labor Rate Non-OEM Automotive Repair | 1000 | $_______ | 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 miles | Flat 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 miles | Flat 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 Detail | Auto Body Repair Labor Rate Per Hour: |
| Notes |
File details come from the government source that posted it. Updated .