Exam 12: Introduction to Simulation Using Analytic Solver Platform

Exhibit 12.2 The following questions use the information below. The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged cars and the amount of damage to the cars each month. He currently repairs 100 cars per month and feels the change in number of cars can vary uniformly between a decrease of as much as 3% and an increase of up to 5% (average change of 1%). The dollar value of the damage to the cars is a normally distributed random variable with a mean of $3,000 and a standard deviation of $500. The average repair bill has been increasing steadily over the years and the owner expects the mean repair bill will increase by 1% per month. A spreadsheet model to simulate the problem has been run 300 times. A part of the simulation statistics output from Risk Solver Platform (RSP)and a spreadsheet for computing confidence intervals follows. -Using the information in Exhibit 12.2, what formula should go in cell B8 of the Confidence Intervals spreadsheet to compute the upper limit on a 95% confidence interval for the true population mean?

Exhibit 12.5 The following questions use the information below. The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation. He is interested in simulating the number of customers and the amount ordered by customers each month. He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%. The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5. The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month. You have created the following spreadsheet to simulate the problem. -What is the probability that 3 or more phone calls are received in any hour of operation? Instructions: Answer the following questions using the Analytic Solver Platform Excel add-in.

Exhibit 12.3 The following questions use the information below. An auto parts store wants to simulate its inventory system for engine oil. The company has collected data on the shipping time for oil and the daily demand for cases of oil. A case of oil generates a $10 profit. Customers can buy oil at any auto parts store so there are no backorders (the company loses the sale and profit). The company orders 30 cases whenever the inventory position falls below the reorder point of 15 cases. Orders are placed at the beginning of the day and delivered at the beginning of the day so the oil is available on the arrival day. An average service level of 99% is desired. The following spreadsheets have been developed for this problem. The company has simulated 2 weeks of operation for their inventory system. The current level of on-hand inventory is 25 units and no orders are pending. -The average demand is 4.45 cases per day. Using the information in Exhibit 12.3, what formula should go in cell H4 to determine the average lost sales?

Exhibit 12.1 The following questions use the information below. The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged cars and the amount of damage to the cars each month. He currently repairs 100 cars per month and feels this can vary uniformly between a decrease of as much as 3% and an increase of up to 5% (average change of 1%) over the previous months. The dollar value of the damage to the cars is a normally distributed random variable with a mean of $3,000 and a standard deviation of $500. The average repair bill has been increasing steadily over the years and the owner expects the mean repair bill will increase by 1% per month. You have created the following spreadsheet to simulate the problem. -Using the information in Exhibit 12.1, what Analytic Solver Platform function should go in cell B9 and copied to B10:B19 to compute the number of cars repaired in the subsequent months?

The Analytic Solver Platform is a good simulation tool because

Risk needs to be analyzed using models in order to

The benefit(s) of simulation discussed in the text is/are

Which of the following distributions can be generated by Analytic Solver Platform?

Which of the following probability distributions are associated with continuous outcomes?

Exhibit 12.3 The following questions use the information below. An auto parts store wants to simulate its inventory system for engine oil. The company has collected data on the shipping time for oil and the daily demand for cases of oil. A case of oil generates a $10 profit. Customers can buy oil at any auto parts store so there are no backorders (the company loses the sale and profit). The company orders 30 cases whenever the inventory position falls below the reorder point of 15 cases. Orders are placed at the beginning of the day and delivered at the beginning of the day so the oil is available on the arrival day. An average service level of 99% is desired. The following spreadsheets have been developed for this problem. The company has simulated 2 weeks of operation for their inventory system. The current level of on-hand inventory is 25 units and no orders are pending. -Using the information in Exhibit 12.3, what formula should go in cell J8 to determine the arrival date for an order?

Exhibit 12.1 The following questions use the information below. The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged cars and the amount of damage to the cars each month. He currently repairs 100 cars per month and feels this can vary uniformly between a decrease of as much as 3% and an increase of up to 5% (average change of 1%) over the previous months. The dollar value of the damage to the cars is a normally distributed random variable with a mean of $3,000 and a standard deviation of $500. The average repair bill has been increasing steadily over the years and the owner expects the mean repair bill will increase by 1% per month. You have created the following spreadsheet to simulate the problem. -Using the information in Exhibit 12.1, what Analytic Solver Platform function should go in cell B8 to compute the number of cars repaired in the first month?

