CAT DI Data Change Over Period Questions & Solutions

A sample of real CAT DI Data Change Over Period past-year questions, each with a worked solution and the correct answer highlighted. AthenaPrep has 75 DI Data Change Over Period questions in all — sign up free to practise them timed.

1. Passage

   The horizontal bars in the above diagram represent 2020 aggregate sales (in ₹ million) of a company for the different subcategories of its products. The top four product subcategories (Bookcases, Chairs, Furnishings, Tables) belong to furniture product category; the bottom four product subcategories (Accessories, Copiers, Machines, Phones) belong to the technology product category while all other product subcategories belong to the office supply product category. For each of the product subcategories, there is a vertical line indicating the sales of the corresponding subcategory in 2019.

   Q1.CAT 2021

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

   • 18.0

   • 16.5

   • 13.5

   • 12.5

2. Passage

   There are 21 employees working in a division, out of whom 10 are special-skilled employees (SE) and the remaining are regular-skilled employees (RE). During the next five months, the division has to complete five projects every month. Out of the 25 projects, 5 projects are "challenging", while the remaining ones are "standard". Each of the challenging projects has to be completed in different months. Every month, five teams — T1 T2, T3, T4 and T5, work on one project each. T1, T2, T3, T4 and T5 are allotted the challenging project in the first, second, third, fourth and fifth month, respectively. The team assigned the challenging project has one more employee than the rest.
   In the first month, T1 has one more SE than T2, T2 has one more SE than T3, T 3 has one more SE than T4, and T4 has one more SE than T5. Between two successive months, the composition of the teams changes as follows:
   a. The team allotted the challenging project, gets two SE from the team which was allotted the challenging project in the previous month. In exchange, one RE is shifted from the former team to the latter team.
   b. After the above exchange, if T1 has any SE and T5 has any RE, then one SE is shifted from T1 to T5, and one RE is shifted from T5 to T1. Also, if T2 has any SE and T4 has any RE, then one SE is shifted from T2 to T4, and one RE is shifted from T4 to T2.
   Each standard project has a total of 100 credit points, while each challenging project has 200 credit points. The credit points are equally shared between the employees included in that team.

   Q2.CAT 2017

   Which of the following CANNOT be the total credit points earned by any employee from the projects?

   • 140

   • 150

   • 170

   • 200

3. Passage

   DIRECTIONS for the following three questions: Answer the questions on the basis of the information given below.

   Date of Issue	Notified Amount	Maturity	Competitive bids received	Non-competitive bids received	Competitive bids accepted		Non competitive bids accepted		Total Amount	Coupon Rate %	Implicit Yield %
   	Rs. Crore	Years	No.	No.	No.	Value	No.	Value	Rs. Crore
   17-Jul-02	40	15	229	23	66	15.21	23	0.37	16	8.07	7.80
   17-Jul-02	30	10	145	12	90	29.88	12	0.12	30	6.72	6.72
   5-Aug-02	50	9	324	13	105	49.68	13	0.33	50	9.39	7.24
   5-Aug-02	20	24	163	9	34	19.81	9	0.19	20	10.18	7.93
   28-Aug-02	50	15	260	26	157	48.92	26	1.08	50	7.46	7.46
   28-Aug-02	20	30	119	15	67	19.61	15	0.39	20	7.95	7.95
   11-Sep-02	40	15	261	22	152	38.93	22	1.07	40	7.46	7.44
   11-Sep-02	30	20	131	20	98	29.44	20	0.56	30	8.35	7.70
   9-Oct-02	40	11	361	26	119	39.22	26	0.78	40	7.27	7.14
   9-Oct-02	30	30	91	15	39	29.52	15	0.48	30	7.95	7.89
   7-Nov-02	40	17	245	14	20	39.71	14	0.29	40	10.03	7.26
   7-Nov-02	30	24	166	11	49	29.70	11	0.31	30	10.18	7.48
   9-Apr-03	40	20	245	25	65	39.53	25	1.47	40	6.30	6.30
   9-Apr-03	50	11	236	24	201	49.40	24	0.60	50	7.37	5.98
   23-Apr-03	50	15	319	26	134	48.98	26	1.02	50	6.25	6.10
   23-Apr-03	20	29	131	19	9	19.39	19	0.61	20	7.95	6.33
   5-May-03	60	10	314	14	98	59.69	14	0.31	60	7.27	5.97
   5-May-03	30	20	143	14	118	29.58	14	0.42	30	6.30	6.35
   4-Jun-03	30	25	187	19	15	28.50	19	1.50	30	6.13	6.13
   4-Jun-03	60	9	378	21	151	59.09	21	0.91	60	6.85	5.76
   2-Jul-03	50	11	298	20	116	49.05	20	0.95	50	7.37	5.76
   2-Jul-03	30	25	114	20	45	28.64	20	1.36	30	6.31	6.10
   16-Jul-03	60	17	371	29	115	57.00	29	3.10	60	6.35	5.97
   16-Jul-03	30	29	134	22	12	29.32	22	0.68	30	7.95	6.20
   Total	930								906

   One of the functions of the Reserve Bank of India is to mobilize funds for the Government of India by issuing securities. The following table shows details of funds mobilized during the period July 2002 - July 2003. Notice that on each date there were two rounds of issues, each with a different maturity.

   Q3.CAT 2003

   How many times was the issue of securities under-subscribed, i.e., how often did the total amount mobilized fall short of the amount notified?

   • 0

   • 1

   • 2

   • 3

