ITM 215 Class 24 Apr 22

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

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

ITM 215: Computer Concepts in Business Performing What-If

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

View Full Document
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
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

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

View Full Document
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
8/13/2007 New Perspectives on Microsoft Office Excel Cost-Volume-Profit Relationships 5

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

View Full Document
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
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

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

View Full Document
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
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

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

View Full Document
8/13/2007 New Perspectives on Microsoft Office Excel Goal Seek Example 10 Car Example
8/13/2007 New Perspectives on Microsoft Office Excel Working with What-If Analysis and Goal Seek 11

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 05/05/2010 for the course COM 4123 taught by Professor Ted during the Spring '10 term at SUNY Albany.

### 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
Ask a homework question - tutors are online