question found on page 44 (attached) American Auto is evaluating....

There is a analytic program that take a minute to download, and its free. instructions attached.

MBA604 Course Syllabus MBA604 Management methods for business decision-making Software MS Excel This course heavily relies on two commercial software products. The first 10 weeks and the final exam of the course are based on decision models and algorithms that are included in MS Excel and the Analytic Solver Platform add-in for Excel. A semester-long license for this add-in is provided with this course. The add-in runs on all MS Excel versions, however, it is highly recommended to have at least Excel 2010. Mac users would first have to install \"dual-boot\" or VM software (i.e. partition the machine to be a Mac or a Windows machine) and then MS Windows and MS Excel. You cannot use MAC Excel for this course. The honest recommendation for Mac users: try to find a Windows computer for this semester. Alternatively, you will also have the option to access a Virtual Computer Lab (VCL) at Marist; however, access time to the lab may be limited depending on course enrollment. The VCL provides you with access to windows computers that have Excel installed, together with RiskSolver, the older version of the Analytic Solver Platform add-in. Except for the name, RiskSolver is identical in the functionalities. MS Access If you have MS Access, please check the version. We will be using the 2013 version. If you do not have MS Access, you will access this software through the Virtual Computer Lab (VCL) at Marist. Instructions for Manzo Book and Analytic Solver Platform add-in 1) Instructions to access Mazon book This book is an online book that you can purchase on your own (not via the bookstore). If you prefer to have a hardcopy, you will to spend some more money. However, as I did not want to burden students' budgets even more, as we are already using three different books, it is perfectly fine to use the online version. Please follow this link. If you are already an experienced Excel user, the study version will suffice, otherwise I recommend the digital all access pass. Again, if you prefer to hold a book in your hand, you can also choose the hardcopy. https://students.flatworldknowledge.com/course/2438877 2) Installation of Analytic Solver add-in You should only do this if you have at least 15-30 min time. It may not take that long, but you do not want to get interrupted or distracted in-between. Preparation You MUST follow these instructions by the word, step by step. Not doing so will most likely lead to unnecessary troubles and frustrations. Do not attempt to download the software without the book and course code - you will only get a 15 day trial license and will have to go through all sorts of time-consuming trouble to change that to the course license. Read the following VERY carefully. 1. If you have a Mac, visit and read www.solver.com/using-frontline-solvers-macintosh. To use the software for this course, you'll need to install Windows alongside Mac OSX, and install Excel or Office 1 Internal MBA604 for Windows. This will also allow you to use other Windows software, as well as Mac software on your machine. 2. Check whether you have 32-bit or 64-bit Excel - this determines which software version you should download. You probably have 32-bit Excel. You have 64-bit ONLY if (i) in Excel 2010, you click File - Help, and you see 64-bit in the lower right, or (ii) in Excel 2013, you click File - Account - About Excel, and you see 64-bit at the top of the dialog. Registration 1. Point your browser to http://www.solver.com/welcome-students. (Do not attempt to register or download anywhere else on Solver.com - this will cause trouble later.) 2. Fill out the form on this page. Enter your email address (to ensure you receive your license activation code), enter a login password you can remember, enter your first and last name, and Marist College for your school. 3. Enter RSMDA7 for the Textbook Code and MBA604F15 for the Course Code. These are special for our course - entering these will give you a 140-day license. (Leaving them blank will give you a 15-day license.) 4. Check the box to acknowledge that you accept the Frontline Systems license agreement. Note: Frontline receives no money from you, or the textbook publisher, or the university; this free 140-day license is a courtesy that they offer to students. 5. Click the button Proceed to Download Page. If everything is OK, this will take you to the Download page. Download 1. On the Download page, change 32-bit to 64-bit ONLY if you've confirmed that you have 64-bit Excel (see above). Click the blue Download Now button. 2. In some browsers you will see a dialog "Do you want to run or save this file?" Click Save to save the file, named either SolverSetup.exe or SolverSetup64.exe. 3. Now check your email, at the email address you entered above, for a message containing an installation password and a license activation code. Frontline sends this email twice, from different servers, to ensure that you receive it. If you don't get it, visit www.solver.com/installation-password-request and login to request another email message. Installation 1. Make sure that Excel is closed (not running), then run the program SolverSetup.exe (or SolverSetup64.exe). SolverSetup will prompt you to enter the password and activation code from the email message above - enter them exactly as shown in the email (you can copy and paste). 2. The SolverSetup program will prompt you to choose between Analytic Solver Platform, Risk Solver Platform and XLMiner. Choosing Analytic Solver Platform gives you all the features of Risk Solver 2 Internal MBA604 Platform and XLMiner, so this is usually the best choice. You can CHANGE this choice later in Excel, by choosing a menu option Help - Change Product on the Ribbon. 3. When the SolverSetup program finishes, start Excel (the last Setup dialog prompts you to do this). You should see new tabs on the Ribbon for Analytic Solver Platform or Risk Solver Platform, and XLMiner. Click the Solver Platform tab - you should see a \"Welcome\" dialog with various links. Use the Help dropdown menu to open Help text, the User Guide and Reference Guide, and load example workbooks. If all has gone well, you're ready for our class exercises. If you have problems, the best avenues to get help are to email support@solver.com (this creates a support ticket in Frontline's Help Desk) or start a Live Chat from any page on www.solver.com, or from within Excel (Help - Support Live Chat). 3 Internal MBA604 Course Schedule Wee Topics k 1 Introduction to Excel Part I 2 Introduction to Linear Programming and Optimization 4 Advanced topics in Linear programming. 5 6 Advanced topics in mathematical programming: integer and non-linear programming Introduction to Decision Analysis 7 Advanced Decision Analysis 8 Stochastic Simulation 9 Stochastic Simulation 10 G Ch Introduction to Office (as needed) ; M Ch 1-2 Decision Making Experiment, due 9/6 M Ch 3, Lecture Notes & Articles R Ch 1 Discussion: Heuristics and Cognitive Biases Form Homework Teams Excel Skill Test, due 9/13 R Ch 2, R Ch 3 (3.1 - 3.8) Lecture Notes Assignments, due 9/20 R Ch 3 (3.9 -3.15) R Ch 4 (4.0 - 4.5) Lecture Notes; Assignments, due 9/27 R Ch 6.0- 6.9, R Ch 8.0-8.5 Lecture Notes; Assignments, due 10/04 Introduction to Excel Part II Introduction to Decision Sciences and Decision Support Systems 3 Required Readings and Assignments Forecasting - moving averages, weighted moving average, exponential smoothing, linear regression Data Management: Relational DBMS, database queries and connectivity. (Access) Continuation: Data Management 11 12 13 Business Intelligence: Data warehousing, business reporting 14 Business Performance Management 15 R Ch 14.0-14.11 Lecture Notes; Assignments, due 10/11 R Ch 14.13-14.19 Lecture Notes; Assignments, due 10/18 R Ch 12.0-12.13 Lecture Notes; Assignment, due 10/25 R Ch 12.14-12.18 Assignments, due 11/01 R Ch 9.0-9.14 and R Ch 11.0-11.6, 11.1511.16 Lecture Notes; Assignments, due 11/8 G Ch 1-2 Team Book reports due 11/15 G Ch. 3-4 Assignments, due 11/22 Discussion Book reports T Ch 1-2 Lecture Notes NO assignments, Thanksgiving Week T Ch 3 Lecture Notes; Articles; Discussion Business Intelligence and Performance in Practice T Ch 4, 5 Lecture Notes; Article; Assignment, due 12/13 due 12/18 midnight Business Intelligence: Data and Text Mining Exa m week 4 Internal MBA604 5 Internal