Sarah Schlott
  • Home
  • START HERE
  • About
  • Services
    • FP&A Consulting
      • Forecasting & Planning
      • Scenario Modeling
      • Management Reporting
      • Cash Forecasting
      • FP&A Systems & Processes
      • Variance Analysis
      • KPI Dashboards
      • Board Reporting
      • FP&A for PE-Backed Companies
    • Accounting Services
      • Bookkeeping Support
      • Month-End Close
      • Financial Statements
      • Accounts Payable
      • Accounts Receivable
      • Accounting Cleanup
  • FP&A Resources
    • FP&A Library
    • Tools & Templates
    • Budget Variance Calculator
    • Break-Even Calculator
    • Price Increase Calculator
    • Cash Runway Calculator
    • Revenue Growth Calculator
    • Employee Cost Calculator
    • Blog
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
FP&A

Diesel Prices Are Wrecking the Freight Budget. The IEA Says the Squeeze Could Last Into 2027.

Financial charts on desk

Diesel can wreck a company’s margin without the company ever buying a gallon.

That is an impressive talent for a commodity. It sneaks in through the freight invoice, visits a supplier’s surcharge, spends some time in inventory and eventually turns up in the cash forecast wearing a name badge that says “unexpected.”

Meanwhile, the freight budget may still be last year’s actuals plus 3%. Apparently, the template has negotiated better terms with the global energy market than Procurement has with our carriers.

The International Energy Agency’s October report makes that approach particularly hard to defend. My argument isn’t that Finance should predict the exact diesel price. My argument is that we should stop pretending the timing of cost recovery doesn’t matter.

A company can ultimately recover a cost increase and still lose months of profit and a meaningful amount of cash along the way. “We can pass it through” is the start of the analysis. It is not the answer.

The diesel shortage 2027 freight budget needs a calendar

The IEA’s October 14, 2026 Oil Market Report describes strained diesel markets and constrained middle-distillate supplies likely to persist well into 2027. Its outlook depends on supply recovery and remains uncertain. The report and public analysis are here.

That supports stress-testing transportation exposure. It does not tell me that our specific carrier invoice will increase by a particular percentage.

I’d begin with our contracts: the index used, the base fuel price, the surcharge schedule and the frequency of resets. Then I’d place our customer price-reset dates on the same calendar.

That’s where the story often becomes interesting. The carrier can reprice next week. The customer can consider our request at its next annual review, after Legal has had a restorative holiday.

All numerical company examples below are hypothetical. They show how I would make decisions; they are not IEA price forecasts.

The contract is the forecast’s inconvenient relative

I want the actual surcharge formula, including any floors, caps and exemptions. “Fuel is included” can mean included at the current rate, included up to a threshold, or included until a renewal allows the carrier to change the base charge.

I’d also check whether the index reflects our geography and mode. Crude prices, wholesale diesel and delivered retail fuel are related, but they are not interchangeable inputs.

Suppose a carrier’s total freight charge consists of a $100 base rate and a $20 surcharge. If the surcharge doubles while the base rate stays flat, total freight rises from $120 to $140, or 16.7%. It does not rise 100%.

Conversely, a supplier can increase its base rate as well as its surcharge. Using only the fuel component can then understate exposure.

This is why I would insist on a contract-driven model. An external chart is context. The agreement tells us how that context reaches the invoice. A surprising number of budget arguments could be settled by reading the thing we signed.

A distributor with a small freight line and a large problem

Consider a hypothetical distributor with $120 million of annual revenue. Other cost of sales is $84 million, and freight included in cost of sales is $9 million. Gross profit is $27 million, or 22.5%.

Assume freight rises 20% with no initial operational response. The annual cost increase is $1.8 million. Gross profit falls to $25.2 million, and gross margin falls to 21.0% if revenue remains unchanged.

A 1.5-percentage-point margin decline sounds mild until you calculate what it consumes. The $1.8 million increase removes 6.7% of gross profit.

If fixed operating expense is $18 million, operating profit falls from $9 million to $7.2 million, a 20% reduction. That assumes no other changes and no variable selling costs.

