1. A class-based storage system is to be used in a storage area you have been tasked to design. Management would like to position the goods in the storage areas so that the costs of material handling are minimized. Management has provided the following data regarding the product classes that need to be stored. The figure below the table shows an overhead view of the storage areas with storage areas where classes of products can be stored. There is a shipping area and receiving area that are separate (see image below). Due to safety concerns, product class 4 must be stored as far away from shipping and receiving (e.g. can only be stored in areas 13, 14, 15, or 16. In addition, product class 2 must be stored in grides 1-8 to be near shipping and receiving. Product Shipping Receivin Class Satitl Tfi:s : Trips 1 5 147 52 2 5 121 24 3 3 95 45 4 2 22 5 5 1 32 12 a. (4) Write the MIP/Binary Program mathematical model (include your objective function, constraints. and decisions variables as variables) b. (3) Using a type of solver (Excel, Lindo, etc.), determine where the product classes should be stored to minimize travel distance (use the distance based objective function from the course slides). [Submit your Excel file on Canvas along with PDF answers]