You can use other data for this question below.

PART C. Discuss, justify and illustrate the following features that can be included, to help with strategic decision making. ( SUMIF COUNTIF Forecasting Index Match Function IF with And/OR Use suitable data for the purpose of illustration, on separate sheets. Feel free to use data from this question/ other sources. Total Cost of Sales Mark-up Total Sales Revenue Promotional Discounts Gross Pofit Payment Type Quantity Unit Cost 16 23 19 14 12 12 24 21 23 12 21 23 13 YUME INTERNATIONAL PVT LTD Costs & Revenue Information Sheet Order Date Shipped Date Shipper Name Product Name Category 1/10/19 5/10/19 Global Shipping Company Coffee Beverages 1/10/19 4/10/19 Taunus logistics Almands 1/10/19 6/10/19 Global Shipping Company Olive Oil 1/10/19 S/10/19 Global Shipping Company Dried Apples 1/10/19 4/10/19 Taurus Logistics Chocolate 1/10/19 4/10/19 Global Shipping Company Clam Chowder 1/10/19 6/10/19 Taurus Logistics Chocolate 1/10/19 3/10/19 Evergreen Shipping Company Beer 1/10/19 3/10/19 Global Shipping Company Clam Chowder 1/10/19 6/10/19 Global Shipping Company Collee 1/10/19 5/10/19 Global Shipping Company Dried Plums 1/10/19 4/10/19 Global Shipping Company Chai 1/10/19 6/10/19 Taung Lagistics Coffen 1/10/19 4/10/19 Taurus Logistics Boysenberry Spread 1/10/19 5/10/19 Taurus Lagistics Baysenberry Spread 1/10/19 6/10/19 Evergreen Shipping Company Chocolate Biscuits Mix 1/10/19 5/10/19 Evergreen Shipping Company Chocolate 1/10/19 5/10/19 Taurus Logistics Dried Pears 1/10/19 3/10/19 Taurus Logistics Chocolate 1/10/19 6/10/19 Global Shipping Company Curry Sauce 2/10/19 6/10/19 Global Shipping Company Olive Oil 2/10/19 6/10/19 Evergreen Shipping Company Mammalade 2/10/19 6/10/19 Evergreen Shipping Company Chocolate Biscuits Mix 2/10/19 4/10/19 Evergreen Shipping Company Chocolate Biscuits Mix 2/10/19 5/10/19 Global Shipping Company Crab Meat 2/10/19 7/10/19 Evergreen Shipping Company Chocolate 2/10/19 7/10/19 Taurus Logistics Long Grain Rice 2/10/19 7/10/19 Global Shipping Company Dried Plums 2/10/19 6/10/19 Global Shipping Company Olive Oil 2/10/19 5/10/19 Global Shipping Company Mozzarella 2/10/19 5/10/19 Global Shipping Company Syrup 2/10/19 7/10/19 Global Shipping Company Curry Sauce 2/10/19 1/10/19 Taurus Logistics Green Tea 20 20 24 20 22 19 12 20 20 15 24 17 17 19 19 13 23 19 24 14 Product Name Mark-up Promotional Discount 20% 2% 15% 2% 20% 2% 3% 4% 5% 3% 10% 4% 4% Pasta 0% 0% 0% 0% Product Details Category Cost / crate Baked Goods & Mixes $ 53.0 Beverages $ 65.0 Dried Fruit & Nuts $ 65.0 Grains $ 66.0 Sauces $ 67.0 Condiments $ 68.0 Fruit & Veg $ 53.0 $ 51.0 Candy $ 51.0 Canned Meat $ 58.0 Baked Goods & Mixes $ 58.0 Soups $ 23.0 Beverages $ 65.0 Dried Fruit & Nuts $ 53.0 Oil $ $ 55.0 Jams, Preserves $ 67.0 Beverages $ 55.0 Jams, Preserves $ 59.0 Dairy Products $ 51.0 Beverages $ 54.0 Condiments $ 56.0 Dried Fruit & Nuts $ 59.0 Pasta $ 51.0 Dried Fruit & Nuts $ 45.0 Chocolate Biscuits Mix Coffee Dried Plums Long Grain Rice Curry Sauce Syrup Fruit Cocktail Gnocchi Chocolate Crab Meat Scones Clam Chowder Beer Almonds Olive Oil Marmalade Green Tea Boysenberry Spread Mozzarella Chai Cajun Seasoning Dried Pears Ravioli Dried Apples 5% 6% 5% 7% 10% 4% 11% 10% 13% 0% 3% 3% 3% 2% 14% 16% 17% 18% 3% 4% 4% 5% 15% 13% 14% 5% 4% 11% 9% 3% 3% Payment Details Customer ID Payment Type 20055 Credit Card 20022 Cheque 20084 Credit Card 20145 Cheque 20007 Credit Card 20160 Credit Card 20103 Cheque 20120 Cheque 20096 Credit Card 20166 Credit Card 20179 Credit Card 20145 Cheque 20023 Credit Card 20048 Cheque 20073 Cheque 20200 Cheque 20023 Credit Card 20068 Cheque