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 (pp. 28-45 of the IDEA Workbook). 2. Perform an aging analysis by following the instructions on pp. 52-56 of the IDEA Workbook. Required Data Files: IDEA Data Analysis Workbook ACC REC2015.ACCDB Required: Complete all of the related steps shown above using IDEA. After completing each step, answer the following questions. (Enter your answers exactly as they appear in 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? 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. 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 > 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 (pp. 28-45 of the IDEA Workbook). 2. Perform an aging analysis by following the instructions on pp. 52-56 of the IDEA Workbook. Required Data Files: IDEA Data Analysis Workbook ACC REC2015.ACCDB Required: Complete all of the related steps shown above using IDEA. After completing each step, answer the following questions. (Enter your answers exactly as they appear in 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? 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. 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 >
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
Accounting
ISBN: 978-1118608227
9th edition
Authors: Lew Edwards, John Medlin, Keryn Chalmers, Andreas Hellmann, Claire Beattie, Jodie Maxfield, John Hoggett
Posted Date:
Students also viewed these accounting questions
-
Kegler Bowling buys scorekeeping equipment with an invoice cost of $185,000. The electrical work required for the installation costs $19,425. Additional costs are $3,885 for delivery and $13,330 for...
-
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 electrons that can be held in all orbitals having the same principal quantum number n?
-
Suppose you have a consumer that calls the lion() method within a Lion service. You have four distinct modules: consumer, service locator, service provider, and service provider interface. If you add...
-
What steps would you take to prevent ADEA cases after a major restructuring or reduction in force?
-
Solve the given systems of equations by Gaussian elimination. Exercise 36 Data from Exercises 36 Solve the given systems of equations using the inverse of the coefficient matrix. 6x + 6y 3z = 24 x +...
-
3. During the course of 10 months, Joseph Melle sent more than 60 million unsolicited e-mail advertisements to AOL members. What charges could be brought against him?
-
Exhibit 3.36 presents a statement of cash flows for Starbucks for 2006, 2007, and 2008. This statement is an expanded version of the statement of cash flows for Starbucks shown in Exhibit 1.28....
-
Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link.This course requires the use of Strayer Writing...
-
Cary Company manufactures two models of industrial componentsa Standard model and an Advanced Model. It has provided the following information with respect to these two products: Standard Advanced...
-
For each of the following resident individual taxpayers, calculate the amount that they would be entitled to claim under either s.US-6Oor s.25-65 as a deduction for election expenses forthe2O2J/22...
-
can you help write a budgetery plan for a staffing agency along with ideas on budget planning and controls along with 2 sample budgets ( Cash and Selling and Administrative ) thank you
-
what ways does psychological contract theory impact employee engagement, motivation, and retention within modern workplaces ?
-
A basketball player shoots a successsful free throw standing a horizontal distance of 4.6 m away from the basket as shown. Ax = 4.6m- Ay=? If the initial velocity of the ball is 7.5 m/s at an angle...
-
Lowell Inc. gives 30 days credit to customers. On an average, how many extra days are customers taking to pay? Please use the Year 1 information in the sheet attached here. (Days Sales Outstanding'...
-
Calculations Marketing Inc. Issued 10.5% bonds with a par value of $410.000 and a five-year life on January 1, 2023, for $417,914. The bonds pay Interestion June 30 and December 31. The market...
-
A strong directional light source will help you observe the planes of your subject. Group of answer choices True False
-
From 1970 to 1990, Sri Lanka's population grew by approximately 2.2 million persons every five years. The population in 1970 was 12.2 million people.What is the best formula for P, Sri Lanka's...
-
Jaensch Ltd reported the following non-current assets at 30 June 2016: Land Buildings Less: Accumulated Depreciation Buildings $42000000 19 400000 $ 4 800000 22600000 Equipment Less: Accumulated...
-
It has been argued that many companies profits are overstated because they fail to take into account the full cost of their operating activities. This is particularly relevant when considering the...
-
ABC acquired a piece of open land for speculation purposes. It is expected that the value of the land will increase so that it can be sold in the future at a profit. Where should this land be...
-
How could auditors have stopped Parmalat's deceptions?
-
In order to determine how risky a particular company is that you are auditing, you prepare these five ratios along with the same ratios of this company's peers: What are your thoughts about the risk...
-
You are provided the following information about a company for two years (in millions): a. Days Sales in receivable index b. Gross margin index c. Sales growth index Any thoughts about this company?...
Study smarter with the SolutionInn App