Kathy Minor is considering investing up to $100,000 to improve security. She has come to you to help her make a logical decision. What combination of investments would you recommend? In an interoffice memo format provide Kathy with a recommendation and details of your findings. Assume that the existing situations:
Minutes Worse Average Best
Protection: 15 20 25
Detection 10 8 5
Correction 20 14 6
A) An investment of $75,000 would change the estimates for protection time to 19 (worse), 23 (average), 30 (best)
B) An investment of $75,000 would change the estimates for detection time to 7 (worse), 4 (average), 2(best)
C) An investment of $75,000 would change the estimates for corrective time to 10 (worse), 6 (average), 3 (best)
D) An investment of $25,000 would change the estimates for protection time to 17 (worse), 22 (average), 28 (best)
E) An investment of $25,000 would change the estimates for detection time to 9 (worse), 7 (average), 4 (best)
F) An investment of $25,000 would change the estimates for corrective time to 12 (worse), 9 (average), 4 (best)
Using Excel prepare a spreadsheet to perform your analysis. Send an IOM to Kathy explaining your recommendation and your findings.