Find all materials and labor variances in a spreadsheet

Assignment Help Finance Basics
Reference no: EM131227836

Calculating variances

Application: Calculating Variances and Analyzing the Results

While many organizational costs can be planned for, the actual results may vary from the initial projections. Assessing how these variances impact the bottom line is an essential task of many managers.

For this Assignment, review the Learning Resources for this week and consider how they might apply to the scenario presented. Consider how variance analysis and the results obtained from conducting such an analysis might impact decision making.

Spine Line is a manufacturer of high-quality products designed to help support healthy spines. Their newest product offering is a massage chart. Below is the standard cost structure for the chair:

Standard Cost Sheet: Massage Chair

Metal tubing

6 meters @ $3

$18.00

Leather

2 square meters @ $7

$14.00

Padding

3 kilograms @$4

$12.00

Direct labor

4 hours @ $15

$60.00

Total standard cost

 

$104.00

This month, Spine Line manufactured 500 massage chairs. The following costs were incurred:

Actual Costs Incurred for the Month: Massage Chair

Metal tubing

3,100 meters

$9,455

Leather

1,100 square meters

$7,722

Padding

1,600 kilograms

$6,560

Direct Labor

1,800 hours

$27,270

Total cost

 

$51,007

Adapted from: Zimmerman, J. L. (2014). Accounting for decision making and control (8th ed.). New York: NY: McGraw-Hill, "Healing Touch", p. 565.

Suppose you are the senior controller for Spine Line and you plan to perform a variance analysis of the massage chairs manufactured to determine if the standards are being met. Once you have completed the analysis, you plan to show it to the production department manager and ask for an explanation of any variances that you believe should be examined.

The Assignment:

• Part 1: Calculate all materials and labor variances in a spreadsheet by using a program like Excel. Be sure to include price, quantity, wage rate, and labor efficiency variances.

• Part 2: Prepare a memo to your subordinate, using a program like Word.

o Summarize and analyze the actual costs in relation to the standard costs incurred for the month.

o Ask for clarification of any variances that need to be investigated.

Reference no: EM131227836

Questions Cloud

Fraction of the initial amount of krypton : Imagine Clark Kent is investigating the half-life of Krypton-8 and finds that it is approximately 10.8 years. \What fraction of the initial amount of Krypton-8 would still be remaining after 60 years?
Dimensional analysis and giant ones : A one minute advertisement on a local television station during prime time(8-10pm on week nights) costs the advertisement $12,800. To the nearest cent ,how much does the advertisement cost per second? Show your work using the dimensional analysis ..
Describe the costing system adopted : Describe the costing system adopted and how it is used to arrive at the cost of products or services - Does the costing system meet the needs of the organization? Discuss.
Effective rate of compound interest rate or investment : Find the effective rate of the compound interest rate or investment. (Round your answer to two decimal places.)16%compounded monthly. [Note: This rate is a typical credit card interest rate, often stated as1.3%per month.
Find all materials and labor variances in a spreadsheet : Calculate all materials and labor variances in a spreadsheet by using a program like Excel. Be sure to include price, quantity, wage rate, and labor efficiency variances.
Albert einsteins most famous theory : What was Albert Einsteins most famous theory and why was it the most famous?
How can commercial banks create money : (Creating Money) Often it is claimed that banks create money by making loans. How can commercial banks create money? Is the government the only institution that can legally create money?
Determining the real number : Prove that if p ∈ N is a prime number, then there exist a real number x, such that x2 = p. Moreover, x ∉ Q.
Is the same true of lowering the discount rate : What would happen if the Fed bought U.S. bonds from, or sold them to, the banking system?

Reviews

Write a Review

Finance Basics Questions & Answers

  Define the various capital budgeting methods

Define the various capital budgeting methods such as net present value (NPV), internal rate of return (IRR), and so on, and explain how they differ from one another.

  Electrical contractor that employs 10 electricians

Electrical Services is an electrical contractor that employs 10 electricians. Electrical Services faces numerous loss exposures. One general liability loss exposure arises out of faulty work that an electrician performs in a customer's home, which..

  Calculate the duration of a 1000 6 percent coupon bond

Calculate the duration of a $1,000, 6% coupon bond with three years to maturity. Assume that all market interest rates are 7%

  How much will be in the account immediately

How much will be in the account immediately after you make the first withdrawal?

  Estimate of the stocks required rate of return

Suppose you observe that the stock is selling for $50.00 per share, and that this is the best estimate of its equilibrium price. What would you conclude about either (i) your estimate of the stock's required rate of return; or (ii) the CFO's estim..

  Initial investment be worth

Over the next five years, the wealth manager has returns of 27%, 12%, (-17%), (-4%) and 31%. Assuming there are no fees (BIG ASSUMPTION), how much will your initial investment be worth at the end of the fifth year?

  Use the template below to show the financial statement effec

Use the template below to show the financial statement effects of (1) The December 31, 2010 issue (2) The December 31, 2011 interest payment and interest expense accrual

  What about if the first payment is due right now

You want to buy a car that costs $30,000 with a 4-year loan at an annual rate of 6%. How much is your montly payment if the first payment is due one month from now? what about if the first payment is due right now?

  What is the weighted average contribution margin per unit

What is the weighted average contribution margin per unit for Carlos? (please show your work step by step)

  National australia bank is listed on the australian

national australia bank is listed on the australian securities exchange with code nab. the company has 2.2731 billion

  A company currently sells

A company currently sells 60,000 units a month at $10 per unit. The marginal cost per unit is $6. The company is considering raising the price by 10% to $11. If the price elasticity of demand is _______________ in that price range, then profit wou..

  What is the meaning of an initial return for an ipo

What is the meaning of an initial return for an IPO? Were initial returns of Internet IPOs in the late 1990s higher or lower than normal? Why?

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