Question

In: Accounting

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

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

Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000.

Direct labor quantity standard is 1.5 direct labor hours per unit.

Variable overhead costs per direct labor hour total to $2.50.

Fixed overhead costs per quarter total to $62,000

Instructions

a. Prepare the manufacturing overhead budget for 2017 by quarters.

b.What is the pre-determined FOH rate based on direct labor hours?

c. How much fixed overhead will be applied in the first quarter?

Solutions

Expert Solution

Ans.(a) Ajanta Company
Manufacturing Overhead Budget
For the year 2017
Qtr.1 Qtr.2 Qtr.3 Qtr.4
Units Produced 10000 12000 14000 16000
Standard hours of direct labor hours per unit 1.5 1.5 1.5 1.5
Total Standard hours of direct labor hours per unit manufactured 15000 18000 21000 24000
Variable overhead cost per direct labor hours $         2.50 $          2.50 $         2.50 $        2.50
       Total variable overhead cost $    37,500 $     45,000 $    52,500 $    60,000
Add: Fixed overhead cost per Quarter 62000 62000 62000 62000
Total Manufacturing Overhead cost $    99,500 $   107,000 $ 114,500 $ 122,000
Ans.(b) Predetermined manufacturing overhead rate = Total estimated manufacturing overhead costs / Total estimated direct labor cost
Qtr.1 Qtr.2 Qtr.3 Qtr.4
Total Manufacturing Overhead cost $      99,500 $     107,000 $ 114,500 $   122,000
/ Total Standard hours of direct labor hours per unit manufactured          15,000            18,000         21,000         24,000
Pre-determined overhead rate $           6.63 $            5.94 $         5.45 $          5.08
Ans.(c) Fixed overhead applied = Total fixed overhead cost in quarter 1 / Total units produced
= $62,000 / 10,000
= $6.20

Related Solutions

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,500, 12,400, 14,700, 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.30; and maintenance $0.60. Fixed overhead costs per quarter: supervisory salaries $36,820; depreciation $18,270; and maintenance $14,100. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...
tlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following....
tlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following. Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000. 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.50. Fixed overhead costs per quarter: supervisory salaries $35,000; depreciation $15,000; and maintenance $12,000. Prepare the manufacturing overhead budget for the year, showing quarterly data
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,100, 12,300, 14,500, 16,200. Direct labor: Time is 1.5 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 $38,410; depreciation $19,790; and maintenance $14,080. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate...
E21-11  prepare a manufacturing overhead budget for the year Atlanta Company is preparing its manufacturing overhead budget...
E21-11  prepare a manufacturing overhead budget for the year Atlanta Company is preparing its manufacturing overhead budget for 2017.  Relevant data consist of the following. Units to be produced (by quarters):  10,000, 12,000, 14,000, 16,000. Direct labor: time is 1.5 hour per unit. Variable overhead costs per direct labor hour:  indirect materials $0.80; indirect labor $1.20; and maintenance $0.50. Fixed overhead costs per quarter:  supervisory salaries $35,000; depreciation $15,000; and maintenance $12,000. Instructions Prepare the manufacturing overhead budget for the year; showing quarterly data. ATLANTA...
1A . Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its...
1A . Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales:Sales for the year are expected to total 1,000,000 units. Quarterly sales are 20%, 25%,25%,and 30% respectively.The sales price is expected to be $40 per unit for the first three quartersand $45 per unit beginning in the fourth quarter.Sales in the first quarter of 2018 are expected to be 20% higher than the budgeted sales...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production,...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,000,000 units. Quarterly sales are 18%, 23%, 23%, and 36%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production,...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,900,000 units. Quarterly sales are 22%, 26%, 27%, and 25%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $44 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 15% higher...
RiverbedCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and...
RiverbedCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,400,000 units. Quarterly sales are 18%, 26%, 24%, and 32%, respectively. The sales price is expected to be $40 per unit for the first three quarters and $46 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.
  Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.Sales. Sales for the year are expected to total 1,700,000 units. Quarterly sales are 19%, 27%, 23%, and 31%, respectively. The sales price is expected to be $42 per unit for the first three quarters and $44 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 15% higher...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.
Do It! Review 21-2 Your answer is partially correct. Try again. Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 2,000,000 units. Quarterly sales are 22%, 26%, 27%, and 25%, respectively. The sales price is expected to be $40 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT