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 Foxed costs: Supervisory salares 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 Alternative Comnutation of Ovarhead Variances: PR 23-4B Factory Overhead Cost Variance Report Obj. 4 Feeling Better Medical 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. 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