Reference no: EM132340458

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.

Assignment - Supply (At Least)

Analytics School (AS) 1,000

College (COL) 1,400

Location - Demand (At Most)

Texas (TX) 750

California (CA) 650

DC (DC) 300

New York (NY) 80$

Cost $ per Student TX CA DC NY

AS 3000 2500 5000 4000

COL 4500 4000 1500 2000