4. A subscription food delivery service, Extra Tasty, is planning to launch four precooked meal packages. They intend to hire a celebrity chef to develop the recipes offered in the four new packages: Vegan, Glu-free, Meatlove and Keto. Extra Tasty will spend $15,000 to hire a top chef to create the recipes, and $225,000 on marketing. The prices and variable costs of the monthly meal packages are: Pegan- $312, Vein - $70; Patree $280, Vou free $62; Peatlove=$336, VCMcartone = $80; and Preto - S240, VCKeto-$48. They expect to sell the packages in the ratio 4:5:7:3, respectively. The total customer base of Extra Tasty is 15,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 Extra Tasty from month to month has been 75%, 82%, 68%, and 85%. Assuming a discount rate of 4% annually, calculate the CV for customers in each meal plan segment. Use the total contribution for each meal plan from part (a) as the annual) margin in each case, and remember to subtract the AC (which is the FC/customer base). (4) C. If Extra Tasty 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,000umber of customers in that segment. Rearrange the CV formula in terms of gives the following). (3) (CLV AC) (1 + d) (M + CLV + AC) d. Suppose that instead of spending on retention, Extra Tasty 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 500 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 e. Again, just looking at the highest GLV segment, suppose that instead of spending the whole $300,000 on the ad buy, Extra Tasty would like to consider spending some of the 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 Hint: (Ad spendingumber who switched) + coupon)