The career counselor at Mountain Peak College has a tough job. She is expected to provide information to help students decide which major they should take. The counselor knows that she can use quantitative analysis to help her with her work. She did a survey and came up with six most popular degree programs at her college. One of the biggest factors she considered was the “earning” power of the degree in four different economic conditions. The table below presents the information she collected on the degree programs. The amounts shown are 3-year gross salaries of the alumni she surveyed. During recession: Game design engineer = $145k Nursing = $150k Hospitality = $115k Business = $130k Biotechnology = $115k Computer Science = $125k During average economy: Game design engineer = $175k Nursing = $180k Hospitality = $165k Business = $180k Biotechnology = $145k Computer Science = $150k During good economy: Game design engineer = $220k Nursing = $205k Hospitality = $220k Business = $210k Biotechnology = $235k Computer Science = $190k During a bullish economy: Game design engineer = $260k Nursing = $215k Hospitality = $320k Business = $280k Biotechnology = $305k Computer Science = $250k The college offered to pay for a projection of the probability of each economic condition over the next 3 years. The research company estimated that:   P(recession) = 0.20; P(average economy) = 0.40; P(good economy) = 0.30; P(bullish economy) = 0.10 What you need to do: 1) Build the payoff table showing the 3-year gross salaries of the different careers. 2) Determine the best degree program in terms of the projected gross salary using the following approaches: Maximax Laplace Hurwicz (α=.50) Expected value 3) Determine what degree program the career counselor should recommend to the students. 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 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

The career counselor at Mountain Peak College has a tough job. She is expected to provide information to help students decide which major they should take. The counselor knows that she can use quantitative analysis to help her with her work. She did a survey and came up with six most popular degree programs at her college. One of the biggest factors she considered was the “earning” power of the degree in four different economic conditions. The table below presents the information she collected on the degree programs. The amounts shown are 3-year gross salaries of the alumni she surveyed.

During recession:

Game design engineer = $145k

Nursing = $150k

Hospitality = $115k

Business = $130k

Biotechnology = $115k

Computer Science = $125k

During average economy:

Game design engineer = $175k

Nursing = $180k

Hospitality = $165k

Business = $180k

Biotechnology = $145k

Computer Science = $150k

During good economy:

Game design engineer = $220k

Nursing = $205k

Hospitality = $220k

Business = $210k

Biotechnology = $235k

Computer Science = $190k

During a bullish economy:

Game design engineer = $260k

Nursing = $215k

Hospitality = $320k

Business = $280k

Biotechnology = $305k

Computer Science = $250k

The college offered to pay for a projection of the probability of each economic condition over the next 3 years. The research company estimated that:

 

P(recession) = 0.20; P(average economy) = 0.40; P(good economy) = 0.30; P(bullish economy) = 0.10

What you need to do:

1) Build the payoff table showing the 3-year gross salaries of the different careers.

2) Determine the best degree program in terms of the projected gross salary using the following approaches:

    • Maximax
    • Laplace
    • Hurwicz (α=.50)
    • Expected value

3) Determine what degree program the career counselor should recommend to the students. Explain your reasoning.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Economic trends
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
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
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
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.