post and attach one Microsoft Excel file per problem. Please show all of the steps needed to solve your problem(s).
Module 7 Problems
Number Question 1 Question 2
1 Exercise 13(Page 59) Exercise 14(Page 63)
2 Exercise 13(Page 59) Exercise 15(Page 63)
3 Exercise 13(Page 59) Exercise 16(Page 66)
4 Exercise 13(Page 59) Exercise 11(Page 50)
5 Exercise 14(Page 63) Exercise 15(Page 63)
6 Exercise 14(Page 63) Exercise 16(Page 66)
7 Exercise 14(Page 63) Exercise 11(Page 50)
8 Exercise 15(Page 63) Exercise 16(Page 66)
9 Exercise 15(Page 63) Exercise 11(Page 50)
10 Exercise 16(Page 66) Exercise 11(Page 50)
Requirements:
* Read this ru
ic before posting your answer.
* You can find the description of each problem under Module: "Module 6 PDF Files".
* Please post your answers to this discussion board. Remember to show all of the steps needed to solve you
problem(s). No credit will be awarded for responses containing only the answers—your reasoning and
calculations must be included.
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