How to: Set Up Stock Coverage

Stock Coverage is a functionality which enables users to calculate how long a store is able to continue selling items or groups of items given a sales history and inventory. A Coverage Goal (weeks) can be set up in the Stock Coverage page per item category or product group, as well as for a specific season. When the Stock Coverage is set up for a specific season, its Ending Date follows the ending date for that season and the Coverage Goal (weeks) is then automatically calculated. The Weekly Sales Qty. is calculated based on the No. of Sales Days to Analyse field in Replenishment Setup.

To set up No. of Sales Days to Analyze

  1. Click the icon, enter Replen. Setup, and select the relevant link.
  2. In the Stock Coverage and Store Capacity FastTab, fill in the No. of Sales Days to Analyse field. This field defines how many days to go back in history for Weekly Sales Qty. calculation in Stock Coverage.

Note: If the Stock Coverage is only set up for a specific season, make sure that the Season Code field in the Retail Item Card is filled for all affected seasonal items.

To set up Stock Coverage

The Stock Coverage page is accessible with the Stock Coverage action, which you can find in:

  • Locations page.
  • Retail Item Categories page.
  • Retail Product Groups page.
  • Seasons page.
  1. On any of these pages, click the Stock Coverage action to open the Stock Coverage.
  2. Fill in the Location Code.
  3. Fill in the Item Category Code.
  4. Fill in the Product Group Code, if needed.
  5. Fill in the Season Code if the coverage is set up for a specific season. The Ending Date is automatically updated from the season.
  6. Update the Ending Date manually, if needed.
  7. The Goal (weeks), which is the coverage goal for the item category or product group, can be manually entered if no Ending Date exists. It will always be automatically calculated if an Ending Date exists.
  8. Repeat steps 2 to 7 for each Stock Coverage you want to create.
  9. Click the Calculate Coverage action to calculate and update the value for Eff. Inventory, Weekly Sales Qty., Actual (weeks), and Coverage %. For more information see How to: Calculate Stock Coverage.

Note: The Last Time Calculated field indicates the date and time of the last Calculate Coverage action performed.

See also

Stock Coverage

Lifecycle Planning Worksheet