尊敬的 微信汇率:1円 ≈ 0.046239 元 支付宝汇率:1円 ≈ 0.04633元 [退出登录]
SlideShare a Scribd company logo
Chapter 6.
Business Operations
Disclaimer:
• All images such as logos, photos, etc. used in this presentation are the property of their respective copyright owners and are used
here for educational purposes only
• Some material adapted from: Sorger, Stephan. “Marketing Analytics: Strategic Models and Metrics. Admiral Press. 2013.
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Outline/ Learning Objectives
Topic Description
Forecast Learn how to forecast future sales
Predictive Describe how to use predictive analytics
Data Mining Describe how to use data mining to gain insight
Scorecards Utilize balanced scorecards
Success Identify critical success factors for supporting KPIs
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Topic Description
Operations Processes, actions, decisions to enable tactics from strategy
Wide Impact Can affect multiple disciplines: Products, Price, and so on
Responsibility Often done by the Marketing department
Business Operations
Strategy Tactics
Business Operations
Enabler of tactics
- Forecasting
- Predictive analytics
-Data mining
-Critical success factors
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting Applications
Promotion
Sales
Support
Product
Price
Place (Distribution)
Forecasting
Quantity of product to manufacture
Calculate price for break-even point
Estimate type and quantity of channels
Selection of promotion vehicles
Track expected vs. actual sales
Staff support centers
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting Methods
Trial Rate
Forecasting Methods
Causal Analysis
Time Series Diffusion Models
Study sales history Study underlying causes Study initial trials Study analogous adoption
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting Methods
Method Description and Usage
Time Series Leverage known sales history to extrapolate future sales
Best for rapid predictions of short-term future sales
Resources required: Low; Accuracy: Low
Causal Analysis Examines underlying causes to predict future conditions
Best for in-depth analyses of sales
Resources required: High; Accuracy: Medium - High
Trial Rate Uses market surveys of initial trials to predict future sales
Best for introduction phase of new product or service
Resources required: High; Accuracy: Medium
Diffusion Model Uses analogous situations to predict adoption rate
Best for introduction of new product or service
Resources required: Low; Accuracy: Medium
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: How to Select a Method
Forecasting
Method
Selection
Life Cycle Stage
Resources
Time Horizon
Accuracy
Data Availability
Degree of accuracy required
Causal requires significant data
One quarter, One year, One decade
Introduction vs. maturity stages
Availability of time and money
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Regression Analysis to Support Forecasting
A. Verify Data Linearity
Microsoft Excel: Least Squares Algorithm
Good to plot out data to check if linear
Verify
Data
Linearity
Launch
Data
Analysis
Select
Regression
Analysis
Input
Regression
Data
$6,000
$7,000
$10,000
Spending
Income
$5,000
$8,000
$9,000
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
B. Launch Data Analysis
Verify
Data
Linearity
Launch
Data
Analysis
Select
Regression
Analysis
Input
Regression
Data
Excel
Home Data …
…
Data Analysis
A B C D E F G
Regression Analysis to Support Forecasting
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
C. Select “Regression” from Analysis Tools
Verify
Data
Linearity
Launch
Data
Analysis
Select
Regression
Analysis
Input
Regression
Data
Data Analysis
Analysis Tools
OK
Regression
Regression Analysis to Support Forecasting
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
D. Input Regression Data
Y Range: Dependent Variable (Response Variable, such as Spending)
X Range: Independent Variables (could have multiple X variables)
Verify
Data
Linearity
Launch
Data
Analysis
Select
Regression
Analysis
Input
Regression
Data
Regression
Input Y Range OK
Input X Range
Labels
Constant is Zero
Confidence Level: %
95
x
x
Regression Analysis to Support Forecasting
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
R-Squared, the Coefficient of Determination
Also known as “Goodness of Fit”, from 0 (no fit) to 1 (perfect fit)
Regression Analysis to Support Forecasting
Scenario R-Squared
No Relationship 0.0
Social Science Studies 0.3
Marketing Research 0.6
Scientific Applications 0.9
Perfect Relationship 1.0
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Regression Analysis to Support Forecasting
Statistic Description
Standard Error Estimate of standard deviation of the coefficient
t-Stat Coefficient divided by the Standard Error
P-value Probability of encountering equal t value in random data
P-value should be 5% or lower
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Spending = 449.339 + (0.290749) * Income
Results:
Regression Analysis to Support Forecasting
Parameter Coefficient Standard Error t-Stat P-value
Intercept 449.339 1036.95 0.433329 0.707034
Income Coeff. 0.290749 0.042254 6.880976 0.020474
$6,000
$7,000
$10,000
Spending
Income
$5,000
$8,000
$9,000
Spending = (Y-Intercept) + (Income Coefficient) * Income
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Time Series Methods
Technical stock analysts
study stock trends over time
to predict future direction
Stock Price
Time
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Time-Series
Sales
$100
$110
$120
$130
$140
$150
1 2 3 4 5 6 7 8 Time
Raw data
Period Sales
Period 1 110
Period 2 110
Period 3 120
Period 4 130
Period 5 120
Period 6 130
Period 7 140
Period 8 ???
Plot out sales data
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trend Line
Sales
$100
$110
$120
$130
$140
$150
1 2 3 4 5 6 7 8 Time
Trend Line + 8
Sales = (Intercept) + (Slope) * (Time, in Periods)
Sales = (103.1) + (4.85) * (8) = 142.0
Output Description Value in Our Example
R-Square Goodness of fit of line with data 0.75
Intercept Point where line crosses Y-axis 103.1
Slope Coefficient for time variable 4.85
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Time Series: Smoothing
Sales
Period Sales 3PMA*
1 110 --
2 110 113**
3 120 120
4 130 123
5 120 127
6 130 130
7 140 137
8 142 --
*3 Period Moving Ave
**(110+110+120) / 3 = 113
$100
$110
$120
$130
$140
$150
1 2 3 4 5 6 7 8 Time
Smoothed; 3PMA
3 Period Moving Average
Calculations
Chart after 3PMA Smoothing
Exponential Smoothing
Similar to 3PMA, but weights recent data higher than past data
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Causal Analysis
$0
$100
$200
$300
$400
2006 2007 2008 2009 2010 2011 2012
iPhone 1 iPhone 3G iPhone 3GS iPad 1 iPhone 4
Value Investors: Seeks to find intrinsic characteristics of companies which can
cause significant stock growth
Causal Analysis examines root causes of marketing phenomena
Apple
Stock
Price
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Candidate Causal Factors
Factors
Driving
Sales
Distribution
Promotion
Sales Experience
Support
Market Conditions
Competitive Environment
Product/ Service
Brand
Pricing
Sales decline in recessions
Example: Consumer goods
Airline fare wars
Example: United Airlines
New products can drive sales
Example: Apple
Strong brands can drive sales
Example: Audi
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Candidate Causal Factors
Factors
Driving
Sales
Distribution
Promotion
Sales Experience
Support
Market Conditions
Competitive Environment
Product/ Service
Brand
Pricing
New outlet store can drive sales
Example: H&R Block expansion
Price drops can drive sales
Example: Walmart
Social media can drive sales
Example: GEICO
Skilled salespeople drive sales
Example: Nordstrom
Disgruntled customers hurt sales
Example: Dell Computers
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Causal Factors: Multivariate
Period Sales Level Market Awareness Number of Locations
Q1 2012 $1.0 million 80% 5
Q2 2012 $1.1 million 80% 5
Q3 2012 $1.3 million 85% 6
Q4 2012 $1.2 million 85% 6
Q1 2013 $1.3 million 85% 7
Q2 2013 $1.5 million 90% 8
Q3 2013 $1.5 million 90% 8
Q4 2013 $1.4 million 90% 8
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Causal Factors: Multivariate
Sales = (Intercept) + (Coefficient 1) * (Market Awareness) + (Coefficient 2) * (Number of Locations)
= (- 1.44) + (0.028) * (Market Awareness) + (0.043) * (Number of Locations)
Example: Maintain brand awareness at 90%; Open two new retail stores (10 total)
= (-1.44) + (0.028) * (90) + (0.043) * (10) = $1.56 million
Output Description Values in Our Sales Example
R-Square Goodness of fit of model to data 0.93
Intercept Point where line crosses Y axis -1.44
Coefficient 1 Coefficient for Market Awareness 0.028
Coefficient 2 Coefficient for Number of Locations 0.043
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate Forecasting
Survey
Sales
Trial Rate
Repeat Rate
Forecast
Trial Rate =(Number of First-Time Purchasers or Users in Period t) / (Population)
Repeat Rate = (Number of Repeat Purchasers or Users in Period t)
(Number of First-Time Purchasers or Users in Period t-1)
Penetration in Period t = [Penetration in Period (t – 1)] * (Repeat Rate in Period t)
+ (Number of First-Time Purchasers or Users in Period t)
Projection of Sales in Period t = (Penetration in Period t) *
(Average Frequency of Purchase) * (Average Units per Purchase)
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate Forecasting
Example: Acme Dog Walking Service
Provides dog walking services for town of population 5000; Repeat rate of 90%.
Trial of new dog grooming service with 100 people during 1 month test period
Acme expects to gain 80 new purchases in next period.
Trial Rate = (Number of First-Time Purchasers or Users in Period t) / (Population)
Trial Rate = (100 first-time purchasers) / (5,000 inhabitants) = 2.0%
.
.
..
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate Forecasting
Example: Acme Dog Walking Service
Provides dog walking services for town of population 5000; Repeat rate of 90%.
Trial of new dog grooming service with 100 people during 1 month test period
Acme expects to gain 80 new purchases in next period.
Penetration in Period t = [Penetration in Period (t – 1)] * (Repeat Rate in Period t)
+ (Number of First-Time Purchasers or Users in Period t)
Penetration in Period t = (100 customers in previous period) * (90% repeat rate)
+ (80 customers in current period) = 170 customers
.
.
..
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate Forecasting
Example: Acme Dog Walking Service (continued)
Acme finds out that the average customer owns 1.5 dogs and gets them groomed once/ month
Acme charges $50 for grooming services
Projection of Sales in Period t = (Penetration in Period t) * (Average Frequency of Purchase)
•(Average Units per Purchase)
Projection of Sales in Period t = (170 customers) * (1 per month) * (1.5 units per purchase)
= 255 units expected to be purchased  Sales amount = units sold * price/unit = $255*$50=$12,750
.
.
..
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate: Market Survey
Qualification Questions
Classification Questions
Body Questions
Survey
Definitely Will Not Buy Probably Will Not Buy May or May Not Buy Probably Will Buy Definitely Will Buy
Acme conducts market surveys to estimate trial volume
Trial volume = number of units we expect to sell to the population over a given time
3 Principal sections in survey: Qualification; Body; Classification
Intention to Buy scale
Determines if respondent is relevant to our study
Asks the main information we want to know
Classifies the respondent into segments
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate: Market Survey
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate: Market Survey
Trial Volume = (Population) * (Awareness) * (Availability) *
[(80% * Definitely Buy) + (30% * Probably Buy)] * (Units per Purchase)
Trial Volume = (5,000) * (20% Awareness) * (30% Availability) *
[(80% * 10% Definitely Buy) + (30% * 20% Probably Buy)] * (1.5 units/ purchase)
= 63 units
Survey Question Results
Number of dogs owned 1.5, on average
Frequency of dog grooming Every 8 weeks, or 0.5 purchases/ month
Likelihood to buy Definitely will buy: 10%
Probably will buy: 20%
Awareness of Acme 20%
Availability of Pet Store 1 30%
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Trial Rate: Market Survey
Repeat Volume = [(Trial Population) * (Repeat Rate)] *
(Repeat Unit Volume per Customer) * (Repeat Occasions)
Trial Population = (Population) * (Awareness) * (Availability)
Trial Population = (5,000) * (20% Awareness) * (30% Availability)
= 300 people
Repeat Volume = [(300 people) * (90% Repeat Rate)]
* (1.5 units per purchase) * (0.5 purchase per month)
= 202.5 units per month * 12 months per year
= 2,430 units/ year
Total Volume = (Trial Volume) + (Repeat Volume)
= (63 units) + (2,430 units)
= 2,493 units in first year
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models: Adopter Categories
Innovators
Early
Adopters
Early
Majority
Late
Majority Laggards
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models: 2 Contributors
Imitators
Innovators
Innovation
Diffusion
Innovators seek new ideas
with little concern if others
have adopted.
Drives less than 20% of sales
Imitators adopt new innovations
through the influence of others.
Imitators wait until others have tried.
Drives more than 80% of sales
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models: Imitator-Based
Time
Adoption
100%
Waiting for others to try first
Quick adoption rate,
once others have adopted
Vast majority of innovations follow this profile
Examples:
Smartphones
Movies (most)
Resorts
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models: Innovator-Based
Time
Adoption
100%
Rapid initial adoption; Minority of adoptions
Examples:
Early HD TVs
Early washers
Early automobiles
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models: Bass
f(t)/ [1 – F(t)] = p + q/M [A(t)]
The equation includes the following variables:
f(t): Portion of the potential market that adopts a new innovation at a certain time (t)
F(t): Portion of the potential market that has adopted the innovation at a certain time (t)
A(t): Cumulative adopters of the new innovation at a certain time (t)
M: Potential market (the ultimate number of people likely to adopt the new innovation)
p: Coefficient of innovation (the degree to which Innovators drive adoption)
q: Coefficient of imitation (the degree to which Imitators drive adoption)
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models
Conflicting Standards
Market Situations
For
Bass Coefficients
Clashing technical standards/formats
“Format wars”: HD-DVD vs. Blu-Ray
p = 0.00637; q = 0.7501
Fee-Based Content
Distribution of content through network
Cable TV; Online “paywalls”
p = 0.00001; q = 0.5013
High Investments
Financial commitment to adopt
CD players and digital recording
p = 0.0017; q = 0.3991
Market Timing
Ability of market to accept
Bad timing; ATM machines
p = 0.00053; q = 0.4957
Network Effects
Value increases with adoption
Cell phone networks
p = 0.00074; q = 0.4132
Value Proposition
Clear, compelling reason to buy
Clothes washers
p = 0.03623; q = 0.234
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models: Bass Approach
Look up
Values
for p and q
Determine
M (Size
of Market)
Execute
Bass
Model
Interpret
Bass
Results
Understand
Market
Situation
Internet search: “Bass Model Excel”  Many free Excel models available
Internet search: “Bass Coefficients”  Tables of p and q for different innovations
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Diffusion Models
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Forecasting: Triangulation of Multiple Forecasts
Salesforce Estimate
Triangulation Informed Estimate
Forecast 2
Forecast 3 Sales History
Forecast 1
Forecast = (W1 * Forecast 1) + (W2 * Forecast 2) + (W3 * Forecast 3)
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Predictive Analytics: Trends
Growth Demands
Competitive Advantage
Technology
Data Availability
Trends Driving
Predictive
Analytics
Cloud computing, Cheap storage
Terabytes of customer data
Looking for growth opportunities
Powerful tool to target niches
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Predictive Analytics: Applications
Fraud Detection
Healthcare
Customer Profitability
Banking
Collections
Predictive
Analytics
Applications
Cross-Selling Insurance
Airlines
Predict maintenance before failure
FICO scores
Predict which customers will pay
“Customers who bought X bought Y”
Identify profitable customers
Predict fraudulent claims
Predict at-risk patients
Assign prices to policies
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Data Mining: Process
Target
Data
Pre-
Processed
Data
Transformed
Data
Patterns Actionable
Information
Selection Pre-Processing Transformation Data Mining Interpretation
Data
Step Description
Selection Select portion of data to target
Pre-Processing Data cleansing; Removing duplicate records
Transformation Sorting; Pivoting; Aggregation; Merging
Data Mining Find patterns in data
Interpretation Form judgments based on the patterns
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Data Mining: Approaches
Clustering
Regression
Association Rule Learning
Classification
Data
Mining
Approaches
Search for associations in data
Seek products purchased together
Sorts data into different categories
Have prior knowledge of patterns
Spam filtering
Identify patterns in data
No prior knowledge of patterns
Find relationships between variables
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Balanced Scorecard: Balance
Financial Measurement Non-Financial Measurement
Topic Description
Creators Kaplan and Norton
Balanced Considers financial, as well as non-financial, measures
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Balanced Scorecard: Perspectives
Perspective Description and Example
Customers Time; Quality; Service; Cost
Example: Southwest: Delivering customer value
Financial Profitability; Growth; Shareholder Value
Example: L’Oreal: 5th in the world for value creation
Innovation & Learning Ability to create value; Ability to improve efficiencies
Example: Nvidia: Ability to efficiently launch products
Internal Processes Core competencies for the market
Example: Zynga: Competency in speed of development
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Critical Success Factors: Types
Environmental
Temporal
Industry
Strategy
Critical
Success
Factors
Required areas of competency
to succeed in the industry
Verizon: Customer retention
Strategies of individual companies
Cupcakery: Niche strategy
Respond to changes: PESTLE
Solar Panels: Leasing options
Address barriers to change
Internal: Prepare for re-org
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Critical Success Factors: Process
List
Candidate
CSFs
Select
Final
CSFs
Identify
Relevant
KPIs
Track
Critical
KPIs
Establish
Primary
Objectives
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Critical Success Factors: Process
Step Description and Example
Establish Objectives Establish primary objectives and strategy to achieve
Market Development Example:
Company decides on strategy of market development
List Candidate CSFs Consider required competencies to achieve objectives
Example: Create list of CSFs
Select Final CSFs Identify top 3 – 5 CSFs
Example: Focus on customer service
List
Candidate
CSFs
Select
Final
CSFs
Identify
Relevant
KPIs
Track
Critical
KPIs
Establish
Primary
Objectives
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Critical Success Factors: Process
Step Description and Example
Identify Relevant KPIs Assign one or more KPIs for each CSF
Example: Measure customer satisfaction rates
Track Critical KPIs Monitor KPIs to evaluate execution of CSFs
Example: Track customer satisfaction over time
List
Candidate
CSFs
Select
Final
CSFs
Identify
Relevant
KPIs
Track
Critical
KPIs
Establish
Primary
Objectives
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
Check for Understanding
Topic Description
Forecasting Apply different techniques to forecast future sales
Predictive Know the concepts behind predictive analytics & data mining
Scorecards Identify the concepts behind balanced scorecards
Success Review how to set up critical success factors
© Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1

