spreedsheet

Week # 5 - Chapter # 9 Assignment

This week we cover Chapter 9 “Enhancing Decision Making with Solver” Before you start on the Excel exercises be sure to read and make sure you understand the Chapter Introduction and VERY IMPORTANT, the Case Scenario on page 553. Power Points are available in Blackboard Lectures and, video tutorials guiding you through the Learning part of each level of each chapter are available on youtube.com.

 Level 1 Solving Product Mix Questions Using Solver

 Level 2, Enhancing the Production Plan with Solver.

 Level 3, Managing Transportation Problems with Solver

We will cover Levels 1 and 2 only. Let's get started: ==========================================================================================

Week # 5 - Chapter # 9 Assignment

Chapter # 9 - Level 1: Objectives (Pages 552 – 572)  Understand the differences between Goal Seek and Solver  Analyze data by creating and running a Solver model  Save a Solver solution as a scenario and interpret an answer report

Level One: LEARNING

The material covered the Case Scenario in Level 1 (pages 553) “Solving Product Mix Questions Using Goal Seek and Solver”.

You should read learning material on pages 554 - 570 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 1: “Solving Product Mix Questions Using Goal Seek and Solver” Or use the link: https://www.youtube.com/watch?v=Hskt00wF5Yo&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&

index=25

Level One: PRACTICE:

In the Week # 5 - Chapter 9 - Exercises.pdf Document, make the Exercise Ch9-1: Level 1 –Sports Wear Retailers Post your completed file to Blackboard for review and grading. The file Name should be 9-1-MagazineAds-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Level One: APPLYING

In the Week # 5 - Chapter 9 - Exercises.pdf Document, make the Exercise Ch9-2: Level 1 – Creating a Production Plan for ATC Inc. Post your completed file to Blackboard for review and grading. The file Name should be 9-2-ATCValve-Production-YourName.

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 5 - Chapter # 9 Assignment

Chapter # 9 - Level 2: Objectives (Pages 572 – 581)  Expand a Solver model by adding new decision variables to it  Identify feasible, infeasible, and unbounded solutions  Troubleshoot infeasible and unbounded solutions

Level Two: LEARNING The material covered in Level 2: Enhancing the Production Plan with Solver on pages 572 to 581.

You should read the learning material covered on pages 572 to 581 and the youtube.com video tutorial for this level. Use the attached presentation in Level 2 to see the video Level 2: Enhancing the Production Plan with Solver. Or use the link: https://www.youtube.com/watch?v=6f4iELMD8HQ&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d

&index=26

Level Two: PRACTICE

In the Week # 5 - Chapter 9 - Exercises.pdf Document, make the Exercise Ch9-3: Level 2 – Radio Advertisement

Post your completed file to Blackboard for review and grading. The file Name should be 9-3-RadioAds-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Level Two: APPLYING

In the Week # 5 - Chapter 9 - Exercises.pdf Document, make the

Exercise Ch9-4: Level 2 - Managing Purchases for BrightStar Toy Company.

Post your completed file to Blackboard for review and grading. The file Name should be 9-4-Power-Blocks-YourName.xlsx. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 5 - Chapter # 9 Assignment

Create a Word Document 5-Essay-Chapter9-YourName to answer the following questions. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

1. What are the limitations of using Goal Seek? 2. How many variable cells can you use in a Solver model? 3. What are the three required parameters of a Solver model, and what do they represent? 4. What are two advantages of creating a constraints table in a worksheet that includes a Solver model? 5. What is the advantage of linking the constraints in the Solver Parameters dialog box to values in a constraints table in the worksheet? 6. What is the difference between a policy constraint and a physical constraint? Give one example of each type of constraint. 7. What is an objective function? 8. What are the five comparison operators that you can use in Solver? 9. When should you include integer constraints in a Solver model? What is the disadvantage of using an integer constraint? 10. What is a scenario in Solver?

Week # 5 - Chapter # 9 Assignment

Let me know if there is anything you don't understand -- the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.

The solution files that you need to attach are: 9-1-MagazineAds-YourName.xlsx (20 points) 9-2-ATCValve-Production-YourName (20 points) 9-3-RadioAds-YourName.xlsx (20 points) 9-4-Power-Blocks-YourName.xlsx (20 points) 5-Essay-Chapter9-YourName.docx (Questions requested) (20 points)