Allowable order sizes Target values
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
Exercise 18:
a. For each scenario in the above table, run 100 simulations and report the overall mean service
level and the estimated cost. Report the lowest cost scenario that achieves a service level of
at least .9.
. Can you find a better scenario? You may also try varying the time between orders from every
7 days to every 10 days.
If you like, see Appendix 3 for how to use the feature Scenarios to run these model variations
more efficiently.
What is simulation
SimQuick
Process Simulation with Excel
Third Edition
David Hartvigsen
Mendoza College of Business
University of Notre Dame
(Updated on 6/15/2016)
2
Copyright © 2016 by David Hartvigsen
Updated on 6/15/2016
All rights reserved. No part of this publication may be reproduced, distributed, or transmitted
in any form or by any means, including photocopying, recording, or other electronic or
mechanical methods, without the prior written permission of the author, except in the case of
ief quotations embodied in critical reviews and certain other noncommercial uses permitted
y copyright law. For permission requests, write to the author at
David Hartvigsen
Mendoza College of Business
University of Notre Dame
Notre Dame, IN 46556
Email: XXXXXXXXXX
To order, go to Amazon.com
Printed by CreateSpace, Charleston, SC
This book was previously published by: Pearson Education, Inc.
3
To Nancy
4
Table of Contents
Preface ...................................................................................... XXXXXXXXXX7
Motivation ........................................................................ XXXXXXXXXX7
How to use the booklet .................................................... XXXXXXXXXX8
Chapter 1: Introduction .................................................... XXXXXXXXXX11
Sec. 1: What is process simulation? ............................... XXXXXXXXXX12
Sec. 2: What does SimQuick do? ................................... XXXXXXXXXX13
Sec. 3: How does SimQuick incorporate uncertainty? ... XXXXXXXXXX14
Sec. 4: System requirements and “installation” .............. XXXXXXXXXX16
Chapter 2: Waiting Lines ................................................. XXXXXXXXXX18
Sec. 1: Solving a problem with SimQuick ...................... XXXXXXXXXX19
Example 1: A Bank ............................................. XXXXXXXXXX19
Modeling the process (with a process flow map XXXXXXXXXX
Entering the model into SimQuick ......... XXXXXXXXXX20
Interpreting SimQuick results ................. XXXXXXXXXX26
Improving the process, Variation 1 ......... XXXXXXXXXX29
Improving the process, Variation 2 ......... XXXXXXXXXX31
Sec. 2: Additional waiting line processes ....................... XXXXXXXXXX33
Example 2: A grocery store checkout ................. XXXXXXXXXX33
Example 3: A call center .................................... XXXXXXXXXX34
Example 4: A fast-food restaurant drive-thru ..... XXXXXXXXXX35
Sec. 3: Decision Points.................................................... XXXXXXXXXX35
Example 5: An airport security system ............... XXXXXXXXXX36
Example 6: A department of motor vehicles ...... XXXXXXXXXX39
Example 7: A hospital emergency room ............. XXXXXXXXXX41
Sec. 4: Advanced SimQuick features ............................ XXXXXXXXXX42
Example 8: Buffer Tracking ............................... XXXXXXXXXX43
Example 9: “Unavailable” elements ................... XXXXXXXXXX44
Example 10: Changing Distributions ................. XXXXXXXXXX45
Example 11: Discrete Distributions .................... XXXXXXXXXX48
5
Example 12: Resources and Priorities ................ XXXXXXXXXX50
Chapter 3: Inventory in Supply Chains ...................... XXXXXXXXXX54
Sec. 1: A periodic review inventory policy ..................... XXXXXXXXXX56
Example 13: Grocery store inventory ................. XXXXXXXXXX56
Sec. 2: Reorder point inventory policies ......................... XXXXXXXXXX59
Example 14: An electronics superstore .............. XXXXXXXXXX59
Example 15: A warehouse .................................. XXXXXXXXXX63
Example 16: Two stores and a warehouse .......... XXXXXXXXXX64
Sec. 3: More complex inventory policies ....................... XXXXXXXXXX66
Example 17: An appliance store ......................... XXXXXXXXXX67