Assignment
Using the date provided in problem 12 of chapter 6, develop the projection for wins of the 15 year using the following models:
1. Linear regression
2. Moving Average using a N= 4, and N=6
3. Weight Moving Average with (45%, 30%, 25%)
4. Exponential Smoothing with alpha =20%
Calculate the MAD for each model and determine which model is more aligned with the trend of the values.
Calculate R and F for the Linear regression and make your interpretation.
Problem 12 - Chapter 6
The graduate assistant for the Santa Clara Broncos football team has compiled the following statistics:
|
YEAR
|
WINS
|
AVERAGE OFFENSIVE YARDS
|
AVERAGE INTERCEPTIONS
|
|
1
|
10
|
500
|
2
|
|
2
|
8
|
450
|
4
|
|
3
|
5
|
250
|
10
|
|
4
|
10
|
485
|
1
|
|
5
|
7
|
399
|
4
|
|
6
|
11
|
521
|
2
|
|
7
|
4
|
158
|
15
|
|
8
|
11
|
525
|
0
|
|
9
|
8
|
485
|
4
|
|
10
|
4
|
300
|
9
|
|
11
|
5
|
350
|
9
|
|
12
|
7
|
375
|
9
|
|
13
|
2
|
150
|
15
|
|
14
|
5
|
380
|
5
|
a. Using Excel, develop a linear regression model for wins, employing average offensive yards and average interceptions.
b. Calculate the MAD for your model.
c. Calculate R, F, and t statistics and interpret them.
d. Run tests for multicollinearity,auto corrrelation,and he tero scedasticity.Comment on the
outcomes.
Wk 5
Topic: Economic Order Quantity
Determine the Economic Order Quantity in Excel for:
Price of Product: $150
Savings Rate: 12%
Annual Usage: 16240
Cost of transportation: $200/order
Cost of PO preparation: $60/order
Warehouse Rental: $8/piece
Topic: Linear Programming
Develop problem 1 of chapter 8 using excel or by hand. You need to present the objective and constraints equations. No need to solve it.
Problem 1
The Waikiki Enterprise Corporation produces two types of computersatits manufacturing plant in Torrance, California. Profit on computer A is $900 per unit and for computer B it is $600. The manufacturing plant can produce not more than 50 of computer A and 100 of computer B a day.
The following table displays the capacity for the manufacturing plant.
|
PLANT
|
CAPACITY TO PRODUCE COMPUTER A
|
CAPACITY TO PRODUCE COMPUTER B
|
MAXIMUM AVAILABLE CAPACITY
|
|
A Riverview Plant
|
51
|
101
|
18000
|
|
Unit profit
|
$900
|
$600
|
|
a. What are the decision variables?
b. What is the objective function?
c. What are the constraints?
d. What are the non-negativity assumptions?