Customers Sales Information

Evidence:

Quiz: #CF104-1L

Time: 25 min

Marks: 15 

Sales Chart

Create the above excel document and fill up the following blank 

fields based on following criteria:

For Discount 1: a) If total items cost is greater than or equal to 5000 and less than 10000 then discount

                                 will be 5%.

                            b) If total items cost is greater than or equal to 10000 and less than 20000 then discount

                                 will be 8%.

                            c) If total items cost is greater than or equal to 20000 then discount will be 10%.

For Discount 2:  Customer will get the membership discount if he/she has membership card.

Special discount: After deducting discount 1 and discount 2 if the total cost is greater than or equal to

                               20000 then customer will get extra 2% discount.