Level 2 Sprint 3 INV01 - Safety Stock Exception

Options
tgovekar
tgovekar Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

Hello,

 

Im currently in Sprint 3. When I was publishing the values to a dashboard, I noticed My Safety Stock Exception value was very high(Screenshot attached)

On digging deeper, I found out my Ending Inventory values are negative for some months. Can this be the reason for high Safety Stock Exception value?

I have checked the formulas for Final Shipment and Confirm Purchase order receipt and they seem to be right.

I don't seem to know whats wrong.

Some of my formulas are as below:

Ending Inventory: Beginning Inventory + Confirm Purchase Order Receipt - Forecast Demand

Beginning Inventory: IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

Please help.

 

Regards,
Tejas.

Tagged:

Comments

  • tgovekar
    tgovekar Member, ALL USERS, Certified Model Builder Posts: 5 New Contributor

    @JussiLi 

    Thanks for the input.

     

    Regards,
    Tejas.

  • HAMPMAX
    HAMPMAX Member, ALL USERS, Partner, Certified Model Builder Posts: 1 New Contributor

    Hello

     

    I just wanted to reopen this thread as I have exactly the same problem. Unfortunately, it does not resolve once I upload the order schedule from the exam. Can someone please have a look at the formulas attached and help me to find and resolve the issue? 

     

    Would be very much appreciated after hours of trying!

    Thanks and BR
    Max

Categories