This problem requires the use of ACL software, which is included in the CD attached to the text. Information about installing and using ACL and solving this problem can be found in Appendix, pages 838-842. You should read all of the reference material preceding instructions about "Quick Sort" before locating the appropriate command to answer questions a-f. For this problem, use the file labeled "Payroll" in the "Payroll-Analysis" subfolder under tables in Sample-Project. The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.
a. Determine the number of payroll transactions in the file. (Read the bottom of the Payroll file screen.)
b. Determine the largest and smallest payroll transaction (gross pay) for the month of September. (Quick Sort)
c. Determine gross pay for September. (Total)
d. Determine and print gross pay by department. (Summarize)
e. Recalculate net pay for each payroll transaction for September and compare it to the amount included in the file. (Filter)
f. Determine if there are any gaps or duplicates in the check (cheque) numbers. If there are gaps or duplicates, what is your concern?
(Gaps and Duplicates)