Question: Task 2 Download Excel2.xls Calculate how many transactions have incorrect Amount. Note: Amount is price*qty, and applying the discount. If Discount Percentage is 0, that

Task 2

Download Excel2.xls

Calculate how many transactions have incorrect Amount.

Note: Amount is price*qty, and applying the discount. If Discount Percentage is 0, that means no discount is applied. If Discount Percent is, say, 0.2, that means 20% discount is applied, and the amount should be price*qty*0.8.

Note: Notice that the Amount is a result of rounding to the 2nd decimal digits.

Add a column and label it "ErrorCount". Assign it a value of 1 if the Amount is incorrect; assign it a value of 0 if otherwise.

At the bottom of the sheet, total the ErrorCount.

You are free to add new columns for interim calculations.

Task 2 Download Excel2.xls Calculate how many

1 J K L N O P Q R S T U Comp Product 1 Number Flag 2 01832190 S 3 01832190 S 4 01832190 S 5 01832190 S 6 01832190 S 7 01832190 S 8 01832190 S 9 01832190 S 10 01832190 S 11 01832190 S 12 01832190 S 13 01832190 S 14 01832190 S 15 01832190 S 16 01832190 S 17 01832190 S 18 01832190 S 19 01832190 S 20 01832190 S 21 01832190 S 22 01832190 S 23 01832190 S 24 01832190 S 25 01832190 S 26 01832190 S 27 01832190 S 28 01832190 S 29 01832190 S 30 01832190 S 31 01832190 S 32 01832190 S 33 01832190 S 34 01832190 S 35 01832190 S 36 01832190 S 37 01832190 S 38 01832190 S 39 01832190 S 40 01832190 S 41 01832190 S 42 01832190 S 43 01832190 S Sales Unit Program Discoun Price Code t Percent Qty $16.11 6253 0 $16.11 0253 0 $16.11 0253 0 $16.11 0253 0 $16.11 0253 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0.3002 $16.11 6059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0.3002 $16.11 0059 0.3002 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 6059 0.3002 $16.11 0059 0 $16.11 6059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 0059 0 $16.11 6059 0 $16.11 0059 0.2247 ErrorCou Amount nt 1 $16.11 1 $16.11 2 $32.22 2 $32.22 1 $16.11 1 $16.11 1 $16.11 2 $32.22 2 $32.22 2 $32.22 1 $16.11 1 $16.11 1 $16.11 1 $16.11 1 $16.11 1 $16.11 3 $48.33 1 $16.11 2 $32.22 4 $64.44 1 $16.11 2 $32.22 1 $16.11 1 $16.11 1 $16.11 2 $32.22 1 $16.11 2 $32.22 3 $48.33 1 $16.11 1 $16.11 1 $16.11 1 $16.11 1 $16.11 4 $64.44 4 $64.44 3 $48.33 3 $48.33 3 $48.33 3 $48.33 3 $48.33 3 $37.47 Sales Details + Ready + 160%

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 General Management Questions!

It is January 2 and Twin Pines Farm is putting together its annual net worth statement Following are a nurmher of pieces of information they have collected. Help them fit it all together using the...

This is a individual assignment, which is due on 27th of jan, wed, 1pm. Can u help me to do it? Financial Accounting 2 ACG 27, Study Period 4, 2015 Case Study for Annual Report Assignment The...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Processing steps for 18 questions are required. Thanks so much for help! Queensland University of Technology QUT Business School School of Accountancy AYB 219 Taxation Law HandiTax Group Project...

this assignment is regarding return the tax of a client by using handy taxassignment. can anyone help me to complete the income section of this assignment, just write the solution in a pdf file?I...

can any expert help me with the below assignment just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question...

Fact Find Initial Interview: Time Date Location Referred by: A. Personal Details Applicant 1 Applicant 2 Full Name of Applicant Full Name of Applicant Mr Mrs Miss OMS Dr Mr Mrs Miss OMs Dr Full Name...

Here is a copy of Schedule D and Form 8949 for completing the required assignment,Instructions for all IRS forms are a great resource and can be found at www . irs .gov. Here are links to...

The business was purchased on May 31, 2022. Medical supplies $481 Medical Equipment $16,791 Bank Loan (due June 2023) $27,997 Accounts Payable $8,755 Motor Vehicle $38,618 Accounts Receivable $23,799...

The Gotham City News is moving to a paywall subscription service rather than a free news website with unlimited access. If subscribers would like to access more than 10 articles per month, they will...

Backford company just paid a dividend yesterday of $2.25 per share. The company's common stock is currently selling for $70 per shhre, and the required rate of return on the backford company stock is...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....