Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information Case Summary: ABC Company is a large retaller that collects its order-to-cash data in a large ERP system that was. recently updated to
Required information Case Summary: ABC Company is a large retaller that collects its order-to-cash data in a large ERP system that was. recently updated to comply with the AICPA's audit data standards. ABC Company currently collects all relevant data in the ERP system and digitizes any contracts, orders, or recelpts that are completed on paper. The credit department reviews customers who request credit. Sales orders are approved by managers before being sent to the warehouse for preparation and shipment. Cash receipts are collected by a cashier and applied to a customer's outstanding balance by an accounts recelvable clerk. You have been assigned to the audit team that will perform the internal controls audit of ABC Company. In this lab, you should identify appropriate questions and develop a hypothesis for each question. Then you should transiate questions Into target fieids and value in a database and perform a simple analysis Note: Submit your answers for the following Analysis Questions In the text entry fleid below. approval of shipments sent to customers, your question might be "Are any shipping managers approving shipments more than 2 days after they are recelved?" ihipping managers are approving shipments more than 2 days after they are recelved." Required Information Case Summary: ABC Company is a Iarge retaller that collects its order-to-cash data in a large ERP system that was recently updated to comply with the AICPA's audit data standards. ABC Company currently collects all relevant data In the ERP system and digitizes any contracts, orders, or recelpts that are completed on paper. The credit department revlews customers who request credit. Sales orders are approved by managers before being sent to the warehouse for preparation and shipment. Cash recelpts are collected by a cashier and applied to a customer's outstanding balance by an accounts recelvable clerk. You have been assigned to the audit team that will perform the internal controls audit of ABC Company. In this lab, you should identify approprlate questions and develop a hypothesis for each question. Then you should translate questions into target fields and value in a database and perform a simple analysis. Note: Submit your answers for the following Analysis Questions in the text entry field below. Approved_By, Entered_Date, and Approved_Date fields. AQ2. Are there data values you Identified in Part 1 that don't exist in the tables? Explain how you might collect the missing data or where you might locate them
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