Forecasting Help

[lachlanmclean]

Hi Everyone,

I am trying to create a forecasting table that will tell me how many months of cover I have based on current stock on hand. In the image you can see the fields Sock Holdings and Outbounds Forecast. What I need is to create a field where I can see for example March 2024, how many future months I have in cover based on current SOH and the figures in the outbound forecasts.

Thanks!

[TheTimeSavingCo]

Hm, I'm not too sure what you're trying to do so I put this together:

This is just Stock holdings / Outbounds forecast; what would you need to have changed from this?

[lachlanmclean]

Hi Adam, What I need is: take the march record, the stock holding is 24352, when comparing this to the outbound forecast it is 2471 then 1000, 6084 4373 ect. What I need to do is know how many months that 24352 would cover based upon the amounts in the monthly outbound forecast.

[TheTimeSavingCo]

Hmm, so you need to take the "Outbound forecasts" from the next couple of months and deduct it from March's "Stock holding" value until it hits 0, is that right? 

If so, I'd recommend a script to handle that as I can't think of how to do that with automations alone I'm afraid