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.

model for MCC's inventory problem Mllienmum Competer C Dacision Cells Forecast Cells Assumption Cells Key Cell Formulas & CB Settings Copied to -50 D7 035 (Using CB CB Distibutiorc Custom linked t:Data ISFS7: SGS17 -GB-E7 IRHE-1.SM$6,0) CB Distributiort Custom Linked tor Data!SC$7:SDS9 17:135 (Using CB copy SUMEB E35/SUMD:D35