Answered step by step
Verified Expert Solution
Question
1 Approved Answer
N5 fx G H - K F 1 Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience stores in
N5 fx G H - K F 1 Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience stores in Australia. 2 You are provided with the information related to its customer details, product details, and costs and revenue information sheet. 3 Yume International has partnered with three shipping companies who ships the products to its Australian customers on time. 4 You are a junior accountant and your Senior Accounts Manager wants you to summarise this data in a meaningful way. 5 Required: 6 PART-A: Complete missing information in costs and revenue information sheet (highlighted in yellow colour) (5 marks) PART B: Pivot Table and Recommended Charts (5 marks) 1. Calculate gross profit for each customer along with product name and payment type using Pivot Table; categorising the columns by salesperson ii. Calculate sales revenue by cach salesperson using Pivot Table and illustrate it via Clustered Bar Chart 10 iii. Calculate sales revenue and gross profit earned by each product using Pivot Table and illustrate it via 100% stacked line graph 11 12 For Pivot Tables and charts, please use a new worksheet and lobel it as (Pivot and Charts). You must use relevant Excel functions for the tasks assigned. Do not calculate it manually. 9 13 14 Customer and Product Details 15 16 17 Customer ID 20055 18 Mark-up 20% 15% 20% 4% 5% 10% 5% Promotional Discount 2% 2% 2%. 3% 3% $ 4% 0% Customer Name Pies and Rolls Cafe Coffee Shop Chal Coffee The Black Kettle Harrison Pvt ltd Yumm Cafe Seedling Cafe Campbell Candy Mitlada Beer Co Ples and Rolls Cafe Pioneer Bakers The Good Cafe Sorento Cafe Grain Store Third Wave Cafe Third Wave Cafe Good Meat Mitalda Beer Co 20022 20084 20145 20007 20160 20103 20120 20096 20166 20179 20145 20023 20048 20073 20200 20023 20068 Customer Details Contact Name Customer Address Cooper Jesse 25 Glaria Circuit, Ballarat VIC 3090 Xavier Matteo 15 ludy Street, Albury NSW 2000 Parker Dear 25 Joseph Street, Wollongong NSW 2000 Roman Zayden 8 Pamela Cresent, Hervey Bay QLD 4019 Jason Prestan 12 Katherine Drive, Perth WA 6010 Santiago August 35 Kelly Street, Geelong VIC 3000 Chase Oscar 35 Samantha Street, Canberra ACT 2609 Sawyer Jeremy 17 Jesse Drive, Albury NSW 2000 Gavin Alejandro 30 Gabriel Street, Adelaide SA 5090 Leonardo Marcus 25 Gloria Circuit, Ballarat VIC 3090 Kayden Dawson 17 Diane Lane, Sydney NSW 2000 Zion Lorenzo 25 Jeffrey Lane, Adelaide SA 5090 Maximus Messiah 33 Christian Street, Canberra ACT 2609 Ezekiel Rhett 12 Sean Circuit, Hervey Bay QLD 4018 Carson Avery 33 Sandra Circuit, Sydney NSW 2000 Evan Steven 7 Larry Lane, Wollongong NSW 2000 Maverick Graham 6 Beverly Lane, Hobart TAS 4018 Bryson Kaleb 30 Gabriel Street, Adelaide SA 5090 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 5% Customer Contact +61 424 111 569 +61 488 828 287 +61 457 753 694 +61 478 236 315 +61 446 723 724 +61 420 730 309 +61 440 833 544 +61 413 338 154 +61 463 165 450 +61 468 338 295 +61 482 312 571 +61 460 771 110 +61 476 609 674 +61 449 174 290 +61 417 644 717 +61 460 123 704 +61 477 132 358 +61 474 789 711 0% 09 Product Details Category Cost/crate Baked Goods & Mixes $ $ 55.0 Beverages $ 65.0 Dried Fruit & Nuts 65,0 Grains $ 66.0 Sauces $ 67.0 Condiments $ 68.0 Fruit & Veg $ 53.0 Pasta $ 51.0 Candy $ 51.0 Canned Meat $ 58.0 Baked Goods & Mixes $ 58.0 Saups $ 23.0 Beverages $ 65.0 Dried Fruit & Nuts s $ 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 Is 43.0 Product Name 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 Agoles 7% 10% 4% 11% OX 3% 10% 13% 14% 2% 39% 49 16% 17% 18% 15% 13% 14% 11% 995 SX 5% 4% 3% 3% 146 x fox A B C D H 1 K L 14 Customer and Product Details 15 Markup Promotional Discount 2% 20% 15% 2% 2% 3% 3% 4% 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Customer ID 20055 20022 20084 20145 20007 20160 20103 20120 20096 20166 20179 20145 20023 20048 20073 20200 20023 20068 Customer Name Pies and Rolls Cafe Coffee Shop C. ple - The Black Kettle Harrison Pvt Ltd Yumm Cafe Seedling Cafe Campbel Candy Mitlada Beer CO Pies and Rolls Cafe Pioneer Bakers The Good Cafe Sorento Cafe Grain Store Third Wave Cafe Third Wave Cafe Good Meat Mitalda Beer Co Customer Details Contact Name Customer Address Cooper Jesse 25 Gloria Circuit Ballarat VIC 3090 Xavier Matteo 15 Judy Street, Albury NSW 2000 Parker Desar 25 Joseph Street, Wollongong NSW 2000 Roman Zayden 8 Pamela Cresent. Hervey Bay QLD 4019 Jason Preston 12 Katherine Drive Perth WA 5010 Santiago August 35 Kelly Street, Geelong VIC 3000 Chase Oscar 35 Samantha Street, Canberra ACT 2609 Sawyer Jeremy 17 Jesse Drive, Albury NSW 2000 Gavin Alejandro 30 Gabriel Street, Adelaide SA 5090 Leonardo Marcus 25 Gloria Circuit, Ballarat VIC 3090 Kayden Dawson 17 Diane Lane, Sydney NSW 2000 Zion Lorenzo 25 Jeffrey Lane, Adelaide SA 5090 Maximus Messiah 33 Christian Street, Canberra ACT 2609 Ezekiel Rhett 12 Sean Circuit, Hervey Bay QLD 4018 Carson Avery 33 Sandra Circuit, Sydney NSW 2000 Evan Steven 7 Larry Lane, Wollongong NSW 2000 Maverick Graham 6 Beverly Lane, Hobart TAS 4018 Bryson Kaleb 30 Gabriel Street, Adelaide 5A 5090 Customer Contact +61 424 111 569 +61 488 828 287 +61 457 753 694 +61 478 236 315 +61 446 733 724 +61 420 730 309 +61 440 833 544 +61 413 338 154 +61 463 165 450 +61 468 338 296 +61 482 312 571 +61 460 771 110 +61 476 609 674 +61 449 174 290 +61 417 644 717 +61 460 123 704 +61 477 132 358 +61 474 789 711 0% 0% 0% Product Name 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 Product Details Category Cost/ crate Baked Goods & Mixes $ 55.0 Beverages $ 65.0 Dried Fruit & Nuts $ 65.0 Grains $ 66.0 Sauces $ 67.0 Condiments $ 58.0 Fruit & Veg $ 53.0 Pasta $ 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 $ 43.0 20% 4% 5% 10% 5% 6% 5% 7% 10% 4% 0% 0% 3% 3% 2% 396 11% 10% 13% 14% 16% 17% 18% 15% 13% 14% 4% 5% 5% 4% 119 9% 3% 3% 43 45 46 47 48 49 50 51 52 53 54 SS 56 57 58 59 60 61 62 63 Payment Details Customer ID Payment Type 20055 Credit Card 20022 Cheque 20084 Credit Card 20145 Credit Card 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 LILIT 22wCEA SAFA Merge & Centre Find Scle == BB Chamonde 99 Paste BI U Format Cell Conditional Format Insert Delete Format Formatting as Table Styles Sort & Clear Filter NS L M P 5 V 2 40 A 18 YUME INTERNATIONAL PVT LTD IB Costs & Revenue Information Sheet 17 spaus ORTE Cake Danacha Cal Vi copy Bed Head calls My 1 URER Rescheduseksual de 1/10/12 1977 Vignern 13 WYMI 24 els 20 LEN ... 34 2 NELY 22 ! tem Anabra saturpara 31 an acce arra Warna 10242 E 1. 2002 . aidd 10 21. MI . 21:20 drade Chair week 393) Dun Crown did Ew 22 999 2/19 Chet onder 03 CH I 22 10 2: IT 1/10/15 1. 4099 25 33125 1/10/14 al 29188 . 1. 4.11.10 Pas 23 3312 ar 29221 1/10 1,2338 2014 Marn 11 23 sane 23 h) TAPINA tan daa 23333 drap Lhat 2015: 13 2/1/18 111111 ne 31 w 21:45 2/12/ 222 Dore er LEIN30507 MUTE 22 40 2 36202 Depan Coroan Chasa ada ya 21 2 Lava 21 UN 311 99,99 Shun 21:55 acas 1932 Dergen AN are 27 21 RAIS 24 45 Na SL 22. Per DAY 23 216179 han Mind AT wela 33143 18 4711 34 wim 21:45 2009 Get Core Sras 22397 33 Anne 2: 242.2 CROCEE Curse 22. 11 .. Land 1. 31 2:13:14 WIRE V. 33 31 Bergen NS 73 53 ASA C 21375 2/30/35 Lucie CN. 1933Cat Cerer WENT 22 205420) Depescanpan China 1, 2017 h 25 12. W 2010 2.44 97133 land 23 28 Ben Selun 21345 BB 2) Cerpen Guns 22 nam 2. La 2331 / 38124 2020 95 21355 2003 5.97 De CERCA Chechende 23 22355 AD 342.2 dia Lero 2012 Cathe 3336 20 LE 118 1919 rannlag . 20:23 1922 et Care 22 LE 21.90 1102 tapicera CITY designer Lars Home Insert Draw Page Layout Formulas Data Review View Tell me S Auto-sum v X Cut Copy Calibri (Body) V 11 v AA a Wrap Text General A B7 Filly Paste B I Uv === E Merge Centre -0% Insert Dalata Format Format Conditional Format Call Formatting as Table Styles Clear Sart A Filter Find a Select NS fox 1 Y 2 T P 23 OL T! 1917TI 33. Det er vi GR. Nam IROIR 31.0110 31.01. IV A TE 23 14 31 12 10 4'LOVIS IT: 13 24 Vys A 23:20 Adwords adw Cards 123 Para 23 3310 91154 Nya Natur 23:30 Dar 2210 wa JALOU 231 N. 31 3117 Adwords 23:43 UNGUM 2322 SM 3316 . 311 Inn 3272 Anar 23956 22932 J 1199 ary 1632) Drawne CaTEM Cra Hot ai udende w do 111311 dir ARS CO2 BERRY Chestra 54222 Dicting CATEN Orecari FELLAYALTY ei NU 13:41 13,99 PER 14 30 15 vis 51/01. SUM SIA... * YARI Sie SI 4'TE 4'LONES F SL AL LL ar ? 20 3012 Tank 341) Laping CaTEM/ D un Uurchewd 21 23 15 Islam 331 VY He SIN PL NE G1/01% 31.0118 11/01. THER 502 Car 42.2 Cctv pre CITET HARGA PLYMY 14 J3 14 r SL ww PHTH Acords 23150 Jadw Cards 23.0: HEJ 21 3314 37173 29354 Musiwe awards wun mward 2 VIIMIS WHITE yIyI SITE SLOVIE en in 003 14 1 13 CE 222 233 IRELESS :: wiec Grad NY VA 130 Wys VRY'S my 111111 017 239 222 311 m 29995 2396 22-23 L. Lun.au US 101.8 51/01.9 31.01.2 AVA 20 11 79 21 31 23 J3 24 20 21 10 na trawie CSTINY 11:22 pri 1 11/13 1141 Cur Chende Gott ter a WHI ME 2.6 PL " INI GINIS 51/01.,2 51/01. JE 14 231 311 2917 Adwords 23200 Jadwards 2332) Rada 12 lai 2011 2317 Mys 2714 Dan Molon 23:45 Dann Hole 22000 1:2 3012 56:22 Dewi On Hous 11. Ghee The ''IV piny a na Wys 1111311411 WIT VII Star CM 'LOMID 12/12) Otras Co G'LANIS 2. Ostwin LATIN E FE PL IL 1 J5 220 221 222 124 130 125 225 227 220 IN N. 1017 4.7: Tales 23 10 93 13 GIAN SINI vis G1/01/2 51.01.2 '11 33120 2171 23359 2321 2 Oor Onde Adwords num 22 tetorin 13. MIRA 14 LOVI T.CO N5 fx G H - K F 1 Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience stores in Australia. 2 You are provided with the information related to its customer details, product details, and costs and revenue information sheet. 3 Yume International has partnered with three shipping companies who ships the products to its Australian customers on time. 4 You are a junior accountant and your Senior Accounts Manager wants you to summarise this data in a meaningful way. 5 Required: 6 PART-A: Complete missing information in costs and revenue information sheet (highlighted in yellow colour) (5 marks) PART B: Pivot Table and Recommended Charts (5 marks) 1. Calculate gross profit for each customer along with product name and payment type using Pivot Table; categorising the columns by salesperson ii. Calculate sales revenue by cach salesperson using Pivot Table and illustrate it via Clustered Bar Chart 10 iii. Calculate sales revenue and gross profit earned by each product using Pivot Table and illustrate it via 100% stacked line graph 11 12 For Pivot Tables and charts, please use a new worksheet and lobel it as (Pivot and Charts). You must use relevant Excel functions for the tasks assigned. Do not calculate it manually. 9 13 14 Customer and Product Details 15 16 17 Customer ID 20055 18 Mark-up 20% 15% 20% 4% 5% 10% 5% Promotional Discount 2% 2% 2%. 3% 3% $ 4% 0% Customer Name Pies and Rolls Cafe Coffee Shop Chal Coffee The Black Kettle Harrison Pvt ltd Yumm Cafe Seedling Cafe Campbell Candy Mitlada Beer Co Ples and Rolls Cafe Pioneer Bakers The Good Cafe Sorento Cafe Grain Store Third Wave Cafe Third Wave Cafe Good Meat Mitalda Beer Co 20022 20084 20145 20007 20160 20103 20120 20096 20166 20179 20145 20023 20048 20073 20200 20023 20068 Customer Details Contact Name Customer Address Cooper Jesse 25 Glaria Circuit, Ballarat VIC 3090 Xavier Matteo 15 ludy Street, Albury NSW 2000 Parker Dear 25 Joseph Street, Wollongong NSW 2000 Roman Zayden 8 Pamela Cresent, Hervey Bay QLD 4019 Jason Prestan 12 Katherine Drive, Perth WA 6010 Santiago August 35 Kelly Street, Geelong VIC 3000 Chase Oscar 35 Samantha Street, Canberra ACT 2609 Sawyer Jeremy 17 Jesse Drive, Albury NSW 2000 Gavin Alejandro 30 Gabriel Street, Adelaide SA 5090 Leonardo Marcus 25 Gloria Circuit, Ballarat VIC 3090 Kayden Dawson 17 Diane Lane, Sydney NSW 2000 Zion Lorenzo 25 Jeffrey Lane, Adelaide SA 5090 Maximus Messiah 33 Christian Street, Canberra ACT 2609 Ezekiel Rhett 12 Sean Circuit, Hervey Bay QLD 4018 Carson Avery 33 Sandra Circuit, Sydney NSW 2000 Evan Steven 7 Larry Lane, Wollongong NSW 2000 Maverick Graham 6 Beverly Lane, Hobart TAS 4018 Bryson Kaleb 30 Gabriel Street, Adelaide SA 5090 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 5% Customer Contact +61 424 111 569 +61 488 828 287 +61 457 753 694 +61 478 236 315 +61 446 723 724 +61 420 730 309 +61 440 833 544 +61 413 338 154 +61 463 165 450 +61 468 338 295 +61 482 312 571 +61 460 771 110 +61 476 609 674 +61 449 174 290 +61 417 644 717 +61 460 123 704 +61 477 132 358 +61 474 789 711 0% 09 Product Details Category Cost/crate Baked Goods & Mixes $ $ 55.0 Beverages $ 65.0 Dried Fruit & Nuts 65,0 Grains $ 66.0 Sauces $ 67.0 Condiments $ 68.0 Fruit & Veg $ 53.0 Pasta $ 51.0 Candy $ 51.0 Canned Meat $ 58.0 Baked Goods & Mixes $ 58.0 Saups $ 23.0 Beverages $ 65.0 Dried Fruit & Nuts s $ 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 Is 43.0 Product Name 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 Agoles 7% 10% 4% 11% OX 3% 10% 13% 14% 2% 39% 49 16% 17% 18% 15% 13% 14% 11% 995 SX 5% 4% 3% 3% 146 x fox A B C D H 1 K L 14 Customer and Product Details 15 Markup Promotional Discount 2% 20% 15% 2% 2% 3% 3% 4% 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Customer ID 20055 20022 20084 20145 20007 20160 20103 20120 20096 20166 20179 20145 20023 20048 20073 20200 20023 20068 Customer Name Pies and Rolls Cafe Coffee Shop C. ple - The Black Kettle Harrison Pvt Ltd Yumm Cafe Seedling Cafe Campbel Candy Mitlada Beer CO Pies and Rolls Cafe Pioneer Bakers The Good Cafe Sorento Cafe Grain Store Third Wave Cafe Third Wave Cafe Good Meat Mitalda Beer Co Customer Details Contact Name Customer Address Cooper Jesse 25 Gloria Circuit Ballarat VIC 3090 Xavier Matteo 15 Judy Street, Albury NSW 2000 Parker Desar 25 Joseph Street, Wollongong NSW 2000 Roman Zayden 8 Pamela Cresent. Hervey Bay QLD 4019 Jason Preston 12 Katherine Drive Perth WA 5010 Santiago August 35 Kelly Street, Geelong VIC 3000 Chase Oscar 35 Samantha Street, Canberra ACT 2609 Sawyer Jeremy 17 Jesse Drive, Albury NSW 2000 Gavin Alejandro 30 Gabriel Street, Adelaide SA 5090 Leonardo Marcus 25 Gloria Circuit, Ballarat VIC 3090 Kayden Dawson 17 Diane Lane, Sydney NSW 2000 Zion Lorenzo 25 Jeffrey Lane, Adelaide SA 5090 Maximus Messiah 33 Christian Street, Canberra ACT 2609 Ezekiel Rhett 12 Sean Circuit, Hervey Bay QLD 4018 Carson Avery 33 Sandra Circuit, Sydney NSW 2000 Evan Steven 7 Larry Lane, Wollongong NSW 2000 Maverick Graham 6 Beverly Lane, Hobart TAS 4018 Bryson Kaleb 30 Gabriel Street, Adelaide 5A 5090 Customer Contact +61 424 111 569 +61 488 828 287 +61 457 753 694 +61 478 236 315 +61 446 733 724 +61 420 730 309 +61 440 833 544 +61 413 338 154 +61 463 165 450 +61 468 338 296 +61 482 312 571 +61 460 771 110 +61 476 609 674 +61 449 174 290 +61 417 644 717 +61 460 123 704 +61 477 132 358 +61 474 789 711 0% 0% 0% Product Name 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 Product Details Category Cost/ crate Baked Goods & Mixes $ 55.0 Beverages $ 65.0 Dried Fruit & Nuts $ 65.0 Grains $ 66.0 Sauces $ 67.0 Condiments $ 58.0 Fruit & Veg $ 53.0 Pasta $ 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 $ 43.0 20% 4% 5% 10% 5% 6% 5% 7% 10% 4% 0% 0% 3% 3% 2% 396 11% 10% 13% 14% 16% 17% 18% 15% 13% 14% 4% 5% 5% 4% 119 9% 3% 3% 43 45 46 47 48 49 50 51 52 53 54 SS 56 57 58 59 60 61 62 63 Payment Details Customer ID Payment Type 20055 Credit Card 20022 Cheque 20084 Credit Card 20145 Credit Card 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 LILIT 22wCEA SAFA Merge & Centre Find Scle == BB Chamonde 99 Paste BI U Format Cell Conditional Format Insert Delete Format Formatting as Table Styles Sort & Clear Filter NS L M P 5 V 2 40 A 18 YUME INTERNATIONAL PVT LTD IB Costs & Revenue Information Sheet 17 spaus ORTE Cake Danacha Cal Vi copy Bed Head calls My 1 URER Rescheduseksual de 1/10/12 1977 Vignern 13 WYMI 24 els 20 LEN ... 34 2 NELY 22 ! tem Anabra saturpara 31 an acce arra Warna 10242 E 1. 2002 . aidd 10 21. MI . 21:20 drade Chair week 393) Dun Crown did Ew 22 999 2/19 Chet onder 03 CH I 22 10 2: IT 1/10/15 1. 4099 25 33125 1/10/14 al 29188 . 1. 4.11.10 Pas 23 3312 ar 29221 1/10 1,2338 2014 Marn 11 23 sane 23 h) TAPINA tan daa 23333 drap Lhat 2015: 13 2/1/18 111111 ne 31 w 21:45 2/12/ 222 Dore er LEIN30507 MUTE 22 40 2 36202 Depan Coroan Chasa ada ya 21 2 Lava 21 UN 311 99,99 Shun 21:55 acas 1932 Dergen AN are 27 21 RAIS 24 45 Na SL 22. Per DAY 23 216179 han Mind AT wela 33143 18 4711 34 wim 21:45 2009 Get Core Sras 22397 33 Anne 2: 242.2 CROCEE Curse 22. 11 .. Land 1. 31 2:13:14 WIRE V. 33 31 Bergen NS 73 53 ASA C 21375 2/30/35 Lucie CN. 1933Cat Cerer WENT 22 205420) Depescanpan China 1, 2017 h 25 12. W 2010 2.44 97133 land 23 28 Ben Selun 21345 BB 2) Cerpen Guns 22 nam 2. La 2331 / 38124 2020 95 21355 2003 5.97 De CERCA Chechende 23 22355 AD 342.2 dia Lero 2012 Cathe 3336 20 LE 118 1919 rannlag . 20:23 1922 et Care 22 LE 21.90 1102 tapicera CITY designer Lars Home Insert Draw Page Layout Formulas Data Review View Tell me S Auto-sum v X Cut Copy Calibri (Body) V 11 v AA a Wrap Text General A B7 Filly Paste B I Uv === E Merge Centre -0% Insert Dalata Format Format Conditional Format Call Formatting as Table Styles Clear Sart A Filter Find a Select NS fox 1 Y 2 T P 23 OL T! 1917TI 33. Det er vi GR. Nam IROIR 31.0110 31.01. IV A TE 23 14 31 12 10 4'LOVIS IT: 13 24 Vys A 23:20 Adwords adw Cards 123 Para 23 3310 91154 Nya Natur 23:30 Dar 2210 wa JALOU 231 N. 31 3117 Adwords 23:43 UNGUM 2322 SM 3316 . 311 Inn 3272 Anar 23956 22932 J 1199 ary 1632) Drawne CaTEM Cra Hot ai udende w do 111311 dir ARS CO2 BERRY Chestra 54222 Dicting CATEN Orecari FELLAYALTY ei NU 13:41 13,99 PER 14 30 15 vis 51/01. SUM SIA... * YARI Sie SI 4'TE 4'LONES F SL AL LL ar ? 20 3012 Tank 341) Laping CaTEM/ D un Uurchewd 21 23 15 Islam 331 VY He SIN PL NE G1/01% 31.0118 11/01. THER 502 Car 42.2 Cctv pre CITET HARGA PLYMY 14 J3 14 r SL ww PHTH Acords 23150 Jadw Cards 23.0: HEJ 21 3314 37173 29354 Musiwe awards wun mward 2 VIIMIS WHITE yIyI SITE SLOVIE en in 003 14 1 13 CE 222 233 IRELESS :: wiec Grad NY VA 130 Wys VRY'S my 111111 017 239 222 311 m 29995 2396 22-23 L. Lun.au US 101.8 51/01.9 31.01.2 AVA 20 11 79 21 31 23 J3 24 20 21 10 na trawie CSTINY 11:22 pri 1 11/13 1141 Cur Chende Gott ter a WHI ME 2.6 PL " INI GINIS 51/01.,2 51/01. JE 14 231 311 2917 Adwords 23200 Jadwards 2332) Rada 12 lai 2011 2317 Mys 2714 Dan Molon 23:45 Dann Hole 22000 1:2 3012 56:22 Dewi On Hous 11. Ghee The ''IV piny a na Wys 1111311411 WIT VII Star CM 'LOMID 12/12) Otras Co G'LANIS 2. Ostwin LATIN E FE PL IL 1 J5 220 221 222 124 130 125 225 227 220 IN N. 1017 4.7: Tales 23 10 93 13 GIAN SINI vis G1/01/2 51.01.2 '11 33120 2171 23359 2321 2 Oor Onde Adwords num 22 tetorin 13. MIRA 14 LOVI T.CO
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started