Version: B (Total 80 Marks)
Please submit the below three items
1. Two separate TBWX files for Part I and II showing your analysis performed (e.g., formula, label, column, row, filter, legend)
2. One-word document contains brief answers (1-2 sentences) to each question in the below tables (feel free to adjust the size of the table
3. Provide final screenshot to support your analysis to each question
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 use Tableau 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.
Please use the dataset “JATireSales.xls” provided to your audit firm by the company for your analysis. This file contains sales transaction information for the year ended December 31, 2019. Please 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. Perform analysis below using Tableau. Please refer to Appendix 1: How to import data from Excel Tabs to Tableau
Dataset: “JATireSales.xls”
|
1. [16 marks in total] Summarize sales by month (5 marks) and sales division (5 marks) using a graph or chart in Tableau. Identify any sales divisions (3 marks) or months (3 marks) that you believe should be examined further and document your rationale
|
Brief Answer:
Final Screen |
|
2. [32 marks in total] For any divisions identified above for follow-up, summarize sales by customer and month using a graph or chart in Tableau (8 marks). Identify any months (8 marks), customers (8 marks) and specific transactions (8 marks) that you want to examine further and document your rationale.
|
Brief Answer:
Final Screen
|
• Dataset: Inventory
• Required: Please perform Tableau data visualization and answer the following questions:
|
1. Which of the five regions’ operations has the highest gross profit? 8 marks
|
Brief Answer: Final Screen
|
|
2. Which of the five regions’ operations has the lowest gross profit? 8 marks |
Brief Answer: Final Screen
|
|
3. Which state’s operations provides the highest gross profit ratio? (Round your answer to 1 decimal place; present it on the US map) 8 marks |
Brief Answer:
Final Screen
|
|
4. Which state’s operations provides the lowest gross profit ratio? (Round your answer to 1 decimal place; present it on the US map) 8 marks |
Brief Answer:
Final Screen
|
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
