Ziad Y. Mazboudi
Project Management
MGT 6529
Silver Zuma Project Computer Exercise 2 Blue Zuma Memorandum To: Professor From: Ziad Mazboudi Date: 7/30/2011 Subject: Blue Zuma Project Part 2 memo This memo discusses resources allocation and related issues. In this memo, I will address specific questions regarding resources. 1. Which if any of the resources are over allocated? Using the Resource sheet in Microsoft Project, I found that four of the resources are over allocated: Marketing Specialist Design Engineer Industrial Engineer Purchasing Agent 2. Which activities involve over allocated resources? Using the Resource Usage in Microsoft Project, and reviewing the Gantt chart, I determined that the following activities are over allocated: Detailed marketing plan Detailed product design Install production equipment 3. Assume that the project is time constrained and try to resolve any over-allocation problems by leveling within slack. What happens? Using Microsoft Project, and leveling all activities with the leveling option to “level only within available slack”, two of the over allocated resources are not anymore, however there were two that remained over allocated, design engineer and industrial engineer, as shown in the table below.
Resource Name |Type |Initials |Group |Max. Units |Std. Rate |Ovt. Rate |Cost/Use |Accrue At |Base Calendar |Over allocated | |Marketing Specialist |Work |MS |Marketing |400% |$60.00/hr |$0.00/hr |$0.00 |Prorated |Calendar 2 |No | |Design Engineer |Work |DesE |Design |400% |$90.00/hr |$0.00/hr |$0.00 |Prorated |Calendar 2 |Yes | |Development engineer |Work |DevE |Development |400% |$80.00/hr |$0.00/hr |$0.00 |Prorated |Calendar 2 |No | |Industrial engineer |Work |IE |Industrial |400% |$70.00/hr |$0.00/hr |$0.00 |Prorated |Calendar 2 |Yes | |Purchasing agent |Work |PA |Purchasing |100% |$50.00/hr