Acme Materials Company manufactures and sells synthetic coatings that can withstand high temperatures. Its primary customers are aviation manufacturers and maintenance companies. The following table contains financial information pertaining to cost of quality (COQ) in 2022 and 2023 (in thousands of dollars): 2022
Acme Materials Company manufactures and sells synthetic coatings that can withstand high temperatures. Its primary customers are aviation manufacturers and maintenance companies. The following table contains financial information pertaining to cost of quality (COQ) in 2022 and 2023 (in thousands of dollars): 2022
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...
Related questions
Question
Do not give image format
![Required information
[The following information applies to the questions displayed below.]
Acme Materials Company manufactures and sells synthetic coatings that can withstand high temperatures. Its primary
customers are aviation manufacturers and maintenance companies. The following table contains financial information
pertaining to cost of quality (COQ) in 2022 and 2023 (in thousands of dollars):
Sales
Materials inspection
In-process (production) inspection
Finished product inspection
Preventive equipment maintenance
Scrap (net)
Warranty repairs
Product design engineering
Vendor certification
Direct costs of returned goods
Training of factory workers
Product testing-equipment maintenance
Product testing labor
Field repairs
Rework before shipment
Product-liability settlement
Emergency repair and maintenance
3a.
3b.
3c.
3d.
3e.
3f.
e. Percentage change in total internal failure costs, 2022 to 2023;
f. Percentage change in total external failure costs, 2022 to 2023.
Req 1 and 2
2022
$ 16,500
350
165
300
25
550
750
155
15
325
Req 3
45
65
260
75
290
410
250
Complete this question by entering your answers in the tabs below.
Required:
1. Classify the cost items in the table into cost-of-quality (CDQ) categories.
2. Calculate the ratio of each COQ category to revenues in each of the 2 years.
3. Calculate the percentage change in each COQ category and total COQ and comment on the results:
a. Percentage change in total COQ as a percentage of sales, from 2022 to 2023;
b. Total COQ in 2023 expressed as a percentage of 2022 sales dollars;
c. Percentage change in total prevention costs, 2022 to 2023;
d. Percentage change in total appraisal costs, 2022 to 2023;
> Answer is not complete.
Percentage change in total COQ as a percentage of sales, from 2022 to 2023
Total COQ in 2023 expressed as a percentage of 2022 sales dollars
Percentage change in total prevention costs, 2022 to 2023
Percentage change in total appraisal costs, 2022 to 2023
Percentage change in total internal failure costs, 2022 to 2023
Percentage change in total external failure costs, 2022 to 2023
< Req 1 and 2
2023
$ 20,500
65
130
75
65
Req 3 >
350
500
Calculate the percentage change in each COQ category and total COQ and comment on the results: (Round your answers to 2
decimal places.)
320
65
85
145
65
95
45
205
65
80
1,675.00 % decrease
%
116.39 X %
increase
66.04 X
%
decrease
41.74 % decrease
55.44 %
decrease
oooo
✓](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fdf558df7-ab88-43d4-aa53-b38a541bb6de%2F6ff6b760-c648-4bd0-9a2e-b2a7722cb781%2Fju16ukb_processed.png&w=3840&q=75)
Transcribed Image Text:Required information
[The following information applies to the questions displayed below.]
Acme Materials Company manufactures and sells synthetic coatings that can withstand high temperatures. Its primary
customers are aviation manufacturers and maintenance companies. The following table contains financial information
pertaining to cost of quality (COQ) in 2022 and 2023 (in thousands of dollars):
Sales
Materials inspection
In-process (production) inspection
Finished product inspection
Preventive equipment maintenance
Scrap (net)
Warranty repairs
Product design engineering
Vendor certification
Direct costs of returned goods
Training of factory workers
Product testing-equipment maintenance
Product testing labor
Field repairs
Rework before shipment
Product-liability settlement
Emergency repair and maintenance
3a.
3b.
3c.
3d.
3e.
3f.
e. Percentage change in total internal failure costs, 2022 to 2023;
f. Percentage change in total external failure costs, 2022 to 2023.
Req 1 and 2
2022
$ 16,500
350
165
300
25
550
750
155
15
325
Req 3
45
65
260
75
290
410
250
Complete this question by entering your answers in the tabs below.
Required:
1. Classify the cost items in the table into cost-of-quality (CDQ) categories.
2. Calculate the ratio of each COQ category to revenues in each of the 2 years.
3. Calculate the percentage change in each COQ category and total COQ and comment on the results:
a. Percentage change in total COQ as a percentage of sales, from 2022 to 2023;
b. Total COQ in 2023 expressed as a percentage of 2022 sales dollars;
c. Percentage change in total prevention costs, 2022 to 2023;
d. Percentage change in total appraisal costs, 2022 to 2023;
> Answer is not complete.
Percentage change in total COQ as a percentage of sales, from 2022 to 2023
Total COQ in 2023 expressed as a percentage of 2022 sales dollars
Percentage change in total prevention costs, 2022 to 2023
Percentage change in total appraisal costs, 2022 to 2023
Percentage change in total internal failure costs, 2022 to 2023
Percentage change in total external failure costs, 2022 to 2023
< Req 1 and 2
2023
$ 20,500
65
130
75
65
Req 3 >
350
500
Calculate the percentage change in each COQ category and total COQ and comment on the results: (Round your answers to 2
decimal places.)
320
65
85
145
65
95
45
205
65
80
1,675.00 % decrease
%
116.39 X %
increase
66.04 X
%
decrease
41.74 % decrease
55.44 %
decrease
oooo
✓
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: Introduce about cost of quality (COQ)
VIEWStep 2: 1. Classify the cost elements into the appropriate cost of quality categories.
VIEWStep 3: 2. Calculate the ratio of each COQ category to revenues in each of the 2 years
VIEWStep 4: 3. Calculate the % change in each COQ category and total COQ and comment on the results.
VIEWStep 5: Provide the answer to each of the subpart of part 3 for part a and b.
VIEWStep 6: Provide the answer to each of the subpart of part 3 for part c and f.
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 7 steps with 10 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.