|
 |
| 
Ice Manufacturer - Dallas, Texas
You know who your biggest customers are; are they also your best, most profitable customers? Have you ever wanted better insight into the relationship between sales and profits? Are you interested in knowing how
outside factors directly impact sales?
Our client wanted answers to questions like these. As the largest ice manufacturer in the country, they hired LiveLogic to develop an enterprise-wide set of reporting and analysis tools. We expanded and enhanced their existing data warehouse, built automated parameter-driven batch reports, and developed and delivered
training company-wide.
Business Case:
Needed detailed customer reports for ongoing sales calls (over 100,000 customers)
Needed to improve efficiency of deliveries
Needed to understand weather impact on sales
Needed to optimize product mix across all customers and regions
Needed to generate monthly report book for all factories
Needed to push ad-hoc information across to factories
Needed to re-categorize products in different hierarchy from transactional database
LiveLogic built a new system using AS/400 as the source system, SQL Data Transformation Services, SQL Server, Analysis Services, and ProClarity, both thick client and web versions. A custom-built Excel Report Writer was developed to automate the monthly batch reports.
Results:
Data sources: sales data from internal database and weather data from NOAA
> 100 remote users >20 corporate users
Client now has much better information than their customers
Client has the ability to optimize product mix
Report book automatically generated within minutes of month-end
Detailed analysis by customer, product, factory, delivery route and method, weather (temperature, rainfall, rain days, variance from norm, etc.), geography
Analysis of actual sales versus budget
Analysts now spend bulk of time analyzing data rather than manipulating spreadsheets
"On behalf of Reddy Ice Corporation we would like to express our gratitude for the fine work you recently completed. Your expertise with Microsoft Analysis Services, OLAP, ProClarity, and understanding of management requirements of information resulted in achieving a long awaited goal of producing certain management reports. Our experience with LiveLogic in this endeavor was one of great success, and we look forward to working with you in the future."
-Steve Janusek, Chief Financial Officer
-Doug Reeves, I.T. Director
|
|
