Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Simquick examples

22/12/2020 Client: saad24vbs Deadline: 14 Days

SimQuick Process Simulation with Excel


Second Edition


by David Hartvigsen


Mendoza College of Business Administration University of Notre Dame


Prentice Hall Upper Saddle River, NJ 07458


v


Table of Contents Preface Motivation................................................................................................................x


How to use the booklet ............................................................................................x Chapter 1: Introduction .............................................................................................1 Sec. 1: What is process simulation?.........................................................................2 Sec. 2: What does SimQuick do?.............................................................................3 Sec. 3: How does SimQuick incorporate uncertainty? ............................................4 Sec. 4: System requirements and “installation”.......................................................6 Chapter 2: Waiting Lines...........................................................................................8 Sec. 1: Solving a problem with SimQuick...............................................................9 Example 1: A Bank..................................................................................................9


Modeling the process (with a process flow map) ......................................10 Entering the model into SimQuick ............................................................10 Interpreting SimQuick results ....................................................................15 Improving the process, Variation 1............................................................19 Improving the process, Variation 2............................................................22


Sec. 2: Additional waiting line processes ..............................................................23


Example 2: A grocery store checkout........................................................23 Example 3: A call center............................................................................24 Example 4: A fast-food restaurant drive-thru ............................................25 Example 5: A bank with a discrete distribution.........................................26 Example 6: A bank with changing demand ...............................................27


Sec. 3: Waiting lines with Decision Points............................................................29


Example 7: An airport security system......................................................30 Example 8: A department of motor vehicles .............................................33 Example 9: A hospital emergency room....................................................34


x


Sec. 4: Waiting lines with priorities and resources................................................36


Example 10: Cross-trained workers at a fast-food restaurant....................36 Example 11: Value meals at a fast-food restaurant ...................................40


Chapter 3: Inventory in Supply Chains..............................................................44 Sec. 1: A periodic review inventory policy ...........................................................46


Example 12: Grocery store inventory........................................................46 Sec. 2: Reorder point inventory policies................................................................49


Example 13: An electronics superstore .....................................................49 Example 14: A warehouse .........................................................................53 Example 15: Two stores and a warehouse.................................................54


Sec. 3: More complex inventory policies ..............................................................56


Example 16: An appliance store ................................................................57 Example 17: A department store................................................................62


Chapter 4: Manufacturing ......................................................................................69 Sec. 1: Linear flow processes ................................................................................70


Example 18: A generic linear flow process ...............................................71 Example 19: A manufacturing cell ............................................................73


Sec. 2: Assembly/disassembly processes...............................................................75


Example 20: Box manufacturing ...............................................................75 Sec. 3: Batch and job shop processes ....................................................................79


Example 21: Pharmaceutical manufacturing .............................................79 Example 22: A single machine job shop....................................................83


Sec. 4: Quality and reliability in processes............................................................86


Example 23: A quality control station .......................................................86 Example 24: A machine with breakdowns ................................................89


vii


Chapter 5: Project Management ...........................................................................91 Example 25: A software development project.................................................92 Example 26: A house addition project.............................................................96


Appendix 1: The Steps in a Simulation Project ...............................................98 Appendix 2: Enhancing SimQuick with Excel Features...............................99 Appendix 3: Using Custom Schedules .......................................................................... 105 Appendix 4: SimQuick Reference Manual ......................................................108


x


