this assignment is based on the SimQuick Book. I have attached the ebook and the corresponding question.

this assignment is based on the SimQuick Book. I have attached the ebook and the corresponding question.



Allowable order sizes Target values 20 60 100 100 20 60 100 120 40 60 100 100 40 60 100 120 40 60 120 120 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. b. 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 brief quotations embodied in critical reviews and certain other noncommercial uses permitted by 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: [email protected] 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 ........................................................................................................ 7 Motivation ......................................................................................... 7 How to use the booklet ..................................................................... 8 Chapter 1: Introduction ...................................................................... 11 Sec. 1: What is process simulation? ................................................. 12 Sec. 2: What does SimQuick do? ..................................................... 13 Sec. 3: How does SimQuick incorporate uncertainty? ..................... 14 Sec. 4: System requirements and “installation” ................................ 16 Chapter 2: Waiting Lines ................................................................... 18 Sec. 1: Solving a problem with SimQuick ........................................ 19 Example 1: A Bank ............................................................... 19 Modeling the process (with a process flow map) ..... 20 Entering the model into SimQuick ........................... 20 Interpreting SimQuick results ................................... 26 Improving the process, Variation 1 ........................... 29 Improving the process, Variation 2 ........................... 31 Sec. 2: Additional waiting line processes ......................................... 33 Example 2: A grocery store checkout ................................... 33 Example 3: A call center ...................................................... 34 Example 4: A fast-food restaurant drive-thru ....................... 35 Sec. 3: Decision Points...................................................................... 35 Example 5: An airport security system ................................. 36 Example 6: A department of motor vehicles ........................ 39 Example 7: A hospital emergency room ............................... 41 Sec. 4: Advanced SimQuick features .............................................. 42 Example 8: Buffer Tracking ................................................. 43 Example 9: “Unavailable” elements ..................................... 44 Example 10: Changing Distributions ................................... 45 Example 11: Discrete Distributions ...................................... 48 5 Example 12: Resources and Priorities .................................. 50 Chapter 3: Inventory in Supply Chains ........................................ 54 Sec. 1: A periodic review inventory policy ....................................... 56 Example 13: Grocery store inventory ................................... 56 Sec. 2: Reorder point inventory policies ........................................... 59 Example 14: An electronics superstore ................................ 59 Example 15: A warehouse .................................................... 63 Example 16: Two stores and a warehouse ............................ 64 Sec. 3: More complex inventory policies ......................................... 66 Example 17: An appliance store ........................................... 67