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 onder at least 50 cases and can not onder more than 200 cases on any one invoice. Customer numbers are integer between 300 and 700 Sales invoice numbers started with 600 () (C) E ( 0) CA) Sales Invoice Number D ( - Cases Ordered 75 ) Price per Case Customer Number 650 (G) 10.000 Beverage Tax 50.00 Total Amount Sold 1,500.00 Number 0 Total Sales Invoice 1,650.00 Relisting One 1,650.00 Relisting Three 1.650.00 90 Customer Name Blutz Brewery whether Boer Toad Milling Express Deli Road Masters Red Line Inn Mankato Inn New Ulm Pub England 554 175 20 107 ABC 093 Relisting Two 1.650,00 1,000.00 10000 2.618.00 50.00 00 2354,00 1,21200 1610.00 1,672.00 2.948.00 308.00 3.960.00 1.958.00 8.800.00 1.800.00 1.300.00 2.380.00 3,500.00 3,080 00 2.140.00 1,120.00 3,300.00 1.520.00 2.680.00 280.00 3.600.00 1.780.00 H 8,000.00 180.00 - 13000 2800 350.00 08 00 214.00 112.00 30.00 152.00 268.00 28.00 36000 178.00 800.00 1,000.00 1,000.00 10000 1000 251.50 251.50 3,850.00 50.00 00 00 2,354.00 2,354.00 1,232.00 1.232.00 361000 1100 1.672.00 1672.00 2.948.00 2.948.00 308.00 30000 3,960.00 3.960.00 1.958.00 1,958.00 8,800.00 8.800.00 1.000.00 1.430.00 251.80 3.850.00 33 CO 2,354.00 3,630.00 1.672.00 290 00 308.00 3.950.00 1,958.00 8.800.00 0.00 20 610 176 114 140 180 612 Rad Water Bar The Cellar The Attic Wayside Stop Road Matters 489 20 2 20 20 20 400 Column Tetails 41,778.00 38,189.80 9,105 7,837 2,095 280 37.980.00 3,798.00 39,421.30 39,151.80 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 control would detect or prevent. Identify the field by coordinate-ie Al and name the control. Only list test once -seven different tests e. 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 occurred during each of the three cases. Specifically identify the processing error in columns I, J, and K. 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 onder at least 50 cases and can not onder more than 200 cases on any one invoice. Customer numbers are integer between 300 and 700 Sales invoice numbers started with 600 () (C) E ( 0) CA) Sales Invoice Number D ( - Cases Ordered 75 ) Price per Case Customer Number 650 (G) 10.000 Beverage Tax 50.00 Total Amount Sold 1,500.00 Number 0 Total Sales Invoice 1,650.00 Relisting One 1,650.00 Relisting Three 1.650.00 90 Customer Name Blutz Brewery whether Boer Toad Milling Express Deli Road Masters Red Line Inn Mankato Inn New Ulm Pub England 554 175 20 107 ABC 093 Relisting Two 1.650,00 1,000.00 10000 2.618.00 50.00 00 2354,00 1,21200 1610.00 1,672.00 2.948.00 308.00 3.960.00 1.958.00 8.800.00 1.800.00 1.300.00 2.380.00 3,500.00 3,080 00 2.140.00 1,120.00 3,300.00 1.520.00 2.680.00 280.00 3.600.00 1.780.00 H 8,000.00 180.00 - 13000 2800 350.00 08 00 214.00 112.00 30.00 152.00 268.00 28.00 36000 178.00 800.00 1,000.00 1,000.00 10000 1000 251.50 251.50 3,850.00 50.00 00 00 2,354.00 2,354.00 1,232.00 1.232.00 361000 1100 1.672.00 1672.00 2.948.00 2.948.00 308.00 30000 3,960.00 3.960.00 1.958.00 1,958.00 8,800.00 8.800.00 1.000.00 1.430.00 251.80 3.850.00 33 CO 2,354.00 3,630.00 1.672.00 290 00 308.00 3.950.00 1,958.00 8.800.00 0.00 20 610 176 114 140 180 612 Rad Water Bar The Cellar The Attic Wayside Stop Road Matters 489 20 2 20 20 20 400 Column Tetails 41,778.00 38,189.80 9,105 7,837 2,095 280 37.980.00 3,798.00 39,421.30 39,151.80 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 control would detect or prevent. Identify the field by coordinate-ie Al and name the control. Only list test once -seven different tests e. 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 occurred during each of the three cases. Specifically identify the processing error in columns I, J, and K
