The following observations we have from the data given above:
1) Mode 1 : Booked and delivered in the same month.
2) Mode 2 : Booked and delivered in the next month.
3) Mode 3 : Booked and delivered in the next to next month.
Thus, the number of deliveries in a particular month will be the sum of bookings done in mode 1 in that month, with bookings done with mode 2 in the previous month and bookings done with mode 3 in two months back.
i.e., No. of deliveries = Mode 1(current month) + Mode 2(previous month) + Mode 3(two months before)
Also, it is given that except for January, the number of bookings made through Mode 2 is 10% of the total bookings.
Thus, the table will become as follows:
Consider the deliveries in the month of August:
The number of bookings made in either July or August is 0. Thus, the number of deliveries in this month are of the bookings made in the month of June through mode 3.
Thus, the number of bookings made in June with mode 3 = 500.
Now, consider the deliveries in the month of July:
The number of bookings made in July is also 0. Thus, the number of deliveries will be the bookings made in the month of June through mode 2 and the ones made in May through mode 3.
We know that bookings made through mode 2 in the month of June = 100.
Thus, the bookings made in May through mode 3 will be 350 - 100 = 250
Now, consider the month of June:
Total number of bookings = 1000
Mode 2 = 100 and Mode 3 = 500.
Thus, Mode 1 = 1000 - (100 + 500) = 400
Similarly, the bookings made through Mode 1 in May = 250
Again, consider the deliveries done in June:
The number of deliveries will be the bookings made in the month of June through mode 1, the ones made in May through mode 2, and the ones made in April through mode 3.
Mode 1(June) = 400, Mode 2(May) = 50.
Thus, Mode 3(April) = 770 - (400 + 50) = 320
Similarly, in this manner, we can backtrack all the values, and the final table will be:
Thus, from the table, it is evident that the highest number of bookings done through Mode 3 is in June.
The correct option is D.