How is Weeks-on-Hand calculated on the Merchandise Analysis Report

Summary:

How is Weeks-on-Hand calculated on the Merchandise Analysis Report

Cause:

Weeks on-hand is a measure of how many weeks to expect the current quantity on-hand to last, based on sales in the period entered.

Solution:

The formula for Weeks on-hand is:

Weeks on-hand = Qty-on-hand / Average-Qty-Sold-per-week

In this formula the Average-Qty-Sold-per-week is calculated as [7 * (Qty-sold / Days-in-period)

Article ID: 208
Created: July 29, 2014
Last Updated: January 5, 2017

Online URL: https://counterpoint.knowledgebase.co/article.php?id=208