Warehouse utilization Template

[Scribeman]

Hi

As part of a set of KPI's requested by a customer, I have to provide a
weekly report demonstrating warehouse utilization during the week. The
clients ideas on what they want to see are somewhat 'fuzzy' but as i see it
we have certain pallet racking spaces that are set for large, medium &
smaller machines and the client would like to know what percentage each area
is used and overall weekly & monthly peak/low usage.

Any help would be gratefully received.

Thanks

 

[Joel]

This is another form of the old classic problem that comes from phone usage.
A company wanted to what the optimal number of trunk lines that were neeeded
base on phone usage. The phone usage was listed as the call start time and
amount of time for each call. Since calls started and ended at different
times you need to find out how many calls were occuring simultaneously. The
method was to create a list of times for each day from midnight to midnight
in 5 minutes periods

12:00 AM
12:05 AM
12:10 AM
....
11:50 PM
11:55 PM

The period of time (5 minutes) is arbitrary according to your needs. You
probably need to due it hourly or daily

Then the process was to go through each call and add 1 from each time period
the call took place in the table I made above. If a call took 30 minutes
then you would add one to each of the six 5 minutes periods where the call
took place.

Your problem is similar. You need to make a table of the different times
during the week and figure out how many items are in the wharehouse.