Microsoft Office Tutorials and References
In Depth Information
Exhibit 8.20 Distribution of daily arrivals for 250 simulated days
the majority of the 250 daily arrivals generated. In fact, for this particular sample,
we can see in Exhibit 8.20 that the number of simulated days of arrivals between 14
and 22 is 196 of the 250 days of arrivals, or approximately 78%.
8.5.6 Building the Data Collection Worksheet
There is still an important element missing in our understanding of daily demand:
we are unaware of the types of service that each of the arrivals will request and the
related times for service. Although the analysis, thus far, has been very useful, the
types of service requested could have a substantial impact on the demand for service
time. What remains is the assignment of speciļ¬c types of service to arrivals and the
subsequent determination of service times. Both of these issues need to be resolved
to determine the amount of daily demand that is serviced.
Should the calculations take place in the Calculation worksheet or the Data
Collection worksheet? I suggest that when you are in doubt you should consider
2 factors: (a) is one worksheet already crowded and, (b) is the calculation important
to collaboration, such that you would want it to appear on the same worksheet as
other calculations. The location of some model processes is often a judgment call. In
our case, the Calculation worksheet has been used to generate daily arrivals and the
sequence of arrival. Thus, we will use the Data Collection worksheet to deal with
service. This division of calculations will make the workbook more manageable to
those using the workbook for analysis.
Now, let us consider the delivery of service for the model. There is an impor-
tant issue to be aware of when considering service: simply because there is demand
for service, this does not imply that the Autohaus service system can process all
Search JabSto ::

Custom Search