DRP - Excess Sales Orders FAQ

Question: In Product DRP Management, how are excess sales orders values calculated for monthly forecasting with weekly scheduling?

Answer: The excess sales orders are distributed based on the sales order required dates in reverse chronological order.

Example The total quantity of open sales orders in January 2020 is 200. The remaining forecast is 150. Excess sales orders are calculated as 50, and then the 50 is distributed into weekly periods as shown below.

Order #

Required Date

Open Sales Order Quantity

Remaining Forecast

Schedule Week

Excess Sales Orders

NJ.1

01/01/2020

55

30

12/26-01/01

10

NJ.2

01/08/2020

25

30

01/02-01/08

0

NJ.3

01/13/2020

50

30

01/09-01/15

20

NJ.4

01/18/2020

20

30

01/16-01/22

0

NJ.5

01/26/2020

50

30

01/23-01/29

20

Total

 

200

150

 

50