Formula for Calculating Forward Weeks Cover....

Anyone had any ideas on how to solve my issue ?.... let me know if you require any further clarification over and above that already provided.

Thanks.

Hi
How did you work out COGS for a future date?
I would use the average COGS for an overall position.
Would this suit your needs?
eg: current SOH / (( prev 3 months COGS / ( prev 3 months workdays / 5 )) = weeks cover.