Group project 3
saalecynthia123
SupplyChainManagementProject-Final2.xlsxIntro
| Project Plan and Cost for |
| Supply Chain Management System |
| Go to the Sheet Tap Bar to see the details |
Project activities
| Project Activities Definition | |
| Project management | Initiate the project and set-up the project structure and facilitate the project necessary tools and lead |
| Business blueprint | Understand the business requirement and define the scope of the project and set up scope creep procedures and risk management method |
| Design | Outline the conceptual design for solutions and develop a prototype of main process flows and activities |
| Build | Develop the solution according to defined scope during the design phase |
| Testing | Organize business representatives to perform User Acceptance Test and coordinate the testing and fixing activities until test sign-off |
| IT Platform | Ensure the entire IT platform is ready for development and monitor system performance indicators secure technical go-live stability |
| Security | Check and ensure all security aspects are covered in the project |
| System accesses | Define business roles and authorizations and ensure accesses are checked and approved from segregation of duties perspective |
| Integration | Identify all impacted integrated systems and developed the necessary interfaces and solutions |
| Migration | Study what data to be migrated from the legacy system into the new system and conduct a cutover plan and methodology |
| Technical Go-live | Identify the activities for technical go-live and ensure all mater data set up are completed |
| Change Management | Develop information, news letters and training materials for end users |
| Implementation | Select a pilot organization for testing the solutions and prepare pilot outcome approval checklist and develop rollout time plan for the entire organization |
| Handover | Develop a system blueprint and other relevant materials and knowledge transfer to assigned IT people and guide how to support their organization |
| Post Go-live support | Support the business onsite during two weeks along with the organization's IT department |
| Project closure | Document final project report and lessons learned to terminate the project |
Time plan
| Supply Chain Management Project Time plan | ||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Project management | ||||||||||||
| Business blueprint | ||||||||||||
| Design | ||||||||||||
| Build | ||||||||||||
| Testing | ||||||||||||
| IT Platform | ||||||||||||
| Security | ||||||||||||
| System accesses | ||||||||||||
| Integration | ||||||||||||
| Migration | ||||||||||||
| Technical Go-live | ||||||||||||
| Change Management | ||||||||||||
| Implementation | ||||||||||||
| Handover | ||||||||||||
| Post Go-live support | ||||||||||||
| Project closure |
Resource Plan
| Resource Plan | ||
| Project activities | Number of resources | Required Resources |
| Project management | 1 | Project manager |
| Business blueprint | 3 | Business Matter Expert, Solution architect, System Matter Expert |
| Design | 4 | Business Matter, Expert, Solution architect, System Matter Expert, System developer |
| Build | 7 | Business Matter, System Matter Expert, Solution architect, System development lead and 3 Developers |
| Testing | 7 | Business Matter, System Matter Expert, Solution architect, System development lead and 3 Developers |
| IT Platform | 1 | Infrastructure architect |
| Security | 1 | IT security expert |
| Business accesses | 2 | Roles and Authorization design and developers |
| Integration | 2 | System integration expert, system integration developer |
| Data migration | 3 | Data migration lead, 2 migration experts |
| Technical Go-live | 5 | Business Matter Expert, System Matter Expert, Solution architect, 2 System developers |
| Change Management | 2 | Change management lead, document and training materials developer |
| Implementation | 5 | Business Matter Expert, System Matter Expert, Solution architect, 2 System developers |
| Handover | 4 | Solution architect, Infrastructure architect, IT security expert, Development lead |
| Post Go-live support | 5 | Solution architect, Business matter expert, System matter expert, 2 developers |
| Project closure | 2 | Project manager, Solution architect |
Time reporting
| Project Resources | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | ||
| Project Manager | Xxxxxxxx Xxxxxxxx | 100% | 168 | 168 | ||||||||||||
| Business Matter Expert | Xxxxxxxx Xxxxxxxx | 100% | 165 | 165 | ||||||||||||
| Solution architect | Xxxxxxxx Xxxxxxxx | 100% | 160 | 160 | ||||||||||||
| System Matter Expert | Xxxxxxxx Xxxxxxxx | 100% | 155 | 155 | ||||||||||||
| System Matter Expert | Xxxxxxxx Xxxxxxxx | 100% | 165 | 165 | ||||||||||||
| System development lead | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| System developer-1 | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| System developer-2 | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| System developer-3 | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Infrastructure architect | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| IT security expert | Xxxxxxxx Xxxxxxxx | 25% | 0 | |||||||||||||
| Roles and Authorization design and developer | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Roles and Authorization design and developer | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| System integration expert | Xxxxxxxx Xxxxxxxx | 50% | 0 | |||||||||||||
| System integration developer | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Data migration lead | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Migration expert-1 | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Migration expert-2 | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Change management lead | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| Document and training materials developer | Xxxxxxxx Xxxxxxxx | 100% | 0 | |||||||||||||
| 813 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1626 | ||||
| 81,300 | 81,300 |
Project Cost
| Price Rate $100 per hour (one price rate for the sake of simplicity) | |||||||||||||||||||||||||||||||||||||||||||
| Avarage hours per month = 168 | |||||||||||||||||||||||||||||||||||||||||||
| No vacation during the project | |||||||||||||||||||||||||||||||||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total cost | |||||||||||||||||||||||||||||||
| Project activities | Required number of resources | Required efforts in FTE | Required period in month | Estimated resource hours | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Estimated cost | Actual cost | Difference | Total estimated | Total Actual | Total difference |
| Project management | 1 | 1 | 12 | 201,600.00 | 16,800.00 | 16,800.00 | 0.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 201,600.00 | 16,800.00 | 184,800.00 | |||||||||||
| Business blueprint | 3 | 3 | 1 | 50,400.00 | 50,400.00 | 48,000.00 | 2,400.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 50,400.00 | 48,000.00 | 2,400.00 | ||||||||||||||||||||||
| Design | 4 | 4 | 2 | 134,400.00 | 0.00 | 67,200.00 | 67,200.00 | 67,200.00 | 67,200.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 134,400.00 | 0.00 | 134,400.00 | ||||||||||||||||||||||
| Build | 7 | 7 | 3 | 352,800.00 | 0.00 | 0.00 | 0.00 | 117,600.00 | 117,600.00 | 117,600.00 | 117,600.00 | 117,600.00 | 117,600.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 352,800.00 | 0.00 | 352,800.00 | |||||||||||||||||||||
| Testing | 7 | 7 | 2 | 235,200.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 117,600.00 | 117,600.00 | 117,600.00 | 117,600.00 | 0.00 | 0.00 | 0.00 | 0.00 | 235,200.00 | 0.00 | 235,200.00 | ||||||||||||||||||||||
| IT Platform | 1 | 0.5 | 9 | 75,600.00 | 0.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 8,400.00 | 0.00 | 0.00 | 75,600.00 | 0.00 | 75,600.00 | |||||||||||||||
| Security | 1 | 0.25 | 6 | 25,200.00 | 0.00 | 0.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 4,200.00 | 0.00 | 0.00 | 0.00 | 0.00 | 25,200.00 | 0.00 | 25,200.00 | ||||||||||||||||||
| System accesses | 2 | 2 | 7 | 235,200.00 | 0.00 | 0.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 0.00 | 0.00 | 0.00 | 235,200.00 | 0.00 | 235,200.00 | |||||||||||||||||
| Integration | 2 | 1 | 7 | 117,600.00 | 0.00 | 0.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 16,800.00 | 0.00 | 0.00 | 0.00 | 117,600.00 | 0.00 | 117,600.00 | |||||||||||||||||
| Migration | 3 | 3 | 4 | 201,600.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 50,400.00 | 50,400.00 | 50,400.00 | 50,400.00 | 50,400.00 | 50,400.00 | 50,400.00 | 50,400.00 | 0.00 | 0.00 | 0.00 | 201,600.00 | 0.00 | 201,600.00 | ||||||||||||||||||||
| Technical go-live | 5 | 5 | 1 | 84,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 84,000.00 | 84,000.00 | 0.00 | 0.00 | 0.00 | 84,000.00 | 0.00 | 84,000.00 | |||||||||||||||||||||||
| Change Management | 2 | 2 | 7 | 235,200.00 | 0.00 | 0.00 | 0.00 | 0.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 0.00 | 235,200.00 | 0.00 | 235,200.00 | |||||||||||||||||
| Implementation | 5 | 5 | 4 | 336,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 84,000.00 | 84,000.00 | 84,000.00 | 84,000.00 | 84,000.00 | 84,000.00 | 84,000.00 | 84,000.00 | 336,000.00 | 0.00 | 336,000.00 | ||||||||||||||||||||
| Handover | 4 | 2 | 2 | 67,200.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 33,600.00 | 33,600.00 | 33,600.00 | 33,600.00 | 67,200.00 | 0.00 | 67,200.00 | ||||||||||||||||||||||
| Post go-live support | 5 | 5 | 1 | 84,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 84,000.00 | 84,000.00 | 84,000.00 | 0.00 | 84,000.00 | |||||||||||||||||||||||
| Project closure | 2 | 2 | 0.5 | 16,800.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 16,800.00 | 16,800.00 | 16,800.00 | 0.00 | 16,800.00 | |||||||||||||||||||||||
| TOTAL | 54 | 49.75 | 56.5 | 2,452,800.00 | 67,200.00 | 64,800.00 | 2,400.00 | 92,400.00 | 0.00 | 92,400.00 | 147,000.00 | 0.00 | 147,000.00 | 197,400.00 | 0.00 | 197,400.00 | 231,000.00 | 0.00 | 231,000.00 | 281,400.00 | 0.00 | 281,400.00 | 281,400.00 | 0.00 | 281,400.00 | 281,400.00 | 0.00 | 281,400.00 | 327,600.00 | 0.00 | 327,600.00 | 142,800.00 | 0.00 | 142,800.00 | 168,000.00 | 0.00 | 168,000.00 | 235,200.00 | 0.00 | 235,200.00 | 2,452,800.00 | 64,800.00 | 2,388,000.00 |
Cost Follow-up
| Cost Follow-up Report | ||||
| Estimate Cost | Actual Cost | Diff | Comment | |
| January | 67,200.00 | 67,200.00 | ||
| February | 92,400.00 | 92,400.00 | ||
| March | 147,000.00 | 147,000.00 | ||
| April | 197,400.00 | 197,400.00 | ||
| May | 231,000.00 | 231,000.00 | ||
| June | 281,400.00 | 281,400.00 | ||
| July | 281,400.00 | 281,400.00 | ||
| August | 281,400.00 | 281,400.00 | ||
| September | 327,600.00 | 327,600.00 | ||
| October | 142,800.00 | 142,800.00 | ||
| November | 168,000.00 | 168,000.00 | ||
| December | 235,200.00 | 235,200.00 | ||
| 2,452,800.00 | 2,452,800.00 |
