Register
Ask the Community

Week Coverage, also known as forward coverage or stock cover

Week Coverage, also known as forward coverage or stock cover

Status: Considered for Future Roadmap Submitted by Community Manager on ‎10-01-2018 09:46 AM
3 Comments (3 New)

A description of the enhancement requested
Week Coverage, also known as forward coverage or stock cover.
As an example we have Forecast Sales and Current Stock.
Formula should calculate how many future periods of forecast will be covered by Current stock.

This is achievable in Anaplan with below function:

Look Forward + (Stock - MOVINGSUM(Forecast Sales, 1, Look Forward, SUM)) / OFFSET(Forecast Sales, Look Forward + 1, 0)

"Look Forward" is a list item of number format where you give the number of value to look forward.
The formula is complicated, and MOVINGSUM only accepts time dimension.

 

A story for why they want the enhancement (specifically how would it help their business process)
I am pretty sure every supply planning models require this calculation. It is very informative for planners.
Users wanting similar expression can be found in below links.
https://www.excelbanter.com/excel-worksheet-functions/64914-help-single-cell-formula-calculate-weeks...

https://www.mrexcel.com/forum/excel-questions/415158-inventory-forward-cover-calculation.html

This formula can be used for other financial calculations as well.

3 Comments
AnaplanIdeas
Community Manager
Community Manager
‎10-01-2018 09:46 AM
‎10-01-2018 09:46 AM
 
Status changed to: Considered for Future Roadmap
Cam_Haines
Occasional Contributor
Occasional Contributor
‎11-07-2018 11:07 PM
‎11-07-2018 11:07 PM

I 100% second this enhancement request.  Calculating a weeks or days of inventory in this manner is basic inventory and supply planning functionality and really needs to be added to the platform to compete with other supply chain software solutions.

 

Just making sure... the formula you entered above is just a description of how this would work if Anaplan was to add the Look Forward function, correct?  When I first read through it, I thought you found a work around or something.  If you did, I'm all ears.

 

 

DeveloperCYT
Regular Contributor
‎04-01-2019 08:40 AM
‎04-01-2019 08:40 AM

This is something that i would have hoped would be a 'built in'. Trying to calculate stock cover on very variable Demand and Inventory data is hard, and when you then move up the hierarchy of products, it becomes very unstable and includes outliers which then have a huge impact on stock days, where as they should be handled differently.

Currently I am not aware of a 'good' method to calculate days cover, are there any suggestions, pointers or examples please?

 

thanks