gg-3 - DecisionMaking UsingExcel...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style 11 Decision Making 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
22 Agenda For both of the following functions:   Goal Seek and Solver Discuss reading Go over problems together
Background image of page 2
What-if Analysis Very handy in all business settings Most important thing to remember:    The “changing cell(s)” should not  have a formula in them—if they do, you  shouldn’t be changing those cells, need  to select other cells to change 33
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
44 Goal Seek Can determine a single value Need to define Set cell To value By changing cell
Background image of page 4
55 Solver Used for optimization Need to define Target cell Changing cells Constraints SUMPRODUCT function is very 
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
66 What are Solvers Good For? Solvers, or optimizers, are software tools that help users find the  best way to  allocate scarce resources . The resources may be raw  materials, machine time or people time, money, or anything else in 
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

gg-3 - DecisionMaking UsingExcel...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online