Textbook Notes (378,732)
CA (167,254)
McMaster (9,163)
COMPSCI (45)
Dr.Hurst (18)
Chapter

# Excel Session 10.docx

3 Pages
131 Views

Department
Computer Science
Course Code
COMPSCI 1BA3
Professor
Dr.Hurst

This preview shows page 1. Sign up to view the full 3 pages of the document.
Comp Sci Session 10: Performing What-IF Analysis
1
Comp Sci Session 10: Performing What-IF Analysis
Comp Sci Session 10.1 Data Tables and What-IF
Analysis
Understanding Cost-Volume-Profit Relationships (pg. 166)
ï‚· Cost-volume-profit (CVP) studies relationships expenses, sales, volume, and
profitability
Comparing Expenses and Revenue (pg. 166)
ï‚· First component of CVP is cost or expense
ï‚· There are 3 types of expenses:
o Variable
o Fixed
o Mixed
ï‚· Variable expenses change in respect to the amount of business a company does
o Expense such as, buying the product, making the product.
ï‚· Fixed expense that must be paid regardless of the number of sales.
o Ex. Paying the employees, salaries, insurance plan, benefits
ï‚· Mixed expense is a mixture of variable and fixed expenses.
Determining the Break-Even Point (pg. 168)
ï‚· Break-even point is the point where revenue equals expenses. Sales below the
break-even point = lose of money, above the break-even point = increase in profit
o CVP analysis calls this break-even analysis
ï‚· Cost-volume-profit (CVP) chart is a chart that displays the point where the
revenue and expenses meet.
Performing a What-IF analysis with Goal Seek (pg. 170)
ï‚· What-IF analysis lets you observe the impact of changing values in a worksheet
ï‚· We can input an income statement into Excel and then perform:
o What if analysis:
ï‚§ Change the value of an input cell and observe the effects on
calculated cells
o Goal seeking:
ï‚§ Specify the value for a calculated cell, then excel produce a input
value needed to reach that goal

#### Loved by over 2.2 million students

Over 90% improved by at least one letter grade.

OneClass has been such a huge help in my studies at UofT especially since I am a transfer student. OneClass is the study buddy I never had before and definitely gives me the extra push to get from a B to an A!

Leah â€” University of Toronto

Balancing social life With academics can be difficult, that is why I'm so glad that OneClass is out there where I can find the top notes for all of my classes. Now I can be the all-star student I want to be.

Saarim â€” University of Michigan

As a college student living on a college budget, I love how easy it is to earn gift cards just by submitting my notes.

Jenna â€” University of Wisconsin

OneClass has allowed me to catch up with my most difficult course! #lifesaver

Anne â€” University of California
Description
Comp Sci Session 10: Performing What-IF Analysis Comp Sci Session 10.1 Data Tables and What-IF Analysis Understanding Cost-Volume-Profit Relationships (pg. 166) ï‚· Cost-volume-profit (CVP) studies relationships expenses, sales, volume, and profitability Comparing Expenses and Revenue (pg. 166) ï‚· First component of CVP is cost or expense ï‚· There are 3 types of expenses: o Variable o Fixed o Mixed ï‚· Variable expenses change in respect to the amount of business a company does o Expense such as, buying the product, making the product. ï‚· Fixed expense that must be paid regardless of the number of sales. o Ex. Paying the employees, salaries, insurance plan, benefits ï‚· Mixed expense is a mixture of variable and fixed expenses. Determining the Break-Even Point (pg. 168) ï‚· Break-even point is the point where revenue equals expenses. Sales below the break-even point = lose of money, above the break-even point = increase in profit o CVP analysis calls this break-even analysis ï‚· Cost-volume-profit (CVP) chart is a chart that displays the point where the revenue and expenses meet. Performing a What-IF analysis with Goal Seek (pg. 170) ï‚· What-IF analysis lets you observe the impact of changing values in a worksheet ï‚· We can input an income statement into Excel and then perform: o What if analysis: ï‚§ Change the value of an input cell and observe the effects on calculated cells o Goal seeking: ï‚§ Specify the value for a calculated cell, then excel produce a input value needed to reach that goal Comp Sci Session 10: Performing What-IF Analysis 1 Goal Seeking ï‚— Very useful for doing simple queries to see what the effects are of changing the value of one variable ï‚— For more complex a
More Less

Only page 1 are available for preview. Some parts have been intentionally blurred.

Unlock Document

Unlock to view full version

Unlock Document
Notes
Practice
Earn
Me

OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.