O Question 29 10 p The following table is a listing of the payroll checks prepared and paid on June 15 2020. The payroll covers the week ended u 13, 2020. The report is sorted by payroll check number. Checks issued on June 15, 2020 started with number 91111. The employee's name and number is listed. The employee name should only be fifteen characters long -- including spaces. The employee number should be unique to each employee and should be in a range from 110 to 300. Because of the labor union contract, no employee can work more than 54 hours a week. The employees are paid at a hourly rate between $20 and $49 hour. In order to determine the propriety of the hours and pay rate each employee's gross pay is initialed by their manager only acceptable initials are CAH,MJK, GWY, and APT. Deductions from gross pay should be between 30% and 55% of Net pay is gross pay minus deductions. Required: 1. What is the record count for the table? 2. Identify a column from the table that has a hash total (only identify one column for each): 3. Identify a column from the table that has a financial total (only identify one column for each): 4. Identify seven specific cells (fields) in the table that are in error and the processing control would detect or pres the cell by coordinate - ie 1A -- and give the processing control (you can only use a processing control once): MacBook Air #WN Payroll Row Check Number Date Number 6/15/2020 91111 6/15/2020 91112 6/15/2020 91113 6/15/2020 91114 6/15/2020 91115 6/15/2020 91116 6/15/2020 91117 6/15/2020 91118 6/15/2020 91119 6/15/2020 91120 6/15/2020 91121 6/15/2020 91122 E F G H Gross Pay Deductions Approval Employee Hours Wage per Gross from Net Employee Initials Name Worked Hour Pay Pay Pay Number GWY S. Smith 40 35.48 1.419.20 681.22 737.98 200 APT E. Johnson 21.71 521.04 203.21 317.83 292 V. Williams 37.36 9,713.60 4,079.71 5,633.89 289 MJK W. Jones 19.09 572.70 251.99 320.71 160 MJK G. Brown 38.69 2,050.57 840.73 1.209.84 172 APT S. Davis 22.30 535.20 208.73 326.47 24 N. Miller 37.46 1,947.92 915.52 1,032.40 2 H. Wilson 22.50 472.50 151.20 321.30 GWY D. Moore 49 35.72 1,750.28 840.13 910.15 U. Taylor 43.85 1.140.10 776.23 363.87 MJK S. Schottsneider 40 26.28 1.051.20 578.16 473.04 - 42 MJK K. Thomas 23.16 972.72 418.27 554.4" MacBook Air GENERAL LEDGER 6/7 6/7 10100 - Cash Date Description 6/1 Beginning Balance Check #1140 Deposit Check #1141 6/8 Deposit 6/8 Check #1142 6/14 Check #1143 6/14 Check #1144 6/15 Check #1145 6/16 Check #1146 6/19 Deposit 6/21 Check #1147 6/22 Check #1148 6/22 Check #1149 Post Debit Credit Balance 51,179.71 2,575.00 48,604.71 4,090.52 52,695.23 7.367.00 45,328,23 2,806.00 48,134.23 34,390.50 13,743.73 1,360.25 12,383.48 778.75 11,604.73 3,523.23 8,081.50 14.82 8,066.68 45,000.00 53,066.68 45.75 53,020.93 2,790.54 50,230.39 160200 48.628.39 6/21 Check #1147 6/22 Check W1148 6/22 Check #1149 6/22 Check #1150 6/22 Check #1151 6/23 Deposit 6/25 Deposit 6/26 Check #1152 6/26 Deposit 6/30 Check #1153 Check #1154 6/30 Check #1156 6/30 Check #1157 6/30 Check #1159 6/30 Check #1160 6/30 Check #1161 6/30 Check #1162 6/30 Deposit 6/30 45,000.00 53.06668 45.75 53.020.93 2.790.54 50.230.39 1.602.00 48.628.39 1,324.35 47,304.04 1.350.00 5,954.04 6,122.88 52.076.92 7.880.25 59.957.17 615.05 59,342.12 1.920.80 61.262.92 1.322.98 59.939.94 4.762.52 55,177.42 519.50 54,657.92 3,620.83 51,037.09 6,220.20 44,816.89 50.19 44,766.70 198.75 44,567.95 2,120.63 42,447.32 19,190.36 61,637.68 No new data to save. Last checked a O Question 29 10 p The following table is a listing of the payroll checks prepared and paid on June 15 2020. The payroll covers the week ended u 13, 2020. The report is sorted by payroll check number. Checks issued on June 15, 2020 started with number 91111. The employee's name and number is listed. The employee name should only be fifteen characters long -- including spaces. The employee number should be unique to each employee and should be in a range from 110 to 300. Because of the labor union contract, no employee can work more than 54 hours a week. The employees are paid at a hourly rate between $20 and $49 hour. In order to determine the propriety of the hours and pay rate each employee's gross pay is initialed by their manager only acceptable initials are CAH,MJK, GWY, and APT. Deductions from gross pay should be between 30% and 55% of Net pay is gross pay minus deductions. Required: 1. What is the record count for the table? 2. Identify a column from the table that has a hash total (only identify one column for each): 3. Identify a column from the table that has a financial total (only identify one column for each): 4. Identify seven specific cells (fields) in the table that are in error and the processing control would detect or pres the cell by coordinate - ie 1A -- and give the processing control (you can only use a processing control once): MacBook Air #WN Payroll Row Check Number Date Number 6/15/2020 91111 6/15/2020 91112 6/15/2020 91113 6/15/2020 91114 6/15/2020 91115 6/15/2020 91116 6/15/2020 91117 6/15/2020 91118 6/15/2020 91119 6/15/2020 91120 6/15/2020 91121 6/15/2020 91122 E F G H Gross Pay Deductions Approval Employee Hours Wage per Gross from Net Employee Initials Name Worked Hour Pay Pay Pay Number GWY S. Smith 40 35.48 1.419.20 681.22 737.98 200 APT E. Johnson 21.71 521.04 203.21 317.83 292 V. Williams 37.36 9,713.60 4,079.71 5,633.89 289 MJK W. Jones 19.09 572.70 251.99 320.71 160 MJK G. Brown 38.69 2,050.57 840.73 1.209.84 172 APT S. Davis 22.30 535.20 208.73 326.47 24 N. Miller 37.46 1,947.92 915.52 1,032.40 2 H. Wilson 22.50 472.50 151.20 321.30 GWY D. Moore 49 35.72 1,750.28 840.13 910.15 U. Taylor 43.85 1.140.10 776.23 363.87 MJK S. Schottsneider 40 26.28 1.051.20 578.16 473.04 - 42 MJK K. Thomas 23.16 972.72 418.27 554.4" MacBook Air GENERAL LEDGER 6/7 6/7 10100 - Cash Date Description 6/1 Beginning Balance Check #1140 Deposit Check #1141 6/8 Deposit 6/8 Check #1142 6/14 Check #1143 6/14 Check #1144 6/15 Check #1145 6/16 Check #1146 6/19 Deposit 6/21 Check #1147 6/22 Check #1148 6/22 Check #1149 Post Debit Credit Balance 51,179.71 2,575.00 48,604.71 4,090.52 52,695.23 7.367.00 45,328,23 2,806.00 48,134.23 34,390.50 13,743.73 1,360.25 12,383.48 778.75 11,604.73 3,523.23 8,081.50 14.82 8,066.68 45,000.00 53,066.68 45.75 53,020.93 2,790.54 50,230.39 160200 48.628.39 6/21 Check #1147 6/22 Check W1148 6/22 Check #1149 6/22 Check #1150 6/22 Check #1151 6/23 Deposit 6/25 Deposit 6/26 Check #1152 6/26 Deposit 6/30 Check #1153 Check #1154 6/30 Check #1156 6/30 Check #1157 6/30 Check #1159 6/30 Check #1160 6/30 Check #1161 6/30 Check #1162 6/30 Deposit 6/30 45,000.00 53.06668 45.75 53.020.93 2.790.54 50.230.39 1.602.00 48.628.39 1,324.35 47,304.04 1.350.00 5,954.04 6,122.88 52.076.92 7.880.25 59.957.17 615.05 59,342.12 1.920.80 61.262.92 1.322.98 59.939.94 4.762.52 55,177.42 519.50 54,657.92 3,620.83 51,037.09 6,220.20 44,816.89 50.19 44,766.70 198.75 44,567.95 2,120.63 42,447.32 19,190.36 61,637.68 No new data to save. Last checked a