| Labor | Rate ($) | Year 1 hrs | Year 1$ | Year 2hrs | Year 2 $ | Year 3hrs | Year 3$ | Year 4hrs | Year 4 $ | Notes: |
| Project Manager | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Full time Years 1&2, Half time year 3, 0 in year 4 | www.salary.com for pay rate & include the burden rate of 50% |
| Desktop Support | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | There are 2 Personnel- Half time years 1, 2, 3, full time in year 4 | 2080 working hours per year (40hr x 52 weeks) |
| Server maintenance | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Full time Years 1&2, Half time year 3, 25% time in year 4 | This color shows where you input your data |
| SharePoint Developer | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Full time in year 1 |
| Software Trainer | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Full time in year 1. Half time in years 2, 3, 4, |
| Customer Support | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | There are 2- Personnel 18 hours/month and increases 4 hours per month each year |
| Totals | cost | # | 0.00 | # | 0.00 | # | 0.00 | # | 0.00 |
| Hardware/Software |
| Exchange Server | 2,299.99 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Server # increases by 1 in year 3 |
| Office Pro Plus | 399.99 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | = total # of users (you do not add anything here it will self-calcuate ) |
| Visio Pro | 589.00 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | = total # of users (you do not add anything here it will self-calcuate ) |
| Project Pro | 1,159.92 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | = total # of users (you do not add anything here it will self-calcuate ) |
| | | | 0.00 | | 0.00 |
| Utilities Expenses per hr | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | 8760 potential uptime hours per year per Server | 24 hours a day multiplied by 365 days |
| Totals | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Resesearch commercial utility rates for kwh in SC | kwh = Kilowatts per hour |
| Training | $per user | # of new | | # of new | | # of new | | # of new |
| | $138 |
| Users Total | | 0 | | 0 | | 0 | | 0 | | There are 125 new users in the first year |
| New | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Year 2 there is an increase of 10% of new users over the previous year |
| | | | | | | | | | | Year 3 there is a decrease of 30% of new users over the previous year |
| TCO | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Year 4 there is a decrease of 50% of new users over the previous year. |
| per user | | | ERROR:#DIV/0! | | ERROR:#DIV/0! | | ERROR:#DIV/0! | | ERROR:#DIV/0! |
| Total TCO | | | | | 0.00 | | 0.00 | | 0.00 |
Note to Self 
2TCO-ROIworksheet-forOfficein-house.xlsx
