Level 2 Sprint 3 INV01 - Safety Stock Exception
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