Do not use Ai The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped toregional distribution centers located in Boston, Atlanta, and Houston. Because of an anticipated increase in demand, Martin-Beck plans to increase capacity by constructing a new plant in one or more of the following cities: Detroit, Toledo, Denver, orKansas City. The estimated annual fixed cost and the annual capacity for the four proposed plants are as follows: ProposedPlant Annual Fixed Cost Annual Capacity Detroit $175,000 40,000 Toledo $300,000 10,000 Denver $375,000 20,000 KansasCity $500,000 30,000 The company's long-range planning group developed forecasts of the anticipated annual demand atthe distribution centers as follows: Dis

IntroductionThe Martin-Beck Company is faced with the challenge of meeting an anticipated increase…

Answered: The Martin-Beck Company operates a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Mick Karra is the manager of MCZ Drilling products which produces a variety of especially valves for oil field equipment. Recent activity in the oil fields has cause demand to increase drastically, and a decision has been made to open a new manufacturing facility. Three locations are being considered, and the size of the facility would not be the same in each location Thus, overtime might be necessary at times. The folowing table gives the total monthly cost (in 1000s) for each possible location under each demand posibility. The probabilities for the demand levels have been determined to be 20% for low demand, 30% for medium demand, and 50% for high demand Demand is Low Demand is medium Demand is High Ardmore, OK 85 110 150 Sweetwater, TX 90 100 120 Lake Charles, LA 110 120 130 (a) Which location would be selected based on the optimistic criterion? (b) which location would be selected based on the pessimistic criterion? (c) which location would be selected based on the…
AlwaysRain Irrigation, Inc. would like to determine capacity requirements for the next four years. Currently, two production lines are in place for making bronze and plastic sprinklers. Three types of sprinklers are available in both bronze and plastic: 90- degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: Plastic 90 Plastic 180 Plastic 360 Bronze 90 Bronze 180 Bronze 360 1 (IN 0005) 33 14 51 6 4 10 YEARLY DEMAND 2 (IN 000s) 3 (IN 000s) 4 (IN 0005) 42 15 54 6 4 Plastic Demand for plastic sprinklers Percentage of capacity used Machine requirements Labor requirements Bronze Demand for bronze sprinklers Percentage of capacity used Machine requirements Labor requirements 12 54 18 61 5 6 14 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require four operators and can produce up to 15,000 sprinklers. The plastic…
Hardgrave Machine Company produces computer components at its factories in Cincinnati, Kansas City, and Pittsburgh. These factories have not been able to keep up with demand for orders at Hardgrave’s four warehouses in Detroit, Houston, New York, and Los Angeles. As a result, the firm has decided to build a new factory to expand its productive capacity. The two sites being considered are Seattle, Washington, and Birmingham, Alabama. Both cities are attractive in terms of labour supply, municipal services, and ease of factory financing. Table 1 presents the production costs and monthly supplies at each of the three existing factories, monthly demands at each of the four warehouses, and estimated production costs at the two proposed factories. Transportation costs from each factory to each warehouse are summarized in Table 2. In addition to this information, Hardgrave estimates that the monthly fixed cost of operating the proposed facility in Seattle would be $400,000. The…
Niue Vanilla has had two successive years in which the Vanilla bean harvest has stretched the firm’s capacity within their drying sheds. Pita, the manger for the drying operation must now make a decision on capacity for next year. Estimated profits under each of the three possible states of nature are as shown in the table below, along with 3 possible alternatives he is considering: Do Nothing, Expand the Drying Shed operation, or Subcontract to a local farmer group who can do some of the drying. Suppose after a certain amount of discussion, Pita is able to subjectively assess the probabilities of low, medium and high demand: P(low) = 0.2, P(Medium) = 0.35 and P(high) = 0.45 Determine the expected profit of each alternative. Which alternative is best? Why? Analyse the problem using a decision tree. Show the expected profit of each alternative on the tree.
Niue Vanilla has had two successive years in which the Vanilla bean harvest has stretched the firm’s capacity within their drying sheds. Pita, the manger for the drying operation must now make a decision on capacity for next year. Estimated profits under each of the three possible states of nature are as shown in the table below, along with 3 possible alternatives he is considering: Do Nothing, Expand the Drying Shed operation, or Subcontract to a local farmer group who can do some of the drying. Suppose after a certain amount of discussion, Pita is able to subjectively assess the probabilities of low, medium and high demand: P(low) = 0.2, P(Medium) = 0.35 and P(high) = 0.45 Compute the expected value of perfect information. How could Pita use this knowledge?
A chain restaurant wants to open a new location. It is considering three (3) potential sites for the new restaurant. One location is downtown, the other location is in the suburbs and the final location is at the city limits. The downtown location will have monthly fixed costs of $9,500 and labor and materials at $3.75 an order. The suburb location will have a monthly fixed cost of $8,200 and labor and materials at $3.00 an order. The city limits locations will have a monthly fixed cost of $5,500 and labor and materials at $3.85 an order. The average price per order is $15.50 A. The restaurant chain's business analyst is using three different demand levels for each location 1,000 units, 800 units and 500 units. Determine the profitable of each potential location using each of the demand levels. B. At what demand level is each potential location most profitable? C. At what demand level is each potential location least profitable?
AlwaysRain Irrigation, Inc. would like to determine capacity requirements for the next four years. Currently, two production lines are in place for making bronze and plastic sprinklers. Three types of sprinklers are available in both bronze and plastic: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: YEARLY DEMAND 1 (IN 000s) 2 (IN 000s) 3 (IN 000s) 4 (IN 000s) Plastic 90 33 42 54 51 Plastic 180 14 15 18 17 Plastic 360 51 54 61 68 Bronze 90 6 5 14 Bronze 180 4 12 Bronze 360 10 12 14 17 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require four operators and can produce up to 15,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires five operators and can produce up to 240,000 sprinklers. Three bronze machines and only one injection molding machine are…
AlwaysRain Irrigation, Inc. would like to determine capacity requirements for the next four years. Currently, two production lines are in place for making bronze and plastic sprinklers. Three types of sprinklers are available in both bronze and plastic: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: YEARLY DEMAND 1 (IN 000s) 2 (IN 000s) 3 (IN 000s) 4 (IN 000s) 54 Plastic 90 32 43 55 Plastic 180 14 18 15 18 Plastic 360 52 55 62 68 Bronze 90 Bronze 180 9. 10 7. 7. Bronze 360 14 14 16 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require three operators and can produce up to 11,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires three operators and can produce up to 300,000 sprinklers. Three bronze machines and only one injection molding machine are…
Williams Auto Top Carriers currently maintains plants in Atlanta and Tulsa to supply auto top carriers to distribution centers in Los Angeles and New York. Because of expanding demand, Williams has decided to open a third plant and has narrowed the choice to one ot two cities – New Orleans and Houston. Table below provides pertinent production and distribution costs as well as plant capacities and distribution demands. Which of the new locations, in combination with the existing plants and distribution centers, yields a lower cost for the firm? From Plants To Distribution centers Normal production Unit production cost Los Angeles New York Existing plants Atlanta Tulsa $8 $4 $5 $7 600 900 $6 $5 Proposed locations New Orleans Houston $5 $4 $6 $6a 500 500 $4 (anticipated) $3 (anticipated) Forecast demand 800 1,200 2,000 a – Indicates distribution cost (shipping, handling, storage) will be $6 per…
William Green, vice president of manufacturing for computer products (CPC), and his staff are studying three midwestern alternative locations for a new production facility for producing high-resolution scanners. His staff analysts predict that the scanners will be a growing market over the next ten years, and the analyst's group shares marketing's enthusiasm for planning facilities for producing this new product line. The analysts have developed these estimates for the three locations; In what range of production volume would each of the locations be preferred (at the minimum cost)? Variable cost locations Annual Fixed costs per scanner Cleveland, Ohio $390,000 $34 South Bend, Indiana $360,000 $37 Grand Rapids, Michigan $310,000 $40
Two vaccination schemes are recently adopted in Lebanon, Pfizer and Astrazenica The profit for each one of these is dependent on the site (clinic or hospital) performing the vaccination process. This is shown in the following payoff table. Ministry of health considering the maximum profit to be able to cover the cost of staff where vaccination process can either be in a small clinics, or medium size hospitals or in main hospitals Alternative capacity for new store Pfizer Astrazenica Clinics 10 Small Hospitals Main Hospitals 7 6. 3 (a) Assume the payoffs represent profits. Determine the alternative that would be chosen under each of these decision criteria: Maximin, Maximax, Laplace, In your own opinion, which alternative likely to be excluded and why? (b) The ministry of health would like to check the possible loss. Find out the minimax regret table and identify the recommended alternative. (c) Assuming the probability of getting Pfizer is 0.6 and getting Astrazenica is 40%, determine…
The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose lati-tudes and longitudes are shown in Table 13.1, along with the population in each census tract (in thou-sands). Customers will travel from the seven census-tract centers to the new facility when they needhealth care. What is the target area’s center of gravity for the Health-Watch medical facility?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS