_____ l___ _ 2. (A) What is the average time taken between producing a pallet at our facilities and the pallet reaching a retail store? (B) What is the average time taken between producing a pallet at our facilities and the pallet reaching a retail store for each of the following specific product categories: Pallet of Diapers, Pallet of Soaps, Pallet of Detergents, Pallet of Probiotics? (C) How do the averages for each product category in part (B) compare to the overall average in part (A)? 3. What is the average number of days that a pallet is spending in the distributor's warehouse? Hint: On a sheet named "Question 3," create two separate pivot tables with EPC Read and Tag Read Date and Time. For both pivot tables, filter by 'Type of Interaction". For the first pivot table, lter by "Pallet loaded on a shipping truck" and select MAX of Tag Read Date and Time. For the second pivot table, filter by "Pallet stored in the warehouse" and select MIN ot Tag Read Date and Time. Now subtract the MIN time (second pivot table) from the MAX time in the rst pivot table to obtain the total days a pallet is spending in the warehouse. Now take the average of these days