# Benchmarking Process Data - Man-day calculation gone wrong

M

#### mikethepenguin

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?

Last edited by a moderator:

#### howste

##### Thaumaturge
Super Moderator
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)

M

#### mikethepenguin

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.

#### howste

##### Thaumaturge
Super Moderator
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.

M

#### mikethepenguin

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.

#### jackwathers

##### Registered
Congratulations on figuring it out.

W Benchmarking Teardown and Salvage Process Benchmarking 1
A CATERPILLAR BGPP (Benchmarking Guide for Painting Process) Questionnaire Customer and Company Specific Requirements 4
D Hospital benchmarking process - Rate of unplanned re-admissions Hospitals, Clinics & other Health Care Providers 5
Document Approval Matrix Benchmarking Document Control Systems, Procedures, Forms and Templates 3
Web based tool for benchmarking audit findings Benchmarking 6
M What is Benchmarking? Benchmarking 7
Benchmarking: Approved Supplier List for Multiple Sites Supplier Quality Assurance and other Supplier Issues 2
M Benchmarking - Timely Closure of Corrective Actions Nonconformance and Corrective Action 3
M Tell me about Benchmarking Benchmarking 4
P Benchmarking and Continuous Improvement Tool Benchmarking 3
P Cross Site Benchmarking of levels of business excellence Benchmarking 3
C Benchmarking Warranty Rates - What Rates should Trigger Actions? Benchmarking 1
C PPAP Benchmarking as it relates to the Aerospace Industry APQP and PPAP 7
Benchmarking cGMP compliance (Systems compliance ) US Food and Drug Administration (FDA) 4
B Automotive Supplier Benchmarking - Supplier PPM Data Benchmarking 5
R Cost of Quality Benchmarking Information for the Electronics Industry Benchmarking 1
C Benchmarking our QMS against other organisations Benchmarking 8
R Benchmarking Supplier Certification Programs Supplier Quality Assurance and other Supplier Issues 7
S Benchmarking of Capability, Accuracy and Stability analyses - In Heat treatment Capability, Accuracy and Stability - Processes, Machines, etc. 3
S Load Testing Benchmarking Benchmarking 3
S Benchmarking PVC Profile Extrusion Metrics Benchmarking 2
R Benchmarking New Supplier First Article Processes Supplier Quality Assurance and other Supplier Issues 4
W Benchmarking vs. Goal Setting - Differences Benchmarking 3
M Benchmarking Audit programs General Auditing Discussions 13
F What's the best way to present benchmarking data? Benchmarking 6
C Benchmarking Preventive Maintenance Sales Benchmarking 0
Z Injection Molding cycle time benchmarking - Ball State University student Benchmarking 10
W Internal Benchmarking between product groups Benchmarking 4
B QFD (Quality Function Deployment) - World Class / Competitor Benchmarking Benchmarking 3
R What is the purpose of Benchmarking? Benchmarking 5
D Who can share Benchmarking Methods? Benchmarking 4
DEA (Data Envelopment Analysis) for Benchmarking Quality Tools, Improvement and Analysis 0
A Information About Benchmarking Parameters of Castings Used for Automobile Sector Benchmarking 2
D How to Benchmark? Is Benchmarking of any value? Seeking advice Benchmarking 34
ISO 9001 Objectives Data for Benchmarking / Comparison Benchmarking 0
C Benchmarking The Worst in Business Benchmarking 5
Automotive makers strategy and benchmarking on supplier quality management Supplier Quality Assurance and other Supplier Issues 2
P Benchmarking and how it differs from the ISO or QS standards? Benchmarking 1
Definition Strategic Benchmarking - Definition Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 0
Definition Benchmarking - Definition Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 1
J TL 9000 and benchmarking data - Wholesale distribution Benchmarking 3
Benchmarking - Information Services Provider Benchmarking 4
Y Benchmarking and Success Rate Survey (ROI) from ISO 9001 Implementation Benchmarking 11
APQP Benchmarking Exercise - Help Wanted Benchmarking 5
M Benchmarking documentation systems as ISO 9004 suggests. Benchmarking 3
H Benchmarking - What objectives have your company set? Benchmarking 4
F Preventive and Predictive Maintenance - Benchmarking Partner Benchmarking 6
I Automotive Benchmarking Benchmarking 4
A Quality Organizational Chart Benchmarking - See attachment Benchmarking 11
E Total Quality Information Software - Benchmarking my product against other software Benchmarking 12