link to the assignment https://twu.instructure.com/courses/2919782/assignments/26468270username: ngahonagyirepassword: Habiyakare 5
You will use Microsoft Excel spreadsheet software to analyze a list or table of data. In Lab 1 we will use Microsoft Excel PivotTable functionality to analyze data. Using the Lab1.xlsx Download Lab1.xlsx file continue to update this spreadsheet to create the following pivot tables: 1. Pivot Table 1: Sales by Region, Product Type, and Product (rows) by Quarter (columns) 2. Pivot Table 2: Sales by Product and Customer (rows) by Quarter (columns) 1. Include a Graph of Pivot Table 2 3. Pivot Table 3: Average Sales by Product and Region (rows) by Quarter (columns) Filtered by the Top 10 Selling Products in Quarter 3 4. Focus your responses on the business represented in Lab 1 and use Zara's experience Chapter 3.2 in your textbook to examine how the business in Lab 1 can use information technology to evaluate product offerings, inventory, logistics, marketing, and profitability. Write a response to the following questions in a Word document: 1. What is the business in Lab 1? How would you apply the Zara model to the business represented in Lab 1? 2. What can you determine about the sales of the business represented in Lab 1? What does the analysis of the pivot tables tell you about Lab 1 quarterly sales? Refer to the results in Lab 1 pivot tables to answer this question. 3. What observations about the data can you provide the business represented in Lab 1? What additional data or information do you need to make actual recommendations? 4. The instructor will be grading the 500+ Microsoft Word paper using the Lab Rubric. Getting Started Resources available to help you get started include: 1. Review the Lab Rubric to understand how Lab 1 will be graded. 2. A demonstration assignment is recorded in Module 1 - Discussion 3. Review ExcelLinks to an external site. topics to become familiar with Microsoft Excel. 4. Review Intro to Pivot TablesLinks to an external site. to learn how to organize and summarize data in Microsoft Excel. 5. Download the Lab1.xlsx Download Lab1.xlsxfile to get started, enhance the existing Microsoft Excel spreadsheet to address the requirements for the Lab 1 Assignment and save the changes. 6. Write a response for Lab 1-Step 4 in a Word document. Deliverables You will need to submit the following: 1. Submit (attach) your updated Lab 1 Microsoft Excel spreadsheet (.xlsx file). 2. Submit (attach) your Lab 1-Step 4 Microsoft Word document (.docx file). 3. Submit any additional comments that you believe are helpful. Source Data ProductProduct TypeCustomerRegionQtr 1Qtr 2Qtr 3Qtr 4 Alice MuttonMeatANTONNortheast$ - 0$ 702.00$ - 0$ - 0 Alice MuttonMeatBERGSSoutheast$ 312.00$ - 0$ - 0$ - 0 Alice MuttonMeatBOLIDMidwest$ - 0$ - 0$ - 0$ 1,170.00 Alice MuttonMeatBOTTMSouthwest$ 1,170.00$ - 0$ - 0$ - 0 Alice MuttonMeatERNSHWest$ 1,123.20$ - 0$ - 0$ 2,607.15 Alice MuttonMeatGODOSNortheast$ - 0$ 280.80$ - 0$ - 0 Alice MuttonMeatHUNGCSoutheast$ 62.40$ - 0$ - 0$ - 0 Alice MuttonMeatPICCOMidwest$ - 0$ 1,560.00$ 936.00$ - 0 Alice MuttonMeatRATTCSouthwest$ - 0$ 592.80$ - 0$ - 0 Alice MuttonMeatREGGCWest$ - 0$ - 0$ - 0$ 741.00 Alice MuttonMeatSAVEANortheast$ - 0$ - 0$ 3,900.00$ 789.75 Alice MuttonMeatSEVESSoutheast$ - 0$ 877.50$ - 0$ - 0 Alice MuttonMeatWHITCMidwest$ - 0$ - 0$ - 0$ 780.00 Aniseed SyrupCondimentALFKISouthwest$ - 0$ - 0$ - 0$ 60.00 Aniseed SyrupCondimentBOTTMSouthwest$ - 0$ - 0$ - 0$ 200.00 Aniseed SyrupCondimentERNSHWest$ - 0$ - 0$ - 0$ 180.00 Aniseed SyrupCondimentLINODWest$ 544.00$ - 0$ - 0$ - 0 Aniseed SyrupCondimentQUICKNortheast$ - 0$ 600.00$ - 0$ - 0 Aniseed SyrupCondimentVAFFESoutheast$ - 0$ - 0$ 140.00$ - 0 Boston Crab MeatSeafoodANTONNortheast$ - 0$ 165.60$ - 0$ - 0 Boston Crab MeatSeafoodBERGSSoutheast$ - 0$ 920.00$ - 0$ - 0 Boston Crab MeatSeafoodBONAPMidwest$ - 0$ 248.40$ 524.40$ - 0 Boston Crab MeatSeafoodBOTTMSouthwest$ 551.25$ - 0$ - 0$ - 0 Boston Crab MeatSeafoodBSBEVSouthwest$ 147.00$ - 0$ - 0$ - 0 Boston Crab MeatSeafoodFRANSWest$ - 0$ - 0$ - 0$ 18.40 Boston Crab MeatSeafoodHILAANortheast$ - 0$ 92.00$ 1,104.00$ - 0 Boston Crab MeatSeafoodLAZYKSoutheast$ 147.00$ - 0$ - 0$ - 0 Boston Crab MeatSeafoodLEHMSMidwest$ - 0$ 515.20$ - 0$ - 0 Boston Crab MeatSeafoodMAGAASouthwest$ - 0$ - 0$ - 0$ 55.20 Boston Crab MeatSeafoodOTTIKWest$ - 0$ - 0$ 368.00$ - 0 Boston Crab MeatSeafoodPERICNortheast$ 308.70$ - 0$ - 0$ - 0 Boston Crab MeatSeafoodQUEENSoutheast$ 26.46$ - 0$ 419.52$ 110.40 Boston Crab MeatSeafoodQUICKNortheast$ - 0$ - 0$ 1,223.60$ - 0 Boston Crab MeatSeafoodRANCHMidwest$ 294.00$ - 0$ - 0$ - 0 Boston Crab MeatSeafoodSAVEANortheast$ - 0$ - 0$ 772.80$ 736.00 Boston Crab MeatSeafoodTRAIHSouthwest$ - 0$ 36.80$ - 0$ - 0 Boston Crab MeatSeafoodVAFFESoutheast$ 294.00$ - 0$ - 0$ 736.00 Camembert PierrotDairyANATRWest$ - 0$ - 0$ 340.00$ - 0 Camembert PierrotDairyAROUTNortheast$ - 0$ - 0$ - 0$ 510.00 Camembert PierrotDairyBERGSSoutheast$ - 0$ - 0$ 680.00$ - 0 Camembert PierrotDairyBOTTMSouthwest$ - 0$ - 0$ - 0$ 1,700.00 Camembert PierrotDairyCHOPSSoutheast$ - 0$ 323.00$ - 0$ - 0 Camembert PierrotDairyFAMIAMidwest$ - 0$ 346.80$ - 0$ - 0 Camembert PierrotDairyFRANKSouthwest$ - 0$ - 0$ 612.00$ - 0 Camembert PierrotDairyFURIBWest$ 544.00$ - 0$ - 0$ - 0 Camembert PierrotDairyGOURLNortheast$ - 0$ - 0$ - 0$ 340.00 Camembert PierrotDairyLEHMSMidwest$ - 0$ 892.50$ - 0$ - 0 Camembert PierrotDairyMEREPSoutheast$ - 0$ - 0$ 2,261.00$ - 0 Camembert PierrotDairyOTTIKWest$ - 0$ - 0$ 1,020.00$ - 0 Camembert PierrotDairyQUEENSoutheast$ - 0$ - 0$ - 0$ 510.00 Camembert PierrotDairyQUICKNortheast$ - 0$ 2,427.60$ 1,776.50$ - 0 Camembert PierrotDairyRICARMidwest$ 1,088.00$ - 0$ - 0$ - 0 Camembert PierrotDairyRICSUSouthwest$ 1,550.40$ - 0$ - 0$ - 0 Camembert PierrotDairySAVEANortheast$ - 0$ - 0$ 2,380.00$ - 0 Camembert PierrotDairyWARTHWest$ - 0$ 693.60$ - 0$ - 0 Camembert PierrotDairyWOLZANortheast$ - 0$ - 0$ 510.00$ - 0 Chef Anton's Cajun SeasoningSpiceBERGSSoutheast$ - 0$ - 0$ 237.60$ - 0 Chef Anton's Cajun SeasoningSpiceBONAPMidwest$ - 0$ 935.00$ - 0$ - 0 Chef Anton's Cajun SeasoningSpiceEASTCSoutheast$ - 0$ - 0$ - 0$ 550.00 Chef Anton's Cajun SeasoningSpiceFOLKOMidwest$ - 0$ 1,045.00$ - 0$ - 0 Chef Anton's Cajun SeasoningSpiceFURIBWest$ 225.28$ - 0$ - 0$ - 0 Chef Anton's Cajun SeasoningSpiceMAGAASouthwest$ - 0$ - 0$ 198.00$ - 0 Chef Anton's Cajun SeasoningSpiceQUEENSoutheast$ - 0$ - 0$ - 0$ 132.00 Chef Anton's Cajun SeasoningSpiceQUICKNortheast$ - 0$ 990.00$ - 0$ - 0 Chef Anton's Cajun SeasoningSpiceTRADHSouthwest$ - 0$ - 0$ 352.00$ - 0 Chef Anton's Cajun SeasoningSpiceWARTHWest$ - 0$ - 0$ 550.00$ - 0 Chef Anton's Gumbo MixSpiceMAGAASouthwest$ - 0$ - 0$ 288.22$ - 0 Chef Anton's Gumbo MixSpiceTHEBIWest$ - 0$ - 0$ - 0$ 85.40 Filo MixSpiceAROUTNortheast$ - 0$ 210.00$ - 0$ 56.00 Filo MixSpiceBERGSSoutheast$ - 0$ - 0$ - 0$ 175.00 Filo MixSpiceBLONPNortheast$ 112.00$ - 0$ - 0$ - 0 Filo MixSpiceDUMONSoutheast$ - 0$ - 0$ 63.00$ - 0 Filo MixSpiceFAMIAMidwest$ - 0$ - 0$ - 0$ 28.00 Filo MixSpiceLAUGBMidwest$ - 0$ - 0$ 35.00$ - 0 Filo MixSpiceNORTSSouthwest$ - 0$ 42.00$ - 0$ - 0 Filo MixSpiceOLDWOWest$ - 0$ - 0$ 168.00$ - 0 Filo MixSpiceREGGCWest$ - 0$ - 0$ 23.80$ - 0 Filo MixSpiceRICARMidwest$ - 0$ 490.00$ - 0$ - 0 Filo MixSpiceRICSUSouthwest$ - 0$ - 0$ - 0$ 420.00 Filo MixSpiceTOMSPNortheast$ 75.60$ - 0$ - 0$ - 0 Filo MixSpiceVAFFESoutheast$ - 0$ - 0$ - 0$ 99.75 Filo MixSpiceVINETSoutheast$ - 0$ - 0$ - 0$ 126.00 Gorgonzola TelinoDairyAROUTNortheast$