An insurance company has decided to construct a local area network (LAN) in one of its large offices so that its employees can share printers, files, and other conveniences. The project consists of 15...

An insurance company has decided to construct a local area network (LAN) in one of its large offices so that its employees can share printers, files, and other conveniences. The project consists of 15 activities, labeled A through O, as listed in Table 15.2. This table indicates the immediate predecessors and immediate successors of each activity, along with each activity’s expected duration. (At this point these durations are assumed known.) Note that activity A is the only activity that can start right away, and activity O is the last activity to be completed. This table implies the AON network in Figure 15.2. The company wants to know how long the project will take to complete, and it also wants to know which activities are on the critical path.

Objective To develop a spreadsheet model of the LAN project so that we can calculate the time required to complete the project and identify the critical activities.