Attached Files:

• Case of the Belated Lab Tests Part 2.docx(18.021 KB)

To develop a GANTT Chart

Assignment Description

This assignment is a continuation of the Belated Lab Test scenario. Read the attached scenario.

Step 1

Put this data into an Excel spreadsheet and create a graph, or multiple graphs that will show the relationship between TAT and the other factors.

HINT: TAT should be your vertical side of the graph. You will want a graph with Test, Shift, Day and Floor data displayed on the horizontal side of your graph. It might be easiest to create 4 separate graphs.

Step 2

Develop a summary which describes that your graphs are showing you and theories that you have for the root cause

Step 3

Using the data that has been collected and the information from the interview. Determine next steps in the process. Create a Gantt Chart which displays the timeline and the next five steps in the performance improvement process

Step 4

Submit the graph, summary and Gantt chart for grading