Download PDF
Information Builders > Case Studies > Food Lion Roars Ahead With Self-Service Reporting System
Information Builders Logo

Food Lion Roars Ahead With Self-Service Reporting System

Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
  • Retail
Applicable Functions
  • Business Operation
  • Sales & Marketing
Use Cases
  • Predictive Quality Analytics
  • Real-Time Location System (RTLS)
Services
  • Software Design & Engineering Services
  • System Integration
The Challenge
Food Lion, a major grocery retailer, was facing challenges with its mainframe-based reporting processes. The company was struggling to deliver financial information to the field in a timely manner. The hardcopy reports generated by mainframe reporting programs had to be manually bursted and stuffed into envelopes, then mailed to store managers and the operations team in the field. By the time managers received this information, it was generally more than one week old. It was also difficult to find particular bits of information, since the reports were printed in a rigid, hardcopy format. The profit and loss statements were generated by a mainframe-based reporting tool. Changes to the reports had to be requested of the IT department.
About The Customer
Food Lion is a major grocery retailer with more than 1,200 stores in 11 states. Founded in 1957 as Food Town in Salisbury, North Carolina, Food Lion LLC is a subsidiary of Delhaize America, the U.S. division of Brussels-based Delhaize Group. Today, Food Lion operates 1,211 stores and employs approximately 73,000 associates in 11 Southeast and Mid-Atlantic states. The company was facing challenges with its mainframe-based reporting processes and was struggling to deliver financial information to the field in a timely manner.
The Solution
Food Lion decided to create a parameter-driven, self-service reporting environment that allows managers to access their choice of reports via the corporate intranet, as well as automatically schedule and distribute daily sales reports by e-mail. The company purchased WebFOCUS along with enterprise application integration technology from iWay Software. The development team began by creating reporting extracts from Food Lion’s production information systems, which are stored in flat files on the mainframe. iWay converts data from DB2, VSAM, SQL Server, and DB/400 databases on several different computer platforms into a common format to simplify the reporting process. They also used WebFOCUS to duplicate key mainframe reports, which were distributed via e-mail by ReportCaster. Finally, they created a parameter-driven, self-service reporting environment that allows the operations team to access reports via the corporate intranet.
Operational Impact
  • Sales results and other financial data received days to weeks sooner
  • Better analysis of weekly store promotions
  • The ability to quickly detect buying patterns and respond to changes in the marketplace
Quantitative Benefit
  • Sales results and other financial data received days to weeks sooner
  • Significant reduction in distribution costs for printing, handling, and mailing reports
  • Reduction in labor costs due to quick report generation and fewer administrative requirements

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.