1
Tabla 1 Producto Precio Cantidad Total Diferencia Precio de costo total Costo Rentabilidad Margen Bruto Beneficio Bruto Rentabilidad de las ventas EBITA Producto 1 (habas) 24 $33.90 3 $101.70 $10.17 $30.51 $23.73 0.98608141716 170 $172.89 $5763.00 $21.36 Producto 2 ( garbanzo) 24 $17.50 6 $105.00 $5.25 $31.50 $12.25 1.01807815931 70 $73.50 $1225.00 $22.05 Producto 3 (lentejas) 24 $10.50 12 $126.00 $3.15 $37.80 $7.35 1.22169379117 70 $88.20 $735.00 $26.46 Producto 4 (maíz palomero) 24 $10.00 2 $20.00 $3.00 $6.00 $7.00 0.19391964939 70 $14.00 $700.00 $4.20 Producto 5 (arroz) 84 $21.50 35 $752.50 $6.45 $225.75 $15.05 7.29622680842 70 $526.75 $1505.00 $158.03 Producto 6 (arroz con tomate) 36 $21.50 1 $21.50 $6.45 $6.45 $15.05 0.20846362309 70 $15.05 $1505.00 $4.52 Producto 7 (arroz instantáneo) 40 $28.90 13 $375.70 $8.67 $112.71 $20.23 3.64278061385 70 $262.99 $2023.00 $78.90 Producto 8 (arroz pre cocido) 80 $17.90 39 $698.10 $5.37 $209.43 $12.53 6.76876536207 70 $488.67 $1253.00 $146.60 Producto 9 (arroz para paella) 48 $39.70 5 $198.50 $11.91 $59.55 $27.79 1.92465252022 70 $138.95 $2779.00 $41.69 Producto 10 (arroz grueso) 80 $17.40 3 $52.20 $5.22 $15.66 $12.18 0.50613028491 70 $36.54 $1218.00 $10.96 Producto 11 (arroz extra fino) 60 $28.90 35 $1011.50 $8.67 $303.45 $20.23 9.80748626806 70 $708.05 $2023.00 $212.42 Producto 12 (vinagre blanco) 147 $10.00 2 $20.00 $3.00 $6.00 $7.00 0.19391964939 70 $14.00 $700.00 $4.20 Producto 13 (vinagre de manzana) 49 $15.50 12 $186.00 $4.65 $55.80 $10.85 1.80345273935 70 $130.20 $1085.00 $39.06 Producto 14 (vinagre balsámico) 14 $42.50 3 $127.50 $12.75 $38.25 $29.75 1.23623776488 70 $89.25 $2975.00 $26.78 Producto 15 (Vinagre para ensaladas) 20 $27.49 15 $412.35 $8.25 $123.71 $19.24 3.99813837136 70 $288.65 $1924.30 $86.59 Producto 16 (grasa mixta) 60 $18.00 17 $306.00 $5.40 $91.80 $12.60 2.96697063571 70 $214.20 $1260.00 $64.26 Producto 17 (aceite vegetal) 126 $17.90 86 $1539.40 $5.37 $461.82 $12.53 14.9259954138 70 $1077.58 $1253.00 $323.27 Producto 18 (aceite de canola) 182 $27.00 100 $2700.00 $8.10 $810.00 $18.90 26.1791526680 70 $1890.00 $1890.00 $567.00 Producto 19 (aceite de girasol) 168 $22.70 48 $1089.60 $6.81 $326.88 $15.89 10.5647424989 70 $762.72 $1589.00 $228.82 Producto 20 (aceite de soya) 672 $23.50 20 $470.00 $7.05 $141.00 $16.45 4.55711176074 70 $329.00 $1645.00 $98.70 TOTAL 457 $10313.55 $135.69 $3094.07 $316.60 100 1500 $7321.19 $35050.30 $2165.85

Calculos Walmart

Embed Size (px)

Citation preview

