Show step-by-step solution

A bookstore 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.

The number of calendars that the book store's supplier can supply is uniformly distributed between 125 and 200.

The sequence of events is as follows:

1. The bookstore places an order.

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.

3. The bookstore receives the supply of calendars and sells them to customers.

The manager of the bookstore has decided to order either 150 or 175 calendars.

Use Monte Carlo simulation, with 1000 replications of a Data Table, to help the manager choose between these two order quantities.

The 2 columns of numbers under "Data Table" for "Profit with order=150" and "Profit with order=175" on the right-side goes until 1000 in each column

Please use the template provided below. Order Quantity Demand Sold Revenue Cost Profit Average Profit Data Table Profit with Order=150 Data Table Profit with Order=175 Available Supply Shipped to bookstore 150 175 1 WN 2 3 4 5 6 7 8 9 10 10 Please use the template provided below. Order Quantity Demand Sold Revenue Cost Profit Average Profit Data Table Profit with Order=150 Data Table Profit with Order=175 Available Supply Shipped to bookstore 150 175 1 WN 2 3 4 5 6 7 8 9 10 10