Word O Sea Case Study Dunkin Fall 2020 fv A 20 S Mailings Review Insert Draw Design Layout References 2. USING EXCEL TO SOLVE BUSINESS PROBLEMS. As part of your final project, individually you will apply Excel (business computer tool) solving three case studies. Concept and tools leamed in our class will be applied to evaluate each case. Create an Excel file, rename three worksheets with nomenclature 2.1, 2.2 and 2.3 and solve one problem on each worksheet. Upload the Excel file to Blackboard (final project) Please read the following business cases studies and apply the suggested analytical tools to make sound business decision that will be beneficial to Dunkin 2.1 Evaluate Different solutions Use Excel to solve the problem (Evaluates sources of information according to appropriate criteria and perform calculations) (Urilize electronic spreadsheets to capture and analyze data) A Dunkin shop in San Antonio, Texas sells the following variety of coffee with the following daily demand Beverage sold Price per beverage Material cost per beverage Regular brew 450 S1 $0.50 Expresso 250 $2.50 $0.75 Cappuccino 350 $4 $1.50 The location has daily labor costs of $400.00, daily equipment cost of $150 and overhead cost of 5300 Corporative offices has suggested that introducing a new coffee variety called Mocha Frappuccino will help compete with other brands, bring in new customers and not cannibalize current demand. It is estimated that a 100 Mocha Frappuccino will be sold daily with a price of $5.00 and material cost of $1.50 per unit. Assuming that the new equipment is purchased before the new product is added is added to the menu. The overall costs of this location will increase, with new equipment cost increasing to $200 (daily), and new overhead cost increasing to $350 (daily) Regular brew Expresso Cappuccino Beverage sold 450 $1 250 $2.50 350 54 Price per beverage Material cost per hevera Mocha Frappuccino 100 SS $0.50 $0.75 $1.50 $1.50 Does it increase the profit? Does it increase the labor productivity? TA