1. The Fruit & Vegetable Store (40 points) The Fruit & Vegetable Store is a store that specializes in selling fresh fruit and vegetables. It sells a gourmet variety of fresh tomatoes, costing $2.45 per pound and selling for a price of $3.95 per pound. The tomatoes are delivered at the beginning of a week. At the end of each week any left-over tomatoes are sold to a wholesaler for $1.25 per pound. Based on recent history, the weekly demand for the tomatoes in pounds is given by the following distribution: Demand 10 11 12 13 14 15 16 17 18 19 20 Probability 2% 6% 9% 11% 13% 15% 18% 11% 7% 5% 3% The manager has decided to limit her/his choices to ordering either 12, 15, or 18 pounds of the tomatoes. She has asked you to recommend what she should do. Answer the following questions. (a) Using Excel, but without using Data Table, construct a Payoff Matrix in terms of possible values of demand together with the corresponding probabilities of the demand. (Submit answer in an Excel file, 5 pts) (b) Using Excel, but now using Data Table, construct a Payoff Matrix in terms of possible values of demand together with the corresponding probabilities of the demand. Please include your formula sheet. (Submit answer in an Excel file, 5 pts) (c) Using Excel, construct the Decision Tableau for this problem. (Submit answer in an Excel file, 5 pts) (d) Using a Scatter Chart in Excel, graph the Risk Profile of ordering 15 pounds. (Submit answer in an Excel file, 5 pts) (e) Graphically represent the Reverse Cumulative View of each Risk Profile in a Clustered Column Chart. For which Profit Goals does Ordering 12 pounds give the largest probability of achieving the Goal? (Submit answer in an Excel file, 5 pts) (6What is the Expected Profit from ordering 12 pounds of tomatoes? Also, what are respective Expected Profits from ordering 15 pounds and 18 pounds? Based on the Expected Value Criterion, which order quantity would you recommend? (Submit answer in an Excel file, 5 pts) (g) If the owner's sole profit goal for the tomatoes was to make at least $15, which ordering quantity would you recommend? If instead the sole profit goal were $20, which ordering quantity would you recommend? And what would you recommend if the owner's sole profit questions 60. Answertholowing (a) Using Excel, but without using Data Table, construct a Payoff Matrix in terms of possble values of demand together with the corresponding probabilities of the demand (Submit answer in an Excel file, 5 pts) (b) Using Excel, but now using Data Table, construct a Payoff Matrix in terms of possible values of demand together with the corresponding probabilities of the demand. Please include your formula sheet. (Submit answer in an Excel file, 5 pts) (0) Using Excel , construct the Decision Tableau for this problem. (Submit answer in an Excel file, 6 pts) (6) Using a Scatter Chart in Excel, graph the Risk Profile of ordering 15 pounds. (Submit answer in an Excel file, 5 pts) (o) Graphically represent the Reverse Cumulative View of each Risk Profilo in a Clustered Column Chart For which Ploft Goals does Ordering 12 pounds give the largest probability of achieving the Goal? (Submit answer in an excelle, 6 pts) (What the Expected Profit from ordering 12 pounds of tomatoes? Also, what are respective Expected Profits from ordering 15 pounds and 18 pounds? Based on the Expected Valle Criterion, which order Quantity would you d? (Submit answer in an Excel file. pts) (a) if the owner's sole prof goal for the tomatoes was to make it last 15which ordering quantity would you need? It instead the sok profit goal were $20, which ordering quantity would you recommend? And what would you recommend it the owner's sole profit goal were $257 (Submit answer in an Excel file, 5 pts) th) Given tho conticting awers and () above, what would you recommend? Why? (Submit answer in an Excel file, 5 pts) 1. The Fruit & Vegetable Store (40 points) The Fruit & Vegetable Store is a store that specializes in selling fresh fruit and vegetables. It sells a gourmet variety of fresh tomatoes, costing $2.45 per pound and selling for a price of $3.95 per pound. The tomatoes are delivered at the beginning of a week. At the end of each week any left-over tomatoes are sold to a wholesaler for $1.25 per pound. Based on recent history, the weekly demand for the tomatoes in pounds is given by the following distribution: Demand 10 11 12 13 14 15 16 17 18 19 20 Probability 2% 6% 9% 11% 13% 15% 18% 11% 7% 5% 3% The manager has decided to limit her/his choices to ordering either 12, 15, or 18 pounds of the tomatoes. She has asked you to recommend what she should do. Answer the following questions. (a) Using Excel, but without using Data Table, construct a Payoff Matrix in terms of possible values of demand together with the corresponding probabilities of the demand. (Submit answer in an Excel file, 5 pts) (b) Using Excel, but now using Data Table, construct a Payoff Matrix in terms of possible values of demand together with the corresponding probabilities of the demand. Please include your formula sheet. (Submit answer in an Excel file, 5 pts) (c) Using Excel, construct the Decision Tableau for this problem. (Submit answer in an Excel file, 5 pts) (d) Using a Scatter Chart in Excel, graph the Risk Profile of ordering 15 pounds. (Submit answer in an Excel file, 5 pts) (e) Graphically represent the Reverse Cumulative View of each Risk Profile in a Clustered Column Chart. For which Profit Goals does Ordering 12 pounds give the largest probability of achieving the Goal? (Submit answer in an Excel file, 5 pts) (6What is the Expected Profit from ordering 12 pounds of tomatoes? Also, what are respective Expected Profits from ordering 15 pounds and 18 pounds? Based on the Expected Value Criterion, which order quantity would you recommend? (Submit answer in an Excel file, 5 pts) (g) If the owner's sole profit goal for the tomatoes was to make at least $15, which ordering quantity would you recommend? If instead the sole profit goal were $20, which ordering quantity would you recommend? And what would you recommend if the owner's sole profit questions 60. Answertholowing (a) Using Excel, but without using Data Table, construct a Payoff Matrix in terms of possble values of demand together with the corresponding probabilities of the demand (Submit answer in an Excel file, 5 pts) (b) Using Excel, but now using Data Table, construct a Payoff Matrix in terms of possible values of demand together with the corresponding probabilities of the demand. Please include your formula sheet. (Submit answer in an Excel file, 5 pts) (0) Using Excel , construct the Decision Tableau for this problem. (Submit answer in an Excel file, 6 pts) (6) Using a Scatter Chart in Excel, graph the Risk Profile of ordering 15 pounds. (Submit answer in an Excel file, 5 pts) (o) Graphically represent the Reverse Cumulative View of each Risk Profilo in a Clustered Column Chart For which Ploft Goals does Ordering 12 pounds give the largest probability of achieving the Goal? (Submit answer in an excelle, 6 pts) (What the Expected Profit from ordering 12 pounds of tomatoes? Also, what are respective Expected Profits from ordering 15 pounds and 18 pounds? Based on the Expected Valle Criterion, which order Quantity would you d? (Submit answer in an Excel file. pts) (a) if the owner's sole prof goal for the tomatoes was to make it last 15which ordering quantity would you need? It instead the sok profit goal were $20, which ordering quantity would you recommend? And what would you recommend it the owner's sole profit goal were $257 (Submit answer in an Excel file, 5 pts) th) Given tho conticting awers and () above, what would you recommend? Why? (Submit answer in an Excel file, 5 pts)