Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Dwayne Whitten, president of Whitten Industries, is
considering whether to build a manufacturing plant in north Texas. His decision is summarized in the following table:
Alternatives
Favorable Market
Unfavorable Market
Build large plant
$400,000
−$300,000
Build small plant
$120,000
−$15,000
Don't Build
$0
$0
Market Probability
0.40
0.60
a) The correct decision tree for Dwayne is shown in
Figure ____
(all
payoffs are in
thousands).
b) To maximize the return, Dwayne's decision should be to ______
.
c) For Dwayne, the expected value of perfect information (EVPI) =
$___________
(enter your answer as a whole num
The Zhao family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria weights
and location ratings follow. What is the recommended vacation location?
Criteria
Travel distance
Vacation
Entertainment available
Outdoor activities
Unique experience
Family fun
O Myrtle Beach, South Carolina
OSmoky Mountains
Branson, Missouri
Weight
2
5
3
2
4
5
Myrtle Beach,
South Carolina
5
5
7
9
5
8
Ratings
Smoky
Mountains
9
6
4
6
9
9
Branson,
Missouri
3
8
4
5
9
8
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
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- John and Jane Darling are newlyweds trying to decide amongseveral available rentals. Alternatives were scored on a scaleof 1 to 5 (5 = best) against weighted performance criteria,as shown in Table 13.7. The criteria included rent, proximity to work and recreational opportunities, security, and otherneighborhood characteristics associated with the couple’svalues and lifestyle. Alternative A is an apartment, B is abungalow, C is a condo, and D is a downstairs apartment inJane’s parents’ home.Which location is indicated by the preference matrix? Whatqualitative factors might cause this preference to change?arrow_forwardDetermine the best crop to plant, using the following decision criteria: a) Maximax b) Maximin c) Minimax Regret d) Hurwicz (alpha = 0.30) e) Equal Likelihood f) What coefficient of pessimism should a farmer have so that he is indifferent on his decision to either plant corn or peanuts?arrow_forwardABC is a small chain of stores specializing in casual cotton clothing. The co. currently has 5 stores and wants to open a new one in one of 3 locations. Five factors are being considered for this decision. The weights and scores assigned by a hired consultant are as follows; Location factor College proximity Median income Vehicle traffic Mall quality & size Proximity to shopping Weight 0.30 0.25 0.25 0.10 0.10 Scores (0 to 100) Mall 1 Mall 2 Mall 3 90 65 79 80 50 40 60 75 80 60 90 90 100 80 30 Required Given that all the sites have basically the same leasing costs and labor and operating costs, advice ABC on where to locate the new store.arrow_forward
- A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? is/are best and 4 8 is/are least desirable.arrow_forwardThe owner of a food truck implemented a new location strategy so that they would be better positioned near a crowded office park during the lunch hour. How should they evaluate the new location strategy?arrow_forwardA landowner is considering a community development project. Even though he realizes that the current market for housing is not very favourable, he believes that there will be an influx of retirees into the area within the next five years. He is trying to decide between two alternatives: (1) building detached homes in a planned retirement community or (2) building a smaller townhouse/condominium complex. Mortgage interest rates will affect his outcomes as shown (in $ millions) in the accompanying payoff table. According to the maximax approach, what should the landowner do? Click the icon to view the payoff table. ..... A. Build townhouses/condominiums B. Build detached homes in a planned retirement community if interest rates go up, otherwise build townhouses/condominiums C. Build detached homes in a planned retirement community D. Build detached homes in a planned retirement community if interest rates go down, otherwise build townhouses/condominiums O E. Build detached homes in a…arrow_forward
- The Dynaco Manufacturing Company is to build a new plant to make ring bearings (used in automobiles and trucks). The site selection team is evaluating three sites, and it has graded the important weighted criteria for each as follows: Develop a scoring model to determine which site the selection team should recommend.arrow_forward← Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C, or D. The following table shows the results thus far obtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factor scoring is 1 through 5. Factor 1 2 3 4 6 7 Factor Description Quality of labor Construction cost Transportation costs Proximity to Markets Taxes Weather Energy costs a) Based on the given information, the best site for Daniel Tracy is D with a total weighted score of B Weight 10 7 7 8 A 6 5 A 5 3 4 2 B 2 5 3 2 5 4 Site Scores C 5 4 4 4 3 4 4 (Enter your response as an integer.) D 3 1 2 3 4 3arrow_forwardThe director of career advising at Orange Community College wants to use decision analysis to provide information to help students decide which 2-year degree program they should pursue. The director has set up the following payoff table for six of the most popular and successful degree programs at OCC that shows the estimated 5-year gross income ($) from each degree for four future economic conditions: Determine the best degree program in terms of projected income, using the following decision criteria: a. Maximax b. Maximin c. Equal likelihoodarrow_forward
- Harden College is contemplating opening a Europeancampus where students from the main campus could go to take courses for 1 of the 4 college years. At the moment, it is con-sidering five countries: The Netherlands, Great Britain, Italy, Belgium, and Greece. The college wishes to consider eight factorsin its decision. The first two factors are given weights of 0.2, whilethe rest are assigned weights of 0.1. The following table illustratesits assessment of each factor for each country (5 is best). issuearrow_forwardAnswer choices: A: 67, 0, 250 67, 0, 250 67, 0, 250 B: SIte 1, Site 2, Site 3 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardImagine that Mary is planning a vacation and has to choose between two vacation spots. Based onthe information, if asked to choose the best spot, which would Mary choose? If asked to reject achoice, which vacation spot would Mary reject? Why?Spot Aaverage weatheraverage beachesmedium-quality hotelmedium-temperature wateraverage nightlifeSpot Blots of sunshinegorgeous beaches and coral reefsultra-modern hotelvery cold watervery strong windsno nightlifearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY