Business Analytics Simulation Project

C​‌‍‍‍‌‍‍‌‌‍‌‍‍‌‌‌‍‍‍‍​ollaboration and consultation of external resources is authorized and encouraged. However, this is an individual assignment and student submissions must be entirely the student’s original work. Using online or past student’s materials for these problems is prohibited. Submit homework that is neat, organized, and legible in a single PDF. Typing solutions is recommend and encouraged; use MS Word equation editor (“ALT” + “=” is the hotkey) when necessary. If you hand-write solutions, scan them into a single PDF (use a scanner or high-quality camera; you can put the images into a Word document on separate pages and save-as PDF). Take screen-shots of relevant Excel work (SNIP feature or copy and paste as picture). Embed these with your solutions on the PDF. ​‌‍‍‍‌‍‍‌‌‍‌‍‍‌‌‌‍‍‍‍​Show your models, output, etc. as necessary. Submit your Excel files along with PDF to show your individual work. Naming convention for worksheets within the Excel workbook is ”Problem x.x” or “Problem x.xa”, etc. Please copy and paste the given problem data in its corresponding solution tab on your solution spreadsheet. Put your answer in words with the correct units, don’t just highlight it or point to it. Unless otherwise specified, use 1000 simulation trials. Problem 1 (25 points): Textbook problem 11.1 (No data file). Problem 3 (25 points): Textbook problem 11.11 (No data file). Problem 4 (25 points): Textbook problem 11.19 (OuRx.xlsx Download OuRx.xlsx). Problem 5 (25 points): Textbook problem 11.Case Problem (FourCorners.xlsx Download FourCorners​‌‍‍‍‌‍‍‌‌‍‌‍‍‌‌‌‍‍‍‍​.xlsx).