4. Passage

   The following table shows the revenue and expenses in millions of Euros (European currency) associated with REPSOL YPF company’s oil and gas producing activities in operations in different parts of the world for 1998-2000.

   S. No.	Item	Year	Total World	Spain	North Africa & Middle East	Argentina	Rest of Latin America	Far East	North Sea	Rest of the World
   1	Revenue	1998	916	70	366	281	34	82	78	5
   		1999	3374	55	666	2006	115	301	140	91
   		2000	8328	394	1290	5539	482	603	0	20
   2	Expenses	1998	668	39	255	187	57	63	52	15
   		1999	1999	48	325	1168	131	204	65	58
   		2000	3709	43	530	2540	252	311	0	33
   3	Income Before Taxes & Charges (Revenue − Expenses)	1998	248	31	111	94	−23	19	26	−10
   		1999	1375	7	341	838	−16	97	75	33
   		2000	4619	351	760	2999	230	292	0	−13
   4	Taxes and Charges	1998	152	6	104	33	−3	9	6	−3
   		1999	561	3	169	338	−6	39	21	−3
   		2000	1845	126	404	1150	61	103	0	1
   5	Net Income = (3)-(4)	1998	96	25	7	61	−20	10	20	−7
   		1999	814	4	172	500	−10	58	54	36
   		2000	2774	225	356	1849	169	189	0	−14

   Q4.CAT 2002

   How many operations (Spain, North Africa and Middle East,..) of the company accounted for less than 5% of the total revenue earned in 1999?

   • 2

   • 3

   • 4

   • None of these

5. Q5.CAT 2002

   Of the following statements, which one is not true?

   • The operations in Spain had the best efficiency in 2000

   • The Far East operations witnessed an efficiency improvement from 1999 to 2000

   • The North Sea operations witnessed an efficiency improvement from 1998 to 1999

   • In 1998, the operations in Rest of Latin America were the least efficient

6. Passage

   Directions for the next 5 questions: Answer the questions with reference to the table given below: Information Technology Industry in India (Figures are in million US dollars)
   
   

   	1994-95	1995-96	1996-97	1997-98	1998-99
   Software:
   Domestic	350	490	670	950	1250
   Exports	485	734	1083	1750	2650
   Hardware:
   Domestic	590	1037	1050	1205	1026
   Exports	177	35	286	201	4
   Peripherals:
   Domestic	148	196	181	229	329
   Exports	6	6	14	19	18
   Training	107	143	185	263	302
   Maintenance	142	172	182	221	236
   Networking and others	36	73	156	193	237
   Total	2041	2886	3807	5031	6052

   Q6.CAT 2000

   The total annual exports lay between 35 and 40 percent of the total annual business of the IT industry, in the years:

   • 1997-98 & 1994-95

   • 1996-97 & 1997-98

   • 1996-97& 1998-99

   • 1996-97& 1994-95

