You have obtained a client’s data file and you plan to use it to analyze the movement of the inventory and the provision for sales discounts to customers. To begin, you will need to access the Excel file Invoice data_ cleansing located in WileyPLUS. Open the file, perform the following steps, and answer the related questions.

Required

a. Cleanse the data in the file by identifying and updating blank fields and ensuring that all values are in a consistent format for each field.

b. Add a calculated field to the worksheet labelled “Price per Unit.” The field should calculate the price per unit for each invoice. Change the field to a currency format.

c. Create a line graph that will allow you to readily identify any notable items related to the price per unit. The x-axis should be invoice date.

d. Document the work you have performed in a working paper. Explain why a line graph was the visualization selected.

e. Evaluate the results and document your initial conclusions. You will likely want to refer back to the source data to understand the notable items.

f. What areas of the financial statements are likely to be impacted by these notable item(s)?
g. The auditor realizes the same data file can be used to understand the customer relationships and outliers in terms of pricing. Using the same data:
i. Sort by the Customer Number field.
ii. Using the subtotal function, calculate the average for each change in the customer number.
iii. Create a radar style chart, which presents the data in a circular visualization, to identify customers with outlying average purchase prices (both below and above average).
iv. What impact might the above information have on your audit procedures?