SIMON FRASER UNIVERSITY
BEEDIE SCHOOL OF BUSINESS
BUS 336 D100/E100 Data & Decisions II
Note: This is an individual assignment. Identical assignments will receive a
mark of 0.
Due: Thursday, Oct 2nd at 5:00pm. (Both Sections).
The D100 (Day Section) Drop
BUS 336: Normal Probability Distribution Problem Set
The Standard Normal Distribution
1.
Find the area under the graph of the standard normal distribution which lies:
(make sure you sketch and label the distribution diagram for each one)!
a) between z = 0
BUS 336 Burnaby (D100 and E100) Final Exam Info:
Date: Thursday April 18th from 7:00pm to 9:30pm
Location: GYMWEST
Format:
Closed Books, Closed Notes
Formula Sheet Provided
Please bring SFU Photo ID
Approx. 40% Multiple Choice
Approx. 60% Longer Ques
13Ch13_Render.QXD
2/6/09
6:25 PM
Page 1
CHAPTER 13
Inventory Control
Models
L EARNING OBJECTIVES
After completing this chapter, students will be able to
1. Understand the importance of inventory control.
2. Use the economic order quantity (EOQ) model to
d
DA Problem Set #2
Solutions:
1. MDDJ Decision Problem. Solution by hand:
Question 1 Using Treeplan:
Disassemble for Parts
11000
11000
11000
0.7
VSM Buys it
19500
Re-jig & try to sell to VSM
-500
13500
20000
19500
0.3
VSM doesn't buy
2
-500
13500
0
-500
0.
Regression Problem Set #2 Numeric Solutions
Textbook Questions
6. a. See file:PRB9_6.XLS for the regression output. There is a reasonably linear relationship
between the variables given the scatterplot
^
b. The estimated regression equation is: Y - 7.84 +
Question 1:
The cost of delivering a module from factory to a manufacturer is the production cost plus the shipping
cost.
Let Xij (i=1,2,3, j=1,2,3,4) represent the units of products shipped from plant i to manufacturer j
Question 2:
Let x1 represent the
Q1
A)
Define Decision Variables:
Let X1 be the amount of $ invested in Green Fund, in thousands,
Let X2 be the amount of $ invested in Super X, in thousands of $
Objective Function:
Max: annual return=0.12X1+0.15X2
Operational Constraints:
Subject to:
Inv
BUS 336 (MidExam)
1. (a) The optimal solution of $26 profit lies at the point X 2,Y 3.
(b) If the first constraint is altered to 1X 3Y 8, the feasible region and optimal
solution shift considerably, as shown in the next graph.
X1 = number of medical patie
Chapter 8
Forecasting Models
BUS 336
Data & Decisions II
Forecasting
Predict the future, reduce uncertainty
No single model is best
Done repeatedly over time
Qualitative models
Subjective
Time series models
Quantitative historical
Causal models
Cause
Chapter 6
Regression
BUS 336
Regression Analysis
Building models that characterize the relationships
between a dependent variable and one (single) or
more (multiple) independent variables, all of which
are numerical.
Regression analysis can be used for:
SIMON FRASER UNIVERSITY
Faculty of Business Administration
COURSE: BUS 336 E100 (Burnaby)
TITLE: Data and Decisions II
Venues
SEMESTER: Fall 2016
Lecture (E100): Thurs 5:30 8:20 pm in C9002
Tutorial (E101): Tues 5:30 6:20 pm in AQ3182
D100 Open Labs (in W
BUS 336
Week 4 Tutorial Handout
Time Series Method 1: Moving Average (MA) simple Chapter 11: Section 11.4
Take the average of k periods to predict the forecast in period t + 1
For Wallace Garden, use k = 2 to forecast for the first 6 periods
where k repre
BUS 336
Decision Analysis Problem Set #2 Decision Trees and Bayes Theorem
1. MDDJ Co. has built a specialized processing machine for AJ Co. at a cost of $18,000.
Unfortunately, AJ has gone bankrupt and cannot take delivery of the machine. MDDJ has a
numbe
BUS 336 - DA Problem Set #1 Solutions
Textbook Solutions:
4. a)
Amount of Snow:
Size of
Order:
Large
Medium
Small
Heavy
$10
$8
$4
Normal
$7
$8
$4
Light
$3
$6
$4
Maximum
<-maximum
$10
$8
$4
Therefore, using Maximax Decision rule, Brenda should select a lar
BUS336DataandDecisionsII
Anyone who does not have a partner
for Assignment#2, please meet at the
front of the class during the break or
after class.
Please note: you MUST carry out this
assignment with someone from your
section.
MLR Issues
Regression Assu
BUS336DataandDecisionsII
Assignment #2
Posted in Canvas in the assignment folder
Similar to todays exercise except you will be dealing
with real data! And you will be performing
Backwards Step-Wise Regression
A little more than 2 weeks to complete it.
Tea
Regression Problem Set #2
Please complete the following Exciting Regression Questions for Homework (not to be
handed in but very important for final exam preparation!):
When asked what regression model performs best, please make sure that you provide a cl
BUS 336 - DA Problem Set #1 Solutions
Textbook Solutions:
4. a)
Amount of Snow:
Size of
Order:
Large
Medium
Small
Heavy
$10
$8
$4
Normal
$7
$8
$4
Light
$3
$6
$4
Maximum
$10
$8
$4
<-maximum
Therefore, using Maximax Decision rule, Brenda should select a lar
Solutions to LP Problem Set #3 Sensitivity Analysis
(Revised Problem: Profit = 5X1 + 35X2)
1. How many products A and B should the furniture company make in order to
maximize the total profit contribution? State the maximum profit.
Make 0 units of Product
Crystal Ball Data
Workbook Variables
Name:
Value:
Last Var Column
Worksheet Data
Last Data Column Used
0
2
Sheet Ref
Err:509
Err:509
Sheet Guid
a9b81843-1430-4530-9426-6ef657ec58f9
6dcac32b-3d5c-4704-980c-9ab72a39af61
Deleted sheet count
Last row used
28
Month
January
February
March
April
May
June
July
August
September
October
November
December
Year 1
Year 2
Year 3
170
180
195
180
205
210
205
215
230
230
245
280
240
265
290
315
330
390
360
400
420
290
335
330
240
260
290
240
270
295
230
255
280
195
220
25
Bill Pritchett's Shop
Known Parameters
Selling price per unit
Fixed cost
Variable cost per unit
Variables
Number of units, X
Results
Total revenue
Fixed cost
Total variable cost
Total cost
Profit
$10.00
$1,000.00
$5.00
1000
$10,000.00
$1,000.00
$5,000.00
Outcomes
(states of Prior prob
HD
0.3
MD
0.5
LD
0.2
Conditional prob.
given demand
PS
NS
0.967
0.033
0.533
0.467
0.067
0.933
Total
Given information
To be calculated
Joint prob. (Prior prob. Conditional prob.
X condit. prob.)
given Survey Result
PS
NS
PS
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.896159669
R Square
0.8031021524
Adjusted R Square
0.7969490947
Standard Error
7790.8746383093
Observations
100
ANOVA
df
3
96
99
SS
MS
F
23766951871.5343 7922317290.51 130.5208218
5826981852.46567 60697727.
Problem 1-19
Known parameters:
Selling price per unit
Fixed cost
Variable cost per unit
Input Data
Number of units, X
Results
Total revenue
Fixed cost
Total variable cost
Total cost
Profit
$0.06
$15,000.00
$0.02
375000
$22,500.00 BEP=
$15,000.00 BEP in do