University Of Chicago

BUSINESS 36106

READ THIS BEFORE YOU START  If you would like to receive partial credit, you can upload your files back to Canvas.  This is an open book, open notes exam; but individual work! No communication of any form with anything except the instructor is allowed.  You will need a computer running Microsoft Excel and the following Excel add-ins to solve the problems: Solver, PrecisionTree, @RISK  There are 13 pages in this exam (including the cover page), and 4 main problems, each with multiple parts. Each part will be graded independently; therefore, if you are not able to answer one part, it is better to move on to the next part and revisit the earlier part(s) later (time permitting).  Anything that you want to be graded should be legibly placed inside the indicated boxes below each question. If needed, you can use the back of each page, but again place anything that you want to be graded inside a box and indicate the part the box refers to.  You can work on the exam for during any 4.5-hour period within the window starting Thursyda (3/19) 8:00am and ending Tuesday (3/31) 11:59pm. Office Use Only 1 - out of 25 2 - out of 25 3 - out of 25 4 - out of 25 TOTAL - out of 100 2 1. The tables below present Solver’s Sensitivity Report for a linear optimization model for a catering company that decides on how many of each type of sandwiches to make for the Operations Workshops at Chicago Booth, while minimizing its total cost. In addition to the constraints listed below, the lower bound on the numbers of Tuna, Tuna/Ch, Ham, Ham/Ch, and Cheese sandwiches is 10, 12, 10, 12, and 0, respectively. Variable Cells Final Reduced Obje