Inventory Management

Inventory Ledger

Name SKU Purchase Price Selling Price Opening Stock Purchase Return Stock Sales Closing Stock Sales Days Re-Order Level Short/ Excess
Trimetazidine 6X10s NK20 525.00 750.00 100 10 0 90 20 7 15.43 4.57
Trimetazidine 3X10s NK22 525.00 750.00 500 0 0 191 309 7 32.74 276.26
Sacubitril + Valsartan 2X10s NK24 525.00 750.00 300 0 0 200 100 7 34.29 65.71
Enoxaparin Sodium 1X1'S NK27 525.00 750.00 300 0 0 30 270 7 5.14 264.86
Carvedilol 3X10s NK30 525.00 750.00 500 0 0 50 450 7 8.57 441.43
Clopidogrel+Aspirin 2X10s NK31 525.00 750.00 300 0 0 30 270 7 5.14 264.86
Clopidogrel 3X10s NK32 525.00 750.00 100 0 0 25 75 7 4.29 70.71
Empagliflozin 2x10's NK33 525.00 750.00 300 0 0 130 170 7 22.29 147.71
Empagliflozin 1x10's NK34 525.00 750.00 100 0 0 95 5 7 16.29 -11.29
Entecavir 1X10'S NK36 525.00 750.00 100 50 0 100 50 7 17.14 32.86
Glimepiride 3x10 CF001 30.00 55.00 0 0 0 0 0 7 0.00 0.00
Gliclazide 2X14s GLI-0001 525.00 750.00 0 0 0 10 -10 7 1.71 -11.71
Gliclazide 5X10s GLI-0002 525.00 750.00 0 0 0 10 -10 7 1.71 -11.71
Furosemide + Spironolactone 3X10s FUR-0003 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Linagliptin 5 mg 3 x 10s LIN-0004 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Linagliptin 5 mg 5x4s LIN-0005 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Linagliptin 5 mg 1X15s LIN-0006 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Atorvastatin 3x10s ATO-0007 530.00 750.00 0 100 0 0 100 7 0.00 100.00
Atorvastatin 2x10s ATO-0008 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Mirabegron 10x2s MIR-0009 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Bisoprolol 3x10s BIS-0010 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Nebivolol 3x10s NEB-0011 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Olmesartan Medoxomil 3x10s OLM-0012 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Fluvoxamine 1x10s FLU-0013 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Co-Enzyme Q10 3x10s COE-0014 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ramipril 5X10s RAM-0015 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ramipril 3X10s RAM-0016 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ranolazine 2 X 10s RAN-0017 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Rosuvastatin 2x10s ROS-0018 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Rosuvastatin 3x10s ROS-0019 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Metformin 10x10s MET-0020 525.00 750.00 0 0 0 20 -20 7 3.43 -23.43
Tolterodine 2X14s TOL-0021 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Tamsulosin 2X14s TAM-0022 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Tamsulosin + Dutasteride 4X4s TAD-0023 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ursodeoxycholic Acid 3x10s URS-0024 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ursodeoxycholic Acid 2X10 URS-0025 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ursodeoxycholic Acid URS-0026 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Vildagliptin Tab 50 mg 3X10s VIL-0027 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Vildagliptin Tab 50 mg 2X10s VIL-0028 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Aceclofenac 5x10s ACE-0029 150.00 180.00 0 63 0 23 40 7 3.94 36.06
Esomeprazole 3X10s ESO-0030 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Esomeprazole 40 mg 1x1s ESO-0031 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Albendazole 20x1s ALB-0032 525.00 750.00 0 10 1 60 -49 7 10.29 -59.29
Amitriptyline 10x10s AMI-0033 3.00 2.00 0 13 0 40 -27 7 6.86 -33.86
Midazolam 1x1s MID-0034 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Midazolam 1x10s MID-0035 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Midazolam 3X10s MID-0036 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Losartan 2X10s LOS-0037 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Losartan 5X10s LOS-0038 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Losartan 3X10s LOS-0039 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Astaxanthin 3x10s AST-0040 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Astaxanthin 2X10s AST-0041 2.00 2.00 0 2 0 104 -102 7 17.83 -119.83
Paracetamol 60ml PAR-0042 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Paracetamol 25x10s PAR-0043 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Azithromycin 20ml AZI-0044 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Azithromycin 35ml AZI-0045 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Azithromycin 50ml AZI-0046 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Azithromycin 4x3s AZI-0047 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Cetalkonium Chloride 0.01% + Choline Salicylate 8.714% 10 GM CET-0048 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Vitamin B1+B6+B12 5x2s VIT-0049 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Vitamin B1+B6+B12 5X10s VIT-0050 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Bromhexine 100ml BRO-0051 525.00 750.00 0 0 0 10 -10 7 1.71 -11.71
Butamirate 100ml BUT-0052 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Calcium+Vitamin D3+Multimineral 15X1 CAL-0053 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Calcium+Vitamin D3+Multimineral 30X1 CAL-0054 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Calcium Carbonate (Elemental) + Vitamin D 15X1 CAL-0055 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Calcium Carbonate (Elemental) + Vitamin D 30X1 CAL-0056 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Paracetamol 500 mg + Caffeine 65 mg 10x10s PAR-0057 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Amlodipine 5X10s AML-0058 525.00 750.00 0 0 0 20 -20 7 3.43 -23.43
Amlodipine 3X10s AML-0059 525.00 750.00 0 0 2 10 -8 7 1.71 -9.71
Ceftibuten Dihydrate 4X2s CEF-0060 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Ceftibuten Dihydrate 1x1s CEF-0061 525.00 750.00 0 0 0 0 0 7 0.00 0.00
Total 248 1,248 1,603 213.94 1,389.06