Build an excel spreadsheet for the shateau job shop

Assignment Help Financial Accounting
Reference no: EM13876783

Factory Overhead Variances Shateau Job Shop had the following operating data for its operations in 2010:

Budgeted fixed overhead

$20,000

Standard variable overhead application rate

$3 per MH

Fixed overhead incurred

$21,400

Variable overhead incurred

$32,500

Practical capacity (5,000 units)

10,000 MH

Actual machine hours (MH) worked

9,500

Units produced

4,500

Required: Build an Excel spreadsheet for the Shateau Job Shop that computes the following:

1. Variable overhead spending variance.

2. Variable overhead efficiency variance.

3. Fixed overhead spending (budget) variance.

4. Production-volume variance.

5. Overhead spending variance using a three-variance analysis.

6. Overhead flexible-budget (controllable) variance using a two-variance analysis.

Reference no: EM13876783

Questions Cloud

Derive the modified formula for price of bond : Assuming that the account in the previous problem continues to receive the same interest rate, for how long can this individual withdraw $40,000 a year from the account?
What arguments can you make for and against such state laws : What arguments can you make for and against such state laws?
Ch has developed several formulas : Custom Homebuilders (CH) designs and constructs high-end homes on large lots owned by customers.
Should they allowed to sue on grounds of unfair competition : Should workers who are citizens or legal residents be allowed to sue an employer who knowingly employs illegal workers and What about competitors: Should they be allowed to sue on grounds of unfair competition?
Build an excel spreadsheet for the shateau job shop : Build an Excel spreadsheet for the Shateau Job Shop that computes the following: Variable overhead spending variance.
Features and characteristics of the ideal market : Make an assignment on  an arena for nerf guns for kids. so the target market will be families with younger kids and teenagers aged 14-25
What happened when practices were challenged in court : In Freehold, New Jersey, Mamaroneck, New York, and Redondo Beach, California, Latino day laborers who solicit work are arrested or given tickets for loitering in public places.
Compute the variable overhead efficiency variance : Compute the following Variable overhead efficiency variance, Variable overhead spending variance and Fixed overhead spending (budget) variance for April.
Determine the interest rate that the ira paid out : A self-employed individual contributes $5,000 annually for 30 years into an Individual Retirement Account (IRA). At the end of 30 years the account balance is $230,000. Assuming monthly compounding, determine the interest rate that the IRA paid out..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Assume that both x and y are well-diversified portfolios

assume that both x and y are well-diversified portfolios and the risk-free rate is 8.nbsp portfolio x has an expected

  Prepare the necessary entries to clear the intangible assets

Prepare the necessary entries to clear the Intangible Assets account and to set up separate accounts For distinct types of intangibles. Make the entries as of December 31, 2007,

  What is the net present value of the proposed investment

What is the net present value of the proposed investment ignore income taxes and depreciation and assuming a 5-year straight-line depreciation, how will this impact the factory's fixed costs for each of the 5 years (and the implied product costs)? ..

  Long-term loans are the only external debt arrangement

Adrian Lee is a recent AMME graduate. A few years ago he launched his new incorporated business, “Meter Marshall”. Adrian is a keen inventor and entrepreneur. Assuming that long-term loans are the only “external debt” arrangement, what is the gearing..

  Troubled debt restructuring-asset swap

McKeon Machine Company has outstanding a $210,000 note payable to Tejon Investment Corporation. Because of financial difficulties, McKeon negotiates with Tejon to exchange inventory of machine parts to satisfy the debt. Prepare the journal entry for ..

  What was account balance at end of the tenth year

At the end of the sixth year, the account balance was transferred to a bank paying 10%, and annual deposits of $6,000 were made at the end of each year from the seventh through the tenth years. What was account balance at the end of the tenth yea..

  What else is a component of the equity section of the

what else is a component of the equity section of the balance sheet? please explain to the class how the retained

  Calculate the basic financial ratios

Profitability Ratios-profit margin, asset turnover, return on assets, debt-to-equity ratio, return on equity-long-term Solvency Ratios-debt-to-equity ratio, debt to total assets, times interest earned, cash debt coverage

  Borrowing needs and preparation of statement of cash flows

Borrowing Needs and Preparation of Statement of Cash Flows

  Independent assumptions

On January 1, 2014, Lauren Corporation had $1,000,000 of common stock outstanding that was issued at par. It also had retained earnings of $750,000. The company issued 40,000 shares of common stock at par on July 1 and earned net income of $400,000 f..

  What are the principal limitations of the cash payback

Why is one product line preferred over the other, even though they both have the same total net cash flows through eight periods?

  Managements valuation assertion for accounts receivable

Which of the following audit procedures would an auditor most likely perform to test controls relating to management's valuation assertion for accounts receivable?

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