Ziad Y. Mazboudi
Silver Zuma Project Computer Exercise 2
Blue Zuma Memorandum
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:
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...