You will need Microsoft Excel to prepare this assignment. You have two weeks to complete this Assignment, which is due at the end of Module 6.
This is a two-part case where students are asked to assume the role of an auditor and perform various audit procedures on the order-to-cash business cycle (accounts receivable and sales) for TechWear, a start-up company that manufactures and sells upper-end, high-tech sportswear. Throughout the case, students will be developing their analytics mindset in an audit context by learning how to:
A brief overview of TechWear:
TechWear is a privately owned business that began operations in March 2015. Its sole business is the manufacture and sale of upper-end, high-tech sportswear. It only sells to large distribution outlets. Its primary product is a line of lightweight exercise clothes that contain a new, long-range RFID chip that captures the following information about the user based on personal data (age and weight, for example) entered by the user:
The chip is able to continuously send this information to a host device as far away as 15 miles. The clothes are also GPS-enabled and able to track routes, distances, and elevations. Management prides itself on being on the cutting edge. The company expects to conduct an IPO within a year or two.
TechWear recently retained your firm as its auditors, largely because of your commitment to conduct a highly efficient, technology-enabled audit.
Case and Assignment Requirements:
You are first responsible for performing a risk assessment of TechWear related to its order-to-cash function. Therefore, you know that your focus needs to be on sales and cash transactions. Your first task is to acquire the data for these transactions. You work with TechWear’s IT group to gain access to its sales and cash receipts data for its start-up period of operations—March through December 2015.
You have been provided with an Excel file with this data (Analytics_mindset_case_study_Techwear_Part1_data file.xls) so you can begin your analysis. The data file includes the following fields:
Become familiar with your data file. Make certain that your data is complete and accurate before performing any analysis. Complete the following using Excel:
Part I (additional guidance):
This section allows students to become familiar with the background company and the data for the order-to-cash business process (sales and cash receipts covering the start-up period of operations, which runs from March 5 through December 31, 2015).
Students are asked to perform some select steps in the ETL process to make certain of the integrity of the data they will be using for their analysis (note that there are more possible steps that could be done, but the requirements are limited for purposes of this case). This work is done in Excel. Students are using some basic Excel skills, including (covering questions 1 through 3):
Now that you have your data, you need to perform appropriate analytics techniques to inform your risk assessment for the order-to-cash cycle for TechWear.
Part II (additional guidance):
This section asks students to develop an accounts receivable trial balance for December 31, 2015, and perform an initial risk assessment of the collectibility of that balance. This work is done in Excel. Students are using some moderate-level Excel skills, including: (Note that there are MP4 files here to provide you some guidance.)
You are to submit a Word document with your answers to the three Part I Questions.
You are to submit Excel document, using the Tab function in Excel, to answer the four Part II Questions.
Why Choose Us
We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.
Professional Academic Writers
Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.
Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.
We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.
At Papers Owl, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.
Customer Support 24/7
Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: firstname.lastname@example.org.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Papers Owl has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
At Papers Owl, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.