Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Directions: Complete this template by replacing the bracketed text with the relevant information. Using the provided Data Visualization Screenshot and Data Analytics Cash Data Set,

Directions: Complete this template by replacing the bracketed text with the relevant information. Using the provided Data Visualization Screenshot and Data Analytics Cash Data Set, answer the following questions for each criterion: 1. Examine expenditures to look for anomalies. A. Which day in March shows the largest amount of expenditure for the bank account ending in 4190? [Add content here.] 2. Examine transactions to identify transaction types. A. What type of transactions are paid through the bank account ending in 3176? [Add content here.] 3. Examine the interactive capability to analyze transaction amounts. A. What is the transaction amount for the commission occurred on March 4? [Add content here] 4. Examine cash internal control to analyze internal controls for cash expenditures. A. When looking at the bank account ending in 3176, what is the largest daily expenditure in March 2019? [Add content here.] B. Why do you think the expenditure is significantly larger compared to those on other days in March? [Add content here] 5. Review auditing procedures to analyze weekend transactions. A. What transactions do you observe over the weekends based on the total amount shown in the visualization or bank accounts ending in 4190? [Add content here] B. What might larger or smaller total amounts for the weekends indicate? [Add content here] Question Five Hint: 3/2, 3/3, 3/9, 3/10, 3/16, 3/17, 3/23, 3/24 and 3/30, 3/31 are all Long description: Two graphs in a tableau window positioned one over the other depicting the transaction date, amount, and type of transactions for bank account BOA- 134579654190. Both graphs display the negative x and y quadrants. The "Bank Account" window is followed by a dropdown box comprising the bank account number "BOA-134579654190." Next to it, there is a sliding bar, followed by a few viewing options and a "Show history" checkbox. The first graph depicts the transaction activities for bank account BOA- 134579654190. The y-axis is titled "Amount" and has the values -400K, -200K, and 0K. The x-axis is titled "Trans Date". The values represent the days of a month, ranging from Day 1 to Day 31, in increments of 1. From Day 1 to Day 9, the line graph highly fluctuates. A line plotted on the graph begins on Day 1 on the x-axis at the y-axis value of -420,609. From Days 2 to 9, the y-axis values are -485,370, -339,905, -457,798, -301,425, -395,296, -379,669, -338,359, and -482,766, respectively. From Day 9 onwards, the graph line rises from -482,766 on Day 9 to -346,396 on Day 10, -335,556 on Day 11, and -308,244 on Day 12. From Day 12 to Day 15, the graph declines from -308,244 on Day 12 to -322,389 on Day 13, -369,600 on Day 14, and -410,042 on Day 15. From Day 15 to Day 19, the graph line rises to the highest point from -410,042 on Day 15, -350,828 on Day 16, -284,381 on Day 17, -275,148 on Day 18, and finally, -269,938 on Day 19. From Day 19 to Day 21, the graph line declines from -269,938 on 19 to -306,071 on 20 and -441,711 on 21. From Day 21 to 23, the graph line rises from -441,711 on Day 21 to -279,812 on Day 22 and -292,752 on Day 23. From 23 to 25, the graph line declines from -292,752 on 23 to -367,100 on 24 and -423,706 on 25. From Day 25 until Day 31, the graph line fluctuates highly. On Day 25, the y-axis value is -423,706; on 26, the y-axis is -298,838. The lowest point of the graph line is on Day 27 at a y-axis valued at - 497,505. Finally, on Days 28, 29, 30, and 31, the y-axis values are -300,048, -411,707, -474,716, and -357,500, respectively. The second graph is a bar graph that depicts the types of transaction activity conducted in one month for the bank account "BOA-134579654190." The graph is a cumulation of four bars representing four separate sections positioned one on top of the other. Next to the y-axis, the four sections are labeled "commission," "purchases," "salary," and "travel expenses." These sections come under the common header "Types of Transaction." The y-axis in each section is titled "Amount" and only has the value "-0.5 M" marked on it. The x-axis is titled "Trans Date," comprising values representing the dates in a month ranging from Days 1 to 31 with increments of 1. These transactions are represented via bars plotted across the graphs. In the first section labeled "commission," a minimal transaction activity is detected on Day 4 of approximately -0.12 M. The heaviest transaction activity is depicted in the "purchases" section. The transactions made from Days 1 to 31 are approximately -0.4 M, -0.45 M, -0.25 M, -0.3 M, -0.2 M, -0.25 M, -0.25 M, -0.2 M, -0.49 M, -0.25 M, -0.25 M, -0.2 M, -0.2 M, -0.3 M, 0.35 M, -0.25 M, 0.2 M, -0.15 M, -0.15 M, -0.2 M, -0.4 M, -0.15 M, -0.2 M, -0.25 M, -0.3 M, -0.2, -0.5 M, -0.2 M, 0.3 M, 0.49 M, and 0.3 M, respectively. On Day 27, the transactions hit the lowest point on the graph at -0.5 M. There are no transaction activities in the "salary" and "travel expenses." sections.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions