Bramble 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. Variable costs Rate per Direct Labor Hour Annual Fixed Costs Indirect labor $0.40 Supervision $44,400 Indirect materials 0.50 Depreciation 18,840 Factory utilities 0.30 Insurance 16,440 Factory repairs 0.23 Rent 27,120 The master overhead budget was prepared on the expectation that 482,100 direct labor hours will be worked during the year. In June, 40,300 direct labor hours were worked. At that level of activity, actual costs were as shown below. Variableper direct labor hour: indirect labor $0.44, indirect materials $0.49, factory utilities $0.32, and factory repairs $0.28. Fixed: same as budgeted. (a) & (b) (a) Prepare a monthly manufacturing overhead flexible budget for the year ending December 31, 2020, assuming production levels range from 35,300 to 51,800 direct labor hours. Use increments of 5,500 direct labor hours. (List variable costs before fixed costs.) BRAMBLE COMPANY Monthly Manufacturing Overhead Flexible Budget Ironing Department For the Year 2020 Select an opening budget item Select a budget item Enter a number of hours Enter a number of hours Enter a number of hours Enter a number of hours Select an opening name for section one Select a budget item $ Enter a dollar amount $ Enter a dollar amount $ Enter a dollar amount $ Enter a dollar amount Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a closing name for section one Enter a total amount for section one Enter a total amount for section one Enter a total amount for section one Enter a total amount for section one Select an opening name for section two Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a budget item Enter a dollar amount Enter a dollar amount Enter a dollar amount Enter a dollar amount Select a closing name for section two Enter a total amount for section two Enter a total amount for section two Enter a total amount for section two Enter a total amount for section two Select a closing budget item $ Enter a total amount for this budget $ Enter a total amount for this budget $ Enter a total amount for this budget $ Enter a total amount for this budget (b) Prepare a budget report for June comparing actual results with budget data based on the flexible budget. (List variable costs before fixed costs.) BRAMBLE COMPANY Ironing Department Manufacturing Overhead Flexible Budget Report For the Month Ended June 30, 2020 Difference Budget Actual Costs Favorable Unfavorable Neither Favorable nor Unfavorable Select an opening budget report item Enter a number of hours Enter a number of hours Select an opening name for section one Select a budget report item $ Enter a dollar amount $ Enter a dollar amount $ Enter a dollar amount Select an option Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a closing name for section one Enter a total amount for section one Enter a total amount for section one Enter a total amount for section one Select an option Select an opening name for section two Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a budget report item Enter a dollar amount Enter a dollar amount Enter a dollar amount Select an option Select a closing name for section two Enter a total amount for section two Enter a total amount for section two Enter a total amount for section two Select an option Select a closing budget report item $ Enter a total amount for this budget $ Enter a total amount for this budget $ Enter a total amount for this budget Select an option