Calculate all materials and labor variances in a spreadsheet

Assignment Help Financial Accounting
Reference no: EM131150693

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:

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.

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: EM131150693

Questions Cloud

Determine the present value of the bonds payable : Determine the present value of the bonds payable, using present value tables in Chapter 10 of your text. Round to the nearest dollar. Illustrate the General Journal entry that would be made to record the issuance of the bonds.
Time-constrained project and resource-constrained project : Compare the difference between a time-constrained project and a resource-constrained project. What industries typically have time-constrained projects, resource-constrained projects, or both?
Create written work utilizing concepts of critical thinking : Explain your answers to the "believing" questions about the three (3) premises opposing your position from the Procon.org website. Examine at least two (2) types of biases that you likely experienced as you evaluated the premises for and against ..
A step towards a better future with online education : Write a Custom Essays on the topic :"A Step towards a Better Future with Online Education"
Calculate 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.
How would the government respond to the attack : Your paper will be the basis for an upcoming DHS press conference in which the Deputy Director will attempt to assuage the public's fear.
How does his behavior affect his heroic image : Consider the main character from "Sigurd the Volsung." What kind of person is Sigurd? What tests of character confront him? To what extent does he pass them? Which temptations does he resist, and which does he find irresistible? Why? How does the ..
Government dissemination strategies : What were the most compelling topics learned in this course - How did participating in discussions help your understanding of the subject matter?
What is the factor-rating score for ling services : An operations manager is performing a factor-rating analysis to help her choose an outsourcing provider. She is focusing on three factors: A, B, and C, with weights of .50, .20, and .30, respectively. She has scored one potential outsourcer, Ling Ser..

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