Operating Income Master Data

Member ID Description Hierarchy Formula Account Ty H000000 Finance H100000 Operating Income H000000 INC H105000 Gross Profit H100000 INC H110000 Net Revenue H105000 INC H111000 Gross Revenue H110000 INC H111100 Gross Sales H111000 INC H111200 Retail Returns H111000 EXP H112000 Discounts H110000 EXP H112100 Pricing Adjustments H112000 EXP H112200 Sale Allowances H112000 EXP H112300 Sales Discounts - Other H112000 EXP H112400 Sales Markdowns H112000 EXP H120000 Cost of Goods Sold H105000 EXP H121000 Raw Materials H120000 EXP H121100 Labor H120000 EXP H121200 Purchase Price Variance H120000 EXP H122000 Other Direct Costs H120000 EXP H122100 Vendor Chargebacks H120000 EXP H122200 Freight H120000 EXP H130000 Operating Expenses H100000 EXP H131000 Sales and Marketing H130000 EXP H131100 Marketing Expenses H131000 EXP H132200 Sales Expenses H131000 EXP H133000 Personnel Costs H130000 EXP H133100 Salaries H133000 EXP H133200 Wages H133000 EXP H133300 Bonus H133000 EXP H133400 Burden H133000 EXP H133500 Training H133000 EXP H133600 Recruiting H133000 EXP H133700 Equipment H133000 EXP H133800 Computer H133000 EXP H133900 Tuition H133000 EXP H134000 IT Expenses H130000 EXP H134100 IT Expenses H134000 EXP H135000 Other Expenses H130000 EXP H135100 Other Expenses H135000 EXP H200000 Key Performance Indicators H000000 KPI0001 Gross Margin % H200000 [H105000]/[H110000] INC KPI0002 Operating Profit % H200000 [H100000]/[H110000] INC KPI0003 Operating Exp Ratio H200000 [H130000]/[H110000] EXP D00 Drivers DRV0010 Growth Rate % D00 NFIN

Rate Type Calculated Aggregation Type Exception Aggregation Type None Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum Average Sum None Average Average Average