I'm having trouble pulling together a flexible budget. Can you help me with the problems identified on this worksheet?

Flexible Budget Preparation Template Solve Problems 1-5 based on the information in the following scenario. Conglomco has asked you to develop a flexible overhead budget, based on the data below. Standard Costs for Product per Unit Direct materials (6 pounds, at $5 per pound) $22.50 Direct labor (2 hours, at $17 per hour) $25.50 Overhead (2 hours, at $18.50 per hour) $27.75 Total standard cost $75.75 The predetermined overhead rate ($13.87 per direct labor hour) is based on an expected volume of 75% of the factory's capacity of 20,000 units per month. Budgeted Overhead Costs per Month (at 75% capacity) Variable Costs Indirect materials Amount ($) 33,750. Indirect labor 135,000. Power 33,750. Repairs and maintenance 67,500. Total variable overhead costs Fixed Overhead Costs 270,000. Amount ($) Depreciation: Building 18,000. Depreciation: Machinery 60,000. Taxes and insurance Supervision 9,000. 59,250. Total fixed overhead costs 146,250. Total overhead costs 416,250. 1 The company incurred the following actual costs when it operated at 75% of capacity in September. Expenses Amount ($) Direct materials (91,000 pounds, at $5.1 per pound) 348,075. Direct labor (30,500 hours, at $17.25 per hour) 394,500. Overhead costs Indirect materials 33,187. Indirect labor 133,312. Power 32,250. Repairs and maintenance 72,000. Depreciation: Building 18,000. Depreciation: Machinery 56,250. Taxes and insurance 8,625. Supervision 67,750. Total overhead costs Total costs 421,374. 1,163,949. Complete the problems below. Add your answers in this template and show your work. Problem 1. Examine the monthly overhead budget to: Determine the costs per unit for each variable overhead item, and each item's total per-unit costs. Identify the total fixed costs per month. Problem 2. Prepare flexible overhead budgets for September, showing the amounts of each variable and fixed cost at the 65%, 75%, and 85% capacity levels. Problem 3. Include the price and quantity variances to compute the direct materials cost variance. Problem 4. Include the rate and efficiency variances to compute the direct labor cost variance. Problem 5. Prepare the overhead variance report, showing the overhead variances for individual items. 2