CTR073960_Pricing_11.16.2024.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- Master Agreement AZ|CTR073960
- Contract number
- CTR073960
- Issued by
- Arizona
About this file
The document is an Excel spreadsheet (CTR073960_Pricing_11.16.2024.xlsx) detailing a state and local contract pricing structure for Tartan Oil, covering fuel pricing across multiple Arizona counties including Apache, Cochise, Coconino, Gila, Graham, Greenlee, La Paz, Maricopa, Mohave, Navajo, Pima, Pinal, Santa Cruz, Yavapai, and Yuma.
The pricing document provides a comprehensive margin structure for various fuel types, including Diesel, Red Dye Diesel, Low Sulfur Diesel, Unleaded, Unleaded Oxygenated, Diesel Winter Blend, B20 Clear Diesel Fuel, and Flex Fuel. Pricing is stratified by volume tiers: 0-1,000 gallons, 1,000-4,000 gallons, and 4,000-10,000 gallons, with consistent emergency delivery charges of $150 across all counties. The margins vary slightly by county and fuel type, ranging from negative margins (as low as -0.011) to positive margins (up to 0.7439), reflecting potential volume discounts and regional pricing variations. The contract appears valid through November 16, 2024, offering a structured pricing mechanism for fuel procurement across Arizona's diverse geographical regions.
View the file
Other files
Show all 27
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
Sheet1
| Tartan Oil Price Structure | Apache | Cochise | Coconino | Gila | Graham | Greenlee | La Paz | Maricopa | Mohave | Navajo | Pima | Pinal | Santa Cruz | Yavapai | Yuma |
| Contractor's Margin ($ per Gallon) | |||||||||||||||
| Do NOT Include Taxes | |||||||||||||||
| Diesel | |||||||||||||||
| 0 to 1,000 gallons | 0.7339 | 0.701 | 0.6908 | 0.668 | 0.6934 | 0.7263 | 0.663 | 0.6123 | 0.6858 | 0.7212 | 0.6756 | 0.6427 | 0.6934 | 0.6503 | 0.668 |
| 1,000 to 4,000 gallons | 0.2706 | 0.2376 | 0.2275 | 0.2047 | 0.23 | 0.263 | 0.1997 | 0.149 | 0.2224 | 0.2579 | 0.2123 | 0.1794 | 0.23 | 0.187 | 0.2047 |
| 4,000 to 10,000 gallons | 0.1106 | 0.0776 | 0.0675 | 0.0447 | 0.07 | 0.103 | 0.0397 | -0.011 | 0.0624 | 0.0979 | 0.0523 | 0.0194 | 0.07 | 0.027 | 0.0447 |
| Emergency Delivery Charge | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
| Red Dye Diesel | |||||||||||||||
| 0 to 1,000 gallons | 0.7339 | 0.701 | 0.6908 | 0.668 | 0.6934 | 0.7263 | 0.663 | 0.6123 | 0.6858 | 0.7212 | 0.6756 | 0.6427 | 0.6934 | 0.6503 | 0.668 |
| 1,000 to 4,000 gallons | 0.2706 | 0.2376 | 0.2275 | 0.2047 | 0.23 | 0.263 | 0.1997 | 0.149 | 0.2224 | 0.2579 | 0.2123 | 0.1794 | 0.23 | 0.187 | 0.2047 |
| 4,000 to 10,000 gallons | 0.1106 | 0.0776 | 0.0675 | 0.0447 | 0.07 | 0.103 | 0.0397 | -0.011 | 0.0624 | 0.0979 | 0.0523 | 0.0194 | 0.07 | 0.027 | 0.0447 |
| Emergency Delivery Charge | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
| Low Sulfur Diesel | |||||||||||||||
| 0 to 1,000 gallons | 0.7339 | 0.701 | 0.6908 | 0.668 | 0.6934 | 0.7263 | 0.663 | 0.6123 | 0.6858 | 0.7212 | 0.6756 | 0.6427 | 0.6934 | 0.6503 | 0.668 |
| 1,000 to 4,000 gallons | 0.2706 | 0.2376 | 0.2275 | 0.2047 | 0.23 | 0.263 | 0.1997 | 0.149 | 0.2224 | 0.2579 | 0.2123 | 0.1794 | 0.23 | 0.187 | 0.2047 |
| 4,000 to 10,000 gallons | 0.1106 | 0.0776 | 0.0675 | 0.0447 | 0.07 | 0.103 | 0.0397 | -0.011 | 0.0624 | 0.0979 | 0.0523 | 0.0194 | 0.07 | 0.027 | 0.0447 |
| Emergency Delivery Charge | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
| Unleaded | |||||||||||||||
| 0 to 1,000 gallons | 0.7113 | 0.6832 | 0.6746 | 0.6552 | 0.6768 | 0.7048 | 0.6508 | 0.6077 | 0.6703 | 0.7005 | 0.6616 | 0.6336 | 0.6768 | 0.6401 | 0.6552 |
| 1,000 to 4,000 gallons | 0.218 | 0.1899 | 0.1813 | 0.1618 | 0.1834 | 0.2115 | 0.1575 | 0.1143 | 0.1769 | 0.2072 | 0.1683 | 0.1402 | 0.1834 | 0.1467 | 0.1618 |
| 4,000 to 10,000 gallons | 0.078 | 0.0499 | 0.0413 | 0.0218 | 0.0434 | 0.0715 | 0.0175 | -0.0257 | 0.0369 | 0.0672 | 0.0283 | 0.0002 | 0.0434 | 0.0067 | 0.0218 |
| Emergency Delivery Charge | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
| Unleaded Oxygenated | |||||||||||||||
| 0 to 1,000 gallons | 0.6077 | 0.6336 | |||||||||||||
| 1,000 to 4,000 gallons | 0.1143 | 0.1402 | |||||||||||||
| 4,000 to 10,000 gallons | -0.0257 | 0.0002 | |||||||||||||
| Emergency Delivery Charge | 150 | 150 |
| Diesel Winter Blend | |||||||||||||||
| 0 to 1,000 gallons | 0.7439 | 0.711 | 0.7008 | 0.678 | 0.7034 | 0.7363 | 0.673 | 0.6223 | 0.6958 | 0.7312 | 0.6856 | 0.6527 | 0.7034 | 0.6603 | 0.678 |
| 1,000 to 4,000 gallons | 0.2806 | 0.2476 | 0.2375 | 0.2147 | 0.24 | 0.273 | 0.2097 | 0.159 | 0.2324 | 0.2679 | 0.2223 | 0.1894 | 0.24 | 0.197 | 0.2147 |
| 4,000 to 10,000 gallons | 0.1206 | 0.0876 | 0.0775 | 0.0547 | 0.08 | 0.113 | 0.0497 | -0.001 | 0.0724 | 0.1079 | 0.0623 | 0.0294 | 0.08 | 0.037 | 0.0547 |
| Emergency Delivery Charge | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
| B20 Clear Diesel Fuel | |||||||||||||||
| 0 to 1,000 gallons | 0.7339 | 0.701 | 0.6908 | 0.668 | 0.6934 | 0.7263 | 0.663 | 0.6123 | 0.6858 | 0.7212 | 0.6756 | 0.6427 | 0.6934 | 0.6503 | 0.668 |
| 1,000 to 4,000 gallons | 0.2806 | 0.2476 | 0.2375 | 0.2147 | 0.24 | 0.273 | 0.2097 | 0.159 | 0.2324 | 0.2679 | 0.2223 | 0.1894 | 0.24 | 0.197 | 0.2147 |
| 4,000 to 10,000 gallons | 0.1206 | 0.0876 | 0.0775 | 0.0547 | 0.08 | 0.113 | 0.0497 | -0.001 | 0.0724 | 0.1079 | 0.0623 | 0.0294 | 0.08 | 0.037 | 0.0547 |
| Emergency Delivery Charge | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
| Flex Fuel | |
| 0 to 1,000 gallons | 0.6077 |
| 1,000 to 4,000 gallons | 0.1143 |
| 4,000 to 10,000 gallons | -0.0257 |
| Emergency Delivery Charge | 150 |
File details come from the government source that posted it. Updated .