Estimate the payoff for each alternative in each event

Assignment Help Managerial Accounting

Reference no: EM131308857

Decision Making Under Uncertainty

Problem Description

Mangers deal with a number of decisions about processes, capacity, location, inventory, etc. The process of making a decision is complicated because of the uncertainties of the future. This implies that the future outcomes of alternatives that we consider today are in doubt.

The aim of this project is to build a decision support system that allows the user to make decisions under uncertainty. We describe a systematic approach that can be used by managers in the process of making decisions. To learn more about decision making under uncertainty, we refer the students to Krajewski and Ritzman (2002).

Solution approach

Step 1:

List the feasible alternatives.

Step 2:

List the events that have an impact on the outcome of each alternative but are not under managers' control.

Step 3:

Estimate the payoff for each alternative in each event.

Step 4:

Estimate the likelihood of each event using past data, executive opinion, or other forecasting methods.

Step 5:

Select a decision rule to evaluate the alternatives, such as choosing the alternative with the lowest expected cost or choosing the alternative with the maximum expected profits.

The following are decision rules to help the managers select an alternative.

Maximin: Choose the alternative that is the "best of the worst." This rule is for the pessimist who anticipates the "worst case" return for each alternative.

Maximax: Choose the alternative that is the "best of the best." This rule is for the optimist who anticipates the "best case" return for each alternative.

Laplace: Choose the alternative with the best-weighted payoff. To find the weighted payoff, give equal importance to each event. For example, if there are n events, the probability assigned to each event is 1/n. This rule is for the realist.

Minimax: Choose the alternative that gives the best "worst regret." Calculate a table of regrets in which the rows represent the alternatives and the columns represent the events. A regret is the difference between a given payoff and the best payoff in the same column. For an event, it shows how much is lost by picking an alternative to the one that is best for this event. The regret can be lost profit or increased cost, depending on the situation.

User Interface

1. Build a welcome form.

2. Build a data analysis form. The following are suggestions to help you design this form.

a. Insert two text boxes where the user types in the total number of events (n) and the total number of alternatives (m). Upon submission of this information a table appears. This table has dimensions m by n. The user types in this table the payoff of each alternative in each event. Label the rows by the name of alternatives. Label the columns by the name of events.

b. Insert a command button titled "Enter the Likelihood of Events." When the user clicks on this button, a table with dimensions 1 by n appears. The user types in this table the likelihood of each event, if this information is available.

c. Insert a frame named "Selection Rules." The frame includes five option buttons and a command button. The option buttons enable the user to select one of the following decision rules: maximin, maximax, Laplace, minimax regret and expected payoff. When the user clicks on the command button, the decision rule chosen applies, and the user is prompted about the best alternative found. Note that the expected payoff decision rule applies in the case that the user has provided information about the likelihood of the events.

3. Build a form that allows the user to access the reports created.

Design a logo for this project. Insert this logo in the forms created above. Pick a background color and a font color for the forms created. Include the following in the forms created: record navigation command buttons, record operations command buttons, and form operations command buttons as needed.

Reports

1. Present the table of regrets for the proposed alternatives.

2. Report the best alternative found using the maximin, maximax, Laplace, minimax regret and expected payoff methods.

Reference

Krajewski, L.J., Ritzman, L.P., "Operations Management: Strategy and Analysis." Prentice Hall, 6th Ed., 2002.

Reference no: EM131308857

Questions Cloud

Perform present value analysis on each investment : A firm has the following investment alternatives: Cash Inflows Year A B C 1 $500 $0 $0 2 500 400 0 3 500 800 0 4 600 900 1,900 Which investment should be considered? (for any credit, show your work). Use a 9.5% discount rate. Hint: A discount rate gi..

Create an outline of topics for your presentation : Brainstorm a list of topics for your presentation. Consider what would be valuable to your audience.- Create an outline of topics for your presentation. Plan on a logical sequence.

Implementing change within an organization : What types of obstacles/objections do leaders face from stakeholders when implementing change within an organization? What strategies can leaders use to work with stakeholders, remove obstacles, and address objections?

Assume the market is in equilibrium with required return : Constant Growth Rate, g A stock is trading at $85 per share. The stock is expected to have a year-end dividend of $6 per share (D1 = $6), and it is expected to grow at some constant rate g throughout time. The stock's required rate of return is 11% (..

Estimate the payoff for each alternative in each event : Estimate the payoff for each alternative in each event. List the events that have an impact on the outcome of each alternative but are not under managers' control.

Write term paper-an argumentative paper on a relevant topic : Term Paper-an argumentative paper on a relevant topic. A useful writing prompt has been provided in the question area. Grade will take into account the topic choice, writing ability, and essay structure as well as other factors.

Create a competitive advantage as a result : The Panama Canal is undergoing a major widening. As a port owner/administrator what would you do to create a competitive advantage as a result of the widening and the post-Panamax hulls?

Horizon value of free cash flows current : Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual Projected 2015 2016 2017 2018 Free cash flow $607.00 $667.68 $707.73 $750.19 (millions of dollars) Growth is expected to be co..

Prepare and deliver a team presentation : Prepare and deliver a team presentation.- Assign either the pro or the con side of one of the given topics.- Drug testing should be mandatory for all employees.

User Account

All Pages