Project: Portfolio Management at Rockwell Automation
Using the project topic selected in week 2 for the Reality Project, create project estimates.
Note: You will probably want to create the word doc first and then finalize after you complete the Excel workbook.
Compile an Excel workbook –
Activity worksheet – Include 10 to 15 major activities required for your Reality Project. Include start and finish dates for each activity (each should be 5-20 business days).
Resource worksheet – Include five different types of labor with cost per hour.
Update Activity worksheet to include resource types for each activity and include percentage of resource required ex: Activity x may require labor type a (50%) and labor type b (50%). Add column for cost of labor and calculate for each activity the cost.
Create a Word document that provides a scope overview of the project, description, purpose, value (benefits), expected outcome, etc. Provide the schedule and cost estimates from your Excel workbook. Describe the implications of delays and cost overruns. Describe your method to controlling/monitoring the project to prevent delays and cost overruns.