Required information [The following information applies to the questions displayed below] The following data are the...

Transcribed Image Text:

Required information [The following information applies to the questions displayed below] The following data are the actual results for Marvelous Marshmallow Company for October. Actual output Actual variable overhead Actual fixed overhead Actual machine time 9,000 cases $ 485,000 $122,000 40,500 machine hours Standard cost and budget information for Marvelots Marshmallow Company follows: Standard variable-overhead rate Standard quantity of machine hours Budgeted fixed overhead Budgeted output $9.00 per machine hour $ 120,000 per month) 4 hours per case of marshmallows 10,000 cases per month 2. 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. Required information [The following information applies to the questions displayed below] The following data are the actual results for Marvelous Marshmallow Company for October. Actual output Actual variable overhead Actual fixed overhead Actual machine time 9,000 cases $ 485,000 $122,000 40,500 machine hours Standard cost and budget information for Marvelots Marshmallow Company follows: Standard variable-overhead rate Standard quantity of machine hours Budgeted fixed overhead Budgeted output $9.00 per machine hour $ 120,000 per month) 4 hours per case of marshmallows 10,000 cases per month 2. 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.