a. Create an MS Word solving the three analytical problems marked as 1.1, 1.2 and 1.3.. Upload the MS Word file to Blackboard (class project) b. Create an Excel file, rename three worksheets with nomenclature 1.1, 1.2 and 1.3 and solve one problem on each worksheet. Upload the Excel file to Blackboard (class 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. 1.2 Apply relevant data to formulate alternative solutions (Hint. Review problem 3 from Chapter 2 in your textbook) To address the waiting problem in this Dunkin location the manager is offered several options by the general office to expedite coffee preparation Option 1 Hiring extra employees and buying prepackaged ingredients 2 Buy system that aids employees improve time preparation on coffee 3 Buy fully automatic system to prepare all types of coffee to reduce preparation time and reduces waste Fixed cost (monthly) $2000 $50,000 $100,000 Variable cost per customer $2 $1 $0.50 What would be the customer traffic required (monthly) for this store to select each option just based on the costs. Extra points: draw a line chart using Excel which explains the break even point analysis.

What would be the customer tenfiic required (monthly) for this store to select each option just based on the costs. Bxtra points: din a line chart using Eircel which explains the brenk even point analysis