The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
Benchmarking Process Data - Man-day calculation gone wrong
UL - Underwriters Laboratories - Health Sciences
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Benchmarking Process Data - Man-day calculation gone wrong
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

Benchmarking Process Data - Man-day calculation gone wrong


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links




Courtesy Quick Links


Links Elsmar Cove visitors will find useful in the quest for knowledge and support:

Jennifer Kirley's
Conway Business Services


Howard's
International Quality Services


Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum


Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining


Ajit Basrur
Claritas Consulting, LLC



International Standards Bodies - World Wide Standards Bodies

ASQ - American Society for Quality

International Organization for Standardization - ISO Standards and Information

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Some Related Topic Tags
benchmarking, calculation formulas, man-days (a measure of work), mathematical equations
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 16th August 2017, 09:25 AM
mikethepenguin

 
 
Total Posts: 12
Please Help! Benchmarking Process Data - Man-day calculation gone wrong

Man-day calculation gone wrong

Dear all, whilst looking at improving a process I have used the following criteria;

1 working day = 7hrs = 420mins
Number of items processed = 1600
Time taken to process items = 7 months
Process time for 1 unit = 66minutes

1600*66 = 105600/420 = 251 man-days.


How can this process take 251 man-days when only 7 months has elapsed?!
50 working weeks * 5 days a week = 250 days per year.
250*(7/12) = 146 days in 7 months.

Does this mean in theory the person doing this task is working over-time?
105600/146 = 723mins for the day or 12hrs per day processing these items?
Can anyone offer some advice?

Last edited by mikethepenguin; 16th August 2017 at 10:32 AM.

Sponsored Links
  Post Number #2  
Old 16th August 2017, 10:49 AM
howste's Avatar
howste

 
 
Total Posts: 5,008
re: Benchmarking Process Data - Man-day calculation gone wrong

Is only one person working in the process? Is the person able to work on more than one item at a time? (i.e. place part in fixture and start machine, then do another task on another part while it's running)
Sponsored Links

  Post Number #3  
Old 17th August 2017, 03:23 AM
mikethepenguin

 
 
Total Posts: 12
Re: Benchmarking Process Data - Man-day calculation gone wrong

Is only one person working in the process?
Sometimes, someone can start the process for him but not very often, from what I remember.

Is the person able to work on more than one item at a time?
Yes sometimes he can multiple items in one process step.

This an invoice processing process, the main part of the process takes 36 minutes to process 1 invoice. Then there's a delay of 8hrs over night where someone looks at the invoice, this is then sent back. If there are changes to be made the rest of the process takes 30 minutes. Putting it back to 66 minutes processing time.
  Post Number #4  
Old 17th August 2017, 09:06 AM
howste's Avatar
howste

 
 
Total Posts: 5,008
Re: Benchmarking Process Data - Man-day calculation gone wrong

It sounds like you're making the assumption that all invoices take an equal amount of time, but they actually don't. You said that if there are changes the processing time is 66 minutes. By logic then, if there are no changes then the processing time is 36 minutes. What percentage of the time are there changes needed?

I'll assume (as an example) that only 1 in 5 invoices need changes. Then the math would be (320*66) + (1280*36) = 67200 minutes or 160 man days. This is a lot closer to the actual time that you're showing. If you reduce it to 1 in 10 invoices you're at about 148 days.
  Post Number #5  
Old 17th August 2017, 09:28 AM
mikethepenguin

 
 
Total Posts: 12
Re: Benchmarking Process Data - Man-day calculation gone wrong

Quote:
In Reply to Parent Post by howste View Post

It sounds like you're making the assumption that all invoices take an equal amount of time, but they actually don't. You said that if there are changes the processing time is 66 minutes. By logic then, if there are no changes then the processing time is 36 minutes. What percentage of the time are there changes needed?

I'll assume (as an example) that only 1 in 5 invoices need changes. Then the math would be (320*66) + (1280*36) = 67200 minutes or 160 man days. This is a lot closer to the actual time that you're showing. If you reduce it to 1 in 10 invoices you're at about 148 days.


Thanks I was already trying to guess where your next point was going, and I have gone with the assumption that 90% pass through at 36 min with 10% taking 30 min. Extrapolated for the year results with 254 days to run the process.
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >

Bookmarks



Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Emoticons are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Gage R&R - Is my sheet calculation wrong? kedarg6500 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 21 27th March 2017 05:59 AM
In Process Data Collection and Cpk Calculation KCIPOH Manufacturing and Related Processes 13 28th November 2011 05:37 AM
What's the best way to present benchmarking data? floyd2511 Benchmarking 6 5th August 2009 11:44 AM
DEA (Data Envelopment Analysis) for Benchmarking BradM Quality Tools, Improvement and Analysis 0 5th September 2007 11:46 AM
ISO 9001 Objectives Data for Benchmarking / Comparison Crusader Benchmarking 0 3rd November 2006 01:11 PM



The time now is 11:45 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 
 
 


NOTE: This forum uses "Cookies"