Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Month Direct Labour-Hours Total Overhead Costs
January 1,500 $ 44,000
February 1,680 $ 47,200
March 1,800 $ 48,000
April 2,520 $ 51,200
May 2,700 $ 53,600
June 3,300 $ 56,800
July 3,900 $ 59,200
August 4,500 $ 61,600
September 4,200 $ 60,000
October 2,700 $ 54,400
November 1,860 $ 49,600
December 3,900 $ 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.)

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.)

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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

2. What are the components of IT infrastructure?

Answered: 1 week ago