Question 1

What is the average quarterly sales of Store D?

Accepted Answer

Step 1: Add all quarterly sales of Store D: 30 + 45 + 60 + 75 = 210 lakhs. Step 2: Divide by 4 quarters: 210 ÷ 4 = 52.5 lakhs.

Question 2

What is the difference between the total sales of Product C and Product E from January to June?

Accepted Answer

Step 1: Total sales of Product C = 20+20+20+20+20+20 = 120 lakhs
Step 2: Total sales of Product E = 15+14+13+12+11+10 = 75 lakhs
Step 3: Difference = 120 - 75 = 45 lakhs

Question 3

What is the total sales of Product A from January to June?

Accepted Answer

Step 1: Add all monthly sales of Product A: 12 + 15 + 18 + 20 + 22 + 25 = 112 lakhs

Question 4

What is the total sales of Store A across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Store A. Step 2: 50 + 60 + 70 + 80 = 260 lakhs.

Question 5

What is the average number of units sold by Company E across all four quarters?

Accepted Answer

Step 1: Total units sold by Company E = 1400 + 1600 + 1600 + 2400 = 7000. Step 2: Average = Total / Number of quarters = 7000 / 4 = 1750. Answer: 1750

Question 6

What is the difference between the total sales of Store C and Store E across all quarters?

Accepted Answer

Step 1: Total sales of Store C = 60 + 60 + 60 + 60 = 240 lakhs. Step 2: Total sales of Store E = 80 + 75 + 70 + 65 = 290 lakhs. Step 3: Difference = 290 - 240 = 50 lakhs.

Question 7

By what percentage did Product D's sales increase from January to June?

Accepted Answer

Step 1: Product D sales in January = 5 lakhs
Step 2: Product D sales in June = 15 lakhs
Step 3: Increase = 15 - 5 = 10 lakhs
Step 4: Percentage increase = (10/5) × 100 = 200%

Question 8

Which product has the highest total sales from January to June?

Accepted Answer

Step 1: Calculate total for each product:
Product A: 12+15+18+20+22+25 = 112
Product B: 8+10+12+14+16+18 = 78
Product C: 20+20+20+20+20+20 = 120
Product D: 5+7+9+11+13+15 = 60
Product E: 15+14+13+12+11+10 = 75
Step 2: Product C has the highest total of 120 lakhs

Question 9

What is the average monthly sales of Product B?

Accepted Answer

Step 1: Total sales of Product B = 8+10+12+14+16+18 = 78 lakhs
Step 2: Average = 78 ÷ 6 = 13 lakhs per month

Question 10

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

Accepted Answer

Step 1: Q1 sales of Store B = 40 lakhs, Q4 sales = 70 lakhs. Step 2: Increase = 70 - 40 = 30 lakhs. Step 3: Percentage increase = (30 ÷ 40) × 100 = 75%.

Question 11

If the production growth rate from Q3 to Q4 for Laptops continues at the same rate, what would be the expected production in Q5?

Accepted Answer

Step 1: Q3 Laptops production = 90, Q4 Laptops production = 105. Step 2: Growth from Q3 to Q4 = 105 - 90 = 15 thousand units. Step 3: If same growth continues, Q5 production = 105 + 15 = 120 thousand units.

Question 12

What is the average production of Beta company across all four quarters?

Accepted Answer

Step 1: Add all quarterly production values for Beta: 100 + 120 + 140 + 160 = 520 thousand units. Step 2: Divide by number of quarters: 520 ÷ 4 = 130 thousand units.

Question 13

Which product showed the highest total production across all four quarters?

Accepted Answer

Step 1: Calculate total for each product. Smartphones: 120+150+180+210 = 660. Tablets: 80+100+120+140 = 440. Laptops: 60+75+90+105 = 330. Smartwatches: 40+50+60+70 = 220. Headphones: 100+120+140+160 = 520. Step 2: Smartphones has the highest total of 660 thousand units.

Question 14

By what percentage did Alpha's production increase from Q1 to Q4?

Accepted Answer

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

Question 15

What is the ratio of total sales of Company B to total sales of Company D over all four years?

Accepted Answer

