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.
Five Things You Need To Know About Forecasting Read More »
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.
Get an Instant Rating for your Excel Planning Read More »
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.
How to Share Excel Data in the Cloud Read More »
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.
How To Plan for Long Lead-Time Materials Read More »
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.
Uncertainty and the Predictive Power Of Planning Read More »
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.
Seven Habits for Highly Effective Excel Planning Read More »
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
Build a Material Planning Tool in 10 Minutes Read More »
