1 / 28

Teaching Management Science in 2011

What's New in Spreadsheet Modeling and Decision Analysis 6e and Risk Solver Platform softwareNew Versions of Familiar Examples from SMDA 6eSolver ? Premium Solver ? Risk Solver PlatformImpact of Windows 7, Excel 2010, Solver, 64-bitsRSP Student Licenses, IT/Faculty/Student SupportYour Questions

julie
Download Presentation

Teaching Management Science in 2011

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Teaching Management Science in 2011 Using Spreadsheet Modeling and Decision Analysis 6th Ed. and Risk Solver Platform for Education Software Cliff Ragsdale, Virginia Tech Daniel Fylstra, Frontline Systems Inc.

    2. What’s New in Spreadsheet Modeling and Decision Analysis 6e and Risk Solver Platform software New Versions of Familiar Examples from SMDA 6e Solver ? Premium Solver ? Risk Solver Platform Impact of Windows 7, Excel 2010, Solver, 64-bits RSP Student Licenses, IT/Faculty/Student Support Your Questions on Any Part of This What We’ll Cover

    3. Change is Never Easy, but it’s Needed Now Because of PC/Software Changes in 2010 Frontline Systems and Ragsdale / Cengage Have Teamed Up to Provide a Better Solution New RSPE – One Software Package – Replaces Premium Solver, Crystal Ball, TreePlan, DA Add-in to Simplify Teaching Spreadsheet Modeling and Decision Analysis 6e Uses RSPE Software Throughout Main Take-Away Messages

    4. Available now from Cengage Printed / bound textbook, Instructor’s edition Resource CD: PowerPoints, exercises, Test Bank For a review copy, please: Contact your Cengage rep (www.cengage.com/findrep.html) Email esales@cengage.com How to Get the Textbook

    6. Available now at www.solver.com/student Fill out the form to download the software Use RSMDA6 for the Textbook Code Use faculty for the Course Code Run RSPSetup.exe to install the software Use bestwaytoteach as the Password Use 1702-0362-5214-4584 as the Activation Code (this will be emailed to you) For a permanent RSPE license, please email Marc Kellison at marc@solver.com or call him at (775) 831-0300 x4 How to Get the Software

    7. Designed to Simplify Life for OR/MS Teachers, Save Classroom Time With a Single, Supported Software Package: Teach Linear/Integer, Nonlinear Optimization Teach Simulation/Risk Analysis at Any Level Teach Sensitivity Analysis, Decision Analysis Teach Stochastic Optimization Far More Easily Spreadsheet Modeling and Decision Analysis 6e Uses This Software Throughout Risk Solver Platform for Education www.solver.com/rspe

    8. Risk Solver Platform Optimization

    9. Works with any recent Excel version Accepts Models created in any Excel version Runs Solver VBA Macros created in any version Emulates both old and new (2010) Excel Solver dialog-based interface New Ribbon-based interface and old dialog-based interface, synchronized at all times Offers much greater optimization power than Solver or Premium Solver Risk Solver Platform for Education www.solver.com/rspe

    10. Solver Subsets / Supersets

    11. Ch 1-2: Introduction to Modeling & Optimization Ch 3-4: Linear Programming & Sensitivity Analysis: LP/Quadratic Solver, Sensitivity Tools Ch 5-7: Networks, Integer Programming, & Multi-Objective Optimization: LP/Quadratic Solver Ch 8: Nonlinear & Evolutionary Optimization: GRG Nonlinear Solver, Evolutionary Optimizer RSPE in SMDA 6e

    12. Ch 9-11: Regression Analysis, Discriminant Analysis, & Time Series Analysis LP/Quadratic Solver, Discriminant Analysis Tool Ch 12: Simulation Risk Solver & Simulation Optimization Ch 13: Queuing Theory: LP/Quadratic Solver Ch 14: Project Management: LP/Quadratic Solver, Risk Solver Ch 15: Decision Analysis: Decision Tree, Sensitivity Tools RSPE in SMDA 6e

    13. Risk Solver Platform Simulation

    14. Select Distributions from Dropdown Gallery Adjust Parameters, Shifting, Truncation Display PDF, CDF, Statistics, Percentiles Fit Distribution to User-Supplied Data Rank-Order Correlation of Distributions RSPE Monte Carlo Simulation

    15. Select as Output or Reference in Statistic Display Frequency, Sensitivity/Tornado Charts, Scatter Plots, Statistics, Percentiles Fit Distribution to Simulation Results Reports / Charts for Multiple, Parameterized Simulations RSPE Monte Carlo Simulation

    16. Windows 7 and Office 2010 are Mainstream (32-bit and 64-bit) Excel 2010 Solver has New Capabilities and Changes in its User Interface Add-Ins Designed for 32-bit Excel Won’t Work in 64-bit Excel 2010 Need and Opportunity for Change PC/Software Changes and RSPE

    17. Designed to Simplify Life for OR/MS Teachers, Save Classroom Time One Supported Software Package Covers All Main Management Science Methods One User Interface for Optimization, Simulation, Etc. Simplify the Transition to Excel 2010, New Solver, 64 Bits Runs on Excel 2003/2007/2010, 32/64 Bits Emulates old and new Solver as Transition Aid Risk Solver Platform for Education www.solver.com/rspe

    18. Using RSPE with SMDA 6e: New Versions of Familiar Models

    19. Focus on Models and Decisions – not just discrete topics of optimization and simulation Show students how to use sensitivity analysis, simulation, optimization together Show the unity of the methods: simulation + linear programming for stochastic optimization Risk Solver Platform for Education www.solver.com/rspe

    20. RSPE Decision Trees

    21. RSPE Sensitivity Analysis

    22. RSPE Discriminant Analysis

    23. More powerful optimization, automatic model diagnosis – from Premium Solver Platform Full-featured risk analysis and Monte Carlo simulation – from Risk Solver Solve stochastic optimization models with uncertainty and recourse decisions Sensitivity analysis and decision tree features Gurobi Solver – Ultra-Fast LP/MIP Solver Risk Solver Platform for Education www.solver.com/rspe

    24. Free permanent evaluation licenses for Instructors Free semester-length licenses for Students using Ragsdale 6th Edition $50 permanent licenses for Students and Student Lab machines – minimum 10, cheaper for 100+ Full features of $4,000 commercial product, but: 200 Decision Variables, 100 Nonlinear Constraints 100 Uncertain Variables, 50 Uncertain Functions 10 Simulations, 10,000 Monte Carlo Trials / Simulation These Limits are Adjustable in the License Code Background ‘Watermarks’ on all Charts Gurobi Solver is the Only Plug-in Solver Engine Risk Solver Platform Licensing www.solver.com/rspe

    25. Priority technical support for University IT: Licensing for lab machines, networks, imaged PCs Contact Duane Lincoln at duane@solver.com Priority technical support for Instructors Installation technical support for Students A strategic priority for Frontline Systems Risk Solver Platform Support www.solver.com/rspe

    26. Available now at www.solver.com/student Fill out the form to download the software Use RSMDA6 for the Textbook Code Use faculty for the Course Code Run RSPSetup.exe to install the software Use bestwaytoteach as the Password Use 1702-0362-5214-4584 as the Activation Code (this will be emailed to you) For a permanent RSPE license, please email Marc Kellison at marc@solver.com or call him at (775) 831-0300 x4 How to Get the Software

    27. Available now from Cengage Printed / bound textbook, Instructor’s edition Resource CD: PowerPoints, exercises, Test Bank For a review copy, please: Contact your Cengage rep (www.cengage.com/findrep.html) Email esales@cengage.com How to Get the Textbook

    28. Frontline Systems, Inc. Incline Village, Nevada, US Email info@solver.com Web www.solver.com Toll-Free (888) 831-0333 Tel (775) 831-0300 Fax (775) 831-0314 Risk Solver Platform Contact Us for More Information

More Related