Spreadsheet

A retail store sells a popular cosmetic called Devine and the store manager was given $$100,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\mathrm{.}50,$ a customer defection rate of $12$ percent, and a

repurchase frequency of five times a year. These improvement funds could be used to $($a$)$ increase the contribution margin to $0\mathrm{.}55$ or $($b$)$ reduce the customer

defection rate to $8$ percent or $($c$)$ increase the repurchase frequency to six 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 nearest cent.

What is the best way to use $$100,000$ in improvement funds?

The best way to use the $$100,000$ in improvement funds is

Hide Feedback

Incorrect

$0=$ Icon Key

Problem $2-53$ Algo $($Analytics in Operations Management$)$