Question: please post the calculations on excel spreadsheet. Set this up in excel spreadsheet. 3-22 Waldo Books needs to decide how many copies of a new

please post the calculations on excel spreadsheet. Set this up in excel spreadsheet.
3-22 Waldo Books needs to decide how many copies of a new hardcover release to purchase for its shelves. The store has assumed that demand will be 50, 100, 150, or 200 copies next month, and it needs to decide whether to order 50, 100, 150, or 200 books for this period. Each book costs Waldo $20 and can be sold for $30. Waldo can sell any unsold books back to the supplier for $4. (a) Which option should Waldo choose if it uses the maximax criterion? (b) Which option should Waldo choose if it uses the maximin criterion? (c) Which option should Waldo choose if it uses the equally likely criterion? (d) Which option should Waldo choose if it uses the criterion of realism with a = 0.7? (e) Which option should Waldo choose if it uses the minimax regret criterionStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
