Question: Please formulate and LP model and draw a network flow model to represent this problem. Please show excel solving and optimal solution. A B C

Please formulate and LP model and draw a network flow model to represent this problem. Please show excel solving and optimal solution.

Please formulate and LP model and draw a network

A B C D E F 1 K L M 2 1. A steel manufacturing needs to cool 17 pieces of steel. The weight and due date for each piece are listed in sheet "1.SteelCooling". 3 Processing and cooling a batch in the furnace takes five minutes regardless of the weight in the furnace. 4 The furnace can handle up to 1000 pounds at a time. Jobs 6 and 7 (size 640 and 450, respectively) must be completed on time. How can the company minimize the total time the jobs are late? 6 Steel cooling Due Date 8 Piece 91 10 2 11 3 12 4 135 14 6 15 7 8 17 9 10 19 11 20 12 21 13 Size 360 330 920 590 860 640 450 880 930 70 820 390 840 990 260 440 120 15 16 17 20 A B C D E F 1 K L M 2 1. A steel manufacturing needs to cool 17 pieces of steel. The weight and due date for each piece are listed in sheet "1.SteelCooling". 3 Processing and cooling a batch in the furnace takes five minutes regardless of the weight in the furnace. 4 The furnace can handle up to 1000 pounds at a time. Jobs 6 and 7 (size 640 and 450, respectively) must be completed on time. How can the company minimize the total time the jobs are late? 6 Steel cooling Due Date 8 Piece 91 10 2 11 3 12 4 135 14 6 15 7 8 17 9 10 19 11 20 12 21 13 Size 360 330 920 590 860 640 450 880 930 70 820 390 840 990 260 440 120 15 16 17 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Cars-to-Dealers Logistics Inc. is the exclusive logistics provider for the Summit Motor Co. and has responsibility for transporting cars from Summit's 3 manufacturing plants in Toledo, OH; Charlotte,...

Formulate the problem as a linear program to determine how the cars should be distributed in order to minimize the distribution costs. I have done a lot of the leg work however I cannot figure out...

Can you please see the question in the picture attached? Question #16. Parts a, b, and c? I was able to do question 15. When I attempt to do the spreadsheet, it comes up with formula errors. If you...

Please use excel for this question and show me your excel data. I will give the high rate. Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two production...

please solve this two questions and show me the excel of the second one. I will give the high rate! Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two...

Q 4 : Chapter 5 , Problem 2 8 Please download the Excel file for your work and submit your Excel file. Union Express has 6 0 tons of cargo that needs to be shipped from Boston to Dallas. The shipping...

can you please explain what type of functions I have to use in excel to solve it? 30. The Britts & Straggon company manufactures small engines at three different plants. From the plants, the engines...

A cotton grower in South Georgia produces cotton on farms in Statesboro and Brooklet, ships it to cotton gins in Claxton and Millen where it is processed, and then sends it to distribution centers in...

I need a detailed solution to the below question along with netflow model diagram Q 5 . The Britts & Straggon company manufactures small engines at three different plants. From the plants, the...

The Roche limit is the radial distance from the center of a planet at which the tidal forces exerted by the planet on one of its moons will overcome the gravitational force holding the moon together....

Point Company acquired 80 percent of the stock of Slash Corp. on January 1, 2019. The stockholder's equity section of Slash's balance sheet at that date is as follows: Stockholders Equity Section...

Jamie Lee and Ross are shocked at the cost of the dorms and decide to call Jay Hall, their investment counselor, to discuss if buying the house would be a smart investment. Jay tells Jamie Lee and...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...