-r 25 Question 2 of 2 17.34/50 Bridgeport Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2022. 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 Supervision $43,680 Indirect labor $0.40 Indirect materials 0.51 Depreciation 17,160 0.34 Insurance 12,480 Factory utilities Factory repairs 0.24 Rent 23,040 The master overhead budget was prepared in the expectation that 484,200 direct labor hours will be worked during the year. In June, 38,600 direct labor hours were worked. At that level of activity, actual costs were as shown below. Variable-per direct labor hour: indirect labor $0.43, indirect materials $0.50, factory utilities $0.38, and factory repairs $0.29. Fixed: same as budgeted. (a) Prepare a monthly manufacturing overhead flexible budget for the year ending December 31, 2022, assuming production levels range from 42,400 to 57.400 direct labor hours. Use increments of 5.000 direct labor hours (list variable costs before friend costs.) BRIDGEPORT COMPANY Monthly Manufacturing Overhead Flexible Budget Ironing Department For the Year 2022 Activity Level 42.400 Direct Labor Hours 47400 52100 Variable Costs $ 16900 18960 $ 20160 Indirect Labor 24174 26724 Indirect Materials 21624 16116 1716 14416 Factory Utilities 11376 12576 10176 Factory Flepairs 70026 7076 63176 Total Variable costs Factory Out 14616 16116 106 Factory 11376 12578 Tots Variable Couts 63176 TO Fixed Con Supervision 543.00 145650 Directions 17160 1240 rence POOOOO 00000 0000!! 23010 23040 9300 Todos 159536 TotalCout Prepare a budget report for one comparing actual results with big data based on the ble budget. (Livio before the costs BRIDGEPORT COMPANY (b) Prepare a budget report for June comparing actual results with budget dita based on the flexible budget is variable costs before fred costs) BRIDGEPORT COMPANY Ironing Department Manufacturing Overhead Flexible Budget Report For the Month Ended June 10, 2002 F Un Neith nor Budget Actual Costs 36600 Checator Hours 38800 Variable costs 10590 1351 15640 Indirea Labor 10300 1966 Indirect Mater 15 1466 Factory 111 24 Factory Hepsi estion 17.34/50 Factory Repairs 9264 1930 Total Variable Cosi 57514 61760 4246 Fixed Costs Supervision 43680 0 43680 DOO Depreciation 17160 17160 Insurance 12480 12480 PORTEN 23040 23040 o Rent 0 96360 96360 Total Fixed Costs 153874 353874 $ Total Conts Tawtheek and Media