Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »
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

Answered 7 days After Nov 27, 2023

Solution

Pashikanti Sneha answered on Dec 04 2023
17 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here