Brief memo to the manager and include the charts

Assignment Help Accounting Basics

Reference no: EM133610211

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 already performed, you identified risks related to the fact that salespersons receive a commission 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 review sales information by sales division and by month to identify potential risk areas that might warrant further audit procedures related to sales.

Required

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 worksheet 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.
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.
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.

Reference no: EM133610211

Questions Cloud

What will accounts payable be at the end of april : Purchases are paid in the month after purchase. Sporting makes all sales on credit and collects 40% in the month of sale and 60% in the month after sale

What does each thinker consider to be the ultimate goal : What does each thinker consider to be the ultimate goal of love? Provide example from your own life, novel or movie of how love acted as a transformative force

How would you recognize an ethical pharmaceutical company : Do pharmaceutical companies have any moral responsibility to ensure their products are not consumed illegitimately?

What did you learn about accessibility for people : Where did you find the most items? What items were hardest to find? What did you learn about accessibility for people with disabilities through this activity?

Brief memo to the manager and include the charts : 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

Who has struggled with depression on and off since beginning : who has struggled with depression on and off since beginning college. She was picked up by campus police after being caught vandalizing a man's apartment

What did you find difficult about using joint attention : What did you find difficult about using joint attention? What did you find beneficial about using these strategies? Were there any moments that surprised you?

Make an estimated payroll every months for a year : Make an estimated payroll every months for a year, for 4 owners, 1 independent contractors with Hourly Pay of $30 for Curated box gift business

What are the goals of the bankruptcy act : What are the goals of the Bankruptcy Act? How are the various creditors' claims prioritized in bankruptcy?

User Account

All Pages