+ Reply to Thread
Results 1 to 1 of 1

Working out pick rate, work sheet attached,

  1. #1
    Registered User
    Join Date
    07-30-2015
    Location
    Kerry
    MS-Off Ver
    2007
    Posts
    2

    Working out pick rate, work sheet attached,

    I am trying to do a formula within excel to find out Picking rates within a Warehouse to measure the picking team,
    I know it is normally done by cases picked within a shift then divide by hours spent on the picking task
    eg 1000 cases picked in 8 hour shift equates to pick rate 125 cases an hour,
    Examples below Issue I have is eg, This is new position for me in a place where they never had pick rates , Working day 8.5 Hours with 45 minutes break time so actual working time 7 Hours 45 minutes

    I have started a new job as Warehouse Manager and there is no benchmark in place for what the case rate an hour should be , The benchmark I could then judge by would be taking the 3 best pickers take their average and set benchmark eg at 85%-90% of their average, But I do not know how to do a formula on the picking task,
    Picker A,B,C are the 3 besr pickers so how can I work out a pick rate that work's fairly considering cases to lines picked along with pallets which need to be wrapped which can take on average 3 minutes
    Thanks Presley
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Add Item Rate to the Form and Calculate Total Material Cost to the work sheet
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2015, 09:17 AM
  2. account ledger not working properly with detail i attached file for work
    By harisjawed86 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-23-2014, 10:43 AM
  3. [SOLVED] Pick up the relevant rate through formula
    By khurramfarooqpk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2013, 09:04 PM
  4. Calculate Pick Rate for team of pickers
    By Callumlenehan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2012, 06:15 AM
  5. Time Sheet: Hourly Rate for work Performed between 10PM to 6AM
    By nicoskygush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2009, 03:45 PM
  6. unique record filter is not working only in this attached sheet
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2008, 06:31 PM
  7. Hourly Pick Rate.
    By pobrien31 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-31-2006, 01:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1