productivity measures withproductivity measures … measures...productivity measures...

Productivity Measures withProductivity Measures with Labware LIMS

Dj K i h & Vi t Z iDj Krishna & Victor Zesiger

Merieux NutriSciences

Agenda

About Merieux NutriSciences Labware LIMS Landscapeab a e S a dscape Productivity Relevance Productivity Metrics Microbiology KPI Chemistry KPI

Process Flow Micro & Chem Process Flow – Micro & Chem Reporting Strategy QuestionsQ

© LabWare 2014 Results Count www.labware.com

About Merieux NutriSciences

•Provides laboratory, auditing, consulting, g gcontract research and education services

•Strong food safety experience

Off R h•Offers Research services for innovation in nutrition


Labware LIMS Landscape

5 Labware LIMS instances (3 v5 & 2 v6) 24 * 7 * 365 W ld id L b t 24 * 7 * 365 Worldwide Laboratory Operations

High throughput environment• ~ 25K samples / day• ~ 70K tests / day• ~ 8K COA’s / day


Productivity - Relevance

LIMS

Productivity(KPI)

Customer E iExperience

& Profitability

Quality(KQI)

Profitability


Productivity Metrics

Executive Management Reports Extraction to compile monthly Key Productivity Indicators (KPI) Total number of completed tests/ category department laboratory division country Total number of completed tests/ category, department, laboratory, division, country Typically expressed in tests/ hour using HR payroll data

Laboratory and Department Level Extraction of data to support day to day operations Compiled at the sub-department level Real time data of productivity of actions/ batch, shift, day

T bilit f ti th h i ti LIMS fi ld Traceability of time through existing LIMS fields Requires discipline in operational processes


Microbiology Sub-DepartmentKPI - Examples

Sample Reception Samples logged/ hour Samples received/ hour Samples received/ hour

Sample Preparation Tests prepared/ hour For Microbiology, preparation to incubation time

• For a single test, batch of tests or by technician

S l lid tiSample validation Tests validated/ hour Incubation to validation time

• For a single test batch of tests or by technician


For a single test, batch of tests or by technician

Chemistry Sub-DepartmentKPI - Examples

Chemistry KPI - Inventory Management Turn-around-time in days versus hours for Microbiology Productivity managed by work-in-progress (WIP) tools

M t i b d LIMS fi ld th t i di t l t t Metrics are based on LIMS fields that indicate sample status

Analysis Tally Unreceived

Tally Recd -Not Prepped

Tally Prepped

Total WIP End of Day

Std Daily Test Prod Rate

Tally Out Test Reviewed Last 24hrs

Est TAT to Test Review at Today's Rate

HISTAMINE 0 8 5 13 50 0 0.3

ICPMS HM 1 4 79 83 50 25 3 3ICPMS-HM 1 4 79 83 50 25 3.3

ICPMS-PREP 9 25 79 104 40 4 26


ICPMS-SCRN 0 7 5 12 50 3 4

Micro Process Flow – Data points

Sample Login

• Login Date• Login by• Login Error• Sample count

Sample Reception

• Received Date• Recd by• Expected Date• Owner Location

Batch Prep

• Date_Created• Batch Action Start Time• Created By

Incubation

• Batch create date• Incubation start time

Result Entry

• Results Entered Date

Review• Test Review Date• Test Review By

Release COA’s

• COA Report date

Invoice

• Test Invoiced Date • Results Entered Date• Entered By

Test Review By• Sample Review Date• Retests• QC Tests• Test Count

• COA Report date• On Time Delivery

• Test Invoiced Date• Invoiced Status


Chemistry Process Flow – Data Points

Sample Login Sample Reception Test Prep Result EntrySample Login

• Login Date• Login by• Login Error• Sample count

Sample Reception

• Received Date• Recd by• Expected Date• Owner Location

Test Prep

• Prep Status• Prep Time• Test Prep By

Result Entry

• Results Entered Date• Entered By

Review• Test Review Date• Test Review By

Release COA’s

COA R t d t

Invoice

T t I i d D t • Test Review By• Sample Review Date• Retests• QC Tests• Test Count

• COA Report date• On Time Delivery Date

• Test Invoiced Date• Invoiced Status


Example 1 – Sample Check-in Measure

SAMPLE.LOGIN_DATE

SAMPLE OWNER LOCATIONSAMPLE.OWNER_LOCATION

Count of Sample Records


Example 2 – Tests completed / hour by a Department

LIMS Data• Test. Status = ‘A’• Test.Test_Location = ‘Chicago’• Test.Lab = ‘Micro’

HR System Data• Technician Hours• FTE count• Lab location• Department


Operational Reporting Strategy

Enterprise Portal

Global Data Warehouse

LABWAREv5

LABWAREv6

Other LIMS

HR Systems

ERP CRM


v5 v6 LIMS Systems

Questions


productivity measures withproductivity measures … measures...productivity measures...

Documents