Macro Enabled Notebook for Material Requirement Planning
This VBA does the material requirement planning by looking at the supply and demands of components. The algorithm takes top components and BOM structure into account and do the calculations accordingly. The scrit calculates the Available to Promise quantity according to each component and recommends an action if the supply fall short. Also, it merge the cells of the Available to Promise quantities of same item with different supply types.
This code is highly customized according to the business requirements itself, using it directly is not recommended.