With greater access to more data sets, it is easier to do bad statistical work. BusinessWeek illustrated this in humorous way:
Monthly Archives: February 2013
Blending Optimization at Coco Cola to Make Better Orange Juice
BusinessWeek recently ran an article on Coca Cola’s new orange juice plant. Although this article doesn’t give the details of their secret production formula (which they call Black Book), it looks like a nice application of the classic linear programming blending problem. It is also interesting to see all the other data collection and analytics that go into the process.
Here is a key passage from the article:
Black Book isn’t really a secret formula. It’s an algorithm. Revenue Analytics consultant Bob Cross, architect of Coke’s juice model, also built the model Delta Air Lines (DAL) uses to maximize its revenue per mile flown. Orange juice, says Cross, “is definitely one of the most complex applications of business analytics. It requires analyzing up to 1 quintillion decision variables to consistently deliver the optimal blend, despite the whims of Mother Nature.”
The Black Book model includes detailed data about the myriad flavors—more than 600 in all—that make up an orange, and consumer preferences. Those data are matched to a profile detailing acidity, sweetness, and other attributes of each batch of raw juice. The algorithm then tells Coke how to blend batches to replicate a certain taste and consistency, right down to pulp content. Another part of Black Book incorporates external factors such as weather patterns, expected crop yields, and cost pressures. This helps Coke plan so that supplies will be on hand as far ahead as 15 months. “If we have a hurricane or a freeze,” Bippert says, “we can quickly replan the business in 5 or 10 minutes just because we’ve mathematically modeled it.”
In-Store Analytics Catching Up With On-Line Analytics
The Economist recently published an interesting article on how advances in security cameras are allowing stores to better track and respond to consumers.
It seems like it wasn’t too long ago that an average 3-year-old could easily beat a computer at determining someone’s gender by looking at a picture. Now, these cameras are getting better at determining gender as well as age of the shoppers in the store.
This advance really allows in-store retailers to catch-up with their on-line counterparts in terms of understanding customers: where do they spend their time, how long do they stay, what do they look at, and what do they ultimately buy?
The article provides an example of a retailer who determined when the number of shoppers peaked (it wasn’t when sales peaked) and built their staff schedules around that to generate more sales.
There is a lot more retailers can do with this information. It will be interesting to see how this evolves over the next few years.
DC Water and IBM– A Case Study in Analytics
DC Water suppliers water to 2 million customers in the Washington DC area with several thousand miles of pipes (with an average age of over 75 years) and maintains nearly 9000 fire hydrants. Several years ago, everything was tracked on paper.
IBM and DC Water have recently published several videos and articles on how DC Water has applied descriptive, predictive, and prescriptive analytics to the system with positive results.
This is a nice case study in the use of analytics.
The descriptive analytics allowed DC Water to map the location of the fire hydrants for better maintenance. With extra sensors it also allowed them to better monitor water useage and look for anomalies
With aging pipes, the predictive analytics allowed them to predict failures before they happened.
And, the prescriptive analytics allowed DC Water to better route maintenance crews to fix trouble tickets increasing the productivity of the maintenance team while driving down fuel cost.
IBM published several videos on the solution>
This first video is a nice high-level overview of the solution:
The second video provides more details of the solution:
The third video highlights the predictive analytics solution:
IBM also published a written document of the solution, but I found the videos very well done.