OPRE 3310: Homework Assignment 3 PLEASE PROVIDE EXPLANATIONS FOR ALL YOUR ANSWERS TO ENSURE YOU CAN RECEIVE PARTIAL CREDIT. Q1 (15 points) A concrete company transports concrete from three plants, 1, 2 and 3, to three construction sites, A, B and C. The plants can supply the following quantity of concrete (in tons) per week: Plant Supply (capacity) 300 300 100 The requirements of the sites, in number of tons per week, are: Construction site Demand (requirement) A 200 B 200 300 The cost of transporting I ton of concrete from each plant to each site is shown in the table below (in dollars per ton). Sites To A B From 1 3 Plants 7 5 9 5 5 How much concrete should the company ship from each plant to each construction site to fill the demand while minimizing the transportation cost? a) List and explain carefully what the decision variables are. (3 points) Page 1 of 3OPRE 3310: Homework Assignment 3 b) Write out the objective function. (2 points) c) Write out the constraints. (6 points) d) Solve the LP using Excel and report the optimal solution. (4 points) Page 2 of 3