Q2. (i) Probability distribution model using monte carlo simulation

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

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; [10 marks] () 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. [15 marks] [Total 25 marks] Table Q2: Car Shop Services Offered Time Required to Services Complete the Service Frequency of services (minutes) for past month Oil & Coolant Level 15 13 Check-up Air Filter Change 30 22 Tire Pressure Check & 10 52 Charging Oil & Filter Change 55 66 Rotate Tire & Alignment 90 20 Waxing Vehicle 45 52