More Related Content

Similar to MarketingAnalytics_Ch6_BusinessOperations.ppt

HR / Talent Analytics
HR / Talent AnalyticsHR / Talent Analytics
HR / Talent Analytics
Akshay Raje
 
Data Visualization: Sales forecasting
Data Visualization: Sales forecastingData Visualization: Sales forecasting
Data Visualization: Sales forecasting
AlgoAnalytics Financial Consultancy Pvt. Ltd.
 
IRJET - Stock Recommendation System using Machine Learning Approache
IRJET - Stock Recommendation System using Machine Learning ApproacheIRJET - Stock Recommendation System using Machine Learning Approache
IRJET - Stock Recommendation System using Machine Learning Approache
IRJET Journal
 
Chapter 03 Slides ( Exclude).pptx
Chapter 03 Slides (              Exclude).pptxChapter 03 Slides (              Exclude).pptx
Chapter 03 Slides ( Exclude).pptx
ryan gementiza
 
6 sigma understanding
6 sigma understanding6 sigma understanding
6 sigma understanding
Jitesh Gaurav
 
Forecast Performance KPIs & Metrics
Forecast Performance KPIs & MetricsForecast Performance KPIs & Metrics
Forecast Performance KPIs & Metrics
Simon C Jones CSCP
 
Sales Forecasting
Sales ForecastingSales Forecasting
Sales Forecasting
Aslı Karabulut
 
