Quantity of Automobile Lube Jobs # Q P # Cars Adv Pr 1 86 30 22.0 500 20 2 87 35 23.0 550 29 3 93 28 23.4 430 31 4 92 25 23.0 400 35 5 86 30 23.6 500 29 6 93 20 24.0 400 30 7 88 29 24.1 300 35 8 89 31 24.5 450 28 9 88 35 25.0 430 25 10 93 29 25.6 500 30 11 87 35 26.0 400 29 12 89 40 26.0 570 31 13 88 47 26.7 520 35 14 82 34 27.3 300 29 15 93 35 28.0 450 35 Average 88.93 32.20 24.81 446.67 30.07 1. Run the data through Excel Regression - print output (10%) 2. Evaluate the statistical significance of the equation and each of the parameters - (10%) 3. Generate the specific form of the equation using average values of the original data (5%) 4. Calculate the inverse form of the demand equation (5%) 5. Calculate the elasticity coefficients of each of the parameters using the function and average values of the dataset (20%) 6. Using the own-price elasticity you calculated in #5 above what effect would a price increase have on total revenue (10%)

Eliminating entries (including goodwill impairment) and worksheets for various years on january 1, 2013, porter company purchased an 80% interest in the capital stock of salem company for$850,000. at that time, salem company had capital stock of $550,000 and retained earnings of $80,000.differences between the fair value and the book value of the identifiable assets of salem company were asfollows: fair value in excess of book valueequipment$130,000land65,000inventory40,000the book values of all other assets and liabilities of salem company were equal to their fair values onjanuary 1, 2013. the equipment had a remaining life of five years on january 1, 2013. the inventory was sold in2013.salem company’s net income and dividends declared in 2013 and 2014 were as follows: year 2013 net income of $100,000; dividends declared of $25,000year 2014 net income of $110,000; dividends declared of $35,000required: a.prepare a computation and allocation schedule for the difference between book value of equity acquired andthe value implied by the purchase price.b.present the eliminating/adjusting entries needed on the consolidated worksheet for the year endeddecember 31, 2013. (it is not necessary to prepare the worksheet.)lo6lo1