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.1 Use analytical tools to comprehend, analyze, and critically evaluate complex and unstructured qualitative and quantitative business problems 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 $1 $0.50 The location has daily labor costs of $400.00, daily equipment cost of $150 and overhead cost of $300. Regular brew 450 $1 Corporative offices has suggested that introducing a new coffee variety called Green coffee (made using sustainable coffee and biodegradable cups) will help compete with other brands, bring in new customers concerned about sustainability and not cannibalize current demand. It is estimated that a 100 Green coffee 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). Beverage sold Price per beverage Material cost per $0.50 beverage Expresso 250 $2.50 $0.75 Does it increase the profit? Does it increase the labor productivity? Expresso 250 $2.50 $0.75 Cappuccino 350 $4 Cappuccino 350 $4 $1.50 $1.50 Does it increases the multifactor productivity? Is the introduction of the new green coffee a sound business decision? Green coffee 100 $5 $1.50

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 Exeel file, rename three workheets with nomenclature 1.1, 1.2 and 1.3 and solve one problem on each worksheet. Upload the Excel file to Blackboard (elass 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.1 Use analytical tools to comprehend, analyze, and critically evaluate complex and unstructured qualltative and quantitative business problems A Dunkin shop in San Antonio, Texas sells the following variety of coffce with the following daily demand The location has daily labor costs of $400.00, dilily equipment cost of $150 and overbead cost of $300. Corporative offices has suggested that introducing a new coffce varicty called Green coffee (made using sustainable coffee and biodegredable cups) will help compete with other brands, bring in new customers concerned about sustainability and not cannibalize current demand. it is estimated that a 100 Green coffee 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 (dhily). Does it increase the profit? Does it increase the labor productivity? Does it increneer the multifector productivity? Is the introduction of the new green coffee a sound business decision