Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, while the advanced model is faster but costs more. Profitability will depend on future demand. The following table presents an estimate of profits over the next three years.    Decision  Low  Medium  High  Basic Model  $65,000  $85,000  $125,000  Advanced Model  $70,000  $140,000  $240,000      Given the uncertainty associated with the demand volume and no other information to work with, how would you make a decision?    Use the Excel template Decision Analysis and explain your reasoning.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 21P
icon
Related questions
Question

Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, while the advanced model is faster but costs more. Profitability will depend on future demand. The following table presents an estimate of profits over the next three years.

 

 Decision

 Low

 Medium

 High

 Basic Model

 $65,000

 $85,000

 $125,000

 Advanced Model

 $70,000

 $140,000

 $240,000

 

  

Given the uncertainty associated with the demand volume and no other information to work with, how would you make a decision? 

 

Use the Excel template Decision Analysis and explain your reasoning.

Expert Solution
steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
Knowledge Booster
Data analytics tools
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Purchasing and Supply Chain Management
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