Reference no: EM132914369
The data is about the store that sells wine and other alcohols beverages.
1) What is your recommendation regarding the price for Product No 2114 and the price for Product No 3804. Use the data you created to support your answer.
Data
Product No. = 2114
Sales Price = $12.99 Ave. Profit = $8.49 Total Profit = $1688.72
Sales Price = $15.99 Ave. Profit = $15.77 Total Profit = $583.37
Product No. = 3804
Sales Price = $9.99 Ave. Profit = $3.62 Total Profit = $567.75
Sales Price = $12.99 Ave. Profit = $7.11 Total Profit = $384.10
2) What is your recommendation regarding products that do not sell? There are 245 products that are unsold. Remember those products that not selling are on the store shelves (i.e. inventory) at the store.
3) Look at the days the store is closed {daily units sold = 0 (some are holidays 11/26; 12/25; 3/27; and some are not)}. There are 10 days the store is closed. What recommendations would you make to CEO Ms. Chen regarding the days the store is closed?
4) Based on your calculation of the store's daily fixed cost to break-even (-$101,431.69), what recommendations do you have for this store?