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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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