Assignment #2 - Willowbrook College - Due Jun 27th (by 11:59PM via iLearn DropBox) Willowbrook College is a liberal arts college located on the East Coast. You are the systems analyst assigned from the college IT department to conduct the systems analysis phase of the development of a new listing system for the school's housing office. Background Based on your earlier recommendations, the housing office decided to continue the systems development process for a new listing system. Now, at the end of the systems analysis phase, you are ready to prepare a system requirements document and give a presentation to the housing office. You must examine tangible costs and benefits to determine the economic feasibility of several alternatives. If the housing office decides to go ahead with the development process, the system either can be developed in-house or a vertical package can be purchased and configured to meet the needs of the office. Housing listings are created by an employee at the housing office. While the demands on her time vary throughout the year, based on previous work logs kept by employees in the office you determine that the time spent maintaining the manual system (creating listing sheets for the various binders, copying, and filing listings in binders) by this employee works out to an average of 36 hours of overtime per month. This employee is paid $25 per hour, including overhead. Housing listings are pulled throughout the month, and all listings are reviewed once a month to delete those more than two months old. Currently, the once-a-month reviews are done by a student worker who spends 22 hours a month going through the 18 binders at the housing office and pulling all old listings for review by a housing office staff member. This student is paid $16 per hour, including overhead. A new system would conduct this review automatically and generate a list for review. Your estimates indicate that the housing office can expect to have staff spend 6 hours a week performing maintenance, file backups, and updating of the new system, at $25 per hour. The universiry has lost revenue on some of its rental properties, having them lie idle for a month because of listings pulled either erroneously by staff, or deliberately by people using the housing listing service. Estimates put the amount of lost revenue due to listing problems such as these at three percent of anticipated yearly rental receipts. In the current year, the anticipated reutal receipts total $375,000. Rents are increased 3 percent a year across the board. 1. Provide an overview of the proposed system, including costs and benefits, (Sell the customer on the potential benefits of the proposed system). (5 Marks) 2. Conduct feasibility analysis, using payback analysis (identifying payback period) and/or Indicating ROI (Return on Investment). (5 Marks) 3. Provide a brief explanation of the various alternatives that should be investigated if development continues, including in-house development and any other possible strategies. Identify advantages and disadvantages of each alternative strategy. ( 5 Marks)