Excel

1. Create a table for the first 6 months of 2020 for the Gentry Corporation for 5 items.
2. Insert purchase cost data for each item each month. Insert values from $10,000- $40,000 per item per month.
3. Create a lookup table for purchase discounts. For $10,000-20,000 they get 2% off the full amount purchased price, $20,000- $40.000 they get 3% off for the full amount purchased, and if they buy more than $40,000, they get 4% off the total purchase price.
4. Find the total $ value of purchases each month.
5. Find the total $ value of purchases by item for the 6 month period
6. Find the total $ value of discount by item for the 6 month period
7. Find the $ net cost by item for the 6 month period.
8. Create a pie chart that illustrates the share of net purchase dollars the company spent for each item. Make sure the chart is properly titled.

I would like to know what the excel formula is to calculate the discounts from number 3 for the 6month period