Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel exercise: find a fraud: please find the invoices that you believe have fraud red flags and briefly explain why. fNotes: The times and dates

Excel exercise: find a fraud: please find the invoices that you believe have fraud red flags and briefly explain why.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
\fNotes: The times and dates for all sales are automatically recorded by the database system when the sale is complete. All sales over $20,000 must be authorized by a senior manager before the sale can be entered into the system. Invoice Customer Credit Memo Credit Date Credit Number Sale Date Sale Time Sale Amount Salesperson Number Number Amount 20001 11/2/15 13:31:28 $8,090.03 A 1124 20002 11/2/15 13:41:33 $19,166.57 A 1131 20003 11/2/15 15:19:56 $6,269.27 A 1127 20004 11/2/15 16:26:52 $13,361.81 B 1132 20005 11/2/15 16:01:22 $9,216.60 B 1140 20006 11/2/15 09:24:38 $11,528.98 C 1137 20007 11/2/15 11:03:18 $19,000.00 C 1123 20008 11/2/15 15:46:55 $9,579.46 B 1120 20009 11/2/15 09:52:03 $14,768.82 A 1129 3145 11/7/15 $14,768.82 20010 11/2/15 10:37:37 $8,733.64 A 1128 20011 11/2/15 09:21:39 $18,992.28 1131 20012 11/2/15 13:15:29 $12,019.59 1124 20013 11/2/15 10:13:52 $51,394.33 C 1126 20014 11/2/15 16:01:19 $7,922.47 B 1138 20015 11/2/15 13:45:07 $35,896.57 B 1138 20016 11/2/15 13:03:29 $10,308.75 B 1137 20017 11/2/15 14:54:29 $19,900.00 C 1123 20018 11/3/15 09:59:28 $20,000.00 C 1133 20019 11/3/15 12:48:32 $12,406.18 A 1130 20020 11/3/15 13:50:00 $7,242.38 A 1128 3146 11/9/15 $7,242.38 20021 11/6/15 21:50:01 $17,490.62 C 1123 20022 11/6/15 09:12:09 $12,852.28 B 1122 20023 1 1/6/15 08:49:04 $12,636.12 1140 20024 11/9/15 16:09:15 $7,691.13 A 1121 20025 11/9/15 15:56:03 $11,976.10 B 1122 20026 11/9/15 16:36:17 $9,615.38 B 1120 20027 11/9/15 11:15:21 $11,746.38 B 1138 20028 1 1/9/15 13:24:57 $11,869.73 1123 20029 11/9/15 14:40:00 $7,268.23 1139 20030 11/9/15 10:26:11 $8,596.85 1130 20031 11/10/15 15:19:42 $8,481.82 1128 20032 11/10/15 11:19:07 $9,202.38 1125 20033 11/10/15 15:49:12 $11,433.28 1132 20034 11/10/15 12:57:16 $7,368.18 A 1127

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

Fundamental Accounting Principles

Authors: John Wild, Ken Shaw, Barbara Chiappetta

19th Edition

0077303202, 9780077303204

More Books

Students also viewed these Accounting questions

Question

=+a) What were the factors and factor levels?

Answered: 1 week ago

Question

5. It is the needs of the individual that are important.

Answered: 1 week ago