This website is an answer to the many questions we get about planning and spreadsheets.
It seems there are many people out there asking how to do material, production and distribution planning using Excel.
We write the articles on this site to show how data in MRP and ERP systems can be manipulated in Excel to do the planning that is needed to figure out what to buy, make and sell.
You might ask: Why are there so many questions about planning with spreadsheets? Don’t we have those MRP and ERP systems to do exactly that?
Well, firstly there is a lot of spreadsheet use in planning. Aberdeen Group estimate that 63% of best-in-class companies use spreadsheets for Demand Management (and a whopping 84% of laggards). The Demand Driven Institute finds that 95% of companies use spreadsheets to augment MRP. It is clear- the data may sit in an ERP system, but planners need to work that data manually in spreadsheets to do things that the system can’t.
So, why are so many companies using Excel to perform planning? When we ask this question, two answers stand out:
- Our system doesn’t do what we want it to do. We need more flexibility.
- Our system doesn’t show us what we want to see. We want more transparency.
In that case, what is the problem? Why is Excel the dirty little secret in the world of planning software? What is the reason for Excel Hell?
The two reasons given the most are:
- Manually working with spreadsheets is slow and leads to error. We need more speed and quality
- Our spreadsheets are disconnected from other systems and processes. We need more integration.
If we just follow the recommendations of the MRP system, we buy and make too much of the wrong things and not enough of the right ones. And we can’t see the information we need.
If we pull out the data and work with them in spreadsheets we can plan better, and show the right information but it is a manual process – it takes a long time, we are too slow to respond and we often make mistakes.
MRP systems provide the wrong answers because they are dated and disconnected. The planning logic for MRP was created in 1958 and the systems conceived in the 1960’s. Much has changed in the world since then. Demand volatility is up, product variety and mix is up, customers are ever more demanding: There is more error in the forecast than ever before. And MRP logic relies so heavily on the forecast.
Fortunately, the people who wrote the book on MRP have not been sitting idle. There is a new methodology called Demand-Driven MRP (DDMRP). DDMRP recognises that forecasting cannot be at the centre of the planning process. You need to use actual customer demand to drive your purchasing and production orders. And when you need to make decisions before you get the customer orders, you need to buffer inventory carefully and adjust those buffers according to the way demand is changing.
DDMRP teaches that the most important concept in the supply chain is flow. The flow of the right material and product towards the customer, and the right information flowing back to the supplier.
at Production-Scheduling.com we have spoken before about the limitations with forecasting, and using a service level to size your inventory. And creating flow in the supply chain is mother’s milk to us.
One of the appealing aspects of DDMRP is that it is integrated. You take a look across the whole flow of raw materials, WIP and finished goods to work out where you place inventory, before what and how much. It is flexible to respond to the way demand changes and has parameters so you can adapt the method to your own business. And it is transparent in that you can learn the methods and simple visual techniques to manage the planning process. Only then do we automate and make the right process happen every day at the touch of a button, making planning more responsive, faster with far fewer errors.
We would like to demonstrate how DDMRP works with Excel to offer an integrated, flexible supply chain planning system. It will all be open to see how the logic works and how the rules apply to get the right inventory in the right place at the right time. And it is fully automated, so there is no more cut-and-paste and manual spreadsheet error.
Here is the next chance to see this system in action and learn how it works;
on the 26 – 27 May we will be teaching a workshop in Birmingham, UK.
Demand-Driven MRP in Excel Workshop
|Dates:||26 – 27 May 2016|
|Times:||9am to 5pm|
|Location:||Woodbrooke Conference Centre
1046 Bristol Road
Birmingham UK, B29 6LJ
|Cost:||£900 + VAT|
This workshop is intended to teach the basic principles in integrated supply chain planning and the DDMRP method.
We will use a fully functional system with a fictitious manufacturing company to show how a DDMRP system works. You will set up inventory buffers to position against variable demand and then see how they perform with a series of demand scenarios.
You will come away from this workshop with a fully functional DDMRP planning system in Excel- there is not licence or additional cost. With the skills you learn here, you could connect the system to your own data and have a complete integrated planning system working as a pilot or even a live system.
What this course will provide:
- 2 days of classroom and hands-on training on DDMRP in Excel
- An overview of DDMRP and integrated supply chain planning concepts
- A detailed look into our methods and templates for building planning systems in Excel
- A copy of an unlocked, fully-functional DDMRP planning system in Excel
- The knowledge of how to connect it with your own data
What this course will NOT provide:
- Certified training on DDMRP (please visit the Demand-Driven Institute for the CDDP and CDDL courses)
- Ongoing support for the DDMRP system after the workshop (We can help you at additional cost as a consulting service)
What you will need to bring:
- A Windows laptop with Microsoft Excel 2007 or higher installed
If you have completed the CDDP or CDDL courses (certified DDMRP training ) this will be advantageous, but it is NOT a requirement. We only have 12 places for this course to keep the class size small and a good level of attention to your questions.
Registration is now closed
You can also see our DDMRP in Excel system in a half-day workshop that Tony Rice will be presenting at SAPICS 2016, 12 – 14 June in Sun City, South Africa. We will also be giving away a free copy of the DDMRP in Excel planning system to every participant in that workshop.
Participation is included for all delegates registered to the SAPICS conference. Find out more about the SAPICS event here.