The freight line was only 7.5% of revenue. Its increase still took a fifth of operating profit. Small percentages have no obligation to produce small consequences.

I’d put that calculation in front of management before anyone describes the exposure as “manageable.”

Recovering the dollars and restoring the margin are different tasks

At unchanged volume, a 1.5% realized price increase produces $1.8 million of additional revenue on the original $120 million. That restores gross-profit dollars to $27 million.

But revenue is now $121.8 million and cost of sales is $94.8 million. Gross margin is approximately 22.17%, still below the original 22.5%.

To restore the original gross-margin percentage, revenue must equal $94.8 million divided by 77.5%, or approximately $122.323 million. That requires about $2.323 million of additional revenue, a 1.94% increase.

Neither target is inherently the right one. Management might prioritize gross-profit dollars, operating profit, return on capital or customer retention. I’d make the choice explicit.

Otherwise Sales can report that it recovered the cost while Finance reports a margin miss, and both departments are technically correct and personally offended.

I’d also include rebates, concessions and commission effects. A nominal 2% price increase is not a realized 2% increase if we quietly return half of it through another line.

The annual model can hide three expensive months

Assume the $1.8 million annual freight shock begins in January, adding $150,000 of cost each month. Customer pricing can change only from April.

If we recover the incremental monthly cost from April onward, the first three months still lose $450,000 of gross profit. Full monthly recovery after that point does not recover the earlier gap.

To recover the entire year’s $1.8 million in the remaining nine months requires $200,000 of additional monthly revenue. Against $10 million of baseline monthly revenue, that is a 2% realized increase from April, assuming unchanged volume.

At a 1.5% increase from April, annual price recovery is only $1.35 million. We end the year $450,000 short even though the exit-rate economics look repaired.

That is the difference between a run rate and a result. The December slide can be green while the annual cash balance remembers January.

I’d require the model to show effective dates. A price action without a date is a suggestion dressed as revenue.

Volume doesn’t sit quietly while we change prices

Now assume customers respond to the April price action by reducing affected volume 2%. For an annualized steady-state illustration, baseline revenue falls from $120 million to $117.6 million before the price increase.

Assume the $84 million of other cost of sales and the stressed $10.8 million freight cost vary proportionally with volume. They fall to $82.32 million and $10.584 million, respectively. Total cost of sales is $92.904 million.

To restore $27 million of gross profit, revenue must be $119.904 million. Relative to the reduced-volume revenue of $117.6 million, the required price increase is about 1.96%.

That calculation is intentionally simplified. Freight may contain fixed lane commitments, minimum charges and step costs. If volume falls but freight cost doesn’t fall proportionally, the required price increase is higher.

I’d model customer response by segment rather than invent one elasticity for the whole company. A critical product with few substitutes behaves differently from a commodity available from six suppliers.

The spreadsheet needs to permit customers to have opinions.

Blanket pricing lets the wrong customers subsidize the right ones

A uniform surcharge can be administratively easy and economically clumsy.

I’d segment accounts by delivered contribution, shipping frequency, order size and contractual flexibility. A customer placing one consolidated order may be cheap to serve. Another generating daily small deliveries can consume the same gross product margin and much more logistics expense.

Suppose two customers each buy $1 million annually at a 25% product margin before outbound freight. Customer A costs $40,000 to deliver; customer B costs $120,000. Their delivered contributions are $210,000 and $130,000.

A 20% delivery-cost increase reduces those contributions by $8,000 and $24,000. A uniform $10,000 price recovery overcompensates A’s incremental cost and leaves B $14,000 short.

I’d consider minimum orders, delivery fees, revised service schedules or account-specific pricing. Product price is only one lever.

This also makes the customer conversation more honest. If the real problem is service frequency, a generic fuel surcharge may obscure the fix and irritate customers whose orders are already efficient.

Consolidating deliveries can beat arguing about fuel

Before buying a forecasting subscription or designing a heroic surcharge, I’d ask whether we can reduce the number of shipments.

Assume a hypothetical lane makes 1,000 deliveries per month at $500 each. Combining orders reduces delivery count by 10%, but increases the cost of the remaining deliveries to $525 because they are larger.

