Assume you are a manager working for a manufacturer of consumer product goods. Using the attached RFID reader and tag data, arrive at answers to the following questions:
On what days did a given pallet with EPC 48 3 5 0614141 000734 347900 move from one location to another? What are the chronological movements of the pallet?
(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)?
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, filter 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 of Tag Read Date and Time. Now subtract the MIN time (second pivot table) from the MAX time in the first pivot table to obtain the total days a pallet is spending in the warehouse. Now take the average of these days. What is the average number of days that shipping trucks are taking to deliver a pallet from the manufacturing facility to the distributor’s warehouse? Hint: On a sheet named “Question 4,” 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, filter by “Pallet loaded on a shipping truck” and select MIN of Tag Read Date and Time. For the second pivot table, filter by “Pallet stored in the warehouse” and select MIN of Tag Read Date and Time. Now subtract the two MIN times in the two pivot tables to obtain the total days it takes shipping trucks to deliver product form manufacturing facility to the warehouse. Now take the average of these days. What is the average number of days that shipping trucks are taking to deliver a pallet from the distributor’s warehouse to the retail store? Hint: On a sheet named “Question 5,” 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, filter by “Pallet loaded on a shipping truck” and select MAX of Tag Read Date and Time. For the second pivot table, filter by “Pallet delivered to and stored in the retail store” and select MIN of Tag Read Date and Time. Now subtract the two times in the two pivot tables to obtain the total days it takes shipping trucks to deliver product form warehouse to the retail store. Now take the average of these days. Are some types of pallets (types of products) getting delivered quicker to the retail stores from the distributor’s warehouses? HINT: Copy the worksheet in Question 5 as a new worksheet. Add Product name to the pivot tables. Group the the times by product names and take average of times for each product name.
What is the average number of days that a pallet is spending in our manufacturing facilities before it is picked up by a shipping truck? Hint: On a sheet named “Question 7”, 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, filter by “Pallet stored in the storage area” and select MAX of Tag Read Date and Time. For the second pivot table, filter by “Pallet loaded on a shipping truck” and select MIN of Tag Read Date and Time. Now subtract the two times in the two pivot tables to obtain the total days product is spending in the manufacturing facility. Now take the average of these days.
What is the average number of days that a pallet is spending in transit between locations? Hint: Add the answers for average time you computed in Question 4 and Question 5.
Between 1/3/2019 and 1/9/2019 (both inclusive), which pallets have recorded activities and what are these activities by pallet?