### Decision Analysis Based on Profit MatrixWhen making decisions based on different scenarios, it is important to consider various decision-making criteria. Below is the given profit matrix, which will be used to decide the best alternative by considering Expected Value, Savage Regret Minimax, and EVPI (Expected Value of Perfect Information).#### Profit Matrix:| Probability | S1 (0.20) | S2 (0.30) | S3 (0.50) ||-------------|-----------|-----------|-----------|| A | 50 | -10 | 90 || B | 80 | 0 | 50 || C | 40 | 20 | 60 |#### Decision Criteria:1. **Expected Value**: - Calculate the expected profit for each alternative. - Formula: \[ EV = (Probability\ of\ S1 \times Profit\ in\ S1) + (Probability\ of\ S2 \times Profit\ in\ S2) + (Probability\ of\ S3 \times Profit\ in\ S3) \]2. **Savage Regret Minimax**: - Calculate the regret for each alternative in each state. - Regret is the difference between the highest possible profit in a state and the profit obtained by that alternative in the same state. - Use these regrets to determine the minimax decision, which minimizes the maximum regret. 3. **EVPI (Expected Value of Perfect Information)**: - Calculate EVPI which represents the average amount we would be willing to pay to gain perfect information. - Formula: \[ EVPI = (Maximum\ of \ Expected\ Value\ for\ each\ state) - (Expected\ Value\ of\ the\ optimal\ alternative\ without\ perfect\ information) \]### Steps to Draw Decision Tree and Decide Based on Each Criterion:1. **Expected Value**: - Calculate for each alternative. - Example calculation for Alternative A: \[ EV_A = 0.20(50) + 0.30(-10) + 0.50(90) = 10 + (-3) + 45 = 52 \] 2. **Savage Regret Minimax**: - Identify the maximum profit for each state. - Calculate regret for each alternative.

Answered: Given the following profit matrix. Draw…

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...

See similar textbooks

Similar questions

5. The manager of a fast-food restaurant featuring hamburgers is adding salads to the menu. If they choose to include a salad bar (i.e., the MAKE option), it will cost $14,000 in annual fixed costs for the leased equipment and added employee, and $1 per salad variable cost. If they choose to have pre-made salads (i.e., the BUY option), it will cost $3 per salad. The manager expects to sell 7,500 salads per year. What is the make or buy quantity (i.e., the breakeven point between making vs. buying)?
Maximax, Maximin, Minimax RegretLearning material: Watch this videoLab Scenario:Imagine a local entrepreneur is considering starting a business and has three options: open a coffeeshop, a bookshop, or a fusion coffee-bookshop. The entrepreneur is uncertain about the market'sreaction to these businesses. The possible market conditions are: favorable, neutral, and unfavorable.Data (Payoff Table in USD):Business Option Favorable Market Neutral Market Unfavorable MarketCoffee Shop 150,000 70,000 -30,000Bookshop 100,000 60,000 -20,000Fusion Shop 130,000 80,000 -10,000Positive values represent profits, and negative values represent losses.Assignment Steps:1. Maximax (Optimist's Criterion) Approach:For each business option, identify the maximum possible payoff.First Question What is the business option with the highest of these maximum payoffs? (5points)2. Maximin (Pessimist's Criterion) Approach:For each business option, identify the minimum possible payoff.Second Question What is the…
Answer properly please, and format your answer/work so it's clear to follow
PLEASE Make a decision tree diagram and show all payoffs!!! You are a logistics manager for Alphasmart, a smartphone manufacturer. You are trying to selecta single supplier for the raw materials for your product. Two companies can provide the necessarymaterials – Hunts and Madis.Hunts has sufficient capacity to meet your demand and charges $5.00 per unit. Madis is a smallsupplier with a limited capacity, can supply up to 36,000 units per year, and charges $4.50 perunit of the raw material. If you do not get raw material from your supplier, you buy from the spotmarket at $10 per unit.Alphasmart sold 30,000 smartphones last year and estimates demand for smartphones to go up by20% with a probability of 60 percent and to remain the same as last year with a probability of40% for the first year. The same percentage increase in demand and probability would apply forthe second year as well. Alphasmart uses a discount rate of 10 percent. Assume all costs areincurred at the end of the year and…
Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, whereas 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. Demand Volume Decision Low Medium High Basic model $90,000 $110,000 $155,000 Advanced model $60,000 $135,000 $190,000 Fill in the table below for maximum and minimum profit payoffs under each model. Round your answers to the nearest dollar. Decision alternative Maximum Minimum Basic model $ $ Advanced model $ $ Calculate the amounts foregone by not adopting the optimal course of action for each possible demand level. Determine the maximum opportunity cost for each model. Fill in the table below. If your answer is zero, enter "0". Round your answers to the nearest dollar. Opportunity Loss Matrix Future events Decision alternative Low Medium High Maximum…
Typed plz and Asap thanks
I need typing clear urjent no chatgpt use i will give 5 upvotes
Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, whereas 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. Demand Volume Decision Low Medium High Basic model $65,000 $100,000 $180,000 Advanced model $55,000 $105,000 $205,000 Fill in the table below for maximum and minimum profit payoffs under each model. Round your answers to the nearest dollar. Decision alternative Maximum Minimum Basic model $ $ Advanced model $ $ Calculate the amounts foregone by not adopting the optimal course of action for each possible demand level. Determine the maximum opportunity cost for each model. Fill in the table below. If your answer is zero, enter "0". Round your answers to the nearest dollar. Opportunity Loss Matrix Future events Decision alternative Low Medium High Maximum Basic…
ABC company wants to open one, two, or three shops. The average Profit varies with the demand in three categories low, medium and high. Determine which one is better using Maximax, Maximin, Laplace, Minimax regret. Demand Number of Shops 1 2 3 Low 150 175 200 Medium 100 200 200 High 0 170 400 I don't want the solution with excel
Lakewood Fashions must decide how many lots of assorted ski wear to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table, in thousands. Order size 1 lot 2 lots 3 lots (a) Show a regret table. Order size 1 lot 2 lots 3 lots 13 9 6 Low 13 9 6 Low Demand Medium 16 24 32 16 24 32 High 16 32 61 Demand Medium (b) What decision should be made by the optimist? O 1 lot O2 lots 3 lots 16 32 61 High Maximum Regret 2:06 PM
II. + James Scott is considering the possibility of opening a small outfit shop on Sta. Maria District, a few blocks from St. Green Ville College. She has located on a mall that attracts students. To open a small shop, medium sized shop, or no shop at all are her options. The market can be good, average, or bad. The probabilities for these three possibilities are 30% for good market, 50% for an average market, and 20% for bad market. The profit or loss for the said market conditions are given in the table below; ALTERNATIVE Small Shop Medium Sized Shop No Shop GOOD 150,000 200,000 0 AVERAGE 50,000 70,000 0 a) Calculate the Expected Value of Perfect Information (EVPI) b) What do you recommend? BAD -80,000 -120,000 0
kindly do solve accurately and exact with correct formuas thanks..with complete steps

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Given the following profit matrix. Draw the decision tree and decide which alternative you choose based on: probability (-20) (.30) (50) a. Expected Value $1 $2 $3 b. Savage regret minimax A 50 -10 c. EVPI B 80 0 C 20 Alternate 40 90 50 60