Question

The total sales (in ₹ million) in 2019 from products in office supplies category is closest to

• A. 18.0
• B. 16.5
• C. 13.5
• D. 12.5
• A. 20%
• B. 8%
• C. 25%
• D. 1%
• A. furniture, technology, office supply
• B. technology, furniture, office supply
• C. office supply, technology, furniture
• D. office supply, furniture, technology

Answer 1

The Correct Option is C

To determine the total sales for the office supplies category in 2019, we first isolate subcategories not classified as furniture or technology. These include:

• Paper
• Labels
• Storage
• Appliances
• Binders
• Envelopes
• Fasteners
• Art
• Presentation
• Supplies

By referencing the bar graph's vertical lines for these subcategories, we can estimate their 2019 sales in ₹ million. The sum of these estimates provides the approximate total office supplies sales for 2019.

Subcategory	2019 Sales (₹ million)
Paper	2.5
Labels	1.0
Storage	0.5
Appliances	1.0
Binders	1.5
Envelopes	1.0
Fasteners	1.0
Art	1.0
Presentation	2.0
Supplies	2.0

The summation of these values is as follows:

2.5 + 1.0 + 0.5 + 1.0 + 1.5 + 1.0 + 1.0 + 1.0 + 2.0 + 2.0 = 13.5

Consequently, the total 2019 sales for the office supplies category are approximately ₹13.5 million.

Answer 2

To determine the percentage sales growth for Furniture from 2019 to 2020, execute the following steps:

1. Record the sales figures for each Furniture subcategory (Bookcases, Chairs, Furnishings, Tables) for both 2019 and 2020.
2. Aggregate the sales for each year:
   • 2019 Total Sales = Bookcases₂₀₁₉ + Chairs₂₀₁₉ + Furnishings₂₀₁₉ + Tables₂₀₁₉
   • 2020 Total Sales = Bookcases₂₀₂₀ + Chairs₂₀₂₀ + Furnishings₂₀₂₀ + Tables₂₀₂₀
3. Calculate the sales difference: Sales Variance = 2020 Total Sales - 2019 Total Sales
4. Compute the percentage increase:

Percentage Increase = (Sales Variance / 2019 Total Sales) × 100

Based on the provided diagram and data:

• 2019 Sales were approximately ₹100 million.
• 2020 Sales were approximately ₹108 million.

Consequently, the Sales Variance = ₹108 million - ₹100 million = ₹8 million.

Percentage Increase = (₹8 million / ₹100 million) × 100 = 8%

Therefore, the sales increase for the Furniture category between 2019 and 2020 is approximately 8%.

Answer 3

• Condition 1: 2019 sales must be at least ₹ 4 million.
• Condition 2: 2020 sales must exceed 2019 sales by more than 25%.

Evaluating each subcategory:

1. Chairs:
   2019 Sales: ₹ 6.2 million
   2020 Sales: ₹ 7 million
   Required 2020 sales for 25% increase: \( 6.2 \times 1.25 = 7.75 \) million
   Result: ₹ 7 million is less than ₹ 7.75 million, so this subcategory fails.
2. Tables:
   2019 Sales: ₹ 4.4 million
   2020 Sales: ₹ 4.5 million
   Required 2020 sales for 25% increase: \( 4.4 \times 1.25 = 5.5 \) million
   Result: ₹ 4.5 million is less than ₹ 5.5 million, so this subcategory fails.
3. Storage:
   2019 Sales: ₹ 4.3 million
   2020 Sales: ₹ 5.1 million
   Required 2020 sales for 25% increase: \( 4.3 \times 1.25 = 5.375 \) million
   Result: ₹ 5.1 million is less than ₹ 5.375 million, so this subcategory fails.
4. Phones:
   2019 Sales: ₹ 5.75 million
   2020 Sales: ₹ 7.5 million
   Percentage increase: \( \frac{7.5 - 5.75}{5.75} \times 100 = 30.43\% \)
   Result: 30.43% is greater than 25%, so this subcategory satisfies both conditions.

Conclusion: Only one subcategory, Phones, meets the specified criteria.

Answer 4

To establish the improvement index for each category, calculate the sales percentage increase from 2019 to 2020 for subcategories within each main category. The improvement index represents the highest percentage increase observed among the subcategories of a given category. The procedure to determine the correct order is as follows:

1. Furniture: Subcategories include Bookcases, Chairs, Furnishings, and Tables. Determine the maximum percentage increase.
2. Technology: Subcategories comprise Accessories, Copiers, Machines, and Phones. Determine the maximum percentage increase.
3. Office Supply: This category includes all subcategories not listed under Furniture or Technology. Determine the maximum percentage increase.
4. Compute the percentage increase for each subcategory using the formula: \[ \text{Percentage Increase} = \left(\frac{\text{Sales in 2020} - \text{Sales in 2019}}{\text{Sales in 2019}}\right) \times 100 \]
5. Identify the maximum percentage increase for each category:

Category	Max Percentage Increase
Furniture	Calculated Value
Technology	Calculated Value
Office Supply	Calculated Value

6. Arrange the categories in ascending order based on their respective maximum percentage increases.

The correct sequence is furniture, technology, office supply, corresponding to the provided options.