plese complete in the same format

Problem 23-2A a-b, d (Video) Sheffield Company manufactures tablecloths Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2020. The following data were used in developing the master manufacturing overhead budget for the Ironing Department, which is based on an activity index of direct labor hours. Rate per Direct Variable costs Labor Hour Annual Fixed Costs Indirect labor $0.43 Supervision $42,240 Indirect materials 0.51 Depreciation 15,600 Factory utilities 0.34 Insurance 15,960 Factory repairs 0.20 Rent 23,280 The master overhead budget was prepared on the expectation that 477,800 direct labor hours will be worked during the year. In June, 43,300 direct labor hours were worked. At that level of activity, actual costs were as shown below Variable per direct labor hours indirect labor $0.47, indirect materials 50.49, factory Utilities $0.38, and factory repairs $0.24 Fixed: same as budgeted (a) Prepare a monthly manufacturing overhead Plexible budget for the year ending December 31, 2020, assuming production levels range from 37,400 to 55,100 direct labor hours. Use increments of 5.900 direct labor hours. (List variable costs before fixed costs.) SHEFFIELD COMPANY Monthly Manufacturing Overhead Flexible Budget Ironing Department For the Year 2020 . $ (b) Prepare a budget report for June comparing actual results with budget data based on the flexible budget. (List variable costs before fixed costs.) SHEFFIELD COMPANY Ironing Department Manufacturing Overhead Flexible Budget Report For the Month Ended June 30, 2020 Difference Favorable Unfavorable Neither Favorable Budget Actual Costs nor Unfavorable $ 4 . State the formula for computing the total budgeted costs for the Ironing Department (Round variable cost per unit to 2 decimal places, e.g. 1.55.) The formula is total fixed costs + variable costs of per direct labor hour. Click if you would like to show Work for this question: Open Show Work LINK TO TEXT VIDEO SIMILAR