Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

Please complete all work in excel.  Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.  You must have an excel file with formulas within the cell.

  • A brokerage firm is considering investment options for its clients. If the market is good the clients could get a net profit of $120,000 for Fund A, $100,000 for Fund B, and $80,000 for Fund C.  If the market is fair, they could get a net profit of $20,000 for Fund A, $40,000 for Fund B, and $30,000 for Fund C.  If the market is poor, clients would lose $30,000 for Fund A, $50,000 for Fund B, and $15,000 for Fund C.  They must Fund one to invest in for their clients.  An economist group offers to do a market study for $2,000.  They know the following probabilities:

              P(good market Fund A | favorable study) = 0.6

              P(fair market Fund A | favorable study) = 0.3

              P(poor market Fund A | favorable study) = 0.1

              P(good market Fund A | unfavorable study) = 0.2

              P(fair market Fund A | unfavorable study) = 0.1

              P(poor market Fund A | unfavorable study) = 0.7

              P(good market Fund B | favorable study) = 0.8

              P(fair market Fund B | favorable study) = 0.1

              P(poor market Fund B | favorable study) = 0.1

              P(good market Fund B | unfavorable study) = 0.2

              P(fair market Fund B | unfavorable study) = 0.3

              P(poor market Fund B | unfavorable study) = 0.5

              P(good market Fund C | favorable study) = 0.6

              P(fair market Fund C | favorable study) = 0.2

              P(poor market Fund C | favorable study) = 0.2

              P(good market Fund C | unfavorable study) = 0.2

              P(fair market Fund C | unfavorable study) = 0.2

              P(poor market Fund C | unfavorable study) = 0.6

              P (favorable study) = 0.6

              P (good market) = 0.4

              P (fair market) = 0.4

              P (poor market) = 0.2

1. Calculate EMVs 

Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Operations Management
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
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
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
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.