Homework # 5 Risk Determination & Decision Tree Analysis 1. Review Module-5 Lecture Notes and Chapter Readings 2. Use the Risk Determination Excel Workbook and complete the following worksheets: a. Corporate Assets Risk Summary – Tab ( 25-Points ) i. Use the Reference Tab in the workbook to select the appropriate values from the respective tables and complete Columns C, D, E, F, & G ( Hint : use the Threat Vulnerability Reference Table; return the numerical value for the corresponding probability and impact). Threat   Vulnerability Work Table Impact Low Medium High Probability High 3 6 9 Medium 2 5 8 Low 1 4 7 ii. Column H (Risk Score) is a calculated field already formatted iii. Column I (Possible Safeguards) provide the safeguards you would put in place to mitigate the threat (e.g., controls, policies, etc.); provide sufficient level of detail iv. Column J (Cost Estimates) provide cost estimates/ranges for the safeguards you would put in place to mitigate the threat; provide sufficient level of detail in the Comments Section Column K . v. Provide thorough summary analysis of each section b. Occupation Analysis – Tab ( 25-Points ) i. Use the Risk Level Table provided on worksheet (Cells B25-C31) to assign the appropriate value for each occupation and the corresponding threats outlined in Columns C,D,E,& F ii. Column G (Total) is a calculated filed already formatted iii. Complete the occupational analysis; answer the four questions after completing your occupational vulnerability assessment; provide sufficient level of detail in your responses. c. Decision Tree Analysis – Tab ( 50-Points ) i. Examine the Decision Tree Analysis for enterprise CRM solution approach ii. Complete the corresponding tables for both paths and individual branches referencing the values in the decision tree diagram. iii. Some of the data is already populated iv. Total fields, Branch Total fields, and Value Fields are calculated fields and are already formatted v. Answer the question regarding which options provides the best overall value vi. Explain your reasoning for the choice you made, response should be based on your analysis of the decision tree results. vii. Hint : Only one of the value fields should have a negative value when finished 3. Complete the Risk Determination Worksheets (M.S. Excel Document not PDF) and upload the file using the designated link on Moodle on or before the assignment due date.

Looking for solution of this Assignment?


We deliver quality original papers

Our experts write quality original papers using academic databases.  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay