Welcome To Cost-To-Profit Analytics Project Overview
Project Name
COST-TO-PROFIT ANALYTICS
Company Name
Aditak
Problem
AdiTak needed a clear understanding of which products are profitable and whether profit margins are sustainable
Data Collection
Ingredients unit costs, ingredient quantities for each products, and general production costs (e.g, employee salary)
Method used
Created Excel models to calculate costs, compare with sales prices, and analyze product profitability and margins.
Results
Identified products that are profitable with sustainable profit margins.
Flagged products that are no longer profitable at current prices.
Developed a comprehensive, dynamic Excel system where updating the price of a single ingredient automatically recalculates production costs for all products.
​
​
Tools
Excel
Download Sample Version
Deep Into Project
The Cost-to-Profit Analytics project was developed for AdiTak, an Iranian pastry-based company, to analyse and identify net profit and profit margins for each product. The system allows production costs to be recalculated automatically by updating the price of a single ingredient, with costs adjusting instantly across all products based on ingredient usage and quantity.
​
The model includes a traffic-light system to support decision-making: products turn red/amber when production costs exceed or closely match sales prices, and green when sales prices remain sustainably higher than production costs. This enables rapid cost analysis, supports pricing decisions, and helps prevent potential losses.