| 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 & double to include the burden rate |
| 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) |
| 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 | Half time in years 1, 2, 3, 4, | This color shows where you input your data |
| 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 | | | 0.00 | | 0.00 | | 0.00 | | 0.00 |
| Hardware/Software | Cost | # of users | | # of users | | # of users | | # of users |
| Exchange online server | 47.63 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Online server license for IT staff of 20 personnel/year |
| MS Enterprise Office
online | 238.00 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | = total # of users |
| Project Online | 691.00 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | = total # of users |
| Visio Online | 154.96 | | 0.00 | | 0.00 | | 0.00 | | 0.00 | = total # of users |
| | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | 8760 potential uptime hours per year per Server |
| Totals | | | 0.00 | | 0.00 | | 0.00 | | 0.00 |
| Training | $per user | # of new | | # of new | | # of new | | # of new |
| | 138.00 |
| Users Total | | 0 | | 0 | | 0 | | 0 | | # of new users increases by 10% per year |
| New | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | Starts with 125 users in year 1 |
| TCO | | | 0.00 | | 0.00 | | 0.00 | | 0.00 | |
| per user | | | ERROR:#DIV/0! | | ERROR:#DIV/0! | | ERROR:#DIV/0! | | ERROR:#DIV/0! |
| Total TCO | | | | | 0.00 | | 0.00 | | 0.00 |
Mohammedhajis
TCO-ROIworksheet-forOfficeonline2018.xlsx
