Get Adobe Flash player

Statistical Dreams

The Setting

Jack and Jill were co-chairing the annual planning meeting. They had invited representatives from Sales, Marketing, Production, Accounts, Finance and IT. The idea was to talk about the 'Big Picture'.

"Welcome, All!", Jack started. "We are missing opportunities in the market and Jill and I want for us to talk about that. We know it is not for want of trying. It is clear that everyone is busy at their posts. So, we want to keep the meeting in a positive spirit and see where we can go and how!", he finished. "Jill, would you take it from here?"

The Warning

"Thanks, Jack", she said. "I have been going through the sales figures from last year and found them good. Just for good measure, I pulled out the sales stats for the two years prior - I had wanted a full five-year set, but could not find them in the office, anyone know where they are?", she interjected herself, "I also pulled out our management accounts for the same periods in order to compare".

"I am happy to report that the trends seem fine. We have had a CAGR (Compound Annual Growth Rate) of 8% in sales over the last three years, matched by a similar increase in the cost of production. Profits, at the end of the day, have been acceptable for our shareholders. We mostly know this by an absence of tough talk from the Board!", she finished.

"But, when I took a look at our industry statistics, something struck me! The average growth rate in the industry is 12% for the same period and our main competitor had a whopping 20% increase in sales. To me this means two things: We have lost opportunities, there for the having, and we have lost market share!" Jill was expressing this with some annoyance. "Back to you, Jack".

"OK, Team!", he continued. "Let's open up a round of comments and suggestions from everyone. Joe, what is the situation in Sales?"

The Wip

Always Sales first when we have to find solutions, Joe thought to himself. "Well", he coughed as he started, "We have just heard the news about our sales growth and I can add that the results are broadly based. A few customers have bought 10-15% more than last year, but the trend overall is broad-based. Our Internet sales volume has grown faster than that coming from our sales team, but not by much. Roughly 20% of our turnover now come from Internet sales". Joe was quietly pleased that he had won the battle to keep the Internet sales under his wing. Far too many companies had set up separate Internet sales desks with the excuse that success on the Internet required insight into IT and technology. He was glad he had taken several IT courses and he had for some time been able to conduct insightful discussions with the IT desk.

"The thing is", he continued, "We've got all hands on deck. Every sales person on the team has a full set of active accounts and are busy filling the order book. We are planning for a 20% increase in sales personnel this year, which should let us visit new accounts as well. On the Internet front we have not had any major hiccups - the IT backup has worked flawlessly. There were two outages over the last year, but IT put the servers back online after 6 and 10 minutes respectively. The thing we are missing more than anything is an inspired marketing campaign", he said with a smile and a look at Mark from Marketing.

Mark spluttered in his coffee at that remark and sat the cup down again. "We have a very creative team, but we too have to live within a budget and we just cannot do more than two campaigns per year", he complained. Having become a recent Dad, he had not had time to take the same IT courses Joe had, so he was not quite up to speed with click-through rates, server logs and the like. Most of his team were Old School and the budget went on print advertising in trade journals.

"In any case", Tim from Production broke in, "We are operating at 95% of capacity and I am not sure we could accommodate a spike in volume that easily!"

"Well, we are on good terms with our bankers", said Finn from Finance, "and given our good trading record, I am sure we could increase our borrowing facility if you need to increase your production capacity".

"And we could use some funding if we have to go out with a third campaign", Mark said, suddenly hopeful.

"I don't know if it is of any interest", continued Harry from Accounts, "but our new accounting system can actually export a great deal of data in tabular format. Maybe we could analyse the sales, marketing and production figures. Then we could gain some insights into sales/advertising and sales/production cost ratios and such?"

"We could contribute with number of sales calls per account and geographical distribution of accounts", added Joe, "but I do not have the click-through rates from the marketing department".

Mark blushed, but said nothing.

The Saviour

"Maybe I can be helpful here", said Salit from IT. She hesitated, "You know management has asked us to keep our web-server log files for three months for compliance purposes and then delete them? Well, we followed the directive and have them auto-deleted on a rolling basis after 90 days, but we had a team meeting where we agreed that they could be so useful if someone should ever decide to mine the data in them. We have everything in these files: IP and geographical address of each visitor, which pages were clicked on our site, how long the visitor stayed on each page, how many orders were cancelled on the payment page, how many were completed and so on. We decided to keep a backup copy, just in case someone asked. Don't be mad, Jack, the files are just stored on a spare hard drive we had lying around. I think this is needed here, though." Salit was visibly nervous.

