##

(Solved) Activity 2.6 - Module 2 Problems Complete the following problems and submit the results in either a Microsoft Word document or a Microsoft Excel...

Please answer all questionsÂ in Excel sheet.

there are 2 different files.Â

Activity 2.6 â€“ Module 2 Problems

Complete the following problems and submit the results in either a Microsoft Word document

or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each

problem on a separate sheet and label the tab with problem number. Save your document with

a descriptive file name, including the assignment and your name.

These problems are similar to problems in the text, but have been altered by the course

monitor.

2-1

Kenneth Brown is the principal owner of Brown Oil, Inc. After quitting his university teaching

job, Ken has been able to increase his annual salary by a factor of over 100. At the present time, Ken is

forced to consider purchasing some more equipment for Brown Oil because of competition. His

alternatives are shown in the following table:

Equipment

Sub 100

Oiler J

Texas Favorable Market ($)

300,000

265,000

85,000 Unfavorable Market ($)

-200,000

-96,000

-18,000 For example, if Ken purchases a Sub 100 and if there is a favorable market, he will realize a profit of

$300,000. On the other hand, if the market is unfavorable, Ken will suffer a loss of $200,000.

But Ken has always been a very optimistic decision maker.

The Lubricant is an expensive oil newsletter to which many oil giants subscribe, including Ken Brown. In

the last issue, the letter described how the demand for oil products would be extremely high. Apparently,

the American consumer will continue to use oil products even if the price of these products doubles.

Indeed, one of the articles in the Lubricant states that the chances of a favorable market for oil products was

75%, while the chance of an unfavorable market was only 25%. Ken would like to use these probabilities

in determining the best decision.

(a) What decision model should be used?

(b) What is the optimal decision?

(c) Ken believes that the $300,000 figure for the Sub 100 with a favorable market is too high. How

much lower would this figure have to be for Ken to change his decision made in part b?

2-2

Mickey Lawson is considering investing some money that he inherited. The following payoff

table gives the profits that would be realized during the next year for each of three investment alternatives

Mickey is considering: Decision Alternative

Stock Market

Bonds

CDs

Probability State of Nature

Good Economy

Poor Economy

80000

-20000

40000

21000

25000

25000

.5

.5 (a) What decision would maximize expected profits?

(b) What is the maximum amount that should be paid for a perfect forecast of the economy?

(c) Develop an opportunity loss table for the investment problem that Mickey Lawson faces.

(d) What decision would minimize the expected opportunity loss?

(e) What is the minimum EOL? 2-3

Allen Young has always been proud of his personal investment strategies and has done very well

over the past several years. He invests primarily in the stock market. Over the past several months,

however, Allen has become very concerned about the stock market as a good investment. In some cases, it

would have been better for Allen to have his money in a bank than in the market. During the next year,

Allen must decide whether to invest $10,000 in the stock market or in a certificate of deposit (CD) at an

interest rate of 8%. If the market is good, Allen believes that he could get a 15% return on his money. With

a fair market, he expects to get a 6% return. If the market is bad, he will most likely get no return at allâ€”in

other words, the return would be 0%.

Allen estimates that the probability of a good market is 0.4, the probability of a fair market is 0.4, and the

probability of a bad market is 0.2, and he wishes to maximize his long-run average return.

Mr. Young is thinking about paying for a stock market newsletter. A friend of his said that these types of

letters could predict very accurately whether the market would be good, fair, or poor. Then, based on these

predictions, Allen could make better investment decisions.

(a)

(b)

(c)

(d) Develop a decision table for this problem.

What is the best decision?

What is the most that Allen would be willing to pay for a newsletter?

Mr. Young now believes that a good market will give a return of only 12% instead of 15%. Will

this Information change the amount that Allen would be willing to pay for the newsletter? If your

answer is yes, determine the most that Allen would be willing to pay, given this new information. 2-4

Brilliant Color is a small supplier of chemicals and equipment that are used by some photographic

stores to process 35mm film. One product that Brilliant Color supplies is BC-6. John Kubick, president of

Brilliant Color, normally stocks 11, 12, or 13 cases of BC-6 each week. For each case that John sells, he

receives a profit of $55. Like many photographic chemicals, BC-6 has a very short shelf life, so if a case is

not sold by the end of the week, John must discard it. Since each case costs John $58, he loses $58 for

every case that is not sold by the end of the week. There is a probability of 0.35 of selling 11 cases, a

probability of 0.40 of selling 12 cases, and a probability of 0.25 of selling 13 cases.

(a) Construct a decision table for this problem. Include all conditional values and probabilities in the

table.

(b) What is your recommended course of action?

(c) If John is able to develop BC-6 with an ingredient that stabilizes it so that it no longer has to be

discarded, how would this change your recommended course of action?

You may submit just the answers or you may submit the answers and the QM worksheets you used to arrive

at the answer. Choosing the latter will afford instructors the opportunity to review your work and determine

if you understand the concept but have made some minor computational error, therefore allowing them to

assign some credit based on your understanding. Submitting just the answers does not provide for any

partial credit.

**Solution details:**
This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

×
Please Enter Your Payment Email Address To Receive Solution.