Operations analysis using Microsoft Excel

Title:

Personal Author:

Weida, Nancy C.

Publication Information:

Australia : Duxbury Thomson Learning, 2001

ISBN:

9780534517397

Subject Term:

Microsoft Excel for Windows

Production management

Electronic spreadsheets

Added Author:

Richardson, Ronny

Vazsonyi, Andrew

Available:*

Library	Item Barcode	Call Number	Material Type	Item Category 1	Status
Searching... PSZ JB	30000004847194	HF5548.4.M523 W44 2001	Open Access Book	Book	Searching... Unknown
Searching... Razak School	30000005038892	HF5548.4.M523 W44 2001	Open Access Book	Book	Searching... Unknown

This new text is intended for courses in operations management and management science, with business statistics as a prerequisite. The authors offer practical approaches to managerial decision-making using spreadsheets and step-by-step instructions to present realistic operations management problems that reflect overall organizational issues and integrate other functional areas such as marketing and finance.Perfect as a supplement to any operations management or management science text, students need only posses a familiarity with Microsoft Excel in order to learn both basic and advanced techniques.

1 Creative Operations Management Problem Solving: A Decision-Making Approach	p. 1
1.1 Managerial Decision Making	p. 1
1.2 The Intelligence Phase of the Decision-Making Process	p. 4
1.3 The Design Phase of the Decision-Making Process	p. 10
1.4 The Choice Phase of the Decision-Making Process	p. 14
1.5 An Example: Jackets versus Scrap at the UNEEDA Corporation	p. 16
1.6 Concluding Comments	p. 25
Exercises	p. 25
2 Forecasting	p. 27
2.1 Forecasting at the LastEver Corporation	p. 28
2.2 Patterns of Data	p. 33
2.3 Forecasting Approaches	p. 42
2.4 Time Series Analysis	p. 44
2.5 Concluding Comments	p. 56
Exercises	p. 56
3 Advanced Forecasting	p. 59
3.1 Extrapolation from the Past	p. 59
3.2 Regression Analysis	p. 63
3.3 Cyclical and Seasonal Issues	p. 71
3.4 Concluding Comments	p. 81
Exercises	p. 81
4 Planning Models	p. 85
4.1 The Basic Planning Problem	p. 85
4.2 The Basic Pricing Problem	p. 87
4.3 Nonlinear Cost and Demand Functions	p. 91
4.4 Preparing a Five-Year Plan	p. 96
4.5 The Impact of Pricing	p. 97
4.6 Concluding Comments	p. 99
Exercises	p. 100
5 Aggregate Planning and Learning Curves	p. 103
5.1 The Nature of Aggregate Planning	p. 103
5.2 Tradeoffs between Production and Inventory	p. 103
5.3 Learning Curves	p. 110
5.4 Concluding Comments	p. 112
Exercises	p. 113
6 Inventory	p. 117
6.1 Why Hold Inventory?	p. 117
6.2 The Cost of Inventory	p. 118
6.3 Cyclic Inventory Control	p. 119
6.4 The Economic Order Quantity Model	p. 123
6.5 What-If Scenarios	p. 126
6.6 EOQ Model with Price Breaks	p. 130
6.7 Economic Production Lot Size Model	p. 132
6.8 Single-Period Models with Probabilistic Demand	p. 136
6.9 Multi-Period Models with Probabilistic Demand	p. 144
6.10 Concluding Comments	p. 149
Exercises	p. 150
7 Material Requirements Planning	p. 153
7.1 Where MRP Fits In	p. 153
7.2 Master Production Schedule	p. 155
7.3 Bill of Materials	p. 158
7.4 A Simple MRP Example	p. 162
7.5 Rolling the MRP Schedule	p. 163
7.6 Adding Allocated Inventory and Safety Stock	p. 165
7.7 A More Complex MRP Example	p. 166
7.8 Dealing with Multiple Products	p. 168
7.9 Problems at Central Products Incorporated	p. 171
7.10 Concluding Comments	p. 176
Exercises	p. 177
8 Quality: Monitoring Processes Using Charts	p. 181
8.1 Monitoring Processes by Charts: Looking at the Data	p. 181
8.2 Mean Charts	p. 183
8.3 The Run Chart	p. 186
8.4 The R (Range) Chart	p. 186
8.5 Standard Deviation Charts	p. 189
8.6 Using These Charts	p. 189
8.7 Control Charts for Attribute Data	p. 191
8.8 Other Quality Control Charts	p. 194
8.9 Concluding Comments	p. 197
Exercises	p. 197
9 Machine Replacement and Maintenance	p. 199
9.1 Machine Replacement Decisions	p. 199
9.2 Machine Maintenance Decisions	p. 206
9.3 Group Maintenance Decisions	p. 211
9.4 Concluding Comments	p. 214
Exercises	p. 214
10 Project Management	p. 217
10.1 The Project	p. 217
10.2 The Professor	p. 219
10.3 Network Diagrams	p. 219
10.4 Probabilities	p. 224
10.5 Crunching	p. 229
10.6 Concluding Comments	p. 234
Exercises	p. 235
11 Facility Location Decisions	p. 237
11.1 Factor Weighting	p. 237
11.2 Center-of-Gravity Method	p. 240
11.3 Cost-Volume Analysis	p. 242
11.4 Concluding Comments	p. 244
Exercises	p. 245
12 Risk Analysis and Simulation	p. 247
12.1 Problems Where Uncertainty Is Important	p. 247
12.2 Working the Cough Drop Problem	p. 252
12.3 Generating Random Numbers	p. 259
12.4 Break-Even Analysis under Uncertainty: A Case Study	p. 269
12.5 The Farmer's Problem: Dependent Random Variables	p. 274
12.6 Concluding Comments	p. 277
Exercises	p. 277
13 Simulating Operations Management Processes	p. 279
13.1 The Network-Flow Production Process	p. 280
13.2 The Matchstick Shuffling System	p. 280
13.3 The Copy Machine Problem	p. 288
13.4 Why Projects Are Late	p. 297
13.5 The Single Station System	p. 300
13.6 Concluding Comments	p. 304
Exercises	p. 304
14 Resource Allocation: Applied Constraint Management	p. 307
14.1 Making Mathematical Programming Relevant for Operations Management	p. 307
14.2 A Production Planning Support System	p. 308
14.3 A Transportation Problem	p. 317
14.4 Concluding Comments	p. 321
Exercises	p. 321
Appendix A Using Excel	p. 323
Appendix B The Models	p. 355
For Further Reading	p. 367
Index	p. 368

Available:*

On Order

Summary

Summary

Table of Contents