TE Pre-Audit Process Final DMAIC Report Skye Sun, Leo Lu, Sarah - - PowerPoint PPT Presentation

te pre audit process
SMART_READER_LITE
LIVE PREVIEW

TE Pre-Audit Process Final DMAIC Report Skye Sun, Leo Lu, Sarah - - PowerPoint PPT Presentation

TE Pre-Audit Process Final DMAIC Report Skye Sun, Leo Lu, Sarah Congleton, Annie Lane April 17, 2015 AGENDA 1. INTRODUCTION & REFRESHMENTS 2. PRESENTATION 3. FEEDBACK 2 PROJECT PARTICIPANTS Champions : Data Analytics : Korrina Thomas


slide-1
SLIDE 1

TE Pre-Audit Process Final DMAIC Report

Skye Sun, Leo Lu, Sarah Congleton, Annie Lane

April 17, 2015

slide-2
SLIDE 2

2

  • 1. INTRODUCTION &

REFRESHMENTS

  • 2. PRESENTATION
  • 3. FEEDBACK

AGENDA

slide-3
SLIDE 3

3

Champions: Korrina Thomas & Tim Ogonek Process Owner: Jennifer Snyder Team Members: Evan Jones, Helga Mattingly, Andy Wood, Tina Pike, Judy Reid

PROJECT PARTICIPANTS

Data Analytics: Jessica Gravely & Alex Roman Survey Expert: Pamela Allen Project Coach: Cheryl Dickerson

slide-4
SLIDE 4

4

slide-5
SLIDE 5

5

Define Phase

slide-6
SLIDE 6

6

The Travel and Expense pre-audit process at Ohio Shared Services takes too long. In 2014, 67% of travel and expense requests were satisfactorily completed within 3 days

  • f receipt compared to a target of 80%.

PROBLEM STATEMENT

Problem Statement: Originated from Korrina Thomas

slide-7
SLIDE 7

7

Reports processed by the TE team post-traveler submission and pre-reimbursement

PROJECT SCOPE

slide-8
SLIDE 8

8

Traveler:

1. Decrease pre-audit cycle time 2. Reduce/eliminate need for report resubmission

VOICE OF CUSTOMER

TE Team:

1. Reduce/Eliminate rework 2. Better system design

OSS Managers:

1. Increase consistency in 3 day cycle time to 80% 2. Improve customer satisfaction 3. Standardize process

slide-9
SLIDE 9

9

VOICE OF CUSTOMER: CTQC

Fast Processing of Reports 100% of receipts & supporting docs for expense 100% of docs are submitted same date as submission 100% of conversation is recorded TE emails traveler within 2 days of holding report TE resubmits report if traveler does not respond within 1 day Report worked within 3 days of submission

Need Drivers CTQC

Necessary Documents Provided Good Traveler/TE Communication Quick Response by TE Associate # of On-Hold + # of resubmitted

KPIs

Date of Approval - Date of Submission Team Efficiency # of ER worked / Total ER

slide-10
SLIDE 10

10

BUSINESS CASE

↑ Efficiency = ↑ Customer Satisfaction

  • Decreases cycle time of report
  • Less calls to call center
  • Allows OSS to grow by introducing more

service lines (potential reallocation)

  • Reduces cost to state agencies
slide-11
SLIDE 11

11

DELIVERABLES

  • 1. Establish team productivity standard
  • 2. Validate or revise standard operating

procedure/work distribution

  • 3. Timely & accurate processing of TE

reports

  • 4. Improved customer satisfaction
  • 5. Develop new customer satisfaction

measure/survey

slide-12
SLIDE 12

12

Measure Phase

slide-13
SLIDE 13

13

slide-14
SLIDE 14

14

In 2014, 33% of ER were processed in more than 3 days.

2014 BASELINE PERFORMANCE

slide-15
SLIDE 15

15

2014 WORK DISTRIBUTION

The charts demonstrate that work is evenly distributed, but not evenly accomplished.

A C B D E F G E

slide-16
SLIDE 16

16

EFFICIENCY METRICS

Old calculation shows that process has great variability with no clear goal. Efficiency recalculated to reduce variability. New metric reveals process is stable.

slide-17
SLIDE 17

17

GAP from 2015 Data

Average activity takes ~3 mins (Jessica’s time study). Working goal of 200 reports per day is not reached. This goal requires 25% of total available capacity.

slide-18
SLIDE 18

18

RESUBMISSIONS

Majority of reports show as approved at first pass (1). First pass reports have longer cycle times. Moving forward: figure out why.

