Adj. Customer Receipts Qty

[Former Member]

Hi,

I want to simulate a scenario that a major customer has switched to another competitor that leads to excess inventory in our DC.

Customer Forecast is in "Consensus Demand Plan Qty"

It is propagated to "Constrained Demand Plan Qty"

Now that the customer demand has dropped to 0 and we are unable to ship the inventory produced for that customer. How to show that impact of excess inventory in current month in "Projected Inventory Qty"

I thought to use " Adj. Customer Receipts Qty" to control the shipment to customer but unable to simulate the scenario.

ideal simulation scenario:

1. customer demand for July month = 1000 units

2. Heuristics propagated this demand of 1000 units to DC and Production Plant

3. Production Plant has produced 1000 units and shipped it to DC

4. Now that customer is NOT issuing the PO to receive 1000 units, it will lead to excess inventory in DC

Please help in executing this scenario in IBP S&OP.

Thanks,

Tauseef

[former_member123657]

Hi

Try using the inventory correction KF. This will impact the Projected Stock.

This Key figure can either be +ve or - ve, I mean for Inv Correction KF.

Vivek

[Former Member]

Vivek,

Thanks for the suggestion, I will try that.

I want to do the following:

1. decrease "Supply Qty" so that I can exclude the supply qty for customer which leaves us

2. increase the "projected inventory qty" by the same quantity as decreased in step 1

3. decrease the "consensus demand plan qty" of that customer by same quantity as step 1

4. adjust the "customer source ratio" to 0 for this customer

Please suggest how to perform all these steps in sync and run the heuristics.

Thanks,

Tauseef

[Former Member]

Hi Tauseef,

I think making inventory correction as suggested by Vivek should resolve your issue. You can do the following-

1) Make inventory correction of double of quantity which were to be supplied to the customer( so for 1000 demand of customer make inventory correction of +2000 at DC)

2) This will build your projected stock to 1000( Inv correction - Customer demand) after running supply plan. It now represents the actual quantity which was received from plant.

3) Now you can manually delete the consensus demand qty for this customer and save the data.

4) From 'manage' master data option in excel, change the customer source ratio to 0 and save.

let us know if this works for you.

Best regards,

Rohit

[Former Member]

Hi Rohit and Vivek,

thanks for reply,

I tried using "adjusted customer receipt qty" to decrease the customer demand and "adjusted transport qty" to increase the receipt qty in DC but decrease the supply qty out of DC.

The "projected inventory qty" is increased now and simulation looks good.

Regards,

Tauseef