Problem Solving with Jonny 5

Is your fuel surcharge set right?

Your fuel surcharge was set based on what diesel cost when you negotiated it. If diesel has moved since then — and it has — the math may no longer work in your favor. Select your region, enter your details, and Jonny 5 shows exactly how much you are covering or absorbing per week.

💡

This week: West Coast diesel is $1.50/gal more than Gulf Coast. A 10-truck fleet running 2,500 miles/week pays $5,000 more per week on the West Coast. Select your region below to see your actual numbers.

NEUTRAL Diesel Forecast vs Current — Week of June 06 2026

Current Diesel (National)$5.350/gal

Your RegionSelect below

13-Week Forecast$5.347/gal

Disruption Scenario$5.546/gal

Surcharge Gap Calculator

Select your region — calculations use your actual regional diesel price.

Your Region

Weekly Miles Per Truck

Average MPG

Number of Trucks

Current Surcharge ($/mile)

Gallons/Week—

Surcharge Revenue/Week—

Fuel Cost/Week (Your Region)—

Weekly Gap—

What will fuel cost on jobs you are bidding today?

Select your region. Enter your job details. See your actual fuel cost under three scenarios before you commit.

💡

This week: West Coast diesel is $1.50/gal more than Gulf Coast. If you are bidding cross-country jobs, the fuel cost on the return leg may be dramatically different from the outbound leg.

Forward Bid Calculator

Your Region

Total Job Miles

Number of Trucks

Average MPG

Your Bid Rate ($/mile)

Conservative

$5.228/gal

—

Base Forecast

$5.347/gal

—

Supply Disruption

$5.546/gal

—

What should you lock in with suppliers this week?

Food cost inflation does not announce itself. It builds upstream — in energy prices, freight costs, and manufacturing inputs — weeks before it hits your supplier invoices.

GPPI: 1.05 MODERATE PRESSURE

Review supplier contracts within 30 days. Moderate upstream pressure building.

Category Pressure — What to Do This Week

Category	YoY Change	Signal	Action
Cereals & Bakery	2.6%	Moderate	Review soon
Meat, Poultry & Fish	1.8%	Low	Monitor
Dairy	6.1%	High	Lock in now
Fruits & Vegetables	5.1%	High	Lock in now

Margin Impact Calculator — By Food Segment

Enter your weekly spend by category. Each segment uses its actual upstream pressure signal from the GPPI. Total margin impact reflects your specific product mix.

Proteins — ($/week)
Moderate pressure

Dairy — ($/week)
High pressure

Produce — ($/week)
High pressure

Dry Goods — ($/week)
Moderate pressure

Total Weekly Food Cost$4,000

Projected Cost Increase--

Highest Risk Category--

Annual Margin Impact--

Proteins Impact/yr--

Dairy Impact/yr--

Produce Impact/yr--

Dry Goods Impact/yr--

What do you need to order and when?

Stockouts do not happen because demand spikes unexpectedly. They happen because nobody did the math far enough in advance.

Inventory Risk Calculator

Current Inventory (units)

Average Weekly Sales (units)

Supplier Lead Time (weeks)

Revenue Per Unit ($)

Weeks of Supply—

Reorder Point—

Recommended Order—

Revenue at Risk—

The signals your costs follow — before you feel them

Crude oil moves first. Diesel follows within 1-2 weeks. Freight costs adjust within 2-4 weeks. Your supplier invoices reflect it 4-8 weeks later. These are the live readings — updated weekly.

💡

This week: West Coast diesel ($6.398/gal) vs Gulf Coast ($4.900/gal) = $1.50/gal spread. A 10-truck fleet running 2,500 miles/week pays $5,000 more per week on the West Coast. That is $260,000/year.

What to watch this week — June 06 2026

Crude Oil

WTI crude at $95.96/bbl — +47% year over year. Supply disruption scenario is not theoretical at current levels.

Food Cost Pressure

GPPI at 1.05 — moderate pressure. Dairy showing highest upstream cost signal at 6.1% YoY.

Diesel Forecast Range

Diesel forecast range: $5.228 (conservative) to $5.546 (supply disruption) over 13 weeks vs current $5.350. Base scenario shows modest relief — conditions may improve.

