Part 1: From the textbook End of Chapter 3 of the textbook, "Homework Assignments" problem 1 and 2 Note that, problem #2 part b should read Solve problem #l. not problem 31) Part I: Problems from outside sources Preblal Arizona Plumbing Co. makes, among other products, a full line of bathtubs. To Minimize transportation cost, the firm Must decide which of its factories should supply which of its warehouses. Relevant data for the company and proceed in Tabel and Figure 1. Table I shows for example, that it costs the company to ship one but from Des Moines factory to its Albuquerque warehouse, S4 to Boston, and S3 to Cleveland Likewise you can see in Figure that the 300 units required by Ar u ming' A w we may be shipped in various combinations from its Des Moines, Evansville and Fort Lauderdale factories Table 1. Transportation Costs per Bathtub foron Plumbing FROM ALSUOLER BOSTON CLEVELA Des Moines Evansville Fort Lauderdale Figure 1. Transportation Problem What is Required 1) develop the transportation Matrix (tabular form the model) 2) Formulate the problem 3) use the software and determine final shipment schedule. And total shipping cost 4-solve problem using the following umpis C e A nswer questions and above, assuming that the anchouse in Boston requires only 150 units Cwe 18 Answer questions 1.2 and above, that there is a direct route from Des Moines to Cleveland, and any shipment from Des Mo to Cleveland is shipped first to Evansville plant storage (At a cost of $2.35 per bhabi and then from there to Cleveland Prolom Williams Auto Top Carriers currently maintains plants in Alanta and Tulsa to supply to top camers To distribution centers in Los Angeles and New York Because of punding demand, W ams has decided to open a third plant and has marrowed the choice of two cities New Orleans and Houston Table 2. Provides pertinent production and distribution costs as well as plant capacities and distribution demands Which of the new locations, in combination with the existing plants and distribution centers, yields a lower cost for the firm? You need to show transport and solution, including total cost for each alternative Figure 1. Transportation Problem What is Required 1)-develop the transportation Matrix (tabular form f the model) 2) Formulate the problem 3) use the software and determine final shipment schedule. And total shipping cost 4)- solve problemi, using the following assumptions: Case A: Answer questions 1 and 2 above, assuming that the warehouse in Boston requires only 150 units Case 1B: Answer questions 1.2 and 3 above, assuming that there is no direct route from Des Moines to Cleveland, and any shipment from Des Moines to Cleveland is shipped first to Evansville plant storage (At a cost of $2.25 per bathtub), and then, from there to Cleveland. Problem Williams Auto Top Carriers currently maintains plants in Atlanta and Tulsa to supply auto top camers To distribution centers in Los Angeles and New York. Because of expanding demand, Williams has decided to open a third plant and has narrowed the choice to one of two cities New Orleans and Houston Table 2. Provides pertinent production and distribution costs as well as plant capacities and distribution demands Which of the new locations, in combination with the existing plants and distribution centers, yields a lower cost for the firm? You need to show transportation matrix and solution, including total cost for each alternative. TABLE 2. Production Costs, Distribution Costs, Plant Capabilities, and Market Demands for Williams Auto Top Carrier ROM PLANTS NORMAL TRODUCTION PRODUCTION CONT Existing plants Atlanta Tul Proposed locations New Orleans Houston Forecast demand S5 S4 Canticipated 53 800 500 2.000 1.200 Case 24 Suppose the third plant (the one determined in problem (2), in addition to shipping to warehouses is allowed to ship to the two original plants (at a distribution cost of $4.50 forcach plant) Show the transportation matrix and using the software, determine total cost. Will the new policy (allowing 3 plant to ship to other plants) result in a lower total cost? Part 1: From the textbook End of Chapter 3 of the textbook, "Homework Assignments" problem 1 and 2 Note that, problem #2 part b should read Solve problem #l. not problem 31) Part I: Problems from outside sources Preblal Arizona Plumbing Co. makes, among other products, a full line of bathtubs. To Minimize transportation cost, the firm Must decide which of its factories should supply which of its warehouses. Relevant data for the company and proceed in Tabel and Figure 1. Table I shows for example, that it costs the company to ship one but from Des Moines factory to its Albuquerque warehouse, S4 to Boston, and S3 to Cleveland Likewise you can see in Figure that the 300 units required by Ar u ming' A w we may be shipped in various combinations from its Des Moines, Evansville and Fort Lauderdale factories Table 1. Transportation Costs per Bathtub foron Plumbing FROM ALSUOLER BOSTON CLEVELA Des Moines Evansville Fort Lauderdale Figure 1. Transportation Problem What is Required 1) develop the transportation Matrix (tabular form the model) 2) Formulate the problem 3) use the software and determine final shipment schedule. And total shipping cost 4-solve problem using the following umpis C e A nswer questions and above, assuming that the anchouse in Boston requires only 150 units Cwe 18 Answer questions 1.2 and above, that there is a direct route from Des Moines to Cleveland, and any shipment from Des Mo to Cleveland is shipped first to Evansville plant storage (At a cost of $2.35 per bhabi and then from there to Cleveland Prolom Williams Auto Top Carriers currently maintains plants in Alanta and Tulsa to supply to top camers To distribution centers in Los Angeles and New York Because of punding demand, W ams has decided to open a third plant and has marrowed the choice of two cities New Orleans and Houston Table 2. Provides pertinent production and distribution costs as well as plant capacities and distribution demands Which of the new locations, in combination with the existing plants and distribution centers, yields a lower cost for the firm? You need to show transport and solution, including total cost for each alternative Figure 1. Transportation Problem What is Required 1)-develop the transportation Matrix (tabular form f the model) 2) Formulate the problem 3) use the software and determine final shipment schedule. And total shipping cost 4)- solve problemi, using the following assumptions: Case A: Answer questions 1 and 2 above, assuming that the warehouse in Boston requires only 150 units Case 1B: Answer questions 1.2 and 3 above, assuming that there is no direct route from Des Moines to Cleveland, and any shipment from Des Moines to Cleveland is shipped first to Evansville plant storage (At a cost of $2.25 per bathtub), and then, from there to Cleveland. Problem Williams Auto Top Carriers currently maintains plants in Atlanta and Tulsa to supply auto top camers To distribution centers in Los Angeles and New York. Because of expanding demand, Williams has decided to open a third plant and has narrowed the choice to one of two cities New Orleans and Houston Table 2. Provides pertinent production and distribution costs as well as plant capacities and distribution demands Which of the new locations, in combination with the existing plants and distribution centers, yields a lower cost for the firm? You need to show transportation matrix and solution, including total cost for each alternative. TABLE 2. Production Costs, Distribution Costs, Plant Capabilities, and Market Demands for Williams Auto Top Carrier ROM PLANTS NORMAL TRODUCTION PRODUCTION CONT Existing plants Atlanta Tul Proposed locations New Orleans Houston Forecast demand S5 S4 Canticipated 53 800 500 2.000 1.200 Case 24 Suppose the third plant (the one determined in problem (2), in addition to shipping to warehouses is allowed to ship to the two original plants (at a distribution cost of $4.50 forcach plant) Show the transportation matrix and using the software, determine total cost. Will the new policy (allowing 3 plant to ship to other plants) result in a lower total cost