slide-19
SLIDE 19

19

RESUBMISSION PARETO

slide-20
SLIDE 20

20

This chart demonstrates there is a relatively low percentage of total ERs put on hold.

ON-HOLD BREAKDOWN

slide-21
SLIDE 21

21

CUSTOMER SATISFACTION

Conclusions: Scoring well overall. Need to focus on timeliness and solution satisfaction consistency. Pareto shows VOC.

slide-22
SLIDE 22

22

CUSTOMER SATISFACTION

slide-23
SLIDE 23

23

KEY TAKEAWAYS

  • 1. Project is focused on voice of customer
  • Decrease cycle time defects (>3day processing time)
  • Increase customer satisfaction
  • 2. Key metrics: cycle time, # reports requiring extra

attention, efficiency

  • 3. Resubmissions have a significantly shorter cycle time
  • 4. Current data is very good, but not complete.
  • Large gap between goal and performance identifies

that potentially a large portions of daily activity are not recorded by system.

slide-24
SLIDE 24

24

Analyze Phase

slide-25
SLIDE 25

25

slide-26
SLIDE 26

26

FISHBONE DIAGRAM

PROCESSING TIME OF ERS GREATER THAN 3 DAYS

Materials Machines Information Environment People

CALL CENTER USING TE ASSOCIATE WHEN IT ISN'T THEIR CRM DAY MULTIPLE BREAKS TAKEN THROUGHOUT THE DAY MUST DOWNLOAD MULTIPLE DOCUMENTS COMPENSATION BASED ON QUALITY NOT QUANTITY POOR COMMUNICATION METHOD BETWEEN TE ASSOCIATE AND TRAVELER SLOW PROCESSING TIME IN OAKS HAVE TO GO IN AND OUT OF ER TO RETRIEVE RECEIPTS DISTRACTING WORK PLACE CALL CENTER USING TE'S TO DO THEIR WORK

Methods

LOW MORALE IN TEAM OTHER RESPONSIBILITIES IN OFFICE LACK OF CLARITY FROM TRAVELER'S AS TO WHAT IS INCORRECT WITH ER NO VISIBILITY OF PERFORMANCE INDIVIDUAL MENTALITY CALL CENTER CASES DISRUPT FIFO NOT REGULARLY UPDATING QUERY VARIABLE OPINION OF WHEN DAILY WORK IS FINISHED INCONSISTENCY OF WORK FINISHED WORK IS MONOTONOUS/BORING POOR EFFICIENCY METRIC CRM DAYS GIVE TE AN EXCUSE TO DO LESS WORK STANDARDIZED RESPONSES REQUIRE ADDITIONAL COMMENTS POOR ACCURACY OF REPORT FROM TRAVELER CALCULATION OF TAX WITH CALCULATOR SLOW COMPUTER PROCESSING LOOKUP PER DIEM NO VISIBILITY: % OF REPORTS WITHIN 3 DAYS

slide-27
SLIDE 27

27

ROOT CAUSES

MUST DOWNLOAD MULTIPLE DOCUMENTS THE SYSTEM ALLOWS REPORTS TO BE SUBMITTED WITHOUT ALL REQUIRED INFO/DOCS

slide-28
SLIDE 28

28

POOR ACCURACY OF REPORT FROM TRAVELER

ROOT CAUSES

POORLY DESIGNED SYSTEM

slide-29
SLIDE 29

29

POOR EFFICIENCY METRIC

ROOT CAUSES

CALCULATION DOES NOT INCLUDE QUEUE OF REPORTS FROM PREVIOUS DAY

slide-30
SLIDE 30

30

NO VISIBILITY: % OF REPORTS PROCESSED WITHIN 3 DAYS

ROOT CAUSES

NOT RECORDED ON DAILY SCORECARD

slide-31
SLIDE 31

31

VARIABLE OPINION OF WHEN DAILY WORK IS FINISHED

ROOT CAUSES

NO STANDARD FOR INDIVIDUAL DAILY WORKLOAD

slide-32
SLIDE 32

32

BREAKS TAKEN THROUGHOUT THE DAY

ROOT CAUSES

WORK IS MONOTONOUS

slide-33
SLIDE 33

33

Improve Phase

slide-34
SLIDE 34

34

slide-35
SLIDE 35

35

RECOMMENDATIONS AND IMPLEMENTATION PLAN

slide-36
SLIDE 36

36

Include queue in beginning balance Include metric into daily scorecard Put daily scorecard in visible space Short- term goal

  • f 50%

