Exam 12: Introduction to Simulation Using Risk Solver Platform

What is the expected number of phone calls per hour based on the following distribution on the number of phone calls per hour?

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 Risk Solver Platform (RSP) function should go in cell B8 to compute the number of cars repaired in the first month?

Friendly Bank has various branches throughout the city. Ronnie Fare is a branch manager. Ronnie has always been very customer focused. Her branch is relatively small; three counter tellers and two drive-through tellers. Her drive-through support appears more than adequate. Her concern is with the in-branch service. She is concerned with the level of service being provided and whether or not each of her three tellers are of equal proficiency. When a customer comes in for service, they wait in a single line and move to the first available teller. Once serviced, the customer leaves the bank. Six weeks ago, Ronnie enlisted a small company to conduct time studies of the bank processes. The data was collected over a four-week period. This extended collection period helped overcome bias in the data collection due to observation activities. The final set of data just arrived in the mail and Ronnie is ready to conduct some desk-top analysis of the data to answer her own questions about her branch.The data pertinent to her concerns are: At first glance, it appears there is no difference between the tellers. However, Ronnie wants to simulate the bank process to provide estimates on the following pieces of information: Build a simulation model to help answer Ronnie Fare's questions. Use 250 arrivals per day. Provide appropriate statistical information in your answer.

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 H8 to determine if an order should be placed?

What function should be used for generating random numbers between 1 and 12 from a continuous uniform distribution?