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 preceding table do not include Metcalf’s supervisory labor cost, which is step-fixed in nature. For volume levels of less than 15,000 hours, supervisory labor amounts to $76,000. The cost is $152,000 from 15,000–29,999 hours and $228,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 Metcalf’s 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 29,600 direct-labor hours are worked.
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...
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 March's 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...
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...
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...
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 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...
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...
Atlanta Company is preparing its manufacturing overhead budget for 2014. Relevant data consist of the following. Units to be produced (by quarters): 10,400, 12,900, 14,500, 16,100. Direct labor: time is 1.6 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,110; depreciation $17,010; and maintenance $14,100. Prepare the manufacturing overhead budget for the year, showing quarterly data.
Ayayal Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the Tollowing. Units to be produced (by quarters): 10.100, 12, 100, 14,100,16,100. 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.50. Fixed overhead costs per quarter: supervisory salaries $36,000; depreciation $17,000; and maintenance $13,000. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...