Group7.xlsx - Willowbrook School System Plan A In House...

Willowbrook School System
Plan A: In House Costs
Costs: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Consultant Time for development 10,000
Purchase necessary software 2000
Hardware 3000
Consultant training time 2000
Office staff maintenance(s) - 2496 2496 2496 2496 2496
Total Costs 17,000 2496 2496 2496 2496 2496
Benefits:
Eliminate Overtime - 4320 4320 4320 4320 4320
Eliminate additional position - 5760 5760 5760 5760 5760
Eliminate daily errors - 1440 1440 1440 1440 1440
Total Benefits 11520 11520 11520 11520 11520
Plan B: Purchase Vertical Software Package Costs
Costs: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Purchase price for package 2500 2500 2500
Tech Sup Contract 500 500 500 500 500
Consultant Time to install 6000
Hardware 3000
Consultant training time 2000
Office Maintenance(s) - 2496 2496 2496 2496 2496
Total Cost 13500 5496 5496 2996 2996 2996
Benefits:
Eliminate Overtie 4320 4320 4320 4320 4320
Eliminate additional position 5760 5760 5760 5760 5760
Eliminate Daily Errors 1440 1440 1440 1440 1440
Total Benefits 11520 11520 11520 11520 11520
Payback Analysis
Plan A: In House
Costs Cumulative Costs Benefits Cumulative Benefits
Year 0 17000 17000 - -
Year 1 2496 19496 11520 11520
Year 2 2496 21992 11520 23040
Year 3 2496 24488 11520 34560
Year 4 2496 26984 11520 46080
Year 5 2496 29480 11520 57600