Spreadsheet Modeling and Applications Essentials of Practical Management Science (with CD-ROM and InfoTrac),9780534380328

Spreadsheet Modeling and Applications Essentials of Practical Management Science (with CD-ROM and InfoTrac)

by ;
Edition: 1st
ISBN13: 9780534380328
ISBN10: 0534380328
Format: Hardcover
Pub. Date: 2004-04-21
Publisher(s): South-Western College Pub
Upgraded Edition: Click here!
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $183.75

Buy New

Arriving Soon. Will ship when available.
$175.00
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $15.04

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Knowing spreadsheets can save your job? Absolutely. SPREADSHEET MODELING AND APPLICATIONS: ESSENTIALS OF PRACTICAL MANAGEMENT SCIENCE shows you how with just a little spreadsheet magic you can solve real life business problems. It's relevant, it's simple and it comes with DecisionTools? Suite. With DecisionTools? Suite you'll get the spreadsheet add-ins to make homework a snap.

Table of Contents

Introduction to spreadsheet modeling
Introduction to Modeling
Introduction
A Waiting Line Example
Modeling Versus Models
The Seven-Step Modeling Process
A Successful Management Science Application
Why Study Management Science? Software Included in This Book
Conclusion
Introductory Spreadsheet Modeling
Introduction
Basic Spreadsheet Modeling: Concepts and Best Practices
Cost Projections
Breakeven Analysis
Ordering with Quantity Discounts and Demand Uncertainty
Decisions Involving the Time Value of Money
Conclusion
Appendix: Tips for Editing and Documenting Spreadsheets
Decision making under certainty
Introduction to Optimization Modeling
Introduction
Introduction to Optimization
A Two-Variable Model
Sensitivity Analysis
Properties of Linear Models
Infeasibility and Unboundedness
A Product Mix Model
A Multiperiod Production Model
A Comparison of Algebraic and Spreadsheet Models
A Decision Support System
Conclusion
Appendix: Information on Solvers
Linear Programming Models
Introduction
Advertising Models
Static Workforce Scheduling Models
Aggregate Planning Models
Blending Models
Production Process Models
Financial Models
Conclusion
Network Models
Introduction
Transportation Models
Assignment Models
Minimum Cost Network Flow Models
Shortest Path Models
Project Scheduling Models
Conclusion
Linear Optimization Models with Integer Variables
Introduction
Overview of Optimization with Integer Variables
Capital Budgeting Models
Fixed-Cost Models
Set Covering Models and Location/Assignment Models
Conclusion
Nonlinear Optimization Models
Introduction
Basic Ideas of Nonlinear Optimization
Pricing Models
Advertising Response and Selection Models
Facility Location Models
Models for Rating Sports Teams
Portfolio Optimization Models
Conclusion
Decision making under uncertainty
Decision Making Under Uncertainty
Introduction
Elements of a Decision Analysis
The PrecisionTree Add-In
Bayes? Rule
Multistage Decision Problems
Incorporating Attitudes Toward Risk
Conclusion
Introduction to Simulation Modeling
Introduction
Real Applications of Simulation
Probability Distributions for Input Variables
Simulation with Built-In Excel Tools
Introduction to @RISK
The Effect of Input Distributions on Results
Conclusion
Simulation Models
Introduction
Operations Models
Financial Models
Marketing Models
Simulating Games of Chance
Conclusion
Queuing Models
Introduction
Elements of Queuing Models
The Exponential Distribution
Important Queueing
Relationships
Analytical Queuing Models
Queuing Simulation Models
Conclusion
Regression and Forecasting Models
Introduction
Overview of Regression Models
Simple Regression Models
Multiple Regression Models
Overview of Time Series Models
Moving Averages Models
Exponential Smoothing Models
Conclusion
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.