Monthly freight moves from $500,000 to $472,500: 900 multiplied by $525. That’s a $27,500 monthly saving, or $330,000 annualized.

Now subtract $60,000 of annual scheduling and customer-service costs. Net annual operating benefit is $270,000, before any inventory or service effects.

That isn’t a promise that consolidation works everywhere. Customers may need urgent deliveries. Warehouses may lack staging space. Reduced frequency can increase stock requirements at either end.

I’d pilot a few lanes and measure delivered cost, damage, lateness and customer behavior. An operational change should earn its projected saving in actual shipments. We don’t get to book efficiency because a workshop produced a good diagram.

Inventory can eat the logistics savings

Suppose the consolidation plan requires $1 million of additional average inventory. At an illustrative 10% annual financing cost, that adds $100,000 per year.

Allow another $40,000 for incremental storage, handling and expected obsolescence. The $270,000 operating benefit falls to $130,000 after those modeled economic costs.

The company also needs the $1 million of cash upfront. The annual economic benefit and the initial liquidity requirement are different dimensions of the choice.

A profitable plan can still be difficult to fund. A cash-rich business might accept the inventory investment readily; a constrained company might prioritize pricing or a smaller pilot.

I would not reject consolidation automatically because it uses working capital. I would require the decision to include it.

Procurement and Logistics deserve credit for real savings. Treasury deserves to know where the money went. If each department optimizes its own dashboard, the company can accidentally purchase a very efficient cash shortage.

The cost shock also changes inventory valuation

Higher inbound freight may become part of inventory cost, depending on the facts and accounting policy. Outbound selling costs may flow differently. I’d work with Accounting rather than throw every freight dollar into the same working-capital calculation.

For a simplified sensitivity, suppose $3 million of incremental annual landed cost is capitalized into inventory, and average inventory holds 60 days of that cost flow. Using 365 days, additional inventory investment is about $493,151.

If supplier terms finance 30 days of the same incremental purchases, additional payables could offset about $246,575. The net cash exposure would be roughly $246,576 before timing differences and other effects.

Those assumptions require validation. Inventory days may reflect a different cost base; not all freight is payable on supplier terms; purchase and payment timing can differ.

Still, the exercise is useful. It shows why the cash response can be smaller or larger than a simple expense sensitivity.

I’d rather use a rough model with visible assumptions than a precise one that accidentally finances costs through terms we don’t have.

Fixed-price freight isn’t free protection

Locking rates can reduce uncertainty. It can also embed a premium, minimum volume or service restriction.

Suppose a fixed-price arrangement costs $300,000 more annually than today’s variable-rate expectation but avoids a $1.2 million increase in a severe scenario. Relative to the variable base case, the fixed arrangement loses $300,000 in the benign outcome and saves $900,000 in the severe outcome.

In a simplified two-outcome expected-cost comparison, fixed pricing becomes preferable when the severe-outcome probability exceeds 25%. That follows from $300,000 divided by the $1.2 million difference between outcomes.

I would not claim that probability from an IEA headline. I’d use the calculation to show the decision’s sensitivity.

I’d also examine service guarantees, carrier creditworthiness and what happens if our volumes change. Price certainty is less useful if the carrier cannot perform or the contract forces us to pay for unused capacity.

Insurance has a price. The question is whether the protected exposure and our liquidity make that price reasonable.

Hedging needs to match the thing we actually pay

A financial diesel hedge may help some companies manage exposure, but I’d be cautious about assuming it solves an outsourced freight problem.

The carrier may reference a different index, region or timing convention. Fuel is only part of the invoice. Volume uncertainty can leave the company with a hedge larger than its actual exposure.

I’d ask Treasury to map the hedge to expected gallons or surcharge sensitivity and explain basis risk. I’d also include collateral, settlement timing and the accounting consequences.

The alternative might be a contractual cap or a price-reset clause with customers. Those can address the operating mismatch more directly.

For many companies, simpler contract changes deserve consideration before complex instruments. For others, a disciplined hedging program may be appropriate. I would choose based on the exposure and capability, not on which approach sounds more sophisticated in a meeting.

