Forecasting and operational planning

Plan what to order and when to add capacity.

We build forecasts and planning models around decisions about stock, staffing, and budgets. Compare changes in demand or supplier timing, see what those changes require, and update the plan as actual results come in.

Discuss a planning model

Illustrative four-week plan

The same receipt. Two demand assumptions.

Start with 100 units. Receive 100 more at the start of week 3.

40 units / week60 units / week
Projected stock at the end of each weekHigher demand creates a shortfall in weeks 2 and 4. Exact balances are in the table below. Negative stock represents backorders. +100 received 80400−40 W1W2W3W4
Week-end stock · units
DemandW1W2W3W4
40 / week60208040
60 / week40-2020-40

Negative balances are backorders. A later receipt does not prevent an earlier shortfall.

Try a larger plan in the inventory demo

When to bring us in

When demand changes faster than the plan

  • Stock runs short in some places and accumulates in others.
  • Workload changes faster than staffing or capacity plans.
  • The budget or forecast is difficult to update or explain.

Services

Model demand, supply, and the resources required

Demand and sales forecasting

Use the available history to estimate demand at the level you plan.

  • Forecasts by relevant product, customer, or channel
  • Treatment of seasonality, events, and known changes
  • Documented assumptions and overrides

Inventory and replenishment

Translate demand into a view of stock, timing, and purchasing needs.

  • Lead times, incoming stock, and order constraints
  • Shortfall and excess-stock visibility
  • Replenishment scenarios and cash implications

Capacity and staffing plans

Connect expected work to the resources needed to deliver it.

  • Workload and throughput assumptions
  • Staffing and resource scenarios
  • Bottlenecks and timing of capacity requirements

Budgeting and operating models

Model how sales, staffing, and other operating assumptions affect the budget.

  • Revenue and cost drivers
  • Budget and rolling-outlook support
  • Scenario comparisons and cash timing assumptions

Scenarios and sensitivity

Identify which assumptions change the decision most.

  • Higher and lower demand cases
  • Supplier, timing, and capacity changes
  • Tradeoffs, thresholds, and contingency options

Forecast review and improvement

Compare forecasts with actual demand and review persistent over- or under-forecasting.

  • Forecast error and bias reviews
  • Assumption changes and version history
  • A review cadence with clear decision owners

Example engagement

Decide what to order before stock runs short.

For a business balancing demand, supplier lead times, and cash tied up in stock.

How we check the result

  • Stock movements reconcile across the planning horizon.
  • A change in demand or lead time produces an explainable result.
  • The forecast can be reviewed against a suitable baseline and actuals.

Illustrative engagement. Your proposal defines the deliverables and exclusions.

Sample demonstration

Change demand and supplier timing in a sample plan

Questions

Models and assumptions

Can forecasting help with limited history?

Sometimes. We assess what the data supports and may start with transparent assumptions, comparable patterns, or scenarios. We make the limits clear rather than implying precision the evidence cannot support.

How do we update the forecast when demand changes?

We compare actual demand with the forecast, review the assumptions behind the difference, and update the next planning period. Scenarios show how a different outcome would affect the decision.

Can you work with an existing spreadsheet model?

Yes. We can review the logic, clarify assumptions, improve the structure, or add scenarios and checks before considering a replacement.

Does budgeting support include accounting or tax advice?

The focus is on operational assumptions and planning models. Accounting treatments, tax positions, and other regulated advice remain with the appropriate professionals.

Related services

Other help you may need

Which planning decision is hardest to make?

Tell us what you need to plan, how far ahead, and which assumptions keep changing.

Discuss a planning model