DELETE FROM rotacionproducto WHERE bodegaid = 749 AND codperiodo = '082023';
INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('46716','749','082023','0.28333333333333','0.650000000000003','170500')
				,('43550','749','082023','0.32000000000000006','3.6600000000000006','170000')
				,('23806','749','082023','0.12000000000000001','1.8199999999999998','170000')
				,('43184','749','082023','0.25','0.71875','168000')
				,('43180','749','082023','1','2','168000')
				,('59553','749','082023','0.270833333333331','1.6979166666666687','150000')
				,('23812','749','082023','0.266666666666667','0.711111111111111','148500')
				,('58014','749','082023','0.09','1.89','140000')
				,('43290','749','082023','0.12000000000000001','1.8199999999999998','130000')
				,('26533','749','082023','0.44','1.4799999999999998','110000')
				,('43283','749','082023','0.71875','0.71875','108800')
				,('55782','749','082023','0.066666666666666','4.933333333333334','102000')
				,('34301','749','082023','0.1','1.9','94000')
				,('46090','749','082023','0.041666666666667','1.916666666666666','93000')
				,('39853','749','082023','0.999999999999995','0','92900')
				,('28973','749','082023','0.166666666666666','0.8333333333333339','91200')
				,('26707','749','082023','0.041666666666666','0.9583333333333339','91200')
				,('31759','749','082023','0.349999999999998','1.4833333333333358','89400')
				,('39660','749','082023','1','1','88500')
				,('44302','749','082023','0.13333333333333','1.800000000000003','81000')
				,('57517','749','082023','1','1','79500')
				,('38541','749','082023','0.7666666666666689','1.0999999999999963','78000')
				,('49672','749','082023','0.083333333333334','1.8749999999999991','76000')
				,('41833','749','082023','0.16666666666667','0.83333333333333','73200')
				,('33555','749','082023','0.5499999999999999','3.0499999999999994','70000')
				,('48571','749','082023','1.2','2.8','69500')
				,('55304','749','082023','0.2','1.7999999999999998','69000')
				,('41855','749','082023','4.500000000000001','12.400000000000006','67000')
				,('33743','749','082023','0.250000000000004','0.5416666666666622','64800')
				,('44681','749','082023','1','2','64600')
				,('38577','749','082023','0.59999999999999','1.4000000000000101','64500')
				,('29762','749','082023','0.08','0.9199999999999999','62500')
				,('54483','749','082023','0.33333333333334','0.9333333333333259','62000')
				,('40253','749','082023','0.41666666666666496','2.5000000000000018','61600')
				,('58898','749','082023','0.333333333333335','1.1999999999999933','61500')
				,('52361','749','082023','1','2','60900')
				,('46895','749','082023','0.133333333333333','1.800000000000001','60400')
				,('45830','749','082023','1','2','60000')
				,('61909','749','082023','1','0','59900')
				,('51946','749','082023','1','2','57700')
				,('53776','749','082023','0.7083333333333429','1.1666666666666567','57600')
				,('47148','749','082023','0.125','0.875','56400.01')
				,('47147','749','082023','0.041666666666667','0.9166666666666661','56399.99')
				,('25785','749','082023','0.375','1.541666666666666','55200')
				,('30525','749','082023','0.1','1.7999999999999998','55000')
				,('43362','749','082023','0.1','2.8','54000')
				,('43359','749','082023','0.1','1.9','54000')
				,('22880','749','082023','1.1','0.8199999999999998','52000')
				,('43534','749','082023','1','3','51900')
				,('22302','749','082023','1','0','51000')
					,('27585','749','082023','1','1','50200');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('29755','749','082023','0.04','0','50000')
				,('29874','749','082023','0.1','1.7','49500')
				,('58101','749','082023','3','4','49400')
				,('49747','749','082023','0.133333333333333','1.833333333333334','48000')
				,('31287','749','082023','0.33333333333333','1.66666666666667','47500')
				,('54056','749','082023','0.3','1.7','46000')
				,('43226','749','082023','1','7','45200')
				,('62036','749','082023','1','5','45000')
				,('58540','749','082023','0.1','1.9','45000')
				,('56535','749','082023','0.6','0.49999999999999933','45000')
				,('55738','749','082023','1','6','44900')
				,('39116','749','082023','0.250000000000003','1.722222222222219','43200')
				,('46623','749','082023','0.083333333333333','-0.083333333333333','42000')
				,('32981','749','082023','1','1','42000')
				,('51594','749','082023','1','1','39900')
				,('46495','749','082023','1','1','39900')
				,('24327','749','082023','0.1','1.9','39500')
				,('54035','749','082023','1','1','39499.99')
				,('22930','749','082023','0.13333333333333','1.86666666666667','39000')
				,('57302','749','082023','1','1','38900')
				,('31399','749','082023','0.5','1.5','38000')
				,('46720','749','082023','1.5999999999999999','2.4','37800')
				,('39201','749','082023','1','3','36100')
				,('44582','749','082023','0.15789473684211','-0.15789473684211','36100')
				,('45899','749','082023','0.9166666666666701','1.08333333333333','36000')
				,('59286','749','082023','1','3','36000')
				,('23805','749','082023','1','2','35900')
				,('39934','749','082023','0.30000000000000004','0.7000000000000001','35000')
				,('40614','749','082023','2','6','35000')
				,('54476','749','082023','0.875000000000003','2.958333333333327','34500')
				,('49041','749','082023','1','0.6666666666666701','34500')
				,('46776','749','082023','1.166666666666675','8.499999999999982','34200')
				,('54384','749','082023','0.66666666666666','4.833333333333339','33000')
				,('52509','749','082023','0.33333333333333','0.6666666666666701','32800')
				,('46908','749','082023','0.08','-0.08','32500')
				,('60832','749','082023','1','5','32000')
				,('59529','749','082023','1','6','31500')
				,('52456','749','082023','2','1','31100')
				,('56390','749','082023','1','2','31000')
				,('41333','749','082023','0.1','-0.1','30000')
				,('53948','749','082023','0.2','3.8000000000000003','30000')
				,('23612','749','082023','0.57142857142857','1.9285714285714302','30000')
				,('23577','749','082023','0.5','1.5','30000')
				,('44220','749','082023','0.2','1.7999999999999998','30000')
				,('54107','749','082023','1','1.5','29900')
				,('57262','749','082023','1','2','29700')
				,('31190','749','082023','0.2','3.079999999999999','29500')
				,('23616','749','082023','0.1','1.7999999999999998','29000')
				,('53417','749','082023','1','3','28900')
				,('53970','749','082023','1','1','28900')
					,('38369','749','082023','1','3','28900');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('46200','749','082023','1.7500000000000142','4.1666666666666545','28800')
				,('49769','749','082023','0.9166666666666701','2.83333333333333','28800')
				,('23565','749','082023','0.1','3.15','28600')
				,('46798','749','082023','1','3','28300')
				,('33638','749','082023','0.41666666666666896','1.5833333333333308','27600')
				,('28120','749','082023','1','2','27500')
				,('31344','749','082023','0.5','3.5','27500')
				,('43331','749','082023','1','0.5','26900')
				,('57659','749','082023','1','3','26300')
				,('42089','749','082023','0.4','1.2000000000000002','25900')
				,('46205','749','082023','1','2','25800')
				,('55891','749','082023','1','1','25500')
				,('46328','749','082023','0.04','-0.04','25000')
				,('50062','749','082023','1.18','0.66','25000')
				,('51593','749','082023','1.250000000000005','0.7499999999999947','25000')
				,('54625','749','082023','0.8999999999999999','4.800000000000003','25000')
				,('61316','749','082023','1','10','25000')
				,('57267','749','082023','1','7','24900')
				,('26074','749','082023','0.2','3.5999999999999996','24500')
				,('30157','749','082023','1','1','24200')
				,('26243','749','082023','0.33333333333333','1.66666666666667','24100')
				,('23587','749','082023','1.111111111111112','1.6666666666666679','24100')
				,('45567','749','082023','2','1','24000')
				,('56887','749','082023','2','2','24000')
				,('49905','749','082023','1','2','23500')
				,('26212','749','082023','1','0.5','23300')
				,('53835','749','082023','1','5','23000')
				,('45895','749','082023','0.33333333333333703','3.499999999999993','23000')
				,('45886','749','082023','1.75','1.5499999940395357','22500')
				,('23598','749','082023','2','2','22500')
				,('31309','749','082023','2','1','22500')
				,('60935','749','082023','3','6','22500')
				,('46737','749','082023','1','1','22100')
				,('31414','749','082023','2','3','21900')
				,('28034','749','082023','1','1','21500')
				,('26553','749','082023','1','2','21200')
				,('58834','749','082023','0.250000000000003','2.249999999999997','21000')
				,('31699','749','082023','1','0','20500')
				,('38465','749','082023','2','5','20300')
				,('35579','749','082023','1','1','20300')
				,('25540','749','082023','1','2','20100')
				,('34188','749','082023','0.01','0.99','20000')
				,('41317','749','082023','1','1','20000')
				,('44318','749','082023','1','2','20000')
				,('31151','749','082023','0.2','5.600000000000001','20000')
				,('51597','749','082023','1','1','19900')
				,('38462','749','082023','2','1','19900')
				,('27805','749','082023','1','2','19900')
				,('48371','749','082023','1','1','19200')
				,('33251','749','082023','1','2','19000')
					,('45897','749','082023','2','0.30000000000000004','19000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('23704','749','082023','1','4.6','19000')
				,('46343','749','082023','1','3','18900')
				,('40547','749','082023','2','7','18900')
				,('33009','749','082023','1','1','18700')
				,('60894','749','082023','1','3','18500')
				,('58219','749','082023','2','2','18400')
				,('39000','749','082023','3','0','18100')
				,('31391','749','082023','1','1','18000')
				,('29713','749','082023','1','1','18000')
				,('45871','749','082023','1','2','17900')
				,('57559','749','082023','1','5','17800')
				,('59240','749','082023','1','1','17699.99')
				,('45829','749','082023','1','6','17400')
				,('54910','749','082023','1','3','17100')
				,('39738','749','082023','1','6','17000')
				,('58701','749','082023','2','16','16900')
				,('53327','749','082023','1','1','16900')
				,('31133','749','082023','1','5','16800')
				,('46504','749','082023','1','1','16700')
				,('29930','749','082023','1','1','16600')
				,('23609','749','082023','1','0','16500')
				,('27381','749','082023','2','2','16400')
				,('53109','749','082023','2','0','16400')
				,('33646','749','082023','1','1','16200')
				,('38600','749','082023','3.5','4.5','16000')
				,('39158','749','082023','1','3','15900')
				,('39151','749','082023','2','3','15900')
				,('54138','749','082023','1','3','15500')
				,('26238','749','082023','1','5','15300')
				,('46294','749','082023','1','6','15200')
				,('43258','749','082023','1','1','15100')
				,('23597','749','082023','2','5','15000')
				,('49170','749','082023','1','2','15000')
				,('23590','749','082023','0.33333333333333','3.66666666666667','15000')
				,('54785','749','082023','3','8','15000')
				,('26537','749','082023','1','0','15000')
				,('44354','749','082023','1','3','15000')
				,('45304','749','082023','1','3','15000')
				,('39156','749','082023','2','3','15000')
				,('48401','749','082023','1','3','15000')
				,('26529','749','082023','1.25','2.75','15000')
				,('24278','749','082023','4','3','15000')
				,('49879','749','082023','1','3','14900')
				,('39039','749','082023','1','4','14900')
				,('29858','749','082023','1','10','14900')
				,('58075','749','082023','1','3','14900')
				,('47943','749','082023','1','0','14500')
				,('54385','749','082023','1.75','4','14500')
				,('40264','749','082023','1','3','14500')
				,('45909','749','082023','1','1','14500')
					,('58919','749','082023','1','3','14300');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('42127','749','082023','1','2','14300')
				,('47121','749','082023','2','4','14200')
				,('24473','749','082023','2','1','14000')
				,('58552','749','082023','1','2','14000')
				,('45885','749','082023','1','8','14000')
				,('52193','749','082023','0.2','2.8','13900')
				,('53528','749','082023','1','1','13900')
				,('56017','749','082023','2','2','13900')
				,('40265','749','082023','1','4','13900')
				,('57222','749','082023','2','8','13500')
				,('23820','749','082023','0.5','1.5','13500')
				,('54127','749','082023','4','6','13500')
				,('57223','749','082023','1','8','13100')
				,('31475','749','082023','1','3','13000')
				,('39152','749','082023','1','3','13000')
				,('31446','749','082023','2','2','12900')
				,('45874','749','082023','1','4','12900')
				,('31223','749','082023','3','13','12900')
				,('23318','749','082023','1','3','12900')
				,('26551','749','082023','1','1','12800')
				,('28181','749','082023','2','2','12700')
				,('27387','749','082023','2','1','12500')
				,('44821','749','082023','1','3','12300')
				,('45860','749','082023','0.5','9.5','12200')
				,('33273','749','082023','2','4','12200')
				,('45319','749','082023','1','1','11900')
				,('43131','749','082023','1','1','11700')
				,('22928','749','082023','1','3','11600')
				,('60600','749','082023','2','7','11500')
				,('49874','749','082023','2.5','18.5','11500')
				,('23835','749','082023','1','3','11300')
				,('31632','749','082023','1.5999999999999999','8.000000000000004','10900')
				,('40348','749','082023','1','8','10900')
				,('31412','749','082023','1','0','10600')
				,('25108','749','082023','1','0','10600')
				,('49793','749','082023','1','1','10500')
				,('55608','749','082023','2','8','10500')
				,('22198','749','082023','2','2','10400')
				,('54176','749','082023','1','1','10200')
				,('57605','749','082023','0.5','1.5','10000')
				,('23600','749','082023','0.3','3.3','10000')
				,('23315','749','082023','2','8','9900')
				,('24472','749','082023','1','2','9500')
				,('49390','749','082023','1','3','9500')
				,('28686','749','082023','1','3','9500')
				,('22843','749','082023','1','2','9000')
				,('24285','749','082023','2','4','9000')
				,('46789','749','082023','1','1','9000')
				,('22283','749','082023','2','6','8600')
				,('40577','749','082023','1','4','8500')
					,('40579','749','082023','3','4','8500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('46886','749','082023','1','3','8500')
				,('31300','749','082023','1','3','8500')
				,('29728','749','082023','1','3','8400')
				,('55721','749','082023','5','19','8200')
				,('22275','749','082023','2','9','8200')
				,('22277','749','082023','1','11','8200')
				,('22278','749','082023','5','21','8200')
				,('46744','749','082023','1','3','8000')
				,('33571','749','082023','1','5','8000')
				,('33981','749','082023','8','16','8000')
				,('47205','749','082023','5','26','8000')
				,('25778','749','082023','2','0','8000')
				,('24467','749','082023','1','4','8000')
				,('59849','749','082023','3','4','8000')
				,('59848','749','082023','1','11','8000')
				,('33916','749','082023','3','22','8000')
				,('47206','749','082023','1','12','8000')
				,('47204','749','082023','2','9','8000')
				,('54196','749','082023','18','10','8000')
				,('57203','749','082023','1','3','7900')
				,('55211','749','082023','1','4','7500')
				,('43118','749','082023','2','2','7100')
				,('52920','749','082023','1','8','7000')
				,('45306','749','082023','4','4','7000')
				,('31562','749','082023','1','9','6900')
				,('50903','749','082023','2','3','6900')
				,('49648','749','082023','1','3','6700')
				,('46816','749','082023','2','4','6500')
				,('55176','749','082023','3','2','6500')
				,('34241','749','082023','1','5','6500')
				,('26000','749','082023','1.33333333333333','1.66666666666667','6400')
				,('61718','749','082023','2','10','6000')
				,('23570','749','082023','1','3','6000')
				,('31293','749','082023','3','6.8','5900')
				,('31629','749','082023','1.5','9.5','5500')
				,('48626','749','082023','1','4','5500')
				,('31378','749','082023','1','3','5500')
				,('50233','749','082023','1','2','5500')
				,('62018','749','082023','1','15','5500')
				,('48362','749','082023','1','6','5500')
				,('24465','749','082023','1','7','5300')
				,('52613','749','082023','1','5','5200')
				,('52325','749','082023','1','4','5200')
				,('52327','749','082023','1','4','5200')
				,('52312','749','082023','3','0','5200')
				,('47203','749','082023','1','1','5100')
				,('28228','749','082023','1','3','5000')
				,('40145','749','082023','3','9','5000')
				,('40301','749','082023','4','3','4700')
				,('40411','749','082023','2','2','4600')
					,('25501','749','082023','1','5','4500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('53500','749','082023','3','1','4500')
				,('27760','749','082023','1','5','4500')
				,('27763','749','082023','1','5','4500')
				,('49397','749','082023','1','3','4500')
				,('42766','749','082023','1','5','4500')
				,('52692','749','082023','2','3','4500')
				,('56283','749','082023','2','1','4500')
				,('48361','749','082023','2','10','4500')
				,('49419','749','082023','1','5','4400')
				,('24370','749','082023','1','5','4400')
				,('37834','749','082023','2','8','4300')
				,('42980','749','082023','1','3','4000')
				,('43316','749','082023','1','4','3900')
				,('40383','749','082023','1','3','3800')
				,('56092','749','082023','1','4','3500')
				,('47117','749','082023','1','9','3500')
				,('53832','749','082023','1','0','3000')
				,('59333','749','082023','1','3','3000')
				,('50147','749','082023','1','5','3000')
				,('36492','749','082023','2','4','3000')
				,('48900','749','082023','3','8','3000')
				,('27762','749','082023','6','3','2900')
				,('53724','749','082023','3','3','2900')
				,('36086','749','082023','1','4','2900')
				,('62082','749','082023','1','6','2700')
				,('53095','749','082023','6','6','2700')
				,('62083','749','082023','3','5','2700')
				,('53728','749','082023','2','6','2500')
				,('30213','749','082023','2','2','2500')
				,('54650','749','082023','2','23','2500')
				,('56731','749','082023','1','22','2500')
				,('27772','749','082023','1','9','2500')
				,('53169','749','082023','1','11','2500')
				,('52184','749','082023','2','8','2500')
				,('59542','749','082023','1','5','2400')
				,('42770','749','082023','1','10','2300')
				,('62041','749','082023','1','19','2200')
				,('36121','749','082023','2','6','2200')
				,('49261','749','082023','1','5','2199.99')
				,('56775','749','082023','2','6','2100')
				,('42905','749','082023','1','5','2000')
				,('48019','749','082023','18','261','2000')
				,('55601','749','082023','1','26','1800')
				,('50688','749','082023','2','17','1800')
				,('52362','749','082023','4','19','1800')
				,('38319','749','082023','18','76','1700')
				,('57675','749','082023','1','17','1600')
				,('57672','749','082023','5','10','1600')
				,('33929','749','082023','3','21','1600')
				,('53768','749','082023','2','4','1500')
					,('55572','749','082023','2','3','1500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('62134','749','082023','3','0','1500')
				,('58852','749','082023','2','22','1500')
				,('57521','749','082023','1','5','1500')
				,('49020','749','082023','4','15','1500')
				,('53741','749','082023','6','1','1500')
				,('35207','749','082023','3','2','1400')
				,('53172','749','082023','1','16','1400')
				,('51082','749','082023','1','6','1200')
				,('62038','749','082023','2','7','1200')
				,('46409','749','082023','1','5','1000')
				,('59924','749','082023','7.5','-7.5','1000')
				,('58629','749','082023','4','44','1000')
				,('27449','749','082023','2','7','1000')
				,('36120','749','082023','2','22','1000')
				,('27450','749','082023','6','3','1000')
				,('53175','749','082023','5','1','1000')
				,('44348','749','082023','42','-56','1000')
				,('46955','749','082023','6','94','833')
				,('60966','749','082023','21','39','800')
				,('32623','749','082023','6','18','800')
				,('34799','749','082023','1','8','700')
				,('62414','749','082023','3','3','700')
				,('39236','749','082023','6','93','600')
				,('53641','749','082023','4','1','600')
				,('46100','749','082023','17','79','500')
				,('37852','749','082023','3','57','300')
				,('40609','749','082023','5','-5','100')
				,('44347','749','082023','206','1222','100')
				,('49226','749','082023','32','-37','0');
/* TOTAL LINEAS : 386 */