Chapter 11 – Managing the Merchandise Planning Process
11–18
• Research indicates that these allocation decisions
have a much bigger impact on profitability than does
of the challenges of allocating
merchandise to stores. What
might influence the decision of
A. Amount of Merchandise Allocated
* Retail chains typically classify each of their stores on the
basis of annual sales. Thus, A stores would have the largest
sales volume and typically receive the most inventory,
• B. Type of Merchandise Allocated In addition to classifying
stores on the basis of their size and sales volume, retailers
See PPT 11–40 for illustrations
C. Timing of Merchandise Allocation
• Differences in the timing of category purchases across
stores also needs to be considered.
See PPT 11–41
Chapter 11 – Managing the Merchandise Planning Process
11–19
VIII. Analyzing Merchandise Management Performance
• The next step in the merchandise management process is
to analyze the performance of the process and make
adjustments as necessary.
LO 11-8 Review how retailers
evaluate the performance of
their merchandise
management decisions.
A. Evaluating the Merchandise Plan Using Sell-Through Analysis:
• A sell-through analysis is a comparison between actual and
planned sales to determine whether price reuctions
(markdowns) are required or whether more merchandise is
See PPT 11–43
Ask students what action
B. Evaluating the Assortment Plan Using ABC Analysis
• ABC analysis identifies the performance of individual SKUs
in the assortment plan.
See PPT 11–44
Ask students to think of other
Chapter 11 – Managing the Merchandise Planning Process
11–20
come from 20 percent of the products.
• The first step in the ABC analysis is to rank-order SKUs
using one or more performance measures.
• A items account for 5 percent of items and represent 70
percent of sales. These items should never be out of stock.
• B items represent 10 percent of the SKUs and an additional
20 percent of sales. The store should pay close attention
to the B items, but it may run out of some SKUs in the B
category, since it’s not carrying the same amount of
backup stock as for A items.
1. Evaluating Vendors Using the Multiattribute Method
• The multiattribute analysis method for evaluating vendors
uses a weighted-average score for each vendor.
• A buyer can evaluate vendors by using five steps.
1. Develop a list of issues to consider in the decision. A
See PPT 11–45
Students may find this a little
too “academic.” To make it a
Chapter 11 – Managing the Merchandise Planning Process
11–21
IX. Summary
• This chapter provides an overview of the merchandise
management planning process and examines sales
forecasting and assortment planning in more detail.
Appendix 11A: Merchandise Budget Report and Open-to-Buy
System for a Fashion Merchandise Category
I. Merchandise Budget Plan
A. Monthly Sales Percent Distribution To Season (Line 1)
• Line 1 of the plan projects what percentage of the
total sales is expected to be sold in each month.
Also called a seasonality index.
Most merchandise has some
seasonality. Even toilet paper –
– fancy styles sell better during
Chapter 11 – Managing the Merchandise Planning Process
11–22
month.
See PPT 11A-4
B. Monthly Sales (Line 2)
• Monthly sales are the forecasted total sales for the
See PPT 11A-5
C. Monthly Reductions Percent Distribution to Season (Line 3)
• To have enough merchandise every month to support
the monthly sales forecast, the buyer must consider
factors that reduce the inventory level. Apart from
• Shrinkage is caused by shoplifting by employees or
customers, by merchandise being misplaced or
damaged, or by poor bookkeeping. The buyer
Reductions are often difficult
for students to understand.
Tell them that they work in the
reductions. If they don’t,
consider reductions, they will
run out of stock by the amount
D. Monthly Reductions (Line 4)
• Monthly reductions are calculated the same way
monthly sales are calculated. Total reductions are
multiplied by each percentage in line 3.
See PPT 11A-7
Chapter 11 – Managing the Merchandise Planning Process
11–23
E. BOM (Beginning-of-Month) Stock-to–Sales Ratio (Line 5)
• The stock-to-sales ratio specifies the amount of
• Step 1: Calculate stock-to-sales ratio
• Step 2: Convert the sales-to-stock ration to inventory
turnover
Like % distribution of sales by
month, monthly stock-to-sales
ratios fluctuate by month, but
until May, so in May, stock and
sales are both increasing, but
sales are increasing faster, so
stock-to-sales ratio decreases.
But in July, stores still have
See PPT 11A-8
F. BOM Stock (Line 6)
• The amount of inventory planned for the beginning
of month (BOM) equals
Sales X (stock/sales) = stock.
That is, sales drops out of the
equation.
G. EOM (End of Month) Inventory (Line 7)
• The BOM inventory from the current month is the
When a retailer closes for
business at the end of the
month, the inventory should be
H. Monthly Additions to Stock (Inventory) (line 8)
• The monthly additions to stock is the amount to be
ordered for delivery in each month, given turnover
Emphasize: Retailer should
purchase amounts indicated in
line 8 which is based on sales
Chapter 11 – Managing the Merchandise Planning Process
11–24
II. Open-to-Buy System
• The open-to-buy system is used after the merchandise
is purchased using the merchandise budget plan or
staple merchandise management system.
• The open-to-buy system keeps track of merchandise
See PPT 11A–16
Now that the buyer knows how
much to spend in each month
(based on the merchandise
A. Calculating Open-to-Buy for the Current Period
• Buyers develop plans indicating how much inventory
for the merchandise category will be available at the
end of the month.
• These plans might be inaccurate. Shipments might not
arrive on time, sales might be greater than expected,
See PPT 11A–17
Chapter 11 – Managing the Merchandise Planning Process
11–25
• Thus the projected EOM inventory will be less than
Chapter 11 – Managing the Merchandise Planning Process
11–26
ANSWERS TO SELECTED GET OUT & DO ITS
2. INTERNET EXERCISE Go to the home page of Merchandise Management Company
section on “news”) on this website. How does this service provider support vendors to
manage merchandise sold at this discount department store (read section on “Our Services”)?
Increases sales at retail
– Consistent product presentation to match planograms
3. IN-STORE or INTERNET EXERCISE Go to the store location or homepage for a craft store
such as Michaels Stores, Jo-Ann Fabric and Craft Stores, or A.C. Moore Arts & Crafts
does this retailer organize its merchandise in terms of merchandise group, department,
category, and stock-keeping unit? Select two categories of merchandise: one you would
expect to have a high inventory turnover and the other, a low inventory turnover. Explain
your reasoning for each selection.
From the Michael’s Homepage – Departments
Art Supplies, Beads, Craft Painting, Framing, Home Décor, Scrapbooking, Wedding,
4. GO SHOPPING Visit a big-box office supply store and then a discount store to shop for
school supplies. Contrast the variety and assortment offered at both. What are the
advantages and disadvantages of breath versus. depth for each retailer? What are the
advantages and disadvantages from the consumer’s perspective?
Students should be able to describe that an office supply store has greater depth in
Chapter 11 – Managing the Merchandise Planning Process
11–27
5. INTERNET EXERCISE. Go to the home pages of the following retail trade publications: Chain
an article in each that focuses on managing merchandise. How can these articles assist
retailers with merchandise planning decisions?
with information to support merchandising planning, forecasting, and measurement?
From the company website…
Right merchandise. Right place. Right price.
Only SAS Merchandise Intelligence provides real intelligence at every step of the
merchandising life cycle. With this collection of software and services, you can maximize
Chapter 11 – Managing the Merchandise Planning Process
11–28
Because it includes our leading forecasting capabilities and advanced analytics, SAS
Merchandise Intelligence helps you drive profits by optimizing the merchandising process
from planning through inventory fulfillment.
Chapter 11 – Managing the Merchandise Planning Process
11–29
ANSWERS TO DISCUSSION QUESTIONS AND PROBLEMS
1. How and why would you expect variety and assortment to differ between JCPenney’s
store and Internet site?
JCPenney’s individual stores will cater more toward local and regional tastes than will
JCPenney’s online site. In addition, JCPenney’s stores are limited on space and cannot
2. Simply speaking, increasing inventory turnover is an important goal for a retail manager.
What are the consequences of turnover that’s too low? Too high?
With a high amount of turnover, sales volume increases. When retailers sell merchandise
3. Assume you are the grocery buyer for canned fruits and vegetables at a five-store
supermarket chain. Del Monte has told you and your boss that it would be responsible
for making all inventory decisions for those merchandise categories. It would determine
how much to order and when shipments should be made. It promises a 10 percent
increase in gross margin dollars in the coming year. Would you take Del Monte up on its
offer? Justify your answer.
In this case, Del Monte would act as a category captain for the fruits and vegetables
category for the supermarket chain. Since the supermarket is a small five-store chain, one
Chapter 11 – Managing the Merchandise Planning Process
11–30
A partnership arrangement with Del Monte would provide this chain with tremendous
benefits. It can leverage the customer insights developed at Del Monte through its
expertise in the field and experience in working with other supermarkets. These insights, in
Del Monte could offer a lot of advantages, but several risks and issues do remain. On one
hand, the various benefits and the promise of a 10 percent increase in gross margin dollars
is attractive. But, a cautious supermarket executive would try to negotiate a deal that
4. A buyer at Old Navy has received a number of customer complaints that he has been out
of stock on some sizes of men’s T-shirts. The buyer subsequently decides to increase this
category’s product availability from 80 percent to 90 percent. What will be the impact on
backup stock and inventory turnover? Would your answer be the same if the product
category were men’s fleece sweatshirts?
An increase in customer service by 10 percent will increase backup stock by much greater
than 10 percent (see Exhibit 11–10). Inventory turnover will be adversely affected.
5. Variety, assortment, and product availability are the cornerstones of the merchandise
planning process. Provide examples of retailers that have done an outstanding job of
positioning their stores based on one or more of these issues.
Chapter 11 – Managing the Merchandise Planning Process
Students will have a variety of answers to this question. However, some possible responses
are:
* Costco has a wide variety of merchandise where you can find 4,000 carefully chosen
6. The fine jewelry department in a department store has the same GMROI as the small
appliances department, even though characteristics of the merchandise are quite
different. Explain this situation.
The jewelry department has a low turnover, but a very high margin. Typically, a jewelry
department can command a very high markup because they are selling merchandise that
7. Calculate the GMROI and inventory turnover given annual sales of $20,000, average
inventory (at cost) of $4,000 and a gross margin of 45 percent.
• GMROI = Gross margin % x Sales-to-stock ratio
Chapter 11 – Managing the Merchandise Planning Process
11–32
8. As the athletic shoe buyer for Dick’s Sporting Goods, how would you go about forecasting
sales for a new Nike running shoe?
As the athletic shoe buyer for Dick’s Sporting Goods, you are dealing with a staple
merchandise category. Sales of athletic shoes should prove to be relatively steady over time
9. Using the 80-20 principle, how can a retailer make certain it has enough inventory of fast–
selling merchandise and a minimal amount of slow-selling merchandise?
Retailers should rank products by the 80-20 principle, which maintains that 80 percent of a
retailer’s sales or profits come from 20 percent of the products. This ranking system is
10. A buyer at a sporting goods store in Denver receives a shipment of 400 ski parkas on
October 1 and expects to sell out by 31. On November 1, the buyer still has 350 parkas
left. What issues should the buyer consider in evaluating the selling season’s progress?
Using a sell-through analysis, if the selling season is supposed to be four months, the buyer
should expect to sell about 100 units in the first month. Before deciding whether or not the
Chapter 11 – Managing the Merchandise Planning Process
11–33
11. A buyer is trying to decide from which vendor to buy a certain item. Using the following
information, determine from which vendor the buyer should buy.
VENDOR PERFORMANCE
Importance
Issues Weight Vendor A Vendor B
Reputation for collaboration 8 9 8
Service 7 8 7
Vendor A Vendor B
8 x 9= 72 8 x 8 = 64
7 x 8 = 56 7 x 7 = 49
Chapter 11 – Managing the Merchandise Planning Process
CONNECT ACTIVITIES FOR CHAPTER 11
Activity Type(s)
Topic(s)
Learning Objective(s)
Merchandise
Management Process
Drag and Drop;
Matching (accessible
version)
Overview of
Merchandise
Management
11-1 Explain the
merchandise
management
organization and
performance
measures.