Top Billers processes bills for customers. Lately, they have been getting complaints of errors in the bills

Question:

Top Billers processes bills for customers. Lately, they have been getting complaints of errors in the bills they have processed. Bills can contain errors resulting from a number of causes, such as incorrect amounts, wrong dates, wrong customer information, etc. The quality manager for Top Billers decides to sample one customer’s batch of bills per day to determine the number and proportion of errors. Use a u-chart to analyze the data found in the table in the worksheet Prob07-09 in the Ch07Data.xlsx file.

 

Top Billers
























Average Number of Nonconformances Per Unit (u) Chart







This spreadsheet is designed for up to 75 samples. Enter data ONLY in yellow-shaded cells.




Click on the sheet tab to display the control chart (some rescaling may be needed). 


















Average (u-bar)0.01406























Sample










Number ofUnitDefects Standard







SampleNonconformancesSizeper unitDeviationLCLuCLUCLu




121710.01170.0090700.01410.0413

2171
211940.00520.0085100.01410.0396

1194
311210.00830.0107800.01410.0464

1121
432000.01500.0083900.01410.0392

3200
511590.00630.0094000.01410.0423

1159
631620.01850.0093200.01410.0420

3162
741860.02150.0087000.01410.0402

4186
811820.00550.0087900.01410.0404

1182
921550.01290.0095300.01410.0426

2155
1021850.01080.0087200.01410.0402

2185
1111790.00560.0088600.01410.0407

1179
1231600.01880.0093800.01410.0422

3160
1311590.00630.0094000.01410.0423

1159
1411540.00650.0095600.01410.0427

1154
1571510.04640.0096500.01410.0430

7151
1651690.02960.0091200.01410.0414

5169
1731890.01590.0086300.01410.0399

3189
1841780.02250.0088900.01410.0407

4178
1921610.01240.0093500.01410.0421

2161
2011980.00510.0084300.01410.0393

1198
21

#N/A#N/A#N/A#N/A#N/A




22

#N/A#N/A#N/A#N/A#N/A
SUM = 483413
23

#N/A#N/A#N/A#N/A#N/A




24

#N/A#N/A#N/A#N/A#N/A




25

#N/A#N/A#N/A#N/A#N/A




26

#N/A#N/A#N/A#N/A#N/A




27

#N/A#N/A#N/A#N/A#N/A




28

#N/A#N/A#N/A#N/A#N/A




29

#N/A#N/A#N/A#N/A#N/A




30

#N/A#N/A#N/A#N/A#N/A




31

#N/A#N/A#N/A#N/A#N/A




32

#N/A#N/A#N/A#N/A#N/A




33

#N/A#N/A#N/A#N/A#N/A




34

#N/A#N/A#N/A#N/A#N/A




35

#N/A#N/A#N/A#N/A#N/A




36

#N/A#N/A#N/A#N/A#N/A




37

#N/A#N/A#N/A#N/A#N/A




38

#N/A#N/A#N/A#N/A#N/A




39

#N/A#N/A#N/A#N/A#N/A




40

#N/A#N/A#N/A#N/A#N/A




41

#N/A#N/A#N/A#N/A#N/A




42

#N/A#N/A#N/A#N/A#N/A




43

#N/A#N/A#N/A#N/A#N/A




44

#N/A#N/A#N/A#N/A#N/A




45

#N/A#N/A#N/A#N/A#N/A




46

#N/A#N/A#N/A#N/A#N/A

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

Step by Step Answer:

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