Regional Diesel Prices — This Week

EIA PADD district prices. Updated weekly. Select your region on the Trucker and Fleet tabs to use your actual price.

Region	Current Price	vs Last Week	vs National Avg	10-Truck Fleet Impact
Gulf Coast	$4.900/gal	-0.145	-0.450	Cheapest ✅
East Coast	$5.237/gal	-0.157	-0.113	+$1,123/wk vs Gulf Coast
Rocky Mountain	$5.331/gal	-0.162	-0.019	+$1,437/wk vs Gulf Coast
Midwest	$5.392/gal	-0.231	+0.042	+$1,640/wk vs Gulf Coast
West Coast	$6.398/gal	-0.102	+1.048	+$4,993/wk vs Gulf Coast

10-truck fleet impact based on 2,500 miles/week per truck at 7.5 MPG vs Gulf Coast (cheapest region).

Diesel Price — 52 Week History + 13 Week Forecast

Solid = actual | Dashed = base forecast | Shaded = scenario range

Grocery Price Pressure Index — 12 Month History

Rising GPPI leads food cost inflation by 4-8 weeks.

Fuel Price Forward Range — 13 Weeks

Three scenarios based on WTI crude trajectory. National average.

Conservative
WTI -15%

$5.228/gal

-0.122 vs current

Base Forecast
Current trajectory

$5.347/gal

-0.003 vs current

Supply Disruption
WTI +25%

$5.546/gal

+0.196 vs current

The Transmission Chain

When crude oil moves, your costs follow.

🛢️

WTI Crude Oil — $95.96/bbl (+47% YoY)
The root signal. Everything downstream follows crude.

↓ 1-2 weeks

⛽

Diesel Retail Price — $5.350/gal national | $4.900 (Gulf) to $6.398 (West Coast)
Regional spreads reflect local refinery capacity, taxes, and transport costs.

↓ 2-4 weeks

🚛

Trucking and Freight Costs
Carriers pass diesel costs into freight rates. Regional price differences directly affect route profitability.

↓ 4-8 weeks

🛒

Grocery and Food Prices — GPPI 1.05 (Moderate Pressure)
By the time this moves, operators with no early warning have already lost margin.

The problem this tool solves

Every week, operators across America make decisions that cost them money — not because they are bad at their jobs, but because they are flying blind on what is coming.

A trucker sets a fuel surcharge in January and finds out in March it does not cover diesel anymore. A fleet operator bids a job at $2.50/mile and watches the margin disappear when fuel spikes. A restaurant owner gets hit with a supplier invoice 15% higher than last month with no warning. An e-commerce operator runs out of their best SKU during peak season because their forecast was last month sales in a spreadsheet.

None of these are surprises. The signals are visible weeks in advance. The problem is that nobody was translating them into plain language for the people who actually need it. That is what Jonny 5 does.

How it works

Jonny 5 pulls live data from FRED every week. That data feeds into multivariate forecasting models built on the Hyndman/Fable methodology — the same statistical framework used in enterprise forecasting systems at publicly traded companies. The output is not a chart for a data scientist. It is a verdict for an operator.

Data sources

Source	What it provides	Frequency
FRED (Federal Reserve)	Retail fuel prices by region (PADD), CPI, PPI, consumer sentiment	Weekly / Monthly
EIA (US Energy Information Administration)	Crude oil prices, regional diesel by PADD district	Daily / Weekly
BLS (Bureau of Labor Statistics)	Food at home CPI, category price indices	Monthly

Forecasting Methods

Jonny 5 uses three model types. For each series all three are fit and evaluated — the best performer on a holdout period is selected automatically.

Model	What it does	When it wins
ETS Error, Trend, Seasonality	Captures trend and seasonal patterns	Stable series with clear seasonality — retail fuel prices, food CPI
ARIMA Autoregressive Integrated Moving Average	Captures autocorrelation — last week price informs this week	Series with strong momentum or mean-reversion
ARIMAX ARIMA with external regressors	ARIMA plus macro signals as leading indicators	When external forces drive the series — WTI predicts diesel

The three scenarios

