question archive Project 3 - Analytics for Expenditure This is the second of the two data analysis group projects for the course, where you will complete a set of data analysis tasks related to the Expenditure Cycle

Project 3 - Analytics for Expenditure This is the second of the two data analysis group projects for the course, where you will complete a set of data analysis tasks related to the Expenditure Cycle

Subject:BusinessPrice: Bought3

Project 3 - Analytics for Expenditure

This is the second of the two data analysis group projects for the course, where you will complete a set of data analysis tasks related to the Expenditure Cycle. To do so, you are allowed to use any software package you wish (e.g., Excel, Access, Tableau, PowerBI, IDEA...) or any combination of software (e.g., Access & Excel).

Tasks

The subject of your data analysis still the hypothetical company named Lehigh Wholesale Supply but now you will focus on the Expenditure process. The background of the company is provided in the form of a company description (Analytics_CaseDescription_Expenditure.doc). Their accounting information system is provided in a set of record layout diagrams that depict tables and data elements in each table (Analytics_Flowcharts_File Structures_Expenditure_Updated.pptx).

The transaction level data is available in a set of tables. I have provided them as either an Excel workbook (Lehigh_Expenditure.xlsx) or an Access database (Lehigh_Expenditure.accdb).

Deliverable

Based on your data analysis and interpretation of the results, you will create a deliverable to turn in. This deliverable will essentially be a report of the tasks you performed, how you performed them (this will be essential to include), and your discussion of the results. The deliverable will need to contain tables to help aid in describing your findings. See the requirements below for more detail.

Requirements

Read the Case Description and Flowcharts and File Structures files and use the data provided to complete the following steps:

Specify relevant audit objectives for each management assertion presented in the summary matrix below (remember AP and Inventory are the key accounts). For each audit objective, briefly describe the test procedure and include a short summary of the results. See the Analytics_ReportOutline_Expenditure.docx download for how to arrange your report AND for the list of acceptable assertions.

Below the summary table, include a fuller description of the tests performed and more detail about your results (e.g., a printout of exceptions). Note – I do not want the original source tables included in the report.

Finally, as a result of your tests, describe what amount of Inventory and AP you would propose that your client report for the fiscal year (i.e., what adjustment to their Inventory and AP related accounts would you propose they make).

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions