Business Mathematics: Break-Even Analysis worksheet
1. For each of the following, perform a break-even analysis showing:
- algebraic statements of the revenue function and the cost function
- a detailed break-even graph
- computation of the break-even poi
Business Mathematics in Canada, Eight Edition
Excel Workbook for:
Exercise 4.1: Trade Discounts
The three templates in this workbook can help you solve virtually every problem in Exercise 4.1.
Each one of these problems requires you to determine a net pri
MANIPULATION OF FORMULAS
INSTRUCTIONS: In each formula, solve for the indicated variables. Show all steps.
FORMULA
a)
b)
c)
d)
e)
I PRT
A P I
A P PRT
SOLVE FOR
P, R, T
P, I
P, R, T
C, M
C, E, P
S C M
S C E P
M
S
M
Rc
C
9
F C 32
5
5
C F 32
9
TR Px
f) R s
Chapter 4 | Mathematics of Merchandising
4.3
4.3S-1
SUPPLEMENT: DIAGRAM MODEL FOR MARKUP
PROBLEMS
The accompanying diagram is a useful aid for setting up and solving markup problems.
Figure 4.5 is a pictorial representation of the relationships between Se
1.
Rules of Exponents
Operations on exponents having the same base or an exponent with an integer base.
Rule no. 1: The product of exponents with the same base is the same base, raised to sum of the powers.
Example: 32x33=32+3=35
Rule no. 2: Dividing two
Summary of Key Formulas
APPLICATIONS OF ALGEBRA
Portion
Rate = _
Base
(1-1)
Sum of (Weighting factor Value)
Weighted average = _
Sum of weighting factors
Vf - Vi
c = _ 100%
(2-1)
Vi
or value on the selected date Base value
_
Index number = Price
Price or
Appendix 9C
APPENDIX 9C:
9C-1
ANNUALIZED RATES OF RETURN AND GROWTH
Suppose that Investment A provided a total return of 3.1% during a four-month holding period,
and Investment Bs total return over a seven-month period was 5.25%. Although B produced
the l
Business Mathematics in Canada, Eighth Edition
Excel Workbook for:
Exercise 6.2: Determining the Time Period (Term)
A Note on Date Formats
If you just enter "October 15, 2011" (without the quotes) in an unformatted cell, Excel will display
the date as 15-
Business Mathematics in Canada, Eighth Edition
Excel Workbook for:
Example 6.1D
There are four variables in the simple interest formula, I=Prt. We want to create a
single template that will enable us to calculate any one of the four variables if we first
Business Mathematics in Canada, Eighth Edition
Excel Workbook for:
Exercise 5.4: CVP Analysis
All five templates in this workbook are based on the net income formula:
NI = (S - VC) X - FC
If you know any four of the five variables, select the tab labelled
Business Mathematics in Canada, Eighth Edition
Introduction to Excel Functions
Excel provides many special-purpose functions. Each function represents a built-in
ready-to-use formula that will perform a specialized calculation on your worksheet data.
You
Business Mathematics in Canada, Eighth Edition
Introduction to Excel Functions
Excel possesses many special-purpose functions. A function represents a built-in
ready-to-use formula that will perform a specialized calculation on your worksheet data.
You do
Business Mathematics in Canada, Eighth Edition
Excel Workbook for:
Exercise 6.3: Maturity Value (Future Value) of a Loan or Investment
After you program the four templates (one on each worksheet), you can use them to help solve
the problems in Exercise 6.
Business Mathematics in Canada, Eighth Edition
Excel Workbook for:
Exercise 8.5: Other Applications of Compounding
The template in this workbook is intended for calculating an investment's (compounded)
future value where the periodic rate of interest can
Model 1
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.8207385938
R Square
0.6736118394
Adjusted R Square
0.6269849594
Standard Error
2.5139433051
Observations
9
ANOVA
df
1
7
8
SS
MS
F
91.3028456319 91.3028 14.4469
44.2393765903 6.31991
135.5422222222
Actual Data
Pension Plan
Job ClassificationPlan A Plan B Plan C
Supervisor
10
13
29
Clerical
19
80
19
Labor
81
57
22
Total
110
150
70
P-Value
CHITEST
2.42509616E-017
The value of p is lower than alpha => we reject H0 => there is a significant association
Actual Data
Pension Plan
Job ClassificationPlan A Plan B Plan C
Supervisor
10
13
29
Clerical
19
80
19
Labor
81
57
22
Total
110
150
70
P-Value
CHITEST
2.42509616E-017
The value of p is lower than alpha => we reject H0 => there is a significant association
Yazan Alhayek
6157457
Confused Word Passage
1. Although he was shy, the new budget coordinator learned to accept praise gracefully.
2. The news of the merger affected moral was to increase tension.
3. Now an affluent man, Bill Gates dedicates his life to
Yazan Alhayek
6157457
PASS THIS, DAMN IT!
Present tense, only. (is/are)
1.
2.
3.
4.
5.
6.
7.
8.
There is a virus in my computer.
One of students is helping me at the school.
During the exam time, he is playing with his phone.
There are too many chairs in
Math1020 - Unit 2
Chapter 8 - Compound Interest and Applications
8.1 Basic Concepts
Compound Interest employed when term is greater than 1 year. Interest is periodically calculated and
converted to principal. Interest earned in one period will itself earn
13. A scheduled payment stream consisted of three payments: $2100 due (but not paid) 1 years
ago, $1300 due today, and $800 due in 2 years. What single payment, 6 months from now,
would be economically equivalent to the payment stream? Money can earn 4.5%
MATH1020: BUSINESS MATH 2 - Guelph
WEEK
Dates
Topics and Practice
1
Mon Jan 9th
Wed Jan 11th
2
Mon Jan 16th
Wed Jan 18th
3
Mon Jan 23rd
Wed Jan 25th
4
Mon Jan 30th
Wed Feb 1st
5
Mon Feb 6th
Wed Feb 8th
6
Mon Feb 13th
Wed Feb 15t
MATH1020 Test#2 Review
f =( 1+i )m1
1. What amount three years ago is equivalent to $4800 on a date 1 years from now if
money earns 8% compounded semiannually?
$ 3372.42
2. Jacques has just been notified that the combined principal and interest on an
amou