Skip to main content

Anston Products sells equipment and parts to retailers throughout the United States

Answer all parts of these requirements on this page through page 7-33. It is more convenient to complete the assignment if you remove pages 7-31 and 7-33 now. For each requirement, include the command you used, where applicable, and the correct answer or exception(s) found. For requirements that require a printout, include the assignment number on the printout you hand in to the instructor.
Anston Products sells equipment and parts to retailers throughout the United States. You are planning tests of inventory purchases for the yea r ended 6/30115. Inventory acquisitions are by far the most significant acquisition transactions, and they a rerecorded in a separate acquisitions journal already included in ACL as the Inventory _Purchases table in the Anston Products project.
You have already completed the preliminary internal controls assessment for acquisitions and have identified several deficiencies. After completing planning, your assistant will be doing tests of controls and substantive tests of transactions for acquisitions, as well as year-end testing of accounts payable.
The IT department informed you that there a re 752 records in the file and the control totals for only the amount column is 4,090,981.79. The general ledger totals for inventory purchases are:
July
$ 234,250.59
January
$ 247,300.69
August
$ 190,742.00
February
$ 1,358,603.66
September
$ 311,244.41
March
$ 250,049.56
October
$ 176,435.11
April
$ 204,049.56
November
$ 300,942.85
May $ 321,416.05
December $ 301,940.49
June $ 293,731.16
Complete the following requirements using ACL:
Q 1. Use the Verify, Count, and Total commands to determine the completeness of the inventory purchases file and the accuracy of the information provided by IT. Explain.
Answer:
Q 2. Determine whether the general ledger monthly total is correct. Explain.
Answer:
Q 3. Without using any analysis commands, identify any date or data concerns that you believe require any follow-up. State what you did and any concerns identified.
Answer:
Q 4. Perform classify or summarize commands on the key fields as a test of their reasonableness. State each command you used, the fields used in the command, and any concerns that you believe require additional testing.
Answer:
Q 5. The audit plan calls for testing a random sample of all acquisition transactions, as well as tests of the existence and completeness of year-end accounts payable. Indicate how you would modify your testing in response to the concerns identified

Comments

Post a Comment

Popular posts from this blog

Identify and discuss a key milestone in the history of computers that interests you and why.

  Part 1Title: Lab ResponseDiscuss one feature of MS Word and one feature of MS Excel that you found challenging within the lab and why. Examples are WordArt, inserting shapes, adding borders, cell styles, etc. This response should be at least one paragraph in length. Part 2Title: History of Computers Identify and discuss a key milestone in the history of computers that interests you and why. This section should be at least one paragraph. Part 3Title: System Software vs. Application Software In your words, explain the difference between application software and system software as if to another coworker who has limited technical knowledge. Use examples to support your rationalization. This section should be at least two paragraphs. Part 4Title: Blockchain and Cryptocurrency In a minimum of one paragraph each: 1. Conduct some research on the internet and discuss one underlying technology of cryptocurrencies like blockchain, cryptography, distributed ledger technol...
Post a Comment
Read more

Cybersecurity and Infrastructure Security (CISA)

 Develop a research paper that identifies a specific Department of Homeland Security (DHS) operating agency. Fully describe 1 DHS operating agency from the following list: Cybersecurity and Infrastructure Security (CISA) U.S. Customs and Border Protection (CBP) U.S. Citizenship and Immigration Services (USCIS) Federal Emergency Management Agency (FEMA) U.S. Coast Guard (USCG) U.S. Immigration and Customs Enforcement (ICE) U.S. Secret Service (USSS) Transportation Security Administration (TSA) The information must include a discussion of the selected DHS agency. Identify the agency’s mission, goals, objectives, and metrics. Conduct an analysis of how these mission areas address the threats or challenges. Recommend agency program priorities among the current set of goals, objectives, metrics, or budget items. Justification of all choices is an essential element of this assignment. Reference all source material and citations using APA format. WE OFF...
Post a Comment
Read more

You have been given the t

PPMP20009 Leading Lean Projects Term 2, 2018 Page 1 of 3 Assessment 1 (Individual Work – 40%) Case study: Managing Lean Project Introduction You have been given the task to organise the FIFA 2018 World Cup football tournament ( https://ift.tt/2If0UDE ). (For those not familiar with football, you may change the event to the recently concluded 2018 Gold Coast Commonwealth Games: https://gc2018.com/ ). Your tasks This assessment item requires you to work INDIVIDUALLY. 1. As the project manager in charge of delivering such as an important world sporting event: i. Identify and elaborate the following terms with regards to the event. a. Voice of the Customer (VOC) b. Critical to Customer Requirements (CCR) c. Critical to Quality parameters (CTQ) ii. In what ways would you have implemented lean project management for this event? Identify and elaborate processes from PMBOK, PRINCE2, Organisational Project iii. Management Agile Practices and Lean Six Sigma (DMAIC Me...
Post a Comment
Read more