Question

Individual CPM Assignment SCENARIO:

Big Organization, inc. wants to automate their warehouse and put you in charge of the project.

You already put together your team and had several productive meetings with them. Among accomplishments, you created a WBS which identified activities to be done.

Starting with the WBS and with input from your team you then identified each activity’s predecessor activities. Later, in a subsequent meeting with your team you estimated activity completion times for each activity. The table below shows the activities you identified along with predecessor activities and the estimated time each activity is expected to take. Estimated activity times are shown in the last column.

Automated Warehouse
Activity	Description	Preceding Activity	Activity Times
A	Define Requirements	none	10 days
B	Assign Team	A	5 days
C	Design Hardware	A	25 days
D	Code Software	B	20 days
E	Build & Test Hardware	C	50 days
F	Develop Patent Request	C	15 days
G	Test Software	D	35 days
H	Integrate Systems	E, F, G	15 days

B. Second tab (Worksheet) in Microsoft Excel template Workbook: Calculate the EST, EFT, LST, LFT, and slack for each activity. Also determine the total project completion time and the critical path(s). Note that some calculations have been done for you (15 points). Example table:

		Expected						Critical?
Activity	Pred	Time	EST	EFT	LST	LFT	Slack	Y/N
A	-	10
B	A	5
C	A	25
D	B	20
E	C	50
F	C	15
G	D	35
H	E,F,G	15
Critical Path =
Project Length =				days

Answer 1

Formula

Critical path = A-C-E-H

Project duration = 100 days