Difference between revisions of "Rollout"
(Spreadsheet to calculate go-live resources and a description of the spreadsheet.) |
|||
| Line 3: | Line 3: | ||
Field explanations | Field explanations | ||
| − | Number of Sites - Number of physical locations requiring resources | + | -Number of Sites - Number of physical locations requiring resources |
| − | Simultaneous Sites to Go-live - How many physical locations requiring resources will be going live at the same time | + | |
| − | Week 1 Resources per Site - How many resources will be at each site week 1 of the go-live | + | -Simultaneous Sites to Go-live - How many physical locations requiring resources will be going live at the same time |
| − | Weeks of Post Live Support - The number of weeks that a site will be given post-live resources | + | |
| − | + | -Week 1 Resources per Site - How many resources will be at each site week 1 of the go-live | |
| − | + | ||
| − | Weeks to complete all sites - Calculation of how long it will take to cycle through all sites | + | -Weeks of Post Live Support - The number of weeks that a site will be given post-live resources |
| − | Resource cost per week - Variable defining the weekly cost in dollars for a go-live resource | + | |
| − | Net Cost - Calculation based on the number of resources to maintain pace, weekly cost and number of weeks to maintain pace | + | -Number of resources Left in Support role per site - The number of resources to support in the |
| + | Post-live support | ||
| + | |||
| + | -Number of resources to maintain pace - Calculation based on the above telling how many resources would be necessary to rollout with those criteria | ||
| + | |||
| + | -Weeks to complete all sites - Calculation of how long it will take to cycle through all sites | ||
| + | |||
| + | -Resource cost per week - Variable defining the weekly cost in dollars for a go-live resource | ||
| + | |||
| + | -Net Cost - Calculation based on the number of resources to maintain pace, weekly cost and number of weeks to maintain pace | ||
[[Image:Go-Live Resource Calculator.xls]] | [[Image:Go-Live Resource Calculator.xls]] | ||
Revision as of 20:51, 26 July 2007
Working on rollout strategies we found it helpful to have a tool that would enable us to calculate the amount of resources necessary to support a given rollout strategy. Based on this, we created the attached spreadsheet. The spreadsheet is a great tool for estimating based on averages or resourcing a particular go-live. The sheet has the ability to calculate by number of sites or providers. The sides would be used seperately not at the same time.
Field explanations
-Number of Sites - Number of physical locations requiring resources
-Simultaneous Sites to Go-live - How many physical locations requiring resources will be going live at the same time
-Week 1 Resources per Site - How many resources will be at each site week 1 of the go-live
-Weeks of Post Live Support - The number of weeks that a site will be given post-live resources
-Number of resources Left in Support role per site - The number of resources to support in the Post-live support
-Number of resources to maintain pace - Calculation based on the above telling how many resources would be necessary to rollout with those criteria
-Weeks to complete all sites - Calculation of how long it will take to cycle through all sites
-Resource cost per week - Variable defining the weekly cost in dollars for a go-live resource
-Net Cost - Calculation based on the number of resources to maintain pace, weekly cost and number of weeks to maintain pace