Due Date: Mart $25,2024$

Consider the following continuously operating job shop. Interarrival times of jobs are distributed

as follows:

Processing times for jobs are normally distributed with mean $54$ minutes and standard deviation $6$ minutes.

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$).$ Create an Excel spreadsheet

model to simulate this system behavior for the $1000$ jobs.

a$)$ What was the average time in the queue for the $1000$ new jobs?

b$)$ What was the average processing time of the $1000$ new jobs?

c$)$ What was the maximum time in the system for the $1000$ new jobs?

$($Hint: Use Excel's NORMINV function$)$

Create a generalized Excel file in which the mentioned $(M,N)$ inventory system for different $N$

$($review period$)$ and M $($maximum stock level$)$ values can be simulated.