Question 1

What is the total sales of the Delhi branch across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Delhi. Step 2: 120 + 150 + 180 + 210 = 660 lakhs.

Question 2

What is the average quarterly sales of Tablets?

Accepted Answer

Step 1: Tablet sales are 80, 90, 100, 110 lakhs in Q1, Q2, Q3, Q4 respectively.
Step 2: Average = (80 + 90 + 100 + 110) / 4 = 380 / 4 = 95 lakhs.
Answer: 95 lakhs

Question 3

What is the average sales of the Bangalore branch across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Bangalore: 100 + 120 + 140 + 160 = 520 lakhs. Step 2: Divide by 4 quarters: 520 ÷ 4 = 130 lakhs.

Question 4

Which product category had the highest total sales across all four quarters?

Accepted Answer

Step 1: Calculate total sales for each category:
- Smartphones: 150 + 180 + 210 + 240 = 780
- Laptops: 120 + 140 + 160 + 180 = 600
- Tablets: 80 + 90 + 100 + 110 = 380
- Accessories: 60 + 70 + 80 + 90 = 300
- Software: 40 + 50 + 60 + 70 = 220
Step 2: Smartphones has the highest total of 780 lakhs.
Answer: Smartphones

Question 5

Which branch has the highest sales in Q3?

Accepted Answer

Step 1: Compare Q3 sales across all branches. Delhi = 180, Mumbai = 175, Bangalore = 140, Chennai = 120, Kolkata = 150. Step 2: Delhi has the highest Q3 sales at 180 lakhs.

Question 6

What is the percentage increase in sales of the Chennai branch from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 80 lakhs, Q4 sales = 140 lakhs. Step 2: Increase = 140 - 80 = 60 lakhs. Step 3: Percentage increase = (60/80) × 100 = 75%.

Question 7

What is the total sales of Smartphones across all four quarters?

Accepted Answer

Step 1: Add all Smartphone sales across Q1, Q2, Q3, and Q4.
Step 2: 150 + 180 + 210 + 240 = 780 lakhs.
Answer: 780 lakhs

Question 8

What is the ratio of Q1 sales of Mumbai to Q1 sales of Kolkata?

Accepted Answer

Step 1: Q1 sales of Mumbai = 140 lakhs, Q1 sales of Kolkata = 110 lakhs. Step 2: Ratio = 140:110 = 14:11 (dividing both by 10).

Question 9

By what percentage did Laptop sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 Laptop sales = 120 lakhs, Q4 Laptop sales = 180 lakhs.
Step 2: Increase = 180 - 120 = 60 lakhs.
Step 3: Percentage increase = (60 / 120) × 100 = 50%.
Answer: 50%

Question 10

What is the ratio of Q4 sales of Software to Q4 sales of Accessories?

Accepted Answer

Step 1: Q4 Software sales = 70 lakhs, Q4 Accessories sales = 90 lakhs.
Step 2: Ratio = 70 : 90 = 7 : 9 (dividing both by 10).
Answer: 7:9

Question 11

What is the percentage increase in total sales of Delta Pvt from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of Delta Pvt = 4000 units
Step 2: Q4 sales of Delta Pvt = 5800 units
Step 3: Increase = 5800 - 4000 = 1800 units
Step 4: Percentage increase = (1800/4000) × 100 = 45%
Answer: 45%

Question 12

What is the average quarterly sales of Home & Kitchen category?

Accepted Answer

Step 1: Sum of Home & Kitchen sales = 60 + 75 + 90 + 105 = 330 lakhs. Step 2: Average = 330 ÷ 4 = 82.5 lakhs.

Question 13

Which region had the highest total sales across all four quarters?

Accepted Answer

Step 1: North total = 450 + 540 + 630 + 720 = 2,340 Lakhs
Step 2: South total = 380 + 420 + 480 + 560 = 1,840 Lakhs
Step 3: East total = 320 + 360 + 400 + 480 = 1,560 Lakhs
Step 4: West total = 400 + 500 + 600 + 700 = 2,200 Lakhs
Step 5: Comparing all totals: North (2,340) > West (2,200) > South (1,840) > East (1,560)
Answer: North region

Question 14

By what percentage did the North region's sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales (North) = 450 Lakhs, Q4 sales (North) = 720 Lakhs
Step 2: Increase = 720 - 450 = 270 Lakhs
Step 3: Percentage increase = (270 ÷ 450) × 100 = 60%
Answer: 60%

Question 15

What is the total sales of Electronics category across all four quarters?

Accepted Answer

Step 1: Add all Electronics sales across quarters: Q1 + Q2 + Q3 + Q4 = 120 + 150 + 180 + 210 = 660 lakhs.

Question 16

By what percentage did Clothing sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 Clothing sales = 80 lakhs, Q4 Clothing sales = 140 lakhs. Step 2: Increase = 140 - 80 = 60 lakhs. Step 3: Percentage increase = (60/80) × 100 = 75%.

Question 17

What is the ratio of South region's Q4 sales to East region's Q4 sales?

Accepted Answer

Step 1: South Q4 sales = 560 Lakhs
Step 2: East Q4 sales = 480 Lakhs
Step 3: Ratio = 560 : 480
Step 4: Simplify by dividing both by 80 = 7 : 6
Answer: 7:6

Question 18

What is the total revenue (in ₹) earned by Company C and Company D together in the year 2023?

Accepted Answer

Step 1: Total Revenue of Company C = Units Sold × Selling Price = 8,000 × 250 = ₹20,00,000. Step 2: Total Revenue of Company D = Units Sold × Selling Price = 15,000 × 180 = ₹27,00,000. Step 3: Combined Revenue = 20,00,000 + 27,00,000 = ₹47,00,000. Answer: ₹47,00,000.

Question 19

Which manufacturer has the highest sales efficiency (sales as % of production) across all four quarters combined?

Accepted Answer

Step 1: Calculate total production and sales for each manufacturer across all quarters.
Alpha: Prod = 23000, Sales = 21700, Efficiency = (21700/23000) × 100 = 94.35%
Beta: Prod = 21600, Sales = 20100, Efficiency = (20100/21600) × 100 = 93.06%
Gamma: Prod = 27000, Sales = 25600, Efficiency = (25600/27000) × 100 = 94.81%
Delta: Prod = 21000, Sales = 19600, Efficiency = (19600/21000) × 100 = 93.33%
Epsilon: Prod = 25000, Sales = 23500, Efficiency = (23500/25000) × 100 = 94%
Step 2: Gamma Inc has the highest efficiency at 94.81%
Answer: Gamma Inc

Question 20

In Q3, what is the ratio of total production of Beta Ltd and Delta Pvt combined to that of Gamma Inc?

Accepted Answer

Step 1: Q3 production of Beta Ltd = 5600 units
Step 2: Q3 production of Delta Pvt = 5500 units
Step 3: Combined production of Beta and Delta = 5600 + 5500 = 11100 units
Step 4: Q3 production of Gamma Inc = 7000 units
Step 5: Ratio = 11100 : 7000 = 111 : 70 (dividing both by 100)
Answer: 111:70

Question 21

In Q3, what is the ratio of Sports & Outdoors sales to Books & Media sales?

Accepted Answer

Step 1: Q3 Sports & Outdoors sales = 60 lakhs. Step 2: Q3 Books & Media sales = 30 lakhs. Step 3: Ratio = 60:30 = 2:1.

Question 22

Which product category shows a consistent growth of 30 lakhs per quarter?

Accepted Answer

Step 1: Check Electronics: 120→150 (30), 150→180 (30), 180→210 (30). Consistent growth of 30 lakhs per quarter. Step 2: Verify others do not have this pattern. Electronics is the answer.

Question 23

What is the average production across all manufacturers in Q2?

Accepted Answer

Step 1: Add Q2 production for all manufacturers: 5500 + 5200 + 6500 + 5000 + 6000 = 28200 units
Step 2: Divide by number of manufacturers: 28200 ÷ 5 = 5640 units
Answer: 5640 units

Question 24

Which plant has the highest total unsold inventory (Production - Sales) across all four quarters combined?

Accepted Answer

Step 1: Calculate unsold inventory for each plant across all quarters:
Plant A: (8000-7200) + (9000-8100) + (10500-9450) + (11000-10120) = 800 + 900 + 1050 + 880 = 3630
Plant B: (6500-5850) + (7200-6480) + (8100-7290) + (9000-8370) = 650 + 720 + 810 + 630 = 2810
Plant C: (7500-6750) + (8400-7560) + (9200-8280) + (10000-9200) = 750 + 840 + 920 + 800 = 3310
Plant D: (5500-4950) + (6200-5580) + (7000-6300) + (7800-7020) = 550 + 620 + 700 + 780 = 2650
Plant E: (9000-8100) + (10000-9000) + (11500-10350) + (12500-11250) = 900 + 1000 + 1150 + 1250 = 4300

Step 2: Plant E has the highest unsold inventory of 4300 units.

Question 25

For Product C, what is the percentage of total annual sales relative to total annual production?

Accepted Answer

Step 1: Calculate total annual production for Product C: 4000 + 4500 + 5000 + 5500 = 19000 units. Step 2: Calculate total annual sales for Product C: 3600 + 4200 + 4800 + 5300 = 17900 units. Step 3: Percentage = (17900 ÷ 19000) × 100 = 94.21%. Rounding to nearest whole number = 94%.

Question 26

What is the average production across all four product lines for Q2?

Accepted Answer

Step 1: Identify Q2 Production for all products: Product A = 5500, Product B = 3200, Product C = 4500, Product D = 2800. Step 2: Sum = 5500 + 3200 + 4500 + 2800 = 16000. Step 3: Average = 16000 ÷ 4 = 4000 units.

Question 27

What is the average sales conversion rate (Sales/Production × 100) across all plants in Q2? (Round to nearest integer)

Accepted Answer

Step 1: Calculate Q2 conversion rate for each plant:
Plant A: (8100/9000) × 100 = 90%
Plant B: (6480/7200) × 100 = 90%
Plant C: (7560/8400) × 100 = 90%
Plant D: (5580/6200) × 100 = 90%
Plant E: (9000/10000) × 100 = 90%

Step 2: Average = (90 + 90 + 90 + 90 + 90) / 5 = 450 / 5 = 90%

Question 28

What is the percentage increase in total production from Q1 to Q4 across all plants combined?

Accepted Answer

Step 1: Calculate total Q1 production:
8000 + 6500 + 7500 + 5500 + 9000 = 36500 units

Step 2: Calculate total Q4 production:
11000 + 9000 + 10000 + 7800 + 12500 = 50300 units

Step 3: Percentage increase = ((50300 - 36500) / 36500) × 100
= (13800 / 36500) × 100
= 37.81% ≈ 38%

Question 29

Which product line has the highest total annual sales, and what is the difference between its sales and the product line with the lowest total annual sales?

Accepted Answer

Step 1: Calculate total annual sales for each product. Product A: 4500 + 5200 + 5800 + 6200 = 21700. Product B: 2700 + 3100 + 3400 + 3600 = 12800. Product C: 3600 + 4200 + 4800 + 5300 = 17900. Product D: 2250 + 2600 + 3000 + 3400 = 11250. Step 2: Highest = Product A (21700), Lowest = Product D (11250). Step 3: Difference = 21700 - 11250 = 10450 units.

Question 30

What is the average sales of the Chennai branch across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Chennai: 80 + 100 + 120 + 140 = 440 lakhs. Step 2: Divide by 4 quarters: 440 ÷ 4 = 110 lakhs.

Question 31

What is the total sales of the Mumbai branch across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Mumbai. Step 2: 140 + 160 + 200 + 240 = 740 lakhs.

Question 32

What is the average sales of the Central branch across all four quarters?

Accepted Answer

Step 1: Total sales of Central = 110 + 130 + 150 + 170 = 560 lakhs. Step 2: Average = 560 ÷ 4 = 140 lakhs.

Question 33

Which product category had the highest total sales across all four quarters?

Accepted Answer

Step 1: Smartphones total = 120 + 150 + 180 + 240 = 690. Step 2: Laptops total = 80 + 100 + 120 + 160 = 460. Step 3: Tablets total = 60 + 75 + 90 + 120 = 345. Step 4: Accessories total = 40 + 50 + 60 + 80 = 230. Step 5: Smartphones has the highest total of 690 lakhs. Answer: Smartphones

Question 34

