convert .xls to mpp

profilemathgirl
20141111192310software_project_management_chart_week_3.xlsx
Home>Information Systems homework help>convert .xls to mpp

System Implementation

Gantt Chart 0
Going Live (Software Installation)
Freight Shipping Company Limited Today's Date: 11/5/14 Wednesday
(vertical red line)
Project Lead: [42]
Start Date: 9/1/14 Monday
[42] First Day of Week (Mon=2): 2 9/1/14 9/2/14 9/3/14 9/4/14 9/5/14 9/6/14 9/7/14 9/8/14 9/9/14 9/10/14 9/11/14 9/12/14 9/13/14 9/14/14 9/15/14 9/16/14 9/17/14 9/18/14 9/19/14 9/20/14 9/21/14 9/22/14 9/23/14 9/24/14 9/25/14 9/26/14 9/27/14 9/28/14 9/29/14 9/30/14 10/1/14 10/2/14 10/3/14 10/4/14 10/5/14 10/6/14 10/7/14 10/8/14 10/9/14 10/10/14 10/11/14 10/12/14 10/13/14 10/14/14 10/15/14 10/16/14 10/17/14 10/18/14 10/19/14 10/20/14 10/21/14 10/22/14 10/23/14 10/24/14 10/25/14 10/26/14 10/27/14 10/28/14 10/29/14 10/30/14 10/31/14 11/1/14 11/2/14 11/3/14 11/4/14 11/5/14 11/6/14 11/7/14 11/8/14 11/9/14 11/10/14 11/11/14 11/12/14 11/13/14 11/14/14 11/15/14 11/16/14 11/17/14 11/18/14 11/19/14 11/20/14 11/21/14 11/22/14 11/23/14 11/24/14 11/25/14 11/26/14 11/27/14 11/28/14 11/29/14 11/30/14 12/1/14 12/2/14 12/3/14 12/4/14 12/5/14 12/6/14 12/7/14 12/8/14 12/9/14 12/10/14 12/11/14 12/12/14 12/13/14 12/14/14 12/15/14 12/16/14 12/17/14 12/18/14 12/19/14 12/20/14 12/21/14 12/22/14 12/23/14 12/24/14 12/25/14 12/26/14 12/27/14 12/28/14 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
WBS
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.		 Tasks Software Selection Start
Jon: Start Date Enter the starting date for this task. To associate the start date with the end of another task, enter a formula in the start date that refers to the end date of that task.		 End
Jon: End Date The ending date is calculated by adding the Duration (calendar days) to the Start date minus 1 day, because the task duration is from the beginning of the Start day to the end of the End day. 		Duration (Days)
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.		 % Complete
Jon: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%).		 Working Days
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.		 Days Complete
Jon: Calendar Days Complete This column is calculated by multiplying the Duration by the %Complete and rounding down to the nearest integer.		 Days Remaining
Jon: Calendar Days Remaining This column is calculated by subtracting the Days Complete from the Duration.
Vertex42: Terms of Use and Copyright: See the Terms Of Use worksheet and the license agreement on Vertex42.com. Copyright notices may not be removed.
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.
Jon: Start Date Enter the starting date for this task. To associate the start date with the end of another task, enter a formula in the start date that refers to the end date of that task.
Jon: End Date The ending date is calculated by adding the Duration (calendar days) to the Start date minus 1 day, because the task duration is from the beginning of the Start day to the end of the End day.
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.		 01 - Sep - 14 08 - Sep - 14 15 - Sep - 14 22 - Sep - 14 29 - Sep - 14 06 - Oct - 14 13 - Oct - 14 20 - Oct - 14 27 - Oct - 14 03 - Nov - 14 10 - Nov - 14 17 - Nov - 14 24 - Nov - 14 01 - Dec - 14 08 - Dec - 14 15 - Dec - 14 22 - Dec - 14 29 - Dec - 14 05 - Jan - 15 12 - Jan - 15 19 - Jan - 15 26 - Jan - 15 02 - Feb - 15 09 - Feb - 15 16 - Feb - 15 23 - Feb - 15 02 - Mar - 15 09 - Mar - 15 16 - Mar - 15 23 - Mar - 15 30 - Mar - 15 06 - Apr - 15 13 - Apr - 15 20 - Apr - 15
1 Task Category 1 Consultation on the needs of the organization with regard to software 1/Sep/14 9/Sep/14 5 100% 3 3 2 Days remaining are Sundays which are not working days The reasons for implementing a new software stipulated. Various softwares identified Various softwares identified Various softwares identified Presentation System selected and contact made with the supplier Signing of contract
Search for software that meets those needs 9/Sep/14 25/Sep/14 17 100% 15 15 0 Needs for the new system - tracking,shipping,receiving and inventory management 25th September 2014 - software selected
0.1 Sub Task level 2 Shortlisting of software selected 25/Sep/14 29/Sep/14 5 100% 4 4 1 This would then form the expectations for the new software.
0.2 Sub Task level 2 Presentation to Management 30/Sep/14 30/Sep/14 1 100% 1 1 0
0.2.1 Sub Task level 3 Selection of One system 1/Oct/14 5/Oct/14 5 100% 4 4 1
0.2.2 Sub Task level 3 Contact with supplier 6/Oct/14 10/Oct/14 5 100% 5 5 0
0.3 Sub Task level 2 Negotiations 11/Oct/14 15/Oct/14 5 100% 4 4 1
0.4 Sub Task level 2 Agreement and signing of contract 16/Oct/14 20/Oct/14 5 100% 4 4 1
Task Category 2 Software Implementation 4/Nov/14 28/Nov/14 25 25% 19 6 19
0.1 Sub Task level 2 Identifying the tasks for project implementation 4/Nov/14 8/Nov/14 5 25% 5 1 4 This is the backbone of the project and it needs to be conducted with great caution as it will determine the success or failure of the software implementation The project lead will work closely with the information technology and operations manger to assess the needs and also formulate the tasks that shall be required to be executed
0.2 Sub Task level 2 Assessing the needs for the software implementation 10/Nov/14 14/Nov/14 5 25% 5 1 4 Fifteen computers will be required for the project
0.3 Sub Task level 2 Selecting members to carry out tests on the software 17/Nov/14 21/Nov/14 5 25% 5 1 4 Two members per department must be selected of facilitate implementation
0.4 Sub Task level 2 Informing the Executive team on the selection 24/Nov/14 28/Nov/14 5 25% 5 1 4 Agreement on the members of the team to spearhead testing and relocation. Managers of each team will be informed on trhe selection of members. Mangers will then agree or disagree with the selection made and solutions on the same sought.
1 Task Category 3 Relocation and Testing 29/Nov/14 22/Dec/14 24 0% 16 0 24
1.1 Sub Task level 2 Relocation of the selected team members 29/Nov/14 4/Dec/14 6 0% 4 0 6 Relocation of the selected team members
1.2 Sub Task level 2 Test scripts analyzed for testing 5/Dec/14 10/Dec/14 6 0% 4 0 6 Test scripts assessed and procedures identified on how the testing will be carried out. Which team will start and which one will finish or end the testing process
1.3 Sub Task level 2 Commencement of tests 11/Dec/14 16/Dec/14 6 0% 4 0 6 Testing begins each carried out as per the test scripts
1.4 Sub Task level 2 Collection and interpretation of data after testing 17/Dec/14 22/Dec/14 6 0% 4 0 6 Each test done is well documented with data being accurately registered and the same analyzed to assess if it meets the needs of the organization
2 Task Category 4 Analysis and Implementation 23/Nov/14 27/Jan/15 64 0% 47 0 64
2.1 Sub Task level 2 Bottlenecks Identified 23/Dec/14 27/Dec/14 5 0% 4 0 5 Identify the areas that need to be changed and what needs to be done. This will be tied to the expectations of the organization pertaining to the new software
2.2 Sub Task level 2 Changes that need to be made highlighted 28/Dec/14 1/Jan/15 5 0% 4 0 5 Changes made to the system with authorization and consultation with management on the same. The supplier will be part of the consultation process too.
2.3 Sub Task level 2 System modified 2/Jan/15 6/Jan/15 5 0% 3 0 5 Further modifications done to the system if need be.
2.4 Sub Task level 2 Final implementation carried out 6/Jan/15 10/Jan/15 5 0% 4 0 5 System is tested with the new modifications in place and the final implementation takes place. Computers are returned to the headquarters. The staff also relocate back to the organization.