Given:
There are 5 items along with the number of items brought and sold for each quarter for each item in a given table.
Total number of quarters = 4
Calculation:
Total number of items bought in Q1 = 300 + 270 + 280 + 320 + 325 = 1495
Total number of items sold in Q1 = 170 + 180 + 210 + 250 + 275 = 1085
The ratio of bought to sold in Q1 = 1495/1085 = 1.377...
Total number of items bought in Q2 = 400 + 280 + 350 + 340 + 370 = 1740
Total number of items sold in Q2 = 335 + 200 + 310 + 290 + 315 = 1450
The ratio of bought to sold in Q2 = 1740/1450 = 1.2
Total number of items bought in Q3 = 370 + 350 + 250 + 280 + 320 = 1570
Total number of items sold in Q3 = 320 + 330 + 200 + 180 + 170 = 1200
The ratio of bought to sold in Q3 = 1570/1200 = 1.30...
Total number of items bought in Q4 = 410 + 380 + 250 + 280 + 265 = 1585
Total number of items sold in Q4 = 370 + 340 + 200 + 240 + 190 = 1340
The ratio of bought to sold in Q4 = 1585/1340 = 1.18...
Hence, Q4 has the lower ratio of bought to sold.
Therefore, Q4 quarter has the minimum bought to sold ratio.