The spreadsheet below deals with determining the optimal reorder point for a computer monitor sold by Millennium Computer Corp (MCC):

THIS SPREADSHEET NOW NEEDS TO BE MODIFIED: 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 above to determine the reorder point and order quantity that maximize the average monthly profit associated with this monitor. You MUST use Microsoft Excel with ASPE to solve.

Millennium Computer Corp. Quantity Demanded Shipping Time Prob 0.20 0.60 0.20 1.00 Days Prob 0.01 0.02 0.04 0.06 0.09 0.14 0.18 0.22 0.16 0.06 0.02 1.00 Units Total 6 7 10 Total Millennium Computer Corp. Quantity Demanded Shipping Time Prob 0.20 0.60 0.20 1.00 Days Prob 0.01 0.02 0.04 0.06 0.09 0.14 0.18 0.22 0.16 0.06 0.02 1.00 Units Total 6 7 10 Total