Question: please fully complete the excel portion Feeling Better Medical Inc. Factory Overhead Cost Variance Report-Assembly Department For the Month Ended October 31 Normal capacity for

please fully complete the excel portion
please fully 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: Actual production for the month: \begin{tabular}{|r|} \hline 30,000 \\
\hline 28,500 \\ \hline \end{tabular} hours hours Fled costs: Supervisory salaries Depreciation

Feeling Better Medical Inc. Factory Overhead Cost Variance Report-Assembly Department For the Month Ended October 31 Normal capacity for the month: Actual production for the month: \begin{tabular}{|r|} \hline 30,000 \\ \hline 28,500 \\ \hline \end{tabular} hours hours Fled costs: Supervisory salaries Depreciation of plant and equip. Insurance and property taxes Total flixed cost Total factory overhead cost Total controllable variances Net controllable variance - (tavorable) unfavorable Idie (Excess) Hours Fixed Factory OH Rate Volume variance-(fav.) unfav. Total factory overhead cost variance - (favorable) unfavorable Alternative Computation of Overhead Variances: Factory Overhead \begin{tabular}{l|l|l|l} \hline Actual costs & & & Applied costs \\ \hline Balance & & & \\ \hline \hline \end{tabular} Actual Factory Budgeted Factory Overhead Applied Factory Overhead for Amount Produced Overhead Controllable Varlable cost Flxed cost Total Volume Variance Total Factory Overhead Cost Variance Supporting calculation: Variable factory overhead rate: Budgeted total variable cost Budgeted hours Variable factory overhead rate Fixed factory overhead rate: Total fixed costs Productive capacty hours Fixed factory ovemead rate Total Actual hours Applied costs 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. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f