The model should show residual risk after the hedge. A forecast that labels the whole line “protected” can hide the exact mismatch that eventually creates the surprise.

My response would start with decisions we can make now

I would first inventory material contracts and identify the fastest cost resets and slowest recovery dates. That gives us the near-term cash gap.

Then I’d select customer and lane actions based on economics. Accounts with low delivered contribution and high service costs get attention before profitable consolidated customers. Contract renewals become opportunities to improve reset terms.

I’d assign an owner and date to each action. “Sales will recover it” is insufficient. Which customers, how much, when, and with what likely concessions?

I would ask Treasury to reserve liquidity against the time gap, using realistic payable and receivable dates. Operations would validate consolidation opportunities and service constraints.

The actions would remain distinct from the external price assumptions. We can control a delivery schedule or a contract negotiation. We cannot control the global diesel market by sending it an assertive email.

That separation makes the response usable even when our commodity forecast is wrong.

The scenarios need asymmetric recovery

A downside case should include both higher costs and slower customer recovery. Those effects can reinforce each other when customers are also under pressure.

An easing case needs its own timing. Carriers may lower surcharges quickly, while fixed-price agreements remain unchanged. Customers may demand reductions before we have recovered the earlier increase.

I’d model contract mechanics in both directions. Otherwise we can overstate the upside by assuming costs fall immediately while prices remain elevated forever.

For each case, I’d show delivered contribution, operating profit and peak funding need. The peak matters because annual averages won’t pay a bill during the worst month.

My earlier discussion of historical budget baselines and driver-based forecasting applies directly: last year’s percentage is an input to investigate, not a strategy.

I’d revise assumptions when contracts, indices or realized customer behavior change materially. Updating every headline produces noise; ignoring new evidence produces a very tidy mistake.

My conclusion: price recovery needs a date and a bank balance

I don’t expect Finance to call the diesel market perfectly. I do expect us to know how a cost change enters the business and how long the money takes to come back.

My preferred response combines targeted pricing, service redesign and liquidity planning. Fixed-rate contracts or hedges can support that response when their economics fit. None should substitute for understanding the underlying terms.

I’d reject a 2027 freight budget built on a comfortable percentage with no contract logic. I’d also reject a blanket panic surcharge that ignores customer economics.

The company that handles this well may still get the commodity forecast wrong. It will have options, funding and a faster way to adjust.

When management says the increase can be passed through, I want the calendar. Then I want the cash forecast. If we are funding three months of everybody else’s fuel bill, I’d prefer to discover that before the bank balance does.

Sources and calculation notes

Market context comes from the IEA’s October 2026 Oil Market Report, published October 14. Every price increase, distributor result, contract premium, probability and cash sensitivity here is hypothetical. Actual exposure depends on contract language, geography, volumes and accounting treatment.

0 Comments/by Sarah Schlott
Tags: Budgeting and forecasting, CFO, driver-based forecasting, Financial Forecasting
Share this entry
  • Facebook Facebook Share on Facebook
  • X-twitter X-twitter Share on X
  • Linkedin Linkedin Share on LinkedIn
  • Reddit Reddit Share on Reddit
  • Mail Mail Share by Mail
https://sarahgschlott.com/wp-content/uploads/2026/10/Financial-charts-on-desk-—-Pexels.jpg 1067 1600 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-300x300.png Sarah Schlott2026-10-14 06:38:392026-10-14 06:38:39Diesel Prices Are Wrecking the Freight Budget. The IEA Says the Squeeze Could Last Into 2027.
You might also like
Driver-based forecasting and business drivers Driver-Based Forecasting: How to Find the Right Business Drivers
Finance team reviewing charts Goldman Sachs Just Delivered a Monster Quarter. I Want to Know How Much of It Is Repeatable.
Accounting documents Your 2027 Budget Has a Problem: Last Year’s Numbers May Be the Wrong Starting Point
Finance professional reviewing financial charts and working capital data on a laptop Working Capital Forecasting: Why the P&L Can Be Right and Cash Still Be Wrong
CFO Declares “Strategic Finance” Mission Accomplished After Attending 1 AI Webinar
Financial analysis calculator Wells Fargo’s EPS Grew Faster Than Earnings. I’d Like the Rest of the Story.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Join the Discussion Cancel reply