"Far from being angry", Jack responded thoughtfully, "I think we need a rethink of what we need to do with our business data. Ideally, we need to capture this data in a central location and then crunch the creepers out of it. But, with the economy the way it is management has hinted that a hiring freeze may be around the corner and I do not think we have the resources - or skills - to do this job in any of your departments?" This question was directed at the meeting in general. Some people shook their head, but most just looked down at their notepads.

"You know what this means", he continued managerially, "This means we have to rent a business consultant. Someone who can run sophisticated statistical analysis on our numbers and maybe enhance them with some of his own. We would then want him to report back in two months with a global picture. What do you say?"

The Relief

Sighs of relief around the table suggested everyone agreed and were happy not to have to take on this difficult task.

"OK, Team!", said Jill, "That's it. Many thanks for your contributions and special merit to Salit for keeping the interests of the business in mind, even in the face of orders to the contrary! See you in two months!"


So what are you waiting for?

Contact us right away:

Did Anybody See Me Break The World Record?

This is a story about IT in use at a major sports event. Any similarity with actual events, past or future, is unintentional.

 

Verain Colt entered the stadium. It was just after midday and the sun was shining harshly overhead. Unusually for London the temperature was a sub-tropical 31 degrees Celsius, so he had been extra careful to keep hydrated. His main event this afternoon was the Men's 100 yard dash. It was scheduled for 1400 hours, so he had just under 120 minutes to compose himself and prepare mentally. It was only the semi-final, but three of his main competitors were there and he had to be careful not to get psyched out before the main action.

Curt, his personal coach, was pacing nervously back and forth nearby trying to get his own emotions under control. He had just finished a call to Louise, the Men's Athletics manager on the National Committee, who wanted to know if Verain would be available for a Q&A with the press outside the stadium in half an hour. Earlier he had spoken to his commercial agent who had promised a major bonus if Verain went on to win the final, but apologetically had announced that the standing sponsorship agreement would see the monthly retainer cut by 50%. The excuse was the depressed economy, which could not sustain extravagant advertising campaigns. This was bad news so he knew Verain would need the press coverage, but equally he needed to win, so he had decided to decline the Q&A.

Across the stadium the long jump team was preparing for their own event, when one of them had the idea to speak to Verain to get a wish of good luck and to seek some much needed moral support. Curt had been in two minds about handing his phone to Verain. He did not want to upset his thought processes. In the end he had interupted Verain and the phone call had lasted 10 minutes. Verain had seemed pleased.

Across the country, attending a different discipline, the National Team logistics manager needed to know if an extra-ordinary evening roll-call could be arranged and was calling all participating athletes, one by one, to get their agreement. Mostly she spoke to the personal or team coaches, who had all promissed to get back to her later. But she had asked for a 1900 hours meeting kick-off and she was getting increasingly stressed out that she was getting no immediate reaction. There were important messages about meals to announce and she knew the meeting absolutely had to take place.

Just before 1400 hours the power supply to the broadcasting station was cut. No-one knew why, as all road-works within ten miles had been banned during the event and the power was working elsewhere in the stadium. The power installations were brand new and should not be prone to malfunction.

While the technicians were working feverishly, the 100 yard dash took place. Verain won in World Record time and by a margin so large it would not likely be repeated at the final! Across the country and around the world TV newscasters were debating the contestants in studio discussions in the absence of a live TV feed. TV journalists at the event took to using their mobile phone cameras to capture the sprint and were now busily uploading the video clips to their respective news organisations. This resulted in a massive mobile phone outage, as the specially erected phone antennas at the stadium had been dimensioned for voice calls and not for thousands of simultaneous video feeds.

Later in the afternoon, Louise was racing back to London to get to the 1900 hours meeting. She had prepared an agenda, but had been cut from the Internet while in transit. She hastily printed out 45 copies at the team event office before running to the meeting room at 1901 hours. Catching her breath in the room, she realised that only half the National Team was present. The rest had not received the information or were out celebrating with Verain. Lousie cut the meeting short; she knew she would have to call it again tomorrow to get her message out.

---


So what are you waiting for?

Contact us right away:

'The Company' - A Serialization

The Trials and Tribulations of 'The Company'

We hope you will find amusement in following the trials and tribulations of our team of gentle souls at 'The Company'. They meet everyday issues in trying to make their business operate well enough to at least pay the salaries.

In doing so, they make just about every mistake possible related to their IT installations and their use. SEE IF YOU CAN SPOT THE ERRORS!

We think you will recognise at least some of the issues they come across. We hope you will smile knowingly when you do.

Follow the episodes and vignettes from their lives around our web site - for instance:

  1. Hello, Can You Hear Me?
  2. The X:drive Files!
  3. Surviving Backup Hell
  4. Streamlining the Sales Office
  5. Document Jack
  6. Jill's Big Project
  7. Did Anybody See Me Break The World Record?
  8. Statistical Dreams