Hello,
My problem is as follows:
I have a monthly sales forecasts per customer which I need to convert to a weekly sales forecast per customer taking into account the following elements:
1) Monthly Sales forecast per Customer:
<tbody>
</tbody>
2) Some weeks cross over 2 months (assumption: week starts on a Monday)
3) I have a historical profile of sales per customer per week of month (maximum 6 weeks in 1 month) which also needs to be applied:
<tbody>
</tbody>
So I want to have these elements taken into account when transforming the monthly sales forecast to a weekly sales forecast.
The goal is to fill in the weekly forecast per customer according to the following setup:
<tbody>
</tbody>
Your help is greatly appreciated.
MDPOR
My problem is as follows:
I have a monthly sales forecasts per customer which I need to convert to a weekly sales forecast per customer taking into account the following elements:
1) Monthly Sales forecast per Customer:
| August | September | October | November | December | |
| Customer X | 32 000 | 25 000 | 15 000 | 45 000 | 20 000 |
<tbody>
</tbody>
2) Some weeks cross over 2 months (assumption: week starts on a Monday)
3) I have a historical profile of sales per customer per week of month (maximum 6 weeks in 1 month) which also needs to be applied:
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | |
| Customer X | 10% | 20% | 15% | 35% | 15% | 5% |
<tbody>
</tbody>
So I want to have these elements taken into account when transforming the monthly sales forecast to a weekly sales forecast.
The goal is to fill in the weekly forecast per customer according to the following setup:
| Aug 1 - Aug 7 | Aug 8 - Aug 14 | Aug 15 - Aug 21 | Aug 22 - Aug 28 | Aug 29 - Sep 4 | ... | |
| Customer X | Amount A | Amount B | Amount C | Amount D | Amount E |
<tbody>
</tbody>
Your help is greatly appreciated.
MDPOR
