Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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" productStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started