PROYECCION DE LA DEMANDA POR MINIMOS CUADRADOS.xlsx

LISTADO MAESTRO DE PRODUCTOS DE TRANSMILENIO LOGISTICA DE TRANSPORTE GRUPO NOCHE

CODIGO PRODUCTO SKU CODIGO DE BARRAS

100001 BONBOMBUM 7702011012890100002 BONBOMBUM SIN RELLENO SABORES SURTIDOS 7702011011186100003 POLVOS AZUCARADOS BIPBIP FRIO 7702354008604100004 DULCE FRUTICAS 7002011001719100005 DULCES DUROS 7002011001672100006 DULCES DE CAFÉ DUROS 7702011001764100007 WAFER BRIDGE MINITACO FRESA Paq x 8100008 WAFER BRIDGE MINITACO VAINILLA Paq x 9100009 WAFER NUCITA CUBIERTA DE CHOCOLATE Paq x 10100010 MUUU GALLETA DE CHOCOLATE100011 PIAZZA CHOCOLATE Paq x 10100012 PIAZZA FRESA Paq x 6100013 PONKY PONQUE Paq x 6100014 CRAQUEÑAS GALLETAS SALTIN TACO Paq x 7100015 NUCITA 1 7702011012401100016 BARRA DE CHOCOLATE KICK 1100017 CHOCO BREAK 1 7702011039293100018 CHOCO MASMELOS 1 7702011013828100019 CAFÉ BUEN DIA 1 7707211630912100020 ESTUCHES DE BOMBONES

100021 SARDINA VAN CAMP’S EN TOMATE POR 425 gr 425 grs. 722008504914100022 SARDINA VAN CAMP’S EN ACEITE DE 298 gr 298 grs100023 SARDINA VAN CAMP’S EN TOMATE DE 170 gr 170 grs 722008000317100024 ATUN VAN CAMP’S EN AGUA DE 184 gr 184 grs 7702367000022100025 ATUN VAN CAMP’S EN AGUA DE 354 gr 354 grs 7702367000763100026 ATUN VAN CAMP’S EN ACEITE DE 184 gr 184 grs 770236000015100027 ATUN VAN CAMP’S EN ACEITE DE 354 gr 354 grs100028 AREQUIPE COLOMBINA POR 50 gr 50 grs100029 AREQUIPE COLOMBINA POR 250 gr 250 grs 7702097066497100030 AREQUIPE COLOMBINA POR 500 gr 500 grs 7702097066503100031 LECHE CONDENSADA COLOMBINA POR 300 gr 300 grs100032 LECHE CONDENSADA COLOMBINA POR 400 gr 400 grs 7702097066558100033 PALETA DE AGUA

100034 PALETA DE CREMA

100035 VASOS

100036 GALLETAS

100037 CONOS

100038 ROBIN HOOD

100039 POSTRE HELADO

100040 SNAKI

100041 SALSA DE TOMATE DOY PACK * 400 g 702097032751

100042 SALSA DE TOMATE DOY PACK * 200 g 702097035424

100043 SALSA MOSTANEZA ORIGINAL DOY PACK * 200 g 702097038807

7702011047588 7702011005397

7702011026439

7702011048042 7702011046703

100044 SALSA MOSTANEZ RANCHERA DOY PACK * 380 g 7020970370572

100045 MERMELADA DE FRUTOS ROJOS DOY PACK * 200 g 702097036643

100046 MERMELADA DE PIÑA DOY PACK * 200 g 702097036643

100047 VINAGRETA FRASCO * 325g 702097037244

100048 SALSA PARA PASTAS CON CHAMPIÑONES FRASCO * 450g 702097035103

LISTADO MAESTRO DE PRODUCTOS DE TRANSMILENIO LOGISTICA DE TRANSPORTE GRUPO NOCHE

LINEA DE PRODUCTO

