Excel Scenario and Goal Seek Class Exercises

Simple Scenario and Goal Seek for a Manufacturing Problem

Download the following spreadsheet-

Excel/Scenarios/BreakEvenScenario.xlsx

  1. Use Scenario Manager to create 3 scenarios-
  2. Use Goal Seek to determine the break even point (0 profit) in terms of

Use the spreadsheet below as a base for determining a

GoalSeek & Scenario Exercise - Grade Problem-Excel Sheet.xlsx

Use the spreadsheet (above) as a basis for creating a final grade calculator like the one below-

 

 

Also, use the Scenario Manager to create 3 different scenarios based on a "Bad" (low scores), "OK", and "Great" (high scores) on Quiz 4, Mini-quizzes, and Homework, and the Broadway Cafe project. Save each scenario under the names- Bad, OK, and Great.