Calculate ARO, ALE, and CBA, computer science homework help
Q1. Calculate ARO, ALE, and CBAOne year ago, the Mesusa Corporation conducted a threat evaluation and created a list of threats, the cost per incident and the projected frequency of occurrence. During the year, Mesusa decided to implement controls designed to reduce the cost per incidence and the number of threats. The spreadsheet, MesusaControls.xls, indicates thepre-control cost and frequency of occurrence, the cost of controls for each type of threat, and the post-control cost and frequency of occurrence. Calculate the AROs, theALEs and the CBA for this initiative, and return the completed spreadsheet. You can use the websites linked above to help you out. Please include your name on your spreadsheet before submission.NOTE: The spreadsheet is provided below.Submission RequirementsFormat: Microsoft ExcelFont: Arial, 12-PointReference:Instructor NotesStudents usually have trouble with calculating ALE, SLE, and ARO. You may want to take another look at this before you start your homework.ALE is a common quantitative method for assessing risk.The first step in calculating ALE is to calculate Single Loss Expectancy (SLE). --> SLE = asset value * exposure factorALE is then calculated by multiplying SLE by Annualized Rate of Occurrence (ARO). --> ALE = SLE * AROFor example, to calculate the exposure factor, assume the asset value of a small office building and its contents is $2 million. Also assume that this building houses the call center for a business, and the complete loss of the center would take away about half of the capability of the company. Therefore, the exposure factor is 50 percent. The SLE is $2 million * 0.5 = $1 millionThe ALE is then calculated simply by multiplying the SLE by the number of times the event is expected to occur in a year, which is called the annualized rate of occurrence (ARO): --> ALE = SLE * ARO If the event is expected to occur once in 20 years, then the ARO is 1/20. Typically the ARO is defined by historical data, either from a company’s own experience or from industry surveys. Continuing our example, assume that a fire at this business’s location is expected to occur about once in 20 years. Given this information, the ALE is: $1 million * 1/20 = $50,000. Therefore, in order to protect the office building the company should spend no more than $50,000 on countermeasures protecting the building from complete loss. •Office building and contents = $2 million •Exposure factor 50% •SLE = $2 million * 0.5 = $1 million •ALE = SLE * ARO •ARO = 1/20 (One occurrence every 20 years) •ALE = $1 million * 1/20 = $50,000The Mesusa Controls.xls spreadsheet is needed for assignment.MesusaControls-yourname(1).xls Q2. Write about Importance of Firewall in Network Security ? and also Write about future Generation Firewalls.Requirement : One to One and Half Page. Please Note that it's Overall Two Page work and i am also Giving Two days time for this. So, $10 is the maximum that i can pay for this question. But, I promise that will assign 70% of my coming works to you. (I post 10 - 20 works every week).