Page 1: Calculos Walmart

Tabla 1

Producto Precio Cantidad Total Diferencia Precio de costo total

Costo Rentabilidad Margen Bruto

Beneficio Bruto

Rentabilidad de las ventas

EBITA

Producto 1 (habas) 24

$33.90 3 $101.70 $10.17 $30.51 $23.73 0.986081417164798 170 $172.89 $5763.00 $21.36

Producto 2 ( garbanzo) 24

$17.50 6 $105.00 $5.25 $31.50 $12.25 1.01807815931469 70 $73.50 $1225.00 $22.05

Producto 3 (lentejas) 24

$10.50 12 $126.00 $3.15 $37.80 $7.35 1.22169379117763 70 $88.20 $735.00 $26.46

Producto 4 (maíz palomero) 24

$10.00 2 $20.00 $3.00 $6.00 $7.00 0.193919649393274 70 $14.00 $700.00 $4.20

Producto 5 (arroz) 84

$21.50 35 $752.50 $6.45 $225.75 $15.05 7.29622680842193 70 $526.75 $1505.00 $158.03

Producto 6 (arroz con tomate) 36

$21.50 1 $21.50 $6.45 $6.45 $15.05 0.208463623097769 70 $15.05 $1505.00 $4.52

Producto 7 (arroz instantáneo) 40

$28.90 13 $375.70 $8.67 $112.71 $20.23 3.64278061385265 70 $262.99 $2023.00 $78.90

Producto 8 (arroz pre cocido) 80

$17.90 39 $698.10 $5.37 $209.43 $12.53 6.76876536207222 70 $488.67 $1253.00 $146.60

Producto 9 (arroz para paella) 48

$39.70 5 $198.50 $11.91 $59.55 $27.79 1.92465252022824 70 $138.95 $2779.00 $41.69

Producto 10 (arroz grueso) 80

$17.40 3 $52.20 $5.22 $15.66 $12.18 0.506130284916445 70 $36.54 $1218.00 $10.96

Producto 11 (arroz extra fino) 60

$28.90 35 $1011.50 $8.67 $303.45 $20.23 9.80748626806483 70 $708.05 $2023.00 $212.42

Producto 12 (vinagre blanco) 147

$10.00 2 $20.00 $3.00 $6.00 $7.00 0.193919649393274 70 $14.00 $700.00 $4.20

Producto 13 (vinagre de manzana) 49

$15.50 12 $186.00 $4.65 $55.80 $10.85 1.80345273935745 70 $130.20 $1085.00 $39.06

Producto 14 (vinagre balsámico) 14

$42.50 3 $127.50 $12.75 $38.25 $29.75 1.23623776488212 70 $89.25 $2975.00 $26.78

Producto 15 (Vinagre para ensaladas) 20

$27.49 15 $412.35 $8.25 $123.71 $19.24 3.99813837136582 70 $288.65 $1924.30 $86.59

Producto 16 (grasa mixta) 60

$18.00 17 $306.00 $5.40 $91.80 $12.60 2.96697063571709 70 $214.20 $1260.00 $64.26

Producto 17 (aceite vegetal) 126

$17.90 86 $1539.40 $5.37 $461.82 $12.53 14.9259954138003 70 $1077.58 $1253.00 $323.27

Producto 18 (aceite de canola) 182

$27.00 100 $2700.00 $8.10 $810.00 $18.90 26.179152668092 70 $1890.00 $1890.00 $567.00

Producto 19 (aceite de girasol) 168

$22.70 48 $1089.60 $6.81 $326.88 $15.89 10.5647424989456 70 $762.72 $1589.00 $228.82

Producto 20 (aceite de soya) 672

$23.50 20 $470.00 $7.05 $141.00 $16.45 4.55711176074194 70 $329.00 $1645.00 $98.70

TOTAL 457 $10313.55 $135.69 $3094.07 $316.60 100 1500 $7321.19 $35050.30 $2165.85