(solution) 5. Part B: Resource Planning 1. The resource requirements for

(solution) 5. Part B: Resource Planning 1. The resource requirements for

5. Part B: Resource Planning 1. The resource requirements for your team members for each project activity are listed in Table 5.2. Using Microsoft Project, determine whether you can meet the May 15 due date by using the resource leveling feature. Each team member is available to work on the project 12 hours per week, thus work week will need to be modified within your project model. There are six team members. The resource requirements represent the number of team members required for 12 hours per week. Again, provide the Gantt chart and input table with your answer (10 pts). 2. If the schedule provided in (1) does not meet the project due date, suggest changes in resource calendars and assignments that will allow you to meet the project due date. One team member has suggested that the team schedule an additional two hours on Saturday morning to work on the project. Will this be sufficient, or would you suggest additional changes? Provide a feasible schedule shown in a Gantt chart to justify your answer (10 pts).

Haluk Demirkan

5 of 6 2/15/2016

Table 5.1. Work Breakdown Structure, Activities, Durations, Sequence Activity Number Activity Duration Predecessor 0 Phoenix rollout, Bill Pay 1 Final Project Plan 1 wk – 2 Regulatory application & approval 3 Prepare application to state 1 wk 1 4 File with State Regulators 2 wk 3 5 Milestone: Obtain regulatory approval 2 hrs 4 6 Web Page Design 7 Prototype web page design 2 wk 1 8 Prototype security check 1 wk 1 9 Milestone: Prototype Approval 2 hrs 7,8 10 Local Market Survey 11 Survey Design .5 wk 1 12 Survey execution 2 wk 11 13 Analyze survey results 1.5 wk 12 14 Develop Marketing plan 2 wk 13 15 Final Page and System Design 16 Final design .5 wk 9,14 17 Code pages 2 wk 16 18 Systems test, final design 1 wk 17 19 Milestone: Final design approval 2 hrs 18 20 Web Site Security system 21 Final security analysis .5 wk 5,8 22 System security system dev. 2 wk 21 23 Approve final system 2 hrs 19,22 24 Implement production system .5 wk 23 25 Final integration and site test 26 Web site integration 2 wk 23 27 Test design .5 wk 26 28 Execute test 1 wk 27 29 Milestone: Rollout readiness review 2 hrs 28 30 Finalize Marketing Plan and Develop advertising campaign 31 Complete marketing plan 2 wk 14,19 32 Develop media plan .5 wk 14,19 33 Write content 2 wk 31,32 34 Design and release advertising to media 1 wk 33 35 Site Rollout 36 Begin media campaign 1 wk 34 37 Final preparation for website rollout 2 wk 29,24 38 Milestone: Approve Rollout 2 hrs 36,37

Haluk Demirkan

6 of 6 2/15/2016

Table 5.2. Resource Requirements

Activity Number Activity

Team members required 0 Phoenix rollout, Bill Pay 1 Final Project Plan 6 2 Regulatory application & approval 3 Prepare application to state 4 4 File with State Regulators 4 5 Obtain regulatory approval 6 6 Web Page Design 7 Prototype web page design 3 8 Prototype security check 3 9 Prototype Approval 6 10 Local Market Survey 11 Survey Design 4 12 Survey execution 2 13 Analyze survey results 3 14 Develop Marketing plan 2 15 Final Page and System Design 16 Final design 2 17 Code pages 6 18 Systems test, final design 3 19 Final design approval 6 20 Web Site Security system 21 Final security analysis 2 22 System security system dev. 2 23 Approve final system 6 24 Implement production system 3 25 Final integration and site test 26 Web site integration 3 27 Test design 2 28 Execute test 4 29 Rollout readiness review 6 30 Finalize Marketing Plan and Develop advertising campaign 31 Complete marketing plan 3 32 Develop media plan 4 33 Write content 2 34 Design and release advertising to media 2 35 Site Rollout 36 Begin Media campaign 2 37 Rollout website 2 38 Begin Bill Pay site operations 6

5. Part B: Resource Planning 1. The resource requirements for your team members for each project
activity are listed in Table 5.2. Using Microsoft Project, determine whether you can meet the May…