Question

In: Accounting

Create a cost and benefit analysis. A company has a Ecommerce website that generates $500,000 per...

Create a cost and benefit analysis.

A company has a Ecommerce website that generates $500,000 per year.

Calculate the annualized rate of occurrence (ARO) and annualized loss expectancy (ALE) for each risk:

Category Cost per incident Frequency of occurrence
Programming errors $1,000 2 per week
Information theft(hacker) $2,000 1 per quarter
Information theft(employee) $5,000 1 per year
Viruses $1,000 1 per year
Denial of service attacks $3,500 1 per 6 month
Natural diaster $100,000 1 per 20 years

-Make sure to convert frequency of occurrence to yearly base.-

One year past, calculate the cost and benefit of controls that have been in place.

Category Cost per incident Frequency of occurrence Cost of control Type of control
Programming errors $1,000 2 per week $2500 Training
Information theft(hacker) $2,000 1 per quarter $10,000 Firewall
Information theft(employee) $5,000 1 per year $10,000 Physical security
Viruses $1,000 1 per year $10,000 Anti-virus
Denial of service attacks $3,500 1 per 6 month $10,000 Firewall
Natural diaster $100,000 1 per 20 years $15,000 Insurance

Solutions

Expert Solution

Annualized rate of occurrence refers to the probability that a risk will occur in a specific year. For instance, if a statistic indicate that a serious accident is likely to occur once in 20 years, then the ARO is 1/20 = 0.05. This implies that we have to convert the frequency of occurrence to the yearly base for each category.

In case of Programming errors which has a frequency of occurrence of 2 per week implies that there will be two Programming errors each week and there are 52 weeks in a year, therefore, the annualized rate of occurrence (ARO) for Programming errors of 2 per week will become 2*52 = 104 Programming errors per year.

In case of Information theft (hacker) which has a frequency of occurrence of 1 per quarter implies that there will be one Information theft (hacker) every quarter and there are four quarters in a year, therefore, the annualized rate of occurrence (ARO) for Information theft (hacker) of 1 Information theft (theft) per quarter will become 1*4 = 4 per year.

In case of Information theft (employee) and viruses which have a frequency of occurrence of 1 per year implies that there will be one Information theft (hacker) and viruses every year, therefore, the annualized rate of occurrence (ARO) for Information theft (employee) and viruses of 1 per year will become 1*1 = 1 Information theft (employee) and viruses per year.

In case of Denial of service attacks which has a frequency of occurrence of 1 per 6 month implies that there will be one Denial of service attacks every six months and there are two six months in a year, therefore, the annualized rate of occurrence (ARO) for Denial of service attacks of 1 per six months will become 1*2 = 2 Denial of service attacks per year.

Finally, in case of Natural disaster which has a frequency of occurrence of 1 per 20 years implies that there will be one Natural disaster every 20 years, therefore, the annualized rate of occurrence (ARO) for Natural disaster of 1 per 20 years will become 1/20 = 0.05 Natural disasters per year.

Therefore, the respective ARO will be

Category Annualized rate of occurrence (ARO)
Programming errors 104
Information theft(hacker) 4
Information theft(employee) 1
Viruses 1
Denial of service attacks 2
Natural disaster 0.05

Annualized loss expectancy (ALE) = Single Loss expectancy (SLE) * Annualized Rate of Occurrence (ARO). Therefore, ALE = SLE × ARO

But SLE = Asset value × Exposure Factor (EF)

So for us to calculate the SLE we need to compute Exposure Factor (EF). Exposure Factor (EF) is defined as the subjective, potential percentage of loss to a particular asset in case the particular threat is realized. Exposure factor represents the value to which the asset value is reduced. Given that E-bidding Company has a ecommerce website generating $500,000 per year, the Asset Value is $500,000, therefore,

  • EF for Programming errors with a cost per incident of $1,000 is $1,000/$500,000 = 0.002
  • EF for Information theft (hacker) with a cost per incident of $2,000 is $2,000/$500,000 = 0.004
  • EF for Information theft (employee) with a cost per incident of $5,000 is $5,000/$500,000 = 0.001
  • EF for Viruses with a cost per incident of $1,000 is $1,000/$500,000 = 0.002
  • EF for Denial of service attacks with a cost per incident of $3,500 is $3,500/$500,000 = 0.007
  • EF for Natural disaster with a cost per incident of $100,000 is $100,000/$500,000 = 0.2

From the above EF, we can now calculate SLE = Asset value × Exposure Factor (EF)

Category SLE= Asset value × Exposure Factor (EF)
Programming errors 0.002× 500,000 = $1,000
Information theft(hacker) 0.004× 500000= $ 2,000
Information theft(employee) 0.001×500000 = $5,000
Viruses 0.002× 500000 = $1,000
Denial of service attacks 0.007×500000 = $3,500
Natural disaster 0.2×500000 =$100,000

Finally, to arrive at ALE we multiply SLE by ARO

Category ALE= ARO × SLE
Programming errors 104× $1,000 = $104,000
Information theft(hacker) 4× $ 2,000 = $8,000
Information theft(employee) 1×$5,000 = $5,000
Viruses 1× $1,000 = $1,000
Denial of service attacks 2×$3,500 = $7,000
Natural disaster 0.05×$100,000 = $5,000

