Supply chain analyst role: forecasts, stock cover and reorder points

The monthly planning cycle drives everything

Many companies run some form of sales and operations planning (S&OP) each month. The analyst's work fits around it:

• Week 1: close last month's numbers. Compute forecast accuracy and bias by SKU and region, and service level (the share of orders fulfilled in full and on time).
• Week 2: prepare the baseline statistical forecast for the next few months and circulate it to sales for adjustments, such as a planned festive-season promotion.
• Week 3: consensus meeting. Sales, planning, finance and production agree the numbers; the analyst shows what changed and why.
• Week 4: translate the plan into inventory: update safety stocks and reorder points, flag SKUs heading for stock-out or excess.

Between those milestones come daily fires: a supplier's shipment is delayed, a distributor wants an emergency order, a warehouse shows negative stock because a transfer was booked wrongly.

Measuring forecast quality in a way people accept

Two numbers carry most of the conversation. Accuracy, often reported as 100% minus a weighted absolute percentage error, and bias, the direction of error. For one SKU over three months with forecasts of 1,000, 1,200 and 900 units against actuals of 1,100, 1,000 and 950:

• Absolute errors: 100, 200, 50. Total 350. Total actual: 3,050.
• Weighted absolute percentage error: 350 ÷ 3,050 = 11.5%, so accuracy about 88.5%.
• Bias: total forecast 3,100 minus total actual 3,050 = +50, a slight over-forecast.

Accuracy tells you how wrong the forecast is; bias tells you whether someone is consistently padding it. A sales team that always adds 15% "to be safe" shows up as persistent positive bias, which inflates inventory.

The artefact: safety stock and reorder point for one SKU

A commonly used textbook formula, when demand varies but lead time is steady, is:

Safety stock   = z × (standard deviation of daily demand) × √(lead time in days)
Reorder point  = (average daily demand × lead time in days) + safety stock

Hypothetical SKU at one warehouse
  Average daily demand            = 120 units
  Std deviation of daily demand   = 30 units
  Supplier lead time              = 9 days
  Target cycle service level      = 95%  → z ≈ 1.645

Safety stock  = 1.645 × 30 × √9 = 1.645 × 30 × 3 = 148 units (rounded)
Reorder point = 120 × 9 + 148 = 1,080 + 148 = 1,228 units

When stock on hand plus stock on order falls to 1,228 units, a replenishment order goes out. Raise the target service level to 99% (z ≈ 2.326) and safety stock rises to about 209 units. That is the conversation the analyst facilitates: a higher service level costs real working capital. Real planning also allows for lead-time variability, minimum order quantities and shelf life, which matters a great deal in pharma and food.

Scorecard

Supply chain analysts are commonly judged on forecast accuracy and bias, service level or fill rate, inventory days of cover, value of slow-moving or expired stock, and how early they flagged risks. Nobody thanks you for a stock-out warning that came the day it happened.

Planners, warehouses, procurement and sales

Usually a demand planning manager, supply planning head or supply chain lead. You work with sales and distributors, procurement, production planning, warehouse teams and finance, who care about inventory value on the balance sheet.

Not to be confused with

• Procurement executive: negotiates with and orders from suppliers. The analyst tells them when and how much; the buyer handles the supplier.
• Logistics coordinator: arranges transport and tracks shipments.
• Demand planner: often the same job with a different title. Some companies separate the forecaster (planner) from the analyst who builds reports and models.

S&OP, demand planning and SAP APO in postings

Forecast accuracy baseline before any new model

Month one: learn how the ERP records a sale, a transfer, a return and a stock adjustment; most wrong numbers come from misreading these. Month two: build the accuracy and bias report for your category. Month three: review safety stocks for the top SKUs and bring one evidence-based change to the planning meeting.

Planner, S&OP lead or operations analytics

Demand or supply planner, planning manager, S&OP lead, or a broader operations analytics role; see the operations analyst guide. The Data Analyst programme covers the SQL, Excel modelling and reporting discipline this work depends on, taught live online with optional Noida labs.