Excel WSSI Template Instructions

wssi template instant download

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.

Parts of the WSSI Template

  1. Today’s Date – this is a formula that will update daily
  2. Opening stock £
  3. Opening stock U
  4. Calendar Month
  5. Business week number
  6. Week commencing calendar date
  7. Current year sales value
  8. Plan sales value
  9. Previous year sales value
  10. Percentage performance variance verses previous year
  11. Previous year minus one sales value
  12. Percentage performance variance verses previous year minus one
  13. Current year sales units
  14. Previous year sales units
  15. Percentage performance variance verses previous year
  16. Previous year minus one sales units
  17. Percentage performance variance verses previous year minus one
  18. Current closing stock value
  19. Plan closing stock value
  20. Previous year closing stock value
  21. Previous year minus one closing stock value
  22. Current closing stock units
  23. Previous year closing stock units
  24. Previous year minus one closing stock units
parts of the wssi template

Parts of the WSSI Template

25. Current year spot cover
26. Previous year spot cover
27. Previous year minus one spot cover
28. Current year 8 week forward cover
29. Previous year 8 week forward cover
30. Previous year minus one 8 week forward cover
31. Total Markdown cost value
32. Total POS cost value
33. POS % of sales
34. Markdown % of sales
35. Previous year Markdown cost value
36. Previous year POS cost value
37. Previous year POS % of sales
38. Current year intake value
39. Current year intake cost value
40. Current year intake margin %
41. Current year intake units

parts of the wssi template

Parts of the WSSI Template

42. Month subtotal
43. Rolling cumulative subtotal
44. 6 month total

parts of the wssi template

Parts of the WSSI Template

45. 12 month (full year) total
46. Start of the following business year

parts of the 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)
  5. Input current year sales units and value (can be a mix of actualised and forecast sales)
setting up the wssi template for the first time
setting up the wssi template for the first time
setting up the wssi template for the first time
setting up the wssi template for the first time

Updating actualised numbers

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

Accessing performance metrics

  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 eight weeks
  3. Forward cover is over two weeks slower than the forecast forward cover – in this template the forecast forward cover is eight 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
  •  

WSSI Template

Perfect for experienced users
£ 18
00
  •  

Join my mailing list

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

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.