MGSC 1205
Module 2
Financial Models
Learning Objectives
Concepts
Time value of money
Simple versus compound interest and the effect of compounding
Effective interest rate versus nominal rate
Effects of interest rates and payment schedules on debt and
MGSC 1205
Module 0
An Introduction to Problem Solving, Decision Models and Excel
Supplementary Notes
0.1 A Brief Introduction to Problem Solving
0.2 Accessing on the University Network
0.3 Excel Basics Finding a Total
0.4 Excel Basics Building a Model
0.1
COMPUTER PARTS (Chapter 1)
Fall 2017
BITS & BYTES
To process data into information, computers use binary language.
Binary language: consists of just two (2) digits. What are they? 0, 1
Bit: binary digit; 0 or 1
Byte: 8 bits; string of eight (8) 0s and 1s
MGSC 1205
Solutions to Finance Practice Problems
Finance Formulas
Future value of a single
amount
Future value of an
annuity
Present value of an
annuity
= (1 + )
(1 + ) 1
]
1
1
(1 + )
= [
]
= [
1. Many years ago, Canada Savings Bonds carried coupons. Y
MGSC 1205
Module 1
Simple Linear Descriptive Models breakeven, process selection,
supply/demand
Learning Objectives
Concepts
Role of descriptive models what if?
Cost, revenue, and profit relationships with volume
Capacity options and tradeoffs
Viewing
Sample Midterm MGSC 1205 Fall 2017
The midterm is intended to cover the material addressed in assignments #1 to #4 breakeven, machine
selection, basic finance models. Although Assignment #5 will be completed and returned before the
midterm, we will not be
MGSC 1205
Introduction to Quantitative Methods I
Fall 2017
Assignment #5
Due: 1 pm, Friday, October 13th
1.
The Smith family is planning for their daughters education. She just turner 5 years old and will be 18 when
she starts university. They are plannin
MGSC 1205
Introduction to Quantitative Methods I
Fall 2017
Assignment #3
Due: 1 pm, Friday, September 29nd
1.
Before leaving for a 4 year posting overseas, Julie Midyear had invested $5,000 at 8% compounded quarterly.
a. How much will she have when she re
MGSC 1205
Introduction to Quantitative Methods I
Fall 2017
Assignment #1
Due: 1 pm, Friday, September 15th
1. Dr. Aleda Roth, a prolific author, is considering starting her own publishing company. She will call it DSI Smithson
Foods is considering launchi
Solution to MGSC 1205 Sample Final Exam
[Question 1 Mortgage] Jasmine and her husband are considering trading up their home by selling their
current house, and buying a new house at a price of $1 450,000. They plan to sell their current house for
$280,000
Optimized results: Bass Boat=70
Assignment #7
Quant 1
Ski Boat=120
Speed Boat=76
Jonathan Bowles
A00417000
a.
b.
c.
d.
e.
What is the impact on the profit and production plan if the number of drilling hours is increased to
703?
Profit will decrease and pr
MGSC 1206.2
*Final Exam*
MGSC 1206.2
Solution Key to Final Exam
Name: _ (print)
ID#: _
Name: _ (signed)
Section: _ Instructor: _
1.
2.
3.
4.
5.
6.
7.
There should be SIX pages including this cover page.
Please answer all questions on the exam paper. Use t
MGAC 1206.2
Review for Final Exam
Dr. Muhong Wang
Practical Problems on Probability & Decision Analysis
#1. A representative group of 300 working people in their thirties were asked when they plan to retire.
Their responses were classified as early (by ag
MGSC 1206.2
Introduction to Quantitative Methods II
Winter 2017
ASSIGNMENT 1
Due: 1:00 PM. Friday, January 20, 2017
PRACTICE PROBLEMS:
In 11.3 Exercises on pp.566-569, problems #26, 27, 30,31.
In 11.4 Exercises on pp.584-587, problems #13,48, 49,51.
In 12
MGSC 1206
Introduction to Quantitative Methods II
Winter 2017
ASSIGNMENT 2
Due: 1:00 PM. Friday, February 3, 2017
PRACTICE PROBLEMS:
In 13.1 Exercises on pp.668-669, problems #13,15,17,47.
In 13.2 Exercises on pp.680-681, problems #13, 15, 45, 49.
In 13.3
FLASH FICTION NOTES:
Brevity is the soul of wit.
Jonathan Swif
Flash fiction is an intellectually-challenging blurb of a story. Its length can vary: 1 sentence, 50
words, or 2 pages. Heres an example:
A woman is sitting in her old, shuttered house. She kn
Name: Xiaofei Ma
A00378746
DATE: 18/7/2015
Professor: David R. Wilson
ENGL 1205 introduction of literature
ONCE UPON A TIME
In Nadine Gordimers Once Upon a Time, the most important is the theme. It clearly shows
that the whole story tell me two part that
1
MGSC2207
ASSIGNMENT #5 QUESTIONS do not hand in Mar 2017
answers to be posted on 31 March
Note: Do NOT hand in this assignment. Solutions will be posted towards the end of next week.
Note: On the final exam, you will be responsible for being able to ans
[QUANTITATIVE METHODS 1: MGSC 1205 SAMPLE QUESTIONS]
Instructor: Nader AZAD
Example 1. Satish Mehras company in considering producing a gear assembly that it now is sold at the price $5 per unit. Mehra
estimates that it will cost $14,000 to set up the pro
MGSC 1205
INTRODUCTION TO QUANTITATIVE METHODS I
2015
Fall
1. Dr. Marshall operates a plant producing glass products. He is considering purchasing a machine to
make more units. The machine will cost $20,000. Dr. Marshall intends to sell the glass product
MGSC 1205
Quantitative Methods I
Winter 2017
Assignment #2
Total: 30 Points
1) An account paying annual compound interest was opened with $1,000 ten years ago. Today, the
account balance is $1,500.
a) What annual interest rate did the account pay? (5 poin
MGSC 1205
Quantitative Methods I
Winter 2017
Assignment #3
1) The Ricordi family has just bought a house for $275,000. They have been saving money for a while
and are able to make a $100,000 down payment. They have chosen a 30-year mortgage from their
ban
MGSC 1205
Quantitative Methods I
Winter 2017
Assignment #1
30 Points
1) Dr. Marshall operates a plant producing glass products. He is considering purchasing a machine to make
more units. The machine will cost $20,000. Dr. Marshall intends to sell the glas
Lee midterm 2016
February 15, 2017
3:37 AM
<Lee midterm 2016.pdf>
Right skewed distribution
On average, the numbers of bee colonies that either
disappeared or succumbed
differ from each other by 12.
On average , the typical difference between numbers of d
Page |1
Page |2
PROBLEM 1 15 Points
Various Cost and Sales data for Gunn Inc. are given below for the year ending June
30, 2015.
Purchases of Raw
Materials
Raw Materials Inventory,
Beginning
Rent, Factory
Insurance, Factory
Direct Labour
Rent, Admin. Offi
A
1
2
3
4
B
C
D
E
F
G
H
I
J
Assignment #7
A
B
Selection
Max Profit
C
D
E
F
0
#
1
#
0
#
1
#
1
#
1
#
660000
10
1
110000
9
1
53000
8
1
1
47000
6
1
92000
12
1
85000
5
1
1
5
6
s.t
Constraint
Constraint
9 Constraint
10 Constraint
11 Constraint
7
8
1
2
3
4
5
-1
Farah Al-Jbour
A00394528
Q.1)
Unadjusted Balance: $2,000 at June 30,2015
Unadjusted balance per Book: $614
Comoulink Inc.
Bank Reconciliation
June 30,2015
Cash Balance Per Bank
Add: Deposit in transit
$
$
2,000
160
Less: Outstanding Cheques
Adjusted Cash
A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Number of Hours
Min cost
B
C
D
E
F
Sign
>=
>=
>=
<=
<=
RHS
X
Y
Name And ID
10
0
$ 5.00 $ 10.00 $ 50.00 < Min
s.t.
Constraint 1:
Constraint 2:
Constraint 3:
Constraint 4:
Constraint 5:
LHS
3
1
1
Lee midterm 2016
February 15, 2017
3:37 AM
Lee midterm 2016
SMU Page 1
SMU Page 2
Right skewed distribution
On average, the numbers of bee colonies that either
disappeared or succumbed
differ from each other by 12.
SMU Page 3
SMU Page 4
On average , the t