1. Read the case study instructions (the case study file)

2. Create your case study in MS Word (provide me a report in the standard format that we have used for the class). Also, you will have to submit a working Excel model in order to receive 50% credit for this case study. 


I have provided a presentation of mine on spreadsheet modeling / optimization to help you work with Solver in Excel.