Overview
Chapter 11 provides the opportunity to apply the skills you have learned in Audit Command Language (ACL) to prepare reports for data analysis and presentation. This chapter allows you to create reports based on the various cycles, such as cash receipts fraud.
Prompt
For this assignment, go to pages 12-17 and 12-19 of your textbook and prepare reports for Activities 1 - 4. Follow the instructions provided in the textbook for each project.
Specifically, the following critical elements must be addressed:
- For Project 1, create a report that shows inventory cost by product class with report items for each product class.
- For Project 2, create a pie graph stratifying the invoices using invoice amounts.
- For Project 3, prepare a report that shows year-to-date sales by sales rep, sorted in ascending order.
- For Project 4, arrange an aging AR table using criteria.
What to Submit
Submit your reports as a PDF, Microsoft Word, or Microsoft Excel document. The reports should follow the instructions as indicated on pages 11-16 and 11-17 of the textbook.
Module Eight Activity Rubric
| Criteria | Proficient (100%) | Needs Improvement (75%) | Not Evident (0%) | Value |
|---|---|---|---|---|
| Project 1 | Creates a report that shows inventory cost by product class with report items for each product class | Creates a report that shows inventory cost by product class, but report lacks organization or items are missing | Does not create a report that shows inventory cost by product class | 25 |
| Project 2 | Creates a pie graph stratifying the invoices using invoice amounts | Creates a pie graph stratifying the invoices using invoice amounts, but invoice amounts or stratification categories are incorrect | Does not create a pie graph stratifying the invoices using invoice amounts | 25 |
| Project 3 | Prepares report that shows year-to-date sales by sales rep, sorted in ascending order | Prepares report that shows year-to-date sales by sales rep, sorted in ascending order, but data is incorrect | Does not prepare report that shows year-to-date sales by sales rep, sorted in ascending order | 25 |
| Project 4 | Creates a line graph of the aged data using invoice amounts | Creates a line graph of the aged data, but invoice amounts or aging categories are incorrect | Does not create a line graph of the aged data | 25 |
| Total: | 100% |