This assignment is based on

SimQuick: Process Simulation with Excel. i have attached the book and requirements as well as. You need to work on the Number 5

Exercise 14(Page 63)

Exercise 15(Page 63)

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 rubric 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 your 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 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