Instructions: use excel solver to resolve the following problems. You are to submit an excel spreadsheetwith the solver modelsand solutions.

Problem1:Steelcomanufactures three types of steel at different plants. The time required tomanufacture 1 ton of steel (regardless of type) and the cost at each plant are shown in the table below

SEE ATTACHED FILE FOR THE QUESTIONS!

Assignment 3: 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 1 ton of steel (regardless of type) and the cost at each plant are shown in the table below Plant Steel\t1 Cost\tin\t$\tper\tton Steel\t2 1 2 3 $60 $50 $43 $40 $30 $20 Steel\t3 $28 $30 $20 Time\tto manufacture\t1 ton (minutes) 20 16 15 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. Problem 2: The Patricia Garcia Company is producing seven new medical products. Each of Garcia'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 Garcia assign the new products to the plants in order to minimize manufacturing costs? Plants 1 2 3 4 5 6 7 8 Products C53 $0.10 $0.12 $0.13 $0.11 $0.10 $0.06 $0.16 $0.12 C81 $0.05 $0.06 $0.04 $0.08 $0.04 $0.09 $0.06 $0.06 D5 $0.32 $0.40 $0.31 $0.30 $0.42 $0.35 $0.36 $0.49 D44 $0.17 $0.14 $0.19 $0.15 $0.10 $0.16 $0.19 $0.12 E2 $0.06 $0.07 $0.10 $0.05 $0.08 $0.10 $0.11 $0.05 E35 $0.08 $0.10 $0.12 $0.08 $0.09 $0.10 $0.09 $0.06 G99 $0.55 $0.62 $0.61 $0.70 $0.62 $0.63 $0.65 $0.59