please answer all of question 4 thank you
The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? a) Draw the network representation of this problem. b) Formulate this problem as a transportation problem (write down explicitly the decision variables, objective function, and constraints). The Versatech Corporation has decided to produce three new products. Five branch plants now have excess product capacity. The unit manufacturing cost of the first product would be $39, $42, $38, and $29 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the second product would be $55, $51, $56, $52, and $53 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the third product would be $48, $45, $50 in Plants 1, 2, and 3, respectively, whereas Plants 4 and 5 do not have the capacity for producing this product. Sales forecasts indicate that 700, 1000, and 900 units of products 1, 2, and 3, respectively, should be produced per day. Plants 1, 2, 3, 4, and 5 have the capacity to produce 400, 600, 400, 600, and 1000 units daily, respectively, regardless of the product or combination of products involved. Assume that any plant having the capability and capacity to produce them can produce any combination of the products in any quantity. Management wishes to know how to allocate the new products to the plants to minimize total manufacturing cost. a) Formulate this problem as a transportation problem (write down explicitly the decision variables, objective function and constraints). b) Obtain an optimal solution by Excel Solver. The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? a) Draw the network representation of this problem. b) Formulate this problem as a transportation problem (write down explicitly the decision variables, objective function, and constraints). The Versatech Corporation has decided to produce three new products. Five branch plants now have excess product capacity. The unit manufacturing cost of the first product would be $39, $42, $38, and $29 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the second product would be $55, $51, $56, $52, and $53 in Plants 1, 2, 3, 4, and 5, respectively. The unit manufacturing cost of the third product would be $48, $45, $50 in Plants 1, 2, and 3, respectively, whereas Plants 4 and 5 do not have the capacity for producing this product. Sales forecasts indicate that 700, 1000, and 900 units of products 1, 2, and 3, respectively, should be produced per day. Plants 1, 2, 3, 4, and 5 have the capacity to produce 400, 600, 400, 600, and 1000 units daily, respectively, regardless of the product or combination of products involved. Assume that any plant having the capability and capacity to produce them can produce any combination of the products in any quantity. Management wishes to know how to allocate the new products to the plants to minimize total manufacturing cost. a) Formulate this problem as a transportation problem (write down explicitly the decision variables, objective function and constraints). b) Obtain an optimal solution by Excel Solver
