You will use Microsoft Excel spreadsheet software to sort the Lab 2 data by criteria such as item description, item cost, vendor number, vendor name, or A/P terms. A/P Terms is expressed as the number of days that the customer has to pay the vendor for a purchase. In other words, 30 designates net 30 days. The vendor that allows customers the longest time to pay for an order would offer the most favorable payment terms. You need to complete the following tasks: Create a Product Costs worksheet to determine the vendor with the lowest price for the same item when it is supplied by multiple vendors. You can filter the data using the Item Description column. This filters list can be sorted by Item Cost and Vendor Number. Include the following columns in the solution: Order Number Item Number Item Description Item Cost Quantity Cost Per Order A/P Terms Order Date Arrival Date Delivery Days (Delivery Days is Arrival Date - Order Date) In Chapter 15.3 of your textbook you were required to: Recognize the function and role of data aggregators, the potential for leveraging third-party data, the strategic implications of relying on externally purchased data, and key issues associated with aggregators and firms that leverage externally sourced data. Write a response to the following questions in a Word document: Make a list of the kind of data you might give up when using a cash register, a website, or a loyalty card, or when calling a firms customer support line. How might firms leverage this data to better serve you and improve their performance? Would you recommend any of these solutions to the business represented in Lab 2? What are some of the sources data aggregators tap to collect information? What might be collected about the business represented in Lab 2? What data represented in Lab 2 would you consider private? What are the potential privacy law benefits to consumers? Do consumers lose anything from this legislation?