MGMT20005 Business Decision Analysis
Business Decision Analysis
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
MGMT20005
Business Decision Analysis
Authorised Materials:
Scientific calculators permitted
English-other language translation dictionaries permitted
No lap top or note book computers
Instructions to Students:
This examination contributes 60% to the final subject mark.
This examination paper includes 6 questions with a total mark of 100. You must answer them all.
Use two decimal points for calculations where relevant.
Instructions to Invigilators:
Paper to be held by Library: Yes
Student may keep the paper: No
Student may annotate the paper during reading time: Yes
Extra Materials Required:
Note: Graph paper is attached at the end of this booklet.
Page 2
Question 1 [28 marks]
An appliance dealer must decide how many new microwave ovens to order for next month. The
ovens each cost $220 and sell for $300. Because the oven manufacturer is coming out with a new
product line in two months, any ovens not sold next month will have to be sold at the dealer’s half
price clearance sale. Additionally, the appliance dealer feels he suffers a loss of $25 for every oven
demanded when he is out of stock. On the basis of past months’ sales data, the dealer estimates
the probabilities of monthly demand (D) for 1, 2, or 3 ovens to be 0.5, 0.3, and 0.2, respectively.
Consistent with the demand scenarios, the dealer is looking to order 1, 2, or 3 ovens.
The dealer is considering conducting a telephone survey on the customers’ attitudes towards
microwave ovens. The results of the survey will either be favorable (F) or unfavorable (U). The
dealer’s probability estimates for the survey results based on the number of units demanded are:
P(F | D = 1) = 0.3 P(F | D = 2) = 0.6 P(F | D = 3) = 0.9
P(U | D = 1) = 0.7 P(U | D = 2) = 0.4 P(U | D = 3) = 0.1
a. Use a decision tree to recommend a decision based on EMV when the survey is not
conducted. [6 marks]
EV(order 1) = 62.5
EV(order 2) = 80
EV(order 3) = 45
Optimal decision based on EV is to order 2, and the maximum profit is 80.
b. Use EVPI to determine whether the dealer should attempt to obtain a better estimate of
demand. [4 marks]
In the presence of perfect information:
If D=1, then order 1, which gives 80
If D=2, then order 2, which gives 160
If D=3, then order 3, which gives 240
EVwPI = 80*0.5+160*0.3+240*0.2 = 136
EVPI = EVwPI – EvwoPI = 136 – 80 = 56
c. Use a decision tree to determine the optimal decision for the appliance dealer given that
the survey is conducted? [14 marks]
favourable
states of nature Prior conditional joint posterior
D=1 0.5 0.3 0.15 0.294
D=2 0.3 0.6 0.18 0.353
D=3 0.2 0.9 0.18 0.353
0.51
unfavourable
states of nature Prior conditional joint posterior
D=1 0.5 0.7 0.35 0.686
D=2 0.3 0.4 0.12 0.235
D=3 0.2 0.1 0.02 0.039
0.49
Optimal decision:
If favorable, then order 2 and the expected profit is 107.06;
Otherwise, order 1 and the expected profit is 69.02.
Page 3
d. What is the expected value of the information provided by the survey?
[4 marks]
EVwSI = 107.06*0.51+69.02*0.49=88.42
EVSI = EVwSI – EvwoSI = 88.42-80=8.42
Question 2 [12 marks]
Luke’s utility function is given by () = 100 − 2 for 0 ≤ ≤ 50 where represents total
wealth in dollars.
a. If Luke currently has $20, should he take a bet in which he will win $15 with probability 0.3
and lose $10 with probability 0.7, based on expected utility?
[6 marks]
NOT BET: U(20)=1600
BET: EU=0.3*U(35)+0.7*U(10)=1312.5
So, it is optimal not to bet based on the EU approach.
b. If Luke’s total assets are currently $25, what is the certainty equivalent if he takes the bet
in (a)? What is the risk premium he would pay for the bet? [6 marks]
EU=0.3*U(40)+0.7*U(15)=1612.5
Certainty equivalent is obtained by solving the equation 100*CE-CE^2=1612.5.
Thus, CE is 20.21.
EV=0.3*40+0.7*15=22.5
Risk Premium = EV – CE = 2.29
Question 3 [16 marks]
Consider the following linear program:
Max Z = 4 X1 + 5 X2 (total profit in dollars)
Subject to:
Constraint A: 2 X1 + 4 X2 <= 120
Constraint B: 4 X1 + 3 X2 <= 140
Constraint C: X1 + X2 >= 40
X1 ≥ 0, X2 ≥ 0
Use the graphical solution approach to solve the above linear programming model, and answer
the following questions (you need to use the graph paper at the end of this booklet to draw
graphs):
a. What are the optimal solutions (including the optimal values for decision variables and the
optimal profit)? [8 marks]
Optimal values for decision variables: x1=20, x2=20
Optimal objective value: 180
b. Suppose the unit profit for X1 is decreased from $4 to $3. Are the values for decision
variables in (a) still optimal? What is the optimal value of the objective function when this
unit profit is decreased to $3? [8 marks]
Page 4
The optimal decision variable values remain the same.
But the objective function value becomes 160.
Question 4 [16 marks]
A farmer in Iowa has a 100-acre farm on which to plant watermelons and cantaloupes. Every acre
planted with watermelons requires 50 gallons of water per day and must be prepared for planting
with 20 pounds of fertilizer. Every acre planted with cantaloupes requires 75 gallons of water per
day and must be prepared for planting with 15 pounds of fertilizer. The farmer estimates it will take
2 hours of labor to harvest each acre planted with watermelons and 2.5 hours of labor to harvest
each acre planted with cantaloupes. He believes that watermelons will sell for about $3 each, and
cantaloupes will sell for about $1 each. Every acre planted with watermelons is expected to yield
90 saleable units. Every acre planted with cantaloupes is expected to yield 300 saleable units. The
farmer can pump about 6,000 gallons of water per day for irrigation purposes from a shallow well.
He can buy as much fertilizer as he needs at a cost of $10 per 50-pound bag and can hire laborers
to harvest the fields at a rate of $5 per hour. Finally, the farmer decides that the land use for
watermelons cannot exceed that for cantaloupes.
If the farmer sells all the watermelons and cantaloupes he produces, how many acres of each crop
should the farmer plant to maximize the total profit?
The following table shows the partial sensitivity analysis report produced by Excel Solver.
a. Formulate an linear programming (LP) model for the problem.
[4 marks]
Let x1 be the number of acres of land for watermelon; x2 be the number of acres of land for
cantaloupes
Maximise total profit or
z = 3*90*x1 + 1*300*x2 – (2*x1+2.5*x2)*5 – (20*x1+15*x2)*10/50=256x1+284.5x2
Subject to x1 + x2 ≤ 100
50*x1 + 75*x2 ≤ 6000
X1 – x2 <= 0
x1 and x2 ≥ 0
b. For the optimal solution, how much land is used to grow each of the two crops, and what is
the maximum profit?
[2 marks]
x1=48 acres of land for watermelons
x2=48 acres of land for cantaloupes
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$16 ? 48 0 ? 1E+30 66.33333333
$C$16 ? 48 0 ? 99.5 540.5
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$21 land use LHS ? 0 ? 1E+30 4
$B$22 water LHS ? 4.324 ? 250 6000
$B$23 requirement LHS ? 39.8 ? 20 80
Page 5
The maximum profit is given by 25944
c. For the optimal solution, how much land is left unused and how much water is used?
[2 marks]
4 acres of land is left unused, i.e., 100 – 48 – 48 = 4.
No water is left used.
d. Would the optimal solution change if the price for watermelon is increased by $0.5?
[2 marks]
No. With $0.5 increase in the price of watermelon, there is $0.5*90=$45 increase in the
revenue and thus profit per acre, which is smaller than the allowable increase + infinity.
Thus, the optimal solution would not be changed.
e. What would be the optimal solution if the price for cantaloupe is increased by $0.5?
[2 marks]
The increase in the price of cantaloupe per acre is given by $.5*300=$150, which is greater
than the allowable increase 99.5. Thus, the optimal solution would change.
f. How much would the total profit increase if the water available is increased from 6,000
gallons to 6,200 gallons?
[2 marks]
The allowable increase for the RHS of the constraint is 250. The increase in the water is
200=6200-6000, smaller than the allowable increase 250. Thus, the shadow price $4.324 can
be used to examine the profit increase due to the increase in water. We obtain that the
profit increase is given by 200*$4.324=$864.8.
g. The farmer has an opportunity to sell 3 acres of land at a price of $1,000. Do you recommend
him make the sale?
[2 marks]
The allowable decrease for the RHS of the constraint is 4. The reduction in land is 3 acres,
which is smaller than the allowable decrease 4. Thus, the shadow price $0 can be used to
examine the revenue loss due to the reduction in land. We obtain that the profit loss is given
by 3*$0=$0, which is smaller than the price 1,000. Therefore, we recommend him make the
sale.
Question 5 [12 marks]
Johnson Bicycle makes a plastic tricycle that is composed of three major components: a
handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has
orders for 12,000 of these tricycles. Current schedules yield the following information.
Requirements Cost to
Manufacture
Cost to
Purchase Component Plastic Time Space
Assembly 3 10 2 8 12
Seat/Frame 4 6 2 6 9
Rear wheel (each) 0.5 2 0.1 1 3
Available 50,000 160,000 30,000
The company obviously does not have the resources available to manufacture everything needed
for the completion of 12,000 tricycles so has gathered purchase information for each component.
Develop a linear programming model to tell the company how many of each component should
Page 6
be manufactured and how many should be purchased in order to provide 12,000 fully completed
tricycles at the minimum cost.