Problem 23-6A a-d (Video) (Part Level Submission) Coronado Company uses a responsibility reporting system. It has divisions in Denver, Seattle, and San Diego. Each division has three production departments: Cutting, Shaping, and Finishing. The responsibility for each department rests with a manager who reports to the division productiorn manager. Each division manager reports to the vice president of production. There are also vice presidents for marketing and finance. All vice presidents report to the president. In January 2020, controllable actual and budget manufacturing overhead cost data for the departments and divisions were as shown below Manufacturing Overhead Actual Budget Individual costs-Cutting Department-Seattle Indirect labor Indirect materials Maintenance Utilities Supervision $73,200 $69,900 45,900 17,600 16,700 19,800 $184,000 $169,900 48,200 20,600 20,000 22,000 Total costs $148,800 204,000 672,600 715,200 Shaping Department-Seattle $158,300 210,700 678,200 721,700 Finishing Department-Seattle Denver division San Diego divisiorn Additional overhead costs were incurred as follows: Seattle division production manager-actual costs $52,100, budget $51,100; vice president of production-actual costs $65,200, budget $63,500; president-actual costs $75,900, budget $74,700. These expenses are not allocated The vice presidents who report to the president, other than the vice president of production, had the following expenses Vice President Marketing Finance Actual Budget $133,500 108,900 $130,000 105,000 (a1) Prepare the Manufacturing overhead-Cutting Department manager-Seattle division responsibility report. To Cutting Department Manager-Seattle Division Month: January Favorable Unfavorable Neither Favorable nor Unfavorable Controllable Costs: Budget Actual Total (a2) Prepare the Manufacturing overhead-Seattle division manager responsibility report. To Division Production Ma ttle Month: January Favorable Unfavorable Neither Favorable nor Unfavorable Controllable Costs: Seattle Division Departments Budget Actual Total Determine the percentage by which the actual costs of each of the Seattle departments are different from the budgeted costs. Then rank the comparative performance of the department managers in the Seattle Division based upon these percentages. (Round answers to 1 decimal place, e.g. 1.5%.) Ranking (a3) Prepare the Manufacturing overhead-vice president of production responsibility report. To Vice President-Production Month: January Favorable Unfavorable Neither Favorable nor Unfavorable Controllable Costs Budget Actual V-P Production Divisions: Total Rank the comparative performances of division managers Ranking (a4) Prepare the Manufacturing overhead and expenses-president responsibility report. To President Month: January Favorable Unfavorable Neither Favorable nor Unfavorable Actual Controllable Costs: President Vice-Presidents: Budget Total Determine the percentage by which the actual costs of each of the vice presidents' are different from the budgeted costs. Then rank the comparative performance of the vice presidents based upon these percentages. (Round answers to 1 decimal place, e.g. 1.5%.) Ranking