One of the examples in this chapter dealt with determining the optimal reorder point for a computer

Question:

One of the examples in this chapter dealt with determining the optimal reorder point for a computer monitor sold by Millennium Computer Corp. Suppose that it costs MCC $0.30 per day in holding costs for each monitor in beginning inventory, and it costs $20 to place an order. Each monitor sold generates a profit of $45, and each lost sale results in an opportunity cost of $65 (including the lost profit of $45 and $20 in lost goodwill). Modify the spreadsheet shown in Figure to determine the reorder point and order quantity that maximize the average monthly profit associated with thismonitor.

Opportunity Cost
Opportunity cost is the profit lost when one alternative is selected over another. The Opportunity Cost refers to the expected returns from the second best alternative use of resources that are foregone due to the scarcity of resources such as land,...