Compute the following table using a spreadsheet.
a. Generate the two random number streams, corresponding to interarrival time and operation time at station A, for the first ten arriving entities in the two workstation in a series model. Do this by using the random number generator built into your spreadsheet program. In Excel, this would be accomplished by entering the function rand() into each cell of the Pseudo-random Number / Bet. Arrivals and the Pseudorandom Number / Service Time columns.
b. Use the inverse-transformation method to generate the time between arrivals and service time samples. This means entering equation 5-1 into each cell in the Sample / Bet. Arrivals column and entering equation 5-2 into each cell in the Sample / Service Time column. The corresponding pseudo-random number in the columns should be referenced for each cell.
