Set up a minimum and maximum key can help you with a flexible coverage from Master planning. This is useful when you want to make a seasonal forecast.
Static Min and Max Key:
Static Max and variable Min Key:
Variable Min key and Max Key:
Example:
Set up a Static minimum key
|
Date |
Sales Forecast Qty |
Planned Order Qty |
Minimum Stock |
|
1/01/2008 |
500 |
600 |
100 |
|
2/01/2008 |
500 |
600 |
100 |
|
3/01/2008 |
700 |
800 |
100 |
|
4/01/2008 |
500 |
600 |
100 |
|
5/01/2008 |
500 |
600 |
100 |
|
6/01/2008 |
500 |
600 |
100 |
|
7/01/2008 |
500 |
600 |
100 |
|
8/01/2008 |
900 |
1000 |
100 |
|
9/01/2008 |
1800 |
1900 |
100 |
|
10/01/2008 |
1400 |
1500 |
100 |
|
11/01/2008 |
1500 |
1600 |
100 |
|
12/01/2008 |
700 |
800 |
100 |
Set up a variable minimum key
| Date | Sales Forecast Qty | Planned Order Qty | Minimum Stock |
| 1/01/2008 | 500 | 600 | 100 |
| 2/01/2008 | 500 | 700 | 200 |
| 3/01/2008 | 700 | 800 | 100 |
| 4/01/2008 | 500 | 600 | 100 |
| 5/01/2008 | 500 | 600 | 100 |
| 6/01/2008 | 500 | 700 | 200 |
| 7/01/2008 | 500 | 800 | 300 |
| 8/01/2008 | 900 | 1400 | 500 |
| 9/01/2008 | 1800 | 1900 | 100 |
| 10/01/2008 | 1400 | 1500 | 100 |
| 11/01/2008 | 1500 | 1600 | 100 |
| 12/01/2008 | 700 | 800 | 100 |
Welcome to Khue Trinh 
Leave a comment