I need help knowing how to compute this problem in excel.

1. Sch. 5: Overhead each month is estimated using a flexible budget formula. Activity is measured in DL hours. Fixed and variable overhead costs are as follows Overhead Category Fixed Cost per Month Variable Cost per DL Hour Supplies $1.15 Power $0.30 Maintenance $10,500 $1.20 Supervision $15,000 Depreciation $50,000 RE & PP Taxes $9,800 Other $62,000 $1.60 E F G H March 21,250 Quarter 1 118,700 April 14,625 B D 1 2 3 Schedule 5: Overhead Budget 4 January February 5 Budgeted Direct Labor Hours 54,315 126,225 6 Variable OH Rate 7 Budgeted Variable OH 8 Budgeted Fixed OH 9 Total OH Cost 10 11 12 13 14