7. Passage

   The table given below gives the annual details of loans from rural banks and agricultural loans over the years 1970 to 1983. Using this data answer the questions that follow.
   
   

   Year	Loan from Rural			Agricultural Loans		Consumer Price Index
   	No. of rural banks	Avg. no. of loans	Average size (in Rs.)	No. ('000)	Value (Rs. In millions)
   1970	90	28	109	18.3	2	43
   1971	115	39	133	20.4	3.58	49
   1972	130	52	178	25.1	6.26	55
   1974	260	98	243	41.2	34.54	70
   1975	318	121	283	51.4	52.21	78
   1980	605	288	567	135.7	498.4	131
   1981	665	312	622	152.8	612.4	137
   1983	840	380	711	211.6	915.7	149

   Q7.CAT 1997

   From the given data, the number of rural loans up to 1980 formed approximately what percentage of those in 1983?

   • 112%

   • 80%

   • 97%

   • Cannot be determined

8. Q8.CAT 1997

   If the consumer price index for 1970 is to be taken as 105 and the indices for the subsequent years are to be corrected accordingly, what is the approximate value of the agricultural loans in 1980 at 1983 prices?

   • Rs. 570 million

   • Rs. 680 million

   • Rs. 525 million

   • Rs. 440 million

9. Passage

   The following table gives the tariff [in paise per kilo-watt-hour (kWh)] levied by the UPSEB in 1994-95, in four sectors and the regions within them. The table also gives the percentage change in the tariff as compared to 1991-92.
   
   

   	Region 1		Region 2		Region 3		Region 4		Region 5
   	P/kWh	%	P/kWh	% incr.	P/kWh	%incr.	P/kWh	% incr.	P/kWh	% incr.
   Sector 1	425	15	472	5	420	−4	415	8	440	10
   Sector 2	430	12	468	8	448	7	423	−3	427	11
   Sector 3	428	8	478	−4	432	6	441	10	439	8
   Sector 4	434	−5	470	15	456	10	451	12	446	−12

   Q9.CAT 1997

   What was the approximate average tariff in sector 3 in 1991-92?

   • 407

   • 420

   • 429

   • None of these

10. Passage

    Answer the questions based on the following information. The amount of money invested (rupees in crores) in the core infrastructure areas of two districts, Chittoor and Khammam, Andhra Pradesh, is as follows.
    
    

    Chittor district

    Core Area	1995	1996
    Electricity	815.2	1054.2
    Chemical	389.5	476.7
    Thermal	632.4	565.9
    Solar	468.1	589.6
    Nuclear	617.9	803.1
    Total	2923.1	3489.5

    Khammam District

    Core Area	1995	1996
    Electricity	2065.8	2365.1
    Chemical	745.3	986.4
    Thermal	1232.7	1026.3
    Solar	1363.5	1792.1
    Nuclear	1674.3	2182.1
    Total	7081.6	8352

    Q10.CAT 1996

    In Khammam district, the investment in which area in 1996 showed the highest percentage increase over the investment in that area in 1995?

    • Electricity

    • Chemical

    • Solar

    • Nuclear

11. Passage

    Direction for questions: Answer the questions based on the following information. The data given in the table shows the investment details in country ‘Fortune Land’ of companies A, B, C, D, E and F. Figures in the table are in US dollars in billions.

    	A	B	C	D	E	F
    year 1	2.5	4.6	5.8	3.11	10.6	7.8
    year 2	6.7	7.5	12.5	5.6	17.4	25.3
    Year 3	11.5	18.7	21.2	7.7	29.8	60.1

    Q11.CAT 1996

    For which company is investment not increased from year 1 to year 3?

    • C

    • D

    • F

    • None of these

12. Passage

    The following table gives the national income and the population of a country for the years 1984 – 85 to 1989 – 90. For each of the following questions choose the best alternative:

    Year	National Income (in Rs. crore)	Population (in crore)
    1984-85	229,225	74
    1985-86	261,174	75
    1986-87	291,556	77
    1987-88	329,934	78.5
    1988-89	388,539	80
    1989-90	433,500	81.2

    Q12.CAT 1991

    Increase in the per capita income compared to the previous year among the years given below was highest for the year:

    • 1985-86

    • 1986-87

    • 1987-88

    • 1988-89

CAT DI Data Change Over Period previous year questions with solutions — AthenaPrep