Processing times for jobs are normally distributed, with mean 50 minutes and standard deviation 8 minutes. Construct a simulation table and perform a simulation for 10 new customers. Assume that, when the simulation begins, there is one job being processed (scheduled to be completed in 25 minutes) and there is one job with a 50-minute processing time in the queue.

Time Between Arrivals (Hours)	Probability
0	.23
1	.37
2	.28
3	.12

a) what was the avg. time in the queue for the 10 new jobs?

b) what was the avg. processing time of the 10 new jobs?

c) what was the max. time in the system for the 10 new jobs?

Question 1: How does the fact that the jobs are normally distributed impact the solution?

Question 2: Can you kindly solve it in Excel?

Expert Answer

• 
  Anonymous answered this

  Was this answer helpful?

  1,132 answers

  Distribution of time between arrivals

  

  

  Simulation table

  a) Average time in queue=(sum of time in queue for all customers)/no.of customers=168/10=16.8 min

  b)Average processing time=sum of service time for all customers/no.of customers=532/10=53.2 min

  c) MAX TIME IN THE SYSTEM=110 MIN

  Comment