Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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).

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

7th Edition

978-0-538-4527, 0-538-45274-9, 978-1133161646

More Books

Students also viewed these Accounting questions