Cost of quality data are often expressed as indexes by dividing by some reference value, such as

Question:

Cost of quality data are often expressed as indexes by dividing by some reference value, such as cost/sales dollar or cost/labor dollar. Compute a labor cost base index for Loire Valley Wine Co. from data in the worksheet Prob03-09 in the Excel workbook Ch03Data.xlsx on the Student Companion website, and prepare a memo to management.


 























































































































































































































































Loire Valley Wine Co.
$000's QUARTERLY QUALITY COSTS
1234
Total labor18,00017,50020,50017,200
% Total Labor/Base 10097.22113.8995.56
External failure1,400900950530
Internal failure1,7001,9251,250900
Appraisal9001,1001,350700
Prevention4006009001,100
Total Quality Cost4,4004,5254,4503,230
PERCENTAGES QTRLY. QUALITY/LABOR COSTS
1 Qtr.2 Qtr.3 Qtr.4 Qtr.
External failure7.785.144.633.08
Internal failure9.4411.006.105.23
Appraisal5.006.296.594.07
Prevention2.223.434.396.40
Total Quality/Labor Cost 24.4425.8621.7118.78


image

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: