Microsoft Office Tutorials and References
In Depth Information
resolved for each auto, as shown in the process element Auto Serviced? When the
simulation starts, the model will be operated for a predetermined period of time,
simulating a number of days of operation, during which it will collect data on the
servicing of autos.
How will we apply the MCS method to our problem; that is, how do we execute
the steps 6c- 6f ? Although we have not yet speciﬁed every detail of Inez’s problem,
we now have a general idea of how we will structure the simulation. We can take
the two processes described in Exhibit 8.16, simulate each, and use the results of
the Arrival Process as input for the ServiceProcess . The steps for determining the
remaining details of a model can be arduous, and there are numerous details that
still need to be determined. Through interviews with Wolfgang, and through her
own research, Inez must identify, to the best of her ability, the remaining details.
Table 8.2 is a compilation of some detail issues that remain for the model. This
table takes us one step closer to the creation of an Excel simulation model by
detailing the arrival and service processes. In the Arrival process we decide that
arrival of demand is complete by 9:00 am. Permitting arrivals all day will make the
model much more complex. Certainly model complexity should not suggest how she
designs her service, but given that this business model will have contract demand as
opposed to drop-in demand, she has incentives to manage demand to suit her capac-
ity planning. Additionally, this procedure may suit the customer well by providing
all customers with a structured approach for requesting service.
In the Service portion of the model, the arriving autos will receive a random
assignment of a service type. Although the assignment is random, it will be based
on an anticipated distribution of service type. Then service will be administered
in a ﬁrst-come-ﬁrst-served manner at the corresponding bay, as long as capacity is
available. Finally, we will use Wolfgang’s subjective opinion on the service time
distributions for the three services to consume service capacity at the bays.
We have resolved most of the issues that are necessary to begin constructing
an Excel model. As usual, we should consider the basic layout of the workbook.
I suggest that we provide for the following predictable worksheets: (1) introduc-
tion to the problem or table of contents ,(2)a brain containing important data and
parameters, (3) a calculation page for the generation of basic uncertain events of the
simulation, (4) a data collection page for collecting data generated by the logic of
the simulation, and (5) a graph page to display results.
8.5.1 Status of Autohaus Model
Now, let us take stock of where we are and add the ﬁnal detail to our model of
operation for Autohaus:
1. We have developed a sampling mechanism to determine the random Poisson
arrivals of autos. Additionally, we have a similar discrete sampling mechanism
for assigning the service type that is requested by each arrival.