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

208 January 5, 2017 8083

Summary:

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)