Analyze the Lab 1 Business - Focus your responses on the business represented in Lab 1 and examine how the business in Lab 1 can use information technology to evaluate product offerings, inventory, logistics, marketing, and profitability. Wrte a response in 500 words to the following questions in a Word document:

1. What is the business in Lab 1?
2. What can you determine about the sales of the business represented in Lab 1? What does the analysis of the PivotTable tell you about Lab 1 sales? Refer to the results in the Lab 1 PivotTable to answer this question.
3. What observations about the data can you provide regarding the business represented in Lab 1? What additional data or information do you need to make actual recommendations?

A C D E G H M N First Name Last Name Guests Average Age Home Country Tour Region Tour Country Days Per Person Cost Total Cost Statistics Darlene Oliver 2 35 United States Centralni Montenegro 295.00 $ 590.00 Total Value of Tours Sold $ 45,065.00 |Cody Prince 48 Brazi Madrid Spain 7 5 490.00 $ 980.00 Total Number of Guests Served 114 4 Patrik Haas 2 United Kingdom Lapland Finland 10 9 200.00 $ 800.00 Total Number of Group 50 5 Tomos Gillespie 60 France Ostrobothnia Finland 14 $ 150.00 $ 300.00 Total Nymber of Guests Aged 40 or Over 35 6 Antonina Bartlett 16 Canada Geneva Switzerland 5 S 85.00 $ 1,570.00 Percentage of Guests Aged 40 or Over 70% Blessing Leon 34 United States Tuscany taly 7 5 520.00 $ 520.00 8 Reuber Knowles 69 Brazil Veneto Italy 10 $ 555.00 $ ,110.00 9 Ehsan Philip 27 United Kingdom Westfjords Iceland 14 $ 220.00 $ 440.00 10 Luc Ramos 55 France Slavonia Croatia 5 $ 360.00 $ ,080.00 11 Macie chane 41 Canada Valencia Spain 7 5 865.00 $ 1,730.00 12 Kajus Singh 33 United States Zurich Switzerland 10 $ 415.00 $ 830.00 13 Lexi-Mae Briggs 62 Brazil Primorski Montenegro 14 $ 155.00 $ 155.00 14 Isha Whitehouse 30 United Kingdom Catalonia Spain 5 5 335.00 $ 670.00 15 Nathanie Bishop 9 France Bern Switzerland 7 $ 485.00 $ 970.00 16 Tayler chung 24 Canada Aosta Valley Italy 10 $ 355.00 $ ,775.00 17 Aniya Senior 36 United State Highlands Iceland 14 $ 230.00 $ 460.00 18 Zaynah Tierney 6 Brazil Istria Coratia 5 5 415.00 $ 830.00 19 Nola Mclellan 65 United Kingdom Centraln Montenegro 7 5 245.00 $ 980.00 20 Arman Sparks 60 France Madrid Spain 10 $ 455.00 $ 910.00 21 Rehaan Dolan 51 Canada Lapland Finland 14 $ 235.00 $ 470.00 22 Mami O'Doherty 38 United States Ostrobothnia Finland 5 $ 175.00 $ 175.00 23 Braxton Coates 9 Brazil Geneva Switzerland 7 5 785.00 $ 1,570.00 24 Reo Gomez 57 United Kingdom Tuscany Italy 10 $ 485.00 $ 970.00 25 Erika Bird 65 France Veneto Italy 14 $ 530.00 $ 1,590.00 26 Cobie Mcneil 59 Canada Westfjords Iceland 5 $ 245.00 $ 490.00 J N A N N U N N H N N W N N H N N A N N U N N H N N W N N H N N A N N U N N H N N W N N H N N AN 27 Onur Lugo 40 United States Slavonia Croatia 7 $ 430.00 $ 860.00 28 Cecilia Betts 40 Brazil Valencia Spain 10 $ 865.00 865.00 9 Jorgie Connolly 51 United Kingdom Zurich Switzerland 14 $ 390.00 $ 780.00 30 Chloe-Louise Burnet 47 France Primorski Montenegro 5 $ 85.00 $ 170.00 31 Tariq Salazar 45 Canada Catalonia Spain 7 $ 405.00 $ 2,025.00 $2 Manon Valdez 65 United States Bern Switzerland 10 $ 535.00 $ 1,070.00 $3 Aneesal Goddard 67 Brazil Aosta Valley Italy 14 $ 355.00 $ 710.00 34 Mate Baxter 54 United Kingdom Highlands Iceland 5 $ 60.00 $ 640.00 5 Azeem Peters 4 France Istria Coratia 7 $ 365.00 $ 730.00 $6 Jasmin Dougherty 65 Canada Centralni Montenegro 10 $ 295.00 $ 590.00 37 Kavita Branch 57 United States Madri Spain 14 $ 490.00 $ 490.00 38 Ross Petty 40 Brazil Lapland Finland 5 $ 35.00 $ 470.00 39 Marlene earson 24 United Kingdom Ostrobothnia Inland 7 $ 125.00 $ 250.00 40 |Ama spinosa 29 France Geneva Switzerland 10 $ 750.00 $ 2,250.00 41 Saul trame 22 Canada uscany Italy 14 $ 520.00 $ 1,040.00 42 Avni Colley 67 United States Venet Italy 555.00 $ 1,110.00 43 Darla Kinne 1 Brazil Westfjords Iceland 7 $ 245.00 $ 245.00 44 Primrose Case 70 United Kingdom Slavoni Croatia 10 $ 395.00 $ 790.00 45 Merryn Keller 39 France Valenci Spain 14 5 840.00 $ 1,680.00 46 Carys Maguire 6 Canada Zurich Switzerland 415.00 $ 2,075.00 47 Faizan Ferrell 62 United States Primorski Montenegro 7 $ 155.00 $ 310.00 48 Katerina Morris 4 Brazil Catalonia Spain 10 $ 405.00 $ 810.00 49 Bernadette Ayers 60 United Kingdom Aosta Valley Italy 14 $ 510.00 5 2,040.00 50 Sidney Byers 45 France Highlands Iceland 10 5 320.00 $ 640.00 51 Etta Hodges 14 Canada Istria coratia 14 5 230.00 $ 460.00 52 List Analysis Customer Profile +A B C D E G H J K First Name Last Name Guests Averaghome Country Tour Region Tour Country Days Per Person Cost Total Cost Etta Hodges 2 44 Canad Istria Coratia 14 5 230.00 $ 460.00 Coratia Total 460.00 Luci Ramos 55 France Slavonia Croatia 5 5 360.00 $ 1,080.00 Onur Lug 40 United States Slavonia Croatia 7 $ 430.00 $ 860.00 Primrose Case ND 70 United Kingdom Slavonia Croatia LO 395.00 $ 790.00 Croatia Total 2,730.00 Patrik Haas 72 United Kingdom Lapland Finland 10 $ 200.00 $ 800.00 Rehaan Dolan 51 Canada Lapland Finland 14 $ 35.00 $ 170.00 UNN 10 Ross Petty 40 Brazil Lapland Finland 5 $ 235.00 $ 470.00 1 Tomos Gillespie 60 France Ostrobothnia Finland 14 $ 150.00 $ 300.00 Finland Tota 2,040.00 Mateo Baxter 54 United Kingdom Highlands Iceland 5 $ 160.00 $ 640.00 4 Sidney Byer 45 France Highlands Iceland 10 $ 320.00 $ 640.00 5 Cobie Mcneil 69 Canada Westfjords celand 5 $ 245.00 $ 490.00 6 Darla Kinne 51 Brazil Westfjords Iceland 7 5 245.00 $ 245.00 17 Iceland Total 2,015.00 18 Aneesah Goddard N 67 Brazil Aosta Valley Italy 14 $ 355.00 $ 710.00 9 Bernadette Ayer 50 United Kingdom Aosta Valley Italy 14 $ 510.00 $ 2,040.00 20 Reo Gomez 57 United Kingdom Tuscany Italy 10 $ 485.00 $ 970.00 Reuben Knowles 69 Brazil Veneto Italy 10 S 555.00 $ ,110.00 22 Erika Bird N WN 65 France Veneto Italy 14 $ 530.00 $ 1,590.00 Avni colley 67 United States Veneto Italy 5 5 $55.00 $ 1,110.00 Italy Total ,530.00 5 Nola Mclellan 4 65 United Kingdom Centralni Montenegro 7 $ 245.00 $ 80.00 26 Jasmin Dougherty N 55 Canada Centralni Montenegro 10 $ 295.00 $ $90.00 27 Lexi-Mae Brige 62 Brazil Primorsk Montenegro 14 $ 155.00 $ 155.00 18 Chloe-Louise Burnett 47 France Primorski Montenegro 5 $ 85.00 $ 170.00 29 Faizan Ferrell 62 United States Primorski Montenegro 7 $ 155.00 $ 310.00 Montenegro Total 2,205.00 Tariq Salaza 45 Canada Catalonia Spain 7 $ 405.00 $ 2,025.00 2 Katerina Morris 64 Braz Catalonia Spain 10 $ 405.00 $ 810.00 $3 Cody Prince NNN 48 Brazil Madrid Spain 7 $ 490.00 $ 80.00 Armani Sparks 50 France Madri Spain 10 $ 455.00 $ 10.00 35 Kavita Branch 57 United States Madrid Spain 14 $ 490.00 $ 490.00 36 Macie Chaney 41 Canada Valenci Spain 7 $ 865.00 $ 1,730.00 Cecilia Betts 40 Brazil Valencia Spain 10 865.00 $ 865.00 Spain Total 7,810.00 $9 Manon Valdez 65 United States Bern Switzerland 10 $ 535.00 $ 1,070.00 10 Antonina Bartlett 46 Canada Geneva Switzerland 5 $ 785.00 $ ,570.00 11 Braxton Coates 19 Brazil Geneva Switzerland 7 $ 785.00 $ 1,570.00 Jorgie Connolly 51 United Kingdom Zurich Switzerland 14 $ 390.00 $ 780.00 Carys Maguire 46 Canada Zurich Switzerland 5 $ 415.00 $ 2,075.00 Switzerland Total 7,065.00 Grand Total 31,855.00 Row Labels Sum of Total Cost 18 Brazi 7,745.00 Total 19 Canada 12,225.00 France 10,320.00 1 United Kingdom 3,360.00 $2 United States 6,415.00 Grand Total 45,065.00 Brazil Ca nada France United Kingdom United States List Analysis Customer Profile +19 X V fx =SUM(JulyList [Total Cost]) 2 4 5 6 B D E G H K Statistics REVENUE BY CLIENT COUNTRY Total Value of Tours United States, Sold $ 45,065.00 $6,415.00 Brazil, $7,745.00 Total Number of 10 Guests Served 114 Total Number of 11 Groups 50 United Kingdom, Total Nymber of $8,360.00 Guests Aged 40 or 12 Over 35 Canada, $12,225.00 Percentage of Guests Aged 40 or 13 Over 70% France, $10,320.00 14 15 16 17 Canada is the most popular tour country with client groups with an average fo 40 or older 18 First Name Last Name Guests Average Age Home Country Tour Region Tour Country Days Per Person Cost Total Cost 19 Etta Hodges 2 44 Canada Istria Coratia 14 $ 230.00 $ 460.00 20 Coratia Total $ 460.00 21 Luci Ramos 55 France lavonia Croatia 5 $ 360.00 $ 1,080.00 22 Onu Lugo 10 United States Slavonia Croatia 430.00 $ 860.00 N NW 23 Primrose Case 70 United Kingdom Slavonia Croatia 395.00 $ 790.00 24 Croatia Total $ 2,730.00 25 Patrik Haas 72 United Kingdom Lapland Finland 10 $ 200.00 $ 800.00 26 Rehaan Dolan 51 Canad Lapland Finland 14 235.00 $ 470.00 NNNA 27 Ross Petty 10 Brazil Lapland Finland 5 $ 235.00 $ 470.00 28 Tomos Gillespie 60 France Ostrobothnia Finland 14 5 150.00 $ 300.00 29 Finland Total $ 2,040.00 30 Baxter 54 United Kingdom Highlands Iceland 160.00 $ 640.00 31 Sidney Byers 45 France Highlands Iceland 10 $ 320.00 $ 640.00 HNNA 32 obie Mcneil 59 Canada Westfjords Iceland 5 $ 245.00 $ 490.00 33 Darla inne 1 Brazil Westfjords Iceland 245.00 $ 245.00 34 Iceland Total $ 2,015.00 35 Aneesah Goddard 67 Brazil Aosta Valley Italy 14 $ 355.00 $ 710.00 36 Bernadette Ayers 60 United Kingdom Aosta Valley Italy 14 $ 510.00 $ 2,040.00 Reo Gomez $7 United Kingdom Tuscany Italy 10 $ 485.00 $ 970.00 NWNNAN 38 Reuben Knowles 69 Brazil Veneto taly 10 $ 555.00 $ 1,110.00 39 Erika Bird 65 France Veneto Italy 14 $ 530.00 $ 1,590.00 40 Avni Colley 7 United States Italy 5 $ $55.00 $ 1,110.00 41 Italy Total $ 7,530.00 42 Nola Mclellan 65 United Kingdom Centralni Montenegro 7 $ 245.00 $ 980.00 43 Jasmin Dougherty 55 Canada Centralni Montenegro 10 $ 295.00 $ 590.00 44 Lexi-Mae Briggs 62 Brazil Primorski Montenegro 14 $ 155.00 NNINA 45 Chloe-Louise Burnett 17 France Primorsk Montenegro i S 85.00 $ 170.00 46 Faizan Ferrell 62 United States Primorski Montenegro 155.00 $ 310.00 47 Montenegro Total $ 2,205.00 48 Tari alaza 45 Canada Catalonia Spain 405.00 $ 2,025.00 49 Katerina Morris 64 Brazi Catalonia Spain 10 405.00 $ 810.00 50 Cody Prince 48 Brazil Madrid Spain 7 9 490.00 $ 980.00 51 Armani Sparks H NHNN NUT 60 France Madrid Spain 10 455.00 $ 910.00 Kavit Branch 57 United States Madrid Spain 14 5 490.00 $ 490.00 53 Maci Chane 41 Canada Valencia Spain 7 5 865.00 $ 1,730.00 54 Cecilia Betts 10 Brazil Valencia Spain LOS 865.00 $ 865.00 55 Spain Total $ 7,810.00 56 Manon Valdez 65 United States Bern Switzerland o $ 535.00 $ 1,070.00 57 Antonina Bartlett 16 Canada Geneva Switzerland 5 5 785.00 $ 1,570.00 58 Braxton Coates UI NN NN 49 Brazil Geneva Switzerland 7 $ 785.00 $ 1,570.00 59 Jorgie Connolly 51 United Kingdom Zurich Switzerland 14 S 390.00 $ 780.00 60 Carys Maguire 16 Canada Zurich Switzerland 5 5 415.00 $ 2,075.00 61 Switzerland Total $7 065 00 List Analysis Customer Profile +