This is operation research question. Do it on excel with step by step process and formulate the column 1. Steelco manufactures 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) mustbe produced. Each plant is open 40 hours per week.Formulate a balanced transportation problem to minimize the cost of meetingSteelco's weekly requirements.TABLE 8Plant1233 *Steel 1605043Cost (S)Steel 2403020Steel 3283020(minutes)201615

Find the Given details below: Given details: Costs Time(minutes) Plant Steel 1 Steel 2…

Answered: 1. Steelco manufactures three types of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section: Chapter Questions

Problem 67P

See similar textbooks

Similar questions

United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a differentproduction capacity (in tons per day) for each grade, as follows:MillAluminumGrade 1 2High 6 2Medium 2 2Low 4 10The company has contracted with a manufacturing firm to supply at least 12 tons of high-grade aluminum, 8 tons of medium-grade aluminum, and 5tons of low-grade aluminum. It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know thenumber of days to operate each mill in order to meet the contract at the minimum cost What would be the effect on the optimal solution if the cost of operating mill 1 increased from $6,000 to $7,500 per day?
United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a differentproduction capacity (in tons per day) for each grade, as follows:MillAluminumGrade 1 2High 6 2Medium 2 2Low 4 10The company has contracted with a manufacturing firm to supply at least 12 tons of high-grade aluminum, 8 tons of medium-grade aluminum, and 5tons of low-grade aluminum. It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know thenumber of days to operate each mill in order to meet the contract at the minimum cost Identify and explain the shadow prices for each of the aluminum grade contract requirements.
Textbook Problem. Practical Management Science. 6Th Edition 78. In the original RedBrand problem (Example 5.4), suppose that the company could add up to 100 tons of capacity, in increments of 10 tons, to any singleplant. Use SolverTable to determine the yearly savings in cost from having extra capacity at the various plants. Assume that the capacity will cost $28,000 per ton right now. Also, assume that the annual cost savings from having the extra capacity will extend over 10 years and that the total 10-year savings will be discounted at an annual 10% interest rate. How much extra capacity should the company purchase, and which plant should be expanded? (Hint: Use the PV function to find the present value of the total cost saving over the 10-year period. You can assume that the costs occur at the ends of the respective years.)
4. Barrows Textile Mills produces two types of cotton cloth— denim and corduroy.Corduroy is a heavier grade of cotton cloth and, as such, requires 7.5 pounds of rawcotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard ofcorduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours.Although the demand for denim is practically unlimited, the maximum demand forcorduroy is 510 yards per month. The manufacturer has 6500 pounds of cotton and 3000hours of processing time available each month. The manufacturer makes a profit of$2.25 per yard of denim and $3.10 per yard of corduroy. The manufacturer wants toknow how many yards of each type of cloth to produce to maximize profit.
4 Sunco processes oil into aviation fuel and heating oil. Itcosts $40 to purchase each 1,000 barrels of oil, which isthen distilled and yields 500 barrels of aviation fuel and 500barrels of heating oil. Output from the distillation may besold directly or processed in the catalytic cracker. If soldafter distillation without further processing, aviation fuelsells for $60 per 1,000 barrels, and heating oil sells for $40per 1,000 barrels. It takes 1 hour to process 1,000 barrels ofaviation fuel in the catalytic cracker, and these 1,000 barrelscan be sold for $130. It takes 45 minutes to process 1,000barrels of heating oil in the cracker, and these 1,000 barrelscan be sold for $90. Each day, at most 20,000 barrels of oilcan be purchased, and 8 hours of cracker time are available.Formulate an LP to maximize Sunco’s profits.
A manufacturer can sell product 1 at a profit of $2/unitand product 2 at a profit of $5/unit. Three units of rawmaterial are needed to manufacture 1 unit of product 1, and6 units of raw material are needed to manufacture 1 unit ofproduct 2. A total of 120 units of raw material are available.If any of product 1 is produced, a setup cost of $10 isincurred, and if any of product 2 is produced, a setup costof $20 is incurred. Formulate an IP to maximize profits.
Capsule Drugs manufactures two drugs. The drugs areproduced by blending two chemicals. By weight, drug 1must contain at least 65% chemical 1, and drug 2 mustcontain at least 55% chemical 1. Drug 1 sells for $6 perounce, and drug 2 sells for $4 per ounce. Chemicals 1and 2 can be produced by one of two production processes. Running process 1 for an hour requires 7 ouncesof raw material and 2 hours of skilled labor, and ityields 3 ounces of each chemical. Running process 2 foran hour requires 5 ounces of raw material and 3 hoursof skilled labor, and it yields 3 ounces of chemical 1 and1 ounce of chemical 2. A total of 3000 hours of skilledlabor and 5000 ounces of raw material are available.Determine how to maximize Capsule’s sales revenues.
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. Letting R = number of regular gloves C = number of catcher's mitts leads to the following formulation: Max 5R + 8C s.t. R + 3 2 C ≤ 800 Cutting and sewing 1 2 R + 1 3 C ≤ 240 Finishing 1 8 R + 1 4 C ≤ 100 Packaging and shipping R, C ≥ 0 The computer solution is shown below. Optimal Objective Value = 3520.00000 Variable Value Reduced Cost R 320.00000 0.00000 C 240.00000 0.00000 Constraint Slack/Surplus Dual Value 1 120.00000 0.00000 2 0.00000 3.00000 3 0.00000 28.00000 Variable ObjectiveCoefficient AllowableIncrease AllowableDecrease R 5.00000 7.00000 1.00000 C 8.00000 2.00000 4.66667 Constraint RHSValue AllowableIncrease AllowableDecrease 1 800.00000 Infinite 120.00000 2 240.00000 160.00000 106.66667 3…
State University must purchase 1100 computers fromthree vendors. Vendor 1 charges $500 per computerplus a total delivery charge of $5000. Vendor 2 charges$350 per computer plus a total delivery charge of$4000. Vendor 3 charges $250 per computer plus atotal delivery charge of $6000. Vendor 1 will sell theuniversity at most 500 computers, vendor 2, at most900, and vendor 3, at most 400. The minimum orderfrom any vendor is 200 computers. Determine how tominimize the cost of purchasing the needed computers.
Can you show how to put it in Excel? XYZ store sells regular and premium nut mixes. Premium mix contains three quarters pound of cashews and one quarter of peanuts, and the regular mix has half pound of cashews and half pound peanuts per bag. The shop has 200 pounds of cashews and 300 pounds of peanuts to work with. Cashews cost $1.50 per pound, and peanuts cost 60 cents per pound. Premium mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner esimtes that no more than 200 bags of one types can be sold. What is the best combinations of products that maximizes profits? Make sure to create a feasible solution with countable number of products (no partials)
Dogie Agency has three police dogs to be assigned to 3 different department stores. The cost of each dog on eachdepartment is given below Dogs SM Robinson CSI1 200 350 2702 300 250 1503 400 350 270 1. What quantitative technique can you utilize for this problem? Explain.2. Determine the minimum cost of each dog per department.
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. Letting R = number of regular gloves C = number of catcher's mitts leads to the following formulation: Max 6R + 9C s.t. R + 3 2 C ≤ 1,000 Cutting and sewing 1 2 R + 1 3 C ≤ 300 Finishing 1 8 R + 1 4 C ≤ 100 Packaging and shipping R, C ≥ 0 The computer solution is shown below. Optimal Objective Value = 4350.00000 Variable Value Reduced Cost R 500.00000 0.00000 C 150.00000 0.00000 Constraint Slack/Surplus Dual Value 1 275.00000 0.00000 2 0.00000 4.50000 3 0.00000 30.00000 Variable ObjectiveCoefficient AllowableIncrease AllowableDecrease R 6.00000 7.50000 1.50000 C 9.00000 3.00000 5.00000 Constraint RHSValue AllowableIncrease AllowableDecrease 1 1000.00000 Infinite 275.00000 2 300.00000 100.00000 166.66667 3…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS