PrepRung

CAT 2023 Slot 1 · DILR · Data Interpretation · medium

CAT 2023 Slot 1 DILR: Pharmacy Medicine Stock

A retail pharmacy stocks six medicines. The table below shows, for each medicine, its therapeutic category, the number of units in stock, the cost price (CP) per unit, the selling price (SP) per unit, and the number of months remaining until the stock expires.

| Medicine | Category | Stock (units) | CP/unit (₹) | SP/unit (₹) | Months to Expiry |
|---|---|---|---|---|---|
| Paracet-500 | Analgesic | 420 | 2.50 | 3.80 | 8 |
| Amoxiclin-250 | Antibiotic | 180 | 6.20 | 9.00 | 5 |
| Cetrizyn-10 | Antihistamine | 300 | 1.80 | 2.70 | 14 |
| Metfor-500 | Antidiabetic | 250 | 3.40 | 5.10 | 3 |
| Omepra-20 | Antacid | 360 | 2.90 | 4.20 | 11 |
| Vitacal-D3 | Supplement | 150 | 4.50 | 6.75 | 20 |

The total cost-price value of a medicine's stock = Stock × CP/unit. The profit margin percentage for a medicine = [(SP − CP)/CP] × 100. Assume all stock will eventually be sold at the listed selling price.

Question 1

Single correct option

Which medicine has the highest profit margin percentage, [(SP−CP)/CP]×100?
  1. A. Paracet-500
  2. B. Amoxiclin-250
  3. C. Cetrizyn-10
  4. D. Omepra-20
Show answer and solution

Answer: (A) Paracet-500

Compute margin% for each: Paracet-500 = (3.80−2.50)/2.50×100 = 52.0%; Amoxiclin-250 = (9.00−6.20)/6.20×100 ≈ 45.2%; Cetrizyn-10 = (2.70−1.80)/1.80×100 = 50.0%; Metfor-500 = 50.0%; Omepra-20 = (4.20−2.90)/2.90×100 ≈ 44.8%; Vitacal-D3 = 50.0%. The highest is Paracet-500 at 52.0%.

Question 2

Numerical answer

What is the total cost-price value (in ₹) of the entire pharmacy stock (sum of Stock × CP/unit over all six medicines)?
Show answer and solution

Answer: 5275

CP value per medicine = Stock × CP/unit: Paracet-500 = 420×2.50 = 1050; Amoxiclin-250 = 180×6.20 = 1116; Cetrizyn-10 = 300×1.80 = 540; Metfor-500 = 250×3.40 = 850; Omepra-20 = 360×2.90 = 1044; Vitacal-D3 = 150×4.50 = 675. Sum = 1050+1116+540+850+1044+675 = 5275.

Question 3

Single correct option

Which medicine represents the largest cost-price value currently held in stock?
  1. A. Paracet-500
  2. B. Amoxiclin-250
  3. C. Omepra-20
  4. D. Cetrizyn-10
Show answer and solution

Answer: (B) Amoxiclin-250

CP values: Paracet-500 = 1050, Amoxiclin-250 = 1116, Omepra-20 = 1044, Cetrizyn-10 = 540 (Metfor-500=850, Vitacal-D3=675, both lower). The largest is Amoxiclin-250 at ₹1116, even though it has fewer units than several others, because its cost price per unit is much higher.

Question 4

Numerical answer

What is the combined cost-price value (in ₹) of medicines that will expire within 6 months (i.e., 6 months or less)?
Show answer and solution

Answer: 1966

Medicines with expiry ≤ 6 months: Amoxiclin-250 (5 months, CP value 180×6.20=1116) and Metfor-500 (3 months, CP value 250×3.40=850). Combined = 1116+850 = 1966.

Question 5

Single correct option

If the entire stock of all six medicines is sold at the listed selling prices, what is the overall profit margin (total profit as a percentage of total cost price), to the nearest whole number?
  1. A. 44%
  2. B. 46%
  3. C. 48%
  4. D. 50%
Show answer and solution

Answer: (C) 48%

Total CP value = 5275 (computed earlier). Total SP value = sum of Stock×SP/unit = 420×3.80 + 180×9.00 + 300×2.70 + 250×5.10 + 360×4.20 + 150×6.75 = 1596+1620+810+1275+1512+1012.5 = 7825.5. Overall profit% = (7825.5−5275)/5275×100 ≈ 48.35%, which rounds to 48%.
Report a mistake

Original question written in the CAT 2023 Slot 1 pattern and checked twice for the correct answer. Not an official question paper. How we write and check questions · Corrections policy · Report a mistake