s&op mini project
TRANSCRIPT
HANA S&OP ProjectSHASHANK, JUAN, THUY
1
Agenda• S&OP Overview• Schwarz Inc. Case• Implement Data Warehouse in HANA Studio• Visualize and create report in SAP Lumira• Summary• References
2
Sales and Operations Planning Overview• S&OP is a set of decision-making processes to balance demand and supply, to integrate
financial planning and operational planning, and to link high level strategic plans with day-to-day operations. • Merging of tactical and strategic planning methods• S&OP is a long, tough road to travel, but the rewards at the end are substantial
3
S&OP ProcessDemand
• Consensus Demand Planning and New Products
• Input from Sales, Marketing, Finance and Operations, including quantity, price, revenue and margin
Supply
• Based on updated demand plan, understand capacity and material impacts, including contract manufacturing
• Understand long-term gaps in supply and demand
Balance
• Review and resolve outstanding supply issues
• Compare constrained plan with finance plan
• Define and compare scenarios
Executive Review
• Escalate resolution plans with scenarios, if applicable
• Review key changes since last meeting
4
5
Schwarz Inc.
6
Locations
Products
Furtwangen
Shirt
Jacket
Pants
Schwarz Inc. Problem Statement:Present to the top manager a forecast analysis for year 2017 of the
main products of the company, based on information of sales and marketing department:• Forecast demand in whole year 2017• Forecast demand in each brand in 2017: Shirt, Jacket, Pants • Forecast demand in the first Quarter of 2017
7
Forecast for 2017
8
9
Star SchemaDim: Time
Time ID
Month
Year
Dim: Product
Product ID
Product Description
Dim: Store
Store ID
City
Fact Table: Monthly Forecast
Time_ID
Product_ID
Store_ID
Sales Forecast
Marketing Forecast
Consensus Forecast
Import tables to HANA Studio
10
• Master Data
Import tables to HANA Studio
11
• Fact Table
Create Analytical View in HANA Studio
12
Dashboard and Reporting in Lumira
13
Lumira Reports
14
Lumira Reports
15
Lumira Reports
16
Lumira Reports
17
Lumira Reports
18
Summary•Uploading enterprise data, creating Dimension and Fact Tables is
much easier than SAP BW• SAP Lumira provides an efficiently way to visualize Data and
Create Reports• S&OP on Hana can bring the problem to the weekly level and
improve the S&OP plan quality• S&OP real time decision becomes making smarter and faster as
data upload in seconds
19
References SAP Business Suite powered by SAP HANA, Fact Book, Studio SAP, 28550enUS (14/08)
The In-memory Revolution, Hasso Plattner & Bernd Leukert. 2015.
SAP Sales and Operations Planning Compare & Contrast with SAP APO. Phil Gwynne. 2013
20