The necessary data needed to solve: Please help and show all the work please this is 1 question. please answer all parts

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: 1. Import the client's database of sales invoices (Excel File - ACC 546 Wk. 2 Practice Case Assignment Values Tab A). 2. Perform an aging analysis (Excel File - ACC 546 Wk. 2 Practice Case Assignment Values Tab B Required Data Files: In the Resources section of this question, you will see e-book, hints, and files. Select Files to download the Excel template to answer the questions below Required: Use the Excel File Template to answer the following questions. a. Upon downloading the Wk. 2 Practice Case Assignment Data File Template Worksheet, what is the total Number of Records? What is the Control Total for the GROSS_AMT Field? b. What percentage of customers have accounts that are aged greater than 90 days? c. What percentage of customer balances (net value) are aged greater than 90 days? d-1. Determine the effect that your findings in parts (b) and (c) would have on the auditor's assessment of the risk of material misstatement d-2. Determine which of the given accounts and assertions are most likely influenced by your findings. For each of the descriptions in Column A, match the correct word or words from Column B. Column A Column B 1. Sets forth a contractual understanding with the client. Auditors' record of compliance with the planning and supervision provisions of GAAS. 3. The written basis for the auditor's conclusions. 4. A file that contains information of continuing audit significance. 5. Chain of evidence found at an audit client. Complete this question by entering your answers in the tabs below. Required A Reqs B and C Required D1 Required D2 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 Required A Reqs B and C > Complete this question by entering your answers in the tabs below. Required A Reqs B and cRequired D1 Required D2 b. What percentage of customers have accounts that are aged greater than 90 days? c. What percentage of customer balances (net value) are aged greater than 90 days? (Enter both answers as whole percentages rounded to 2 decimal places.) b. Percentage of customers have accounts that are aged greater than 90 days c. Percentage of customer balances (net value) are aged greater than 90 days Required A Reqs B and C Required D1 Required D2 d-1. Determine the effect that your findings in parts (b) and (c) would have on the auditor's assessment of the risk of material misstatement. As a result of these findings, the risk of material misstatement should be assessed lower As a result of these findings, the risk of material misstatement should remain the same As a result of these findings, the risk of material misstatement should be assessed higher As a result of these findings, either the risk of misstatement should be assessed lower or the risk of misstatement should be assessed the same. Complete this question by entering your answers in the tabs below. Required A Regs B and C Required D1 Required D2 d-2. Determine which of the given accounts and assertions are most likely influenced by your findings. JO The risk of material misstatement related to the completeness of accounts receivable is likely to be higher The risk of material misstatement related to the valuation of accounts receivable is likely to be higher The risk of material misstatement related to the completeness of accounts receivable is likely to be lower The risk of material misstatement related to the valuation of accounts receivable is likely to be lower GROSS_AMT_ 435.864.35 509,929.85 300 PST 33,408.34 36,412.04 300 GST 29,511.00 32,163.32 300 12 30,817.16 -1,326.16 254 34 12 34,910.49 -1,501.55 254 34 Numeric Statistics Net Value (Control Value) Absolute Value # Records # Zero Records Positive Value Negative Value # Positive Records # Negative Records # Data Errors # Valid Values Arranged Value Minimum Value Maximum Value Record # of Min Record # of Max Sample Std Dev Sample Variance Pop Std Dev O 472,897.35 -37,032.50 255 45 0 300 1,452.99 -3,145.73 18,349.53 236 262 2,996.06 8,976,402.64 2,981.07 300 98.37 -205.80 1200.44 236 262 193.09 37,282.40 192.76 0 300 111 -233.02 1,359.22 236 262 218.64 47,801.50 218.27 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: 1. Import the client's database of sales invoices (Excel File - ACC 546 Wk. 2 Practice Case Assignment Values Tab A). 2. Perform an aging analysis (Excel File - ACC 546 Wk. 2 Practice Case Assignment Values Tab B Required Data Files: In the Resources section of this question, you will see e-book, hints, and files. Select Files to download the Excel template to answer the questions below Required: Use the Excel File Template to answer the following questions. a. Upon downloading the Wk. 2 Practice Case Assignment Data File Template Worksheet, what is the total Number of Records? What is the Control Total for the GROSS_AMT Field? b. What percentage of customers have accounts that are aged greater than 90 days? c. What percentage of customer balances (net value) are aged greater than 90 days? d-1. Determine the effect that your findings in parts (b) and (c) would have on the auditor's assessment of the risk of material misstatement d-2. Determine which of the given accounts and assertions are most likely influenced by your findings. For each of the descriptions in Column A, match the correct word or words from Column B. Column A Column B 1. Sets forth a contractual understanding with the client. Auditors' record of compliance with the planning and supervision provisions of GAAS. 3. The written basis for the auditor's conclusions. 4. A file that contains information of continuing audit significance. 5. Chain of evidence found at an audit client. Complete this question by entering your answers in the tabs below. Required A Reqs B and C Required D1 Required D2 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 Required A Reqs B and C > Complete this question by entering your answers in the tabs below. Required A Reqs B and cRequired D1 Required D2 b. What percentage of customers have accounts that are aged greater than 90 days? c. What percentage of customer balances (net value) are aged greater than 90 days? (Enter both answers as whole percentages rounded to 2 decimal places.) b. Percentage of customers have accounts that are aged greater than 90 days c. Percentage of customer balances (net value) are aged greater than 90 days Required A Reqs B and C Required D1 Required D2 d-1. Determine the effect that your findings in parts (b) and (c) would have on the auditor's assessment of the risk of material misstatement. As a result of these findings, the risk of material misstatement should be assessed lower As a result of these findings, the risk of material misstatement should remain the same As a result of these findings, the risk of material misstatement should be assessed higher As a result of these findings, either the risk of misstatement should be assessed lower or the risk of misstatement should be assessed the same. Complete this question by entering your answers in the tabs below. Required A Regs B and C Required D1 Required D2 d-2. Determine which of the given accounts and assertions are most likely influenced by your findings. JO The risk of material misstatement related to the completeness of accounts receivable is likely to be higher The risk of material misstatement related to the valuation of accounts receivable is likely to be higher The risk of material misstatement related to the completeness of accounts receivable is likely to be lower The risk of material misstatement related to the valuation of accounts receivable is likely to be lower GROSS_AMT_ 435.864.35 509,929.85 300 PST 33,408.34 36,412.04 300 GST 29,511.00 32,163.32 300 12 30,817.16 -1,326.16 254 34 12 34,910.49 -1,501.55 254 34 Numeric Statistics Net Value (Control Value) Absolute Value # Records # Zero Records Positive Value Negative Value # Positive Records # Negative Records # Data Errors # Valid Values Arranged Value Minimum Value Maximum Value Record # of Min Record # of Max Sample Std Dev Sample Variance Pop Std Dev O 472,897.35 -37,032.50 255 45 0 300 1,452.99 -3,145.73 18,349.53 236 262 2,996.06 8,976,402.64 2,981.07 300 98.37 -205.80 1200.44 236 262 193.09 37,282.40 192.76 0 300 111 -233.02 1,359.22 236 262 218.64 47,801.50 218.27