3. A subscription food box service, GoldBelly, is planning to launch a new line of boxes....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. A subscription food box service, GoldBelly, is planning to launch a new line of boxes. Each month the subscriber will receive (or be able to send) a particular type of food item from the best restaurants around the USA. The four boxes they are going to add are cookie, ice-cream, pie, and cake. It will cost the company about $50,000 to coordinate the boxes, and $125,000 in marketing. The prices and variable costs of the models are: Pcookie = $50, VCcookie = $15; Picecream = $90, VCicecream = $25; Ppie = $65, VCpie = $18; and Pcake= $75, VCcake = $22. They expect to sell the models in the ratio 7:4:5:3, respectively. The total customer base of GoldBelly is 10,400 customers. a. Calculate the breakeven quantity for each model. [4] b. Assume that customers usually by one plan or the other and the probability of staying with GoldBelly from month to month has been 80%, 73%, 64%, and 59% respectively. Assuming a discount rate of 5%, calculate the CLV for customers in each subscription. (Hint: Use the total contribution for each subscription from part (a) as the margin in each case, and remember to subtract the AC.) [4] If Gold Belly has $250,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. Find the new M by subtracting $250,000/number of customers in that segment. Rearranging 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, GoldBelly would like to increase the number of customers from its highest CLV segment. It is considering an ad buy for the $250,000, which will be viewed by 2,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 C. Breakeven Acquisition Rate = CLV e. Again, just looking at the highest CLV segment, suppose that instead of spending the whole $150,000 on the ad buy, GoldBelly decided to spend a portion on ads, and some towards coupons. Of course, not everyone will redeem the coupon, but they expect to gain at least 600 of those customers with an offer of a $10 coupon, or at least 4,500 if they offer a $5 coupon. Assuming that spending the $150,000 on advertising would have brought in 3,000 customers: i. Calculate the new CLV for each option [3]: 1. $150,000 on ads 2. $100,000 on ads and a $10 coupon 3. $115,000 on ads and a $5 coupon (Hint: AC for the ones with coupons will be (Ad spending/number of customers who switched) + coupon. AC is the only change in each case). ii. Calculate the total segment value for those new customers for each option from part (1). (Hint: CLV* number of new customers). [3] 3. A subscription food box service, GoldBelly, is planning to launch a new line of boxes. Each month the subscriber will receive (or be able to send) a particular type of food item from the best restaurants around the USA. The four boxes they are going to add are cookie, ice-cream, pie, and cake. It will cost the company about $50,000 to coordinate the boxes, and $125,000 in marketing. The prices and variable costs of the models are: Pcookie = $50, VCcookie = $15; Picecream = $90, VCicecream = $25; Ppie = $65, VCpie = $18; and Pcake= $75, VCcake = $22. They expect to sell the models in the ratio 7:4:5:3, respectively. The total customer base of GoldBelly is 10,400 customers. a. Calculate the breakeven quantity for each model. [4] b. Assume that customers usually by one plan or the other and the probability of staying with GoldBelly from month to month has been 80%, 73%, 64%, and 59% respectively. Assuming a discount rate of 5%, calculate the CLV for customers in each subscription. (Hint: Use the total contribution for each subscription from part (a) as the margin in each case, and remember to subtract the AC.) [4] If Gold Belly has $250,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. Find the new M by subtracting $250,000/number of customers in that segment. Rearranging 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, GoldBelly would like to increase the number of customers from its highest CLV segment. It is considering an ad buy for the $250,000, which will be viewed by 2,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 C. Breakeven Acquisition Rate = CLV e. Again, just looking at the highest CLV segment, suppose that instead of spending the whole $150,000 on the ad buy, GoldBelly decided to spend a portion on ads, and some towards coupons. Of course, not everyone will redeem the coupon, but they expect to gain at least 600 of those customers with an offer of a $10 coupon, or at least 4,500 if they offer a $5 coupon. Assuming that spending the $150,000 on advertising would have brought in 3,000 customers: i. Calculate the new CLV for each option [3]: 1. $150,000 on ads 2. $100,000 on ads and a $10 coupon 3. $115,000 on ads and a $5 coupon (Hint: AC for the ones with coupons will be (Ad spending/number of customers who switched) + coupon. AC is the only change in each case). ii. Calculate the total segment value for those new customers for each option from part (1). (Hint: CLV* number of new customers). [3]
Expert Answer:
Answer rating: 100% (QA)
GoldBelly Subscription Boxes Part a Breakeven Quantity We can use the breakeven formula to calculate the quantity needed for each model to cover its costs BreakEven Quantity BEQ Total Fixed Costs Cont... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
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....
-
This question is optional and will not be graded. We are interested in examining factors determining women's labor force participation. Use the data set mroz. dta and the do file ps5.2. do to answer...
-
What are some of the most important current events that are part of the general subject matter of international economics? Why are they important? How do they affect the economic and political...
-
W. Duellman and J. Kohler explore a new species of frog in the article "New Species of Marsupial Frog (Hylidae: Hemiphractinae: Gastrotheca) from the Yungas of Bolivia" (Journal of Herpetology, Vol....
-
Ajax Savings Bank has certificate of deposit notes with a face value of $\$ 10,000$ with a $10 \%$ interest rate compounded daily. What is the current market price of the $\mathrm{CD}$ if the term of...
-
Clothes, Inc., has an average annual demand for red, medium polo shirts of 25,000 units. The cost of placing an order is $80 and the cost of carrying one unit in inventory for one year is $25....
-
Please indicate each account if its: - Balance sheet or income statment - is it credit or debit - what is the properties for each account as follow:cash, prepaid expenses, long term investments,...
-
5. C. d. e. a. b. 7 a. b. b. C. d. e. 6. Find the value of x. C. d. e. Find the value of x. log 3x--4 5 a. b. logs 7 7. Simplify the expression. log 3 32 x-1 x-81 x-3 c. x=5 d. x=-5 c. x-0 2 4 6 3...
-
Give examples of commonly used priority rules.
-
Describe scheduling needs in job shops.
-
What very important lesson does the constant service time model provide for managers?
-
What metrics are used to help managers analyze waiting lines?
-
Interpret computer solutions of linear programming problems.
-
"When Joe didn't have renter's insurance, he was very careful not to leave candles lit in his apartment and locked the door when he left. Now that he has renter?s insurance, he typically leaves...
-
Use a calculator to evaluate the expression. Round your result to the nearest thousandth. V (32 + #)
-
Jason and Mary Wells, friends of yours, were married on December 30, 2012. They know you are studying taxes and have come to you with a question concerning their filing status. Jason and Mary would...
-
On July 1, 2012, Ted, age 73 and single, sells his personal residence of the last 30 years for $365,000. Ted's basis in his residence is $35,000. The expenses associated with the sale of his home...
-
Ken (age 31) and Amy (age 28) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of these items must be used to...
-
A change in chromosome structure that does not involve a change in the total amount of genetic material is a. a deletion. b. a duplication. c. an inversion. d. none of the above.
-
The term endopolyploidy refers to the phenomenon of having a. too many chromosomes. b. extra chromosomes inside the cell nucleus. c. extra sets of chromosomes in certain cells of the body. d. extra...
-
Which of the following is a type of plasmid? a. F factor (fertility factor) b. R factor (resistance plasmid) c. Virulence plasmids d. All of the above are types of plasmids.
Study smarter with the SolutionInn App