1:30 Files .: 4G Question two marks) usingel Al Quds Company produces three types of canned meats. The products are distributed to across Jordan to consumers. The company wants to know those vendors net income in 2009 tetaan delivery costs are out out. Using the following table, find the following Ver Y 20000 2000 15000 9000 2000 A B C D 2000 1000 F G 1 Total sales after cutting delivery costs 2. Using their function to calculate the tax based on total sales tercing der 5% of total sales if they are equal or less than 15000 7% of total sales if they are more than 15000 3. Calculate total net sales after removing delivery costs and to Average of Sales 5 The deviation of each vendor in total net sales 6. Max net sales 2. Minnetales & Draw chart fchultered column) showcasing the relation between wendors and total et les Destionem of the linear equation Ysabe shows the relationship between demand and price 1. Using Excel to create them and Minesotho 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 B Sales 20000 15000 9000 32000 17500 7000 45000 delivery Cost 2000 3000 1000 2500 2500 1200 12000 = D E F G 1. Total sales after cutting delivery costs 2. Using the IF function to calculate the tax based on total sales after cutting delivery costs. a. 5% of total sales if they are equal or less than 15000 b.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. 1:30 Files .: 4G Question two marks) usingel Al Quds Company produces three types of canned meats. The products are distributed to across Jordan to consumers. The company wants to know those vendors net income in 2009 tetaan delivery costs are out out. Using the following table, find the following Ver Y 20000 2000 15000 9000 2000 A B C D 2000 1000 F G 1 Total sales after cutting delivery costs 2. Using their function to calculate the tax based on total sales tercing der 5% of total sales if they are equal or less than 15000 7% of total sales if they are more than 15000 3. Calculate total net sales after removing delivery costs and to Average of Sales 5 The deviation of each vendor in total net sales 6. Max net sales 2. Minnetales & Draw chart fchultered column) showcasing the relation between wendors and total et les Destionem of the linear equation Ysabe shows the relationship between demand and price 1. Using Excel to create them and Minesotho 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 B Sales 20000 15000 9000 32000 17500 7000 45000 delivery Cost 2000 3000 1000 2500 2500 1200 12000 = D E F G 1. Total sales after cutting delivery costs 2. Using the IF function to calculate the tax based on total sales after cutting delivery costs. a. 5% of total sales if they are equal or less than 15000 b.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