Part 4 you MUST upload the word file and supporting Excel workbooks that are named by each question.

Question 4) (25 points) Consider a transportation problem. ay 4:41 There are a set of suppliers and a set of customers in a region. The customers have their known demand of a specific product. Suppliers have supply capacities for the product. An operations Em manager wants to make shipment decisions, i.e., how many items to ship from each supplier to each customer, subject to the points mugs, an omcast demand requirements and supply capacities. The demand and lay need le below supply information are presented below. Suppliers Supply Capacity Customers Demand 550 100 2 600 B ars of lab 250 950 350 icraled by 9001 450 $50, res ear optim 700 E 400 he numb 650 F 450 ced in o 300 I consider ailable bjective a model A shipping cost is charged for shipping each unit of item from a to solve ci shoul supplier to a customer. The cost information is summarized below. According to this cost matrix, for example to ship 100 units of the item from supplier 2 to customer B, a shipping cost points volume le types of is charged. hours. " The goal is to minimize the total transportation costs. in this mi Cost Matrix its) C d to a cu From To ABCDEFG me of h item. 1 out th ntial pre FG 1 10 2 10 5 10 3 10 late th 10 1 20 2 94 54 34 6 3 3 5 3 5 18 8 4 27 8 9 27 4 acturer s 5 3 6 47 3 2 10 rder to m on mode 6 82 2 4 10 8 4 s, objecti atical ization 1- How many items should be shipped from each supplier to ecisi he mach each customer to minimize the total transportation costs? le op Ive th the probl Formulate a mathematical model for this problem and use ed? w of each i Excel to solve the problem. in? sider inte ry value () (5 P Is in Exc 2- What is the excess capacity of supplier 2 in the optimal mult if we con solution? lues