Unit 4 Assignment: Project Schedules & Crashing

BUS472_U4_Assignment_Excel_Template.xlsx

Home >Business & Finance homework help >Operations Management homework help >Unit 4 Assignment: Project Schedules & Crashing

Sheet1

BUS472 Unit 4 Assignment Template
		Instructions: Fill in the only the yellow fields:
	1. Activity Network Diagram
			Create a Network Diagram using the following data:
			Activity		Predecessor			Duration
			A		-			3
			B		A			5
			C		A			7
			D		B, C			3
			E		B			5
			F		D			4
			G		C			2
			H		E, F, G			5
			Drag the activities so they are correct (the below is just an example). Ensure to update arrows accordingly.
	2. Critical Path
		A. Complete the forward and backwards pass in the following example:																							L-M-O-T
																									L-M-P-R-T
														O											L-N-P-R-T
								M						6											L-N-Q-S-T
								5																	L-N-P-S-T
			0	L								P				R					T
			0	2				N				4				3					4				15
								6																	17
												Q				S									19
				Legend:								2				4									20
					ES	ID	EF																		22
					LS	Dur	LF																		24
		B. What, in order, are the tasks on the critical path:																							A-B-D-F-H
		C. What is the longest duration of the project?																							A-B-E-H
		D. Looking at the project from question #1 determine the critical path:																							A-C-D-F-H
																									A-C-G-H
																									A-C-E-H
	3. Project Crashing
		A. Compute the per day costs for crashing each activity
						Normal					Crashed					Per Day
				Activity		Duration		Cost			Duration		Cost			Crashed Cost
				A		4 days		$1,000			3 days		$2,000
				B		5 days		$2,500			3 days		$5,000
				C		3 days		$750			2 days		$1,200
				D		7 days		$3,500			5 days		$5,000
				E		2 days		$500			1 day		$2,000
				F		5 days		$2,000			4 days		$3,000
				G		9 days		$4,500			7 days		$6,300
		B. What is the most attractive candidate to crash:
		C. What is the second most attractive candidate to crash:
		D. What is the least attractive candidate to crash:
	4. Resource Loading
		Review resource-loading chart. Suppose that you can commit a maximum of eight resource hours per day.
			Note the close bracket represents the late finish date or if there is any float available for the task.
			Activity		1	2	3	4	5	8	9	10	11	12	15	16	17	18	19	22	23	24	25	26
			A		6	6	6	6	6 ]
			B							2	2	2	2					]
			C							4	4	4	4	4 ]
			D							3	3	3	3	3	]
			E												4	4	4	4	4 ]
			F												2	2	2	2	2	2				]
			G																		4	4	4	]
			Total:		6	6	6	6	6	9	9	9	9	7	6	6	6	6	6	2	4	4	4	0
		What days are project resources overallocated?
		How could you reconfigure to correct the overallocation?