Chapter 10 Example Problem: The first three columns of the following table is a listing of the sales of the product "Red Steer" by sales invoice number for the month of December 2018. The product sells for $20 a case. Because of shipping restrictions customers must order at least 50 cases and can not order more than 200 cases on any one invoice. Customer numbers are integers between 300 and 700. Sales invoice numbers started with 600. Price Total 10.00% Total Row Invoice Customer Cases per Amount Beverage Sales Relisting Relisting Relistin Number Number Number Custormer Name Ordered CaseSold 650 Blutz Brewery 75 410 306 Toad Milling 455 Express Deli1 150.00 1,650.00 1,650.00 1,650.001,650 Bubwhether 601 20 1,800.00 180.00 1,980.00 1,980.00 1,980 00 1,980 20 1,300.00 130.00 1,430.00 1,430.00 1,430.00 1,430. 119 20 2,380.00 238.00 261.80 261.80 2,618.00 261.8 554 Road Masters 175 20 3,500.00 350.003,830.00 3,8000 3,80.00 3,850 219 Red Line Inn 154 203,080.00 308.00 3,388.00 3,388.00 3,388.00 3,388 107 20 2,140.00 214.00 2,354.00 2.354.00 2,354.00 2,354 ABC New Ulm Pub 5620 1,120.00 11200 1,232.00 1,23200 1,232.00 3,630 00 3,360.00 3,630.00 1,672 Mankato Inn 423 England Pub 165 20 3,300.00 10 76 20 1,520.00 152.001,672.00 1.672.00 1,672.00 2,948 608 699 Bad Water Bar134 20 2,680.00 268.002.94800 2,948 00 2,948.00 308 08.00 308.00 308.00 3,96 20 3,600.00360.003,960.00 3,960.00 3,960.00 1,95 2 280 0028.003 611 612 376 489The Attic The Cellar 613 645 Wayside Stop 89 20 1,780.00 178.00 1.958.00 1958.00 1.958.00 8,80 614 698 Road Maters 400 20,000.00 800.00 8,800.00 8,80.00 8.800 Totals9,1057,837 2,025 282 37980.00 3,798.00 39,421.80 39,151 80 41,778.00 Required: a. Indicate the amount or calculate an example of these totals: only list one in each category A hash total A financial total The record count . b. Identify five (seven on test) specific fields in the table of an error or probable error that a processing contro would detect or prevent. Identify the field by coordinate-ie Al and name the control. Only list test once seven different tests c. The last three columns in the table lists the invoice amounts that have been summed to obtain a total. Assume the data in column H is correct. Columns I, J, and K are incorrect. One processing error occurre three cases. Specifically identify the o Chapter 10 Example Problem: The first three columns of the following table is a listing of the sales of the product "Red Steer" by sales invoice number for the month of December 2018. The product sells for $20 a case. Because of shipping restrictions customers must order at least 50 cases and can not order more than 200 cases on any one invoice. Customer numbers are integers between 300 and 700. Sales invoice numbers started with 600. Price Total 10.00% Total Row Invoice Customer Cases per Amount Beverage Sales Relisting Relisting Relistin Number Number Number Custormer Name Ordered CaseSold 650 Blutz Brewery 75 410 306 Toad Milling 455 Express Deli1 150.00 1,650.00 1,650.00 1,650.001,650 Bubwhether 601 20 1,800.00 180.00 1,980.00 1,980.00 1,980 00 1,980 20 1,300.00 130.00 1,430.00 1,430.00 1,430.00 1,430. 119 20 2,380.00 238.00 261.80 261.80 2,618.00 261.8 554 Road Masters 175 20 3,500.00 350.003,830.00 3,8000 3,80.00 3,850 219 Red Line Inn 154 203,080.00 308.00 3,388.00 3,388.00 3,388.00 3,388 107 20 2,140.00 214.00 2,354.00 2.354.00 2,354.00 2,354 ABC New Ulm Pub 5620 1,120.00 11200 1,232.00 1,23200 1,232.00 3,630 00 3,360.00 3,630.00 1,672 Mankato Inn 423 England Pub 165 20 3,300.00 10 76 20 1,520.00 152.001,672.00 1.672.00 1,672.00 2,948 608 699 Bad Water Bar134 20 2,680.00 268.002.94800 2,948 00 2,948.00 308 08.00 308.00 308.00 3,96 20 3,600.00360.003,960.00 3,960.00 3,960.00 1,95 2 280 0028.003 611 612 376 489The Attic The Cellar 613 645 Wayside Stop 89 20 1,780.00 178.00 1.958.00 1958.00 1.958.00 8,80 614 698 Road Maters 400 20,000.00 800.00 8,800.00 8,80.00 8.800 Totals9,1057,837 2,025 282 37980.00 3,798.00 39,421.80 39,151 80 41,778.00 Required: a. Indicate the amount or calculate an example of these totals: only list one in each category A hash total A financial total The record count . b. Identify five (seven on test) specific fields in the table of an error or probable error that a processing contro would detect or prevent. Identify the field by coordinate-ie Al and name the control. Only list test once seven different tests c. The last three columns in the table lists the invoice amounts that have been summed to obtain a total. Assume the data in column H is correct. Columns I, J, and K are incorrect. One processing error occurre three cases. Specifically identify the o