Question: it's requested to be solved by excel 2. Steel mills in three cities produce the following amounts of steel: Location A. Bethlehem B. Birmingham C.

it's requested to be solved by excel

it's requested to be solved by excel 2. Steel

2. Steel mills in three cities produce the following amounts of steel: Location A. Bethlehem B. Birmingham C. Gary Weekly Production (tons) 150 210 320 680 These mills supply steel to four cities, where manufacturing plants have the following demand: Location Weekly Demand (tons) 1. Detroit 130 2. St. Louis 70 3. Chicago 180 4. Norfolk 240 620 Shipping costs per ton of steel are as follows: To (cost) From 1 2 3 4 A $16 B $14 11 16 $ 9 8 12 7 10 $18 16 22 Because of a truckers strike, shipments are prohibited from Birmingham to Chicago. Formulate this problem as a linear programming model and solve it by using the computer

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!

Assume the following: the sales price to consumers is $150 the retailers markup is 50% Whirlpools after tax profit margin is 4% The hurdle rate is 20% Populations are as follows: Brazil 182...

Please solve it in Excel 2. Steel mills in three cities produce the following amounts of steel: Location Weekly Production (tons) A. Bethlehem 150 B. Birmingham 210 C. Gary 320 680 These mills supply...

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$10 Xa1 0 1 14 1E+30 1 $C$10 Xa2 70 0 9 0 12 $D$10 Xa3 0 9 16 1E+30 9 $E$10 Xa4 80 18 1...

Question 2 Steel mills in three cities produce the following amounts of steel: Location Weekly production (tons) A. Bethlehem 220 B. Birmingham 200 C. Gary 200 These steel mills supply steel to four...

Steel Mills in three cities produce the following amounts of steels: Location Weekly Production (tons) A. Bethlehem 150 B. Birmingham 210 C. Gary 260 Total 620 These Mills supply steel to four...

Steel mills in three cities produce the following amounts of steel: Location Weekly Production (tons) Bethlehem 210 Birmingham 240 Gary 320 770 These mills supply steel to four cities, where...

Chapter 6 4. Steel mills in three cities produce the following amounts of steel: Location Weekly Production (tons) A. Bethlehem 150 B. Birmingham 210 C. Gary 320 680 These mills supply steel to four...

Question 4: (25 pts) Steel mills in three cities produce the following amounts of steel: Location Weekly Production (tons) A. Bethlehem 150 B. Birmingham 210 C. Gary 320 680 These mills supply steel...

Brass is a substitutional alloy consisting of a solution of copper and zinc. A particular sample of red brass consisting of 80.0% Cu and 20.0% Zn by mass has a density of 8750 kg/m3. (a) What is the...

Who are the major actors in political and legal systems? Which participant do you believe is most influential in international business?

Ownership and debt instruments of the government and other companies that can be readily converted to cash are best reported as: Question 7 options: 1 ) long - term investments 2 ) cash 3 )...

Mountains Pty Ltd (Mountains) deals with geographic analysis. The Managing Director of Mountains is Kosciuszko. Gravatt is the Company Secretary and Barney is the Director of Innovation. Crosby...