Auditing

Refer to Tableau (Links to an external site.). If you do not already have a login, please register.

Your instructor will provide you with an Excel spreadsheet with the data for the ABC Company to use in this case.

Required:

Sort the file from largest to smallest Sales revenue. Determine a lower bound for the upper stratum. Defend your choice.

Assume that the ABC Company’s FYE is 12/31/12. Check for appropriate sales cutoff. Identify any potential errors in sales revenue.

Use Tableau to determine the market segment of sales by product category and consumer market region. What category of product has the highest sales volume? What category has the lowest sales volume? What are the top two regions in the world for sales volume of consumer office supplies? Which market region is an emerging market for Superstore Sales?

What month is the highest in terms of sales value? What is the year with the highest sales so far for the ABC Company?

Use the “Show Me” feature to determine which category of furniture sales yields the lowest profit, regardless of geographic location.

Learn about how to create a forecast in Tableau using the following link (and associated webinar): Forecasting with Tableau (Links to an external site.). Assume that you wish to develop an expectation to compare likely sales levels by month across the three product categories, that is, furniture, office, and technology. What is your forecast of sales for FYE 2013 for each of these categories? How would you use these forecasts as compared to actual FYE 2013 amounts as asserted by management?

Your written response paper should be 8-10 pages in length. Type your paper in a Word document and follow APA format, according to CSU Global Writing Center Requirements (Links to an external site.). Include a title page and reference page. Use four (4) outside academic sources other than the textbook, course materials, or other information provided as part of the course materials.