Help

Forecasting Help

Topic Labels: Automations Formulas
532 3
cancel
Showing results for 
Search instead for 
Did you mean: 
lachlanmclean
4 - Data Explorer
4 - Data Explorer

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.

lachlanmclean_0-1731018463597.png

Thanks!

 

3 Replies 3

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

Screenshot 2024-11-08 at 11.44.35 AM.png

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

lachlanmclean
4 - Data Explorer
4 - Data Explorer

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.

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