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

Hardcover (Print)
Rent
Rent from BN.com
$57.09
(Save 83%)
Est. Return Date: 10/27/2014
Buy Used
Buy Used from BN.com
$216.68
(Save 37%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $33.40
Usually ships in 1-2 business days
(Save 90%)
Other sellers (Hardcover)
  • All (17) from $33.40   
  • New (3) from $254.78   
  • Used (14) from $33.40   

Overview

Chris Albright and Wayne Winston have brought their hallmark teach-by-example approach to the undergraduate spreadsheet modeling course. Renowned for their other successful texts in operations research/management science, Winston and Albright successfully show how spreadsheets are used in real life to model and analyze real business problems. By modeling problems using spreadsheets from the outset, SPREADSHEET MODELING AND APPLICATIONS prepares future managers for the types of problems they will encounter on the job. Real cases throughout the text further cement this book's status as the most relevant of its kind on the market. This text is also accompanied by Palisade Corporation's professional spreadsheet add-ins, DecisionTools Suite.

Read More Show Less

Editorial Reviews

From the Publisher
"I like the real-world examples interlaced in the problems and prose. In particular, it is refreshing that the authors admit that the mathematical models take into account several assumptions in order to establish a frame of reference or starting point in solving them."

"The level of difficulty of the examples is varied, so that some examples are quite readily absorbed, whereas others require deeper study. The examples are nicely designed to lead into the exercise sets that follow them."

"The level of difficulty of the examples is varied, so that some examples are quite readily absorbed, whereas others require deeper study. The examples are nicely designed to lead into the exercise sets that follow them."

"In fact, the exercises are graded (not formally) in their level of difficulty, and there are plenty of them, giving the instructor plenty of room to assign a subset of the exercises that the instructor deems to be appropriate for the backgrounds and skill levels of the students studying from the book."

Read More Show Less

Product Details

  • ISBN-13: 9780534380328
  • Publisher: Cengage Learning
  • Publication date: 4/21/2004
  • Edition description: Book & CD-ROM, with Software Package
  • Edition number: 1
  • Pages: 688
  • Sales rank: 1,310,688
  • Product dimensions: 7.92 (w) x 10.18 (h) x 1.88 (d)

Meet the Author

S. Christian Albright received his B.S. degree in mathematics from Stanford in 1968 and his Ph.D. in operations research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. His current interest is in spreadsheet modeling, including development of VBA applications in Excel. Dr. Albright has published more than 20 articles in leading operations research journals in the area of applied probability as well as a number of successful textbooks, including DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, and SPREADSHEET MODELING AND APPLICATIONS.

Wayne L. Winston is Professor of Operations and Decision Technologies in the Kelley School of Business at Indiana University, where he has taught since 1975. Wayne received his B.S. degree in Mathematics from MIT and his Ph.D. degree in Operations Research from Yale. He has written the successful textbooks OPERATIONS RESEARCH: APPLICATIONS AND ALGORITHMS, MATHEMATICAL PROGRAMMING: APPLICATIONS AND ALGORITHMS, SIMULATION MODELING WITH @RISK, PRATICAL MANAGEMENT SCIENCE, DATA ANALYSIS FOR MANAGERS, SPREADSHEET MODELING AND APPLICATIONS, AND FINANCIAL MODELS USING SIMULATION AND OPTIMIZATION. Wayne has published over 20 articles in leading journals and has won many teaching awards, including the school-wide MBA award four times. His current interest is in showing how spreadsheet models can be used to solve business problems in all disciplines, particularly in finance and marketing.

Read More Show Less

Table of Contents

Part I: INTRODUCTION TO SPREADSHEET MODELING. 1. 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. 2. 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. Part II: DECISION MAKING UNDER CERTAINTY. 3. 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. 4. Linear Programming Models. Introduction. Advertising Models. Static Workforce Scheduling Models. Aggregate Planning Models. Blending Models. Production Process Models. Financial Models. Conclusion. 5. Network Models. Introduction. Transportation Models. Assignment Models. Minimum Cost Network Flow Models. Shortest Path Models. Project Scheduling Models. Conclusion. 6. 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. 7. 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. Part III: DECISION MAKING UNDER UNCERTAINTY. 8. Decision Making Under Uncertainty. Introduction. Elements of a Decision Analysis. The PrecisionTree Add-In. Bayes Rule. Multistage Decision Problems. Incorporating Attitudes Toward Risk. Conclusion. 9. 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. 10. Simulation Models. Introduction. Operations Models. Financial Models. Marketing Models. Simulating Games of Chance. Conclusion. 11. Queuing Models. Introduction. Elements of Queuing Models. The Exponential Distribution. Important Queueing. Relationships. Analytical Queuing Models. Queuing Simulation Models. Conclusion. 12. 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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)