Excel Array Formulas
Excel array formulas allow you to write
concise formulas that perform operations that
might not be included as Excel built-in functions.
This workbook contains several examples of using
array formulas.
Operation Examples
Multiply all
Introduction to Financial Analysis
Case Study Example
This workbook summarizes many of the concepts that are taught in the course: Introduction to Financial
Analysis. Information about this course and other free resources can be found at: www.exinfm.com
T
Process Analysis
Order Winners
Operational Capabilities
-Price
-Low cost process
-Quality
-High quality process
-Speed
-Fast process
-Flexibility
-Flexible process
Order winners are criteria that differentiate one firm form another
Cycle Time: average tim
Process Analysis
Order Winners
Operational Capabilities
-Price
-Low cost process
-Quality
-High quality process
-Speed
-Fast process
-Flexibility
-Flexible process
Order winners are criteria that differentiate one firm form another
Cycle Time: average tim
PRE MIDTERM
Process Analysis Order winners: price,
quality, speed, flexibility
Cycle Time: time between consecutive units
leaving process, inverse of output rate
Flow Time: time it takes a unit from entering to
leaving the process
Theoretical FT: minimum
TO 502: Business Statistics
TO Final Review
TO 502: Business Statistics
Course Review
TO 502 Final Exam
Final examination
Cumulative, open book and notes
PDF version of notes okay.
Calculators ok
Laptop will be used. Make sure you can run a regression.
(N
TO 502 Fall 2016 Final Exam Solution
Part 1: Multiple choice, 3 points each.
1. If
X
is a continuous random variable, which of the following is not true?
a. The height of the probability density function at any point gives the probability that
X
takes tha
Weeks 3-6 Schedule (from Syllabus Page 5)
(Tutorial 6, Lecture File 01)
Page 5)
The Three Dimensions of a Workbook
This graphic suggests the possibility of intra-workbook referencing
(building formulas on a worksheet that refer, at least in part, to
infor
. MW
MAI c H I CAN
TO 301 : BUSINESS ANAL YTIcs AND STA TISTIcs
HONOR POLICY
We, the members of the Ross School of Business at the University of Michigan community
students, faculty and staff commit ourselves to do our work and perform our duties hones
Module 1
Optimal point is always on a binded constraint, other constraints are not binding
Feasible region - straight edges and corners
Feasible solution - solution for which all of the constraints are satisfied
Optimal solution - feasible solution that h
TO 301: Homework Assignment
Discrete and Continuous Distributions
Due 11:55 pm Tuesday, October 18
Questions: Discrete distributions and random variables
1. Daily demand for printers at a local Test-Buy store takes values from cfw_0, 1, 2, 3, 4. The likel
Module 1
Optimization
Decision variables - variables in objective formula
Objective function - profit, cost
f(x) = f(x1, x2, . xn)
Constraints - restriction of available resources
Dont forget non-negativity constraints
Optimal point is always on a binded
TO 301 Quiz # 1
1. Which ofthe following function/constraint(s) are linear?
a. 2 + 3x 4y + Z /
b. x2 + 3 y X
c. xy + yz + xz -><
d. 2 + 1/36 x
, - X >/ 2 X + l
e. 122+1/x andel / AbZCCWSi WC COW Yewwhz CU cfw_
_ X \
cfw_A / $2? )ZC'hWc gtCiQJ ("ZN 3Kuh-0n
Sunday Review Problems
Module 1
1. Solve the following LP graphically:
Max
y +2
Subject to
x+ y 2
x y 3
x0
2. Bartley Machine produces machined parts for an automotive supplier. Bartley has two
production facilities, one in New Hampshire and one in Florid
TO 313 Operations Management
Class 1:
Class 2:
Class 3:
Law
Class 4:
Introduction to OM and Process Analysis
Process Analysis Application I: Kristens Cookies Co.
Taxonomy of Process Types, Inventory Build-up, Littles
Process Analysis Application II: Natio
Final Exam
Monday, April 27, 1:30 pm - 3:30 pm
Alternate exam: Monday, April 27, 10:30 am 12:30 pm
Locations announced one week before exam
Closed book, allowed to bring 1 ONE note
page. Double-Sided 8.5 x 11 No flaps.
Bring a Calculator. Other elect
TO 313 Operations Management
Class
Class
Class
Class
Class
Class
Class
Class
1-4: Process Analysis
5-7: Waiting Time Analysis
8-9: Inventory Management: Newsvendor
10: Quality Management
11: Optimization (Linear Programming)
12: Midterm Review
13, 15: Pro
TO 313 Operations Management
Class 1: Introduction to OM and Process Analysis
Class 2: Process Analysis Application I: Kristens Cookies Co.
Class 3: Taxonomy of Process Types, Inventory Build-up, Littles
Law
Class 4: Variability, Buffers, Matching Supply
Example 1: Component Commonality
Sport Obermeyer originally matched the color of the
zipper with the color of the garment. Red zippers daily
demand is N(100, 30). Blue zippers daily demand is
N(300, 40). Sport Obermeyer uses a fixed-order
quantity model w
TO 313 Operations Management
Class
Class
Class
Class
Class
Class
1-4: Process Analysis
5-7: Waiting Time Analysis
8-9: Inventory Management: Newsvendor
10: Quality Management
11: Optimization (Linear Programming)
12: Midterm Review
Class 13, 15: Project M
TO 313: Operations Management
Class 1
Introduction to OM and Process
Analysis
Course Expectations
My Job
Arrive to class on time and prepared
Deliver OM concepts and tools
Help you learn outside classroom
Evaluate your performance
Your Job
Arrive t
TO 313 Operations Management
Class
Class
Class
Class
Class
Class
Class
Class
Class
Class
1-4: Process Analysis
5-7: Waiting Time Analysis
8-9: Inventory Management: Newsvendor
10: Quality Management
11: Optimization (Linear Programming)
12: Midterm Review
TO 313 Operations Management
Class
Class
Class
Class
Class
Class
1-4: Process Analysis
5-7: Waiting Time Analysis
8-9: Inventory Management: Newsvendor
10: Quality Management
11: Optimization (Linear Programming)
12: Midterm Review
Class 13, 15: Project M
Example 1: Component Commonality
Sport Obermeyer originally matched the color of
the zipper with the color of the garment. Red
zippers daily demand is N(100, 30). Blue zippers
daily demand is N(300, 40). Sport Obermeyer uses a
fixed-order quantity model w
TO 313 Operations Management
Class
Class
Class
Class
Class
Class
Class
Class
1-4: Process Analysis
5-7: Waiting Time Analysis
8-9: Inventory Management: Newsvendor
10: Quality Management
11: Optimization (Linear Programming)
12: Midterm Review
13, 15: Pro
TO 313 Operations Management
Class 1-4: Process Analysis
Class 5-7: Waiting Time Analysis
Class 8-9: Inventory Management: Newsvendor
Class 10: Quality Management
Class 11: Optimization (Linear Programming)
Class 12: Midterm Review
Class 13, 15: Project M