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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!