Sold Revenue 1 2 4 A book store needs to place an order for calendars. Each calendar sells for $10. Customer demand is assumed to be normally distributed with mean 200 and standard deviation 60. 5 The number of calendars that the book store's supplier can supply is uniformly distributed between 125 and 200. 6 The sequence of events is as follows: 7 1. The book store places an order. 8 2. The supplier looks at the available supply, and ships as many calendars as he can. The supplier charges $8 per calendar if he can supply the entire order; otherwise he charges only $7.50 per calendar. 9 3. The book store receives the supply of calendars, and sells them to customers. 10 The manager of the book store has decided to order either 150 or 175 calendars. 11 Use Monte Carlo simulation, with 1000 replications of a Data Table, to help the manager choose between these two order quantities. 12 Please use the template provided below. 13 14 15 Order Quantity Available Supply Shipped to bookstore Demand Cost Profit Average Profit Data Table Profit with Order=150 Data Table Profit with Order=175 16 150 1 17 175 2 18 19 4 4 20 5 5 21 6 22 7 7 23 8 24 9 25 10 10 26 11 11 27 12 12 28 13 13 29 14 14 30 15 15 31 16 16 32 17 17 3 3 6 7 8 9