There are 44 payroll transactions in the Payroll file. (This is determined by reading the number at the bottom of the screen. ) b. The largest and smallest gross pay amounts for September are $4,395.
83 and $1,278. 33, respectively. (Use Quick Sort. ) c. Total gross pay for September was $99,585. 46.
(Use the Total command. ) d. The report on the following page shows gross pay by department. (Use the Summarize command on the Gross Pay column, save to a file, and print.
) Note that this screenshot was produced using the “Screen” option in the Output tab of the Summarize window.Students’ hardcopy printouts will appear slightly different, but will contain the same departmental totals. e. There are no exceptions in the calculation of net pay for September. (Use the following Filter: Gross Pay – Taxes < > Net Pay.
) f. There are no duplicate check numbers. (Use the Duplicates command on the check [cheque] number column). There are four missing checks (#12389- #12392). The audit concern is that there may be unrecorded payroll transactions. (Use the Gaps command on the check [cheque] number column.
) Report for requirement d: [pic] Chapter 8There are 148 positive amounts, 2 zero amounts, and 2 negative amounts. b. There are several negative values in inventory, which is not possible. There is also one especially large item that should be verified.
c. There are alternative Expressions that can be used. One is Value/MktVal. Three items have market value less than cost. Several have a small difference between market value and cost that may night represent normal markups.
