7. Solve the following problem by using Solver in your spreadsheet: Steelcomanufactures three types of steel at different plants. The time required tomanufacture 1 ton of steel (regardless of type) and the costs at each plant areshown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must beproduced. Each plant is open 40 hours per week.Formulate a balanced transportation problem to minimize the cost of meetingSteelco's weekly requirements.TABLE 8Plant123Steel 1605043Cost ($)Steel 2403020Write down the problem formulation !Steel 3283020Time(minutes)201615a.b. Write down your conclusion !8. Write down the formal LP Formulation from Problem No. 7.Solve the LP formulation from No.8 by using Excel Solver !9.10. Compare Problem No. 7's solution and Problem No. 9's solution, and thenexplain your conclusion !

Given: In this question, the given details are, Solve the following problem by using Solver in your…

Answered: 7. Solve the following problem by using…

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

Ethan Steel, Inc. has three factories that manufacture steel components for three different rail projects located at three different sites. They want to determine how many steel components must be transported from each factory to each project site. The demand for the steel components for the three projects, A, B and C, are 2500, 3000 and 4500, respectively. The production and shipping details are as below: Production details: Factory Maximum capacity 1 3000 5000 3000 2 3 Shipping details (with per-unit shipping cost in dollars): Project Factory A B C 1 7 8 2 2 6 5 4 3 1 9 6 Develop a linear programming optimization model to determine the distribution plan (from factories to projects) that minimizes the total transportation cost. (Do NOT solve the model.)
Problem Il: A company plans to make 3 models (A, B, and C) of their main product next month. Production capacity is limited to 100 totals. Each model takes the same about of production time. A supplier problem results in only 1,000 gallons being available next month. Each Model A requires 5 gallons of paint, each Model B requires 7 gallons and each Model C requires 10 Ballons. Marketing wants the following mix: at least 5 Model B's; and no more than 2 Model C's for each Model B produced. The firm wants to select that product mix so as to maximize profit contribution. Here are the numbers that go into profit contribution: Product profit per unit A 1600 $ 1500 $ B 1200 S Formulate this as a linear programming problem.
Example 3. Food I contains 10 units of vitamin A and 12 unit of vitamin R gram and cost 20 paise per gram. Food II contains 7 unit of vitamin A and 15 unis of vitamin B and costs 18 paise per gram. The daily requirement of vitamin A and R are atleast 80 units and 90 units respectively. Formulate the above as an LPP to per minimise the cost. CS Scanned with CamScanner
A company uses four special tank trucks to deliver four different gasoline products to customers. Eachtank has five compartments with capacities: 500, 750, 1200, 1500, and 1750 gallons. The daily demands forthe four products are 10000, 15000, 12000, and 8000 gallons. Any quantities that cannot be delivered by thecompany’s four trucks must be subcontracted at the additional costs of 5, 12, 8, and 10 cents per gallon forproducts 1, 2, 3, and 4, respectively. The goal is to develop the optimal daily loading schedule for the fourtrucks that will minimize the additional cost of subcontracting. Formulate this problem as an integer linearprogram, and solve it using linear program solver.
A dietitian in a hospital is to arrange a special diet composed of three basic foods. The diet is to include exactly 340 units of calcium, 180 units of iron, and 400 units of vitamin A The number of units per ounce of each special ingredient for each of the foods is indicated in the table. Construct a Units per Ounce Food A Food B Food C Calcium 30 10 20 Iron 10 10 20 Vitamin A mathematical model to complete parts (A) through (C) below. Use Gauss-Jordan elimination to solve the model and then interpret the solution. 30 30 Construct a mathematical model for this situation. Let the first, second, and third equations represent calcium, iron, and vitamin A, respectively. Let x, represent the number of ounces of food A, x, represent tine number of ounces of food B, and x, represent the number of ounces of food C. - 2 * 3 = X, + X, + %3D (Type integers or decimais.) 20
A company manufactures a product at its plants in A, B, and C, then ships the product to six customers in G, H, J, K, and L, The monthly capacity of plants A, B, and Care 7400, 7300, and 10000 units, respectively. The monthly demand from customers G, H, J, K, and Lare 3000, 500, 4600, 7500, and 8900 units, respectively. Use Excel Solver to find the optimal distribution plant that will give the lowest total monthly shipping cost if the shipping cost per unit (in dollars per unit) are as follows: - from A to G, H, J, K, and L are 4, 9, 20, 6, and 13 dollars per unit, respectively; from B to G, H, J, K, and L are 12, 7, 3, 10, and 6 dollars per unit, respectively; from C to G, H, J, K, and L are 7, 6, 12, 2, and 9 dollars per unit, respectively. - The optimal total shipping costs is dollars per month.
XYZ Corporation operates two plants, each of which has a capacity of 200 units per day. Each day, XYZ must ship their product to each of four customers. Customers A, B, and C each have a demand of 17 units per day while customer D has a demand of 349 units per day. The cost of shipping one unit of each product from each of the two plants to each of the customers is shown in the table below. Customer A Customer B Customer C Customer D Plant 1 25 19 12 14 Plant 2 15 21 23 20 How many units should XYZ ship from each plant to each customer?
Need only a handwritten solution only (not a typed one).
A florist provides fresh flowers to shops in Wollongong. At present she has one nursery in Goulburn with capacity 9000 units a year. The florist is considering opening shops in Canberra and Sydney, and has found three potential nursery sites at Wagga, Orange and Bathurst. The transportation tableau below summarises the projected nursery capacities (units), the cost per unit of shipping from each nursery to each destination (dollars), and the demand (units) for the coming year. j=1 j=2 j=3 Sydney Capacities Wollongong Canberral 5 i=1 Goulburn 12 9000 i=2 Wagga 7 10 4000 i=3 Orange 4 7000 i=4 Bathurst 11000 Demand 11000 5000 8000 There are further constraints on how the nurseries can be located: • If a nursery is located in Wagga, another must be located in Bathurst and vice- versa. • One nursery can be located in Orange or Bathurst, but not both. Suppose that the costs of establishing new nurseries are Wagga $180,000 Orange $160,000 Bathurst $270,000 The goal is to develop a 0-1…
G.97.
please help
General Ford produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed as the table below. where a blank means that a shipment is not allowed. Los Angeles can produce up to 1600 cars, and Detroit can produce up to 3200 cars. Houston must receive 1800 cars, and Tampa must receive 2900 cars. 1. Determine how to minimize the cost of meeting demands in Houston and Tampa. 2. Modify the answer to part a if no shipments through Atlanta are allowed. From LA Detroit Atlanta Houston Tampa To LA Detroit $97 $94 $87 $129 $147 $100 $103 $145 Atlanta Houston $95 $125 $103 $110 $95 $88 $60 $103 Tampa $156 $148 $56 $100

Recommended textbooks for you

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Basic Technical Mathematics

Advanced Math

ISBN:

9780134437705

Author:

Washington

Publisher:

PEARSON

Topology

Advanced Math

ISBN:

9780134689517

Author:

Munkres, James R.

Publisher:

Pearson,

SEE MORE TEXTBOOKS