Final Project

1. Ideal situation: Setup the spreadsheet model correctly and answer (in a Word document) all questions in the first part of the case. I provide feedback and you continue working on the second part. (Note: To be able to do the second part, we need to learn the content in Module 3.) Then, by December 9, you consolidate your analysis of the first and second parts, put them in a report format with the instructions given (executive summary, etc.) and submit.

2. Expected situation: Setup the spreadsheet model and provide brief answers to part I questions within the Excel worksheet. I provide feedback, and you will be working on the rest of the questions until December 9. If there is any mistake in your progress submission, I will provide specific instructions on how to fix them, and in the following weeks after that, you may submit additional progress reports to make sure you are on the right track. I will provide feedback on your progress if you ask for it. 

3. Flexible situation: Read/understand the case, have some ideas about what method you will use to solve it and how you will set up the Excel model, and have a feasible plan that will help you finish the case by the final deadline. In this case, you can submit a draft or partially-complete Excel worksheet and I will provide feedback based on your submission. 

Case: Location, Distribution, and Capacity Expansion at a Beer Manufacturer

A Case Study of Location, Distribution, and Capacity Expansion Decisions at Anadolu Efes

Case Description and Objectives

This case study involves the application of linear programming and integer linear programming methods in solving a distribution and capacity planning problem at Anadolu Efes Beverage Group. Faced with intense competition and anticipated increase in beer demand that will surpass the current production capacity, the company wants to optimize its malt and beer distribution network and make capacity decisions over the next several years to supply for increased...