Please show your math!Steel Mills in three cities produce the following amounts of steels:LocationWeekly Production (tons)A. Bethlehem150B. Birmingham210C. Gary260Total620These Mills supply steel to four cities, where manufacturing plants have the following demand:LocationWeekly Demand (tons)1. Detroit1302. St. Louis703. Chicago1804. Norfolk240Total620Shipping Costs per ton of steel are as follows:To (Cost)3. ChicagoForm1. Detroit2. St. Louis4. NorfolkA. Bethlehem$14$9$16$18B. Birmingham$11$8$7$16C. Gary$16$12$10$22a. Write down the function for Total cost in cell B19.b. Find the Minimum cost in cell B19 using Solver in Excel.

Answered: Please show your math! Steel Mills in…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section6.5: Set-covering And Location-assignment Models

Problem 32P

See similar textbooks

Similar questions

Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
Consider a small Oil production firm with 5 competing oil production projects, A - E. The table below shows the estimated long-term profit (Net Present Value) for each project as well as the amount of investment capital required to start the project. You have been contacted to help select the best combination of projects to maximize the Net Present Value subject to the capital investment limit of $32 million. Production Project A B C D E Estimated Profit (millions) 25 20 19 28 21 Capital Required (millions) 11 8 14 19 13 Formulate a Binary Integer Programming (BIP) model on a spreadsheet. Solver the model using Solver.
What combination of x and y will yield the optimum for this problem? Maximize $10x + $4y, subject to (1) 5x + 3y ≤ 15 and (2) 3x + 6y ≤ 18 and (3) x, y ≥ 0.
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
The distance between two cities in the United States can be approximated by the following formula, where lat1 and long1 are the latitude and longitude of city 1 and lat2 and long2 are the latitude and longitude of city 2. 69 (lat1 − lat2)2 + (long1 − long2)2 Ted's daughter is getting married, and he is inviting relatives from 15 different locations in the United States. The file Wedding gives the longitude, latitude, and number of relatives in each of the 15 locations. Ted would like to find a wedding location that minimizes the demand-weighted distance, where demand is the number of relatives at each location. Assuming that the wedding can occur anywhere, find the latitude and longitude of the optimal location. (Hint: Notice that all longitude values given for this problem are negative. Make sure that you do not check the option for Make Unconstrained Variables Non-Negative in Solver. Round your answers to three decimal places.) latitude of the optimal wedding location:…
Find the optimal solution for the following problem. (Round your answers to 3 decimal places.) Minimize C = 11x + 5y + 10z subject to 8x + 12y + 19z ≥ 68 13x + 16y + 5z ≥ 136 and x ≥ 0, y ≥ 0, z ≥ 0. What is the optimal value of x? What is the optimal value of y? What is the optimal value of z? What is the minimum value of the objective function?
Macnamara Corporation has two manufacturing departments--Casting and Finishing. The company used the following data at the beginning of the year to calculate predetermined overhead rates: Casting Finishing Total Estimated total machine-hours (MHs) 1,000 4,000 5,000 Estimated total fixed manufacturing overhead cost $ 4,800 $ 8,800 $ 13,600 Estimated variable manufacturing overhead cost per MH $ 1.80 $ 2.90 During the most recent month, the company started and completed two jobs--Job F and Job M. There were no beginning inventories. Data concerning those two jobs follow: Job F Job M Direct materials $ 11,500 $ 9,000 Direct labor cost $ 18,400 $ 7,400 Casting machine-hours 700 300 Finishing machine-hours 1,600 2,400 Assume that the company uses departmental predetermined overhead rates with machine-hours as the allocation base in both production departments. The manufacturing overhead applied to Job F is closest to: $4,620…
The Big Bang Theory Assume the hours needed to cook a meal or done a basket of laundry are different, and they are described below: 1 MEAL 1 BASKET SHELDON 2 1 LEONARD 1/2 2 1. What is the maximum number of meals Sheldon can produce in 12 hours? What is the maximum number of laundry baskets Sheldon can complete in 12 hours? 2. Plot in a graph: Sheldon’s production possibility frontier. 3: Plot in a graph: Leonard’s production possibility frontier. 4. What is Sheldon’s opportunity cost of one meal (in terms of baskets given up)? What is his opportunity cost of one basket (in terms of meals given up)? 5. Does Leonard have an absolute advantage in producing both meals and baskets? 6. Who has a comparative advantage in cooking? 7. Suppose each person has 12 hours for the two tasks in a week, and suppose both Sheldon and Leonard each spend 6 hours on cooking and 6 hours on laundry. Consider an offer from Leonard to Sheldon: do 3 baskets of laundry for me each week, and I’ll cook you 2…
Find the optimal solution for the following problem. (Round your answers to 3 decimal places.) Minimize C = 17x + 19y subject to 8x + 14y ≥ 21 11x + 6y ≥ 31 and x ≥ 0, y ≥ 0. What is the optimal value of x and y? What is the minimum value of the objective function? Please show me step by step how to do this by hand, not through excel.
The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown below. Factory Shipping Cost per Case to Warehouses Capacity W1 W2 W3 W4 W5 F1 $1.50 $4.50 $6.00 $7.50 $9.00 40,000 30,000 10,000 F2 $3.00 $3.00 $1.50 $6.00 $7.50 30,000 25,000 5,000 F3 $1.50 $7.50 $1.50 $4.50 $1.50 30,000 10,000 20,000 F4 $7.50 $3.00 $6.00 $7.50 $6.00 25,000 25,000 Demand 30,000 35,000 25,000 15,000 20,000 125,000 What is the total cost of the optimal solution? Total cost = $nothing. (Enter your response to the nearest dollar.)
The High-Price Oil Company owns a pipeline network that is used to convey oil from its source to several storage locations. A portion of the network is as follows: Due to the varying pipe sizes, the flow capacities vary. By selectively opening and closing sections of the pipeline network, the firm can supply any of the storage locations. a. If the firm wants to fully utilize the system capacity to supply storage location 7, how long will it take to satisfy a location 7 demand of 100,000 gallons? What is the maximal flow for this pipeline system? b. If a break occurs on line 2–3 and that line is closed down, what is the maximal flow for the system? How long will it take to transmit 100,000 gallons to location 7?
Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35% of his investments to be in nonmortgage instruments and no more than 60% to be in high-yield (and high-risk) instruments (i.e., expected interest > 8%). How should his investment be diversified to make the most interest income? Investment Expected Return Maximum Allowed Low-income mortgage loans 6.50% 20% Conventional mortgage loans 6.00% 30% Government sponsored mortgage loans 8.25% 25% Bond investments 5.75% 15% Stock investments 8.75% 18% Futures trading 9.25% 10%

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