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...
-
Write the complete ionic equation for CaCl2(aq) + Pb(NO3)2(aq) ( Ca(NO3)2(aq) + PbCl2(s)
-
Find the lift and the moment coefficient at the midchord of an airfoil undergoing sudden velocity change. Use the Wagner function.
-
Which one of the following does not relate to diesel engines ? (a) fuel pump (b) fuel injector (c) governor (d) carburettor
-
Barbara Fox was the agent of Burt Hollander, a well-known athlete. She discovered that Tom Lanceford owned a 1957 Chevrolet convertible, which had been stored in a garage for the past 15 years. After...
-
A corporation buys $2.5 million (face value) of a 20-year bond with a 5% semi-annual coupon priced at 102.25 with a duration of 16.36. What position should the corporation take in a 10-year zero...
-
ABC Framing has been hired to frame a light commercial building. The project began on July 2 and was completed on August 9. The following is a list of accounting transactions associated with the...
-
Identify the project of your choice and you are required to do the following i . Develop full cost estimates supported with an introduction of the project rationale the project, objectives of the...
-
Rocco Valentino shops only at Walmart because Rocco believes he will receive the lowest price without further hassles. This type of pricing strategy is known as __________ pricing. a. dynamic b....
-
What results when there is an increase in overall prices? a. Inflation b. Deflation c. Expansion d. Recession
-
A social environment is an interconnected system of different demographic factors such as a. climate conditions. b. globalization and political conditions. c. gender, age, and income. d. tax policy...
-
The U.S. Postal Service and Amtrak are examples of large organizations operated by the federal government. Discuss the pros and cons of privatizing these businesses.
-
a. Draw the load line for the network of Fig. 4.122 on the characteristics of Fig. 4.121 using b from problem 8 to find IBQ. Fig. 4.122 Fig. 4.121 b. Find the Q -point and resulting values ICQ and...
-
Fill in the Balance Sheet. ( Do not round intermediate calculations. Round your answers to 2 decimal places. ) Sales $ 6 2 9 6 Total Assets Turnover 4 . 1 Current Ratio 4 . 4 Quick Ratio 3 Current...
-
With your classmates, form small teams of skunkworks. Your task is to identify an innovation that you think would benefit your school, college, or university, and to outline an action plan for...
-
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...
-
Let \[f(x, y)=\frac{1}{2} \sin (x+y), 0 \leq x, y \leq \frac{\pi}{2}\] be the joint probability density of the random vector \((X, Y)\). (1) Determine the marginal densities. (2) Are \(X\) and \(Y\)...
-
A large population of rats had been fed with individually varying mixtures of wholegrain wheat and puffed wheat to see whether the composition of the food has any influence on the lifetimes of the...
-
The random vector \((X, Y)\) is defined as follows: \(X\) is uniformly distributed in the interval \([0,10]\). On condition \(X=x\), the random variable \(Y\) is uniformly distributed in the interval...
Creative Destruction How To Start An Economic Renaissance 1st Edition - ISBN: 1447336119 - Free Book
Study smarter with the SolutionInn App