A doughnut company has to determine the quantity of doughnut it has to produce for the following day. The historical record of their sales is listed in the following table Day Sales 1 100 2 300 3 300 4 100 5 500 6 400 7 200 8 100 9 500 10 300 11 12 13 14 15 16 100 100 500 5001 200 100 100 400 400 100 17 18 19 20 The production cost of each doughnut is $0.50. Each doughnut is sold for $1.95. If there are remaining doughnuts at the end of the day, each doughnut has to be disposed of with an extra cost of $0.25. Suppose that the company is considering to produce either 100, 200, 300, 400, or 500 doughnuts for the next day. Based on 1000 replications of Monte Carlo simulation runs, based on the average expected profit value, what production quantity (100, 200, 300, 400, or 500 doughnuts) would bring the highest profit? (Please hand in the excel sheet and highlight the end conclusion in the excel sheet) A doughnut company has to determine the quantity of doughnut it has to produce for the following day. The historical record of their sales is listed in the following table Day Sales 1 100 2 300 3 300 4 100 5 500 6 400 7 200 8 100 9 500 10 300 11 12 13 14 15 16 100 100 500 5001 200 100 100 400 400 100 17 18 19 20 The production cost of each doughnut is $0.50. Each doughnut is sold for $1.95. If there are remaining doughnuts at the end of the day, each doughnut has to be disposed of with an extra cost of $0.25. Suppose that the company is considering to produce either 100, 200, 300, 400, or 500 doughnuts for the next day. Based on 1000 replications of Monte Carlo simulation runs, based on the average expected profit value, what production quantity (100, 200, 300, 400, or 500 doughnuts) would bring the highest profit? (Please hand in the excel sheet and highlight the end conclusion in the excel sheet)