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:

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.

a. What are the decision variables?

b. What is the objective function?

c. What are the constraints?

d. What are the non-negativity assumptions?