THIS IS A TABLEAU ASSIGNMENT!

Link to the

Roger Company cash disbursements excel file: https://drive.google.com/file/d/1Wl66VGVEg0R5DGVrCjfpcWseYcyhDRWj/view?usp=sharing

In order to answer the questions you will need to use (the above file) Roger Company cash disbursements file. You can Import this Excel file to Tableau then answer the questions. [THANK YOU]

1) First, make a new worksheet (tab) called CD by Payee.

• Add Amount Paid and Payee to the grid.
• Using the Show Me feature, view the data in a box-and-whiskers plot.

Which payee has been paid the most?

a) Nutritious Products

b) Hayward and Kjelstrom

c) Hartford Brothers

d) Perris Wheel Company

2) Make a new worksheet (tab) called CD by Week.

• Add Amount Paid and Date Paid to the plot.
• Expand Date Paid until Days are shown, then remove Years/Quarters/Month from the plot.

Company policy is to pay only on the 15thor the 30thof the month. What total dollar amount is paid off-cycle?

3) Regarding the off-cycle payments from #2, drill down and identify who was paid with those payments.

In conjunction with Questions #1 and #2 above, does this raise any concerns from an audit or fraud risk perspective?