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 Il, 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. Project Task 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 Initiation Business End Users Business Sponsor IS Sponsor Business Driver Business Project Lead R A R C L Project Manager C Business Sys. Analyst Data Modeler DBA Data Staging Designer Educator Appl'n Developer C H R Tech/Security Architect Tech Support Specialist Data Staging Programmer Data Steward QA AnalystPlanning 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 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 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 projectLegend Creates the deliverable C1: primary creator; C2: contributor Input required Reviews the deliverable Approves the deliverable Notified when the deliverable is complete Owns the deliverable upon completion oz e =T