Skip to Content
1
Oct 25, 2018 at 06:44 PM

Weighted avg for min/max inv targets aggregated at product level

145 Views

We are implementing IBP IO and have a requirement to take the weighted average for min and max inventory targets, which are at a PERPRODLOC level, and assigning this weighted average to the min/max at the aggregated PERPROD level. I was wondering how this can be done in IBP. The business does not have a file providing the weights but would like this calculation to be done for these key figures in IBP. Is there a way for IBP to reference the key figure quantities and assign the weights based on the inventory in those product-locations? Does anyone know the best approach to assign this weighted average at an aggregated product level?