Intuit Confidential and Proprietary1

Using Anaplan to Forecast Demand and Supply Across ChannelsBrent Orr and Roy Cowing

May 19, 2015

Intuit Confidential and Proprietary2

Who we are…

Intuit Confidential and Proprietary3

Retail Forecasting “Before” – First Step

Intuit Confidential and Proprietary4

Supply Chain/Retail Forecasting “Before” ~ 5 years ago

Empty Box Excel

File

MSKU Excel Data

Ad Hoc Manual Load

MS Access Data Formatting/Analytics

Retail Excel

File

Direct File for NIM

ADIS-Excel

File

FE-Reports

Adhoc Ops

Models

Retail Excel

Prep File

Intuit Confidential and Proprietary5

• Customers and Inputs

– Finance/Marketing – No SKU?!

• QB/FMS/QBPro/Costco

– Retail Sales – Lowest Level

• 424370/Costco

– Supply Chain/Tier 1

• 424370 – for All Customers

• Still ‘Wonky’ but now only 1 question

• “Is it right in Anaplan?”

Win #1 – Multiple Hierarchies

Intuit Confidential and Proprietary6

Current Retail and Direct Process

BOMArena

Oracle 9.2Transactions

Manufacturing Systems

Anaplan(Daily

planner work: retail &

direct)

Daily Automated Load

Ad Hoc Manual Load

MS Access Data Formatting/Analytics

NIM-Excel File

ASI-Excel File

FE-Reports

Intuit Confidential and Proprietary7

Direct Forecasting Dashboard

Intuit Confidential and Proprietary8

• Antiquated SQL Server DB and Server

Win #2 – Replaced “Apollo”

Intuit Confidential and Proprietary9

Anaplan Up and Running Avoided Catastrophe

Intuit Confidential and Proprietary10

Win #3 - Forecasting Displays & Empty Boxes

Intuit Confidential and Proprietary11

Thank You