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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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