Question Details

(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
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:
Sub 100
Oiler J
Texas Favorable Market ($)
85,000 Unfavorable Market ($)
-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?
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
Probability State of Nature
Good Economy
Poor Economy
.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.
(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
(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 question was answered on: Sep 05, 2019

PRICE: $18 (25.37 KB)

Buy this answer for only: $18

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

About this Question






Sep 05, 2019





We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.


Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.


Order Now