Confiteria Terminado paq x 24 4,910 Confiteria Terminado paq x 24 4,910 Confiteria Terminado paq x 24 6,000 Confiteria Terminado paq x 100 5,130 Confiteria Terminado paq x 100 8,550 Confiteria Terminado paq x 100 10,100 Galleteria Terminado Paq x 8 2,340 Galleteria Terminado Paq x 9 2,340 Galleteria Terminado Paq x 10 2,240 Galleteria TerminadoGalleteria Terminado Paq x 10 1,260 Galleteria Terminado Paq x 6 1,260 Galleteria Terminado Paq x 6 2,710 Galleteria Terminado Paq x 7 1,480 Chocolates y Café Terminado X 6 UND 2,360 Chocolates y Café TerminadoChocolates y Café Terminado X 30 UND 3,590 Chocolates y Café Terminado X 12 UND 12,330 Chocolates y Café Terminado X 85 GR 7,480 Chocolates y Café TerminadoEnlatados de pescado TerminadoEnlatados de pescado TerminadoEnlatados de pescado TerminadoEnlatados de pescado TerminadoEnlatados de pescado TerminadoEnlatados de pescado TerminadoEnlatados de pescado TerminadoPostres TerminadoPostres TerminadoPostres TerminadoPostres TerminadoPostres TerminadoHelados Terminado 69 grs 1,910 Helados Terminado 72 grs 2,170 Helados Terminado 48 grs 1,670 Helados Terminado 65 grs 1,020 Helados Terminado 86 grs 1,430 Helados Terminado 535 grs 13,260 Helados Terminado 93 grs 2,840 Helados Terminado 50 grs 800 Salsas y conservas Terminado 14 ONZAS 3,440

Salsas y conservas Terminado 7 ONZAS 2,060


TIPO DE PRODUCTO

PRESENTACION COMERCIAL

PRECIO PARA EL CONSUMIDOR

Salsas y conservas Terminado 13.3 ONZAS 4,140





CODIGO PRODUCTO SKU MES 1

100001 BONBOMBUM 120,000 100002 BONBOMBUM SIN RELLENO SABORES SURTIDOS 83,500 100003 POLVOS AZUCARADOS BIPBIP FRIO 25,000 100004 DULCE FRUTICAS 46,800 100005 DULCES DUROS 34,680 100006 DULCES DE CAFÉ 38,789 100007 WAFER BRIDGE MINITACO FRESA Paq x 8 46,923 100008 WAFER BRIDGE MINITACO VAINILLA Paq x 9 19,830 100009 WAFER NUCITA CUBIERTA DE CHOCOLATE Paq x 10 78,623 100010 MUUU GALLETA DE CHOCOLATE 64,300 100011 PIAZZA CHOCOLATE Paq x 10 41,500 100012 PIAZZA FRESA Paq x 6 32,560 100013 PONKY PONQUE Paq x 6 47,600 100014 CRAQUEÑAS GALLETAS SALTIN TACO Paq x 7 46,900 100015 NUCITA 1 153,290 100016 BARRA DE CHOCOLATE KICK 1 35,790 100017 CHOCO BREAK 1 25,800 100018 CHOCO MASMELOS 1 24,600 100019 CAFÉ BUEN DIA 1 21,570 100020 ESTUCHES DE BOMBONES 14,600 100021 SARDINA VAN CAMP’S EN TOMATE POR 425 gr 425 grs. 24,790 100022 SARDINA VAN CAMP’S EN ACEITE DE 298 gr 298 grs 28,900 100023 SARDINA VAN CAMP’S EN TOMATE DE 170 gr 170 grs 39,020 100024 ATUN VAN CAMP’S EN AGUA DE 184 gr 184 grs 57,300 100025 ATUN VAN CAMP’S EN AGUA DE 354 gr 354 grs 28,700 100026 ATUN VAN CAMP’S EN ACEITE DE 184 gr 184 grs 65,200 100027 ATUN VAN CAMP’S EN ACEITE DE 354 gr 354 grs 23,600 100028 AREQUIPE COLOMBINA POR 50 gr 50 grs 24,370 100029 AREQUIPE COLOMBINA POR 250 gr 250 grs 18,670 100030 AREQUIPE COLOMBINA POR 500 gr 500 grs 14,690 100031 LECHE CONDENSADA COLOMBINA POR 300 gr 300 grs 21,390 100032 LECHE CONDENSADA COLOMBINA POR 400 gr 400 grs 17,800 100033 PALETA DE AGUA 253,800 100034 PALETA DE CREMA 236,790 100035 VASOS 189,500 100036 GALLETAS 93,600 100037 CONOS 103,540 100038 ROBIN HOOD 86,230 100039 POSTRE HELADO 47,900 100040 SNAKI 43,210 100041 SALSA DE TOMATE DOY PACK * 400 g 38,900 100042 SALSA DE TOMATE DOY PACK * 200 g 45,700 100043 SALSA MOSTANEZA ORIGINAL DOY PACK * 200 g 23,500 100044 SALSA MOSTANEZ RANCHERA DOY PACK * 380 g 19,200

100045 MERMELADA DE FRUTOS ROJOS DOY PACK * 200 g 21,300 100046 MERMELADA DE PIÑA DOY PACK * 200 g 16,800 100047 VINAGRETA FRASCO * 325g 12,300 100048 SALSA PARA PASTAS CON CHAMPIÑONES FRASCO * 450g 13,400

NUMERO DE REGISTROS 6 SUMATORIA 348,769

MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8

1 1 1 1 1 1 1

129,120 116,040 145,002 132,219 106,908 156,558 150,164 89,846 80,745 100,897 92,002 74,390 108,939 104,489 26,900 24,175 30,209 27,546 22,272 32,616 31,284 50,357 45,256 56,551 51,565 41,694 61,058 58,564 37,316 33,536 41,906 38,211 30,896 45,245 43,397 41,737 37,509 46,871 42,739 34,557 50,606 48,539 50,489 45,375 56,699 51,701 41,804 61,218 58,718 21,337 19,176 23,962 21,849 17,666 25,871 24,815 84,598 76,028 95,004 86,629 70,045 102,576 98,386 69,187 62,178 77,697 70,847 57,285 83,889 80,463 44,654 40,131 50,146 45,726 36,972 54,143 51,932 35,035 31,486 39,344 35,875 29,008 42,480 40,744 51,218 46,029 57,517 52,447 42,407 62,101 59,565 50,464 45,352 56,672 51,676 41,783 61,188 58,689 164,940 148,231 185,228 168,899 136,566 199,990 191,822 38,510 34,609 43,247 39,434 31,885 46,694 44,786 27,761 24,949 31,175 28,427 22,985 33,660 32,285 26,470 23,788 29,725 27,105 21,916 32,094 30,784 23,209 20,858 26,064 23,766 19,217 28,141 26,992 15,710 14,118 17,642 16,087 13,007 19,048 18,270 26,674 23,972 29,955 27,314 22,085 32,342 31,021 31,096 27,946 34,921 31,843 25,747 37,704 36,164 41,986 37,732 47,150 42,993 34,763 50,908 48,828 61,655 55,409 69,238 63,135 51,048 74,757 71,703 30,881 27,753 34,680 31,622 25,569 37,444 35,914 70,155 63,048 78,784 71,839 58,086 85,063 81,589 25,394 22,821 28,517 26,003 21,025 30,790 29,532 26,222 23,566 29,447 26,851 21,711 31,794 30,496 20,089 18,054 22,560 20,571 16,633 24,358 23,363 15,806 14,205 17,751 16,186 13,087 19,165 18,383 23,016 20,684 25,847 23,568 19,056 27,907 26,767 19,153 17,213 21,509 19,612 15,858 23,223 22,274 273,089 245,425 306,679 279,643 226,110 331,121 317,596 254,786 228,976 286,125 260,901 210,956 308,929 296,311 203,902 183,247 228,982 208,796 168,825 247,232 237,134 100,714 90,511 113,101 103,131 83,388 122,116 117,128 111,409 100,123 125,112 114,083 92,243 135,084 129,566 92,783 83,384 104,196 95,010 76,822 112,500 107,905 51,540 46,319 57,880 52,777 42,674 62,493 59,940 46,494 41,784 52,213 47,610 38,496 56,374 54,071 41,856 37,616 47,005 42,861 34,656 50,751 48,678 49,173 44,192 55,222 50,353 40,714 59,623 57,187 25,286 22,725 28,396 25,893 20,936 30,659 29,407 20,659 18,566 23,200 21,155 17,105 25,049 24,026

