In response to intensive foreign competition, the management of Florex Company has attempted over the past year to improve the quality of its products. A statistical process control system has been installed and other steps have been taken to decrease the amount of warranty and other field costs, which have been trending upward over the past several years. Costs relating to quality and quality control over the last two years are given below: Costs (in thousands) Last Year This Year Inspection $ 720 $ 909 Quality engineering $ 450 $ 765 Depreciation of test equipment $ 675 $ 270 Rework labor $ 1,080 $ 1,530 Statistical process control $ 0 $ 225 Cost of field servicing $ 1,350 $ 1,260 Supplies used in testing $ 45 $ 81 Systems development $ 720 $ 900 Warranty repairs $ 3,780 $ 1,620 Net cost of scrap $ 630 $ 1,170 Product testing $ 900 $ 1,800 Product recalls $ 3,150 $ 900 Disposal of defective products $ 810 $ 1,080 Sales have been flat over the past few years, at $90,000,000 per year. A great deal of money has been spent in the effort to upgrade quality, and management is anxious to see whether or not the effort has been effective. Required: 1. Prepare a quality cost report that contains data for both this year and last year. (Enter amount values in thousands. Round your percentage answers to 2 decimal places (i.e 0.1234 should be entered as 12.34)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

In response to intensive foreign competition, the management of Florex Company has attempted over the past year to improve the quality of its products. A statistical process control system has been installed and other steps have been taken to decrease the amount of warranty and other field costs, which have been trending upward over the past several years. Costs relating to quality and quality control over the last two years are given below:

	Costs (in thousands)
Last Year	This Year
Inspection	$ 720	$ 909
Quality engineering	$ 450	$ 765
Depreciation of test equipment	$ 675	$ 270
Rework labor	$ 1,080	$ 1,530
Statistical process control	$ 0	$ 225
Cost of field servicing	$ 1,350	$ 1,260
Supplies used in testing	$ 45	$ 81
Systems development	$ 720	$ 900
Warranty repairs	$ 3,780	$ 1,620
Net cost of scrap	$ 630	$ 1,170
Product testing	$ 900	$ 1,800
Product recalls	$ 3,150	$ 900
Disposal of defective products	$ 810	$ 1,080

Sales have been flat over the past few years, at $90,000,000 per year. A great deal of money has been spent in the effort to upgrade quality, and management is anxious to see whether or not the effort has been effective.

Required:

1. Prepare a quality cost report that contains data for both this year and last year. (Enter amount values in thousands. Round your percentage answers to 2 decimal places (i.e 0.1234 should be entered as 12.34).)

Expert Solution