Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

given your results, evaluate the probability of purchasing errors or fraud in your company. identify any high risk suppliers. Sep 2020 Formula (54.264.80) ($299.99) $0.00

given your results, evaluate the probability of purchasing errors or fraud in your company. identify any high risk suppliers.
image text in transcribed
image text in transcribed
Sep 2020 Formula (54.264.80) ($299.99) $0.00 (54,564.79) $0.00 5662.47 $662.47 $0.00 $0.00 $250.00 (5350 00) ($100.00) $0.00 $0.00 $0.00 6 (Vendor) Total Q2 Total Q3 7 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 8 2021 - Sep 2021) Date Quarter 9 American Computers 10 7/07/2020 2020-3 $4,264 80 11 26/06/2020 2020-2 (5299.99) 12 Total - An $0.00 $0.00 ($299.99) $4,264.80 13 Best Fixture, Inc. 14 $50,000.00 15/07/2021 2021-3 15 9/05/2020 2020-2 $662.47 16 Total - Be $50,000.00 $662.47 $0.00 $0.00 17 Bob Ford, CPA 18 10/05/2020 2020-2 $250.00 19 15/07/2020 2020-3 $350,00 20 Total - Bo $0.00 $250.00 $0.00 $350.00 21 Canon, Inc $523,594.00 15/08/2021 2021-3 22 Clancy Ma $16,500.00 15/04/2021 2021-2 23 Computers Extreme 24 $324,860.00 15/06/2021 2021-2 25 $219,500.00 15/09/2021 2021-3 26 Total - Co $544,360.00 $0.00 $0.00 $0.00 27 Federal Express 15/06/2020 2020-2 $8.00 28 Herman M $995.00 31/05/2021 2021-2 29 Iron Horse $80,000.00 15/06/2021 2021-2 30 Koka Office Supplies 31 6/06/2020 2020-2 $69.21 32 11/05/2020 2020-2 $139.05 33 27/06/2020 2020-2 $12.04 34 23/05/2020 2020-2 $221.63 35 7/07/2020 2020-3 580.29 36 Total - Ko $0.00 $360.68 $81.25 $80.29 37 Maxson Waste Management 38 20/06/2020 2020-2 $80.00 39 20/05/2020 2020-2 $80.00 40 20/07/2020 2020-3 $80.00 41 Total - Ma $0.00 $80.00 $80.00 $80.00 42 McGeever Property Management 43 $4,800.00 4/04/2021 2021-2 44 4/05/2020 2020-2 $4,800.00 45 4/06/2020 2020-2 54,800.00 46 4/07/2020 2020-3 $4,800.00 47 Total - Mc $4,800.00 $4,800.00 $4,800.00 $4,800.00 48 Merlin CustomPurchasebyVendor Sum $0.00 $0.00 $0.00 $8.00 $0.00 $0.00 $69.21 $139.05 $12.04 $221.63 ($80.29) $361.64 $0.00 $80.00 $80.00 (580.00) $80.00 $0.00 50.00 $4,800.00 54,800.00 (54,800 00) $4,800.00 $0.00 $4,800.00 $4,800.00 $4,800.00 $4,800.00 $0.00 (54,800.00) $4,800.00 $60,000.00 ($60,000.00) $0.00 $0.00 $60,000.00 (560,000.00) $0.00 $0.00 $0.00 $0.00 $1,260.37 $1,216 22 $1,368.75 $1,368.75 $1,260.37 $1,216.22 $1,260.37 ($1,216.22) $1,368.75 $1,412.90 $0.00 $0.00 16 4/07/2020 2020-3 37 Total - Mc $4,800.00 18 Merlin 19 3/09/2020 2020-3 50 $120,000.00 15/07/2021 2021-3 51 $20,000.00 15/09/2021 2021-3 52 Total - Me $140,000.00 53 Motorola $18,000.00 15/06/2021 2021-2 54 Pacific Bell Telephone 55 4/06/2020 2020-2 56 4/07/2020 2020-3 57 4/05/2020 2020-2 58 Total - Pa $0.00 59 Panasonic $86,250.00 15/07/2021 2021-3 60 Safety Net Security 61 $199.00 14/04/2021 2021-2 62 $199.00 14/07/2021 2021-3 63 14/07/2020 2020-3 64 $199.00 14/05/2021 2021-2 65 $199.00 14/08/2021 2021-3 66 14/06/2020 2020-2 67 $199.00 14/09/2021 2021-3 68 14/05/2020 2020-2 69 $199.00 14/06/2021 2021-2 70 Total - Sa $1,194.00 71 Steele & Frock Law Offices 15/06/2020 2020-2 72 Superior ISP 73 $900.00 8/05/2021 2021-2 74 8/07/2020 2020-3 75 8/05/2020 2020-2 76 $900.00 8/04/2021 2021-2 77 Total - Su $1,800.00 78 Torrance Printing, Inc. 1/07/2020 2020-3 79 UPS 1/06/2020 2020-2 80 Total $1,467,493.00 81 82 $199.00 $199.00 50.00 $0.00 ($199.00) $0.00 $0.00 $199.00 $0.00 $199.00 $0.00 $199.00 $150.00 $199.00 $199.00 $199.00 $0.00 $199.00 $150.00 $900.00 5900.00 $900.00 $0.00 $900.00 $216.50 $344 25 $8,620.90 $6,622.88 $12,106.81 $0.00 (5900.00) $900.00 $0.00 $0.00 $0.00 ($216.50) $344.25 $60,000.00 (556,863.03) Sep 2020 Formula (54.264.80) ($299.99) $0.00 (54,564.79) $0.00 5662.47 $662.47 $0.00 $0.00 $250.00 (5350 00) ($100.00) $0.00 $0.00 $0.00 6 (Vendor) Total Q2 Total Q3 7 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 8 2021 - Sep 2021) Date Quarter 9 American Computers 10 7/07/2020 2020-3 $4,264 80 11 26/06/2020 2020-2 (5299.99) 12 Total - An $0.00 $0.00 ($299.99) $4,264.80 13 Best Fixture, Inc. 14 $50,000.00 15/07/2021 2021-3 15 9/05/2020 2020-2 $662.47 16 Total - Be $50,000.00 $662.47 $0.00 $0.00 17 Bob Ford, CPA 18 10/05/2020 2020-2 $250.00 19 15/07/2020 2020-3 $350,00 20 Total - Bo $0.00 $250.00 $0.00 $350.00 21 Canon, Inc $523,594.00 15/08/2021 2021-3 22 Clancy Ma $16,500.00 15/04/2021 2021-2 23 Computers Extreme 24 $324,860.00 15/06/2021 2021-2 25 $219,500.00 15/09/2021 2021-3 26 Total - Co $544,360.00 $0.00 $0.00 $0.00 27 Federal Express 15/06/2020 2020-2 $8.00 28 Herman M $995.00 31/05/2021 2021-2 29 Iron Horse $80,000.00 15/06/2021 2021-2 30 Koka Office Supplies 31 6/06/2020 2020-2 $69.21 32 11/05/2020 2020-2 $139.05 33 27/06/2020 2020-2 $12.04 34 23/05/2020 2020-2 $221.63 35 7/07/2020 2020-3 580.29 36 Total - Ko $0.00 $360.68 $81.25 $80.29 37 Maxson Waste Management 38 20/06/2020 2020-2 $80.00 39 20/05/2020 2020-2 $80.00 40 20/07/2020 2020-3 $80.00 41 Total - Ma $0.00 $80.00 $80.00 $80.00 42 McGeever Property Management 43 $4,800.00 4/04/2021 2021-2 44 4/05/2020 2020-2 $4,800.00 45 4/06/2020 2020-2 54,800.00 46 4/07/2020 2020-3 $4,800.00 47 Total - Mc $4,800.00 $4,800.00 $4,800.00 $4,800.00 48 Merlin CustomPurchasebyVendor Sum $0.00 $0.00 $0.00 $8.00 $0.00 $0.00 $69.21 $139.05 $12.04 $221.63 ($80.29) $361.64 $0.00 $80.00 $80.00 (580.00) $80.00 $0.00 50.00 $4,800.00 54,800.00 (54,800 00) $4,800.00 $0.00 $4,800.00 $4,800.00 $4,800.00 $4,800.00 $0.00 (54,800.00) $4,800.00 $60,000.00 ($60,000.00) $0.00 $0.00 $60,000.00 (560,000.00) $0.00 $0.00 $0.00 $0.00 $1,260.37 $1,216 22 $1,368.75 $1,368.75 $1,260.37 $1,216.22 $1,260.37 ($1,216.22) $1,368.75 $1,412.90 $0.00 $0.00 16 4/07/2020 2020-3 37 Total - Mc $4,800.00 18 Merlin 19 3/09/2020 2020-3 50 $120,000.00 15/07/2021 2021-3 51 $20,000.00 15/09/2021 2021-3 52 Total - Me $140,000.00 53 Motorola $18,000.00 15/06/2021 2021-2 54 Pacific Bell Telephone 55 4/06/2020 2020-2 56 4/07/2020 2020-3 57 4/05/2020 2020-2 58 Total - Pa $0.00 59 Panasonic $86,250.00 15/07/2021 2021-3 60 Safety Net Security 61 $199.00 14/04/2021 2021-2 62 $199.00 14/07/2021 2021-3 63 14/07/2020 2020-3 64 $199.00 14/05/2021 2021-2 65 $199.00 14/08/2021 2021-3 66 14/06/2020 2020-2 67 $199.00 14/09/2021 2021-3 68 14/05/2020 2020-2 69 $199.00 14/06/2021 2021-2 70 Total - Sa $1,194.00 71 Steele & Frock Law Offices 15/06/2020 2020-2 72 Superior ISP 73 $900.00 8/05/2021 2021-2 74 8/07/2020 2020-3 75 8/05/2020 2020-2 76 $900.00 8/04/2021 2021-2 77 Total - Su $1,800.00 78 Torrance Printing, Inc. 1/07/2020 2020-3 79 UPS 1/06/2020 2020-2 80 Total $1,467,493.00 81 82 $199.00 $199.00 50.00 $0.00 ($199.00) $0.00 $0.00 $199.00 $0.00 $199.00 $0.00 $199.00 $150.00 $199.00 $199.00 $199.00 $0.00 $199.00 $150.00 $900.00 5900.00 $900.00 $0.00 $900.00 $216.50 $344 25 $8,620.90 $6,622.88 $12,106.81 $0.00 (5900.00) $900.00 $0.00 $0.00 $0.00 ($216.50) $344.25 $60,000.00 (556,863.03)

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

IFRS edition volume 2

978-0470613474, 470613475, 978-0470616314

More Books

Students also viewed these Accounting questions

Question

7. LO.1, 2 Interpret this Regulation citation: Reg. 1.16310(a)(2).

Answered: 1 week ago