Webinars – Integrated Planning System in Excel

Integrated Planning System in Excel


Inventory Replenishment


Capacity Planning


Finite Scheduling Gantt Charts


Demand and Supply by Item

This webinar will show you an integrated supply chain planning system – working entirely in Excel spreadsheets.

This system takes demand (forecasts and sales orders), supply (inventory, purchase orders and capacity) and master data to perform material, inventory and capacity planning and production scheduling functions.

We will walk you through a full-scale working example with 100’s of different products, semi-finished and raw material items.

You can learn how to set up the input data from a host MRP system or manually manage it in Excel. You can see a selection of standard reports showing:

– Inventory Replenishment
– Purchasing Actions to Take
– Inventory Performance Analysis
– Capacity Planning
– Finite Production Scheduling

This system uses familiar spreadsheets so you can clearly see how the logic works. There are templates for you to create powerful custom reports quickly and easily.

On the webinar, you will have opportunity to ask questions and understand how it can be set up with your own data. You will find out how to download the system and access all the help you need to get a fully functioning system working in your own company.

Webinar Recordings

Thursday 16 June 2016, 19:00 BST

Friday 17 June 2016, 09:00 BST

Thursday 23 June 2016, 19:00 BST

Friday 24 June 2016, 09:00 BST

Webinar Slides

Powerpoint slides of the Integrated Planning System in Excel

Leave a Reply

Scroll to Top