C01 NON LINEAR BREAK EVEN 2310 002 073

# C01 NON LINEAR - 140,000 120,000 100,000 80,000 60,000 Y'exp Marginal Expense Y'pft Marginal profit(1-MC Toal Variable Exp(MC*R FC Total Exp-TVC

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

60,000 80,000 100,000 120,000 140,000 160,000 - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 Y'exp: Marginal Expense Y'pft: Marginal profit (1-MC) Toal Variable Exp (MC*R) FC: Total Exp--TVC Break Even Point: Rev

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

View Full Document
COMPARATIVE INCOME STATEMENT 1995 1996 1997 1998 1999 2000 2001 SALES (Revenue) 72,051 81,844 82,879 84,407 91,568 107,137 110,496 OPERATING INCOME (3,769) 316 4,252 (1,775) 1,432 5,826 3,281 OPERATING EXPENSES 75,820 81,528 78,627 86,182 90,136 101,311 107,215 y = 9E-07x2 + 0.6631x + 21762 = 8.868872E-07x2 + 6.630742E-01x + 2.176237E+04 Yexp: Expense Function '= 8.868872*10^-7*(b3)^2 + 6.630742*10^-1*(b3) + 2.176237*10^4 1995 1996 1997 1998 1999 2000 2001 SALES (Revenue) 72,051 81,844 82,879 84,407 91,568 107,137 110,496 Y'exp: Marginal Expense 0.79 0.81 0.81 0.81 0.83 0.85 0.86 Y'pft: Marginal profit (1-MC) 0.21 0.19 0.19 0.19 0.17 0.15 0.14 Toal Variable Exp (MC*R) 56,983 66,150 67,139 68,605 75,589 91,400 94,924 FC: Total Exp--TVC 18,837 15,378 11,488 17,577 14,547 9,911 12,291 Break Even Point: Rev 90,074 80,196 60,490 93,888 83,362 67,474 87,215 60,000 80,000 100,000 120,000 1 (20,000) - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 xyz OPERATING INCOME OPERATING EXPENSES Revenue Profit/Costs 20,000 40,000 60,000 80,000 100,000 120,000 140,000 Y'exp: Marginal Expense Y'pft: Marginal profit (1-MC) Toal Variable Exp (MC*R) FC: Total Exp--TVC Break Even Point: Rev
60,000 70,000 80,000 90,000 100,000 110,000 120,000 13 -

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

View Full Document
2002 2003 2004 2005 118,023 119,083 122,935 136,973 2,516 6,685 6,946 8,379 115,507 112,398 115,989 128,594 2002 2003 2004 2005 118,023 119,083 122,935 136,973 0.87 0.87 0.88 0.91 0.13 0.13 0.12 0.09 102,966 104,114 108,322 124,102 12,541 8,284 7,667 4,492 98,302 65,901 64,500 47,803 140,000 160,000
30,000 140,000 150,000

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

View Full Document
The Process of Revenue-Expense-Breakeven Analysis 01/18/2010 SALES OP INCOMEOP EXPENSES SALES OPERATINGOPERATING EXPENSES 136,973 8,379 128,594 72,051 (3,769) 75,820 119,083 6,685 112,398 81,844 316 81,528 122,935 6,946 115,989 82,879 4,252 78,627 118,023 2,516 115,507 Data Sorted Data 84,407 (1,775) 86,182 110,496 3,281 107,215 Sort 91,568 1,432 90,136 107,137 5,826 101,311 Sales 107,137 5,826 101,311 91,568 1,432 90,136 110,496 3,281 107,215 84,407 (1,775) 86,182 118,023 2,516 115,507 72,051 (3,769) 75,820 119,083 6,685 112,398 81,844 316 81,528 122,935 6,946 115,989 82,879 4,252 78,627 Transposed data 136,973 8,379 128,594 Edit, Copy, Paste Special, Transpose ACTUAL INFORMATION 1995 1996 1998 1999 2000 2001 2002 2003 2004 2005 SALES 72,051 81,844 82,879 84,407 91,568 107,137 110,496 118,023 119,083 122,935 136,973 OPERATING INCOME (3,769) 316 4,252 (1,775) 1,432 5,826 3,281 2,516 6,685 6,946 8,379 OPERATING EXPENSES 75,820 81,528 78,627 86,182 90,136 101,311 107,215 115,507 112,398 115,989 128,594 Create the graph Insert, Chart, X Y(scatter) Create a trendline and its equation and correlation squared Chart, Add Trend line, Polynomial, Option, Display equation & R-squares Format data and the equation Format, Selected Data Labels,Number, Scientific (6decimals) writing the equation in a cell Op Expense function (OEF) =(8.868872)*(10^-7)*(sales value)^2+(6.630742)*(10^-1)*(sales value)+(2.176237)*10^4) Op Income function =(-8.868872)*(10^-7)*(sales value)^2+(3.369258)*(10^-1)*(sales value)+(2.176237)*10^4) The derivative function for Oper. Expense (MVC)
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/17/2010 for the course MATH 2310 taught by Professor Shakroh during the Spring '09 term at Langara.

### Page1 / 11

C01 NON LINEAR - 140,000 120,000 100,000 80,000 60,000 Y'exp Marginal Expense Y'pft Marginal profit(1-MC Toal Variable Exp(MC*R FC Total Exp-TVC

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

View Full Document
Ask a homework question - tutors are online