ESBD_510341_1777574963681_SOL_EXH_F.8_Mandatory Pricing Schedule.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- DPS Austin HQ's & Florence TTC Plumbing Services
- Solicitation number
- 405-26R0009652
- Issued by
- Travis County, Austin City, Texas
About this file
This is a mandatory pricing schedule for a plumbing services contract solicitation (405-26R0009652) issued by the Department of Public Safety (DPS) for Austin Headquarters and Florence Training and Tactics Center locations in Texas. The contract encompasses comprehensive plumbing maintenance and repair services across multiple skill levels and time periods. Vendors must provide pricing for Master Technician, Technician, Apprentice, and Project Management hourly rates, as well as set trip charges for service calls. The pricing schedule includes three distinct service rate categories: business day and business hours, after-hours service, and holiday hours. The contract term spans five years with separate pricing required for each year. An example milestone worth $200,000 ($100,000 per job for two jobs) is provided as a reference point for evaluation purposes.
The pricing schedule requires vendors to establish hourly rates for each technician classification and service period, with all rates currently showing $0.00 placeholders pending vendor submission. Additionally, vendors must specify material cost markups for parts and supplies across eight tiered price ranges ($0.01–$100.00 through $25,001–$50,000), with a maximum allowable markup of 20 percent, plus separate markup percentages for miscellaneous supplies, services, and rental equipment. The scenario-based pricing section includes estimated quantities for evaluation purposes only, projecting approximately $43,930 in potential costs based on assumed labor hours and material expenditures. The pricing schedule explicitly requires vendors to complete and return this spreadsheet with their response; failure to do so may result in proposal rejection. All pricing must be entered in Excel format for each of the five contract years.
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
Pricing Schedule
| Mandatory Pricing Schedule Exhibit | ||||||||||||||||||
| SOLICITATION No.: | 405-26R0009652 | |||||||||||||||||
| SOLICITATION NAME: | DPS Austin HQ's & Florence TTC Plumbing Services | |||||||||||||||||
| VENDOR NAME: | ||||||||||||||||||
| Anticipated Go Live Date: | ||||||||||||||||||
| Contract Term Year One | Contract Term Year Two | Contract Term Year Three | Contract Term Year Four | Contract Term Year Five | ||||||||||||||
| Item # | NIGP | Item Description | Proposal/Solicitation Reference Section | Period of Performance | Quantity | Unit of Measure | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Unit Price | Extended Price | Total Estimated Cost for Life of Contract | |
| Ex. 1 | 938-62 | Ex. Milestone 1 | Ex. Section C.11.2-C.11.4 | Ex. 06/15/2020 - 06/14/2021 | 2 | JOB | $100,000.00 | $200,000.00 | $100,000.00 | $200,000.00 | $100,000.00 | $200,000.00 | $100,000.00 | $200,000.00 | $100,000.00 | $200,000.00 | Ex. $200,000 | |
| Service Rates - Business Day and Business Hours | ||||||||||||||||||
| 1 | 910/60 | Master Technician rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 2 | 910/60 | Technician rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 3 | 910/60 | Apprentice rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 4 | 910/60 | Project Management rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 5 | 910/60 | Set Trip Charge for Service Calls | 1 | EA | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| Service Rates - After Hours | ||||||||||||||||||
| 6 | 910/60 | Master Technician rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 7 | 910/60 | Technician rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 8 | 910/60 | Apprentice rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 9 | 910/60 | Project Management rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 10 | 910/60 | Set Trip Charge for Service Calls | 1 | EA | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| Service Rates - Holiday Hours | ||||||||||||||||||
| 11 | 910/60 | Master Technician rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 12 | 910/60 | Technician rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 13 | 910/60 | Apprentice rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 14 | 910/60 | Project Management rate per hour | 1 | HR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 15 | 910/60 | Set Trip Charge for Service Calls | 1 | EA | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| Percentage for material cost markup or supply charges - Not to exceed 20% |
ENTER % IN UNIT PRICE COLUMN
| 16 | 910/60 | Percentage on Vendor Cost for Parts $0.01 - $100.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 17 | 910/60 | Percentage on Vendor Cost for Parts $100.01 - $250.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 18 | 910/60 | Percentage on Vendor Cost for Parts $250.01 - $500.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 19 | 910/60 | Percentage on Vendor Cost for Parts $500.01 - $1,000.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 20 | 910/60 | Percentage on Vendor Cost for Parts $1,000.01 - $5,000.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 21 | 910/60 | Percentage on Vendor Cost for Parts $5,000.01 - $10,000.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 22 | 910/60 | Percentage on Vendor Cost for Parts $10,000.01 - $25,000.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 23 | 910/60 | Percentage on Vendor Cost for Parts $25,000.01 - $50,000.00 | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 24 | 910/60 | Percentage on Vendor Cost for Misc. Supplies, Services or Parts | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 25 | 910/60 | Percentage on Vendor Cost for Rental Equipment | 1 | LOT | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| 30 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 31 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 32 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 33 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 34 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 35 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 36 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 37 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 38 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 39 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 40 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 41 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 42 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 43 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 44 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 45 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 46 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 47 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 48 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 49 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 50 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| NOTES: THIS SPREADSHEET MUST BE RETURNED WITH THE RESPONSE. FAILURE TO RESPOND ON THE PRICING SCHEDULE MAY LEAD TO A REJECTED RESPONSE. PRICING SCHEDULE IS IN EXCEL FORMAT. ENTER UNIT PRICE FOR HOURLY RATES, TRIP CHARGE, AND PERCENTAGE MARKUP FOR EACH CONTRACT YEAR TERM. | $0.00 |
Scenario Pricing
| Mandatory Pricing Schedule Exhibit - Scenario Based Pricing | ||||||||||
| SOLICITATION No.: | 405-26R0009652 | |||||||||
| SOLICITATION NAME: | DPS Austin HQ's & Florence TTC Plumbing Services | |||||||||
| VENDOR NAME: | ||||||||||
| Anticipated Go Live Date: | ||||||||||
| SCENARIO BASED PRICING | ||||||||||
| Item # | NIGP | Item Description | Quantity | Unit of Measure | Unit Price | Extended Price | ||||
| Ex. 1 | 938-62 | Ex. Milestone 1 | 2 | JOB | $100,000.00 | $200,000.00 | ||||
| Service Rates - Business Day and Business Hours | $0.00 | SUBTOTAL | ||||||||
| 1 | 910/60 | Master Technician rate per hour | 8 | HR | $0.00 | $0.00 | ||||
| 2 | 910/60 | Technician rate per hour | 40 | HR | $0.00 | $0.00 | ||||
| 3 | 910/60 | Apprentice rate per hour | 80 | HR | $0.00 | $0.00 | ||||
| 4 | 910/60 | Project Management rate per hour | 8 | HR | $0.00 | $0.00 | ||||
| 5 | 910/60 | Set Trip Charge for Service Calls | 5 | EA | $0.00 | $0.00 | ||||
| Service Rates - After Hours | $0.00 | SUBTOTAL | ||||||||
| 6 | 910/60 | Master Technician rate per hour | 8 | HR | $0.00 | $0.00 | ||||
| 7 | 910/60 | Technician rate per hour | 16 | HR | $0.00 | $0.00 | ||||
| 8 | 910/60 | Apprentice rate per hour | 32 | HR | $0.00 | $0.00 | ||||
| 9 | 910/60 | Project Management rate per hour | 8 | HR | $0.00 | $0.00 | ||||
| 10 | 910/60 | Set Trip Charge for Service Calls | 2 | EA | $0.00 | $0.00 | ||||
| Service Rates - Holiday Hours | $0.00 | SUBTOTAL | ||||||||
| 11 | 910/60 | Master Technician rate per hour | 4 | HR | $0.00 | $0.00 | ||||
| 12 | 910/60 | Technician rate per hour | 8 | HR | $0.00 | $0.00 | ||||
| 13 | 910/60 | Apprentice rate per hour | 16 | HR | $0.00 | $0.00 | ||||
| 14 | 910/60 | Project Management rate per hour | 4 | HR | $0.00 | $0.00 | ||||
| 15 | 910/60 | Set Trip Charge for Service Calls | 1 | EA | $0.00 | $0.00 | ||||
| Percentage for material cost markup or supply charges - Not to exceed 20% | ||||||||||
| ENTER % IN UNIT PRICE COLUMN | $43,930.00 | SUBTOTAL | ||||||||
| 16 | 910/60 | Percentage on Vendor Cost for Parts $0.01 - $100.00 | $10.00 | LOT | 0.00% | $10.00 | ||||
| 17 | 910/60 | Percentage on Vendor Cost for Parts $100.01 - $250.00 | $110.00 | LOT | 0.00% | $110.00 | ||||
| 18 | 910/60 | Percentage on Vendor Cost for Parts $250.01 - $500.00 | $260.00 | LOT | 0.00% | $260.00 | ||||
| 19 | 910/60 | Percentage on Vendor Cost for Parts $500.01 - $1,000.00 | $510.00 | LOT | 0.00% | $510.00 | ||||
| 20 | 910/60 | Percentage on Vendor Cost for Parts $1,000.01 - $5,000.00 | $1,010.00 | LOT | 0.00% | $1,010.00 | ||||
| 21 | 910/60 | Percentage on Vendor Cost for Parts $5,000.01 - $10,000.00 | $5,010.00 | LOT | 0.00% | $5,010.00 | ||||
| 22 | 910/60 | Percentage on Vendor Cost for Parts $10,000.01 - $25,000.00 | $10,010.00 | LOT | 0.00% | $10,010.00 | ||||
| 23 | 910/60 | Percentage on Vendor Cost for Parts $25,000.01 - $50,000.00 | $25,010.00 | LOT | 0.00% | $25,010.00 | ||||
| 24 | 910/60 | Percentage on Vendor Cost for Misc. Supplies, Services or Parts | $1,000.00 | LOT | 0.00% | $1,000.00 | ||||
| 25 | 910/60 | Percentage on Vendor Cost for Rental Equipment | $1,000.00 | LOT | 0.00% | $1,000.00 | ||||
| 30 | $0.00 | |||||||||
| 31 | $0.00 | |||||||||
| 32 | $0.00 | |||||||||
| 33 | $0.00 | |||||||||
| 34 | $0.00 | |||||||||
| 35 | $0.00 | |||||||||
| 36 | $0.00 | |||||||||
| 37 | $0.00 | |||||||||
| 38 | $0.00 | |||||||||
| 39 | $0.00 | |||||||||
| 40 | $0.00 | |||||||||
| 41 | $0.00 | |||||||||
| 42 | $0.00 | |||||||||
| 43 | $0.00 | |||||||||
| 44 | $0.00 | |||||||||
| 45 | $0.00 | |||||||||
| 46 | $0.00 | |||||||||
| 47 | $0.00 | |||||||||
| 48 | $0.00 | |||||||||
| 49 | $0.00 | |||||||||
| 50 | $0.00 | |||||||||
| THIS SCHEDULE IS FOR EVALUATION PURPOSES ONLY, QUANTITIES ARE ESTIMATED, AND WILL BE USED TO EVALUATE VENDOR RESPONSES. UPON AWARD OF A CONTRACT/PURCHASE ORDER, THE AMOUNT WILL BE SET AT THE ESTIMATED AMOUNT DPS MAY SPEND. | $43,930.00 | TOTAL |
File details come from the government source that posted it. Updated .