Scenario
The Project Manager of GDS asked you to use an Excel spreadsheet to create a Resource Assignment Matrix specifying cost and availability. Then update the Microsoft Project file by assigning resources and costs to resource sheet and tasks identified in the previously created WBS. You must identify and address all over-allocation issues using the leveling tools within the project management software. The Project Manager identified the following resources for this project: Project Manager, System Administrator I, System Administrator II, Network Administrator and IT Technician.
Instructions
With the resources identified in the scenario, use an Excel spreadsheet to create the Resource Assignment Matrix (RAM). Update the Microsoft Project file created for Deliverable 4 by assigning resources and costs to resource sheet and work packages (subtasks). Resolve any over allocation issues with assigned resources.
- Using the Excel template provided, create the Resource Assignment Matrix (RAM) using the resources identified in the scenario.
RAM
| Resource Assignment Matrix | ||||||||||||||||||||
| Project | Project # | |||||||||||||||||||
| Project manager | Sponsor | 0 | ||||||||||||||||||
| Project artifacts | Updated | |||||||||||||||||||
| Project Task | Business End Users | Business Sponsor | IS Sponsor | Business Driver | Business Project Lead | Project Manager | Business Sys. Analyst | Data Modeler | DBA | Data Staging Designer | Educator | Appl'n Developer | Tech/Security Architect | Tech Support Specialist | Data Staging Programmer | Data Steward | QA Analyst | |||
| Project Management and Requirements | ||||||||||||||||||||
| Initiation | ||||||||||||||||||||
| 1 | Develop preliminary project scope | |||||||||||||||||||
| 2 | Identify business need | |||||||||||||||||||
| 3 | Develop preliminary budget | |||||||||||||||||||
| 4 | Identify preliminary return on investment | |||||||||||||||||||
| 5 | Complete project charter | |||||||||||||||||||
| Planning | ||||||||||||||||||||
| 1 | Establish project identity | |||||||||||||||||||
| 2 | Identify project team/resources | |||||||||||||||||||
| 3 | Conduct stakeholder analysis | |||||||||||||||||||
| 4 | Prepare draft project schedule | |||||||||||||||||||
| 5 | Conduct project kickoff meeting | |||||||||||||||||||
| 6 | Gather detailed user requirements | |||||||||||||||||||
| 7 | Define current business processes (as is) | |||||||||||||||||||
| 8 | Revise project schedule | |||||||||||||||||||
| 9 | Develop project communication plan | |||||||||||||||||||
| 10 | Develop project organizational structure | |||||||||||||||||||
| 11 | Identify training plan | |||||||||||||||||||
| 12 | Develop project quality plan | |||||||||||||||||||
| 13 | Develop scope management plan | |||||||||||||||||||
| 14 | Develop risk management plan | |||||||||||||||||||
| 15 | Develop change management plan | |||||||||||||||||||
| 16 | Develop cost management plan | |||||||||||||||||||
| 17 | Develop schedule management plan | |||||||||||||||||||
| 18 | Develop technical specifications | |||||||||||||||||||
| 19 | Develop technical architecture | |||||||||||||||||||
| 20 | Conduct project procurement | |||||||||||||||||||
| 21 | Finalize project budget | |||||||||||||||||||
| 22 | Finalize return on investment | |||||||||||||||||||
| 23 | Ongoing project management | |||||||||||||||||||
| Execution | ||||||||||||||||||||
| 1 | Develop training materials | |||||||||||||||||||
| 2 | Execute communication plan | |||||||||||||||||||
| 3 | Develop software | |||||||||||||||||||
| 4 | Develop new business processes (to be) | |||||||||||||||||||
| 5 | Deploy new software | |||||||||||||||||||
| 6 | Conduct training | |||||||||||||||||||
| Closing | ||||||||||||||||||||
| 1 | Get deliverable acceptance | |||||||||||||||||||
| 2 | Close out contracts | |||||||||||||||||||
| 3 | Finalize budget | |||||||||||||||||||
| 4 | Finalize return on investment | |||||||||||||||||||
| 5 | Conduct closure survey | |||||||||||||||||||
| 6 | Conduct/document lessons learned | |||||||||||||||||||
| 7 | Archive project | |||||||||||||||||||
| Legend | ||||||||||||||||||||
| Creates the deliverable | C1: primary creator; C2: contributor | |||||||||||||||||||
| Input required | I | |||||||||||||||||||
| Reviews the deliverable | R | |||||||||||||||||||
| Approves the deliverable | A | |||||||||||||||||||
| Notified when the deliverable is complete | N | |||||||||||||||||||
| Owns the deliverable upon completion | O | |||||||||||||||||||
