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

  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