Here is a demonstration of how to use the Fast Excel Development Template. You can see how we build a Material Planning Tool in just 10 minutes using this template.
The inputs are demand, on-hand inventory and open purchase orders. The outputs are availability and shortages for all of the sales orders. It is helpful to know which orders have material cover and which cannot be met with current on-hand and on-order stock.
Here is an article from October 2020 that describes the latest features in Template Version 4.
If you are registered and logged in as a free member, you can download the template with the link below.