For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. B D Numeric Statistics GROSS AMT GST PST Net Value (Control Value) Absolute Value 435,864.35 29,511.00 33,408.34 36,412.04 509,929.85 32,163.32 # Records 300 300 300 # Zero Records 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 # 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 Sample Variance Pop Std Dev 2,996.06 193.09 218.64 8,976,402.64 37,282.40 47,801.50 2,981.07 192.76 218.27 A B C D E F H. 1 Accunts Receivable March 31, 2015 2 3 Int (Days) No. Records % Records Debits % Debits Credits % Credits Net Value % Net Value 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 31 162 64.03 $259,715.26 63.93 $31.940.83 86.40 $227,774.43 61.68 6 59 67 26.48 $91,318.66 22.48 5027.29 13.60 $86,291.37 23.37 7 91 21 8.30 $49,724.04 12.24 0.00 0.00 $49,724.04 13.47 8 121 0.79 $3,119.75 0.77 0.00 0.00 $3,119.75 0.84 9 121+ 1. 0.40 $2,345.54 0.58 0.00 0.00 2345.54 0.64 10 ERR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11 12 Totals 253.00 100.00 $406,223.25 100.00 $36,968.12 100.00 $369,255.13 100.00 13 14 Complete this question by entering your answers in the tabs below. Required A Regs 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 < RequiredA Reqs B and C > Complete this question by entering your answers in the tabs below. Required A Regs B and C Required 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 Regs 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. OAs a result of these findings, the risk of material misstatement should be assessed lower OAs a result of these findings, the risk of material misstatement should remain the same OAs a result of these findings, the risk of material misstatement should be assessed higher OAs a result of these findings, either the risk of misstatement should be assessed lower or the risk of misstatement should be assessed the same. < Reqs B and C Required D2 > 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. OThe risk of material misstatement related to the completeness of accounts receivable is likely to be higher OThe risk of material misstatement related to the valuation of accounts receivable is likely to be higher OThe 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 < Required D1 Required D2 > 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. B D Numeric Statistics GROSS AMT GST PST Net Value (Control Value) Absolute Value 435,864.35 29,511.00 33,408.34 36,412.04 509,929.85 32,163.32 # Records 300 300 300 # Zero Records 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 # 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 Sample Variance Pop Std Dev 2,996.06 193.09 218.64 8,976,402.64 37,282.40 47,801.50 2,981.07 192.76 218.27 A B C D E F H. 1 Accunts Receivable March 31, 2015 2 3 Int (Days) No. Records % Records Debits % Debits Credits % Credits Net Value % Net Value 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 31 162 64.03 $259,715.26 63.93 $31.940.83 86.40 $227,774.43 61.68 6 59 67 26.48 $91,318.66 22.48 5027.29 13.60 $86,291.37 23.37 7 91 21 8.30 $49,724.04 12.24 0.00 0.00 $49,724.04 13.47 8 121 0.79 $3,119.75 0.77 0.00 0.00 $3,119.75 0.84 9 121+ 1. 0.40 $2,345.54 0.58 0.00 0.00 2345.54 0.64 10 ERR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11 12 Totals 253.00 100.00 $406,223.25 100.00 $36,968.12 100.00 $369,255.13 100.00 13 14 Complete this question by entering your answers in the tabs below. Required A Regs 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 < RequiredA Reqs B and C > Complete this question by entering your answers in the tabs below. Required A Regs B and C Required 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 Regs 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. OAs a result of these findings, the risk of material misstatement should be assessed lower OAs a result of these findings, the risk of material misstatement should remain the same OAs a result of these findings, the risk of material misstatement should be assessed higher OAs a result of these findings, either the risk of misstatement should be assessed lower or the risk of misstatement should be assessed the same. < Reqs B and C Required D2 > 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. OThe risk of material misstatement related to the completeness of accounts receivable is likely to be higher OThe risk of material misstatement related to the valuation of accounts receivable is likely to be higher OThe 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 < Required D1 Required D2 > 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. B D Numeric Statistics GROSS AMT GST PST Net Value (Control Value) Absolute Value 435,864.35 29,511.00 33,408.34 36,412.04 509,929.85 32,163.32 # Records 300 300 300 # Zero Records 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 # 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 Sample Variance Pop Std Dev 2,996.06 193.09 218.64 8,976,402.64 37,282.40 47,801.50 2,981.07 192.76 218.27 A B C D E F H. 1 Accunts Receivable March 31, 2015 2 3 Int (Days) No. Records % Records Debits % Debits Credits % Credits Net Value % Net Value 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 31 162 64.03 $259,715.26 63.93 $31.940.83 86.40 $227,774.43 61.68 6 59 67 26.48 $91,318.66 22.48 5027.29 13.60 $86,291.37 23.37 7 91 21 8.30 $49,724.04 12.24 0.00 0.00 $49,724.04 13.47 8 121 0.79 $3,119.75 0.77 0.00 0.00 $3,119.75 0.84 9 121+ 1. 0.40 $2,345.54 0.58 0.00 0.00 2345.54 0.64 10 ERR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11 12 Totals 253.00 100.00 $406,223.25 100.00 $36,968.12 100.00 $369,255.13 100.00 13 14 Complete this question by entering your answers in the tabs below. Required A Regs 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 < RequiredA Reqs B and C > Complete this question by entering your answers in the tabs below. Required A Regs B and C Required 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 Regs 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. OAs a result of these findings, the risk of material misstatement should be assessed lower OAs a result of these findings, the risk of material misstatement should remain the same OAs a result of these findings, the risk of material misstatement should be assessed higher OAs a result of these findings, either the risk of misstatement should be assessed lower or the risk of misstatement should be assessed the same. < Reqs B and C Required D2 > 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. OThe risk of material misstatement related to the completeness of accounts receivable is likely to be higher OThe risk of material misstatement related to the valuation of accounts receivable is likely to be higher OThe 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 < Required D1 Required D2 > 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. B D Numeric Statistics GROSS AMT GST PST Net Value (Control Value) Absolute Value 435,864.35 29,511.00 33,408.34 36,412.04 509,929.85 32,163.32 # Records 300 300 300 # Zero Records 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 # 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 Sample Variance Pop Std Dev 2,996.06 193.09 218.64 8,976,402.64 37,282.40 47,801.50 2,981.07 192.76 218.27 A B C D E F H. 1 Accunts Receivable March 31, 2015 2 3 Int (Days) No. Records % Records Debits % Debits Credits % Credits Net Value % Net Value 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 31 162 64.03 $259,715.26 63.93 $31.940.83 86.40 $227,774.43 61.68 6 59 67 26.48 $91,318.66 22.48 5027.29 13.60 $86,291.37 23.37 7 91 21 8.30 $49,724.04 12.24 0.00 0.00 $49,724.04 13.47 8 121 0.79 $3,119.75 0.77 0.00 0.00 $3,119.75 0.84 9 121+ 1. 0.40 $2,345.54 0.58 0.00 0.00 2345.54 0.64 10 ERR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11 12 Totals 253.00 100.00 $406,223.25 100.00 $36,968.12 100.00 $369,255.13 100.00 13 14 Complete this question by entering your answers in the tabs below. Required A Regs 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 < RequiredA Reqs B and C > Complete this question by entering your answers in the tabs below. Required A Regs B and C Required 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 Regs 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. OAs a result of these findings, the risk of material misstatement should be assessed lower OAs a result of these findings, the risk of material misstatement should remain the same OAs a result of these findings, the risk of material misstatement should be assessed higher OAs a result of these findings, either the risk of misstatement should be assessed lower or the risk of misstatement should be assessed the same. < Reqs B and C Required D2 > 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. OThe risk of material misstatement related to the completeness of accounts receivable is likely to be higher OThe risk of material misstatement related to the valuation of accounts receivable is likely to be higher OThe 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 < Required D1 Required D2 >
Expert Answer:
Answer rating: 100% (QA)
Question Answer Explanation A Total Number of records shown by IDEA is 900 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
What is the total number of gates required to build a 4-bit adder? Assuming two transistors per NOT gate (as in Figure 16.8) and four transistors per AND and OR gate (as in Figures 16.9 and 16.10,...
-
What is the total number of lines a grating must have in order just to separate the sodium doublet ( 1 = 5895.9 , 2 = 5890.0 ) in the third order?
-
The following data represent x = the total number of businesses and y = the number of business failures in mountain states over a 1-year period. a. Draw a scatter diagram representing these data. b....
-
make a stored procedure called projects_at_this_location that receives a location and returns the projects (if any) at that location as shown in the following sample run: (2 points) exec...
-
According to Crown ATM Network, the mean ATM withdrawal is $67. Assume that the standard deviation for withdrawals is $35. (a) Do you think the variable ATM withdrawal is normally distributed? If...
-
When setting materiality levels it is crucial that the auditor considers the external environment. Discuss. The magnitude of an omission or misstatement that, individually or in the aggregate, could...
-
What are the depreciation journal entries on November 30, 2008, for each of the following accounts? Depr. Expense Vehicles Accum. Depr. Vehicles Depr. Expense Off. Eqpt. Accum. Depr. Office Eqpt....
-
Oceanview School, a private high school, is preparing a planned income statement for the coming academic year ending August 31, 2013. Tuition revenues for the past two years ending August 31 were as...
-
Assess the feasibility of a capital investment project using the net present value (NPV) method. Use the following data: Particulars Year 1 ($) Year 2 ($) Year 3 ($) Cash Inflows $50,000 $60,000...
-
Developed by Coca-Cola Asia Pacific, Coca-Cola Fiber+ (or just Coke Plus) is expanding through Hong Kong, Japan, Mainland China, Mongolia, and Taiwan. Coke Plus is a zero calorie soda (essentially...
-
You have received an offer of employment as the Sales Director from CC plc, an insurer. Before deciding whether to accept the offer, you review the recent financial performance of CC plc. From CC...
-
What are the ethical issues and concerns of each accountings (International accounting and managerial accounting)? Do you think they are both facing the same ethical issues and concerns or...
-
Find the magnitude (in km) of the sum of the following two vectors: R1 = TR R2 = (3.25 -6.50 ) km 6.00 km at 15.0 south of west Your Answer:
-
Your mother is fleeing from severe economic hardship and violence in their home country; granting her parole would be a humanitarian act. Knowing that a grant of parole is a discretionary...
-
The coupon rate on a bond is 3.14%. The par value of the bond is $1,000. The bond has a maturity of 21 years. If today's price of the bond is $737.27, what is the current yield?
-
Styles Brick by Brick (BBB) is a building business that provides a range of building services to the public. Recently it has been asked to quote for garage conversions (GC) and extensions to...
-
3.16. For a system with non-identical service rates (see Sect. 3.5) and a limit of N jobs in the system (Eq. 3.13), obtain an expression for the mean service time per job, E[Ts], as a function of the...
-
After experimenting with bin.html's binary search capabilities, answer the following questions: What is the minimum number of inspections required to find an item in an array using binary search?...
-
What task would the following machine-language program perform? 0: 1010001000000000 1: 1000001000000011 2: 1111111111111111
-
1. TRUE or FALSE? Nonmetals such as carbon and oxygen tend to be good conductors of electricity. 2. TRUE or FALSE? A semiconductor is a metal that can be manipulated to be either a good or a bad...
-
Polecat Corporation is considering beginning drilling operations in three separate fields. Polecat decides to analyze these fields using a 13% discount rate. The estimated cash flows for each field...
-
Define the following: asset retirement obligation retirement accretion promissory estoppel legally enforceable obligation obligating event
-
Define the following: impairment asset group traditional present value approach expected present value approach
Study smarter with the SolutionInn App