efficiency Long- term goal

  • f 70%

efficiency

Recalculate Efficiency Metric

1

SHORT-TERM

slide-37
SLIDE 37

37

Include % of Reports Processed Within 3 Days

2

Include metric into daily scorecard Put daily scorecard in visible space

SHORT-TERM

slide-38
SLIDE 38

38

Define Standard for when Daily Work is Completed

3

SHORT & LONG-TERM

1

200 ERs

2

SHORT-TERM LONG-TERM

slide-39
SLIDE 39

39

Create New Standard Operating Procedure for Updating Queue

4

Run new query at 9am and 1pm

SHORT-TERM

slide-40
SLIDE 40

40

Eliminate CRM Days

5

Calls go to TE who worked on report initially

SHORT-TERM

slide-41
SLIDE 41

41

Improve Team Morale

6

Monday Morning Meetings

SHORT-TERM

Review performance from previous week Discuss team goals, obstacles, work conflict

slide-42
SLIDE 42

42

Computer Training Session

7

SHORT-TERM Teach keyboard shortcuts Discuss best way to do reports

slide-43
SLIDE 43

43

Create New Customer Satisfaction Survey

8

SHORT-TERM Create Survey Manager Approval Send to Customers

slide-44
SLIDE 44

44

SAMPLE SURVEY

slide-45
SLIDE 45

45

Redesign system

9

Freeze correct parts of report View all attachments in one window

Categorize receipts

Traveler cannot submit ER without all necessary documents

LONG-TERM

slide-46
SLIDE 46

46

Reallocate People to Other Roles 10

VERY LONG-TERM

= 50% CAPACITY

slide-47
SLIDE 47

47

KEY TAKEAWAYS

  • 1. A lot of flaws in the system allow imperfections into the

process, increasing cycle time

  • 2. New metrics allow for better understanding of current

performance by the TE team

  • 3. More standards are needed in order to increase team

efficiency & morale, and in order to achieve better customer service

slide-48
SLIDE 48

48

Control Phase

slide-49
SLIDE 49

49

slide-50
SLIDE 50

50

  • 1. Cycle time
  • 2. Efficiency
  • 3. Daily work (# reports processed)

TRACK KPI’s

slide-51
SLIDE 51

51

CYCLE TIME

Breakdown of Processed Report Cycle Time CURRENTLY REPORTED NEW ADDITION

Note: Data shown are not related.

slide-52
SLIDE 52

52

CYCLE TIME

(Approval Date – Submission Date)

slide-53
SLIDE 53

53

EFFICIENCY

# ERs Worked/(Beginning Balance + # ERs Received)

slide-54
SLIDE 54

54

2015 EFFICIENCY METRICS

New calculation will be used moving forward. Short term goal of 25%, scaling to 50%, and eventually 70%+.

Team Efficiency

slide-55
SLIDE 55

55

DAILY WORK

(# Reports Processed)

slide-56
SLIDE 56

56

2015 DAILY WORK COMPLETED

Goal of 200 reports per day rarely reached. Productivity spiked when we were at OSS and again on 3/31. There has been an increase in variability during March 2015.

slide-57
SLIDE 57

57

NEW DAILY SCORECARD

slide-58
SLIDE 58

58

SPECIAL THANKS

Ohio Shared Services

Korrina Thomas Tim Ogonek Jennifer Snyder Alex Roman Jessica Gravely Evan Jones Helga Mattingly Tina Pike Judy Reid Andy Wood Pamela Allen

The Ohio State University

Cheryl Dickerson

slide-59
SLIDE 59

59

What questions do you have for us?

FEEDBACK

slide-60
SLIDE 60

60

APPENDIX

slide-61
SLIDE 61

61

CURRENT PROCESS

slide-62
SLIDE 62

62

TIME ALLOCATION STUDY

slide-63
SLIDE 63

63

What are we missing? How do you use your time? What other tasks are being done?

ADDENDUM: UTILIZATION

GOAL: 200 reports/day x 5 days/week = 1,000 reports/week CURRENT PERFORMANCE: 3 min/report x 1,000 reports/week = 3,000 min/week TIME AVAILABLE: 5 people x 40 hours/week x 60 mins/hr = 12,000 mins/week UTILIZATION: 3,000/12,000 = 25%

25% 75% Total time available

slide-64
SLIDE 64

64

Of the ERs that had received receipts, we determined that 49% of those receipts came in after the submission of the report.

slide-65
SLIDE 65

65