BUAD306
Dr. Kydd
Exercise 1
Forecasting
Using the data on the next page, complete the following:
a) Use a 3-month moving average model to forecast sales for periods 6-11.
b) Use a 5-month moving average model to forecast sales for periods 6-11.
c) Use an
Dr. C. Kydd
BUAD 306
Exercise 2
Linear Programming
1.
The Scrod Manufacturing Co. produces two key items special-purpose Widgets
(W) and more generally useful Frami (F).
Management wishes to determine that mix of W & F which will maximize total
Profits (P
BUAD 306
Exercise 3
Transportation Problem
a) Find an initial solution using Northwest Corner and find the cost of
this solution.
Plant/W
H
1
2
3
4
Capacity
A
B
C
1200
1900
1800
500
1500
3100
1800
2000
D
E
Demand
3500
900
4400
0
0
0
1100
1100
1200
4200
50
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.877447
R Square
0.769913
Adjusted R Square
0.741153
Standard Error
6624.175
Observations
10
ANOVA
df
Regression
Residual
Total
Intercept
X Variable 1
SS
MS
F Significance F
1 1.17E+009 1.2E+009 26.76952 0.
BUAD306
Dr. Kydd
Exercise 1
Forecasting
a) Use a 3-month moving average model to forecast sales for periods 6-11.
i. F6= $61,500
ii. F7= $62,421.67
iii. F8= $62,248.33
iv. F9= $60,151.67
v. F10= $65,771.67
vi. F11= $72,838.33
MAD=677,767.66
Bias=5,370
b)
Dr. C. Kydd
BUAD 306
Exercise 2
Linear Programming
1.
The Scrod Manufacturing Co. produces two key items special-purpose Widgets
(W) and more generally useful Frami (F).
Management wishes to determine that mix of W & F which will maximize total
Profits (P
Dr.Kydd
BUAD 306
Exercise 2
Linear Programming
1.
1. Let: W= Number of Widgets
F= Number of Frami
Z= Total amount of Profit
2. Objective is to maximize profit
Objective Function: Max. Z= 30W+20F
3. Constraints Without Demand Estimates:
1/2W+ 1/4F =< 160 h
(A)
Period
3 month MA
Data
Ft
et
1
$37,725
2
47,180
3
54,965
4
63,220
5
66,315
6
57,730
61500.00
7
62,700
62421.67
8
60,025
62248.33
9
74,590
60151.67
10
83,900
65771.67
(B)
Period
-3,770.00
278.33
-2,223.33
14,438.33
18,128.33
5 month MA
Data
Ft
et
1
$37
3.
Matchpoint Company produces 3 types of tennis balls: Heavy Duty, Regular, and
Extra Duty, with a profit contribution of $24, $12, and $36 per gross (12 dozen),
respectively.
The linear programming formulation is:
Max.
24x1 + 12x2 + 36x3
Subject to:
.75
Dr. C. Kydd
BUAD 306
Exercise 6
Inventory/MRP
1.
Dee and Carol are owners of a company supplying tin cans to countries at war.
This war tin company has had a history of lack of control, particularly in the productioninventory area. Both Dee and Carol expe
BU306
Fall, 2005
Dr. C. Kydd
Name _
Operations Management
Exam 2
UD OnLine
1. (60 points)
The Acme Company has four factories that ship products to five warehouses. The
shipping costs, warehouse requirements, and factory capacities are given below in the
Exercise 2 - Solution for Problem 1
Max. Z = 30W + 20F
subject to
1/2W + 1/4F <= 160 hours Mach. 1
1/3W + 1/3F <= 160 hours Mach. 2
W + F => 200 hours
Min. Production
W => 250 units
F => 500 units
Desired but not
necessary
Exercise 2 - Solution for Proble
Simulation - Exercise 8
Policy variable: Number of machines (3 vs 4)
Parameters: $4 idle time cost per hour, $6 lost
goodwill cost per hour, 22 hours of machine
time per day.
Endogenous variables: idle time, lost goodwill
hours (hours carried over a day).
Practice Exam 1 Questions on LP
1. ( 120 pts.)
Bryants Pizza, Inc., is a producer of frozen pizza products. The company makes a
profit of $1.00 for each pepperoni pizza it produces and $1.50 for each double-pepperoni
pizza produced. Each pizza includes a
MURPHY: BUAD306
Last Name:_ First Name: _
Fall 2014 - QUIZ1 - Project Management
SECTION 12
SHOW ALL WORK AS DONE IN CLASS- Answer the following questions given the network diagram
and duration/crash cost information given below. Please write answers unde
BUAD306
Dr. Kydd
Exercise 1
Forecasting
a) Use a 3-month moving average model to forecast sales for periods 6-11.
F6=(54,965+63,220+66315)/3= 61,500 , e6= -3,770
F7= 62,421.667 , e7= 278.333
F8= 62,248.333 , e8= -2,223.333
F9= 60,151.667 , e9= 14,438.333
HW2 Solution
1. The following diagram shows a four-step process that begins with Operation 1 and ends with
Operation 4. The rates shown in each box represent the effective capacity of that operation.
a. Determine the capacity of this process.
b. Which act
The Forsite Company is screening three ideas for new services. Resources constraints allow only
one idea to be commercialized at the present time. The following estimated have been made for
the five performance criteria that management believes to be most
Ch3 Tutorial Solution
1. Given the following data:
Period
1
2
3
4
5
Number of Complaints
60
65
55
58
64
Prepare a forecast for period 6 using each of these approaches:
a. A three-period moving average.
b. A weighted average using weights of 0.50 (most rec
HW3 Solution
1. As part of a major plant renovation project, the industrial engineering department has
been asked to balance a revised assembly operation to achieve an output of 240 units
per eight-hour day. Task times and precedence relationships are as
HW1 Solution
1. Freight car loadings at a busy port are as follows:
Wee
k
1
Number
220
2
245
3
280
4
275
5
300
6
310
7
350
8
360
9
400
10
380
11
420
12
450
13
460
14
475
15
500
16
510
17
525
18
541
a. (0.6') Determine a linear trend line for expected frei
Ch8 Tutorial Solution
1. A small producer of machine tools wants to move to a larger building, and has identified two
alternatives. Location A has annual fixed costs of $800,000 and variable costs of $14,000 per
unit; location B has annual fixed costs of
Homework 3
Problem 1: Alesha plays a game in which she rolls a fair five-sided die. On
a 1 or 2, she loses 2 dollars. On a 3 or 4, she neither wins nor loses money.
On a 5, she wins 5 dollars. Let M be the random variable representing how
much Alesha earn
Matthew Pomponio
BUAD306
Dr. Kydd
Exercise 1
Forecasting
Using the data on the next page, complete the following:
a) Use a 3-month moving average model to forecast sales for periods 6-11.
Period 6: ($66,315 + $63,220 + $54,965)/3 = $61,500
Period 7: ($57,
Ch19 Tutorial Solution
1. A retired couple supplement their income by making fruit pies, which they sell to a
local grocery store. During the month of September, they produce apple and grape pies.
The apple pies are sold for $1.50 to the grocer, and the g