Forecasting — plan cases, spend, freight and capacity ahead
Forecast cases period by period and see what the plan means for buying, spend, program money, transport, receiving and storage. Build scenarios, enter DC capacity and margins, and check how accurate the forecast has been.
Open Forecasting and pick a plan
In the Supply Chain sidebar, open <b>Management › Forecasting</b>. Choose the <b>Plan</b> to look at, such as <b>Baseline — today's rate, no levers</b> or a saved scenario, and how far it runs in <b>To the end of</b> (for example FY28). The top right shows when the history was read and the last closed period. <b>How it is built</b> explains the baseline: each DC and temperature at its cases a week over the last six closed periods, split to categories by their share of the last year.
Use the plan tools
Beside the plan are <b>New scenario</b>, <b>DC capacity and margins</b>, and buttons for comments and the change log, history and download.
Read the Summary
The <b>Summary</b> tab gives the headline numbers and the forecast itself.
- Summary cards — Cases for this fiscal year and next, purchases over the next 12 periods, and program margin over the next 12 periods.
- Cases received, by fiscal period — The baseline with its range (where four periods in five landed when tested), against the same period last year, the approved plan and the budget. Grey shading marks periods beyond what was tested.
- Why the forecast moved — How the next periods changed since last month or since the plan was approved, DC by DC, as a new period came in and the oldest left.
- Approved plan, by DC, by temperature and by category — The plan against the approved figures, and each DC, temperature and category with its range and fiscal-year totals.
Check the Buying Plan
<b>Buying Plan</b> shows what the plan implies for each vendor at a DC: cases and POs by period at the vendor's share of the last year, its usual cases a PO and its lead time. Filter by <b>DC</b>, <b>Temperature</b> and <b>Category</b>. It's advisory: nothing is sent to purchasing. A second table flags categories where one supplier carries half the cases or more.
Review Spend and Program Money
Two tabs follow the money.
- Spend — Purchases for the next 12 periods and each fiscal year, product cost change and product margin, purchases by period against the budget, and spend by category.
- Program Money — Allowance earned, freight expense and program margin over the next 12 periods, against the budget; the margin % trend; and allowance, expense and margin by DC.
Look at Transport, Receiving and Storage
Three tabs show what the plan needs from operations.
- Transport — Loads planned, the share through a cross-dock, any period over fleet capacity, loads by mode each period, and fleet loads by DC.
- Receiving — Each DC's busy week against its receiving ceiling, period by period, with the fullest DCs first. Until capacity is entered, each DC is held to the most it has received in a week.
- Storage — Stock and days of supply today, the stock and pallets planned by temperature zone, safety stock, and stock likely to pass its shelf life.
Track the KPIs
<b>KPIs</b> shows the goals volume drives: freight under management by cases and by weight, managed load margin, margin earned and new conversions. Each is shown today, over the next 12 periods and at the end of the plan, against its goal.
Check Accuracy
<b>Accuracy</b> compares each closed period with what was forecast a period before, lists the DCs that came in outside their range, and measures the error as it goes and by how far ahead. A warning flags a DC that keeps coming in under or over. Select <b>Tell me when a period closes</b> to be notified.
Build a scenario
Select <b>New scenario</b> to start from the baseline and add levers, each from the period you choose: <b>Growth</b>, <b>Move volume between DCs</b>, <b>Events</b>, <b>Accounts won or lost</b>, <b>Open or close a DC</b>, <b>New items</b>, <b>Items dropped</b>, <b>Conversions</b>, <b>Prices</b>, <b>The program</b> and <b>Stock</b>. Give it a name and note, then select <b>Save scenario</b>.
Enter DC capacity and margins
Select <b>DC capacity and margins</b> to enter figures the data doesn't carry: <b>Pallet positions</b> by DC and temperature zone, and <b>Product margin % by category</b>. Select <b>Save</b>. Changes apply company-wide and are kept in history.
Comment and review the change log
The comments button opens <b>Comments and change log</b>. Under <b>Comments</b>, leave a note on the whole plan, a DC or a period for the next planning meeting, and filter comments by DC or period. <b>Change log</b> lists every plan's changes: scenarios saved, settings changed, history refreshed and plans approved.
Why it matters
One forecast drives buying, freight, receiving and storage. Seeing what it means for each, testing scenarios before you commit, and checking how accurate it has been lets every team plan from the same numbers.
Ready to build your own?
Start free and ship your first app in minutes — or have us set it up with you.
More guides in Supply Chain
More resources