Distribution Centers iAll DCsHistory read Nov 13, 2026 · last closed period FY27 P01
Plan
Baseline — today’s rate, no levers
To the end of
FY28
+ New scenarioDC capacity and margins3
HOW IT IS BUILT
Each DC and temperature at its cases a week over the last six closed periods, times the weeks of each period ahead; split to categories by their share of the last year. No growth, no changes — the levers are a scenario’s.
From the distributorThe plan covers the 5 DCs in the distributor’s feed. The distributor reports 8: three of its DCs aren’t in the feed.
Cases received, by fiscal period
The shaded band is the range: four periods in five landed inside it when this method was tested on the distributor’s own history. Grey shading marks the periods beyond what was tested — an envelope, not a measured forecast.
Range (4 in 5)BaselineSame period last yearApproved plan, FY27Distributor’s budget
Why the forecast moved
Each DC and temperature is forecast at its cases a week over its last six settled periods, so the forecast moves when a period comes into those six and the oldest leaves.
Since last monthSince FY27’s plan was approved
The next 6 periods moved +231K (+0.6%) since the forecast made after FY26 P12. Came in: FY27 P01 at 1.63M a week. Left: FY26 P07 at 1.57M a week.
FY27 P01 came in -1.6% against that forecast.
By DC
Each DC’s next period with its range, each fiscal year’s total, and against the same periods last year.
By temperature
Dry, chilled and frozen across the DCs in scope.
iAdvisory. What the plan implies at each vendor’s share of the last year and its usual cases a PO — not an order, a size or a date. Nothing here is sent to the distributor’s purchasing.
DC
DC 12
Temperature
All
Category
All
Vendors: 52 · shares from FY26 P02 – FY27 P01 · the largest 14 shown
Purchases by fiscal period
Product margin shows once the distributor’s margin % by category is entered under DC capacity and margins.
PurchasesDistributor’s budgetProduct margin
By category
From the distributorThe distributor’s budget, next 12 periods: allowance $80.0M and freight expense $54.3M; this plan: $86.4M and $60.3M.
iFreight cost moves at its trend: +2.8% a year — the distributor’s expense a hauled case over the last 13 periods against the 13 before. Allowance and expense are the distributor’s own figures from its managed-freight file; the money model agrees with them within a point.
Allowance, expense and margin
Allowance earnedFreight expenseMargin
Margin %
Against the last 13 closed periods and, for a scenario, its baseline.
Margin %Last 13 periods
Loads by mode
Distributor-hauled POs by how they moved at each DC over the last year: each PO under its costliest leg, carrying every leg’s share of the linehaul.
From the distributorThe distributor’s receiving capacity isn’t in yet: each DC is held to the most it has received in a week so far.
iA busy week is the plan’s cases a week at the DC’s own busy-week ratio — its 90th-percentile week over its average. Near: 95% of the ceiling or more. Nothing is booked, moved or refused.
Busy weeks against each DC’s ceiling
The fullest DCs first. A cell is the period’s busy week as a share of the ceiling; hover for its cases.
From the distributorThe distributor’s pallet positions aren’t in yet. Meanwhile each zone is set against the most it has held on a day since Mar 2, 2025: a stand-in, not a capacity.
iStock is planned at today’s days of supply unless the scenario sets them.
Pallets planned by temperature zone
DryChilledFrozenMost held so far, each zone at its peak
The goals volume drives
Today is the last 13 closed periods; planned is the average of the next 12 periods and the plan’s last period. Goals are the dashboard’s, due September 2027.
Not forecast — they follow how the program is run, not how much moves: Lanes blocked by missing data, Managed freight on a Blueprint, Truck fill on hired truckloads, Blueprint approval wait, Blueprint compliance, Planned freight with compliance on, Actual vs planned margin, Churn back to unmanaged.
iError is the misses added up over the volume added up (WAPE). Bias below zero means the forecast ran low. The range is where four periods in five landed: the plan shows it on every figure.
The forecast against what came
Each closed period against what the forecast said a period before it. A period counts as closed once the distributor’s feed has brought its last day in.
🔔 Tell me when a period closes
• DC 41 has come in under its forecast 3 periods running (-5%, -5%, -6%). Its baseline is off: an event or a DC change in a scenario can carry it.
Measured as it goes
3 people get the bell.
New scenarioThe baseline with levers: each one applies from the period chosen. Saving reads what the levers need from the distributor’s data — an item’s receipts, a vendor’s share, the ready lanes.×
Scenario
Name
Plan to the end of
FY28
Note
Prices
Yearly changes, compounded to each period. Freight left blank moves at its trend (+2.8% a year). The distributor’s load file carries the linehaul alone, so fuel moves freight cost only by the share of it you enter.
Product cost, % a year
Freight cost, % a year
trend 2.8
Fuel price, %
Fuel’s share of freight, %
Allowance rates, %
The program
Back-haul, % of hauled cases
each DC’s own
Set the mode mix
Fleet capacity, loads a week — a period above it is flagged on the Transport tab.
+ Fleet capacity
Stock
Days of supply to hold; blank keeps each DC and zone at today’s.
Days of supply, every DC
today’s
+ A DC’s days of supply
Save scenarioCancel
DC capacity and marginsThe distributor’s figures that its data does not carry. Company-wide; every change is kept in the goals’ history.×
Pallet positions
By DC and temperature zone, as the distributor plans with them. Blank leaves a zone without a capacity.
Product margin % by category
The margin on sales the distributor makes in a category; Spend shows product margin for the categories given one.
Find a category
SaveCancel
Comments and change logComments are kept with the plan shown; the change log is every plan’s.×
Comments3Change log
New commentOn Baseline
A comment for the next planning meeting…
No DC — the whole plan
No period
Add Comment
Every DC
Every period
Forecasting
Open Forecasting under Management. Pick the plan to look at and how far ahead it runs; the top right shows the last closed period.
Plan tools
Make a scenario, enter DC capacity and margins, comment, see history or download. How it is built explains the baseline.
Summary
Cases this fiscal year and next, purchases and program margin over the next 12 periods.
The forecast
Cases by fiscal period: the baseline in its range, against last year, the approved plan and the budget.
What moved
Why the forecast moved since last month or since the plan was approved, then the plan by DC and by temperature.
Buying Plan
What the plan implies for each vendor at a DC: cases and POs by period, at its usual size and lead time. Advisory only.
Spend
Purchases by period against the budget, product cost change and product margin, then spend by category.
Program Money
Allowance earned, freight expense and program margin over the next 12 periods, and how the margin % trends.
Transport
Loads planned, the share through a cross-dock, fleet capacity, and loads by mode each period.
Receiving
Each DC’s busy week against its receiving ceiling, period by period. The fullest DCs come first.
Storage
Stock and days of supply today, the stock and pallets planned, safety stock, and stock past its shelf life.
KPIs
The goals volume drives: freight under management, managed load margin and margin earned, against each goal.
Accuracy
Each closed period against what was forecast, the DCs outside their range, and the error as it goes.
New scenario
Start from the baseline and add levers: growth, moves, events, accounts, DCs, items, conversions, prices, the program and stock.
Capacity & margins
Enter pallet positions by DC and zone, and product margin % by category. Every change is kept in history.
Comments
Leave a comment on the plan, a DC or a period for the next planning meeting.
Change log
Every plan’s changes: scenarios saved, settings changed, history refreshed and plans approved.
Supply Chain
Plan ahead.Period by period.
Forecast cases, spend, freight money, transport, receiving and storage, try scenarios, and see how accurate it has been.
Supply Chain
One plan. Every number it drives.
A baseline you can trust, scenarios you can test, and the accuracy to prove it.