Currently we are following multi-level(10 to 15 levels) bill of material for producing a particular finished goods. Every week around 40 finished goods will run in the shop floor. The semi-finished or finished goods used to produce a particular finished goods can also be used to produce some other finished goods at any level. we are following make to order scenario and we used to deliver the finished goods partially to customer.
Based on customer demand we can also do partial planning weekly basis. MRP run is automated every day.
For planning we need to check what are all the semi-finished goods and raw materials required all the level for around 40 finished material that is planned for a week. we need what is the current on-hand stock for the above and what is the demand and our requirement too.
Kindly update me how can i do planning for total around 40 finished material in our system