Prepare a weighted scoring model to compare the above projects using Microsoft Excel. Develop at least ten criteria, assign weights to each criterion, assign scores, and then calculate the weighted scores. (Be sure to show all computations using formula in Microsoft Excel).

A. Automated Claim Processing System: Develop an automated system to replace the current manual claim processing system. In the current manual claim processing system the claimants contact an agent via phone and the agent records all the information of the claimants manually. The field offices arrange inspection and makes estimates of the claim. This information from the field insurance offices is then faxed over to the claims processing department of the corporate office. The corporate office then makes the payment to the claimants. You estimate that the automation project would save your company $1.5 million each year for the next three years. The project is estimated to take 18 months and cost about $750,000 for development and maintenance. B. Health Coverage Cost Monitoring System: Develop an application to track employee health care expenses and company health care costs. Health care premiums continue to increase, and the company has changed insurance carriers several times in the past ten years. This application should allow business modeling of various scenarios as well as tracking and analyzing current and past employee health care expenses and company health care costs. This could access it and download selective data for further analysis. The new application must also import data from the current systems that track employee expenses submitted to the company and the company's costs to the insurance provider. You believe that having this data will help you revise policies concerning employee contributions to health care premiums and help you negotiate for lower premiums with insurance companies. You estimate that this application would save your company about $20/employee/year for full-time employees over the next four years and cost about $100,000 to develop C. Web Portal for Customer Services: Develop a Web-based application to improve the delivery of products and services. The web portal will serve the existing as well as potential customers. Through this web-based interface the prospective and existing customers will be able to get an insurance quote, existing customers can login to manage their policies with abilities to add or remove coverage, view bills online, make online make payments, and file claims electronically. This interface will also serve as the main web interface for the company. You estimate that this system would save your company about $2 million each year for three years after implementation. You estimate it will take one year and $3 million to develop and require 10 percent of development costs each year to maintain. D. Payroll System Upgrade Project: Develop a new software and hardware solution to replace the company's age-old payroll system which has been limited in functionality and runs on old outdated technology. The current system also requires payroll data to be entered manually from paper- ed time-card submitted by employees. The proposed upgrade will allow employees to enter and all employee data will be saved in a large centralized database. The proposed new system will process direct deposit and print electronic payment slips. This centralized payroll system will be run from the corporate head quarters and bring all the employees of the field offices under this system. This new centralized system will also eliminate the separate payroll systems run by field offices thus reducing costs. You estimated that this proposed system would increase company profit by $1 million each year for the next three years and cost about $800,000 each year for development and maintenance. A. Automated Claim Processing System: Develop an automated system to replace the current manual claim processing system. In the current manual claim processing system the claimants contact an agent via phone and the agent records all the information of the claimants manually. The field offices arrange inspection and makes estimates of the claim. This information from the field insurance offices is then faxed over to the claims processing department of the corporate office. The corporate office then makes the payment to the claimants. You estimate that the automation project would save your company $1.5 million each year for the next three years. The project is estimated to take 18 months and cost about $750,000 for development and maintenance. B. Health Coverage Cost Monitoring System: Develop an application to track employee health care expenses and company health care costs. Health care premiums continue to increase, and the company has changed insurance carriers several times in the past ten years. This application should allow business modeling of various scenarios as well as tracking and analyzing current and past employee health care expenses and company health care costs. This could access it and download selective data for further analysis. The new application must also import data from the current systems that track employee expenses submitted to the company and the company's costs to the insurance provider. You believe that having this data will help you revise policies concerning employee contributions to health care premiums and help you negotiate for lower premiums with insurance companies. You estimate that this application would save your company about $20/employee/year for full-time employees over the next four years and cost about $100,000 to develop C. Web Portal for Customer Services: Develop a Web-based application to improve the delivery of products and services. The web portal will serve the existing as well as potential customers. Through this web-based interface the prospective and existing customers will be able to get an insurance quote, existing customers can login to manage their policies with abilities to add or remove coverage, view bills online, make online make payments, and file claims electronically. This interface will also serve as the main web interface for the company. You estimate that this system would save your company about $2 million each year for three years after implementation. You estimate it will take one year and $3 million to develop and require 10 percent of development costs each year to maintain. D. Payroll System Upgrade Project: Develop a new software and hardware solution to replace the company's age-old payroll system which has been limited in functionality and runs on old outdated technology. The current system also requires payroll data to be entered manually from paper- ed time-card submitted by employees. The proposed upgrade will allow employees to enter and all employee data will be saved in a large centralized database. The proposed new system will process direct deposit and print electronic payment slips. This centralized payroll system will be run from the corporate head quarters and bring all the employees of the field offices under this system. This new centralized system will also eliminate the separate payroll systems run by field offices thus reducing costs. You estimated that this proposed system would increase company profit by $1 million each year for the next three years and cost about $800,000 each year for development and maintenance