DELETE FROM rotacionproducto WHERE bodegaid = 742 AND codperiodo = '122025';
INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('46716','742','122025','0.083333333333334','0.9666666666666665','207000')
				,('43180','742','122025','0.125','0.5625','196200')
				,('31129','742','122025','1','-1','189000')
				,('23812','742','122025','0.077777777777777','0.03333332803515233','183500')
				,('63445','742','122025','0.1','0.5099999904632532','173500')
				,('28755','742','122025','1','0','165900')
				,('52342','742','122025','1','3','165200')
				,('33603','742','122025','2','0','160900')
				,('43290','742','122025','0.1','0.1600000071525534','156100')
				,('65669','742','122025','1','0','154400')
				,('43524','742','122025','0.1','0.750000001490116','151800')
				,('61831','742','122025','1','0','151200')
				,('61835','742','122025','1','1','145000')
				,('55782','742','122025','0.066666666666666','0.4666666805744383','135000')
				,('60315','742','122025','1','0','127800')
				,('26533','742','122025','0.14','0.9799999999999986','127000')
				,('32976','742','122025','0.66666666666667','2','126400')
				,('43283','742','122025','0.40625','1.40625','122200')
				,('31759','742','122025','0.533333333333331','1.7333333373070046','119700')
				,('57515','742','122025','1','0','111500')
				,('37241','742','122025','0.16666666666667','0.9444444444444208','111000')
				,('22870','742','122025','0.19999999999999998','0.9799999999999999','110000')
				,('25533','742','122025','0.66666666666666','0.3333333432674603','105800')
				,('39853','742','122025','0.285714285714283','0.7142857412497511','103000')
				,('46090','742','122025','0.083333333333334','1.1666666666666456','102500')
				,('60645','742','122025','3','3','102000')
				,('62772','742','122025','0.125','0.6249999999999964','100500')
				,('28973','742','122025','0.33333333333333','0.16666664679844628','96600')
				,('52400','742','122025','3','0','94100')
				,('44302','742','122025','0.43333333333333','1.1666666666666683','91500')
				,('22304','742','122025','1','1','91200')
				,('55304','742','122025','0.1','0.799999999999997','90000')
				,('46696','742','122025','0.2','1.2999999999999996','89200')
				,('66237','742','122025','1','1','89100')
				,('49672','742','122025','0.33333333333333504','0.6666666666666612','87000')
				,('50187','742','122025','1','4','85200')
				,('22305','742','122025','1','3','84000')
				,('48571','742','122025','0.6000000000000001','1.800000023841858','84000')
				,('56752','742','122025','2','14','82700')
				,('41855','742','122025','2.400000000000001','6.800000010430934','81500')
				,('61315','742','122025','0.1','2.4000000000000004','80000')
				,('55996','742','122025','0.2','1.0000000029802305','80000')
				,('32586','742','122025','2','7','78600')
				,('48240','742','122025','2','4','78500')
				,('55995','742','122025','0.5833333333333429','1.6666666666666432','78000')
				,('51396','742','122025','2','0','77800')
				,('31775','742','122025','0.1','1.3000000029802314','77500')
				,('22729','742','122025','2','3','77300')
				,('53058','742','122025','0.33333333333333','1.66666666666667','76700')
				,('38457','742','122025','2','4','76400')
					,('48906','742','122025','1','2','75500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('61909','742','122025','1','2','75200')
				,('29755','742','122025','0.12','0.4400000071525572','75000')
				,('55343','742','122025','0.1','0.4999999776482553','74800')
				,('33743','742','122025','0.041666666666667','0.5416666616995798','74700')
				,('56587','742','122025','3','5','74500')
				,('46895','742','122025','0.099999999999999','0.30000000198684507','73600')
				,('61384','742','122025','0.045454545454545','0.863636374473602','72100')
				,('53073','742','122025','1','0','70000')
				,('38410','742','122025','1','6','68900')
				,('33403','742','122025','3','6.5','68700')
				,('52935','742','122025','1','0','68400')
				,('40253','742','122025','0.83333333333333','2.166666674117334','67900')
				,('65832','742','122025','0.083333333333334','3.041666666666654','66000')
				,('47190','742','122025','1','0','66000')
				,('62346','742','122025','0.125','0.24999999503293252','66000')
				,('22302','742','122025','1','3','64900')
				,('58898','742','122025','0.599999999999999','1.5333333571751315','64500')
				,('41556','742','122025','0.2','1','64500')
				,('41955','742','122025','1','2','64300')
				,('22880','742','122025','0.16','0.4400000059604602','63500')
				,('54420','742','122025','1','3','63000')
				,('50913','742','122025','4','8','62600')
				,('58357','742','122025','2','6','60700')
				,('41900','742','122025','0.33333333333333504','0.9999999999999938','59700')
				,('51946','742','122025','6','16','59500')
				,('65001','742','122025','0.5','0.9999999999999994','58000')
				,('43362','742','122025','0.1','0','57200')
				,('42677','742','122025','1','0','56000')
				,('56535','742','122025','0.8999999999999999','3.9999998807907207','55500')
				,('58540','742','122025','0.1','1.0999999880790643','55500')
				,('58572','742','122025','0.1','0','55500')
				,('31286','742','122025','0.4','0.39999999999999764','55000')
				,('61904','742','122025','1','1','54500')
				,('61606','742','122025','1','1','54500')
				,('58101','742','122025','8','18','54100')
				,('61766','742','122025','5','9','53500')
				,('39840','742','122025','0.30000000000000004','0.4999999999999999','52300')
				,('32981','742','122025','0.33333333333333','2.00000000000001','52100')
				,('58109','742','122025','2','1','51300')
				,('25348','742','122025','1','0','51200')
				,('38366','742','122025','6','7','51200')
				,('50162','742','122025','0.16666666666667','1.4999999801317687','51000')
				,('57616','742','122025','1','1','51000')
				,('54056','742','122025','0.4','2.5999999999999996','50600')
				,('62033','742','122025','2','0','50200')
				,('55738','742','122025','4','19','49600')
				,('37243','742','122025','1','1','49500')
				,('58292','742','122025','1','1','49500')
				,('55810','742','122025','0.22222222222222','1.0000000000000195','48900')
				,('29001','742','122025','1','0','48200')
					,('63441','742','122025','0.250000000000002','1.333333333333325','48000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('63438','742','122025','0.166666666666667','0.6666666666666536','48000')
				,('46345','742','122025','1','-1','48000')
				,('63439','742','122025','0.24999999999999997','0','48000')
				,('62646','742','122025','1','1','47400')
				,('61062','742','122025','1','1','46000')
				,('42083','742','122025','1','-1','45600')
				,('43224','742','122025','8','11','45300')
				,('22930','742','122025','0.033333333333333','0','44800')
				,('55727','742','122025','2','13','44700')
				,('34283','742','122025','1','1','44400')
				,('50766','742','122025','1','3','43800')
				,('42901','742','122025','1','0','43500')
				,('62528','742','122025','2','2','42900')
				,('48941','742','122025','1','2','42900')
				,('53687','742','122025','2','1','42500')
				,('57424','742','122025','1','0','41600')
				,('52675','742','122025','1','1','41500')
				,('46495','742','122025','1','3','41400')
				,('22741','742','122025','1','1','41200')
				,('47275','742','122025','1','1','41100')
				,('24327','742','122025','1','0','40700')
				,('53948','742','122025','0.733333333333327','3.100000000000047','39600')
				,('54476','742','122025','1.1666666666666698','0.6666666666666289','39600')
				,('31190','742','122025','0.2','1.6','39100')
				,('48643','742','122025','0.33333333333334','3.1666666467981077','38000')
				,('58026','742','122025','1','1','37900')
				,('23565','742','122025','0.1','0.9000000000000014','37800')
				,('43221','742','122025','2','18','37500')
				,('46776','742','122025','2.333333333333342','0.9999999999999911','35900')
				,('43162','742','122025','0.25','1.5','35800')
				,('59982','742','122025','0.166666666666666','0.49999999999999406','35700')
				,('62671','742','122025','1','3','35200')
				,('26122','742','122025','0.1','0.8499999970197677','34000')
				,('51304','742','122025','3','0','33300')
				,('23849','742','122025','1','0','33000')
				,('54285','742','122025','1','0.5999999999999996','32900')
				,('45938','742','122025','4','-1','32900')
				,('46791','742','122025','2','1','32700')
				,('46200','742','122025','0.5833333333333349','2.8333333383003168','32500')
				,('54824','742','122025','1','0','32500')
				,('54477','742','122025','1','2','31400')
				,('54482','742','122025','1','3','30800')
				,('51697','742','122025','1','0','30500')
				,('45886','742','122025','0.1','0.04999998807907344','30000')
				,('33560','742','122025','1','1','29900')
				,('38369','742','122025','2','12','28900')
				,('22981','742','122025','1','0','28800')
				,('24440','742','122025','1','1','28500')
				,('38373','742','122025','1','-1','28400')
				,('26243','742','122025','0.33333333333333','0.6666666766008014','28000')
					,('32974','742','122025','2','3','27800');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('60637','742','122025','1','2','27800')
				,('53544','742','122025','1','1','26900')
				,('53074','742','122025','0.5','4.625','26500')
				,('36584','742','122025','1','4','26500')
				,('31416','742','122025','1','1','26400')
				,('31615','742','122025','1','0','26000')
				,('45871','742','122025','1','1','25900')
				,('53327','742','122025','1','1','25800')
				,('34273','742','122025','1','5','25800')
				,('53835','742','122025','0.7','2.9999999999999964','25300')
				,('57163','742','122025','2','0','25200')
				,('45897','742','122025','2','3','25200')
				,('46328','742','122025','0.18','1.3799999999999921','25000')
				,('31151','742','122025','0.8999999999999999','4.8000000119210835','25000')
				,('65857','742','122025','2','5','24900')
				,('58355','742','122025','2','6','24900')
				,('32908','742','122025','1','2','23900')
				,('51303','742','122025','1','2','23900')
				,('53149','742','122025','1','0','23200')
				,('33251','742','122025','6','5','22800')
				,('43229','742','122025','1','3','22800')
				,('60273','742','122025','3','3','22600')
				,('23704','742','122025','0.2','3.80000000298019','22500')
				,('31502','742','122025','0.42000000000000004','2.299999999999996','22500')
				,('63778','742','122025','3','15','22500')
				,('32849','742','122025','2','2','22000')
				,('40254','742','122025','1','4','21800')
				,('23550','742','122025','2','0','21500')
				,('54469','742','122025','2','7','21300')
				,('47121','742','122025','1','2','21000')
				,('31230','742','122025','1','1','21000')
				,('46294','742','122025','2','5','21000')
				,('56951','742','122025','1','4','21000')
				,('38992','742','122025','0.1','4.199999999999997','20700')
				,('38465','742','122025','4','14','20600')
				,('57148','742','122025','1','2','20600')
				,('48394','742','122025','1','0','20500')
				,('63747','742','122025','1','2','20300')
				,('42931','742','122025','1','2','20100')
				,('64514','742','122025','0.6','1.9999999880790749','20000')
				,('43549','742','122025','0.5','14','19900')
				,('38462','742','122025','1','-1','19900')
				,('47398','742','122025','1','1','19900')
				,('40547','742','122025','1','18','19700')
				,('39044','742','122025','2','3','19700')
				,('33646','742','122025','0.5','0.5','19300')
				,('49874','742','122025','0.5','2','19300')
				,('52691','742','122025','1','1','19100')
				,('29913','742','122025','1','0','18900')
				,('54826','742','122025','1','-1','18700')
					,('63519','742','122025','1','2','18600');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('58868','742','122025','6','2','18500')
				,('31699','742','122025','7','20','18500')
				,('43203','742','122025','2','5','18300')
				,('39151','742','122025','1','6','18200')
				,('39150','742','122025','1','1','18200')
				,('60970','742','122025','2','3.5','18000')
				,('66369','742','122025','0.33333333333333','0.3333333333333503','18000')
				,('23820','742','122025','0.1','3.0000000119209287','18000')
				,('24352','742','122025','1','0','17700')
				,('43299','742','122025','0.75','1.5','17600')
				,('61024','742','122025','1','1','17500')
				,('51392','742','122025','1','0','17500')
				,('24819','742','122025','1','4','17400')
				,('54364','742','122025','1','0','17400')
				,('64724','742','122025','1','0','17300')
				,('45874','742','122025','3','1','17200')
				,('26537','742','122025','3','7','17000')
				,('65851','742','122025','1','2','17000')
				,('38539','742','122025','1','8','16900')
				,('40002','742','122025','1','0','16800')
				,('23847','742','122025','1','0','16600')
				,('54385','742','122025','1.5','3','16500')
				,('28717','742','122025','1','0','16500')
				,('65445','742','122025','1','0','15700')
				,('49898','742','122025','1','7','15500')
				,('39697','742','122025','7','10','15500')
				,('39152','742','122025','1','8','15000')
				,('54127','742','122025','5','7','14900')
				,('43398','742','122025','1','3','14900')
				,('43266','742','122025','3','3','14800')
				,('31349','742','122025','2','2.0000000000000018','14500')
				,('24273','742','122025','3','9','14500')
				,('57151','742','122025','1','3','14500')
				,('31475','742','122025','1','4','14400')
				,('45577','742','122025','1','2','14300')
				,('60840','742','122025','1','-1','14000')
				,('33273','742','122025','2','21','14000')
				,('60971','742','122025','3','0','13900')
				,('24341','742','122025','0.5','1.5','13600')
				,('33849','742','122025','5','0','13600')
				,('51554','742','122025','1','0','13500')
				,('43131','742','122025','1','1','13500')
				,('57223','742','122025','1','2','13100')
				,('31223','742','122025','7','19','12900')
				,('33174','742','122025','1','1','12900')
				,('39832','742','122025','2','3','12800')
				,('31563','742','122025','1','0','12700')
				,('52526','742','122025','0.33333333333333','4.000000000000073','12500')
				,('27387','742','122025','1','4','12500')
				,('24353','742','122025','1','2','12400')
					,('44177','742','122025','1','2','12300');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('44821','742','122025','1','0','12300')
				,('54754','742','122025','1','2','12200')
				,('31632','742','122025','2','6.000000000000032','12200')
				,('42862','742','122025','1','0','12200')
				,('22283','742','122025','1','2','11800')
				,('58398','742','122025','1','1','11700')
				,('42858','742','122025','2','8','11600')
				,('63745','742','122025','0.66666666666667','1.333333343267451','11600')
				,('31314','742','122025','1','2','11500')
				,('63738','742','122025','0.66666666666666','0.6666666666666701','11500')
				,('52495','742','122025','1','2','11500')
				,('56917','742','122025','1','2','11000')
				,('58575','742','122025','1','1','10800')
				,('46787','742','122025','1','4','10700')
				,('46789','742','122025','1','2','10700')
				,('27985','742','122025','1','2','10600')
				,('48351','742','122025','2','4','10500')
				,('40265','742','122025','1','12','10500')
				,('62932','742','122025','4','0','10500')
				,('31651','742','122025','4','3','10200')
				,('59266','742','122025','3','7','10200')
				,('22269','742','122025','4','10','10100')
				,('55721','742','122025','8','19','10100')
				,('22278','742','122025','3','13','10100')
				,('44839','742','122025','3','5','10100')
				,('22277','742','122025','3','7','10100')
				,('55720','742','122025','3','11','10100')
				,('52920','742','122025','2','0','9900')
				,('31189','742','122025','2','3','9900')
				,('29857','742','122025','1','1','9600')
				,('66156','742','122025','3','1','9500')
				,('64011','742','122025','1','8','9500')
				,('43298','742','122025','0.5','0.5','9500')
				,('42767','742','122025','1','2','9500')
				,('40575','742','122025','6','5','9500')
				,('63606','742','122025','1','1','9500')
				,('47206','742','122025','4','19','9400')
				,('52291','742','122025','7','63','9400')
				,('27765','742','122025','1','2','9400')
				,('34700','742','122025','2','1','9400')
				,('59849','742','122025','1','11','9400')
				,('66614','742','122025','1','1','9400')
				,('54196','742','122025','15','58','9400')
				,('60209','742','122025','5','-6','9400')
				,('47204','742','122025','3','13','9400')
				,('48062','742','122025','2','0','9400')
				,('33981','742','122025','7','22','9400')
				,('33916','742','122025','1','10','9400')
				,('32600','742','122025','1','0','9000')
				,('45306','742','122025','1','2','9000')
					,('57617','742','122025','1','0','9000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('55210','742','122025','1','0','8900')
				,('43351','742','122025','1','2','8800')
				,('24361','742','122025','0.5','3.5','8500')
				,('43308','742','122025','1','1','8400')
				,('32672','742','122025','4','7','8300')
				,('27936','742','122025','1','2','8100')
				,('44379','742','122025','1','0','8000')
				,('54111','742','122025','4','0','7900')
				,('56142','742','122025','4','16','7600')
				,('61718','742','122025','2','3','7500')
				,('48626','742','122025','6','20','7500')
				,('31562','742','122025','1','7','7500')
				,('46816','742','122025','1','0','7500')
				,('46291','742','122025','1','1','7300')
				,('60551','742','122025','1','2','7300')
				,('31494','742','122025','1','1','7200')
				,('37329','742','122025','1','0','7100')
				,('40564','742','122025','1','2','7000')
				,('40562','742','122025','2','2','7000')
				,('31766','742','122025','6','8.5','6900')
				,('65830','742','122025','1','0','6900')
				,('50903','742','122025','3','11','6900')
				,('29860','742','122025','1','2','6800')
				,('31293','742','122025','3','6','6500')
				,('66087','742','122025','1','2','6300')
				,('66086','742','122025','2','4','6300')
				,('57132','742','122025','1','2','6000')
				,('30409','742','122025','1','0','6000')
				,('27763','742','122025','2','3','5900')
				,('42766','742','122025','1','4','5900')
				,('37030','742','122025','1','2','5800')
				,('31629','742','122025','1','2','5800')
				,('45305','742','122025','1','2','5800')
				,('53814','742','122025','2','3','5500')
				,('56796','742','122025','1','6','5500')
				,('54008','742','122025','1','-2','5500')
				,('56896','742','122025','1','1','5500')
				,('53888','742','122025','1','3','5500')
				,('49156','742','122025','1','10','5300')
				,('37854','742','122025','1','1','5300')
				,('24465','742','122025','1','7','5300')
				,('52613','742','122025','1','2','5200')
				,('52327','742','122025','1','2','5200')
				,('34081','742','122025','33','12','5200')
				,('65748','742','122025','3','5','5100')
				,('65746','742','122025','1','4','5100')
				,('65757','742','122025','2','6','5100')
				,('57040','742','122025','5','9','5100')
				,('40145','742','122025','1','4','5000')
				,('66402','742','122025','7','4','5000')
					,('56126','742','122025','1','4','5000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('62384','742','122025','1','5','5000')
				,('49419','742','122025','1','3','5000')
				,('40129','742','122025','1','2','5000')
				,('25505','742','122025','1','2','4900')
				,('59636','742','122025','2','10','4900')
				,('64647','742','122025','7','2','4900')
				,('54742','742','122025','1','2','4900')
				,('24264','742','122025','2','3','4800')
				,('55375','742','122025','1','-2','4700')
				,('48361','742','122025','1','6','4700')
				,('63975','742','122025','1','3','4600')
				,('25826','742','122025','8','-36','4600')
				,('35306','742','122025','1','4','4600')
				,('60902','742','122025','1','-1','4500')
				,('26149','742','122025','4','8','4500')
				,('40271','742','122025','1','3','4400')
				,('34398','742','122025','2','5','4300')
				,('63752','742','122025','5','7','4300')
				,('61320','742','122025','3','0','4200')
				,('35164','742','122025','1','2','4100')
				,('57011','742','122025','1','1','4100')
				,('55624','742','122025','6','16','4000')
				,('54335','742','122025','1','2','4000')
				,('63786','742','122025','2','41','4000')
				,('63957','742','122025','1','4','4000')
				,('53832','742','122025','2','2','4000')
				,('22826','742','122025','2','26','3900')
				,('54650','742','122025','4','4','3800')
				,('54651','742','122025','6','6','3800')
				,('42929','742','122025','2','1','3800')
				,('56354','742','122025','5','8','3800')
				,('64044','742','122025','2','14','3800')
				,('60339','742','122025','6','6','3800')
				,('60390','742','122025','4','17','3800')
				,('44961','742','122025','1','2','3700')
				,('56307','742','122025','13','0','3700')
				,('58218','742','122025','1','5','3700')
				,('34397','742','122025','16','-13','3700')
				,('47117','742','122025','1','2','3500')
				,('59067','742','122025','3','-8','3400')
				,('35518','742','122025','2','3','3400')
				,('35524','742','122025','1','3','3400')
				,('35520','742','122025','3','-3','3400')
				,('64034','742','122025','2','8','3300')
				,('50088','742','122025','2','1','3200')
				,('35287','742','122025','3','0','3200')
				,('53357','742','122025','1','2','3200')
				,('54760','742','122025','1','-2','3100')
				,('33418','742','122025','1','3','3000')
				,('37036','742','122025','2','-1','3000')
					,('54241','742','122025','2','1','3000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('25798','742','122025','1','7','2900')
				,('27772','742','122025','4','2','2900')
				,('52362','742','122025','2','3','2800')
				,('55601','742','122025','12','15','2800')
				,('37247','742','122025','1','0','2800')
				,('42905','742','122025','2','2','2800')
				,('50688','742','122025','2','5','2800')
				,('54498','742','122025','1','1','2800')
				,('50721','742','122025','2','8','2600')
				,('52184','742','122025','6','18','2600')
				,('64856','742','122025','3','11','2600')
				,('64234','742','122025','12','10','2600')
				,('60824','742','122025','1','0','2500')
				,('33929','742','122025','1','12','2500')
				,('62083','742','122025','1','6','2500')
				,('48019','742','122025','23','94','2500')
				,('60397','742','122025','2','11','2400')
				,('57675','742','122025','3','11','2300')
				,('58744','742','122025','1','7','2300')
				,('57672','742','122025','4','13','2300')
				,('60825','742','122025','1','7','2300')
				,('51246','742','122025','1','2','2300')
				,('66616','742','122025','1','0','2200')
				,('32692','742','122025','1','18','2200')
				,('38319','742','122025','1','12','2100')
				,('57012','742','122025','2','-2','2100')
				,('44348','742','122025','77','-7973','2000')
				,('53182','742','122025','1','19','1900')
				,('54814','742','122025','3','0','1900')
				,('53162','742','122025','3','8','1900')
				,('27459','742','122025','1','11','1600')
				,('62038','742','122025','4','7','1500')
				,('49161','742','122025','2','4','1500')
				,('52915','742','122025','2','-24','1200')
				,('58629','742','122025','17','74','1000')
				,('59924','742','122025','22.5','-124.2','1000')
				,('39236','742','122025','5','35','1000')
				,('63651','742','122025','6','33','800')
				,('58667','742','122025','6','5','500')
				,('46100','742','122025','5','74','500')
				,('58481','742','122025','1','29','500')
				,('44347','742','122025','129','88','300')
				,('49226','742','122025','7','-930','0');
/* TOTAL LINEAS : 451 */