Step 1: Total sales of Company B = 200 + 250 + 300 + 350 = 1100 Lakhs. Step 2: Total sales of Company D = 80 + 100 + 140 + 160 = 480 Lakhs. Step 3: Ratio = 1100 : 480 = 55 : 24. Answer: 55 : 24.

Question 16

What is the ratio of Gamma's Q4 production to Delta's Q4 production?

Accepted Answer

Step 1: Gamma's Q4 production = 140 thousand units. Step 2: Delta's Q4 production = 140 thousand units. Step 3: Ratio = 140:140 = 1:1.

Question 17

What is the ratio of Smartwatches production in Q2 to Headphones production in Q2?

Accepted Answer

Step 1: Smartwatches production in Q2 = 50 thousand units. Step 2: Headphones production in Q2 = 120 thousand units. Step 3: Ratio = 50 : 120 = 5 : 12 (after dividing both by 10).

Question 18

By what percentage did Smartphone production increase from Q1 to Q4?

Accepted Answer

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

Question 19

In Q2, what was the difference between the highest and lowest production among all companies?

Accepted Answer

Step 1: Q2 production values are: Alpha=150, Beta=120, Gamma=100, Delta=140, Epsilon=130. Step 2: Highest = 150 (Alpha), Lowest = 100 (Gamma). Step 3: Difference = 150 - 100 = 50 thousand units.

Question 20

Which company had the highest total production across all four quarters?

Accepted Answer

Step 1: Calculate total for each company. Alpha: 120+150+180+210 = 660. Beta: 100+120+140+160 = 520. Gamma: 80+100+120+140 = 440. Delta: 140+140+140+140 = 560. Epsilon: 110+130+150+170 = 560. Step 2: Alpha has the highest total of 660 thousand units.

Question 21

What is the average production of Tablets across all four quarters?

Accepted Answer

Step 1: Add production of Tablets across all quarters = 80 + 100 + 120 + 140 = 440 thousand units. Step 2: Divide by number of quarters = 440 ÷ 4 = 110 thousand units.

Question 22

What is the average sales (in ₹ Lakhs) of all five companies in the year 2022?

Accepted Answer

Step 1: Total sales of all companies in 2022 = 180 + 300 + 240 + 140 + 300 = 1160 Lakhs. Step 2: Average = 1160 ÷ 5 = 232 Lakhs. Answer: ₹232 Lakhs.

Question 23

What is the percentage increase in the sales of Company A from 2020 to 2023?

Accepted Answer

Step 1: Sales of Company A in 2020 = ₹120 Lakhs; Sales in 2023 = ₹240 Lakhs. Step 2: Increase = 240 - 120 = 120 Lakhs. Step 3: Percentage increase = (120 / 120) × 100 = 100%. Answer: 100%.

Question 24

In which year was the total sales of all five companies together the highest?

Accepted Answer

Step 1: Total sales in 2020 = 120+200+160+80+240 = 800 Lakhs. Step 2: Total sales in 2021 = 150+250+200+100+270 = 970 Lakhs. Step 3: Total sales in 2022 = 180+300+240+140+300 = 1160 Lakhs. Step 4: Total sales in 2023 = 240+350+280+160+330 = 1360 Lakhs. Step 5: Highest total is in 2023 = 1360 Lakhs. Answer: 2023.

Question 25

In Q3, what is the ratio of total production of Alpha and Epsilon combined to the total production of Delta and Gamma combined?

Accepted Answer

Step 1: Q3 Production of Alpha and Epsilon = 150 + 133 = 283 thousand units.
Step 2: Q3 Production of Delta and Gamma = 108 + 108 = 216 thousand units.
Step 3: Ratio = 283 : 216.
Step 4: Simplify by finding GCD. 283 and 216 share no common factors (283 is prime).
Step 5: Express as decimal ratio = 283 ÷ 216 ≈ 1.31 or approximately 283:216 which simplifies to approximately 1.31:1.

Question 26

If the cost price per unit is ₹100 for all companies, what is the total profit (in ₹ lakhs) earned by Epsilon across all four quarters? [Profit = Production × Cost Price × Profit % ÷ 100]

Accepted Answer

