pert.xlsx

Sheet1

Task Most Optimistic Most Likely Most Pessimistic Expected Estimate
1.1     Initiation
1.1.1 Evaluation & Recommendations
1.1.2 Brainstorming and compiling information needed
1.1.3 Develop Project Charter
1.1.4 Develop Budget
1.1.5 Deliverable: Submit Project Charter
1.1.6 Project Sponsor Reviews Project Charter
1.1.7 Project Team Reviews Project Charter
1.1.8 IT, Sales, Consulting management leaders review Project Charter
1.1.9 Project Charter Signed/Approved
1.2     Planning
1.2.1 Create Preliminary Scope Statement
1.2.2 Determine Project Team
1.2.3 Equipment Procurement
1.2.4 Salvage procurement
1.2.5 IT lays out protocol to push new system
1.2.6 Project Team Kickoff Meeting
1.2.7 Develop Project Plan
1.2.8 Create timeline, identify major milestones
1.2.9 Create control cost schedule
1.2.10    Create GANTT/PERT
1.2.11    Submit Project Plan with GANTT/PERT
1.2.12    Milestone: Project Plan Approval
1.3     Execution
1.3.1 Project Kickoff Meeting
1.3.2 Verify & Validate User Requirements
1.3.3 Development and Design Email Server/Service
1.3.4 Write program, develop platform protocol and create final software
1.3.5 IT reviews software
1.3.6 Sales, Consulting determine to proceed or reconfigure based on IT’s reviews
1.3.7 Overlay server with new programmed software platform
1.3.8 Consolidate five systems into one server/system
1.3.9 Testing Phase
1.3.10    Install Live System
1.3.11    Add 500 new user accounts, integrate 2000 existing user accounts and employee accounts
1.3.12    Review server/system for errors or alternations
1.3.13    Upgrade user PC’s to accommodate the new email system
1.3.14    Test LAN and remote access
1.3.15    Set-up help desk and support infrastructure
1.3.16    Employee user training, integrate customer training prompts
1.3.17    Become fully operational, release to public
1.4     Control
1.4.1 Project Management
1.4.2 Project Status Meetings
1.4.3 Risk Management
1.4.4 Update Project Management Plan
1.5     Closeout
1.5.1 Equipment Salvage
1.5.2 Audit Procurement
1.5.3 Customer/end user feedback
1.5.4 Surveys to employees and helpdesk
1.5.5 Document Lessons Learned
1.1.1 Update Files/Records
1.1.2 Gain Formal Acceptance
1.1.3 Archive Files/Documents