Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Case Study Shorecliff College Shorecliff College is a liberal arts college located on the West Coast. You are the analyst to conduct the project analysis

Case Study Shorecliff College

Shorecliff College is a liberal arts college located on the West Coast. You are the analyst to conduct the project analysis of the development of a new listing system for the schools housing office.

Background

The housing office has decided to create a new listing system. 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 commercial 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 25 hours of overtime per month. This employee is paid $22 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 20 hours a month going through the 15 binders at the housing office, and pulling all old listings for review by a housing office staff member. This student is paid $12 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 4 hours a week performing maintenance, file backups, and updating of the new system, at $22 per hour.

The university 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 rental receipts total $340,000. Rents are increased four percent a year across the board.

Based on your research, you originally estimated that an in-house development project could be completed in about three weeks. This time estimate is based on 35 hours a week for you and another analyst from the IT department. The IT department uses a chargeback rate of $35 per hour for work for other university departments.

As an alternative to in-house development, a commercial software package is available for about $9,000, including an on-site day of training and tech support for the first year. If the department buys the package, it would take you about four weeks to install, configure, and test it, working full-time. The vendor provides free support during the first year of operation, but then the housing office must sign a tech support agreement at an annual cost of $1,000.

Training and support for an in-house system would require 30 hours from a training specialist in the IT department, billed at $30 per hour, to develop training materials and provide training. The training materials would be added to documentation created during in-house development, and a training session for IT support staff would be provided, at an additional $10 per hour charge. Training and tech support for the first year for the vertical software package is included in the initial price.

For both the in-house development and the commercial software package, the necessary hardware will cost about $3,000. Network upgrading, necessary for either option, has been estimated at $5,000 by the network operations group.

In your view, the useful life of the system will be about five years, including the year in which the system becomes operational.

Assignments

Your report to the housing office should include the following analyses:

1. Provide an overview of the proposed system, including costs and benefits.

2. Perform financial analyses, including net present values, ROI, and payback analysis, assuming a discount rate of 8% in the period.

3. Provide a brief explanation of the alternatives, including in-house development and purchase of commercial software package, and make your recommendation to the administration.

Submit your report in Word format and attach the Excel workbook upon submission.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Life Audit

Authors: Michelle Moroney

1st Edition

978-0717184736

More Books

Students also viewed these Accounting questions