{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# hw5 - C17=C16 B17...

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

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.

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

View Full Document
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)
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

{[ snackBarMessage ]}