Linear Programming
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 + 3
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).
Data
W
Unit profit contributi
BUAD 831
Dr. Hyde
Assignment 1
Forecasting
1. (30 points)
Using the data below,
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 exponential smoot
Linear Programming
2.
The Ace Manufacturing Company produces two lines of its product, the super and
the regular. Resource requirements for production are given in the table. There are 1,600
hours of assembly worker hours available per week, 700 hours of
SAMPLE LINEAR PROGRAMMING MODEL
A company makes Product X and Product Y. Per unit profit on X is $100. Per unit profit on Y is $120.
Combined production of X and Y must be at least 200.
After production, products are stored in a warehouse having 36,000 cu
Quantitative Forecasting
Techniques
Time Series Models
Demand is tracked over time to see
natural patterns
Causal Models
Demand is tracked as a function of
another variable, such as advertising
dollars. As the variable changes, we
look for corresponding
SOLVING LINEAR PROGRAMMING MODELS USING EXCEL
Numerous software packages exist for solving LP models. Excel is the package of choice for this course
because (1) Excel is a very popular spreadsheet package in both industry and academia, (2) most students
h
7/9/16
?
?
Goal Programming
Mathematical model similar to Linear
Programming, however it allows for
multiple goals to be satisfied at the same
time. Also the multiple goals can be
prioritized and weighted to account for the
DMs utility for meeting the var
7/9/16
? Goal Programming Example
?
WebNet.com is a growth oriented firm
which establishes monthly performance
goals for its sales force
WebNet determines that the sales force has
a maximum available hours per month for
visits of 640 hours
Further, it
Dr. Hyde April 2017
BUAD 831 Online
Assignment 5
Project Management
1. The following activities comprise a software/hardware design project. A description of the activities and
their predecessors is given below.
Activity
A
B
C
D
E
F
G
H
I
J
K
L
M
Descript
ASSIGNMENT 7 PART 1
Byco opened its first retail store in Denmark in 1938. 75 years later, the company is a reputable retailer with more than
8,000 stores in Europe, Scandinavia and the U.S. During the past 20 years, Bycos strategy has been to provide pro
Assignment 3
Dr. Rhonda Hyde
BUAD831
Spring 2017
Part 1 10 pts
Tole wishes to introduce two new fruit juice products to its current product line: Product A and Product B. The relevant
production and cost information regarding these two new products appear
BUAD 831 - Sample Forecasting Problems
1.
Give an example of a time series data set that
i)
exhibits upward trend Number of hybrid vehicles sold annually in the U.S. from 2000
ii)
exhibits seasonality
Average monthly high temperature in Newark in 2010 - 2