More user friendly format? (labor hours)

F

feelkg211

New Member
Joined
Apr 12, 2017
Messages
30
I need to make a workbook that contains sheets of different products. For every product, there's a list of the processes it need to produce it, including the time each process takes, and the employees needed per process. Been trying to make an easier format wherein you just input the quantity ordered for that product and it auto-computes the time needed to make the product.

Any ideas?
9
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
feelkg211 said:
I need to make a workbook that contains sheets of different products. For every product, there's a list of the processes it need to produce it, including the time each process takes, and the employees needed per process. Been trying to make an easier format wherein you just input the quantity ordered for that product and it auto-computes the time needed to make the product.

Any ideas?
9
Click to expand...

Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting --> link to current format
 
Upvote 0
.
.
Assuming MIN PER ITEM & SECONDS PER ITEM are fixed values ... placing appropriate formulas in the remaining
cells as needed ... the remaining values auto-calculate. You only need to enter the ORDER QUANTITY for the remaining
values to fill in.

Download the attached sample file and let me know if this is close.
(The image below is slightly skewed from the actual worksheet).



[TABLE="class: head"]
<tbody>[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #538ED5"]
43087001​
[/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
Order Quantity:​
[/TD]
[TD][/TD]
[TD][/TD]
[TD]
1000​
[/TD]
[TD][/TD]
[TD][/TD]
[TD]
Min in Day​
[/TD]
[TD]
480​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
Process​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
Min per Item​
[/TD]
[TD]
Seconds​
[/TD]
[TD]
Min Needed for Order​
[/TD]
[TD][/TD]
[TD]
Days Required​
[/TD]
[TD]
Employees Required​
[/TD]
[TD]
Days Needed​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
A​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
0.13​
[/TD]
[TD]
7.8​
[/TD]
[TD]
130​
[/TD]
[TD][/TD]
[TD]
0.27​
[/TD]
[TD]
1​
[/TD]
[TD]
0.27​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
B​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
0.12​
[/TD]
[TD]
7.2​
[/TD]
[TD]
120​
[/TD]
[TD][/TD]
[TD]
0.25​
[/TD]
[TD]
3​
[/TD]
[TD]
0.08​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
C​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
0.11​
[/TD]
[TD]
6.6​
[/TD]
[TD]
110​
[/TD]
[TD][/TD]
[TD]
0.23​
[/TD]
[TD]
2​
[/TD]
[TD]
0.11​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #538ED5"]
TOTAL​
[/TD]
[TD="bgcolor: #538ED5"]
0.47


​
[/TD]
[/TR]
</tbody>[/TABLE]


RESOURCE LINK FOR FILE DOWNLOAD

https://www.amazon.com/clouddrive/share/CktPsVe9fUJkzSlrCINdqDkzvEN505u5UvuDIhmmjzK?ref_=cd_ph_share_link_copy
 
Upvote 0
Logit said:
.
.
Assuming MIN PER ITEM & SECONDS PER ITEM are fixed values ... placing appropriate formulas in the remaining
cells as needed ... the remaining values auto-calculate. You only need to enter the ORDER QUANTITY for the remaining
values to fill in.

Download the attached sample file and let me know if this is close.
(The image below is slightly skewed from the actual worksheet).



[TABLE="class: head"]
<tbody>[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #538ED5"]
43087001​
[/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD="bgcolor: #538ED5"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
Order Quantity:​
[/TD]
[TD][/TD]
[TD][/TD]
[TD]
1000​
[/TD]
[TD][/TD]
[TD][/TD]
[TD]
Min in Day​
[/TD]
[TD]
480​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
Process​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
Min per Item​
[/TD]
[TD]
Seconds​
[/TD]
[TD]
Min Needed for Order​
[/TD]
[TD][/TD]
[TD]
Days Required​
[/TD]
[TD]
Employees Required​
[/TD]
[TD]
Days Needed​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
A​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
0.13​
[/TD]
[TD]
7.8​
[/TD]
[TD]
130​
[/TD]
[TD][/TD]
[TD]
0.27​
[/TD]
[TD]
1​
[/TD]
[TD]
0.27​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
B​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
0.12​
[/TD]
[TD]
7.2​
[/TD]
[TD]
120​
[/TD]
[TD][/TD]
[TD]
0.25​
[/TD]
[TD]
3​
[/TD]
[TD]
0.08​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD]
C​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
0.11​
[/TD]
[TD]
6.6​
[/TD]
[TD]
110​
[/TD]
[TD][/TD]
[TD]
0.23​
[/TD]
[TD]
2​
[/TD]
[TD]
0.11​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #538ED5"]
TOTAL​
[/TD]
[TD="bgcolor: #538ED5"]
0.47


​
[/TD]
[/TR]
</tbody>[/TABLE]


RESOURCE LINK FOR FILE DOWNLOAD

https://www.amazon.com/clouddrive/share/CktPsVe9fUJkzSlrCINdqDkzvEN505u5UvuDIhmmjzK?ref_=cd_ph_share_link_copy
Click to expand...

yeah, that's the same with what I ended up with. Thank you so much!
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Custom Cabinet Spreadsheet - issues with how to make it user friendly for customers
Replies
1
Views
304
Cubist
Cubist
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
525
Akuini
Akuini
D
  • Question Question
Calculating OT Labor hours
Replies
5
Views
700
awoohaw
awoohaw
E
  • Solved
Performance issue using a combination of dropdowns & lookups
Replies
9
Views
660
Akuini
Akuini
S
  • Question Question
Excel VBA - Sort & Get Totals - Logic
Replies
4
Views
426
STARL0RD
S

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top