...
Key Deliverables
Due Date: Feburary February 28 is the IT-SPARCC presentation.
27th of February is our drop-dead date.
- slide stack, changed a bit from 2005.
- THREE YEARS of changes, turning the pie chart into a bar graph.
- Angie has started the new slide stack and Diana has a placeholder for it on sparkler.
Departmental view of all spending, for the Relationship Managers.
- Keep the IT shops data disaggregated at low enough level to match the ITshops to DLC.
Timeline constraints
- design the Brio IT Shops query on Feb 5.
- know by Feb 12 whether we can do the IT shops that way, and if not, do it by hand.
- be done with the data aggregation by Feb 22. Slides are generated by Feb 23.
Major Work Breakdown Structure
...
- need to revive the OLD list of IT Shop profit centers and cost objects, to see if they are still active and so on.
- need to review the list of NEW cost centers to find addtitional IT Shops.
- need to find a more powerful way to use Brio to automate the sifting and aggregation of costs.
Salaries
- Need to tease apart the Kelley Connors sheet to total SWEB by Department (using the HR hierarchy) and match that to DLC in the PC Hierarchy.
- Store that data in a way that can be pivoted into the Excel tool same as the Software, Equipment, and other categories.
Software / Equipment / Contracts / Telecomm
- download the DTR transactions for all major profit centers, for all the categories. See the Profit Centers child page.
- rule out non-IT spending in Equipment
- rule out non-IT spending in Contracts