What do you think? No account or email required.

Latest Posts

  • Galderma’s $1.5 Billion Skincare Deal. Somebody Please Show Me the Synergy Spreadsheet.
  • Lonza Wants Higher Margins From Maturing Investments. I’d Like to Meet the Payback Schedule.
  • Rio Tinto Targets $5 Billion in Capital Release. I’d Start With the Cash We Already Own.
  • Workday Wants AI Agents to Do the Finance Work. Wonderful. Who Signs Off When They’re Wrong?
  • A $700,000 Signing Bonus for a CFO? I’d Like to See the Hiring Economics, Please.
  • Diesel Prices Are Wrecking the Freight Budget. The IEA Says the Squeeze Could Last Into 2027.
  • Wells Fargo’s EPS Grew Faster Than Earnings. I’d Like the Rest of the Story.
  • Goldman Sachs Just Delivered a Monster Quarter. I Want to Know How Much of It Is Repeatable.
  • CFOs Are Optimistic About Their Businesses but Worried About Stock Valuations. Both Can Be Right.
  • AI Skills May Command Higher Finance Salaries. Now CFOs Have Another Budget Problem.
  • The AICPA Just Published AI Audit Guidance. Finance Might Want to Check Who’s Responsible for the Numbers.
  • The 2027 Budget Isn’t Broken Yet. Its Assumptions Are Already Getting Nervous.
  • PayPal’s Budget Reallocation Playbook Has One Rule Finance Teams May Not Like: No Sacred Cows
  • McKinsey Says Automation Could Absorb Half of U.S. Work Hours. Who’s Training the Next Finance Leader?
  • AWS Replaced an 18-Tab Pricing Model With an AI Chatbot. The Interesting Part Isn’t the Chatbot.
  • AI Was Supposed to Improve Margins. Why Is It Showing Up in Cost of Revenue?
  • Your 2027 Budget Has a Problem: Last Year’s Numbers May Be the Wrong Starting Point
  • Only 10% of Companies Have Fully Integrated Planning. Apparently, the Other 90% Have Meetings.
  • Business Spending Is Still Growing in 2026: Why CFOs Shouldn’t Put Every Investment on Hold
  • AI Productivity Gains Are the Next Earnings Story: Why FP&A Could Become the Most Important Team in the Room
  • UnitedHealth Raises 2026 Earnings Guidance: The Profit Growth Lesson Hiding in Its Medical Costs
  • IMF Raises Global Growth Forecast for 2026: Why CFOs Should Look for Opportunities, Not Just Risks
  • FIS Launches Agentic AI Cash Flow Forecasting: Finance Might Finally Get Ahead of the Money
  • Goldman Sachs Q3 2026 Earnings Beat: What FP&A Can Learn From a $1.8 Billion Revenue Surprise
  • JPMorgan CFO Sees AI Dealmaking Opportunities: Why the Next Wave of AI Investment Could Be Good for Business
  • IMF Warns of AI Investment Bubble Risks: The $1 Trillion Question CFOs Should Be Asking
  • How AI Is Changing Accenture’s Consulting Business Model: The Billable Hour Has a Proble
  • How CFOs Are Using AI to Prepare Earnings Calls: The Financial Reporting Risks Nobody Wants to Explain
  • AI Chip Stocks Are Falling. Your Forecast Shouldn’t Pretend They Can’t
  • Your First Finance Hire: Are You Solving a Problem or Just Collecting Job Titles?
  • Long-Range Financial Planning: Build a Three-Year Plan Without Pretending to Predict
  • Top-Down vs. Bottom-Up Budgeting: Which One Should Finance Trust?
  • How to Build a Business Budget From Scratch Without Guesswork
  • Budgeting and Forecasting: Seven Controls That Make the Numbers More Reliable
  • Predictive Budgeting: When the Algorithm Gets the Assumptions Wrong
  • FP&A Forecast Credibility: How CFOs Keep Optimism From Becoming the Official Number
  • FP&A Decision Rights Framework: How CFOs Turn Financial Analysis Into Action
  • How to Forecast SaaS Renewal Costs and Avoid Software Budget Surprises
  • How to Calculate the Impact of a Supplier Price Increase on Gross Margin
  • How to Build a Financial Forecast Model in Excel: A Step-by-Step FP&A Example
  • FP&A Software Implementation Timeline: How Long It Takes and What CFOs Should Budget
  • Board Forecast Bridge Analysis: How CFOs Explain What Changed and What to Do Next
  • Forecast Assumption Ownership: How CFOs Stop Planning Surprises
  • Capital Expenditure Stage Gate Process: When CFOs Should Release the Money
  • Sales Capacity Planning: How CFOs Test Revenue Targets Before Hiring
  • Business Unit Profitability Analysis: How to Separate Real Losses From Allocated Costs
  • Capacity-Constrained Financial Planning: A CFO Guide
  • Your CFO Changed the Forecast. Was That Judgment or Wishful Thinking?
  • Post-Acquisition Synergy Tracking: Where Did the Promised Savings Go?
  • Capital Allocation for CFOs: When Every Investment Looks Good
  • That $24,000 Job Looked Profitable. So Where Did the Money Go?
  • Lease or Buy the Equipment? I’d Like to See the Numbers Before We Sign Anything.
  • Your Business Might Be Sitting on More Cash Than You Think. Let’s Find It.
  • Your Monthly Management Report Is Beautiful. Does Anyone Actually Do Anything With It?
  • Should You Outsource the Work or Keep It In-House? Let’s Do the Math.
  • Your Biggest Customer Is 30% of Revenue. How Much Risk Is That, Really?
  • How to Calculate Price, Volume, and Mix Variances Without Fooling Yourself
  • How to Calculate Whether a Sales Discount Is Worth It (Before You Give Away Your Margin)
  • How to Calculate Break-Even Sales for Multiple Products (And Why the Mix Matters)
  • How to Forecast Accounts Receivable Collections Without Pretending Every Customer Pays on Time
  • Customer Profitability Analysis: Your Biggest Customer Might Not Be Your Best Customer
  • When Should I Hire a Controller? Look for the Ownership Gap
  • Can My Business Afford Another Employee? Model the Gap Before You Hire
  • How Much Cash Should a Small Business Keep in Reserve?
  • Continuous Planning vs. Rolling Forecast: What Is the Difference?
  • How to Build an AI Business Case for Finance That a CFO Can Defend
  • Headcount Planning in FP&A: Build the Model Around Decisions, Not Rows
  • How to Measure Forecast Accuracy in FP&A Without Gaming the Forecast
  • Rolling Forecast vs. Annual Budget: Do You Actually Need Both?
  • AI Governance for Finance Teams: A Practical CFO Framework

Sarah Schlott

FP&A consulting, forecasting, accounting support and finance strategy for CFOs and growing finance teams.

Work With Sarah →

FP&A

FP&A ConsultingForecasting & PlanningScenario Modeling & Decision SupportManagement ReportingCash ForecastingFP&A Function & Finance SystemsVariance AnalysisKPI DashboardsBoard ReportingFP&A for PE-Backed CompaniesOrlando FP&A Consulting

Accounting

Accounting ServicesAccounting & Bookkeeping SupportMonth-End Close & Financial ReportingFinancial Statements & ReportingAccounts Payable SupportAccounts Receivable SupportAccounting Cleanup & Catch-UpOrlando Accounting Services
© Copyright - Sarah Schlott
Link to: Wells Fargo’s EPS Grew Faster Than Earnings. I’d Like the Rest of the Story. Link to: Wells Fargo’s EPS Grew Faster Than Earnings. I’d Like the Rest of the Story. Wells Fargo’s EPS Grew Faster Than Earnings. I’d Like the Rest of...Financial analysis calculator Link to: A $700,000 Signing Bonus for a CFO? I’d Like to See the Hiring Economics, Please. Link to: A $700,000 Signing Bonus for a CFO? I’d Like to See the Hiring Economics, Please. Modern office teamA $700,000 Signing Bonus for a CFO? I’d Like to See the Hiring Economics,...
Scroll to top Scroll to top Scroll to top