Analytics on the iSeries: Success at HP Hood, LLC

1
Analytics on the iSeries Success at HP Hood, LLC

• Navigating High Growth Using the ShowCase Suite
  from SPSS

2
Agenda

• SPSS Analytics that enable the predictive
  enterprise
• HP Hood Analytics enabling high growth
• Special Offer

3
Enabling the Predictive Enterprise
Advanced Analytics
4
Optimal Actions
5
Predictive Analytics Described
6
SPSS Enterprise Platform
7
HP Hood An Analytic Journey during High Growth

• Shawn Brown

8
Who is Hood?

• Founded in 1846
• Privately owned company
• 4 Lines of business
• Home Service
• DSD (Direct Store Delivery)
• Warehouse Division
• Ice Cream

9
HP Hood LLC Stats

• Sales Growth
• Sales Dollars
• 2000 630m
• 2003 1.1b
• 2004 estimate 2.5b
• Product SKUs
• 2000 1982
• 2004 1787
• Customers
• 2000 8224
• 2004 8992

• Company Growth
• Employees
• 2000 1,580
• 2003 1,740
• 2004 5,200

10

HP Hood Barne, VT
HP Hood Oneida, NY
HP Hood Portland, ME
HP Hood Vernon, NY
HP Hood Agawam, MA
HP Hood Suffield, CT
HP Hood Winchester, VA
April 3, 2004
Crowley
HP Hood
11

April 4, 2004
Crowley
HP Hood
12
Product Mix

• Hood Branded
• Regional Hood Branded (shelf milk)
• Speciality Milk
• Simply Smart
• Carb CountDown
• Licensed Products
• NesQuik
• Lactaid
• Etc.

• Hood Acquired Brands

13
I/S Structure

• Staff of 50
• 350 Users of Data Warehouse
• iSeries centric
• Packaged software solutions

14
Our Analytic Journey
Warehouse Mgmt HR Financial
Marketing
H/R, Payroll, G/L
Acquisition Support
Distribution
Sales
1998
1999
2000
2005
2004
2001
2002
2003
15
SPSS Software Environment

• ShowCase Suite
• Production / Relational Reporting
• Query/Report Writer
• Essbase Reporting
• Warehouse Manager
• Enterprise Reporting
• Multi-dimensional Analysis (OLAP)
• Essbase
• Excel add-in
• Analyzer
• Warehouse Builder
• WB for SQL Server

16
Analytic Journey

• SPSS / ShowCase relationship established in 1998
• 1998
• Initial scope limited to sales information
• Essbase prototype was built by ShowCase
• Development of relational enterprise
• 1999
• Further cube development built around sales
  information
• Brand Promotional Geographic-Telesale

17
Solutions Marketing

• Analysis
• New product introduction
• Light-Block Bottle
• Fruit Stirrer
• Promotions
• Advertising
• Customer Type Basket Analysis
• Buying trends (Delivery Trends)

18
Shipments vs. Sell - Through
19
Analytic Journey (contd)

• 2000
• Began to expand beyond sales (Distribution
  Metrics)
• Subset of Kronos (time attendance)
• Subset of G/L (distribution expense)
• DSD Metrics- sales, hours, G/L
• Solutions - Distribution
• Metric Reporting
• Compilation of multi-source data
• Empty Case Tracking

20
Solutions- Distribution
21
Solutions - Distribution
Financials
Time Attendance
Sales
22
Analytic Journey (contd)

• 2002
• Addition of Infinium (H/R, Payroll)
• Master file data, transaction data
• Replaced all custom report development
• Transaction level G/L data
• G/L Cube (BPCS G/L)
• 16 consulting days
• Served as replacement for antiquated reporting
  tool
• 2003-Present
• Warehouse Management System (Logistics Pro)
• H/R cubes
• H/R Financial Metrics (cube)

23
H/R Metrics
24
H/R Metrics
25
HR Financial Cube

• Productivity Measures
• Hours
• Labor (direct, indirect)
• Labor cost per gallon
• Labor Revenue
• Headcount

26
Analytic Journey (contd)

• Acquisition Support Management
• Pre-Acquisition
• Fulfillment of Department of Justice data
  requests (twice)
• Post- Acquisition
• Data Warehouse extended to new companies
• Feature attraction foundation for new employees
• Facilitates multiple organizational structures to
  manage accountability
• No reliance or customization of core systems
• Gives ability to aggregate historical data across
  companies
• Permits shut down of redundant systems
• Data analysis to structure Operations
• Realignment of Ice Cream

27
Results Goals

• H.P. Hood has become information driven
• Past- decisions made on gut feel
• Present- informed decisions made through analysis
  of solid data
• Future- Increase our modeling capability
• Complete profitability
• Automate decision making process

28
QA
Q A
29
Special OfferShowCase Effectiveness Audit
Service

• For current ShowCase Suite customers
• Three to five day on site event
• Maximize your system resources
• Assess quality of information
• Review deployment plan
• Benefits
• Enhance your journey
• Optimize system performance and minimize batch
  windows
• Verify alignment of ShowCase Suite deployment
  business initiatives to maximize ROI
• Limited time offer - 5000 through February 2005

30
Features and Next Steps

• Service Features
• Preparation
• Scoping and business requirements
• System Review
• Examination of environment for optimization
• Interviews
• With IT and business users to identify issues
  and opportunities
• Report and recommendations
• Next Steps
• For more details call or email Graham Boote,
  ShowCase Services Manager
• 312-261-6551
• gboote_at_spss.com

31
Thank you for your time and participation today!

• For copies of todays presentation, please visit
  www.spss.com/events
• To learn more about the SPSS solutions you saw
  today
• Contact your SPSS representative today at
  800-543-2185 or email sales_at_spss.com
• Visit our the SPSS Website at www.spss.com
• Visit our booth at IBM COMMON March 13 15 in
  Chicago
• Register for the next Analytics on the iSeries
  online seminar at www.spss.com/events
• Retail Success at Chase-Pitkin Home Centers
• Leveraging Analytics Across the Enterprise
• February 24, 2005 200 p.m. CST