Part 3-Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-risk...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 3-Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-risk area for most audit engagements (PCAOB 2014), you will utilize Tableau to create data visualizations and dashboards for various aspects of the audit of US Superstore's revenue (order to cash) cycle and related accounts. For the following issues, first, brainstorm in your group to develop questions that you need to evaluate with Tableau, and second, prepare the necessary data visualizations related to the following issues and questions you developed. (Refer to Chapter 7, Revenue and Collection Cycle). Your engagement partner provided the following initial substantive testing issues to your team that need to be evaluated: (1) Are there any indicators of slow-moving product? (2) Are there any indications of cut-off issues? (3) Are there any indicators of related-party transactions? (4) Which customers should receive confirmations? (5) Are there any issues or concerns with discounts and cash receipts? (6) What is the Accounts Receivable 12/31 balance for each year? Are there concerns as to the quality of US Superstore's accounts receivable? For 12/31/14, what is the total amount of accounts receivable that are more than 30, 60, and 90 days past due? Based on this analysis, identify risky items. Explain why you consider these items risky. (8) Are there any indicators that inventory might be overvalued? (9) What are shipping costs per region or product? (10) Are there any other issues you think are important? Part 3-Substantive Testing of the Revenue (Order to Cash) Cycle. As revenue is considered a high-risk area for most audit engagements (PCAOB 2014), you will utilize Tableau to create data visualizations and dashboards for various aspects of the audit of US Superstore's revenue (order to cash) cycle and related accounts. For the following issues, first, brainstorm in your group to develop questions that you need to evaluate with Tableau, and second, prepare the necessary data visualizations related to the following issues and questions you developed. (Refer to Chapter 7, Revenue and Collection Cycle). Your engagement partner provided the following initial substantive testing issues to your team that need to be evaluated: (1) Are there any indicators of slow-moving product? (2) Are there any indications of cut-off issues? (3) Are there any indicators of related-party transactions? (4) Which customers should receive confirmations? (5) Are there any issues or concerns with discounts and cash receipts? (6) What is the Accounts Receivable 12/31 balance for each year? Are there concerns as to the quality of US Superstore's accounts receivable? For 12/31/14, what is the total amount of accounts receivable that are more than 30, 60, and 90 days past due? Based on this analysis, identify risky items. Explain why you consider these items risky. (8) Are there any indicators that inventory might be overvalued? (9) What are shipping costs per region or product? (10) Are there any other issues you think are important?
Expert Answer:
Answer rating: 100% (QA)
Here are the questions I would evaluate with Tableau for the given issues along with sample data visualizations 1 Are there any indicators of slowmovi... View the full answer
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date:
Students also viewed these accounting questions
-
You have been asked to perform substantive testing of the receivables account for Ocie's Manufacturing. You have been instructed to utilize sampling techniques. There are 3,000 customer accounts...
-
Transactions related to revenue and cash receipts completed by Tex Max Inc. during the month of March 2010 are as follows: Mar. 2. Issued Invoice No. 512 to Browne Co., $820. 4. Received cash from...
-
Transactions related to revenue and cash receipts completed by Starcom Inc. during the month of March 2006 are as follows: Mar. 2. Issued Invoice No. 512 to Conrad Co., $790. 4. Received cash from...
-
East Corp is a mature company and expects its sales and operating costs to be fixed (or unchanged) in perpetuity. It has sales of $524,000 and operating costs of $272,480. The firm has a tax rate of...
-
Draw a distinction between a project and a program. Why is the distinction important?
-
A 3.2 meter long plank of negligible mass has a 33 kg mass at one end of the plank and a 39 kg mass at the other end. How far from the 33 mass should a fulcrum be placed so the plank is balanced?
-
For a certain fluid flow problem it is known that both the Froude number and the Weber number are important dimensionless parameters. If the problem is to be studied by using a 1:15 scale model,...
-
Replacement of a machine, income taxes, sensitivity. (CMA, adapted) The Smacker Company is a family-owned business that produces fruit jam. The company has a grinding machine that has been in use for...
-
Some commonly occurring quantities. All of the quantities that follow will occur frequently in your study of physics. (a) Expressthe speed of light (3.00 108 m/s) in mi/s and mi/h. (b) Find the speed...
-
Using the alternative-parameter method, determine the parameters of the following distributions based on the given assessments. Refer to Step 5.5 if necessary. a. Find the parameter value for the...
-
Consider the information given below. Output Inputs 310,000 units 6,100 labor hours @ $17.00 per hour Sales price = $1,306.00/unit Material cost = $42,250,000 Utilities cost = $4,200 Calculate the...
-
potato slices have been dehydrated from an initial solid content of 1 2 % to a final solid content of 9 4 % . if peeling and other losses are to the tune of 1 0 % , final yield of the dried chips per...
-
For the function f(x)= (7x-6)/((-6x-7)(9x-6)), what are the verticle asymptotes? a) give a list of the x-values of the asymptotes separated by commas. x=__________ b) what is the horizontal...
-
Consider a non-dividend-paying stock with the current stock price of $32. Calculate the intrinsic value of the following options on the stock where time to maturity is six months: a) An American call...
-
Through its retail stores, Apple seeks to offer both products and services solutions to its customers. That is, when a person looks to buy an Apple product, both the product and service are offered...
-
What role do centromeres play in ensuring accurate chromosome segregation during cell division, and how do centromere abnormalities contribute to chromosomal instability and disease ?
-
Suppose that for the year 2015, Speedy Chef, a fast food restaurant, had a gross profit of $1,281,648. Speedy Chef had the following expenses: Cost of Goods Sold 1,251,167 Selling Expenses 70,578...
-
Maria Castigliani is head of the purchasing department of Ambrosiana Merceti, a medium-sized construction company. One morning she walked into the office and said, The main problem in this office is...
-
Following are several decisions that the auditor must make in an audit of a nonpublic company. Letters indicate alternative conclusions that could be made. Required a. Identify the sequence in which...
-
Explain why most auditors consider the receipt of goods and services the most important point in the acquisition and payment cycle.
-
Explain why many people think of internal auditors as the primary group responsible for conducting operational audits.
-
Define internal combustion engine and explain how it is different from external combustion engines?
-
In an air standard Otto cycle, the pressure and temperature at the start of compression stroke are 1 bar and \(30^{\circ} \mathrm{C}\), respectively. The temperature at the end of compression is...
-
In I.C. engines, power developed inside the cylinder is known as: (a) Brake horse power (b) Indicated horse power (c) Pumping power (d) None of the above
Study smarter with the SolutionInn App