Forecast Based on Tonnage Factor

Summary:

Hi Experts,

We need your inputs in achieving solution for following demand management scenario

Content (required):

1) We get a high level target for tonnage on a monthly basis from an external EPM Tool.  (e.g. 5000)

2) This tonnage is then split across multiple suppliers Supplier A (10%) , Supplier B (50%) , Supplier C(40%) etc manually by percentages.

3) Again for each of these percentage what each supplier has to be fulfill we have a product Mix which is again split under each of these Suppliers.

I'm attaching an image for easy understanding. This product mix is also not system driven. But input provided by planner. Based on product mix percentage contribution, each of the end-item demand will be driven.