1. Create a System Maintenance plan recommendation to maintain the new system. ( 30pts) Include the following in your System Maintenance Plan: - Corrective maintenance: Server upkeep Availability of the SIM system Integration with the parts system - Adaptive maintenance: Adding new functionality Adding new reports Making it more user friendly - Perfective maintenance: Automate repetitive tasks Optimize user settings - Preventative maintenance Installation of patches/updates Install new antivirus updates Analyze issues 2. List Pros (minimum 4) and Cons (minimum 4) for doing the system maintenance Inhouse and for outsourcing it. (15 pts) 3. Make a list of security risks that includes these 6 areas: physical, network, application, file, user, and procedural. Identify minimum of 3 risks for each area (20 pts) 4. Decide on and justify the system backup method to be used - explain why you have chosen this method (what are the benefits) (15 pts) 5. Calculate the cost feasibility for this new system given the security, training, and maintenance costs, assuming that the system will be developed in-house. Assess the system's TCO for the next 5 years. (30 pts) Excel Spreadsheet Required. You will use the Resource library (Build costs and durations), the textbook, emails, and online research to perform these activities. EMAILS: Our system administrator was asking me about the security for SIM. You and I have not discussed this topic in depth. We need to do a risk assessment and look at all types of security issues: physical, network, application, file, user, and procedural. Make a list of the security risks for all six security levels. We need to make sure that we don't leave our new system vulnerable to attacks. Also, what is the backup method to be used for SIM? Please explain why you've chosen this method. Hope you had a great weekend! Carlie Email\#2 As you well know, maintenance on any system is essential to fix mistakes, add enhancements, or maintain security. I was wondering what you were thinking for SIM's ongoing maintenance plan. We are hoping that this system will last for the next 5 years. We will have to assume responsibility for maintenance if we build this system in-house. Do you think we should hire enough IT staff to maintain this system in-house or should we outsource it? To help the company think this decision through, please make two lists for pros and cons of in-house maintenance vs. outsourced maintenance. Could you get this to me today? Thanks! Carlie Email \# 3 Now that we have isolated the necessary features for an in-house built system, we need figure out if it will be economically feasible to build this software. Mae Roth has asked for the bottom-line numbers for this project. Not only do we need to tell her how much the system will cost to build, but she wants to know what the total cost of ownership would be if we use this system for the next 5 years. You will need give her the numbers in net present value. Since our IT team is unionized, their contract states that they will get a $3/ hour raise each year for the next 5 years. Assume that we will need 2 servers initially for this project. Also assume that we will have to replace these servers every two years. In the spreadsheet that you create, show the initial build cost and the cost for years 2-5 of maintenance. Finally, give the NPV for the entire project. After the cost feasibility is complete, Mae will finally decide between the pre-packaged software and an in-house build. Thanks for all your incredible work on this project