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...
icon
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
✓
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 10 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.