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

  Straight-line method

Based on the following questions, ignore income taxes and make the assumption that the company's compulsory return is 14%. In order to calculate the depreciation, this company uses the straight-line method.

  Variable manufacturing overhead

Variable manufacturing overhead costs $1,900,000 Fixed manufacturing overhead costs $1,600,000 Manufacturing overhead application base Expected Direct Labour hours

  Budget line for consumer-using demand curve and utility

Given the following information, Describe the budget line for consumer. Be sure to label the axis and give a number for vertical and horizontal intercepts. Slope? Meaning?

  Preparing budget-top-down and bottom-up approach

Recognize and explain a project where the top-down budgeting approach would be most appropriate. Detail your rationale for decision and list the advantages for using that approach.

  Determining the problem of cash conversion cycle

Calculate Coffee Mill's Cash Conversion Cycle. If Coffee Mill were to shorten its inventory conversion period by 10 days, what effect would this have on the Cash Conversion Cycle? What effect (in dollars) would (b) have on Coffee Mill's total worki..

  Managerial accounting-conversion costs

What would be the cost per equivalent unit for conversion costs for the month? (Round off to three decimal places.)

  Job-order costing-hoover inc

Hoover Inc. uses a job-order coding system. The company's inventory balances on February 1, the start of its fiscal year, were as follows:

  Question-managerial accounting

The following monthly budgeted data are available for a wholesale company: Calculate the break-even sales for the month. Calculate the margin of safety in sales dollars.

  Why is the cost allocation method used

Why is the cost allocation method used by an organization an important part of its cost accounting system?

  Cost behaviour-scatter diagram

Phenix Corporation reports following information regarding its sales and cost of sales. Draw the estimated line of cost behavior by using the scatter diagram, and evaluate fixed costs and variable costs per unit sold.

  Effects of inventory management on cash coversion and cog

Please discuss the effects of inventory management on cash conversion cycle and cost of goods for the firm.

  Activity-based costing and management

Mattresses-A-Million produces Pillow-Top mattresses. They have been using a volume-based costing system to allocate overhead based on direct labor-hours. The Pillow-Top requires two hours of direct labor.

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