Problem 24-3A (Part Level Submission) Ratchet Company uses budgets in controllin
ID: 2436891 • Letter: P
Question
Problem 24-3A (Part Level Submission) 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 For the Month Ended August 31, 2017 Unfavorable Neither Favorable Ma Variable costs Direct materials $56,320 $55,320 $1,000 Favorable Direct labor Indirect materials 29,440 29,640 200 Unfavorable Indirect labor Utilities 61,440 58,64O 2,800 Favorable 21,760 21,330 430 Favorable 16,000 15,900 100 Favorable 8,960 9,220 260 Unfavorable Total variable 193.920 190,050 3,870 Favorable Fixed costs 12,500 12,500 0-Neither Favorable nor Unfavorable 17,600 17,600Neither Favorable nor Unfavorable 6,800 6,800-0 Neither Favorable nor Unfavorable 36,900 36,900 Neither Favorable nor Unfavorable Total fixed Total costs $230,820 S226,950 $3,870 Favorable 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) Your answer is correct. (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.) 36,900variable costs of $ 3.03 per unit.Explanation / Answer
Answers
Total costs for 64000 units
Unit cost based on 64000 units
Total cost for flexible budget for 68000 units
[A = given]
[B = A/64000]
[C = B x 68000]
Variable Costs:
Direct Materials
$ 56,320.00
$ 0.88
$ 59,840.00
Direct Labor
$ 61,440.00
$ 0.96
$ 65,280.00
Indirect Materials
$ 29,440.00
$ 0.46
$ 31,280.00
Indirect Labor
$ 21,760.00
$ 0.34
$ 23,120.00
Utilities
$ 16,000.00
$ 0.25
$ 17,000.00
Maintenance
$ 8,960.00
$ 0.14
$ 9,520.00
Total Variable cost
$ 193,920.00
$ 3.03
$ 206,040.00
Actual Costs for August
Actual cost for September
Units
62,000
68,000
Variable Costs:
Direct Materials
$ 55,320.00
$ 60,852.00
Direct Labor
$ 58,640.00
$ 64,504.00
Indirect Materials
$ 29,640.00
$ 32,604.00
Indirect Labor
$ 21,330.00
$ 23,463.00
Utilities
$ 15,900.00
$ 17,490.00
Maintenance
$ 9,220.00
$ 10,142.00
Total Variable cost
$ 190,050.00
$ 209,055.00
Budget
Actual Costs
Difference
Units
$ 68,000.00
$ 68,000.00
Variable Costs:
Direct Materials
$ 59,840.00
$ 60,852.00
$ 1,012.00
Unfavourable
Direct Labor
$ 65,280.00
$ 64,504.00
$ 776.00
Favourable
Indirect Materials
$ 31,280.00
$ 32,604.00
$ 1,324.00
Unfavourable
Indirect Labor
$ 23,120.00
$ 23,463.00
$ 343.00
Unfavourable
Utilities
$ 17,000.00
$ 17,490.00
$ 490.00
Unfavourable
Maintenance
$ 9,520.00
$ 10,142.00
$ 622.00
Unfavourable
Total Variable cost
$ 206,040.00
$ 209,055.00
$ 3,015.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
$ 242,940.00
$ 245,955.00
$ 3,015.00
Unfavourable
Total costs for 64000 units
Unit cost based on 64000 units
Total cost for flexible budget for 68000 units
[A = given]
[B = A/64000]
[C = B x 68000]
Variable Costs:
Direct Materials
$ 56,320.00
$ 0.88
$ 59,840.00
Direct Labor
$ 61,440.00
$ 0.96
$ 65,280.00
Indirect Materials
$ 29,440.00
$ 0.46
$ 31,280.00
Indirect Labor
$ 21,760.00
$ 0.34
$ 23,120.00
Utilities
$ 16,000.00
$ 0.25
$ 17,000.00
Maintenance
$ 8,960.00
$ 0.14
$ 9,520.00
Total Variable cost
$ 193,920.00
$ 3.03
$ 206,040.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.