In this case, Josey decided to switch from the companys traditional cost driver (candle inches produced) to a new cost driver (DL hours) because of the possibility that the new line will make candle inches a less effective driver. The following table presents Wedgewoods total production costs, total candle inches produced, and total DL hours for the past five (5) years: Year 2015 Total Production Costs Total Candle Inches Produced Total DL Hours $5,595,000 5,300,000 36,250 2014 $5,200,000 4,700,000 35,360 2013 $4,750,000 4,000,000 27,075 2012 $4,000,000 3,500,000 28,000 2011 $3,275,000 2,800,000 19,650 Using this information, perform two regressions. Both will have production costs as the dependent (or Y) variable, but one will use candle inches and the other will use DLH as the independent (or X) variable. Then use this information, as well as the information from the case, to write a memo to Jeremiah Wedgewood, the current CFO of Wedgewood Candle Company, discussing which driver you suggest the company use. Remember that your memo is going to a senior member of the management team, so you will need to provide adequate support for your arguments and provide a polished final product. A) Complete the Excel spreadsheet (Critical Thinking Template) attached to this exercise. Attach the completed Excel spreadsheet to this assignment (10 points). B) Use the Wedgewood memo template to create a business memo (Wedgewood Candle Memo Word file template is attached) to Jeremiah Wedgewood and attach the memo to this problem, You are not limited to one page on the memo.