Risk Assessment Assignment

profiletase15
itp-4.xlsx

Sheet1

Task Labor Hours Rate Unit Materials Material Cost Labor Cost Total Cost
1. Commence Project Stakeholders 0 $ - 0
2. Interview the client Project Manager 3 $ 37.00 100% $ 111.00 $ 111.00
3. Conduct Project Kickoff Meeting Project Manager $ 37.00 10% $ - 0 $ - 0
3.1 Brief Project Proposal to Management Project Manager $ 37.00 5% $ - 0 $ - 0
3.1.1 Conduct Powerpoint presentation Project Manager 1 $ 37.00 100% $ 37.00 $ 37.00
3.1.2 Brief Charter Project Facilitator 1 $ 33.00 100% $ 33.00 $ 33.00
3.1.3 Acquire sponsor and stakeholder support Project Manager $ 37.00 10% $ - 0 $ - 0
3.1.3.1 Answer sponsor questions Project Manager 1 $ 37.00 100% $ 37.00 $ 37.00
3.1.3.2 Answer stakeholder questions Project Manager 1 $ 37.00 100% $ 37.00 $ 37.00
3.1.3.3 Acquires signatures on project document Project Manager 4 $ 37.00 5% $ 148.00 $ 148.00
4. Identify project team Project Manager $ 37.00 5% $ - 0 $ - 0
4.1 Select team members Project Manager $ 37.00 5% $ - 0 $ - 0
4.1.1 Review corporate roster Human Resource Officer 12 $ 23.00 25% $ 276.00 $ 276.00
4.1.2 Make list of candidates Human Resource Officer 12 $ 23.00 25% $ 276.00 $ 276.00
4.1.3 Conduct background check Human Resource Officer 48 $ 23.00 25% $ 1,104.00 $ 1,104.00
4.1.4 Conduct interviews Project Manager 8 $ 37.00 10% $ 296.00 $ 296.00
4.1.5 Approve members Project Manager 16 $ 37.00 10% $ 592.00 $ 592.00
5. Develop Project Infrastructure Project Manager $ 37.00 5% $ - 0 $ - 0
5.1 Determine roles Human Resource Officer $ 23.00 50% $ - 0 $ - 0
5.1.1 Make list of required roles Human Resource Officer 16 $ 23.00 10% $ 368.00 $ 368.00
5.1.2 Analyze member abilities Human Resource Officer 16 $ 23.00 10% $ 368.00 $ 368.00
5.1.3 Assign roles to members Human Resource Officer 16 $ 23.00 10% $ 368.00 $ 368.00
6. Create schedule Project Facilitator $ 33.00 1% $ - 0 $ - 0
6.1 Detemine required events Project Facilitator $ 33.00 1% $ - 0 $ - 0
6.1.1 Make list of required events Project Facilitator 6 $ 33.00 50% $ 198.00 $ 198.00
6.1.2 Review list of required events Project Manager 3 $ 37.00 100% $ 111.00 $ 111.00
6.1.3 Approve list of events Sponsor, Stakeholders 6 $ - 0 10% $ - 0 $ - 0
6.2 Determine task load Project Manager $ 37.00 10% $ - 0 $ - 0
6.2.1 Determine areas of reponsibility Project Facilitator 2 $ 33.00 100% $ 66.00 $ 66.00
6.2.2 Assign Action Officers Project Manager 2 $ 37.00 100% $ 74.00 $ 74.00
6.2.3 Assign tasks Project Manager 2 $ 37.00 100% $ 74.00 $ 74.00
7. Create Policies Project Manager $ 37.00 10% $ - 0 $ - 0
7.1 Determine value of assets Finance Officer $ 45.00 10% $ - 0 $ - 0
7.1.1 Make list of assets Finance Officer 16 $ 45.00 10% $ 720.00 $ 720.00
7.1.2 Prioritize list of assets Finance Officer 6 $ 45.00 10% $ 270.00 $ 270.00
7.1.3 Determine qualitative value of assets Finance Officer 6 $ 45.00 10% $ 270.00 $ 270.00
7.1.4 Determine quantitative value of assets Finance Officer 6 $ 45.00 10% $ 270.00 $ 270.00
7.2 Determine risks Risk Manager $ 33.00 10% $ - 0 $ - 0
7.2.1 Determine risks to organization Risk Manager 6 $ 33.00 10% $ 198.00 $ 198.00
7.2.2 Determine risks to project Risk Manager 6 $ 33.00 10% $ 198.00 $ 198.00
7.3 Determine risk countermeasures Risk Manager $ 33.00 10% $ - 0 $ - 0
7.3.1 Develop physical controls Risk Manager 6 $ 33.00 10% $ 198.00 $ 198.00
7.3.2 Develop technical controls Risk Manager 6 $ 33.00 10% $ 198.00 $ 198.00
7.4 Develop or acquire high-level policy Project Manager $ 37.00 1% $ - 0 $ - 0
7.4.1 Find Corporate Policy document Project Facilitator 6 $ 33.00 50% $ 198.00 $ 198.00
7.4.2 Review documents Project Facilitator 6 $ 33.00 50% $ 198.00 $ 198.00
7.4.3 Develop or review Security Policy Project Facilitator 6 $ 33.00 50% $ 198.00 $ 198.00
7.5 Develop low-level policies based on high-level policy Project Manager $ 37.00 1% $ - 0 $ - 0
7.5.1 Develop procedures Project Manager 6 $ 37.00 10% $ 222.00 $ 222.00
7.5.1.1 Develop administrative procedures Human Resource Officer 6 $ 23.00 10% $ 138.00 $ 138.00
7.5.1.2 Develop technical/logical procedures Quality Control Officer 6 $ 22.00 100% $ 132.00 $ 132.00
8. Conduct research Project Facilitator $ 33.00 1% $ - 0 $ - 0
8.1 Determine research areas Project Facilitator $ 33.00 1% $ - 0 $ - 0
8.1.1 Make list of required research Project Facilitator 12 $ 33.00 50% $ 396.00 $ 396.00
8.1.2 Determine best fit for research tasks Project Facilitator 12 $ 33.00 50% $ 396.00 $ 396.00
8.1.3 Assign research tasks Project Facilitator 12 $ 33.00 50% $ 396.00 $ 396.00
9. Conduct planning Project Manager $ 37.00 1% $ - 0 $ - 0
9.1 Develop PM plan Project Manager $ 37.00 1% $ - 0 $ - 0
9.1.1 Meet with members Project Manager, Project Facilitator, Quality Control Officer, Finance Officer 4 $ 37.00 50% $ 148.00 $ 148.00
9.1.2 Draft plan Project Manager 4 $ 37.00 25% $ 148.00 $ 148.00
9.1.3 Review plan Project Manager, Risk Manager, Project Facilitator 4 $ 37.00 50% $ 148.00 $ 148.00
9.1.4 Get support for plan Project Manager $ 37.00 1% $ - 0 $ - 0
9.1.4.1 Get sponsor support in writing Project Manager 3 $ 37.00 20% $ 111.00 $ 111.00
9.1.4.2 Get stakeholder support in writing Project Manager 3 $ 37.00 10% $ 111.00 $ 111.00
9.2 Determine requirements Project Manager $ 37.00 1% $ - 0 $ - 0
9.2.1 Determine internal requirements Project Manager $ 37.00 1% $ - 0 $ - 0
9.2.1.1 Gather requirements from sponsor Project Manager 3 $ 37.00 50% $ 111.00 $ 111.00
9.2.1.2 Gather requirements from stakeholder Project Manager 4 $ 37.00 50% $ 148.00 $ 148.00
9.2.1.3 Gather requirements from department Project Manager 4 $ 37.00 50% $ 148.00 $ 148.00
9.2.1.4 Take input from team members Project Facilitator 12 $ 33.00 50% $ 396.00 $ 396.00
9.2.2 Determine external requirements Project Manager $ 37.00 10% $ - 0 $ - 0
9.2.1.1 Make list of vendors Project Facilitator 6 $ 33.00 100% $ 198.00 $ 198.00
9.2.1.2 Get quotes from vendor Project Facilitator 16 $ 33.00 100% $ 528.00 $ 528.00
9.2.1.3 Consolidate external requirements Project Facilitator 6 $ 33.00 100% $ 198.00 $ 198.00
9.3 Define the scope of project Project Manager $ 37.00 5% $ - 0 $ - 0
9.3.1 Determine start and end points Project Manager $ 37.00 5% $ - 0 $ - 0
9.3.1.1 Determine affected equipment Network Administrators 3 $ 24.00 100% $ 72.00 $ 72.00
9.3.1.2 Determine affected services Network Administrators 3 $ 24.00 100% $ 72.00 $ 72.00
9.3.1.3 Determine affected users Network Administrators 1 $ 24.00 100% $ 24.00 $ 24.00
9.4 Determine budget Finance Officer $ 45.00 5% $ - 0 $ - 0
9.4.1 Determine equipment costs Finance Officer $ 45.00 5% $ - 0 $ - 0
9.4.1.1 List equipment costs Finance Officer 7 $ 45.00 40% $ 315.00 $ 315.00
9.4.1.2 Total equipment costs Finance Officer 7 $ 45.00 40% $ 315.00 $ 315.00
9.4.2 Determine labor costs Human Resource Officer $ 23.00 5% $ - 0 $ - 0
9.4.2.1 List labor costs Human Resource Officer $ 23.00 5% $ - 0 $ - 0
9.4.2.1.1 Hire LAN Cabling Contractors Human Resource Officer 16 $ 23.00 $ 368.00 $ 368.00
9.4.2.2 Total equipment costs Finance Officer 16 $ 45.00 $ 720.00 $ 720.00
9.4.2.3 Phase 1 Completed Quality Control Officer 0 $ 22.00 $ - 0 $ - 0
10. Execute the project Project Manager $ 37.00 $ - 0 $ - 0
10.1 Conduct Building Area Assessment Project Facilitator $ 33.00 $ - 0 $ - 0
10.1.1 Assess Building 1 Network Administrators $ 24.00 10% LAN Cabling Contractors $ 100.00 $ - 0 $ 100.00
10.1.1.1 Identify Network Cable Run Network Administrators 16 $ 24.00 10% LAN Cabling Contractors $ 100.00 $ 384.00 $ 484.00
10.1.2 Assess Building 2 Network Administrators $ 24.00 10% LAN Cabling Contractors $ 100.00 $ - 0 $ 100.00
10.1.2.1 Identify Connection to Building One Network Network Administrators 16 $ 24.00 10% LAN Cabling Contractors $ 100.00 $ 384.00 $ 484.00
10.1.3 Assess Risk Risk Manager $ 33.00 5% $ - 0 $ - 0
10.1.3.1 Identify Risk Risk Manager $ 33.00 5% $ - 0 $ - 0
10.1.3.1.1 Tailor risk assessment questionaire Risk Manager 16 $ 33.00 10% $ 528.00 $ 528.00
10.1.3.1.2 Identify known risk Risk Manager 16 $ 33.00 10% $ 528.00 $ 528.00
10.1.3.2 Analyze Risk Risk Manager $ 33.00 5% $ - 0 $ - 0
10.1.3.2.1 Rate each risk based on questionaire (H, M, L) Risk Manager 8 $ 33.00 10% $ 264.00 $ 264.00
10.1.3.2.2 Select highest risk Risk Manager 8 $ 33.00 10% $ 264.00 $ 264.00
10.1.3.2.3 Document the category, description & impact to risk response plan Risk Manager 8 $ 33.00 10% $ 264.00 $ 264.00
10.1.3.3 Response Planning Risk Manager $ 33.00 5% $ - 0 $ - 0
10.1.3.3.1 Consult risk assessment Risk Manager 16 $ 33.00 10% $ 528.00 $ 528.00
10.1.3.3.2 Establish risk response actions Risk Manager 24 $ 33.00 10% $ 792.00 $ 792.00
10.1.3.3.3 Schedule actions Risk Manager 8 $ 33.00 10% $ 264.00 $ 264.00
10.1.4 Conduct Interal Office Space Assessment Project Facilitator $ 33.00 10% $ - 0 $ - 0
10.1.4.1 Designate Computer Suite Placement Project Facilitator 112 $ 33.00 20% $ 3,696.00 $ 3,696.00
10.1.4.2 Designate Multifunction Device Placement Project Facilitator 80 $ 33.00 20% $ 2,640.00 $ 2,640.00
10.1.4.3 Indentify Server Rack Location Project Facilitator $ 33.00 10% $ - 0 $ - 0
10.1.4.3.1 Identify Climate Controlled Room Network Administrators 8 $ 24.00 100% $ 192.00 $ 192.00
10.1.4.3.2 Upgrade closet Network Administrators 16 $ 24.00 100% $ 384.00 $ 384.00
10.2 Acquire equipment Finance Officer $ 45.00 10% $ - 0 $ - 0
10.2.1 IT Procurement Finance Officer $ 45.00 10% $ - 0 $ - 0
10.2.1.1 Purchase Servers Finance Officer 40 $ 45.00 10% $ 10,000.00 $ 1,800.00 $ 11,800.00
10.2.1.2 Purchase Desktop Suite Finance Officer 40 $ 45.00 10% $ 1,400.00 $ 1,800.00 $ 3,200.00
10.2.1.3 Purchase Printers Finance Officer 40 $ 45.00 10% Printers $ 3,200.00 $ 1,800.00 $ 5,000.00
10.2.1.4 Purchase Software Finance Officer $ 45.00 10% $ - 0 $ - 0
10.2.1.4.1 Procure MS Office Small Business 2013 Finance Officer 40 $ 45.00 10% $ 150.00 $ 1,800.00 $ 1,950.00
10.2.1.4.2 Procure Vmware Licensing Finance Officer 40 $ 45.00 10% $ 5,200.00 $ 1,800.00 $ 7,000.00
10.2.1.4.3 Procure Server 2012R2 Finance Officer 40 $ 45.00 10% $ 546.00 $ 1,800.00 $ 2,346.00
10.2.1.5 Purchase Network Equipment Finance Officer $ 45.00 10% $ - 0 $ - 0
10.2.1.5.1 Purchase Server Rack Mounting Hardware Finance Officer 40 $ 45.00 10% $ 500.00 $ 1,800.00 $ 2,300.00
10.2.1.5.2 Purchase Router Finance Officer 40 $ 45.00 10% $ 1,200.00 $ 1,800.00 $ 3,000.00
10.2.1.5.3 Purchase Switches Finance Officer 40 $ 45.00 10% $ 792.00 $ 1,800.00 $ 2,592.00
10.2.2 Receive equipment Project Facilitator $ 33.00 100% $ - 0 $ - 0
10.2.2.1 Configure Internal LAN Network Administrators $ 24.00 50% CatV Cabling, Fiber Cabling $ 416.00 $ - 0 $ 416.00
10.2.2.1.1 Run Network Cables LAN Cabling Contractors $ 100.00 $ - 0 $ 100.00
10.2.2.1.1.1 Add Network Ports 160 LAN Cabling Contractors $ 100.00 $ - 0 $ 100.00
10.2.2.1.2 Complete Server Configuration $ - 0 $ - 0
10.2.2.1.2.1 Create Virtual Servers Network Administrators $ - 0 $ - 0
10.2.2.1.2.1.1 Install Server Network Administrators 6 $ 24.00 $ 144.00 $ 144.00
10.2.2.1.2.1.2 Install Vmware Network Administrators 6 $ 24.00 Vmware $ 5,200.00 $ 144.00 $ 5,344.00
10.2.2.1.2.1.3 Install Server 2012R2 Network Administrators 6 $ 24.00 Server 2012R2 $ 546.00 $ 144.00 $ 690.00
10.2.2.1.2.1.4 Configure Servers Network Administrators 6 $ 24.00 $ 144.00 $ 144.00
10.3 Install equiment Database Developers $ 33.00 15% $ - 0 $ - 0
10.3.1 Create Administrative System Database Developers $ 33.00 15% $ - 0 $ - 0
10.3.1.1 Configure Patient Database Database Developers $ 33.00 20% $ - 0 $ - 0
10.3.1.1.1 Install MS Office Small Business Software Engineer/Installer 80 $ 31.25 50% $ 2,500.00 $ 2,500.00
10.3.1.1.2 Install MS SharePoint Software Engineer/Installer $ 31.25 50% $ - 0 $ - 0
10.3.1.1.2.1 Link to Internal Database Database Developers 8 $ 33.00 25% $ 264.00 $ 264.00
10.3.1.1.3 Import Patient Information Database Developers 56 $ 33.00 25% $ 1,848.00 $ 1,848.00
10.3.1.1.4 Phase 2 Completed Project Facilitator 0 $ 33.00 1% $ - 0 $ - 0
11. Control and monitor project Project Manager $ 37.00 1% $ - 0 $ - 0
11.1 Control scope Project Manager $ 37.00 1% $ - 0 $ - 0
11.1.1 Conduct weekly project meetings - Stakeholder Project Manager $ 37.00 1% $ - 0 $ - 0
11.1.1.1 Conduct meeting with Sponsor/Stakeholders Project Manager 4 $ 37.00 25% $ 148.00 $ 148.00
11.1.1.2 Conduct meeting with project team Project Manager 4 $ 37.00 25% $ 148.00 $ 148.00
11.1.1.3 Ensure risk management plan and risk response plan are implemented Risk Manager 3 $ 33.00 10% $ 99.00 $ 99.00
11.1.1.4 Maintain risk response plan Risk Manager 3 $ 33.00 10% $ 99.00 $ 99.00
11.1.1.5 Risk response tracking Risk Manager 4 $ 33.00 10% $ 132.00 $ 132.00
11.1.2 Conduct weekly project meetings - Project Team Project Manager 3 $ 37.00 25% $ 111.00 $ 111.00
11.1.2.1 Conduct weekly project meetings - Project Team 1 Project Manager 3 $ 37.00 25% $ 111.00 $ 111.00
11.1.2.2 Conduct weekly project meetings - Project Team 2 Project Manager 3 $ 37.00 25% $ 111.00 $ 111.00
11.2.2.3 Conduct weekly project meetings - Project Team 3 Project Manager 3 $ 37.00 25% $ 111.00 $ 111.00
11.2.2.4 Conduct weekly project meetings - Project Team 4 Project Manager $ 37.00 25% $ - 0 $ - 0
11.2.2.5 Conduct weekly project meetings - Project Team 5 Project Manager $ 37.00 25% $ - 0 $ - 0
11.1.3 Test Quality Control Officer $ 22.00 1% $ - 0 $ - 0
11.1.3.1 Define Testing Specifications Quality Control Officer 8 $ 22.00 50% $ 176.00 $ 176.00
11.1.3.2 Test offline network Network Administrators 4 $ 24.00 100% $ 96.00 $ 96.00
11.1.3.2 Test offline network Security Consultant 4 $ 24.00 100% $ 96.00 $ 96.00
11.1.3.3 Test online network Network Administrators 4 $ 24.00 100% $ 96.00 $ 96.00
11.1.3.3 Test online network Security Consultant 4 $ 24.00 100% $ 96.00 $ 96.00
12. Review project status Quality Control Officer $ 22.00 1% $ - 0 $ - 0
12.1 Confirm project status Quality Control Officer $ 22.00 1% $ - 0 $ - 0
12.1.1 Review tests Quality Control Officer 8 $ 22.00 25% $ 176.00 $ 176.00
12.1.2 Meet with sponsor Quality Control Officer 4 $ 22.00 25% $ 88.00 $ 88.00
12.1.3 Meet with stakeholder Quality Control Officer 4 $ 22.00 25% $ 88.00 $ 88.00
12.1.4 Meet with project team Quality Control Officer 4 $ 22.00 25% $ 88.00 $ 88.00
12.1.5 Phase 3 Completed Quality Control Officer 0 $ 22.00 1% $ - 0 $ - 0
13. Document project Project Facilitator $ 33.00 5% $ - 0 $ - 0
13.1 Document project milestones Project Facilitator $ 33.00 5% $ - 0 $ - 0
13.1.1 Document Testing Project Facilitator 24 $ 33.00 100% $ 792.00 $ 792.00
13.1.2 Document installation Project Facilitator 24 $ 33.00 100% $ 792.00 $ 792.00
13.1.3 Document configurations Project Facilitator 24 $ 33.00 100% $ 792.00 $ 792.00
14. Train Veterinarian Staff IT Trainer $ - 0 $ - 0
14.1 Train on Basic System Troubleshooting IT Trainer 8 $ 50.00 100% Training Facility $ 500.00 $ 400.00 $ 900.00
14.2 Train on Application Usage IT Trainer 8 $ 50.00 100% Training Facility $ 500.00 $ 400.00 $ 900.00
14.3 Train on Basic Desktop Maintenance IT Trainer 8 $ 50.00 100% Training Facility $ 500.00 $ 400.00 $ 900.00
15. Close project Project Manager $ 37.00 5% $ - 0 $ - 0
15.1 Complete project documentation Project Facilitator 8 $ 33.00 100% $ 264.00 $ 264.00
15.2 Conduct lessons learned meeting Project Manager 1 $ 37.00 100% $ 37.00 $ 37.00
16. Go Live Sponsor $ - 0 100% $ - 0 $ - 0
Totals $ 31,250.00 $ 51,896.00 $ 83,146.00

Sheet2

Sheet3