Opex-to-Sales

High Level Design

Overview

Companies often spend vast amounts of money on the products they sell, incurring expenses such as marketing, storage, manufacturing and salaries of workers. To maintain profitability, it is important to verify each product’s operational expenses (Opex) to Sales ratio is as low as possible

 

Goals

Reduce Opex to Sales ratio.

KPI Architecture

Objective KPI’s Measures Data source
Reduce Opex to Sales ratio Opex to Sales (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales

 

Total expenses ([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost]) MarketingCosts,

Fact_Sales

 

Total Sales [Total SubCategory_LineTotal] Fact_Sales
Opex to Sales Ratio Year over Year (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales,

DimDate

 

Ratio by Category (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales,

DimCategory

5 most/least leading subcategories in sales – their ratio (([Total MarketingCosts]+[Total Salary_loaded_per_SubCategoryMonthly]+[Total SubCategory_StorageCost]+[Total SubCategory_ProductionCost])/[Total SubCategory_LineTotal]) MarketingCosts,

Fact_Sales,

DimCategory

Data Modeling (Elasticube Design)

Opex to Sales data model

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation