LOGO Home›Forecasting Ella AI SC

Forecasting

Distribution Centers i All DCs History read Nov 13, 2026 · last closed period FY27 P01
Plan
Baseline — today’s rate, no levers
To the end of
FY28
+ New scenario DC capacity and margins 3
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.

SummaryBuying PlanSpendProgram MoneyTransportReceivingStorageKPIsAccuracy
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.

Fleet, truckloadFleet, LTLCarrier truckloadCarrier LTLIntermodal
Modes, next 12 periods
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.