Problem 11.8 - Excel Solution Making Hard Decisions with DecisionTools, 3rd ed., Clemen & Reilly Annual Calendar Sales Cost per Calendar $5.95 Order Quantities Expected Profit* Expected Profit St. Dev. Of Profit* St Dev of Profit Retail Price per Cal. $14.95 650 #NAME? #NAME? #NAME? #NAME? Refund per Cal. $1.95 660 #NAME? #NAME? #NAME? #NAME? Opportunity Cost per Cal. $3.00 670 #NAME? #NAME? #NAME? #NAME? Order Quantity #NAME? 680 #NAME? #NAME? #NAME? #NAME? Quantity Demanded #NAME? 690 #NAME? #NAME? #NAME? #NAME? 700 #NAME? #NAME? #NAME? #NAME? eftovers #NAME? 710 #NAME? #NAME? #NAME? #NAME? Unmet Demand #NAME? 720 #NAME? #NAME? #NAME? #NAME? Revenue 730 #NAME? #NAME? #NAME? #NAME? Sales #NAME? Refund #NAME? otal Revenue #NAME? $12.00 Costs $10.00 Cost of Order #NAME? Opportunity Cost #NAME? $8.00 Total Cost #NAME? $6.00 * Expected Profit* -+ Expected Profit Profit #NAME? $4.00 Profit* #NAME? $2.00 Profit* is the Profit value minus $0.00 the Opportunity Cost value. 640 650 660 670 680 690 700 710 720 730 740