The demand for the next 12 weeks are estimated below. Modify your worksheet to include the possible resale revenue and loss of sales cost. Use the spreadsheet to answer the following questions. Week Predicted Demand 1 700 1200 500 4 1150 1000 950 1300 800 1050 10 950 11 1200 12 1150 9. What is the average weekly profit? How many weeks did they have loss of sales? 10. What if they produce 900 units per week. What is the average weekly profit? How many weeks did they have loss of sales? 11. What if they produce 1,100 units per week. What is the average weekly profit? How many weeks did they have loss of sales? 12. Out of the three production quantities, 900, 1,000, and 1,100, which one is the best options and why