Help needed with budgetary control excel

X V E24-4 Prepare flexible budget reports f X V E24-4 Prepare flexible budget reports for mar A B C D E F G H K B C D E F G H I L (al THOME COMPANY Manufacturing Overhead Flexible Budget Report Thome Company uses a flexible budget for manufacturing overhead based on direct labor hours. For the Month Ended July 31, 2014 Variable manufacturing overhead costs per direct labor hour are as follows. Difference Budget at Actual Costs Favorable F Indirect labor $1.00 9,000 DLH 9,000 DLH Unfavorable U Indirect materia 0.60 Direct labor hours (DLH) Utilities 0.40 Variable costs Indirect labor Value Value Value Fixed overhead costs per month are supervision $4,000, depreciation, $1,200, and property taxes $800. Indirect materials Value Value Value The company believes it will normally operate in a range of 7,000 - 10,000 direct labor hours per month. Utilities Value Value Value Total variable costs Using the information above, assume that in July 2014, Thome Company incurs the following manufacturing Fixed costs overhead costs Supervision Value Value Value Depreciation Value Value Value Variable Costs Fixed Costs Property taxes Value Value Value Indirect labor $ 8,800 Supervision 4,000 Total fixed costs ? Indirect materia 5,300 Depreciation 1.200 Utilities 3,200 Property taxes 800 Total costs ? ? ? Instructions (a) Prepar a flexible budget performance report, assuming that the company worked 9,000 direct labor hours during the month (b) THOME COMPANY (b) Prepare a flexible budget performance report, assuming that the company worked 8,500 direct labor hours Manufacturing Overhead Flexible Budget Report during the month. For the Month Ended July 31, 2014 (c ) Comment on your findings. Difference NOTE: Enter a number in cells requesting a value: enter either a number or a formula in cells w Budget at Actual Costs Favorable F 8,500 DLH 8,500 DLH Unfavorable U Direct labor hours (DLH) Variable costs [a) THOME COMPANY Indirect labor ($1.00) Value Value Value Manufacturing Overhead Flexible Budget Report Indirect materials ($0.60) Value Value Value For the Month Ended July 31, 2014 Utilities ($0.40) Value Value Value Difference Total variable costs ($2.00) ? ? ? Budget at Actual Costs Favorable F Fixed costs 9,000 DLH 9,000 DLH Unfavorable U Supervision Value Value Value Direct labor hours (DLH) Depreciation Value Value Value Variable costs Property taxes Value Value Value Indirect labor Value Value Value Total fixed costs ? ? ? ndirect materials Value Value Value Utilities Value Value Value Total costs ? Total variable costs ? ? ? Fixed costs Supervision Value Value Value 01 - Thome Co. Q2 - Thome Co 03 - Dewitt Co (+ Q1 - Thome Co. Q2 - Thome Co Q3 - Dewitt Co +