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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

please check answer twice

Q4
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
January
February
March
April
May
June
July
August
September
October
November
December
Direct
Labour-Hours
1,500
1,680
1,800
2,520
2,700
3,300
3,900
Variable overhead cost
Total fixed cost
4,500
4,200
2,700
1,860
3,900
Total Overhead
Costs
$44,000
$47,200
$48,000
$51,200
$53,600
$56,800
$59,200
$61,600
$60,000
$54,400
$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
Transcribed Image Text:Q4 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 January February March April May June July August September October November December Direct Labour-Hours 1,500 1,680 1,800 2,520 2,700 3,300 3,900 Variable overhead cost Total fixed cost 4,500 4,200 2,700 1,860 3,900 Total Overhead Costs $44,000 $47,200 $48,000 $51,200 $53,600 $56,800 $59,200 $61,600 $60,000 $54,400 $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 Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education