5. Analyze the cost data in the Excel workbook C08Data.xlsx for the Costcutin Co
ID: 339642 • Letter: 5
Question
5. Analyze the cost data in the Excel workbook C08Data.xlsx for the Costcutin Co. What percent of sales are represented by each category of cost? What are the implications of these data for management?
9. The Excel workbook C08Data.xlsx provides data on quality losses at Nosoco Paper Mill. Construct an appropriate Excel chart to analyze the data. What conclusions do you reach?
22. River Bottom Fire Department is evaluating their response times in order to determine whether a new fire station is needed. Samples were taken for 30 ran- dom days from 6 stations. These data can be found in the worksheet Prob. 8-22 in the C08Data.xlsx file. a. Using Microsoft Excel® or similar software with statistical capability, construct a histogram for these 180 individual readings. b. Construct a run chart for the sample means. c. Interpret what the data show. Does the process appear to be in control?
Problem 8-5 Costcutin Co. Product $1,537.280 $933,600 $1,397,120 18% Total sales Total quality costs as % of sales 21% 12% External failure Internal failure Appraisal Prevention 30% 55% 11% 4% 19% 31% 39% 11% 10% 28% 36% 26% (Bold figures represent percentages of quality costs by product.)Explanation / Answer
The cost data table of the Costcutin Co.
The implications of these data for management shows that in case of A the Total quality cost is more than C which shows that the cost associated with it is more. This would be reduced if the Sales has to be made effective.
The Product B shows that the amount which is used in the Quality Sales is very effective than any other process as it is low than other product. Internal failures are more in the case of A product which shows that as per the sales figure the failures to the product is more so it effects the business goodwill.
Product
A
B
C
Sales
1,537,280.00
933,600.00
1,397,120.00
Total Quality Cost
as % of Sales
21%
18%
12%
in Amount ($ milion)
322,828.80
168,048.00
167,654.40
External failure %
30%
19%
10%
in Amount ($ milion)
96,848.64
31,929.12
16,765.44
Internal Failure
55%
31%
28%
in Amount ($ milion)
177,555.84
52,094.88
46,943.23
Appraisal
11%
39%
36%
in Amount ($ milion)
35,511.17
65,538.72
60,355.58
Prevention
4%
11%
26%
in Amount ($ milion)
12,913.15
18,485.28
43,590.14
Product
A
B
C
Sales
1,537,280.00
933,600.00
1,397,120.00
Total Quality Cost
as % of Sales
21%
18%
12%
in Amount ($ milion)
322,828.80
168,048.00
167,654.40
External failure %
30%
19%
10%
in Amount ($ milion)
96,848.64
31,929.12
16,765.44
Internal Failure
55%
31%
28%
in Amount ($ milion)
177,555.84
52,094.88
46,943.23
Appraisal
11%
39%
36%
in Amount ($ milion)
35,511.17
65,538.72
60,355.58
Prevention
4%
11%
26%
in Amount ($ milion)
12,913.15
18,485.28
43,590.14
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.