Fruit shop, Apple is $9/KG, Orange is $6.5/KG

Validate whether we are invoicing ABC for all the products they issued. Assume the goods ordered is the source of truth.

The title of Source which is used to define the dimension of the appended data (such as sales in GL and Goods ordered).

Question 1

a. Create a pivot table report where we can view the quantity in kg of sales in GL and Goods ordered by Sales Order number (That is, Source as Column; Sales Order number as Row and Quantity in kg as Values). There should be no grand totals displayed for rows.

b. In the first column to the right of the pivot table, calculate the difference between the sales in GL and Goods ordered.

c. Summarise your findings. This should include:

i. The sales order number for where you have identified a discrepancy

ii. The kilogram in kg variance

iii. Actions that should be taken to correct.

Q2

a. Consider the process that you have been through and identify and explain the weaknesses of manually checking all the inconsistencies (e.g. checking the inconsistencies between goods ordered and goods invoiced). No more than 50 words.

b. Consider the process that you have been through and identify and explain what improvements we can make in this process instead of manually checking all the inconsistencies (e.g. what controls could be present in the process that would mean that some of data analysis work would not be necessary). No more than 50 words.

X AutoSave Ooff Search (Alt+Q) X AutoSave Ooff X AutoSave Ooff Search (Alt+Q) X AutoSave Ooff