Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Management Science, Revised (with Interactive Video Skillbuilder CD-ROM, Microsoft Project 2007, Crystal Ball Pro Printed Access Card)
/ Edition 5
Cliff Ragsdale is an innovator of the spreadsheet teaching revolution and is highly regarded in the field of management science. The revised fifth edition of SPREADSHEET MODELING AND DECISION ANALYSIS retains the elements and philosophy that has made its past editions so successful. New topics have been added as well as examples that are relevant to decision making in today's business world. This version of SPREADSHEET MODELING AND DECISION ANALYSIS has been updated for use with Microsoft Office Excel 2007. It provides succinct instruction in the most commonly used management science techniques and shows how these tools can be implemented using the most current version of Excel for Windows. This text also focuses on developing both algebraic and spreadsheet modeling skills.
Cliff Ragsdale is the Bank of America Professor, Department of Business Information Technology in the Pamplin College of Business at Virginia Tech, where he has taught since 1990. He received his Ph.D. in Management Science and Information Technology from the University of Georgia. He also holds an M.B.A. in Finance and B.A. in Psychology from the University of Central Florida. Before pursuing his Ph.D., he was supervisor of Benefit Finance & Qualified Plans at the international headquarters of Red Lobster, Inc. He is a member consultant for Compass Modeling, Inc., and has served as an information systems and statistical consultant for the General Mills Restaurant Group and the accounting firm of Deloitte & Touche. Dr. Ragsdale's primary areas of research interest include microcomputer systems and applications, artificial intelligence, mathematical programming, and applied statistics. His research has appeared in DECISION SCIENCES, NAVAL RESEARCH LOGISTICS, OMEGA: THE INTERNATIONAL JOURNAL OF MANAGEMENT SCIENCE, COMPUTERS & OPERATIONS RESEARCH, OPERATIONS RESEARCH LETTERS, PERSONAL FINANCIAL PLANNING, and other publications. He has also received the Pamplin award for excellence in teaching from the Pamplin College of Business Administration at Virginia Tech. Dr. Ragsdale is an active member of DSI and INFORMS. He was proceedings coordinator for the 1995 National DSI Meeting and has served as vice president for Member Services and vice president of Publications for Southeast DSI. He has also served on the board of directors for the Southwest Virginia Chapter of APICS and as the faculty adviser for the student chapter of APICS at Virginia Tech.
1. Introduction to Modeling and Decision Analysis. 2. Introduction to Optimization and Linear Programming. 3. Modeling and Solving LP Problems in a Spreadsheet. 4. Sensitivity Analysis and the Simplex Method. 5. Network Modeling. 6. Integer Linear Programming. 7. Goal Programming and Multiple Objective Optimization. 8. Nonlinear Programming & Evolutionary Optimization. 9. Regression Analysis. 10. Discriminant Analysis. 11. Time Series Forecasting. 12. Introduction to Simulation using Crystal Ball. 13. Queuing Theory. 14. Project Management. 15. Decision Analysis.