1. 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 23 2 3 Steel 1 60 50 43 Cost (S) Steel 2 40 30 20 Steel 3 28 30 20 Time (minutes) 20 16 15 a. Write down the problem formulation ! b. Write down your conclusion ! 2. Write down the formal LP Formulation from Problem No. 1. 3. Solve the LP formulation from No.2 by using Excel Solver ! 4. Compare Problem No. 1 solution and Problem No. 2's solution, and then explain your conclusion !
1. 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 23 2 3 Steel 1 60 50 43 Cost (S) Steel 2 40 30 20 Steel 3 28 30 20 Time (minutes) 20 16 15 a. Write down the problem formulation ! b. Write down your conclusion ! 2. Write down the formal LP Formulation from Problem No. 1. 3. Solve the LP formulation from No.2 by using Excel Solver ! 4. Compare Problem No. 1 solution and Problem No. 2's solution, and then explain your conclusion !
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter5: Network Models
Section: Chapter Questions
Problem 68P
Related questions
Question
This is operations research question and the question is connected. Please with the step-step process on how to do it in excel solver and to insert the formula.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,