• Creating effective merchandising and ecommerce strategies

Simple Excel WSSI Template Instructions

Simple WSSI Template

Congratulations!

You are about to begin an exciting adventure in performance analysis. From the moment you get familiar with your WSSI, you will be able to identify opportunities to improve performance and risks that could impact performance.

Before you start to use the template, I recommend reading through the following instructions, step by step, to discover the many features and ease of operation of the tool.

LIST OF CONTENTS

Template basics

Working with the template

Troubleshooting

General Information

Parts of the WSSI Template

  1. Today’s Date
  2. Opening stock
  3. Calendar Month
  4. Business week number
  5. Week commencing calendar date
  6. Current year sales units
  7. Previous year sales units
  8. Percentage performance variance verses previous year
  9. Current closing stock units
  10. Previous year closing stock units
  11. Current year spot cover
  12. Previous year spot cover
  13. Current year 4 week forward cover
  14. Previous year 4 week forward cover
  15. Current year intake units
Simple WSSI Template

Parts of the WSSI Template

16.Month subtotal

17. Rolling cumulative subtotal

18. 6 month total

Simple WSSI Template

Parts of the WSSI Template

19. 12 month (full year) total

20. Start of the next business year

Simple WSSI Template

Setting up the template for the first time

  1. Input opening stock units
  2. Input previous year sales and stock units (if known)
  3. Input current year intake (can be a mix of actualised and forecast intake)
  4. Input current year sales units (can be a mix of actualised and forecast sales)
Simple WSSI Template
Simple WSSI Template
Simple WSSI Template

Updating actualised numbers

  1. Input actualised current year sales units, closing stock units and intake for the reporting week.
  2. Change the colour of the updated sales to grey to show at a glance the difference between actualised and forecast data.
Simple WSSI Template

Accessing performance metrics

Simple WSSI Template
Simple WSSI Template
  1. Negative closing stock units – this will indicate that forecast units are too high or forecast intake it too light
  2. Forward cover is less than the forecast forward cover – in this template the forecast forward cover is four weeks
  3. Forward cover is over two weeks slower than the forecast forward cover – in this template the forecast forward cover is four weeks
  4. Current year sales are less than previous year, but stock is higher than previous year

Troubleshooting guide

Problem

Cause

Correction

Forward cover column shows #DIV/0!

Formula trying to divide by zero

Input sales units

Closing stock units showing as negative numbers

Sales forecast I higher than available stock

Input intake units, review sales forecast

Business Usecase Examples

Compare templates and features

Simple WSSI Template

Perfect for beginners
£ 12
00
  •  
Shop Now

WSSI Template

Perfect for experienced users
£ 18
00
  •  
Shop Now

Join my mailing list

Receive exclusive access to summaries of the content shared on my blog and socials. And the techniques behind my methodology.

Sign Up

Book a discovery call

A discovery call is an opportunity for you to share your business goals, receive FREE expert advice and gain insight on what to do next.

Book Now