PROJ 587. Week 6: United Healthcare Group Case Study—Budget and
Let’s look at our finances and funding. Also, we know that this program represents significant change. I’d like to have your recommendations on what change management methodologies we should use, and how it will fit into our planning. We decided to go forward with the current resource projections and cover the shortfall of subcontractors, that brings the average hourly rate up. Here are the average hourly rates for our project resources, representing a mix of internal and external resources to use for our preliminary budget. We don’t yet know the mix, but we do know that we’ll be adding enough resources to make up for the shortfall. Systems analysts average at $60 an hour, security $40 an hour, our data specialists will be about $35 an hour, and project managers $50 an hour. Here again is the allocation of each resource type by month for the first three projects in the program for the first year. Given this information, what is the total cost for each resource type and each project per month? We’d also like a forecast of the months when our spending will be at its highest. By the end of our first year, what will be the planned value of the program? Define the metrics that will be used to report performance and your recommendations for the frequency of those reports: weekly, monthly, or quarterly. Your next assignment is a recommendation regarding a change management methodology for the program. Please explain why you believe this to be the best approach and outline the steps for an implementation. Once all of that is done, we’ll be ready to start the first project. You have your work cut out for you. Thank you for all the work you’ve done in planning.
In a four- to five-page paper, do the following.
1. Formulate a preliminary budget per month for each resource and each project as well as an overall total.
2. Create a chart to show what months the spend will be the highest.
3. Calculate the planned value of the program at the end of the first year.
4. Make recommendations regarding the type of performance metrics you will be tracking and acceptable limits.
5. Recommend a change management methodology and justify your recommendation.
6. Outline the steps required to implement the change.
Instructions
INSTRUCTIONS | |
1. | Change the starting month and drag it across the table. |
2. | Select the resource group. |
3. | Select the resource type. |
4. | Enter the program component name. |
5. | Enter the number of resources of that type and group. |
NOTE: Change the drop-down menus. | |
Right-click worksheet name and select “Unhide.” | |
Add or change the drop-down items. | |
RIght-click worksheet name and select “Hide.” |
Program Resource Summary
Component Name | Start | End | Duration | January | February | March | April | May | June | July | August | September | October | November | December |
Multi-Factor Authentication | January | June | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 |
Skype for Business Upgrade | March | August | 5 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 0 | 0 | 0 | 0 |
Exchange Upgrade | |||||||||||||||
0 | |||||||||||||||
` | |||||||||||||||
Total |
Resource Management
Resource Group | Resource Type | Component Name | January | February | March | April | May | June | July | August | September | October | November | December | Start | |
Team Members | System Analysists | Multi-Factor Authentication | 2 | 2 | 2 | 2 | 2 | 2 | ||||||||
Team Members | Security | Multi-Factor Authentication | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | Data Specialists | Multi-Factor Authentication | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | Project Managers | Multi-Factor Authentication | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | System Analysists | Skype for Business Upgrade | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | Security | Skype for Business Upgrade | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | Data Specialists | Skype for Business Upgrade | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | Project Managers | Skype for Business Upgrade | 1 | 1 | 1 | 1 | 1 | 1 | 0 | |||||||
Team Members | System Analysists | Exchange Upgrade | 2 | 2 | 2 | 2 | 2 | 2 | ||||||||
Team Members | Data Specialists | Exchange Upgrade | 2 | 2 | 2 | 2 | 2 | 2 | ||||||||
Team Members | Security | Exchange Upgrade | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Team Members | Project Managers | Exchange Upgrade | ||||||||||||||
System Analysists | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 0 | |||
Security | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | |||
Data Specialists | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 0 | |||
Project Managers | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | |||
TOTAL | TOTAL | 5 | 5 | 9 | 9 | 9 | 9 | 9 | 9 | 5 | 5 | 5 | 5 | |||
Hourly Rates | ||||||||||||||||
Average rate per hour | ||||||||||||||||
System Analysists | $ 60.00 | |||||||||||||||
Security | $ 40.00 | |||||||||||||||
Data Specialists | $ 35.00 | |||||||||||||||
Project Managers | $ 50.00 |
UHG IT Infrastructure Upgrade
Program Name | UHG IT Infrastructure upgrade | ||||||||||||||||||||||||||||||
Total Program Duration(Months) | 28 | ||||||||||||||||||||||||||||||
Component | PLAN START | PLAN DURATION | MONTHS | ||||||||||||||||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | ||||
Multi Factor Authentication | 1 | 6 | |||||||||||||||||||||||||||||
Skype for Business Upgrade | 3 | 6 | |||||||||||||||||||||||||||||
Exchange Upgrade | 6 | 10 | |||||||||||||||||||||||||||||
AD Modernization | 10 | 6 | |||||||||||||||||||||||||||||
Sel Service Password Reset | 10 | 6 | |||||||||||||||||||||||||||||
IAM Phase 2 | 10 | 6 | |||||||||||||||||||||||||||||
Windows 10-Office 365 | 16 | 10 | |||||||||||||||||||||||||||||
Affiliate Integration | 26 | 3 | |||||||||||||||||||||||||||||
American Health Migration | 26 | 3 | |||||||||||||||||||||||||||||
Physician Service Alliance Migration | 26 | 3 |
DropDown
Resource Group | ResourceType | Available Resources |
Team Members | System Analysists | 2 |
Team Members | Security | 4 |
Team Members | Data Specialists | 4 |
Project Managers | 4 |