Preface Motivation Process simulation is one of the conceptually simplest and most often applied techniques in Operations Management and Management Science, yet it has not been widely taught to business students. A key reason for this is that performing process simulation requires the use of software, and the software that is available tends to be complex and expensive. Even the more graphics-based packages, although often beautifully designed, frequently have an enormous number of features that place an unnecessary burden on students (and instructors) in classes that are not devoted to simulation. SimQuick is a computer package for process simulation that is easy to learn (most of its features can be learned in under an hour of class time or independent reading) and inexpensive. It is aimed primarily at business students and managers who want to understand process simulation and be able to quickly analyze and improve real-world processes. SimQuick is flexible in its modeling capability; that is, it is not a “hardwired” set of examples; it requires true modeling. In addition, SimQuick runs in the widely-known Microsoft Excel spreadsheet environment (it is an ordinary Excel 2000 file with some hidden macros). Hence, users of Excel will already be familiar with much of the interface, and the results are already in the spreadsheet, ready for analysis. This booklet accompanies SimQuick. It presents the basics of process simulation by having the reader construct, run, and analyze simulations of realistic processes using SimQuick. Chapter 1 contains a brief introduction to process simulation and the concepts underlying SimQuick. The next four chapters contain a variety of examples of process simulation. These examples are organized as follows: waiting lines (Chapter 2), inventory in supply chains (Chapter 3), manufacturing (Chapter 4), and project management (Chapter 5). Each example is followed by an exercise. All of the examples and exercises have been designed with business students and managers in mind. In addition to presenting the basics of process simulation, this booklet introduces a number of key concepts from the analysis of processes: service level, cycle (or waiting) time, throughput, bottleneck, batch size, setup, priority rule, and so on. The booklet also introduces some key trade-offs from the analysis of processes: number of servers vs. service level, inventory level vs. service level, working time variability vs. throughput, batch size vs. service level, and so on. These notions are presented through computer models that the reader constructs and experiments with using SimQuick. How to use the booklet The booklet is self-contained; that is, all technical terms involving processes or operations are defined. (The reader is assumed to have a rudimentary understanding of how to use Excel on the level of knowing how to save files and how to enter information into cells.) The chapters are


ix


organized around typical topics in Operations Management and Management Science courses so that this booklet can easily be used in these types of courses. The reader should first read Chapter 1 (which contains a conceptual explanation of process simulation and SimQuick) and Section 1 of Chapter 2 (which contains a step-by-step explanation of how to use SimQuick by completely working through a simple example). After this the reader has a lot of freedom: The remaining sections in Chapters 2, 4, and 5 can be read in any order (except Example 7 should be read before Example 11). However, the sections in Chapter 3 build on one another and should be read in sequence. The bulk of Chapters 2 through 5 consists of examples of processes that can be modeled using SimQuick. When needed, an example discusses how to build the SimQuick model. Each example is followed by an exercise. A very quick treatment of process simulation could consist of working through Example/Exercise 1, followed by Examples/Exercises 2-4 for waiting lines and Example/Exercise 18 for manufacturing. With just this material, many real-world processes can be easily modeled and studied. Adding Example/Exercise 7 with Decision Points would allow the modeling of many more types of processes. Adding Examples/Exercises 12 and 13 would provide a quick introduction to the modeling of inventory in supply chains. The booklet contains four appendices. Appendix 1 contains a list of the basic steps in conducting a simulation project. Appendix 2 contains tips on how to enhance SimQuick by using some of the features built into Excel. These tips are tied to examples in the booklet. Appendix 3 describes how to use a feature of SimQuick called Custom Schedules. Appendix 4 contains a succinct description of all the features of SimQuick and can be used for reference. Hence, the features of SimQuick are presented in two ways: through examples and in a reference manual. Solutions to exercises: Instructors are provided with complete solutions (in Excel) to every exercise. These solutions may be distributed to the students at the instructor’s discretion. Web site: Refer to www.prenhall.com/hartvigsen for additional information on SimQuick, this booklet, technical support, and process simulation in general. Over the past four years, I have used SimQuick in the classroom with executive MBAs, full-time MBAs, and undergraduate business students. After a one-hour introduction in class (basically, covering Section 1 of Chapter 2), the students successfully solve a variety of modeling problems with little help. This introduction also serves as a launching pad for term projects, whereby students identify and analyze real-world processes of their choice.


x


New to the 2nd edition: The SimQuick software in the second edition has been changed in a number of ways from its first incarnation. These changes include the following (the manual in Appendix 4 contains all the features of SimQuick):


• SimQuick runs considerably more quickly. This allows more simulations to be performed in a reasonable amount of time, which leads to more accurate results. As a result, more simulations are allowed.


• SimQuick accepts larger models: up to 250 elements (new tables can be added by pasting copies of the 20 tables given for each element).


• Essentially arbitrary statistical distributions can be constructed using discrete distributions (introduced in Example 5).


• A “View Model” button has been added to the Control Panel. Clicking this button produces a copy of the tables used in the model in a format convenient for printing and logic checking.


• The initial number of objects at Buffers can be generated randomly. This allows models to capture demand patterns that change over time (see Example 6).