22,919 20,597 25,738 23,469 18,976 27,789 26,654 18,077 16,246 20,300 18,511 14,967 21,918 21,023 13,235 11,894 14,863 13,552 10,958 16,047 15,392 14,418 12,958 16,192 14,764 11,938 17,482 16,768 6 6 6 6 6 6 6

MES 9 MES 10 MES 11 MES 12 TOTAL

1 1 1 1

117,979 105,133 151,126 193,193 1,623,442 82,094 73,155 105,159 134,430 1,129,645 24,579 21,903 31,485 40,249 338,217 46,012 41,002 58,939 75,345 633,142 34,096 30,383 43,675 55,833 469,175 38,136 33,983 48,850 62,448 524,764 46,133 41,110 59,094 75,543 634,806 19,496 17,373 24,974 31,925 268,274 77,299 68,882 99,017 126,578 1,063,665 63,217 56,334 80,978 103,519 869,894 40,801 36,358 52,264 66,813 561,440 32,012 28,526 41,006 52,420 440,494 46,798 41,703 59,947 76,633 643,965 46,110 41,089 59,065 75,506 634,495 150,708 134,299 193,051 246,788 2,073,811 35,187 31,356 45,073 57,620 484,191 25,365 22,604 32,492 41,537 349,040 24,186 21,552 30,981 39,605 332,806 21,207 18,898 27,165 34,726 291,814 14,354 12,791 18,387 23,505 197,519 24,372 21,719 31,220 39,910 335,376 28,413 25,320 36,396 46,527 390,979 38,363 34,186 49,141 62,820 527,889 56,335 50,201 72,163 92,250 775,193 28,217 25,144 36,144 46,205 388,273 64,102 57,122 82,112 104,968 882,070 23,203 20,676 29,721 37,995 319,277 23,960 21,351 30,691 39,234 329,694 18,356 16,357 23,513 30,058 252,580 14,443 12,870 18,500 23,650 198,736 21,030 18,740 26,938 34,437 289,378 17,500 15,595 22,417 28,657 240,811 249,525 222,356 319,632 408,603 3,433,579 232,802 207,454 298,210 381,218 3,203,456 186,308 166,023 238,653 305,084 2,563,685 92,024 82,004 117,878 150,691 1,266,284 101,796 90,712 130,397 166,693 1,400,760 84,778 75,547 108,597 138,825 1,166,578 47,093 41,966 60,325 77,116 648,024 42,482 37,857 54,418 69,566 584,574 38,245 34,081 48,990 62,627 526,266 44,930 40,038 57,554 73,574 618,261 23,104 20,589 29,596 37,834 317,924 18,877 16,821 24,180 30,911 259,751

20,941 18,661 26,825 34,292 288,161 16,517 14,719 21,158 27,047 227,282 12,093 10,776 15,490 19,802 166,403 13,174 11,740 16,876 21,573 181,284 6 6 6 6 6

PRODUCTO 100001 BONBOMBUM PRODUCTO 100002X Y X2 XY X Y

1 120,000 1 120,000 1 83,5002 129,120 4 258,240 2 89,8463 116,040 9 348,120 3 80,7454 145,002 16 580,007 4 100,8975 132,219 25 661,094 5 92,0026 106,908 36 641,446 6 74,3907 156,558 49 1,095,909 7 108,9398 150,164 64 1,201,311 8 104,4899 117,979 81 1,061,810 9 82,094

10 105,133 100 1,051,330 10 73,15511 151,126 121 1,662,388 11 105,15912 193,193 144 2,318,317 12 134,430

CONTEO 12 12SUMATORIA 78 1,623,442 650 10,999,972 78 1,129,645

PRODUCTO 100004 DULCE FRUTICAS PRODUCTO 100005X Y X2 XY X Y

1 46,800 1 46,800 1 34,6802 50,357 4 100,714 2 37,3163 45,256 9 135,767 3 33,5364 56,551 16 226,203 4 41,9065 51,565 25 257,827 5 38,2116 41,694 36 250,164 6 30,8967 61,058 49 427,404 7 45,2458 58,564 64 468,511 8 43,3979 46,012 81 414,106 9 34,096

10 41,002 100 410,019 10 30,38311 58,939 121 648,331 11 43,67512 75,345 144 904,144 12 55,833

CONTEO 12 12SUMATORIA 78 633,142 650 4,289,989 78 469,175

