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...
-
Suppose the Fed decides that it needs to pursue a contrac-tionary policy. It wants to decrease the money supply by $2 million. Assume people hold 20 percent of their money in the form of cash...
-
The angular velocity vector of a football which has just been kicked is horizontal, and its axis of symmetry OC is oriented as shown. Knowing that the magnitude of the angular velocity is 200 rpm and...
-
A person donates a bag of clothes to Goodwill completely unaware that there is valuable sterling silver in the bag. The clothing and silver are subsequently sold, for a very economical price, to...
-
Record the following transactions of the State of Delaware general government activities for the year ended June 30, 20X6. (Amounts are stated in thousands of dollars.) Make all required entries. 1....
-
Thunderduck Shoes provides shoe shining and repair services to customers. For the year which ended Dec 31, the company reports the following amounts: Account Amount Account Amount Rent Expense 22,400...
-
Find the simple interest for each of the following. Round to the nearest cent. 1. $27,850 at 7.75% for 100 days 2. $7800 at 9.25% for 4 months 3. A loan of $5800 at 9% made on May 22 and due July 5...
-
b) What do you see as the main Health and Safety training needs in your workplace during induction and when a new employee starts working there?
-
Evaluate the following expression. 13! 4!(13-4)!
-
4. For each of the following, answer briefly (no formal math needed explain intuitively). (30 points) (a) Given a training dataset with N features, is the number of nodes in any decision tree learned...
-
The Trespasser physics engine simulated rigid body box-shaped colliders and allowed the game player to easily build complicated structures such as a staircase made of crates.
-
W What was the average speed maintained by Dick Rutan and Jenna Yeager on their non-stop flight around the world?
-
Which noun corresponds with Concrete the type of noun. noodles? mars? Speed? weasels? Fear?
-
Indices of occupational segregation by gender understate the true extent of segregation because A) Occupational taxonomies often combine dissimilar jobs, for example cashier and seller of stocks and...
-
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...
-
Kids Sports Consulting Pty Ltd is a company set up by sports and recreation management students to gain experience in running their own business. It had the following contribution margin income...
-
V. Zarb, the marketing manager for Maltese Treasures Ltd, is preparing a sales budget for the year ended 30 June 2020. In reviewing the actual sales data for the previous year, the sales and...
-
The following expenses budget has been prepared for Abacus Services for the year ending 30 June 2020. Professional salaries, secretarial wages and training are paid in the quarter in which they are...
Study smarter with the SolutionInn App