Required:

Using highlight tables,

$(1)$ consider the amount of the total relationship between the vendor and the company is serviced by the A$/$P clerk, and $(2)$ for the two most significant relationships, evaluate the invoice payment period $($to see if there is any favoritism being shown$).$

Duplicate the sheets with highlight tables to create box plots and build a dashboard with both box plot sheets.

Ask the Question: Is there an abnormal, nonrandom relationship between the A$/$P clerk and a company's vendors?

Master the Data: Open Tableau and connect to Excel File Lab $7-9$ Alt Data.xIsx. Apply the same steps as Lab $7-9$ to the Lab $7-9$ Alt Data.xlsx dataset.

Software needed

Tableau

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Lab $7-9$ Alt Data.xIsx.

Perform the Analysis: Refer to Lab $7-9$ Alternate in the text for instructions and Lab $7-9$ steps for each the of lab parts.

Share the Story: We will next take this analytics and report to the internal auditor or to the audit committee for further investigative work.

quired:

What is the average days to pay between Bobs and AP Clerk # AP $0010?$

$37$

$29\mathrm{.}6$

$17\mathrm{.}25$

$38\mathrm{.}25$

What is the average days to pay between Peters and AP Clerk # AP $0050?$

$29\mathrm{.}6$

$17\mathrm{.}25$

$37$

$57$

iven the evidence, which pair would you have the biggest concern about their being favorable treatment?