Team Project WBS Team B v2

Smart Study

team_project_gantt_chart.xlsx

Home >Reading homework help >Team Project WBS Team B v2

Sheet1

[Project Name]

Gantt Chart

Security Network Upgrade

Team B

Today's Date:

9/5/16

Monday

(vertical red line)

Jon: Work Breakdown Structure Level 1: 1, 2, 3, ... Level 2: 1.1, 1.2, 1.3, ... Level 3: 1.1.1, 1.1.2, 1.1.3, … The WBS is automatically entered, but the formulas are different for different levels.

Project Lead:

Team B

Jon: Duration (Calendar Days) Enter the number of calendar days for the given task. Refer to the Working Days column or use a calendar to determine the corresponding working days. The duration is from the beginning of the Start date to the ending of the End Date. When the duration is calculated, it is calculated as End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day.

Jon: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%).

Jon: Working Days Counts the number of working days using the NETWORKDAYS() formula, which excludes weekends. When planning work based upon the number of working days, adjust the Duration until the desired # of working days is reached.

Jon: Calendar Days Complete This column is calculated by multiplying the Duration by the %Complete and rounding down to the nearest integer.

Jon: Calendar Days Remaining This column is calculated by subtracting the Days Complete from the Duration.

Start Date:

9/5/16

Monday

[42]

First Day of Week (Mon=2):

12/29/14

12/30/14

12/31/14

1/1/15

1/2/15

1/3/15

1/4/15

1/5/15

1/6/15

1/7/15

1/8/15

1/9/15

1/10/15

1/11/15

1/12/15

1/13/15

1/14/15

1/15/15

1/16/15

1/17/15

1/18/15

1/19/15

1/20/15

1/21/15

1/22/15

1/23/15

1/24/15

1/25/15

1/26/15

1/27/15

1/28/15

1/29/15

1/30/15

1/31/15

2/1/15

2/2/15

2/3/15

2/4/15

2/5/15

2/6/15

2/7/15

2/8/15

2/9/15

2/10/15

2/11/15

2/12/15

2/13/15

2/14/15

2/15/15

2/16/15

2/17/15

2/18/15

2/19/15

2/20/15

2/21/15

2/22/15

2/23/15

2/24/15

2/25/15

2/26/15

2/27/15

2/28/15

3/1/15

3/2/15

3/3/15

3/4/15

3/5/15

3/6/15

3/7/15

3/8/15

3/9/15

3/10/15

3/11/15

3/12/15

3/13/15

3/14/15

3/15/15

3/16/15

3/17/15

3/18/15

3/19/15

3/20/15

3/21/15

3/22/15

3/23/15

3/24/15

3/25/15

3/26/15

3/27/15

3/28/15

3/29/15

3/30/15

3/31/15

4/1/15

4/2/15

4/3/15

4/4/15

4/5/15

4/6/15

4/7/15

4/8/15

4/9/15

4/10/15

4/11/15

4/12/15

4/13/15

4/14/15

4/15/15

4/16/15

4/17/15

4/18/15

4/19/15

4/20/15

4/21/15

4/22/15

4/23/15

4/24/15

4/25/15

4/26/15

4/27/15

4/28/15

4/29/15

4/30/15

5/1/15

5/2/15

5/3/15

5/4/15

5/5/15

5/6/15

5/7/15

5/8/15

5/9/15

5/10/15

5/11/15

5/12/15

5/13/15

5/14/15

5/15/15

5/16/15

5/17/15

5/18/15

5/19/15

5/20/15

5/21/15

5/22/15

5/23/15

5/24/15

5/25/15

5/26/15

5/27/15

5/28/15

5/29/15

5/30/15

5/31/15

6/1/15

6/2/15

6/3/15

6/4/15

6/5/15

6/6/15

6/7/15

6/8/15

6/9/15

6/10/15

6/11/15

6/12/15

6/13/15

6/14/15

6/15/15

6/16/15

6/17/15

6/18/15

6/19/15

6/20/15

6/21/15

6/22/15

6/23/15

6/24/15

6/25/15

6/26/15

6/27/15

6/28/15

6/29/15

6/30/15

7/1/15

7/2/15

7/3/15

7/4/15

7/5/15

7/6/15

7/7/15

7/8/15

7/9/15

7/10/15

7/11/15

7/12/15

7/13/15

7/14/15

7/15/15

7/16/15

7/17/15

7/18/15

7/19/15

7/20/15

7/21/15

7/22/15

7/23/15

7/24/15

7/25/15

7/26/15

7/27/15

7/28/15

7/29/15

7/30/15

7/31/15

8/1/15

8/2/15

8/3/15

8/4/15

8/5/15

8/6/15

8/7/15

8/8/15

8/9/15

8/10/15

8/11/15

8/12/15

8/13/15

8/14/15

8/15/15

8/16/15

8/17/15

8/18/15

8/19/15

8/20/15

8/21/15

8/22/15

8/23/15

WBS

Tasks

Start

End

Duration (Days)

% Complete

Working Days

Days Complete

Days Remaining

05 - Sep - 16

06 - Sep - 16

07 - Sep - 16

08 - Sep - 16

09 - Sep - 16

10 - Sep - 16

11 - Sep - 16

12 - Sep - 16

13 - Sep - 16

14 - Sep - 16

15 - Sep - 16

16 - Sep - 16

17 - Sep - 16

Task Lead

Security Network Upgrade

Team B

9/5/16

9/17/16

Meet and Create Schedule

Team B

9/5/16

9/6/16

Meet and Create Schedule

2.1

Office Managers Meeting for Discussion

9/5/16

2.1

2.2

Create and Submit Security Upgrade

9/6/16

2.2

2.3

Approve schedule

9/6/16

2.3

Receive New Security Software

Team B

9/7/16

9/10/16

50%

Receive New Securty Software

3.1

Purchase New Software

9/7/16

50%

3.1

3.2

Ensure Hardware is sufficient

9/7/16

50%

3.2

3.3

Purchase Accessories

9/8/16

50%

3.3

3.4

Prepare for Hardwasre installation

9/9/16

9/10/16

3.4

Back Up Data

Team B

9/11/16

9/13/16

Back Up Data

4.1

Back Up shared Drives & Files

9/11/16

4.1

4.2

Back Up User Data

9/12/16

4.2

4.3

Ensure Back Up Was Successful

9/13/16

4.3

Install and configure

Team B

9/14/16

9/17/16

Install and configure

5.1

Set Up Security Software

9/14/16

5.1

5.2

Set Up Firewals

9/15/16

5.2

5.3

Create Passwords and Acces Rules

9/16/16

5.3

5.4

Individual Security Settings

9/17/16

5.4

Final

Network Upgrade Ready

Final