Skip to Content
0
Jul 30, 2020 at 09:21 AM

How to disaggregate demand of a product group into each product in supply review?

73 Views

Hi experts,

Can you tell me the way to disaggregate demand of a product group into each product in supply review? For instance, assuming that demand of a product group called iPhone10 is 100 in a region, I want to disaggregate the demand into each product such as iPhone10-red and iPhone10-white respectively, depending on the pre-defined ratio. I assume that setting of how much to supply by each product can be done by manually in Excel, but I wanna know the automatic way. please help me, thanks.