Hierarchy and Demand planning(like MRP)
I was wondering if you might be able to help point me in the right direction as I seem to have hit a wall. I am building a model which appears to have a linear hierarchy SKU-> Product -> product Family and this is working as expected.
However in part of the model I need to work out component requirements in which we currently take the monthly figure then multiply it by a percentage per component. The problem I'm having is that to be able to do this I feel I need to change my hierarchy but as soon as I do that the levels below can't map he current level and I need the figures from the existing hierarchy to get my solution. e.g. Jan 10,000 is made up of part A 60% and part B 40% I want to be able to show that at product family level we need 6000 Part A and 4000 Part B
I'm just a bit stumped and I'm looking for possible suggestions that might get me moving on it.