on ‎2020 Oct 13 8:24 PM
If I put in a Production Receipts Adjustment of one value in a given month, after the heuristic is run, I would expect the Production Receipts to be equal to that value for that month, but it isn't. Is this due to the monthly value being disaggregated to technical week (the planning level of the KF) and also converted to calendar week to run the heuristic?
Thank you for any insight you can provide.
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
Hello Susan,
I faced the same issue at one of our customer. Your assumption is correct, it has to do with the disaggregation to technical weeks. In my case it was because I was running the Supply Heuristic on Calendar Weeks, but we were looking at data on Monthly level. I will place here an explanation (based on calendar weeks, but with the same logic for months), which I hope will help you understand the concept:
Let's look at the key figures in different time levels:
M3 M4 M5
PRODUCTION 0 0 0
ADJUSTEDPRODUCTION 0 1000 0
TW14a TW14b(start of month M4) TW15 TW16 TW17 TW18a TW18b
PRODUCTION 0 0 0 0 0 0 0
ADJUSTEDPRODUCTION 0 100 250 250 250 150 0
W14 W15 W16 W17 W18
PRODUCTION 0 0 0 0 0
ADJUSTEDPRODUCTION 100 250 250 250 150
When you run the Heuristic on weekly level, the supply operator will see the values like in the Weekly level, so the result will be this:
W14 W15 W16 W17 W18
PRODUCTION 100 250 250 250 150
ADJUSTEDPRODUCTION 100 250 250 250 150
TW14a TW14b(start of month M4) TW15 TW16 TW17 TW18a TW18b
PRODUCTION 40 60 250 250 250 100 50
ADJUSTEDPRODUCTION 0 100 250 250 250 150 0
The ADJUSTEDPRODUCTION will not be disaggregated, because it is not an output of the Supply operator.
M3 M4 M5
PRODUCTION 40 910 50
ADJUSTEDPRODUCTION 0 1000 0
Because TW14a and TW18b is not part of M4 month, they will be in a different month and not the original one.
It's probably not the best explanation that you were looking for, but hopefully will guide you in the right direction of solving your issue.
Best regards,
Vlase
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
PS: Sorry about the formatting issue in my reply, but the text box doesn't support excel tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 17 | |
| 16 | |
| 6 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.