MGMT 4103 Simulation Homework Spring 2016 Set up the models in a single Excel file, use a separate worksheet for each problem, put your name on each...

MGMT 4103 Simulation Homework Spring 2016

• Set up the models in a single Excel file, use a separate worksheet for each problem, put your name on each worksheet.

• Use the random number generator in Excel (Data/Data Analysis) to simulate the random variable(s) in each model.

• Submit the Excel file in Blackboard Assignment

1. Use the information given in problem #18 chapter 10 (Sunrise Bakery) to do the following:

Set up a simulation model to calculate daily profit.

Simulate 1 month (25 days) of operation.

No additional replications are required.

2. Alisa Goldman was delighted with her new job as director of the Tourist Information Center for the city of Miami Beach. She had completed her graduate work in the Hotel and Entertainment Services program of a highly rated college in New York and had accepted an offer for this new position from her former internship employer, the city of Miami Beach.

The Tourist Information Center is staffed by one employee and is open from 9am to 5 pm. Alisa saw her first task as determining the needs for service at the center. In order to do so she collected data concerning both the demand for services as well as service capabilities.

The length of service required by tourists varies according to the following probability distribution:

The arrivals at the center occur according to the following distribution:

Set up the model in a spreadsheet and simulate the arrival of 20 tourists. Note that two sets of random numbers are needed: the time required to service each tourist and the time between service arrivals.

Assume the first arrival is at time 0 and that only one tourist can be served at a time (there may be waiting).

Once you have simulated the arrival and service of 20 tourists, determine the average waiting time per tourist and the percentage of time that the employee is busy.