Concord Company estimates that 342,000 direct labor hours will be worked during the coming year, 2025, in the Packaging Department. On this basis, the following budgeted manufacturing overhead cost data are computed for the year. Variable Overhead Costs Fixed Overhead Costs Supervision Depreciation $109,440 Indirect labor $143,640 82.000 Indirect materials 102,600 Insurance 34.200 Repairs 78.660 Rent 27.360 Utilities 82.000 Property taxes 20520 Lubricants 20.520 $273,600 $427,500 It is estimated that direct labor hours worked each month will range from 20.300 to 42.400 hours During October 30,100 direct labor hours were worked and the following overhead costs were incurred Fled overhead costs supervision $9.120, depreciation $6.840, insurance $2.001, rent 32.200 and property taxes $1.710 Variable overhead cost indirect labor $14.161. Indirect materials 58.762, repairs 56.792 uses 57.764, and lubricants 52.102. (a) Prepare a monthly manufacturing overhead flexible budget for each increment of 4.100 direct labor hours over the relevant range for the year ending December 31, 2025. (List variable costs before fixed costs.) CONCORD COMPANY Packaging Department Monthly Manufacturing Overhead Flexible Budget For the Year 2025 (b) Prepare a flexible budget report for October. (List variable costs before fixed costs.) CONCORD COMPANY Packaging Department Manufacturing Overhead Flexible Budget Report Budget Actual Costs > S Difference Favorable Unfavorable Neither Favorable nor Unfavorable Property Taxes Utilities Indirect Labor Total Costs Insurance Supervision Lubricants Variable Costs Repairs Total Fixed Costs Rent Indirect Materials Direct Labor Hours Depreciation Fixed Costs Direct Materials Activity Level Total Variable Costs Direct Labor