Mastering Sales Forecast, Demand & Procurement Planning to Stabilize Your Supply Chain

Who Manages Sales Forecast, Demand Plan, and Procurement Plan?

Sales forecasting, demand planning, and procurement planning are often mentioned in PPTs, but many people are unclear about their responsibilities and how they cooperate. This article clarifies the ownership, scope, and best‑practice execution of each plan to keep the supply chain orderly, delivery stable, and inventory light.

1. Sales Forecast

Who does it? Sales or marketing department.

Basis? Historical sales, customer feedback, channel activity, exhibition/promotion plans.

What it manages? A forward‑looking estimate of how much may be sold.

Characteristics: Highly subjective, needs regular rolling adjustments, but guides the entire supply‑chain plan.

Sales forecast is the starting point of supply‑chain planning, providing an initial judgment of future customer demand.

2. Demand Plan

Who does it? Planning department or supply‑chain centre.

Basis? Sales forecast, customer orders, current inventory, capacity load, work‑in‑process, etc.

What it manages? Transforms uncertain forecasts into concrete decisions on how much to stock or produce.

Characteristics: The hub of supply‑demand balance; must coordinate customer demand with enterprise resources.

Demand planning looks at what customers want and what the company can produce.

3. Procurement Plan

Who does it? Purchasing department.

Basis? Demand plan, BOM structure, inventory status, in‑transit material, lead times, safety stock, etc.

What it manages? What material to replenish, when, and how much.

Characteristics: Execution‑level plan; directly impacts supply‑chain smoothness; any delay or error triggers a chain reaction.

Procurement planning is not “buy when out of stock”; it is a proactive preparation based on demand forecasts.

How to Build Each Plan

Sales Forecasting

Answer the question: How many orders might customers place in the future?

Historical sales: How much was sold in the same season last year?

Customer communication: Do key customers have upcoming stocking plans?

Market activities: Are there upcoming promotions or new product launches?

For mature systems, consider more refined methods:

Full‑process data tracking: Record every customer visit, proposal, and quotation.

Stage win‑rate modeling: Split the sales process into stages (initial contact, proposal, contract) and assign a probability to each.

Forecast amount calculation: Capture expected deal size and timing; the system auto‑calculates a weighted forecast.

Multi‑dimensional analysis: Analyze opportunity source, conversion rate, regional distribution, loss reasons, etc., for review and adjustment.

All forecast data are aggregated into a dashboard showing month‑over‑month and quarter‑over‑quarter trends, turning subjective estimates into a data‑driven input for demand planning.

Demand Planning

The goal is to convert the sales forecast into concrete production and stocking quantities.

Current inventory levels.

Confirmed customer orders and forecasted sales.

Safety stock, minimum order quantities, and other strategy parameters.

If the ERP includes a “data factory”, the system can automatically:

Consolidate all inbound/outbound records.

Calculate current stock for each material.

Sum all planned, in‑process, and pending demand to obtain total demand.

Compare total demand with current stock; the difference is the raw‑material procurement forecast.

Procurement Planning

Do not wait for a stockout; instead, reverse‑engineer from the demand plan.

Net demand awareness: Know the shortage amount in advance.

Lead‑time planning: Determine how early to place orders (lead time + buffer).

Key procurement details:

Safety stock: Set a threshold (e.g., alert when stock < 200 units) to trigger automatic purchase suggestions.

Purchase batch size: Respect minimum order quantities, packaging constraints, and supplier MOQ.

Common Pitfalls and Three Practical Recommendations

Many supply‑chain failures stem from unreliable demand forecasts.

Separate customers: Treat customers with reliable forecasts (large accounts) differently from ad‑hoc buyers.

Set a freeze period: Lock demand for the next two weeks; emergency orders must go through an approval workflow.

Conduct forecast deviation analysis: Monthly compare forecast vs. actual orders; flag frequent deviators and link performance to incentives.

Conclusion

Sales forecasting, demand planning, and procurement planning are not three isolated spreadsheets; they form a continuous chain of capability that requires coordination among sales, planning, purchasing, and systems.

The true measure of a mature organization is not 100 % forecast accuracy, but a robust tolerance mechanism, rhythm control, and system integration that keep the supply chain stable.