Prepare a spreadsheet that produces a cost-of-quality report

Assignment Help Cost Accounting
Reference no: EM13876503

Cost-of-Quality (COQ) Reporting Carrie Lee, the president of Lee Enterprises, was concerned about the results of her company's new quality control efforts. "Maybe the emphasis we've placed on upgrading our quality control system will pay off in the long run, but it doesn't seem to be helping us much right now. I thought improved quality would give a real boost to sales, but sales have remained flat at about $10,000,000 for the last two years."

Lee Enterprises has seen its market share decline in recent years because of increased foreign competition. An intensive effort to strengthen the quality control system was initiated a year ago (on January 1, 2011) in the hope that better quality would strengthen the company's competitive position and reduce warranty and servicing costs. The following costs (in thousands) relate to quality and quality control over the last two years:

 

2010

2011

Warranty repairs

$420

$140

Rework labor

140

200

Supplies used in testing

4

6

Depreciation of testing equipment

22

34

Warranty  replacements

60

18

Field servicing

180

120

Inspection

76

120

Systems  development

64

106

Disposal of defective products

54

76

Net cost of scrap

86

124

Product recalls

340

82

Product testing

98

160

Statistical process control

-

74

Quality engineering

56

80

Required

1. Prepare a spreadsheet that produces a cost-of-quality (COQ) report for both 2010 and 2011. Carry per- centage computations to two decimal places.

2. Use your spreadsheet to prepare a histogram showing the distribution of the various quality costs by category. (Note: Your histogram should include results for both 2010 and 2011.)

3. Prepare a written evaluation to accompany the reports you have prepared in requirements 1 and 2. This evaluation should discuss the distribution of quality costs in the company, changes in this distribution that you detect have taken place over the last year, and any other information you believe would be use- ful to management.

4. A member of the management team believes that employees will be more conscientious in their work if they are held responsible for mistakes. He suggests that workers should do rework on their own time and that they also should pay for disposal of defective units and the cost of scraps. The proposal estimates that the firm can save another $400,000 in quality costs and the employees are less likely to make as many errors. Should the firm implement the proposal? Why or why not?

Reference no: EM13876503

Questions Cloud

Right and the relative velocity : Small wheels attached to the ends of rod AB roll along two surfaces. Knowing that at the instant shown the velocity vA of wheel A is 4.5 ft/s to the right and the relative velocity vB/A of wheel B with respect to wheel A is perpendicular to rod AB,..
Identify steps that mary stein follow to resolve situation : Identify steps that Mary Stein should follow to resolve the situation. Explain why the request from Maria Sanchez to Mary Stein is unethical.
Identify the main issue or problem outlined within the case : Read through the case, "Cow Wow Cereal Milk". In a brief paragraph, identify the main issue/problem outlined within the case. Identify the market segments/clusters presented and any other relevant segments not mentioned in the case
Write essay on diversity : In this essay, you will write about diversity. The purpose of this essay is to demonstrate how you have met the diversity outcome through your past coursework or work experiences
Prepare a spreadsheet that produces a cost-of-quality report : Prepare a spreadsheet that produces a cost-of-quality (COQ) report for both 2010 and 2011. Carry per- centage computations to two decimal places.
Discuss why jan williams has an ethical responsibility : Discuss why Jan Williams has an ethical responsibility to take some action in the matter of GroChem, Inc., and the dumping of toxic wastes.
What is the total coq as a percentage of total sales : What is the total COQ as a percentage of total sales? Create a bar chart to compare the percentages of each of the COQ categories and the total COQ in 2010 and 2011.
What is the foundation of morals : "It may be objected that many who are capable of the higher pleasures occasionally, under the influence of temptation, postpone them to the lower." To what is this an objection? What is Mill's response?
Evaluate an existing computer work station : This activity is designed to give you an opportunity to apply ergonomic principles to evaluate an existing computer work station. You may evaluate your own computer work station or that of a co-worker or friend

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