Info Tech Project/Team Management
tiffanymac2001
Milestone4Example.pdf
i. To: CEO, CIO, Wellness Works Project Representative
ii. CC: Project team iii. From: Patrick Connolly iiii. Subject: Scope, Cost, and Quality Planning Report
v. Date: 30 July 2017
2. IT 625 – Project Milestone 4 Monday, July 31, 2017
3. Project Scope Planning
a. Business Requirements Requirements Traceability Matrix
Project Name: Wellness Vendor Project
Project Number: V1 Project Manager: Patrick Connolly
Task ID RequirementNumber Requirement Description Status Release Test Case
Design Component
/ Module Comments
14 1.1 SSRS deployment server
Complete
V1
Test Case #1: Operational SRSS Deployment server
Verify that the SRSS server is installed, configured per requirements and operational.
i. To: CEO, CIO, Wellness Works Project Representative
ii. CC: Project team iii. From: Patrick Connolly iiii. Subject: Scope, Cost, and Quality Planning Report
v. Date: 30 July 2017
2. IT 625 – Project Milestone 4 Monday, July 31, 2017
3. Project Scope Planning
a. Business Requirements Requirements Traceability Matrix
Project Name: Wellness Vendor Project
Project Number: V1 Project Manager: Patrick Connolly
Task ID RequirementNumber Requirement Description Status Release Test Case
Design Component
/ Module Comments
14 1.1 SSRS deployment server
Complete
V1
Test Case #1: Operational SRSS Deployment server
Verify that the SRSS server is installed, configured per requirements and operational.
i. To: CEO, CIO, Wellness Works Project Representative
ii. CC: Project team iii. From: Patrick Connolly iiii. Subject: Scope, Cost, and Quality Planning Report
v. Date: 30 July 2017
2. IT 625 – Project Milestone 4 Monday, July 31, 2017
3. Project Scope Planning
a. Business Requirements Requirements Traceability Matrix
Project Name: Wellness Vendor Project
Project Number: V1 Project Manager: Patrick Connolly
Task ID RequirementNumber Requirement Description Status Release Test Case
Design Component
/ Module Comments
14 1.1 SSRS deployment server
Complete
V1
Test Case #1: Operational SRSS Deployment server
Verify that the SRSS server is installed, configured per requirements and operational.
i. To: CEO, CIO, Wellness Works Project Representative
ii. CC: Project team iii. From: Patrick Connolly iiii. Subject: Scope, Cost, and Quality Planning Report
v. Date: 30 July 2017
2. IT 625 – Project Milestone 4 Monday, July 31, 2017
3. Project Scope Planning
a. Business Requirements Requirements Traceability Matrix
Project Name: Wellness Vendor Project
Project Number: V1 Project Manager: Patrick Connolly
Task ID RequirementNumber Requirement Description Status Release Test Case
Design Component
/ Module Comments
14 1.1 SSRS deployment server
Complete
V1
Test Case #1: Operational SRSS Deployment server
Verify that the SRSS server is installed, configured per requirements and operational.
docx.docx.pdf Saved to Dropbox • Jun 13, 2018 at 8;16 PM
14 1.2 MS Visual Studio 2008 Shell
Complete
V1
Test Case #2: Installed & Operational Visual Studio
Verify that everyone has a Visual Studio installed and configured identically
14 1.3
SQL Server Business Intelligence Development Studio Complete
V1 Test Case #3:BI Dev Studio
Verify that everyone has a BI Dev Studio installed and configured identically
14 1.4 SQL Server Management Studio
Complete
V1 Test Case #4: Management Studio
Verify that everyone has a Management Studio installed and configured identically
42 2.1 MS SQLServer 2008 R2
Complete
V1
Test Case #5: Operational SQL Database with all required tables
This database will control authentication and report parameter selection
24 2.2 MS SQLServer 2008 R2 Open V1
Test Case #6: User authentication
Users can athenticate
42-44 2.3 MS SQLServer 2008 R2 Open V1
Test Case #7: Parameter selection
Users can retreive and select report parameter.
16-24 2.4 Teradata 14
Complete
V1
Test Case #8: Operational database with all required tables.
Validate that all required tables are there and that vendor data can be pupulated.
27,30,33 3.1 Import Chip Reward vendor data
Complete
V1
Test Case #9: Chip Reward scheduled import
Verify that weekly data import from Chip Rewards auto- starts and that all the data is imported into the correct tables.
27,30,33 3.2 Import Spirevendor data
Complete
V1
Test Case #10: Spire scheduled imprort
Verify that weekly data import from Spire auto-starts and that all the data is imported into the correct tables.
27,30,33 3.3 Import MDLive vendor data
Complete
V1
Test Case #11: MDLive scheduled imports
Verify that Monthly data import from MDLive auto- starts and that all the data is imported into the correct tables.
14 1.2 MS Visual Studio 2008 Shell
Complete
V1
Test Case #2: Installed & Operational Visual Studio
Verify that everyone has a Visual Studio installed and configured identically
14 1.3
SQL Server Business Intelligence Development Studio Complete
V1 Test Case #3:BI Dev Studio
Verify that everyone has a BI Dev Studio installed and configured identically
14 1.4 SQL Server Management Studio
Complete
V1 Test Case #4: Management Studio
Verify that everyone has a Management Studio installed and configured identically
42 2.1 MS SQLServer 2008 R2
Complete
V1
Test Case #5: Operational SQL Database with all required tables
This database will control authentication and report parameter selection
24 2.2 MS SQLServer 2008 R2 Open V1
Test Case #6: User authentication
Users can athenticate
42-44 2.3 MS SQLServer 2008 R2 Open V1
Test Case #7: Parameter selection
Users can retreive and select report parameter.
16-24 2.4 Teradata 14
Complete
V1
Test Case #8: Operational database with all required tables.
Validate that all required tables are there and that vendor data can be pupulated.
27,30,33 3.1 Import Chip Reward vendor data
Complete
V1
Test Case #9: Chip Reward scheduled import
Verify that weekly data import from Chip Rewards auto- starts and that all the data is imported into the correct tables.
27,30,33 3.2 Import Spirevendor data
Complete
V1
Test Case #10: Spire scheduled imprort
Verify that weekly data import from Spire auto-starts and that all the data is imported into the correct tables.
27,30,33 3.3 Import MDLive vendor data
Complete
V1
Test Case #11: MDLive scheduled imports
Verify that Monthly data import from MDLive auto- starts and that all the data is imported into the correct tables.
14 1.2 MS Visual Studio 2008 Shell
Complete
V1
Test Case #2: Installed & Operational Visual Studio
Verify that everyone has a Visual Studio installed and configured identically
14 1.3
SQL Server Business Intelligence Development Studio Complete
V1 Test Case #3:BI Dev Studio
Verify that everyone has a BI Dev Studio installed and configured identically
14 1.4 SQL Server Management Studio
Complete
V1 Test Case #4: Management Studio
Verify that everyone has a Management Studio installed and configured identically
42 2.1 MS SQLServer 2008 R2
Complete
V1
Test Case #5: Operational SQL Database with all required tables
This database will control authentication and report parameter selection
24 2.2 MS SQLServer 2008 R2 Open V1
Test Case #6: User authentication
Users can athenticate
42-44 2.3 MS SQLServer 2008 R2 Open V1
Test Case #7: Parameter selection
Users can retreive and select report parameter.
16-24 2.4 Teradata 14
Complete
V1
Test Case #8: Operational database with all required tables.
Validate that all required tables are there and that vendor data can be pupulated.
27,30,33 3.1 Import Chip Reward vendor data
Complete
V1
Test Case #9: Chip Reward scheduled import
Verify that weekly data import from Chip Rewards auto- starts and that all the data is imported into the correct tables.
27,30,33 3.2 Import Spirevendor data
Complete
V1
Test Case #10: Spire scheduled imprort
Verify that weekly data import from Spire auto-starts and that all the data is imported into the correct tables.
27,30,33 3.3 Import MDLive vendor data
Complete
V1
Test Case #11: MDLive scheduled imports
Verify that Monthly data import from MDLive auto- starts and that all the data is imported into the correct tables.
14 1.2 MS Visual Studio 2008 Shell
Complete
V1
Test Case #2: Installed & Operational Visual Studio
Verify that everyone has a Visual Studio installed and configured identically
14 1.3
SQL Server Business Intelligence Development Studio Complete
V1 Test Case #3:BI Dev Studio
Verify that everyone has a BI Dev Studio installed and configured identically
14 1.4 SQL Server Management Studio
Complete
V1 Test Case #4: Management Studio
Verify that everyone has a Management Studio installed and configured identically
42 2.1 MS SQLServer 2008 R2
Complete
V1
Test Case #5: Operational SQL Database with all required tables
This database will control authentication and report parameter selection
24 2.2 MS SQLServer 2008 R2 Open V1
Test Case #6: User authentication
Users can athenticate
42-44 2.3 MS SQLServer 2008 R2 Open V1
Test Case #7: Parameter selection
Users can retreive and select report parameter.
16-24 2.4 Teradata 14
Complete
V1
Test Case #8: Operational database with all required tables.
Validate that all required tables are there and that vendor data can be pupulated.
27,30,33 3.1 Import Chip Reward vendor data
Complete
V1
Test Case #9: Chip Reward scheduled import
Verify that weekly data import from Chip Rewards auto- starts and that all the data is imported into the correct tables.
27,30,33 3.2 Import Spirevendor data
Complete
V1
Test Case #10: Spire scheduled imprort
Verify that weekly data import from Spire auto-starts and that all the data is imported into the correct tables.
27,30,33 3.3 Import MDLive vendor data
Complete
V1
Test Case #11: MDLive scheduled imports
Verify that Monthly data import from MDLive auto- starts and that all the data is imported into the correct tables.
14 1.2 MS Visual Studio 2008 Shell
Complete
V1
Test Case #2: Installed & Operational Visual Studio
Verify that everyone has a Visual Studio installed and configured identically
14 1.3
SQL Server Business Intelligence Development Studio Complete
V1 Test Case #3:BI Dev Studio
Verify that everyone has a BI Dev Studio installed and configured identically
14 1.4 SQL Server Management Studio
Complete
V1 Test Case #4: Management Studio
Verify that everyone has a Management Studio installed and configured identically
42 2.1 MS SQLServer 2008 R2
Complete
V1
Test Case #5: Operational SQL Database with all required tables
This database will control authentication and report parameter selection
24 2.2 MS SQLServer 2008 R2 Open V1
Test Case #6: User authentication
Users can athenticate
42-44 2.3 MS SQLServer 2008 R2 Open V1
Test Case #7: Parameter selection
Users can retreive and select report parameter.
16-24 2.4 Teradata 14
Complete
V1
Test Case #8: Operational database with all required tables.
Validate that all required tables are there and that vendor data can be pupulated.
27,30,33 3.1 Import Chip Reward vendor data
Complete
V1
Test Case #9: Chip Reward scheduled import
Verify that weekly data import from Chip Rewards auto- starts and that all the data is imported into the correct tables.
27,30,33 3.2 Import Spirevendor data
Complete
V1
Test Case #10: Spire scheduled imprort
Verify that weekly data import from Spire auto-starts and that all the data is imported into the correct tables.
27,30,33 3.3 Import MDLive vendor data
Complete
V1
Test Case #11: MDLive scheduled imports
Verify that Monthly data import from MDLive auto- starts and that all the data is imported into the correct tables.
14 1.2 MS Visual Studio 2008 Shell
Complete
V1
Test Case #2: Installed & Operational Visual Studio
Verify that everyone has a Visual Studio installed and configured identically
14 1.3
SQL Server Business Intelligence Development Studio Complete
V1 Test Case #3:BI Dev Studio
Verify that everyone has a BI Dev Studio installed and configured identically
14 1.4 SQL Server Management Studio
Complete
V1 Test Case #4: Management Studio
Verify that everyone has a Management Studio installed and configured identically
42 2.1 MS SQLServer 2008 R2
Complete
V1
Test Case #5: Operational SQL Database with all required tables
This database will control authentication and report parameter selection
24 2.2 MS SQLServer 2008 R2 Open V1
Test Case #6: User authentication
Users can athenticate
42-44 2.3 MS SQLServer 2008 R2 Open V1
Test Case #7: Parameter selection
Users can retreive and select report parameter.
16-24 2.4 Teradata 14
Complete
V1
Test Case #8: Operational database with all required tables.
Validate that all required tables are there and that vendor data can be pupulated.
27,30,33 3.1 Import Chip Reward vendor data
Complete
V1
Test Case #9: Chip Reward scheduled import
Verify that weekly data import from Chip Rewards auto- starts and that all the data is imported into the correct tables.
27,30,33 3.2 Import Spirevendor data
Complete
V1
Test Case #10: Spire scheduled imprort
Verify that weekly data import from Spire auto-starts and that all the data is imported into the correct tables.
27,30,33 3.3 Import MDLive vendor data
Complete
V1
Test Case #11: MDLive scheduled imports
Verify that Monthly data import from MDLive auto- starts and that all the data is imported into the correct tables.
27,30,33 4.1
Generate Report in SQL Server Reporting Services (SSRS) based on user- selected parameters. Open
V1 Test Case #12: Report Generation
Verify that reports are generated based on the parameters that are selected. Verify that all the correct information is in the report.
42- 44,48 4.2
Display the new wellness vendor reports withing the existing application Open
V1 Test Case #13
Verify that the new reports are displayed correctly within the existing application.
42- 44,48 4.3
Export reports in Excel 97- 2003 (XLS) format
Open
V1 Test Case #14: Export to XLS
Verify that each report can be successfully exported to XLS and that each report contains user friendly headers instead of database column names
42- 44,48 4.4
Export reports in Portable Document Format (PDF) format
Open
V1 Test Case #15: Export to PDF
Verify that each report can be successfully exported to PDF and that each report contains user friendly headers instead of database column names
42- 44,48 4.5
Export reports in Comma Separated Value (CSV) format
Open
V1 Test Case #16: Export to CSV
Verify that each report can be successfully exported to CSV and that each report contains user friendly headers instead of database column names
b. Existing Work Breakdown Schedule (WBS)
27,30,33 4.1
Generate Report in SQL Server Reporting Services (SSRS) based on user- selected parameters. Open
V1 Test Case #12: Report Generation
Verify that reports are generated based on the parameters that are selected. Verify that all the correct information is in the report.
42- 44,48 4.2
Display the new wellness vendor reports withing the existing application Open
V1 Test Case #13
Verify that the new reports are displayed correctly within the existing application.
42- 44,48 4.3
Export reports in Excel 97- 2003 (XLS) format
Open
V1 Test Case #14: Export to XLS
Verify that each report can be successfully exported to XLS and that each report contains user friendly headers instead of database column names
42- 44,48 4.4
Export reports in Portable Document Format (PDF) format
Open
V1 Test Case #15: Export to PDF
Verify that each report can be successfully exported to PDF and that each report contains user friendly headers instead of database column names
42- 44,48 4.5
Export reports in Comma Separated Value (CSV) format
Open
V1 Test Case #16: Export to CSV
Verify that each report can be successfully exported to CSV and that each report contains user friendly headers instead of database column names
b. Existing Work Breakdown Schedule (WBS)
27,30,33 4.1
Generate Report in SQL Server Reporting Services (SSRS) based on user- selected parameters. Open
V1 Test Case #12: Report Generation
Verify that reports are generated based on the parameters that are selected. Verify that all the correct information is in the report.
42- 44,48 4.2
Display the new wellness vendor reports withing the existing application Open
V1 Test Case #13
Verify that the new reports are displayed correctly within the existing application.
42- 44,48 4.3
Export reports in Excel 97- 2003 (XLS) format
Open
V1 Test Case #14: Export to XLS
Verify that each report can be successfully exported to XLS and that each report contains user friendly headers instead of database column names
42- 44,48 4.4
Export reports in Portable Document Format (PDF) format
Open
V1 Test Case #15: Export to PDF
Verify that each report can be successfully exported to PDF and that each report contains user friendly headers instead of database column names
42- 44,48 4.5
Export reports in Comma Separated Value (CSV) format
Open
V1 Test Case #16: Export to CSV
Verify that each report can be successfully exported to CSV and that each report contains user friendly headers instead of database column names
b. Existing Work Breakdown Schedule (WBS)
27,30,33 4.1
Generate Report in SQL Server Reporting Services (SSRS) based on user- selected parameters. Open
V1 Test Case #12: Report Generation
Verify that reports are generated based on the parameters that are selected. Verify that all the correct information is in the report.
42- 44,48 4.2
Display the new wellness vendor reports withing the existing application Open
V1 Test Case #13
Verify that the new reports are displayed correctly within the existing application.
42- 44,48 4.3
Export reports in Excel 97- 2003 (XLS) format
Open
V1 Test Case #14: Export to XLS
Verify that each report can be successfully exported to XLS and that each report contains user friendly headers instead of database column names
42- 44,48 4.4
Export reports in Portable Document Format (PDF) format
Open
V1 Test Case #15: Export to PDF
Verify that each report can be successfully exported to PDF and that each report contains user friendly headers instead of database column names
42- 44,48 4.5
Export reports in Comma Separated Value (CSV) format
Open
V1 Test Case #16: Export to CSV
Verify that each report can be successfully exported to CSV and that each report contains user friendly headers instead of database column names
b. Existing Work Breakdown Schedule (WBS)
c. IT 625 – Project Milestone 4 Monday, July 31, 2017
d. Responsibility Assignment Matrix
Responsibility Assignment Matrix
Project Manag
er
IS Manag
er
Busine ss
Owner
Busine ss
Analyst
Report Developers
ETL Developers
Archi tect
Quality Assura
nce
Subject Matter Expert
Databa se
Admini strator
Develo per
Cuns ultant
Task ID Task Name
Patrick Connol
ly
Waltra ud
Tatem
Brant Amero
Kevin Smith
Roy Kirk
Corri na
Kees
Rohn Laqu anda
Joan Will mon
Trey Matti
a
Ellena Borel
Ricarda Sienkie
wicz
Walton Almed
a
Jacqual ine
Water
Jame s
Smit h
3 Budget dollarservice request X
4 Project Charter X
5 ObtainApprovals X
7 Project Plan X
8 Resource allocation approvals
X
10 Develop Communication Plan
X
11 Review/Approve Communication Plan
X X
12 Project Kickoff X X X X X X X X X X X X X X
14 Technical Support for Dev Environment
X
17 Create/Modify vendor database tables
X
18 Promote tablesto QA X
19 Validate tables X 20 UAT X
22 Create production ticket SR#
X
23 Deploy Tables X 24 Validate Tables X
26 Module 1 codereview X
27 Validate dataaccuracy X
c. IT 625 – Project Milestone 4 Monday, July 31, 2017
d. Responsibility Assignment Matrix
Responsibility Assignment Matrix
Project Manag
er
IS Manag
er
Busine ss
Owner
Busine ss
Analyst
Report Developers
ETL Developers
Archi tect
Quality Assura
nce
Subject Matter Expert
Databa se
Admini strator
Develo per
Cuns ultant
Task ID Task Name
Patrick Connol
ly
Waltra ud
Tatem
Brant Amero
Kevin Smith
Roy Kirk
Corri na
Kees
Rohn Laqu anda
Joan Will mon
Trey Matti
a
Ellena Borel
Ricarda Sienkie
wicz
Walton Almed
a
Jacqual ine
Water
Jame s
Smit h
3 Budget dollarservice request X
4 Project Charter X
5 ObtainApprovals X
7 Project Plan X
8 Resource allocation approvals
X
10 Develop Communication Plan
X
11 Review/Approve Communication Plan
X X
12 Project Kickoff X X X X X X X X X X X X X X
14 Technical Support for Dev Environment
X
17 Create/Modify vendor database tables
X
18 Promote tablesto QA X
19 Validate tables X 20 UAT X
22 Create production ticket SR#
X
23 Deploy Tables X 24 Validate Tables X
26 Module 1 codereview X
27 Validate dataaccuracy X
c. IT 625 – Project Milestone 4 Monday, July 31, 2017
d. Responsibility Assignment Matrix
Responsibility Assignment Matrix
Project Manag
er
IS Manag
er
Busine ss
Owner
Busine ss
Analyst
Report Developers
ETL Developers
Archi tect
Quality Assura
nce
Subject Matter Expert
Databa se
Admini strator
Develo per
Cuns ultant
Task ID Task Name
Patrick Connol
ly
Waltra ud
Tatem
Brant Amero
Kevin Smith
Roy Kirk
Corri na
Kees
Rohn Laqu anda
Joan Will mon
Trey Matti
a
Ellena Borel
Ricarda Sienkie
wicz
Walton Almed
a
Jacqual ine
Water
Jame s
Smit h
3 Budget dollarservice request X
4 Project Charter X
5 ObtainApprovals X
7 Project Plan X
8 Resource allocation approvals
X
10 Develop Communication Plan
X
11 Review/Approve Communication Plan
X X
12 Project Kickoff X X X X X X X X X X X X X X
14 Technical Support for Dev Environment
X
17 Create/Modify vendor database tables
X
18 Promote tablesto QA X
19 Validate tables X 20 UAT X
22 Create production ticket SR#
X
23 Deploy Tables X 24 Validate Tables X
26 Module 1 codereview X
27 Validate dataaccuracy X
c. IT 625 – Project Milestone 4 Monday, July 31, 2017
d. Responsibility Assignment Matrix
Responsibility Assignment Matrix
Project Manag
er
IS Manag
er
Busine ss
Owner
Busine ss
Analyst
Report Developers
ETL Developers
Archi tect
Quality Assura
nce
Subject Matter Expert
Databa se
Admini strator
Develo per
Cuns ultant
Task ID Task Name
Patrick Connol
ly
Waltra ud
Tatem
Brant Amero
Kevin Smith
Roy Kirk
Corri na
Kees
Rohn Laqu anda
Joan Will mon
Trey Matti
a
Ellena Borel
Ricarda Sienkie
wicz
Walton Almed
a
Jacqual ine
Water
Jame s
Smit h
3 Budget dollarservice request X
4 Project Charter X
5 ObtainApprovals X
7 Project Plan X
8 Resource allocation approvals
X
10 Develop Communication Plan
X
11 Review/Approve Communication Plan
X X
12 Project Kickoff X X X X X X X X X X X X X X
14 Technical Support for Dev Environment
X
17 Create/Modify vendor database tables
X
18 Promote tablesto QA X
19 Validate tables X 20 UAT X
22 Create production ticket SR#
X
23 Deploy Tables X 24 Validate Tables X
26 Module 1 codereview X
27 Validate dataaccuracy X
c. IT 625 – Project Milestone 4 Monday, July 31, 2017
d. Responsibility Assignment Matrix
Responsibility Assignment Matrix
Project Manag
er
IS Manag
er
Busine ss
Owner
Busine ss
Analyst
Report Developers
ETL Developers
Archi tect
Quality Assura
nce
Subject Matter Expert
Databa se
Admini strator
Develo per
Cuns ultant
Task ID Task Name
Patrick Connol
ly
Waltra ud
Tatem
Brant Amero
Kevin Smith
Roy Kirk
Corri na
Kees
Rohn Laqu anda
Joan Will mon
Trey Matti
a
Ellena Borel
Ricarda Sienkie
wicz
Walton Almed
a
Jacqual ine
Water
Jame s
Smit h
3 Budget dollarservice request X
4 Project Charter X
5 ObtainApprovals X
7 Project Plan X
8 Resource allocation approvals
X
10 Develop Communication Plan
X
11 Review/Approve Communication Plan
X X
12 Project Kickoff X X X X X X X X X X X X X X
14 Technical Support for Dev Environment
X
17 Create/Modify vendor database tables
X
18 Promote tablesto QA X
19 Validate tables X 20 UAT X
22 Create production ticket SR#
X
23 Deploy Tables X 24 Validate Tables X
26 Module 1 codereview X
27 Validate dataaccuracy X
c. IT 625 – Project Milestone 4 Monday, July 31, 2017
d. Responsibility Assignment Matrix
Responsibility Assignment Matrix
Project Manag
er
IS Manag
er
Busine ss
Owner
Busine ss
Analyst
Report Developers
ETL Developers
Archi tect
Quality Assura
nce
Subject Matter Expert
Databa se
Admini strator
Develo per
Cuns ultant
Task ID Task Name
Patrick Connol
ly
Waltra ud
Tatem
Brant Amero
Kevin Smith
Roy Kirk
Corri na
Kees
Rohn Laqu anda
Joan Will mon
Trey Matti
a
Ellena Borel
Ricarda Sienkie
wicz
Walton Almed
a
Jacqual ine
Water
Jame s
Smit h
3 Budget dollarservice request X
4 Project Charter X
5 ObtainApprovals X
7 Project Plan X
8 Resource allocation approvals
X
10 Develop Communication Plan
X
11 Review/Approve Communication Plan
X X
12 Project Kickoff X X X X X X X X X X X X X X
14 Technical Support for Dev Environment
X
17 Create/Modify vendor database tables
X
18 Promote tablesto QA X
19 Validate tables X 20 UAT X
22 Create production ticket SR#
X
23 Deploy Tables X 24 Validate Tables X
26 Module 1 codereview X
27 Validate dataaccuracy X
29 Module 2 codereview X
30 Validate dataaccuracy X
32 Module 3 codereview X X X X X X X X X X X X X X
33 Validate dataaccuracy X
36 Define BusinessRules X X
37 Data Mapping X X 38 Report mockups X X
39 Documentation and Current Mockup Layouts
X X
42 Report file layout data mapping
X
43 Report UAT X
44
Reports Approved by Business Owner/Vendor
X X
46 Test CaseCreation X
47 Test CaseExecution X
48 Deploy Reportsto Production X
50 Testing Support X X X X 51 Remediation X X X X
52 ProductionSupport X X X X
54 Project Manager X 55 Architect X
61 Define SupportProcess X
62 Review SupportProcess X
63 Support ProcessApproved X X
65 Lessons Learned X
i. IT 625 – Project Milestone 4 Monday, July 31, 2017
4. Project Cost Planning and Control
a. Cost-Benefit analysis: The cost-benefit analysis is a subjective process where you compare the cost and benefits of a project against its alternatives i.e. not doing the project (Rouse, 2011). We know that the project is going to cost $649,980.00 and that it will take 3.18 years to break even based on the estimated cash flow over the next 6 years.
29 Module 2 codereview X
30 Validate dataaccuracy X
32 Module 3 codereview X X X X X X X X X X X X X X
33 Validate dataaccuracy X
36 Define BusinessRules X X
37 Data Mapping X X 38 Report mockups X X
39 Documentation and Current Mockup Layouts
X X
42 Report file layout data mapping
X
43 Report UAT X
44
Reports Approved by Business Owner/Vendor
X X
46 Test CaseCreation X
47 Test CaseExecution X
48 Deploy Reportsto Production X
50 Testing Support X X X X 51 Remediation X X X X
52 ProductionSupport X X X X
54 Project Manager X 55 Architect X
61 Define SupportProcess X
62 Review SupportProcess X
63 Support ProcessApproved X X
65 Lessons Learned X
i. IT 625 – Project Milestone 4 Monday, July 31, 2017
4. Project Cost Planning and Control
a. Cost-Benefit analysis: The cost-benefit analysis is a subjective process where you compare the cost and benefits of a project against its alternatives i.e. not doing the project (Rouse, 2011). We know that the project is going to cost $649,980.00 and that it will take 3.18 years to break even based on the estimated cash flow over the next 6 years.
29 Module 2 codereview X
30 Validate dataaccuracy X
32 Module 3 codereview X X X X X X X X X X X X X X
33 Validate dataaccuracy X
36 Define BusinessRules X X
37 Data Mapping X X 38 Report mockups X X
39 Documentation and Current Mockup Layouts
X X
42 Report file layout data mapping
X
43 Report UAT X
44
Reports Approved by Business Owner/Vendor
X X
46 Test CaseCreation X
47 Test CaseExecution X
48 Deploy Reportsto Production X
50 Testing Support X X X X 51 Remediation X X X X
52 ProductionSupport X X X X
54 Project Manager X 55 Architect X
61 Define SupportProcess X
62 Review SupportProcess X
63 Support ProcessApproved X X
65 Lessons Learned X
i. IT 625 – Project Milestone 4 Monday, July 31, 2017
4. Project Cost Planning and Control
a. Cost-Benefit analysis: The cost-benefit analysis is a subjective process where you compare the cost and benefits of a project against its alternatives i.e. not doing the project (Rouse, 2011). We know that the project is going to cost $649,980.00 and that it will take 3.18 years to break even based on the estimated cash flow over the next 6 years.
29 Module 2 codereview X
30 Validate dataaccuracy X
32 Module 3 codereview X X X X X X X X X X X X X X
33 Validate dataaccuracy X
36 Define BusinessRules X X
37 Data Mapping X X 38 Report mockups X X
39 Documentation and Current Mockup Layouts
X X
42 Report file layout data mapping
X
43 Report UAT X
44
Reports Approved by Business Owner/Vendor
X X
46 Test CaseCreation X
47 Test CaseExecution X
48 Deploy Reportsto Production X
50 Testing Support X X X X 51 Remediation X X X X
52 ProductionSupport X X X X
54 Project Manager X 55 Architect X
61 Define SupportProcess X
62 Review SupportProcess X
63 Support ProcessApproved X X
65 Lessons Learned X
i. IT 625 – Project Milestone 4 Monday, July 31, 2017
4. Project Cost Planning and Control
a. Cost-Benefit analysis: The cost-benefit analysis is a subjective process where you compare the cost and benefits of a project against its alternatives i.e. not doing the project (Rouse, 2011). We know that the project is going to cost $649,980.00 and that it will take 3.18 years to break even based on the estimated cash flow over the next 6 years.
cash flow over the next 6 years. Investment $ 649,980.00
Year Cash Flow Cumulative Cash flow 1 $ (370,038.00) $ (370,038.00) 2 $ 341,995.00 $ (28,043.00) 3 $ 532,457.00 $ 504,414.00 4 $ 783,095.00 $1,287,509.00 5 $ 782,195.00 $2,069,704.00 6 $ 733,649.00 $2,803,353.00
649980-504414 = $ 145,566.00 3 + 145566/783095 = 3.185885493
b. TCO: Based on the calculations made above, the TCO
for this project is $2,803,353.00 c. Budgeted versus Actual Costs Name Actual Cost Baseline Cost
Wellness Vendor Project $220,049.00 $234,124.00
d. Earned Value of the project: The below calculations are
based on 14 of the 44 tasks are complete as of 30 July 2017. The actual cost includes the $75K payment to the vendor.
cash flow over the next 6 years. Investment $ 649,980.00
Year Cash Flow Cumulative Cash flow 1 $ (370,038.00) $ (370,038.00) 2 $ 341,995.00 $ (28,043.00) 3 $ 532,457.00 $ 504,414.00 4 $ 783,095.00 $1,287,509.00 5 $ 782,195.00 $2,069,704.00 6 $ 733,649.00 $2,803,353.00
649980-504414 = $ 145,566.00 3 + 145566/783095 = 3.185885493
b. TCO: Based on the calculations made above, the TCO
for this project is $2,803,353.00 c. Budgeted versus Actual Costs Name Actual Cost Baseline Cost
Wellness Vendor Project $220,049.00 $234,124.00
d. Earned Value of the project: The below calculations are
based on 14 of the 44 tasks are complete as of 30 July 2017. The actual cost includes the $75K payment to the vendor.
cash flow over the next 6 years. Investment $ 649,980.00
Year Cash Flow Cumulative Cash flow 1 $ (370,038.00) $ (370,038.00) 2 $ 341,995.00 $ (28,043.00) 3 $ 532,457.00 $ 504,414.00 4 $ 783,095.00 $1,287,509.00 5 $ 782,195.00 $2,069,704.00 6 $ 733,649.00 $2,803,353.00
649980-504414 = $ 145,566.00 3 + 145566/783095 = 3.185885493
b. TCO: Based on the calculations made above, the TCO
for this project is $2,803,353.00 c. Budgeted versus Actual Costs Name Actual Cost Baseline Cost
Wellness Vendor Project $220,049.00 $234,124.00
d. Earned Value of the project: The below calculations are
based on 14 of the 44 tasks are complete as of 30 July 2017. The actual cost includes the $75K payment to the vendor.
cash flow over the next 6 years. Investment $ 649,980.00
Year Cash Flow Cumulative Cash flow 1 $ (370,038.00) $ (370,038.00) 2 $ 341,995.00 $ (28,043.00) 3 $ 532,457.00 $ 504,414.00 4 $ 783,095.00 $1,287,509.00 5 $ 782,195.00 $2,069,704.00 6 $ 733,649.00 $2,803,353.00
649980-504414 = $ 145,566.00 3 + 145566/783095 = 3.185885493
b. TCO: Based on the calculations made above, the TCO
for this project is $2,803,353.00 c. Budgeted versus Actual Costs Name Actual Cost Baseline Cost
Wellness Vendor Project $220,049.00 $234,124.00
d. Earned Value of the project: The below calculations are
based on 14 of the 44 tasks are complete as of 30 July 2017. The actual cost includes the $75K payment to the vendor.
cash flow over the next 6 years. Investment $ 649,980.00
Year Cash Flow Cumulative Cash flow 1 $ (370,038.00) $ (370,038.00) 2 $ 341,995.00 $ (28,043.00) 3 $ 532,457.00 $ 504,414.00 4 $ 783,095.00 $1,287,509.00 5 $ 782,195.00 $2,069,704.00 6 $ 733,649.00 $2,803,353.00
649980-504414 = $ 145,566.00 3 + 145566/783095 = 3.185885493
b. TCO: Based on the calculations made above, the TCO
for this project is $2,803,353.00 c. Budgeted versus Actual Costs Name Actual Cost Baseline Cost
Wellness Vendor Project $220,049.00 $234,124.00
d. Earned Value of the project: The below calculations are
based on 14 of the 44 tasks are complete as of 30 July 2017. The actual cost includes the $75K payment to the vendor.
cash flow over the next 6 years. Investment $ 649,980.00
Year Cash Flow Cumulative Cash flow 1 $ (370,038.00) $ (370,038.00) 2 $ 341,995.00 $ (28,043.00) 3 $ 532,457.00 $ 504,414.00 4 $ 783,095.00 $1,287,509.00 5 $ 782,195.00 $2,069,704.00 6 $ 733,649.00 $2,803,353.00
649980-504414 = $ 145,566.00 3 + 145566/783095 = 3.185885493
b. TCO: Based on the calculations made above, the TCO
for this project is $2,803,353.00 c. Budgeted versus Actual Costs Name Actual Cost Baseline Cost
Wellness Vendor Project $220,049.00 $234,124.00
d. Earned Value of the project: The below calculations are
based on 14 of the 44 tasks are complete as of 30 July 2017. The actual cost includes the $75K payment to the vendor.
5. Project Quality Planning a. Key Performance Indicators (KPI): PKIs are specific
measurements that are used to determine we are meeting project goals or how far off from the goals that we are (Florida Tech, 2017). The following are a couple of the PKIs for this project
i. Project schedule: Is the project on schedule? What percentage of tasks were completed late?
ii. Project cost: Actual cost compared to the initial budgeted cost.
b. Quality Standards: The following are the expected
outcome for each deliverable: i. New database tables for storing the vendor data. ii. New reports for analyzing the new data.
c. Quality Metrics: Each deliverable includes user acceptance testing (UAT). By passing the UATs insures that they quality standards have been met.
References Florida Tech. (2017). Key performance indicators in project management. Retrieved from Florida Tech: https://www.floridatechonline.com/blog/business/key- performance-indicators-in-project-management/ Rouse, M. (2011, August). Cost-benefit analysis (CBA).
Retrieved from TechTarget: http://whatis.techtarget.com/definition/cost-benefit- analysis-CBA
IT 625 – Project Milestone 4 Monday, July 31, 2017
5. Project Quality Planning a. Key Performance Indicators (KPI): PKIs are specific
measurements that are used to determine we are meeting project goals or how far off from the goals that we are (Florida Tech, 2017). The following are a couple of the PKIs for this project
i. Project schedule: Is the project on schedule? What percentage of tasks were completed late?
ii. Project cost: Actual cost compared to the initial budgeted cost.
b. Quality Standards: The following are the expected
outcome for each deliverable: i. New database tables for storing the vendor data. ii. New reports for analyzing the new data.
c. Quality Metrics: Each deliverable includes user acceptance testing (UAT). By passing the UATs insures that they quality standards have been met.
References Florida Tech. (2017). Key performance indicators in project management. Retrieved from Florida Tech: https://www.floridatechonline.com/blog/business/key- performance-indicators-in-project-management/ Rouse, M. (2011, August). Cost-benefit analysis (CBA).
Retrieved from TechTarget: http://whatis.techtarget.com/definition/cost-benefit- analysis-CBA
IT 625 – Project Milestone 4 Monday, July 31, 2017
5. Project Quality Planning a. Key Performance Indicators (KPI): PKIs are specific
measurements that are used to determine we are meeting project goals or how far off from the goals that we are (Florida Tech, 2017). The following are a couple of the PKIs for this project
i. Project schedule: Is the project on schedule? What percentage of tasks were completed late?
ii. Project cost: Actual cost compared to the initial budgeted cost.
b. Quality Standards: The following are the expected
outcome for each deliverable: i. New database tables for storing the vendor data. ii. New reports for analyzing the new data.
c. Quality Metrics: Each deliverable includes user acceptance testing (UAT). By passing the UATs insures that they quality standards have been met.
References Florida Tech. (2017). Key performance indicators in project management. Retrieved from Florida Tech: https://www.floridatechonline.com/blog/business/key- performance-indicators-in-project-management/ Rouse, M. (2011, August). Cost-benefit analysis (CBA).
Retrieved from TechTarget: http://whatis.techtarget.com/definition/cost-benefit- analysis-CBA
IT 625 – Project Milestone 4 Monday, July 31, 2017
5. Project Quality Planning a. Key Performance Indicators (KPI): PKIs are specific
measurements that are used to determine we are meeting project goals or how far off from the goals that we are (Florida Tech, 2017). The following are a couple of the PKIs for this project
i. Project schedule: Is the project on schedule? What percentage of tasks were completed late?
ii. Project cost: Actual cost compared to the initial budgeted cost.
b. Quality Standards: The following are the expected
outcome for each deliverable: i. New database tables for storing the vendor data. ii. New reports for analyzing the new data.
c. Quality Metrics: Each deliverable includes user acceptance testing (UAT). By passing the UATs insures that they quality standards have been met.
References Florida Tech. (2017). Key performance indicators in project management. Retrieved from Florida Tech: https://www.floridatechonline.com/blog/business/key- performance-indicators-in-project-management/ Rouse, M. (2011, August). Cost-benefit analysis (CBA).
Retrieved from TechTarget: http://whatis.techtarget.com/definition/cost-benefit- analysis-CBA
IT 625 – Project Milestone 4 Monday, July 31, 2017
