Marketing Analytics: Case Studies
© Stephan Sorger, 2013; www.StephanSorger.com 1
MARKETING ANALYTICS: Case Study  Name: ____________________
© Stephan Sorger 2013; www.stephansorger.com  Date:     ________________________ 
Case No. Chapters Case Title
7B 7 Product Analytics: Resource Allocation using BCG Matrix
Background:
You are the portfolio manager for Honda motor company. You have been asked to consider the role that six
Honda vehicles play in the overall portfolio of the company. The portfolio exercise asks you to consider how
the sales performance of these vehicles compares with that of market leader Toyota. You have gathered the
following sales data for Honda, Toyota, and total sales and growth rates for six automotive categories: * 
Category Honda  Sales, 2010  Toyota   Sales, 2010 Category; Growth
Midsize  Accord  186,356 Camry     189,297 1,942,699; +10.2%
Small  Civic  156,832 Corolla     167,846 1,324,140;   – 4.9%
Minivan  Odyssey   62,278 Sienna       53,482    449,546; +11.0%
Midsize SUV Pilot      59,681 4-Runner      25,767    341,886; +27.3%
Crossover Element     8,306 Venza       29,220 1,542,211; +14.0%
Pickup  Ridgeline     9,848 Tacoma      60,471 1,045,835; +10.6% 
1. Calculate the market share for Honda and Toyota. Calculate the relative market share for Honda.
Category Honda  Market Share  Toyota   Market Share Relative Market Share
Midsize  Accord  _____% Camry  _____% _____
Small  Civic  _____  Corolla  _____  _____
Minivan  Odyssey _____  Sienna  _____  _____
Midsize SUV Pilot    _____  4-Runner _____  _____
Crossover Element _____  Venza  _____  _____
Pickup  Ridgeline _____  Tacoma _____  _____ 
2. Plot the positions for the 6 Honda vehicles on the BCG matrix. (Note the relative share axis is inverted)
Growth .            .
+30% |  Question Marks     |  Stars      |
+25% |       |       |
+20% |       |       |
+15% |       |       |
+10% |_________________________________|____________________________________________|
+  5% |       |       |
    0 |       |                   |
–   5% |. Dogs       |  Cash Cows      |
0 0.2 0.4 0.6 0.8 1.0 1.2 1.4 1.6 1.8 2.0 2.2 2.4
Relative Market Share
3. Identify vehicles in each quadrant. Suggest a strategy for each vehicle.
Quadrant Vehicles Strategy
Dogs
Cash Cows
Question Marks
Stars
*(1) Source: Honda Press Release, “American Honda Reports July Sales.” August 3, 2010.
http://www.hondanews.com/channels/honda-automobiles-headlines/releases/american-honda-reports-july-sales-2
(2) Source: Toyota Press Release: July 2010 Sales Chart
http://pressroom.toyota.com/pr/tms/document/July_Sales_Chart.pdf
(3) Source: Wall Street Journal, “Market Data Center, Automotive Sales.” September 1, 2010.
http://online.wsj.com/mdc/public/page/2_3022-autosales.html
  
Marketing Analytics: Case Studies
© Stephan Sorger, 2013; www.StephanSorger.com 1
MARKETING ANALYTICS: Case Study  Name: ____________________
© Stephan Sorger 2013; www.stephansorger.com  Date:     ________________________ 
Case No. Chapters Case Title
8 8 Pricing: Acme Lamp Company
You are the marketing manager for Acme Lamp Company. Acme specializes in the manufacture of lamps
(light bulbs) for industrial applications. You are in charge of launching Acme’s new LED-12 light emitting
diode (LED) lamp. The LED-12 uses an array of 12 high-intensity LEDs to replace a standard medium-base
incandescent lamp. As part of the launch plan, you must select a price. You have the following data: 
Attribute Data Description
Investment $20,000 Money invested to develop product
Fixed Cost $10,000 Overhead costs not changing with quantity produced
Variable Cost $10 Labor and material costs to produce each unit
Unit Sales 5,000/ year Quantity of units forecast to sell at $20 per unit
Unit Sales, Max 10,000/ year Constraint on production; Maximum production quantity
% Markup 20% Desired return on sales
Target ROI 20% Target return on investment for new projects
LED-12: Life 24 months Long life due to rugged LED design
Existing lamps: Price $1 Price of existing lamps: Incandescent and CFL
Existing lamps: Life 3 months Shortened life due to severe conditions in industrial plant
Existing lamps: Labor $20/ lamp to replace Labor cost to replace existing lamp
Price elasticity 1 % change in demand given a % change in price
1. Calculate the target price using Markup/ Cost-Plus pricing.
Pricing Calculations Results
Unit Cost
Markup Price
2. Calculate the target price using Target Return pricing.
Pricing Calculations Results
Unit Cost
Target-Return Price
3. Calculate the target price using Value-In-Use pricing. Assume industrial plant uses 100 lamps.
Pricing Calculations Results
Current cost
Value In Use Price
4. Calculate the target price using the Optimal Price Analysis tool on www.StephanSorger.com.
Pricing Calculations Results
Optimal Price
- MarketingAnalytics_Case7B_BCG_v1
 - MarketingAnalytics_Case8_Pricing_v1
 
					