More user friendly format? (labor hours)

[feelkg211]

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?

 

[feelkg211]

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?

Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting --> link to current format

 

[Logit]

.
.
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).

43087001​
Order Quantity:​			1000​			Min in Day​	480​
Process​				Min per Item​	Seconds​	Min Needed for Order​		Days Required​	Employees Required​	Days Needed​
A​				0.13​	7.8​	130​		0.27​	1​	0.27​
B​				0.12​	7.2​	120​		0.25​	3​	0.08​
C​				0.11​	6.6​	110​		0.23​	2​	0.11​
									TOTAL​	0.47 ​

<tbody>
</tbody>

RESOURCE LINK FOR FILE DOWNLOAD

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

 

[feelkg211]

.
.
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).

43087001​
Order Quantity:​			1000​			Min in Day​	480​
Process​				Min per Item​	Seconds​	Min Needed for Order​		Days Required​	Employees Required​	Days Needed​
A​				0.13​	7.8​	130​		0.27​	1​	0.27​
B​				0.12​	7.2​	120​		0.25​	3​	0.08​
C​				0.11​	6.6​	110​		0.23​	2​	0.11​
									TOTAL​	0.47 ​

<tbody>
</tbody>

RESOURCE LINK FOR FILE DOWNLOAD

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

yeah, that's the same with what I ended up with. Thank you so much!

 

[Logit]

You are welcome.