• Twitter - Grey Circle
  • Facebook - Grey Circle
  • LinkedIn - Grey Circle

Access to and use of this website is subject to our Terms & Conditions, Cookie Policy & Privacy Policy
© mySupermarket Limited, 2005-2017. All rights reserved.

Availability

The availability report can be used by Brand Managers to understand which specific retailers and which specific branches of a retailer are experiencing stock availability issues with their products. Top level availability issues will be highlighted at the top of the screen.

 

It is important to note that this report analyses availability in a regional resolution. For example, the client can track availability in each of the retailer branches, they can then focus on specific branches that exhibit high out of stock issues and work to resolve them.

 

The KPI’s covered in this report are:

  • Portfolio Size - gain an understanding of which SKU’s are available to purchase with the parameters selected. If an SKU was available in the last 30 days, it will be displayed here.

  • In Stock - Shows the % of in stock SKU’s from the parameters selected.

  • Out of Stock - Shows the % of out of stock SKU’s from the parameters selected.

  • Void - SKU’s out of stock for the past 14 days are noted as ‘void’.

 

When viewing the Availability report, the first part of the screen shows a top level breakdown of the brand’s availability across the retailers that they have selected.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Terms used in this report:

 

  •  Your availability: availability KPIs of selected brand/s.

  • Category benchmark: Metrico algorithm calculates average stock KPIs across entire category (all brands).

  • Top sellers/top SKUs: Most popular SKUs according to MSM sales data.

  • Top branches: Most popular branches ac

  • cording to MSM sales data.

  • Promotions availability: availability of SKUs that are now under promotion.

  • NPDs availability: Availability of SKUs that are considered NPD.

 


The below graph shows availability by the retailer. Hovering over a column indicates the specific availability breakdown in that retailer.

 

 

 

 

 

 

 

 

 

 

 

.

 

 

 

 

 

 

 

 

Clicking on the retailer itself will then bring you to a further breakdown where you can drill down to see the specific stock data per branch. Branches with the highest out of stock levels are highlighted at the top.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

As with most reports, the raw data is visible in an exportable format at the bottom of the report page. Clicking on the retailers in this view will bring you to the individual retailer view as shown in the screenshot above. In addition, data can be exported based on SKU availability.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Trended Reports

 

Trended reports have been created to highlight data patterns over periods of time. 

 

Date Ranges:

 

  • Last month - compared to same month year before
  • Single date- compared to same day year before
  • Last week - compared to same week (by week number) year before

  • Custom range - i.e 1-12 Jan 2017 - compare to 1-12 Jan 2016

 

Scope

 

  • For numbers, data will be presented - YOY % change

  • For percentages - YOY point change

  • For graphs - add YOY reference line/bar graph

 

 

 

Trend on\off will be controlled by the user. The user will be able to turn trend on\off by checkbox at the top part of each report.

 

 

 

 

 

 

 

 

Availability Dashboard 

 

Trend points are shown in points for Your availability and Highlights, the trends will show in this section regardless if "Show Trends is selected 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The trend will show in points not percentage (i.e percentage gone up from 93% to 97% will show trend of 5 points).

 

 

Out of Stock and Void trends

 

A downward green arrow will indicate a positive change, an upwards red arrow will indicate a negative change. 

 

If the change is 0% the number will show 0%, if there is no data the data will show - "N/A"

 

In stock trends

 

A downward red arrow will indicate a negative change, an upwards green arrow will indicate a positive change.

 

If the change is 0% the number will show 0%, if there is no data the data will show - "N/A"

 

Availability by Retailers (date range)

 

When selecting a custom range date longer than a single date, the Availability by Retailer chart will show, here you can use the drop down list to change retailer enabling you to view one retailer at a time. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Availability by Retailers (Single date)

 

When selecting a single date, the Availability trend bar graph will show, here you can use the drop-down list to change retailer enabling you to view one retailer at a time.