Excel Problem
Enter the data below into a spreadsheet, and then perform the following tasks:
EMPLOYEE NUMBER | PAY RATE | HOURS WORKED | GROSS PAY | DEDUCTIONS | NET PAY |
12355 | 10.55 | 38 | 400.90 | 125.00 | 275.90 |
2178g | 11.00 | 40 | 440.00 | 395.00 | 45.00 |
24456 | 95.00 | 90 | 8,550.00 | 145.00 | 8,405.00 |
34567 | 10.00 | 40 | 400.00 | 105.00 | 505.00 |
a. Calculate examples of these batch totals:
• A hash total
• A financial total
• A record count
b. Assume the following rules govern normal data:
• Employee numbers are five digits in length and range from 10000 through 99999.
• Maximum pay rate is $25, and minimum is $9.
• Hours worked should never exceed 40.
• Deductions should never exceed 40% of gross pay.
Give a specific example of an error or probable error in the data set that each of the following controls would detect:
• Field check
• Limit check
• Reasonableness test
• Cross-footing balance test
c. Create a control procedure that would prevent, or at least detect, each of the errors in the data set.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.