Must be on Excel as formatted below:

***The time is to be specified in AM and PM** (ex 9:00AM start time)

Figure 3.4 is:

For understanding you must add in a critical pathway (a step that has to be done or the task will not be completed) and a noncritical pathway ( a simple crazy step such as placing the address in a GPS)

Create a PERT chart for the process in the below scenario using Microsoft Excel; follow the cell template in Figure 3.4 on page 70 of Lighter (2010). You call your physician to obtain a refill for your prescription. Create a PERT chart that includes all the steps of taking your medication. The 7-cell method needs to look like this: Early start Early finish Early finish Duration Early start Duration TASK TASK Late start Late finish Slack Late start Slack Late finish Actual times need to be in the Early-Start. Early-Finish Late-Start, and Late-Finish cells. 0:00 1:00 1:00 Patient registers upon arrival at office 1:45 3:30 6:15 Task 1 1:00 2:15 3:15 Staff finds paper chat 6:15 5:30 14:00 Task 2 Critical Path 6:15 2:00 8:15 Nurse reviews chart for completeness 32:15 6:30 10:45 Task 4 8:15 3:30 11:45 Patient greeted by nurse and taken to exam room 40:45 3:15 47:30 Task 5 11:45 2:30 14:15 Physician reviews chart and greets patient 47:30 5:45 55:45 Task 6 3:15 3:00 6:15 Patient waits for Task 3 open room 14:00 15:15 | 32:15