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)