Skip to Content
0
Jul 06, 2020 at 07:33 AM

TS Supply Optimizer Demand and Inventory Target Fulfillment calculation on business log

259 Views Last edit Jul 06, 2020 at 07:34 AM 3 rev

Hello IBP Optimizer community,

I have been trying unsuccessful to explain the fulfillment percentage and Missing demand numbers that appear in the business log of IBP after running an optimizer.

Since I couldn't really find this in the help, I always thought that the Demand Fulfillment and Inventory Target Fulfillment rate were simple calculations:

Demand Fulfillment Rate: CONSENSUSDEMAND/CONSTRAINEDDEMAND X 100

Inventory Target Fulfillment rate: INVENTORYTARGET/PROJECTEDINVENTORY X 100

But as you can see for the following example, If I compare for the same Planning horizon all the key figures with the results of the business logs, these numbers don't really match and for a reason unknown to me, the optimizer is taking a Huge Amount of Demand and Inventory Targets that are not in my input key figures/

These are my KF at the highest Attribute level (Material Type)

CONSENSUSDEMAND : 99,000,000

CONSTRAINEDDEMAND: 88,000,000

INVENTORYTARGET: 1,300,000

PROJECTEDINVENTORY: 500,00

I have made sure that all my costs are up to date and bigger than zero and I also made sure I don't have any Adjusted/Minimum receipts.

Three questions:

  1. Have anyone have this issue before?
  2. What are the input key figures that are making optimizer consider more demand than there is in my CONSENSUSDEMAND KF
  3. How are Demand and Inventory target Fulfillment really calculated?

Thanks!