Page 553 -

SIMULATION WITH EXCEL 533

Appendix 12.1 Simulation with Excel

Excel enables small and moderate-sized simulation models to be implemented
relatively easily and quickly. In this appendix we show the Excel worksheets for
the three simulation models presented in the chapter.
The PortaCom Simulation Model

We simulated the PortaCom problem 500 times. The worksheet used to carry out
the simulation is shown again in Figure 12.15. Note that the simulation results for
trials 6 through 495 have been hidden so that the results can be shown in a
reasonably sized figure. If desired, the rows for these trials can be shown and the

Figure 12.15 Worksheet for the Portacom Problem

EXCEL file

PORTACOM

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.