The owner of the Party City Toronto Company must decide among building a megacentre 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 materialcosts remain stable, increase moderately, or increase significantly. In the payoff tablebelow the estimated profits/losses are given in $thousands.Material CostsStableMegaCentreDecision New StoresLeasingDetermine the best decision using the Maximax decision criterion.2130ModerateIncrease18508405301050940O 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)SignificantIncrease-2470-1501040

Material CostsStableModerate IncreaseSignificant IncreaseDecisionMega Centre2130530-2470New…

Answered: The owner of the Party City Toronto…

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 manager must decide between two location alternatives, Boston and Chicago. Boston would have annual fixed costs of $70000, transportation costs of $60 per unit, and labor and material costs of $200 per unit. Chicago would have annual fixed costs of $90000, transportation costs of $40 per unit, and labor and material costs of $170 per unit. Revenue will be $300 per unit. 1. Which alternative would yeild the higher profit for an annual demand of 3000 units? 2. Would the two locations yeild the same profit at a certain volume? If so, at what volume would that be?
The owner of Pearl Automotive Dealers is trying to decide whether to expand his current facility. If he expands and customer demand turns weak, there is a chance he could lease part of his newly constructed facility to another dealer.If he doesn’t expand and strong demand occurs, he could attempt to lease another facility across town. Analyze the decision tree in Figure A8. What is the best set of decisions and the expected payoff?
In solving the given problem ,you may refer to the following payoff table: New bridge built No new bridge Alternative location A 1 14 for new warehouse B 2 10 C 4 6 1. Assume the payoffs represent profits. Determine the alternative that would be chosen under each of these decision criteria: A. Maximin B. Maximax C. Laplace 2. Using the information in the payoff table, develop a table of regrets, and then: A. Determine the alternative that would be chosen under minimax regret. B. Determine the expected value of perfect information using the regret table, assuming that the probability of a new bridge being built is 0.60. 3. Using the probabilities of 0.60 for a new bridge and 0.40 for no new bridge, compute the expected value for each alternative in the payoff table , and identify the alternative that would be selected under the expected-value approach. 4.…
A flood control reservoir project and channel improvement project are proposed for reducing flood damages along a stream in an urban area. Estimated costs are as follows: Dam and reservoir project Channel improvement project Initial investment $1,500,000 $1,200,000 Annual maintenance $10,000/yr $5,000/yr Hydrologic, hydraulic and economic studies have been conducted to develop the following relationships for the river reach and flood plain: (a) annual exceedance probability versus peak discharge with and without the reservoir, (b) discharge versus stage with and without the channel improvement, and (c) stage versus damage Annual Peak discharge Stage (ft) exceedance (cfs) probability Without With Discharge reservoir reservoir (cfs) Without With Stage Damage project project (ft) million) 0.50 3,000 2,700 0 0 0 9 0.0 0.20 5,400 0.10 7,600 4,200 3,500 5,000 10. 7 10 0.2 10,000 15° 11 15 1.1 0.05 10,400 5,500 15,000 20 14 20 2.2 0.02 0.01 19,000 0.005 24,000 20,000 15,000 8,600 20,000 23 17…
Zaki has been thinking about starting his own petrol station. He’s problem is to decide how large his petrol station should be. The annual return that will be achieved depends on whether the economy is good, fair, or poor. A payoff table has been constructed to illustrate this situation: (Business Quantitative Analysis) Determine using the best investment using the following decision criteria: a) Maximax criterion b) Maximin criterion c) Equally Likely criterion d) Minimax Regret criterion The probabilities of good market, average market, and poor market are 0.4, 0.5, and 0.1 respectively. Construct an expected opportunity loss table. Using minimum EOL as the decision criterion, determine the best alternative
Use the information of the following payoff table Size of Market factory nature Good Average Bad Factory A 400 300 -100 Factory B 700 500 -200 Factory C 1,100 600 -300 a) Which factory should be built if the investor is very optimistic? Very pessimistic? b) Which factory should be built using minimax regret criterion? c) If the probabilities of Good/Average/Bad market are 0.4, 0.3, and 0.3, respectively, what is the decision of the size of factory using Expected Opportunity Loss (EOL) criterion?
A television network earns an average of $1.6 million each season from a hit program and loses an averageof $400,000 each season on a program that turns out to be a flop, and of all programs picked up by thisnetwork in recent years, 25% turn out to be hits and 75% turn out to be flops. a) Construct a decision tree to help the television network identify the strategy that maximizes itsexpected profit in responding to a newly proposed television program. Make sure to label all decisionand chance nodes and include appropriate costs, payoffs and probabilities. b) What should the network do? What is their expected profit? c) The network can conduct market research to determine whether a program will be a hit or a flop. Ifthe market research report is perfectly reliable, what is the most the network should be willing to payfor it? Can you please include pictures of excel sheets. Having trouble determining what the excel sheet should look like
2. Garysburg Fire Rescue (GFR) is considering three different locations for a new fire station. Using factor rating, GFR has created the following table. When rating these locations, GFR used a 5- point scale, where 1 means unfavorable and 5 means excellent. (Noteshaper Scenario #26) Factor Weight Location 1 Location 2 Location 3 Cost of land 0.5 4 1 Accessibility 0.3 2 2 4 Size of Land 0.2 1 3 3 a. Which of the following statements are true and which are false? I. The cost of the available land parcel is of the greatest importance in this analysis. I. Location 2 has better accessibility than location 3. GFR considers the size of the available land parcel to be the least important III. factor.
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?
6

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