Las tiendas PelicanInforme para los directivos

Información tiendas Pelican

•Tiendas Pelican son una división de National Clothing, que es una cadena de ropa femenina, que tiene sucursales por todo Estados Unidos.

•National Clothing Inc. fue constituido en Washington en el año de 1986.

•Actualmente tiene unos ingresos de $ 500 000 000 Usd.

•Esta tienda ofrece ropa para mujeres, hombres, niños.

Datos promoción

•Se realizó una promoción , que consistía en enviar cupones de descuento a todos los clientes de otras tiendas de National Clothing.

•Se va a mostrar datos en las tiendas Pelican durante un día de la promoción de descuento.

•Pelican Store verificamos el modo de pago de los clientes en el día de la promoción, los clientes que compraron con cupón, clientes que realizaron compras sin el cupón de descuento.

Datos de las 100 compras en el día de promoción en tienda Pelican

CustomerType of

Customer Items Net SalesMethod of Payment Gender

Marital Status Age

1 Regular 1 39,50 Discover Male Married 322 Promotional 1 102,40 Proprietary CardFemale Married 363 Regular 1 22,50 Proprietary CardFemale Married 324 Promotional 5 100,40 Proprietary CardFemale Married 285 Regular 2 54,00 MasterCard Female Married 346 Regular 1 44,50 MasterCard Female Married 447 Promotional 2 78,00 Proprietary CardFemale Married 308 Regular 1 22,50 Visa Female Married 409 Promotional 2 56,52 Proprietary CardFemale Married 4610 Regular 1 44,50 Proprietary CardFemale Married 3611 Regular 1 29,50 Proprietary CardFemale Married 4812 Promotional 1 31,60 Proprietary CardFemale Married 4013 Promotional 9 160,40 Visa Female Married 4014 Promotional 2 64,50 Visa Female Married 4615 Regular 1 49,50 Visa Male Single 2416 Promotional 2 71,40 Proprietary CardMale Single 3617 Promotional 3 94,00 Proprietary CardFemale Single 2218 Regular 3 54,50 Discover Female Married 4019 Promotional 2 38,50 MasterCard Female Married 3220 Promotional 6 44,80 Proprietary CardFemale Married 5621 Promotional 1 31,60 Proprietary CardFemale Single 2822 Promotional 4 70,82 Proprietary CardFemale Married 3823 Promotional 7 266,00 American ExpressFemale Married 5024 Regular 2 74,00 Proprietary CardFemale Married 4225 Promotional 2 39,50 Visa Male Married 48

26 Promotional 1 30,02 Proprietary CardFemale Married 6027 Regular 1 44,50 Proprietary CardFemale Married 5428 Promotional 5 192,80 Proprietary CardFemale Single 4229 Promotional 3 71,20 Proprietary CardFemale Married 3230 Promotional 1 18,00 Proprietary CardFemale Married 7031 Promotional 2 63,20 MasterCardFemale Married 2832 Regular 1 75,00 Proprietary CardFemale Married 5233 Promotional 3 63,20 Proprietary CardFemale Married 4434 Regular 1 40,00 Proprietary CardFemale Married 3435 Promotional 5 105,50 MasterCardFemale Married 5636 Regular 1 29,50 MasterCardMale Single 3637 Regular 2 102,50 Visa Female Single 4238 Promotional 6 117,50 Proprietary CardFemale Married 5039 Promotional 5 13,23 Proprietary CardFemale Married 4440 Regular 2 52,50 Proprietary CardFemale Married 5841 Promotional 13 198,80 Proprietary CardFemale Married 4242 Promotional 4 19,50 Visa Female Married 4643 Regular 2 123,50 Proprietary CardFemale Married 4844 Promotional 1 62,40 Proprietary CardFemale Married 5445 Promotional 2 23,80 Proprietary CardFemale Married 3846 Promotional 2 39,60 Proprietary CardFemale Married 6047 Regular 1 25,00 MasterCardFemale Married 4648 Promotional 3 63,64 Proprietary CardFemale Married 3049 Promotional 1 14,82 Proprietary CardFemale Married 3250 Promotional 9 145,20 MasterCardFemale Married 46

51 Promotional 6 176,62 Proprietary CardFemale Married 3852 Promotional 5 118,80 Proprietary CardMale Married 6853 Regular 1 58,00 Discover Female Single 7854 Regular 2 74,00 Visa Female Single 2055 Regular 2 49,50 MasterCardFemale Married 3256 Promotional 3 141,60 Proprietary CardFemale Married 3857 Promotional 6 123,10 Proprietary CardFemale Married 5458 Promotional 2 80,40 Proprietary CardFemale Married 4859 Promotional 4 65,20 MasterCardFemale Married 4660 Promotional 4 113,00 Proprietary CardFemale Single 5061 Promotional 1 108,80 Proprietary CardFemale Married 4662 Promotional 3 59,91 Proprietary CardFemale Single 3063 Promotional 5 53,60 Proprietary CardFemale Married 5464 Promotional 1 31,60 Proprietary CardFemale Single 4265 Promotional 2 49,50 Proprietary CardFemale Married 4866 Promotional 1 39,60 Proprietary CardFemale Married 6267 Promotional 2 59,50 Proprietary CardFemale Married 3468 Promotional 5 146,80 Proprietary CardFemale Married 2869 Promotional 2 47,20 Proprietary CardMale Married 4670 Promotional 8 95,05 Proprietary CardFemale Married 5471 Promotional 5 155,32 Proprietary CardFemale Married 3072 Promotional 4 58,00 MasterCardFemale Married 3273 Regular 1 69,00 Proprietary CardFemale Single 2274 Promotional 2 46,50 Proprietary CardFemale Married 3275 Promotional 2 45,22 Proprietary CardFemale Married 74

Promotional 4 84,74 Proprietary CardFemale Married 6277 Regular 2 39,00 Proprietary CardFemale Married 4278 Promotional 4 111,14 Proprietary CardFemale Married 2879 Promotional 3 86,80 Proprietary CardFemale Married 3880 Regular 2 89,00 Discover Female Married 5481 Promotional 2 78,00 MasterCardFemale Married 6882 Promotional 6 53,20 Proprietary CardFemale Single 3083 Promotional 4 58,50 Visa Female Married 3684 Promotional 3 46,00 Proprietary CardFemale Married 4485 Regular 2 37,50 Visa Female Married 4486 Promotional 1 20,80 Proprietary CardFemale Married 6287 Regular 6 144,00 MasterCardFemale Single 4888 Regular 4 107,00 Proprietary CardFemale Married 3689 Promotional 1 31,60 Proprietary CardFemale Single 2090 Promotional 6 57,60 Proprietary CardFemale Married 4291 Promotional 4 95,20 Proprietary CardFemale Married 5492 Promotional 1 22,42 Proprietary CardFemale Married 5493 Regular 5 159,75 Proprietary CardFemale Married 7294 Promotional 17 229,50 Proprietary CardFemale Married 3095 Regular 3 66,00 American ExpressFemale Married 4696 Regular 1 39,50 MasterCardFemale Married 4497 Promotional 9 253,00 Proprietary CardFemale Married 3098 Promotional 10 287,59 Proprietary CardFemale Married 5299 Promotional 2 47,60 Proprietary CardFemale Married 30

100 Promotional 1 28,44 Proprietary CardFemale Married 44

DISTRIBUCIÓN DE FRECUANCIA PORCENTUAL DE LA VARIABLE TIPO DE CLIENTE (CUPONES=PROMOCIONAL)

Clientes Frec. Relativa (Promocional vs. Regular ) Frec. Porcentual (Promocional vs. Regular)1 a 10 0.04 0.06 4% 6%11 a 20 0.07 0.03 7% 3%21 a 30 0.08 0.02 8% 8%31 a 40 0.06 0.04 6% 4%41 a 50 0.08 0.02 8% 2%51 a 60 0.07 0.03 7% 3%61 a 70 0.1 - 10% -71 a 80 0.07 0.03 7% 3%81 a 90 0.07 0.03 7% 3%91 a 100 0.07 0.03 7% 3%

0.71 0.29 71% 29%TOTAL 1 100%

Número de clientes por cada modo de pago cupón.

Discover 1

Propietary Card 7

Master Card 2

Número de clientes por cada modo de pago cupón.

Discover 10%

Propietary Card 70%

Master Card 20%

Variables Aclaradas

•Artículos El numero total de artículos vendidos son 322.

•Ventas netasCantidad total cargadas a la tarjeta de crédito es $ 7760.05

Ventas netas.

Ventas netas Tipo cliente $10-59 $60-109 $110-159 $160-209… TotalRegular 19 8 2 1 30Promocional 30 23 9 8 70Total 49 31 11 9 100

Cuando Pelican tiene promociones tienen mas ventas que cuando son regulares.

Diagrama de dispersión y línea de tendencia de las tiendas Pelican.

Conclusiones • Se mostro que tiendas Pelican tienen mas ventas cuando hay cupones con promoción que cuando no los hay.•Los consumos de los clientes promocionales son mayores que de los clientes regulares.•Claramente se puede ver que el aumento de ventas tiene una fuerte dependencia de los clientes promocionales. •Al no contar con información de costos no se puede evaluar la rentabilidad de la promoción.•El 70% de los pagos fueron hechos con Property Card, se puede aprovechar esto para llevar a cabo campañas de Marketing directo (fidelización, etc.).