{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

hw5 - C17=C16 B17...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ISE 435 Discrete Systems Simulation Homework #5 Spring Semester 2012 Due: Wednesday, February 29 1) Using the Excel solution from HW1 (attached), create a history of the number of people waiting in the queue from the beginning of the simulation until the time when Customer #15 exits the system. Use your history to calculate the average and standard deviation for the number of people waiting in the queue.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A B C D E F G H Percent Server Idle Time '=Total Server Idle Time/Total Simulation Time =sum(Server_Idle)/End_Serv(Last Customer) =652/1778.5=36.72% Average Customer Waiting Time =Total Customer Waiting Time/Total Number of Customers =241/500=0.482 Sample calculation for the second customer Arrival(I)=Arrival(I-1)+Arrival_Interval(I)
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C17=C16+B17 Start_Serv(I)=IF(End_Serv(I-1)<Arrival(I) , Arrival(I) ,End_Serv(I-1)) E17=IF(F16<C17,C17,F16) End_Serv(I)=Start_Serv(I)+Service_Time(I) F17=E17+D17 Server_Idle(I)=Start_Sevr(I) - End_Serv(I-1) G17=E17-F17 Cust._Waiting(I)=Start_Serv(I) - Arrival(I) H17=E17-C17 Cust. Arrival_Interval Arrival Service_Time Start_Serv End_Serv Server_Idle Cust._Waiting 1 3 3 2.5 3 5.5 3 2 3 6 2 6 8 0.5 3 2 8 2.5 8 10.5 4 6 14 2 14 16 3.5 5 1 15 2 16 18 1 6 4 19 2 19 21 1 7 3 22 2 22 24 1 8 1 23 2 24 26 1 9 1 24 2.5 26 28.5 2 10 1 25 2 28.5 30.5 3.5 11 2 27 2 30.5 32.5 3.5 12 4 31 2.5 32.5 35 1.5 13 2 33 2.5 35 37.5 2 14 3 36 2.5 37.5 40 1.5 15 4 40 2.5 40 42.5...
View Full Document

Report

{[ snackBarMessage ]}