Revise the Excel spreadsheet in Figure 8.1 to create a template for a decision with four alternatives
Question:
Revise the Excel spreadsheet in Figure 8.1 to create a template for a decision with four alternatives and four outcomes.
Figure 8.1
Transcribed Image Text:
IF function is used to identify the best alternative. Identifies maximum Identifies minimum payoff. payoff. Thompson Lumber (Dec Making Under Uncertainty) PAYOFFS Outcomes Modera de Maximan Masimin in payolf MNBS.05) Rdemand Low deman -120000 Choce FIES-MAXESE37 Besr Fite-MAXIESS EST Best Choice F35-MAXOS5 G57 Besr FIG-MAGSS GS7) Best Alternatives Large plant 200000 Smal plant No plant -MAX(BS 05) -MAXDE DE) 100000 90000 s0000 20000 PAYOFS 10 Ainernative H Large plant 12 Smal pant 13 No plant 14 Outcomes Tar mare Hurwicz Eeually kely Poor markel -120000 20000 Realem payolf Chece Averaga payel Choice 200000 100000 50000 -FS14MAX(B12 012)-(1-FS14N812012) FE12-MAXIES11ES13 Besr AVERAGEIBI2012) FG12-MANOS11.GS13 Beatr 045 -15 16 REGET 17 ARernatives 18 Large plantMAXBSS B85 -MAXICSS.CSCS MANOSSOSOSMAXS1801E 19. Smal plant 20 No p Outcomes Loderae demand Manimaxi AVERAGE function is used to calculate Nigh Cemand Lew demand Oce FE1-NES1SES20), Best SFIE-NES1SES20 Best -MAXBS5.557-88 -MAKICS5 CS7-08 -MAXOSS.DS708-MAXB1901) equally likely payoffs. Formula to calculate regret values Identifies maximum - a x maximum payoff + (1-a) x minimum payoff regret.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 44% (9 reviews)
To revise the Excel spreadsheet in Figure 81 to create a template for a decision with four alternatives and four outcomes you would follow these steps ...View the full answer
Answered By
Fahmin Arakkal
Tutoring and Contributing expert question and answers to teachers and students.
Primarily oversees the Heat and Mass Transfer contents presented on websites and blogs.
Responsible for Creating, Editing, Updating all contents related Chemical Engineering in
latex language
4.40+
8+ Reviews
22+ Question Solved
Related Book For
Managerial Decision Modeling Business Analytics With Spreadsheet
ISBN: 9781501515101
4th Edition
Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson
Question Posted:
Students also viewed these Business questions
-
Revise the Excel spreadsheet in Figure 8.3 to create a template for a decision with four alternatives and four outcomes. Figure 8.3 A. D. E 1 Thompson Lumber (Dec Making Under Risk) 3 PAYOFFS...
-
A decision maker faced with four decision alternatives and four states of nature develops the following profit payoff table. The decision maker obtains information that enables the following...
-
People visiting video rental stores often rent more than one DVD at a time. The probability distribution for DVD rentals per customer at Video To Go is given in the table below. There is a five-video...
-
Give the eccentricities of conic sections with one focus at the origin of the polar coordinate plane, along with the directrix for that focus. Find a polar equation for each conic section. e = 1/2, r...
-
The equilibrium constant Kc for the reaction equals 4.0 1013 at 25oC. Does the equilibrium mixture contain predominantly reactants or products? If [NO] = [O2] = 2.0 106 M at equilibrium, what is...
-
When allocating costs, should you take time to figure out if the costs relate to materials or labor, or should you allocate all the costs as manufacturing overhead? It is your first day on the job at...
-
Shiraz plc is financed by 10m shares, whose current market value is 2.40 a share, and 10 per cent debentures with a nominal and market value of 14m. The return on the ordinary shares is 20 per cent....
-
Fowler Corporations computer services department assists two operating departments in using the companys information system effectively. The annual cost of computer services is $360,000. The...
-
The entry to record the semiannual payment and amortization of the discount using the straight-line method on a 10%, $200,000, 5-year bond issued at 97 would be to: debit Bond Interest Expense...
-
Prepare a financial plan for the following client and write a critical report for Joe considering the two possible developments in Joes life as listed below. The report must explain and discuss the...
-
Xun Xus Aeronautics is comparing market research proposals from two different companies. If both research reports were free, the EMV using the report from Jackson Analytics would be $240,000, while...
-
Consider the Thompson Lumber EMV decision from Table 8.8. Suppose that the utility function for Thompson Lumber can be expressed as 1 1.2 [(X + 120,000) / 30,000] for monetary value X. (a) Compute...
-
The Beal Manufacturing Company's costing system has two direct-cost categories: direct materials and direct manufacturing labor. Manufacturing overhead (both variable and fixed) is allocated to...
-
From your reading this unit on motivation and change from the TIP series, what is the connection and interplay between these concepts/statements below in your opinion in working with clients facing...
-
Please help with the following The partnership of Bauer, Ohtani, and Souza has elected to cease all operations and liquidate its business property. A balance sheet drawn up at this time shows the...
-
Pacifico Company, a U.S.-based importer of beer and wine, purchased 1,200 cases of Oktoberfest-style beer from a German supplier for 276,000 euros. Relevant U.S. dollar exchange rates for the euro...
-
Define meaning of partnership deed.
-
List down the information contains in the partnership deed.
-
The trial balance of Eastwood Inc. and other related information for the year 2020 follows: Additional information: 1. The inventory has a net realizable value of $212,000. The FIFO method of...
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
What does the degree of brand familiarity imply about previous and future promotion efforts? How does the degree of brand familiarity affect the Place and Price variables?
-
You operate a small hardware store with emphasis on manufacturer brands and have barely been breaking even. Evaluate the proposal of a large wholesaler that offers a full line of dealer-branded...
-
Give an example where packaging costs probably ( a ) lower total distribution costs and ( b ) raise total distribution costs.
-
Be prepared to explain the texts comprehensive To illustrate the issues related to interest capitalization, assume that on November 1, 2016, Shalla Company contracted Pfeifer Construction Co. to...
-
On April 1, 2020. Indigo Company received a condemnation award of $473,000 cash as compensation for the forced sale of the company's land and building, which stood in the path of a new state highway....
-
The market price of a stock is $24.55 and it is expected to pay a dividend of $1.44 next year. The required rate of return is 11.23%. What is the expected growth rate of the dividend? Submit Answer...
Study smarter with the SolutionInn App