Productivity formula

[angandbri]

I am trying to calculate the amount of time it takes to stuff an item. (item per minute). Is there a productivity formula I can use or something that will help me out.

I have 7.5 hours - 8 people - 345 items stuffed. Need the amount of time it is taking to stuff each item. Need to be able to formulate it to create a chart.

I have been taking item stuffed by the hours, but there is the problem with the amount of people, and the conversion from hours to minutes. PLEASE HELP!! NEED FOR WORK TOMORROW!!

 

[Michael M]

Maybe, where
A2 = number of staff
B2 = Hrs / Day
C2 = Items to be stuffed

Excel Workbook
	A	B	C	D
1	No of Staff	Hrs / day	Items	stuff rate
2	8	7.5	345	10:26:05
Sheet1

Excel 2003

Cell Formulas
Range	Formula
D2	=TEXT(((B2*60)*A2)/C2,"hh:mm:ss")

 

[angandbri]

You answer has it at 10 hours, so I am not following.... We are aiming for stuffing items at 2 mins per item, which we are not hitting, but something in your formula is incorrect. Can you try again??

 

[Michael M]

Oops, my error , sorry
try

Excel Workbook
	A	B	C	D
1	No of Staff	Hrs / day	Items	stuff rate MM:ss)
2	8	7.5	345	10:26
Sheet1

Excel 2003

Cell Formulas
Range	Formula
D2	=(B2*60*60*A2)/86400/C2

 

[howard]

Hi Michael

Interesting calculation. How did you compute 86400?

 

[Michael M]

Seconds in a day !
I had it in a snippet from a previous post ( can't remember the poster), but it works for me.
The end result in the formula is actually 0.0072463 as a number but by formatting the cell to mm:ss it comes up with 10:26, which I believe is the correct answer.

 

[konew1]

I think the first posting gave the better solution, the only problem is the OP thought the answer was 10 hours when it was 10 minutes

 

[Michael M]

Hi Konew
I thought so too, but it was a bit misleading.

 

[howard]

Hi Michael

Thanks for the explanation

 

[MrVillareal]

Hi I dont know if my assumption is correct but Im just trying to help..

I think the answer is 1.304347826 minutes per item..because the 10 minutes answer is what your paying for..but if we are considering the time per item is stuff, then we should assessed base on working as a group..they stuff one item in just 1.304347826 minutes..so they meet the standard of 2 minutes per item..again this is my own opinion..

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #000000;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">Items</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">WorkingHours</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">WorkingPeople</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Data</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">345</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">7.5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">Simultaneously As A Group</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">ItemsPerWorkingsHours</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">46</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">ItemsPerWorkingsMinutes</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0.766667</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">WorkingHoursPerItem</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0.021739</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">WorkingMinutePerItem</td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">1.304348</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet31</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B4</th><td style="text-align:left">=B$2/C2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B5</th><td style="text-align:left">=B$2/(<font color="Blue">C2*60</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B6</th><td style="text-align:left">=1/B4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B7</th><td style="text-align:left">=1/B5</td></tr></tbody></table></td></tr></table><br />