Applied Management Science

(1)

(2)

2

Main Menu

The material in the CD-ROM portion of Applied Management Science, Second Edition has been designed to expand the coverage in the text, provide additional problem material, and provide a collection of resources for your use in this course. The material here is organized by resource, and then by chapter. Much of the material on this CD-ROM is in the Adobe Acrobat PDF format, and you can navigate through this material by selecting the links on the screens that follow. Some of the other material, such as the Excel files and

templates, PowerPoint presentations and Excel Add-ins, will require you to go through other applications and access the material through the folders on this CD-ROM.

Select a resource below to begin.

Additional Chapters Supplements

Appendices

Problem Motivations

Additional Problems and Cases Excel Templates

Excel Files

Excel Add-Ins and Software PowerPoint Files

Photo Credits

(3)

Additional Chapters

These auxiliary chapters, frequently omitted in the introductory management science course due to the

degree of complexity or lack of time, are included here for students and instructors who wish to explore these topics. Select a chapter to begin.

Chapter 11 – Quality Management Models Chapter 12 – Markov Processes Models

Chapter 13 – Nonlinear Models: Dynamic, Goal, and Nonlinear Programming Models

Return To Main Menu

(4)

4

Supplements

Supplement CD1 provides a brief review of material covered in a first course in statistics (up through

regression). The last five of these supplementary units provide coverage of additional theoretical concepts and the mathematical algorithms for topics covered in the text. Select a Supplement to begin.

Supplement CD1 – Review of Probability and Statistics Concepts Supplement CD2 – Duality

Supplement CD3 – The Simplex Method

Supplement CD4 – Branch and Bound Algorithms for Integer Programming Models Supplement CD5 – Algorithms for Network Models

Supplement CD6 – Production Based Inventory Models

Return to Main Menu

(5)

Appendices

These appendices provide more extensive mathematical and theoretical coverage of models, algorithms, and mathematical derivations, as well as software applications for simulation models. Select an Appendix to begin.

Appendix 3.1 Additional “Real-Life” Linear Models

Appendix 3.2 A Multiperiod Cash Flow Scheduling Model Appendix 3.3 Data Envelopment Analysis

Appendix 3.4 An Integer Programming Advertising Model Appendix 7.2 Daniel’s Test for Trend

Appendix 7.3 Test for Autocorrelation

Appendix 7.4 Forecasting Based on Taking First Differences

Appendix 7.5 Determining Whether to Include Dummy Seasonal Variables in Regression Models Appendix 7.6 Use of the Excel Trendline Feature

Appendix 7.7 Developing an Excel Spreadsheet for Performing Classical Decomposition Appendix 8.2 Mathematical Formulas for Inventory Models

Appendix 8.3 Determining the Reorder Point, R, Corresponding to a Unit Service Level

Appendix 8.4 Determining the Optimal Order Quantity Under an Incremental Discount Schedule Appendix 8.5 Derivation of the Planned Shortage Model

Appendix 8.6 Single-Period Inventory Model

Appendix 9.2 Goodness of Fit Testing to Determine the Appropriate Probability Distribution for the Arrival and Service Processes

Appendix 9.3 The Erlangian Distribution

Appendix 9.4 Derivation of the Performance Measures for M/M/1 Queues Using Balance Equations Appendix 9.5 Derivation of the Performance Measures for M/M/k Queues Using Balance Equations Appendix 9.6 Transition Diagram for an M/M/k/F Queuing System

Appendix 9.7 Transition Diagram for an M/M/1//m Queuing System

Appendix 9.8 Assembly Line Balancing – An Application of Tandem Queues Appendix 10.1 Conducting a Nest Event Simulation Using Extend

Appendix 10.2 Generating Pseudo-Random Numbers Using the Linear Congruential Method Appendix 10.3 Statistical Tests for Comparing Simulation Results

Appendix 10.4 Simulation of a Capital Bank Model Using Excel

