IFB_7800_TJP1027_0600_v1.xlsx
XLSX spreadsheet 53 KB Posted
- Solicitation number
- IFB 7800 TJP1027
- Issued by
- Texas
About this file
This is a Pricing Submittal Sheet template for Invitation for Bid (IFB) 7800 TJP1027 issued by the City of Austin, Texas, for vehicle painting, dent repair, and refinishing services under Procurement Specialist Tanisha Pappillion. The solicitation encompasses four primary service categories: labor rates for light-duty vehicles (Category 1A) with estimated annual quantities ranging from 150 to 250 hours across body labor, mechanical labor, and refinish labor; labor rates for medium and heavy-duty vehicles (Category 1B) with identical hour estimates; materials markup charges (Category 2) with an estimated annual material spend of $55,000; and miscellaneous services (Category 3) including pickup and delivery of city vehicles and expedited services. The contract does not specify response dates, due dates, site visits, bidder conferences, award dates, or renewal options in this template document.
Offerors must submit pricing using the provided template without alteration, with all prices all-inclusive of administrative costs, overhead, per-diem, and shipping or transportation to the Austin, Texas area. The estimated annual total across all categories is $73,350. Markup to costs for materials shall not exceed 15 percent and must account for all delivery and overhead expenses. Bidders must confirm ASE or I-CAR certification status, technician experience requirements, facility capabilities for expedited and in-house repairs, proximity to the State Capitol, and submission of manufacturer price lists. The City reserves the right to award a single contract or multiple awards based on overall low cost or other criteria deemed most advantageous. No specific set-asides, incumbent information, or funding sources are identified in this template document.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| IFB_7800_TJP1027_0600_v2.xlsx | XLSX spreadsheet | |
| IFB_7800_TJP1027_ADD_1_v1.pdf | ||
| RFQS_6100_CLMP392_ATT_20_v3.pdf | ||
| IFB_7800_TJP1027_ATT_1_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_3_v1.docx | DOCX document | |
| IFB_7800_TJP1027_PAC1_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_6_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_8_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_7_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_2_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_5_v1.docx | DOCX document | |
| IFB_7800_TJP1027_ATT_4_v1.docx | DOCX document |
Show all 12
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 (Delete)
| Instructions for Excel Sheet Templates | These Price Sheets replace the old Bid Sheets. They are templates and can be modified to fit the solicitation, as needed. Procurement Specialist should adjust as needed and remove the additional sheets from the template before sending the solicitation out for publication (including the instruction sheet). | |
| The templates are unlocked. It is recommended that you lock the cells before issuing the solicitation. | In order to lock certain cells you need to protect the sheet under the format dropdown. From there you can enter a password (or not) to lock the cells. Then go back to the format cells dropdown and lock any needed cells. | |
| Please note that the buyer can pick and choose which categories will best apply for the solicitation. | Not every sheet has the same amount of rows and columns so you might have to format a bit. | |
| RED TEXT indicates areas that need your attention. Update, delete, or change the font color as necessary. | Ex: See Services bid sheet, Category 2. | |
| Taking out categories or cells may change the formulas, double check formulas before sending out. | In order to see the formulas select the cell and look at the bar under your ribbon. | |
| Read every section thoroughly and ensure each line is filled in completely and numbered correctly. | Ex: SERVICES in category 3 there are blanks for the buyer to fill out. |
COMMODITIES
Solicitation
PRICE SHEET
| SOLICITATION # | IFB 7800 TJP1027 |
| PROCUREMENT SPECIALIST | TANISHA PAPPILLION |
Special Instructions: Offerors must use this Pricing Submittal Sheet to submit pricing.
Be advised that altering the Pricing Submittal Sheet or taking exceptions to any portion of the solicitation may jeopardize acceptance of your Offer.
The quantities noted below are estimates and not a guarantee of actual volume. The City does not guarantee the purchase of the quantities listed, actual purchases may be more or less. Quantities are provided as a guide based on historical or anticipated usage. Order quantities will be as-needed and specified by the City for each order.
A bid of "0" (zero) will be interpreted by the City as a no-charge (free) item and the City will not expect to pay for that item. A bid of "no bid" or no response (space left blank) will be interpreted by the City that the Offeror does not wish to bid on that item. Be advised, a "no bid" or no response may be considered as non-responsive and may result in disqualification of the bid.
Prices offered on the Pricing Submittal Sheet shall be all inclusive of fees not expressly allowed in the scope of work. The Offeror shall not charge separately for administrative, overhead, per diem, and shipping or transportation costs (travel time, fuel surcharges, mileage, stop-fee, etc.) to deliver services or items to the Austin, Texas area. The Offeror shall provide all tools, labor, travel, and equipment necessary to perform the services required under this contract.
The City reserves the right to award a single contract based on overall low cost or multiple awards based on individual or categories/groups of specific line items, cost, or any criteria or combination deemed most advantageous to the City.
| CATEGORY 1A - LABOR RATE - GROUP 1 VEHICLES (CARS, LIGHT TRUCKS UP TO 14,000 GVW OR UP TO 24 FEET IN LENGTH) | ||||||
| ITEM NO. | ITEM DESCRIPTION | UNIT OF MEASURE | ESTIMATED ANNUAL QUANTITY | UNIT PRICE* | ||
| *Unit price should be no more than 4 decimal places | EXTENDED PRICE | |||||
| 1.1 | Body Labor - Steel bodies | HOUR | 250 | $8.00 | $2,000.00 | |
| 1.2 | Body Labor - Aluminum Bodies | HOUR | 150 | $8.00 | $1,200.00 | |
| 1.3 | Mechanical Labor | HOUR | 150 | $8.00 | $1,200.00 | |
| 1.4 | Refinish Labor - Steel Bodies | HOUR | 150 | $8.00 | $1,200.00 | |
| 1.5 | Refinish Labor - Aluminum Bodies | HOUR | 150 | $8.00 | $1,200.00 | |
| 1.6 | Paint Materials | HOUR | 250 | $8.00 | $2,000.00 | |
| TOTAL FOR CATEGORY 1A = | $8,800.00 |
| CATEGORY 1B - LABOR RATE - GROUP 2 VEHICLES (MEDIUM & HEAVY DUTY VEHICLES ABOVE 14,000 GVW OR ABOVE 24 FEET IN LENGTH) | ||||||
| ITEM NO. | ITEM DESCRIPTION | UNIT OF MEASURE | ESTIMATED ANNUAL QUANTITY | UNIT PRICE* | ||
| *Unit price should be no more than 4 decimal places | EXTENDED PRICE | |||||
| 2.1 | Body Labor - Steel bodies | HOUR | 250 | $8.00 | $2,000.00 | |
| 2.2 | Body Labor - Aluminum Bodies | HOUR | 150 | $8.00 | $1,200.00 | |
| 2.3 | Mechanical Labor | HOUR | 150 | $8.00 | $1,200.00 | |
| 2.4 | Refinish Labor - Steel Bodies | HOUR | 150 | $8.00 | $1,200.00 | |
| 2.5 | Refinish Labor - Aluminum Bodies | HOUR | 150 | $8.00 | $1,200.00 | |
| 2.6 | Paint Materials | HOUR | 250 | $8.00 | $2,000.00 | |
| TOTAL FOR CATEGORY 1B = | $8,800.00 |
CATEGORY 2 - MARKUP TO COSTS FOR MATERIALS
The City estimates an annual spending need of $55,000 for non-specified auto body repair parts.
Offeror shall be able to provide materials to complete the repairs. The percentage markup to costs listed shall be the maximum amount offered for the category line throughout the term of the contract including any subsequent renewal periods, and are not subject to change. The invoice prices for these materials shall be based off a markup to costs paid by the offeror as indicated below. The percentage markup given should take into all costs (administrative, overhead, shipping charges, etc.) to deliver the materials to the Austin, TX area. These costs shall be factored into the markup to costs rates and shall not be paid separately. Markup to costs shall be expressed in numerical terms and not exceed 15%. A bid of '0' (zero) or left blank will be interpreted by the City as a zero percent markup to the City.
The annual spending need amount is an estimate and not a guarantee of actual volume. The City reserves the right to purchase more or less of these quantities as may be required during the contract Term. Quantities will be as-needed and specified by the City for each order.
| ITEM NO. | ITEM DESCRIPTION | ESTIMATED ANNUAL MATERIAL SPEND | MARKUP TO COSTS | ||
| (PERCENTAGE) | EXTENDED PRICE | ||||
| 2.1 | Markup to Costs for all related Materials and associated Components (not to exceed 15%) | $25,000.00 | 10.00% | $27,500.00 | |
| 2.2 | Markup to Subcontracting Costs [DESCRIPTION] (not to exceed 15%) | $25,000.00 | 10.00% | $27,500.00 | |
| TOTAL FOR CATEGORY 2 = | $55,000.00 |
| CATEGORY 3 - MISCELLANEOUS SERVICES | |||||
| ITEM NO. | DESCRIPTION | ESTIMATED ANNUAL QUANTITY | UNIT | UNIT PRICE | EXTENDED PRICE |
| 3.1 | FLAT FEE FOR ROUND TRIP PICKUP AND DELIVERY OF CITY VEHICLES | 100 | EA | $5.00 | $500.00 |
| 3.2 | FLAT FEE FOR EXPEDITED SERVICES | 50 | EA | $5.00 | $250.00 |
| TOTAL FOR CATEGORY 3 = | $750.00 |
TOTAL EXTENDED PRICE FOR CATEGORIES 1 THRU 3 = $73,350.00
| SECTION 4 - CONFIRMATION OF REQUIREMENTS | ||
| 5.2 | How many ASE or I-CAR certified technicians do you have? | ___________________NUMBER OF Certified TECHNICIANS |
| 5.3 | Do the service technicians have three years of hands-on experience in the last five years? | ○ YES ○ NO |
| 5.4 | Is your Repair Facility able to provide expedited repairs? | ○ YES ○ NO |
| 5.5 | State the distance your Repair Facility is to the Texas State Capitol. | ____________________________ MILES |
| 5.6 | Is your Repair Facility able to provide alignment and mechanical repairs in-house? | ○ YES ○ NO |
| 5.7 | Is the Manufacturer's Price List included with the bid? | ○ YES ○ NO |
| DELIVERY TERMS: FOB Destination, Freight Pre-paid and Allowed |
| DELIVERY METHOD: COMMON CARRIER _________ VENDOR STAFF ________ |
| EMAIL ADDRESS: |
&"Arial,Regular"&9Section 0600 - Bid Sheet &"Arial,Regular"&9Page &P of &N
SERVICES
Solicitation
PRICE SHEET
| SOLICITATION |
| PROCUREMENT SPECIALIST |
Special Instructions: Offerors must use this Pricing Submittal Sheet to submit pricing.
Be advised that altering the pricing submittal sheet or taking exceptions to any portion of the solicitation may jeopardize acceptance of your Offer.
The quantities noted below are estimates and not a guarantee of actual volume. The City does not guarantee the purchase of the quantities listed, actual purchases may be more or less. Quantities are provided as a guide based on historical or anticipated usage. Order quantities will be as-needed and specified by the City for each order.
A bid of "0" (zero) will be interpreted by the City as a no-charge (free) item and the City will not expect to pay for that item. A bid of "no bid" or no response (space left blank) will be interpreted by the City that the Offeror does not wish to bid on that item. Be advised, a "no bid" or no response may be considered as non-responsive and may result in disqualification of the bid.
Prices offered on the Pricing Submittal Sheet shall be all inclusive of fees not expressly allowed in the scope of work. The Offeror shall not charge separately for administrative, overhead, per diem, and shipping or transportation costs (travel time, fuel surcharges, mileage, stop-fee, etc.) to deliver services or items to the Austin, Texas area. The Offeror shall provide all tools, labor, travel, and equipment necessary to perform the services required under this contract.
The City reserves the right to award a single contract based on overall low cost or multiple awards based on individual or categories/groups of specific line items, cost, or any criteria or combination deemed most advantageous to the City.
| CATEGORY 1 - HOURLY LABOR RATE | ||||
| ITEM NO. | LABOR | ESTIMATED ANNUAL HOURS | HOURLY RATE | EXTENDED PRICE |
| 1.1 | Labor rate for services during normal business hours, defined as Monday through Friday 6:00 am - 5:00 pm | 1,000 | $25.00 | $25,000.00 |
| 1.2 | Labor rate for services after hours, defined as Monday through Friday 5:01 pm - 5:59 am, Saturday and Sunday and City holidays | 500 | $50.00 | $25,000.00 |
| 1.3 | ||||
| 1.4 | ||||
| 1.5 | ||||
| SUBTOTAL FOR CATEGORY 1 = | $50,000.00 |
CATEGORY 2 - ROUTINE AND PREVENTIVE MAINTENANCE
Proposer must be able to establish and provide routine and preventive maintenance for all types of requested services as described in Section 0500 - Scope of Work, Paragraph #.#.# (of the scope of work). The prices for these routine and preventive maintenance services shall include all labor, transportation, and material costs (lubrication, cleaning, towels, etc.). If additional repair services are needed, those repairs shall be invoiced separately using Category 1 pricing for Labor and Category 3 pricing for Materials.
| ITEM NO. | ITEM DESCRIPTION | ESTIMATED ANNUAL QUANTITY | UNIT PRICE | ||
| (EACH) | EXTENDED PRICE | ||||
| 2.1 | Flat fee for Routine and Preventative Maintenance Services (services descriptor or range) | 12 | $100.00 | $1,200.00 | |
| 2.2 | |||||
| 2.3 | |||||
| 2.4 | |||||
| 2.5 | |||||
| SUBTOTAL FOR CATEGORY 2 = | $1,200.00 |
CATEGORY 3 - MARKUP TO COSTS FOR MATERIALS
The City estimates an annual spending need of $(enter dollar amount) for materials to complete these services.
Offeror shall be able to provide materials to complete the repairs. The percentage markup to costs listed shall be the maximum amount offered for the category line throughout the term of the contract including any subsequent renewal periods, and are not subject to change. The invoice prices for these materials shall be based off a markup to costs paid by the offeror as indicated below. The percentage markup given should take into all costs (administrative, overhead, shipping charges, etc.) to deliver the materials to the Austin, TX area. These costs shall be factored into the markup to costs rates and shall not be paid separately. Markup to costs shall be expressed in numerical terms and not exceed 25% (or specified percentage amount). A bid of '0' (zero) or left blank will be interpreted by the City as a zero percent markup to the City.
The annual spending need amount is an estimate and not a guarantee of actual volume. The City reserves the right to purchase more or less of these quantities as may be required during the contract Term. Quantities will be as-needed and specified by the City for each order.
| ITEM NO. | ITEM DESCRIPTION | ESTIMATED ANNUAL MATERIAL SPEND | MARKUP TO COSTS | ||
| (PERCENTAGE) | EXTENDED PRICE | ||||
| 3.1 | Markup to Costs for all related Materials and associated Components (not to exceed 25%) | $350,000.00 | 25.00% | $437,500.00 | |
| SUBTOTAL FOR CATEGORY 3 = | $437,500.00 |
TOTAL EXTENDED PRICE FOR CATEGORIES 1 THRU 3 = $488,700.00
CATEGORY 4 - NON-SPECIFIED SERVICES (Pricing for this Category will not be used to determine award.)
Please list any additional related services your Company can offer the City along with an associated labor rate, discount off retail price or mark-up to costs for the listed services. Information in this Category will not be evaluated, and the City does not guarantee the purchase of any additional services. Revisions to the prices may only be adjusted using the Published Price Lists provision in Section 0400. Please include additional pages as necessary.
| ITEM NO. | ITEM DESCRIPTION | UNIT OF MEASURE | UNIT PRICE |
| 4.1 | General Services Labor Rate | Hour | |
| 4.2 | |||
| 4.3 | |||
| 4.4 |
ADDITIONAL CATEGORIES BELOW:
Insert and use as necessary.
CATEGORY 5 - (OPERATIONAL CATEGORY FORMAT)
| ITEM NO. | ITEM DESCRIPTION | ESTIMATED ANNUAL (UNIT OF MEASURE) | UNIT PRICE | EXTENDED PRICE |
| 5.1 | ||||
| 5.2 | ||||
| 5.3 | ||||
| 5.4 | ||||
| 5.5 | ||||
| 5.6 | ||||
| 5.7 | ||||
| 5.8 | ||||
| SUBTOTAL FOR CATEGORY 5 = |
CATEGORY 6 - DISCOUNT OFF OR MARKUP TO MANUFACTURER PRICE LISTS FOR NON-SPECIFIED PRODUCTS (For Informational Purposes Only)
The City may require the Offeror to provide additional products as they relate to this contract. In order to be paid for those additional products, provide manufacturers name and catalog numbers for the additional products you can provide the City. Indicate the minimum percentage discount or maximum markup to costs you can provide the City for these products. The percentage discount(s) or markup(s) listed shall be fixed throughout the term of the Contract including any subsequent renewal periods.
This information will not be used in the evaluation of the bid but is for informational purposes only and there is no guarantee of purchase. Please include additional pages as necessary.
| ITEM NO | NAME AND NUMBER OF PRICE LIST | LATEST EFFECTIVE DATE OF PRICE LIST | MINIMUM DISCOUNT FROM OR MAXIMUM MARKUP TO PRICE LIST |
| 6.1 |
Name ____________________________________________________________________
Number ___________________________________________________________________ _______________% Discount or ________________% Markup 6.2 Name ____________________________________________________________________
Number ___________________________________________________________________ _______________% Discount or ________________% Markup 6.3 Name ____________________________________________________________________
Number ___________________________________________________________________ _______________% Discount or ________________% Markup 6.4 Name ____________________________________________________________________
Number ___________________________________________________________________ _______________% Discount or ________________% Markup
| COMPANY NAME: |
| EMAIL ADDRESS: |
&"Arial,Regular"&9Section 0600 - Bid Sheet &"Arial,Regular"&9Page &P of &N image1.png
File details come from the government source that posted it. Updated .