Each dashboard is a collection of reports containing the type of information that is used by brand managers and category managers at consumer marketing and retailing firms. Data such as market size, share, trade contribution and in-store promotions is obtained by these companies from retail tracking services. Information on perceptions and brand image is obtained from quantitative research studies, and information on media and advertising is obtained from media tracking services. Vendors for these services include Nielsen, the Kantar Group, Ipsos and IRI.
Market Dashboard is specially configured for reviewing market trends. The report enables you to gauge the size of the market, its growth rate, and the performance of retailers, manufacturers, brands, channels and segments. It covers information on sales volume, sales value and price, across all channels and chains, and across all segments. The dashboard is ideal for examining the impact of marketing activities on the market as a whole, and across channels, banners and segments.
The data shown in the video is for the Hygenia category. The tabs and the spin buttons at the top of the page, pertain to selections for dashboard, metric, segment, channel and category.
The chart on the right depicts the share for big brands and the one on the left pertains to the remaining brands.
As is the case with all the dashboards, the market dashboard is a collection of tables, and each table is a collection of views.
The data can be viewed across the 5 different channels and chains, including total trade. It can also view across the 5 different segments. So there are 25 tables for each trade/segment combination, and since the tables can be viewed in volume or value, there are 50 views per category, each providing a different perspective of the market share data. You normally tend to view only a few of these perspectives.
Share in Segment and Segment Contribution
Depending on the information you are seeking or the business issue you are studying, you need to examine the data in different ways. For instance, at times you are interested in the market as a whole, and at other times you want to zoom into a particular market breakdown (MBD) such as a chain or a particular segment. If you are interested in your brand’s performance in a segment or chain, you should examine the brand’s share in that market breakdown. On the other hand, if you want to know the importance of the segment or chain, examine its contribution. Contribution relates not only to your brand’s share in the MBD, but also to the size of the MBD.
For instance, a Hygenia brand may have relatively high share in the Hedonist segment, and because the segment is by far the biggest segment, its contribution to the brand’s sales is likely to be huge.
Sales | Total | Hedonist | Beauty | Family | Price |
---|---|---|---|---|---|
Hygenia | 10000 | 5000 | 2200 | 1400 | 1400 |
Iris | 2000 | 1250 | 200 | 300 | 250 |
Schisandra | 2000 | 750 | 600 | 400 | 250 |
Others | 6000 | 3000 | 1400 | 700 | 900 |
For a better understanding of the difference between market share and segment contribution, consider Table 2.2. Based on the data in this table, it may be concluded that Iris is relatively strong in the Hedonist segment, and that the segment is contributing 62.5% to the brand’s total sales:
Share in Trade and Trade Contribution
Sales | Total | Fujimart | Inulas | Lower Trade |
---|---|---|---|---|
Hygenia | 10000 | 2400 | 1800 | 5800 |
Iris | 2000 | 600 | 400 | 1000 |
Schisandra | 2000 | 800 | 400 | 800 |
Others | 6000 | 1000 | 1000 | 4000 |
Table 2.3 displays the break-up of sales across chains and the lower trade. This data tell us that:
One may drill deeper into the data, for instance, segment share within chain. If the Iris brand manager is interested in determining what proportion of Iris sales in Fujimart are to the Hedonists, she should select ‘Fujimart’ from the Trade Channel tab at the top, of the dashboard.
If however, she is interested in information pertaining to shopper segments (price conscious, quality conscious, convenience seekers and experimenters), she can obtain the required information from the trade dashboard.
This dashboard also provides information on price, weighted across the 13 weeks of the quarter. This is essentially sales value divided by sales volume.
Trade Dashboard provides for a detailed review of the performance of the retail chains and the lower trade. The information provided includes:
The 3 charts at the top sum up the performance of Fujimart, Inulas and the Lower Trade.
The chart at the left pertains to trade contribution. For the category as a whole, the chart in the video tells us that for Q4, 33.5% of the sales of Hygenia are through Fujimart, 28.3% from Inulas and the remainder from the Lower Trade. Fujimart is bigger than Inulas, and it is particularly strong among quality conscious shoppers, as can be seen once you select ‘quality conscious’ from the segments drop down list.
The charts in the middle and right pertain to Price and Promotion, two of the factors that contribute to the trends in trade contribution. The average price of Hygenia products is significantly higher in Inulas, and promotional activity in the chain, is a substantially higher, peaking in Q3 and Q4.
Y1 | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | |
Schisandra - Volume | 115.7 | 24.6 | 29.6 | 31.7 | 29.8 |
Purchase '000 | 121.1 | 21.7 | 29.5 | 37.3 | 32.6 |
Stock '000 | 14.1 | 0.1 | 5.6 | 8.4 | |
OOS Days | 4 | 4 |
Purchase Dashboard provides information across brands on sales volume, purchases, stocks and out of stock days. This information is required by retailers for making purchasing decisions, and it is required by manufacturers for determining how much to produce.
Relationship between Opening Stock, Closing Stock and Purchases
The two column charts at the top left and middle pertain to brand purchases, opening stock, sales and closing stock. With reference to Table 2.4, for the brand Schisandra at Inulas, notice that in Q4, the purchase volume (32.6) + opening stock (5.6) is equal to the sales volume (29.8) + closing stock (8.4) in the next chart. (Sales = Purchases + Opening Stock − Closing Stock. Refer MarketingMind).
Purchasing Decisions
Details provided in the table in this dashboard are required by retailers for making purchasing decisions. Manufacturers too need this information so that they can produce adequate quantities to cater to retailer purchases.
Note that for Q2 (Table 2.4), Inulas purchased 29.5 thousand units of Schisandra and sold 29.6 thousand units. The closing stock of 100 in Q1 is the opening stock for Q2.
The purchased quantity and the opening stock was entirely sold out, leaving no closing stock in Q2. Importantly too, the chain experienced 4 days of stock outs. Since each quarter is a little over 90 days, the chain was out of stock for about 4.4% of the time.
One may conclude that Inulas lost the opportunity to sell more Schisandra because it did not purchase adequate quantities.
The information on sales trend, closing stock and the stock out days suggests that Inulas should be purchasing more units in the next quarter, because the demand in Q2 was higher than what was available for sale. Moreover, to minimize the likelihood of a stock out, the chain should be maintaining adequate stock levels.
Depending on the shoppers’ loyalty to the brand, persistent stock outs could compel shoppers to switch stores. This will impair the retailer’s performance not only for the brand and the category, but also for the other categories stocked by the retailer.
Maintaining too much excess stock is also detrimental. In part because inventory holding cost is 2%. Importantly for perishables, stocks need to be cleared before they expiry.
Stock Cover (Stock Cover Days): Number of days that stock would last, assuming sales continue at the same rate. This measure is used for managing supplies in trade.
Example: If stock is 300 units and sales is 600 units per quarter (91 days), then stock cover days = 300/600 = half a quarter, or about 45 days.
If the opening stock is 300 units (i.e. the stock level at start of quarter) and you are expecting to sell 600 units during the quarter, and you want to maintain 30 days of stocks, i.e. desired closing stock is about one third of quarterly sales or 200 units, then you need to purchase 500 units:
Promotion Dashboard provides information on retailer displays, co-op advertising and price discount (price-off) promotions.
Promo Type | Description | Rating |
---|---|---|
Price-off | 0.5 to 5(-)% | 2 |
5 to 10(-)% | 4 | |
10 to 15(-)% | 6 | |
15 to 20(-)% | 8 | |
20% or more | 10 | |
Display | Small | 2 |
Medium | 4 | |
Large | 6 | |
Feature | Quarter | 3 |
(Co-op ad) | Half | 5 |
Full | 7 |
The weight or magnitude of a promotion, measured in terms of promotions rating points (PRP), is a function of the type of promotion, and its frequency and scale. For example, a small display has a rating of 2 points, a medium display has rating of 4 points and a large display has rating of 6 points. A complete list of promo types and their rating is provided in Table 2.5.
Based on the rating scale, a 12% price-off promotion supported with a large display and a quarter size co-operative feature ad, running for 3 weeks will amass 45 rating points i.e. 3 × (6+6+3).
Brand Image Dashboard provides information on:
The WT column provides the segment importance weights for the Rating, Profile and Ad Emphasis tables. For the Share in Segment table, the values under this column reflect the weighted average image rating for the brand, across each segment.
Advertising Dashboard provides information on advertising spend and brand salience. Measures include:
Product Dashboard provides relevant information for product design and development. Details include product ingredient composition, cost of ingredients, product utility (product quality), utility index, price index, listed (undiscounted) trade price and material cost.
Utility
Utility is a measure of preference for a product, in terms of its performance. If product A’s utility is greater than that for product B, it means that on average consumers prefer A over B. Similarly, the extent to which a product’s formulation has improved can be measured in term the increase in its utility.
The relationship between composition of ingredients and their utility or part-worth is derived from conjoint analysis, a technique for designing and developing products. For the food and personal care categories in Destiny, the relationship is quadratic or ideal point. As ingredient composition is increased the part-worth rises up to an optimum level. Further increase in composition is not advisable as it will result in loss of utility.
Besides the optimum level, product developers need to know the importance of the ingredients in terms of their contribution to the product’s utility. Nectar, for instance, contributes more than any other ingredient to the utility of ambrosia products.
The optimum level (opt) and relative importance (imp) of ingredients is shown at the right of the ingredients table in the product dashboard. The utility curve, i.e. the mathematical relationship between the ingredient composition and part-worth is depicted in the ingredient workbook under the resources tab.
Product development typically requires trade-offs between quality and material costs. Use the utility function and the data on cost of ingredients to achieve the desired improvement in product quality at minimum cost.
Utility Index and Price Index
An Index is a normalized average. If the product’s utility is equal to the weighted average utility of products in the market, it will have an index of 100. Similarly, if a product’s price index is 100, that means the product’s price is exactly the same as the weighted average price of products in the category. If the product’s price index is greater than 100, it means on weighted average its price is higher than that for competing products.
A product’s price index may be computed as follows:
Because it is a weighted ratio, the utility index (or price index) can change, even if there is no change in the product’s composition (or its price). Indices are also be affected when the proportion of sales across brands (i.e., market share) changes.
Price Performance Gap
Product quality and price, are among the key factors that determine brand choice.
Comparison between a product’s utility index and price index provides an understanding of the price performance gap. If the utility index is greater than the price index, the product offers relatively good value for money.
Configured for diagnosing the health of a brand, the brand dashboard provides information on the metrics driving brand sales and profitability:
Commercial Dashboard is configured to impart an understanding of the ingredient cost and gross margin of the products. It also provides information on the production capacities.
Measures include:
Note that for trade price and ingredient cost, the relevant tables also provide information on the current decision time periods, i.e. the next two quarters.
Prices at Different Stages of the Supply Chain
As with any commercial setting, prices at different stages of the supply chain will impact your company’s performance in Destiny. These include:
The Dashboards provide broad based information pertaining to the markets, including metrics on the market size and share, trade dynamics, advertising, brand image, product development and commercial. Updated after each decision cycle, they are designed to address the diverse information needs of retailers and manufacturers.
The metrics:
Historical data pertaining to Year 1 for the above measures is also provided in the Appendix.
Y1 | Y2 | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 | Y2 Q3 | Y2 Q4 | |
Market Share (%Volume) | – | |||||||||
Ambrosia | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
M1-Ambrosia | 54.8 | 54.3 | 53.1 | 54.1 | 55.6 | 56.6 | 57.8 | 55.2 | 53.4 | 51.2 |
M2-Ambrosia | 15.1 | 12.0 | 17.1 | 16.0 | 14.0 | 13.2 | 12.5 | 12.1 | 9.9 | 13.3 |
M3-Ambrosia | 20.7 | 17.6 | 22.2 | 20.3 | 20.8 | 19.5 | 16.6 | 16.8 | 19.6 | 17.3 |
Nagara Drink | 5.6 | 3.6 | 6.3 | 5.4 | 5.8 | 4.8 | 4.1 | 3.7 | 3.5 | 3.2 |
Athena Drink | 49.3 | 50.7 | 46.8 | 48.6 | 49.8 | 51.8 | 53.7 | 51.4 | 49.8 | 48.0 |
Ginko Drink | 9.3 | 6.7 | 10.0 | 9.7 | 9.0 | 8.7 | 8.1 | 7.4 | 5.8 | 5.5 |
Haw | 2.5 | 1.7 | 3.0 | 3.0 | 2.2 | 1.8 | 1.9 | 1.7 | 1.7 | 1.4 |
Kew | 3.2 | 2.6 | 4.0 | 3.3 | 2.7 | 2.7 | 2.5 | 3.1 | 2.4 | 2.2 |
Jasmine | 1.1 | 4.2 | ||||||||
Mahonia Drink | 11.6 | 8.2 | 12.1 | 10.8 | 11.9 | 11.4 | 8.9 | 9.2 | 7.9 | 7.0 |
Aloe Indica | 9.1 | 7.3 | 10.1 | 9.5 | 8.9 | 8.1 | 7.7 | 7.6 | 7.3 | 6.5 |
Tritoma | 2.1 | 4.4 | 3.8 | |||||||
Fuji Drink | 4.2 | 6.5 | 3.8 | 4.4 | 4.1 | 4.6 | 5.3 | 6.3 | 6.9 | 7.6 |
Inula Drink | 5.2 | 9.6 | 3.8 | 5.2 | 5.5 | 6.1 | 7.8 | 9.6 | 10.3 | 10.7 |
Volume '000 | + | |||||||||
Ambrosia | 4,677 | 4,930 | 1,165 | 1,161 | 1,172 | 1,179 | 1,205 | 1,219 | 1,242 | 1,263 |
M1-Ambrosia | 2,564 | 2,679 | 619 | 628 | 651 | 667 | 697 | 673 | 663 | 647 |
M2-Ambrosia | 704 | 590 | 199 | 185 | 164 | 156 | 151 | 148 | 123 | 168 |
M3-Ambrosia | 969 | 866 | 259 | 236 | 244 | 230 | 200 | 205 | 243 | 218 |
Nagara Drink | 260 | 179 | 73 | 63 | 67 | 56 | 49 | 46 | 44 | 40 |
Athena Drink | 2,305 | 2,500 | 546 | 565 | 583 | 611 | 648 | 627 | 619 | 607 |
Ginko Drink | 437 | 329 | 117 | 112 | 106 | 103 | 98 | 90 | 72 | 69 |
Haw | 118 | 82 | 36 | 35 | 26 | 21 | 23 | 21 | 21 | 18 |
Kew | 149 | 126 | 47 | 38 | 32 | 32 | 31 | 38 | 30 | 28 |
Jasmine | 53 | 53 | ||||||||
Mahonia Drink | 541 | 405 | 141 | 126 | 140 | 134 | 107 | 112 | 98 | 88 |
Aloe Indica | 428 | 358 | 117 | 110 | 104 | 96 | 93 | 93 | 91 | 82 |
Tritoma | 102 | 54 | 48 | |||||||
Fuji Drink | 199 | 321 | 45 | 51 | 48 | 54 | 63 | 76 | 86 | 96 |
Inula Drink | 241 | 475 | 44 | 61 | 64 | 72 | 94 | 117 | 128 | 135 |
Price ($/kg) | + | |||||||||
Ambrosia | 21.95 | 22.45 | 21.67 | 21.98 | 22.03 | 22.11 | 22.54 | 22.15 | 22.58 | 22.51 |
M1-Ambrosia | 25.21 | 26.33 | 25.02 | 25.20 | 25.12 | 25.48 | 26.09 | 26.26 | 26.55 | 26.44 |
M2-Ambrosia | 23.10 | 23.26 | 22.50 | 23.03 | 23.53 | 23.51 | 23.91 | 23.37 | 23.60 | 22.34 |
M3-Ambrosia | 16.23 | 18.02 | 15.77 | 16.52 | 16.62 | 16.03 | 16.66 | 16.32 | 19.02 | 19.73 |
Nagara Drink | 13.95 | 14.97 | 13.87 | 14.05 | 14.06 | 13.82 | 14.80 | 14.55 | 15.06 | 15.55 |
Athena Drink | 26.47 | 27.14 | 26.51 | 26.44 | 26.39 | 26.55 | 26.94 | 27.11 | 27.37 | 27.15 |
Ginko Drink | 27.62 | 28.34 | 27.68 | 27.59 | 27.51 | 27.69 | 27.94 | 28.19 | 28.75 | 28.70 |
Haw | 14.23 | 14.74 | 14.17 | 14.23 | 14.21 | 14.34 | 14.37 | 14.36 | 15.03 | 15.33 |
Kew | 16.88 | 17.43 | 15.90 | 17.72 | 18.01 | 16.17 | 18.13 | 16.76 | 17.25 | 17.76 |
Jasmine | 18.83 | 18.83 | ||||||||
Mahonia Drink | 17.05 | 17.60 | 16.27 | 17.70 | 17.65 | 16.65 | 17.84 | 17.02 | 17.48 | 18.16 |
Aloe Indica | 15.19 | 16.00 | 15.16 | 15.18 | 15.25 | 15.15 | 15.31 | 15.46 | 16.21 | 17.15 |
Tritoma | 26.75 | 26.50 | 27.04 | |||||||
Fuji Drink | 13.86 | 14.27 | 13.81 | 13.82 | 13.91 | 13.91 | 13.61 | 13.86 | 14.43 | 14.91 |
Inula Drink | 13.63 | 13.13 | 13.62 | 13.61 | 13.63 | 13.64 | 12.59 | 12.63 | 13.28 | 13.81 |
Share in Segment (%Vol) | + | |||||||||
All | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Price | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Health | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Functional | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Connoisseur | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Share in Trade (%Vol) | + | |||||||||
Total Trade | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Fujimart | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Inulas | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Upper Trade | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Lower Trade | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Price in Trade ($/kg) | + | |||||||||
Total Trade | 21.95 | 22.45 | 21.67 | 21.98 | 22.03 | 22.11 | 22.54 | 22.15 | 22.58 | 22.51 |
Fujimart | 20.46 | 21.72 | 19.94 | 20.31 | 20.74 | 20.75 | 21.38 | 21.74 | 22.03 | 21.75 |
Inulas | 20.45 | 20.86 | 20.52 | 20.60 | 20.26 | 20.43 | 21.23 | 20.32 | 20.97 | 20.93 |
Upper Trade | 20.45 | 21.27 | 20.22 | 20.45 | 20.52 | 20.60 | 21.31 | 21.01 | 21.45 | 21.32 |
Lower Trade | 24.13 | 25.01 | 23.39 | 24.28 | 24.41 | 24.60 | 24.94 | 24.64 | 25.12 | 25.35 |
Segment Contribution (%Vol) | + | |||||||||
All | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Price | 19.1 | 19.0 | 19.1 | 19.1 | 19.2 | 19.1 | 19.1 | 19.0 | 19.0 | 19.0 |
Health | 24.7 | 24.7 | 24.7 | 24.6 | 24.7 | 24.7 | 24.7 | 24.7 | 24.6 | 24.8 |
Functional | 27.4 | 27.4 | 27.4 | 27.4 | 27.3 | 27.3 | 27.4 | 27.5 | 27.4 | 27.4 |
Connoisseur | 28.8 | 28.9 | 28.8 | 28.8 | 28.8 | 28.9 | 28.9 | 28.9 | 29.0 | 28.8 |
Trade Contribution (%Vol) | + | |||||||||
Total Trade | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 |
Fujimart | 31.5 | 32.8 | 28.4 | 32.1 | 32.9 | 32.5 | 33.7 | 33.2 | 31.5 | 32.8 |
Inulas | 27.9 | 35.7 | 25.7 | 27.9 | 28.2 | 29.7 | 32.4 | 35.2 | 37.6 | 37.5 |
Upper Trade | 59.3 | 68.5 | 54.1 | 59.9 | 61.1 | 62.2 | 66.1 | 68.4 | 69.1 | 70.3 |
Lower Trade | 40.7 | 31.5 | 45.9 | 40.1 | 38.9 | 37.8 | 33.9 | 31.6 | 30.9 | 29.7 |