I have question to solve, CIS 360, Business Database Analyse

Bradmark Comprehensive Case Chapter 10 - Expenditure Cycle Questions Read The Bradmark Case located in the \"Bradmark Case Description\" folder and answer the following questions: 1) From the case description and the associated flowcharts, assess Bradmark's internal controls over its expenditure cycle procedures. (again, there are three issues - related to transaction authorization, segregation of duties and accounting records) 2) Using the case description, the flowchart, the file structure, and financial data below, audit objectives (that can be achieved using ACL) are provided for each management assertion presented in the matrix below. For each audit objective, briefly describe the ACL test procedure. (and I've given you the last two, so you only have to list the audit procedure for the first assertion!) Selected Financial data: Inventory Balance at 12/31/2004 Management Assertion Completeness Valuation or Allocation Accuracy Audit Objective Verify that the Accounts Payable figure reflects all purchases that occurred and were received during period Verify that the inventory balance is reported at net realizable value Verify that payments to vendors accurately reflect the amounts owed. $ 1,108,194.94 Audit Procedures to be Performed Using ACL Recalculate Inventory balance and verify that the lower of cost or market values for individual items was used in the reported balance. Join Chk Register and Voucher Pay on Voucher Num. Review for discrepancies. To answer parts 3 and 4 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. 3) Perform the ACL tests outlined in step 2 above. The Project and ACL files for the Bradmark case are located in the Bradmark Data Folder. 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. 4) Using the matrix format below briefly describe the audit objective and ACL procedures to answer the given operational (business) concern related to the expenditure procedures. Perform the ACL test and prepare a report with your conclusions. Document your report with ACL printouts showing details of test results and the command log. Operational/Audit Risk (indicate which) Purchase discounts are not being taken. (operational risk). Operational/Audit Objective Payments should be made on their due date. Audit Procedures to be Performed Using ACL