Weeks Cover is the ratio of stock to sales at the end of a single week and shows how many weeks the same level of sales could be maintained if there was no further intake. Weeks Cover is also a very useful measure of relative demand. and. Some retailers, especially those with a very fast stock turn such as grocers will use Days Cover.
Cover is calculated differently depending on whether you are using Units or Value, although the result will be the same.
UNIT WEEKS COVER = CLOSING STOCK UNITS ÷ SALES UNITS
VALUE WEEKS COVER = CLOSING STOCK VALUE ÷ (SALES VALUE + PROMOTIONAL COST + DISCOUNTS)
WEEKS COVER (UNITS)
1,000 ÷ 100
WEEKS COVER (VALUE)
10,000 ÷ (850 + 100 + 50)
7.2.10 AVERAGE WEEKS COVER
The Average Weeks Cover for a period longer than a week (or day) is calculated using the total sales and the sum of the weekly closing stocks for the period. Average Weeks Cover is mostly used to show relative demand over the period concerned.
SUM OF CLOSING STOCK
CLOSING STOCK WEEK 1 + CLOSING STOCK WEEK 2 ETC.
AVERAGE WEEKS COVER
12,000 ÷ 2,500
7.2.11 STOCK TURN
Stock Turn measures the number of times throughout the year that stock is completely replaced in the outlets. It is a critical measure of business health since it reflects the speed at which the business turns its assets into cash.
It can be calculated in two ways. The result is the same.
STOCK TURN = 52 X (ANNUAL SALES ÷ SUM OF CLOSING STOCKS )
STOCK TURN = 52 ÷ AVERAGE WEEKS COVER
SUM OF CLOSING STOCK FOR YEAR
CLOSING STOCK WEEK 1 + …. CLOSING STOCK WEEK 52
STOCK TURN (METHOD 1)
52 X (2,600 ÷ 33,800)
AVERAGE WEEKS COVER
33,800 ÷ 2,600
STOCK TURN (METHOD 2)
52 ÷ 13.0
Method 2 can be used to calculate the prevailing annual Stock Turn using the data for ANY period
7.2.12 FORWARD COVER
Forward Cover is used in conjunction with Weeks Cover to determine if the business is holding sufficient stock.
It can be calculated using units or value and shows :
• The number of weeks of future actual or forecast Sales Value, Markdown, Promotional Cost, Discounts and Stock Adjustments Value that can be covered by the Closing Stock Value at the end of a week.
• The number of weeks of future actual or forecast Sales Units and Stock Adjustments Units that can be covered by the Closing Stock Units at the end of a week.
CLOSING STOCK UNITS
FORWARD COVER WEEKS
The Closing Stock of 750 units will cover sales performance
for 3 more weeks on the basis of the forecast performance for those weeks
Since the Forward Cover calculation looks at future performance which can be both actual or forecast it must always be calculated retrospectively and can change until all the future weeks it covers are actual performances. The Forward Cover of 3.0 in week 1 above will only be the ‘true’ figure, for example, if weeks 2 to 4 are the actual performances.
7.2.13 TERMINAL STOCK
Terminal stock is the value or unit stock remaining of a specific stock identity at the end of the corresponding season or merchandise half. It is usually represented either as a percentage of that season’s sales or as a percentage of the total closing stock in the ‘terminal week’