ESBD_419151_1749845286195_Exhibit_C-1_Freight Contract Pricing Sheet.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
HHSC Emergency Mgmt Seeks Emergency Freight Services
Solicitation number
HHS0016008
Issued by
Texas

About this file

This document is a Freight Contract Pricing Sheet (Exhibit C-1) that appears to be part of a state or local government transportation services procurement. The spreadsheet details a comprehensive pricing structure for various transportation assets including semi-tractors, trucks, and trailers with different configurations such as dry, refrigerated, and freezer units. The pricing sheet includes multiple rate options for each vehicle type, including daily, weekly, monthly, and per-mile rates, as well as delivery and pickup rates. The contract includes a Consumer Price Index (CPI-W) calculation mechanism for potential price adjustments during renewal periods, with an initial CPI increase of 9.3% specified.

The pricing document provides a detailed rate matrix with all entries currently showing $0.00, suggesting this is a template or draft pricing document. The contract includes provisions for on-site support at a State Operations Center, with 12-hour and 24-hour shift options. The CPI calculation section links to the Bureau of Labor Statistics website for historical CPI-W index data, indicating a standardized approach to potential future price escalations. The document appears designed to establish a flexible pricing framework for transportation and logistics services, with multiple vehicle and service configurations to meet potential government transportation needs.

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

Price List - CPI Calculation

Initial Term PricingPricing for CPI increase for Renewal 1- 9.3%
Itemclass- itemItem DescriptionQTYUMunit pricesub - totalunit pricesub-total
Transportation Asset with Driver
1

HHSCUser: ECPS users

Increase row height by holding and pulling the bottom line of the row down to the height needed.958-47Semi-tractor Truck Load 53 Foot Trailer
2Daily Rate1Day$0.00$0.00
3Weekly Rate1Week$0.00$0.00
4Montly Rate1Month$0.00$0.00
5Per Mile Cost1Mile$0.00$0.00
6Trucks not ordered1Each$0.00$0.00
7958-47Semi-tractor- Less than Truck Load Size
8Daily Rate1Day$0.00$0.00
9Weekly Rate1Week$0.00$0.00
10Montly Rate1Month$0.00$0.00
11Per Mile Cost1Mile$0.00$0.00
12Trucks not ordered1Each$0.00$0.00
13958-47Straight Truck with box- refrigerated/freezer
14Daily Rate1Day$0.00$0.00
15Weekly Rate1Week$0.00$0.00
16Montly Rate1Month$0.00$0.00
17Per Mile Cost1Mile$0.00$0.00
18Trucks not ordered1Each$0.00$0.00
19958-47Semi-Tractor with box-dry
20Daily Rate1Day$0.00$0.00
21Weekly Rate1Week$0.00$0.00
22Montly Rate1Month$0.00$0.00
23Per Mile Cost1Mile$0.00$0.00
Trucks not ordered1Each$0.00$0.00
24958-47Semi-tractor- no trailer
25Daily Rate1Day$0.00$0.00
26Weekly Rate1Week$0.00$0.00
27Montly Rate1Month$0.00$0.00
28Per Mile Cost1Mile$0.00$0.00
29Trucks not ordered1Each$0.00$0.00
Trailers
30958-47Truck load-53 Foot Trailer-Dry
31Daily Rate1Day$0.00$0.00
32Weekly Rate1Week$0.00$0.00
33Montly Rate1Month$0.00$0.00
34Per Mile Cost1Mile$0.00$0.00
35Delivery Rate1Each$0.00$0.00
36Pickup Rate1Each$0.00$0.00
37Trucks not ordered1Each$0.00$0.00
38958-47Less than Truck Load Size Trailer-Dry
39Daily Rate1Day$0.00$0.00
40Weekly Rate1Week$0.00$0.00
41Montly Rate1Month$0.00$0.00
42Per Mile Cost1Mile$0.00$0.00
43Delivery Rate1Each$0.00$0.00
44Pickup Rate1Each$0.00$0.00
45Trailers not ordered1Each$0.00$0.00
46958-47Truck load-53 Foot Trailer-Refrigerated/Freezer Trailer
47Daily Rate1Day$0.00$0.00
48Weekly Rate1Week$0.00$0.00
49Montly Rate1Month$0.00$0.00
50Per Mile Cost1Mile$0.00$0.00
51Delivery Rate1Each$0.00$0.00
52Pickup Rate1Each$0.00$0.00
53Trucks not ordered1Each$0.00$0.00
54958-47Less than Truck Load Size Trailer-Refrigerated/Freezer Trailer
55Daily Rate1Day$0.00$0.00
56Weekly Rate1Week$0.00$0.00
57Montly Rate1Month$0.00$0.00
58Per Mile Cost1Mile$0.00$0.00
59Delivery Rate1Each$0.00$0.00
60Pickup Rate1Each$0.00$0.00
61Trucks not ordered1Each$0.00$0.00
62990-36On-site Support at State Operations Center
6312-hour shift1Each$0.00$0.00
6424-hour shift1Each$0.00$0.00

CPI-W Calculation Consumer Price Index Calculations

CPI Index at exercise of Renewal Period DATE

CPI Baseline Index at Bid Opening DATE

Subtract CPI Index at exerice of Renewal Period from CPI Base Line Index at Bid Opening Date = Index Point Change
0.00

Divide Index Point Change by Baseline Index at Bid Opening ERROR:#DIV/0!

Result multiply by 100 =
Percent Increase Allowed Rounded to Nearest 0.10%ERROR:#DIV/0!

CPI W Index Link

CPI-W
https://www.bls.gov/regions/southwest/data/consumerpriceindexhistorical_us1967_table.pdf

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