Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

About the data Invoices and Sales describe 2 datasets that should be cleaned and reconciled: total sales should equal total invoices, and the objective is

About the data Invoices and Sales describe 2 datasets that should be cleaned and reconciled: total sales should equal total invoices, and the objective is to identify and understand the differences Question 1: SALES AMOUNT and NET AMOUNT in Sales are both missing decimal points (i.e. row 2: 6850 should be 68.50 and 6000 should be 60.00). Update the raw data to correct for this decimal error TYPE in Sales indicates the sign of the transaction (positive or negative). 1 indicates a positive transaction and 2 indicates a negative transaction. Update the raw data to reflect the appropriate Answer 1a: After you have accounted for the missing decimal and sign, what is the total of the sales amount column? Answer and explain how you approached the problem in the Explanation + Summary tab. Answer 1b: After you have accounted for the missing decimal and sign, what is the total of the net amount column? Answer and explain how you approached the problem in the Explanation + Summary tab

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

Managerial Accounting Working Papers

Authors: John G. Helmkamp

2nd Edition

0471514292, 978-0471514299

More Books

Students also viewed these Accounting questions