One year past, calculate the cost and benefit of controls that have been in place.

Category Cost per incident Frequency of occurrence Cost of control Type of control
Programming errors $1,000 2 per week $2500 Training
Information theft(hacker) $2,000 1 per quarter $10,000 Firewall
Information theft(employee) $5,000 1 per year $10,000 Physical security
Viruses $1,000 1 per year $10,000 Anti-virus
Denial of service attacks $3,500 1 per 6 month $10,000 Firewall
Natural disaster $100,000 1 per 20 years $15,000 Insurance

Solution

In carrying out the Cost/benefit analysis, we need to find the annual cost of the countermeasure which is cost of control multiplied by Annualized Rate of Occurrence (ARO) which is shown in the table below.

Type of control = ARO × cost of control
Training 104× $2,500 = $260,000
Firewall 4× $ 10,000 = $40,000
Physical security 1×$10,000 = $10,000
Anti-virus 1× $10,000 = $10,000
Firewall 2×$10,000 = $20,000
Insurance 0.05×$15,000 = $750

After calculating the annual cost of the countermeasure, we compare it with the Annualized loss expectancy (ALE) to see if there are net benefits or net losses.

Annualized loss expectancy-Annual cost of control = Net benefits (losses)

Type of control Net benefits (losses)
Training $104,000 – $260,000 = -$156,000
Firewall $8,000- $40,000 = -$32,000
Physical security $5,000 – $10,000 = -$5,000
Anti-virus $1,000 – $10,000 = -$9,000
Firewall $7,000 – $20,000 = -$13,000
Insurance $5,000 – $750 = $4,250

From the table below, it is clear that all the types of control other than Insurance are not worthwhile as they have not losses rather than net benefits. It costs more money to protect against the risks. It costs more to protect against the potential loss and hence the risk is rather increased and not reduced. Therefore, it is not logical from a business point of view as the firm will spend more money that they can potentially lose


Related Solutions

Wen-Ching is working to develop a preliminary cost-benefit analysis for a website to support the leasing...
Wen-Ching is working to develop a preliminary cost-benefit analysis for a website to support the leasing department at a major university. She developed the following estimates. Development costs – Personnel 2 Systems Analysts       350 hours each at $80/hour 2 Agile Programmer/testers   350 hours each at $70/hour 1 Web designer           100 hours at $125/hour 1 Telecom specialist       20 hours at $150/hour 1 Database specialist       110 hours at $100/hour Development costs – Training 2 interactive training seats...
Create a cost-benefit analysis for regulating the sharing economy in Canada. Identify the stakeholders.
Create a cost-benefit analysis for regulating the sharing economy in Canada. Identify the stakeholders.
Suppose that you are interested in buying a new computer. Create a cost benefit analysis that...
Suppose that you are interested in buying a new computer. Create a cost benefit analysis that illustrates the return on investment that you would receive from making this purchase. Computer-related websites (e.g., Apple, Dell, HP) should have real tangible costs that you can include in your analysis. Project your numbers out to include a three-year period and provide the net present value of the final total.
Create a cost-benefit analysis for legalizing marijuana in Canada. Identify 2-3 stakeholders.
Create a cost-benefit analysis for legalizing marijuana in Canada. Identify 2-3 stakeholders.
• Do a cost-benefit analysis of the selected healthcare organization. Explain your analysis of the cost-benefit...
• Do a cost-benefit analysis of the selected healthcare organization. Explain your analysis of the cost-benefit ratio and how it helps an organization. • Explain the impact of the cost-benefit ratio on recruitment and retention strategies of a healthcare organization. • Outline ways to improve the cost-benefit ratio of the selected healthcare organization. • Explain the role of HRM in ensuring the most competitive compensation package for employees. • Describe methods of improving the compensation package of the selected healthcare...
how does cost benefit analysis differ from cost effectiveness analysis? why has cost effectiveness analysis become...
how does cost benefit analysis differ from cost effectiveness analysis? why has cost effectiveness analysis become the method of choice in health economists around the world
Fixed costs are assumed to be $500,000 per year. The company estimates the variable cost per...
Fixed costs are assumed to be $500,000 per year. The company estimates the variable cost per unit (v) to be $75 and expects to sell each unit for $425. There are no taxes and the required rate of return is 22% per year. Suppose that sales are currently estimated to be 5000 units per month. What is the degree of operating leverage?   (Round to 1 decimal place, ie 2.3) Using your answer from above, estimate what the new monthly operating...
Discuss the challenges associated with the cost and benefit estimation methods in a cost-benefit analysis of...
Discuss the challenges associated with the cost and benefit estimation methods in a cost-benefit analysis of pollution abatement. 5 MARKS
explain project cost-benefit analysis?
explain project cost-benefit analysis?
What is cost-benefit analysis? How would you apply cost-benefit analysis to your decision to go to...
What is cost-benefit analysis? How would you apply cost-benefit analysis to your decision to go to college? What are the benefits and what are the costs of going to college? b. What happens to your analysis if the interest rate rises? What happens if the payoff period shrinks? Who is more likely to find college economically worthwhile: you for your 63-year-old professor? c. How would you apply cost-benefit analysis to environmental policy? What are the costs of pollution? What are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT