Medivalle Dashboard ERI

Exactitud del Registro de Inventario & Auditoría Mantis ERP

SQL Server 2022 En Vivo
Ir al Aplicativo
Tomas Asignadas
558
13,764 SKUs en 52 farmacias
Tomas Ejecutadas
143
25.63% de cumplimiento total
Tomas Pendientes
374
En proceso de conteo en punto
Exactitud ERI Global
83.24%
Confiabilidad de Stock Físico vs Kardex
Ítems con Descuadre
2307
Ajustados vía documentos AJT

Top 10 Farmacias: Asignadas vs Ejecutadas

Estado de Ejecución Global

Semáforo de Cumplimiento & Confiabilidad ERI por Farmacia (52 Puntos)

Cód Farmacia / Punto de Dispensación Regente Responsable Tomas Asig. SKUs Totales Ejecutadas Pendientes Cumplimiento % Ítems Descuadre $ Sobrantes $ Faltantes Exactitud ERI %
416 416 MI FARMACIA CALI SUR (FOMAG) LSVELEZ 30 2,511 21 8 70.0% 1368 $138,665,466 $194,807,075 45.5%
445 445 MI FARMACIA JAMUNDI (FOMAG) DPULIDO 22 555 3 16 13.6% 3 $217,858 $217,858 99.5%
408 408 MI FARMACIA PALMIRA (FOMAG) LONAVIA 19 521 0 18 0.0% 3 $121,119 $121,119 99.4%
17 17 MI FARMACIA CIPRES DALZATE 19 737 1 18 5.3% 8 $124,406 $124,410 98.9%
518 518 MI FARMACIA CHINCHINA (FOMAG) AMBEDOYA 19 457 5 13 26.3% 18 $1,046,503 $711,209 96.1%
718 718 MI FARMACIA LA UNION FOMAG LJHBOLIVAR 19 985 14 5 73.7% 421 $21,888,415 $22,912,608 57.3%
524 524 MI FARMACIA SALAMINA (FOMAG) MAGUIRRE 18 34 13 5 72.2% 4 $312,417 $312,419 88.2%
457 457 MI FARMACIA YUMBO (FOMAG) MTBRAVO 16 350 0 15 0.0% 6 $341,139 $259,381 98.3%
404 404 MI FARMACIA TULUA (FOMAG) YRBRAVO 16 310 1 15 6.2% 8 $737,117 $683,173 97.4%
494 494 MI FARMACIA GUACARI (FOMAG) DJARAMILLO 16 73 6 9 37.5% 0 $0 $0 100.0%
412 412 MI FARMACIA CALI NORTE (FOMAG) AACASTILLO 15 414 0 13 0.0% 4 $142,416 $142,706 99.0%
572 572 MI FARMACIA SUPIA 2 (FOMAG) DMACEVEDO 15 300 0 15 0.0% 3 $43,418 $43,418 99.0%
540 540 MI FARMACIA SANTANDER Q/CHAO YCARO 15 60 7 7 46.7% 3 $32,289 $32,288 95.0%
36 36 MI FARMACIA ZARAGOZA YRESTREPO 14 436 1 13 7.1% 3 $2,337 $8,960 99.3%
514 514 MI FARMACIA LA DORADA (FOMAG) YMAHECHA 14 262 1 9 7.1% 1 $108,445 $108,445 99.6%
581 581 MI FARMACIA PASOANCHO (FOMAG) MRIBARBO 14 401 2 9 14.3% 9 $6,822,025 $4,372,129 97.8%
424 424 MI FARMACIA ZARZAL (FOMAG) LTVILLADAS 14 1,288 9 5 64.3% 609 $31,054,755 $34,727,116 52.7%
589 589 MI FARMACIA ANSERMA CALDAS ( FOMAG) AHENAO 13 260 0 13 0.0% 19 $336,387 $336,386 92.7%
510 510 MI FARMACIA MANIZALES (FOMAG) YMJIMENEZ 13 287 1 12 7.7% 11 $257,803 $633,897 96.2%
577 577 MI FARMACIA SANTA ROSA (FOMAG) PECHEVERRI 13 122 2 10 15.4% 13 $396,229 $1,334,583 89.3%
746 746 MI FARMACIA BALBOA EJARAMILLO 13 36 10 2 76.9% 1 $158,763 $158,763 97.2%
544 544 MI FARMACIA POPAYAN CADAZA 12 136 0 11 0.0% 4 $181,144 $181,151 97.1%
502 502 MI FARMACIA RIOSUCIO (FOMAG) BPOSADA 12 131 2 7 16.7% 7 $55,187 $522,874 94.7%
687 687 MI FARMACIA ARMENIA LCFORERO 12 136 2 9 16.7% 8 $734,120 $734,120 94.1%
28 28 MI FARMACIA QUIMBAYA AHERRERA 12 290 4 7 33.3% 16 $678,243 $2,251,463 94.5%
99 99 MI FARMACIA MIRANDA CAUCA RHERRERA 12 108 6 4 50.0% 0 $0 $0 100.0%
30 30 MI FARMACIA SAN JOAQUIN EFVALENCIA 11 446 0 11 0.0% 0 $0 $0 100.0%
400 400 MI FARMACIA BUGA (FOMAG) CTAMAYO 11 117 1 10 9.1% 17 $1,407,249 $1,407,249 85.5%
498 498 MI FARMACIA FLORIDA (FOMAG) LSEGURA 11 96 4 6 36.4% 2 $152,419 $152,419 97.9%
103 103 MI FARMACIA CORINTO CAUCA ELOPEZ 11 283 5 5 45.5% 5 $266,021 $208,032 98.2%
25 25 MI FARMACIA LA VIRGINIA 2 C.V MTORO 10 211 0 9 0.0% 18 $2,353,224 $2,397,978 91.5%
593 593 MI FARMACIA MARQUETALIA (FOMAG) YRHINCAPIE 10 160 0 10 0.0% 0 $0 $0 100.0%
1 1 PRINCIPAL MEDIVALLE REARTEAGA 10 72 8 1 80.0% 887 $467,642,634 $465,835,225 0.0%
609 609 MI FARMACIA AGUADAS (FOMAG) VASALAZAR 9 230 1 8 11.1% 5 $1,037,638 $111,913 97.8%
34 34 MI FARMACIA TUMACO LVAQUIRO 9 84 2 7 22.2% 19 $1,477,647 $1,134,629 77.4%
565 565 MI FARMACIA CIP CARTAGO NVICUÑA 9 52 2 7 22.2% 0 $0 $0 100.0%
23 23 MI FARMACIA LA UNION NARIÑO SBRAVO 7 56 0 7 0.0% 0 $0 $0 100.0%
182 182 MI FARMACIA PASTO JMARTINEZ 7 54 2 4 28.6% 3 $206,246 $24,748 94.4%
620 620 MI FARMACIA TORIBIO ESYATACUE 6 62 0 6 0.0% 1 $1,599 $0 98.4%
170 170 MI FARMACIA APÍA RISARALDA ITOBON 4 159 0 1 0.0% 13 $39,789 $1,689,190 91.8%
428 428 MI FARMACIA ROLDANILLO (FOMAG) LSANTIAGO 4 38 0 4 0.0% 0 $0 $0 100.0%
449 449 MI FARMACIA CARTAGO (FOMAG) ZMONTENEGRO 4 15 1 3 25.0% 3 $884,180 $884,180 80.0%
420 420 MI FARMACIA PEREIRA (FOMAG) LGUERRA 3 219 0 2 0.0% 9 $1,291,776 $1,291,776 95.9%
16 16 MI FARMACIA CAICEDONIA MFPELAEZ 3 21 0 2 0.0% 1 $0 $1,384,314 95.2%
11 11 MI FARMACIA AIC CALI FSALAZAR 2 12 0 1 0.0% 4 $1,502,001 $1,502,001 66.7%
15 15 MI FARMACIA ARANZAZU DAMURIEL 2 99 0 2 0.0% 5 $15,280 $10,095 95.0%
683 683 MI FARMACIA MISTRATO LJGUEVARA 2 0 2 0 100.0% 16 $2,218,308 $2,377,872 100.0%
692 692 MI FARMCIA QUINCHIA 2 0 2 0 100.0% 0 $0 $0 100.0%
528 MEDIFARMA JP DROGUERIA SUPIA REARTEAGA 1 1 0 0 0.0% 0 $0 $0 100.0%
21 21 MI FARMACIA HOSPITALARIA LMARIN 1 69 0 0 0.0% 0 $0 $0 100.0%
433 433 MI FARMACIA GUATICA LSOTO 1 8 1 0 100.0% 0 $0 $0 100.0%
568 568 MI FARMACIA BUENAVENTURA 2 (FOMAG) 1 0 1 0 100.0% 4 $149,619 $149,620 100.0%