Scenario	Assumption	What it models
Conservative	WTI crude drops 15%	Demand weakness, supply recovery, de-escalation
Base	Current trajectory continues	No major macro shifts from current conditions
Supply Disruption	WTI crude rises 25%	Supply shock from geopolitical disruption or OPEC cut

Why this matters: The forecast range is not a guess. It is the output of a model evaluated on real held-out data before deployment. Wider uncertainty bands mean less predictable conditions — which is itself information worth acting on.

Data Dictionary — What is actually in the model

Jonny 5 pulls 20+ data series every week. Here is what each one is, where it comes from, and why it matters.

Fuel Series

Series	Source	What it measures	Why it matters
WTI Crude Oil	EIA via FRED	West Texas Intermediate spot price, daily	The upstream driver of all refined fuel prices. Moves first, everything else follows
Retail Diesel (National)	EIA via FRED	Weekly retail on-highway diesel, US average	Direct operating cost for every fleet and trucking operation
Retail Diesel (PADD 1-5)	EIA via FRED	Weekly retail diesel by region	Regional spreads can exceed $1.50/gal — the national average hides this
Brent Crude	EIA via FRED	North Sea benchmark, weekly	International crude benchmark. Diverges from WTI during geopolitical events
Natural Gas Spot	EIA via FRED	Henry Hub spot price	Input cost for fertilizer, food manufacturing, and cold chain logistics
Retail Gasoline	EIA via FRED	Weekly retail regular gasoline, US average	Consumer cost signal — affects sentiment and discretionary spending
Gas Days Supply	EIA via FRED	Weeks of gasoline supply on hand	Inventory signal. Below seasonal average = upward price pressure
Refinery Capacity	EIA via FRED	US refinery utilization rate	Below 90% tightens refined product supply. Diesel most sensitive

Grocery & Food Series

Series	Source	What it measures	Why it matters
Food at Home CPI	BLS via FRED	Consumer prices for groceries	The headline number restaurant and food operators feel in supplier invoices
Cereals & Bakery CPI	BLS via FRED	Category-level food price index	Grain and wheat cost pass-through — driven by energy and fertilizer costs
Meats, Poultry & Fish CPI	BLS via FRED	Category-level food price index	Energy-intensive cold chain. Sensitive to diesel and natural gas moves
Dairy CPI	BLS via FRED	Category-level food price index	High energy intensity — refrigeration, transport, feed costs
Fruits & Vegetables CPI	BLS via FRED	Category-level food price index	Highly seasonal and fuel-sensitive due to long-haul transport
PPI Food Manufacturing	BLS via FRED	Producer prices for food processors	Leads consumer food prices by 4-8 weeks
PPI Trucking	BLS via FRED	Producer prices for freight transport	Measures diesel cost pass-through into food distribution costs

Macro Series

Series	Source	What it measures	Why it matters
Consumer Sentiment	U of Michigan via FRED	Monthly consumer confidence index	Leading indicator of demand. Falling sentiment precedes demand weakness
Real PCE	BEA via FRED	Real personal consumption expenditures	Actual consumer spending. The broadest demand signal in the model
CPI All Items	BLS via FRED	Headline consumer inflation	Baseline inflation context for all price signals
Unemployment Rate	BLS via FRED	Monthly unemployment	Demand and wage pressure signal
Real Disposable Income	BEA via FRED	Inflation-adjusted household income	Strongest predictor of consumer goods demand in the e-commerce model

Track record

Company	What was built	Result
Intuit / QuickBooks	Growth forecasting models feeding Wall Street earnings guidance	Sub-3% error on a multi-billion dollar revenue base
Gogo Air	Route-level demand forecasting across 8 airlines	3-person team managed 13,000 daily flights
BevMo	Pricing intelligence for 200 locations	Manual Excel replaced with automated R systems
Independent trading	Quantitative models targeting pricing inefficiencies	7 years, consistent 3-5% annual ROI on multi-million dollar portfolios

This is the public version

The tools here use live macro data to demonstrate the methodology. If you want Jonny 5 running on your actual business data — your SKUs, your routes, your supplier contracts — that is a conversation worth having.

Get in touch →