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)