please complete the excel portion

Feeling Better Medical Inc. Factory Overhead Cost Variance Report-Assembly Department For the Month Ended October 31 Normal capacity for the month: hours Actual production for the month: hours Variable costs: Indirect factory wages Power and light Indirect materials Total variable cost Fixed costs: Supervisory salaries Depreciation of plant and equip. Insurance and property taxes Total fixed cost Total factory overhead cost Total controllable variances Net controllable variance - (favorable) unfavorable Idle (Excess) Hours Fixed Factory OH Rate Volume variance-(fav.) unfav. Total factory overhead cost variance-(favorable) unfavorable Factory Overhead Actual costs Balance \begin{tabular}{l|l|l|l|l} \hline & & & & Applied costs \\ \hline & & & & \\ \hline \end{tabular} Actual Factory Budgeted Factory Overhead Applied Factory Overhead for Amount Produced Overhead Controllable Volume Variance Variance Total Factory Overhead Cost Variance Supporting calculation: Variable factory overhead rate: Budgeted total variable cost Budgeted hours Variable factory overhead rate Fixed factory ovemead rate: Total foxed costs Productive capacity hours Fixed factory overhead rate Total Actual hours Applied costs Obj. 4 Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for October of the current year. The company expected to operate the department at 100% of normal capacity of 30,000 hours. Details During October, the department operated at 28,500 hours, and the factory overhead costs incurred were indirect factory wages, $234,000; power and light, $178,500; indirect materials, $50,600; supervisory salaries, $126,000; depreciation of plant and equipment, $70,000; and insurance and property taxes, $44,000. During October, the department operated at 28,500 hours, and the factory overhead costs incurred were indirect factory wages, $234,000; power and light, $178,500; indirect materials, $50,600; supervisory salaries, $126,000; depreciation of plant and equipment, $70,000; and insurance and property taxes, $44,000. INSTRUCTIONS Prepare a factory overhead cost variance report for October. To be useful for cost control, the budgeted amounts should be based on 28,500 hours. Answer: Check Figure: Controllable variance, $(1,450)F Feeling Better Medical Inc. Factory Overhead Cost Variance Report-Assembly Department For the Month Ended October 31 Normal capacity for the month: hours Actual production for the month: hours Variable costs: Indirect factory wages Power and light Indirect materials Total variable cost Fixed costs: Supervisory salaries Depreciation of plant and equip. Insurance and property taxes Total fixed cost Total factory overhead cost Total controllable variances Net controllable variance - (favorable) unfavorable Idle (Excess) Hours Fixed Factory OH Rate Volume variance-(fav.) unfav. Total factory overhead cost variance-(favorable) unfavorable Factory Overhead Actual costs Balance \begin{tabular}{l|l|l|l|l} \hline & & & & Applied costs \\ \hline & & & & \\ \hline \end{tabular} Actual Factory Budgeted Factory Overhead Applied Factory Overhead for Amount Produced Overhead Controllable Volume Variance Variance Total Factory Overhead Cost Variance Supporting calculation: Variable factory overhead rate: Budgeted total variable cost Budgeted hours Variable factory overhead rate Fixed factory ovemead rate: Total foxed costs Productive capacity hours Fixed factory overhead rate Total Actual hours Applied costs Obj. 4 Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for October of the current year. The company expected to operate the department at 100% of normal capacity of 30,000 hours. Details During October, the department operated at 28,500 hours, and the factory overhead costs incurred were indirect factory wages, $234,000; power and light, $178,500; indirect materials, $50,600; supervisory salaries, $126,000; depreciation of plant and equipment, $70,000; and insurance and property taxes, $44,000. During October, the department operated at 28,500 hours, and the factory overhead costs incurred were indirect factory wages, $234,000; power and light, $178,500; indirect materials, $50,600; supervisory salaries, $126,000; depreciation of plant and equipment, $70,000; and insurance and property taxes, $44,000. INSTRUCTIONS Prepare a factory overhead cost variance report for October. To be useful for cost control, the budgeted amounts should be based on 28,500 hours. Answer: Check Figure: Controllable variance, $(1,450)F