Question
Bumblebee Company estimates that 315,600 direct labor hours will be worked during the coming year, 2017, in the Packaging Department. On this basis, the budgeted
Bumblebee Company estimates that 315,600 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 $88,800 Indirect labor $145,176 Depreciation 70,080 Indirect materials 69,432 Insurance 29,040 Repairs 31,560 Rent 25,440 Utilities 63,120 Property taxes 21,840 Lubricants 15,780 $235,200 $325,068 It is estimated that direct labor hours worked each month will range from 25,700 to 32,000 hours. During October, 25,700 direct labor hours were worked and the following overhead costs were incurred. Fixed overhead costs: Supervision $7,400, Depreciation $5,840, Insurance $2,380, Rent $2,120, and Property taxes $1,820. Variable overhead costs: Indirect labor $12,792, Indirect materials, $5,234, Repairs $2,520, Utilities $5,450, and Lubricants $1,575. (a) Prepare a monthly manufacturing overhead flexible budget for each increment of 2,100 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 Entry field with correct answer Entry field with correct answer 25700 Entry field with correct answer 27800 Entry field with correct answer 29900 Entry field with correct answer 32000 Entry field with correct answer Entry field with correct answer $Entry field with correct answer 11822 $Entry field with correct answer 12788 $Entry field with correct answer 13754 $Entry field with correct answer 14720 Entry field with correct answer Entry field with correct answer 5654 Entry field with correct answer 6116 Entry field with correct answer 6578 Entry field with correct answer 7040 Entry field with correct answer Entry field with correct answer 2570 Entry field with correct answer 2780 Entry field with correct answer 2990 Entry field with correct answer 3200 Entry field with correct answer Entry field with incorrect answer 5654 Entry field with incorrect answer 6116 Entry field with incorrect answer 6578 Entry field with incorrect answer 7040 Entry field with correct answer Entry field with incorrect answer 1799 Entry field with incorrect answer 1946 Entry field with incorrect answer 2093 Entry field with incorrect answer 2240 Entry field with correct answer Entry field with incorrect answer 27499 Entry field with incorrect answer 29746 Entry field with incorrect answer 31993 Entry field with incorrect answer 34240 Entry field with correct answer Entry field with correct answer Entry field with correct answer 7400 Entry field with correct answer 7400 Entry field with correct answer 7400 Entry field with correct answer 7400 Entry field with correct answer Entry field with correct answer 5840 Entry field with correct answer 5840 Entry field with correct answer 5840 Entry field with correct answer 5840 Entry field with correct answer Entry field with correct answer 2420 Entry field with correct answer 2420 Entry field with correct answer 2420 Entry field with correct answer 2420 Entry field with correct answer Entry field with correct answer 2120 Entry field with correct answer 2120 Entry field with correct answer 2120 Entry field with correct answer 2120 Entry field with correct answer Entry field with correct answer 1820 Entry field with correct answer 1820 Entry field with correct answer 1820 Entry field with correct answer 1820 Entry field with correct answer Entry field with correct answer 19600 Entry field with correct answer 19600 Entry field with correct answer 19600 Entry field with correct answer 19600 Entry field with correct answer $Entry field with incorrect answer 47099 $Entry field with incorrect answer 49346 $Entry field with incorrect answer 51593 $Entry field with incorrect answer 53840 (b) Prepare a flexible budget report for October. (List variable costs before fixed costs.) BUMBLEBEE COMPANY Packaging Department Manufacturing Overhead Flexible Budget Report For the Month Ended October 31, 2017 Difference Budget Actual Costs Favorable Unfavorable Neither Favorable nor Unfavorable Entry field with correct answer Entry field with correct answer 25700 Entry field with correct answer 25700 Entry field with correct answer Entry field with incorrect answer $Entry field with correct answer 11822 $Entry field with correct answer 12792 $Entry field with correct answer 970 Entry field with correct answer Entry field with correct answer Entry field with correct answer 5654 Entry field with correct answer 5234 Entry field with correct answer 420 Entry field with correct answer Entry field with correct answer Entry field with correct answer 2570 Entry field with correct answer 2520 Entry field with correct answer 50 Entry field with correct answer Entry field with correct answer Entry field with incorrect answer 5654 Entry field with correct answer 5450 Entry field with incorrect answer 204 Entry field with correct answer Entry field with correct answer Entry field with incorrect answer 1799 Entry field with correct answer 1575 Entry field with incorrect answer 224 Entry field with correct answer Entry field with correct answer Entry field with incorrect answer 27499 Entry field with incorrect answer 72571 Entry field with incorrect answer 72 Entry field with correct answer Entry field with correct answer Entry field with correct answer Entry field with correct answer 7400 Entry field with correct answer 7400 Entry field with correct answer 0 Entry field with incorrect answer Entry field with correct answer Entry field with correct answer 5840 Entry field with correct answer 5840 Entry field with correct answer 0 Entry field with incorrect answer Entry field with correct answer Entry field with correct answer 2420 Entry field with correct answer 2380 Entry field with correct answer 40 Entry field with correct answer Entry field with correct answer Entry field with correct answer 2120 Entry field with correct answer 2120 Entry field with correct answer 0 Entry field with incorrect answer Entry field with correct answer Entry field with correct answer 1820 Entry field with correct answer 1820 Entry field with correct answer 0 Entry field with incorrect answer Entry field with correct answer Entry field with correct answer 19600 Entry field with correct answer 19560 Entry field with correct answer 40 Entry field with correct answer Entry field with correct answer $Entry field with incorrect answer 47099 $Entry field with incorrect answer 92131 $Entry field with incorrect answer 45032 Entry field with incorrect answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started