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

  Joint cost-utilization of scarce resources

The Dallas plant of Oscar Chemical processes talphazine into zetazine and gammazine. A batch comprises of 20,000 gallons of talphazine, costing $11,000.

  Reject opportunity-cost drivers-opportunity costs

Explain two long-run effects which might lead to managers' rejecting opportunities to cut prices and obtain increases in short-run profits.

  Prepare flexible budget several levels

Make a flexible budget for following levels of production: 18,000 units, 20,000 units, and 22,000 units. Find out the flexible budget formula for the year ended December 31?

  Performance evaluation based on accounting measures

Read Using Shareholder Value to Evaluate Strategic Choices - The basic principle of the article is that performance evaluation based on accounting measures alone is not sufficient.

  Cash conversion cycle-breakeven

A firm has annual operating outlays of $1,800,000 and a cash conversion cycle of 60 days. If the firm currently pays 12 percent for negotiated financing and reduces its cash conversion cycle to 50 days, what is the annual savings?

  Management accounting formats

Management accounting formats are identical for all companies

  Determination of cost variances

Gridiron Merchandising anticipated selling 27,000 units of a major product and paying sales commissions of $6 per unit. Actual sales and sales commissions totaled 27,500 units and $171,400, respectively.

  High-low method of cost estimation

Describe how the high-low method of cost estimation can be used in estimating the fixed cost component of a mixed cost in a business.

  Percentage markups on cost

What percentage markups on selling price are equivalent to the following percentage markups on cost: 33 1/3, 20, 40, and 50? Discuss importance.

  Determining activity-based costing system

Give five disadvantages to using an activity-based costing system: Based on these answers, why would a company who only makes a few products not want to use such a system?

  Questions of cvp

The rapid meal has two restaurants that are open 24 hours. Fixed costs for the two restaurants together total $450,000 per year. Service varies from a cup of coffee to full meals.

  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

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