Related topics
This function allows you to interactively increase the suggested order size of a purchase suggestion so you can meet target values for an order’s weight, value or volume.
You can access this program directly from a purchase suggestion and set the desired target value. The system interactively cycles through the purchase suggestion lines, including lines not originally suggested for purchase (null suggestions), and proportionally increases the days of supply until the approximate target value is reached. The number of days added to a suggestion will never exceed the value entered in Max line buy days in the IC control file, a value that may not exceed one year.
Interactive line buy calculations
This section describes the suggestion quantity calculations for interactive line buy.
In the example below, a constant rate of forecasted consumption is 10 units a day. The daily forecasted consumption is not a constant in cases where periods are spanned and an item is seasonal or a sales promotion is defined for it.
Note: The daily forecasted consumption will only increase the suggested order quantity once the EOQ has been exceeded.
Original suggestion (5 days):
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
100.00 |
200.00 |
200.00 |
| 100B |
<40> |
<40> |
50.00 |
0.00 |
| 100C |
100.00 |
100.00 |
75.00 |
100.00 |
Original suggestion (5 days) + 1 day:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
110.00 |
200.00 |
200.00 |
| 100B |
<40> |
<30> |
50.00 |
0.00 |
| 100C |
100.00 |
110.00 |
75.00 |
110.00 |
Original suggestion (5 days) + 2 days:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
120.00 |
200.00 |
200.00 |
| 100B |
<40> |
<20> |
50.00 |
0.00 |
| 100C |
100.00 |
120.00 |
75.00 |
120.00 |
Original suggestion (5 days) + 4 days:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
140.00 |
200.00 |
200.00 |
| 100B |
<40> |
0.00 |
50.00 |
0.00 |
| 100C |
100.00 |
140.00 |
75.00 |
140.00 |
Original suggestion (5 days) + 5 days:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
150.00 |
200.00 |
200.00 |
| 100B |
<40> |
10.00 |
50.00 |
50.00 |
| 100C |
100.00 |
150.00 |
75.00 |
150.00 |
Original suggestion (5 days) + 10 days:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
200.00 |
200.00 |
200.00 |
| 100B |
<40> |
60.00 |
50.00 |
60.00 |
| 100C |
100.00 |
200.00 |
75.00 |
200.00 |
Original suggestion (5 days) + 11 days:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
210.00 |
200.00 |
210.00 |
| 100B |
<40> |
70.00 |
50.00 |
70.00 |
| 100C |
100.00 |
210.00 |
75.00 |
210.00 |
Original suggestion (5 days) – 5 days:
| Item |
Original requirement |
Revised requirement |
EOQ |
Suggested quantity |
| 100A |
100.00 |
50.00 |
200.00 |
200.00 |
| 100B |
<40> |
<90> |
50.00 |
0.00 |
| 100C |
100.00 |
50.00 |
75.00 |
75.00 |
Enquiries
- Purchase suggestion enquiry
Related topics