Forecasting Daily to Weekly MDS

Hi

I have a requirement in forecast entries.

We import forecast based of 5 different customer specific on day buckets for a week, This is possible as the customer details details can be maintained in forecast. But when we load the forecast to MDS we need to consolidate the daily quantity and create entry as Weekly in MDS.

For e.g.

Let us say Item 1 has Forecast qty as 100 on each day from Monday to Friday.

When we are loading into the MDS, we need to consolidate the day level qty to Weekly bucket that is 500 at the start day of the week that is on Monday..