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 |, 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 Assighment Matrix (RAM) using the resources identified in the scenario. Project Project Task Project artifacts Project manager Project Management and Requirements 2 Identify business need 5 Complete project charter 3 Develop preliminary budget 1 Develop preliminary project scope 4 Identify preliminary return on investment Resource Assignment Matrix Initiation Business End Users Business Sponsor IS Sponsor Business Driver Sponsor Updated Project # 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 0Planning 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 7Define current business processes (as is) 8 Revise project schedule 9 Develop project communication plan 10 Develop project organizational structure 1 1 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 managementExecution Develop training materials Execute communication plan e | [ [ Develop software Develop new business processes (to be Deploy new software Conduct traming Get deliverable acceptance Closing Close out contracts Finalize budget Finalize return on investment Conduct closure survey Conduct/document lessons learned | TR (LA [ |l | e [ Archive project Legend Creates the deliverable C1: primary creator; C2: contributor Input required Reviews the deliverable Approves the deliverable Notified when the deliverable is complete 0|2 || Owns the deliverable upon completion