FORMULA Y Bxy X Cxy

100001 BONBOMBUM

1 1,623,442 Bxy 78 12 Cxy -6.52 10,999,972 Bxy 650 78 Cxy

remplazo10,552,371 Bxy -507 -78 Cxy10,999,972 Bxy 650 78 Cxy

447601 143 Bxy

3130 Bxyremplazamon en la 2

10,999,972 3130 650 78 Cxy10,999,972 2034549 78 Cxy

8965423 = 78 Cxy

114,941 = Cxy

Y= 3130 24 114,94175122 + 114,941

190,063

100003 POLVOS AZUCARADOS BIPBIP FRIO

1 338,217 Bxy 78 12 Cxy -6.52 2,291,661 Bxy 650 78 Cxy


93250 143 Bxy


2,291,661 652 650 78 Cxy2,291,661 423864 78 Cxy

1867796 = 78 Cxy

23,946 = Cxy

Y= 652 24 23,94615650 + 23,946

39,596

100005 DULCES DUROS

1 469,175 Bxy 78 12 Cxy -6.52 3,178,992 Bxy 650 78 Cxy


129357 143 Bxy


3,178,992 905 650 78 Cxy3,178,992 587985 78 Cxy

2591007 = 78 Cxy

33,218 = Cxy

Y= 905 24 33,21821710 + 33,218

54,928

BONBOMBUM SIN RELLENO SABORES SUPRODUCTO 100003 POLVOS AZUCARADOS BIPBIPX2 XY X Y X2 XY

1 83,500 1 25,000 1 25,0004 179,692 2 26,900 4 53,8009 242,234 3 24,175 9 72,525

16 403,588 4 30,209 16 120,83525 460,012 5 27,546 25 137,72836 446,339 6 22,272 36 133,63549 762,570 7 32,616 49 228,31464 835,912 8 31,284 64 250,27381 738,843 9 24,579 81 221,210

100 731,550 10 21,903 100 219,027121 1,156,745 11 31,485 121 346,331144 1,613,162 12 40,249 144 482,983

12650 7,654,147 78 338,217 650 2,291,661

DULCES DUROS PRODUCTO 100006 DULCES DE CAFÉX2 XY X Y X2 XY

1 34,680 1 38,789 1 38,7894 74,631 2 41,737 4 83,4749 100,607 3 37,509 9 112,527

16 167,622 4 46,871 16 187,48225 191,056 5 42,739 25 213,69336 185,378 6 34,557 36 207,34249 316,718 7 50,606 49 354,24364 347,179 8 48,539 64 388,31481 306,863 9 38,136 81 343,221

100 303,834 10 33,983 100 339,834121 480,430 11 48,850 121 537,353144 669,994 12 62,448 144 749,377

12650 3,178,992 78 524,764 650 3,555,649

100002 BONBOMBUM SIN RELLENO SABORES SURTIDOS

1 1,129,645 Bxy 78 12 Cxy2 7,654,147 Bxy 650 78 Cxy


311456 143 Bxy


7,654,147 2178 650 78 Cxy7,654,147 1415707 78 Cxy

6238440 = 78 Cxy

79,980 = Cxy

Y= 2178 24 79,98052272 + 79,980

132,252

100004 DULCE FRUTICAS

1 633,142 Bxy 78 12 Cxy2 4,289,989 Bxy 650 78 Cxy


174564 143 Bxy


4,289,989 1221 650 78 Cxy4,289,989 793474 78 Cxy

3496515 = 78 Cxy

44,827 = Cxy

Y= 1221 24 44,82729298 + 44,827

74,125

100006 DULCES DE CAFÉ

1 524,764 Bxy 78 12 Cxy2 3,555,649 Bxy 650 78 Cxy


144683 143 Bxy


3,555,649 1012 650 78 Cxy3,555,649 657651 78 Cxy

2897998 = 78 Cxy

37,154 = Cxy

Y= 1012 24 37,15424282 + 37,154

61,436

-6.5

-6.5

PROYECCION DE LA DEMANDA POR MINIMOS CUADRADOS.xlsx

Documents

Transcript of PROYECCION DE LA DEMANDA POR MINIMOS CUADRADOS.xlsx