SM 4.9
Case Analyses
4-29. Pucinelli Supermarkets
Example:
Computations
(Column B)
UPC Code:
64200115896
Length Test:
OK
Check Digit is:
6
Sum of odd digits:
19
Sum of even digits:
17
Add digits x 3:
57
Sum:
74
Last digit:
4
Computed check
digit:
6
Conclusion:
valid number
Formulas for Column B
064200115896 (Stored in cell B2)
=IF(LEN(B2)=12, “OK”, “Not OK”)
=RIGHT(B2,1)
=MID(B2, 1, 1) + MID(B2, 3, 1) + MID(B2, 5, 1) + MID(B2, 7, 1) + MID(B2, 9, 1) + MID(B2,
11, 1)
=MID(B2, 2, 1) + MID(B2, 4, 1)+MID(B2, 6, 1) + MID(B2, 8, 1)+ MID(B2, 10,1)
=3*B5
=SUM(B6:B7)
=RIGHT(B8,1)
=IF(B9=0, 0, 10-B9)
=IF(AND(B3=”OK”,VALUE(B10)=VALUE(B4)),”valid number”, “invalid number”)
SM 4.10
1.
UPC Code:
Length Test:
Check Digit is:
Sum of odd digits:
Sum of even digits:
Add digits x 3:
Sum:
Last digit:
Computed check digit:
Conclusion:
2.
UPC Code:
Length Test:
Check Digit is:
Sum of odd digits:
Sum of even digits:
Add digits x 3:
30
Sum:
Last digit:
Computed check digit:
Conclusion:
SM 4.11
3.
UPC Code:
Length Test:
Check Digit is:
Sum of odd digits:
Sum of even digits:
Add digits x 3:
Sum:
Last digit:
Computed check digit:
Conclusion:
4.
UPC Code:
Length Test:
Check Digit is:
Sum of odd digits:
Sum of even digits:
Add digits x 3:
Sum:
Last digit:
9
Computed check digit:
Conclusion:
4-30. Savage Motors (Software Training)
Department
No. of
Employees
Word
Processing
Spread-
sheets
Data-base
Presentation
Graphics
Account-
ing
Sales
112
1150
750
900
500
700
Operations
82
320
2450
650
100
500
Accounting
55
750
3600
820
250
2500
Answers for:
Part 1:
No. of
Employees
Word
Processing
Spread-
sheets
Data-base
Presentation
Graphics
Account-
ing
Sales
112
10.3
6.7
8
4.5
6.3
Operations
82
2.9
21.9
5.8
0.9
4.5
Accounting
55
6.7
32.1
7.3
2.2
22.3
SM 4.12
Part 2:
Sales
1150
Word Processing
Operations
2450
Spreadsheets
Accounting
3600
Spreadsheets
Part 3:
No. of
Employees
Word
Processing
Spread-
sheets
Data-base
Presentation
Graphics
Account
ing
Totals:
249
2,220
6,800
2,370
850
3,700
Average
8.9
27.3
9.5
3.4
14.9
Spreadsheets are used the most hours.
Part 4:
0.0
5.0
10.0
15.0
20.0
25.0
30.0
35.0
Word
Processing
Spreadsheets
Database
Presentation
Graphcs
Accounting
Average per week
Software application
Average softrware usage by
application and department
Sales
Operations
Accounting
Part 5:
Answers will vary by students.
4-31. Backwater University
1. One possible solution is to use a coupon system for students. With this system, students
probably make sense to use student ID cards with magnetic stripes for faster throughput. A
several additional alternatives for this question.
2. No additional hardware is required for the coupon plan, although a centralized database of
students approved for a specific type of meal plan.
SM 4.13
3. The software required for the coupon system would maintain a central database of student
of students, plus information indicating whether or not a student used his or her card for a
4. Good information systems pay for themselves quickly. Thus, when evaluating the
entrance to the dining facilities, better control of student funds and plans, and perhaps even
chapters of the book.
4-32. Bennet National Bank
a) special bank code
i) secret passcode
2. The tests of conformity with bank policy and locations for such tests would be:
a) correct passcode test performed by client
f) overdrawing of account test performed by bank’s CPU using central files
4-33. Morrigan Department Stores (The Ethics of Forced Software Upgrading)
General comment: This case discusses the difficulties that most companies, government
SM 4.14
1. Roberta Gardner’s description of “64–bit machines” is not wrong, but probably overly
simplifies what this term means. The transition to 64-bit microprocessor designs represents a
2. Possible arguments against upgrading current hardware or software include:
3. Possible arguments in favor of upgrading current hardware or software include:
departments or branch offices
5. This question asks students if they feel if it is ethical for software vendors such as Microsoft,
Adobe or Apple to ship software packages with both known and unknown defects in them.
While most students are willing to make allowances for “unknown defects,” few are likely to
6. This question asks students if they agree with the argument that “many hardware and/or
SM 4.15
7. Students are likely to agree with Alex McLeod’s statement that companies should provide
training. However, the expectation to learn software “on your own” is a common policy and
common expectation especially characteristic of corporate policy in times of tight budgets.
professional accountants.
8. This question asks students whether or not they feel it was necessary for the corporate
participants in this case to physically meet in one location. Certainly, with the (often free)
availability of conferencing software such as Skype or other messaging software, for