a. To calculate the discount, create a formula that uses the following logic: i. If the quantity ordered for an item is less than 5, no discount is applied to that item's total. ii. If the quantity ordered for an item is 5 or more, but less than 10, a 5% discount is applied to that item's total. iii. If the quantity ordered for an item is 10 or more, a 7.5% discount is applied to that item's total.