Is there anyone who can help me solve this problems ? I appreciate your great help!
Below are some quality-related numbers for Precision Manufacturing Company, for the past five years (20
quarters). BE CAREFUL NOT TO ALTER, AS SHEET IS UNPROTECTED TO ALLOW PASTING CHARTS.
Quarter
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Average
Quarterly
Absentee
personnel
P
A
I (internal
Rate
turnover rate (prevention) (appraisal)
failure)
15.0%
11.00%
$30,000
$50,000
$70,109
14.7%
9.61%
$30,870
$45,053
$70,204
12.6%
7.63%
$31,783
$40,469
$69,855
10.5%
8.75%
$32,711
$36,326
$68,182
11.0%
7.59%
$33,724
$32,641
$66,512
7.2%
6.32%
$34,695
$29,374
$64,845
7.7%
5.09%
$35,802
$26,260
$63,180
8.6%
6.54%
$36,834
$23,593
$61,517
5.4%
5.79%
$37,932
$21,153
$59,857
8.9%
7.30%
$39,039
$19,145
$58,199
7.2%
5.75%
$40,215
$17,074
$56,544
4.9%
4.13%
$41,443
$15,407
$54,891
7.4%
6.30%
$42,756
$13,761
$53,241
8.0%
5.16%
$43,965
$12,190
$51,593
4.7%
6.54%
$45,238
$11,071
$49,947
6.0%
4.07%
$46,517
$10,152
$48,305
5.1%
5.67%
$47,944
$9,005
$46,664
5.8%
3.63%
$49,305
$8,101
$45,025
7.6%
2.53%
$50,690
$7,178
$43,389
6.1%
4.44%
$52,284
$6,566
$41,756
E
(external
failure)
$90,958
$90,239
$96,260
$103,414
$105,203
$99,724
$93,050
$97,465
$93,913
$97,409
$89,553
$89,127
$88,564
$91,384
$91,394
$86,114
$89,432
$81,173
$78,992
$75,378
Total Percent of
Quality original
Costs
total
$241,067
100%
$236,366
98%
$238,367
99%
$240,633
100%
$238,080
99%
$228,638
95%
$218,292
91%
$219,408
91%
$212,855
88%
$213,793
89%
$203,386
84%
$200,868
83%
$198,321
82%
$199,132
83%
$197,651
82%
$191,088
79%
$193,045
80%
$183,604
76%
$180,250
75%
$175,984
73%
What can you conclude from the numbers? What actions does management appear to be taking, and are
they paying off? Insert charts* below to demonstrate key trends, and refer to them in your discussion.
Limit your discussion to the space provided, without changing the font.
Show charts and any calculations below:
*Note that a chart is easy to create by selecting the table and going to Insert?