A seller offers a 10% discount if customers buy at least 100 units and 20% discount if customers buy at least 200 units.

The normal retail price of this unit is 50 JOD.

Required:

Compute net sales of the information given in MS Excel

File Home Insert Formulas Data Review View Help Viewing bv v Times New Ro... v 12 B av 3 Merge v C9 fx ??? A B D F H 1 J K L 1 F G A seller offers a 10% discount if customers buy at least 100 units and 20% discount if customers buy at least 200 units . The normal retail price of this unit is 50 JOD. 2 3 4 Required: Comput net sales of the information given in MS Excel 5 6 7 8 9 10 11 12 Customer Name Kalleed Kamal Emad Razan Hasan Mahmoud Maha Sara Gross Sales 2,000 5,000 500 6,500 13,000 1,000 18,000 10,000 Discount ??? ??? ??? ??? ??? ??? ??? ??? Net Sales ??? ??? ??? ??? ??? ??? ??? ??? 13 14 15 16 17 18 19 20