Wilco Supply Chain
Trident University
Justin Berry
Module 4 Case Assignment
Course Number: LOG501
Course Name: Managing the Supply Chain
Report to Danny Wilco
Mr. Wilco, My current project was to analyze our current delivery model and to give a solution to our loading dock area. Many deliveries recently have been clogging the loading dock and through my analysis, this can be avoided by using time schedules. These schedules are based upon unloading times that were calculated using a queuing system model.
Assumptions
In order to use a queuing model there must be some assumptions made in order to perform calculations. One assumption that was made is that there will be only one truck unloading at a time. This assumption is very valid due to the fact that …show more content…
This amounted to 33.49%. For more than six trucks, this figured decreased to 27.91%. For more than 7 trucks this decreased to 23.26. These figures were derived using the solver solution in the queuing model. In this model I simply first had to find the lambda and beta and enter it into the model. This data was given in the background information of the problem. I then changed the figure that determines probability of having more than the amount desired to five. This then gave me the probability of having more than the desired amount of trucks in the system. This process was repeated for the six and seven truck models. Another calculation determined was the highest number of trucks in the system with a 95% probability. The highest number amounted to 15 trucks. This figure was determined by simply changing the cell that corresponded to probability of less in the system. Through trial and error, I was able to get the desired probability and found my solution. The next calculation determined was the unload rate of five or fewer trucks with a 95% probability. The unload time for this scenario equaled to 5.8 trucks per hour. This number was determined by changing the service rate until the desired probability was found using a five-truck
Justin Berry
Module 4 Case Assignment
Course Number: LOG501
Course Name: Managing the Supply Chain
Report to Danny Wilco
Mr. Wilco, My current project was to analyze our current delivery model and to give a solution to our loading dock area. Many deliveries recently have been clogging the loading dock and through my analysis, this can be avoided by using time schedules. These schedules are based upon unloading times that were calculated using a queuing system model.
Assumptions
In order to use a queuing model there must be some assumptions made in order to perform calculations. One assumption that was made is that there will be only one truck unloading at a time. This assumption is very valid due to the fact that …show more content…
This amounted to 33.49%. For more than six trucks, this figured decreased to 27.91%. For more than 7 trucks this decreased to 23.26. These figures were derived using the solver solution in the queuing model. In this model I simply first had to find the lambda and beta and enter it into the model. This data was given in the background information of the problem. I then changed the figure that determines probability of having more than the amount desired to five. This then gave me the probability of having more than the desired amount of trucks in the system. This process was repeated for the six and seven truck models. Another calculation determined was the highest number of trucks in the system with a 95% probability. The highest number amounted to 15 trucks. This figure was determined by simply changing the cell that corresponded to probability of less in the system. Through trial and error, I was able to get the desired probability and found my solution. The next calculation determined was the unload rate of five or fewer trucks with a 95% probability. The unload time for this scenario equaled to 5.8 trucks per hour. This number was determined by changing the service rate until the desired probability was found using a five-truck