please help and show me step by step how to do it

Answer sheet is provided, students should answer ALL questions in the answer sheet. Question 1 [30 marks] Smart Supplies is a stationery supplier that offers various stationeries for office, school, and government. To celebrate this year's store anniversary, Smart Supplier wants to implement a special discount for customers. The discount policy is as follows: If the customers spend between $100-$299, they will get 5% discount If the customers spend between $300-$499, They will get 10% discount If the customers spend between $500-$799, They will get 20% discount If the customers spend $800 or more, they will get 25% discount . . . . For the sales representative (Rep), Smart Supplies also provide special incentive during the celebration day based on the total sales before discount, with below condition: If the sales representatives earn between $100-$500, they will get 10% incentive of sales before discount If the sales representatives earn between $501-$1000, they will get 15% incentive of sales before discount If the sales representatives earn more than $1000, they will get 20% incentive of sales before discount . . Compute: a. The total b. Discount in percentage using Lookup Function C. Discount in dollars d. Total after discount e. Incentive in percentage using IF or IFS Function f. Incentive in dollars [3 marks] [9 marks] [3 marks] [3 marks] [9 marks] [3 marks] Answer sheet is provided, students should answer ALL questions in the answer sheet. Question 1 [30 marks] Smart Supplies is a stationery supplier that offers various stationeries for office, school, and government. To celebrate this year's store anniversary, Smart Supplier wants to implement a special discount for customers. The discount policy is as follows: If the customers spend between $100-$299, they will get 5% discount If the customers spend between $300-$499, They will get 10% discount If the customers spend between $500-$799, They will get 20% discount If the customers spend $800 or more, they will get 25% discount . . . . For the sales representative (Rep), Smart Supplies also provide special incentive during the celebration day based on the total sales before discount, with below condition: If the sales representatives earn between $100-$500, they will get 10% incentive of sales before discount If the sales representatives earn between $501-$1000, they will get 15% incentive of sales before discount If the sales representatives earn more than $1000, they will get 20% incentive of sales before discount . . Compute: a. The total b. Discount in percentage using Lookup Function C. Discount in dollars d. Total after discount e. Incentive in percentage using IF or IFS Function f. Incentive in dollars [3 marks] [9 marks] [3 marks] [3 marks] [9 marks] [3 marks]