Jeff George
Well Known Member
I've been experimenting with an issue, and I haven't come up with a solution yet.
My company runs a weekly MRP full regen for products in certain Master Planning Families. The version of Supply & Demand Inclusion Rules for this run are empty, but it includes the forecast type for these finished good families. We'll call this MRP A.
This specific run is followed up by a full regen for everything else outside these MPF, using a fairly standard version of Supply & Demand Inclusion Rules. There is also a nightly Net Change based on this run. We'll call this MRP B.
The issue is that the components from MRP B are showing both Firm Work Order Demand for the items that are part of MRP A as well as Planned Work Order Demand based on the forecasts used in MRP A. There is no consideration that there are already Firm Work Orders for the same time period as the Planned Work Orders from the Forecast. Likewise, if you look at the Time Series for something in MRP A you see both the Firm Work Orders and Planned Work Orders (from the forecast) in the same period.
The result is that the Supply & Demand for the components are overstating Demand because of these forecasts. What is the best way to resolve this issue? I've thought that we need to have MRP A use the same Supply & Demand Inclusion Rules and use Forecast Consumption, but the problem with that is that most of the component demand is being created simply by the forecast and existing work orders, not sales orders.
My company runs a weekly MRP full regen for products in certain Master Planning Families. The version of Supply & Demand Inclusion Rules for this run are empty, but it includes the forecast type for these finished good families. We'll call this MRP A.
This specific run is followed up by a full regen for everything else outside these MPF, using a fairly standard version of Supply & Demand Inclusion Rules. There is also a nightly Net Change based on this run. We'll call this MRP B.
The issue is that the components from MRP B are showing both Firm Work Order Demand for the items that are part of MRP A as well as Planned Work Order Demand based on the forecasts used in MRP A. There is no consideration that there are already Firm Work Orders for the same time period as the Planned Work Orders from the Forecast. Likewise, if you look at the Time Series for something in MRP A you see both the Firm Work Orders and Planned Work Orders (from the forecast) in the same period.
The result is that the Supply & Demand for the components are overstating Demand because of these forecasts. What is the best way to resolve this issue? I've thought that we need to have MRP A use the same Supply & Demand Inclusion Rules and use Forecast Consumption, but the problem with that is that most of the component demand is being created simply by the forecast and existing work orders, not sales orders.