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

  Prepare the journal entry to record the sale

Prepare the journal entry to record the sale of these bonds on January 1, 2012 and Prepare the journal entry to record interest expense and bond discount amortization on December 31, 2012, assuming no previous accrual of interest.

  What is the minimum acceptable price

What is the minimum acceptable price of one-time-only special order - Other than price, what other items should Loft Lake Cabinets consider before accepting this one-time-only special order?

  What was the fair value of exactos net assets

What amount did True pay when it purchased Exacto's shares and what was the fair value of Exacto's net assets on January 1, 20x5?

  Prepare a schedule of cost of goods manufactured

Prepare an income statement for the year in good form. The company closes any underapplied or overapplied manufacturing overhead to Cost of Goods Sold.

  Calculate the mean or average of these yoy returns

Calculate the mean or average of these YoY returns from your sample. Calculate the standard deviation of the YoY returns. (In Excel, use the STDEV function.)

  Prepare cash budget for the year-review financial statements

ACCT 2301 Summer 2, 2013a. Prepare the annual proforma financial statements that you would expect Linda to prepare based on her comments about her expectations for the business.

  Compute fixed overhead spending and efficiency variances

Compute the variable overhead spending and volume variances and compute the fixed overhead spending and efficiency variances.

  Using the net realizable method assign costs to l and t

The sales revenue from L amounts to $200,000 of the total. Using the net realizable method, assign costs to L and T for January.

  What was its cost of goods sold

Berry Company sold goods with a total selling price of $800,000 during the year. It purchased goods for $380,000 and had beginning inventory of $67,000. A count of its ending inventory determined that goods on hand was $50,000. What was its cost o..

  Develop a direct labor budget for the months of june

Develop a direct labor budget for the months of June, July, and August and for each type of direct labor.

  Compute arrows direct material variances

Compute Arrows direct material variances, compute Arrow's direct labor variances and compute Arrow's variances for factory overhead.

  Bixby corporation purchased land and a building for 800000

bixby corporation purchased land and a building for 800000. an appraisal shows that the lands value is 400000 and the

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