Question: Complete missing information in costs and revenue information sheet ( highlighted in yellow colour)

Show on your workings on the excel

Take the screenshots

S T w X Y Z AA AB AC AD AE Unit Cost Total Cost of Sales Mark-up * Total Sales Revenue Promotional Discounts Gross Pofit Payment Type Quantity 16 23 19 14 12 13 24 21 23 12 21 23 13 20 20 24 20 22 19 12 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 Taurus Logistics Almonds 1/10/19 6/10/19 Global Shipping Company Olive Oil 1/10/19 5/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 Coffee 1/10/19 5/10/19 Global Shipping Company Dried Plums 1/10/19 4/10/19 Glabal Shipping Company Chal 1/10/19 6/10/19 Taurus Logistics Coffee 1/10/19 4/10/19 Taurus Logistics Boysenberry Spread 1/10/19 5/10/19 Taurus Logistics Boysenberry Spread 1/10/19 6/10/19 Evergreen Shipping Company Chocolate Biscuits Mix 1/10/19 S/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 Glabal Shipping Company Curry Sauce 2/10/19 6/10/19 Global Shipping Company Olive Oil 2/10/19 6/10/19 Evergreen Shipping Company Marmalade 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 7/10/19 7/10/19 Evergreen Shipping Company Chocolate 2/10/19 7/10/19 Taurus Logistics 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 4/10/19 Taurus Logistics Green Tea 2/10/19 7/10/19 Evergreen Shipping Company Chocolate Biscuits Mix 2/10/19 6/10/19 Global Shipping Company Dried Plums 2/10/19 6/10/19 Glabal Shipping Company Dried Plums 2/10/19 5/10/19 Evergreen Shipping Company Chocolate 2/10/19 4/10/19 Evergreen Shipping Company Beer 2/10/19 5/10/19 Evergreen Shipping Company Crab Meat 3/10/19 6/10/19 Taurus Logistics Coffee 3/10/19 8/10/19 Global Shipping Company Green Tea 3/10/19 8/10/19 Evergreen Shipping Company Caffe 3/10/19 8/10/19 Global Shipping Company Crab Meat 3/10/19 8/10/19 Global Shipping Company Mozzarella 3/10/19 S/10/19 Global Shipping Company Clam Chowder 3/10/19 7/10/19 Taurus Logistics Lone Grain Rice 20 20 15 24 17 17 Long Grain Rice 19 19 13 23 19 24 14 22 17 12 16 23 21 23 22 16 16 16 13 23 Order Date Shipped Date Shipper Name Product Name Category Quantity Unit Cost Total Cast of Sales Mark-up % Total Sales Revenue Promotional Discounts Gross Pofit Payment Type 19 13 12 23 16 14 17 13 15 15 16 22 13 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 29/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 30/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 31/10/19 1/11/19 Global Shipping Company 31/10/19 Evergreen SNpping Company 31/10/19 Taurus Logistics 1/11/19 Taurus Logistics 1/11/19 Global Shipping Company 31/10/19 Taurus Logistics 3/11/19 Global Shipping Company 1/11/19 Evergreen Shipping Company 2/11/19 Global Shipping Company 3/11/19 Global Shipping Company 2/11/19 Global Shipping Company 31/10/19 Evergreen Shipping Company 1/11/19 Global Shipping Company 3/11/19 Evergreen Shipping Company 3/11/19 Global Shipping Company 4/11/19 Evergreen Shipping Company 2/11/19 Taurus Logistics 3/11/19 Taurus Logistics 2/11/19 Global Shipping Company 2/11/19 Global Shipping Company 3/11/19 Evergreen Shipping Company 4/11/19 Evergreen Shipping Company 3/11/19 Taurus Logistics 1/11/19 Global Shipping Company 1/11/19 Taurus Logistics 4/11/19 Evergreen Shipping Company 2/11/19 Evergreen Shipping Company 2/11/19 Global Shipping Company 2/11/19 Global Shipping Company 4/11/19 Evergreen Shipping Company 3/11/19 Global Shipping Company 2/11/19 Global Shipping Company 4/11/19 Evergreen Shipping Company 5/11/19 Taurus Logistics 5/11/19 Global Shipping Company 3/11/19 Global Shipping Company 5/11/19 Taurus Logistics 4/11/19 Evergreen Shipping Company 7/11/19 Evergreen Shipping Company 3/11/19 Taurus Logistics 2/11/19 Global Shipping Company S/11/19 Global Shipping Company 5/11/19 Global Shipping Company 2/11/19 Global Shipping Company 5/11/19 Global Shipping Company Olive Oil Crab Meat Boysenberry Spread Coffee Green Tea Long Grain Rice Curry Sauce Chocolate Curry Sauce Gnocchi Dried Plums Green Tea Curry Sauce Chocolate Crab Meat Chocolate Boysenberry Spread Cam Chowder Chocolate Biscuits Mix Olive Oil Green Tea Chocolate Chocolate Gnocchi Boysenberry Spread Chocolate Biscuits Mix Chocolate Chocolate Biscuits Mix Chocolate Biscuits Mix Chocolate Biscuits Mix Cajun Seasoning Syrup Beer Chocolate Cajun Seasoning Chocolate Biscuits Mix Almonds Dried Plums Chocolate Biscuits Mix Dried Plumns Boysenberry Spread Crab Meat Green Tea Curry Sauce Cajun Seasoning 23 14 22 12 12 12 12 20 12 18 17 13 24 12 20 12 23 14 22 17 19 19 24 20 14 17 14 21 13 20 12 Total Total 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