Some discrete distributions available in Analytic Solver Platform are

Exhibit 12.3 The following questions use the information below. An auto parts store wants to simulate its inventory system for engine oil. The company has collected data on the shipping time for oil and the daily demand for cases of oil. A case of oil generates a $10 profit. Customers can buy oil at any auto parts store so there are no backorders (the company loses the sale and profit). The company orders 30 cases whenever the inventory position falls below the reorder point of 15 cases. Orders are placed at the beginning of the day and delivered at the beginning of the day so the oil is available on the arrival day. An average service level of 99% is desired. The following spreadsheets have been developed for this problem. The company has simulated 2 weeks of operation for their inventory system. The current level of on-hand inventory is 25 units and no orders are pending. -Using the information in Exhibit 12.3, what formula should go in cell G9 to compute inventory position?

Exhibit 12.5 The following questions use the information below. The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation. He is interested in simulating the number of customers and the amount ordered by customers each month. He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%. The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5. The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month. You have created the following spreadsheet to simulate the problem. -What function should be used for generating random integer numbers between 2 and 8?

Exhibit 12.1 The following questions use the information below. The owner of Fix-a-dent Auto Repair wants to study the growth of his business using simulation. He is interested in simulating the number of damaged cars and the amount of damage to the cars each month. He currently repairs 100 cars per month and feels this can vary uniformly between a decrease of as much as 3% and an increase of up to 5% (average change of 1%) over the previous months. The dollar value of the damage to the cars is a normally distributed random variable with a mean of $3,000 and a standard deviation of $500. The average repair bill has been increasing steadily over the years and the owner expects the mean repair bill will increase by 1% per month. You have created the following spreadsheet to simulate the problem. -Using the information in Exhibit 12.1, what formula should go cell G5 to calculate the 80^th percentile of the empirical distribution of income?

Exhibit 12.5 The following questions use the information below. The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation. He is interested in simulating the number of customers and the amount ordered by customers each month. He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%. The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5. The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month. You have created the following spreadsheet to simulate the problem. -Using the information in Exhibit 12.5 and the Analytic Solver Platform, what formulas should go in cells B8:D21 of the spreadsheet? Instructions: Answer the following questions using the Analytic Solver Platform Excel add-in.

Exhibit 12.5 The following questions use the information below. The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation. He is interested in simulating the number of customers and the amount ordered by customers each month. He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%. The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5. The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month. You have created the following spreadsheet to simulate the problem. -A machine produces an average of 500 parts per day with a standard deviation of 10 parts. This is a normally distributed variable. The percent of defective parts ranges from 8-12%. Parts which need minor repair comprise 75% of the defective parts and cost $5 to repair. The rest of the defective parts cost $20 to repair. What formulas should go in cells B8:B15 to compute the daily cost of defective parts? Instructions: Answer the following questions using the Analytic Solver Platform Excel add-in.

Methods for analyzing risk that are discussed in the textbook include

Exhibit 12.5 The following questions use the information below. The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation. He is interested in simulating the number of customers and the amount ordered by customers each month. He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%. The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5. The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month. You have created the following spreadsheet to simulate the problem. -A simulation model was replicated 100 times yielding a mean of 82.59 with variance of 17.66. Of the 100 replications, 11 replications yielded an outcome over a value of 100. The 95% confidence interval of the mean is the interval (81.77, 83.41). Of the 100 simulation outcomes, 65 outcomes failed to fall within this interval. What is wrong with the confidence interval?

Exhibit 12.5 The following questions use the information below. The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation. He is interested in simulating the number of customers and the amount ordered by customers each month. He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%. The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5. The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month. You have created the following spreadsheet to simulate the problem. -What gallery distribution should be used for generating the number of times "tails" come up over 15 flips of a "fair" coin?