Skip to Content
avatar image
Former Member

Adj. Customer Receipts Qty

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 31, 2015 at 05:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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