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

Questions Cloud

State maximum concentration level : Explain, in detail, how you would prepare this solution so a labmate could prepare it from your instructions
Develop a program that will allow the district sales manager : You have been asked to develop a program that will allow the district sales manager to input each of the dealership's ID along with their four quarterly sales volumes for the year, calculate and display each quarter's rebate and the sales bonus fo..
State ammonia has a melting point : Ammonia has a melting point of 195 K and a normal boiling point of 240 K. At 225 K and 1atm, ammonia exists primarily as
Coding(using for and while loop) : coding(using for and while loop)
Construct an excel spreadsheet to solve the requirement : 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.
What is the purpose of anhydrous cacl2 : what is the purpose of anhydrous CaCl2? Why it is important that none of the solid CaCl2 be included in the final distillation of your 1-bromobutane?
State solution from pure drug and water : Describe how to prepare 50.0mL of 5.30 x10-2 M solution from pure drug and water.
International financial reporting standards : On the basis of your analysis of the factors presented in the case, determine whether Centcom, TTL Group, or neither party should consolidate Britel under International Financial Reporting Standards
Explain what ph should be used and why : To extract quinine from an aqueous solution, what pH should be used and why? I'm not sure if you use both pKa's or just one.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Evaluate the capital loss

Evaluate the capital loss

  Job-order costing sertoma condos inc

Assuming that the amount of rent revenue from Condo 2 is $48,000, what amount of income did it earn? Based on the preceding information, will the company show finished goods inventory

  Important forecast of master budget

A master budget is the compilation of forecasts for coming year or operating cycle made of many departments or function in an organization. What is the most significant forecast made in the master budget? Mention the reasons for your answer.

  Cost-revenue variances for spiele company

Spiele Inc. manufactures and sells various software packages - Games, Business Applications and Creative Suites. Budget and actual information for the period are presented in the table.

  Portraits unlimited company budgeting project

Prepare Portraits Unlimited Company master budget for each quarter of 2014 and in total for the year by completing the following schedules and statements Sales budget

  Brinkers bicycle shop - a special order decision

Identify and describe or explain the problem that the managers of the organization in question are encountering. What has happened to make the managers realize that the problem has arisen - Managerial Accounting (AF 211)

  Flexible budget analysis and strategic-budget analysis

Why might managers find out a flexible budget analysis more informative than the strategic-budget analysis? Describe your rationale. How might a manager gain insight in the causes of the flexible-budget variance for direct materials?

  Total cost-solution set

A review of Parrish Corporation's accounting records found that at a volume of 144,000 units, the variable and fixed cost per unit amounted to $6 and $2, respectively.

  Major methods of developing advertising budge

Describe the major methods of developing the advertising budget. Make sure you take the position on which method you think is best and why.

  Describing activity-based costing

What is generally true regarding overhead allocation to high-volume products versus low-volume products under the traditional costing system?

  Question on segment reporting

Slatter Corp operates primarily in the United States. However, few years ago, it opened plan in Spain to produce merchandise to sell there. This foreign operation has been so successful that throughout the past 24 months the company started a manu..

  Discussion on product costing

Some firms have a lot of fixed costs and a few variable costs, while other firms are configured the other way around. What effect do you think the existence of a high proportion of fixed costs has on the desirability of using ABC methods?

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