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 OneContract Term Year TwoContract Term Year ThreeContract Term Year FourContract Term Year Five
Item #NIGPItem DescriptionProposal/Solicitation Reference SectionPeriod of PerformanceQuantityUnit of MeasureUnit PriceExtended PriceUnit PriceExtended PriceUnit PriceExtended PriceUnit PriceExtended PriceUnit PriceExtended PriceTotal Estimated Cost for Life of Contract
Ex. 1938-62Ex. Milestone 1Ex. Section C.11.2-C.11.4Ex. 06/15/2020 - 06/14/20212JOB$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.00Ex. $200,000
Service Rates - Business Day and Business Hours
1910/60Master Technician rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
2910/60Technician rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
3910/60Apprentice rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
4910/60Project Management rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
5910/60Set Trip Charge for Service Calls1EA$0.00$0.00$0.00$0.00$0.00$0.00
Service Rates - After Hours
6910/60Master Technician rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
7910/60Technician rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
8910/60Apprentice rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
9910/60Project Management rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
10910/60Set Trip Charge for Service Calls1EA$0.00$0.00$0.00$0.00$0.00$0.00
Service Rates - Holiday Hours
11910/60Master Technician rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
12910/60Technician rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
13910/60Apprentice rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
14910/60Project Management rate per hour1HR$0.00$0.00$0.00$0.00$0.00$0.00
15910/60Set Trip Charge for Service Calls1EA$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

16910/60Percentage on Vendor Cost for Parts $0.01 - $100.001LOT0.00%0.00%0.00%0.00%0.00%
17910/60Percentage on Vendor Cost for Parts $100.01 - $250.001LOT0.00%0.00%0.00%0.00%0.00%
18910/60Percentage on Vendor Cost for Parts $250.01 - $500.001LOT0.00%0.00%0.00%0.00%0.00%
19910/60Percentage on Vendor Cost for Parts $500.01 - $1,000.001LOT0.00%0.00%0.00%0.00%0.00%
20910/60Percentage on Vendor Cost for Parts $1,000.01 - $5,000.001LOT0.00%0.00%0.00%0.00%0.00%
21910/60Percentage on Vendor Cost for Parts $5,000.01 - $10,000.001LOT0.00%0.00%0.00%0.00%0.00%
22910/60Percentage on Vendor Cost for Parts $10,000.01 - $25,000.001LOT0.00%0.00%0.00%0.00%0.00%
23910/60Percentage on Vendor Cost for Parts $25,000.01 - $50,000.001LOT0.00%0.00%0.00%0.00%0.00%
24910/60Percentage on Vendor Cost for Misc. Supplies, Services or Parts1LOT0.00%0.00%0.00%0.00%0.00%
25910/60Percentage on Vendor Cost for Rental Equipment1LOT0.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 #NIGPItem DescriptionQuantityUnit of MeasureUnit PriceExtended Price
Ex. 1938-62Ex. Milestone 12JOB$100,000.00$200,000.00
Service Rates - Business Day and Business Hours$0.00SUBTOTAL
1910/60Master Technician rate per hour8HR$0.00$0.00
2910/60Technician rate per hour40HR$0.00$0.00
3910/60Apprentice rate per hour80HR$0.00$0.00
4910/60Project Management rate per hour8HR$0.00$0.00
5910/60Set Trip Charge for Service Calls5EA$0.00$0.00
Service Rates - After Hours$0.00SUBTOTAL
6910/60Master Technician rate per hour8HR$0.00$0.00
7910/60Technician rate per hour16HR$0.00$0.00
8910/60Apprentice rate per hour32HR$0.00$0.00
9910/60Project Management rate per hour8HR$0.00$0.00
10910/60Set Trip Charge for Service Calls2EA$0.00$0.00
Service Rates - Holiday Hours$0.00SUBTOTAL
11910/60Master Technician rate per hour4HR$0.00$0.00
12910/60Technician rate per hour8HR$0.00$0.00
13910/60Apprentice rate per hour16HR$0.00$0.00
14910/60Project Management rate per hour4HR$0.00$0.00
15910/60Set Trip Charge for Service Calls1EA$0.00$0.00
Percentage for material cost markup or supply charges - Not to exceed 20%
ENTER % IN UNIT PRICE COLUMN$43,930.00SUBTOTAL
16910/60Percentage on Vendor Cost for Parts $0.01 - $100.00$10.00LOT0.00%$10.00
17910/60Percentage on Vendor Cost for Parts $100.01 - $250.00$110.00LOT0.00%$110.00
18910/60Percentage on Vendor Cost for Parts $250.01 - $500.00$260.00LOT0.00%$260.00
19910/60Percentage on Vendor Cost for Parts $500.01 - $1,000.00$510.00LOT0.00%$510.00
20910/60Percentage on Vendor Cost for Parts $1,000.01 - $5,000.00$1,010.00LOT0.00%$1,010.00
21910/60Percentage on Vendor Cost for Parts $5,000.01 - $10,000.00$5,010.00LOT0.00%$5,010.00
22910/60Percentage on Vendor Cost for Parts $10,000.01 - $25,000.00$10,010.00LOT0.00%$10,010.00
23910/60Percentage on Vendor Cost for Parts $25,000.01 - $50,000.00$25,010.00LOT0.00%$25,010.00
24910/60Percentage on Vendor Cost for Misc. Supplies, Services or Parts$1,000.00LOT0.00%$1,000.00
25910/60Percentage on Vendor Cost for Rental Equipment$1,000.00LOT0.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.00TOTAL

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