书籍详情
运筹管理分析：使用Excel 英文版
作者：（美）南希·C.维达（Nancy C.Weida）等著
出版社：机械工业出版社
出版时间：2004-05-01
ISBN：9787111143208
定价：¥36.00
购买这本书可以去
内容简介
运筹管理研究的是商品生产和服务中的变化过程。本书讲授的是如何用Excel分析管理中的问题，使决策者能更好更容易地作出决定。当今的竞争和风云变幻的全球市场使掌握相关的定量的建模方法成为当务之急，所以管理者应当掌握更新更强大的管理工具。用Excel建构模型，可以解决学习运筹管理时最令人头痛的计算繁琐问题。然而本书又强调了决策的做出需要仔细地思考和构思，避免了只能用Excel作简单计算的错觉。市场上有很多优秀的运筹管理教材，也有很多Excel的使用手册，但没有一本书能将其二者有机地结合。 Excel能更好地帮助分析如何解决问题，且本书中的很多方法在传统的运筹管理教材中还未包括。本书不仅讲授了简化分析业务管理的问题，还更深层次地探究了它的细节。本书主要集中于构造和解决运筹管理问题，但是这些方法也可以应用到其他决策中去。本书尽量像实际生活中一样多角度地考虑问题，而不是如一般运筹管理教材一样简单地从一个角度出发。三位作者各有特长，优势互补，或者荣获过很多教学奖项，或者写过多本畅销教材。他们的研究领域也各有侧重，有的有从事运筹和经济管理的多年教学经验，有的擅长写计算机导向的贸易教材，有的有较深的数学和统计学功底。本书适合作为经济管理专业的本科生、研究生的教材或参考书，也可作为MBA及短期MBA课程教材。
作者简介
暂缺《运筹管理分析：使用Excel 英文版》作者简介
目录
1 Creative Operations Management Problem Solving:
A Decision-Making Approach
1
1.1 Managerial Decision Making
1
1.2 The Intelligence Phase of the Decision-Making Process
4
1.3 The Design Phase of the Decision-Making Process
10
1.4 The Choice Phase of the Decision-Making Process
14
1.5 An Example: Jackets versus Scrap at the UNEEDA Corporation
16
1.6 Concluding Comments
25
EXERCISES
25
2 Forecasting
27
2.1 Forecasting at the LastEver Corporation
28
2.2 Patterns of Data
33
2.3 Forecasting Approaches
42
2.4 Time Series Analysis
44
2.5 Concluding Comments
56
EXERCISES
56
3 Advanced Forecasting
59
3.1 Extrapolation from the Past
59
3.2 Regression Analysis
63
3.3 Cyclical and Seasonal Issues
71
3.4 Concluding Comments
81
EXERCISES
81
4 Planning Models
85
4.1 The Basic Planning Problem
85
4.2 The Basic Pricing Problem
87
4.3 Nonlinear Cost and Demand Functions
91
4.4 Preparing a Five-Year Plan
96
4.5 The Impact of Pricing
97
4.6 Concluding Comments
99
EXERCISES
100
5 Aggregate Planning and Learning Curves
103
5.1 The Nature of Aggregate Planning
103
5.2 Tradeoffs between Production and Inventory
103
5.3 Learning Curves
110
5.4 Concluding Comments
112
EXERCISES
113
6 Inventory
117
6.1 Why Hold Inventory
117
6.2 The Cost of Inventory
118
6.3 Cyclic Inventory Control
119
6.4 The Economic Order Quantity Model
123
6.5 What-If Scenarios
126
6.6 EOQ Model with Price Breaks
130
6.7 Economic Production Lot Size Model
132
6.8 Singlc-Period Models with Probabilistic Demand
136
6.9 Multi-Period Models with Probabilistic Demand
144
6.10 Concluding Comments
149
EXERCISES
150
7 Material Requirements Planning
153
7.1 Where MRP Fits In
153
7.2 Master Production Schedule
155
7.3 Bill of Materials
158
7.4 A Simple MRP Example
162
7.5 Rolling the MRP Schedule
163
7.6 Adding Allocated Inventory and Safety Stock
165
7.7 A More Complex MRP Example
166
7.8 Dealing with Multiple Products
168
7.9 Problems at Central Products Incorporated
171
7.10 Concluding Comments
176
EXERCISES
177
8 Quality: Monitoring Processes Using Charts
181
8.1 Monitoring Processes by Charts: Looking at the Data
181
8.2 Mean Charts
183
8.3 The Run Chart
186
8.4 The R Range Chart
186
8.5 Standard Deviation Charts
189
8.6 Using These Charts
189
8.7 Control Charts for Attribute Data
191
8.8 Other Quality Control Charts
194
8.9 Concluding Comments
197
EXERCISES
197
9 Machine Replacement and Maintenance
199
9.1 Machine Replacement Decisions
199
9.2 Machine Maintenance Decisions
206
9.3 Group Maintenance Decisions
211
9.4 Concluding Comments
214
EXERCISES
214
10 Project Management
217
10.1 The Project
217
I0.2 The Professor
219
10.3 Network Diagrams
219
10.4 Probabilities
224
10.5 Crunching
229
10.6 Concluding Comments
234
EXERCISES
235
11 Facility Location Decisions
237
11.1 Factor Weighting
237
11.2 Center-of-Gravity Method
240
11.3 Cost-Volume Analysis
242
11.4 Concluding Comments
244
EXERCISES
245
12 Risk Analysis and Simulation
247
12.1 Problems Where Uncertainty Is Important
247
12.2 Working the Cough Drop Problem
252
12.3 Generating Random Numbers
259
12.4 Break-Even Analysis under Uncertainty: A Case Study
269
12.5 The Farmer''s Problem: Dependent Random Variables
274
12.6 Concluding Comments
277
EXERCISES
277
13 Simulating Operations Management Processes
279
I3.1 The Network-Flow Production Process
280
13.2 The Matchstick Shuffling System
280
13.3 The Copy Machine Problem
288
13.4 Why Projects Are Late 297
13.5 The Single Station System
300
13.6 Concluding Comments
304
EXERCISES
304
14 Resource Allocation:
Applied Constraint Management
307
14.1 Making Mathematical Programming Relevant
for Operations Management
307
14.2 A Production Planning Support System
308
14.3 A Transportation Problem
317
14.4 Concluding Comments
321
EXERCISES
321
AppendixA Using Excel 323
Appendix B The Models 355
For Further Reading 367
Index 368
A Decision-Making Approach
1
1.1 Managerial Decision Making
1
1.2 The Intelligence Phase of the Decision-Making Process
4
1.3 The Design Phase of the Decision-Making Process
10
1.4 The Choice Phase of the Decision-Making Process
14
1.5 An Example: Jackets versus Scrap at the UNEEDA Corporation
16
1.6 Concluding Comments
25
EXERCISES
25
2 Forecasting
27
2.1 Forecasting at the LastEver Corporation
28
2.2 Patterns of Data
33
2.3 Forecasting Approaches
42
2.4 Time Series Analysis
44
2.5 Concluding Comments
56
EXERCISES
56
3 Advanced Forecasting
59
3.1 Extrapolation from the Past
59
3.2 Regression Analysis
63
3.3 Cyclical and Seasonal Issues
71
3.4 Concluding Comments
81
EXERCISES
81
4 Planning Models
85
4.1 The Basic Planning Problem
85
4.2 The Basic Pricing Problem
87
4.3 Nonlinear Cost and Demand Functions
91
4.4 Preparing a Five-Year Plan
96
4.5 The Impact of Pricing
97
4.6 Concluding Comments
99
EXERCISES
100
5 Aggregate Planning and Learning Curves
103
5.1 The Nature of Aggregate Planning
103
5.2 Tradeoffs between Production and Inventory
103
5.3 Learning Curves
110
5.4 Concluding Comments
112
EXERCISES
113
6 Inventory
117
6.1 Why Hold Inventory
117
6.2 The Cost of Inventory
118
6.3 Cyclic Inventory Control
119
6.4 The Economic Order Quantity Model
123
6.5 What-If Scenarios
126
6.6 EOQ Model with Price Breaks
130
6.7 Economic Production Lot Size Model
132
6.8 Singlc-Period Models with Probabilistic Demand
136
6.9 Multi-Period Models with Probabilistic Demand
144
6.10 Concluding Comments
149
EXERCISES
150
7 Material Requirements Planning
153
7.1 Where MRP Fits In
153
7.2 Master Production Schedule
155
7.3 Bill of Materials
158
7.4 A Simple MRP Example
162
7.5 Rolling the MRP Schedule
163
7.6 Adding Allocated Inventory and Safety Stock
165
7.7 A More Complex MRP Example
166
7.8 Dealing with Multiple Products
168
7.9 Problems at Central Products Incorporated
171
7.10 Concluding Comments
176
EXERCISES
177
8 Quality: Monitoring Processes Using Charts
181
8.1 Monitoring Processes by Charts: Looking at the Data
181
8.2 Mean Charts
183
8.3 The Run Chart
186
8.4 The R Range Chart
186
8.5 Standard Deviation Charts
189
8.6 Using These Charts
189
8.7 Control Charts for Attribute Data
191
8.8 Other Quality Control Charts
194
8.9 Concluding Comments
197
EXERCISES
197
9 Machine Replacement and Maintenance
199
9.1 Machine Replacement Decisions
199
9.2 Machine Maintenance Decisions
206
9.3 Group Maintenance Decisions
211
9.4 Concluding Comments
214
EXERCISES
214
10 Project Management
217
10.1 The Project
217
I0.2 The Professor
219
10.3 Network Diagrams
219
10.4 Probabilities
224
10.5 Crunching
229
10.6 Concluding Comments
234
EXERCISES
235
11 Facility Location Decisions
237
11.1 Factor Weighting
237
11.2 Center-of-Gravity Method
240
11.3 Cost-Volume Analysis
242
11.4 Concluding Comments
244
EXERCISES
245
12 Risk Analysis and Simulation
247
12.1 Problems Where Uncertainty Is Important
247
12.2 Working the Cough Drop Problem
252
12.3 Generating Random Numbers
259
12.4 Break-Even Analysis under Uncertainty: A Case Study
269
12.5 The Farmer''s Problem: Dependent Random Variables
274
12.6 Concluding Comments
277
EXERCISES
277
13 Simulating Operations Management Processes
279
I3.1 The Network-Flow Production Process
280
13.2 The Matchstick Shuffling System
280
13.3 The Copy Machine Problem
288
13.4 Why Projects Are Late 297
13.5 The Single Station System
300
13.6 Concluding Comments
304
EXERCISES
304
14 Resource Allocation:
Applied Constraint Management
307
14.1 Making Mathematical Programming Relevant
for Operations Management
307
14.2 A Production Planning Support System
308
14.3 A Transportation Problem
317
14.4 Concluding Comments
321
EXERCISES
321
AppendixA Using Excel 323
Appendix B The Models 355
For Further Reading 367
Index 368
猜您喜欢
