Question two: (4 marks) using Excel

Al Quds Company produces three types of canned meats. The products are distributed through vendors across Jordan to consumers. The company wants to know those vendors' net income in 2019 after tax and delivery costs are cut out. Using the following table, find the following:

Vendors	Sales	delivery Cost
A	20000	2000
B	15000	3000
C	9000	1000
D	32000	2500
E	17500	2500
F	7000	1200
G	45000	12000

`

1. Total sales after cutting delivery costs
2. Using the IF function to calculate the tax based on total sales after cutting delivery costs.
   1. 5% of total sales if they are equal or less than 15000
   2. 7% of total sales if they are more than 15000
3. Calculate total net sales after removing delivery costs and tax.
4. Average of Sales
5. The deviation of each vendor in total net sales
6. Max net sales
7. Min net sales
8. Draw chart (clustered column) showcasing the relation between vendors and total net sales.