Generate the critical path graph

Assignment Help Operation Management

Reference no: EM131931262

QM ASSIGNMENT

Part A

The Project Management Office for your company would like to see the critical path for your major milestones, as well as the earliest-latest starting and finishing times. Based on the project plan developed earlier in the project, the milestones, dependencies, and effort times are as follows:

Milestone	Predecessor	Efforts (Weeks)
A		4
B		6
C	A, B	7
D	B	8
E	B	5
F	C	5
G	D	7
H	D, E	8
I	F, G, H	4

Using Excel QM software (located in the Add-ins section or across the tool bar) and looking in the Project Management category (located in either the QM or Render links in Excel QM), select the Predecessor List (AON) link.

Fill in the data per the table above. Generate the critical path graph (by checking "Include the graph") when generating the appropriate matrix. This selection will also generate the earliest-latest starting and finishing times.

Copy the input table, resulting table, and critical path Gantt chart in to your team's Risk Management Plan under section 2.4.2 Quantitative Analysis - Excel QM.

Part B

The Project Management Office has received a decision from the senior leadership of your organization, to bring the project timeline in from the current 26 weeks (based on the information above). Your team has been asked to look at crashing the schedule to 14 weeks.

The Project Management Office would like to know if the schedule can be crashed to 14 weeks and what the cost would be to crash the schedule.

Using Excel QM software and looking in the Project Management category, choose the Crashing link. Fill in the data based on the 9 milestones from both tables (Part A and B). Copy the resulting table in to your team's Risk Management Plan in section 2.4.2 Quantitative Analysis - Excel QM after the results of Part A.

Note: you may need to add the Solver tool to Excel QM if you do not see it in the Data Analysis section of QM. To do this go to the main TOOLS menu in the top tool bar, click on Add-Ins, and then select Solver.

In addition to the information in Part A you have the following data:

Milestone	Crash Time (Weeks)	Normal Cost	Crash cost per week
A	1	$8,000	$1,500
B	2	$12,000	$1,500
C	3	$14,000	$2,000
D	4	$19,000	$3,000
E	2	$13,000	$1,000
F	3	$9,000	$500
G	2	$16,500	$2,000
H	4	$22,000	$3,000
I	2	$5,500	$500

Please note that the crash cost is a per week cost and the tool asks for total cost (normal and crash).

Reference no: EM131931262

Questions Cloud

Find one appropriate stock to replace these two : Assuming that you could find one appropriate stock to replace these two, what should be its beta?

Implement a message server in a distributed environment : Implement a message server in a distributed environment (i.e. between processes running on machines that are physically separate) by using BSD sockets.

Find the weight corresponding : Find the weight corresponding to t = 1, w1, in the definition of duration as a weighted average of the times at which the cash flows occur: D = 1*w1 + 2*w2.

Who is fernando sorrentino : Who is Fernando Sorrentino? Where and WHen was Fernando Sorrentino writing?

Generate the critical path graph : The Project Management Office would like to know if the schedule can be crashed to 14 weeks and what the cost would be to crash the schedule.

Nervous the stock has risen too high too fast : You’ve no reason to think the price will fall, but you’re nervous the stock has risen too high, too fast.

Draft an e-mail to your sales team : Draft an e-mail to your sales team at Explaining that the corporate office has decided to give all employees either two additional paid days off per year

The impact of globalization on the country mexico : The impact of globalization on the country "Mexico", giving specific attention to technological environment & its impact on different stakeholders.

User Account

All Pages