Week 11-ACC381 - CollegeofBusiness Information Systems Management Accounting Information Systems Lab Goal Seek and Kleitsch Lise Urbaczewski

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

View Full Document Right Arrow Icon
Name College of Business Information Systems Management / Accounting Information Systems Lab - Goal Seek and Solver (chapter 9) Samantha Kleitsch / Lise Urbaczewski
Background image of page 1

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

View Full DocumentRight Arrow Icon
“Good management is the art of making problems so interesting and their solutions so constructive that everyone wants to get to work and deal with them.” - Paul Hawken Property of L. Urbaczewski / S. Kleitsch
Background image of page 2
Focus Today: 1. Review Goal Seek (already covered, ch 2 and ch 8) 2. Learn and apply Solver Property of L. Urbaczewski / S. Kleitsch
Background image of page 3

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

View Full DocumentRight Arrow Icon
Review and Discuss What was Goal Seek? When did we use this? Discuss: Only changing one cell. Is this a limitation? What is the role of data here? How do you go about solving problems? [how do you eat an elephant – one bite at a time…] Property of L. Urbaczewski / S. Kleitsch
Background image of page 4
When do we use Solver? Solves more complex problems Determines optimal inputs to reach desired outcome maximize profit minimize costs best use of resources (people, money, materials) Property of L. Urbaczewski / S. Kleitsch
Background image of page 5

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

View Full DocumentRight Arrow Icon
Example in text: Goal Seek or Solver Production plan for tournament racquets Using Goal Seek, can only modify one cell at a time See and discuss Figure 9.2, page 550 Determining the number of racquets We changed the value in one cell, to see outcome in another cell In this example, we now have determined the Property of L. Urbaczewski / S. Kleitsch
Background image of page 6
Property of L. Urbaczewski / S. Kleitsch
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/07/2011 for the course ACC 381 taught by Professor Samanthakleitsh during the Spring '11 term at University of Michigan-Dearborn.

Page1 / 24

Week 11-ACC381 - CollegeofBusiness Information Systems Management Accounting Information Systems Lab Goal Seek and Kleitsch Lise Urbaczewski

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

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