Ken Gilbert owns the Knoxville Warriors, a minor league baseball team in Tennessee. He wishes to move the Warriors south, to either Mobile (Alabama) or Jackson (Mississippi). The table below gives the factors that Ken thinks are important, their weights, and the scores forMobile and Jackson.FactorWeightMobileJacksonIncentive0.408560Player satisfaction0.302045Sports interestSize of city0.2040850.106535a) Based on the given information, the best location for the Warriors to relocate to iswith a total weighted score of(Enter your response rounded to two decimal places.)b) Jackson just raised its incentive package, and the new score is 80. Why doesn't this impact your decision in part (a)?A. Even if the score is 80, Jackson will stay as the second choice.○ B. Because Jackson is already the better site.OC. Even if the score is 80, Jackson's total weighted score drops to 60, just ahead of Mobile.

FactorWeightMobileJacksonIncentive0.408560Player satisfaction0.302045Sports interest0.204085Size of…

Answered: Ken Gilbert owns the Knoxville…

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

In 2020, Wesley has a fairly simple tax situation with moderate wage income and a modest amount of interest income. Wesley, age 45, wishes to use the easiest possible tax form. He may file:
FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?
Oscar's Bowling, Inc., wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys. It, however, only has enough capital to build one facility. Oscar wants it to be centered by population, as determined by the center of gravity method. The following information is given: City Population x coordinate y coordinate Tempe 275,000 5 5 Scottsdale 415,000 5 10 Chandler 310,000 5 0 Mesa 660,000 10 1 Glendale 335,000 1 10 a. Where should Oscar build? Oscar should build at an x coordinate of nothing and a y coordinate of nothing. b. If Oscar wanted to relocate to the closest city near his new facility, where would he live? (Enter your responses rounded to one decimal place.)
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40.a. Analyze using a tree diagram.
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40. 1- Compute the EVPI 2- Determine the range over which each alternative would be best in terms of the value of P ( low demand )
A franchise operation that sells frozen custardintends to open one or more new stores in amedium-sized metropolitan area. Three sitesare under consideration. Each site hassomewhat different projected profitcontribution and different supervisionrequirements. The first site has an estimateddaily profit of $200 and a weekly supervisionrequirement of 48 hours; the second site has aprojected profit of $100 per day and a weeklysupervision requirement of 30 hours; and thethird site has an estimated daily profit of $150and a weekly supervision requirement of 20hours. The firm will have 65 hours available forper week for supervision.Use Excel to determine which site or sitesshould be selected in order to obtain thehighest projected daily profit?
The CEO of Lucky Petroleum Co. has been considering to open a new gasoline statioin. He must decide how large the station should be. The annual returns (IDR billions) will depend on both the size of the station and market factor. After a careful analysis he developed the following table: Size of Station Good Market Fair Market Poor Market Small 50 20 -10 Medium 70 30 -20 Large 100 50 -30 Probability 0.5 0.3 0.2 Compute the expected value of each alternative size of station, and select the best decision. Construct the opportunity loss table and determine the best decision. Compute the expected value of perfect information.
Oscar's Bowling, Ic., wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys. It, however, only has enough capital to build one facility. Oscar wants it to be centered by population, as determined by the center of gravity method. The following information is given: City Population x coordinate y coordinate Tempe 285,000 Scottsdale 350,000 10 Chandler 725,000 5 Mesa 300.000 10 1 Glendale 345,000 1 10 a. Where should Oscar build? Oscar should build at an x coordinate of and a y coordinate of . (Enter your responses rounded to one decimal place.)
Suppose a payoff table for player 1 in a two person zero sum game is a follows where both the players have three strategy: Player-2 Player-1 1 2 3 1 1 -3 4 2 7 5 -1 3 5 4 -3 Find the optimal strategy for player 1 using graphical procedure. Also find the value of that game. Is it a fair game? Justify your answe.
Brandon is considering expansion of a store. If he expands, the interest rate at which he borrows the money is the important factor. He is not sure what kind of interest rate will be obtained. If he does not expand, the only factor influencing the outcome is future economy. The following table summarizes the situation: Probabilities Payoff Expand Large Favorable interest .3 $60k Neutral interest .5 $30k Unfavorable interest .2 ‑$70k Expand Small Favorable interest .3 $50k Neutral interest .5 $30k Unfavorable interest .2 ‑$30k Do not expand…
1. Kirsten is trying to decide where to go for her well-earned vacation. She would like to camp, but if the weather is bad, she will have to go to a motel. Given the costs and probabilities of bad weather given below, which destination should she choose? Camping cost Motel cost Probability of bad weather Nevada $21.2 $80.9 0.2 Oregon $15.9 $84.6 0.4 California $30 $95 0.1 a. California, because its EMV = $33.14 b. Nevada, because its EMV = $33.14 c. California, because its EMV = $36.5 d. Any of the 3 choices. e. Oregon, because its EMV = $43.38 f. Nevada, because its EMV = $43.38 g. None of the 3 choices. h. Oregon, because its EMV is $36.50.
A battery manufacturing plant has been ordered to cease discharging acidic waste liquids containing mercury into the city sewer system. As a result, the firm must now adjust the pH and remove the mercury from its waste liquids. Quotations from three firms are included in the following table of costs. Bidder Installed Cost Annual Operating Cost Annual Income from Mercury Recovery Salvage Value Foxhill $ 70,000 $5000 $6500 $10,000 Instrument Quicksilver 50,000 5000 2500 0 Almaden 90,000 5000 7800 10,000 If the installation will last 15 years and money is worth 12%, which equipment should be purchased?

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