Hi Gurus,
I am confused about the influence of demand source in item record to calculate item demand plan. Please explain to me!
In sandbox enviroment, I created 4 items:
| Item Name | Setup Demand Source |
| 02 Forecast and Orders | Forecast and Orders |
| 03 Forecast Consumption | Forecast Consumption |
| 04 Forecast from Demand Plan | Forecast from Demand Plan |
| 05 Entered and Planned Orders | Entered and Planned Orders |
Other setup information in item record are the same:
Default ATP Method = Cumulative ATP with Look Ahead
Replenishment method = Time Phased
Lead time = 0
Safety stock level = 0
Lot sizing method = Lot For Lot
Supply type = Purchase
For each item, create data to calculate item demand plan below:
| Expected ship date | Transaction | Quantity |
| 01/03/2020 | Estimate 1 | 2 |
| 20/03/2020 | Sale Order 1 | 10 |
| 31/03/2020 | Opportunity 1 | 50 |
| 31/03/2020 | Sale Order 2 | 20 |
| 15/04/2020 | Estimate 2 | 37 |
| 20/04/2020 | Sale Order 3 | 3 |
| 27/04/2020 | Sale Order 4 | 5 |
| 04/05/2020 | Estimate 3 | 2 |
| 10/05/2020 | Sale Order 5 | 20 |
| 28/05/2020 | Sale Order 6 | 6 |
| 31/05/2020 | Opportunity 2 | 19 |
| 10/06/2020 | Sale Order 7 | 20 |
| 15/06/2020 | Sale Order 8 | 7 |
| 22/06/2020 | Estimate 4 | 5 |
| 30/06/2020 | Opportunity 3 | 15 |
| 05/07/2020 | Sale Order 9 | 3 |
| 16/07/2020 | Estimate 5 | 7 |
| 31/07/2020 | Opportunity 4 | 10 |
| 06/08/2020 | Sale Order 10 | 7 |
I calculated Item Demand Plan with the parameter below:
Projection method = Sales Forecast
Projection interval = Weekly
Projection start date = 14/06/2020
Projection duration = 8 weeks
For these item, the result of each item demand plan is the same, below:
| START DATE | END DATE | WEEKLY CALCULATED | QUANTITY |
| 31/05/2020 | 06/06/2020 | | 61 |
| 07/06/2020 | 13/06/2020 | | |
| 14/06/2020 | 20/06/2020 | 7 | 7 |
| 21/06/2020 | 27/06/2020 | 0 | 0 |
| 28/06/2020 | 04/07/2020 | 15 | 15 |
| 05/07/2020 | 11/07/2020 | 3 | 3 |
| 12/07/2020 | 18/07/2020 | 0 | 0 |
| 19/07/2020 | 25/07/2020 | 0 | 0 |
| 26/07/2020 | 01/08/2020 | 10 | 10 |
| 02/08/2020 | 08/08/2020 | 7 | 7 |
| 09/08/2020 | 15/08/2020 | | |
| 16/08/2020 | 22/08/2020 | | |
| 23/08/2020 | 29/08/2020 | | |
| 30/08/2020 | 05/09/2020 | | |
So I am confused that how configuration demand source in item record affect to calculate item demand plan?
Because 4 items are setup the different demand source but with the same data and same projection method, item demand plan is the same.
Thank you so much!