Calculate churn in terms of customer numbers

Assignment Help Business Economics
Reference no: EM133079343

For this assignment, let's assume the following: 

  • Gross Margin for the firm is 30%. We need this to calculate the margin the firm would earn on the revenue generated from their customers.
  • Assume annual marketing costs are $300,000 total.
  • A customer is considered retained if they have purchased from the firm in the past year.
  • The firm spent $500,000 to acquire all of these customers in 2019-2020.
  • The firm's discount rate is equal to its weighted average cost of capital, which is 10%.
  1. Calculate Churn in terms of customer numbers and revenue.
  2. Calculate the CLV for each customer. Use 1-churn to be the retention rate.
  3. Create CLV categories with cutpoints at the 25th percentile and 75th percentile. This should give you three groups (0-24.99, 25-74.99, 75 +). Calculate customer equity for these groups. What is average customer equity in each group?
  4. Assume we have a Markov transition matrix that looks like this:

 

 

High Effort

$250000

 

 

 

Low Effort

$50000

 

 

Future CLV Grouping

 

 

 

Future CLV Grouping

 

 

CLV Low

CLV Med

CLV High

 

 

 

CLV Low

CLV Med

CLV High

Current CLV grouping

CLV Low

0.65

0.25

0.1

 

Current CLV grouping

CLV Low

0.8

0.15

0.05

CLV Med

0.25

0.5

0.25

 

CLV Med

0.2

0.6

0.2

CLV High

0.1

0.15

0.75

 

CLV High

0.1

0.2

0.7

How many customers would be in the respective groups based on the above Markov matrices? Would what would the return on the marketing investment be for low effort and high effort marketing, if we base CLV on the average of the different groupings (calculated above). Should the firm invest in low effort or high effort? Explain. 

5. Create two Pivot Tables to show: a) How average CLV changes across customer frequency groups, and b) How average CLV changes across customer recency groups. (You will need to create grouping variables on frequency and recency. What would be good cut points for these data? Recall that frequency is numerical and recency relates to days since purchase, so your categories should make sense from that perspective). 

6. If you were working for the firm where this data was generated, how would you advise them to react to this information in terms of marketing activities? Provide a one-page memo to your fictitious manager outlining your rationale for how the firm should react to your analysis.

Reference no: EM133079343

Questions Cloud

Dr chew study strategy videos : What are three things that you found interesting about Dr. Chew's study strategy videos?
What are the fixed overhead costs allocated to the products : Variable Overhead (VOH) is allocated at 50% of Direct Labor costs. What are the Variable Overhead costs allocated to the three products
Making production decisions : Do firms need to consider sunk costs when making production decisions? Why or why not? Please answer this question with clarity and a detailed explanation.
Control of organization data assets : Data governance involves the supervision, monitoring, and control of an organization's data assets.
Calculate churn in terms of customer numbers : Gross Margin for the firm is 30%. We need this to calculate the margin the firm would earn on the revenue generated from their customers.
Find optimal consumption bundle : Suppose Henry views current and future consumption as one- to-on complements. Find his optimal consumption bundle. Show your work.
Opportunities and threats-blue cross blue shield : This analysis is based on your review of the organization's website, research sources with information about the organization, social media sites,
What is the market demand : (1) What is the market demand, Q? (Note: Q should be equal to q1 + q2.)
Should the company make or buy the tables : The fixed overhead costs allocated to the cabinets are common to all items produced in the factory. Should the company make or buy the tables

Reviews

Write a Review

Business Economics Questions & Answers

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

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!

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