9373

Karen is in charge of internship assignments for all students at Northwestern. Karen understands that there is a limited supply of Northwestern students from either the College or the Analytics School. The four main locations she can assign to are Texas, California, DC, or New York; each having their own maximum demand requirements (i.e., Texas can accommodate no more than 750 students). Karen understands that the Analytics School must supply AT LEAST 1000 and the College AT LEAST 1,400 students, respectively and there is limited demand for them at the locations. The specific requirements are shown in the Excel sheet. You are tasked with creating an Excel Spreadsheet model and solving (optimizing) it two different ways, first to maximize the number of students assigned and the second to minimize total cost while meeting the minimum supply requirements.