Step 1: Calculate profit for each quarter of Epsilon:
Q1: 220 × 100 × 18 ÷ 100 = 3960 (in ₹ thousands)
Q2: 240 × 100 × 19 ÷ 100 = 4560 (in ₹ thousands)
Q3: 260 × 100 × 21 ÷ 100 = 5460 (in ₹ thousands)
Q4: 280 × 100 × 23 ÷ 100 = 6440 (in ₹ thousands)
Step 2: Total profit = 3960 + 4560 + 5460 + 6440 = 20420 (in ₹ thousands) = 204.2 (in ₹ lakhs)

Question 27

If the revenue per unit (in crore per thousand units) for Gamma in Q2 is the same as in Q3, and the Q3 production was 108 thousand units, what should the Q3 revenue have been? (The given Q3 revenue is 432 crore. Is the data consistent?)

Accepted Answer

Step 1: Calculate revenue per unit for Gamma in Q2 = 384 ÷ 96 = 4 crore per thousand units.
Step 2: If this rate applies to Q3 with 108 thousand units production, Q3 revenue should be = 108 × 4 = 432 crore rupees.
Step 3: The given Q3 revenue for Gamma is 432 crore rupees.
Step 4: The data is consistent. The answer confirms the consistency and the expected Q3 revenue is 432 crore rupees.

Question 28

What is the average revenue per thousand units produced (in rupees) by company Beta across all four quarters?

Accepted Answer

Step 1: Calculate total production for Beta = 100 + 110 + 125 + 140 = 475 thousand units.
Step 2: Calculate total revenue for Beta = 350 + 385 + 437.5 + 490 = 1662.5 crore rupees.
Step 3: Convert crore to rupees = 1662.5 × 10,000,000 = 16,625,000,000 rupees.
Step 4: Average revenue per thousand units = 16,625,000,000 ÷ 475 = 35,000,000 rupees per thousand units = 3.5 crore per thousand units.
Alternatively: 1662.5 ÷ 475 = 3.5 crore per thousand units.

Question 29

What is the difference between the total annual revenue of Alpha and the total annual revenue of Delta (in crore rupees)?

Accepted Answer

Step 1: Total annual revenue of Alpha = 480 + 540 + 675 + 810 = 2505 crore rupees.
Step 2: Total annual revenue of Delta = 270 + 297 + 324 + 378 = 1269 crore rupees.
Step 3: Difference = 2505 - 1269 = 1236 crore rupees.

Question 30

By what percentage did Delta's production increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 production of Delta = 160 thousand units
Step 2: Q4 production of Delta = 210 thousand units
Step 3: Increase = 210 - 160 = 50 thousand units
Step 4: Percentage increase = (50 ÷ 160) × 100 = 31.25%

Question 31

Plant B's production increased by what percentage from Q1 to Q4?

Accepted Answer

Step 1: Q1 production of Plant B = 100 thousand units.
Step 2: Q4 production of Plant B = 133 thousand units.
Step 3: Increase = 133 - 100 = 33 thousand units.
Step 4: Percentage increase = (33 / 100) × 100 = 33%.

Question 32

Which plant showed the highest absolute profit (in thousand rupees) in Q3, and what was that profit?

Accepted Answer

Step 1: Calculate Q3 profit for each plant using formula: Production × Profit % / 100.
Plant A: 150 × 20 / 100 = 30
Plant B: 121 × 16 / 100 = 19.36
Plant C: 169 × 14 / 100 = 23.66
Plant D: 97 × 24 / 100 = 23.28
Plant E: 133 × 20 / 100 = 26.6
Step 2: Compare all profits. Plant A has the highest at 30 thousand rupees.

Question 33

What is the ratio of Store E's total Q1 sales to Store D's total Q1 sales?

Accepted Answer

Step 1: Store E total Q1 = 165 lakhs. Step 2: Store D total Q1 = 135 lakhs. Step 3: Ratio = 165:135. Step 4: Simplify by dividing both by 15 = 11:9.

Question 34

What is the total sales of Product C across all four quarters?

Accepted Answer

Step 1: Add all quarterly sales of Product C. Step 2: 200 + 200 + 200 + 200 = 800 lakhs.

Question 35

What is the ratio of Q2 sales of Product D to Q2 sales of Product B?

Accepted Answer

Step 1: Read Q2 sales from table: Product D Q2 = 90 lakhs, Product B Q2 = 100 lakhs. Step 2: Ratio = 90:100 = 9:10 (simplified). Answer: 9:10

