For this exercise, your client, Bright IDEAs Inc., has provided you with a listing of sales invoices. To test whether the client appears to have a receivables collectability problem, the auditor must complete a series of related steps:

Required Data Files:

Data Section A

Numeric Statistics	GROSS_AMT_	GST	PST
Net Value (Control Value)	435,864.35	29,511.00	33,408.34
Absolute Value	509,929.85	32,163.32	36,412.04
# Records	300	300	300
# Zero Records	0	12	12
Positive Value	472,897.35	30,817.16	34,910.49
Negative Value	-37,032.50	-1,326.16	-1,501.55
# Positive Records	255	254	254
# Negative Records	45	34	34
# Data Errors	0	0	0
# Valid Values	300	300	300
Arranged Value	1,452.99	98.37	111
Minimum Value	-3,145.73	-205.80	-233.02
Maximum Value	18,349.53	1200.44	1,359.22
Record # of Min	236	236	236
Record # of Max	262	262	262
Sample Std Dev	2,996.06	193.09	218.64
Sample Variance	8,976,402.64	37,282.40	47,801.50
Pop Std Dev	2,981.07	192.76	218.27

Required:

Use the Excel File Template to answer the following questions.

a. Upon importing the ACC_REC2015.ACCDB data file, what is the total Number of Records shown by IDEA? what is the Control Total for the GROSS_AMT Field shown by IDEA? (Enter your answer for "GROSS_AMT" to 2 decimal places.) Total Number of Records shown by IDEA Control Total for the GROSS_AMT Field shown by IDEA a. Upon importing the ACC_REC2015.ACCDB data file, what is the total Number of Records shown by IDEA? what is the Control Total for the GROSS_AMT Field shown by IDEA? (Enter your answer for "GROSS_AMT" to 2 decimal places.) Total Number of Records shown by IDEA Control Total for the GROSS_AMT Field shown by IDEA