Advanced Forecasting and Inventory Management Training with Excel

A hands-on corporate training programme that teaches demand forecasting, safety stock and ordering policies in Excel. Every topic is worked through on a spreadsheet, so participants leave with models they can reuse on their own data.

What is covered

Demand forecasting: Moving average, exponential smoothing, trend and seasonality, and how forecast error is measured.

Safety stock: Service level, demand and lead time variability, and how the resulting stock level is calculated.

Ordering policies: Economic order quantity, reorder point, periodic review and the trade-off between holding and ordering cost.

Putting it together: Building a forecast-to-order sheet that links the three topics.

Format

The programme runs on site or online, as a group, with exercises worked in Excel throughout. The content is adapted to the data and the ordering practice actually in use.

Who it is for

Planning, purchasing, warehouse and supply chain staff who work with stock figures and place orders.

Getting started

A 30-minute introductory call sets the level, the group size and the dates; an agenda is shared before the programme starts.