For problems below: declare your decision variables, objective function and constraints. Write these functions using the data provided, e.g. 2X1 + 3X2

Consider a supply chain consisting of suppliers, terminals and customers. Shipments from suppliers go to terminals, and from terminals to customers. For this distribution problem, supply, and demand data, and direct shipping costs from suppliers to terminals and from the terminals to costumers are given in the tables below.

Consider a supply chain consisting of suppliers, terminals and customers. Shipments from suppliers go to terminals, and from terminals to customers. For this distribution problem, supply, and demand data, and direct shipping costs from suppliers to terminals and from the terminals to costumers are given in the tables below. Supply 15 3 1 Terminal A B 5 4 1 2 5 5 6 1 1 2 3 4 15 Supplier Customer 2 5 1 15 Terminal 1 4 2 17 A B Demand 3 20 15 15 (a) Formulate a mathematical model which will provide a transportation schedule that minimizes the cost of meeting customers' demands. (1 point) (b) Solve the mathematical model of part (a) using Excel. (3 point) (c) Add the following restrictions to your model: (1 point) i. Terminal A has a capacity of 30 units. ii. Terminal B does not serve customer 3. iii. Terminal B cannot process more than 45 units. (d) Solve the mathematical model of part (c) using Excel. (2 point)