Ratchet Company uses budgets in controlling costs. The August 2017 budget report
ID: 2436822 • Letter: R
Question
Ratchet Company uses budgets in controlling costs. The August 2017 budget report for the company's Assembling Department is as follows RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2017 Difference Favorable Unfavorable Neither Favorable nor Unfavorable Manufacturing Costs Budget Actual Variable costs Direct materials Direct labor Indirect materials Indirect labor Utilities Maintenance $56,320 $55,320 $1,000 Favorable 61,440 58,640 2,800 Favorable 29,440 29,640 200 Unfavorable 21,760 21,330 430 Favorable 16,000 15,900 100 Favorable 8,9609220 9.220 260 Unfavorable Total variable 193,920 190,050 3,870 Favorable Fixed costs Rent Supervision Depreciation 12,500 12,500 0 Neither Favorable nor Unfavorable 17,600 17,600 0 Neither Favorable nor Unfavorable -0- Neither Favorable nor Unfavorable -0- Neither Favorable nor Unfavorable 6,800 36,900 36,900 6,800 Total fixed Total costs $230,820 $226,950 $3,870 Favorabl The monthly budget amounts in the report were based on an expected production of 64,000 units per month or 768,000 units per year. The Assembling Department manager is pleased with the report and expects a raise, or at least praise for a job well done. The company president, however, is unhappy with the results for August because only 62,000 units were produced (a) & (b) (a) State the total monthly budgeted cost formula. (Round cost per unit to 2 decimal places, e.g. 1.25.) The formula is - $ (b) Prepare a budget report for August using flexible budget data. (List variable costs before fixed costs.) + variable costs of $ per unit.Explanation / Answer
Answers
Total costs for 64000 units
Unit cost based on 64000 units
Total cost for flexible budget for 62000 units
[A = given]
[B = A / 64000]
[C = B x 62000]
Variable Costs:
Direct Materials
$ 56,320.00
$ 0.88
$ 54,560.00
Direct Labor
$ 61,440.00
$ 0.96
$ 59,520.00
Indirect Materials
$ 29,440.00
$ 0.46
$ 28,520.00
Indirect Labor
$ 21,760.00
$ 0.34
$ 21,080.00
Utilities
$ 16,000.00
$ 0.25
$ 15,500.00
Maintenance
$ 8,960.00
$ 0.14
$ 8,680.00
Total Variable cost
$ 193,920.00
$ 3.03
$ 187,860.00
Cost formula = Fixed cost + Variable cost per unit x No. of Units
The formula = $ 36,900 + Variable cost of $ 3.03 per unit [calculated above]
Budget
Actual Costs
Difference
Units
$ 62,000.00
$ 62,000.00
Variable Costs:
Direct Materials
$ 54,560.00
$ 55,320.00
$ 760.00
Unfavourable
Direct Labor
$ 59,520.00
$ 58,640.00
$ 880.00
Favourable
Indirect Materials
$ 28,520.00
$ 29,640.00
$ 1,120.00
Unfavourable
Indirect Labor
$ 21,080.00
$ 21,330.00
$ 250.00
Unfavourable
Utilities
$ 15,500.00
$ 15,900.00
$ 400.00
Unfavourable
Maintenance
$ 8,680.00
$ 9,220.00
$ 540.00
Unfavourable
Total Variable cost
$ 187,860.00
$ 190,050.00
$ 2,190.00
Unfavourable
Fixed Costs:
Rent
$ 12,500.00
$ 12,500.00
$ -
Neither F nor U
Supervision
$ 17,600.00
$ 17,600.00
$ -
Neither F nor U
Depreciation
$ 6,800.00
$ 6,800.00
$ -
Neither F nor U
Total Fixed Costs
$ 36,900.00
$ 36,900.00
$ -
Neither F nor U
Total Costs
$ 224,760.00
$ 226,950.00
$ 2,190.00
Unfavourable
Total costs for 64000 units
Unit cost based on 64000 units
Total cost for flexible budget for 62000 units
[A = given]
[B = A / 64000]
[C = B x 62000]
Variable Costs:
Direct Materials
$ 56,320.00
$ 0.88
$ 54,560.00
Direct Labor
$ 61,440.00
$ 0.96
$ 59,520.00
Indirect Materials
$ 29,440.00
$ 0.46
$ 28,520.00
Indirect Labor
$ 21,760.00
$ 0.34
$ 21,080.00
Utilities
$ 16,000.00
$ 0.25
$ 15,500.00
Maintenance
$ 8,960.00
$ 0.14
$ 8,680.00
Total Variable cost
$ 193,920.00
$ 3.03
$ 187,860.00
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.