Screen 6 (of 6) |
« Prev Screen First Screen » |
Telecomms spending analysis, continued: actionable information. |
6. |
We get the answer with a time-based treemap, comparing Q3 2002 AT&T spending with Q4 2002 AT&T spending (this is another DHTML extract from BIQ). In this treemap, light green indicates the smallest increase in spending (good news), and light red indicates the largest increase in spending (bad news). Colors in between light red and light green represent lesser degrees of change, black being in the middle. We can see from this that the Technology And Operations department (mouse over it to see), for example, has in fact increased its AT&T expenditure from Q3 to Q4, the reverse of what we would have hoped to see. |
Trouble distinguishing colors? Reds can be changed to blues by clicking on the red/blue color button. |
|
BUT MOST IMPORTANTLY: We are now staring at actionable information For example, the fourth worst block (labeled "Branch 520" -- mouse over it in the red window) is gray, which means there was no spend at all in Q3, and new spend of $2,652 in Q4. It's likely that this is a new branch, and that they have no idea that they're supposed to be using MCI. We can simply pick up the phone, call Branch 520, and save $500 next quarter. There aren't too many of these phone calls necessary to put the original sourcing initiative back on track. We should be able to reduce telecomms expenditures by at least $20K per quarter, and, with BIQ, monitor for any new rogue spending in the future. |
|