Fillable Printable Gantt Chart Excel Template
Fillable Printable Gantt Chart Excel Template

Gantt Chart Excel Template

Given the information provided below and the Gantt chart layout provided, you are to construct a Gantt chart, with overlaps as
specified.
Activity
L
e
t
t
e
r
Activity Description Predecessor
Duration
(months)
Overlap
(months)
A Train project team None 1 None
B Project paperwork and systems design A 2 ½ ¼
C Modify purchased package B 2 1
D Manual systems flow B 1 ½ 1
E Modify in-house procedures B 4 1
F Test and implement modifications to purchased package C 1 ½ 1/8
G Test and implement manual D ¾ 1/8
H Test and implement modifications to in-house procedures E 1 1/8

GANTT CHART EXERCISE
Schedule
Date Assigned: 12/7/87
Project No. 1016-1021 Project Title: Customer Index System
Assigned to: C.I. (Project Team)
Description December January February March April May June July
A. Train Project Team
B. Project Management Paperwork
C. Modify Purchased Package
D. Manual systems Flow
E. Modify In-House Procedures
F. Test and Implement Modifications to
Purchased Package
G. Test and Implement Manual Systems
Flow
H. Test and Implement Modifications to
In-House Procedrues

ANSWER KEY
GANTT CHART EXERCISE
Schedule
Date Assigned: 12/7/87
Project No. 1016-1021 Project Title: Customer Index System
Assigned to: C.I. (Project Team)
Description December January February March April May June July
A. Train Project Team
B. Project Management Paperwork
C. Modify Purchased Package
D. Manual systems Flow
E. Modify In-House Procedures
F. Test and Implement Modifications to
Purchased Package
G. Test and Implement Manual Systems
Flow
H. Test and Implement Modifications to
In-House Procedrues