1
INCREASING THE COMPETITIVENESS OF MEXX B.V. AT SIZE ALLOCATION Size level availability - the Achilles heel of apparel retailing
Master thesis, MscBA, specialization Operations and Supply Chains University of Groningen, Faculty of Operations
Submission date:
27-08-2012
Judit Osika
Student number: s2021668 Aquamarijnstraat 221.
9743 PE Groningen tel.: +31 681459822 e-mail: j.osika@student.rug.nl
Supervisors/ university Dr. T. Bodea
Dr. X. Zhu Supervisor/ field of study
L. Kay
Mexx B.V., Amsterdam
2 Abstract
Matching supply and demand has never been an easy task, especially not in the retail industry. The life cycles of fashion products is shortening while the variety of products offered are increasing and customers are becoming more and more demanding. Before products can be found at any store, an extensive planning process, the merchandise planning takes place. It has to be decided when, where and how much of the products to supply so that the right products are available at the right sizes, colors etc.
When products are not available i.e. they are out of stock (OOS) when demand occurs for them, retailers do not only lose sales and margins but they may also face dissatisfied customers and lose market share in the long term.
In general, forecasting demand is based on extrapolating historic sales data. However, this may result in biased forecasts: sales data only represent partial demand and not the demand which was not satisfied due to the unavailability or stockouts. Therefore sales data is considered to be constrained when the sales are limited by an OOS event.
A sample of 12 styles of merchandise was taken to observe the OOS phenomenon and its associated costs at Mexx B.V. It was found that OOS ratio on average is already at the 4th week after a product was introduced is 27% and increases up to 64% by the 16th week. This could imply that unconstraining methods could foster a better matching of demand on the size level and enable the retailer to have more precise information about demand surrounding a store.
Keywords: merchandise (demand) planning, out-of-stock rates, unconstraining sales data
3 Table of contents
1. Introduction ...4
1.1. Topic area ...4
1.2. Problem statement and research question ...6
2. Literature review ...7
2.1. Revenue management ...7
2.2. Unconstraining methods ...7
2.3. Stock-out in the apparel retail industry ...8
3. Methodology...9
4. MEXX B.V. ...11
4.1. The merchandise hierarchy ...11
4.2. The merchandize planning process ...12
4.2.1. The corporate strategy and the financial planning ...12
4.2.2. Product and Store Planning ...13
4.2.3. Range planning ...14
4.2.4. Assortment planning ...14
4.2.5.Allocation & Replenishment ...14
4.2.7. Size profiles ...15
5. RESULTS ...16
5.2. Out-of- stock rates ...16
5.2 Availability of all sizes on the store levels ...18
5.3. OOS on the store- style- size level ...19
5.4. Quantifying the size level OOS costs ...21
6. DISCUSSION AND CONCLUSION ...24
7. REFERENCES ...26
8. APPENDICES ... Error! Bookmark not defined.
4 1. Introduction
1.1. Topic area
Matching supply and demand has never been an easy task, especially not in the retail industry. Making the right products and services available at the right time, at the right place and in the right quantity is a common manifesto for the industry (Kumar and Banga, 2007). To fulfill this goal, retailers have to manage a series of challenging tasks such as predicting the desires of customers, buying and allocating the right set of merchandise to their stores, setting prices and effective promotions (Kumar and Banga, 2007). These tasks are even more challenging in these present days as product life cycles tend to be shortening while the variety of products offered are increasing, and customers are becoming more and more demanding (Fernie and Corcoran, 2011). As a result the retail supply chain is characterized by inefficiencies such as high inventories, stockouts, steep markdowns, poor assortment, inconsistent pricing and ineffective promotions which result in a negative effect on retailer’s profits (Vinod, 2005).
Although improved distribution systems and technologies are of great help in this challenging business environment, retailers still have a hard time to match supply with demand (Friend and Walker, 2001). Sales are often limited by the supply of goods and services. It has been estimated that 8% of items that customers intend to buy are out of stock, and that one-third of goods are sold at markdowned prices (Friend and Walker, 2001). Both occasions harm the revenues of retailers. If retailers are not able to make the products available when demand occurs for them, they do not only lose sales and margins but they may also face dissatisfied customers and lose market share in the long term (Zinn and Liu, 2001). In the grocery industry it has been estimated that when customers are faced with a stockout for the first time, 31% of the customers leave the store without purchasing.
When it happens for the third time, the percentage of leaving customers without buying anything is as high as 69% (ECR Europe 2003). Retailers are able to satisfy customers when supply matches or exceeds demand. With excess supply however, customer retention is high but retailers are confronted with the costs of holding inventory. They need to use markdown sales to clear their excess inventory which means that they also lose profits as they have to sell their products at a lower price than initially intended. It has been shown that department store markdowns increased from 8% to 37% between 1971 and 1997, and that this trend continues to increase. Fisher et al. (1994) indicated that in highly volatile markets such as the fashion retail industry, the costs of markdowns and stockouts could actually exceed the total cost of manufacturing. Therefore managing the trade-off between the costs of excess inventory and the costs of insufficient inventory has a very important effect on the long-term profitability of retailers.
Developing and implementing a merchandising plan is crucial to overcome the above-mentioned difficulties and to achieve improved margins, inventory turns, comparable store sales and earnings (Friend and Walker, 2001).
Due to outsourced production, lead times in the fashion retail industry can take up to six months. Consequently, there is only a limited possibility for reordering and as fashion items become quickly obsolete, the merchandise have to be sold within couple of weeks or months ((Levy and Weitz, 2008). This means that retailers have maximum 2 or 3 months to generate profit on a product as later it will be not fashionable anymore and it will not sell and generate profit. The merchandise planning process aims to define when, where and how much of the merchandise to sell so that revenue targets are supported. Decisions about merchandising planning, buying, allocation, replenishment, pricing and promotion are all primarily based on historic sales data (Friend and Walker, 2001).
As the product variety offered by the retailers increases year by year, the stock keeping units (SKUs) increase as
well. A stock keeping unit is the lowest level of the merchandize hierarchy and it represents a certain style (i.e. a
variant), color and size variation. For example if two styles of blouses are available (one style is with long
5 sleeves and the other with short sleeve) in two colors (red and white) and five sizes (XS,S,M,L,XL), they represent altogether 20 SKUs. To facilitate the overview of the styles (and corresponding SKUs), retailers use the tool of merchandise hierarchy. The merchandise hierarchy is a kind of taxonomy of the products offered and it is specific to every company. At Mexx B.V. the highest level of the hierarchy is the product group. A product group depends on their target market of the retailers. For example at Mexx B.V. there are the product groups of women, men, youth, accessories and footwear. A product group can be further broken down into classes. A class is a unit in the merchandise hierarchy in which merchandise is carried that a customer may view complementary (Hart and Rafiq, 2006). Mexx B.V. offers generally 10 classes such as blouses, blazers, t-shirts, skirt etc. Within every class there are the styles. The styles are different from each other in material, tailoring and patterns.
Depending on how many colors they are available they are further broken down into a style/color level which is again broken down into a style/color/size level, the SKUs. The merchandise hierarchy does not only to give an overview of the products offered but it is also reflected in the organizational structure. Another complex decision is where, at which locations to offer the products. To continue with the previous example that a retailer wants to allocate 20 SKUs (2styles*2colors*5 sizes) to its 100 stores, it would mean that 2000 decisions have to be made about how much and where to allocate. Therefore to facilitate the planning process, stores of similar sizes are classified together into so-called clusters. With the help of the clustering it can be decided easier which cluster receives which styles. Usually the higher clusters (the bigger stores) receive more styles of class than smaller stores.
In general, forecasting demand is based on extrapolating historic sales data. However, this may result in biased forecasts: sales data only represent partial demand and not the demand which was not satisfied due to the unavailability or stockouts. After products are sold out, demand cannot be observed as “attempted sales” is difficult to record (Talluri and van Ryzin, 2004). Historic sales data embodies only observed demand hence often termed as constrained or truncated demand. Talluri and van Ryzin (2004) illustrate the effect of forecasting based on historic sales data with the example of a product which has been consistently closed (i.e. not open to sale) in the past. Its observed demand would be zero, and a forecast based on this data would forecast demand as zero. Leaving sales data constrained or truncated can result in a negative spiral-down effect on revenue management (Cooper, Homem-de-Mello and Kleywegt, 2006).
Unconstraining stands for the application of statistical methods in order to correct for the incomplete sales data and estimate how much could have been sold if the right quantity of products had been available (Friend and Walker (2001). Thus, observed demand has to be combined with the estimated latent demand (Zhu, 2005).
Although there is no universal solution to unconstrain sales data, Weatherford and Pölt (2002) argue that switching to a better method can increase revenues with 0.5-1 % in the airline industry.
Besides using historic sales data, another weak point of apparel retailers may be that assortment planning relies on aggregate measures such as the clustering of stores mentioned before (Grewal et al, 1999). Mantrala et al.
(2009) suggests that retailers should plan their assortments at individual store levels rather than at a national level. The reason for this is to better match the local taste of customers (Mantrala et al., 2009). Friend and Walker (2001) also express that the most challenging task for retailers is allocating the right mix of merchandise to the stores. They focus on the size level availability and they point out that every store faces different demand with respect to sizes, therefore setting a single size profile for the entre supply chain is ineffective. Moreover if size level out-of-stocks (OOSs) remain unconstrained on the store level, the true size profiles are not revealed and a biased size profile is used. They further propose that each store should have their specific size profiles;
however retailers usually do not consider the allocation at this level because of the associated costs.
The proposition of Friend and Walker (2001) is also underpinned by the emergence of the increasing number of
merchandise optimization software packages such as those provided by JDA, Retek and SAP that model
6 demand at the level of individual stores and individual stock-keeping units (SKUs). With the use of these software packages some retailers reached a 20% gain in productivity (Friend and Walker, 2001). However research on unconstraining methods in the retail industry has not received the same attention as in the airline or hotel industry. This thesis is organized as follows. In the next section the problem and the research question are stated along with the relevance of the study. In chapter 2, the relevant literature is discussed. Chapter 3 introduces the methodology and chapter 4 includes the description of the case study and the analysis. In chapter 5 the results and findings are discussed. Chapter 6 discusses the conclusion of the thesis and chapter 7 discusses further implications and further research areas.
1.2. Problem statement and research question
The aim of this research is to investigate the size level out-of-stock phenomenon in the apparel retail industry and to investigate the feasibility of unconstraining size level sales data. As discussed in the introduction using constrained sales data for planning purposes can harm both the current and future revenues of the retailer.
Therefore quantifying the lost sales does not only mean that the current but also the future revenues of retailers are constrained. Revealing size level OOS rates for individual stores could help in creating size profiles for stores which better match customer demand. Better matching customer demand in turn increases revenues and customer satisfactions levels.
The research questions are: what are the size level OOS rates within the locations and what costs they are associated with?
Before answering the research question the current practice of Mexx B.V. is discussed with regards to the
merchandise planning decisions.
7 2. Literature review
The aim of the literature review to introduce the “science” of revenue management. Besides that another goal is to show where the method of uncontraining is currently staying. It is also the intention of the literature review to demonstrate what revenue management practices have been used so far in the apparel retailing. And finally to show what studies have been made in the retail industry on lost sales ideas.
2.1. Revenue management
Talluri and van Ryzing (2004) and Phillips (2005) provide a thorough introduction to the field of revenue management. Talluri and van Ryzin (2004) refer to revenue management as the complement of supply chain management. Supply chain management addresses the supply side decisions along with the processes of the firm with the objective of lowering costs while revenue management deals with the firm’s connection to the market with the goal of increasing revenues. Thus revenue management concerns decisions about demand management and it is an interdisciplinary science, rooted in operations research methods and management science practices.
In their book they identify three areas of revenue management: structural decisions, price decisions and quantity decisions. The relevance and the timescale of these three areas are dependent on the business environment the firm operates in. Structural decisions concern strategic decisions about the selling of products. Pricing and quantity decisions are about setting prices or deploying capacities in advance. Depending on the choice, the ability to adjust the price or the quantities on the tactical level is limited.
For example retailers usually commit to quantities, in the form of initial stocking decisions. Therefore they have more flexibility to adjust prices over time. However if they decide to keep a certain amount of stock at the warehouse and make a replenishment decision rather than committing all their stock in advance is a mixture of price and quantity based revenue management. The decision is dependent on the ability of the firm to react to the market changes by altering prices or quantities. In apparel retailing generally companies commit to order quantitates well in advance of the selling season, in some cases even to certain stocking levels in each store.
Often it is very costly or impossible to reorder stock or reallocate inventory from one store to another. At the same time, it is easier for most retailers to change prices as this may only require changing signage and making data entries into a point of sale system. For online retailers, changing signage of prices is almost costless therefore they benefit from price-flexibility.
Furthermore, they discuss the common elements of price- and quantity- based revenue management, such as forecasting. For retailers forecasting usually concentrates on forecasting demand as a function of price and promotion. Forecasting often faces the problem that data are partially observable or missing. Incomplete data occurs when sales and no-sales are not directly observable. This makes it difficult to obtain information on customer purchase behavior. As mentioned before revenue management is rooted in the airline reservation context, hence most of the unconstraining methods are applied in that industry.
2.2. Unconstraining methods
Before any successful revenue management optimization could take place, accurate demand information is necessary to be available (Lan et al., 2008).
Unconstraining sales data to obtain more precise demand information can have significant effects on revenue management, however the research on this method is scarce compared to setting and adjusting booking limits (Queenan et al., 2007). Unconstraining sales data is relevant to capacity or resource constrained companies.
There are two ways to approach data unconstraining: direct observation of unmet demand or the use of statistical
methods. Observing unsatisfied demand means recording latent demand which occurs when the resource or the
capacity constraint is reached. Direct observation of latent demand in some industries is simply not possible
because of the used distribution channels (Queenan et al., 2007). In other industries such as the hotel industry,
observation of unmet demand is recorded in the form of request turndowns. However not all the information on
8 turndowns represent latent demand as requests can be also rejected because of the price considerations of customers. Obtaining quality demand data from turndowns is becoming even more difficult with the appearance of booking sites which do not record turndowns. Therefore there is an increasing need for robust statistical methods to unconstrain data (Queenan et al., 2007). Unconstraining methods pursue a common methodology:
demand over time is classified as being constrained or unconstrained.
The most widely used unconstraining method is the expectation-maximization (EM) method was introduced in 1977 by the study of Dempster, Laird and Rubin. Although studies on unconstraining airline demand data began in the mid-1990s (such as Skwarek, 1996 and Shaleh, 1997) under the aegis of AGIFORMS, the application of the EM method was first considered in the airline context by Pölt (2000) and Weatherford (2000). In their subsequent study, Weatherford and Pölt (2002) compare six unconstraining methods to see which one of them is the most robust in the contex of airline reservation systems. They test three naïve averaging methods, the booking profile method, the projection detruncation method and the EM method. Using simulation, they created scenarios where the fractions of total constrained observations vary between 0 and 98 %. A 0 % censoring means that data represent the true demand as the booking limit is not reached; whereas a 98% truncation means that 98% of the data represent demand constrained by the booking limit. The authors find that the first three methods provide better results when there are lower levels of censoring; but as censoring levels increase, methods based on projection de-truncation and expectation maximization are superior. They suggest that using expectation maximization algorithm, 2-12 per cent of improvement in revenue management can be achieved. Although the expectation maximization method is cited as the most accurate method (Ratliff et al., 2007), it also has its limitation as being time and computation-intensive.
Talluri and van Ryzin (2004) describe five methods to unconstrain data: the EM method, Gibbs sampling, Kaplan-Mier Product Limit Estimator, plotting procedures and the projection detruncation method. Queenan et al. (2007) propose the use of double exponential smoothing (DES) to forecast the constrained values of a data set. They compared this method to one averaging method, the EM, the PD method and the so called life table (LT) method which was used previously in medical and reliability engineering experiments. Ratliff et al. (2008) provide an extensive overview of single class, multi class and multi-flight methods in the airline context. The most recently published study about demand unconstraining is the article by Vulcano, van Ryzin and Ratliff (2012). They propose a method for estimating substitute and lost demand when only sales and product availability is observable.
2.3. Stock-out in the apparel retail industry
Although out-of-stock events have received attention in the retail environment, the majority of the studies focus solely on grocery retailers (Grant and Fernie, 2008). The first study which directly aimed at quantifying the cost of OOS events in the fashion industry was done at the House of Fraser by Carey and Staniforth (2007). Their exit survey has shown that 36% of customers who visited the House of Fraser store and planned to purchase did not, mainly because of the non-availability of size and color (Carey and Staniforth, 2007). They estimated that if only half of those customers have bought what they planned to buy, sales could have increased by £63 million.
Fisher and Rajaram (2000) discuss the retail testing method to improve forecasts of fashion merchandise. Retail testing means that new products are introduced at a sample of stores prior to the selling season and from their observed sales, demand for the entire chain is forecasted. They also investigate the clustering of the stores to identify the similar common factors that explain similar sales patterns and they find that store size and location have little impact on sales patterns.
Most of the research in the apparel industry focuses on identifying the causes of OOSs (such as the study Fernie
and Corcoran, 2011) or focuses on understanding the behavior of customers responses to OOSs (such as the
study of Carey and Staniforth, 2007). Unconstraining sales data in the apparel industry received much less
attention from researchers in the past years. It is difficult to tell why it is the norm in the airline and hotel
9 industry and not in the apparel industry. A possible explanation could be that to unconstrain sales data the lowest levels of aggregation has to be considered while retailers tend to use aggregate levels of sales data. With thousands of SKUs and hundreds of locations, the reason why retailers stayed away from unconstraining methods so far could be the associated costs and time (Friend and Walker, 2001).
3. Methodology
This research is conducted within a case study at Mexx B.V. Amsterdam. Interviews are conducted with the manager and the members of the merchandise planning department to get a clear overview of the process flow of planning. The overall retail strategy, merchandise planning, buying, allocation and pricing are described with respect to sizing. Next to the general description of these processes, feedback loops between the processes are also described (if they exist). The most crucial point of the descriptive part is to point out if size level sales data is unconstrained and whether or not it is fed back into the planning processes.
In the second part, the thesis aims to provide actual proof that unconstraining methods are necessary to use. For this, size level sales and inventory data will be analyzed across several stores. The time period chosen for the analysis is the season of fall/ winter of 2011. This season covers the months from June until November.
The study is targeted at the retail stores as the author’s internship takes place at the department where the planning and allocation decisions are handled for them. These retail stores sell a variety of clothing within the product groups of women, men, youth, accessories and footwear. Depending on which product groups the stores offer, retail stores can be classified into family stores (where all the five product groups are available), lifestyle stores (where woman and men product groups are available) and women stores.
Within the retail stores, the family stores are predominant (32 out of 75). The other two store formats, lifestyle and woman stores are not taken into account in the analysis. The overview of the family stores can be found in the appendix. As mentioned in the introduction, to facilitate decision making, based on their size stores are grouped into clusters. The lower the number a cluster is ranked, the bigger the stores it comprises. For example cluster 1 contains the biggest stores while cluster 7 contains the smallest store.
By the end of the season, out of the 32 stores, 4 were closed down. From the 28 stores, 6 were located in the Netherlands. Because of the limitations of the study, only 5 of the stores (Maastricht, Den Haag, Eindhoven, Rotterdam and Breda) were chosen for further analysis, excluding the smallest store, Almere. Maastricht and Den Haag are chosen from the first cluster, Eindhoven and Rotterdam from the second, and Breda from the fourth.
After the choosing the locations, the styles and colors of merchandise had to be selected. For this research the interesting items are the style color variations that are sold in high quantities and/or at a high value. These items can hurt significantly the revenues of the company if they are not available at the right time, right places and the right quantity. The best seller reports of the merchandise planning department were reviewed and 12 styles were chosen. The 12 styles belong to the categories of blazers, blouses, dresses, pants, skirts and outerwear. The description of the styles is found in the Appendix.
In order to analyze the demand, the supply and the size level OOS rates, a rolling time window of 16 weeks was
chosen. For the 16 week period, the weekly sales data, on-hand inventory, returns, original and markdown
prices and initial base stock levels were collected across all the style/colors/size levels. The 12 styles (on average
with 6 sizes) represent 72 SKUs. When the weekly OOS were calculated, it was counted with the help of an
excel function how many of the 72 SKUs were not available in a given week. It was not possible to reveal the
inventory receipts from the database used by MEXX B.V. Therefore where needed it was calculated by
subtracting the difference between the on-hand inventory of the previous week and sales units of the current
week from on-hand inventory of the current week. In some cases, the receipts occurred as certain SKUs were
returned to the store. In the other cases when it was calculated, it is not known whether it was replenishment
from the warehouse or it was transferred from another store.
10 At MEXX B.V. the current practice is that styles are not markdowned until the 8th week after the styles were introduced in the stores. Therefore the time unit chosen is 16 weeks so that 8 weeks of the full price performance and 8 weeks of the markdowned selling performance can be observed.
In the end, with the help of the descriptive part, the results of the analysis are interpreted. The last chapter of the
results section is about quantifying the size level OOS rates. There some assumptions were made about how
much could have been sold without using unconstraining methods.
11 4. MEXX B.V.
4.1. The merchandise hierarchy
The MEXX approach to retailing is very diverse. Their products are sold in 115 company-owned stores, 168 concession and franchise stores, premium department stores, and 700 shop-in-shops, as well as through mail order catalogs and the e-shop. In all, the company has close to 9000 selling points worldwide.
Figure 1 The merchadise hierarchy of MEXX B.V.
The merchandise hierarchy is depicted in Figure 1. The five product groups (woman, man, youth, accessories and footwear) are divided into departments. For instance, women apparel is divided into the departments of casual and metropolitan collections. This distinction is very recent as it is only used from July 2012 on. Before, there was one single department within the woman merchandise group. The distinction was made to separate casual and metropolitan merchandise in order to simplify the planning process and create a better overview of the processes. The difference between casual and metropolitan collections is that the focus of metropolitan collections is on offering more urban and business style merchandise.
The next level in the hierarchy is the level of classes. Generally for both casual and metropolitan women’s department there are ten classes (such as blazers, blouses, pants etc.).
Within each class there are several styles. Each style is identified by an 8 digit code (e.g. N1ME3042). A style represents at least one and at most five-six color variants; this next level is referred to as style-color level. There are three-digit codes used to describe the colors of styles. Therefore when referring to a style/color variation, the code is 11 digit. This 11 digit code can be found on the price tag of clothes. Finally the lowest level is the style/color/size level. Classes have a different size range. For example skirts are available in sizes from 34 until 42, while pants are ranged from size 32 until 42.
Apart from the merchandise hierarchy, it is also important to denote the difference between fashion and staple products. The reason for this is that demand for certain products are stable whereas for others demand is very seasonal and dependent on current fashion trends. The former classification is often referred to as staple merchandise or basic merchandise and the latter is as fashion merchandise (Levy and Weitz, 2008). Staple merchandise is purchased in larger batches and sold during the complete season, and fashion merchandise is trendier, produced in smaller batches. For instance a basic white T-shirt is considered as staple merchandise while T-shirts in seasonal colors with special prints as fashion merchandise.
Merchandise group
WOMEN
Department CASUAL METROPOLITAN
Class BLAZERS BLOUSES DRESSES PANTS …. OUTERWEAR
Style N1ME3042 N1ME3522 …
Color MIDHNIGHT BLUE WHITE/NATURAL …
Size range XS-XL 34-44