Scenario

TheProject Manager of GDSasked you to use anExcelspreadsheet to createe aResource Assignment Matrixspecifying cost and availability. Then update theMicrosoft Project fileby assigning resources and costs to resource sheet and tasks identified in the previously createdWBS. 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 tocreate the Resource Assignment Matrix (RAM).Update the Microsoft Project file created for Deliverable 4by assigning resources and costs to resource sheet and work packages (subtasks). Resolve any over allocation issues with assigned resources.

• Using the Exceltemplateprovided, create the Resource Assignment Matrix (RAM) using the resources identified in the scenario.

PLEASE FILL THIS OUT !!! THANK YOU this is my 6th time trying to figure this out

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