RATCHET COMPANY Budget Report Assembling Department For the Month Ended August 31, 2020 Difference Favorable Unfavorable Neither Favorable Manufacturing Costs Budget Actual 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 Total variable 171,000 167,200 3,800 Favorable Fixed costs Rent 12,000 12,000 -0 Neither Favorable nor Unfavorable Supervision 17,000 17,000 -O- Neither Favorable nor Unfavorable Depreciation 6,000 6,000 -O- Neither Favorable nor Unfavorable Total fixed 35,000 35,000 -0 Neither Favorable nor Unfavorable Total costs $206,000 $202,200 $3,800 Favorable 10 The monthly budget amounts in the report were based on an expected production of 60,000 units per month or 720,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 The monthly budget amounts in the report were based on an expected production of 60,000 units per month or 720,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 58,000 units were produced. Part 1 (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.) RATCHET COMPANY Assembling Department Flexible Budget Report For the Month Ended August 31, 2020 Dif Fay Unfi Neithe nor UI Budget Actual Costs Neither Favorable nor Unfavorable Budget Actual Costs $ $ $ $ $ $