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.
Which option should Waldo choose if it uses the maximin criterion?
Please show all the explanation step by step in excel sheet as well as the formulas which are used for calculations.