Consider you own a warehouse where you need to unload material. The question you need to answer is; What is the proper number of loading docks to optimize your operation?

Assume the following:

a delivery arrives on time every 60 minutes. Arrive a total of 8 trucks - each every 60 mins with the first truck ariving at time = 0.0

the average time to unload the truck is normally distributed as 120 minutes with a standard deviation of 30 minutes (you obtained this from data collection.

Provide a screen shot of your Extend Sim model in your Word document.

Assuming one loading dock - provide the dock utilization and the queue length. What is your conclusion? What is the probability you will exceed 10 hours 600 minutes of "dock time"? Provide Excel graphs in your Word document.

What is the change in dock utilization and queue length if you add 1 loading dock (i.e., total of 2). What is the probability you will exceed 9 hours of dock time to satisfy the demand (i.e,. exceed 540 minutes). Provide Excel graphs in your Word document.

What is the change in dock utilization and queue length if you add 1 more loading dock (i.e., total of 3). What is the probability you will exceed 9 hours of dock time to satisfy the demand (i.e,. exceed 540 minutes). Provide Excel graphs in your Word document.

Propose any change to the system - you may change the schedule, you may change the unload time, whatever you prefer. Demonstrate the projected results of the proposed change.