Level 2 - 3.3.5.3 Check Your Work: issues with the figures in the module INV01 Inventory Ordering

LucaB

Hi,

I completed the formulas in the module INV01 Inventory Ordering, however the figures do not match what reported in the training:

this my module

these the formulas

The Confirmed Purchase Order Receipt value is expected to be 8,194 while in my case is 8,116

In the In Week 5 FY20 column, the Reorder Flag is expected to be TRUE because the Ending Inventory value in Week 7 FY20 should be less than 0. 

In my case instead (see the picture above) my Reorder Flag is FALSE since the Ending Inventory value in Week 7 FY20 is not less than 0….

I'm very confused, anyone can help me out?

Thanks in advance,

Luca

Prajjwal88

Hi @LucaB ,
I can see that the value for the Confirmed Purchase Order Receipt line item is ultimately driven by other calculations, which trace back to the DEM03 Demand Forecast module.

Could you please check if you've applied the growth percentage correctly or whether you've rounded the demand values after applying the growth? If the forecast isn't rounded as expected, it can cause downstream differences like the one you're seeing in INV01.

Hope this helps.