need a excel to calculate replenishment of packing material on a packaging line which has 10 machines in series. E.g Filler, capper, labaler, case erector, case packer, checkweigher & so on. The speeds of each machine is different( filler- 300 botles/min, capper- 320 bottles/min to cap, labeler -350 bottles/min, case packer -30 cases/min & so on.

Also, there should be a second sheet for forklift movement distance calculation which should represent "from" & "to" distances from packing material stores to each machine & how much time forklift would take 1 pallet to shift from PM store to respective machine based on assumption of speed of 10km/hr.