UNIT - II.pptx
UNIT - II.pptxUNIT - II.pptx
UNIT - II.pptx
ssuserd3982b1
 
Carey
CareyCarey
5 Best Practices Used By Einstein Analytics' Best Customers
5 Best Practices Used By Einstein Analytics' Best Customers5 Best Practices Used By Einstein Analytics' Best Customers
5 Best Practices Used By Einstein Analytics' Best Customers
Hyoun Park
 
ASMD 2022 for class.pptx
ASMD 2022 for class.pptxASMD 2022 for class.pptx
ASMD 2022 for class.pptx
MahekSinghania2
 
Effective demand planning - our vision at Solventure
Effective demand planning - our vision at SolventureEffective demand planning - our vision at Solventure
Effective demand planning - our vision at Solventure
Solventure
 
yellow belt training
yellow belt trainingyellow belt training
yellow belt training
Nishant Narendra
 
Analytics for offline retail: Using Advanced Machine Learning
Analytics for offline retail: Using Advanced Machine LearningAnalytics for offline retail: Using Advanced Machine Learning
Analytics for offline retail: Using Advanced Machine Learning
AlgoAnalytics Financial Consultancy Pvt. Ltd.
 
Exploring the Data science Process
Exploring the Data science ProcessExploring the Data science Process
Exploring the Data science Process
Vishal Patel
 
