Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items

sharukhhshaik
sharukhhshaik
in Modeling

Hi, I am getting the wrong values for "Beginning Inventory" and "Forecast Demand" in INV01.

I have used the following formulas..

Beginning Inventory: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

Forecast Demand: 'DEM03 Demand Forecast'.Final Forecast

Final Forecast(in DEM03): IF NOT Override? THEN Initial Demand Forecast ELSE Override Forecast

I've been struck here for a while now. Please help!!

image.png

Thanks,

sshaik

Categories