Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started