Question: Problem 5 (to points}: The national coee store Farhuclrs needs to decide in August how many holidayedition insulated coffee mugs to order. Because the mugs

Problem 5 (to points}: The national coee store Farhuclrs needs to decide in August how many holidayedition insulated coffee mugs to order. Because the mugs are dated, these that are unsold by January 15 are considered a loss. These premium mugs sell for $23.?5 and cost $5.55 each. Farhucks is uncertain of the demand. They helieye that there is a 25% chance that they will sell 15,555 mugs. a 50% chance that they will sell ts.ooo, and a 25% chance that they will sell some a. Build a decision tree in PrecisionTree to determine if they should order 12.ooo. lid-[it], or 183300 mugs. tlint: he sure that your model does not allow Farhuclrs to sell more mugs than they ordered. You can use the IF{ ) formula in Excel . It demand is less than the order quantity. the amount sold is the demand; otherwise. the amount sold is the order quantity. See Excel help for guidance on how to use the IF(} formula if you do not know before. b. Now, assume that any unsold mugs are discounted and sold tor $5. How does this affect the decision
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
