Forecast consumption

Kinetic ERP
1

I need some help to figure out how best to handle the situation we’re in. we have our forecast window set to 5 days before and 5 days after. most forecasts are weekly on Monday’s so that MRP drives to have the parts available to ship by then. The issue we have is that when a Sales Order doesn’t ship on Friday because the trucking company didn’t pick up on time, come Monday that Sales order is still open and consumes the next weeks forecast as well making our forecasts and the consumption inaccurate.

Is there any way to stop a sales order from Consuming more forecast when it has already consumed forecast in the previous week?

Example:
On Friday 12/12, forecast was fully consumed for that week (forecast dated 12/8)
One SO was still open that did not ship as planned, due Friday 12/12
Consumed forecast for 9/8 dropped off (5 days after)
Sunday 12/14
SO that didn’t ship 12/12 was still open
Forecast for 12/15 was first partly consumed by the 12/12 SO, then the rest consumed by a new order that came in for the week of 12/15 - 12/19 .
The remainder of the new SO consumed part of next week’s forecast incorrectly.

2

Can you change the window to be 0 before and 10 after? Or vice versa?

3

We have tried various days before/after windows and 5/5 seemed to fit with the majority of the customers and how they order. Now that we know this is an issue though, we may have to re-evaluate to see if changing it will solve this issue without causing other challenges. I was hoping there was something that said “if the SO already consumed a forecast, don’t consume another one”

4

That is the issue with forecasts, there is no one to one consumption. As long as there is open forecast, any order will consume it if it falls in the date range.

1 Like