Construct a decision table for the problem


Problem:

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 $35. 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 $56, he loses $56 for every case that is not sold by the end of the week. There is a probability of 0.45 of selling 11 cases, a probability of 0.35 of selling 12 cases, and a probability of 0.2 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?

Put this in an excel file.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Construct a decision table for the problem
Reference No:- TGS01941855

Now Priced at $25 (50% Discount)

Recommended (93%)

Rated (4.5/5)