Jensen Tire & Auto is deciding whether to purchase a maintenace contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the data in the above excel sheet. The excel sheet lists information about the weekly usage (in hours) and the corresponding annual maintenance expense (in hundreds of dollars).

1) Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense in hundreds of dollars (y) for a given number of hours of weekly usage (x). Based on the results of your regression, is there likely a relationship between usage and maintenance expense?

2) What is the p-value corresponding to a t test that you could use to determine your answer to the previous question? (Round your answer to four decimal places. Be sure to enter a numeric answer with no words.)

3) How much of the variation in the sample values of annual maintenance expense (in %) does the estimated regression model explain? (Round your answer to one decimal place. Enter a numeric answer with no words, and no special characters such as !, %, etc.)

1. Martha Manufacturing a product through three separate production lines “A”, “B” and “C”. Costs for producing a product through each line as well as maximum outputs of each line and fixed cost associated with setting up the line is shown below:

The company has received an order of 60 units to be produced.

Model the problem for optimum number of products to be made from each production line.

1. Formulate a linear programming model for maximizing total profit contribution. (7 marks)

1. Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution? (7 marks)

**Note that you need to submit your excel document to get credit for this part. please attach the formula for each section and please do it asap