Appendix 10.5 Interpolation Method for Generating Random Variable Inputs

Appendix 10.6 Using Crystal Ball for Simulating Queuing, Decision Analysis and Project Management Models

Appendix 10.7 Variance Reduction Techniques Return to Main Menu

(6)

6

Problem Motivations

These folders give specific problem references for key topics covered in each chapter of the text. Select a chapter below to begin.

Chapter 2: Linear and Integer Programming Models

Chapter 3: Applications of Linear and Integer Programming Models Chapter 4: Network Models

Chapter 5: Project Scheduling Models Chapter 6: Decision Models

Chapter 7: Forecasting Models Chapter 8: Inventory Models Chapter 9: Queuing Models Chapter 10: Simulation Return to Main Menu

(7)

Additional Problems and Cases

These folders contain additional problems for each chapter and a number of additional cases for selected chapters. Select a chapter below to begin.

Chapter 1 Introduction to Management Science Models Chapter 2: Linear and Integer Programming Models

Chapter 7: Forecasting Models Chapter 8: Inventory Models Chapter 9: Queuing Models Chapter 10: Simulation

Return to Main Menu

(8)

8

Templates

Many of the models discussed in the text can be solved using the following templates. To access these files, run Excel and open the files from the “templates” folder on this CD. Additionally, you can copy these files to your hard drive, and access them from there. The files you will find in this folder are:

• CPM-Budget.xls • CPM-Deadline.xls

• Decision Payoff Table.xls • forecast.xls • inventory.xls • Markov.xls • network.xls • PERT-COST.xls • PERT-CPM.xls • QC.xls • queue.xls

Return to Main Menu

(9)

Excel Files

All of the examples discussed in the text have Excel files included in these folders. Additional files are

included for some problems and cases associated with these chapters. To access these files, run Excel and open the files from the “excel” folder on this CD. A separate subfolder has been created for each chapter, making it easier for you to find the file or files for which you are looking. Additionally, you can copy these files to your hard drive, and access them from there.

Chapter 1: Introduction to Management Science Models Chapter 2: Linear and Integer Programming Models

Chapter 11: Quality Management Chapter 12: Markov Processes

Chapter 13: Nonlinear Models: Dynamic, Goal, and Nonlinear Programming Models Supplement CD1: Review of Probability and Statistical Concepts

Return to Main Menu

(10)

10

Excel Add-Ins and Software

This CD-ROM includes student versions of three software packages: TreePlan for Excel

This Excel add-in will help you solve decision tree problems.

To run TreePlan for Excel, run Excel, and open treeplan.xla from this CD-ROM (in the folder software/treeplan – you can also copy this file to your hard drive). Open a new sheet, and choose Decision Tree from the Tools

menu. For instructions on how to use TreePlan, view the documentation by opening the file “treeplan.pdf” in the same folder.

Decision Support Services

Crystal Ball 2000

This Excel add-in will help you analyzing simulations. You will need to install Crystal Ball 2000 on your hard drive. For instructions on how to install Crystal Ball 2000, view the Readme.doc file in the software/crystalball folder.

This software will help you conduct simulations. You will need to install Extend LT5 on your hard drive. For instructions on how to install Extend LT5, view the Readme.doc file in the software/extend folder.

www.imaginethatinc.com

Return to Main Menu

(11)

PowerPoint Files

PowerPoint slides that parallel the discussion of each chapter are given in the following folders. You will need either PowerPoint or the PowerPoint Viewer (which you can install from this CD). Select a chapter below to begin.

Chapter 1: Introduction to Management Science Models Chapter 2: Linear and Integer Programming Models

Chapter 11: Quality Management Chapter 12: Markov Processes

Chapter 13: Nonlinear Models; Dynamic, Goal, and Nonlinear Programming Models

Install the PowerPoint Viewer

Return to Main Menu

(12)

12

Photo Credits

Return to Main Menu