Corporate Auditing: Audit Data Analysis of US Superstore Case Report

This report presents an analysis of the US Superstore case within a corporate auditing context, focusing on audit planning and substantive testing phases. The report utilizes data visualization techniques with Tableau to examine various aspects of the audit, including trend lines of monthly sales, bar diagrams on discounts, returns by customer, sales issues, cut off issues, related party transactions, customer confirmation, discounts, A/R balances, inventory valuation, and shipping costs. The analysis provides insights into potential risks and areas of concern within the revenue cycle, offering a comprehensive overview of the audit process and the application of data analytics in auditing. The report includes visual representations and detailed explanations of the findings, supported by relevant references.

Running head: CORPORATE AUDITING
Corporate Auditing
Name of the Student
Name of the University
Author Note:

1CORPORATE AUDITING
Table of Contents
PART 1 Audit Planning...................................................................................................................2
Trend line of monthly Sales.........................................................................................................2
Bar diagram on Discounts...........................................................................................................3
Bar diagram on returns by customer............................................................................................4
PART 2 Substantive Testing...........................................................................................................5
Substantive test on Sales issues...................................................................................................5
Substantive test on cut off issue...................................................................................................6
Substantive test on related party transactions..............................................................................7
Substantive test on customer confirmation..................................................................................8
Substantive test on Discounts and cash receipts..........................................................................9
Substantive test on A\R balances...............................................................................................10
Substantive test on inventory valuation.....................................................................................10
Substantive test on shipping cost...............................................................................................11
References......................................................................................................................................12

2CORPORATE AUDITING
PART 1 Audit Planning
Trend line of monthly Sales
Figure 1 Trend line of monthly sales
The figure 1 has been provided the relationship between two variables. In the X- axis
shows the month of order date and Y- axis shows the sales. It has been seen that the monthly
sales are fluctuated among the years. In the month of May 2011 the sales is low that means it has
been in the lower part of the trend line and finally in the month of November 2014 it is gradually
increases. The sales are the indicator which defines the slow moving product.

3CORPORATE AUDITING
Bar diagram on Discounts
Figure 2 bar diagram on Discounts
The figure 2 has been provided the relationship between two variables. In the x- axis
shows the name of the products and in the Y-axis shows average discounts. It has been seen that
the maximum discounts getting in the appliances in the office suppliers and minimum discount
getting in chairs in furniture section.

4CORPORATE AUDITING
Bar diagram on returns by customer
Figure 3 bar diagram on returns by customer
The figure 3 has been showed the relationship between two variables in the X-axis
provided the years and in the Y-axis provided the count of returned. The maximum count of
return has been seen in the year 2014 on Binders and minimum count of return has been fall in
2013 on Envelo.

5CORPORATE AUDITING
PART 2 Substantive Testing
Substantive test on Sales issues
Figure 4 bar diagram on sales issues
In the figure 4 shows the relationship between two variables. In the X- axis provide the
sales item like furniture, office supplies and technology. In the Y-axis provide the different
region and average sales. It is clear that the office supplier in the west region has the lowest
average sales. The technology in the west region has the maximum average sales. The
technology in all the region has been shown a good result. In the technology part central region
has the minimum average sales. In the office suppliers the entire four regions has not been shown
a good result.

6CORPORATE AUDITING
Substantive test on cut off issue
Figure 5 bar diagram on cut off issue
The figure 5 has been provided the bar diagram on cut off issue. In the X-axis has been
provided the year of order date and shipping date during 2011-2015. In the Y-axis shows the
regions. In 2011 issues in all four region is good. That means order has to get the customer in
their appropriate shipping time. It is clear from the figure that the some items has to get delay
their service. In this study the central and west region during time 2014-15 has been got delay
service. Ship date and order date is the factor of cut-off issue.

7CORPORATE AUDITING
Substantive test on related party transactions
Figure 6 bar diagram on related party transactions
In the figure 6 has been provided the bar diagram on related party transactions. In the X-
axis shows the name of the customer and in the Y-axis shows the different category and average
paid. It has been seen that in the technology section has the maximum payment holder. It is clear
from the figure that in the office suppliers has been provided a very low average paid. In the
furniture section the average paid is gradually better than the office suppliers.

8CORPORATE AUDITING
Substantive test on customer confirmation
Figure 7 bar diagram on customer confirmation
The figure 7 has been provided the relationship between two variables. In the X- axis
provided the order id and in the Y- axis provide the quarter ship date quarter date paid during
2012-2014. The figure has been provided a good customer confirmation in among the Id code
but in the middle part shows some deflection about their relation. The customer which is ship
date and paid date is same has to be get the confirmation.

9CORPORATE AUDITING
Substantive test on Discounts and cash receipts
Figure 8 bar diagram on Discounts and Paid
In the figure 8 has been showed a bar diagram on paid and discount. In the X-axis
provide the name of the customer and in the Y- axis provide the paid and discount. It is clear
from the figure that the name Freed Momath has been got the maximum discount. The name
Raymond has been payed the maximum amount. Sales are the issue for discount.

10CORPORATE AUDITING
Substantive test on A\R balances
Figure 9 bar diagram on A\R balances
The figure 9 has been provided the bar diagram on A\R balances. In x- axis provided the
average paid and discount. In the Y- axis provide the different category and time in month. It
has been seen that technology does not get any discount. The furniture has been got the
maximum discount and technology has paid the maximum average amount. For technology
accounts receivable is zero. In the office suppliers and furniture on December the accounts
receivable is almost good. The time and category is the US superstores’ AR.
Substantive test on inventory valuation
Figure 10 bar diagram on inventory valuation
The Technology has been got the maximum inventory valuation.

11CORPORATE AUDITING
Substantive test on shipping cost
Figure 11 bar diagram on shipping cost in different region
The shipping cost in the East region has the maximum and in the central region has the
minimum.

12CORPORATE AUDITING
References
Chiu, Y. C., Chien, Y. L., & Wu, Z. L. (2013). U.S. Patent No. 8,378,973. Washington, DC: U.S.
Patent and Trademark Office.
Chiu, Y. C., Chien, Y. L., & Wu, Z. L. (2013). U.S. Patent No. 8,378,973. Washington, DC: U.S.
Patent and Trademark Office.
Hoelscher, J., & Mortimer, A. (2018). Using Tableau to visualize data and drive decision-
making. Journal of Accounting Education, 44, 49-59.
Hudecek, M., Lupo-Stanghellini, M. T., Kosasih, P. L., Sommermeyer, D., Jensen, M. C., Rader,
C., & Riddell, S. R. (2013). Receptor affinity and extracellular domain modifications
affect tumor recognition by ROR1-specific chimeric antigen receptor T cells. Clinical
cancer research, 19(12), 3153-3164.
Monsen, K. A., Peterson, J. J., Mathiason, M. A., Kim, E., Lee, S., Chi, C. L., & Pieczkiewicz,
D. S. (2015). Data visualization techniques to showcase nursing care quality. CIN:
Computers, Informatics, Nursing, 33(10), 417-426.
Nadeem, M. F., Zafar, S., & Zahid, Z. (2015). On certain topological indices of the line graph of
subdivision graphs. Applied Mathematics and Computation, 271, 790-794.
Nandeshwar, A. (2013). Tableau data visualization cookbook. Packt Publishing Ltd.
Rehman, H. M., Sardar, R., & Raza, A. (2017). Computing topological indices of hex board and
its line graph. Open J. Math. Sci, 1(1), 62-71.
Schäfer, G. (2014). Categorified Uq (sl2)-theory using Bar-Natan's approach (Doctoral
dissertation, Universitäts-und Landesbibliothek Bonn).
Simunovic, M., Voth, G. A., Callan-Jones, A., & Bassereau, P. (2015). When physics takes over:
BAR proteins and membrane curvature. Trends in cell biology, 25(12), 780-792.
Weissgerber, T. L., Milic, N. M., Winham, S. J., & Garovic, V. D. (2015). Beyond bar and line
graphs: time for a new data presentation paradigm. PLoS biology, 13(4), e1002128.