ASSIGNMENT
7-38 (OBJECTIVE 7-5) As the in-charge senior auditor on the audit engagement for JA Tire
Manufacturing for the year ended December 31, 2019, you are responsible for performing risk assessment procedures related to the sales cycle. JA Tire has four sales divisions within the U.S. and sells primarily to large tire companies with regional warehouses that subsequently distribute to local retailers. Based on some of the risk assessment procedures you identified risks related to the fact that salespersons receive a com- mission on sales to distributors and the commission is calculated on a monthly basis. Your manager has asked you to perform analytical procedures as a part of audit planning to re- view sales information by sales division and by month to identify potential risk areas that might warrant further audit procedures related to sales.
1. Visit the textbook website to download the file “JATireSales.xls” provided to your
audit firm by the company. This file contains sales transaction information for the
year ended December 31, 2019. If you have not already done so, read the JA Tire
Manufacturing system description provided on the first tab of the Excel file before
attempting this assignment to familiarize yourself with the sales process and the
relevant worksheets and terminology. Using the “Invoices” and “Sales Order” tabs
in the Excel spreadsheet, perform the procedures in requirements 2 through 4
using either Excel, Tableau, or audit software such as ACL or IDEA.
Required
Data
Analytics
Required
AUDIT EVIDENCE 227
2. Summarize sales by month and sales division using a pivot table in Excel (hint: put divisions in columns, months in rows) or using a graph or chart in Tableau. If you are using Excel to summarize, you will first need to add a column to the Excel work- sheet and extract the “month” portion of the shipping date in order to summarize by month. If you are using Excel, use the “graph” feature to graph the pivot table data.
Identify any divisions or months that you believe should be examined further, and document your rationale.
3. For any divisions identified in step 2 for follow-up, summarize sales by customer and month using a pivot table in Excel or graph or chart in Tableau.
You can use a “filter” in Excel or Tableau to limit the analysis to one or more divisions. Identify any months that you want to examine further, and document your rationale.
4. Summarize your findings in a brief memo to the manager and include the charts or graphs generated in steps 2 and 3 above as support for your findings. Discuss your recommendations for performing further audit procedures.
7-39 (OBJECTIVE 7-6) Regulators are taking advantage of advances in technology to ful- fill their oversight responsibilities. Visit the website of the Securities and Exchange Commission (SEC) (www.sec.gov) to locate the speech given at the OpRisk North Scott W. Bauguess, Acting Director and Acting Chief Economist in the Division of Economic and Risk Analysis. Read the speech to answer the following:
a. What data analysis technique did the SEC use as one of its initial attempts to integrate machine learning into its analysis of public company filings at the SEC?
b. What is latent dirichlet allocation (LDA) and how has it been used by the SEC?
c. Describe the magnitude and scale of data for one day of the Option Reporting Authority (OPRA) and highlight how advanced technologies allow analysis of data sets of that size.
d. To what extent might advanced technologies replace humans in the SEC enforcement
process?
7-40 (OBJECTIVES 7-8, 7-9) You are the in-charge auditor on the audit of Vandervoort Company and are to review the audit schedule shown on the next page.
a. List the deficiencies in the audit schedule.
b. For each deficiency, state how the audit schedule could be improved.
c. Prepare an improved audit schedule, using an electronic spreadsheet software pro-
gram. Include an indication of the audit work done as well as the analysis of the client
data (instructor’s option).
Custompaper.help is an academic writing platform that provides students and professionals with quality services to ease their assignment challenges. With a wide range of services, the platform has become one of the leading academic writing service providers in the market due to its reliability and affordability. Below, we shall discuss some of the services which Custompaper.help provides:
Essay Writing Service
The essay writing service provides customers with quality essays on any subject or topic they requested within a given deadline. The writers at custompaper are experts in their respective fields, and they ensure customer satisfaction by producing original content with thorough research involved backed up with strong evidence from reliable sources available online or offline. All essays come with free plagiarism reports as well as revisions if needed so that customers can trust that they are getting high-quality work for their money’s worth.
Research Paper Writing Service
This is another popular service offered by custom paper help wherein customers are assisted in conducting research papers according to their needs and requirements within specified deadlines. Writers at custom paper help have vast knowledge about various topics belonging to different disciplines such as Management, Arts & Humanities, History etc., allowing them to craft impeccable research papers every time regardless of the complexity or urgency level requested by customers. Additionally, all our research papers come along with proper citation formats which ensures customer’s safety when it comes to plagiarism issues while also helping them save time on formatting procedures thus improving overall efficiency even further!
Dissertation Writing Service
CustomPaperHelp also offers dissertation writing assistance for those who need it most – students preparing for graduation or professionals wanting to further refine their skills through higher education levels such as Master/PhD degrees etc, Our team of writers consists of experienced individuals having Master’s/PhD degrees themselves so you can rest assured that your dissertation will be handled expertly from the start till the end! Furthermore, we offer unlimited revisions until your complete satisfaction is achieved, along with regular checkups being done throughout the process just so everything goes according to course without any hiccups!
Editing And Proofreading Services
If you already have written an essay but want professional feedback before submitting it, then CustomPaperHelp also offers editing & proofreading services which helps in identifying & rectifying errors present in assignments like grammar mistakes, spelling mistakes, punctuation problems etc., thereby ensuring top-notch quality work, before submission takes place! We understand how important accuracy & consistency are when it comes to grading systems used at universities nowadays, so taking extra care during this phase becomes absolutely essential if good grades are desired afterward!
Coursework Help
For those who find coursework difficult due to complications of being quite technical in nature; CustomPaperHelp extends its support here too, by providing quality solutions every single time – starting from understanding concepts properly up until composing flawless answers following university guidelines closely enough making sure no loopholes remain whatsoever! Whether it’s related math problem-solving algorithms or lengthy home assignments – our expert panel has got you covered from head-to-toe leaving no stone unturned during this very crucial stage since final grades depend largely upon the success rate achieved here successfully!
Assignment Help
Assignments form an integral part of getting better scores & ultimately, a degree itself (in case pursuing a masters/PhD) – something only possible if precision is made a priority right away; otherwise, chances of failure increase exponentially over a time period detrimentally affecting performance evaluation systems later down road drastically hence stressing timely importance completion prior commencement other operations associated same project altogether consistently meeting high standards expected each situation respectively! Here too, CustomPaperHelp presents comprehensive solution package exceeding expectations beyond point offering optimal values therein ensuring maximum satisfaction reached under circumstances prevailing accordingly without fail…proving once more why people trust us implicitly without second thought whatsoever!!
