Question

Help The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses direct-labor hours as its cost driver for overhead costs. irect-Labor Manufacturin January February March April May June Hours 22,000 24,000 31,000 25,000 29,000 27,000 Overhead $686, 000 725,000 884,000 750,500 783,000 780,000 Marchs costs consisted of machine supplies ($130,200), depreclation ($25,000), and plant maintenance ($728.800,. These costs exhibit the following respective behavior: variable, fixed, and semivariable. The manufacturing overhead figures presented in the preceding table do not include Metcalfs supervisory labor cost, which is step- fixed in nature. For volume levels of less than 15,000 hours, supervisory labor amounts to $70,000. The cost is $140,000 from 15,000- 29,999 hours and $210,000 when activity reaches 30,000 hours or more. Required: 1. Determine the machine supplies cost and depreciation for January. 2. Using the high-low method, analyze Metcalfs plant maintenance cost and calculate the monthly fixed portion and the variable cost per direct-labor hour. 3. Assume that present cost behavior patterns continue into the latter half of the year. Estimate the total amount of manufacturing overhead the company can expect in November if 28,400 direct-labor hours are worked. Complete this question by entering your answers in the tabs below Required 1 Required 2 Required 3 Assume that present cost behavior patterns continue into the latter haif of the year. Estimate the total amount of manufacturing overhead the company can expect in November if 28,400 direct-labor hours are worked Prev4 of 14Next >
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

1) Machine supplies per direct labor hour
=$130,200/31,000 =$4.2Per hour
Therefore, January= 22,000 hours*$4.2 per hour
= $92,400
Depreciation (Fixed) = $25,000
2) High low
Direct labor hours            31,000            22,000
mar Jan
manufacturing overhead        8,84,000        6,86,000
less:Depreciation          -25,000          -25,000
Machine supplies       -1,30,200          -92,400
Plant maintenance cost        7,28,800        5,68,600
Variable cost=($7,28,800-$568,600)/31,000-22,000
                     =$160,200/9,000
                     =$17.8
Fixed cost      =$7,28,800-(31000*17.8)
                       = $7,28,800-5,51,800
                       = $177,000
Direct labor hours for November = 28,400 hours
Expected Manufacturing overhead = Machine Supplies + Depreciation + Variable Plant maintenance cost + Fixed plant maintenance cost + Supervisory labor cost
= (28,400*4.2) + $25,000 + (28,400*17.8) + $177,000 + $140,000
= $119,280+ $25,000 + $505,520 + $177,000 + $140,000
= $9,66,800
Add a comment
Know the answer?
Add Answer to:
Help The following selected data were taken from the accounting records of Metcalf Manufacturing. The company...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses...

    The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses direct-labor hours as its cost driver for overhead costs. Month Direct-Labor Hours Manufacturing Overhead January 20,000 $ 684,000 February 22,000 723,000 March 32,000 882,000 April 23,000 750,000 May 27,000 780,000 June 25,000 777,000 March’s costs consisted of machine supplies ($128,000), depreciation ($24,000), and plant maintenance ($730,000). These costs exhibit the following respective behavior: variable, fixed, and semivariable. The manufacturing overhead figures presented in the...

  • The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses...

    The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses direct-labor hours as its cost driver for overhead costs. Month Direct-Labor Hours Manufacturing Overhead January 34,000 $ 698,000 February 36,000 737,000 March 46,000 896,000 April 37,000 753,500 May 41,000 801,000 June 39,000 798,000 March’s costs consisted of machine supplies ($248,400), depreciation ($31,000), and plant maintenance ($616,600). These costs exhibit the following respective behavior: variable, fixed, and semivariable. The manufacturing overhead figures presented in the...

  • The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours...

    The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours Manufacturing Overhead May 49,500 $ 924,000 June 61,400 1,144,000 July 75,000 1,348,700 August 55,500 987,000 Manufacturing overhead consists of three different costs; (1) machine supplies (variable), (2) property taxes (fixed), and (3) plant maintenance (semivariable). July's overhead costs were $174,000 for machine supplies, $24,700 for property taxes, and $1,150,000 for plant maintenance. Required: Determine the machine supplies and property taxes for May. By using...

  • The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours...

    The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours Manufacturing Overhead May 47,500 $ 904,000 June 60,600 1,136,000 July 71,000 1,306,300 August 53,500 983,000 Manufacturing overhead consists of three different costs; (1) machine supplies (variable), (2) property taxes (fixed), and (3) plant maintenance (semivariable). July's overhead costs were $172,000 for machine supplies, $24,300 for property taxes, and $1,110,000 for plant maintenance. Required: Determine the machine supplies and property taxes for May. By using...

  • Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following....

    Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,100, 12, 100, 14,200, 16,700. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and maintenance $0.60. Fixed overhead costs per quarter: supervisory salaries $38,890; depreciation $19,570; and maintenance $13,090. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2...

  • Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...

    Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 18,000 hours of productive capacity in the department: Variable overhead cost: Indirect factory labor Power and light $144,000 6,480 45,000 $195,480 Indirect materials Total variable overhead cost Fixed overhead cost: Supervisory salaries Depreciation of plant and equipment Insurance and property taxes $68,420 43,010 27,370 Total fixed overhead cost 138,800 Total factory...

  • Exercise 9-11 (Video) Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist...

    Exercise 9-11 (Video) Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,700, 12,500, 14,800, 16,800. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.20; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,290; depreciation $18,530; and maintenance $13,420. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate...

  • Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following...

    Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following Units to be produced (by quarters): 10,400, 12,400, 14,200, 16,600. Direct labor: Time is 1.7 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,580, depreciation $17,620; and maintenance $13,700. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...

  • Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...

    Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 15,000 hours of productive capacity in the department: Variable overhead cost: Indirect factory labor $121,500 Power and light 6,450 Indirect materials 43,500 Total variable overhead cost $171,450 Fixed overhead cost: Supervisory salaries $60,010 Depreciation of plant and equipment 37,720 Insurance and property taxes 24,000 Total fixed overhead cost 121,730 Total factory...

  • The following information was taken from the accounting records of the company Budgets Manufacturing Overhead $497,432...

    The following information was taken from the accounting records of the company Budgets Manufacturing Overhead $497,432 Actual Manufacturing overhead $418,798 Budgeted Direct Labor Hours $16,197 Actual Direct Labor Hours $17,584 The company uses a predetermined overhead rate based on direct labor hours, what would be the rate?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT