Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on your earlier recommendations, Willowbrook decided to continue the systems development process for a new information system that would improve operations, decrease costs, and

Based on your earlier recommendations, Willowbrook decided to continue the systems development process for a new information system that would improve operations, decrease costs, and reduce some of the administrative workload. Willowbrook would like you to create a financial report that will define the costs and benefits of this project. You must examine tangible costs and benefits to determine the economic feasibility of several alternatives. The finance and fundraising committees will need to examine the costs and benefits to determine if the development process will go ahead. If Willowbrook School decides to go ahead with the development process, the system can either be developed in-house or a vertical package can be purchased and configured to meet the needs of the school. Currently, Susan Brown is logging 30 hours of overtime a month to accomplish the increased workload associated with increased enrollment and school expansion. She is being compensated for overtime at the rate of $12 per hour. Based on current enrollment projections, the overtime will need to be expanded to 70 hours a month for the billing requirements for the next school year as the final grade in the 4-6 classroom comes online. The overtime requirement would be eliminated if Willowbrook implements the new system. The current system now causes an average of twenty errors per month, and each error takes about 30 minutes to correct. The new system should eliminate those errors. Based on your research, you originally estimated by working full-time you could complete an in-house development project in about 8 weeks. Your consulting rate, which Willowbrook agreed to, is $50 per hour. If you design the new system as a database application, you can expect to spend about $2,000 for a networked commercial package. One of the parents at Willowbrook has extensive experience with this package as a Database Administrator at a local company and has committed to providing 15 hours per week working with you to develop the project. You have agreed to reduce your estimate to 25 hours per week for 8 weeks to take advantage of this offer. After the system is operational and the staff is trained, you hope that Willowbrook staff and volunteers can handle routine maintenance tasks without your assistance. As an alternative to in-house development, a vertical software package is available for about $7,500. The vendor offers a lease-purchase package of $2,500 down, followed by two annual installments of $2,500 each. If Willowbrook buys the package, it would take you about three weeks to install, configure, and test it, working full-time. The vendor provides free support during the first two years of operation, but then Willowbrook must sign a tech support agreement at an annual cost of $500. Although the package contains many of the features that Willowbrook wants, most of the reports are pre-designed and it would be difficult to modify their layouts. You have agreed to provide 5 hours per week of training and support for the first two months of operation. After the new system is operational, it will need routine maintenance, file backups, and updating. These tasks will require about four hours per week and will be performed by school staff or parent volunteers (use the overtime rate of $12 per hour for maintenance). For both the in-house development and the vertical software package, the necessary hardware will cost about $3,000. Hardware and network installation will be provided by three parent volunteers. In your view, the useful life of the system will be about five years, including the year in which the system becomes operational. The development of the new system will occur in Year 0, but the system will not be used until Year 1. The school will use the manual system during development and will switch over to the new system during the month of June, to start the new school year on the new system. Task Create a financial report for Willowbrook School including the sections outlined below. The report should be a document that can be opened in Microsoft Word or Adobe Reader. The documents should be in report format and not just lists. Costs and Benefits

1. Itemize each cost for Willowbrook School.

2.Itemize each benefit for Willowbrook School.

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

Step: 3

blur-text-image

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

I Don T Trust You But Blockchain And Bitcoin Will Help

Authors: Damu Winston Mba

1st Edition

1734182512, 978-1734182514

More Books

Students also viewed these Finance questions