A peculiar thing happens in northern Florida every year in the springtime. That's harvest season on the many fern farms scattered across the region, and it's also the time when demand for rattlesnake antivenom skyrockets there.
That's no coincidence. Rattlesnakes like to form dens under fern crops, it turns out. That means trouble for those who harvest the plants, and it puts urgent pressure on local hospitals and healthcare providers, which must come up with the highly perishable antivenom on demand.
"A lot of times you never really know how much you're going to need," said Kyle Pudenz, senior director of purchasing for pharmaceutical wholesaler H. D. Smith. "But you also can't stock up and leave it on the shelf."
It's a classic problem in the world of supply-chain planning, and today analytics tools are opening up new ways to solve it.
'I was spending a lot of weekends'
For H. D. Smith, an analytics platform from FusionOps is bringing new visibility to the supply chain, enabling the wholesaler to better anticipate and meet demand and offer service levels it couldn't have previously.
With data dispersed across multiple subsidiaries and storage products, the team at H. D. Smith found that getting everything in one place for analysis was a time-consuming challenge.
"I was spending a lot of weekends trying to pull data out to see what the current situation was," Pudenz said. "By the time I could access it, things had changed."
The supply-chain team was using Microsoft's Access and Excel tools for analysis: "That was the only way they could get the data in one place," said David Guzman, the company's CIO.
Following pilot tests in the fall of 2013, H. D. Smith began rolling out FusionOps a few months later. With modules for procurement, finance, inventory, sales, production planning and customer service, FusionOps recently gained prescriptive analytics as well, enabling users to simulate different scenarios for a better understanding of the pros and cons of alternative decisions.
Among the benefits for H. D. Smith has been better insight into service exceptions, or those times when a customer wanted a product but H. D. Smith couldn't supply it.
Today, team members create dashboards every morning to guide their efforts for the day. "We can slice and dice the data as needed," Pudenz explained.
FusionOps' proactive capabilities have also changed the way H. D. Smith understands and anticipates demand. Say the company sells 500 units of a particular product in a single order every 10 weeks, for example.
A traditional approach would probably dictate that it should keep 50 units on average in stock every week.
"You never have enough to fill the account the one time they order, and the rest of the time, you have more than you need," Pudenz explained.
Sign up for Computerworld eNewsletters.