Strategic approachppg v02
Strategic approachppg v02Strategic approachppg v02
Strategic approachppg v02
Daniel Arturo Espinoza Soto
 
Basic Statistics for Paid Search Advertising
Basic Statistics for Paid Search AdvertisingBasic Statistics for Paid Search Advertising
Basic Statistics for Paid Search Advertising
Nina Estenzo
 
Marketing Analytics: Data Quality, Data Matching & Marketing Metrics
Marketing Analytics: Data Quality, Data Matching & Marketing MetricsMarketing Analytics: Data Quality, Data Matching & Marketing Metrics
Marketing Analytics: Data Quality, Data Matching & Marketing Metrics
Senturus
 
QuantTrendSeriesSLV20150512
QuantTrendSeriesSLV20150512QuantTrendSeriesSLV20150512
QuantTrendSeriesSLV20150512
Kenneth Koh
 
Business Valuation PowerPoint Presentation Slides
Business Valuation PowerPoint Presentation SlidesBusiness Valuation PowerPoint Presentation Slides
Business Valuation PowerPoint Presentation Slides
SlideTeam
 

Similar to MarketingAnalytics_Ch6_BusinessOperations.ppt (20)

HR / Talent Analytics
HR / Talent AnalyticsHR / Talent Analytics
HR / Talent Analytics
 
Data Visualization: Sales forecasting
Data Visualization: Sales forecastingData Visualization: Sales forecasting
Data Visualization: Sales forecasting
 
IRJET - Stock Recommendation System using Machine Learning Approache
IRJET - Stock Recommendation System using Machine Learning ApproacheIRJET - Stock Recommendation System using Machine Learning Approache
IRJET - Stock Recommendation System using Machine Learning Approache
 
Chapter 03 Slides ( Exclude).pptx
Chapter 03 Slides (              Exclude).pptxChapter 03 Slides (              Exclude).pptx
Chapter 03 Slides ( Exclude).pptx
 
6 sigma understanding
6 sigma understanding6 sigma understanding
6 sigma understanding
 
Forecast Performance KPIs & Metrics
Forecast Performance KPIs & MetricsForecast Performance KPIs & Metrics
Forecast Performance KPIs & Metrics
 
Sales Forecasting
Sales ForecastingSales Forecasting
Sales Forecasting
 
UNIT - II.pptx
UNIT - II.pptxUNIT - II.pptx
UNIT - II.pptx
 
Carey
CareyCarey
Carey
 
5 Best Practices Used By Einstein Analytics' Best Customers
5 Best Practices Used By Einstein Analytics' Best Customers5 Best Practices Used By Einstein Analytics' Best Customers
5 Best Practices Used By Einstein Analytics' Best Customers
 
ASMD 2022 for class.pptx
ASMD 2022 for class.pptxASMD 2022 for class.pptx
ASMD 2022 for class.pptx
 
Effective demand planning - our vision at Solventure
Effective demand planning - our vision at SolventureEffective demand planning - our vision at Solventure
Effective demand planning - our vision at Solventure
 
yellow belt training
yellow belt trainingyellow belt training
yellow belt training
 
Analytics for offline retail: Using Advanced Machine Learning
Analytics for offline retail: Using Advanced Machine LearningAnalytics for offline retail: Using Advanced Machine Learning
Analytics for offline retail: Using Advanced Machine Learning
 
Exploring the Data science Process
Exploring the Data science ProcessExploring the Data science Process
Exploring the Data science Process
 
Strategic approachppg v02
Strategic approachppg v02Strategic approachppg v02
Strategic approachppg v02
 
Basic Statistics for Paid Search Advertising
Basic Statistics for Paid Search AdvertisingBasic Statistics for Paid Search Advertising
Basic Statistics for Paid Search Advertising
 
Marketing Analytics: Data Quality, Data Matching & Marketing Metrics
Marketing Analytics: Data Quality, Data Matching & Marketing MetricsMarketing Analytics: Data Quality, Data Matching & Marketing Metrics
Marketing Analytics: Data Quality, Data Matching & Marketing Metrics
 
QuantTrendSeriesSLV20150512
QuantTrendSeriesSLV20150512QuantTrendSeriesSLV20150512
QuantTrendSeriesSLV20150512
 
Business Valuation PowerPoint Presentation Slides
Business Valuation PowerPoint Presentation SlidesBusiness Valuation PowerPoint Presentation Slides
Business Valuation PowerPoint Presentation Slides
 

Recently uploaded

Call Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance Payment
Call Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance PaymentCall Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance Payment
Call Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance Payment
prijesh mathew
 
Overview IFM June 2024 Consumer Confidence INDEX Report.pdf
Overview IFM June 2024 Consumer Confidence INDEX Report.pdfOverview IFM June 2024 Consumer Confidence INDEX Report.pdf
Overview IFM June 2024 Consumer Confidence INDEX Report.pdf
nhutnguyen355078
 
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering RoadshowFabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Gabi Münster
 
SAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content DocumentSAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content Document
newdirectionconsulta
 
Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)
GeorgiiSteshenko
 
Health care analysis using sentimental analysis
Health care analysis using sentimental analysisHealth care analysis using sentimental analysis
Health care analysis using sentimental analysis
krishnasrigannavarap
 
🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...
🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...
🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...
yuvishachadda
 
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
Douglas Day
 
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
jasodak99
 
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
Rebecca Bilbro
 
Direct Lake Deep Dive slides from Fabric Engineering Roadshow
Direct Lake Deep Dive slides from Fabric Engineering RoadshowDirect Lake Deep Dive slides from Fabric Engineering Roadshow
Direct Lake Deep Dive slides from Fabric Engineering Roadshow
Gabi Münster
 
Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...
Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...
Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...
Marlon Dumas
 
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
mona lisa $A12
 
Startup Grind Princeton - Gen AI 240618 18 June 2024
Startup Grind Princeton - Gen AI 240618 18 June 2024Startup Grind Princeton - Gen AI 240618 18 June 2024
Startup Grind Princeton - Gen AI 240618 18 June 2024
Timothy Spann
 
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
hanshkumar9870
 
Hyderabad Call Girls 7339748667 With Free Home Delivery At Your Door
Hyderabad Call Girls 7339748667 With Free Home Delivery At Your DoorHyderabad Call Girls 7339748667 With Free Home Delivery At Your Door
Hyderabad Call Girls 7339748667 With Free Home Delivery At Your Door
Russian Escorts in Delhi 9711199171 with low rate Book online
 
Mumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book Now
Mumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book NowMumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book Now
Mumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book Now
radhika ansal $A12
 
Ahmedabad Call Girls 7339748667 With Free Home Delivery At Your Door
Ahmedabad Call Girls 7339748667 With Free Home Delivery At Your DoorAhmedabad Call Girls 7339748667 With Free Home Delivery At Your Door
Ahmedabad Call Girls 7339748667 With Free Home Delivery At Your Door
Russian Escorts in Delhi 9711199171 with low rate Book online
 
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service LucknowCall Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
hiju9823
 
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
PsychoTech Services
 

Recently uploaded (20)

Call Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance Payment
Call Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance PaymentCall Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance Payment
Call Girls Hyderabad ❤️ 7339748667 ❤️ With No Advance Payment
 
Overview IFM June 2024 Consumer Confidence INDEX Report.pdf
Overview IFM June 2024 Consumer Confidence INDEX Report.pdfOverview IFM June 2024 Consumer Confidence INDEX Report.pdf
Overview IFM June 2024 Consumer Confidence INDEX Report.pdf
 
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering RoadshowFabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
Fabric Engineering Deep Dive Keynote from Fabric Engineering Roadshow
 
SAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content DocumentSAP BW4HANA Implementagtion Content Document
SAP BW4HANA Implementagtion Content Document
 
Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)
 
Health care analysis using sentimental analysis
Health care analysis using sentimental analysisHealth care analysis using sentimental analysis
Health care analysis using sentimental analysis
 
🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...
🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...
🔥Night Call Girls Pune 💯Call Us 🔝 7014168258 🔝💃Independent Pune Escorts Servi...
 
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
 
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
❣VIP Call Girls Chennai 💯Call Us 🔝 7737669865 🔝💃Independent Chennai Escorts S...
 
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
 
Direct Lake Deep Dive slides from Fabric Engineering Roadshow
Direct Lake Deep Dive slides from Fabric Engineering RoadshowDirect Lake Deep Dive slides from Fabric Engineering Roadshow
Direct Lake Deep Dive slides from Fabric Engineering Roadshow
 
Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...
Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...
Discovering Digital Process Twins for What-if Analysis: a Process Mining Appr...
 
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
 
Startup Grind Princeton - Gen AI 240618 18 June 2024
Startup Grind Princeton - Gen AI 240618 18 June 2024Startup Grind Princeton - Gen AI 240618 18 June 2024
Startup Grind Princeton - Gen AI 240618 18 June 2024
 
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
 
Hyderabad Call Girls 7339748667 With Free Home Delivery At Your Door
Hyderabad Call Girls 7339748667 With Free Home Delivery At Your DoorHyderabad Call Girls 7339748667 With Free Home Delivery At Your Door
Hyderabad Call Girls 7339748667 With Free Home Delivery At Your Door
 
Mumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book Now
Mumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book NowMumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book Now
Mumbai Central Call Girls ☑ +91-9833325238 ☑ Available Hot Girls Aunty Book Now
 
Ahmedabad Call Girls 7339748667 With Free Home Delivery At Your Door
Ahmedabad Call Girls 7339748667 With Free Home Delivery At Your DoorAhmedabad Call Girls 7339748667 With Free Home Delivery At Your Door
Ahmedabad Call Girls 7339748667 With Free Home Delivery At Your Door
 
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service LucknowCall Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
 
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
 

