I am trying to figure out how i can project forwards my stock value based on my incoming materials, usage and demand.
Sounds easy as i type it however i seem to have had a brain power loss today.
I have my Current stock level id like to take the current stock value deduct the usage from our planning MRP system and then add the purchase orders that are inbound to get the expected stock level next month.
Then once i have that value, going forwards id like to predict as far into the future as my date table allows 2022 or something.
I have watched the forecasting videos but these are all based from historical data looking back over time im trying to use the actual value of my inventory and predict forwards from that.
See the graph below the red is my current inventory value then grey is the open orders and there will be a blue one called demand shortly i just ran out of time. id like to project this red bar inventory value all the way through something like
Current inventory value + Open POs - demand = November Dec and so on and on