Coyote Company uses a flexible budget for manufacturing overhead based on direct labor

hours. For 2022, the master overhead budget for the Packaging Department based on 400,000

direct labor hours was as follows. Glenda Expects to operate between 33,000 direct labor hours and 35,000 direct labor hours per

month

During July, 34,000 direct labor hours were worked. The company incurred the following

variable overhead costs in July: indirect labor $42,000, supplies and lubricants $12,600,

maintenance $17,000, and utilities $15,000. Actual fixed overhead costs were the same as

monthly budgeted fixed costs.

Instructions:

1. Prepare a monthly flexible manufacturing overhead budget for the expected range of

activity, using increments of 1,000 direct labor hours.

2.

Prepare a flexible budget report for Glenda for the month of July and provide possible

reasons for the difference between the budgeted amount and the actual amount.

P2. Coyote Company uses a flexible budget for manufacturing overhead based on direct labor hours. For 2022, the master overhead budget for the Packaging Department based on 400,000 direct labor hours was as follows. Variable Overhead Costs: Indirect labor $480,000 Supplies and lubricants 160,000 Maintenance 240,000 Utilities 200,000 Total $1,080,000 Fixed Overhead Costs: Depreciation $ 25,000 Supervision $ 60,000 Property taxes 25,000 Insurance 20,000 Total $130,000 Glenda Expects to operate between 33,000 direct labor hours and 35,000 direct labor hours per month. During July, 34,000 direct labor hours were worked. The company incurred the following variable overhead costs in July: indirect labor $42,000, supplies and lubricants $12,600, maintenance $17,000, and utilities $15,000. Actual fixed overhead costs were the same as monthly budgeted fixed costs. Instructions: 1. Prepare a monthly flexible manufacturing overhead budget for the expected range of activity, using increments of 1,000 direct labor hours. 2. Prepare a flexible budget report for Glenda for the month of July and provide possible reasons for the difference between the budgeted amount and the actual amount