Instructions: use excel solver to resolve the following problems. You are to sub

Question

Instructions: use excel solver to resolve the following problems. You are to submit an excel spreadsheet with the solver models and solutions. Problem 1: Steelco manufactures three types of steel at different plants. The time required to manufacture I ton of steel (regardless of type) and the cost at each plant are shown in the table below Each week. 100 tons of each type of steel (1, 2 and 3) must be produced. Each plant b open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. Problem 2: The Patricia Gareia Company is producing seven new medical products. Each of Gareia's eight plants can add one more product to its current line of medical devices. The unit manufacturing costs for producing the different parts at the eight plants are shown below. How should Gareia assign the new products to the plants in order to minimize manufacturing costs?

Explanation / Answer

Steel produced in tons Changing Cells Steel 1 Steel 2 Steel 3 Plant 1 0 0 0 Plant 2 0 0 0 Plant 3 100 100 100 Cost to Mfg 1 ton steel Plant 1 60 40 28 Plant 2 50 30 30 Plant 3 43 20 20 Time in hrs to Mfg 1 ton Plant 1 0.333 0.333 0.333 Plant 2 0.267 0.267 0.267 Plant 3 0.250 0.250 0.250 Constraints Time 75

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.