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

  International nature of the clubs guests poses

The international nature of the club’s guests poses challenges for the kitchen staff, Japanese break-fasts feature miso soup, stewed vegetables in soy sauce, and rice porridge whereas Germans are accustomed to cold cuts and bread for breakfast. The n..

  A dubois inc has 600000 to invest the company is trying to

a dubois inc. has 600000 to invest. the company is trying to decide between two alternative uses of the funds. one

  Illustrate what is the amount of bond issue costs

During the year, Hamlet Inc. paid $22,000 to have bond certificates printed and engraved, paid $110,000 in legal fees, paid $12,000 to a CPA for registration information, and paid $190,000 to an underwriter as a commission. Illustrate what is the..

  Compute the amounts given below for a weekly payroll period

Paychecks are distributed every Friday to all employees. Based on the information given, compute the amounts listed below for a weekly payroll period.

  Which of the happens with respect to the transfer

Teri transferred land worth $200,000 (basis of $40,000) to Angle Corporation, an existing entity, for 300 shares of its stock. Angle Corporation has two other shareholders, Stuart and Carl, each of whom holds 50 shares. Which of the following happens..

  The solvency of the subsidiary

In terms of the rules applying to a section 332 parent-subsidiary liquidation, comment on each of the following: The parent corporation's ownership interest in the subsidiary. The solvency of the subsidiary.

  Allowance for doubtful accounts

The company recorded this amount as an addition to Allowance for Doubtful Accounts. On May 11, 2018, Ling Co. determined that the Jeff Shoemaker account was uncollectible and wrote off $2,072. On June 12, 2018, Shoemaker paid the amount previously wr..

  What monthly sales will have to be

Dorina Company produces and sells a single product. The product sells for $60 per unit and has a contribution margin ratio of 40%. The company's fixed expenses are 28800.

  Prepared at the date of the acquisition combination

Fine Co. issued its common stock in exchange for the common stock of Dandy Corp. in an acquisition. At the date of the combination, Fine had land with a book value of $520,000 and a fair value of $595,000. Dandy had land with a book value of $230,000..

  What is its self-supporting growth rate

Maggie’s Muffins, Inc., generated $5,000,000 in sales during 2013, and its year-end total assets were $2,5000,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $3000,000 of notes payable, $5000,000 of accounts payable, a..

  Company accepts the outside suppliers offer

Foto Company makes 50,000 units per year of a part it uses in the products it manufactures. Calculate the decrease in company profits if Foto Company accepts the outside suppliers offer.

  Income tax accounting

What is the amount of Chantal's Gross Income from these wages? Income Tax Accounting

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