Please wait while the page is being loaded Skip this advertisement >
Saturday | 22 November, 2008
CIO
How Oil Companies Use BI to Maximize Profits
Every day, oil companies harness gushers of data to assess market conditions for a gallon of gas. Learn how they match the right tools with information to maximize profits.
Kim S. Nash 08 July, 2008 14:37:56

But Valero doesn't sell that much in a given day so it must store finished goods until they're ready to be shipped to customers. The company tracks its own inventory movements the way a first-time mother studies her infant. How much of which products did we sell this morning? How about now? And now?

Market analysts run inventory reports "a few hundred times a day," says Kirk Hewitt, vice president of accounting processing optimization . As the cost of crude fluctuates during trading hours, Valero sales and marketing staff want frequent updates so they can sell products at the most profitable price and buy crude to feed their refineries at the best price.

"We're dealing with a commodity whose price changes every second," Hewitt explains. "So our margins change every minute. Our costs change every minute."

Companywide, Valero employees generate more than 20,000 reports per month. These range from gas station profit-and-loss statements to the status of payable invoices to telecommunications charges.

Valero uses WebFocus tools from Information Builders for nearly all its BI reporting, but not for inventory reporting, which has to be quick and dirty. For that, users query Valero's SAP Business Warehouse system, which collects operations data from the SAP R/3 system at Valero's refineries. Data includes items such as the volume of crude processed and the amount of products made from it. The information is presented in an Excel spreadsheet, he says, because "it's a fast way to get a snapshot."

Valero wants to make its BI faster overall. Now most reports use information from data warehouses populated each night with batch updates from SAP. But Hewitt says moving to a service-oriented architecture will enable more frequent updates, so the analysts can query more current data throughout the day. The company is working with SAP to implement SAP Exchange Infrastructure, or XI, to make that happen. Valero will still use WebFocus for what-if analysis and report presentation, he says.

Though the technology is changing, the purpose of the analysis isn't. Valero monitors the value of its inventory, along with sales and efficiency at its gas stations, to make adjustments to the price of its products as it watches demand and supply shift. Just because gas prices are soaring doesn't mean Valero has an easy ride. Aside from gasoline, the company makes asphalt, sulfur and other secondary products. These prices haven't increased as much as gasoline has, or in proportion to the rise in the cost of crude needed to make them. Valero has to balance its dependencies.

Data Analysis Can Help Cut Fuel Costs, Too UPS crunches information from its trucks to improve efficiency and save money

At UPS, there's data everywhere: on the packages, on the drivers carrying handhelds to record customer interactions, even inside those ubiquitous brown trucks. UPS vehicles contain a wealth of data drawn from more than 200 sources inside the trucks. And last year, the company found a way to cut its fuel costs, among other efficiencies, by putting this data together using telematics technology.

Telematics refers to systems used for transmitting data to and from vehicles. UPS's system uses off-the-shelf telematics software to help gather and compile the data from the trucks. Then, proprietary applications using in-house-developed algorithms allow UPS automotive and operations personnel to query and analyze the information.

Featured Whitepaper Sponsors
Market Place
 
Featured Whitepapers

Smart SOA World Tour

Discover how SOA can create smarter outcomes for your business.

Attend and learn:

  • How SOA is helping leading companies to become more agile
  • Where you should be applying SOA processes in your company
  • The top SOA implementation mistakes to avoid

Click here for more information.
  • +

    CIO Live Podcast #79: Brent D Taylor, author of The Outsider's Edge: The Making of Self-Made Billionaires Part II 05 October, 2007 06:00:00

    For his new book, The Outsider's Edge: The Making of Self-Made Billionaires, social researcher Brent D Taylor spent four years of intensive research investigating the psychological make-up and backgrounds of some of the world's richest men and women, including IT luminaries Bill Gates, Larry Ellison and Steve Jobs. Taylor discovered that, despite working in different industries and coming from different upbringings, they all have one thing in common -- they are all outsiders.
  • +

    CIO Live Podcast #78: Brent D Taylor, author of The Outsider's Edge: The Making of Self-Made Billionaires 28 September, 2007 17:34:25

    For his new book, The Outsider's Edge: The Making of Self-Made Billionaires, social researcher Brent D Taylor spent four years of intensive research investigating the psychological make-up and backgrounds of some of the world's richest men and women, including IT luminaries Bill Gates, Larry Ellison and Steve Jobs. Taylor discovered that, despite working in different industries and coming from different upbringings, they all have one thing in common -- they are all outsiders.
  • +

    CIO Live Podcast #77: Panasonic Speeds Up Trans-Pacific File Transfers, Part III 21 September, 2007 07:00:00

    Part three in our three-part special report from CIO's sister publication Network World in the US, as Paul Desmond reports from the Network World IT Roadmap Conference in Santa Clara, California. With development teams in the US and Japan, Panasonic needed a more efficient way to move very large files between the two locations. Iben Rodriguez, IT consultant for Panasonic Research and Development, explains how a storage-area network and virtual server technology helped speed up WAN performance.
  • +

    CIO Live Podcast #76: Panasonic Speeds Up Trans-Pacific File Transfers, Part II 14 September, 2007 07:00:00

    Part two in our three-part special report from CIO's sister publication Network World in the US, as Paul Desmond reports from the Network World IT Roadmap Conference in Santa Clara, California. With development teams in the US and Japan, Panasonic needed a more efficient way to move very large files between the two locations. Iben Rodriguez, IT consultant for Panasonic Research and Development, explains how a storage-area network and virtual server technology helped speed up WAN performance.
  • +

    CIO Live Podcast #75: Panasonic Speeds Up Trans-Pacific File Transfers, Part I 07 September, 2007 07:00:05

    Part one in our three-part special report from CIO's sister publication Network World in the US, as Paul Desmond reports from the Network World IT Roadmap Conference in Santa Clara, California. With development teams in the US and Japan, Panasonic needed a more efficient way to move very large files between the two locations. Iben Rodriguez, IT consultant for Panasonic Research and Development, explains how a storage-area network and virtual server technology helped speed up WAN performance.
  • +

    Chris Hoff on Virtualization and Cloud Computing 20 November, 2008 10:55:00

    Chris Hoff, chief security architect for the systems and technology division at Unisys and an advisor on the Skybox Security customer advisory board, is one of the biggest critics of virtualization security out there. Not because it isn't important - but rather because it is vital and needs to mature rapidly.
  • +

    Cybersecurity is focus of new start-up incubator 20 November, 2008 07:19:00

    Texas uni announces the Institute for Cyber Security.
    The University of Texas at San Antonio Tuesday announced a technology incubator aimed at fostering IT security-based start-ups within the state.
  • +

    Dilip Sarangan on Physical Security M&A 20 November, 2008 11:18:00

    Dilip Sarangan tracks physical security companies for Frost & Sullivan. He expects the industry's "need to have" products to weather the economic storm well, with the big players (now including IBM and Cisco) looking for value-priced acquisitions.
  • +

    International Challenges in PCI Security 20 November, 2008 09:15:00

    In a country that's seen many regulatory compliance challenges this decade, the headaches of PCI security tend to be analyzed from a largely American perspective.
  • +

    PCI council sharpens oversight of security auditors 19 November, 2008 10:53:00

    Quality assurance plan targets security assessors and scanning vendors
    The PCI Security Standards Council Monday unveiled a plan to sharpen oversight of the hundreds of security-service providers now authorized to evaluate merchant networks under the organization's Payment Card Industry data standards.
CIO Webcast Innovation #8 - What are the biggest roadblocks to IT's involvement in innovation at your company?
Watch the latest latest edition of CIO Innovation which is now available for download.
Watch the webcast
Sign up to the CIO Innovation update email


CIO Live Podcast #79: Brent D Taylor, author of The Outsider's Edge: The Making of Self-Made Billionaires Part II
Listen to the latest edition of CIO Live which is now available for download.
Listen to the podcast
Sign up to the CIO Live email
Whitepaper

Gaining Competitive Advantage Through Enterprise Planning

No matter how good its products or innovative its services, no organization can perform to its full potential without an adequate planning structure in place. Discover how this can be done by reading on.