Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. Arrive at the total number of days that each pallet took between manufacturing and reaching the retail store. Are there any trends in terms

image text in transcribed
9. Arrive at the total number of days that each pallet took between manufacturing and reaching the retail store. Are there any trends in terms of the type of pallets and the time taken? Hint: On a sheet named "Question 9", 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 assembly completed" and select MIN 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 product is spending from manufacturing to reaching the retail store. Once you have this basic analysis. you may want to add "Product name" to the pivot tables to figure out the trends

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Effective small business management An Entrepreneurial Approach

Authors: Norman M. Scarborough

10th Edition

132157462, 978-0132157469

More Books

Students also viewed these General Management questions

Question

What is OSHAs role in warehousing safety?

Answered: 1 week ago