Question 2:

JAMIL Car shop offers the following services as shown in Table Q2. The car shop has only two technicians that will do the specific job together. Table Q2 shows the duration for each of the services offered. The frequency of occurrence for each of the services for the past month is also shown in Table Q2. It is estimated that one (1) customer arrives in the car shop every 45-minute period.

Using Monte Carlo Simulation technique, determine the following:

(i) Develop a Probability Distribution model;

(ii) Determine the average waiting time of a customer considering a time duration from 8:00AM to 5:00 PM. Use excel to generate random numbers.

Table Q2: Car Shop Services offered Services Time Required to Complete the Service (minutes) Frequency of services for past month 15 20 30 16 10 53 Oil & Coolant Level Check-up Air Filter Change Tire Pressure Check & Charging Oil & Filter Change Rotate Tire & Alignment Waxing Vehicle 55 76 90 16 45 46