Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Warehouse utilization Template
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Warehouse utilization Template
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. "Scribeman" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warehouse load sheet - Help!! | Excel Discussion (Misc queries) | |||
I want to track tool utilization, tracking by hour and day. | Excel Discussion (Misc queries) | |||
Low CPU Utilization | Excel Discussion (Misc queries) | |||
Create a layout for a warehouse | Excel Discussion (Misc queries) | |||
Increased CPU utilization in Excel 2003 | Excel Discussion (Misc queries) |