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.
Here are five things you need to know about forecasting.
This is a statistics-free zone. Five forecasting principles for demand planning.
How does your Excel planning measure up?
Are you getting the best results or are you suffering from Excel hell?
Here is a simple measurement and a download tool that can give you an instant rating on your planning tools built with spreadsheets.
We build planning and scheduling systems in Excel.
Some systems like this material planning example have more than one user, in different locations.
Here is a way to share Excel data across multiple users by using a simple cloud service.
The biggest headache in material planning is long lead-time materials.
Here is a simple tool that gives visibility between a buyer and a factory separated by a lot of water.
Also see an easy trick to connect multiple Excel users on different continents with free data integration over the cloud.
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.
Happy new year! A time for planning and new year resolutions.
Ouch. The word “Resolutions” doesn’t give you good feelings, does it?
I prefer habits -form them and it takes effort to break them. Here are seven good habits for using Excel for planning.
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 a simple example of such …
