Complicated manpower analysis
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)
microsoft-excel
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
add a comment |
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)
microsoft-excel
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
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
add a comment |
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)
microsoft-excel
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
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)
microsoft-excel
microsoft-excel
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
asked Jan 11 at 10:25
Ilyabeij2008Ilyabeij2008
1
1
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
add a comment |
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
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
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
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
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1393109%2fcomplicated-manpower-analysis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1393109%2fcomplicated-manpower-analysis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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