Question

Microsoft Project Assignment Description

A system development project has been defined to contain the following list of activities along with their estimated times for completion. The project will start on 5/1/2019.

Project Data Provided:

Activity ID	Activity Name	Days			Predecessors
		Optimistic(O)	Realistic(R)	Pessimistic(P)
1	Gather Requirement	1	2	3
2	Analyze processes	1	2	6	1
3	Define DFDs	0.5	1	1.5	2
4	Design Processes	2	7	12	2
5	Design database	4	7	22	3
6	Design UI	2	4	8	3,4
7	Build Database	3	5	7	4,5
8	Develop Software	4	8	12	6,7
9	Test and document	4	8	12	7
10	Install	1	2	6	8,9

           

Follow each of the following Six steps making use of Project functionality.

Step 1. Create the above project in Microsoft Project and Enter the Tasks (activities) and Predecessors then go to Step 2 to enter the task durations

Step 2. PERT Analysis:

Do the analysis manually to calculate the Expected Time (duration) for each task:

To find the Expected Time (T_E) for each task you use the Optimistic(o), Realistic(r) and Pessimistic(p) durations employing the formula T_E = (o + 4r + p)/6

TASK	Optimistic (o)	Realistic (r)	Pessimistic (p)
Task 1	2	5	10

Example:  

                              In this case the calculation is:      T_E = (2 + 4*(5) + 10) / 6

T_E = (2 + 20 + 10) / 6

T_E = (32)/6

T_E = 6 (note that we take the division “ceiling” value) After calculating each expected time (T_E) enter the expected time value as the Duration for each task. Retain your calculations to include in the word file submitted.

Step 3. Within Project - Create a network diagram view for the activities, and save the network diagram view

Step 4. Within Project - Create a detailed Gantt chart view for the project (Covered in “Using Microsoft Project.PDF”), make sure that you:

1. Highlight the activities that are on the critical path in the Gantt chart.
2. Highlight the activities that are on the critical path in the task list
3. Show the total slack time (not free slack time) for each activity in the task list.
4. Save your detail Gantt view

Step 5. Remove any unnecessary custom view that is not required. Make sure you only have the two custom views that are required for Q3 and Q4 under “Custom” in the drop-down menu list. In other words, leave the built-in views alone (you do not have to worry about them) but make sure you only have two custom or self-defined views: one view for the network diagram for Q3 and one view for the detailed Gantt view for Q4.

Step 6. Answer the following questions based on what you get directly from Microsoft Project 2013. –

Q(1) Having done the PERT analysis manually – capture those calculations in this document.

Q(2) What’s the expected finish date of the project?

Q(3) How many working days does the project take?

Q(4) List the names of activities that are on the critical path?

Q(5) List the total slack time (not free slack time) in working days for each activity that is not on the critical path. You should clearly specify which activity has how much total slack time.

Answer 1

Te (a+4m+b)/6 EF ES + Te LS LF-Te Slack LF EF 5td Devlation LF Calculation Value Calculation Value Calculation Calculation Value Value (1+4 2+3)/6 1+4 2+6/6 0.5+4 1+1.5 2.00 0.33 0.00 0.00 2.00 2.00 2.00+2.50 2.00 2.00-2.00 0.00 2.00 2.00-2.00 0.00 2.00 2.50 0.83 4.50 4.50-2.50 4.50 4.50-4.50 0.00 1.00 4.50 4.50+1.00 5.50 5.50-1.00 4.50 5.50 5.50-5.50 0.00 2+47+12)/6 .50 4.50+7.00 5.505.50+9.00 12 7.00 14.50-7.00 7.50 14.50 14.50-11.503.00 1.67 11.50 4+4 7+22)/6 2+4 4+8)/6 9.00 14.50 14.50 9.00 14.5014.50-14.500.00 19.5019.50-15.833.67 4.33 1.00 11.5011.50+4.33 15.83 19.50-4.33 15.17 (3+4 5+7)/6 4+4 8+12)/6 5.00 0.67 14.50 14.50+5.00 19.50 19.50-5.00 19.50 19.50-19.500.00 14.50 8.00 1.33 19.5019.50+8.0027 27.50 27.50 8.00 19.50 27.5027.50 27.500.00 4+4 8+12)/6 8.00 1.33 19.5019.50+8.00 7.50 27.50-8.00 19.50 27.50 27.50-27.50 0.00 1+4 2+6)/6 2.50 0.83 27.50 27.50+2.5030.00 30.00-2.50 27.50 30.00 30.00-30.00 0.00 Standard deviation (s Project completion time (m: 30 days Critical Path 1-2-3-5-7-8-10 or 1-2-3-5-7-9-10 Activities on Critical Path: 1,2,3,5,7,8,9,10