Question 36

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

Accepted Answer

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

Question 37

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 38

What is the ratio of Q1 sales of Store A to Q1 sales of Store D?

Accepted Answer

Step 1: Store A Q1 sales = 50 lakhs, Store D Q1 sales = 30 lakhs. Step 2: Ratio = 50 : 30 = 5 : 3 (after dividing both by 10).

Question 39

Which store has the highest sales in Q3?

Accepted Answer

Step 1: Compare Q3 sales for all stores: Store A = 70, Store B = 60, Store C = 60, Store D = 60, Store E = 60. Step 2: Store A has the highest Q3 sales at 70 lakhs.

Question 40

What is the total sales of Store A across all four quarters?

Accepted Answer

Step 1: Add sales of Store A for all quarters: Q1 + Q2 + Q3 + Q4 = 50 + 60 + 70 + 80 = 260 lakhs.

Question 41

What is the total sales of Store B for Q1 2024?

Accepted Answer

Step 1: From the table, locate Store B row. Step 2: Read the Total Q1 column for Store B. Step 3: The value is 195 lakhs.

Question 42

What is the ratio of Q4 sales of Delhi to Q4 sales of Kolkata?

Accepted Answer

Step 1: Q4 sales of Delhi = 210 lakhs, Q4 sales of Kolkata = 170 lakhs. Step 2: Ratio = 210:170 = 21:17 (dividing both by 10).

Question 43

By what percentage did Store E's sales decrease from Q1 to Q4?

Accepted Answer

Step 1: Store E Q1 sales = 80 lakhs, Q4 sales = 50 lakhs. Step 2: Decrease = 80 - 50 = 30 lakhs. Step 3: Percentage decrease = (30 ÷ 80) × 100 = 37.5%.

Question 44

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 + 170 + 180 = 650 lakhs.

Question 45

By what percentage did the West branch's sales increase from Q1 to Q4?

Accepted Answer

Step 1: Q1 sales of West = 110 lakhs, Q4 sales = 170 lakhs. Step 2: Increase = 170 - 110 = 60 lakhs. Step 3: Percentage increase = (60 ÷ 110) × 100 = 54.54%. Approximately 54.5% or 55% (rounding to nearest integer gives approximately 55%).

Question 46

Which branch showed the maximum growth from Q1 to Q4?

Accepted Answer

Step 1: Calculate growth for each branch (Q4 - Q1). Delhi: 210-120=90, Mumbai: 180-140=40, Bangalore: 160-100=60, Chennai: 140-80=60, Kolkata: 170-110=60. Step 2: Delhi has the maximum growth of 90 lakhs.

Question 47

What is the ratio of Q4 sales of Product D to Q4 sales of Product E?

Accepted Answer

Step 1: Q4 sales of D = 150 lakhs, Q4 sales of E = 130 lakhs. Step 2: Ratio = 150:130 = 15:13 (dividing both by 10).

Question 48

What is the ratio of Q4 sales of Central branch to Q4 sales of North branch?

Accepted Answer

Step 1: Q4 sales of Central = 150 lakhs, Q4 sales of North = 210 lakhs. Step 2: Ratio = 150 : 210. Step 3: Simplify by dividing both by 30: 150 ÷ 30 = 5, 210 ÷ 30 = 7. Step 4: Ratio = 5 : 7.

Question 49

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

Accepted Answer

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

Question 50

What is the average sales of Bangalore branch across all 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 51

What is the average sales of Store D across all four quarters?

Accepted Answer

Step 1: Total sales of Store D = 30 + 45 + 60 + 75 = 210 lakhs. Step 2: Average = 210 ÷ 4 = 52.5 lakhs.

Question 52

Which store recorded the lowest total sales in Q1 2024?

Accepted Answer

Step 1: Compare all Total Q1 values. Store A = 150, Store B = 195, Store C = 105, Store D = 135, Store E = 165. Step 2: The lowest value is 105 lakhs. Step 3: This belongs to Store C.

LIC AAO Tables

LIC AAO Tables — Past Exam Questions

Tables— Rules & Concept

Key Points to Remember

Exam-Specific Tips

Tables — Practice Questions

60-Second Revision — Tables