Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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: 0) Develop a Probability Distribution model; [10 marks] m) 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] Table Q2: Car Shop Services Offered Time Required to Frequency of services Services Complete the Service for past month (minutes) Oil & Coolant Level 15 18 Check-up Air Filter Change 30 18 Tire Pressure Check & 10 74 Charging Oil & Filter Change 55 59 Rotate Tire & Alignment 18 Waxing Vehicle 45 48 90 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: 0) Develop a Probability Distribution model; [10 marks] m) 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] Table Q2: Car Shop Services Offered Time Required to Frequency of services Services Complete the Service for past month (minutes) Oil & Coolant Level 15 18 Check-up Air Filter Change 30 18 Tire Pressure Check & 10 74 Charging Oil & Filter Change 55 59 Rotate Tire & Alignment 18 Waxing Vehicle 45 48 90
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started