Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses when making planning decisions. She is pretty sure that overhead is a mixed cost that varies with direct labour-hours but she would like to do a proper analysis to determine the variable and fixed components. She collected the following information for the past 12 months on direct labour-hours incurred and total overhead expenses. Direct Labour-Hours 1,500 1,680 $ 47,200 1,800 $ 48,000 2,520 $ 51,200 2,700 $ 53,600 ETT 3,300 $ 56,800 3,900 $ 59,200 4,500 $ 61,600 4,200 $ 60,000 2,700 $ 54,400 1,860 3,900 Month January February March April May June July August September October November December Total Overhead Variable overhead cost Total fixed cost Costs $ 44,000 $ 49,600 $ 58,400 Required: 1. Using the least-squares regression method, estimate the variable overhead cost per direct labour-hour and the total fixed overhead cost per month. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per direct labour-hour to 2 decimal places.) per direct labour-hour per month 2. Express the cost data derived in part 1 above in the form Y= a + bx. (Round Fixed cost to the nearest whole dollar amount and the Variable cost to 2 decimal places.) Y = X 3. Using the cost formula stated in part 2, estimate total overhead costs for a month where direct labour-hours are expected to be 3,900. (Round your Variable cost per direct labor hour to 2 decimal places and round your final answer to the nearest whole dollar amount.) Total overhead costs Mary Ellis owns a small manufacturing company and would like to develop more accurate estimates for overhead expenses when making planning decisions. She is pretty sure that overhead is a mixed cost that varies with direct labour-hours but she would like to do a proper analysis to determine the variable and fixed components. She collected the following information for the past 12 months on direct labour-hours incurred and total overhead expenses. Direct Labour-Hours 1,500 1,680 $ 47,200 1,800 $ 48,000 2,520 $ 51,200 2,700 $ 53,600 ETT 3,300 $ 56,800 3,900 $ 59,200 4,500 $ 61,600 4,200 $ 60,000 2,700 $ 54,400 1,860 3,900 Month January February March April May June July August September October November December Total Overhead Variable overhead cost Total fixed cost Costs $ 44,000 $ 49,600 $ 58,400 Required: 1. Using the least-squares regression method, estimate the variable overhead cost per direct labour-hour and the total fixed overhead cost per month. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per direct labour-hour to 2 decimal places.) per direct labour-hour per month 2. Express the cost data derived in part 1 above in the form Y= a + bx. (Round Fixed cost to the nearest whole dollar amount and the Variable cost to 2 decimal places.) Y = X 3. Using the cost formula stated in part 2, estimate total overhead costs for a month where direct labour-hours are expected to be 3,900. (Round your Variable cost per direct labor hour to 2 decimal places and round your final answer to the nearest whole dollar amount.) Total overhead costs
Expert Answer:
Answer rating: 100% (QA)
1 Variable Overhead cost Total fixed cost 2 Y 3 Total overhead costs Working notes Calculation of to... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A regional manager at Acme Markets would like to develop a model to predict the weekly sales of pet food based on the shelf space allotted to the food. The following table shows the results of data...
-
A friend in West Virginia owns a small manufacturing firm employing about 50 workers. His son spent a semester in Japan as an exchange student. Upon return, he said to his dad: "Boy, the Japanese...
-
A small manufacturing company could expand its operation by adding new products. Any or all of the products shown below can be added. If the company uses a MARR of 15% per year and a 5-year project...
-
Find or evaluate the integral by completing the square. 3 L= dx x + 4x + 8
-
Kraft Bakeries introduced in 2010 a new line of frozen apple pie. For 2010, sales by quarter were as follows: 11,000 units; 16,000 units; 15,000 units; and 20,000 units. Because of aggressive...
-
What does professional skepticism mean?
-
VLM Food Trading International, Inc. was a Canadian agricultural supplier. Starting in June 2012, VLM sold frozen potatoes to Illinois Trading Company, an Illinois produce distributor, through nine...
-
Here are selected 2017 transactions of Akron Corporation. Jan. 1 Retired a piece of machinery that was purchased on January 1, 2007. The machine cost $62,000 and had a useful life of 10 years with no...
-
The DD-AA model predicts that a permanent increase in foreign money demand will lead to an improvement in the domestic current account. True/False/Uncertain, explain and support your answer with ONE...
-
1 Alta Electronics 2 3 4 5 Solution value 6 Selling price per unit 7 Material cost per unit 8 Labor cost per unit 15 9 Profit 10 Constraints 10 Cor 11 Department 1 Dep 12 Department 2 13 Department 3...
-
what are the competitive advantages of Walmart and target supermarket
-
People expect the value of houses they buy to appreciate over time. New cars, on the other hand, depreciate over time. The depreciation rate is highest during the first year (about \(20 \%\) on...
-
Zebra mussels are native to freshwater lakes and rivers of western Russia. Canal building to facilitate shipping around the turn of the eighteenth century allowed them to spread throughout Europe and...
-
The Bar Council of India, a statutory body created by the Indian Parliament, prescribes standards of professional conduct for lawyers in the country. One of these standards is that law firms and...
-
Both Omar and Zaid have an initial endowment of the same two goods. Omar has relatively more of Good 1 and his indifference curves are convex to the origin. In contrast, Zaid's indifference curves...
-
Employees in the United Kingdom who are sick for at least four days in a row are entitled to statutory sick leave of \( 89.35\) per week for up to 28 weeks. Sick leave is paid by employers and is a...
-
If the exterior perimeter of a residence is 14,675 If and the exterior wall height is 9'-0" tall how many rolls air barrier would be required to wrap the house if the air barrier comes in rolls of...
-
Write a while loop that uses an explicit iterator to accomplish the same thing as Exercise 7.3. Exercise 7.3. Write a for-each loop that calls the addInterest method on each BankAccount object in a...
-
Fall City Hospital has an outpatient clinic. Jeffrey Harper, tile hospitals chief administrator, is very concerned about cost control and has asked that performance reports be prepared that compare...
-
Describe how job-order costing concepts arc used in professional service firms, such as law practices and consulting firms.
-
Your next-door neighbor recently began a new job as assistant controller for Conundrum Corporation. As her first assignment, she prepared a performance report for January. She was scheduled to...
-
Flaherty Ltd sells two types of shoes, mens shoes and womens shoes. During the financial year ended 30 June 2019, fixed costs were $460 800 and sales were in the ratio of three units (pairs) of mens...
-
Newbery and Newstead is a public accounting firm specialising in auditing local medium-sized businesses. Fees charged for each audit are determined on the basis of identifiable hours worked on an...
-
Hotbox Ltd produces pizza boxes using two processes cutting and packaging. The production budget for the year ending 30 June 2019 estimated raw materials use of $400 000, factory overhead of $270...
Study smarter with the SolutionInn App