13.03
In 20X1, Don Blackburn, president of Price Electronics, received a report indicating that quality costs were 31% of sales. Faced with increasing pressures from imported goods, Don resolved to take measures to improve the overall quality of the company’s products. After hiring a consultant in 20X1, the company began an aggressive program of total quality control. At the end of 20X5, Don requested an analysis of the progress the company had made in reducing and controlling quality costs. The accounting department assembled the following data:
Sales | Prevention | Appraisal | Internal Failure | External Failure | |||||||||||
20X1 | $1,000,000 | $10,000 | $20,000 | $160,000 | $120,000 | ||||||||||
20X2 | 1,200,000 | 50,000 | 30,000 | 120,000 | 100,000 | ||||||||||
20X3 | 1,400,000 | 70,000 | 60,000 | 70,000 | 50,000 | ||||||||||
20X4 | 1,200,000 | 80,000 | 30,000 | 50,000 | 40,000 | ||||||||||
20X5 | 1,000,000 | 100,000 | 10,000 | 24,000 | 16,000 |
Required:
1. Compute the quality costs as a percentage of sales by category and in total for each year. Round your answers to two decimal places.
Prevention | Appraisal | Internal Failure | External Failure | Total | |||||||||||
20X1 | % | % | % | % | % | ||||||||||
20X2 | |||||||||||||||
20X3 | |||||||||||||||
20X4 | |||||||||||||||
20X5 |
2. Prepare a multiple-year trend graph for quality costs, both by total costs and by category in your own paper. Using the graph, assess the progress made in reducing and controlling quality costs. Does the graph provide evidence that quality has improved? Explain.
Quality costs overall have (Pick One: Decreased or Increased) . Real evidence of this change stems from the fact that (Pick One: External Failure and Appraisal, Internal Failure and Appraisal, or Internal and External Failure) costs have (Pick One: Decreased or Increased) the most.
3. Using the 20X1 quality cost relationships (assume all costs are variable), calculate the quality costs that would have prevailed in 20X4.
Prevention | Appraisal | Internal Failure | External Failure | Total | |||||||||||
20X4 | $ | $ | $ | $ | $ | ||||||||||
20X5 |
By how much did profits increase in 20X4 because of the quality
improvement program? Repeat for 20X5.
20X4 $
20X5 $
Progress made in reducing and controlling quality cost is commentable. In 20X1 the total quality cost was 31%, where as at the end of year 20X5 it has come down to just 15% of total sales.
If we look into the graph we can understand that Prevention and Appraisal cost has increased whereas Internal, external failure costs have decreased, this is an indication of quality improvement. Prevention cost is the cost incurred to avoid or minimize the production of defective products (Examples:- Training to employees, quality engineering). Appraisal costs are cost on certain procedures employed to avoid defective products (Example:- Inspection of raw materials). Both Prevention and Appraisal costs are incurred before the final product is manufactured. Internal and external failure costs are the cost incurred to correct the costs before sales or after sales respectively. Thus Internal and external sales are incurred after final product is manufactured. Now if you look into the chart, you will find that both Prevention and Appraisal cost has increased whereas Internal and External failure cost has reduced. This means that cost of quality before product manufacture has increased and cost of quality after product manufacture has decreased, which further means that the quality of product has increased, thereby reducing Internal and external failure cost.
Quality costs overall have Decreased. Real evidence of this change stems from the fact that Internal and External Failure costs have Decreased the most.
Question 3:-
Since all costs are variable, the percentage of each category of quality cost to total sales of 20X4 and 20X5 will be same as 20X1. Below is the table after calculation:
By how much did profits increase in 20X4 because of the quality improvement program?
20X4 = Total cost without quality improvement program - Total cost with quality improvement program
= $372,000 - $200,000
= $172,000
20X5 = Total cost without quality improvement program - Total cost with quality improvement program
= $310,000 - $150,000
= $160,000
Not sure how the answer above got those values, but #1 should be
1000000 | 10000 | 1.00 | 1200000 | 80000 | 6.67 | 1400000 | 70000 | 5.00 | 1200000 | 80000 | 6.67 | 1000000 | 100000 | 10.00 | ||||
1000000 | 20000 | 2.00 | 1200000 | 30000 | 2.50 | 1400000 | 60000 | 4.29 | 1200000 | 30000 | 2.50 | 1000000 | 10000 | 1.00 | ||||
1000000 | 160000 | 16.00 | 1200000 | 50000 | 4.17 | 1400000 | 70000 | 5.00 | 1200000 | 50000 | 4.17 | 1000000 | 24000 | 2.40 | ||||
1000000 | 120000 | 12.00 | 1200000 | 40000 | 3.33 | 1400000 | 50000 | 3.57 | 1200000 | 40000 | 3.33 | 1000000 | 16000 | 1.60 | ||||
31.00 | 16.67 | 17.86 | 16.67 | 15.00 |
13.03 In 20X1, Don Blackburn, president of Price Electronics, received a report indicating that quality costs...
Pintura Company implemented a quality improvement program and tracked the following for the five years: 20X1 20X2 20X3 20X4 Quality Costs $750,000 690,000 680,000 510,000 480,000 Actual Sales $3,000,000 3,000,000 3,400,000 3,400,000 4,000,000 Costs as a Percentage of Sales 25.00% 23.00 20.00 15.00 12.00 20X5 By cost category as a percentage of sales for the same period of time: Appraisal 1.50% External Failure 13.00% 10.50 20X1 20X2 20X3 20X4 20X5 Prevention 1.00% 2.00 2.50 3.00 3.50 Internal Failure 9.50% 8.50...
Interim Quality Performance Report Davis, Inc., had the following quality costs for the years ended December 31, 20x4 and 20x5: 20x4 20x5 Prevention costs: Quality audits $71,000 $106,500 Vendor certification 124,500 186,750 Appraisal costs: Product acceptance $93,000 $139,500 Process acceptance 85,000 107,500 Internal failure costs: Retesting $108,000 $90,000 Rework 200,000 188,000 External failure costs: Recalls $135,000 $108,000 Warranty 315,000 318,000 At the end of 20x4, management decided to increase its investment in control costs by 50 percent for each category’s...
Interim Quality Performance Report Davis, Inc., had the following quality costs for the years ended December 31, 20x4 and 20x5: 20x4 20x5 Prevention costs: Quality audits $60,000 $90,000 Vendor certification 119,500 179,250 Appraisal costs: Product acceptance $90,000 $135,000 Process acceptance 91,000 102,500 Internal failure costs: Retesting $96,000 $86,000 Rework 200,000 176,000 External failure costs: Recalls $142,500 $114,000 Warranty 330,000 314,000 At the end of 20x4, management decided to increase its investment in control costs by 50 percent for each category’s...
Davis, Inc., had the following quality costs for the years ended December 31, 20x4 and 20x5: 20x4 20x5 Prevention costs: Quality audits $69,000 $103,500 Vendor certification 127,500 191.250 Appraisal costs: Product acceptance $90,000 $135,000 Process acceptance 97,000 117,500 Internal failure costs: Retesting $92,000 $96,000 Rework 204,000 170,000 External failure costs: Recalls $127,500 $102,000 Warranty 305,000 302,000 At the end of 20x4, management decided to increase its investment in control costs by 50 percent for each category's items with the expectation...
Quality Cost Report Evans Company had total sales of $3,800,000 for fiscal 20x5. The costs of quality-related activities are given below. Returns/allowances $190,000 Design changes 228,000 Prototype inspection 11,400 Downtime 152,000 Quality circles 7,600 Packaging inspection 15,200 Field testing 7,600 Complaint adjustment 209,000 Required: 1. Prepare a quality cost report, classifying costs by category and expressing each category as a percentage of sales. Round percentages to one decimal place, when rounding is required. For example, 5.78% would be entered as...
Quality Cost Report Evans Company had total sales of $1,800,000 for fiscal 20x5. The costs of quality-related activities are given below. Returns/allowances $90,000 Design changes 72,000 Prototype inspection 3,600 Downtime 90,000 Quality circles 5,400 Packaging inspection 7,200 Field testing 5,400 Complaint adjustment 90,000 Required: 1. Prepare a quality cost report, classifying costs by category and expressing each category as a percentage of sales. Round percentages to one decimal place, when rounding is required. For example, 5.78% would be entered as...
Pareto Chart and Cost of Quality Report for a Manufacturing Company The president of Mission Inc. has been concerned about the growth in costs over the last several years. The president asked the controller to perform an activity analysis to gain a better insight into these costs. The result of the activity analysis is summarized as follows: Required: 1. Classify the activities into prevention, appraisal, internal failure, external failure, and not costs of quality (producing product). Classify the activities into...
Nabors Company had actual quality costs for the year ended June 30,20x5, as given below. Prevention costs: $ 350,000 Prototype inspection Vendor certification 700,000 $ 1,050.000 Total prevention costs Appraisal costs: Process acceptance $365,000 Test labor 410,000 Total Appraisal costs $ 775.000 Internal failure costs: Retesting $ 212,500 Rework 425,000 Total internal failure costs $ 637.500 External failure costs: Recalls $ 227.250 Product liability 515,750 Total external failure costs $ 743,000 Total quality costs $3,205,500 At the zero-defect state, Nabors...
Question No-1 Ventura Company; Quality Cost Report For Years 2017 and 2018 2017 2018 Amount Percentage Amount Percentage Prevention cost 650,000 1.30% 1,000,000 2.00% Appraisal cost 1,200,000 2.40% 1,500,000 3.00% Internal failure cost 2,000,000 4.00% 3,000,000 6.00% External failure cost 5,150,000 10.30% 2,000,000 4.00% Total Quality Costs 9,000,000 18.00% 7,500,000 15.00% Sales 50,000,000 50,000,000 a)Prepare a written evaluation report with graph (use percentage column in the graph) for the Ventura Company on the basis of following quality costs report.
Pareto Chart and A report summarizing the costs, percent of total, and percent of sales by appraisal, prevention, internal failure, and external failure cost of quality categories.Cost of Quality Report for a Manufacturing Company The president of Mission Inc. has been concerned about the growth in costs over the last several years. The president asked the controller to perform an The study of employee effort and other business records to determine the cost of activities.activity analysis to gain a better...