Evaluate all materials and labor variances in a spreadsheet

Assignment Help Financial Accounting
Reference no: EM131326762

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:

o 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.

o Part 2: Prepare a memo to your subordinate, using a program like Word in APA Format.

- Summarize and analyze the actual costs in relation to the standard costs incurred for the month.
- Ask for clarification of any variances that need to be investigated.

Be sure to include whether alternatives exist for the future of the organization and explain how the results of the variance analysis might influence those alternatives.

Reference no: EM131326762

Questions Cloud

What is profitability index using a 14 percent discount rate : What is the NPV using a 14 percent discount rate? What does this mean?- What is the profitability index using a 14 percent discount rate? What does this mean?
Define a deferred tax asset and deferred tax liablity : Define a deferred tax asset and deferred tax liablity and give two examples of each type of deferral. Explain what you learn about the disclosures of your SEC 10-K company relating to Income Taxes.
Which level of analysis is the primary focus of this case : Explain how each of the leadership theory classifications applies to this case, and which one is most relevant.
What is effective tax rate and before tax equivalent yield : What is the effective tax rate and before-tax equivalent yield?- How would you evaluate the tax benefits of this investment?
Evaluate 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.
Describe the process of perception as a series of seven step : Describe the process of perception as a series of seven steps, beginning with the environmental stimulus and culminating in the behavioral responses of perceiving, recognizing and acting.What is the role of higher-level or "cognitive" processes in ..
What is current occupancy rate for office space : What is the current occupancy rate for office space in Small City?- How much office space will be absorbed each year for the next three years?
What is the motivation for a sale leaseback of the land : What is financial leverage? Why is a one-year measure of return on investment inadequate in determining whether positive or negative financial leverage exists?
What are positive and negative financial leverage : What are positive and negative financial leverage? How are returns or losses magnified as the degree of leverage increases?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Determine over or under applied overhead from the facts

determine over or under applied overhead from the facts given.the following information was extracted from the

  Shareholder rule include stock options

Fringe benefits limited by the more-than-2%-shareholder rule include stock options, group term life insurance premiums, and medical insurance premiums. A shareholder owning 2% or more of an S corporation's stock, who is also an employee of the corpor..

  Found on the statement of cash flows

Which of the following can be found on the statement of cash flows? The cost system best suited to industries that manufacture a large number of identical units of commodities on a continuous basis is. The percentage analysis of increases and decreas..

  Interest on the bonds is payable semiannually

On February 28, 2009, $5,000,000 of 6%, 10-year bonds payable, dated December 31, 2008, are issued. Interest on the bonds is payable semiannually each June 30 and December 31. If the total amount received (including accrued interest) by the issuing c..

  Assigned receivables and remits those collections

On October 1, 2014, Gator Inc assigns $1,600,000 of its accounts receivable to American Bank as collateral for a $1,200,000 loan. The bank assesses a finance charge of 2% of the receivables assigned and interest on the note of 7%. On December 31, 201..

  Money market account-bond fund-international stock fund

A person plans to invest a total of $130,000 in a money market account, a bond fund, an international stock fund, and a domestic stock fund. She wants 60 % of her investment to be conservative (money market and bonds). She wants the amount in domesti..

  Two bonds first the highest current yield

Which of these two bonds first the highest current yield? Which one has the highest yield to maturity?

  How many students are needed in order to achieve breakeven

How many students are needed in order to achieve breakeven. -  How many classes need to be taught in order to achieve breakeven.

  Is net income affected by the payment of dividends

How does the payment of dividends of $30,000 affect the three elements of the accounting equation?

  Evaluate the total unit cost of each product line

Evaluate the total unit cost of each product line in a refined state.

  Question ken is 63 years unmarried and old he retired at

question ken is 63 years unmarried and old. he retired at age 55 when he sold his business understock.com. while ken is

  Stock trading recommendations in the short and long term

Write A Case Report : students choose one public corporation, estimate its intrinsic value through analyzing its financial statements and provide stock trading recommendations in the short- and long-term. Students should prepare case reports in their..

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