Integrated Planning System in Excel
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.
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
Powerpoint slides of the Integrated Planning System in Excel