Pucinneli Supermarkets is similar to most other grocery store chains that use the 12-digit UPC code on packages to check out customers. For a variety of reasons, it is important that the computer systems using these codes validate them for accuracy and completeness. To perform this task, UPCs automatically include a “check digit” that can also be computed from the other digits in the code.

Requirement

Develop a spreadsheet to perform the tests described here and test your model with the following UPC codes.

(1) 639277240453

(2) 040000234548

(3) 034000087884

(4) 048109352495