3. PROJECT MANAGEMENT (cont)
FILE NAME: CPMWEEK
FUNCTION: Critical-Path-Method, weekly schedule
OVERVIEW: Similar to CPMDAILY.XLS, except that time is measured in weeks rather than days.
INPUT/OUTPUT/MODIFYING THE WORKSHEET: Similar to CPMDAILY.
Enter task descriptions in C8.... The first and last are always labeled dummy start and dummy finish. Number the tasks in E8.... The dummy start is always zero and the dummy finish is assigned an arbitrary number much larger than the last task.
Enter the number of weeks needed to do each task in F8.... In G8..H12, enter the numbers of the immediately preceding tasks.
If there is only 1 immediately preceding task, use zero as the second. The dummy start is always preceded by two zeros while the dummy finish is preceded by the last task and NA. In G28..., enter the numbers of the immediate successors to each task. If there is only one immediate successor, enter the dummy finish number. For the dummy finish, enter NA. Starting in cell C47, enter a list of consecutive integers starting from one and extending a couple of weeks past your expected finish. If you need more than 16 weeks, read the section on modifying the templates to expand the template. Copy the formula from the D column through the blank cells next to the consecutive integers in columnCA. Finally, enter the kick-off date (the first working day for project) in cell D66.
OUTPUT: Early start and early finish day numbers for each task are shown in I8.... Late start and late finish day numbers are shown in I28.... The number of days of slack for each task is shown inK9... and repeated in cellsK28..... Gantt charts of the early-start and late-start schedules are shown in the last two sections of the worksheet.
1. Get Started
2. Workstation Production Models
3. Scheduling 2 Workstation in Series
4. Scheduling 3 Workstation in Series
5. Scheduling 4 and more Workstation in Series
6. Scheduling 2 Workstation in Parallel
7. Project Management - Daily Schedule
10. Gantt Charting