= D2 * 1.35
In Column G (Precio Venta), enter this formula (assuming Cost is in Column E, and Margin is in Column F as a decimal):
=E2/(1-F2)
Example: Cost is $1.20, Margin is 50% (0.5). Excel calculates =1.20/(1-0.5) = $2.40. Wait, above we had $1.80! That’s a common mistake. This formula calculates markup on selling price. If you want a 50% margin on the sale, the price doubles. If you want a simple 50% markup on cost, use =E2*(1+F2). lista de productos de ferreteria y sus precios en excel
Best practice for hardware: Use the "Markup" method for fast-moving goods.
Usa el "Formato Condicional" de Excel para que los productos con stock bajo (por ejemplo, menos de 5 unidades) se coloreen automáticamente en ROJO. Así sabrás qué pedir en la próxima orden de compra sin revisar fila por fila. = D2 * 1
If you have a price list from a supplier but don't know the margin, use:
=(G2-E2)/G2
Format this cell as a Percentage (%).
You can create this quickly in Excel, or use a free template from: In Column G (Precio Venta), enter this formula
Or create your own with the columns above.
You will give this Excel file to employees or print it for customers. Accidents happen.