A mail order company is planning a direct mail campaign. The fixed cost of designing the special catalog is $20,000. The variable cost of printing and mailing the catalogs mailing is uniformly distributed between $0.30 and $0.50 per copy. The proportion of customers who respond and place an order (response rate) is expected to follow a discrete distribution given below. Response rate distribution Response rate Probability 30% 0.04 35% 0.05 40% 0.10 45% 0.15 50% 0.18 55% 0.25 60% 0.15 65% 0.05 0.03 70% When a customer responds and places an order the dollar value of the orders is expected follow a normal distribution with a mean of $150 and a standard deviation of $15. The variable cost of each of these orders is expected to follow uniform distribution between 70% and 85% of the dollar amount of each order. a. Setup a Monte Carlo simulation model for the total profit for a single mailing campaign with 100,000 as the number of catalogs printed and mailed. Use native Excel functions such as VLOOKUP and NORM.INV, etc., wherever appropriate. b. Using the Data/Table approach run 100 replications and prepare a summary of the replication results. c. Prepare a histogram and box-plot for replication results.