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

  Find what is the net present value of investment

Find what is the net present value of this investment and evaluate the internal rate of return?

  What was the dealers original cost

Jim Abbott purchased a $60,000 RV with a 40 percent markup on selling price. (a) What was the amount of the dealer's markup? (b) What was the dealer's original cost?

  Calculate the amounts for the current year balances

Calculate the amounts for the current year Balances at the end of the year in AAA, AEP, and OAA, each shareholder's basis in ABC stock at the end of the current year and amounts included in AGI by each shareholder for the current year.

  A citys enterprise fund issued revenue bonds with a face

a citys enterprise fund issued revenue bonds with a face value of 10000000. the bonds were issued with a 2 percent

  How to compensate the purchaser for the coupon rate

A bond with an annual coupon payment of $100 originally sold at par for $1,000. Market interest rates are currently 12%. This bond would be selling at a  in order to compensate the purchaser for the below market coupon rate.

  Calculate quakes income from tremor for 2011

Prepare a schedule to allocate the investment fair values/book value differentials relating to Quake's investment in Tremor and calculate Quakes income from Tremor for 2011

  Discuss the problems of estimating overhead cost

Discuss key assumptions and limitations of the regression models which you considered and Discuss the problems of estimating overhead cost at the following projected activity level

  How many patient days does the hospital need to break even

How many patient days does the hospital need to break even and what level of revenue is needed to earn a target income of $540,000?

  What amount should the gain from the sale of the building

The prevailing rate of interest for a note of this type on January 1, 2014, was9%. At what amount should the gain from the sale of the building be reported?

  How many customers do mcdonalds have each year

How many customers do McDonald's have each year? What are the total assets for 2014? Find the Balance Sheet and identify the amounts and explain

  What is the amortization of other comprehensive loss

a. What is the pension expense that Rapley Enterprises should report for 2013 b. What is the amount that Rapley Enterprises should report as its pension liability on its balance sheet as of December 31, 2013

  Bee company collected 150000 from customers in 2010 of

bee company collected 150000 from customers in 2010. of amount collected 30000 was from revenues earned on account in

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