Management Construct MS Project plan

Problem 1
Construct MS Project plan for the project below. Project starting date is September 14, 2014 (using standard calendar)
Activities    Duration    Predecessors    Resource    Normal Time    Min Time    Cost – Normal Time    Cost – Min Time    Crash Cost per Day
A    10 days        X (100%)    10    9    $500    $800    $300
B    11 days    A    X (100%)    11    9    $1,000    $1,800    $400
C    10 days    A    Y (100%)    10    9    $2,000    $2,700    $700
D    11 days    A    X (100%), Y (100%)    11    9    $1,000    $1,900    $450
E    6 days    B,C,D    Z (100%)    6    5    $1,600    $2,200    $600
F    9 days    E    X (100%), Y (100%)    9    7    $1,500    $3,300    $900
G    8 days    E    X (100%)    8    6    $600    $1,800    $600
H    10 days    F,G    Z (100%)    10    9    $1,600    $2,400    $800

1.    What is the project duration

2.    What is the project finish date

3.    List the Critical Path(s)

4.    Fill the following table.
Activity    ES    EF    LS    LF    F. Slack    T. Slack
C
E
G

5.    Key in resource usage information. Does Resource X over allocated? If so, from what date to what date?

6.    List the crashing cost for this project (choose the activity to crash based on lowest crashing cost).

Total Crashing Date    1 Day    2 Days    3 Days    4 Days
Cost

7.    If the company has $1,400 extra resources put into this project, what is the new project duration?

Construct a NEW MS Project plan for the project below. Project starting date is October 31, 2014 (using standard calendar)
Activities    Duration    Predecessors    Resource    % Complete    Actual Cost
1.    Preparation Phase
1.1 A    11 days        X (80 Hours)    100%    $920
1.2 B    6 days    A    X (40 Hours)    100%    $450
1.3 C    5 days    A    Y (40 Hours)    100%    $600
2.    Installation Phase
2.1 D    12 days    B,C    X (50 Hours), Y (60 Hours)    100%    $1,500
2.2 E    9 days    D    Z (70 Hours)    100%    $1,600
2.3 F    8 days    E    X (60 Hours), Y (70 Hours)
3.    Testing Phase
3.1 G    8 days    E    X (40 Hours)
3.2 H    10 days    F,G    Z (100 Hours)

Resource Name    Max    Rate    Overtime Rate
X    100%    $10 / Hour    $15 / Hour
Y    100%    $15 / Hour    $20 / Hour
Z    100%    $20 / Hour    $25 / Hour

8.    Create the WBS format and key in resource usage information, activities’ % completes and actual costs. Do NOT leveling resources (let resources working overtime).Answer the following questions

a)    What is the % complete for the Installation Phase summary task?
b)    What is the % complete for the total project summary task?
c)    What is the remaining work for the project?
d)    What is the remaining duration for the project?
e)    What is the planned cost for “Activity 2.2 E”?

9.    What are your values for the following?
a)    Planned Value (PV) =
b)    Earned Value (EV) =
c)    Actual Cost (AC) =

10.    Calculate the Schedule Performance Index and Estimated Time to Finish.

11.    Calculate the Cost Performance Index and Estimated Cost to Finish.