Question

In: Accounting

Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...

Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.10 Direct labor 1.54 Variable overhead: Supplies 0.23 Maintenance 0.19 Power 0.17 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $77,000, and other overhead of $248,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. Round your answers to the nearest cent, if required.

What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.)

What if Nashler Company’s cost of maintenance rose to $0.22 per unit? How would that affect the unit product costs calculated in Requirement 2? If required, round your answer to the nearest cent.

Solutions

Expert Solution

Answer:

1.
Flexible budget is budget which changes with volume of activity
Nashler company
Flexible Budget
Variable cost per unit Range of production in Units 160,000 Range of production in Units 170,000 Range of production in Units 175,000
Production costs:
Variable:
Direct materials $7.10 $1,136,000 $1,207,000 $1,242,500
Direct labor $1.54 $246,400 $261,800 $269,500
Variable overhead:
Supplies $0.23 $36,800 $39,100 $40,250
Maintenance $0.19 $30,400 $32,300 $33,250
Power $0.17 $27,200 $28,900 $29,750
Total variable costs $9.23 $1,476,800 $1,569,100 $1,615,250
Fixed overhead:
Supervision $98,000 $98,000 $98,000
Depreciation $77,000 $77,000 $77,000
Other overhead $248,000 $248,000 $248,000
Total fixed costs $423,000 $423,000 $423,000
Total production costs $1,899,800 $1,992,100 $2,038,250
The fixed costs under flexible budget would remain same as budgeted and only variable costs would vary with range of production levels.
2.
Calculation of per unit total product costs for each of the production levels
Production costs $1,899,800 $1,992,100 $2,038,250
Range of production 160000 170000 175000
Cost per unit $11.87 $11.72 $11.65
3.
Maintenance costs is variable costs which varies with units produced and so increase in maintenance costs to 0.22 per unit would increase the unit product costs by 0.03 per unit (0.22-0.19)

Related Solutions

Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead: Supplies 0.23 Maintenance 0.19 Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. Round your answers to the nearest...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.10 Direct labor 1.54 Variable overhead:   Supplies 0.23   Maintenance 0.19   Power 0.17 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $77,000, and other overhead of $242,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. Round your answers to the nearest...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.10 Direct labor 1.54 Variable overhead:   Supplies 0.23   Maintenance 0.19   Power 0.17 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $77,000, and other overhead of $242,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. Round your answers to the nearest...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead: Supplies 0.23 Maintenance 0.19 Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. In March, Nashler Company produced 170,000 units and had the following actual costs: Direct materials $1,220,000 Direct labor 268,300 Supplies 39,600 Maintenance 32,250 Power 30,520 Supervision 99,400 Depreciation 76,000 Other...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per...
Flexible Budget for Varying Levels of Activity Nashler Company has the following budgeted variable costs per unit produced: Direct materials $7.20 Direct labor 1.54 Variable overhead: Supplies 0.23 Maintenance 0.19 Power 0.18 Budgeted fixed overhead costs per month include supervision of $98,000, depreciation of $76,000, and other overhead of $245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. Round your answers to the nearest...
Flexible Budget with Different Levels of Production Bowling Company budgeted the following amounts: Variable costs of...
Flexible Budget with Different Levels of Production Bowling Company budgeted the following amounts: Variable costs of production:      Direct materials 3 pounds @ $0.60 per pound      Direct labor 0.5 hr. @ $16.00 per hour      VOH 0.5 hr. @ $2.20 FOH:      Materials handling $6,200      Depreciation $2,600 Required: Prepare a flexible budget for 2,500 units, 3,000 units, and 3,500 units. Bowling Company Flexible Budget 2,500 units 3,000 units 3,500 units Direct materials $ $ $ Direct labor Variable overhead Fixed overhead: Materials handling...
How to prepare a flexible budget for different levels of activity
How to prepare a flexible budget for different levels of activity
A flexible budget seeks to overcome the problem of differing levels of activity between budget and...
A flexible budget seeks to overcome the problem of differing levels of activity between budget and actual output volumes. A new ‘flexed’ budget is prepared at the actual output level to be used for variance analysis purposes. A simple example could be the budget given to you to grade test papers of 30 minutes per paper for 10 students = 300 minutes. If only 8 students sit the test your budget will be flexed to 240 minutes (8 x 30).)...
MOCKTOE INC. Flexible Budget Cost Formula (per toaster) Activity (toasters) 110000 120000 130000 Variable costs: Total...
MOCKTOE INC. Flexible Budget Cost Formula (per toaster) Activity (toasters) 110000 120000 130000 Variable costs: Total variable costs $0.00 $0 $0 $0 Fixed costs: Total fixed costs $0 $0 $0 Total costs $0 $0 $0 ToasToe Inc. (TI) is a manufacturer of heating elements for toaster overs. To improve control over operations, the president wants to install a flexible budgeting system, rather than the single master budget being used at present. The following data are available for expected costs for...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $60,000 per year (A total of 9,000 welding hours are supplied by the six workers.) • Welding supplies: $300 per job • Welding hours: 3 hours used per job...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT