1. Use the correlation tool in Excel to determine which measure should be used for each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Use the correlation tool in Excel to determine which measure should be used for each activity. HINT: The correlation tool can be found on the Analyze menu on the Data tab in Excel. If the Analyze section does not appear, you will need to load the Analysis ToolPak. Click the File tab, click Op- tions, and click Add-Ins. Make sure Excel Add-ins appears in the Manage field. Check the Analysis ToolPak option and click OK. 2. Using the measures identified in 1., determine the activity rates for allocating manufacturing over- head to jobs. 3. What would the predetermined rate be if direct labor hours were used to allocate all manufacturing overhead costs? 4. Assume Kirkland had a job that required 36 direct labor hours, 16 machine hours, 1,875 compo- nents, and 68 boxes. How much manufacturing overhead would be applied to that job under ABC? How does that compare to the amount applied if direct labor hours were used to allocate overhead? What might account for the difference? Budgeted Overhead Materials movement. Assembly. Packaging/Shipping. $1,080,000 $1,950,000 $1,584,000 Budgeted Measures # of jobs Direct labor hours.. Machine hours # of boxes shipped. # of components used 480 16,000 7,800 48,000 4,000,000 1. Use the correlation tool in Excel to determine which measure should be used for each activity. HINT: The correlation tool can be found on the Analyze menu on the Data tab in Excel. If the Analyze section does not appear, you will need to load the Analysis ToolPak. Click the File tab, click Op- tions, and click Add-Ins. Make sure Excel Add-ins appears in the Manage field. Check the Analysis ToolPak option and click OK. 2. Using the measures identified in 1., determine the activity rates for allocating manufacturing over- head to jobs. 3. What would the predetermined rate be if direct labor hours were used to allocate all manufacturing overhead costs? 4. Assume Kirkland had a job that required 36 direct labor hours, 16 machine hours, 1,875 compo- nents, and 68 boxes. How much manufacturing overhead would be applied to that job under ABC? How does that compare to the amount applied if direct labor hours were used to allocate overhead? What might account for the difference? Budgeted Overhead Materials movement. Assembly. Packaging/Shipping. $1,080,000 $1,950,000 $1,584,000 Budgeted Measures # of jobs Direct labor hours.. Machine hours # of boxes shipped. # of components used 480 16,000 7,800 48,000 4,000,000
Expert Answer:
Answer rating: 100% (QA)
A Statement showing activity drivers and rates A B C D E BD Particu... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
The following information should be used for questions 1, 2, and 3. Select the best answers under each of two alternative assumptions: (a) The LCU is the functional currency and the translation...
-
What translation method should be used for a self-sustaining subsidiary that operates in a highly inflationary environment? Why?
-
What sample sizes should be used for these time studies? a. There should be a .90 probability that the value of the sample mean is within 2 minutes, given that the standard deviation is 4 minutes. b....
-
Write an application that works as a comparator. Your program should read two numbers from the user and print 0 if they are equal to each other, 1 if the first number is greater, and 1 if the second...
-
Record transactions and adjustments. Enter the following column headings across the top of a sheet of paper: Enter the transaction/adjustment letter in the first column and show the effect, if any,...
-
Suppose one Schottky defect is present in every tenth unit cell of MgO. MgO has the sodium chloride crystal structure and a lattice parameter of 0.396 nm. Calculate (a) The number of anion vacancies...
-
Which of the following indicates a satisfactory situation from the viewpoint of good internal control? (a) The cashier reports to the treasurer. (b) Payroll accounting reports to the controller. (c)...
-
Widden Company, which sells electric razors, had $400,000 of cost of goods sold during the month of June. The company projects a 5 percent increase in cost of goods sold during July. The inventory...
-
Question 2 a. Assume Time Warner shares have a market capitalization of $40 billion. The company is expected to pay a dividend of $0.25 per share and each share trades for $40. The growth rate in...
-
As the manager of credit card services at Bank of Hanover (BOH), you're aware that the average profitability of a credit card customer grows with the number of years they have used the credit card....
-
The main difference between management and stewardship lies in their underlying ethos and approach. Management is like running a business efficiently to make profits, while stewardship is more about...
-
What is the role of cooling towers in surface condenser ?
-
Define a compound machine.
-
Define vacuum efficiency and condenser efficiency.
-
Differentiate between load and effort.
-
What are the effects of air infiltration in condensers ?
-
Please complete the ETL process of 2018 through 2022 NFL data provided in the links below, appending the queries such that you have one cleaned and compiled set of data to analyze. Using the 2018...
-
Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....
-
Techware Incorporated is considering the introduction of two new software products to the market. In particular, the company has four options regarding these two proposed products: introduce neither...
-
A U.S. Navy recruiting center knows from past experience that the heights of its recruits have traditionally been normally distributed with mean 69 inches. The recruiting center wants to test the...
-
In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both bindingthe company is using all it has. a. Use SolverTable to see what happens to the optimal...
-
Donald Winn and Judy Reed agreed to liquidate their partnership on June 30 of the current year. On that date, after financial statements were prepared and closing entries were posted, the general...
-
Theresa Doran and Roy Eden are partners in a business called D & E Sales. The partnership's work sheet for the year ended December 31 of the current year is provided in the Working Papers. ...
-
Brian Hughes and Wendy Perez formed a partnership five years ago. The partnership has been very successful and is growing rapidly. The partners are evaluating future actions for the next five years....
Study smarter with the SolutionInn App