Textbook Notes (369,072)
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.
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
Me

OR

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.