Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

MICROSOFT PROJECT EXERCISE An aerospace company has received a contract from NAS

ID: 361238 • Letter: M

Question

MICROSOFT PROJECT EXERCISE

An aerospace company has received a contract from NASA for the final assembly of a space module for an upcoming mission. The Project Manager has identified two types of critical resources, engineers and technicians that are needed in the project. Following table lists the project tasks, their precedence relationships, durations, material cost and resource requirements. The indicated resources are needed for the duration of each ask.

For example 3 engineers and 7 technicians are needed during the 30 days of task time for Task A and a half time engineer and 1 technician are needed for the 30 days of task

duration for Task C.

Task Label

Task Definition

Duration (Days)

Predecessors

Material Cost

Engineers Required

Technicians Required

A

Construct Shell of Module

30

-

$35,000

3

7

B

Procure Life Support System and Experimentation Package

15

-

$50,000

0.5

0

C

Procure Components of Control and Navigational System

30

-

$80,000

0.5

1

D

Wire Module

3

A

$4,500

3

5

E

Assemble Control and Navigational System

7

C

$1,500

2

6

F

Preliminary Test of Life Support System

2

B

$1,500

1

3

G

Install Life Support in Module

5

D, F

$1,000

1

5

H

Install Experimentation Package in Module

3

D, F

$1,200

1

4

I

Preliminary Test of Control and Navigational System

4

E, F

$1,800

1

3

J

Install Control and Navigational System in Module

10

H, I

$3,000

2

6

K

Final Testing and Debugging

8

G, J

$4,800

2

5

Schedule the project from the project start date

Five engineers and 15 technicians are available for the duration of the project.

Engineers and technicians are paid at the rate of $100/hour and $35/hour, respectively.

Engineers’ and Technicians hourly rate will be increased to $135, and $45, respectively, in two months.

Task Label

Task Definition

Duration (Days)

Predecessors

Material Cost

Engineers Required

Technicians Required

A

Construct Shell of Module

30

-

$35,000

3

7

B

Procure Life Support System and Experimentation Package

15

-

$50,000

0.5

0

C

Procure Components of Control and Navigational System

30

-

$80,000

0.5

1

D

Wire Module

3

A

$4,500

3

5

E

Assemble Control and Navigational System

7

C

$1,500

2

6

F

Preliminary Test of Life Support System

2

B

$1,500

1

3

G

Install Life Support in Module

5

D, F

$1,000

1

5

H

Install Experimentation Package in Module

3

D, F

$1,200

1

4

I

Preliminary Test of Control and Navigational System

4

E, F

$1,800

1

3

J

Install Control and Navigational System in Module

10

H, I

$3,000

2

6

K

Final Testing and Debugging

8

G, J

$4,800

2

5

Explanation / Answer

Task Label Task Definition Duration (Days) Predecessors Material Cost Engineers Required Technicians Required ES EF Spare Eng Spare Tech A Construct Shell of Module 30 - 35000 3 7 0 30 2 8 B Procure Life Support System and Experimentation Package 15 - 50000 0.5 0 0 15 1.5 8 C Procure Components of Control and Navigational System 30 - 80000 0.5 1 0 30 1 7 D Wire Module 3 A 4500 3 5 30 33 2 10 E Assemble Control and Navigational System 7 C 1500 2 6 30 37 0 4 F Preliminary Test of Life Support System 2 B 1500 1 3 15 17 0 4 G Install Life Support in Module 5 D, F 1000 1 5 37 42 1 1 Only Step without Tech H Install Experimentation Package in Module 3 D, F 1200 1 4 33 36 1 0 I Preliminary Test of Control and Navigational System 4 E, F 1800 1 3 37 41 3 7 J Install Control and Navigational System in Module 10 H, I 3000 2 6 41 51 1 1 K Final Testing and Debugging 8 G, J 4800 2 5 51 59 3 10