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

  Draw conclusions you draw on face of financial

draw conclusions you draw on face of financial statements.the financial health of a company can be analyzed using a

  Computation of contribution per unit for various

computation of contribution per unit for various models.person company makes two types of backpacks. data for the

  Compute the appropriate discount rate

Compute the appropriate discount rate to use when evaluating DEI's project and the manufacturing plant has an eight-year tax life. At end of the project (i.e. the end of Year 5), the plant can be scrapped for $2 million. Find the after-tax salvage ..

  How will the ppaca affect prescription drug costs

the government could take to encourage companies to conduct research and development and still control the costs of pharmaceuticals? How is it done in other nations

  Describe and compare inventories carried by both manufacture

Describe and compare the inventories carried by both manufacturing and merchandising companies. Where would these inventories be reported in the financial statements?

  Analysts behavior regarding cost information is unethical

Bozrah Organics produces items made from local farm products that it distributes to supermarkets in its local market area. Due to an increase in the price competition over the last several quarters, Abby Lane, the company's CFO and controller, is pla..

  Fundamentals of accounting assignmentwrite up assets

fundamentals of accounting assignmentwrite up assets capital and liability accounts in the books of d. gough to record

  Illustrate what total amount should be credited additional

The market value of the common stock at the date of the conversion was $30 per share. Illustrate what total amount should be credited to additional paid-in capital from common stock as a result of the conversion of the preferred stock into common..

  What is the conversion cost per equivalent unit

Fifty-four thousand units were transferred out of the department and the ending inventory consisted of 2,500 units that are 20% complete with respect to conversion. What is the conversion cost per equivalent unit?

  Determine danny and marys taxable income

Your firm has clients named Danny and Mary. They are married and have two dependent children. They also fully support Mary's mother, who lives with them and has no income. Determine Danny and Mary's taxable income.

  Purpose the journal entries to account for lease transaction

Purpose the journal entries to account for the lease transaction in the books of the lessor, Machine Guarantee Limited. Purpose the journal entries to account for the lease transaction in the books of the lessee, Simons Limited.

  Accountants create the traditional financial statements

When dealing with a continued consolidation, there are several issues to consider. The first issue is dealing with the concept of reciprocity. Does the same team of accountants create the traditional financial statements that do the consolidation?

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