Can experts solve this problem:
The Premise : Automated Box Storage & Retrieval
The Problem: Given the length of a storage lane, width of each stop with the lane, and speed of the vehicle, determine the average time it takes for the vehicle to store one box and retrieve another box. Assume the lane is 200 feet long and the width of stop to be 2 feet and the vehicle can travel 90 feet/min.
Since the box may be stored / retrieved in any one of the stops in a lane, I need some help with devising a mathematical formula that can effectively represent this problem and solution in a spreadsheet so I am able to test various configurations of the problem.
Thanks
Start Free Trial