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
Suppose you plan to buy a new car and wish to pick a best one from a list of candidate models, shown in Table 1. To make this decision, you have designated a specialist to rate these models for you. In Table 2, each model has been given a score from 1 (the least desired) to 10 (the most desired) according to respective criteria. The weight of each criterion, representing its importance, is given in the bottom row of Table 1.
Please calculate the overall score for each car model and find out the best alternative with the highest overall score.
Table 1 Alternatives and Criteria of Selecting Car
Price
Fuel Efficiency
Maintenance
Access
Interior
Aesthetics
Overall Score
1. Toyota Camry
8
8
7
9
2. Hyundai Elantra
9
8
5
8
3.Skoda Octavia
7
7
7
8
4.VW Passat
7
7
8
7
5.Citroen C4
7
8
7
9
Weights
0.3
0.4
0.2
0.1
China Eastern Airlines…
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?
Solve the following decision tree and create risk profiles and cumulative risk profiles for the alternatives defined by the original decision “A” and “B” using precisionTree. Which alternative is preferred? Explain.
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
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardA real estate developer is looking into options to develop a 100,000 sq meters of land that he owns by the sea in a touristic Mediterranean city. The developer has completed a framing exercise during which a decision hierarchy was identified to guide the generation of alternative strategies. The following decisions were considered in the decision hierarchy: what type of development to build, how to finance this development, will we develop the full extent of the land, will we sell units before construction is complete, which contractor should we hire for the job. a)Classify the listed decisions into given, focus and non-focus decisions. b)For each focus decision identified above, propose two mutually exclusive options and develop a strategy table accordingly. c)Identify in the strategy table two alternative development strategies for the development. d)List one value measure that will guide the decision of the developer to decide on preferred development alternative.arrow_forward
- The following payoff table provides profits based on various possible decision alternatives adn various levels of demand at Robert Klassan's print shop: decision low high alt 1 $10,000 $36,000 alt 2 $6,000 $38,000 alt 3 -$2500 $52,000 The probability of low demand is 0.40 whereas the probability of high demand is 0.60. a) The alternative that provides Robert the greatest expected monetary value is _________ The EMV for this decision is $_______ b) The expected value with perfect information (EVwPI)= $______ c) The expected value of perfect information (EVPI) for Robert= $________arrow_forwardDwayne 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 numarrow_forwardWhat is the best of the worst decision alternative? DİHL Co. is a Danao-based logistics company owned by Engr. Donald H. Lalican. Anticipating the growing demand for delivery services, he developed a strategic plan for the year 2022. The options are to hire additional delivery crews in their Mandaue facility, construct a new facility in Talisay City, or subcontract Ohlala Move, a small-time company. A study conducted by the marketing department forecasted the following payoff values, which are summarized in the table below. The values are expressed as gains and alpha = 0.6. States of Nature Decision Alternatives Failure Low Moderate High Hire additional Drivers in Mandaue -450,000 -250,000 250,000 500,000 Construct a facility in Talisay -800,000 -400,000 300,000 700,000 Subcontracting Ohlala Move -100,000 -10,000 150,000 300,000 Hire Additional Drivers in Mandaue Construct a Facility in Talisay O Subcontracting Ohlala Move Both Construct a Facility in Talisay and Subcontracting Ohlala…arrow_forward
- Al Khoud Airlines is planning to introduce a new flight service between Khasab in Musandam Governorate and Salalah in Dhofar Governorate. The following budgeted costing and pricing data are available: Ticket Price A OMR88 Ticket Price B OMR188 Variable Cost for Price A OMR54 Variable Cost for Price B OMR58 Targeted Sold Seats for Price A: Targeted Sold Seats for Price B: Business Business - Tourism 27,400 Other Fixed Costs 80 100 Tourism 160 40 Fuel Costs (Fixed) 138,000 The Company assumes that: Tourism travelers would normally start their travel during one week, spend at least one weekend at their destination and return the following week or thereafter; Business travelers usually start and complete their travel within the same work week. They do not stay over weekends. Suggest at least TWO measures for each dimension in assessing AI Khoud's performance using the Balance Score Card approach.arrow_forwardThe following payoff table provides profits based on various possible decision alternatives and various levels of demand. ALTERNATIVE DEMAND LOW MEDIUM HIGH Alternative 1 40 80 150 Alternative 2 80 120 130 Alternative 3 100 100 100 a. Which alternative should be chosen using the equally likely decision criterion? b. Set-up the opportunity loss table. c. Which alternative should be chosen using the minimax regret criterion?arrow_forwardAdam has been offered to open up a Service station. However, the size of the establishment will be based on his decision. The annual return and investment required will be based on both size and market condition. To help out in the decision making, Adam has done the analysis and the expected profit/loss are shown in the table: What is the maximax,maximin and equally likely decision? Develop a decision treearrow_forward
- The Irontown Independent School District wants to sell a parcel of unimproved land that it does not need. Its three best offers are as follows: Organization/Company Offer Proposed Use The State Department of Public Safety (DPS) $5.7 million New state highway patrol barracks The Lexington Presbyterian Church $5.6 million Start a church school Newberry Inc. $5.5 million Open a car dealership As the financial adviser for the school district, which offer would you prefer?arrow_forwardLeisure Corporation’s decision to produce a new line of recreational products resulted in the need to construct either a small plant or a large plant. The best plant size depends on how the marketplace reacts to the new product line. To conduct an analysis, marketing management has decided to view the possible long-run demand as low, medium, or high. The following payoff table shows the projected profit in millions of dollars: Profits Long-Run Demand Low Medium High Small Plant 150 200 200 Large Plant 50 200 500 If Leisure Corporation has an extremely pessimistic outlook on demand, would it build a small or a large plant? If Leisure Corporation wanted to minimize the maximum opportunity losses (regrets), would it build a small or a large plant?arrow_forwardShawna is the marketing manager for Yummy Marinades and Dips. The company wants to should introduce a new cooking sauce product line with the brand Con-Cook-Tions. Shawna is deciding if she would initially do a test market in selected cities on the East Coast or do a big national product launch. The cost of doing the test market is $150,000. If Shawna does the test market, she has to wait for the results of the test market before she decides to do a nationwide launch of Con-Cook-Tions. The probability of a positive response from the test market result is estimated to be 0.6. Alternatively, Shawna could also decide to bypass the test market and go ahead with the national launch. If Con-Cook-Tions is launched nationally and becomes a huge success, the company estimates that it will realize an annual profit of $1.6 million. If the launch fails and the market reacts negatively to the sauces, Yummy will incur a loss of $700,000. Shawna company believes the probability of success for…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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