User Account

All Pages

What was the overall response rate

Assignment Help Marketing Management
Reference no: EM131895696

Question: RFM Segmentation and Lift/Gains Charts

Objectives: The objectives of this exercise are to: 1) learn how to develop a RFM segmentation using SPSS, 2) practice creating and interpreting a cumulative lift chart and a gains chart to evaluate the effectiveness of a segmentation model, and 3) learn how to estimate the expected profitability of a campaign that uses a RFM segmentation.

Assignment: There are four parts to Homework 3. In Part 1 you will learn how to assign customers to RFM segments using SPSS. In Part 2/3 you will practice creating three charts in Excel to evaluate the RFM Segmentation model: 1) Cumulative Lift Chart, 2) Cumulative Gains Chart and 3) a Cumulative Profits chart. A preformatted Excel workbook is attached. In Part 4, you will answer 9 additional questions based on the data that you compiled in Parts 2-3.

If you need assistance with this assignment, then you should consult the video of the most recent Webex session and several videos in the Fox Video Vault that are relevant to this assignment.

Available Videos in Fox Video Vault

• Evaluating Models: Lift Analysis

• Evaluating Models: Gains Analysis

• Evaluating Models: Profit Analysis

There is one additional resource that you also can consult for additional assistance.

• Using Lift Gains to Evaluate Models.pdf - Provides description of how to create and use lift/gains charts.

Part 1: Develop a RFM segmentation model using SPSS.

A RFM segmentation was already developed during the prior Webex session. SPSS is not needed to complete the remainder of the assignment.

Part 2: Conduct a Lift/Gains Analysis of the RFM segmentation model.

Open the following file, ‘Tuscan RFM Segmentation Data.xlsx'. Copy the data from last week's SPSS analysis (Part 1) and paste the data into the Lift/Gains Data.

Complete the following tables in the ‘Lift/Gains Data' tab in the workbook.

• Lift table (Remember to Sort the RFM segments from High to Low on response rate of each segment)

• Cumulative Lift table

• Cumulative Gains table.

Part 3: Conduct a Profitability Analysis of the RFM segments

Complete the Profitability table in the ‘Lift/Gains Data' tab in the workbook. Use the following data to determine operating profits:

• Cost to produce and mail a catalog = $1

• Variable costs = 50% (of sales revenues)

• Average order (of those who order) = $104.24

Part 4: Answer the questions on the ‘Questions' worksheet in ‘Tuscan RFM Segmentation Data.xlsx'

1: What was the overall response rate when all 96,551 customers were contacted?

2: What is the breakeven response rate (BERR) given the available cost data?

3: How many RFM segments have response rates exceeding the BERR?

4: Across all of the segments that exceeded the BERR
how many customers were contacted?

5: Across all of the segments that exceeded the BERR how many buyers were there?

6: What are the following metrics if all 96,551 customers were mailed?

7: What are the following metrics if only the customers in those segments that exceeded the BERR were mailed?

8: Complete the following summary table.

 

Total Customers Contacted

Cumulative
Response Rate

Acquisition Costs
per Customer

Operating
Profit as % of Revenues

ROI

No Model (All Customers Contacted)

 

 

 

 

 

RFM Segmentation Model (Segments that exceed BERR)

 

 

 

 

 

Index

 

 

 

 

 

9: Based on your analysis of the summary table from Question 8, would you recommend using the RFM segmentation? Why?

Information related to above question is enclosed below:

Attachment:- Files.rar

Verified Expert

The task file used the dataset sent by the student and calculations regarding profitability, lift gain, cumulative lift decile was performed for both breakeven and total customers. The profitability, return on investment were also estimated and reported.

Reference no: EM131895696

Questions Cloud

What benefit to consumers of price increasing in hot weather : Based on economics as studied in this course, what is the benefit to consumers of price increasing in hot weather?
The new deal in employment : The New Deal is a series of federal and public program to relief, recovery and reform unemployment population. One important aspect of the employment
Retention for american airlines and delta : Do you have any predictions about attraction and retention for American Airlines and Delta?
Benefits offered by vanguard : Which 3 benefits offered by Vanguard do you believe are most important to deliver work-life balance to employees?
What was the overall response rate : The objectives of this exercise are to: 1) learn how to develop a RFM segmentation using SPSS, 2) practice creating and interpreting a cumulative lift chart.
How vanguard employee benefits are aligned : Describe how Vanguard's employee benefits are aligned with its business strategy ( meaning, which benefits are consistant with the behaviors Vanguard
Address performance deficits or policy violations : Have you seen an example in your organization where HRM and department managers partnered effectively to address performance deficits or policy violations?
What were the key findings and conclusion from the research : What were the key findings and conclusion from the research? How would this theory explain the key findings or conclusion of the research in the article?
Common employee development methods include job rotation : Common employee development methods include job rotation, assistant-to positions, committee assignments, lecture courses and seminars, simulations

Reviews

Write a Review

Marketing Management Questions & Answers

  Integrated marketing communication

Developing an IMC plan of Amazon that aims to create awareness and knowledge amongst Singaporean  consumers of the ethics involved in buying clothing made from Bangladeshi factories  .

  Multiple choice questions on e-commerce

The assignment in Computer Science or Information Technology is about multiple choice questions, particularly in e-commerce. Questions such as types of e-commerce websites, commercial websites, disintermediation, Platform for Piracy, the data that ca..

  Balanced scorecard for red lobster

The assignment in marketing is about Red Lobster, which is one US and Canada's most loved seafood restaurant. It has hundreds of outlets in US and Canada and it now wants to expand further. The approach adopted by Red Lobster has been discussed in fu..

  Marketing plan - marketing audit, swot and smart report

The assignment in marketing is about preparing a marketing plan. As part of marketing plan, the SWOT analysis, assessing the competitive position, identifying critical competitive issues, marketing objectives, strategy and actions have been suggested..

  Marketing plan

Marketing deals with preparing a marketing plan for either an existing product or a new product. Various aspects about launching a new product into the market are discussed ranging from the industry the product belongs to, goals and vision of the com..

  Yamato corporation analysis - harvard case study

Please refer to the PDF for the Case Study and questions.The case study from Harvard Business School is about Yamato Corporation, a parcel delivery company which provides door to door delivery in Japan.

  Marketing plan - create a new product

The assignment in marketing is about competitive analysis for a new product namely "heated insoles". These heated insoles can be put in shoes and they can protect the wearer's feet by keeping them warm during cold winters.

  Report on digital marketing strategy for a website

Promotion strategies of  the one's own developed website

  Integrated marketing campaign of mccafe

Integrated marketing campaign for McDonald's McCafe. McCafe has been launched in Canada. This is a case study which involves the use of digital marketing and social media marketing apart from regular marketing such as TV and radio. All these more are..

  New product development at adidas

In this paper, the researcher also determines the different kind of practices used by Adidas to manufacture shoes for its customers.

  Managing services in competitive environment

Services can be defined as separately identifiable, intangible activities which provide want-satisfaction when marketed to household consumers and/or industrial users.

  Prepare a marketing plan

A marketing plan is an essential tool for any marketer, providing direction for a brand, product or organization. A marketing plan describes the marketing environment, marketing objectives and marketing strategies.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd