Spreadsheet A retail store is a popular com called Devine and the store manager was given $120,000 by the corporate office to improve store performance any way the thinks best. The has information is a price of $26 per bottie, a contribution margin of 0.30, a customer defection rate of 15 percent, and a purchase frequency of our times a year of these improvement funds could be used to (o) increase the contribution margin to 0.34 or (b) reduce the customer defection rate to 12 percent or increase the purchase frequency to six times per year. Assume all other variables roman the base came level for each of the three improvement options Use the complete C to calculate the VLC for each option and summarize your answers using the table below. Round your answers to the nearest cent. Contribution Repurchase Detection Price Margin Frequency Rate VLC in $26 0.30 154 $ 208.10 (a) $26 0.34 4 159 $ 235.85 4 4 12% 0.30 (6) 259.90 $26 6 0.30 (c) 312.16 $26 15% S What is the best way to use $120,000 in improvement funds? The best way to use the $120,000 in improvement funds is option to ! Spreadsheet A retail store is a popular com called Devine and the store manager was given $120,000 by the corporate office to improve store performance any way the thinks best. The has information is a price of $26 per bottie, a contribution margin of 0.30, a customer defection rate of 15 percent, and a purchase frequency of our times a year of these improvement funds could be used to (o) increase the contribution margin to 0.34 or (b) reduce the customer defection rate to 12 percent or increase the purchase frequency to six times per year. Assume all other variables roman the base came level for each of the three improvement options Use the complete C to calculate the VLC for each option and summarize your answers using the table below. Round your answers to the nearest cent. Contribution Repurchase Detection Price Margin Frequency Rate VLC in $26 0.30 154 $ 208.10 (a) $26 0.34 4 159 $ 235.85 4 4 12% 0.30 (6) 259.90 $26 6 0.30 (c) 312.16 $26 15% S What is the best way to use $120,000 in improvement funds? The best way to use the $120,000 in improvement funds is option to