By what percentage did Delhi's sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 120 lakhs, Q4 sales = 210 lakhs. Step 2: Increase = 210 - 120 = 90 lakhs. Step 3: Percentage increase = (90 ÷ 120) × 100 = 75%.

Question 35

In Q3, what is the ratio of Smartphones sales to Accessories sales?

Accepted Answer

Step 1: Q3 Smartphones sales = 180 lakhs. Step 2: Q3 Accessories sales = 60 lakhs. Step 3: Ratio = 180:60 = 3:1. Answer: 3:1

Question 36

What is the total sales revenue for Smartphones across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales for Smartphones. Step 2: 120 + 150 + 180 + 240 = 690 lakhs ₹. Answer: 690 lakhs ₹

Question 37

What is the average quarterly sales for Tablets?

Accepted Answer

Step 1: Sum all Tablets sales = 60 + 75 + 90 + 120 = 345 lakhs. Step 2: Average = 345 ÷ 4 = 86.25 lakhs ₹. Answer: 86.25 lakhs ₹

Question 38

What is the percentage increase in sales of the Delhi branch from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of Delhi = 120 lakhs, Q4 sales = 210 lakhs. Step 2: Increase = 210 - 120 = 90 lakhs. Step 3: Percentage increase = (90/120) × 100 = 75%. Answer: 75%

Question 39

Which product category had the highest total sales across all four quarters?

Accepted Answer

Step 1: Calculate total for each category. Smartphones: 660, Laptops: 440, Tablets: 330, Accessories: 220, Software: 260. Step 2: Smartphones has the highest total of 660 lakhs.

Question 40

What is the average quarterly sales of Tablets?

Accepted Answer

Step 1: Tablets sales are 60, 75, 90, 105 lakhs. Step 2: Sum = 60 + 75 + 90 + 105 = 330 lakhs. Step 3: Average = 330 ÷ 4 = 82.5 lakhs.

Question 41

What is the percentage increase in sales of the East branch from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of East = 80 lakhs, Q4 sales = 140 lakhs. Step 2: Increase = 140 - 80 = 60 lakhs. Step 3: Percentage increase = (60/80) × 100 = 75%.

Question 42

In Q2, what is the ratio of sales of Store A to Store B?

Accepted Answer

Step 1: Q2 sales of Store A = 150 lakhs ₹. Step 2: Q2 sales of Store B = 110 lakhs ₹. Step 3: Ratio = 150:110 = 15:11 (dividing both by 10).

Question 43

What is the total sales of Smartphones across all four quarters?

Accepted Answer

Step 1: Add all Smartphone sales across quarters. Step 2: 120 + 150 + 180 + 210 = 660 lakhs.

Question 44

What is the percentage increase in sales of Store D from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of Store D = 80 lakhs ₹, Q4 sales = 160 lakhs ₹. Step 2: Increase = 160 - 80 = 80 lakhs ₹. Step 3: Percentage increase = (80/80) × 100 = 100%.

Question 45

What is the ratio of Q1 sales of South branch to Q1 sales of West branch?

Accepted Answer

Step 1: Q1 sales of South = 100 lakhs, Q1 sales of West = 140 lakhs. Step 2: Ratio = 100:140 = 5:7 (dividing both by 20).

Question 46

What is the total sales of the North branch across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of North branch. Step 2: 120 + 150 + 180 + 210 = 660 lakhs.

Question 47

By what percentage did Laptops sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales = 80 lakhs, Q4 sales = 160 lakhs. Step 2: Increase = 160 - 80 = 80 lakhs. Step 3: Percentage increase = (80/80) × 100 = 100%. Answer: 100%

Question 48

What is the average sales of the Bangalore branch across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Bangalore. Step 2: 100 + 120 + 140 + 160 = 520 lakhs. Step 3: Average = 520 ÷ 4 = 130 lakhs. Answer: 130 lakhs

Question 49

What is the ratio of Bangalore's Q4 sales to Kolkata's Q4 sales?

Accepted Answer

Step 1: Bangalore Q4 = 160 lakhs, Kolkata Q4 = 170 lakhs. Step 2: Ratio = 160 : 170. Step 3: Simplify by dividing both by 10: 16 : 17.

AFCAT Caselets (paragraph DI)

AFCAT Caselets (paragraph DI) — Past Exam Questions

Caselets (paragraph DI) — Practice Questions