Question: I'm so confused on what needs to be done here. In this case, Josey decided to switch from the company's traditional cost driver (candle inches

 I'm so confused on what needs to be done here. In

I'm so confused on what needs to be done here.

In this case, Josey decided to switch from the company's 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 Wedgewood's total production costs, total candle inches produced, and total DL hours for the pas five (5) years: Year 2015 Total DL Hours Total Production Costs $5,595,000 $5,200,000 $4,750,000 $4,000,000 $3,275,000 Total Candle Inches Produced 5,300,000 4,700,000 4,000,000 3,500,000 2,800,000 2014 2013 2012 2011 36,250 35,360 27,075 28,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 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 attched) to Jeremiah Wedgewood and attach the memo to this problem, You are not limited to one page on the memo. Also you may want to use the business memo writing checklist (Written Simuilation Evaluation Form) to help you create a "poilished" product.. In this case, Josey decided to switch from the company's 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 Wedgewood's total production costs, total candle inches produced, and total DL hours for the pas five (5) years: Year 2015 Total DL Hours Total Production Costs $5,595,000 $5,200,000 $4,750,000 $4,000,000 $3,275,000 Total Candle Inches Produced 5,300,000 4,700,000 4,000,000 3,500,000 2,800,000 2014 2013 2012 2011 36,250 35,360 27,075 28,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 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 attched) to Jeremiah Wedgewood and attach the memo to this problem, You are not limited to one page on the memo. Also you may want to use the business memo writing checklist (Written Simuilation Evaluation Form) to help you create a "poilished" product

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!