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

File Type Posted
2-Pilot Travel SRM ADOT_Boycott_of_Israel.pdf PDF
2-Pilot Travel SRM BPM004763 Price Increase Percentages.pdf PDF
2-Pilot Travel SRM Designation of Confidentiality.pdf PDF
CTR073960_Pricing.xlsx XLSX spreadsheet
ResponseADOT_BAFO_10262022.docx.pdf PDF
2-Pilot Travel BPM004763 Bulk Fuel-Propane PricingSRMFinal.xlsx XLSX spreadsheet
2-Pilot Travel Proposal # 1-prop_items.xls XLS spreadsheet
2-Pilot Travel SRM ADOT Cover Letter.pdf PDF
2-Pilot Travel SRM ADOT Offer and Acceptance.pdf PDF
2-Pilot Travel SRM Method of Approach.pdf PDF
BPM004763 Bulk Fuel-Propane Revised 10-10-2022.pdf PDF
BPM004763 Confidentiality Notification Letter Pilot Travel Center.docx DOCX document
CTR063573 SIR Approved.pdf PDF
SRM ADOT Follow Up.pdf PDF
2-Pilot Travel SRM Emergency Plan.pdf PDF
BPM004763 Bulk Fuel Propane Pricing BAFO 102622.xlsx XLSX spreadsheet
BPM004763 Confidentiality Notification Letter Pilot Travel Center.pdf PDF
CTR063573 Certificate of Insurance Approved.pdf PDF
CTR073960 Usage Report 2025 Q1.pdf PDF
CTR073960_Contract_Amendment_Summary_One__1_.pdf PDF
Pilot Travel Negotations (2).pdf PDF
2-Pilot Travel Financial Envelope-Proposal # 1-prop_answer.xls XLS spreadsheet
2-Pilot Travel SRM Ability and Capacity.pdf PDF
ACCEPTED SIR CTR072014 GL 08.08.24-08.08.25.pdf PDF
CTR073960_Contract_Amendment_Summary_Two__2_.pdf PDF
CTR073960_Contract_Documents.pdf PDF
Pilot Travel Negotations (1).pdf PDF
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 StructureApacheCochiseCoconinoGilaGrahamGreenleeLa PazMaricopaMohaveNavajoPimaPinalSanta CruzYavapaiYuma
Contractor's Margin ($ per Gallon)
Do NOT Include Taxes
Diesel
0 to 1,000 gallons0.73390.7010.69080.6680.69340.72630.6630.61230.68580.72120.67560.64270.69340.65030.668
1,000 to 4,000 gallons0.27060.23760.22750.20470.230.2630.19970.1490.22240.25790.21230.17940.230.1870.2047
4,000 to 10,000 gallons0.11060.07760.06750.04470.070.1030.0397-0.0110.06240.09790.05230.01940.070.0270.0447
Emergency Delivery Charge150150150150150150150150150150150150150150150
Red Dye Diesel
0 to 1,000 gallons0.73390.7010.69080.6680.69340.72630.6630.61230.68580.72120.67560.64270.69340.65030.668
1,000 to 4,000 gallons0.27060.23760.22750.20470.230.2630.19970.1490.22240.25790.21230.17940.230.1870.2047
4,000 to 10,000 gallons0.11060.07760.06750.04470.070.1030.0397-0.0110.06240.09790.05230.01940.070.0270.0447
Emergency Delivery Charge150150150150150150150150150150150150150150150
Low Sulfur Diesel
0 to 1,000 gallons0.73390.7010.69080.6680.69340.72630.6630.61230.68580.72120.67560.64270.69340.65030.668
1,000 to 4,000 gallons0.27060.23760.22750.20470.230.2630.19970.1490.22240.25790.21230.17940.230.1870.2047
4,000 to 10,000 gallons0.11060.07760.06750.04470.070.1030.0397-0.0110.06240.09790.05230.01940.070.0270.0447
Emergency Delivery Charge150150150150150150150150150150150150150150150
Unleaded
0 to 1,000 gallons0.71130.68320.67460.65520.67680.70480.65080.60770.67030.70050.66160.63360.67680.64010.6552
1,000 to 4,000 gallons0.2180.18990.18130.16180.18340.21150.15750.11430.17690.20720.16830.14020.18340.14670.1618
4,000 to 10,000 gallons0.0780.04990.04130.02180.04340.07150.0175-0.02570.03690.06720.02830.00020.04340.00670.0218
Emergency Delivery Charge150150150150150150150150150150150150150150150
Unleaded Oxygenated
0 to 1,000 gallons0.60770.6336
1,000 to 4,000 gallons0.11430.1402
4,000 to 10,000 gallons-0.02570.0002
Emergency Delivery Charge150150
Diesel Winter Blend
0 to 1,000 gallons0.74390.7110.70080.6780.70340.73630.6730.62230.69580.73120.68560.65270.70340.66030.678
1,000 to 4,000 gallons0.28060.24760.23750.21470.240.2730.20970.1590.23240.26790.22230.18940.240.1970.2147
4,000 to 10,000 gallons0.12060.08760.07750.05470.080.1130.0497-0.0010.07240.10790.06230.02940.080.0370.0547
Emergency Delivery Charge150150150150150150150150150150150150150150150
B20 Clear Diesel Fuel
0 to 1,000 gallons0.73390.7010.69080.6680.69340.72630.6630.61230.68580.72120.67560.64270.69340.65030.668
1,000 to 4,000 gallons0.28060.24760.23750.21470.240.2730.20970.1590.23240.26790.22230.18940.240.1970.2147
4,000 to 10,000 gallons0.12060.08760.07750.05470.080.1130.0497-0.0010.07240.10790.06230.02940.080.0370.0547
Emergency Delivery Charge150150150150150150150150150150150150150150150
Flex Fuel
0 to 1,000 gallons0.6077
1,000 to 4,000 gallons0.1143
4,000 to 10,000 gallons-0.0257
Emergency Delivery Charge150

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