Lista De Productos De Ferreteria Y Sus Precios En Excel

Managing a hardware store—whether it is a small neighborhood ferretería or a large industrial supplier—comes with a unique set of challenges. You have thousands of SKUs (Stock Keeping Units), ranging from tiny 1-inch nails to heavy-duty power tools. How do you keep track of inventory costs, selling prices, and profit margins without going crazy?

=(G2-E2)/G2

| SKU | Categoría | Producto | Unidad | Costo | Margen | | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | CLA-101 | Fijación | Clavo 2" para madera (1 kg) | Kilo | $1.20 | 50% | $1.80 | | CLA-202 | Fijación | Clavo 4" galvanizado (1 kg) | Kilo | $1.50 | 45% | $2.18 | | TOR-3X20 | Fijación | Tornillo autoperforante 3/4" (Caja 200pz) | Caja | $4.00 | 60% | $6.40 | | HER-001 | Herramientas | Martillo de uña 16 oz | Unidad | $5.00 | 40% | $7.00 | | HER-045 | Herramientas | Cinta métrica 5m | Unidad | $2.50 | 50% | $3.75 | | ELE-990 | Eléctrico | Cable THW 12 AWG (1 metro) | Metro | $0.60 | 35% | $0.81 | | ELE-456 | Eléctrico | Interruptor simple 10A | Unidad | $0.90 | 55% | $1.40 | | PIN-778 | Pintura | Brocha 2" profesional | Unidad | $1.20 | 70% | $2.04 | | PIN-990 | Pintura | Lija al agua #240 (Paquete 5pz) | Paquete | $0.80 | 60% | $1.28 | | PLM-001 | Plomería | Tubo PVC 1/2" (3m) | Pieza | $1.80 | 40% | $2.52 | | PLM-002 | Plomería | Pegamento PVC (250ml) | Frasco | $2.50 | 45% | $3.63 | lista de productos de ferreteria y sus precios en excel

=E2/(1-F2)