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 heteroscedasticity. Commenton the outcomes.
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 computer satits 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?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.