Question

In: Accounting

Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...

Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows.

RATCHET COMPANY
Budget Report
Assembling Department
For the Month Ended August 31, 2020

Difference


Manufacturing Costs


Budget


Actual

Favorable
Unfavorable
Neither Favorable
nor Unfavorable

Variable costs
   Direct materials

$50,740

$49,740

$1,000

Favorable
   Direct labor

54,280

51,480

2,800

Favorable
   Indirect materials

25,960

26,260

300

Unfavorable
   Indirect labor

22,420

21,940

480

Favorable
   Utilities

14,750

14,580

170

Favorable
   Maintenance

5,900

6,120

220

Unfavorable
      Total variable

174,050

170,120

3,930

Favorable
Fixed costs
   Rent

10,000

10,000

–0–

Neither Favorable nor Unfavorable
   Supervision

18,200

18,200

–0–

Neither Favorable nor Unfavorable
   Depreciation

5,200

5,200

–0–

Neither Favorable nor Unfavorable
      Total fixed

33,400

33,400

–0–

Neither Favorable nor Unfavorable
Total costs

$207,450

$203,520

$3,930

Favorable

The monthly budget amounts in the report were based on an expected production of 59,000 units per month or 708,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 57,000 units were produced.

(a) State the total monthly budgeted cost formula. (Round cost per unit to 2 decimal places, e.g. 1.25.)

The formula is __________ + variable costs of $__________ per unit


(b) Prepare a budget report for August using flexible budget data. (List variable costs before fixed costs.)

(c) In September, 63,000 units were produced. Prepare the budget report using flexible budget data, assuming (1) each variable cost was 10% higher than its actual cost in August, and (2) fixed costs were the same in September as in August. (List variable costs before fixed costs.)

Solutions

Expert Solution

(a) Total monthly budgeted cost formula
Fixed Cost + Variable cost per unit
$33400+$2.95 per unit
(b) Budget Report for August using flexible budget data
Budget Actual Difference
Variable costs
Direct Materials $     49,020 $          49,740 Unfavourable
Direct Labor $     52,440 $          51,480 Favourable
Indirect Materials $     25,080 $          26,260 Unfavourable
Indrect Labor $     21,660 $          21,940 Unfavourable
Utilities $     14,250 $          14,580 Unfavourable
Maintenance $       5,700 $            6,120 Unfavourable
Total Variable $ 168,150 $      170,120 Unfavourable
Fixed Costs
Rent $     10,000 $          10,000 Neither Favourable nor unfavourable
Supervision $     18,200 $          18,200 Neither Favourable nor unfavourable
Depreciation $       5,200 $            5,200 Neither Favourable nor unfavourable
Total Fixed $    33,400 $        33,400 Neither Favourable nor unfavourable
Total Cost $ 201,550 $      203,520 Unfavourable
(c) Budget Report for September using flexible budget data
Budget Actual Difference
Variable costs
Direct Materials $     54,180 $          54,714 Unfavourable
Direct Labor $     57,960 $          56,628 Favourable
Indirect Materials $     27,720 $          28,886 Unfavourable
Indrect Labor $     23,940 $          24,134 Unfavourable
Utilities $     15,750 $          16,038 Unfavourable
Maintenance $       6,300 $            6,732 Unfavourable
Total Variable $ 185,850 $      187,132 Unfavourable
Fixed Costs
Rent $     10,000 $          10,000 Neither Favourable nor unfavourable
Supervision $     18,200 $          18,200 Neither Favourable nor unfavourable
Depreciation $       5,200 $            5,200 Neither Favourable nor unfavourable
Total Fixed $    33,400 $        33,400 Neither Favourable nor unfavourable
Total Cost $ 219,250 $      220,532 Unfavourable
* it is assumed that variable cost increases by 10% in totality and not per unit

Related Solutions

Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $53,760 $52,760 $1,000 Favorable    Direct labor 61,440 58,340 3,100 Favorable    Indirect materials 25,600 25,700 100 Unfavorable    Indirect labor 19,200 18,730 470 Favorable    Utilities 22,400 22,240 160 Favorable    Maintenance 7,680 7,940 260 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $53,760 $52,760 $1,000 Favorable    Direct labor 61,440 58,340 3,100 Favorable    Indirect materials 25,600 25,700 100 Unfavorable    Indirect labor 19,200 18,730 470 Favorable    Utilities 22,400 22,240 160 Favorable    Maintenance 7,680 7,940 260 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $53,760 $52,760 $1,000 Favorable    Direct labor 61,440 58,340 3,100 Favorable    Indirect materials 25,600 25,700 100 Unfavorable    Indirect labor 19,200 18,730 470 Favorable    Utilities 22,400 22,240 160 Favorable    Maintenance 7,680 7,940 260 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $54,600 $53,500 $1,100 Favorable    Direct labor 63,700 60,600 3,100 Favorable    Indirect materials 31,200 31,400 200 Unfavorable    Indirect labor 19,500 19,100 400 Favorable    Utilities 19,500 19,370 130 Favorable    Maintenance 7,800 8,010 210 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $50,740 $49,740 $1,000 Favorable    Direct labor 54,280 51,480 2,800 Favorable    Indirect materials 25,960 26,260 300 Unfavorable    Indirect labor 22,420 21,940 480 Favorable    Utilities 14,750 14,580 170 Favorable    Maintenance 5,900 6,120 220 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $52,460 $51,460 $1,000 Favorable    Direct labor 57,340 53,940 3,400 Favorable    Indirect materials 26,840 27,140 300 Unfavorable    Indirect labor 18,300 17,890 410 Favorable    Utilities 15,250 15,060 190 Favorable    Maintenance 6,100 6,350 250 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $50,020 $48,920 $1,100 Favorable    Direct labor 54,900 52,000 2,900 Favorable    Indirect materials 29,280 29,580 300 Unfavorable    Indirect labor 20,740 20,290 450 Favorable    Utilities 21,350 21,180 170 Favorable    Maintenance 7,320 7,590 270 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs    Direct materials $51,600 $50,600 $1,000 Favorable    Direct labor 56,400 53,600 2,800 Favorable    Indirect materials 28,800 29,000 200 Unfavorable    Indirect labor 22,800 22,380 420 Favorable    Utilities 15,000 14,860 140 Favorable    Maintenance 8,400 8,740 340 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling...
Ratchet Company uses budgets in controlling costs. The August 2020 budget report for the company’s Assembling Department is as follows. RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Manufacturing Costs Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Variable costs Direct materials $48,000 $47,000 $1,000 Favorable Direct labor 54,000 51,200 2,800 Favorable Indirect materials 24,000 24,200 200 Unfavorable Indirect labor 18,000 17,500 500 Favorable Utilities 15,000 14,900 100 Favorable Maintenance 12,000 12,400 400 Unfavorable...
Ratchet Company uses budgets in controlling costs. The August 2017 budget report for th Department is...
Ratchet Company uses budgets in controlling costs. The August 2017 budget report for th Department is as follows. Ratchet Company Budget Report Assembling Department For the Month Ended August 31, 2017    Difference Favorable F Manufacturing Cost                    Budget                           Actual                          Unfavorable U Variable costs Direct materials                         $ 48,000                        47,000                            $1,000 F Direct labor                                  54,000                         51,200                               2,800 F Indirect materials                         24,000                        24,200                                 200 U Indirect labor                               18,000                         17,500                                 500 F Utilities                                         15,000                         14,900                                 100 F Maintenance                                12,000                         12,400                                 400 U Total variable                              171,000                      167,200                               3,800 F Fixed costs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT