This is cis360 CLASS, bisiness data analyse,one acl assignment and one excel

Bradmark Comprehensive Case Fraud Audit IssuesChapter 12 Questions To answer these questions requires that you install ACL Desktop Edition (full educational version) on your computer. To do so follow the instructions on the CD that came with the textbook. The ACL Project and ACL files used in the Bradmark case are located in the Bradmark Data Folder on the website. Download these files to your computer and click on the Bradmark 04 ACL icon. ACL will automatically open the case. Based on your analysis of Bradmark's internal controls and audit tests covered in Assignments 1 and 2, perform tests that could reveal the existence of fraud in the company. Design your tests around the Fraud Tutorials and the Fraud Detection Techniques discussed in the textbook. Hand in a report describing the audit tests and your conclusions about the results of the test. To document your findings, include in your report ACL printouts showing details of test results and the command log. Describe and perform tests to uncover the following fraud: General Control Problem - Because of James Walker's familiarity with the purchases system, he was asked by top management to temporarily oversee the initial running of the new system to ensure a smooth transition from the old legacy system. After several months, Walker was offered a promotion to Warehouse Manager and given permanent responsibility for product purchasing. This act by management placed Walker in a situation that allowed him to exploit inherent weaknesses in the system and perpetrate a fraud. As part of the fraud Walker established himself as a fictitious vendor number 11663. The fraud methodology involved using his uncontrolled access to the system to falsify purchase orders to his phony company and use voided receiving report numbers to simulate inventory receipts. These two events trigger the system to create a voucher payable record. By submitting vendor an invoice from his fictitious company, Walker effectively tricks the system into writing him a check. Semester 1 GPA Course Code ACCT 2820 ACCT 4540 BADM 4010 FNCE 4050 MGMT 3030 Course Name Overall GPA Course Credits Course Grade 0 A C B+ A- Credit Points Credits to Earned GPA Assignment Type Points Earned Points Possible Homework Paper Test Overall Grade Letter Grade % of Total Grade Inputs Assignment # Points Earned 1 20 2 18 3 15 4 18 5 20 6 20 7 15 8 15 9 15 10 16 11 19 12 16 13 17 14 17 15 20 16 16 17 17 18 20 19 18 20 20 21 16 22 16 23 20 24 19 25 18 26 17 27 17 28 19 29 19 30 20 31 45 32 37 33 50 34 27 35 50 36 33 37 29 38 28 39 35 40 37 41 100 42 85 43 81 44 83 45 93 46 96 47 82 48 90 49 93 50 81 Assignment # Assignment Name Points Earned Points Possible % Grade Assignment Type As of 12/31/2013 Customer # Customer Name Invoice # 1 ABC Co. 1 ABC Co. 1 ABC Co. 1 ABC Co. 1 ABC Co. 1 ABC Co. 1 ABC Co. 1 ABC Co. 1 ABC Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 10 BCD Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 9 YZA Co. 15 70669 70730 70762 70790 225615 225673 225727 225756 290298 290396 290413 290464 290468 290491 290507 320272 320342 320367 320409 344561 344568 344583 344606 344607 344623 344640 344658 344659 344752 344763 366623 366662 366667 366677 366718 366721 366734 Invoice Date Ozs Sold Amount Invoiced 6/1/2013 33,292 765,723 7/8/2013 33,284 765,528 7/8/2013 9,848 226,508 7/8/2013 37,042 851,957 7/8/2013 39,676 912,557 9/29/2013 8,190 188,359 9/29/2013 22,879 526,207 9/29/2013 35,329 812,566 9/29/2013 23,493 540,335 11/3/2013 7,456 171,486 11/3/2013 5,542 127,456 11/3/2013 23,536 541,326 11/3/2013 11,998 275,949 11/3/2013 37,458 861,529 11/3/2013 4,397 101,123 11/3/2013 10,139 233,202 11/18/2013 19,681 452,653 11/18/2013 20,280 466,436 11/18/2013 26,070 599,604 11/18/2013 40,676 935,557 12/1/2013 13,347 306,984 12/1/2013 37,378 859,687 12/1/2013 33,730 775,786 12/1/2013 39,975 919,417 12/1/2013 13,028 299,638 12/1/2013 6,765 155,598 12/1/2013 13,989 321,739 12/1/2013 25,919 596,132 12/1/2013 5,751 132,272 12/1/2013 5,873 135,090 12/1/2013 43,307 996,066 12/13/2013 28,036 644,830 12/13/2013 39,804 915,501 12/13/2013 38,936 895,537 12/13/2013 25,452 585,407 12/13/2013 15,173 348,975 12/13/2013 10,350 238,044 12/13/2013 12,136 279,133