diff options
Diffstat (limited to '2023-2/L02')
| -rw-r--r-- | 2023-2/L02/Pedidos.csv | 563 | ||||
| -rw-r--r-- | 2023-2/L02/Productos.csv | 167 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/ReporteDeEntregaDePedisos.txt | 707 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/ReporteDePedidos.txt | 563 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/ReporteDeProductos.txt | 167 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/ReporteDeProductosFinal.txt | 167 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/fun.cpp | 313 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/fun.hpp | 45 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/main.cpp | 30 | ||||
| -rw-r--r-- | 2023-2/L02/mitsuo/simple.ipynb | 1070 |
10 files changed, 3792 insertions, 0 deletions
diff --git a/2023-2/L02/Pedidos.csv b/2023-2/L02/Pedidos.csv new file mode 100644 index 0000000..f4f2d3f --- /dev/null +++ b/2023-2/L02/Pedidos.csv @@ -0,0 +1,563 @@ +JXD-139,50375303,6,24/08/2023 +CRU-009,50375303,5,3/09/2023 +YYK-309,22777006,3,27/08/2023 +OTS-581,42157219,5,28/08/2023 +AWB-345,13245501,1,24/08/2023 +IHG-413,33397650,3,4/09/2023 +KQQ-136,97403853,6,30/08/2023 +OQI-373,78757121,3,22/08/2023 +PVZ-181,26290971,3,3/09/2023 +ICX-503,27912250,1,26/08/2023 +DFF-034,98140264,2,29/08/2023 +VCL-867,25171011,3,29/08/2023 +TZY-323,57263719,6,25/08/2023 +PJG-338,63437380,2,27/08/2023 +SSD-176,35584593,4,31/08/2023 +BWD-036,60574154,2,5/09/2023 +FLJ-040,73535476,4,3/09/2023 +JDC-028,31193794,1,23/08/2023 +OTH-462,73185299,3,31/08/2023 +QIL-029,86828079,5,2/09/2023 +UWA-476,77484838,1,28/08/2023 +XOA-735,13245501,5,5/09/2023 +OBI-353,79901434,6,2/09/2023 +AWB-345,16552775,6,3/09/2023 +CSZ-863,57690875,5,21/08/2023 +UWA-476,73535476,5,3/09/2023 +MLE-193,87813843,4,27/08/2023 +UOD-420,95751208,4,3/09/2023 +KWP-672,87800799,2,25/08/2023 +BXY-119,20864087,4,2/09/2023 +KCO-488,46462527,4,5/09/2023 +PQH-935,71984468,2,22/08/2023 +GBJ-693,15561764,2,3/09/2023 +XLF-273,43488351,5,22/08/2023 +RSE-049,15210391,5,22/08/2023 +CJE-310,79464412,5,28/08/2023 +SJQ-827,76388967,5,28/08/2023 +TKM-141,89148118,6,23/08/2023 +EBI-299,76388967,5,29/08/2023 +DFF-034,79140840,3,27/08/2023 +SSD-176,37110873,1,2/09/2023 +ZEX-027,43043986,1,3/09/2023 +OBI-353,73914283,1,27/08/2023 +SJD-818,41036366,4,2/09/2023 +GLC-370,28390487,2,1/09/2023 +YUQ-590,45783712,2,31/08/2023 +QHC-492,29337157,6,23/08/2023 +CIM-038,35565959,4,25/08/2023 +CRU-009,96258632,2,3/09/2023 +AHB-459,12663268,3,24/08/2023 +MQR-442,86828079,3,26/08/2023 +CNN-411,16552775,5,29/08/2023 +AFL-718,50365593,5,30/08/2023 +CIM-038,11602775,4,21/08/2023 +XZR-640,78078115,5,22/08/2023 +LDR-510,62324793,1,31/08/2023 +QUU-384,37110873,4,31/08/2023 +OWN-701,36380447,5,24/08/2023 +BTO-226,77484838,4,22/08/2023 +BRD-969,98140264,1,2/09/2023 +ZEX-027,29337157,3,21/08/2023 +DFJ-952,84165595,1,1/09/2023 +RDT-761,84165595,6,2/09/2023 +TMN-884,88956889,1,24/08/2023 +FEG-454,59162728,4,24/08/2023 +JDC-028,50365593,6,2/09/2023 +JCW-489,69324480,5,4/09/2023 +KWP-672,46462527,3,29/08/2023 +VDD-853,49087435,2,21/08/2023 +ZEX-027,79901434,2,3/09/2023 +ZVA-180,33713901,6,24/08/2023 +KQA-580,50375303,5,4/09/2023 +QUU-384,77642521,5,25/08/2023 +TKM-141,78922174,5,28/08/2023 +NMV-644,94080926,5,28/08/2023 +CIM-038,93845419,5,5/09/2023 +TYF-885,62566305,4,21/08/2023 +OQI-373,86402303,3,24/08/2023 +AHB-459,79901434,3,25/08/2023 +IDO-503,32565207,6,4/09/2023 +BCK-361,49087435,3,26/08/2023 +TYF-885,83505958,5,30/08/2023 +OPT-996,25171011,6,22/08/2023 +VVS-017,45877001,4,21/08/2023 +QUU-384,67418025,1,25/08/2023 +YOT-530,43053402,2,27/08/2023 +ISU-815,52097922,5,27/08/2023 +III-576,63437380,5,4/09/2023 +LWG-915,50365593,3,1/09/2023 +BWD-036,57263719,3,28/08/2023 +AFL-718,78922174,5,26/08/2023 +AWB-345,63437380,4,30/08/2023 +YYU-726,12663268,4,3/09/2023 +JJN-837,11602775,1,26/08/2023 +ZWF-661,17972674,1,28/08/2023 +EJW-346,83505958,3,21/08/2023 +BWD-036,79475585,5,26/08/2023 +UWA-476,17972674,4,26/08/2023 +XLF-273,89148118,5,28/08/2023 +UXG-019,32565207,4,27/08/2023 +NSM-283,79464412,2,29/08/2023 +VJI-529,95161027,2,22/08/2023 +TYF-885,79140840,2,25/08/2023 +YZD-580,37110873,5,27/08/2023 +XLF-273,11602775,4,25/08/2023 +TZY-323,15210391,3,2/09/2023 +LWG-915,27912250,4,22/08/2023 +TMN-884,91897732,2,4/09/2023 +QHC-492,98140264,4,21/08/2023 +UJV-290,83236386,5,1/09/2023 +OWN-701,52097922,2,29/08/2023 +WZD-331,40348917,3,21/08/2023 +BIT-434,71378466,4,26/08/2023 +AWT-354,71463316,4,31/08/2023 +III-576,95161027,5,2/09/2023 +KCO-488,71463316,5,29/08/2023 +KCO-488,24995742,4,24/08/2023 +JFC-432,20864087,1,2/09/2023 +YOT-530,31611146,4,4/09/2023 +JFC-432,85949265,4,4/09/2023 +DFJ-952,77642521,5,29/08/2023 +QHC-492,53166028,1,29/08/2023 +PFD-286,90237332,4,23/08/2023 +MQR-442,83505958,1,26/08/2023 +JYQ-045,15561764,6,22/08/2023 +AFL-718,50375303,1,2/09/2023 +AFL-718,77484838,1,26/08/2023 +BCK-361,97403853,5,24/08/2023 +XSD-310,12663268,6,27/08/2023 +TXM-139,19829266,3,30/08/2023 +KQA-580,63437380,2,5/09/2023 +RAH-420,12663268,3,4/09/2023 +PFD-286,89298238,2,23/08/2023 +NSM-283,42928709,5,28/08/2023 +PJG-338,45877001,2,29/08/2023 +OQI-373,42928709,5,2/09/2023 +ONB-903,32821689,3,30/08/2023 +FVQ-662,71378466,2,3/09/2023 +YYK-309,11602775,3,27/08/2023 +UDR-957,77484838,3,29/08/2023 +FYF-898,15561764,2,27/08/2023 +CIM-038,57690875,3,28/08/2023 +SPR-580,54716824,3,5/09/2023 +VVS-017,95161027,5,26/08/2023 +KWP-672,90365520,6,21/08/2023 +QHC-492,73185299,3,1/09/2023 +QFR-958,45783712,3,21/08/2023 +SJQ-827,49087435,1,21/08/2023 +DEV-433,54761731,3,26/08/2023 +MMA-577,43053402,6,2/09/2023 +ZXK-295,78757121,4,22/08/2023 +VXS-438,13245501,3,1/09/2023 +LWG-915,46462527,6,31/08/2023 +YUQ-590,88956889,2,4/09/2023 +AQS-362,55552996,1,23/08/2023 +RSE-049,76388967,6,22/08/2023 +III-576,60574154,6,27/08/2023 +UXG-019,55552996,6,5/09/2023 +VRR-793,87800799,2,31/08/2023 +EJW-346,78922174,6,2/09/2023 +BCK-361,80048864,3,28/08/2023 +AWB-345,25171011,6,31/08/2023 +FCN-617,22777006,1,31/08/2023 +AQS-362,42798099,1,5/09/2023 +QFP-254,90237332,3,31/08/2023 +DIQ-718,62566305,4,25/08/2023 +BIT-434,59407188,6,28/08/2023 +TMN-884,42798099,5,1/09/2023 +OXP-732,79901434,2,24/08/2023 +SNY-500,40348917,4,25/08/2023 +QUU-384,73185299,3,27/08/2023 +MTF-868,83236386,2,25/08/2023 +VXS-438,89429489,1,21/08/2023 +VTV-269,26976877,4,3/09/2023 +IHG-413,17913944,4,21/08/2023 +SNY-500,43877279,4,27/08/2023 +GXF-122,37110873,2,22/08/2023 +BCN-855,38913831,3,4/09/2023 +JXD-139,44229880,4,4/09/2023 +FVQ-662,32565207,5,28/08/2023 +DUG-251,32904023,4,1/09/2023 +QJO-060,45828535,6,26/08/2023 +YMU-875,24995742,3,28/08/2023 +VRR-793,81114108,4,21/08/2023 +TYF-885,26290971,3,24/08/2023 +ADX-669,96659352,4,1/09/2023 +CJE-310,98140264,3,2/09/2023 +AFL-718,26976877,5,24/08/2023 +EBI-299,71463316,6,29/08/2023 +AFL-718,89148118,1,1/09/2023 +OPT-996,83236386,2,26/08/2023 +PVZ-181,90237332,5,21/08/2023 +WZD-331,16151792,3,22/08/2023 +RDT-761,80048864,5,5/09/2023 +TXM-139,94080926,5,2/09/2023 +KSO-608,40112594,6,27/08/2023 +CIM-038,73535476,3,22/08/2023 +FLJ-040,40348917,2,21/08/2023 +HFM-021,88956889,6,29/08/2023 +AQS-362,41036366,2,27/08/2023 +TYF-885,43877279,5,5/09/2023 +OQI-373,42798099,2,3/09/2023 +QVJ-982,77191257,5,1/09/2023 +VRR-793,98589725,1,5/09/2023 +CIM-038,25171011,1,27/08/2023 +JDQ-505,20864087,6,2/09/2023 +III-576,42157219,6,26/08/2023 +JXD-139,79464412,4,24/08/2023 +QRC-609,25171011,3,24/08/2023 +QTK-083,89298238,3,22/08/2023 +BCN-855,81114108,4,23/08/2023 +QFP-254,89298238,2,28/08/2023 +DFF-034,66409237,4,2/09/2023 +GBD-525,52097922,5,25/08/2023 +JFC-432,89148118,5,24/08/2023 +FLJ-040,38637282,6,26/08/2023 +TMN-884,23928045,2,3/09/2023 +AWB-345,44679500,1,28/08/2023 +CNQ-172,16151792,1,25/08/2023 +UWA-476,37110873,2,21/08/2023 +JDQ-505,48467976,5,31/08/2023 +XSD-310,22280452,2,5/09/2023 +BCK-361,29847168,1,29/08/2023 +XSD-310,45828535,4,31/08/2023 +AVM-258,35584593,4,28/08/2023 +QHC-492,96258632,2,30/08/2023 +SJD-818,55552996,1,29/08/2023 +FQG-293,55552996,1,21/08/2023 +MYC-756,85871751,2,28/08/2023 +QFP-254,43043986,5,28/08/2023 +AVM-258,45828535,2,24/08/2023 +UWA-476,71463316,3,28/08/2023 +ARS-231,71378466,6,28/08/2023 +KQQ-136,79475585,6,28/08/2023 +AWT-354,66409237,6,2/09/2023 +WZD-331,69975105,6,30/08/2023 +XLF-273,42928709,4,4/09/2023 +UWA-476,88956889,3,4/09/2023 +MMA-577,32821689,5,25/08/2023 +TMJ-043,85949265,6,21/08/2023 +DFF-034,78078115,2,22/08/2023 +KJX-387,32904023,3,28/08/2023 +KBY-991,90365520,6,31/08/2023 +XZR-640,91897732,5,1/09/2023 +KQA-580,96659352,6,27/08/2023 +JXD-139,26976877,2,25/08/2023 +KCO-488,42157219,2,28/08/2023 +UOD-420,69324480,3,3/09/2023 +BRD-969,66409237,3,4/09/2023 +QFP-254,71463316,6,21/08/2023 +VRR-793,22280452,5,23/08/2023 +HLR-109,79140840,1,27/08/2023 +LDR-510,73535476,2,25/08/2023 +YYU-726,93160528,1,1/09/2023 +OWN-701,59407188,1,3/09/2023 +ZAF-449,26233063,2,21/08/2023 +ISU-815,46462527,6,24/08/2023 +WZD-331,87800799,2,29/08/2023 +OQI-373,90237332,1,27/08/2023 +BCN-855,71463316,4,28/08/2023 +QFP-254,42928709,5,4/09/2023 +UJV-290,89298238,4,1/09/2023 +UXG-019,66409237,4,28/08/2023 +SSE-115,89863424,4,27/08/2023 +VXS-438,69324480,3,23/08/2023 +MTF-868,79464412,6,23/08/2023 +OXP-732,23928045,3,28/08/2023 +OPJ-039,90365520,1,21/08/2023 +RDT-761,59407188,5,26/08/2023 +DIQ-718,43488351,6,1/09/2023 +YUQ-590,77484838,6,22/08/2023 +OTH-462,79140840,1,30/08/2023 +CSZ-863,95015539,2,24/08/2023 +GXF-122,78757121,1,26/08/2023 +EUZ-452,90365520,6,26/08/2023 +OPT-996,69639726,3,21/08/2023 +MYC-756,88956889,4,2/09/2023 +GBD-525,87800799,6,30/08/2023 +DON-719,24995742,3,2/09/2023 +VRR-793,43053402,2,29/08/2023 +EBI-299,96258632,5,25/08/2023 +UWA-476,88956889,6,2/09/2023 +BRD-969,93160528,5,23/08/2023 +HFC-845,13245501,6,26/08/2023 +UWA-476,26233063,1,4/09/2023 +QFP-254,32904023,4,2/09/2023 +FQG-293,78078115,4,1/09/2023 +AQS-362,16151792,1,29/08/2023 +QTK-083,43488351,6,23/08/2023 +YOT-530,89298238,4,2/09/2023 +QTK-083,93160528,3,23/08/2023 +JJN-837,11602775,2,24/08/2023 +GLC-370,79372768,4,2/09/2023 +SSD-176,43043986,5,1/09/2023 +GXF-122,62566305,5,30/08/2023 +MTF-868,32821689,5,2/09/2023 +QRC-609,35565959,5,4/09/2023 +PJG-338,49087435,1,21/08/2023 +OTH-462,57263719,5,3/09/2023 +YJD-279,62324793,5,25/08/2023 +LYZ-614,59407188,3,2/09/2023 +CNQ-172,76388967,6,23/08/2023 +ZWF-661,13245501,1,25/08/2023 +TMN-884,79140840,5,21/08/2023 +YJD-279,50375303,5,4/09/2023 +QIL-029,42928709,4,30/08/2023 +QTK-083,55552996,1,2/09/2023 +YGV-332,86828079,1,27/08/2023 +ARS-231,78757121,4,26/08/2023 +FCN-617,37110873,6,3/09/2023 +TMN-884,50365593,6,2/09/2023 +ICX-503,87800799,2,25/08/2023 +RBE-789,81114108,2,29/08/2023 +UDR-957,54716824,1,31/08/2023 +KJX-387,78757121,4,27/08/2023 +KSO-608,26233063,3,28/08/2023 +CIM-038,86241107,2,28/08/2023 +YOT-530,89298238,1,23/08/2023 +BWD-036,24995742,1,26/08/2023 +OTW-288,15210391,3,24/08/2023 +QUU-384,89429489,1,23/08/2023 +BMJ-772,40348917,1,1/09/2023 +GBJ-693,96659352,3,3/09/2023 +TZY-323,16151792,3,5/09/2023 +WLL-607,91897732,1,21/08/2023 +SSD-176,43877279,4,24/08/2023 +VDD-853,37110873,4,31/08/2023 +VXS-438,15210391,4,2/09/2023 +QFR-958,27912250,3,4/09/2023 +AQS-362,73786035,1,25/08/2023 +ZEX-027,54716824,6,31/08/2023 +JJN-837,71984468,5,21/08/2023 +XOA-735,78078115,2,27/08/2023 +DFJ-952,35565959,2,28/08/2023 +XBD-314,78922174,3,1/09/2023 +ZVA-180,50365593,6,23/08/2023 +BZS-261,35565959,1,1/09/2023 +KBY-991,58187172,6,25/08/2023 +UTN-601,52097922,2,3/09/2023 +XSD-310,87813843,3,1/09/2023 +TKM-141,23928045,5,30/08/2023 +HFM-021,15210391,1,21/08/2023 +MTF-868,88995291,3,4/09/2023 +OQI-373,86402303,3,26/08/2023 +FQG-293,62324793,1,29/08/2023 +BTO-226,87800799,3,29/08/2023 +DEN-125,17913944,1,1/09/2023 +UTN-601,17972674,1,21/08/2023 +SSE-115,79420973,5,1/09/2023 +OQI-373,71378466,1,25/08/2023 +HLR-109,88995291,2,25/08/2023 +OFS-384,83236386,1,23/08/2023 +XZR-640,49087435,6,21/08/2023 +TKM-141,32565207,4,30/08/2023 +DFF-034,81114108,5,31/08/2023 +DEN-125,73786035,4,28/08/2023 +SNY-500,44229880,3,29/08/2023 +CSZ-863,79901434,5,3/09/2023 +BWD-036,95751208,3,25/08/2023 +EVN-510,67418025,5,27/08/2023 +KCO-488,35584593,1,22/08/2023 +VCL-867,25171011,1,21/08/2023 +YUQ-590,20864087,5,29/08/2023 +OFS-384,81114108,3,23/08/2023 +TMJ-043,78078115,3,22/08/2023 +OFS-384,64394265,5,31/08/2023 +BRD-969,95751208,4,27/08/2023 +IDO-503,16151792,6,1/09/2023 +GKG-558,26290971,3,30/08/2023 +YUQ-590,85949265,2,21/08/2023 +TZY-323,45828535,6,28/08/2023 +YZD-580,38913831,1,22/08/2023 +CNN-411,42798099,6,31/08/2023 +SSE-115,26976877,4,28/08/2023 +VJI-529,33397650,6,2/09/2023 +TXM-139,43043986,3,21/08/2023 +EUZ-452,87800799,2,25/08/2023 +PPX-620,80048864,1,28/08/2023 +UCX-285,22280452,3,1/09/2023 +TZY-323,71984468,1,1/09/2023 +QRC-609,87800799,1,22/08/2023 +JFC-432,38913831,3,21/08/2023 +XLF-273,57690875,4,26/08/2023 +CIM-038,94080926,2,26/08/2023 +LWG-915,23928045,2,23/08/2023 +ICX-503,66409237,5,22/08/2023 +BXY-119,13245501,5,2/09/2023 +HFC-845,86241107,3,22/08/2023 +YOT-530,57263719,5,25/08/2023 +KQQ-136,26976877,3,27/08/2023 +RDT-761,19829266,3,1/09/2023 +FQG-293,69975105,5,4/09/2023 +PFD-286,76388967,6,4/09/2023 +DIQ-718,69324480,1,2/09/2023 +QIL-029,13245501,2,31/08/2023 +JXD-139,89298238,3,5/09/2023 +QFP-254,73185299,5,23/08/2023 +XBD-314,78922174,2,23/08/2023 +TMJ-043,11602775,6,21/08/2023 +BMJ-772,12663268,1,5/09/2023 +KDA-627,60574154,5,28/08/2023 +FLW-631,38913831,3,27/08/2023 +OTH-462,57263719,2,27/08/2023 +RBE-789,86402303,6,30/08/2023 +KQA-580,48184351,2,30/08/2023 +ZVA-180,54761731,4,26/08/2023 +VRR-793,85949265,5,30/08/2023 +DFJ-952,78078115,5,2/09/2023 +DON-719,15210391,2,30/08/2023 +UXG-019,86241107,2,1/09/2023 +YUQ-590,64394265,1,5/09/2023 +DOV-560,76388967,2,5/09/2023 +ZWF-661,77191257,4,4/09/2023 +HFM-021,29337157,4,2/09/2023 +AWB-345,93845419,5,25/08/2023 +HFM-021,86402303,6,31/08/2023 +BCK-361,40112594,2,28/08/2023 +FVB-607,54761731,5,24/08/2023 +LDR-510,87813843,6,23/08/2023 +HFC-845,36008913,6,22/08/2023 +QVJ-982,79372768,6,28/08/2023 +YEZ-591,63437380,5,27/08/2023 +UXG-019,19829266,2,25/08/2023 +YYK-309,64394265,6,22/08/2023 +KWP-672,42157219,6,26/08/2023 +KWP-672,77191257,2,2/09/2023 +HFM-021,84165595,6,1/09/2023 +OXP-732,91897732,2,27/08/2023 +FVB-607,89863424,1,2/09/2023 +GXF-122,79420973,3,2/09/2023 +VZV-827,54761731,1,26/08/2023 +WZD-331,29337157,4,26/08/2023 +BXY-119,31193794,5,29/08/2023 +PFD-286,91897732,2,4/09/2023 +QUU-384,43877279,5,28/08/2023 +UXG-019,89429489,1,3/09/2023 +EBI-299,89148118,6,31/08/2023 +ISU-815,32821689,1,22/08/2023 +VCL-867,89429489,6,30/08/2023 +TZY-323,26290971,5,22/08/2023 +JFC-432,26233063,4,27/08/2023 +SSD-176,55552996,6,27/08/2023 +XSD-310,52097922,6,3/09/2023 +HLR-109,36380447,2,4/09/2023 +XLF-273,22777006,2,27/08/2023 +LDR-510,85949265,6,24/08/2023 +YJD-279,17913944,5,21/08/2023 +UWA-476,33713901,2,2/09/2023 +SSD-176,78078115,1,24/08/2023 +DUG-251,93160528,2,25/08/2023 +SJQ-827,50375303,2,25/08/2023 +FVQ-662,31611146,4,1/09/2023 +VXS-438,50375303,4,4/09/2023 +KJX-387,73535476,4,26/08/2023 +FEG-454,86241107,2,29/08/2023 +VJI-529,69324480,1,5/09/2023 +VJI-529,35565959,5,24/08/2023 +RDT-761,42798099,6,25/08/2023 +BRD-969,73914283,3,5/09/2023 +OQI-373,87813843,1,31/08/2023 +TZY-323,77191257,3,26/08/2023 +AFL-718,49087435,1,25/08/2023 +VVS-017,33713901,1,3/09/2023 +DFJ-952,25171011,4,4/09/2023 +JXD-139,35565959,5,30/08/2023 +AVM-258,62566305,1,3/09/2023 +QIL-029,93845419,6,31/08/2023 +JCW-489,13245501,5,27/08/2023 +RBE-789,32904023,6,3/09/2023 +PJG-338,78078115,2,23/08/2023 +DUG-251,99842319,2,3/09/2023 +KQQ-136,96659352,3,30/08/2023 +SNY-500,45783712,5,25/08/2023 +CNQ-172,62566305,3,5/09/2023 +KJX-387,13245501,5,5/09/2023 +DUG-251,81114108,5,21/08/2023 +SAM-013,79372768,1,23/08/2023 +ZEX-027,77191257,6,1/09/2023 +OTW-288,64394265,5,23/08/2023 +TXM-139,48184351,1,4/09/2023 +XBD-314,62324793,5,30/08/2023 +YUQ-590,26976877,4,27/08/2023 +FQG-293,95161027,4,29/08/2023 +OFS-384,38637282,1,27/08/2023 +DON-719,69639726,1,29/08/2023 +TZY-323,50365593,1,21/08/2023 +YYU-726,77642521,2,23/08/2023 +SAM-013,32904023,3,21/08/2023 +FLJ-040,27912250,3,26/08/2023 +JFC-432,84165595,3,27/08/2023 +TKM-141,90237332,3,2/09/2023 +ONB-903,53166028,3,29/08/2023 +HFM-021,69975105,6,28/08/2023 +AVM-258,77191257,6,22/08/2023 +MMA-577,52097922,2,22/08/2023 +FVQ-662,43053402,6,28/08/2023 +ICX-503,89298238,3,5/09/2023 +GBJ-693,45877001,5,27/08/2023 +FEG-454,67418025,2,31/08/2023 +QFP-254,12663268,5,23/08/2023 +QVJ-982,41036366,4,1/09/2023 +OTH-462,89863424,6,28/08/2023 +EBI-299,40112594,3,21/08/2023 +QHC-492,84165595,4,22/08/2023 +YMU-875,45828535,5,29/08/2023 +KQQ-136,32904023,1,26/08/2023 +TMJ-043,69975105,6,31/08/2023 +QRC-609,89863424,3,30/08/2023 +ZAF-449,99842319,1,26/08/2023 +BXY-119,89429489,3,2/09/2023 +CRU-009,66409237,4,27/08/2023 +OQI-373,78922174,3,27/08/2023 +VZV-827,45783712,1,24/08/2023 +YMU-875,45783712,4,4/09/2023 +FVQ-662,40112594,4,3/09/2023 +HLR-109,44229880,5,21/08/2023 +YYU-726,67418025,6,5/09/2023 +VVS-017,50365593,3,24/08/2023 +CRU-009,54716824,6,27/08/2023 +NSR-955,93845419,2,22/08/2023 +YGV-332,77484838,3,25/08/2023 +VXS-438,58187172,2,21/08/2023 +XLF-273,17913944,4,27/08/2023 +ZWF-661,57263719,5,26/08/2023 +AQS-362,16151792,1,3/09/2023 +OQI-373,95161027,1,28/08/2023 +VDD-853,90365520,5,2/09/2023 +JXD-139,79140840,4,1/09/2023 +YJD-279,97403853,3,31/08/2023 +JDC-028,87800799,5,24/08/2023 +EUZ-452,79372768,5,2/09/2023 +OBI-353,73914283,4,24/08/2023 +VCL-867,81114108,1,26/08/2023 +TXM-139,53166028,3,2/09/2023 +RDT-761,45877001,5,24/08/2023 +XTE-383,57690875,6,27/08/2023 +SSD-176,45783712,6,2/09/2023 +GBJ-693,97403853,4,30/08/2023 +XSD-310,31611146,1,26/08/2023 +XSD-310,71378466,3,29/08/2023 +RAH-420,15561764,4,21/08/2023 +AVM-258,73185299,3,30/08/2023 +TZY-323,95161027,5,21/08/2023 +DOV-560,57263719,4,2/09/2023 +III-576,49087435,2,1/09/2023 +DFJ-952,40348917,2,2/09/2023 +QRC-609,79140840,5,2/09/2023 +VRR-793,40348917,3,26/08/2023 +LWG-915,27912250,1,22/08/2023 +GLC-370,42928709,6,24/08/2023 +SPR-580,20864087,1,22/08/2023 +BWD-036,77191257,5,21/08/2023 +XZG-521,52097922,4,3/09/2023 +OTS-581,54761731,5,3/09/2023 +AQS-362,15210391,2,30/08/2023 +OTW-288,94080926,5,22/08/2023 +TXM-139,79901434,2,26/08/2023 +BWD-036,80048864,3,22/08/2023 +XZG-521,26976877,3,26/08/2023 +SPR-580,94080926,5,4/09/2023 +OPJ-039,62324793,2,28/08/2023 +ZWF-661,32565207,6,21/08/2023 +KBY-991,45877001,6,30/08/2023 diff --git a/2023-2/L02/Productos.csv b/2023-2/L02/Productos.csv new file mode 100644 index 0000000..40c7ff8 --- /dev/null +++ b/2023-2/L02/Productos.csv @@ -0,0 +1,167 @@ +BIT-434,Campana Extractora modelo Glass,375.09,10 +SSE-115,Refrigeradora CoolStyle 311N Steel,3243.58,23 +NMV-644,Lavadora Automatica,3272.48,5 +MLE-193,Cocina a gas Ingenious,2779.41,10 +YYK-309,Refrigeradora Door in Door,4079.44,25 +QVJ-982,Horno Microondas 0.7 p3,1352.76,12 +VZV-827,Refrigeradora Top Mount,1784.27,2 +HFC-845,Televisor Serie LED R555A,3736.75,22 +AVM-258,Cocina a gas Toscana,2831.23,20 +YUQ-590,Refrigeradora CoolStyle 395N Steel,1979.07,19 +FLJ-040,Parlantes portatiles SOUNDSHOOTER,3703.37,19 +EUZ-452,Impresora Mutifuncional Led Color,3623.88,11 +SPR-580,Dispensador de Agua,404.35,15 +WLL-607,Cocina Electronica Convencion,1525.04,1 +UWA-476,Autoradio MEX BT3150U,1191.39,29 +YOT-530,Deshumedecedor DM-190H,941.73,13 +NSR-955,Cocina a gas Blogna,2591.44,14 +SJD-818,Refrigeradora CoolStyle 281A Steel,3387.75,23 +BCK-361,Tablets 10.1,1872.53,9 +ZAF-449,Tablet Cardle,816.43,16 +OBI-353,Terma Milenium,2960.56,16 +SNY-500,Cocina a gas Praga Quarzo,3297.09,12 +CSZ-863,Video Filmadora,1713.57,17 +TMJ-043,Lavadora EcoBubble,2400.79,23 +MTF-868,Impresora Monocromatica WorkForce M205,971.59,12 +BMJ-772,Refrigeradora Side by Side,936.32,13 +MYC-756,Cocina a gas Leganza INOX,1506.80,21 +FCN-617,Televisor Plasma 60,4121.05,6 +ONB-903,Reproductor BLU-RAY 3D,653.67,16 +VXS-438,Mouse Blue Tooth,60.11,17 +GLC-370,Video Proyector Power Lite 95,552.24,19 +OPT-996,Mini componente GPX88,1367.48,14 +PFD-286,Refrigeradora cap. 415 litros,2776.02,8 +KBY-991,Home Theater E4100,1101.08,24 +KQQ-136,Impresora Laser EPSON,1139.56,17 +NSM-283,Cocina a gas FFG3053SL,936.81,13 +ICX-503,Cocina a gas Roma,1221.02,15 +LDR-510,Mini componente ESX9,2701.87,25 +PJG-338,Impresora Mutifuncional Inalambricar,1067.80,21 +ISB-205,Camara fotografica 16MP,2976.43,3 +UDR-957,Refrigeradora ECOTT 423 IXL,861.70,19 +RAH-420,Cocina a gas Pro 6550 INOX,157.01,5 +JDQ-505,Lavadora Modelo Aquamatic,1572.31,24 +PPX-620,Aire acondicionado tipo split,2873.42,8 +XZG-521,Secadora Electrica FAQE7001LW,704.27,22 +VJI-529,Horno Empotrable Electrico,1102.67,16 +JCW-489,Conservadora Exibidora CMVE-250,2064.97,11 +OTS-581,Galaxy Note 8.0,2653.10,24 +UTN-601,Autoradio XAV-601 BT,562.51,4 +TZY-323,Terma a gas,2341.01,31 +TXM-139,Televisor LED FULL HD 3D,1092.95,5 +ADX-669,Refrigeradora cap. 220 litros,1239.38,15 +QRC-609,Camara de video EOS,1806.66,17 +YJD-279,Cocina a gas Florencia,1028.43,23 +AHB-459,Reproductor DVD Portatil TV 7,685.50,9 +MMA-577,Congeladora Horizontal 252 Lts.,1780.30,14 +VCL-867,Cocina a gas Rubi 2,699.07,9 +JDC-028,Puntero Laser,30.48,19 +JXD-139,Terma Evolucion Soltu,586.02,28 +KQA-580,Cocina Empotrable Glassy Plus,2907.92,17 +XSD-310,Refrigeradora No frost,2259.93,17 +YYU-726,Reproductor DVD Portatil,767.82,14 +EVN-510,Cocina a gas FFG3011LB,2672.30,15 +LZK-729,Cocina a gas Kristel,2850.91,3 +AQS-362,Teclado Inalambrico USB,233.05,7 +AWT-354,Galaxy Gear,3409.22,22 +CJE-310,Mini componente GPX33,3643.39,16 +KWP-672,Televisor UHD TV,1625.30,24 +DOV-560,Impresora Laser Mutifuncion Monocromatica,1203.14,3 +RBE-789,Televisor SMART TV,3303.07,17 +KCO-488,Ventilador de pared,679.60,22 +KSO-608,Secadora Modelo Italica,914.17,21 +TKM-141,Cocina a gas Marsella,402.24,24 +QUU-384,Lavavajilla Blue Touch,2545.54,1 +VRR-793,Rack Giratorio 32/60,241.71,26 +SAM-013,Cocina a gas FFG3047SL,2275.18,1 +YMU-875,Cocina a gas Plermo Quarzo,3232.10,9 +SSD-176,Refrigeradora Linea Gallery,567.71,23 +DFJ-952,Cocina a gas Prestige 60 INOX,3342.77,18 +BZS-261,Cocina a gas Trento,3087.87,8 +ARS-231,Audifonos Stereos,327.62,13 +SJQ-827,Reproductor Multimedia Touch Screen,1719.56,21 +UJV-290,Cocina a gas Fassina Plus,2423.26,10 +QTK-083,Congeladora Conservador Vertical 476 Lts.,2682.73,16 +EQY-018,Radio AM/FM stereo RMU-51C,301.73,7 +OQI-373,Cocina Empotrable Premio Plus,906.16,20 +OTH-462,Lavadora Semi-Automatica,531.04,20 +XTE-383,Rack Fijo 32/60,261.01,10 +ZVA-180,Refrigeradora 322 litros,2903.13,13 +BCN-855,Cocina a gas Bahia Can,4015.92,14 +PQH-935,Rack Giratorio 26/32,94.45,12 +LYZ-614,Impresore Mutifuncional Expression XP-211,3510.84,13 +FYF-898,Proyector a color,1160.46,15 +OPJ-039,Secadora de Ropa,2765.64,12 +CNN-411,Congeladora Side by Side,2296.29,24 +KJX-387,Ventilador de techo,613.19,9 +JFC-432,DVD DVM-L79,307.67,24 +EJW-346,Campana Extractora,359.70,11 +EBI-299,Cocina a gas Fridare,2287.57,15 +FEG-454,Sillon masajeador,1695.70,8 +YEZ-591,Lavadora WA,1320.03,9 +UXG-019,Terma de acumulacion,934.91,16 +FVB-607,Cocina a gas Essenza BL,2953.07,13 +RDT-761,Horno Microondas con dorador,904.95,21 +BWD-036,Cocina Empotrable Klimatica,1086.34,5 +TMN-884,Secadora de mano,310.65,10 +ZXK-295,Cocina Empotrable Electrica,3679.43,9 +DIQ-718,Horno Microondas de Conveccion Cello,390.80,3 +BTO-226,Friobar,863.19,25 +DFF-034,Grabadora de voz digital portatil con USB integrado,259.25,24 +OFS-384,Parlantes Bluetooth,805.22,8 +YZD-580,Mini componente ESX8,1582.29,4 +OTW-288,Cavba de Vinos GE cap. 34 botellas,1119.18,14 +UOD-420,Mini componente ESX6,828.94,10 +IDO-503,Laptop GamerVictus de 15.6,3935.17,23 +VDD-853,Deshumedecedor FAD30D7TSSW 3.4L 25-30m2,1095.67,16 +VTV-269,Extractor de aire,854.48,9 +XZR-640,Lavadora-Secadora FWD,2390.58,14 +DON-719,Secadora de Cabello SG-3035,360.69,12 +HTY-123,Refrigeradora GM-S604ULV,1173.33,1 +LWG-915,Cocina a gas Murano,1101.47,15 +JYQ-045,Horno Microondas 1.2 p3,267.15,20 +AWB-345,Deshumedecedor DM-189H,800.37,6 +YGV-332,Impresora Led Color,2517.66,18 +HLR-109,Parlantes inalambricos,439.47,25 +MQR-442,Reloj Digital RMM-29,271.66,25 +GBD-525,Refrigeradora Puertas Mágicas,2700.95,14 +DEV-433,Parlantes portatiles SHOQBOX,2698.74,13 +OXP-732,Televisor OLED 4K UHD Google TV Smart 77 XR-77A80L LA8,16504.47,8 +FVQ-662,Cocina a gas Pro 6300 INOX,1060.68,13 +DEN-125,Rack Fijo 26/32,562.46,25 +CRU-009,Lavavajilla,2655.78,5 +RSE-049,Radio CD/DVD - TV,4037.51,21 +BRD-969,Centro de Lavado Electrico,2579.72,18 +CIM-038,Cocina Empotrable Petra,2544.64,16 +CNQ-172,Congeladora Horizontal 364 Lts.,3689.62,15 +QFR-958,Cocina a gas Bavaro,1607.46,6 +TYF-885,Videojuego TW 4,794.14,7 +VVS-017,Tablets MW 0731,2599.72,14 +BXY-119,Cocina Empotrable Klimatica,2716.11,12 +GKG-558,Horno Microondas MS2042D,1674.24,23 +UCX-285,Galaxy Tab 3,3290.93,11 +WZD-331,Refrigeradora ECOTT 465 IX,1213.79,7 +AFL-718,Vinera,1664.97,17 +JJN-837,Lavadora Tecnologia Wobbie,1979.92,15 +KDA-627,Cocina a gas Ijasmin,1424.46,7 +PVZ-181,Ventilador circular,309.77,8 +ISU-815,Audifonos,619.89,16 +OWN-701,Olla arrocera ,220.82,21 +HFM-021,Horno Electrico,726.91,26 +GBJ-693,Radio CD,314.20,8 +FQG-293,Rapiducha Premiun,2784.31,23 +XBD-314,Cocina a gas Fassina,1444.90,8 +QIL-029,Mini componente Shake-5,2990.55,16 +ZWF-661,Impresora Led,2731.61,1 +QHC-492,Terma Solucion,1907.23,17 +XLF-273,Centro de Lavado a Gas,2371.95,20 +XOA-735,Congeladora Vertical 392 Lts.,2708.07,12 +FLW-631,Radio Reloj Despertador,819.04,7 +ZEX-027,Tablet Xperia Z,3843.75,23 +QJO-060,Televisor LED FULL HD,2704.14,23 +GXF-122,Televisor Ultra HDTV,1110.16,15 +QFP-254,Calentador electrico instantaneo,180.65,25 +DUG-251,Cocina a gas FFG3047SL,1597.96,7 +III-576,Campana Extractora Venus Plus,1077.65,29 +IHG-413,Parlant Y pedestal PAM-83,317.70,13 +QQB-968,Refrigeradora 484 litros,1452.92,9 diff --git a/2023-2/L02/mitsuo/ReporteDeEntregaDePedisos.txt b/2023-2/L02/mitsuo/ReporteDeEntregaDePedisos.txt new file mode 100644 index 0000000..0b322ff --- /dev/null +++ b/2023-2/L02/mitsuo/ReporteDeEntregaDePedisos.txt @@ -0,0 +1,707 @@ + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 24/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 50375303 JXD-139 Terma Evolucion Soltu 6 586.02 3516.12 + 2) 13245501 AWB-345 Deshumedecedor DM-189H 1 800.37 800.37 + 3) 12663268 AHB-459 Reproductor DVD Portatil TV 7 3 685.50 2056.50 + 4) 36380447 OWN-701 Olla arrocera 5 220.82 1104.10 + 5) 88956889 TMN-884 Secadora de mano 1 310.65 310.65 + 6) 59162728 FEG-454 Sillon masajeador 4 1695.70 6782.80 + 7) 33713901 ZVA-180 Refrigeradora 322 litros 6 2903.13 17418.78 + 8) 86402303 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2718.48 + 9) 24995742 KCO-488 Ventilador de pared 4 679.60 2718.40 +10) 97403853 BCK-361 Tablets 10.1 5 1872.53 9362.65 +11) 79901434 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77A80L LA8 2 16504.47 33008.94 +12) 26290971 TYF-885 Videojuego TW 4 3 794.14 2382.42 +13) 26976877 AFL-718 Vinera 5 1664.97 8324.85 +14) 79464412 JXD-139 Terma Evolucion Soltu 4 586.02 2344.08 +15) 25171011 QRC-609 Camara de video EOS 3 1806.66 5419.98 +16) 89148118 JFC-432 DVD DVM-L79 5 307.67 1538.35 +17) 45828535 AVM-258 Cocina a gas Toscana 2 2831.23 5662.46 +18) 46462527 ISU-815 Audifonos 6 619.89 3719.34 +19) 95015539 CSZ-863 Video Filmadora 2 1713.57 3427.14 +20) 11602775 JJN-837 Lavadora Tecnologia Wobbie 2 1979.92 3959.84 +21) 15210391 OTW-288 Cavba de Vinos GE cap. 34 botellas 3 1119.18 3357.54 +22) 43877279 SSD-176 Refrigeradora Linea Gallery 4 567.71 2270.84 +23) 54761731 FVB-607 Cocina a gas Essenza BL 5 2953.07 14765.35 +24) 85949265 LDR-510 Mini componente ESX9 6 2701.87 16211.22 +25) 78078115 SSD-176 Refrigeradora Linea Gallery 1 567.71 567.71 +26) 35565959 VJI-529 Horno Empotrable Electrico 5 1102.67 5513.35 +27) 45783712 VZV-827 Refrigeradora Top Mount 1 1784.27 1784.27 +28) 50365593 VVS-017 Tablets MW 0731 3 2599.72 7799.16 +29) 87800799 JDC-028 Puntero Laser 5 30.48 152.40 +30) 73914283 OBI-353 Terma Milenium 4 2960.56 11842.24 +31) 45877001 RDT-761 Horno Microondas con dorador 5 904.95 4524.75 +32) 42928709 GLC-370 Video Proyector Power Lite 95 6 552.24 3313.44 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 188678.52 +Total perdido por falta de stock: 0.00 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 3/9/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 50375303 CRU-009 Lavavajilla 5 2655.78 SIN STOCK + 2) 26290971 PVZ-181 Ventilador circular 3 309.77 929.31 + 3) 73535476 FLJ-040 Parlantes portatiles SOUNDSHOOTER 4 3703.37 14813.48 + 4) 16552775 AWB-345 Deshumedecedor DM-189H 6 800.37 SIN STOCK + 5) 73535476 UWA-476 Autoradio MEX BT3150U 5 1191.39 5956.95 + 6) 95751208 UOD-420 Mini componente ESX6 4 828.94 3315.76 + 7) 15561764 GBJ-693 Radio CD 2 314.20 628.40 + 8) 43043986 ZEX-027 Tablet Xperia Z 1 3843.75 3843.75 + 9) 96258632 CRU-009 Lavavajilla 2 2655.78 SIN STOCK +10) 79901434 ZEX-027 Tablet Xperia Z 2 3843.75 7687.50 +11) 12663268 YYU-726 Reproductor DVD Portatil 4 767.82 3071.28 +12) 71378466 FVQ-662 Cocina a gas Pro 6300 INOX 2 1060.68 2121.36 +13) 26976877 VTV-269 Extractor de aire 4 854.48 3417.92 +14) 42798099 OQI-373 Cocina Empotrable Premio Plus 2 906.16 1812.32 +15) 23928045 TMN-884 Secadora de mano 2 310.65 621.30 +16) 69324480 UOD-420 Mini componente ESX6 3 828.94 2486.82 +17) 59407188 OWN-701 Olla arrocera 1 220.82 220.82 +18) 57263719 OTH-462 Lavadora Semi-Automatica 5 531.04 2655.20 +19) 37110873 FCN-617 Televisor Plasma 60 6 4121.05 SIN STOCK +20) 96659352 GBJ-693 Radio CD 3 314.20 942.60 +21) 52097922 UTN-601 Autoradio XAV-601 BT 2 562.51 1125.02 +22) 79901434 CSZ-863 Video Filmadora 5 1713.57 8567.85 +23) 89429489 UXG-019 Terma de acumulacion 1 934.91 934.91 +24) 52097922 XSD-310 Refrigeradora No frost 6 2259.93 13559.58 +25) 33713901 VVS-017 Tablets MW 0731 1 2599.72 2599.72 +26) 62566305 AVM-258 Cocina a gas Toscana 1 2831.23 2831.23 +27) 32904023 RBE-789 Televisor SMART TV 6 3303.07 19818.42 +28) 99842319 DUG-251 Cocina a gas FFG3047SL 2 1597.96 3195.92 +29) 40112594 FVQ-662 Cocina a gas Pro 6300 INOX 4 1060.68 4242.72 +30) 16151792 AQS-362 Teclado Inalambrico USB 1 233.05 233.05 +31) 52097922 XZG-521 Secadora Electrica FAQE7001LW 4 704.27 2817.08 +32) 54761731 OTS-581 Galaxy Note 8.0 5 2653.10 13265.50 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 165720.97 +Total perdido por falta de stock: 10113.78 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 27/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 22777006 YYK-309 Refrigeradora Door in Door 3 4079.44 12238.32 + 2) 63437380 PJG-338 Impresora Mutifuncional Inalambricar 2 1067.80 2135.60 + 3) 87813843 MLE-193 Cocina a gas Ingenious 4 2779.41 11117.64 + 4) 79140840 DFF-034 Grabadora de voz digital portatil con USB integrado 3 259.25 777.75 + 5) 73914283 OBI-353 Terma Milenium 1 2960.56 2960.56 + 6) 43053402 YOT-530 Deshumedecedor DM-190H 2 941.73 1883.46 + 7) 52097922 ISU-815 Audifonos 5 619.89 3099.45 + 8) 32565207 UXG-019 Terma de acumulacion 4 934.91 3739.64 + 9) 37110873 YZD-580 Mini componente ESX8 5 1582.29 SIN STOCK +10) 12663268 XSD-310 Refrigeradora No frost 6 2259.93 13559.58 +11) 11602775 YYK-309 Refrigeradora Door in Door 3 4079.44 12238.32 +12) 15561764 FYF-898 Proyector a color 2 1160.46 2320.92 +13) 60574154 III-576 Campana Extractora Venus Plus 6 1077.65 6465.90 +14) 73185299 QUU-384 Lavavajilla Blue Touch 3 2545.54 SIN STOCK +15) 43877279 SNY-500 Cocina a gas Praga Quarzo 4 3297.09 13188.36 +16) 40112594 KSO-608 Secadora Modelo Italica 6 914.17 5485.02 +17) 41036366 AQS-362 Teclado Inalambrico USB 2 233.05 466.10 +18) 25171011 CIM-038 Cocina Empotrable Petra 1 2544.64 2544.64 +19) 96659352 KQA-580 Cocina Empotrable Glassy Plus 6 2907.92 17447.52 +20) 79140840 HLR-109 Parlantes inalambricos 1 439.47 439.47 +21) 90237332 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16 +22) 89863424 SSE-115 Refrigeradora CoolStyle 311N Steel 4 3243.58 12974.32 +23) 86828079 YGV-332 Impresora Led Color 1 2517.66 2517.66 +24) 78757121 KJX-387 Ventilador de techo 4 613.19 2452.76 +25) 78078115 XOA-735 Congeladora Vertical 392 Lts. 2 2708.07 5416.14 +26) 67418025 EVN-510 Cocina a gas FFG3011LB 5 2672.30 13361.50 +27) 95751208 BRD-969 Centro de Lavado Electrico 4 2579.72 10318.88 +28) 26976877 KQQ-136 Impresora Laser EPSON 3 1139.56 3418.68 +29) 38913831 FLW-631 Radio Reloj Despertador 3 819.04 2457.12 +30) 57263719 OTH-462 Lavadora Semi-Automatica 2 531.04 1062.08 +31) 63437380 YEZ-591 Lavadora WA 5 1320.03 6600.15 +32) 91897732 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77A80L LA8 2 16504.47 33008.94 +33) 26233063 JFC-432 DVD DVM-L79 4 307.67 1230.68 +34) 55552996 SSD-176 Refrigeradora Linea Gallery 6 567.71 3406.26 +35) 22777006 XLF-273 Centro de Lavado a Gas 2 2371.95 4743.90 +36) 13245501 JCW-489 Conservadora Exibidora CMVE-250 5 2064.97 10324.85 +37) 26976877 YUQ-590 Refrigeradora CoolStyle 395N Steel 4 1979.07 7916.28 +38) 38637282 OFS-384 Parlantes Bluetooth 1 805.22 805.22 +39) 84165595 JFC-432 DVD DVM-L79 3 307.67 923.01 +40) 45877001 GBJ-693 Radio CD 5 314.20 SIN STOCK +41) 66409237 CRU-009 Lavavajilla 4 2655.78 SIN STOCK +42) 78922174 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2718.48 +43) 54716824 CRU-009 Lavavajilla 6 2655.78 SIN STOCK +44) 17913944 XLF-273 Centro de Lavado a Gas 4 2371.95 9487.80 +45) 57690875 XTE-383 Rack Fijo 32/60 6 261.01 1566.06 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 249725.18 +Total perdido por falta de stock: 43676.87 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 28/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 42157219 OTS-581 Galaxy Note 8.0 5 2653.10 13265.50 + 2) 77484838 UWA-476 Autoradio MEX BT3150U 1 1191.39 1191.39 + 3) 79464412 CJE-310 Mini componente GPX33 5 3643.39 18216.95 + 4) 76388967 SJQ-827 Reproductor Multimedia Touch Screen 5 1719.56 8597.80 + 5) 78922174 TKM-141 Cocina a gas Marsella 5 402.24 2011.20 + 6) 94080926 NMV-644 Lavadora Automatica 5 3272.48 SIN STOCK + 7) 57263719 BWD-036 Cocina Empotrable Klimatica 3 1086.34 3259.02 + 8) 17972674 ZWF-661 Impresora Led 1 2731.61 SIN STOCK + 9) 89148118 XLF-273 Centro de Lavado a Gas 5 2371.95 11859.75 +10) 42928709 NSM-283 Cocina a gas FFG3053SL 5 936.81 4684.05 +11) 57690875 CIM-038 Cocina Empotrable Petra 3 2544.64 7633.92 +12) 80048864 BCK-361 Tablets 10.1 3 1872.53 5617.59 +13) 59407188 BIT-434 Campana Extractora modelo Glass 6 375.09 2250.54 +14) 32565207 FVQ-662 Cocina a gas Pro 6300 INOX 5 1060.68 5303.40 +15) 24995742 YMU-875 Cocina a gas Plermo Quarzo 3 3232.10 9696.30 +16) 89298238 QFP-254 Calentador electrico instantaneo 2 180.65 361.30 +17) 44679500 AWB-345 Deshumedecedor DM-189H 1 800.37 SIN STOCK +18) 35584593 AVM-258 Cocina a gas Toscana 4 2831.23 11324.92 +19) 85871751 MYC-756 Cocina a gas Leganza INOX 2 1506.80 3013.60 +20) 43043986 QFP-254 Calentador electrico instantaneo 5 180.65 903.25 +21) 71463316 UWA-476 Autoradio MEX BT3150U 3 1191.39 3574.17 +22) 71378466 ARS-231 Audifonos Stereos 6 327.62 1965.72 +23) 79475585 KQQ-136 Impresora Laser EPSON 6 1139.56 6837.36 +24) 32904023 KJX-387 Ventilador de techo 3 613.19 1839.57 +25) 42157219 KCO-488 Ventilador de pared 2 679.60 1359.20 +26) 71463316 BCN-855 Cocina a gas Bahia Can 4 4015.92 16063.68 +27) 66409237 UXG-019 Terma de acumulacion 4 934.91 3739.64 +28) 23928045 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77A80L LA8 3 16504.47 49513.41 +29) 26233063 KSO-608 Secadora Modelo Italica 3 914.17 2742.51 +30) 86241107 CIM-038 Cocina Empotrable Petra 2 2544.64 5089.28 +31) 35565959 DFJ-952 Cocina a gas Prestige 60 INOX 2 3342.77 6685.54 +32) 73786035 DEN-125 Rack Fijo 26/32 4 562.46 2249.84 +33) 45828535 TZY-323 Terma a gas 6 2341.01 14046.06 +34) 26976877 SSE-115 Refrigeradora CoolStyle 311N Steel 4 3243.58 12974.32 +35) 80048864 PPX-620 Aire acondicionado tipo split 1 2873.42 2873.42 +36) 60574154 KDA-627 Cocina a gas Ijasmin 5 1424.46 7122.30 +37) 40112594 BCK-361 Tablets 10.1 2 1872.53 SIN STOCK +38) 79372768 QVJ-982 Horno Microondas 0.7 p3 6 1352.76 8116.56 +39) 43877279 QUU-384 Lavavajilla Blue Touch 5 2545.54 SIN STOCK +40) 69975105 HFM-021 Horno Electrico 6 726.91 4361.46 +41) 43053402 FVQ-662 Cocina a gas Pro 6300 INOX 6 1060.68 SIN STOCK +42) 89863424 OTH-462 Lavadora Semi-Automatica 6 531.04 3186.24 +43) 95161027 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16 +44) 62324793 OPJ-039 Secadora de Ropa 2 2765.64 5531.28 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 289062.21 +Total perdido por falta de stock: 23637.21 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 4/9/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 33397650 IHG-413 Parlant Y pedestal PAM-83 3 317.70 953.10 + 2) 69324480 JCW-489 Conservadora Exibidora CMVE-250 5 2064.97 10324.85 + 3) 50375303 KQA-580 Cocina Empotrable Glassy Plus 5 2907.92 14539.60 + 4) 32565207 IDO-503 Laptop GamerVictus de 15.6 6 3935.17 23611.02 + 5) 63437380 III-576 Campana Extractora Venus Plus 5 1077.65 5388.25 + 6) 91897732 TMN-884 Secadora de mano 2 310.65 621.30 + 7) 31611146 YOT-530 Deshumedecedor DM-190H 4 941.73 3766.92 + 8) 85949265 JFC-432 DVD DVM-L79 4 307.67 1230.68 + 9) 12663268 RAH-420 Cocina a gas Pro 6550 INOX 3 157.01 471.03 +10) 88956889 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1979.07 3958.14 +11) 38913831 BCN-855 Cocina a gas Bahia Can 3 4015.92 12047.76 +12) 44229880 JXD-139 Terma Evolucion Soltu 4 586.02 2344.08 +13) 42928709 XLF-273 Centro de Lavado a Gas 4 2371.95 9487.80 +14) 88956889 UWA-476 Autoradio MEX BT3150U 3 1191.39 3574.17 +15) 66409237 BRD-969 Centro de Lavado Electrico 3 2579.72 7739.16 +16) 42928709 QFP-254 Calentador electrico instantaneo 5 180.65 903.25 +17) 26233063 UWA-476 Autoradio MEX BT3150U 1 1191.39 1191.39 +18) 35565959 QRC-609 Camara de video EOS 5 1806.66 9033.30 +19) 50375303 YJD-279 Cocina a gas Florencia 5 1028.43 5142.15 +20) 27912250 QFR-958 Cocina a gas Bavaro 3 1607.46 4822.38 +21) 88995291 MTF-868 Impresora Monocromatica WorkForce M205 3 971.59 2914.77 +22) 69975105 FQG-293 Rapiducha Premiun 5 2784.31 13921.55 +23) 76388967 PFD-286 Refrigeradora cap. 415 litros 6 2776.02 16656.12 +24) 77191257 ZWF-661 Impresora Led 4 2731.61 SIN STOCK +25) 91897732 PFD-286 Refrigeradora cap. 415 litros 2 2776.02 SIN STOCK +26) 36380447 HLR-109 Parlantes inalambricos 2 439.47 878.94 +27) 50375303 VXS-438 Mouse Blue Tooth 4 60.11 240.44 +28) 25171011 DFJ-952 Cocina a gas Prestige 60 INOX 4 3342.77 13371.08 +29) 48184351 TXM-139 Televisor LED FULL HD 3D 1 1092.95 1092.95 +30) 45783712 YMU-875 Cocina a gas Plermo Quarzo 4 3232.10 12928.40 +31) 94080926 SPR-580 Dispensador de Agua 5 404.35 2021.75 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 190728.37 +Total perdido por falta de stock: 10926.44 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 30/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 97403853 KQQ-136 Impresora Laser EPSON 6 1139.56 6837.36 + 2) 50365593 AFL-718 Vinera 5 1664.97 8324.85 + 3) 83505958 TYF-885 Videojuego TW 4 5 794.14 SIN STOCK + 4) 63437380 AWB-345 Deshumedecedor DM-189H 4 800.37 SIN STOCK + 5) 19829266 TXM-139 Televisor LED FULL HD 3D 3 1092.95 3278.85 + 6) 32821689 ONB-903 Reproductor BLU-RAY 3D 3 653.67 1961.01 + 7) 96258632 QHC-492 Terma Solucion 2 1907.23 3814.46 + 8) 69975105 WZD-331 Refrigeradora ECOTT 465 IX 6 1213.79 7282.74 + 9) 79140840 OTH-462 Lavadora Semi-Automatica 1 531.04 531.04 +10) 87800799 GBD-525 Refrigeradora Puertas Mágicas 6 2700.95 16205.70 +11) 62566305 GXF-122 Televisor Ultra HDTV 5 1110.16 5550.80 +12) 42928709 QIL-029 Mini componente Shake-5 4 2990.55 11962.20 +13) 23928045 TKM-141 Cocina a gas Marsella 5 402.24 2011.20 +14) 32565207 TKM-141 Cocina a gas Marsella 4 402.24 1608.96 +15) 26290971 GKG-558 Horno Microondas MS2042D 3 1674.24 5022.72 +16) 86402303 RBE-789 Televisor SMART TV 6 3303.07 19818.42 +17) 48184351 KQA-580 Cocina Empotrable Glassy Plus 2 2907.92 5815.84 +18) 85949265 VRR-793 Rack Giratorio 32/60 5 241.71 1208.55 +19) 15210391 DON-719 Secadora de Cabello SG-3035 2 360.69 721.38 +20) 89429489 VCL-867 Cocina a gas Rubi 2 6 699.07 4194.42 +21) 35565959 JXD-139 Terma Evolucion Soltu 5 586.02 2930.10 +22) 96659352 KQQ-136 Impresora Laser EPSON 3 1139.56 SIN STOCK +23) 62324793 XBD-314 Cocina a gas Fassina 5 1444.90 7224.50 +24) 89863424 QRC-609 Camara de video EOS 3 1806.66 5419.98 +25) 97403853 GBJ-693 Radio CD 4 314.20 SIN STOCK +26) 73185299 AVM-258 Cocina a gas Toscana 3 2831.23 8493.69 +27) 15210391 AQS-362 Teclado Inalambrico USB 2 233.05 466.10 +28) 45877001 KBY-991 Home Theater E4100 6 1101.08 6606.48 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 137291.35 +Total perdido por falta de stock: 11847.66 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 22/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 78757121 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2718.48 + 2) 71984468 PQH-935 Rack Giratorio 26/32 2 94.45 188.90 + 3) 43488351 XLF-273 Centro de Lavado a Gas 5 2371.95 SIN STOCK + 4) 15210391 RSE-049 Radio CD/DVD - TV 5 4037.51 20187.55 + 5) 78078115 XZR-640 Lavadora-Secadora FWD 5 2390.58 11952.90 + 6) 77484838 BTO-226 Friobar 4 863.19 3452.76 + 7) 25171011 OPT-996 Mini componente GPX88 6 1367.48 8204.88 + 8) 95161027 VJI-529 Horno Empotrable Electrico 2 1102.67 2205.34 + 9) 27912250 LWG-915 Cocina a gas Murano 4 1101.47 4405.88 +10) 15561764 JYQ-045 Horno Microondas 1.2 p3 6 267.15 1602.90 +11) 78757121 ZXK-295 Cocina Empotrable Electrica 4 3679.43 14717.72 +12) 76388967 RSE-049 Radio CD/DVD - TV 6 4037.51 24225.06 +13) 37110873 GXF-122 Televisor Ultra HDTV 2 1110.16 2220.32 +14) 16151792 WZD-331 Refrigeradora ECOTT 465 IX 3 1213.79 SIN STOCK +15) 73535476 CIM-038 Cocina Empotrable Petra 3 2544.64 7633.92 +16) 89298238 QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2682.73 8048.19 +17) 78078115 DFF-034 Grabadora de voz digital portatil con USB integrado 2 259.25 518.50 +18) 77484838 YUQ-590 Refrigeradora CoolStyle 395N Steel 6 1979.07 11874.42 +19) 35584593 KCO-488 Ventilador de pared 1 679.60 679.60 +20) 78078115 TMJ-043 Lavadora EcoBubble 3 2400.79 7202.37 +21) 38913831 YZD-580 Mini componente ESX8 1 1582.29 SIN STOCK +22) 87800799 QRC-609 Camara de video EOS 1 1806.66 1806.66 +23) 66409237 ICX-503 Cocina a gas Roma 5 1221.02 6105.10 +24) 86241107 HFC-845 Televisor Serie LED R555A 3 3736.75 11210.25 +25) 36008913 HFC-845 Televisor Serie LED R555A 6 3736.75 22420.50 +26) 64394265 YYK-309 Refrigeradora Door in Door 6 4079.44 24476.64 +27) 32821689 ISU-815 Audifonos 1 619.89 619.89 +28) 26290971 TZY-323 Terma a gas 5 2341.01 11705.05 +29) 77191257 AVM-258 Cocina a gas Toscana 6 2831.23 16987.38 +30) 52097922 MMA-577 Congeladora Horizontal 252 Lts. 2 1780.30 3560.60 +31) 84165595 QHC-492 Terma Solucion 4 1907.23 7628.92 +32) 93845419 NSR-955 Cocina a gas Blogna 2 2591.44 5182.88 +33) 27912250 LWG-915 Cocina a gas Murano 1 1101.47 1101.47 +34) 20864087 SPR-580 Dispensador de Agua 1 404.35 404.35 +35) 94080926 OTW-288 Cavba de Vinos GE cap. 34 botellas 5 1119.18 5595.90 +36) 80048864 BWD-036 Cocina Empotrable Klimatica 3 1086.34 SIN STOCK +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 262705.03 +Total perdido por falta de stock: 8482.68 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 26/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 27912250 ICX-503 Cocina a gas Roma 1 1221.02 1221.02 + 2) 86828079 MQR-442 Reloj Digital RMM-29 3 271.66 814.98 + 3) 49087435 BCK-361 Tablets 10.1 3 1872.53 SIN STOCK + 4) 78922174 AFL-718 Vinera 5 1664.97 8324.85 + 5) 11602775 JJN-837 Lavadora Tecnologia Wobbie 1 1979.92 1979.92 + 6) 79475585 BWD-036 Cocina Empotrable Klimatica 5 1086.34 SIN STOCK + 7) 17972674 UWA-476 Autoradio MEX BT3150U 4 1191.39 4765.56 + 8) 71378466 BIT-434 Campana Extractora modelo Glass 4 375.09 SIN STOCK + 9) 83505958 MQR-442 Reloj Digital RMM-29 1 271.66 271.66 +10) 77484838 AFL-718 Vinera 1 1664.97 1664.97 +11) 95161027 VVS-017 Tablets MW 0731 5 2599.72 12998.60 +12) 54761731 DEV-433 Parlantes portatiles SHOQBOX 3 2698.74 8096.22 +13) 45828535 QJO-060 Televisor LED FULL HD 6 2704.14 16224.84 +14) 83236386 OPT-996 Mini componente GPX88 2 1367.48 2734.96 +15) 42157219 III-576 Campana Extractora Venus Plus 6 1077.65 6465.90 +16) 38637282 FLJ-040 Parlantes portatiles SOUNDSHOOTER 6 3703.37 22220.22 +17) 59407188 RDT-761 Horno Microondas con dorador 5 904.95 4524.75 +18) 78757121 GXF-122 Televisor Ultra HDTV 1 1110.16 1110.16 +19) 90365520 EUZ-452 Impresora Mutifuncional Led Color 6 3623.88 21743.28 +20) 13245501 HFC-845 Televisor Serie LED R555A 6 3736.75 22420.50 +21) 78757121 ARS-231 Audifonos Stereos 4 327.62 1310.48 +22) 24995742 BWD-036 Cocina Empotrable Klimatica 1 1086.34 SIN STOCK +23) 86402303 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2718.48 +24) 57690875 XLF-273 Centro de Lavado a Gas 4 2371.95 SIN STOCK +25) 94080926 CIM-038 Cocina Empotrable Petra 2 2544.64 5089.28 +26) 54761731 ZVA-180 Refrigeradora 322 litros 4 2903.13 11612.52 +27) 42157219 KWP-672 Televisor UHD TV 6 1625.30 9751.80 +28) 54761731 VZV-827 Refrigeradora Top Mount 1 1784.27 SIN STOCK +29) 29337157 WZD-331 Refrigeradora ECOTT 465 IX 4 1213.79 SIN STOCK +30) 73535476 KJX-387 Ventilador de techo 4 613.19 SIN STOCK +31) 77191257 TZY-323 Terma a gas 3 2341.01 7023.03 +32) 27912250 FLJ-040 Parlantes portatiles SOUNDSHOOTER 3 3703.37 11110.11 +33) 32904023 KQQ-136 Impresora Laser EPSON 1 1139.56 SIN STOCK +34) 99842319 ZAF-449 Tablet Cardle 1 816.43 816.43 +35) 57263719 ZWF-661 Impresora Led 5 2731.61 SIN STOCK +36) 81114108 VCL-867 Cocina a gas Rubi 2 1 699.07 699.07 +37) 31611146 XSD-310 Refrigeradora No frost 1 2259.93 2259.93 +38) 40348917 VRR-793 Rack Giratorio 32/60 3 241.71 725.13 +39) 79901434 TXM-139 Televisor LED FULL HD 3D 2 1092.95 SIN STOCK +40) 26976877 XZG-521 Secadora Electrica FAQE7001LW 3 704.27 2112.81 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 196096.09 +Total perdido por falta de stock: 45914.86 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 29/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 98140264 DFF-034 Grabadora de voz digital portatil con USB integrado 2 259.25 518.50 + 2) 25171011 VCL-867 Cocina a gas Rubi 2 3 699.07 SIN STOCK + 3) 76388967 EBI-299 Cocina a gas Fridare 5 2287.57 11437.85 + 4) 16552775 CNN-411 Congeladora Side by Side 5 2296.29 11481.45 + 5) 46462527 KWP-672 Televisor UHD TV 3 1625.30 4875.90 + 6) 79464412 NSM-283 Cocina a gas FFG3053SL 2 936.81 1873.62 + 7) 52097922 OWN-701 Olla arrocera 2 220.82 441.64 + 8) 71463316 KCO-488 Ventilador de pared 5 679.60 3398.00 + 9) 77642521 DFJ-952 Cocina a gas Prestige 60 INOX 5 3342.77 16713.85 +10) 53166028 QHC-492 Terma Solucion 1 1907.23 1907.23 +11) 45877001 PJG-338 Impresora Mutifuncional Inalambricar 2 1067.80 2135.60 +12) 77484838 UDR-957 Refrigeradora ECOTT 423 IXL 3 861.70 2585.10 +13) 71463316 EBI-299 Cocina a gas Fridare 6 2287.57 13725.42 +14) 88956889 HFM-021 Horno Electrico 6 726.91 4361.46 +15) 29847168 BCK-361 Tablets 10.1 1 1872.53 SIN STOCK +16) 55552996 SJD-818 Refrigeradora CoolStyle 281A Steel 1 3387.75 3387.75 +17) 87800799 WZD-331 Refrigeradora ECOTT 465 IX 2 1213.79 SIN STOCK +18) 43053402 VRR-793 Rack Giratorio 32/60 2 241.71 483.42 +19) 16151792 AQS-362 Teclado Inalambrico USB 1 233.05 233.05 +20) 81114108 RBE-789 Televisor SMART TV 2 3303.07 6606.14 +21) 62324793 FQG-293 Rapiducha Premiun 1 2784.31 2784.31 +22) 87800799 BTO-226 Friobar 3 863.19 2589.57 +23) 44229880 SNY-500 Cocina a gas Praga Quarzo 3 3297.09 9891.27 +24) 20864087 YUQ-590 Refrigeradora CoolStyle 395N Steel 5 1979.07 9895.35 +25) 31193794 BXY-119 Cocina Empotrable Klimatica 5 2716.11 13580.55 +26) 86241107 FEG-454 Sillon masajeador 2 1695.70 3391.40 +27) 95161027 FQG-293 Rapiducha Premiun 4 2784.31 11137.24 +28) 69639726 DON-719 Secadora de Cabello SG-3035 1 360.69 360.69 +29) 53166028 ONB-903 Reproductor BLU-RAY 3D 3 653.67 1961.01 +30) 45828535 YMU-875 Cocina a gas Plermo Quarzo 5 3232.10 SIN STOCK +31) 71378466 XSD-310 Refrigeradora No frost 3 2259.93 6779.79 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 148537.16 +Total perdido por falta de stock: 22557.82 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 25/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 57263719 TZY-323 Terma a gas 6 2341.01 14046.06 + 2) 87800799 KWP-672 Televisor UHD TV 2 1625.30 3250.60 + 3) 35565959 CIM-038 Cocina Empotrable Petra 4 2544.64 10178.56 + 4) 77642521 QUU-384 Lavavajilla Blue Touch 5 2545.54 SIN STOCK + 5) 79901434 AHB-459 Reproductor DVD Portatil TV 7 3 685.50 2056.50 + 6) 67418025 QUU-384 Lavavajilla Blue Touch 1 2545.54 SIN STOCK + 7) 79140840 TYF-885 Videojuego TW 4 2 794.14 SIN STOCK + 8) 11602775 XLF-273 Centro de Lavado a Gas 4 2371.95 SIN STOCK + 9) 62566305 DIQ-718 Horno Microondas de Conveccion Cello 4 390.80 SIN STOCK +10) 40348917 SNY-500 Cocina a gas Praga Quarzo 4 3297.09 13188.36 +11) 83236386 MTF-868 Impresora Monocromatica WorkForce M205 2 971.59 1943.18 +12) 52097922 GBD-525 Refrigeradora Puertas Mágicas 5 2700.95 13504.75 +13) 16151792 CNQ-172 Congeladora Horizontal 364 Lts. 1 3689.62 3689.62 +14) 32821689 MMA-577 Congeladora Horizontal 252 Lts. 5 1780.30 8901.50 +15) 26976877 JXD-139 Terma Evolucion Soltu 2 586.02 1172.04 +16) 73535476 LDR-510 Mini componente ESX9 2 2701.87 5403.74 +17) 96258632 EBI-299 Cocina a gas Fridare 5 2287.57 SIN STOCK +18) 62324793 YJD-279 Cocina a gas Florencia 5 1028.43 5142.15 +19) 13245501 ZWF-661 Impresora Led 1 2731.61 SIN STOCK +20) 87800799 ICX-503 Cocina a gas Roma 2 1221.02 2442.04 +21) 73786035 AQS-362 Teclado Inalambrico USB 1 233.05 SIN STOCK +22) 58187172 KBY-991 Home Theater E4100 6 1101.08 6606.48 +23) 71378466 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16 +24) 88995291 HLR-109 Parlantes inalambricos 2 439.47 878.94 +25) 95751208 BWD-036 Cocina Empotrable Klimatica 3 1086.34 SIN STOCK +26) 87800799 EUZ-452 Impresora Mutifuncional Led Color 2 3623.88 7247.76 +27) 57263719 YOT-530 Deshumedecedor DM-190H 5 941.73 4708.65 +28) 93845419 AWB-345 Deshumedecedor DM-189H 5 800.37 SIN STOCK +29) 19829266 UXG-019 Terma de acumulacion 2 934.91 1869.82 +30) 93160528 DUG-251 Cocina a gas FFG3047SL 2 1597.96 3195.92 +31) 50375303 SJQ-827 Reproductor Multimedia Touch Screen 2 1719.56 3439.12 +32) 42798099 RDT-761 Horno Microondas con dorador 6 904.95 5429.70 +33) 49087435 AFL-718 Vinera 1 1664.97 SIN STOCK +34) 45783712 SNY-500 Cocina a gas Praga Quarzo 5 3297.09 SIN STOCK +35) 77484838 YGV-332 Impresora Led Color 3 2517.66 7552.98 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 128652.65 +Total perdido por falta de stock: 65828.30 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 31/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 35584593 SSD-176 Refrigeradora Linea Gallery 4 567.71 2270.84 + 2) 73185299 OTH-462 Lavadora Semi-Automatica 3 531.04 1593.12 + 3) 45783712 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1979.07 SIN STOCK + 4) 62324793 LDR-510 Mini componente ESX9 1 2701.87 2701.87 + 5) 37110873 QUU-384 Lavavajilla Blue Touch 4 2545.54 SIN STOCK + 6) 71463316 AWT-354 Galaxy Gear 4 3409.22 13636.88 + 7) 46462527 LWG-915 Cocina a gas Murano 6 1101.47 6608.82 + 8) 87800799 VRR-793 Rack Giratorio 32/60 2 241.71 483.42 + 9) 25171011 AWB-345 Deshumedecedor DM-189H 6 800.37 SIN STOCK +10) 22777006 FCN-617 Televisor Plasma 60 1 4121.05 SIN STOCK +11) 90237332 QFP-254 Calentador electrico instantaneo 3 180.65 541.95 +12) 48467976 JDQ-505 Lavadora Modelo Aquamatic 5 1572.31 7861.55 +13) 45828535 XSD-310 Refrigeradora No frost 4 2259.93 SIN STOCK +14) 90365520 KBY-991 Home Theater E4100 6 1101.08 6606.48 +15) 54716824 UDR-957 Refrigeradora ECOTT 423 IXL 1 861.70 861.70 +16) 37110873 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 4 1095.67 4382.68 +17) 54716824 ZEX-027 Tablet Xperia Z 6 3843.75 23062.50 +18) 81114108 DFF-034 Grabadora de voz digital portatil con USB integrado 5 259.25 1296.25 +19) 64394265 OFS-384 Parlantes Bluetooth 5 805.22 4026.10 +20) 42798099 CNN-411 Congeladora Side by Side 6 2296.29 13777.74 +21) 13245501 QIL-029 Mini componente Shake-5 2 2990.55 5981.10 +22) 86402303 HFM-021 Horno Electrico 6 726.91 4361.46 +23) 89148118 EBI-299 Cocina a gas Fridare 6 2287.57 SIN STOCK +24) 87813843 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16 +25) 93845419 QIL-029 Mini componente Shake-5 6 2990.55 17943.30 +26) 67418025 FEG-454 Sillon masajeador 2 1695.70 SIN STOCK +27) 69975105 TMJ-043 Lavadora EcoBubble 6 2400.79 14404.74 +28) 97403853 YJD-279 Cocina a gas Florencia 3 1028.43 3085.29 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 143743.49 +Total perdido por falta de stock: 41870.57 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 5/9/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 60574154 BWD-036 Cocina Empotrable Klimatica 2 1086.34 SIN STOCK + 2) 13245501 XOA-735 Congeladora Vertical 392 Lts. 5 2708.07 13540.35 + 3) 46462527 KCO-488 Ventilador de pared 4 679.60 2718.40 + 4) 93845419 CIM-038 Cocina Empotrable Petra 5 2544.64 SIN STOCK + 5) 63437380 KQA-580 Cocina Empotrable Glassy Plus 2 2907.92 5815.84 + 6) 54716824 SPR-580 Dispensador de Agua 3 404.35 1213.05 + 7) 55552996 UXG-019 Terma de acumulacion 6 934.91 SIN STOCK + 8) 42798099 AQS-362 Teclado Inalambrico USB 1 233.05 SIN STOCK + 9) 80048864 RDT-761 Horno Microondas con dorador 5 904.95 SIN STOCK +10) 43877279 TYF-885 Videojuego TW 4 5 794.14 SIN STOCK +11) 98589725 VRR-793 Rack Giratorio 32/60 1 241.71 241.71 +12) 22280452 XSD-310 Refrigeradora No frost 2 2259.93 SIN STOCK +13) 16151792 TZY-323 Terma a gas 3 2341.01 7023.03 +14) 89298238 JXD-139 Terma Evolucion Soltu 3 586.02 1758.06 +15) 12663268 BMJ-772 Refrigeradora Side by Side 1 936.32 936.32 +16) 64394265 YUQ-590 Refrigeradora CoolStyle 395N Steel 1 1979.07 SIN STOCK +17) 76388967 DOV-560 Impresora Laser Mutifuncion Monocromatica 2 1203.14 2406.28 +18) 69324480 VJI-529 Horno Empotrable Electrico 1 1102.67 1102.67 +19) 73914283 BRD-969 Centro de Lavado Electrico 3 2579.72 7739.16 +20) 62566305 CNQ-172 Congeladora Horizontal 364 Lts. 3 3689.62 11068.86 +21) 13245501 KJX-387 Ventilador de techo 5 613.19 SIN STOCK +22) 89298238 ICX-503 Cocina a gas Roma 3 1221.02 3663.06 +23) 67418025 YYU-726 Reproductor DVD Portatil 6 767.82 4606.92 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 68358.46 +Total perdido por falta de stock: 34273.97 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 23/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 31193794 JDC-028 Puntero Laser 1 30.48 30.48 + 2) 89148118 TKM-141 Cocina a gas Marsella 6 402.24 2413.44 + 3) 29337157 QHC-492 Terma Solucion 6 1907.23 11443.38 + 4) 90237332 PFD-286 Refrigeradora cap. 415 litros 4 2776.02 SIN STOCK + 5) 89298238 PFD-286 Refrigeradora cap. 415 litros 2 2776.02 SIN STOCK + 6) 55552996 AQS-362 Teclado Inalambrico USB 1 233.05 SIN STOCK + 7) 81114108 BCN-855 Cocina a gas Bahia Can 4 4015.92 16063.68 + 8) 22280452 VRR-793 Rack Giratorio 32/60 5 241.71 1208.55 + 9) 69324480 VXS-438 Mouse Blue Tooth 3 60.11 180.33 +10) 79464412 MTF-868 Impresora Monocromatica WorkForce M205 6 971.59 5829.54 +11) 93160528 BRD-969 Centro de Lavado Electrico 5 2579.72 12898.60 +12) 43488351 QTK-083 Congeladora Conservador Vertical 476 Lts. 6 2682.73 16096.38 +13) 93160528 QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2682.73 8048.19 +14) 76388967 CNQ-172 Congeladora Horizontal 364 Lts. 6 3689.62 22137.72 +15) 89298238 YOT-530 Deshumedecedor DM-190H 1 941.73 941.73 +16) 89429489 QUU-384 Lavavajilla Blue Touch 1 2545.54 SIN STOCK +17) 50365593 ZVA-180 Refrigeradora 322 litros 6 2903.13 SIN STOCK +18) 83236386 OFS-384 Parlantes Bluetooth 1 805.22 805.22 +19) 81114108 OFS-384 Parlantes Bluetooth 3 805.22 SIN STOCK +20) 23928045 LWG-915 Cocina a gas Murano 2 1101.47 2202.94 +21) 73185299 QFP-254 Calentador electrico instantaneo 5 180.65 903.25 +22) 78922174 XBD-314 Cocina a gas Fassina 2 1444.90 2889.80 +23) 87813843 LDR-510 Mini componente ESX9 6 2701.87 16211.22 +24) 78078115 PJG-338 Impresora Mutifuncional Inalambricar 2 1067.80 2135.60 +25) 79372768 SAM-013 Cocina a gas FFG3047SL 1 2275.18 SIN STOCK +26) 64394265 OTW-288 Cavba de Vinos GE cap. 34 botellas 5 1119.18 5595.90 +27) 77642521 YYU-726 Reproductor DVD Portatil 2 767.82 1535.64 +28) 12663268 QFP-254 Calentador electrico instantaneo 5 180.65 SIN STOCK +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 132750.02 +Total perdido por falta de stock: 39269.15 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 2/9/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 86828079 QIL-029 Mini componente Shake-5 5 2990.55 SIN STOCK + 2) 79901434 OBI-353 Terma Milenium 6 2960.56 17763.36 + 3) 20864087 BXY-119 Cocina Empotrable Klimatica 4 2716.11 10864.44 + 4) 37110873 SSD-176 Refrigeradora Linea Gallery 1 567.71 567.71 + 5) 41036366 SJD-818 Refrigeradora CoolStyle 281A Steel 4 3387.75 13551.00 + 6) 98140264 BRD-969 Centro de Lavado Electrico 1 2579.72 2579.72 + 7) 84165595 RDT-761 Horno Microondas con dorador 6 904.95 SIN STOCK + 8) 50365593 JDC-028 Puntero Laser 6 30.48 182.88 + 9) 15210391 TZY-323 Terma a gas 3 2341.01 7023.03 +10) 95161027 III-576 Campana Extractora Venus Plus 5 1077.65 5388.25 +11) 20864087 JFC-432 DVD DVM-L79 1 307.67 307.67 +12) 50375303 AFL-718 Vinera 1 1664.97 SIN STOCK +13) 42928709 OQI-373 Cocina Empotrable Premio Plus 5 906.16 SIN STOCK +14) 43053402 MMA-577 Congeladora Horizontal 252 Lts. 6 1780.30 10681.80 +15) 78922174 EJW-346 Campana Extractora 6 359.70 2158.20 +16) 98140264 CJE-310 Mini componente GPX33 3 3643.39 10930.17 +17) 94080926 TXM-139 Televisor LED FULL HD 3D 5 1092.95 SIN STOCK +18) 20864087 JDQ-505 Lavadora Modelo Aquamatic 6 1572.31 9433.86 +19) 66409237 DFF-034 Grabadora de voz digital portatil con USB integrado 4 259.25 1037.00 +20) 66409237 AWT-354 Galaxy Gear 6 3409.22 20455.32 +21) 88956889 MYC-756 Cocina a gas Leganza INOX 4 1506.80 6027.20 +22) 24995742 DON-719 Secadora de Cabello SG-3035 3 360.69 1082.07 +23) 88956889 UWA-476 Autoradio MEX BT3150U 6 1191.39 7148.34 +24) 32904023 QFP-254 Calentador electrico instantaneo 4 180.65 SIN STOCK +25) 89298238 YOT-530 Deshumedecedor DM-190H 4 941.73 SIN STOCK +26) 79372768 GLC-370 Video Proyector Power Lite 95 4 552.24 2208.96 +27) 32821689 MTF-868 Impresora Monocromatica WorkForce M205 5 971.59 SIN STOCK +28) 59407188 LYZ-614 Impresore Mutifuncional Expression XP-211 3 3510.84 10532.52 +29) 55552996 QTK-083 Congeladora Conservador Vertical 476 Lts. 1 2682.73 2682.73 +30) 50365593 TMN-884 Secadora de mano 6 310.65 SIN STOCK +31) 15210391 VXS-438 Mouse Blue Tooth 4 60.11 240.44 +32) 33397650 VJI-529 Horno Empotrable Electrico 6 1102.67 6616.02 +33) 13245501 BXY-119 Cocina Empotrable Klimatica 5 2716.11 SIN STOCK +34) 69324480 DIQ-718 Horno Microondas de Conveccion Cello 1 390.80 SIN STOCK +35) 78078115 DFJ-952 Cocina a gas Prestige 60 INOX 5 3342.77 16713.85 +36) 29337157 HFM-021 Horno Electrico 4 726.91 2907.64 +37) 77191257 KWP-672 Televisor UHD TV 2 1625.30 3250.60 +38) 89863424 FVB-607 Cocina a gas Essenza BL 1 2953.07 2953.07 +39) 79420973 GXF-122 Televisor Ultra HDTV 3 1110.16 3330.48 +40) 33713901 UWA-476 Autoradio MEX BT3150U 2 1191.39 2382.78 +41) 90237332 TKM-141 Cocina a gas Marsella 3 402.24 1206.72 +42) 89429489 BXY-119 Cocina Empotrable Klimatica 3 2716.11 SIN STOCK +43) 90365520 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 5 1095.67 5478.35 +44) 79372768 EUZ-452 Impresora Mutifuncional Led Color 5 3623.88 SIN STOCK +45) 53166028 TXM-139 Televisor LED FULL HD 3D 3 1092.95 SIN STOCK +46) 45783712 SSD-176 Refrigeradora Linea Gallery 6 567.71 3406.26 +47) 57263719 DOV-560 Impresora Laser Mutifuncion Monocromatica 4 1203.14 SIN STOCK +48) 40348917 DFJ-952 Cocina a gas Prestige 60 INOX 2 3342.77 SIN STOCK +49) 79140840 QRC-609 Camara de video EOS 5 1806.66 SIN STOCK +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 206811.28 +Total perdido por falta de stock: 91584.83 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 21/8/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 57690875 CSZ-863 Video Filmadora 5 1713.57 8567.85 + 2) 11602775 CIM-038 Cocina Empotrable Petra 4 2544.64 SIN STOCK + 3) 29337157 ZEX-027 Tablet Xperia Z 3 3843.75 11531.25 + 4) 49087435 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 2 1095.67 2191.34 + 5) 62566305 TYF-885 Videojuego TW 4 4 794.14 SIN STOCK + 6) 45877001 VVS-017 Tablets MW 0731 4 2599.72 10398.88 + 7) 83505958 EJW-346 Campana Extractora 3 359.70 1079.10 + 8) 98140264 QHC-492 Terma Solucion 4 1907.23 SIN STOCK + 9) 40348917 WZD-331 Refrigeradora ECOTT 465 IX 3 1213.79 SIN STOCK +10) 90365520 KWP-672 Televisor UHD TV 6 1625.30 9751.80 +11) 45783712 QFR-958 Cocina a gas Bavaro 3 1607.46 SIN STOCK +12) 49087435 SJQ-827 Reproductor Multimedia Touch Screen 1 1719.56 1719.56 +13) 89429489 VXS-438 Mouse Blue Tooth 1 60.11 60.11 +14) 17913944 IHG-413 Parlant Y pedestal PAM-83 4 317.70 1270.80 +15) 81114108 VRR-793 Rack Giratorio 32/60 4 241.71 966.84 +16) 90237332 PVZ-181 Ventilador circular 5 309.77 SIN STOCK +17) 40348917 FLJ-040 Parlantes portatiles SOUNDSHOOTER 2 3703.37 7406.74 +18) 37110873 UWA-476 Autoradio MEX BT3150U 2 1191.39 2382.78 +19) 55552996 FQG-293 Rapiducha Premiun 1 2784.31 2784.31 +20) 85949265 TMJ-043 Lavadora EcoBubble 6 2400.79 14404.74 +21) 71463316 QFP-254 Calentador electrico instantaneo 6 180.65 SIN STOCK +22) 26233063 ZAF-449 Tablet Cardle 2 816.43 1632.86 +23) 90365520 OPJ-039 Secadora de Ropa 1 2765.64 2765.64 +24) 69639726 OPT-996 Mini componente GPX88 3 1367.48 4102.44 +25) 49087435 PJG-338 Impresora Mutifuncional Inalambricar 1 1067.80 1067.80 +26) 79140840 TMN-884 Secadora de mano 5 310.65 SIN STOCK +27) 91897732 WLL-607 Cocina Electronica Convencion 1 1525.04 SIN STOCK +28) 71984468 JJN-837 Lavadora Tecnologia Wobbie 5 1979.92 9899.60 +29) 15210391 HFM-021 Horno Electrico 1 726.91 726.91 +30) 17972674 UTN-601 Autoradio XAV-601 BT 1 562.51 562.51 +31) 49087435 XZR-640 Lavadora-Secadora FWD 6 2390.58 14343.48 +32) 25171011 VCL-867 Cocina a gas Rubi 2 1 699.07 SIN STOCK +33) 85949265 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1979.07 SIN STOCK +34) 43043986 TXM-139 Televisor LED FULL HD 3D 3 1092.95 SIN STOCK +35) 38913831 JFC-432 DVD DVM-L79 3 307.67 923.01 +36) 11602775 TMJ-043 Lavadora EcoBubble 6 2400.79 14404.74 +37) 17913944 YJD-279 Cocina a gas Florencia 5 1028.43 5142.15 +38) 81114108 DUG-251 Cocina a gas FFG3047SL 5 1597.96 SIN STOCK +39) 50365593 TZY-323 Terma a gas 1 2341.01 2341.01 +40) 32904023 SAM-013 Cocina a gas FFG3047SL 3 2275.18 SIN STOCK +41) 40112594 EBI-299 Cocina a gas Fridare 3 2287.57 SIN STOCK +42) 44229880 HLR-109 Parlantes inalambricos 5 439.47 2197.35 +43) 58187172 VXS-438 Mouse Blue Tooth 2 60.11 120.22 +44) 15561764 RAH-420 Cocina a gas Pro 6550 INOX 4 157.01 SIN STOCK +45) 95161027 TZY-323 Terma a gas 5 2341.01 SIN STOCK +46) 77191257 BWD-036 Cocina Empotrable Klimatica 5 1086.34 SIN STOCK +47) 32565207 ZWF-661 Impresora Led 6 2731.61 SIN STOCK +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 150271.01 +Total perdido por falta de stock: 83402.20 + REPORTE DE ENTREGA DE PEDIDOS +===================================================================================================================================== +FECHA: 1/9/2023 +===================================================================================================================================== +No. DNI Producto Cantidad Precio Total de ingresos +------------------------------------------------------------------------------------------------------------------------------------- + 1) 28390487 GLC-370 Video Proyector Power Lite 95 2 552.24 1104.48 + 2) 84165595 DFJ-952 Cocina a gas Prestige 60 INOX 1 3342.77 SIN STOCK + 3) 50365593 LWG-915 Cocina a gas Murano 3 1101.47 SIN STOCK + 4) 83236386 UJV-290 Cocina a gas Fassina Plus 5 2423.26 12116.30 + 5) 73185299 QHC-492 Terma Solucion 3 1907.23 SIN STOCK + 6) 13245501 VXS-438 Mouse Blue Tooth 3 60.11 SIN STOCK + 7) 42798099 TMN-884 Secadora de mano 5 310.65 SIN STOCK + 8) 32904023 DUG-251 Cocina a gas FFG3047SL 4 1597.96 SIN STOCK + 9) 96659352 ADX-669 Refrigeradora cap. 220 litros 4 1239.38 4957.52 +10) 89148118 AFL-718 Vinera 1 1664.97 SIN STOCK +11) 77191257 QVJ-982 Horno Microondas 0.7 p3 5 1352.76 6763.80 +12) 91897732 XZR-640 Lavadora-Secadora FWD 5 2390.58 SIN STOCK +13) 93160528 YYU-726 Reproductor DVD Portatil 1 767.82 767.82 +14) 89298238 UJV-290 Cocina a gas Fassina Plus 4 2423.26 9693.04 +15) 43488351 DIQ-718 Horno Microondas de Conveccion Cello 6 390.80 SIN STOCK +16) 78078115 FQG-293 Rapiducha Premiun 4 2784.31 11137.24 +17) 43043986 SSD-176 Refrigeradora Linea Gallery 5 567.71 SIN STOCK +18) 40348917 BMJ-772 Refrigeradora Side by Side 1 936.32 936.32 +19) 78922174 XBD-314 Cocina a gas Fassina 3 1444.90 SIN STOCK +20) 35565959 BZS-261 Cocina a gas Trento 1 3087.87 3087.87 +21) 87813843 XSD-310 Refrigeradora No frost 3 2259.93 SIN STOCK +22) 17913944 DEN-125 Rack Fijo 26/32 1 562.46 562.46 +23) 79420973 SSE-115 Refrigeradora CoolStyle 311N Steel 5 3243.58 16217.90 +24) 16151792 IDO-503 Laptop GamerVictus de 15.6 6 3935.17 23611.02 +25) 22280452 UCX-285 Galaxy Tab 3 3 3290.93 9872.79 +26) 71984468 TZY-323 Terma a gas 1 2341.01 SIN STOCK +27) 19829266 RDT-761 Horno Microondas con dorador 3 904.95 SIN STOCK +28) 86241107 UXG-019 Terma de acumulacion 2 934.91 SIN STOCK +29) 84165595 HFM-021 Horno Electrico 6 726.91 SIN STOCK +30) 31611146 FVQ-662 Cocina a gas Pro 6300 INOX 4 1060.68 SIN STOCK +31) 77191257 ZEX-027 Tablet Xperia Z 6 3843.75 23062.50 +32) 41036366 QVJ-982 Horno Microondas 0.7 p3 4 1352.76 SIN STOCK +33) 79140840 JXD-139 Terma Evolucion Soltu 4 586.02 SIN STOCK +34) 49087435 III-576 Campana Extractora Venus Plus 2 1077.65 2155.30 +------------------------------------------------------------------------------------------------------------------------------------- +Total ingresado: 128570.77 +Total perdido por falta de stock: 71170.57 diff --git a/2023-2/L02/mitsuo/ReporteDePedidos.txt b/2023-2/L02/mitsuo/ReporteDePedidos.txt new file mode 100644 index 0000000..a83c51e --- /dev/null +++ b/2023-2/L02/mitsuo/ReporteDePedidos.txt @@ -0,0 +1,563 @@ + 1) 50375303 JXD-139 6 + 2) 13245501 AWB-345 1 + 3) 12663268 AHB-459 3 + 4) 36380447 OWN-701 5 + 5) 88956889 TMN-884 1 + 6) 59162728 FEG-454 4 + 7) 33713901 ZVA-180 6 + 8) 86402303 OQI-373 3 + 9) 24995742 KCO-488 4 +10) 97403853 BCK-361 5 +11) 79901434 OXP-732 2 +12) 26290971 TYF-885 3 +13) 26976877 AFL-718 5 +14) 79464412 JXD-139 4 +15) 25171011 QRC-609 3 +16) 89148118 JFC-432 5 +17) 45828535 AVM-258 2 +18) 46462527 ISU-815 6 +19) 95015539 CSZ-863 2 +20) 11602775 JJN-837 2 +21) 15210391 OTW-288 3 +22) 43877279 SSD-176 4 +23) 54761731 FVB-607 5 +24) 85949265 LDR-510 6 +25) 78078115 SSD-176 1 +26) 35565959 VJI-529 5 +27) 45783712 VZV-827 1 +28) 50365593 VVS-017 3 +29) 87800799 JDC-028 5 +30) 73914283 OBI-353 4 +31) 45877001 RDT-761 5 +32) 42928709 GLC-370 6 + 1) 50375303 CRU-009 5 + 2) 26290971 PVZ-181 3 + 3) 73535476 FLJ-040 4 + 4) 16552775 AWB-345 6 + 5) 73535476 UWA-476 5 + 6) 95751208 UOD-420 4 + 7) 15561764 GBJ-693 2 + 8) 43043986 ZEX-027 1 + 9) 96258632 CRU-009 2 +10) 79901434 ZEX-027 2 +11) 12663268 YYU-726 4 +12) 71378466 FVQ-662 2 +13) 26976877 VTV-269 4 +14) 42798099 OQI-373 2 +15) 23928045 TMN-884 2 +16) 69324480 UOD-420 3 +17) 59407188 OWN-701 1 +18) 57263719 OTH-462 5 +19) 37110873 FCN-617 6 +20) 96659352 GBJ-693 3 +21) 52097922 UTN-601 2 +22) 79901434 CSZ-863 5 +23) 89429489 UXG-019 1 +24) 52097922 XSD-310 6 +25) 33713901 VVS-017 1 +26) 62566305 AVM-258 1 +27) 32904023 RBE-789 6 +28) 99842319 DUG-251 2 +29) 40112594 FVQ-662 4 +30) 16151792 AQS-362 1 +31) 52097922 XZG-521 4 +32) 54761731 OTS-581 5 + 1) 22777006 YYK-309 3 + 2) 63437380 PJG-338 2 + 3) 87813843 MLE-193 4 + 4) 79140840 DFF-034 3 + 5) 73914283 OBI-353 1 + 6) 43053402 YOT-530 2 + 7) 52097922 ISU-815 5 + 8) 32565207 UXG-019 4 + 9) 37110873 YZD-580 5 +10) 12663268 XSD-310 6 +11) 11602775 YYK-309 3 +12) 15561764 FYF-898 2 +13) 60574154 III-576 6 +14) 73185299 QUU-384 3 +15) 43877279 SNY-500 4 +16) 40112594 KSO-608 6 +17) 41036366 AQS-362 2 +18) 25171011 CIM-038 1 +19) 96659352 KQA-580 6 +20) 79140840 HLR-109 1 +21) 90237332 OQI-373 1 +22) 89863424 SSE-115 4 +23) 86828079 YGV-332 1 +24) 78757121 KJX-387 4 +25) 78078115 XOA-735 2 +26) 67418025 EVN-510 5 +27) 95751208 BRD-969 4 +28) 26976877 KQQ-136 3 +29) 38913831 FLW-631 3 +30) 57263719 OTH-462 2 +31) 63437380 YEZ-591 5 +32) 91897732 OXP-732 2 +33) 26233063 JFC-432 4 +34) 55552996 SSD-176 6 +35) 22777006 XLF-273 2 +36) 13245501 JCW-489 5 +37) 26976877 YUQ-590 4 +38) 38637282 OFS-384 1 +39) 84165595 JFC-432 3 +40) 45877001 GBJ-693 5 +41) 66409237 CRU-009 4 +42) 78922174 OQI-373 3 +43) 54716824 CRU-009 6 +44) 17913944 XLF-273 4 +45) 57690875 XTE-383 6 + 1) 42157219 OTS-581 5 + 2) 77484838 UWA-476 1 + 3) 79464412 CJE-310 5 + 4) 76388967 SJQ-827 5 + 5) 78922174 TKM-141 5 + 6) 94080926 NMV-644 5 + 7) 57263719 BWD-036 3 + 8) 17972674 ZWF-661 1 + 9) 89148118 XLF-273 5 +10) 42928709 NSM-283 5 +11) 57690875 CIM-038 3 +12) 80048864 BCK-361 3 +13) 59407188 BIT-434 6 +14) 32565207 FVQ-662 5 +15) 24995742 YMU-875 3 +16) 89298238 QFP-254 2 +17) 44679500 AWB-345 1 +18) 35584593 AVM-258 4 +19) 85871751 MYC-756 2 +20) 43043986 QFP-254 5 +21) 71463316 UWA-476 3 +22) 71378466 ARS-231 6 +23) 79475585 KQQ-136 6 +24) 32904023 KJX-387 3 +25) 42157219 KCO-488 2 +26) 71463316 BCN-855 4 +27) 66409237 UXG-019 4 +28) 23928045 OXP-732 3 +29) 26233063 KSO-608 3 +30) 86241107 CIM-038 2 +31) 35565959 DFJ-952 2 +32) 73786035 DEN-125 4 +33) 45828535 TZY-323 6 +34) 26976877 SSE-115 4 +35) 80048864 PPX-620 1 +36) 60574154 KDA-627 5 +37) 40112594 BCK-361 2 +38) 79372768 QVJ-982 6 +39) 43877279 QUU-384 5 +40) 69975105 HFM-021 6 +41) 43053402 FVQ-662 6 +42) 89863424 OTH-462 6 +43) 95161027 OQI-373 1 +44) 62324793 OPJ-039 2 + 1) 33397650 IHG-413 3 + 2) 69324480 JCW-489 5 + 3) 50375303 KQA-580 5 + 4) 32565207 IDO-503 6 + 5) 63437380 III-576 5 + 6) 91897732 TMN-884 2 + 7) 31611146 YOT-530 4 + 8) 85949265 JFC-432 4 + 9) 12663268 RAH-420 3 +10) 88956889 YUQ-590 2 +11) 38913831 BCN-855 3 +12) 44229880 JXD-139 4 +13) 42928709 XLF-273 4 +14) 88956889 UWA-476 3 +15) 66409237 BRD-969 3 +16) 42928709 QFP-254 5 +17) 26233063 UWA-476 1 +18) 35565959 QRC-609 5 +19) 50375303 YJD-279 5 +20) 27912250 QFR-958 3 +21) 88995291 MTF-868 3 +22) 69975105 FQG-293 5 +23) 76388967 PFD-286 6 +24) 77191257 ZWF-661 4 +25) 91897732 PFD-286 2 +26) 36380447 HLR-109 2 +27) 50375303 VXS-438 4 +28) 25171011 DFJ-952 4 +29) 48184351 TXM-139 1 +30) 45783712 YMU-875 4 +31) 94080926 SPR-580 5 + 1) 97403853 KQQ-136 6 + 2) 50365593 AFL-718 5 + 3) 83505958 TYF-885 5 + 4) 63437380 AWB-345 4 + 5) 19829266 TXM-139 3 + 6) 32821689 ONB-903 3 + 7) 96258632 QHC-492 2 + 8) 69975105 WZD-331 6 + 9) 79140840 OTH-462 1 +10) 87800799 GBD-525 6 +11) 62566305 GXF-122 5 +12) 42928709 QIL-029 4 +13) 23928045 TKM-141 5 +14) 32565207 TKM-141 4 +15) 26290971 GKG-558 3 +16) 86402303 RBE-789 6 +17) 48184351 KQA-580 2 +18) 85949265 VRR-793 5 +19) 15210391 DON-719 2 +20) 89429489 VCL-867 6 +21) 35565959 JXD-139 5 +22) 96659352 KQQ-136 3 +23) 62324793 XBD-314 5 +24) 89863424 QRC-609 3 +25) 97403853 GBJ-693 4 +26) 73185299 AVM-258 3 +27) 15210391 AQS-362 2 +28) 45877001 KBY-991 6 + 1) 78757121 OQI-373 3 + 2) 71984468 PQH-935 2 + 3) 43488351 XLF-273 5 + 4) 15210391 RSE-049 5 + 5) 78078115 XZR-640 5 + 6) 77484838 BTO-226 4 + 7) 25171011 OPT-996 6 + 8) 95161027 VJI-529 2 + 9) 27912250 LWG-915 4 +10) 15561764 JYQ-045 6 +11) 78757121 ZXK-295 4 +12) 76388967 RSE-049 6 +13) 37110873 GXF-122 2 +14) 16151792 WZD-331 3 +15) 73535476 CIM-038 3 +16) 89298238 QTK-083 3 +17) 78078115 DFF-034 2 +18) 77484838 YUQ-590 6 +19) 35584593 KCO-488 1 +20) 78078115 TMJ-043 3 +21) 38913831 YZD-580 1 +22) 87800799 QRC-609 1 +23) 66409237 ICX-503 5 +24) 86241107 HFC-845 3 +25) 36008913 HFC-845 6 +26) 64394265 YYK-309 6 +27) 32821689 ISU-815 1 +28) 26290971 TZY-323 5 +29) 77191257 AVM-258 6 +30) 52097922 MMA-577 2 +31) 84165595 QHC-492 4 +32) 93845419 NSR-955 2 +33) 27912250 LWG-915 1 +34) 20864087 SPR-580 1 +35) 94080926 OTW-288 5 +36) 80048864 BWD-036 3 + 1) 27912250 ICX-503 1 + 2) 86828079 MQR-442 3 + 3) 49087435 BCK-361 3 + 4) 78922174 AFL-718 5 + 5) 11602775 JJN-837 1 + 6) 79475585 BWD-036 5 + 7) 17972674 UWA-476 4 + 8) 71378466 BIT-434 4 + 9) 83505958 MQR-442 1 +10) 77484838 AFL-718 1 +11) 95161027 VVS-017 5 +12) 54761731 DEV-433 3 +13) 45828535 QJO-060 6 +14) 83236386 OPT-996 2 +15) 42157219 III-576 6 +16) 38637282 FLJ-040 6 +17) 59407188 RDT-761 5 +18) 78757121 GXF-122 1 +19) 90365520 EUZ-452 6 +20) 13245501 HFC-845 6 +21) 78757121 ARS-231 4 +22) 24995742 BWD-036 1 +23) 86402303 OQI-373 3 +24) 57690875 XLF-273 4 +25) 94080926 CIM-038 2 +26) 54761731 ZVA-180 4 +27) 42157219 KWP-672 6 +28) 54761731 VZV-827 1 +29) 29337157 WZD-331 4 +30) 73535476 KJX-387 4 +31) 77191257 TZY-323 3 +32) 27912250 FLJ-040 3 +33) 32904023 KQQ-136 1 +34) 99842319 ZAF-449 1 +35) 57263719 ZWF-661 5 +36) 81114108 VCL-867 1 +37) 31611146 XSD-310 1 +38) 40348917 VRR-793 3 +39) 79901434 TXM-139 2 +40) 26976877 XZG-521 3 + 1) 98140264 DFF-034 2 + 2) 25171011 VCL-867 3 + 3) 76388967 EBI-299 5 + 4) 16552775 CNN-411 5 + 5) 46462527 KWP-672 3 + 6) 79464412 NSM-283 2 + 7) 52097922 OWN-701 2 + 8) 71463316 KCO-488 5 + 9) 77642521 DFJ-952 5 +10) 53166028 QHC-492 1 +11) 45877001 PJG-338 2 +12) 77484838 UDR-957 3 +13) 71463316 EBI-299 6 +14) 88956889 HFM-021 6 +15) 29847168 BCK-361 1 +16) 55552996 SJD-818 1 +17) 87800799 WZD-331 2 +18) 43053402 VRR-793 2 +19) 16151792 AQS-362 1 +20) 81114108 RBE-789 2 +21) 62324793 FQG-293 1 +22) 87800799 BTO-226 3 +23) 44229880 SNY-500 3 +24) 20864087 YUQ-590 5 +25) 31193794 BXY-119 5 +26) 86241107 FEG-454 2 +27) 95161027 FQG-293 4 +28) 69639726 DON-719 1 +29) 53166028 ONB-903 3 +30) 45828535 YMU-875 5 +31) 71378466 XSD-310 3 + 1) 57263719 TZY-323 6 + 2) 87800799 KWP-672 2 + 3) 35565959 CIM-038 4 + 4) 77642521 QUU-384 5 + 5) 79901434 AHB-459 3 + 6) 67418025 QUU-384 1 + 7) 79140840 TYF-885 2 + 8) 11602775 XLF-273 4 + 9) 62566305 DIQ-718 4 +10) 40348917 SNY-500 4 +11) 83236386 MTF-868 2 +12) 52097922 GBD-525 5 +13) 16151792 CNQ-172 1 +14) 32821689 MMA-577 5 +15) 26976877 JXD-139 2 +16) 73535476 LDR-510 2 +17) 96258632 EBI-299 5 +18) 62324793 YJD-279 5 +19) 13245501 ZWF-661 1 +20) 87800799 ICX-503 2 +21) 73786035 AQS-362 1 +22) 58187172 KBY-991 6 +23) 71378466 OQI-373 1 +24) 88995291 HLR-109 2 +25) 95751208 BWD-036 3 +26) 87800799 EUZ-452 2 +27) 57263719 YOT-530 5 +28) 93845419 AWB-345 5 +29) 19829266 UXG-019 2 +30) 93160528 DUG-251 2 +31) 50375303 SJQ-827 2 +32) 42798099 RDT-761 6 +33) 49087435 AFL-718 1 +34) 45783712 SNY-500 5 +35) 77484838 YGV-332 3 + 1) 35584593 SSD-176 4 + 2) 73185299 OTH-462 3 + 3) 45783712 YUQ-590 2 + 4) 62324793 LDR-510 1 + 5) 37110873 QUU-384 4 + 6) 71463316 AWT-354 4 + 7) 46462527 LWG-915 6 + 8) 87800799 VRR-793 2 + 9) 25171011 AWB-345 6 +10) 22777006 FCN-617 1 +11) 90237332 QFP-254 3 +12) 48467976 JDQ-505 5 +13) 45828535 XSD-310 4 +14) 90365520 KBY-991 6 +15) 54716824 UDR-957 1 +16) 37110873 VDD-853 4 +17) 54716824 ZEX-027 6 +18) 81114108 DFF-034 5 +19) 64394265 OFS-384 5 +20) 42798099 CNN-411 6 +21) 13245501 QIL-029 2 +22) 86402303 HFM-021 6 +23) 89148118 EBI-299 6 +24) 87813843 OQI-373 1 +25) 93845419 QIL-029 6 +26) 67418025 FEG-454 2 +27) 69975105 TMJ-043 6 +28) 97403853 YJD-279 3 + 1) 60574154 BWD-036 2 + 2) 13245501 XOA-735 5 + 3) 46462527 KCO-488 4 + 4) 93845419 CIM-038 5 + 5) 63437380 KQA-580 2 + 6) 54716824 SPR-580 3 + 7) 55552996 UXG-019 6 + 8) 42798099 AQS-362 1 + 9) 80048864 RDT-761 5 +10) 43877279 TYF-885 5 +11) 98589725 VRR-793 1 +12) 22280452 XSD-310 2 +13) 16151792 TZY-323 3 +14) 89298238 JXD-139 3 +15) 12663268 BMJ-772 1 +16) 64394265 YUQ-590 1 +17) 76388967 DOV-560 2 +18) 69324480 VJI-529 1 +19) 73914283 BRD-969 3 +20) 62566305 CNQ-172 3 +21) 13245501 KJX-387 5 +22) 89298238 ICX-503 3 +23) 67418025 YYU-726 6 + 1) 31193794 JDC-028 1 + 2) 89148118 TKM-141 6 + 3) 29337157 QHC-492 6 + 4) 90237332 PFD-286 4 + 5) 89298238 PFD-286 2 + 6) 55552996 AQS-362 1 + 7) 81114108 BCN-855 4 + 8) 22280452 VRR-793 5 + 9) 69324480 VXS-438 3 +10) 79464412 MTF-868 6 +11) 93160528 BRD-969 5 +12) 43488351 QTK-083 6 +13) 93160528 QTK-083 3 +14) 76388967 CNQ-172 6 +15) 89298238 YOT-530 1 +16) 89429489 QUU-384 1 +17) 50365593 ZVA-180 6 +18) 83236386 OFS-384 1 +19) 81114108 OFS-384 3 +20) 23928045 LWG-915 2 +21) 73185299 QFP-254 5 +22) 78922174 XBD-314 2 +23) 87813843 LDR-510 6 +24) 78078115 PJG-338 2 +25) 79372768 SAM-013 1 +26) 64394265 OTW-288 5 +27) 77642521 YYU-726 2 +28) 12663268 QFP-254 5 + 1) 86828079 QIL-029 5 + 2) 79901434 OBI-353 6 + 3) 20864087 BXY-119 4 + 4) 37110873 SSD-176 1 + 5) 41036366 SJD-818 4 + 6) 98140264 BRD-969 1 + 7) 84165595 RDT-761 6 + 8) 50365593 JDC-028 6 + 9) 15210391 TZY-323 3 +10) 95161027 III-576 5 +11) 20864087 JFC-432 1 +12) 50375303 AFL-718 1 +13) 42928709 OQI-373 5 +14) 43053402 MMA-577 6 +15) 78922174 EJW-346 6 +16) 98140264 CJE-310 3 +17) 94080926 TXM-139 5 +18) 20864087 JDQ-505 6 +19) 66409237 DFF-034 4 +20) 66409237 AWT-354 6 +21) 88956889 MYC-756 4 +22) 24995742 DON-719 3 +23) 88956889 UWA-476 6 +24) 32904023 QFP-254 4 +25) 89298238 YOT-530 4 +26) 79372768 GLC-370 4 +27) 32821689 MTF-868 5 +28) 59407188 LYZ-614 3 +29) 55552996 QTK-083 1 +30) 50365593 TMN-884 6 +31) 15210391 VXS-438 4 +32) 33397650 VJI-529 6 +33) 13245501 BXY-119 5 +34) 69324480 DIQ-718 1 +35) 78078115 DFJ-952 5 +36) 29337157 HFM-021 4 +37) 77191257 KWP-672 2 +38) 89863424 FVB-607 1 +39) 79420973 GXF-122 3 +40) 33713901 UWA-476 2 +41) 90237332 TKM-141 3 +42) 89429489 BXY-119 3 +43) 90365520 VDD-853 5 +44) 79372768 EUZ-452 5 +45) 53166028 TXM-139 3 +46) 45783712 SSD-176 6 +47) 57263719 DOV-560 4 +48) 40348917 DFJ-952 2 +49) 79140840 QRC-609 5 + 1) 57690875 CSZ-863 5 + 2) 11602775 CIM-038 4 + 3) 29337157 ZEX-027 3 + 4) 49087435 VDD-853 2 + 5) 62566305 TYF-885 4 + 6) 45877001 VVS-017 4 + 7) 83505958 EJW-346 3 + 8) 98140264 QHC-492 4 + 9) 40348917 WZD-331 3 +10) 90365520 KWP-672 6 +11) 45783712 QFR-958 3 +12) 49087435 SJQ-827 1 +13) 89429489 VXS-438 1 +14) 17913944 IHG-413 4 +15) 81114108 VRR-793 4 +16) 90237332 PVZ-181 5 +17) 40348917 FLJ-040 2 +18) 37110873 UWA-476 2 +19) 55552996 FQG-293 1 +20) 85949265 TMJ-043 6 +21) 71463316 QFP-254 6 +22) 26233063 ZAF-449 2 +23) 90365520 OPJ-039 1 +24) 69639726 OPT-996 3 +25) 49087435 PJG-338 1 +26) 79140840 TMN-884 5 +27) 91897732 WLL-607 1 +28) 71984468 JJN-837 5 +29) 15210391 HFM-021 1 +30) 17972674 UTN-601 1 +31) 49087435 XZR-640 6 +32) 25171011 VCL-867 1 +33) 85949265 YUQ-590 2 +34) 43043986 TXM-139 3 +35) 38913831 JFC-432 3 +36) 11602775 TMJ-043 6 +37) 17913944 YJD-279 5 +38) 81114108 DUG-251 5 +39) 50365593 TZY-323 1 +40) 32904023 SAM-013 3 +41) 40112594 EBI-299 3 +42) 44229880 HLR-109 5 +43) 58187172 VXS-438 2 +44) 15561764 RAH-420 4 +45) 95161027 TZY-323 5 +46) 77191257 BWD-036 5 +47) 32565207 ZWF-661 6 + 1) 28390487 GLC-370 2 + 2) 84165595 DFJ-952 1 + 3) 50365593 LWG-915 3 + 4) 83236386 UJV-290 5 + 5) 73185299 QHC-492 3 + 6) 13245501 VXS-438 3 + 7) 42798099 TMN-884 5 + 8) 32904023 DUG-251 4 + 9) 96659352 ADX-669 4 +10) 89148118 AFL-718 1 +11) 77191257 QVJ-982 5 +12) 91897732 XZR-640 5 +13) 93160528 YYU-726 1 +14) 89298238 UJV-290 4 +15) 43488351 DIQ-718 6 +16) 78078115 FQG-293 4 +17) 43043986 SSD-176 5 +18) 40348917 BMJ-772 1 +19) 78922174 XBD-314 3 +20) 35565959 BZS-261 1 +21) 87813843 XSD-310 3 +22) 17913944 DEN-125 1 +23) 79420973 SSE-115 5 +24) 16151792 IDO-503 6 +25) 22280452 UCX-285 3 +26) 71984468 TZY-323 1 +27) 19829266 RDT-761 3 +28) 86241107 UXG-019 2 +29) 84165595 HFM-021 6 +30) 31611146 FVQ-662 4 +31) 77191257 ZEX-027 6 +32) 41036366 QVJ-982 4 +33) 79140840 JXD-139 4 +34) 49087435 III-576 2 diff --git a/2023-2/L02/mitsuo/ReporteDeProductos.txt b/2023-2/L02/mitsuo/ReporteDeProductos.txt new file mode 100644 index 0000000..770e5f6 --- /dev/null +++ b/2023-2/L02/mitsuo/ReporteDeProductos.txt @@ -0,0 +1,167 @@ +BIT-434 Campana Extractora modelo Glass 10 375.09 +SSE-115 Refrigeradora CoolStyle 311N Steel 23 3243.58 +NMV-644 Lavadora Automatica 5 3272.48 +MLE-193 Cocina a gas Ingenious 10 2779.41 +YYK-309 Refrigeradora Door in Door 25 4079.44 +QVJ-982 Horno Microondas 0.7 p3 12 1352.76 +VZV-827 Refrigeradora Top Mount 2 1784.27 +HFC-845 Televisor Serie LED R555A 22 3736.75 +AVM-258 Cocina a gas Toscana 20 2831.23 +YUQ-590 Refrigeradora CoolStyle 395N Steel 19 1979.07 +FLJ-040 Parlantes portatiles SOUNDSHOOTER 19 3703.37 +EUZ-452 Impresora Mutifuncional Led Color 11 3623.88 +SPR-580 Dispensador de Agua 15 404.35 +WLL-607 Cocina Electronica Convencion 1 1525.04 +UWA-476 Autoradio MEX BT3150U 29 1191.39 +YOT-530 Deshumedecedor DM-190H 13 941.73 +NSR-955 Cocina a gas Blogna 14 2591.44 +SJD-818 Refrigeradora CoolStyle 281A Steel 23 3387.75 +BCK-361 Tablets 10.1 9 1872.53 +ZAF-449 Tablet Cardle 16 816.43 +OBI-353 Terma Milenium 16 2960.56 +SNY-500 Cocina a gas Praga Quarzo 12 3297.09 +CSZ-863 Video Filmadora 17 1713.57 +TMJ-043 Lavadora EcoBubble 23 2400.79 +MTF-868 Impresora Monocromatica WorkForce M205 12 971.59 +BMJ-772 Refrigeradora Side by Side 13 936.32 +MYC-756 Cocina a gas Leganza INOX 21 1506.80 +FCN-617 Televisor Plasma 60 6 4121.05 +ONB-903 Reproductor BLU-RAY 3D 16 653.67 +VXS-438 Mouse Blue Tooth 17 60.11 +GLC-370 Video Proyector Power Lite 95 19 552.24 +OPT-996 Mini componente GPX88 14 1367.48 +PFD-286 Refrigeradora cap. 415 litros 8 2776.02 +KBY-991 Home Theater E4100 24 1101.08 +KQQ-136 Impresora Laser EPSON 17 1139.56 +NSM-283 Cocina a gas FFG3053SL 13 936.81 +ICX-503 Cocina a gas Roma 15 1221.02 +LDR-510 Mini componente ESX9 25 2701.87 +PJG-338 Impresora Mutifuncional Inalambricar 21 1067.80 +ISB-205 Camara fotografica 16MP 3 2976.43 +UDR-957 Refrigeradora ECOTT 423 IXL 19 861.70 +RAH-420 Cocina a gas Pro 6550 INOX 5 157.01 +JDQ-505 Lavadora Modelo Aquamatic 24 1572.31 +PPX-620 Aire acondicionado tipo split 8 2873.42 +XZG-521 Secadora Electrica FAQE7001LW 22 704.27 +VJI-529 Horno Empotrable Electrico 16 1102.67 +JCW-489 Conservadora Exibidora CMVE-250 11 2064.97 +OTS-581 Galaxy Note 8.0 24 2653.10 +UTN-601 Autoradio XAV-601 BT 4 562.51 +TZY-323 Terma a gas 31 2341.01 +TXM-139 Televisor LED FULL HD 3D 5 1092.95 +ADX-669 Refrigeradora cap. 220 litros 15 1239.38 +QRC-609 Camara de video EOS 17 1806.66 +YJD-279 Cocina a gas Florencia 23 1028.43 +AHB-459 Reproductor DVD Portatil TV 7 9 685.50 +MMA-577 Congeladora Horizontal 252 Lts. 14 1780.30 +VCL-867 Cocina a gas Rubi 2 9 699.07 +JDC-028 Puntero Laser 19 30.48 +JXD-139 Terma Evolucion Soltu 28 586.02 +KQA-580 Cocina Empotrable Glassy Plus 17 2907.92 +XSD-310 Refrigeradora No frost 17 2259.93 +YYU-726 Reproductor DVD Portatil 14 767.82 +EVN-510 Cocina a gas FFG3011LB 15 2672.30 +LZK-729 Cocina a gas Kristel 3 2850.91 +AQS-362 Teclado Inalambrico USB 7 233.05 +AWT-354 Galaxy Gear 22 3409.22 +CJE-310 Mini componente GPX33 16 3643.39 +KWP-672 Televisor UHD TV 24 1625.30 +DOV-560 Impresora Laser Mutifuncion Monocromatica 3 1203.14 +RBE-789 Televisor SMART TV 17 3303.07 +KCO-488 Ventilador de pared 22 679.60 +KSO-608 Secadora Modelo Italica 21 914.17 +TKM-141 Cocina a gas Marsella 24 402.24 +QUU-384 Lavavajilla Blue Touch 1 2545.54 +VRR-793 Rack Giratorio 32/60 26 241.71 +SAM-013 Cocina a gas FFG3047SL 1 2275.18 +YMU-875 Cocina a gas Plermo Quarzo 9 3232.10 +SSD-176 Refrigeradora Linea Gallery 23 567.71 +DFJ-952 Cocina a gas Prestige 60 INOX 18 3342.77 +BZS-261 Cocina a gas Trento 8 3087.87 +ARS-231 Audifonos Stereos 13 327.62 +SJQ-827 Reproductor Multimedia Touch Screen 21 1719.56 +UJV-290 Cocina a gas Fassina Plus 10 2423.26 +QTK-083 Congeladora Conservador Vertical 476 Lts. 16 2682.73 +EQY-018 Radio AM/FM stereo RMU-51C 7 301.73 +OQI-373 Cocina Empotrable Premio Plus 20 906.16 +OTH-462 Lavadora Semi-Automatica 20 531.04 +XTE-383 Rack Fijo 32/60 10 261.01 +ZVA-180 Refrigeradora 322 litros 13 2903.13 +BCN-855 Cocina a gas Bahia Can 14 4015.92 +PQH-935 Rack Giratorio 26/32 12 94.45 +LYZ-614 Impresore Mutifuncional Expression XP-211 13 3510.84 +FYF-898 Proyector a color 15 1160.46 +OPJ-039 Secadora de Ropa 12 2765.64 +CNN-411 Congeladora Side by Side 24 2296.29 +KJX-387 Ventilador de techo 9 613.19 +JFC-432 DVD DVM-L79 24 307.67 +EJW-346 Campana Extractora 11 359.70 +EBI-299 Cocina a gas Fridare 15 2287.57 +FEG-454 Sillon masajeador 8 1695.70 +YEZ-591 Lavadora WA 9 1320.03 +UXG-019 Terma de acumulacion 16 934.91 +FVB-607 Cocina a gas Essenza BL 13 2953.07 +RDT-761 Horno Microondas con dorador 21 904.95 +BWD-036 Cocina Empotrable Klimatica 5 1086.34 +TMN-884 Secadora de mano 10 310.65 +ZXK-295 Cocina Empotrable Electrica 9 3679.43 +DIQ-718 Horno Microondas de Conveccion Cello 3 390.80 +BTO-226 Friobar 25 863.19 +DFF-034 Grabadora de voz digital portatil con USB integrado 24 259.25 +OFS-384 Parlantes Bluetooth 8 805.22 +YZD-580 Mini componente ESX8 4 1582.29 +OTW-288 Cavba de Vinos GE cap. 34 botellas 14 1119.18 +UOD-420 Mini componente ESX6 10 828.94 +IDO-503 Laptop GamerVictus de 15.6 23 3935.17 +VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 16 1095.67 +VTV-269 Extractor de aire 9 854.48 +XZR-640 Lavadora-Secadora FWD 14 2390.58 +DON-719 Secadora de Cabello SG-3035 12 360.69 +HTY-123 Refrigeradora GM-S604ULV 1 1173.33 +LWG-915 Cocina a gas Murano 15 1101.47 +JYQ-045 Horno Microondas 1.2 p3 20 267.15 +AWB-345 Deshumedecedor DM-189H 6 800.37 +YGV-332 Impresora Led Color 18 2517.66 +HLR-109 Parlantes inalambricos 25 439.47 +MQR-442 Reloj Digital RMM-29 25 271.66 +GBD-525 Refrigeradora Puertas Mágicas 14 2700.95 +DEV-433 Parlantes portatiles SHOQBOX 13 2698.74 +OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77A80L LA8 8 16504.47 +FVQ-662 Cocina a gas Pro 6300 INOX 13 1060.68 +DEN-125 Rack Fijo 26/32 25 562.46 +CRU-009 Lavavajilla 5 2655.78 +RSE-049 Radio CD/DVD - TV 21 4037.51 +BRD-969 Centro de Lavado Electrico 18 2579.72 +CIM-038 Cocina Empotrable Petra 16 2544.64 +CNQ-172 Congeladora Horizontal 364 Lts. 15 3689.62 +QFR-958 Cocina a gas Bavaro 6 1607.46 +TYF-885 Videojuego TW 4 7 794.14 +VVS-017 Tablets MW 0731 14 2599.72 +BXY-119 Cocina Empotrable Klimatica 12 2716.11 +GKG-558 Horno Microondas MS2042D 23 1674.24 +UCX-285 Galaxy Tab 3 11 3290.93 +WZD-331 Refrigeradora ECOTT 465 IX 7 1213.79 +AFL-718 Vinera 17 1664.97 +JJN-837 Lavadora Tecnologia Wobbie 15 1979.92 +KDA-627 Cocina a gas Ijasmin 7 1424.46 +PVZ-181 Ventilador circular 8 309.77 +ISU-815 Audifonos 16 619.89 +OWN-701 Olla arrocera 21 220.82 +HFM-021 Horno Electrico 26 726.91 +GBJ-693 Radio CD 8 314.20 +FQG-293 Rapiducha Premiun 23 2784.31 +XBD-314 Cocina a gas Fassina 8 1444.90 +QIL-029 Mini componente Shake-5 16 2990.55 +ZWF-661 Impresora Led 1 2731.61 +QHC-492 Terma Solucion 17 1907.23 +XLF-273 Centro de Lavado a Gas 20 2371.95 +XOA-735 Congeladora Vertical 392 Lts. 12 2708.07 +FLW-631 Radio Reloj Despertador 7 819.04 +ZEX-027 Tablet Xperia Z 23 3843.75 +QJO-060 Televisor LED FULL HD 23 2704.14 +GXF-122 Televisor Ultra HDTV 15 1110.16 +QFP-254 Calentador electrico instantaneo 25 180.65 +DUG-251 Cocina a gas FFG3047SL 7 1597.96 +III-576 Campana Extractora Venus Plus 29 1077.65 +IHG-413 Parlant Y pedestal PAM-83 13 317.70 +QQB-968 Refrigeradora 484 litros 9 1452.92 diff --git a/2023-2/L02/mitsuo/ReporteDeProductosFinal.txt b/2023-2/L02/mitsuo/ReporteDeProductosFinal.txt new file mode 100644 index 0000000..d8fb944 --- /dev/null +++ b/2023-2/L02/mitsuo/ReporteDeProductosFinal.txt @@ -0,0 +1,167 @@ +BIT-434 Campana Extractora modelo Glass 0 375.09 +SSE-115 Refrigeradora CoolStyle 311N Steel 10 3243.58 +NMV-644 Lavadora Automatica 0 3272.48 +MLE-193 Cocina a gas Ingenious 6 2779.41 +YYK-309 Refrigeradora Door in Door 13 4079.44 +QVJ-982 Horno Microondas 0.7 p3 0 1352.76 +VZV-827 Refrigeradora Top Mount 0 1784.27 +HFC-845 Televisor Serie LED R555A 7 3736.75 +AVM-258 Cocina a gas Toscana 4 2831.23 +YUQ-590 Refrigeradora CoolStyle 395N Steel 0 1979.07 +FLJ-040 Parlantes portatiles SOUNDSHOOTER 4 3703.37 +EUZ-452 Impresora Mutifuncional Led Color 0 3623.88 +SPR-580 Dispensador de Agua 6 404.35 +WLL-607 Cocina Electronica Convencion 0 1525.04 +UWA-476 Autoradio MEX BT3150U 2 1191.39 +YOT-530 Deshumedecedor DM-190H 0 941.73 +NSR-955 Cocina a gas Blogna 12 2591.44 +SJD-818 Refrigeradora CoolStyle 281A Steel 18 3387.75 +BCK-361 Tablets 10.1 0 1872.53 +ZAF-449 Tablet Cardle 13 816.43 +OBI-353 Terma Milenium 5 2960.56 +SNY-500 Cocina a gas Praga Quarzo 0 3297.09 +CSZ-863 Video Filmadora 5 1713.57 +TMJ-043 Lavadora EcoBubble 2 2400.79 +MTF-868 Impresora Monocromatica WorkForce M205 0 971.59 +BMJ-772 Refrigeradora Side by Side 11 936.32 +MYC-756 Cocina a gas Leganza INOX 15 1506.80 +FCN-617 Televisor Plasma 60 0 4121.05 +ONB-903 Reproductor BLU-RAY 3D 10 653.67 +VXS-438 Mouse Blue Tooth 0 60.11 +GLC-370 Video Proyector Power Lite 95 7 552.24 +OPT-996 Mini componente GPX88 3 1367.48 +PFD-286 Refrigeradora cap. 415 litros 0 2776.02 +KBY-991 Home Theater E4100 6 1101.08 +KQQ-136 Impresora Laser EPSON 0 1139.56 +NSM-283 Cocina a gas FFG3053SL 6 936.81 +ICX-503 Cocina a gas Roma 4 1221.02 +LDR-510 Mini componente ESX9 10 2701.87 +PJG-338 Impresora Mutifuncional Inalambricar 14 1067.80 +ISB-205 Camara fotografica 16MP 3 2976.43 +UDR-957 Refrigeradora ECOTT 423 IXL 15 861.70 +RAH-420 Cocina a gas Pro 6550 INOX 0 157.01 +JDQ-505 Lavadora Modelo Aquamatic 13 1572.31 +PPX-620 Aire acondicionado tipo split 7 2873.42 +XZG-521 Secadora Electrica FAQE7001LW 15 704.27 +VJI-529 Horno Empotrable Electrico 2 1102.67 +JCW-489 Conservadora Exibidora CMVE-250 1 2064.97 +OTS-581 Galaxy Note 8.0 14 2653.10 +UTN-601 Autoradio XAV-601 BT 1 562.51 +TZY-323 Terma a gas 0 2341.01 +TXM-139 Televisor LED FULL HD 3D 0 1092.95 +ADX-669 Refrigeradora cap. 220 litros 11 1239.38 +QRC-609 Camara de video EOS 0 1806.66 +YJD-279 Cocina a gas Florencia 5 1028.43 +AHB-459 Reproductor DVD Portatil TV 7 3 685.50 +MMA-577 Congeladora Horizontal 252 Lts. 1 1780.30 +VCL-867 Cocina a gas Rubi 2 0 699.07 +JDC-028 Puntero Laser 7 30.48 +JXD-139 Terma Evolucion Soltu 0 586.02 +KQA-580 Cocina Empotrable Glassy Plus 2 2907.92 +XSD-310 Refrigeradora No frost 0 2259.93 +YYU-726 Reproductor DVD Portatil 1 767.82 +EVN-510 Cocina a gas FFG3011LB 10 2672.30 +LZK-729 Cocina a gas Kristel 3 2850.91 +AQS-362 Teclado Inalambrico USB 0 233.05 +AWT-354 Galaxy Gear 12 3409.22 +CJE-310 Mini componente GPX33 8 3643.39 +KWP-672 Televisor UHD TV 5 1625.30 +DOV-560 Impresora Laser Mutifuncion Monocromatica 0 1203.14 +RBE-789 Televisor SMART TV 3 3303.07 +KCO-488 Ventilador de pared 6 679.60 +KSO-608 Secadora Modelo Italica 12 914.17 +TKM-141 Cocina a gas Marsella 1 402.24 +QUU-384 Lavavajilla Blue Touch 0 2545.54 +VRR-793 Rack Giratorio 32/60 4 241.71 +SAM-013 Cocina a gas FFG3047SL 0 2275.18 +YMU-875 Cocina a gas Plermo Quarzo 0 3232.10 +SSD-176 Refrigeradora Linea Gallery 0 567.71 +DFJ-952 Cocina a gas Prestige 60 INOX 0 3342.77 +BZS-261 Cocina a gas Trento 7 3087.87 +ARS-231 Audifonos Stereos 3 327.62 +SJQ-827 Reproductor Multimedia Touch Screen 13 1719.56 +UJV-290 Cocina a gas Fassina Plus 1 2423.26 +QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2682.73 +EQY-018 Radio AM/FM stereo RMU-51C 7 301.73 +OQI-373 Cocina Empotrable Premio Plus 0 906.16 +OTH-462 Lavadora Semi-Automatica 3 531.04 +XTE-383 Rack Fijo 32/60 4 261.01 +ZVA-180 Refrigeradora 322 litros 0 2903.13 +BCN-855 Cocina a gas Bahia Can 3 4015.92 +PQH-935 Rack Giratorio 26/32 10 94.45 +LYZ-614 Impresore Mutifuncional Expression XP-211 10 3510.84 +FYF-898 Proyector a color 13 1160.46 +OPJ-039 Secadora de Ropa 9 2765.64 +CNN-411 Congeladora Side by Side 13 2296.29 +KJX-387 Ventilador de techo 0 613.19 +JFC-432 DVD DVM-L79 4 307.67 +EJW-346 Campana Extractora 2 359.70 +EBI-299 Cocina a gas Fridare 0 2287.57 +FEG-454 Sillon masajeador 0 1695.70 +YEZ-591 Lavadora WA 4 1320.03 +UXG-019 Terma de acumulacion 0 934.91 +FVB-607 Cocina a gas Essenza BL 7 2953.07 +RDT-761 Horno Microondas con dorador 0 904.95 +BWD-036 Cocina Empotrable Klimatica 0 1086.34 +TMN-884 Secadora de mano 0 310.65 +ZXK-295 Cocina Empotrable Electrica 5 3679.43 +DIQ-718 Horno Microondas de Conveccion Cello 0 390.80 +BTO-226 Friobar 18 863.19 +DFF-034 Grabadora de voz digital portatil con USB integrado 8 259.25 +OFS-384 Parlantes Bluetooth 0 805.22 +YZD-580 Mini componente ESX8 0 1582.29 +OTW-288 Cavba de Vinos GE cap. 34 botellas 1 1119.18 +UOD-420 Mini componente ESX6 3 828.94 +IDO-503 Laptop GamerVictus de 15.6 11 3935.17 +VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 5 1095.67 +VTV-269 Extractor de aire 5 854.48 +XZR-640 Lavadora-Secadora FWD 0 2390.58 +DON-719 Secadora de Cabello SG-3035 6 360.69 +HTY-123 Refrigeradora GM-S604ULV 1 1173.33 +LWG-915 Cocina a gas Murano 0 1101.47 +JYQ-045 Horno Microondas 1.2 p3 14 267.15 +AWB-345 Deshumedecedor DM-189H 0 800.37 +YGV-332 Impresora Led Color 14 2517.66 +HLR-109 Parlantes inalambricos 15 439.47 +MQR-442 Reloj Digital RMM-29 21 271.66 +GBD-525 Refrigeradora Puertas Mágicas 3 2700.95 +DEV-433 Parlantes portatiles SHOQBOX 10 2698.74 +OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77A80L LA8 1 16504.47 +FVQ-662 Cocina a gas Pro 6300 INOX 0 1060.68 +DEN-125 Rack Fijo 26/32 20 562.46 +CRU-009 Lavavajilla 0 2655.78 +RSE-049 Radio CD/DVD - TV 10 4037.51 +BRD-969 Centro de Lavado Electrico 2 2579.72 +CIM-038 Cocina Empotrable Petra 0 2544.64 +CNQ-172 Congeladora Horizontal 364 Lts. 5 3689.62 +QFR-958 Cocina a gas Bavaro 0 1607.46 +TYF-885 Videojuego TW 4 0 794.14 +VVS-017 Tablets MW 0731 1 2599.72 +BXY-119 Cocina Empotrable Klimatica 0 2716.11 +GKG-558 Horno Microondas MS2042D 20 1674.24 +UCX-285 Galaxy Tab 3 8 3290.93 +WZD-331 Refrigeradora ECOTT 465 IX 0 1213.79 +AFL-718 Vinera 0 1664.97 +JJN-837 Lavadora Tecnologia Wobbie 7 1979.92 +KDA-627 Cocina a gas Ijasmin 2 1424.46 +PVZ-181 Ventilador circular 0 309.77 +ISU-815 Audifonos 4 619.89 +OWN-701 Olla arrocera 13 220.82 +HFM-021 Horno Electrico 0 726.91 +GBJ-693 Radio CD 0 314.20 +FQG-293 Rapiducha Premiun 8 2784.31 +XBD-314 Cocina a gas Fassina 0 1444.90 +QIL-029 Mini componente Shake-5 0 2990.55 +ZWF-661 Impresora Led 0 2731.61 +QHC-492 Terma Solucion 0 1907.23 +XLF-273 Centro de Lavado a Gas 0 2371.95 +XOA-735 Congeladora Vertical 392 Lts. 5 2708.07 +FLW-631 Radio Reloj Despertador 4 819.04 +ZEX-027 Tablet Xperia Z 5 3843.75 +QJO-060 Televisor LED FULL HD 17 2704.14 +GXF-122 Televisor Ultra HDTV 4 1110.16 +QFP-254 Calentador electrico instantaneo 0 180.65 +DUG-251 Cocina a gas FFG3047SL 0 1597.96 +III-576 Campana Extractora Venus Plus 5 1077.65 +IHG-413 Parlant Y pedestal PAM-83 6 317.70 +QQB-968 Refrigeradora 484 litros 9 1452.92 diff --git a/2023-2/L02/mitsuo/fun.cpp b/2023-2/L02/mitsuo/fun.cpp new file mode 100644 index 0000000..8065ca5 --- /dev/null +++ b/2023-2/L02/mitsuo/fun.cpp @@ -0,0 +1,313 @@ +#include <iomanip> +#include <cstring> +#include <algorithm> // find +#include "fun.hpp" + +using namespace std; + +void lecturaDeProductos(const char *archivo, char ***&productos, int *&stock, double *&precios) { + ifstream in(archivo); + if (!in) { + cerr << "Error: no se pudo abrir el archivo.\n"; + exit(1); + } + + // read (stack memory) + char code[MAXLEN]; + char description[MAXLEN]; + double price; + int qty; + + char **productos_tmp[MAX]; + int stock_tmp[MAX]; + double precio_tmp[MAX]; + + int i; + for (i = 0; i < MAX; i++) { + in.getline(code, MAXLEN, ','); + in.getline(description, MAXLEN, ','); + in >> price; in.get(); + in >> qty; in.get(); + if (!in) { + break; + } + + productos_tmp[i] = crea_producto(code, description); // this is the "Primary Key" of the parallel arrays + stock_tmp[i] = qty; + precio_tmp[i] = price; + } + + // write (heap memory) + int n = i + 1; // "null terminated list" + productos = new char ** [n]; + stock = new int [n]; + precios = new double [n]; + + for (i = 0; i < n; i++) { + productos[i] = productos_tmp[i]; + stock[i] = stock_tmp[i]; + precios[i] = precio_tmp[i]; + } + productos[i] = NULL; +} + +char **crea_producto(char * code, char * description) { + char * field1 = new char [strlen(code) + 1]; + char * field2 = new char [strlen(description) + 1]; + + strcpy(field1, code); + strcpy(field2, description); + + return new char * [2] {field1, field2}; +} + +void pruebaDeLecturaDeProductos(const char *archivo, char ***productos, int *stock, double *precios) { + ofstream out(archivo); + if (!out) { + cerr << "Error: no se pudo abrir archivo.\n"; + exit(1); + } + + char ** producto; + int i; + for (i = 0; i < MAX && (producto = productos[i]); i++) { + out << left; + out << setw(12) << producto[0]; + out << setw(72) << producto[1]; + out << right << setprecision(2) << fixed; + out << setw(8) << stock[i]; + out << setw(12) << precios[i]; + out << '\n'; + } +} + +void lecturaDePedidos(const char *archivo, int *&fechaPedidos, char ***&codigoPedidos, int ***&dniCantPedidos) { + ifstream in(archivo); + if (!in) { + cerr << "Error: no se pudo abrir el archivo.\n"; + exit(1); + } + + int date, dd, mm, yy; + char code[MAXLEN]; + int dni; + int qty; + + // read (stack memory) + int fechas[MAX]; + char * productos[MAX]; // code array + int * dniqtys[MAX]; // dni + qty array + + int n, i; + for (i = 0; i < MAX; i++) { + in.getline(code, MAXLEN, ','); + in >> dni; in.get(); + in >> qty; in.get(); + in >> dd; in.get(); in >> mm; in.get(); in >> yy; in.get(); + date = yy*10000 + mm*100 + dd; + if (!in) { + break; + } + + // First load data in arrays. Then group by date. + fechas[i] = date; // "PK" + productos[i] = new char [strlen(code) + 1]; strcpy(productos[i], code); + dniqtys[i] = new int [2] {dni, qty}; + } + n = i; + + // aggregate by date + int grouped_fecha_tmp[MAX]; + char ** grouped_producto_tmp[MAX]; + int ** grouped_dniqty_tmp[MAX]; + + /* Loop over the dates, then look for all occurrences of a date in + `agrega_pedidos_fecha`. Store already processed dates. + (this is required because you need to know how many orders are in a + specific date, in order to allocate memory) + + Another strategy could be to first sort the 3 parallel arrays. And then + Add the products to a date, until the date changes. + + On second thought, the report only makes sence if the dates are sorted + (doesn't make much serve the orders in seaminly random order, but + it also doesn't make sence that the Pedidos.csv is randomly shuffled, + should come in-order). Lab 3 is exactly the same but now with + "metodo por incrementos", and the professors commented that they + made a similar exercise in class and they grouped by dates "in-order" + (insertion sort). + */ + int fechas_procesadas[MAX]; // ignore already processed dates + int n_procesadas = 0; + int i_grouped = 0; + for (i = 0; i < n; i++) { + int fecha = fechas[i]; + if (find(fechas_procesadas, fechas_procesadas + n_procesadas, fecha) != fechas_procesadas + n_procesadas) { + // already processed date + continue; + } + + grouped_fecha_tmp[i_grouped] = fecha; + agrega_pedidos_fecha(fecha, + grouped_producto_tmp[i_grouped], grouped_dniqty_tmp[i_grouped], + fechas, productos, dniqtys, n); + i_grouped += 1; + + fechas_procesadas[n_procesadas++] = fecha; + } + + // write (heap memory) + n = i_grouped; + fechaPedidos = new int [n + 1]; + codigoPedidos = new char ** [n + 1]; + dniCantPedidos = new int ** [n + 1]; + + for (i = 0; i < n; i++) { + fechaPedidos[i] = grouped_fecha_tmp[i]; + codigoPedidos[i] = grouped_producto_tmp[i]; + dniCantPedidos[i] = grouped_dniqty_tmp[i]; + } + fechaPedidos[i] = 0; +} + +/* agrega todos los pedidos de una determinada fecha en los arreglos paralelos */ +void agrega_pedidos_fecha( + int fecha, char **& pedido_producto, int **& pedido_dniqty, + int * fechas, char ** productos, int ** dniqtys, + int n) +{ + int i; + char * productos_tmp[MAX]; + int * dniqtys_tmp[MAX]; + int j = 0; // numero de pedidos para una fecha + for (i = 0; i < n; i++) { + if (fecha == fechas[i]) { + productos_tmp[j] = productos[i]; + dniqtys_tmp[j] = dniqtys[i]; + j += 1; + } + } + int n_pedidos = j; + pedido_producto = new char * [n_pedidos + 1]; + pedido_dniqty = new int * [n_pedidos + 1]; + + for (i = 0; i < n_pedidos; i++) { + pedido_producto[i] = productos_tmp[i]; + pedido_dniqty[i] = dniqtys_tmp[i]; + } + pedido_producto[i] = NULL; + pedido_dniqty[i] = NULL; +} + +void pruebaDeLecturaDePedidos(const char *archivo, int *fechaPedidos, char ***codigoPedidos, int ***dniCantPedidos) { + ofstream out(archivo); + if (!out) { + cerr << "Error: no se pudo abrir archivo.\n"; + exit(1); + } + + int fecha; + int i, j; + for (i = 0; i < MAX && (fecha = fechaPedidos[i]); i++) { + char ** productos = codigoPedidos[i]; + int ** dniqtys = dniCantPedidos[i]; + for (j = 0; j < MAX && productos[j]; j++) { + int dni = dniqtys[j][0]; + int qty = dniqtys[j][1]; + char * code = productos[j]; + + out << right << setprecision(2) << fixed; + out << setw(2) << j + 1 << ") "; + out << left; + out << setw(12) << dni; + out << setw(12) << code; + out << setw(12) << qty; + out << '\n'; + } + } +} + +void reporteDeEnvioDePedidos(const char *archivo, + char ***productos, int *stocks, double *precios, // productos parallel arrays + int *fechaPedidos, char ***codigoPedidos, int ***dniCantPedidos // pedidos parallel arrays +) { + ofstream out(archivo); + if (!out) { + cerr << "Error: no se pudo abrir archivo.\n"; + exit(1); + } + + int fecha; + int i, j; + for (i = 0; i < MAX && (fecha = fechaPedidos[i]); i++) { + int dd = fecha % 100; + int mm = fecha / 100 % 100; + int yy = fecha / 10000; + out << " REPORTE DE ENTREGA DE PEDIDOS\n" + "=====================================================================================================================================\n" + ; + out << "FECHA: " << dd << "/" << mm << "/" << yy << '\n'; + out << "=====================================================================================================================================\n" + "No. DNI Producto Cantidad Precio Total de ingresos\n" + "-------------------------------------------------------------------------------------------------------------------------------------\n" + ; + + char ** pedido_productos = codigoPedidos[i]; + int ** dniqtys = dniCantPedidos[i]; + + double served_income = 0; + double not_served_income = 0; + for (j = 0; j < MAX && pedido_productos[j]; j++) { + int dni = dniqtys[j][0]; + int qty = dniqtys[j][1]; + char * code = pedido_productos[j]; + + int i_product = busca_producto(productos, code); + char * name = productos[i_product][1]; + int * stock = &stocks[i_product]; + double price = precios[i_product]; + + int qty_served; + if (*stock >= qty) { + qty_served = qty; + *stock -= qty; + } else { + qty_served = max(*stock - qty, 0); + *stock = 0; + } + served_income += qty_served * price; + not_served_income += (qty - qty_served) * price; + + out << right << setprecision(2) << fixed; + out << setw(2) << j + 1 << ") "; + out << left; + out << setw(12) << dni; + out << setw(12) << code; + out << setw(64) << name; + out << right << setprecision(2) << fixed; + out << setw(12) << qty; + out << setw(12) << price; + if (*stock == 0) { + out << left; + out << setw(12) << " SIN STOCK"; + } else { + out << setw(12) << price * qty_served; + } + out << '\n'; + } + out << right << setprecision(2) << fixed; + out << "-------------------------------------------------------------------------------------------------------------------------------------\n"; + out << "Total ingresado: " << served_income << '\n'; + out << "Total perdido por falta de stock: " << not_served_income << '\n'; + } +} + +int busca_producto(char *** productos, char * producto) { + for (int i = 0; productos[i]; i++) { + if (strcmp(productos[i][0], producto) == 0) { + return i; + } + } + return -1; + +}
\ No newline at end of file diff --git a/2023-2/L02/mitsuo/fun.hpp b/2023-2/L02/mitsuo/fun.hpp new file mode 100644 index 0000000..a415cfc --- /dev/null +++ b/2023-2/L02/mitsuo/fun.hpp @@ -0,0 +1,45 @@ +#ifndef FUN_HPP +#define FUN_HPP + +#include <iostream> +#include <fstream> + +#define MAX 1000 +#define MAXLEN 100 + +void lecturaDeProductos(const char *archivo, char ***&productos, int *&stock, double *&precios); +void pruebaDeLecturaDeProductos(const char *archivo, char ***productos, int *stock, double *precios); +void lecturaDePedidos(const char *archivo, int *&fechaPedidos, char ***&codigoPedidos, int ***&dniCantPedidos); +void pruebaDeLecturaDePedidos(const char *archivo, int *fechaPedidos, char ***codigoPedidos, int ***dniCantPedidos); +void reporteDeEnvioDePedidos(const char *archivo, char ***productos, int *stocks, double *precios, int *fechaPedidos, char ***codigoPedidos, int ***dniCantPedidos); +void agrega_pedidos_fecha( + int fecha, char **& pedido_producto, int **& pedido_dniqty, + int * fechas, char ** productos, int ** dniqtys, + int n); + +char **crea_producto(char * code, char * description); +int busca_producto(char *** productos, char * producto); + +using namespace std; +char * leeCad(ifstream &arch, char delim='\n'); +void cargaCodNomProducto(ifstream &arch, char **&buffProd, char *codProd); +void imprimePedidos(ofstream &arch, char **producto, double stock, double precio); +void leeDatos(ifstream &arch, int &dni, int &cant, int &fecha); +int buscaFecha(int *buffFecha, int fecha); +void cargaPedido(char **buffCodPed, char *codPed, int **&buffdniCant, + int dni, int cant, int &numPed); +int buscaPedido(char **buffCodPed, char *codPed); +void sumaCantidad(int *buffdniCant, int cant); +void guardaCliente(int *buffdniCant, int dni, int cant); +void espaciosExactos(char **&codigoPedidos, int numPed); +void espaciosExactos(int **&dniCantPed, int numPed); +void imprimePedidos(ofstream &arch, char **codPed, int **dniCant); +void imprimeCliente(ofstream &arch, int *cliente); +void imprimeRepPedidos(ofstream &arch, char **codigoPedidos, int **dniCantPedidos,char ***prod, int *stock, + double *precios, double &parcialIng, double &parcialFalta); +void imprimePedido(ofstream &arch, char *codPed, char **prod, int &stock, + double precio, int *dniCantPed, double &parcialIng, double &parcialFalta); +void imprimeLinea(ofstream &arch, char c); +int buscaProd(char ***prod, char *codProd); + +#endif /* FUN_HPP */
\ No newline at end of file diff --git a/2023-2/L02/mitsuo/main.cpp b/2023-2/L02/mitsuo/main.cpp new file mode 100644 index 0000000..43b3be4 --- /dev/null +++ b/2023-2/L02/mitsuo/main.cpp @@ -0,0 +1,30 @@ +/* Notes: + "Asignacion exacta de memoria". Arreglos paralelos con data de productos + y pedidos de clientes. Se usan "pseudo estructuras" (arreglos o matrices) + para evaluar manejo de punteros con doble y triple indireccion (Ver + https://en.wikipedia.org/wiki/Pointer_(computer_programming)#Multiple_indirection). + Lo que convierte esta tarea relativamente simple (e.g., usando SQL o un + Excel), compleja de implementar + + $ clang++ -std=c++11 -g *.cpp +*/ + +#include "fun.hpp" + +int main(int argc, char** argv) { + char ***productos, ***codigoPedidos; + int *stock, *fechaPedidos, ***dniCantPedidos; + double *precios; + + lecturaDeProductos("../Productos.csv", productos, stock, precios); + pruebaDeLecturaDeProductos("ReporteDeProductos.txt", productos, stock, precios); + + lecturaDePedidos("../Pedidos.csv", fechaPedidos, codigoPedidos, dniCantPedidos); + pruebaDeLecturaDePedidos("ReporteDePedidos.txt", fechaPedidos, codigoPedidos, dniCantPedidos); + reporteDeEnvioDePedidos("ReporteDeEntregaDePedisos.txt", productos, stock, precios, fechaPedidos, codigoPedidos, dniCantPedidos); + + pruebaDeLecturaDeProductos("ReporteDeProductosFinal.txt", productos, stock, precios); + + return 0; +} + diff --git a/2023-2/L02/mitsuo/simple.ipynb b/2023-2/L02/mitsuo/simple.ipynb new file mode 100644 index 0000000..471d1a2 --- /dev/null +++ b/2023-2/L02/mitsuo/simple.ipynb @@ -0,0 +1,1070 @@ +{ + "cells": [ + { + "cell_type": "code", + "execution_count": 1, + "metadata": {}, + "outputs": [], + "source": [ + "import pandas as pd" + ] + }, + { + "cell_type": "code", + "execution_count": 2, + "metadata": {}, + "outputs": [], + "source": [ + "# pd.set_option('display.max_rows', None)\n", + "pd.set_option('display.max_columns', None)\n", + "pd.set_option('display.expand_frame_repr', False)\n", + "pd.set_option('display.float_format', '{:,.2f}'.format)" + ] + }, + { + "cell_type": "code", + "execution_count": 3, + "metadata": {}, + "outputs": [], + "source": [ + "productos = pd.read_csv(\"../Productos.csv\", names=(\"product_id\", \"product_name\", \"price\", \"stock\"))\n", + "pedidos = pd.read_csv(\"../Pedidos.csv\", names=(\"product_id\", \"client_id\", \"qty\", \"date\"))\n", + "\n", + "productos = productos.set_index('product_id')\n", + "pedidos['date'] = pd.to_datetime(pedidos['date'], format=\"%d/%m/%Y\")" + ] + }, + { + "cell_type": "code", + "execution_count": 4, + "metadata": {}, + "outputs": [ + { + "data": { + "text/html": [ + "<div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>product_name</th>\n", + " <th>price</th>\n", + " <th>stock</th>\n", + " </tr>\n", + " <tr>\n", + " <th>product_id</th>\n", + " <th></th>\n", + " <th></th>\n", + " <th></th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>BIT-434</th>\n", + " <td>Campana Extractora modelo Glass</td>\n", + " <td>375.09</td>\n", + " <td>10</td>\n", + " </tr>\n", + " <tr>\n", + " <th>SSE-115</th>\n", + " <td>Refrigeradora CoolStyle 311N Steel</td>\n", + " <td>3,243.58</td>\n", + " <td>23</td>\n", + " </tr>\n", + " <tr>\n", + " <th>NMV-644</th>\n", + " <td>Lavadora Automatica</td>\n", + " <td>3,272.48</td>\n", + " <td>5</td>\n", + " </tr>\n", + " <tr>\n", + " <th>MLE-193</th>\n", + " <td>Cocina a gas Ingenious</td>\n", + " <td>2,779.41</td>\n", + " <td>10</td>\n", + " </tr>\n", + " <tr>\n", + " <th>YYK-309</th>\n", + " <td>Refrigeradora Door in Door</td>\n", + " <td>4,079.44</td>\n", + " <td>25</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "</div>" + ], + "text/plain": [ + " product_name price stock\n", + "product_id \n", + "BIT-434 Campana Extractora modelo Glass 375.09 10\n", + "SSE-115 Refrigeradora CoolStyle 311N Steel 3,243.58 23\n", + "NMV-644 Lavadora Automatica 3,272.48 5\n", + "MLE-193 Cocina a gas Ingenious 2,779.41 10\n", + "YYK-309 Refrigeradora Door in Door 4,079.44 25" + ] + }, + "execution_count": 4, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "productos.head()" + ] + }, + { + "cell_type": "code", + "execution_count": 5, + "metadata": {}, + "outputs": [ + { + "data": { + "text/html": [ + "<div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>product_id</th>\n", + " <th>client_id</th>\n", + " <th>qty</th>\n", + " <th>date</th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>0</th>\n", + " <td>JXD-139</td>\n", + " <td>50375303</td>\n", + " <td>6</td>\n", + " <td>2023-08-24</td>\n", + " </tr>\n", + " <tr>\n", + " <th>1</th>\n", + " <td>CRU-009</td>\n", + " <td>50375303</td>\n", + " <td>5</td>\n", + " <td>2023-09-03</td>\n", + " </tr>\n", + " <tr>\n", + " <th>2</th>\n", + " <td>YYK-309</td>\n", + " <td>22777006</td>\n", + " <td>3</td>\n", + " <td>2023-08-27</td>\n", + " </tr>\n", + " <tr>\n", + " <th>3</th>\n", + " <td>OTS-581</td>\n", + " <td>42157219</td>\n", + " <td>5</td>\n", + " <td>2023-08-28</td>\n", + " </tr>\n", + " <tr>\n", + " <th>4</th>\n", + " <td>AWB-345</td>\n", + " <td>13245501</td>\n", + " <td>1</td>\n", + " <td>2023-08-24</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "</div>" + ], + "text/plain": [ + " product_id client_id qty date\n", + "0 JXD-139 50375303 6 2023-08-24\n", + "1 CRU-009 50375303 5 2023-09-03\n", + "2 YYK-309 22777006 3 2023-08-27\n", + "3 OTS-581 42157219 5 2023-08-28\n", + "4 AWB-345 13245501 1 2023-08-24" + ] + }, + "execution_count": 5, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "pedidos.head()" + ] + }, + { + "cell_type": "code", + "execution_count": 6, + "metadata": {}, + "outputs": [], + "source": [ + "# reduce stock from products as orders come\n", + "\n", + "pedidos['qty_served'] = 0\n", + "for i, pedido in pedidos.iterrows():\n", + " pid = pedido['product_id']\n", + " qty = pedido['qty']\n", + " stock = productos.loc[pid, 'stock']\n", + " if stock >= qty:\n", + " pedidos.loc[i, 'qty_served'] = qty\n", + " productos.loc[pid, 'stock'] -= qty\n", + " else:\n", + " pedidos.loc[i, 'qty_served'] = max(0, stock)\n", + " productos.loc[pid, 'stock'] = 0" + ] + }, + { + "cell_type": "code", + "execution_count": 7, + "metadata": {}, + "outputs": [ + { + "name": "stdout", + "output_type": "stream", + "text": [ + "FECHA: 21/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 57690875 CSZ-863 Video Filmadora 5 1,713.57 8,567.85\n", + "2 11602775 CIM-038 Cocina Empotrable Petra 4 2,544.64 10,178.56\n", + "3 29337157 ZEX-027 Tablet Xperia Z 3 3,843.75 11,531.25\n", + "4 49087435 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 2 1,095.67 2,191.34\n", + "5 62566305 TYF-885 Videojuego TW 4 4 794.14 3,176.56\n", + "6 45877001 VVS-017 Tablets MW 0731 4 2,599.72 10,398.88\n", + "7 83505958 EJW-346 Campana Extractora 3 359.70 1,079.10\n", + "8 98140264 QHC-492 Terma Solucion 4 1,907.23 7,628.92\n", + "9 40348917 WZD-331 Refrigeradora ECOTT 465 IX 3 1,213.79 3,641.37\n", + "10 90365520 KWP-672 Televisor UHD TV 6 1,625.30 9,751.80\n", + "11 45783712 QFR-958 Cocina a gas Bavaro 3 1,607.46 4,822.38\n", + "12 49087435 SJQ-827 Reproductor Multimedia Touch Screen 1 1,719.56 1,719.56\n", + "13 89429489 VXS-438 Mouse Blue Tooth 1 60.11 60.11\n", + "14 17913944 IHG-413 Parlant Y pedestal PAM-83 4 317.70 1,270.80\n", + "15 81114108 VRR-793 Rack Giratorio 32/60 4 241.71 966.84\n", + "16 90237332 PVZ-181 Ventilador circular 5 309.77 1,548.85\n", + "17 40348917 FLJ-040 Parlantes portatiles SOUNDSHOOTER 2 3,703.37 7,406.74\n", + "18 37110873 UWA-476 Autoradio MEX BT3150U 2 1,191.39 2,382.78\n", + "19 55552996 FQG-293 Rapiducha Premiun 1 2,784.31 2,784.31\n", + "20 85949265 TMJ-043 Lavadora EcoBubble 6 2,400.79 14,404.74\n", + "21 71463316 QFP-254 Calentador electrico instantaneo 6 180.65 1,083.90\n", + "22 26233063 ZAF-449 Tablet Cardle 2 816.43 1,632.86\n", + "23 90365520 OPJ-039 Secadora de Ropa 1 2,765.64 2,765.64\n", + "24 69639726 OPT-996 Mini componente GPX88 3 1,367.48 4,102.44\n", + "25 49087435 PJG-338 Impresora Mutifuncional Inalambricar 1 1,067.80 1,067.80\n", + "26 79140840 TMN-884 Secadora de mano 0 310.65 0.00\n", + "27 91897732 WLL-607 Cocina Electronica Convencion 1 1,525.04 1,525.04\n", + "28 71984468 JJN-837 Lavadora Tecnologia Wobbie 5 1,979.92 9,899.60\n", + "29 15210391 HFM-021 Horno Electrico 1 726.91 726.91\n", + "30 17972674 UTN-601 Autoradio XAV-601 BT 1 562.51 562.51\n", + "31 49087435 XZR-640 Lavadora-Secadora FWD 4 2,390.58 9,562.32\n", + "32 25171011 VCL-867 Cocina a gas Rubi 2 1 699.07 699.07\n", + "33 85949265 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1,979.07 3,958.14\n", + "34 43043986 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", + "35 38913831 JFC-432 DVD DVM-L79 3 307.67 923.01\n", + "36 11602775 TMJ-043 Lavadora EcoBubble 6 2,400.79 14,404.74\n", + "37 17913944 YJD-279 Cocina a gas Florencia 5 1,028.43 5,142.15\n", + "38 81114108 DUG-251 Cocina a gas FFG3047SL 0 1,597.96 0.00\n", + "39 50365593 TZY-323 Terma a gas 1 2,341.01 2,341.01\n", + "40 32904023 SAM-013 Cocina a gas FFG3047SL 0 2,275.18 0.00\n", + "41 40112594 EBI-299 Cocina a gas Fridare 0 2,287.57 0.00\n", + "42 44229880 HLR-109 Parlantes inalambricos 5 439.47 2,197.35\n", + "43 58187172 VXS-438 Mouse Blue Tooth 2 60.11 120.22\n", + "44 15561764 RAH-420 Cocina a gas Pro 6550 INOX 2 157.01 314.02\n", + "45 95161027 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", + "46 77191257 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", + "47 32565207 ZWF-661 Impresora Led 0 2,731.61 0.00\n", + "Total ingresado: 175,564.50\n", + "Total perdido por falta de stock: 58,108.71\n", + "========================================================================================================================\n", + "FECHA: 22/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 78757121 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2,718.48\n", + "2 71984468 PQH-935 Rack Giratorio 26/32 2 94.45 188.90\n", + "3 43488351 XLF-273 Centro de Lavado a Gas 5 2,371.95 11,859.75\n", + "4 15210391 RSE-049 Radio CD/DVD - TV 5 4,037.51 20,187.55\n", + "5 78078115 XZR-640 Lavadora-Secadora FWD 5 2,390.58 11,952.90\n", + "6 77484838 BTO-226 Friobar 4 863.19 3,452.76\n", + "7 25171011 OPT-996 Mini componente GPX88 6 1,367.48 8,204.88\n", + "8 95161027 VJI-529 Horno Empotrable Electrico 2 1,102.67 2,205.34\n", + "9 27912250 LWG-915 Cocina a gas Murano 4 1,101.47 4,405.88\n", + "10 15561764 JYQ-045 Horno Microondas 1.2 p3 6 267.15 1,602.90\n", + "11 78757121 ZXK-295 Cocina Empotrable Electrica 4 3,679.43 14,717.72\n", + "12 76388967 RSE-049 Radio CD/DVD - TV 6 4,037.51 24,225.06\n", + "13 37110873 GXF-122 Televisor Ultra HDTV 2 1,110.16 2,220.32\n", + "14 16151792 WZD-331 Refrigeradora ECOTT 465 IX 3 1,213.79 3,641.37\n", + "15 73535476 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", + "16 89298238 QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2,682.73 8,048.19\n", + "17 78078115 DFF-034 Grabadora de voz digital portatil con USB inte... 2 259.25 518.50\n", + "18 77484838 YUQ-590 Refrigeradora CoolStyle 395N Steel 6 1,979.07 11,874.42\n", + "19 35584593 KCO-488 Ventilador de pared 1 679.60 679.60\n", + "20 78078115 TMJ-043 Lavadora EcoBubble 3 2,400.79 7,202.37\n", + "21 38913831 YZD-580 Mini componente ESX8 0 1,582.29 0.00\n", + "22 87800799 QRC-609 Camara de video EOS 1 1,806.66 1,806.66\n", + "23 66409237 ICX-503 Cocina a gas Roma 5 1,221.02 6,105.10\n", + "24 86241107 HFC-845 Televisor Serie LED R555A 3 3,736.75 11,210.25\n", + "25 36008913 HFC-845 Televisor Serie LED R555A 6 3,736.75 22,420.50\n", + "26 64394265 YYK-309 Refrigeradora Door in Door 6 4,079.44 24,476.64\n", + "27 32821689 ISU-815 Audifonos 1 619.89 619.89\n", + "28 26290971 TZY-323 Terma a gas 5 2,341.01 11,705.05\n", + "29 77191257 AVM-258 Cocina a gas Toscana 6 2,831.23 16,987.38\n", + "30 52097922 MMA-577 Congeladora Horizontal 252 Lts. 2 1,780.30 3,560.60\n", + "31 84165595 QHC-492 Terma Solucion 1 1,907.23 1,907.23\n", + "32 93845419 NSR-955 Cocina a gas Blogna 2 2,591.44 5,182.88\n", + "33 27912250 LWG-915 Cocina a gas Murano 0 1,101.47 0.00\n", + "34 20864087 SPR-580 Dispensador de Agua 1 404.35 404.35\n", + "35 94080926 OTW-288 Cavba de Vinos GE cap. 34 botellas 5 1,119.18 5,595.90\n", + "36 80048864 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", + "Total ingresado: 251,889.32\n", + "Total perdido por falta de stock: 19,298.39\n", + "========================================================================================================================\n", + "FECHA: 23/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 31193794 JDC-028 Puntero Laser 1 30.48 30.48\n", + "2 89148118 TKM-141 Cocina a gas Marsella 6 402.24 2,413.44\n", + "3 29337157 QHC-492 Terma Solucion 6 1,907.23 11,443.38\n", + "4 90237332 PFD-286 Refrigeradora cap. 415 litros 4 2,776.02 11,104.08\n", + "5 89298238 PFD-286 Refrigeradora cap. 415 litros 2 2,776.02 5,552.04\n", + "6 55552996 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", + "7 81114108 BCN-855 Cocina a gas Bahia Can 4 4,015.92 16,063.68\n", + "8 22280452 VRR-793 Rack Giratorio 32/60 5 241.71 1,208.55\n", + "9 69324480 VXS-438 Mouse Blue Tooth 3 60.11 180.33\n", + "10 79464412 MTF-868 Impresora Monocromatica WorkForce M205 6 971.59 5,829.54\n", + "11 93160528 BRD-969 Centro de Lavado Electrico 5 2,579.72 12,898.60\n", + "12 43488351 QTK-083 Congeladora Conservador Vertical 476 Lts. 6 2,682.73 16,096.38\n", + "13 93160528 QTK-083 Congeladora Conservador Vertical 476 Lts. 3 2,682.73 8,048.19\n", + "14 76388967 CNQ-172 Congeladora Horizontal 364 Lts. 6 3,689.62 22,137.72\n", + "15 89298238 YOT-530 Deshumedecedor DM-190H 1 941.73 941.73\n", + "16 89429489 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", + "17 50365593 ZVA-180 Refrigeradora 322 litros 6 2,903.13 17,418.78\n", + "18 83236386 OFS-384 Parlantes Bluetooth 1 805.22 805.22\n", + "19 81114108 OFS-384 Parlantes Bluetooth 3 805.22 2,415.66\n", + "20 23928045 LWG-915 Cocina a gas Murano 2 1,101.47 2,202.94\n", + "21 73185299 QFP-254 Calentador electrico instantaneo 0 180.65 0.00\n", + "22 78922174 XBD-314 Cocina a gas Fassina 2 1,444.90 2,889.80\n", + "23 87813843 LDR-510 Mini componente ESX9 6 2,701.87 16,211.22\n", + "24 78078115 PJG-338 Impresora Mutifuncional Inalambricar 2 1,067.80 2,135.60\n", + "25 79372768 SAM-013 Cocina a gas FFG3047SL 1 2,275.18 2,275.18\n", + "26 64394265 OTW-288 Cavba de Vinos GE cap. 34 botellas 5 1,119.18 5,595.90\n", + "27 77642521 YYU-726 Reproductor DVD Portatil 2 767.82 1,535.64\n", + "28 12663268 QFP-254 Calentador electrico instantaneo 0 180.65 0.00\n", + "Total ingresado: 167,667.13\n", + "Total perdido por falta de stock: 4,352.04\n", + "========================================================================================================================\n", + "FECHA: 24/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 50375303 JXD-139 Terma Evolucion Soltu 6 586.02 3,516.12\n", + "2 13245501 AWB-345 Deshumedecedor DM-189H 1 800.37 800.37\n", + "3 12663268 AHB-459 Reproductor DVD Portatil TV 7 3 685.50 2,056.50\n", + "4 36380447 OWN-701 Olla arrocera 5 220.82 1,104.10\n", + "5 88956889 TMN-884 Secadora de mano 1 310.65 310.65\n", + "6 59162728 FEG-454 Sillon masajeador 4 1,695.70 6,782.80\n", + "7 33713901 ZVA-180 Refrigeradora 322 litros 6 2,903.13 17,418.78\n", + "8 86402303 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2,718.48\n", + "9 24995742 KCO-488 Ventilador de pared 4 679.60 2,718.40\n", + "10 97403853 BCK-361 Tablets 10.1 5 1,872.53 9,362.65\n", + "11 79901434 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77... 2 16,504.47 33,008.94\n", + "12 26290971 TYF-885 Videojuego TW 4 0 794.14 0.00\n", + "13 26976877 AFL-718 Vinera 5 1,664.97 8,324.85\n", + "14 79464412 JXD-139 Terma Evolucion Soltu 4 586.02 2,344.08\n", + "15 25171011 QRC-609 Camara de video EOS 3 1,806.66 5,419.98\n", + "16 89148118 JFC-432 DVD DVM-L79 5 307.67 1,538.35\n", + "17 45828535 AVM-258 Cocina a gas Toscana 2 2,831.23 5,662.46\n", + "18 46462527 ISU-815 Audifonos 6 619.89 3,719.34\n", + "19 95015539 CSZ-863 Video Filmadora 2 1,713.57 3,427.14\n", + "20 11602775 JJN-837 Lavadora Tecnologia Wobbie 2 1,979.92 3,959.84\n", + "21 15210391 OTW-288 Cavba de Vinos GE cap. 34 botellas 3 1,119.18 3,357.54\n", + "22 43877279 SSD-176 Refrigeradora Linea Gallery 4 567.71 2,270.84\n", + "23 54761731 FVB-607 Cocina a gas Essenza BL 5 2,953.07 14,765.35\n", + "24 85949265 LDR-510 Mini componente ESX9 6 2,701.87 16,211.22\n", + "25 78078115 SSD-176 Refrigeradora Linea Gallery 1 567.71 567.71\n", + "26 35565959 VJI-529 Horno Empotrable Electrico 5 1,102.67 5,513.35\n", + "27 45783712 VZV-827 Refrigeradora Top Mount 1 1,784.27 1,784.27\n", + "28 50365593 VVS-017 Tablets MW 0731 3 2,599.72 7,799.16\n", + "29 87800799 JDC-028 Puntero Laser 5 30.48 152.40\n", + "30 73914283 OBI-353 Terma Milenium 4 2,960.56 11,842.24\n", + "31 45877001 RDT-761 Horno Microondas con dorador 0 904.95 0.00\n", + "32 42928709 GLC-370 Video Proyector Power Lite 95 6 552.24 3,313.44\n", + "Total ingresado: 181,771.35\n", + "Total perdido por falta de stock: 6,907.17\n", + "========================================================================================================================\n", + "FECHA: 25/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 57263719 TZY-323 Terma a gas 6 2,341.01 14,046.06\n", + "2 87800799 KWP-672 Televisor UHD TV 2 1,625.30 3,250.60\n", + "3 35565959 CIM-038 Cocina Empotrable Petra 4 2,544.64 10,178.56\n", + "4 77642521 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", + "5 79901434 AHB-459 Reproductor DVD Portatil TV 7 3 685.50 2,056.50\n", + "6 67418025 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", + "7 79140840 TYF-885 Videojuego TW 4 0 794.14 0.00\n", + "8 11602775 XLF-273 Centro de Lavado a Gas 4 2,371.95 9,487.80\n", + "9 62566305 DIQ-718 Horno Microondas de Conveccion Cello 3 390.80 1,172.40\n", + "10 40348917 SNY-500 Cocina a gas Praga Quarzo 4 3,297.09 13,188.36\n", + "11 83236386 MTF-868 Impresora Monocromatica WorkForce M205 2 971.59 1,943.18\n", + "12 52097922 GBD-525 Refrigeradora Puertas Mágicas 5 2,700.95 13,504.75\n", + "13 16151792 CNQ-172 Congeladora Horizontal 364 Lts. 1 3,689.62 3,689.62\n", + "14 32821689 MMA-577 Congeladora Horizontal 252 Lts. 5 1,780.30 8,901.50\n", + "15 26976877 JXD-139 Terma Evolucion Soltu 2 586.02 1,172.04\n", + "16 73535476 LDR-510 Mini componente ESX9 2 2,701.87 5,403.74\n", + "17 96258632 EBI-299 Cocina a gas Fridare 4 2,287.57 9,150.28\n", + "18 62324793 YJD-279 Cocina a gas Florencia 5 1,028.43 5,142.15\n", + "19 13245501 ZWF-661 Impresora Led 0 2,731.61 0.00\n", + "20 87800799 ICX-503 Cocina a gas Roma 2 1,221.02 2,442.04\n", + "21 73786035 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", + "22 58187172 KBY-991 Home Theater E4100 6 1,101.08 6,606.48\n", + "23 71378466 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", + "24 88995291 HLR-109 Parlantes inalambricos 2 439.47 878.94\n", + "25 95751208 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", + "26 87800799 EUZ-452 Impresora Mutifuncional Led Color 2 3,623.88 7,247.76\n", + "27 57263719 YOT-530 Deshumedecedor DM-190H 2 941.73 1,883.46\n", + "28 93845419 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", + "29 19829266 UXG-019 Terma de acumulacion 0 934.91 0.00\n", + "30 93160528 DUG-251 Cocina a gas FFG3047SL 2 1,597.96 3,195.92\n", + "31 50375303 SJQ-827 Reproductor Multimedia Touch Screen 2 1,719.56 3,439.12\n", + "32 42798099 RDT-761 Horno Microondas con dorador 2 904.95 1,809.90\n", + "33 49087435 AFL-718 Vinera 0 1,664.97 0.00\n", + "34 45783712 SNY-500 Cocina a gas Praga Quarzo 1 3,297.09 3,297.09\n", + "35 77484838 YGV-332 Impresora Led Color 3 2,517.66 7,552.98\n", + "Total ingresado: 141,780.44\n", + "Total perdido por falta de stock: 52,700.51\n", + "========================================================================================================================\n", + "FECHA: 26/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 27912250 ICX-503 Cocina a gas Roma 1 1,221.02 1,221.02\n", + "2 86828079 MQR-442 Reloj Digital RMM-29 3 271.66 814.98\n", + "3 49087435 BCK-361 Tablets 10.1 3 1,872.53 5,617.59\n", + "4 78922174 AFL-718 Vinera 5 1,664.97 8,324.85\n", + "5 11602775 JJN-837 Lavadora Tecnologia Wobbie 1 1,979.92 1,979.92\n", + "6 79475585 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", + "7 17972674 UWA-476 Autoradio MEX BT3150U 4 1,191.39 4,765.56\n", + "8 71378466 BIT-434 Campana Extractora modelo Glass 4 375.09 1,500.36\n", + "9 83505958 MQR-442 Reloj Digital RMM-29 1 271.66 271.66\n", + "10 77484838 AFL-718 Vinera 1 1,664.97 1,664.97\n", + "11 95161027 VVS-017 Tablets MW 0731 5 2,599.72 12,998.60\n", + "12 54761731 DEV-433 Parlantes portatiles SHOQBOX 3 2,698.74 8,096.22\n", + "13 45828535 QJO-060 Televisor LED FULL HD 6 2,704.14 16,224.84\n", + "14 83236386 OPT-996 Mini componente GPX88 2 1,367.48 2,734.96\n", + "15 42157219 III-576 Campana Extractora Venus Plus 6 1,077.65 6,465.90\n", + "16 38637282 FLJ-040 Parlantes portatiles SOUNDSHOOTER 6 3,703.37 22,220.22\n", + "17 59407188 RDT-761 Horno Microondas con dorador 5 904.95 4,524.75\n", + "18 78757121 GXF-122 Televisor Ultra HDTV 1 1,110.16 1,110.16\n", + "19 90365520 EUZ-452 Impresora Mutifuncional Led Color 6 3,623.88 21,743.28\n", + "20 13245501 HFC-845 Televisor Serie LED R555A 6 3,736.75 22,420.50\n", + "21 78757121 ARS-231 Audifonos Stereos 4 327.62 1,310.48\n", + "22 24995742 BWD-036 Cocina Empotrable Klimatica 0 1,086.34 0.00\n", + "23 86402303 OQI-373 Cocina Empotrable Premio Plus 3 906.16 2,718.48\n", + "24 57690875 XLF-273 Centro de Lavado a Gas 2 2,371.95 4,743.90\n", + "25 94080926 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", + "26 54761731 ZVA-180 Refrigeradora 322 litros 1 2,903.13 2,903.13\n", + "27 42157219 KWP-672 Televisor UHD TV 6 1,625.30 9,751.80\n", + "28 54761731 VZV-827 Refrigeradora Top Mount 1 1,784.27 1,784.27\n", + "29 29337157 WZD-331 Refrigeradora ECOTT 465 IX 0 1,213.79 0.00\n", + "30 73535476 KJX-387 Ventilador de techo 2 613.19 1,226.38\n", + "31 77191257 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", + "32 27912250 FLJ-040 Parlantes portatiles SOUNDSHOOTER 3 3,703.37 11,110.11\n", + "33 32904023 KQQ-136 Impresora Laser EPSON 0 1,139.56 0.00\n", + "34 99842319 ZAF-449 Tablet Cardle 1 816.43 816.43\n", + "35 57263719 ZWF-661 Impresora Led 0 2,731.61 0.00\n", + "36 81114108 VCL-867 Cocina a gas Rubi 2 0 699.07 0.00\n", + "37 31611146 XSD-310 Refrigeradora No frost 0 2,259.93 0.00\n", + "38 40348917 VRR-793 Rack Giratorio 32/60 3 241.71 725.13\n", + "39 79901434 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", + "40 26976877 XZG-521 Secadora Electrica FAQE7001LW 3 704.27 2,112.81\n", + "Total ingresado: 190,926.29\n", + "Total perdido por falta de stock: 51,084.66\n", + "========================================================================================================================\n", + "FECHA: 27/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 22777006 YYK-309 Refrigeradora Door in Door 3 4,079.44 12,238.32\n", + "2 63437380 PJG-338 Impresora Mutifuncional Inalambricar 2 1,067.80 2,135.60\n", + "3 87813843 MLE-193 Cocina a gas Ingenious 4 2,779.41 11,117.64\n", + "4 79140840 DFF-034 Grabadora de voz digital portatil con USB inte... 3 259.25 777.75\n", + "5 73914283 OBI-353 Terma Milenium 1 2,960.56 2,960.56\n", + "6 43053402 YOT-530 Deshumedecedor DM-190H 2 941.73 1,883.46\n", + "7 52097922 ISU-815 Audifonos 5 619.89 3,099.45\n", + "8 32565207 UXG-019 Terma de acumulacion 4 934.91 3,739.64\n", + "9 37110873 YZD-580 Mini componente ESX8 4 1,582.29 6,329.16\n", + "10 12663268 XSD-310 Refrigeradora No frost 6 2,259.93 13,559.58\n", + "11 11602775 YYK-309 Refrigeradora Door in Door 3 4,079.44 12,238.32\n", + "12 15561764 FYF-898 Proyector a color 2 1,160.46 2,320.92\n", + "13 60574154 III-576 Campana Extractora Venus Plus 6 1,077.65 6,465.90\n", + "14 73185299 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", + "15 43877279 SNY-500 Cocina a gas Praga Quarzo 4 3,297.09 13,188.36\n", + "16 40112594 KSO-608 Secadora Modelo Italica 6 914.17 5,485.02\n", + "17 41036366 AQS-362 Teclado Inalambrico USB 2 233.05 466.10\n", + "18 25171011 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", + "19 96659352 KQA-580 Cocina Empotrable Glassy Plus 6 2,907.92 17,447.52\n", + "20 79140840 HLR-109 Parlantes inalambricos 1 439.47 439.47\n", + "21 90237332 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", + "22 89863424 SSE-115 Refrigeradora CoolStyle 311N Steel 4 3,243.58 12,974.32\n", + "23 86828079 YGV-332 Impresora Led Color 1 2,517.66 2,517.66\n", + "24 78757121 KJX-387 Ventilador de techo 4 613.19 2,452.76\n", + "25 78078115 XOA-735 Congeladora Vertical 392 Lts. 2 2,708.07 5,416.14\n", + "26 67418025 EVN-510 Cocina a gas FFG3011LB 5 2,672.30 13,361.50\n", + "27 95751208 BRD-969 Centro de Lavado Electrico 4 2,579.72 10,318.88\n", + "28 26976877 KQQ-136 Impresora Laser EPSON 3 1,139.56 3,418.68\n", + "29 38913831 FLW-631 Radio Reloj Despertador 3 819.04 2,457.12\n", + "30 57263719 OTH-462 Lavadora Semi-Automatica 2 531.04 1,062.08\n", + "31 63437380 YEZ-591 Lavadora WA 5 1,320.03 6,600.15\n", + "32 91897732 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77... 2 16,504.47 33,008.94\n", + "33 26233063 JFC-432 DVD DVM-L79 4 307.67 1,230.68\n", + "34 55552996 SSD-176 Refrigeradora Linea Gallery 6 567.71 3,406.26\n", + "35 22777006 XLF-273 Centro de Lavado a Gas 0 2,371.95 0.00\n", + "36 13245501 JCW-489 Conservadora Exibidora CMVE-250 5 2,064.97 10,324.85\n", + "37 26976877 YUQ-590 Refrigeradora CoolStyle 395N Steel 1 1,979.07 1,979.07\n", + "38 38637282 OFS-384 Parlantes Bluetooth 0 805.22 0.00\n", + "39 84165595 JFC-432 DVD DVM-L79 3 307.67 923.01\n", + "40 45877001 GBJ-693 Radio CD 3 314.20 942.60\n", + "41 66409237 CRU-009 Lavavajilla 0 2,655.78 0.00\n", + "42 78922174 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", + "43 54716824 CRU-009 Lavavajilla 0 2,655.78 0.00\n", + "44 17913944 XLF-273 Centro de Lavado a Gas 0 2,371.95 0.00\n", + "45 57690875 XTE-383 Rack Fijo 32/60 6 261.01 1,566.06\n", + "Total ingresado: 231,665.85\n", + "Total perdido por falta de stock: 61,736.20\n", + "========================================================================================================================\n", + "FECHA: 28/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 42157219 OTS-581 Galaxy Note 8.0 5 2,653.10 13,265.50\n", + "2 77484838 UWA-476 Autoradio MEX BT3150U 1 1,191.39 1,191.39\n", + "3 79464412 CJE-310 Mini componente GPX33 5 3,643.39 18,216.95\n", + "4 76388967 SJQ-827 Reproductor Multimedia Touch Screen 5 1,719.56 8,597.80\n", + "5 78922174 TKM-141 Cocina a gas Marsella 5 402.24 2,011.20\n", + "6 94080926 NMV-644 Lavadora Automatica 5 3,272.48 16,362.40\n", + "7 57263719 BWD-036 Cocina Empotrable Klimatica 3 1,086.34 3,259.02\n", + "8 17972674 ZWF-661 Impresora Led 1 2,731.61 2,731.61\n", + "9 89148118 XLF-273 Centro de Lavado a Gas 5 2,371.95 11,859.75\n", + "10 42928709 NSM-283 Cocina a gas FFG3053SL 5 936.81 4,684.05\n", + "11 57690875 CIM-038 Cocina Empotrable Petra 3 2,544.64 7,633.92\n", + "12 80048864 BCK-361 Tablets 10.1 1 1,872.53 1,872.53\n", + "13 59407188 BIT-434 Campana Extractora modelo Glass 6 375.09 2,250.54\n", + "14 32565207 FVQ-662 Cocina a gas Pro 6300 INOX 5 1,060.68 5,303.40\n", + "15 24995742 YMU-875 Cocina a gas Plermo Quarzo 3 3,232.10 9,696.30\n", + "16 89298238 QFP-254 Calentador electrico instantaneo 2 180.65 361.30\n", + "17 44679500 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", + "18 35584593 AVM-258 Cocina a gas Toscana 4 2,831.23 11,324.92\n", + "19 85871751 MYC-756 Cocina a gas Leganza INOX 2 1,506.80 3,013.60\n", + "20 43043986 QFP-254 Calentador electrico instantaneo 5 180.65 903.25\n", + "21 71463316 UWA-476 Autoradio MEX BT3150U 3 1,191.39 3,574.17\n", + "22 71378466 ARS-231 Audifonos Stereos 6 327.62 1,965.72\n", + "23 79475585 KQQ-136 Impresora Laser EPSON 6 1,139.56 6,837.36\n", + "24 32904023 KJX-387 Ventilador de techo 3 613.19 1,839.57\n", + "25 42157219 KCO-488 Ventilador de pared 2 679.60 1,359.20\n", + "26 71463316 BCN-855 Cocina a gas Bahia Can 4 4,015.92 16,063.68\n", + "27 66409237 UXG-019 Terma de acumulacion 4 934.91 3,739.64\n", + "28 23928045 OXP-732 Televisor OLED 4K UHD Google TV Smart 77 XR-77... 3 16,504.47 49,513.41\n", + "29 26233063 KSO-608 Secadora Modelo Italica 3 914.17 2,742.51\n", + "30 86241107 CIM-038 Cocina Empotrable Petra 0 2,544.64 0.00\n", + "31 35565959 DFJ-952 Cocina a gas Prestige 60 INOX 2 3,342.77 6,685.54\n", + "32 73786035 DEN-125 Rack Fijo 26/32 4 562.46 2,249.84\n", + "33 45828535 TZY-323 Terma a gas 6 2,341.01 14,046.06\n", + "34 26976877 SSE-115 Refrigeradora CoolStyle 311N Steel 4 3,243.58 12,974.32\n", + "35 80048864 PPX-620 Aire acondicionado tipo split 1 2,873.42 2,873.42\n", + "36 60574154 KDA-627 Cocina a gas Ijasmin 5 1,424.46 7,122.30\n", + "37 40112594 BCK-361 Tablets 10.1 0 1,872.53 0.00\n", + "38 79372768 QVJ-982 Horno Microondas 0.7 p3 6 1,352.76 8,116.56\n", + "39 43877279 QUU-384 Lavavajilla Blue Touch 0 2,545.54 0.00\n", + "40 69975105 HFM-021 Horno Electrico 3 726.91 2,180.73\n", + "41 43053402 FVQ-662 Cocina a gas Pro 6300 INOX 2 1,060.68 2,121.36\n", + "42 89863424 OTH-462 Lavadora Semi-Automatica 6 531.04 3,186.24\n", + "43 95161027 OQI-373 Cocina Empotrable Premio Plus 0 906.16 0.00\n", + "44 62324793 OPJ-039 Secadora de Ropa 2 2,765.64 5,531.28\n", + "Total ingresado: 279,262.34\n", + "Total perdido por falta de stock: 33,437.08\n", + "========================================================================================================================\n", + "FECHA: 29/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 98140264 DFF-034 Grabadora de voz digital portatil con USB inte... 2 259.25 518.50\n", + "2 25171011 VCL-867 Cocina a gas Rubi 2 3 699.07 2,097.21\n", + "3 76388967 EBI-299 Cocina a gas Fridare 5 2,287.57 11,437.85\n", + "4 16552775 CNN-411 Congeladora Side by Side 5 2,296.29 11,481.45\n", + "5 46462527 KWP-672 Televisor UHD TV 3 1,625.30 4,875.90\n", + "6 79464412 NSM-283 Cocina a gas FFG3053SL 2 936.81 1,873.62\n", + "7 52097922 OWN-701 Olla arrocera 2 220.82 441.64\n", + "8 71463316 KCO-488 Ventilador de pared 5 679.60 3,398.00\n", + "9 77642521 DFJ-952 Cocina a gas Prestige 60 INOX 5 3,342.77 16,713.85\n", + "10 53166028 QHC-492 Terma Solucion 1 1,907.23 1,907.23\n", + "11 45877001 PJG-338 Impresora Mutifuncional Inalambricar 2 1,067.80 2,135.60\n", + "12 77484838 UDR-957 Refrigeradora ECOTT 423 IXL 3 861.70 2,585.10\n", + "13 71463316 EBI-299 Cocina a gas Fridare 6 2,287.57 13,725.42\n", + "14 88956889 HFM-021 Horno Electrico 6 726.91 4,361.46\n", + "15 29847168 BCK-361 Tablets 10.1 0 1,872.53 0.00\n", + "16 55552996 SJD-818 Refrigeradora CoolStyle 281A Steel 1 3,387.75 3,387.75\n", + "17 87800799 WZD-331 Refrigeradora ECOTT 465 IX 0 1,213.79 0.00\n", + "18 43053402 VRR-793 Rack Giratorio 32/60 2 241.71 483.42\n", + "19 16151792 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", + "20 81114108 RBE-789 Televisor SMART TV 2 3,303.07 6,606.14\n", + "21 62324793 FQG-293 Rapiducha Premiun 1 2,784.31 2,784.31\n", + "22 87800799 BTO-226 Friobar 3 863.19 2,589.57\n", + "23 44229880 SNY-500 Cocina a gas Praga Quarzo 3 3,297.09 9,891.27\n", + "24 20864087 YUQ-590 Refrigeradora CoolStyle 395N Steel 5 1,979.07 9,895.35\n", + "25 31193794 BXY-119 Cocina Empotrable Klimatica 3 2,716.11 8,148.33\n", + "26 86241107 FEG-454 Sillon masajeador 2 1,695.70 3,391.40\n", + "27 95161027 FQG-293 Rapiducha Premiun 4 2,784.31 11,137.24\n", + "28 69639726 DON-719 Secadora de Cabello SG-3035 1 360.69 360.69\n", + "29 53166028 ONB-903 Reproductor BLU-RAY 3D 3 653.67 1,961.01\n", + "30 45828535 YMU-875 Cocina a gas Plermo Quarzo 5 3,232.10 16,160.50\n", + "31 71378466 XSD-310 Refrigeradora No frost 0 2,259.93 0.00\n", + "Total ingresado: 154,582.86\n", + "Total perdido por falta de stock: 16,512.12\n", + "========================================================================================================================\n", + "FECHA: 30/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 97403853 KQQ-136 Impresora Laser EPSON 6 1,139.56 6,837.36\n", + "2 50365593 AFL-718 Vinera 5 1,664.97 8,324.85\n", + "3 83505958 TYF-885 Videojuego TW 4 3 794.14 2,382.42\n", + "4 63437380 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", + "5 19829266 TXM-139 Televisor LED FULL HD 3D 3 1,092.95 3,278.85\n", + "6 32821689 ONB-903 Reproductor BLU-RAY 3D 3 653.67 1,961.01\n", + "7 96258632 QHC-492 Terma Solucion 2 1,907.23 3,814.46\n", + "8 69975105 WZD-331 Refrigeradora ECOTT 465 IX 1 1,213.79 1,213.79\n", + "9 79140840 OTH-462 Lavadora Semi-Automatica 1 531.04 531.04\n", + "10 87800799 GBD-525 Refrigeradora Puertas Mágicas 6 2,700.95 16,205.70\n", + "11 62566305 GXF-122 Televisor Ultra HDTV 5 1,110.16 5,550.80\n", + "12 42928709 QIL-029 Mini componente Shake-5 4 2,990.55 11,962.20\n", + "13 23928045 TKM-141 Cocina a gas Marsella 5 402.24 2,011.20\n", + "14 32565207 TKM-141 Cocina a gas Marsella 4 402.24 1,608.96\n", + "15 26290971 GKG-558 Horno Microondas MS2042D 3 1,674.24 5,022.72\n", + "16 86402303 RBE-789 Televisor SMART TV 6 3,303.07 19,818.42\n", + "17 48184351 KQA-580 Cocina Empotrable Glassy Plus 2 2,907.92 5,815.84\n", + "18 85949265 VRR-793 Rack Giratorio 32/60 5 241.71 1,208.55\n", + "19 15210391 DON-719 Secadora de Cabello SG-3035 2 360.69 721.38\n", + "20 89429489 VCL-867 Cocina a gas Rubi 2 5 699.07 3,495.35\n", + "21 35565959 JXD-139 Terma Evolucion Soltu 5 586.02 2,930.10\n", + "22 96659352 KQQ-136 Impresora Laser EPSON 2 1,139.56 2,279.12\n", + "23 62324793 XBD-314 Cocina a gas Fassina 3 1,444.90 4,334.70\n", + "24 89863424 QRC-609 Camara de video EOS 3 1,806.66 5,419.98\n", + "25 97403853 GBJ-693 Radio CD 0 314.20 0.00\n", + "26 73185299 AVM-258 Cocina a gas Toscana 3 2,831.23 8,493.69\n", + "27 15210391 AQS-362 Teclado Inalambrico USB 0 233.05 0.00\n", + "28 45877001 KBY-991 Home Theater E4100 6 1,101.08 6,606.48\n", + "Total ingresado: 131,828.97\n", + "Total perdido por falta de stock: 17,310.04\n", + "========================================================================================================================\n", + "FECHA: 31/08/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 35584593 SSD-176 Refrigeradora Linea Gallery 4 567.71 2,270.84\n", + "2 73185299 OTH-462 Lavadora Semi-Automatica 3 531.04 1,593.12\n", + "3 45783712 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1,979.07 3,958.14\n", + "4 62324793 LDR-510 Mini componente ESX9 1 2,701.87 2,701.87\n", + "5 37110873 QUU-384 Lavavajilla Blue Touch 1 2,545.54 2,545.54\n", + "6 71463316 AWT-354 Galaxy Gear 4 3,409.22 13,636.88\n", + "7 46462527 LWG-915 Cocina a gas Murano 6 1,101.47 6,608.82\n", + "8 87800799 VRR-793 Rack Giratorio 32/60 2 241.71 483.42\n", + "9 25171011 AWB-345 Deshumedecedor DM-189H 0 800.37 0.00\n", + "10 22777006 FCN-617 Televisor Plasma 60 1 4,121.05 4,121.05\n", + "11 90237332 QFP-254 Calentador electrico instantaneo 3 180.65 541.95\n", + "12 48467976 JDQ-505 Lavadora Modelo Aquamatic 5 1,572.31 7,861.55\n", + "13 45828535 XSD-310 Refrigeradora No frost 4 2,259.93 9,039.72\n", + "14 90365520 KBY-991 Home Theater E4100 6 1,101.08 6,606.48\n", + "15 54716824 UDR-957 Refrigeradora ECOTT 423 IXL 1 861.70 861.70\n", + "16 37110873 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 4 1,095.67 4,382.68\n", + "17 54716824 ZEX-027 Tablet Xperia Z 6 3,843.75 23,062.50\n", + "18 81114108 DFF-034 Grabadora de voz digital portatil con USB inte... 5 259.25 1,296.25\n", + "19 64394265 OFS-384 Parlantes Bluetooth 4 805.22 3,220.88\n", + "20 42798099 CNN-411 Congeladora Side by Side 6 2,296.29 13,777.74\n", + "21 13245501 QIL-029 Mini componente Shake-5 2 2,990.55 5,981.10\n", + "22 86402303 HFM-021 Horno Electrico 6 726.91 4,361.46\n", + "23 89148118 EBI-299 Cocina a gas Fridare 0 2,287.57 0.00\n", + "24 87813843 OQI-373 Cocina Empotrable Premio Plus 1 906.16 906.16\n", + "25 93845419 QIL-029 Mini componente Shake-5 5 2,990.55 14,952.75\n", + "26 67418025 FEG-454 Sillon masajeador 2 1,695.70 3,391.40\n", + "27 69975105 TMJ-043 Lavadora EcoBubble 6 2,400.79 14,404.74\n", + "28 97403853 YJD-279 Cocina a gas Florencia 3 1,028.43 3,085.29\n", + "Total ingresado: 155,654.03\n", + "Total perdido por falta de stock: 29,960.03\n", + "========================================================================================================================\n", + "FECHA: 01/09/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 28390487 GLC-370 Video Proyector Power Lite 95 2 552.24 1,104.48\n", + "2 84165595 DFJ-952 Cocina a gas Prestige 60 INOX 1 3,342.77 3,342.77\n", + "3 50365593 LWG-915 Cocina a gas Murano 3 1,101.47 3,304.41\n", + "4 83236386 UJV-290 Cocina a gas Fassina Plus 5 2,423.26 12,116.30\n", + "5 73185299 QHC-492 Terma Solucion 3 1,907.23 5,721.69\n", + "6 13245501 VXS-438 Mouse Blue Tooth 3 60.11 180.33\n", + "7 42798099 TMN-884 Secadora de mano 5 310.65 1,553.25\n", + "8 32904023 DUG-251 Cocina a gas FFG3047SL 4 1,597.96 6,391.84\n", + "9 96659352 ADX-669 Refrigeradora cap. 220 litros 4 1,239.38 4,957.52\n", + "10 89148118 AFL-718 Vinera 0 1,664.97 0.00\n", + "11 77191257 QVJ-982 Horno Microondas 0.7 p3 5 1,352.76 6,763.80\n", + "12 91897732 XZR-640 Lavadora-Secadora FWD 5 2,390.58 11,952.90\n", + "13 93160528 YYU-726 Reproductor DVD Portatil 1 767.82 767.82\n", + "14 89298238 UJV-290 Cocina a gas Fassina Plus 4 2,423.26 9,693.04\n", + "15 43488351 DIQ-718 Horno Microondas de Conveccion Cello 0 390.80 0.00\n", + "16 78078115 FQG-293 Rapiducha Premiun 4 2,784.31 11,137.24\n", + "17 43043986 SSD-176 Refrigeradora Linea Gallery 5 567.71 2,838.55\n", + "18 40348917 BMJ-772 Refrigeradora Side by Side 1 936.32 936.32\n", + "19 78922174 XBD-314 Cocina a gas Fassina 3 1,444.90 4,334.70\n", + "20 35565959 BZS-261 Cocina a gas Trento 1 3,087.87 3,087.87\n", + "21 87813843 XSD-310 Refrigeradora No frost 3 2,259.93 6,779.79\n", + "22 17913944 DEN-125 Rack Fijo 26/32 1 562.46 562.46\n", + "23 79420973 SSE-115 Refrigeradora CoolStyle 311N Steel 5 3,243.58 16,217.90\n", + "24 16151792 IDO-503 Laptop GamerVictus de 15.6 6 3,935.17 23,611.02\n", + "25 22280452 UCX-285 Galaxy Tab 3 3 3,290.93 9,872.79\n", + "26 71984468 TZY-323 Terma a gas 1 2,341.01 2,341.01\n", + "27 19829266 RDT-761 Horno Microondas con dorador 3 904.95 2,714.85\n", + "28 86241107 UXG-019 Terma de acumulacion 2 934.91 1,869.82\n", + "29 84165595 HFM-021 Horno Electrico 6 726.91 4,361.46\n", + "30 31611146 FVQ-662 Cocina a gas Pro 6300 INOX 4 1,060.68 4,242.72\n", + "31 77191257 ZEX-027 Tablet Xperia Z 6 3,843.75 23,062.50\n", + "32 41036366 QVJ-982 Horno Microondas 0.7 p3 1 1,352.76 1,352.76\n", + "33 79140840 JXD-139 Terma Evolucion Soltu 4 586.02 2,344.08\n", + "34 49087435 III-576 Campana Extractora Venus Plus 2 1,077.65 2,155.30\n", + "Total ingresado: 191,673.29\n", + "Total perdido por falta de stock: 8,068.05\n", + "========================================================================================================================\n", + "FECHA: 02/09/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 86828079 QIL-029 Mini componente Shake-5 5 2,990.55 14,952.75\n", + "2 79901434 OBI-353 Terma Milenium 6 2,960.56 17,763.36\n", + "3 20864087 BXY-119 Cocina Empotrable Klimatica 4 2,716.11 10,864.44\n", + "4 37110873 SSD-176 Refrigeradora Linea Gallery 1 567.71 567.71\n", + "5 41036366 SJD-818 Refrigeradora CoolStyle 281A Steel 4 3,387.75 13,551.00\n", + "6 98140264 BRD-969 Centro de Lavado Electrico 1 2,579.72 2,579.72\n", + "7 84165595 RDT-761 Horno Microondas con dorador 6 904.95 5,429.70\n", + "8 50365593 JDC-028 Puntero Laser 6 30.48 182.88\n", + "9 15210391 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", + "10 95161027 III-576 Campana Extractora Venus Plus 5 1,077.65 5,388.25\n", + "11 20864087 JFC-432 DVD DVM-L79 1 307.67 307.67\n", + "12 50375303 AFL-718 Vinera 1 1,664.97 1,664.97\n", + "13 42928709 OQI-373 Cocina Empotrable Premio Plus 5 906.16 4,530.80\n", + "14 43053402 MMA-577 Congeladora Horizontal 252 Lts. 6 1,780.30 10,681.80\n", + "15 78922174 EJW-346 Campana Extractora 6 359.70 2,158.20\n", + "16 98140264 CJE-310 Mini componente GPX33 3 3,643.39 10,930.17\n", + "17 94080926 TXM-139 Televisor LED FULL HD 3D 2 1,092.95 2,185.90\n", + "18 20864087 JDQ-505 Lavadora Modelo Aquamatic 6 1,572.31 9,433.86\n", + "19 66409237 DFF-034 Grabadora de voz digital portatil con USB inte... 4 259.25 1,037.00\n", + "20 66409237 AWT-354 Galaxy Gear 6 3,409.22 20,455.32\n", + "21 88956889 MYC-756 Cocina a gas Leganza INOX 4 1,506.80 6,027.20\n", + "22 24995742 DON-719 Secadora de Cabello SG-3035 3 360.69 1,082.07\n", + "23 88956889 UWA-476 Autoradio MEX BT3150U 6 1,191.39 7,148.34\n", + "24 32904023 QFP-254 Calentador electrico instantaneo 4 180.65 722.60\n", + "25 89298238 YOT-530 Deshumedecedor DM-190H 4 941.73 3,766.92\n", + "26 79372768 GLC-370 Video Proyector Power Lite 95 4 552.24 2,208.96\n", + "27 32821689 MTF-868 Impresora Monocromatica WorkForce M205 4 971.59 3,886.36\n", + "28 59407188 LYZ-614 Impresore Mutifuncional Expression XP-211 3 3,510.84 10,532.52\n", + "29 55552996 QTK-083 Congeladora Conservador Vertical 476 Lts. 1 2,682.73 2,682.73\n", + "30 50365593 TMN-884 Secadora de mano 0 310.65 0.00\n", + "31 15210391 VXS-438 Mouse Blue Tooth 4 60.11 240.44\n", + "32 33397650 VJI-529 Horno Empotrable Electrico 6 1,102.67 6,616.02\n", + "33 13245501 BXY-119 Cocina Empotrable Klimatica 5 2,716.11 13,580.55\n", + "34 69324480 DIQ-718 Horno Microondas de Conveccion Cello 0 390.80 0.00\n", + "35 78078115 DFJ-952 Cocina a gas Prestige 60 INOX 5 3,342.77 16,713.85\n", + "36 29337157 HFM-021 Horno Electrico 4 726.91 2,907.64\n", + "37 77191257 KWP-672 Televisor UHD TV 2 1,625.30 3,250.60\n", + "38 89863424 FVB-607 Cocina a gas Essenza BL 1 2,953.07 2,953.07\n", + "39 79420973 GXF-122 Televisor Ultra HDTV 3 1,110.16 3,330.48\n", + "40 33713901 UWA-476 Autoradio MEX BT3150U 2 1,191.39 2,382.78\n", + "41 90237332 TKM-141 Cocina a gas Marsella 3 402.24 1,206.72\n", + "42 89429489 BXY-119 Cocina Empotrable Klimatica 0 2,716.11 0.00\n", + "43 90365520 VDD-853 Deshumedecedor FAD30D7TSSW 3.4L 25-30m2 5 1,095.67 5,478.35\n", + "44 79372768 EUZ-452 Impresora Mutifuncional Led Color 3 3,623.88 10,871.64\n", + "45 53166028 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", + "46 45783712 SSD-176 Refrigeradora Linea Gallery 2 567.71 1,135.42\n", + "47 57263719 DOV-560 Impresora Laser Mutifuncion Monocromatica 1 1,203.14 1,203.14\n", + "48 40348917 DFJ-952 Cocina a gas Prestige 60 INOX 1 3,342.77 3,342.77\n", + "49 79140840 QRC-609 Camara de video EOS 5 1,806.66 9,033.30\n", + "Total ingresado: 263,993.00\n", + "Total perdido por falta de stock: 34,403.11\n", + "========================================================================================================================\n", + "FECHA: 03/09/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 50375303 CRU-009 Lavavajilla 5 2,655.78 13,278.90\n", + "2 26290971 PVZ-181 Ventilador circular 3 309.77 929.31\n", + "3 73535476 FLJ-040 Parlantes portatiles SOUNDSHOOTER 4 3,703.37 14,813.48\n", + "4 16552775 AWB-345 Deshumedecedor DM-189H 5 800.37 4,001.85\n", + "5 73535476 UWA-476 Autoradio MEX BT3150U 5 1,191.39 5,956.95\n", + "6 95751208 UOD-420 Mini componente ESX6 4 828.94 3,315.76\n", + "7 15561764 GBJ-693 Radio CD 2 314.20 628.40\n", + "8 43043986 ZEX-027 Tablet Xperia Z 1 3,843.75 3,843.75\n", + "9 96258632 CRU-009 Lavavajilla 0 2,655.78 0.00\n", + "10 79901434 ZEX-027 Tablet Xperia Z 2 3,843.75 7,687.50\n", + "11 12663268 YYU-726 Reproductor DVD Portatil 4 767.82 3,071.28\n", + "12 71378466 FVQ-662 Cocina a gas Pro 6300 INOX 2 1,060.68 2,121.36\n", + "13 26976877 VTV-269 Extractor de aire 4 854.48 3,417.92\n", + "14 42798099 OQI-373 Cocina Empotrable Premio Plus 2 906.16 1,812.32\n", + "15 23928045 TMN-884 Secadora de mano 2 310.65 621.30\n", + "16 69324480 UOD-420 Mini componente ESX6 3 828.94 2,486.82\n", + "17 59407188 OWN-701 Olla arrocera 1 220.82 220.82\n", + "18 57263719 OTH-462 Lavadora Semi-Automatica 5 531.04 2,655.20\n", + "19 37110873 FCN-617 Televisor Plasma 60 5 4,121.05 20,605.25\n", + "20 96659352 GBJ-693 Radio CD 3 314.20 942.60\n", + "21 52097922 UTN-601 Autoradio XAV-601 BT 2 562.51 1,125.02\n", + "22 79901434 CSZ-863 Video Filmadora 5 1,713.57 8,567.85\n", + "23 89429489 UXG-019 Terma de acumulacion 0 934.91 0.00\n", + "24 52097922 XSD-310 Refrigeradora No frost 2 2,259.93 4,519.86\n", + "25 33713901 VVS-017 Tablets MW 0731 1 2,599.72 2,599.72\n", + "26 62566305 AVM-258 Cocina a gas Toscana 1 2,831.23 2,831.23\n", + "27 32904023 RBE-789 Televisor SMART TV 6 3,303.07 19,818.42\n", + "28 99842319 DUG-251 Cocina a gas FFG3047SL 1 1,597.96 1,597.96\n", + "29 40112594 FVQ-662 Cocina a gas Pro 6300 INOX 0 1,060.68 0.00\n", + "30 16151792 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", + "31 52097922 XZG-521 Secadora Electrica FAQE7001LW 4 704.27 2,817.08\n", + "32 54761731 OTS-581 Galaxy Note 8.0 5 2,653.10 13,265.50\n", + "Total ingresado: 149,786.46\n", + "Total perdido por falta de stock: 26,048.29\n", + "========================================================================================================================\n", + "FECHA: 04/09/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 33397650 IHG-413 Parlant Y pedestal PAM-83 3 317.70 953.10\n", + "2 69324480 JCW-489 Conservadora Exibidora CMVE-250 5 2,064.97 10,324.85\n", + "3 50375303 KQA-580 Cocina Empotrable Glassy Plus 5 2,907.92 14,539.60\n", + "4 32565207 IDO-503 Laptop GamerVictus de 15.6 6 3,935.17 23,611.02\n", + "5 63437380 III-576 Campana Extractora Venus Plus 5 1,077.65 5,388.25\n", + "6 91897732 TMN-884 Secadora de mano 2 310.65 621.30\n", + "7 31611146 YOT-530 Deshumedecedor DM-190H 4 941.73 3,766.92\n", + "8 85949265 JFC-432 DVD DVM-L79 4 307.67 1,230.68\n", + "9 12663268 RAH-420 Cocina a gas Pro 6550 INOX 3 157.01 471.03\n", + "10 88956889 YUQ-590 Refrigeradora CoolStyle 395N Steel 2 1,979.07 3,958.14\n", + "11 38913831 BCN-855 Cocina a gas Bahia Can 3 4,015.92 12,047.76\n", + "12 44229880 JXD-139 Terma Evolucion Soltu 4 586.02 2,344.08\n", + "13 42928709 XLF-273 Centro de Lavado a Gas 4 2,371.95 9,487.80\n", + "14 88956889 UWA-476 Autoradio MEX BT3150U 3 1,191.39 3,574.17\n", + "15 66409237 BRD-969 Centro de Lavado Electrico 3 2,579.72 7,739.16\n", + "16 42928709 QFP-254 Calentador electrico instantaneo 5 180.65 903.25\n", + "17 26233063 UWA-476 Autoradio MEX BT3150U 1 1,191.39 1,191.39\n", + "18 35565959 QRC-609 Camara de video EOS 5 1,806.66 9,033.30\n", + "19 50375303 YJD-279 Cocina a gas Florencia 5 1,028.43 5,142.15\n", + "20 27912250 QFR-958 Cocina a gas Bavaro 3 1,607.46 4,822.38\n", + "21 88995291 MTF-868 Impresora Monocromatica WorkForce M205 0 971.59 0.00\n", + "22 69975105 FQG-293 Rapiducha Premiun 5 2,784.31 13,921.55\n", + "23 76388967 PFD-286 Refrigeradora cap. 415 litros 2 2,776.02 5,552.04\n", + "24 77191257 ZWF-661 Impresora Led 0 2,731.61 0.00\n", + "25 91897732 PFD-286 Refrigeradora cap. 415 litros 0 2,776.02 0.00\n", + "26 36380447 HLR-109 Parlantes inalambricos 2 439.47 878.94\n", + "27 50375303 VXS-438 Mouse Blue Tooth 4 60.11 240.44\n", + "28 25171011 DFJ-952 Cocina a gas Prestige 60 INOX 4 3,342.77 13,371.08\n", + "29 48184351 TXM-139 Televisor LED FULL HD 3D 0 1,092.95 0.00\n", + "30 45783712 YMU-875 Cocina a gas Plermo Quarzo 1 3,232.10 3,232.10\n", + "31 94080926 SPR-580 Dispensador de Agua 5 404.35 2,021.75\n", + "Total ingresado: 160,368.23\n", + "Total perdido por falta de stock: 41,286.58\n", + "========================================================================================================================\n", + "FECHA: 05/09/2023\n", + " client_id product_id product_name qty_served price total\n", + "1 60574154 BWD-036 Cocina Empotrable Klimatica 2 1,086.34 2,172.68\n", + "2 13245501 XOA-735 Congeladora Vertical 392 Lts. 5 2,708.07 13,540.35\n", + "3 46462527 KCO-488 Ventilador de pared 4 679.60 2,718.40\n", + "4 93845419 CIM-038 Cocina Empotrable Petra 5 2,544.64 12,723.20\n", + "5 63437380 KQA-580 Cocina Empotrable Glassy Plus 2 2,907.92 5,815.84\n", + "6 54716824 SPR-580 Dispensador de Agua 3 404.35 1,213.05\n", + "7 55552996 UXG-019 Terma de acumulacion 6 934.91 5,609.46\n", + "8 42798099 AQS-362 Teclado Inalambrico USB 1 233.05 233.05\n", + "9 80048864 RDT-761 Horno Microondas con dorador 5 904.95 4,524.75\n", + "10 43877279 TYF-885 Videojuego TW 4 0 794.14 0.00\n", + "11 98589725 VRR-793 Rack Giratorio 32/60 1 241.71 241.71\n", + "12 22280452 XSD-310 Refrigeradora No frost 2 2,259.93 4,519.86\n", + "13 16151792 TZY-323 Terma a gas 3 2,341.01 7,023.03\n", + "14 89298238 JXD-139 Terma Evolucion Soltu 3 586.02 1,758.06\n", + "15 12663268 BMJ-772 Refrigeradora Side by Side 1 936.32 936.32\n", + "16 64394265 YUQ-590 Refrigeradora CoolStyle 395N Steel 1 1,979.07 1,979.07\n", + "17 76388967 DOV-560 Impresora Laser Mutifuncion Monocromatica 2 1,203.14 2,406.28\n", + "18 69324480 VJI-529 Horno Empotrable Electrico 1 1,102.67 1,102.67\n", + "19 73914283 BRD-969 Centro de Lavado Electrico 3 2,579.72 7,739.16\n", + "20 62566305 CNQ-172 Congeladora Horizontal 364 Lts. 3 3,689.62 11,068.86\n", + "21 13245501 KJX-387 Ventilador de techo 0 613.19 0.00\n", + "22 89298238 ICX-503 Cocina a gas Roma 3 1,221.02 3,663.06\n", + "23 67418025 YYU-726 Reproductor DVD Portatil 6 767.82 4,606.92\n", + "Total ingresado: 95,595.78\n", + "Total perdido por falta de stock: 7,036.65\n", + "========================================================================================================================\n" + ] + } + ], + "source": [ + "# reporte\n", + "\n", + "df = pedidos.merge(productos, how='left', on='product_id')\n", + "\n", + "for date, t in df.groupby(\"date\"):\n", + " print(\"FECHA: \", date.strftime('%d/%m/%Y'))\n", + " t.index = t.reset_index().index + 1\n", + " t['total'] = t['qty_served'] * t['price']\n", + " print(t[['client_id', 'product_id', 'product_name', 'qty_served', 'price', 'total']])\n", + "\n", + " served_income = sum(t['total'])\n", + " not_served_income = sum((t['qty'] - t['qty_served']) * t['price'])\n", + " print(f\"Total ingresado: {served_income:,.2f}\")\n", + " print(f\"Total perdido por falta de stock: {not_served_income:,.2f}\")\n", + " print('========================================================================================================================')" + ] + }, + { + "cell_type": "code", + "execution_count": 8, + "metadata": {}, + "outputs": [ + { + "data": { + "text/html": [ + "<div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>product_name</th>\n", + " <th>price</th>\n", + " <th>stock</th>\n", + " </tr>\n", + " <tr>\n", + " <th>product_id</th>\n", + " <th></th>\n", + " <th></th>\n", + " <th></th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>BIT-434</th>\n", + " <td>Campana Extractora modelo Glass</td>\n", + " <td>375.09</td>\n", + " <td>0</td>\n", + " </tr>\n", + " <tr>\n", + " <th>SSE-115</th>\n", + " <td>Refrigeradora CoolStyle 311N Steel</td>\n", + " <td>3,243.58</td>\n", + " <td>10</td>\n", + " </tr>\n", + " <tr>\n", + " <th>NMV-644</th>\n", + " <td>Lavadora Automatica</td>\n", + " <td>3,272.48</td>\n", + " <td>0</td>\n", + " </tr>\n", + " <tr>\n", + " <th>MLE-193</th>\n", + " <td>Cocina a gas Ingenious</td>\n", + " <td>2,779.41</td>\n", + " <td>6</td>\n", + " </tr>\n", + " <tr>\n", + " <th>YYK-309</th>\n", + " <td>Refrigeradora Door in Door</td>\n", + " <td>4,079.44</td>\n", + " <td>13</td>\n", + " </tr>\n", + " <tr>\n", + " <th>...</th>\n", + " <td>...</td>\n", + " <td>...</td>\n", + " <td>...</td>\n", + " </tr>\n", + " <tr>\n", + " <th>QFP-254</th>\n", + " <td>Calentador electrico instantaneo</td>\n", + " <td>180.65</td>\n", + " <td>0</td>\n", + " </tr>\n", + " <tr>\n", + " <th>DUG-251</th>\n", + " <td>Cocina a gas FFG3047SL</td>\n", + " <td>1,597.96</td>\n", + " <td>0</td>\n", + " </tr>\n", + " <tr>\n", + " <th>III-576</th>\n", + " <td>Campana Extractora Venus Plus</td>\n", + " <td>1,077.65</td>\n", + " <td>5</td>\n", + " </tr>\n", + " <tr>\n", + " <th>IHG-413</th>\n", + " <td>Parlant Y pedestal PAM-83</td>\n", + " <td>317.70</td>\n", + " <td>6</td>\n", + " </tr>\n", + " <tr>\n", + " <th>QQB-968</th>\n", + " <td>Refrigeradora 484 litros</td>\n", + " <td>1,452.92</td>\n", + " <td>9</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "<p>167 rows × 3 columns</p>\n", + "</div>" + ], + "text/plain": [ + " product_name price stock\n", + "product_id \n", + "BIT-434 Campana Extractora modelo Glass 375.09 0\n", + "SSE-115 Refrigeradora CoolStyle 311N Steel 3,243.58 10\n", + "NMV-644 Lavadora Automatica 3,272.48 0\n", + "MLE-193 Cocina a gas Ingenious 2,779.41 6\n", + "YYK-309 Refrigeradora Door in Door 4,079.44 13\n", + "... ... ... ...\n", + "QFP-254 Calentador electrico instantaneo 180.65 0\n", + "DUG-251 Cocina a gas FFG3047SL 1,597.96 0\n", + "III-576 Campana Extractora Venus Plus 1,077.65 5\n", + "IHG-413 Parlant Y pedestal PAM-83 317.70 6\n", + "QQB-968 Refrigeradora 484 litros 1,452.92 9\n", + "\n", + "[167 rows x 3 columns]" + ] + }, + "execution_count": 8, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "productos" + ] + } + ], + "metadata": { + "kernelspec": { + "display_name": "Python 3 (ipykernel)", + "language": "python", + "name": "python3" + }, + "language_info": { + "codemirror_mode": { + "name": "ipython", + "version": 3 + }, + "file_extension": ".py", + "mimetype": "text/x-python", + "name": "python", + "nbconvert_exporter": "python", + "pygments_lexer": "ipython3", + "version": "3.11.5" + } + }, + "nbformat": 4, + "nbformat_minor": 4 +} |