A suburban Motor Taxation Office is to be opened but details of the service level have yet to be decided. Four services will be offered: motor tax renewal, driver’s license renewal, vehicle registration, and change of ownership. Based on predictions from previous similar offices and from changes to procedures and equipment, the average number of customers per day and the service times for each of the four types of service are specified in the Excel project workbook. The probabilities that a customer will require each of the four services are also specified in this file, based on statistics gathered at similar offices. A working day at the office is 8 hours long.

Simulation Task.
Using the values specified in your individual Excel project workbook for the arrival rate, the service times for each type of service, and the probability each service is required, simulate the processing of 450 customers at the Motor Tax Office, assuming that there is a single server. Treat a working day at the office as 8 hours but if your simulation arrival times exceed 8 hours you may ignore this fact for convenience. You should use minutes as the
time unit, as specified in the project file, and all simulated times should be given in number format only (i.e. not in an hour, minutes, seconds format such as 01:24:30). You may assume Poisson arrivals and exponential service times for each type of service when generating simulated arrival times and service times. (See “Important Notes” below for more information.) Fill in the required values in the cells and columns indicated on the template of the simulation worksheet. Each of the four possible types of service should be coded by a number from 1 to 4, as follows:
1 motor tax renewal
2 driver license renewal
3 vehicle registration
4 change of ownership
 
 

The values below are the service time and probability parameters to be used for simulating customers at the Motor Tax Office. Number of Arrivals Per Day Motor Tax Renewal Driver Licence Renewal Vehicle Registration Change of Ownership 86 Mean Service Time (minutes) 4.83 4.08 6.74 7.85 Probability Service is Required 0.37 0.32 0.18 0.13