Compute all materials and labor variances in a spreadsheet

Assignment Help Cost Accounting
Reference no: EM131151060

Application: Calculating Variances and Analyzing the Results

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

*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: Put Both Charts on On Excel Sheet , Also a separate box for

• 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 Document!!!!

• 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: EM131151060

Questions Cloud

Increase the number of medicaid beneficiaries : A county health department wants to increase the number of Medicaid beneficiaries that participate in prenatal care. It knows that only 40 percent of the expectant mothers eligible for prenatal care fully use the benefit.
Informal situational analysis on the organisation : Describe your process for conducting an informal situational analysis on the organisation you chose. What areas did you consider in your analysis and What is marketing? Why is important? Review the Readings. Consider how marketing strategies and o..
Is it just good business or is it unpatriotic : Explain why and how many companies in the United States are moving their operations oversea's for lower tax rates and overall tax preference. Please choose at least one company that has employed this strategy (ie., FaceBook) and discuss their motivat..
Manufacturer of lawn care equipment has introduced : A manufacturer of lawn care equipment has introduced a new product. The anticipated demand is normally distributed with a mean of μ = 100 and a standard deviation of σ = 10. Each unit costs $70 to manufacture and the introductory price is to be $150 ..
Compute 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.
Define opportunity cost of getting your degree by analyzing : Define the opportunity cost of getting your degree by analyzing what steps and economic factors a potential student must make when choosing to pursue an education. Given your answer, is getting a formal college education worth your opportunity co..
Determine the required minimum thickness t of the wall : determine the required minimum thickness t of the wall of the cylinder.
Determine how they are similar and how they differ : Both firewalls and intrusion detection systems are used to monitor network traffic and implement network security policies. Research these technologies and determine how they are similar and how they differ. Are both needed? Explain your answer in..
What is the proportion of customers : Find the upper boundary of the 95% confidence interval for the average unload time and what is the proportion of customers who buy service plans when they buy a computer?

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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