B C D E F G 1 E10.3 Prepare flexible manufacturing overhead budget 2 I K L 3 Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. 4 Variable manufacturing overhead costs per direct labor hour are as follows. 5 6 7 Indirect labor Indirect materials 8 Utilities 9 $ 1.00 0.70 0.40 10 Fixed overhead costs per month are supervision $4,000, depreciation $1,200, and property 11 taxes $800. The company believes it will normally operate in a range of 7,000-10,000 direct 12 labor hours per month. 13 14 Instructions 15 Prepare a monthly manufacturing overhead flexible budget for 2022 for the expected range of 16 activity, 17 18 NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), 19 into the yellow shaded input cells. 20 21 MYERS COMPANY Monthly Manufacturing Overhead Flexible Budget 23 24 25 26 Activity level 27 Direct labor hours 28 Variable costs 29 30 31 32 33 34 35 36 2222222222222222222 37 38 Indirect labor Indirect materials Utilities Total variable cost Fixed costs Supervision Depreciation Property taxes 39 Total costs Total fixed costs For the Year 2022 7.00$+> 8,000 9,000 10,000