Let's say I have 2 shifts at a packaging plant, 8am - 4pm and 6pm - 2am. The user can input inbound hour time (start time) in column A, outbound hour time (end time) in column B, total number of hours worked in column C. Lets say column D is the number of bags packed and column D is the number of hours required, which is basically total number of bags/(number of hours x 20), 20 is number of bags a person can pack in an hour. What I am trying to find is how many persons I would require in a shift.

Shift 1             
Inbound Outbound    Hours worked    Total# of bags  Persons required

8:00    10:00            2                 200             5
10:00   12:00            2                 180             4.5
12:00   14:00            1                 230             11.5
14:00   16:00            2                 130             3.25
                                           Sum             24.25
                                                  25 people

As you can see in this case I would require 25 people but here is the issue, I can't start them all at 8am since my shift would finish way before 8 hours. I need to find a way where I can employ equal number of people (manpower) per hour segment of my shift (in this example my hour segment is 2hrs but it can vary based on user input in columns A and B)

  • You want to use man-hours as your unit of measurements, not people. (ex.: 1 man-hour = one person working for two hours = two people working for 1 hour) So for your first row, you can use 5 people for 2 hours each, 10 people for 1 hour each, or even 20 people for 1/2 hour each. – cybernetic.nomad Jan 11 at 15:34
  • I just noticed you have 1 hour worked between 12:00 and 14:00. Also, to solve this problem, more info is needed: is there a minimum shift length for any one person? If it's 8 hours, then this whole exercise is moot as you will need enough staff to cover the busiest time of day and live with idle hands the rest of the time. – cybernetic.nomad Jan 11 at 15:38

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.