Question 2.

There are reports of errors in pricing. The following is the correct price list. If the correct price is lower than old price, that means we have over-charged the customers.

(Note. The same products may have different price points at different time. The following only applies to the particular price point mentioned.)

Product Number

Old price (on spreadsheet)

Correct price

00200290

8.24

6.99

N4709 90

11.99

12.69

02132490

16.25

11.54

N5415 00

13.10

11.34

Update the spreadsheet with the correct price. Compare the new total amount due with the old one. Decide the amount that we should pay to the customers (or they should pay us).

Present your finding in a new tab or file. Format it and make it presentable.

Note: All numbers should have a comma (,) every 3 digits, and to 2 decimal points.

All percentages should use a percentage sign (%) and to 2 decimal points.