How to build a complete material and capacity planning tool, with finite production scheduling and purchased materials constraints by Excel and the Fast Excel Development Template.
Learn how to create your own Excel planning and scheduling tools for a manufacturing business. Some people want a spreadsheet tool so that it will solve their planning problems at the push of a button.
Others want to take it apart. Figure out how it works. Adapt it and build their own. If you’re like them, then this webinar is for you.
Predictive planning provides a way to manage uncertainty. Planning can resolve the dilemma between schedule-push and demand-pull.
How an Excel-based predictive planning tool can work alongside the business transaction system.
The dilemma of demand planning: to use a forecast or history.
We cannot expect history to repeat itself, yet every day we are reminded of inaccuracy and bias in the forecast.
How to combine the forecast and history to get a true measure of demand.
If you do not know your supply constraints, then it is likely your constraint is the MRP system.
How to use constraints-based planning and overcome the limitations of MRP logic.
I have demand, on-hand inventory and open purchase orders. What orders can I cover with materials and which orders are going to be short? This is a simple question in material planning. We frequently get asked by clients to build spreadsheet tools that can provide an answer. You can download