7. Solve the following problem by using Solver in your spreadsheet: Steelco manufactures three types of steel at different plants. The time required to manufacture 1 ton of steel (regardless of type) and the costs at each plant are shown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must be produced. Each plant is open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. TABLE 8 Plant 1 2 3 Steel 1 60 50 43 Cost (S) Steel 2 a. b. Write down your conclusion ! 40 30 20 Write down the problem formulation ! Steel 3 28 30 20 Time (minutes) 20 16 15

7. Solve the following problem by using Solver in your spreadsheet: Steelco manufactures three types of steel at different plants. The time required to manufacture 1 ton of steel (regardless of type) and the costs at each plant are shown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must be produced. Each plant is open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. TABLE 8 Plant 1 2 3 Steel 1 60 50 43 Cost (S) Steel 2 a. b. Write down your conclusion ! 40 30 20 Write down the problem formulation ! Steel 3 28 30 20 Time (minutes) 20 16 15

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 16EQ

See similar textbooks