Question: what steps would be need to complete the following task - dont have to solve just instructions is fine 1. Identify errors and other issues

what steps would be need to complete the following task - dont have to solve just instructions is fine

1. Identify errors and other issues in the sales and purchase transaction

state what Excel formulas (e.g. vlookup) determine which information is incorrect in the purchase and sales transactions.

Use Excel formulas to correct the transactions

Identify other potential issues regarding the transactions affecting consistency, data quality etc.

what steps would be need to complete the

A B C D E F G H K M 1 Sales Invoice Numbe Sales Date Customer Number Customer Name Address line 1 Address line 2 Email Inventory Number Inventory Description Quantity Unit Price Total Sales Authorising Employe ID 51653 22/01/2022 ADN Adventure Now 1666 Wynnum Road Tingalpa adventurenow@com.au K-BIKE Kids Bike 2 $500.00 $ 746.00 20 51654 2022/1/1 CLB Cycle Lab 20 Preston Road clab@com.au MM-BIKE Men's Mountain Bike 5 $1,326.00 $ 6,630.00 20 UI A W N 51655 2/02/2022 BHB Bike Hub 12 Station Street Nundah bikehub@com.au WM-BIKE Women's Mountain Bike 10 $1,326.00 $13,260.00 20 51656 6/02/2022 CLB Cycle Lab 20 Preston Road Manly West clab@com.au WM-BIKE Women's Mountain Bike 6 $1,326.00 20 51656 6/02/2022 CLB Cycle Lab 20 Preston Road Manly West clab@com.au WM-BIKE Women's Mountain Bike 6 $1,326.00 20 51657 28/02/2022 PKC Peak Cycles 26 Rode Road Wavell Heights pcycles@com.au B-PARTS Bike Parts $60.00 $ 60.00 20 51658 1/03/2022 BHM Bike Home 290 Tingal Road Wynnum B-PARTS Bike Parts $60.00 $ 300.00 20 51659 1/03/2022 PKC Peak Cycles 26 Rode Road Wavell Heights pcycles@com.au WM-BIKE Women's Mountain Bike $ 2,652.00 20 51660 12/03/2022 ADN Peak Cycles 1666 Wynnum Road Tingalpa adventurenow@com.au MM-BIKE Men's Mountain Bike 4 $1,326.00 $ 5,304.00 20 11 31/03/2022 BHM Bike Home 290 Tingal Road Wynnum bikehome@com.au B-PARTS Bike Parts 15 $60.00 $ 900.00 30 12 51662 4/04/2022 CLB Cycle Lab 20 Preston Road Manly West clab@com.au K-HELMET Kids Helmet 7 $50.00 $ 350.00 20 13 51662 10/04/2022 PKC Bike Home 26 Rode Road Wavell Heights K-BIKE Kids Helmet 8 $50.00 $ 400.00 20 14 51663 12/04/2022 CLB Cycle Lab 20 Preston Road Manly West clab@com.au WR-BIKE Women's Road Bike 1 $825.00 $ 825.00 20 15 51664 16/04/2022 ADN Adventure Now 1666 Wynnum Road Tingalpa adventurenow@com.au MM-BIKE Men's Mountain Bike $1,326.00 $ 2,652.00 10 16 51665 5/05/2022 BHM Bike Home 1666 Wynnum Road Tingalpa adventurenow@com.au W-HELMET Women's Helmet 4 $60.00 $ 240.00 20 17 51667 30 May PKC Adventure Now 26 Rode Road Wavell Heights pcycles@com.au M-HELMET Men's Helmet 2 $80.00 $ 160.00 20 18 51668 13/06/2022 PKC Peak Cycles 26 Rode Road Wavell Heights pcycles@com.au MR-BIKE Men's Road Bike 1 $825.00 $ 825.00 20 19 51669 13/06/2022 ADN Adventure Now 1666 Wynnum Road Tingalpa adventurenow@com.au B-PARTS Bike Parts 5 $60.00 $ 300.00 20 20 20/06/2022 ADN Adventure Now 1666 Wynnum Road Tingalpa adventurenow@com.au WM-BIKE Men's Road Bike 2 $60.00 $ 120.00 40 21 51671 21/06/2022 BHM Bike Home Wynnum bikehome@com.au MR-BIKE Men's Road Bike A $825.00 20 22 51672 30/06/2022 CLB Cycle Lab 20 Preston Road Manly West clab@com.au WR-BIKE Women's Road Bike 1 $825.00 $ 825.00 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

STUDENT ASSESSMENT BOOKLET CHC50121 DIPLOMA OF EARLY CHILDHOOD EDUCATION AND CARE 890PEF502 DEVELOP AND USE EMOTIONAL INTELLIGENCE EndAA Ana .63 AA Ans 1.27 3) AA Ans al b) Replace Add-ins Select -...

I have this project that is due within 24 hours. I'm sick pneumonia and haven't been able to get a grasp of it at all. It's 2 parts the first part is due tomorrow by 11:59 and the part II is due...

For this deliverable, you will complete the accounting cycle and prepare financial statements that will provide the result you need to assess the success of business operations. Below you will find...

10:23* api47w.ilovepdf.com Scenario 1: Cultural misunderstanding A customer from a foreign country is visibly upset because they believe that a staff member has insulted their cultural customs. The...

See Project 03-01 Assignment Spring 2015.docx Please Help me on this homework i am having some trouble answering it. Product SAP ERP GBI Release 6.04 Level Undergraduate Graduate Focus...

hello, I can't do the 6th. Can you help me? It says which table to use under the questions. The page number of this question is 14. The following Scenario is used for Question 7, 8 and 9: l'l...

Question 1: You have been approached by the procurement manager who proposed that you may save operating costs by using one product key of MS Window and Microsoft Office package to multiple computers...

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

Jill and Jack are both 25 years old graduated in May 2018 with a BBA in General Business. They were hired by a nonprofit organization and have decided to start saving to make the 20% down payment on...

Swifty corporation completed the following merchandising transaction in the month of May. At the beginning of May, the ledger of Swifty Corporation showed Cash of $5,000 and common Stock of $ 5,000....

In a jurisdiction following the "actually foreseen" approach to third - party negligence claims against an auditor, Cozy Cafe engaged Auditor to audit Cozy Cafe's financial statements, telling...

1.32 Shown below are the ledger balances of Liwayway Trading on December 31, 2007. Cash P 62.825 Notes Receivable 74.250 Accounts Receivable 171.100 Merchandise Inventory - Jan. 1 60.900 Furniture...