In this lab, you will:

Required:

1. Using pivottables,

(1) consider the amount of the total relationship between the vendor and the company as 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).

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

Master the Data: Open Excel File Lab 7-8 Alt Data.xlsx, and perform the analysis, similar to Lab 7-8.

Software needed

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

Data: Excel File Lab 7-8 Alt Data.xlsx.

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

Share the Story: We have identified a possible fraudulent relationship between AP Clerk AP0040 and SLC Inc. and will want to investigate further. We will next take this analytics and report to the internal auditor or to the audit committee for further investigative work.

Part 1: Upload Your Files

Part 2: Assessment

A B D E Invoice Amount 1 A/P Clerk 2 AP0050 475 3 AP0090 202 402 303 194 429 232 295 454 408 430 445 317 316 316 4 AP0050 5 AP0090 6 APO070 7 APO020 8 AP0060 9 AP0070 10 AP0050 11 AP0080 12 APO010 13 AP0050 14 AP0090 15 AP0090 16 AP0080 17 APO030 18 AP0070 19 AP0030 20 AP0010 21 APO020 22 AP0060 23 AP0030 24 AP0010 25 AP0080 26 AP0010 27 AP0030 28 AP0060 29 AP0080 30 AP0050 31 AP0080 32 AP0070 33 AP0040 Vendor Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. 451 499 278 401 475 402 Invoice Date 5/1/23 5/1/23 5/3/23 5/3/23 5/3/23 5/5/23 5/5/23 5/5/23 5/5/23 5/5/23 5/6/23 5/6/23 5/6/23 5/7/23 5/7/23 5/7/23 5/9/23 5/9/23 5/11/23 5/13/23 5/13/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/15/23 5/15/23 5/15/23 Payment Date 5/25/23 6/5/23 6/3/23 6/5/23 6/21/23 6/13/23 6/13/23 6/10/23 6/23/23 5/26/23 6/12/23 5/31/23 7/5/23 6/23/23 6/7/23 5/20/23 6/4/23 5/31/23 6/13/23 6/17/23 7/6/23 6/5/23 6/25/23 6/14/23 6/24/23 5/26/23 7/8/23 6/26/23 6/18/23 6/6/23 6/16/23 6/22/23 311 483 282 225 469 151 181 206 340 390 304 A B D E Invoice Amount 1 A/P Clerk 2 AP0050 475 3 AP0090 202 402 303 194 429 232 295 454 408 430 445 317 316 316 4 AP0050 5 AP0090 6 APO070 7 APO020 8 AP0060 9 AP0070 10 AP0050 11 AP0080 12 APO010 13 AP0050 14 AP0090 15 AP0090 16 AP0080 17 APO030 18 AP0070 19 AP0030 20 AP0010 21 APO020 22 AP0060 23 AP0030 24 AP0010 25 AP0080 26 AP0010 27 AP0030 28 AP0060 29 AP0080 30 AP0050 31 AP0080 32 AP0070 33 AP0040 Vendor Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. Bobs Inc. 451 499 278 401 475 402 Invoice Date 5/1/23 5/1/23 5/3/23 5/3/23 5/3/23 5/5/23 5/5/23 5/5/23 5/5/23 5/5/23 5/6/23 5/6/23 5/6/23 5/7/23 5/7/23 5/7/23 5/9/23 5/9/23 5/11/23 5/13/23 5/13/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/14/23 5/15/23 5/15/23 5/15/23 Payment Date 5/25/23 6/5/23 6/3/23 6/5/23 6/21/23 6/13/23 6/13/23 6/10/23 6/23/23 5/26/23 6/12/23 5/31/23 7/5/23 6/23/23 6/7/23 5/20/23 6/4/23 5/31/23 6/13/23 6/17/23 7/6/23 6/5/23 6/25/23 6/14/23 6/24/23 5/26/23 7/8/23 6/26/23 6/18/23 6/6/23 6/16/23 6/22/23 311 483 282 225 469 151 181 206 340 390 304