please show me the answers step by step in excel

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] B D E F Ratings 35 74 82 23 98 77 44 47 13 62 71 26 80 71 17 32 9 18 74 85 82 40 27 1 Program 2 20/20 3 30 Rock 4 48 Hours Mystery (Sat 10:00 pm) 5 48 Hours Mystery (Sat 9:00 pm) 6 48 Hours Mystery (Tues 10:00 pm) 7 60 Minutes 8 According to Jim (Tues 8:00 pm) 9 According to Jim (Tues 8:30 pm) 10 American Dad (Sun 7:30 pm) 11 American Dad (Sun 9:30 pm) 12 American Idol (Tues 8:00 pm) 13 American Idol (Wed 9:00 pm) 14 America's Funniest Home Videos ?? 15 America's Most Wanted 16 Are You Smarter than a 5th Grader? 17 Bachelor 18 Back to You 19 The Big Bang Theory 20 Big Brother (Sun 8:00 pm) 21 Big Brother (Tues 9:00 pm) 22 Big Brother (Wed 8:00 pm) 23 Biggest Loser 24 Bones 25 Boston Legal 26 Brothers & Sisters 27 Canterbury's Law 28 Cops (Sat 8:00 pm) 29 Cops (Sat 8:30 pm) 30 Crimetime 31 Criminal Minds 32 CSI 33 CSI: Miami 34 CSI: NY 35 Dancing with the Stars 36 Dancing With the Stars (Tues 9:00 pm) 37 Dateline (Fri 9:00 pm) 38 Dateline (Sun 7:00 pm) 39 Deal or No Deal (Mon 8:00 pm) 10 Deal or No Deal (Wed 8:00 pm) 11 Democratic Presidential Debate 42 Desperate Housewives (Fri 8:00 pm) 13 Desperate Housewives (Sun 9:00 pm) 74 Don't Forget the Lyrics! 75 Duel 46 Eli Stone 47 ER 48 Family Guy Network ABC NBC CBS CBS CBS CBS ABC ABC FOX FOX FOX FOX ABC FOX FOX ABC FOX CBS CBS CBS CBS NBC FOX ABC ABC FOX FOX FOX CBS CBS CBS CBS CBS ABC ABC NBC NBC NBC NBC ABC ABC ABC FOX ABC ABC NBC FOX 86 89 12 66 14 24 35 73 84 59 85 93 24 37 31 69 84 60 67 17 82 98 78 60 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] B D E F Ratings 35 74 82 23 98 77 44 47 13 62 71 26 80 71 17 32 9 18 74 85 82 40 27 1 Program 2 20/20 3 30 Rock 4 48 Hours Mystery (Sat 10:00 pm) 5 48 Hours Mystery (Sat 9:00 pm) 6 48 Hours Mystery (Tues 10:00 pm) 7 60 Minutes 8 According to Jim (Tues 8:00 pm) 9 According to Jim (Tues 8:30 pm) 10 American Dad (Sun 7:30 pm) 11 American Dad (Sun 9:30 pm) 12 American Idol (Tues 8:00 pm) 13 American Idol (Wed 9:00 pm) 14 America's Funniest Home Videos ?? 15 America's Most Wanted 16 Are You Smarter than a 5th Grader? 17 Bachelor 18 Back to You 19 The Big Bang Theory 20 Big Brother (Sun 8:00 pm) 21 Big Brother (Tues 9:00 pm) 22 Big Brother (Wed 8:00 pm) 23 Biggest Loser 24 Bones 25 Boston Legal 26 Brothers & Sisters 27 Canterbury's Law 28 Cops (Sat 8:00 pm) 29 Cops (Sat 8:30 pm) 30 Crimetime 31 Criminal Minds 32 CSI 33 CSI: Miami 34 CSI: NY 35 Dancing with the Stars 36 Dancing With the Stars (Tues 9:00 pm) 37 Dateline (Fri 9:00 pm) 38 Dateline (Sun 7:00 pm) 39 Deal or No Deal (Mon 8:00 pm) 10 Deal or No Deal (Wed 8:00 pm) 11 Democratic Presidential Debate 42 Desperate Housewives (Fri 8:00 pm) 13 Desperate Housewives (Sun 9:00 pm) 74 Don't Forget the Lyrics! 75 Duel 46 Eli Stone 47 ER 48 Family Guy Network ABC NBC CBS CBS CBS CBS ABC ABC FOX FOX FOX FOX ABC FOX FOX ABC FOX CBS CBS CBS CBS NBC FOX ABC ABC FOX FOX FOX CBS CBS CBS CBS CBS ABC ABC NBC NBC NBC NBC ABC ABC ABC FOX ABC ABC NBC FOX 86 89 12 66 14 24 35 73 84 59 85 93 24 37 31 69 84 60 67 17 82 98 78 60