Developing Spreadsheet-Based Decision Support Systems

Michelle M.H. Seref; Ravindra A. Ahuja; Wayne L. Winston

ISBN 10: 0975914650 / ISBN 13: 9780975914656

Verlag: Dynamic Ideas, 2007

Fast Shipping - Good and clean conditions used book. Pages and cover are intact. Limited notes marks and highlighting may be present. May show signs of normal shelf wear and bends on edges. Item may be missing CDs or access codes. May include library marks. Bestandsnummer des Verkäufers ZWM.IUM6

Inhaltsangabe:

A decision support system is an intelligent information system that uses data, models it, processes or analyzes it using problem-specific methodologies, and assists the user in the decision-making process through a graphical user interface.

Developing Spreadsheet-Based Decision Support Systems is a comprehensive book that describes how to build decision support systems using the Excel spreadsheet framework and the VBA programming language. This book illustrates complete decision support development applications through several case studies arising in Operations Research, Industrial Engineering, Management, and Business Administration. The main contribution of the book is to present all the techniques needed to build complete Excel-based decision support systems in a highly accessible manner through numerous hands-on examples and case studies. This book is ideally suited as a textbook for teaching undergraduate- and graduate-level courses in any branch of science, engineering, and management and can also be used as a supplementary reference book or a self-study manual. The book contains three parts:

Part I - Excel Essentials:This part presents an overview of Excel basic and extended functionalities. The basic functionality topics include referencing and names, functions and formulas, charts, and pivot tables. The extended functionality topics include statistical analysis, the Solver and modeling, simulation, and working with large datasets.

Part II - VBA for Excel: This part presents an overview of programming in VBA and manipulating Excel objects. Covered topics include macros, programming structures, building user interfaces, and using VBA for optimization and simulation.

Part III - Case Studies: This part presents several case studies of decision support systems arising in different application settings. These case studies include inventory management, retirement planning, reliability analysis, warehouse layout, facility location, forecasting, and portfolio management.

Über die Autorin bzw. den Autor: Michelle M.H. Şeref is a researcher at the Warrington College of Business at the University of Florida, Gainesville. Her research focus is in the area of Operations Management with special interests in operations/marketing interface and new product development.

Ravindra K. Ahuja is a Professor in the Industrial and Systems Engineering at the University of Florida, Gainesville. He is also the President of Innovative Scheduling, Inc., which specializes in building decision support systems for planning and scheduling problems arising in the field of transportation.

Wayne L. Winston is a Professor in the Kelly School of Business at Indiana University, Bloomington. He has written several widely-used textbooks on spreadsheet modeling, financial models, and operations research.

Bibliografische Details

Titel: Developing Spreadsheet-Based Decision ...
Verlag: Dynamic Ideas
Erscheinungsdatum: 2007
Einband: Hardcover
Zustand: good