just do number 5 because numbers 1 to 4 are already

just do number 5 because numbers 1 to 4 are already solved included in the attached excel file. mini analytical (2)
As part of the engagement team for the audit of JA Tire Manufacturing for the year ended December 31, 2019, you are responsible for auditing the sales and collection cycle. The audit data “JATireSales.xls” is provided to you by the company. This file contains sales transaction information for the year ended December 31, 2019.
Perform the following audit procedures:
1. The company issues sales invoices in sequential order. Determine whether there are any gaps or duplicates in the sales invoice sequence.
2. Company policy is that invoices should be prepared within five days of shipment. Identify any sales included in the invoice file that were not invoiced within five days of shipment.
3. Verify that all sales included in the Invoice file are to authorized customers included in the Customer Master file.
4. Determine that the total amount of the invoices included in the Invoice file (in the Amount column) is properly computed based on the quantities shipped and invoice prices.
5. Summarize your findings. Keep your answer precise.
This mini analytical project helps with your understanding of how to use data analytics for the audit of sales invoices.
submit your own Excel worksheet along with a one-paragraph writeup.[supanova_question]

Review the Actual vs. Budgeted Report [DOCX] document and use it Essay

Review the Actual vs. Budgeted Report [DOCX] document and use it for this discussion.
Discuss the most important thing you would do to minimize variances in this report. Support your rationale.
Use references.[supanova_question]

Article for Accounting Essay

Accounting Assignment Help Submit a current event article abstract relating to course material (preferably relating to the topics being covered that week in class). Which was the breakdown of Annual Reports. An abstract with a minimum of three complete paragraphs needs to be prepared for each article. Include in the abstract: outline of the article, how it relates to class and observations.

– Include article name and source
– Explanation of the article
– How it relates to business finance
– Any lessons learned[supanova_question]

External Financing Needed

External Financing Needed [supanova_question]