Description
**You must have MS Project**
To prepare for this assignment, review the following videos from your Topic 7 Resources:
“Creating Work Overview Reports and Earned Value Reports in MS Project”
“Milestones, Baselining and Statusing a Project in MS Project”
Complete the Monitoring and Controlling exercise for the Technology Refresh Project. Utilize Topic 3 individual MS Project assignment collateral. Remember, you have been asked to refresh the GCU campus technology to include 300 desktop computers, 100 laptop computers, and 20 printers.
Complete a revision of your Topic 3 “Updated Project File” (i.e., MS Project file). Utilize the “Project Monitoring and Controlling Template,” specifically the “Execution Actual Duration” and “Revised Resource Rates” tabs, for the Technology Refresh Project.
Part 1:
Update all initiation and planning tasks as being 100% complete and to Planned Values.
Part 2:
Review the Topic 7 project information file for Execution Actual durations and use the Mark on Track (Update Task) function.
Procure hardware from suppliers
Obtain software OS licenses
Obtain software application licenses
Setup test area
Load software onto pilot machines
Validate functionality
Configure production hardware
Deploy production hardware
Load software to deployed hardware
Validate startup on deployed hardware
Perform OS testing
Perform application testing
Obtain formal sign-off from users
Accounting mistakes must be corrected.
Project Manager: $85 per hour
Software Engineer: $65 per hour
What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) and (TCPI) for the project?
Is the project ahead of schedule or behind schedule? Is the project under budget or over budget?
Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?
Use the SPI to estimate how long it will take to finish this project.
Part 3:
As the project management team, you need to analyze the data from Parts 1 and 2 of the assignment to assess the following.
Are there issues that need to be escalated?
Is it acceptable to do nothing and simply proceed?
Should the project be terminated?
Based on your evaluation of the threats to the project, how should you proceed?
Based upon the results of the data review, develop a status report for your project sponsor.
Submit the following completed files in a single zip folder, ensuring your last name is included in both filenames:
“Final Project File” (i.e., MS Project File).
“Project Monitoring and Controlling Information Template” (i.e., MS Excel file; MS Project screenshots included in the “Reports” tab).
Completed MS Word Memo, according to template directions that addresses the Part 3 questions
Unformatted Attachment Preview
MGT-640 Project Monitoring and Controlling Information Template
1) Check that your Topic 3 “Updated Project File” (i.e. MS Project file) Baseline is set correctly.
2) Utilize the status update function and update ALL Intitation and Planning tasks to be 100% complete and per Schedule.
3) Update the Execution tasks with the Actuals in next tab.
4) Revise the Project Manager and Software Engineer labor rates to fix prior accounting errors.
5) Add Baseline Duration and Baseline Cost columns to Gannt View.
6) Analyze the Project Overview Report, Cost Overview Report, and Earned Value Report.
7) Add CPI, SPI, TCPI columns to the Earned Value table and save with the reports.
8) Write a progress report to your Sponsor ( 2 pages in Business Memo format) add relevant tables and graphs.
complete and per Schedule.
ID
1
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Task
TECHNOLOGY REFRESH PROJECT
Executing
Hardware
Procure hardware from suppliers
Software
Obtain software OS licenses
Obtain software application licenses
Pilot Testing
Setup test area
Load software onto pilot machines
Validate functionality
Deployment
Configure production hardware
Deploy production hardware
Load software to deployed hardware
Testing
Validate startup on deployed hardware
Perform OS testing
Perform application testing
Obtain formal sign-off from users
Actual Duration (days)
Predecessor(s)
(ID)
Resource Assignments
16
36
Hardware Engineer
16
16
36
36
Software Engineer
Senior Software Engineer
4
3
7
40
45,46,48,43
49
Systems Test Engineer
Software Engineer
Software Test Engineer
23
17
23
26,50,67,63
52
53
Hardware Technician
Hardware Technician
Software Engineer
8
9
16
18
54
56
57
58
Software Test Engineer
Software Test Engineer
Systems Test Engineer
Project Manager
Project Manager
Work
Project Analyst
Work
Senior Hardware Engineer
Work
Hardware Engineer
Work
Hardware Technician
Work
Requirements Analyst
Work
Senior Software Engineer
Work
Software Engineer
Work
Software Test Engineer
Work
Senior Systems Test Engineer Work
Systems Test Engineer
Work
Contracts Analyst
Work
P
P
S
H
H
R
S
S
S
S
S
C
100% $65.00/hr
100% $35.00/hr
100% $55.00/hr
100% $45.00/hr
100% $35.00/hr
100% $35.00/hr
100% $55.00/hr
100% $45.00/hr
100% $45.00/hr
100% $55.00/hr
100% $40.00/hr
100% $30.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00/hr
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Prorated
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Standard
Note: PM rates are $85/hr.
Note: Software engineer rates are $65/hr.
Topic 3 “Updated Project File” Final Baseline Reports W
(Replace the following example screenshots with your own data.)
PROJECT OVERVIEW
COST OVERVIEW
EARNED VALUE
ine Reports With Topic 7 “Final Project File” Updates.
Purchase answer to see full
attachment
