This case study was created by Ernst & Young. Students will work with a structured data set of several thousand cash, sales, accounts receivable and cost of goods sold subledger transactions for the first two years of operations of TechWear, a start-up company that manufactures and sells upper-end, high-tech sportswear. Students will gain insights into TechWear’s order-to-cash cycle, develop an accounts receivable trial balance and aging schedule and perform an analysis on accounts receivable, sales and cost of goods sold balances. Students will need to interpret their analyses and provide recommendations to the audit committee. The case is completed in both Excel and Tableau and is accompanied by how to videos.
Case Overview
This is a five-part case where you are asked to assume the role of an auditor and perform various audit procedures on accounts receivables and sales for TechWear, a start-up company that manufactures and sells upper-end, high-tech, sportswear. Throughout the case, you will be implementing the analytics mindset in an audit context. The analytics mindset consists of:
➢ Ask the right business questions
➢ Extract, transform, and load relevant data (ETL process) ➢ Apply appropriate data analytic techniques
➢ Interpret and share results with stakeholders
The Five Parts of the Case (ONLY DO PARTS 1-3)
Become familiar with the background of TechWear. Perform basic ETL procedures.
Using data from Part 1, develop an accounts receivable (AR) trial balance and perform
analysis to inform your assessment of the collectability risk on the 12/31/2015 AR
balance.
It is now 2016. Review the audit assertions for accounts receivable and sales and
complete an audit data-planning analysis template.
The post This case study was created by Ernst & Young. Students will work appeared first on PapersSpot.