Construct an excel spreadsheet to solve the requirement

Assignment Help Managerial Accounting
Reference no: EM13163349

Straightforward Computation of Overhead Variances

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

Required:

1. Use any of the methods explained in the chapter to compute the following variances.

Indicate whether each variance is favorable or unfavorable, where appropriate.

a. Variable-overhead spending variance.

b. Variable-overhead efficiency variance.

c. Fixed-overhead budget variance.

d. Fixed-overhead volume variance.

2. 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.

Reference no: EM13163349

Company should get out of the golf club business

Note that under full costing, the company is showing a substantial loss in 2011. Based on the limited information available, does it appear that the company should get out of

Calculate the return on assets ratios for the company

Large traded companies like Target, Ford, Apple, etc. are easy to find this type of information on. We recommend you go straight to Hoover's Pro database to find a company p

Explain traditional managerial approach

Explain Traditional managerial approach? How would allocate resources based on cost efficiencies attempting to optimize benefit for the cost. How political approach to budge

How much will income increase in percentage terms

How much will income increase in percentage terms? Make sure you have read over the DOL discussion and understand the multiplier impact of changes in sales volume that occu

Possible customer returns or account adjustments

On July 15, Mann Company sold $600,000 in accounts receivable for cash of $500,000. The factor withheld 10% of the cash proceeds to allow for possible customer returns or acco

Which can secure sustainable cost advantage over competition

MS6010- What can you learn from the financial statements of competitors that determine the relative cost position of your company? What are some of ways in which you can secur

Compute the before-tax npv of the new lift

Compute the before-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment. Show calculations

Relationship between the money spent on tv advertising

A marketing analyst is studying the relationship between the money spent on TV advertising (x) and the increase in sales (y). One study reported the following data (in $)

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd