ITM 215 Class 24 Apr 22

ITM 215 Class 24 Apr 22 - ITM 215: Computer Concepts in...

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

View Full Document Right Arrow Icon
ITM 215: Computer Concepts in Business Performing What-If
Background image of page 1

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

View Full DocumentRight Arrow Icon
8/13/2007 New Perspectives on Microsoft Office Excel Objectives Explore the principles of cost-volume- profit relationships Perform a basic what-if analysis Use Goal Seek to calculate a solution Create a one-variable data table Create a two-variable data table Create and apply different Excel 2
Background image of page 2
8/13/2007 New Perspectives on Microsoft Office Excel Objectives Generate a scenario summary report Generate a scenario PivotTable report Explore the principles of price elasticity Run Solver to calculate optimal solutions Create and apply constraints to a Solver model 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
8/13/2007 New Perspectives on Microsoft Office Excel Cost-Volume-Profit Relationships Cost-volume-profit (CVP) analysis (expenses, volume of business, profits) Variable expenses A fixed expense A mixed expense 4
Background image of page 4
8/13/2007 New Perspectives on Microsoft Office Excel Cost-Volume-Profit Relationships 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
8/13/2007 New Perspectives on Microsoft Office Excel 6 Isolate Your Assumptions Enter your assumptions (the arguments needed for the function) into cells and use those cells for your arguments For example, in the PMT function, enter the loan amount, number of payments, and interest rate into cells, then use those cells in the PMT function Change the values in those cells to
Background image of page 6
8/13/2007 New Perspectives on Microsoft Office Excel 7 Goal Seek Specify Amount You Want a Formula to Return Use to Find the Value of a Constant in Formula that Excel Can Adjust
Background image of page 7

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

View Full DocumentRight Arrow Icon
8/13/2007 New Perspectives on Microsoft Office Excel Working with What-If Analysis To perform what-if analysis: Change a cell value Observe the impact on one or more calculated cells 8
Background image of page 8
8/13/2007 New Perspectives on Microsoft Office Excel Working with Goal Seek To perform Goal Seek: In the Data Tools group on the Data tab, click the What-If Analysis button, and then click Goal Seek In the Set cell box, select the result cell, and then, in the To value box, specify its value (goal) In the By changing cell box, specify the input cell 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
8/13/2007 New Perspectives on Microsoft Office Excel Goal Seek Example 10 Car Example
Background image of page 10
8/13/2007 New Perspectives on Microsoft Office Excel Working with What-If Analysis and Goal Seek 11
Background image of page 11

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

View Full DocumentRight Arrow Icon
8/13/2007 New Perspectives on Microsoft Office Excel Data Tables A Data Table (sensitivity table) summarizes the impact of one or two variables on formulas that use those variables (one formula at a time). Use data tables to see how different
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 45

ITM 215 Class 24 Apr 22 - ITM 215: Computer Concepts in...

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

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