Answered: Draw a Decision Tree on this…

Draw a Decision Tree on this Alternative Location for New Warehouse Problem indicating graphically the sequences of decision alternatives and states of nature that provide the six possible payoffs.

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

A city mayor you know is interested in recruiting Amazon to build in their city but doesn't know what a company considers before choosing where to build a processing plant. She has hired you to help her and her city council understands what decision factors Amazon might consider before making its choice. Research how companies decide where to locate a facility, and then write a brief report identifying and explaining at least 8 decision factors Amazon might consider before choosing a city to locate their new headquarters.
A farmers' cooperative association plans to build a new sugar mill in Georgetown. Theprimary objective of the mill is to provide the farmers with a place to take their crop forprocessing that will reduce their transportation costs. The members of the co-op believe thatthe center-of-gravity method is appropriate for this objective. While there are over 200 sugarcane farms in the region, they are tightly clustered around six villages. Using the data below,use the center-of-gravity method to calculate the coordinates of the best location for this mill.All mileage references use Browns Town as (0,0).VillageMiles East ofBrowns TownMiles North ofBrowns TownSugar CanetonnageBarney Valley 90 10 240,000Blue Pasture 140 60 320,000Congo Valley 20 70 450,000Bower 50 20 120,000Rabacca 100 80 60,000Salem 10 120 140,000
Exotech Computers manufactures computer components such as chips, circuit boards, motherboards, keyboards, LCD panels, and the like, and sells them around the world. It wants to construct a new warehouse and distribution center in Asia to serve emerging markets there. It has identified sites in Shanghai, Hong Kong, and Singapore and has graded the important weighted decision criteria for each site as follows: Recommend a site based on these decision criteria and grades.
The owner of the Party City Toronto Company must decide among building a mega centre store, building 5 new stores, or leasing 10 of their locations to another company. The profit that will result from each alternative will be determined by whether material costs remain stable, increase moderately, or increase significantly. In the payoff table below the estimated profits/losses are given in $thousands. Material Costs Stable Mega Centre Decision New Stores Leasing Determine the best decision using the Maximax decision criterion. 2130 Moderate Increase 1850 840 530 1050 940 O Decision: Mega Centre based on 2470 = max(2470,1850,1040) O Decision: Mega Centre based on 2130 = max(2130,1850,1040) Decision: Stable based on 2130 = max(2130,1050,1040) O Decision: Leasing based on 2820 = max(190,2750,2820) Significant Increase -2470 -150 1040
Hillary’s Flight Operations offers maintenance and repair services for business jets located in Atlanta. They are considering whether they should expand their operations. Hillary has decided that they have a number of options—four to be precise. They can keep their current facilities; they can modify their facilities to make them more efficient; they can expand their current facility; or they can rent additional space. The decision as to which option they should select is predicated upon the estimation of the direction of the economy for the next four years. Hillary’s Flight Operations developed the following decision matrix. What option should Hillary’s Flight Operations make based on Maximax criterion? Future Air Traffic Alternatives Down Same Up Keep As Is ($40,000) $70,000 $100,000 Remodel ($60,000) $65,000 $200,000 Expansion ($150,000) $50,000 $400,000 Rent ($50,000) $60,000 $80,000 Group of answer choices
The Aggies will host Tech in this year’s homecoming football game. Based on advance ticket sales, the athletic department has forecast hot dog sales as shown in the following table. The school buys premium hot dogs for $1.50 and sells them during the game at $3.00 each. Hot dogs left over after the game will be sold for $0.50 each to the Aggie student cafeteria, where they will be used in making hotdog casserole.Sales Quantity Probability2,000 0.103,000 0.304,000 0.305,000 0.206,000 0.10Use a payoff matrix to determine the number of hot dogs to buy for the game.
The owner of Genuine Subs, Inc., hopes to expand the present operation by adding one new outlet. She has studied three locations. Each would have the same labor and materials costs (food, serving containers, napkins, etc.) of $1.76 per sandwich. Sandwiches sell for $8.00 each in all locations. Rent and equipment costs would be $5,000 per month for location A, $5,500 per month for location B, and $5,800 per month for location C. a. Determine the volume necessary at each location to realize a monthly profit of $10,000. (Do not round Intermediate calculations. Round your answer to the nearest whole number.) Location Monthly Volume A B C b-1. If expected sales at A, B, and C are 21,000 per month, 22,000 per month, and 23,000 per month, respectively, calculate ge profit of the each locations? (Do not round Intermediate calculations. Round your answer to the nearest whole number.) Location A Monthly Profits B C b-2. Which location would yield the greatest profits? e here to search R T J O…
Which type of location analytics help Travelers expedite the claim process after a diaster? Prescriptive Descriptive Predictive
Given is a decision payoff table. Alternatives Low Future Demand Moderate High 91 130 102 81 Small Facility 111 Medium Facility 51 Large Facility -12 124 126 a) The best decision under uncertainty using MAXIMAX is to select Blank 1 facility b) The best decision under uncertainty using MAXIMIN is to select Blank 2 facility c) The best decision under uncertainty using LAPLACE/EQUALITY LIKELY is to select Blank 3 facility d) If the probabilities for Future Demand when it is Low = 0.35, Moderate = 0.30, and High = 0.35, the expected monetary value (EMV) for the large facility Blank 4. e) If the probabilities for Future Demand when it is Low = 0.35, Moderate = 0.30, and High = 0.35, the best decision under risk is to select Blank 5 facility.
The HERCULES company's Process Manager should decide the location of his company's facilities. He has come up with 4 options in 4 communities. The table below shows fixed (land purchase costs, taxes, insurance, machinery, building erection costs, etc.) and variable costs (wages, materials, transportation costs, etc.) for each option Community Issues: A B с D Fixed costs (Annual) $ 150,000 $ 300,000 $ 500,000 $ 600,000 Variable costs (per unit of product) $ 62 $ 38 $ 24 $ 30 (a) Calculate the range of output for which each community minimizes its production costs. (b) If the expected demand for the product is 15,000 units per year, in which community would you advise the process manager to locate his company's plant?
SOLVE USING EXCEL Metal Fabricators, Inc. manufactures gas grill tanks, Model # 1420, for four original equipment manufacturers (OEMs). Demand is forecast to be as follows: Quarter 1 = 2,800 tanks, Quarter 2 = 3,400, Quarter 3 = 3,600, and Quarter 4 = 2,900. Due to a hedging program for sheet steel and increases in international tariffs, production cost per quarter vary as follows: Quarter 1 = $23.50 per tank, Quarter 2 = $28.00, Quarter 3 = $25.90, and Quarter 4 = $29.00. Due to production contracts with the OEMs, no shortages are allowed. Beginning inventory for Quarter 1 is 300 tanks. At the end of each quarter, inventory holding costs are $4.25 per tank. a. Formulate the problem as a linear programming model (see Supplement D). b. Solve the model in (a) using Excel Solver.
The Candle Company plans to open a new retail store in Portland, Maine. The store will sell specialty candles for an average of $10 each. The average variable costs per candle are as follows: Wax $4 Other additives $2 Base $1 The company is negotiating its lease for the new location. The landlord has offered two leasing options: Option A) a lease of $2,500 per month; or Option B) a monthly lease cost of $2,000 plus 10% of the company's monthly sales revenue. The lease option that is more attractive for the company under its current sales expectations is option B, the fixed lease payment plus sales based commission because it results in the lowest total lease costs The indifference point is The company expects to sell approximately 400 candles per month. Requirement 2. At what level of sales (in units) would the company be indifferent between the two lease options? Show your proof. candles. Begin by selecting the equation to determine the indifference point. (Abbreviations used" FC =…