4. A subscription wine club service, Winc, is planning to launch four monthly wine packages. They...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. A subscription wine club service, Winc, is planning to launch four monthly wine packages. They intend to hire a celebrity wine expert to design the combinations offered in the four new packages: Starter, Discover, Sophisticated, and Provocative. Winc will spend $60,000 to hire the wine expert, and $360,000 on marketing. The prices and variable costs of the monthly meal packages are: Pstarter = $25, VC = $12; P Discover $45, VCDiscover = $16; Psophisticated $85, VCSophisticated = $40; and PProvocative = $120, VCProvocative = $62. They expect to sell the packages in the ratio 4:5:7:3, respectively. The total customer base of Winc is 75,000 customers. a. Calculate the breakeven quantity for each model. [4] b. Assume that customers who buy certain packages don't switch to different ones, but the probability of staying with Winc from month to month has been 65%, 72%, 68%, and 85%. Assuming a discount rate of 4% monthly, calculate the CLV for customers in each meal plan segment. Use the total contribution for each meal plan from part (a) as the margin in each case and remember to subtract the AC (which is the FC/customer base). [4] If Winc has $300,000 to spend on increasing the retention rate in the segment with the highest CLV, what would the retention rate need to increase to, in order to justify spending that amount on retention. (Hint: Number of customers would be the sales mix fraction times the total customer base. Change M by subtracting $300,000/number of customers in that segment. Rearrange the CLV formula in terms of r gives the following). [3] New r = (CLV + AC) (1 + d) (New M + CLV + AC) d. Suppose that instead of spending on retention, Winc would like to increase the number of customers from its highest CLV segment. It is considering an ad buy for the $300,000, which will be viewed by 5,000 potential customers in that segment. What percent of the targeted customers would need to join in order for the acquisition spending to be worthwhile? Add a sentence to explain what your answer means. [3] Acquisition Spending Breakeven Acquisition Rate = CLV e. Again, just looking at the highest CLV segment, suppose that instead of spending the whole $300,000 on the ad buy, Winc would like consider spending some funds on ads and some on coupons. Assuming that option 1) spending the $300,000 on advertising would have brought in 1,500 customers, option 2) spending $175,000 on ads, and offering a $40 coupon would draw 2,500 new customers, and option 3) spending $175,000 on ads, and offering a $30 coupon would draw 1,800 new customers. iii. Calculate the new CLV for each option [3]: 1. $300,000 on ads 2. $175,000 on ads and a $40 coupon 3. $175,000 on ads and a $30 coupon C. Hint: (Ad spending/number who switched) + coupon). | iv. Calculate the total segment value for those new customers for each option from part (i). (Hint: CLV* number of new customers). [3] 4. A subscription wine club service, Winc, is planning to launch four monthly wine packages. They intend to hire a celebrity wine expert to design the combinations offered in the four new packages: Starter, Discover, Sophisticated, and Provocative. Winc will spend $60,000 to hire the wine expert, and $360,000 on marketing. The prices and variable costs of the monthly meal packages are: Pstarter = $25, VC = $12; P Discover $45, VCDiscover = $16; Psophisticated $85, VCSophisticated = $40; and PProvocative = $120, VCProvocative = $62. They expect to sell the packages in the ratio 4:5:7:3, respectively. The total customer base of Winc is 75,000 customers. a. Calculate the breakeven quantity for each model. [4] b. Assume that customers who buy certain packages don't switch to different ones, but the probability of staying with Winc from month to month has been 65%, 72%, 68%, and 85%. Assuming a discount rate of 4% monthly, calculate the CLV for customers in each meal plan segment. Use the total contribution for each meal plan from part (a) as the margin in each case and remember to subtract the AC (which is the FC/customer base). [4] If Winc has $300,000 to spend on increasing the retention rate in the segment with the highest CLV, what would the retention rate need to increase to, in order to justify spending that amount on retention. (Hint: Number of customers would be the sales mix fraction times the total customer base. Change M by subtracting $300,000/number of customers in that segment. Rearrange the CLV formula in terms of r gives the following). [3] New r = (CLV + AC) (1 + d) (New M + CLV + AC) d. Suppose that instead of spending on retention, Winc would like to increase the number of customers from its highest CLV segment. It is considering an ad buy for the $300,000, which will be viewed by 5,000 potential customers in that segment. What percent of the targeted customers would need to join in order for the acquisition spending to be worthwhile? Add a sentence to explain what your answer means. [3] Acquisition Spending Breakeven Acquisition Rate = CLV e. Again, just looking at the highest CLV segment, suppose that instead of spending the whole $300,000 on the ad buy, Winc would like consider spending some funds on ads and some on coupons. Assuming that option 1) spending the $300,000 on advertising would have brought in 1,500 customers, option 2) spending $175,000 on ads, and offering a $40 coupon would draw 2,500 new customers, and option 3) spending $175,000 on ads, and offering a $30 coupon would draw 1,800 new customers. iii. Calculate the new CLV for each option [3]: 1. $300,000 on ads 2. $175,000 on ads and a $40 coupon 3. $175,000 on ads and a $30 coupon C. Hint: (Ad spending/number who switched) + coupon). | iv. Calculate the total segment value for those new customers for each option from part (i). (Hint: CLV* number of new customers). [3]
Expert Answer:
Answer rating: 100% (QA)
a To calculate the breakeven quantity for each model we need to find the quantity at which the total contribution equals the fixed costs For the Start... View the full answer
Related Book For
Advertising and Integrated Brand Promotion
ISBN: 978-0538473323
6th edition
Authors: Thomas O'Guinn, Chris Allen, Richard Semenik
Posted Date:
Students also viewed these finance questions
-
A subscription hair service, WigzMax, is planning to launch a new line of wigs. They intend to hire a celebrity hair stylist to make the new line of four new models: Halle, Nia, Janet, and Toni....
-
A table of properties for methyl chloride lists the saturation pressure as 116.7 psia at 100oF. At 100oF, this table also lists hfg = 154.85 Btu/lbm, and vfg = 0.86332 ft3/lbm. Estimate the...
-
Lance Berkman is the controller of Saturn, a dance club whose year-end is December 31. Berkman prepares checks for suppliers in December, makes the proper journal entries, and posts them to the...
-
a. Rejection region. b. Nonrejection region. c. Critical value(s). d. Significance level. e. Construct a graph similar to that in Fig 9.2 on page 350 that depicts your results from parts (a)(d). f....
-
Chase Publishing was disappointed with the financial textbook and decided to purchase the trademark from a well-known record store for $\$ 250,000$. How can the cost of the trademark be accounted for...
-
Powers Rental Service had the following items that require adjustment at year-end. a. Earned $6,420 of revenue from the rental of equipment for which the customer had not yet paid. b. Interest of...
-
Aca Pool Co . has sent check number 4 4 4 4 , dated August 1 , 2 0 1 8 , to Deakin Pool Supplies in payment of invoice # 1 2 0 7 , for $ 1 , 5 4 2 . 5 0 . Assume a paper - based accounting system....
-
A tangent to the hyperbola locus of the midpoint of PQ is x y + 62 2 a 2 - a 6 2 -=1 cuts the ellipse + ,2 -=1 in P and Q. Prove that the
-
Our longest uninterrupted economic expansion took place mainly in the decade of the ______. a) 1940s b) 1950s c) 1960s e) 1980s d) 1970s f) 1990s
-
Employment discrimination results in the __________ of our labor force.
-
The main factor in finally bringing us out of the Great Depression was _________.
-
Full employment implies an unemployment rate of about ______ percent.
-
Since the end of World War II there have been _________ recessions.
-
Brown Industries plans to decrease a $380 petty cash fund to $165. The current balance in the account includes $125 in receipts and $345 in currency. The entry to reimburse and reduce the size of the...
-
The area of a rectangle is 30 cm 2 and its perimeter is 26 cm. Find the length and width of the rectangle.
-
What does it mean to say that culture is "invisible"? Explain how this invisible force serves to restrict and control the activities of advertisers.
-
Describe the various factors that produced an explosion of advertising activity in the P. T. Barnum era.
-
Why is NASCAR a good affiliation for the Old Spice brand?
-
What are the six books of original entry?
-
Why do we have day books? Why don't we just enter every transaction directly into the appropriate ledger accounts?
-
Where is the other side of the double entry for all these expense postings to the ledgers recorded?
Study smarter with the SolutionInn App