Assignment 1- Transportation and Assignment models Question 1 An airconditioning manufacturer produces room airconditioners at plants in Houston, Phoenix, and Memphis. These are sent to regional distributors in Dallas, Atlanta, and Denver. The shipping costs vary, and the company would like to find the least-cost way to meet the demands at each of the distribution centers. Dallas needs to receive 800 air- conditioners per month, Atlanta needs 600, and Denver needs 400. Houston has 850 air conditioners available each month, Phoenix has 650, and Memphis has 300. The shipping cost per unit from Houston to Dallas is R8, to Atlanta is R 12, and to Denver is R 10. The cost per unit from Phoenix to Dallas is R 10, to Atlanta is R 14, and to Denver is R9. The cost per unit from Memphis to Dallas is R11, to Atlanta is R8, and to Denver is R12. 1.1 Use the Northwest corner rule to calculate the number of units that should be shipped from each plant to each regional distribution center at the minimum cost. (10) 1.2 Use MS Excel solver to determine the optimium solution. (15) Question 2 Finnish Furniture manufactures tables in facilities located in three cities -Reno, Denver, and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution schedule that will meet the demands at the lowest possible cost. The shipping cost per unit(in Rands) from each of the sources to each of the destinations is shown in the following table: TO FROM PHOENIX CLEVELAND CHICAGO RENO 10 16 19 DENVER 12 14 13 PITTSBURGH 18 12 12 The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburgh. Phoenix has a demand of 140 units, Cleveland has a demand of 160 units, and Chicago has a demand of 180 units. 2.1 Use the Northwest corner rule to calculate the number of units that should be shipped from each manufacturing facility to each of the retail stores if cost is to be minimised. (10) 2.2 Use MS Excel solver to determine the optimium solution. (15) This is an individual assignment. No copying will be tolerated. This assignment accounts for 25% of your final mark. Submit your answers on Vutela by 19 November 2021