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).NAME:
SLE
(Pre)
Programmer Mistakes
Loss of Intellectual Property
Software Piracy
Theft of Information (External)
Theft of Information (Internal)
Web Defacement
Theft of Equipment
Viruses, Worm, Trojan Horses
DoS Attack
Earthquake
Flood
Fire
$5,000
$75,000
$500
$2,500
$5,000
$500
$5,000
$1,500
$2,500
$250,000
$250,000
$500,000
Programmer Mistakes
Loss of Intellectual Property
Software Piracy
Theft of Information (External)
Theft of Information (Internal)
Web Defacement
Theft of Equipment
Viruses, Worm, Trojan Horses
DoS Attack
Earthquake
Flood
Fire
Cost of
Control
$20,000
$15,000
$30,000
$15,000
$15,000
$10,000
$15,000
$15,000
$10,000
$5,000
$10,000
$10,000
Frequency
(Pre)
1 per week
1 per year
1 per week
1 per quarter
2 per year
1 per month
1 per year
1 per week
1 per quarter
1 per 20 years
1 per 10 years
1 per 10 years
ARO
(Pre)
Type of Control
CBA
Training
Firewall/IDS
Firewall/IDS
Firewall/IDS
Phys. Security
Firewall
Phys. Security
Antivirus
Firewall
Insurance/Backup
Insurance/Backup
Insurance/Backup
ALE
(Pre)
SLE
(Post)
$5,000
$75,000
$500
$2,500
$5,000
$500
$5,000
$1,500
$2,500
$250,000
$50,000
$100,000
Frequency
(Post)
1 per month
1 per 2 year
1 per month
2 per year
1 per year
1 per quarter
1 per 2 year
1 per month
2 per year
1 per 20 year
1 per 10 year
1 per 10 year
ARO
(Post)
ALE
(Post)
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.