PROJ 587. Week 6: United Healthcare Group Case Study—Budget and Performance Metrics Recommendations

Week6UHGCaseStudy_BudgetandPerformanceMetricsRecommendations.xlsx

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."

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 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

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