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 manual

25/12/2020 Client: saad24vbs Deadline: 7 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.

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:

Homework Guru
University Coursework Help
Top Essay Tutor
Helping Hand
Best Coursework Help
Calculation Guru
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

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

$232 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$232 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

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

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

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

$225 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

Ardex wpm 3000x price - 230 mpa to psi - Week 11 Discussion - I may help in homework - Skeletal system gcse pe - Organization leadership - Stroud court community trust - Assignment 1: Procedural Law and the Bill of Rights - Under what type of marketing does kliptech operate - A story told lyrics - Unsw apa style referencing - Personal financial planning billingsley pdf - Bpi philam life tower - Root canal filling materials ppt - Suffer the little children pennhurst documentary - Taxation (120 words) - Othello and emilia affair - Interrupt keyword in c - Saf t intima change - Freeman 1984 stakeholder definition - Atomic energy application form - Ideal gas constant kpa - Asian pacific endodontic confederation - Cultural care plan template - Raptors a field guide for surveys and monitoring - Physical Security Research Paper - How do you find the heat capacity of a calorimeter - 15 ionic bonds worksheet answers - Power Quality and Simulation of VSC with Passive Harmonic Filters (By using Plecs program) - What are the functions and dysfunctions of immigration - New Practical Connection Assignment - Topographic map practice worksheet - Enculturation begins with the development of self-awareness, which may be defined as - Team Management Activity and Reflection - 125 enterprise drive pittsburgh pa 15275 - Was the scarlet pimpernel a real person - Geographic reasoning student pre assessment - Summary of the loneliness beyond poem - Eco - St charles gairdner hospital perth - Sustainability Initiative, Part 4 - Patient Autonomy Power point presentation - Count me in too online - MG315 Discussion Post 3 - Instant displays co uk - Why doesn t cybersecurity have a naics code - Data warehousing, Big Data, Green Computing - Binary signed to unsigned - Behavioral and social-cognitive approaches to forming habits - CPO 2100 European Democracies discussion Board about chapter 3 - Franklin covey planning software 8.0 free download - How positive team culture can correct the impact of lagging leadership creativity - University of queensland postdoctoral fellowship - Smart access account fee - Non medical staff making medical decisions - Airedale hospital respiratory consultants - Art labeling activity the structure of the epidermis - Silver nitrate flame test color - Discussion #2 - Centaurplus c27 wiring y plan - Forms of technical communication - Https www youtube com watch v trf27f2bn a - Strategic plan part 1: new product or service - Co op housing port moody - Keyboard is an output device - A level Physics Tuition - Bertrand russell thought philosophy was important because - Reasons to donate blood speech - Why was the milgram experiment unethical - How will you distinguish borneol and isoborneol by nmr - One point perspective from plan and elevation - Console into cisco switch with mac - What is x squared cubed - Activity 3.7 statistical analysis with excel conclusion question answers - Groups and teams in organizational behavior ppt - ITM capstone - Discussion 3 - Discussion Board Questions - CC W 9 D - Golden boy tara sullivan sparknotes - Runway orientation and design pdf - Eight keys chapter summaries - Examples of exemplars in forensic science - Data Management Systems - Balance sheet of coca cola 2014 - Icd 10 code for right tibial plateau fracture - Process - Access Control - Area perimeter and volume formulas - Assume that the real risk free rate is - Vehicle recovery training costs - Aws direct connect bgp asn - Cognitive humanistic and behavioral schools of thought - Critical reasoning - The length of the string "hello there. " is ____. - Multiphasic personality inventory test online - Briefly describe how supportive and interpersonal psychotherapies are similar - Erecruit nsw health dates - Activity based costing template - Business math and statistical measures - Threat of new entrants airline industry