Factory Overhead Analysis-Two, Three, and Four Variances Walkenhorst Company's machining department prepared its 2010 budget based on the following data:

Practical capacity 40,000 units Machine hours per unit 2

Variable factory overhead $3.00 per machine hour Fixed factory overhead $360,000

The department uses machine hours to apply factory overhead. In 2010, the department used 85,000 machine hours and $625,000 in total manufacturing overhead to manufacture 42,000 units. Actual fixed overhead for the year was $375,000.

Required: Set up an Excel spreadsheet to determine for the year:

1. The variable, fixed, and total factory overhead application rates.

2. The flexible budget for overhead cost based on output achieved in 2010.

3. The production-volume variance.

4. The total overhead spending variance.

5. The overhead efficiency variance.

6. The variable and fixed overhead spending variances.