i need help on part B prepare flexible budget report, assuming that the company worked 10,200 direct labors during the month
Indigo Company uses a flexible budget for manufacturing overhead based on direct labor hours. Budgeted variable manufacturing overhead costs per direct labor hour are as follows. Budgeted foxed overhead costs per month are Supervision $4,800. Depreciation $1,440, and property Taxes $960. The company believes it will normally operate in arange of 8,40012,000 direct labor hours per month. Assume that in July 2022, Indigo Company incurs the following manufacturing overhead costs. (a) Prepare a flexible budget performance report, assuming that the company worked 10.800 direct labor hours during the month. (List variable costs before fixed costs.) (a) Prepare a flexible budget performance report, assuming that the company worked 10.800 direct labor hours during the month. (List variable costs before fixed costs.) \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Indirect Labor & 0 & s & 10800 & s & 10560 & s & 240 & Favorable \\ \hline Indirect Materials & 0 & & 7560 & & 6960 & & 600 & Favorable \\ \hline Utilities & 0 & & 4320 & & 3840 & & 480 & Favorable \\ \hline \multicolumn{2}{|c|}{ Total Variable costs 0} & & 22680 & & 21360 & & 1320 & Favorable \\ \hline \multicolumn{9}{|l|}{ Fixed Costs } \\ \hline Supervision & 0 & & 4800 & & 4800 & & 0 & Neither Fav \\ \hline Depreciation & 0 & & 1440 & & 1440 & & 0 & Neither Fan \\ \hline Property Takes & 0 & & 960 & & 960 & & 0 & Neither Faw \\ \hline Total Fixed Costs & 0 & & 7200 & & 7200 & & 0 & Neither Fans \\ \hline Total Costs & 0 & $ & 29880 & $ & 28569 & $ & 1320 & Favorable \\ \hline \end{tabular} (b) Prepare a flexible budget performance report, assuming that the company worked 10,200 direct labor hours during the month. (List variable costs before fixed costs.) INDIGO COMPANY Manufacturing Overhead Flexible Budget Report \begin{tabular}{cc} Difference \\ \hline Actual Costs & Favorable \\ Unfavorable \\ Neither Favorable \\ nor Unfavorable \\ \hline \end{tabular} Unfaverable Neither Favarable Budget Aetual Costs nor Unfavorable s $ s 0 0 0 o o $ 5