Question: Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: actual output

Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: actual output was 9,100 cases, and actual variable overhead was $395,000.

The following data are the actual results for Marvelous Marshmallow Company for October.

Actual output .................................................................................................................................9,000 cases

Actual variable overhead ................................................................................................................$405,000

Actual fixed overhead .....................................................................................................................$122,000

Actual machine time ......................................................................................................................40,500 machine hours

Standard cost and budget information for Marvelous Marshmallow Company follows:

Standard variable-overhead rate ....................................................................................$9.00 per machine hour

Standard quantity of machine hours ...............................................................................4 hours per case of marshmallows

Budgeted fixed overhead ...............................................................................................$120,000 per month

Budgeted output ...........................................................................................................10,000 cases per month

I need help calculating the variable overhead spending variance, variable overhead efficiency variance, fixed overhead budget variance & fixed overhead volume variance of chapter 11, problem 26e step 5 in managerial accounting 9th edition ronald hilton last 4 questions

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!