plan it

pter 02 Homework: Measuring Performance in Operations and Value Chains x 2. Check My Work (2 remaining) 3. O 4. O O 5. 6. O 7. a Spreadsheet A retail store sells a popular cosmetic called Devine and the store manager was given $80,000 by the corporate office to improve store performance any way she thinks best. The "base case" information is a price of $26 per bottle, a contribution margin of 0.50, a customer defection rate of 13 percent, and a repurchase frequency of five times a year. If these improvement funds could be used to (a) increase the contribution margin to 0.58 or (b) reduce the customer defection rate to 12 percent or (C) increase the repurchase frequency to seven times per year. Assume all other variables remain at the base case level for each of the three improvement options. Use the Excel template VLC to calculate the VLC for each option and summarize your answers using the table below. Round your answers to the cent. Contribution Defection Repurchase Margin Price Frequency Rate VLC in $ $26 0.50 5 13% $ (a) $26 0.58 5 13% $ (b) $26 0.50 5 12% $ (c) $26 0.50 7 13% $ What is the best way to use $80,000 in improvement funds? The best way to use the $80,000 in improvement funds is -Select- Check My Work (2 remaining) 0Icon Key ab Wrap Text y Paste . I U vv Merge & Center v B7 fx 0.4 A B C D E F G E 1 Value of a Loyal Customer Cengage Learning 2 Enter data only in yellow cells. Not for commercial use. 3 4 Revenue per unit $100.00 5 Percent contribution margin to profit and overhead 50.0% 6 Repurchase frequency (purchases/year) 0.25 7 Defection rate 0.4 8 Buyer's life cycle VLCI 2.50 $31.25 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35