MarketingAnalytics_Ch6_BusinessOperations.ppt

  • 1. Chapter 6. Business Operations Disclaimer: • All images such as logos, photos, etc. used in this presentation are the property of their respective copyright owners and are used here for educational purposes only • Some material adapted from: Sorger, Stephan. “Marketing Analytics: Strategic Models and Metrics. Admiral Press. 2013. © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 2. Outline/ Learning Objectives Topic Description Forecast Learn how to forecast future sales Predictive Describe how to use predictive analytics Data Mining Describe how to use data mining to gain insight Scorecards Utilize balanced scorecards Success Identify critical success factors for supporting KPIs © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 3. Topic Description Operations Processes, actions, decisions to enable tactics from strategy Wide Impact Can affect multiple disciplines: Products, Price, and so on Responsibility Often done by the Marketing department Business Operations Strategy Tactics Business Operations Enabler of tactics - Forecasting - Predictive analytics -Data mining -Critical success factors © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 4. Forecasting Applications Promotion Sales Support Product Price Place (Distribution) Forecasting Quantity of product to manufacture Calculate price for break-even point Estimate type and quantity of channels Selection of promotion vehicles Track expected vs. actual sales Staff support centers © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 5. Forecasting Methods Trial Rate Forecasting Methods Causal Analysis Time Series Diffusion Models Study sales history Study underlying causes Study initial trials Study analogous adoption © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 6. Forecasting Methods Method Description and Usage Time Series Leverage known sales history to extrapolate future sales Best for rapid predictions of short-term future sales Resources required: Low; Accuracy: Low Causal Analysis Examines underlying causes to predict future conditions Best for in-depth analyses of sales Resources required: High; Accuracy: Medium - High Trial Rate Uses market surveys of initial trials to predict future sales Best for introduction phase of new product or service Resources required: High; Accuracy: Medium Diffusion Model Uses analogous situations to predict adoption rate Best for introduction of new product or service Resources required: Low; Accuracy: Medium © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 7. Forecasting: How to Select a Method Forecasting Method Selection Life Cycle Stage Resources Time Horizon Accuracy Data Availability Degree of accuracy required Causal requires significant data One quarter, One year, One decade Introduction vs. maturity stages Availability of time and money © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 8. Regression Analysis to Support Forecasting A. Verify Data Linearity Microsoft Excel: Least Squares Algorithm Good to plot out data to check if linear Verify Data Linearity Launch Data Analysis Select Regression Analysis Input Regression Data $6,000 $7,000 $10,000 Spending Income $5,000 $8,000 $9,000 © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 9. B. Launch Data Analysis Verify Data Linearity Launch Data Analysis Select Regression Analysis Input Regression Data Excel Home Data … … Data Analysis A B C D E F G Regression Analysis to Support Forecasting © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 10. C. Select “Regression” from Analysis Tools Verify Data Linearity Launch Data Analysis Select Regression Analysis Input Regression Data Data Analysis Analysis Tools OK Regression Regression Analysis to Support Forecasting © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 11. D. Input Regression Data Y Range: Dependent Variable (Response Variable, such as Spending) X Range: Independent Variables (could have multiple X variables) Verify Data Linearity Launch Data Analysis Select Regression Analysis Input Regression Data Regression Input Y Range OK Input X Range Labels Constant is Zero Confidence Level: % 95 x x Regression Analysis to Support Forecasting © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 12. R-Squared, the Coefficient of Determination Also known as “Goodness of Fit”, from 0 (no fit) to 1 (perfect fit) Regression Analysis to Support Forecasting Scenario R-Squared No Relationship 0.0 Social Science Studies 0.3 Marketing Research 0.6 Scientific Applications 0.9 Perfect Relationship 1.0 © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 13. Regression Analysis to Support Forecasting Statistic Description Standard Error Estimate of standard deviation of the coefficient t-Stat Coefficient divided by the Standard Error P-value Probability of encountering equal t value in random data P-value should be 5% or lower © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 14. Spending = 449.339 + (0.290749) * Income Results: Regression Analysis to Support Forecasting Parameter Coefficient Standard Error t-Stat P-value Intercept 449.339 1036.95 0.433329 0.707034 Income Coeff. 0.290749 0.042254 6.880976 0.020474 $6,000 $7,000 $10,000 Spending Income $5,000 $8,000 $9,000 Spending = (Y-Intercept) + (Income Coefficient) * Income © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 15. Forecasting: Time Series Methods Technical stock analysts study stock trends over time to predict future direction Stock Price Time © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 16. Forecasting: Time-Series Sales $100 $110 $120 $130 $140 $150 1 2 3 4 5 6 7 8 Time Raw data Period Sales Period 1 110 Period 2 110 Period 3 120 Period 4 130 Period 5 120 Period 6 130 Period 7 140 Period 8 ??? Plot out sales data © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 17. Forecasting: Trend Line Sales $100 $110 $120 $130 $140 $150 1 2 3 4 5 6 7 8 Time Trend Line + 8 Sales = (Intercept) + (Slope) * (Time, in Periods) Sales = (103.1) + (4.85) * (8) = 142.0 Output Description Value in Our Example R-Square Goodness of fit of line with data 0.75 Intercept Point where line crosses Y-axis 103.1 Slope Coefficient for time variable 4.85 © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 18. Forecasting: Time Series: Smoothing Sales Period Sales 3PMA* 1 110 -- 2 110 113** 3 120 120 4 130 123 5 120 127 6 130 130 7 140 137 8 142 -- *3 Period Moving Ave **(110+110+120) / 3 = 113 $100 $110 $120 $130 $140 $150 1 2 3 4 5 6 7 8 Time Smoothed; 3PMA 3 Period Moving Average Calculations Chart after 3PMA Smoothing Exponential Smoothing Similar to 3PMA, but weights recent data higher than past data © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 19. Forecasting: Causal Analysis $0 $100 $200 $300 $400 2006 2007 2008 2009 2010 2011 2012 iPhone 1 iPhone 3G iPhone 3GS iPad 1 iPhone 4 Value Investors: Seeks to find intrinsic characteristics of companies which can cause significant stock growth Causal Analysis examines root causes of marketing phenomena Apple Stock Price © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 20. Forecasting: Candidate Causal Factors Factors Driving Sales Distribution Promotion Sales Experience Support Market Conditions Competitive Environment Product/ Service Brand Pricing Sales decline in recessions Example: Consumer goods Airline fare wars Example: United Airlines New products can drive sales Example: Apple Strong brands can drive sales Example: Audi © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 21. Forecasting: Candidate Causal Factors Factors Driving Sales Distribution Promotion Sales Experience Support Market Conditions Competitive Environment Product/ Service Brand Pricing New outlet store can drive sales Example: H&R Block expansion Price drops can drive sales Example: Walmart Social media can drive sales Example: GEICO Skilled salespeople drive sales Example: Nordstrom Disgruntled customers hurt sales Example: Dell Computers © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 22. Forecasting: Causal Factors: Multivariate Period Sales Level Market Awareness Number of Locations Q1 2012 $1.0 million 80% 5 Q2 2012 $1.1 million 80% 5 Q3 2012 $1.3 million 85% 6 Q4 2012 $1.2 million 85% 6 Q1 2013 $1.3 million 85% 7 Q2 2013 $1.5 million 90% 8 Q3 2013 $1.5 million 90% 8 Q4 2013 $1.4 million 90% 8 © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 23. Forecasting: Causal Factors: Multivariate Sales = (Intercept) + (Coefficient 1) * (Market Awareness) + (Coefficient 2) * (Number of Locations) = (- 1.44) + (0.028) * (Market Awareness) + (0.043) * (Number of Locations) Example: Maintain brand awareness at 90%; Open two new retail stores (10 total) = (-1.44) + (0.028) * (90) + (0.043) * (10) = $1.56 million Output Description Values in Our Sales Example R-Square Goodness of fit of model to data 0.93 Intercept Point where line crosses Y axis -1.44 Coefficient 1 Coefficient for Market Awareness 0.028 Coefficient 2 Coefficient for Number of Locations 0.043 © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 24. Forecasting: Trial Rate Forecasting Survey Sales Trial Rate Repeat Rate Forecast Trial Rate =(Number of First-Time Purchasers or Users in Period t) / (Population) Repeat Rate = (Number of Repeat Purchasers or Users in Period t) (Number of First-Time Purchasers or Users in Period t-1) Penetration in Period t = [Penetration in Period (t – 1)] * (Repeat Rate in Period t) + (Number of First-Time Purchasers or Users in Period t) Projection of Sales in Period t = (Penetration in Period t) * (Average Frequency of Purchase) * (Average Units per Purchase) © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 25. Forecasting: Trial Rate Forecasting Example: Acme Dog Walking Service Provides dog walking services for town of population 5000; Repeat rate of 90%. Trial of new dog grooming service with 100 people during 1 month test period Acme expects to gain 80 new purchases in next period. Trial Rate = (Number of First-Time Purchasers or Users in Period t) / (Population) Trial Rate = (100 first-time purchasers) / (5,000 inhabitants) = 2.0% . . .. © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 26. Forecasting: Trial Rate Forecasting Example: Acme Dog Walking Service Provides dog walking services for town of population 5000; Repeat rate of 90%. Trial of new dog grooming service with 100 people during 1 month test period Acme expects to gain 80 new purchases in next period. Penetration in Period t = [Penetration in Period (t – 1)] * (Repeat Rate in Period t) + (Number of First-Time Purchasers or Users in Period t) Penetration in Period t = (100 customers in previous period) * (90% repeat rate) + (80 customers in current period) = 170 customers . . .. © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 27. Forecasting: Trial Rate Forecasting Example: Acme Dog Walking Service (continued) Acme finds out that the average customer owns 1.5 dogs and gets them groomed once/ month Acme charges $50 for grooming services Projection of Sales in Period t = (Penetration in Period t) * (Average Frequency of Purchase) •(Average Units per Purchase) Projection of Sales in Period t = (170 customers) * (1 per month) * (1.5 units per purchase) = 255 units expected to be purchased  Sales amount = units sold * price/unit = $255*$50=$12,750 . . .. © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 28. Forecasting: Trial Rate: Market Survey Qualification Questions Classification Questions Body Questions Survey Definitely Will Not Buy Probably Will Not Buy May or May Not Buy Probably Will Buy Definitely Will Buy Acme conducts market surveys to estimate trial volume Trial volume = number of units we expect to sell to the population over a given time 3 Principal sections in survey: Qualification; Body; Classification Intention to Buy scale Determines if respondent is relevant to our study Asks the main information we want to know Classifies the respondent into segments © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 29. Forecasting: Trial Rate: Market Survey © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 30. Forecasting: Trial Rate: Market Survey Trial Volume = (Population) * (Awareness) * (Availability) * [(80% * Definitely Buy) + (30% * Probably Buy)] * (Units per Purchase) Trial Volume = (5,000) * (20% Awareness) * (30% Availability) * [(80% * 10% Definitely Buy) + (30% * 20% Probably Buy)] * (1.5 units/ purchase) = 63 units Survey Question Results Number of dogs owned 1.5, on average Frequency of dog grooming Every 8 weeks, or 0.5 purchases/ month Likelihood to buy Definitely will buy: 10% Probably will buy: 20% Awareness of Acme 20% Availability of Pet Store 1 30% © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 31. Forecasting: Trial Rate: Market Survey Repeat Volume = [(Trial Population) * (Repeat Rate)] * (Repeat Unit Volume per Customer) * (Repeat Occasions) Trial Population = (Population) * (Awareness) * (Availability) Trial Population = (5,000) * (20% Awareness) * (30% Availability) = 300 people Repeat Volume = [(300 people) * (90% Repeat Rate)] * (1.5 units per purchase) * (0.5 purchase per month) = 202.5 units per month * 12 months per year = 2,430 units/ year Total Volume = (Trial Volume) + (Repeat Volume) = (63 units) + (2,430 units) = 2,493 units in first year © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 32. Forecasting: Diffusion Models: Adopter Categories Innovators Early Adopters Early Majority Late Majority Laggards © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 33. Forecasting: Diffusion Models: 2 Contributors Imitators Innovators Innovation Diffusion Innovators seek new ideas with little concern if others have adopted. Drives less than 20% of sales Imitators adopt new innovations through the influence of others. Imitators wait until others have tried. Drives more than 80% of sales © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 34. Forecasting: Diffusion Models: Imitator-Based Time Adoption 100% Waiting for others to try first Quick adoption rate, once others have adopted Vast majority of innovations follow this profile Examples: Smartphones Movies (most) Resorts © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 35. Forecasting: Diffusion Models: Innovator-Based Time Adoption 100% Rapid initial adoption; Minority of adoptions Examples: Early HD TVs Early washers Early automobiles © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 36. Forecasting: Diffusion Models: Bass f(t)/ [1 – F(t)] = p + q/M [A(t)] The equation includes the following variables: f(t): Portion of the potential market that adopts a new innovation at a certain time (t) F(t): Portion of the potential market that has adopted the innovation at a certain time (t) A(t): Cumulative adopters of the new innovation at a certain time (t) M: Potential market (the ultimate number of people likely to adopt the new innovation) p: Coefficient of innovation (the degree to which Innovators drive adoption) q: Coefficient of imitation (the degree to which Imitators drive adoption) © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 37. Forecasting: Diffusion Models Conflicting Standards Market Situations For Bass Coefficients Clashing technical standards/formats “Format wars”: HD-DVD vs. Blu-Ray p = 0.00637; q = 0.7501 Fee-Based Content Distribution of content through network Cable TV; Online “paywalls” p = 0.00001; q = 0.5013 High Investments Financial commitment to adopt CD players and digital recording p = 0.0017; q = 0.3991 Market Timing Ability of market to accept Bad timing; ATM machines p = 0.00053; q = 0.4957 Network Effects Value increases with adoption Cell phone networks p = 0.00074; q = 0.4132 Value Proposition Clear, compelling reason to buy Clothes washers p = 0.03623; q = 0.234 © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 38. Forecasting: Diffusion Models: Bass Approach Look up Values for p and q Determine M (Size of Market) Execute Bass Model Interpret Bass Results Understand Market Situation Internet search: “Bass Model Excel”  Many free Excel models available Internet search: “Bass Coefficients”  Tables of p and q for different innovations © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 39. Forecasting: Diffusion Models © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 40. Forecasting: Triangulation of Multiple Forecasts Salesforce Estimate Triangulation Informed Estimate Forecast 2 Forecast 3 Sales History Forecast 1 Forecast = (W1 * Forecast 1) + (W2 * Forecast 2) + (W3 * Forecast 3) © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 41. Predictive Analytics: Trends Growth Demands Competitive Advantage Technology Data Availability Trends Driving Predictive Analytics Cloud computing, Cheap storage Terabytes of customer data Looking for growth opportunities Powerful tool to target niches © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 42. Predictive Analytics: Applications Fraud Detection Healthcare Customer Profitability Banking Collections Predictive Analytics Applications Cross-Selling Insurance Airlines Predict maintenance before failure FICO scores Predict which customers will pay “Customers who bought X bought Y” Identify profitable customers Predict fraudulent claims Predict at-risk patients Assign prices to policies © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 43. Data Mining: Process Target Data Pre- Processed Data Transformed Data Patterns Actionable Information Selection Pre-Processing Transformation Data Mining Interpretation Data Step Description Selection Select portion of data to target Pre-Processing Data cleansing; Removing duplicate records Transformation Sorting; Pivoting; Aggregation; Merging Data Mining Find patterns in data Interpretation Form judgments based on the patterns © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 44. Data Mining: Approaches Clustering Regression Association Rule Learning Classification Data Mining Approaches Search for associations in data Seek products purchased together Sorts data into different categories Have prior knowledge of patterns Spam filtering Identify patterns in data No prior knowledge of patterns Find relationships between variables © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 45. Balanced Scorecard: Balance Financial Measurement Non-Financial Measurement Topic Description Creators Kaplan and Norton Balanced Considers financial, as well as non-financial, measures © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 46. Balanced Scorecard: Perspectives Perspective Description and Example Customers Time; Quality; Service; Cost Example: Southwest: Delivering customer value Financial Profitability; Growth; Shareholder Value Example: L’Oreal: 5th in the world for value creation Innovation & Learning Ability to create value; Ability to improve efficiencies Example: Nvidia: Ability to efficiently launch products Internal Processes Core competencies for the market Example: Zynga: Competency in speed of development © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 47. Critical Success Factors: Types Environmental Temporal Industry Strategy Critical Success Factors Required areas of competency to succeed in the industry Verizon: Customer retention Strategies of individual companies Cupcakery: Niche strategy Respond to changes: PESTLE Solar Panels: Leasing options Address barriers to change Internal: Prepare for re-org © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 48. Critical Success Factors: Process List Candidate CSFs Select Final CSFs Identify Relevant KPIs Track Critical KPIs Establish Primary Objectives © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 49. Critical Success Factors: Process Step Description and Example Establish Objectives Establish primary objectives and strategy to achieve Market Development Example: Company decides on strategy of market development List Candidate CSFs Consider required competencies to achieve objectives Example: Create list of CSFs Select Final CSFs Identify top 3 – 5 CSFs Example: Focus on customer service List Candidate CSFs Select Final CSFs Identify Relevant KPIs Track Critical KPIs Establish Primary Objectives © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 50. Critical Success Factors: Process Step Description and Example Identify Relevant KPIs Assign one or more KPIs for each CSF Example: Measure customer satisfaction rates Track Critical KPIs Monitor KPIs to evaluate execution of CSFs Example: Track customer satisfaction over time List Candidate CSFs Select Final CSFs Identify Relevant KPIs Track Critical KPIs Establish Primary Objectives © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  • 51. Check for Understanding Topic Description Forecasting Apply different techniques to forecast future sales Predictive Know the concepts behind predictive analytics & data mining Scorecards Identify the concepts behind balanced scorecards Success Review how to set up critical success factors © Stephan Sorger 2016; www.StephanSorger.com; Ch.6 Business Operations 1
  翻译: