Question
In: Accounting
P11.51B Prepare a flexible budget, budget report, and graph for manufacturing overhead. (LO 2, 3) Finesse...
P11.51B
Prepare a flexible budget, budget report, and graph for manufacturing overhead.
(LO 2, 3) Finesse Company manufactures tablecloths. Sales have grown rapidly over the past two years. As a result, the president has installed a budgetary control system for 2020. The following data were used in developing the master manufacturing overhead budget for the ironing department. The budget is based on an activity index of direct labour hours.
|
Variable Costs |
Rate per Direct Labour Hour |
Annual Fixed Costs |
|
|---|---|---|---|
|
Indirect labour |
$0.50 |
Supervision |
$45,000 |
|
Indirect materials |
0.75 |
Depreciation |
20,000 |
|
Factory utilities |
0.45 |
Insurance |
15,000 |
|
Factory repairs |
0.25 |
Rent |
30,000 |
The company prepared the master overhead budget on the expectation that 600,000 direct labour hours would be worked during the year. In June, 48,000 direct labour hours were worked. At that level of activity, actual costs were as follows:
- 1.Variable, per direct labour hour—indirect labour $0.53; indirect materials $0.70; factory utilities $0.47; and factory repairs $0.29.
- 2.Fixed—same as budgeted.
Instructions
a.
Prepare a monthly flexible manufacturing overhead budget for the year ending December 31, 2020, assuming production levels range from 35,000 to 50,000 direct labour hours per month. Use increments of 5,000 direct labour hours.
Total costs: 35,000 DLH, $77,417; 50,000 DLH, $106,667
b.
Prepare a budget performance report for June, comparing actual results with budgeted data based on the flexible budget.
Budget $102,767; Actual $104,687
c.
Were costs effectively controlled? Explain.
d.
State the formula for calculating the total budgeted costs for Finesse Company.
e.
Prepare a flexible budget graph, showing total budgeted costs at 35,000 and 45,000 direct labour hours. Use increments of 5,000 direct labour hours on the horizontal axis and increments of $10,000 on the vertical axis.
Solutions
Expert Solution
a.
| Finess
Company Flexible Manufacturing Overhead Budget For June 2020 |
||||
| Activity Level ( direct labor hours ) | 35,000 | 40,000 | 45,000 | 50,000 |
| Variable Costs | ||||
| Indirect Labor | $ 17,500 | $ 20,000 | $ 22,500 | $ 25,000 |
| Indirect Materials | 26,250 | 30,000 | 33,750 | 37,500 |
| Factory Utilities | 15,750 | 18,000 | 20,250 | 22,500 |
| Factory Repairs | 8,750 | 10,000 | 11,250 | 12,500 |
| Total Variable Costs | $ 68,250 | 78,000 | 87,750 | 97,500 |
| Fixed Costs | ||||
| Supervision | 45,000 | 45,000 | 45,000 | 45,000 |
| Depreciation | 20,000 | 20,000 | 20,000 | 20,000 |
| Insurance | 15,000 | 15,000 | 15,000 | 15,000 |
| Rent | 30,000 | 30,000 | 30,000 | 30,000 |
| Total Fixed Costs | $ 110,000 | $ 110,000 | $ 110,000 | $ 110,000 |
| Total Manufacturing Overhead | $ 178,250 | $ 188,000 | $ 197,750 | $ 207,500 |
b.
| Finess
Company Flexible Budget Performance Report : Manufacturing Overhead For June 2020 |
|||
| Budget | Actuals | Variance | |
| Activity Level ( direct labor hours ) | 48,000 | 48,000 | |
| Variable Manufacturing Overhead | |||
| Indirect Labor | $ 24,000 | $ 25,440 | $ 1,440 U |
| Indirect Materials | 36,000 | 33,600 | 2,400 F |
| Factory Utilities | 21,600 | 22,560 | 960 U |
| Factory Repairs | 12,000 | 13,920 | 1,920 U |
| Total Variable Manufacturing Overhead | $ 93,600 | $ 95,520 | $ 1,920 U |
| Fixed Manufacturing Overhead | |||
| Supervision | $ 45,000 | $ 45,000 | None |
| Depreciation | 20,000 | 20,000 | None |
| Insurance | 15,000 | 15,000 | None |
| Rent | 30,000 | 30,000 | None |
| Total Fixed Manufacturing Overhead | $ 110,000 | $ 110,000 | None |
| Total Manufacturing Overhead | $ 203,600 | $ 205,520 | $ 19,20 U |
c. No.
d. Total cost = 1.95 q + $ 110,000
ekkarill92 answered 1 year agoRelated Solutions
E9-3 (Static) Preparing a Flexible Budget Performance Report [LO 9-2] Gleason Guitars produces acoustic guitars. The...
E9-3 (Static) Preparing a Flexible Budget Performance Report [LO 9-2] Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month of June (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance).)
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
$165,600
Power and light
5,760
Indirect materials
46,800
Total variable overhead
cost
$218,160
Fixed overhead cost:
Supervisory salaries
$76,360
Depreciation of plant and equipment
48,000
Insurance and property taxes
30,540
Total fixed overhead
cost
154,900
Total factory...
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 9,000 hours of
productive capacity in the department:
Variable overhead cost:
Indirect factory labor
$76,500
Power and light
2,790
Indirect materials
21,600
Total variable overhead
cost
$100,890
Fixed overhead cost:
Supervisory salaries
$35,310
Depreciation of plant and equipment
22,200
Insurance and property taxes
14,120
Total fixed overhead
cost
71,630
Total factory...
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 14,000 hours of
productive capacity in the department:
Variable overhead cost:
Indirect factory labor
$133,000
Power and light
6,440
Indirect materials
30,800
Total variable overhead
cost
$170,240
Fixed overhead cost:
Supervisory salaries
$59,580
Depreciation of plant and equipment
37,450
Insurance and property taxes
23,830
Total fixed overhead
cost
120,860
Total factory...
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 13,000 hours of
productive capacity in the department:
Variable overhead cost:
Indirect factory labor
$122,200
Power and light
4,160
Indirect materials
35,100
Total variable overhead
cost
$161,460
Fixed overhead cost:
Supervisory salaries
$56,510
Depreciation of plant and equipment
35,520
Insurance and property taxes
22,600
Total fixed overhead
cost
114,630
Total factory...
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 costs:
Indirect factory labor
$118,500
Power and light
6,900
Indirect materials
42,000
Total variable overhead
cost
$167,400
Fixed overhead costs:
Supervisory salaries
$58,590
Depreciation of plant and equipment
36,830
Insurance and property taxes
23,440
Total fixed overhead
cost
118,860
Total factory...
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 20,000 hours of
productive capacity in the department:
Variable overhead costs:
Indirect factory labor
$180,000
Power and light
12,000
Indirect materials
64,000
Total variable overhead
cost
$256,000
Fixed overhead costs:
Supervisory salaries
$ 80,000
Depreciation of plant and equipment
50,000
Insurance and property taxes
32,000
Total fixed overhead
cost
162,000
Total...
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 10,000 hours of
productive capacity in the department:
Variable overhead cost:
Indirect factory labor
$87,000
Power and light
4,400
Indirect materials
31,000
Total variable overhead
cost
$122,400
Fixed overhead cost:
Supervisory salaries
$42,840
Depreciation of plant and equipment
26,930
Insurance and property taxes
17,140
Total fixed overhead
cost
86,910
Total factory...
1) Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the...
1)
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
$158,400
Power and light
6,120
Indirect materials
46,800
Total variable overhead
cost
$211,320
Fixed overhead cost:
Supervisory salaries
$73,960
Depreciation of plant and equipment
46,490
Insurance and property taxes
29,580
Total fixed overhead
cost
150,030
Total...
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 9,000 hours of
productive capacity in the department:
Variable overhead costs:
Indirect factory labor
$87,300
Power and light
3,780
Indirect materials
27,000
Total variable overhead
cost
$118,080
Fixed overhead costs:
Supervisory salaries
$41,330
Depreciation of plant and equipment
25,980
Insurance and property taxes
16,530
Total fixed overhead
cost
83,840
Total factory...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella Co.,...
- Parallel Arrays This question is in MindTap Cengage Summary In this lab, you use what you...
- 5. You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella...
- JAVA Write a test program that prompts the user to enter a series of integers and...
- (2) Cite an example on how organizations like Google, Facebook, Youtube etc collect data for image...
- The legal landscape is perpetually changing. Psychologists must remain abreast of these changes to avoid potentially...
- We are evaluating a project that costs $1.68 million, has a six-year life, and has no...
ADVERTISEMENT