• Decision Points can have up to ten outputs. • The simulation details appearing on the Results worksheet can be suppressed, which


allows SimQuick to run faster, especially when many simulations are performed. • The method for using Custom Schedules for modeling arrivals and departures has been


simplified (see Appendix 3). The text has also been updated; these changes include the following:


• Four completely new models have been added. Two of these models deal with services: airport security and a hospital emergency room (Examples 7 and 9); and two deal with inventory in supply chains: a base stock policy used in an appliance store (Example 16) and a periodic review policy used in a department store (Example 17).


• The key introductory section (Section 1 of Chapter 2) on how to use SimQuick has been streamlined (by removing the introduction of Decision Points). As a result, learning the basics of SimQuick is even easier than in the first edition. This makes possible a shorter treatment of process simulation, if the instructor wishes.


• Decision Points are now introduced in a separate section (Section 3 of Chapter 1) via an airport security example. This example is more timely than the ATM bank example from the first edition, which has been removed. Thus the topic of Decision Points may be skipped altogether.


• The issue of how to model observed data with a statistical distribution, particularly when it does not follow a built-in SimQuick distribution, is an important topic and is addressed as a new variation on the introductory bank example (see Example 5).


• The initial conditions of a simulation (particularly how much inventory is initially in the buffers) are of critical importance. This topic is now explicitly dealt with as a new variation on the bank example (see Example 6).


xi


• An important issue in manufacturing environments is that, over the long run, inventory will pile up to fill the available space. This issue is now addressed in the exercise on linear flow processes (see Exercise 18).


• The general model for project management has been simplified. • An appendix has been added that lists the basic steps in a simulation project.


x


To Nancy


Acknowledgments The design of SimQuick was inspired by the breakthrough simulation product XCELL, so I want to begin by acknowledging its authors: Richard Conway, William L. Maxwell, John O. McClain, and Steven L. Worona. Next, I want to thank my editor Tom Tucker at Prentice Hall. He has been indispensable in helping me to define this project and bring it to fruition. I want to thank the following reviewers for their careful reading and excellent suggestions on a draft of the first edition: Sue Abdinnour-Helm, Arundhati Kumar, Larry Meile, Kelly B. Nichols, Jeffrey L. Rummel, and Billy M. Thornton. I’d also like to thank the reviewers of the second edition for their thoughtful suggestions based on their classroom use of SimQuick: C.H. Aikens, Stephen N. Chapman, Christos Koulamas, Michael Schwartz, and Billy M. Thornton. I still haven’t been able to implement all the great ideas I’ve received; I wish there was more time! I want to thank my colleagues Lee Krajewski and Hojung Shin for a number of helpful discussions of this project. I want to thank Kristin Ann Steffeck for her copy editing on the first edition. Finally, I want to thank my many students (executive MBAs, full-time MBAs, and undergraduate business students) of the past four years who have made many helpful suggestions during the development of this software and booklet. In particular, I’d like to single out Douglas Wait, Ben Gaw, Patrick Dahman, Xuejun Zhang, and Katy Delany for their insights.


1


Chapter 1: Introduction Learning objectives: • To understand the idea of process simulation • To understand the general structure of SimQuick models • To understand the role of uncertainty in process simulation • To get SimQuick running on your computer


2


Overview This chapter contains a brief definition of process simulation, an overview of how SimQuick works, and instructions for how to run SimQuick on a computer. Most of the details of how to use SimQuick are covered in Chapter 2, Section 1. Section 1: What is process simulation? Process simulation is a widely used technique for improving the efficiency of processes. Following are some examples of processes and some related efficiency problems that can be addressed with process simulation (and SimQuick): Examples of processes: • People moving through a bank or post office • Telephone calls moving through a call center • Parts moving along an assembly line or through a batch process or a job shop • Inventory moving through a retail store or warehouse • Products moving by trucks, trains, or ships through a supply chain • A software development project Examples of efficiency problems: • How many tellers are needed to keep waiting times at a bank reasonably short? • What effect will a new answering system have on how long customers wait at a call center? • What effect will a new just-in-time (JIT) inventory system have on the number of units


produced per day on an assembly line? • What is the best batch size to use in a factory? • What is the best delivery policy for goods at a warehouse? • How much inventory should be kept on the shelves in a grocery store? • How many machines should each worker operate in a manufacturing cell? • How should inventory be distributed along a supply chain? • What is the expected duration of a software development project? With process simulation, you begin by building a computer model of a real-world process. Your initial goal is to have the computer model behave in a way similar to the real process, except much more quickly. You then try out various ideas for efficiency improvements on the computer model and use the best ideas on the real process. Thus, a lot of time and money can be saved. Simulation is particularly useful when there is uncertainty in a process (e.g., the arrival times of customers, the demand for a product, the supply of parts, the time it takes to perform the work, the quality of the work). With uncertainty, it is often difficult to predict the effects of making changes to a process, especially if there are two or more sources of uncertainty that interact.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Helping Hand
Calculation Guru
Custom Coursework Service
Homework Guru
Best Coursework Help
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$142 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$140 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested.

$135 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

$135 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$142 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$140 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

P0122 throttle pedal position sensor switch a circuit low - Bcvr entries - Total support recruitment rugby - Coworker taking credit for my work - Efe matrix for walt disney company - Strategy report on the Starbucks. - Application of mis in manufacturing sector case study - As1684 span tables download free - Transference and countertransference ppt - Commercial paper and treasury bills - Strategic sourcing from periphery to the core - The leslie fay companies - S/4hana self-service procurement configuration cookbook - Visio 2016 entity relationship diagram - Aboriginal art symbols fire - Attribute extraction template file - Csu discussion - What does the fitt formula stand for - Faculty of engineering malta - Stopping distance formula standard maths - Polc strategy - The communication process involves all of the following except - Ato private health insurance rebate tiers - Symon brewis-weston net worth - Prego 1b - Cross industry standard process for data mining pdf - Before the flood movie worksheet answer key - Cs lewis screwtape letters summary - Prediction interval in r multiple regression - Anatomy and physiology - Warehoousing - Frankenstein reading guide letters answers - Bank of america case analysis - Foundations of comparative politics clark pdf - Income statements for burch company for 2018 and 2019 follow - Square root of 5.5 - Assignment 2 - Blue sky surf shop report - Trevor noah black hitler - Exploring statistics tales of distributions 12th edition pdf - Explicit, Implicit and Tacit Knowledge - Importerror no module named py31compat - David rafalovsky bank of america - Siemens sinamics g110 parameter list - Tata motors case study analysis - Ecdl login ics skills - Late submission penalty latrobe - Archaeology activities for classrooms - Case study analysis example - Evaluative tools - Break even analysis in healthcare - Daniel glaser chairman of the college of san antonio - Intake manifold runner control circuit - Unum sick pay insurance - Leadership style of google ceo - Recall two characters who died of a disease - 4.380 kg in pounds and ounces - Flysky gt3b 8 channel - Doing ethics 5th edition chapter 1 - Coca cola labor issues - One paragraph 3 - Sex education in schools pros and cons essay - Brandon gorin net worth - Week 4 #1 - In a general sense the proverbs can be grouped into two major forms. one of these forms is - Jeff majors psalms 23 instrumental - Sodium chloride and sodium carbonate balanced equation - Franklin covey planning software 8.0 free download - Sub process mapping six sigma - George vs george text - Love song of j alfred prufrock translation - LDR531 Week 5 Strategic Change Case Study - Converting Java script function to Type Script - Glb Ethics - Stats test 18 questions 75mins to do - Need Response 2 to below discussion-bonds - Cpccbc4010b assessment 5 answers - To kill a mockingbird tree filled with cement - Why did caterpillar tractor decide to "unbundle" the price of their tractors? - Optional steps in the accounting cycle - How should management respond to a union organizing campaign - Which portion of the microsoft baseline security analyzer (mbsa) scan takes the longest? - Sir joseph hotung net worth - List of human bones alphabetical - Codes and conventions in horror films - Socio - University of delaware interview - Tlmt 601 - Plot diagram template doc - The message of the almond tree - Nike cost of capital case study solution - Boogie board sync ewriter - Journal Article(NCM) - Summary of journals - Flemings trees top 10 - Microeconomics HW - Dow corning 890 sl silicone joint sealant - Desktop activity moderator driver - Standard deviation is the square root of variance - Describe the moment captured in leonardo's last supper painting