Question

Bumblebee Company estimates that 379,500 direct labor hours will be worked during the coming year, 2017,...

Bumblebee Company estimates that 379,500 direct labor hours will be worked during the coming year, 2017, in the Packaging Department. On this basis, the budgeted manufacturing overhead cost data are computed for the year.

Fixed Overhead Costs
Variable Overhead Costs
Supervision
$94,440
Indirect labor
$174,570
Depreciation
73,320
Indirect materials
75,900
Insurance
25,560
Repairs
53,130
Rent
21,120
Utilities
94,875
Property taxes
20,880
Lubricants
37,950
$235,320
$436,425


It is estimated that direct labor hours worked each month will range from 24,900 to 36,900 hours.

During October, 24,900 direct labor hours were worked and the following overhead costs were incurred.

Fixed overhead costs: Supervision $7,870, Depreciation $6,110, Insurance $2,095, Rent $1,760, and Property taxes $1,740.

Variable overhead costs: Indirect labor $12,544, Indirect materials, $4,500, Repairs $3,406, Utilities $6,545, and Lubricants $2,740.

(a) Prepare a monthly manufacturing overhead flexible budget for each increment of 4,000 direct labor hours over the relevant range for the year ending December 31, 2017. (List variable costs before fixed costs.)

BUMBLEBEE COMPANY
Packaging Department
Monthly Manufacturing Overhead Flexible Budget
For the Year 2017
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Activity Level
Depreciation
Direct Labor
Direct Labor Hours
Direct Materials
Fixed Costs
Indirect Labor
Indirect Materials
Insurance
Lubricants
Property Taxes
Rent
Repairs
Supervision
Total Costs
Total Fixed Costs
Total Variable Costs
Utilities
Variable Costs
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]


(b) Prepare a flexible budget report for October. (List variable costs before fixed costs.)

Homework Answers

Answer #1

Answer a.

Planning Budget:

Number of direct labor hours = 379,500

Indirect labor = $174,570
Indirect labor per direct labor hour = $174,570 / 379,500
Indirect labor per direct labor hour = $0.46

Indirect materials = $75,900
Indirect materials per direct labor hour = $75,900 / 379,500
Indirect materials per direct labor hour = $0.20

Repairs = $53,130
Repairs per direct labor hour = $53,130 / 379,500
Repairs per direct labor hour = $0.14

Utilities = $94,875
Utilities per direct labor hour = $94,875 / 379,500
Utilities per direct labor hour = $0.25

Lubricants = $37,950
Lubricants per direct labor hour = $37,950 / 379,500
Lubricants per direct labor hour = $0.10

Answer b.

Know the answer?
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
Similar Questions
Bumblebee Company estimates that 403,000 direct labor hours will be worked during the coming year, 2020,...
Bumblebee Company estimates that 403,000 direct labor hours will be worked during the coming year, 2020, in the Packaging Department. On this basis, the following budgeted manufacturing overhead cost data are computed for the year. Fixed Overhead Costs Variable Overhead Costs Supervision $94,920 Indirect labor $161,200 Depreciation 66,360 Indirect materials 112,840 Insurance 29,760 Repairs 80,600 Rent 29,400 Utilities 100,750 Property taxes 22,560 Lubricants 24,180 $243,000 $479,570 It is estimated that direct labor hours worked each month will range from 29,800...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows: Indirect labor $1.00 Indirect materials 0.70 Utilities 0.20 Fixed overhead costs per month are Supervision $4,100, Depreciation $1,900, and Property Taxes $700. The company believes it will normally operate in a range of 7,300–10,900 direct labor hours per month. Prepare a monthly manufacturing overhead flexible budget for 2017 for the expected range of activity, using...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.90 Utilities 0.40 Fixed overhead costs per month are Supervision $3,700, Depreciation $1,700, and Property Taxes $800. The company believes it will normally operate in a range of 5,700–9,300 direct labor hours per month. Assume that in July 2020, Myers Company incurs the following manufacturing overhead costs. Variable Costs Fixed...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.30 Indirect materials 0.80 Utilities 0.30 Fixed overhead costs per month are Supervision $4,300, Depreciation $2,000, and Property Taxes $600. The company believes it will normally operate in a range of 6,100–10,000 direct labor hours per month. Assume that in July 2020, Myers Company incurs the following manufacturing overhead costs. Variable Costs Fixed...
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,400, 12,100, 14,200, 17,000. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,850; depreciation $17,390; and maintenance $14,220. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows: Indirect labor $1.00 Indirect materials 0.50 Utilities 0.20 Fixed overhead costs per month are Supervision $3,500, Depreciation $1,000, and Property Taxes $500. The company believes it will normally operate in a range of 5,500–8,500 direct labor hours per month. Prepare a monthly manufacturing overhead flexible budget for 2020 for the expected range of activity, using...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows: Indirect labor $1.00 Indirect materials 0.50 Utilities 0.20 Fixed overhead costs per month are Supervision $3,500, Depreciation $1,000, and Property Taxes $500. The company believes it will normally operate in a range of 5,500–8,500 direct labor hours per month. Prepare a monthly manufacturing overhead flexible budget for 2020 for the expected range of activity, using...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.10 Indirect materials 0.70 Utilities 0.40 Fixed overhead costs per month are Supervision $3,600, Depreciation $1,800, and Property Taxes $800. The company believes it will normally operate in a range of 7,700–11,000 direct labor hours per month. Prepare a monthly manufacturing overhead flexible budget for 2017 for the expected range of activity, using...
Q2: Raney Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable...
Q2: Raney Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.20 Indirect materials 0.60 Utilities 0.50 Fixed overhead costs per month are: Supervision $4,000, Depreciation $1,500, and Property Taxes $800.The company believes it will normally operate in a range of 7,000–10,000 direct labor hours per month. Instructions Prepare a monthly manufacturing overhead flexible budget for 2010 for the expected range of activity,...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.50 Utilities 0.20 Fixed overhead costs per month are Supervision $4,500, Depreciation $1,600, and Property Taxes $700. The company believes it will normally operate in a range of 6,400–11,200 direct labor hours per month. Prepare a monthly manufacturing overhead flexible budget for 2017 for the expected range of activity, using...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT