INDEX AND MATCH 

CHANGE PRODUCT AND MONTH FIND PRICE OF PRODUCT

PRODUCT	PRODUCT 19
MONTH	DEC
PRICE	242618.4149

NAME	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
PRODUCT 1	4500	7800	11100	14400	17700	21000	24300	27600	30900	34200	37500	40800
PRODUCT 2	4502	8900	13298	17696	22094	26492	30890	35288	39686	44084	48482	52880
PRODUCT 3	3800	10000	16200	22400	28600	34800	41000	47200	53400	59600	65800	72000
PRODUCT 4	3098	11100	19102	27104	35106	43108	51110	59112	67114	75116	83118	91120
PRODUCT 5	2396	12200	22004	31808	41612	51416	61220	71024	80828	90632	100436	110240
PRODUCT 6	1694	13300	24906	36512	48118	59724	71330	82936	94542	106148	117754	129360
PRODUCT 7	2500	14400	26300	38200	50100	62000	73900	85800	97700	109600	121500	133400
PRODUCT 8	3306	15500	27694	39888	52082	64276	76470	88664	100858	113052	125246	137440
PRODUCT 9	4112	16600	29088	41576	54064	66552	79040	91528	104016	116504	128992	141480
PRODUCT 10	4918	17700	30482	43264	56046	68828	81610	94392	107174	119956	132738	145520
PRODUCT 11	5724	18800	31876	44952	58028	71104	84180	97256	110332	123408	136484	149560
PRODUCT 12	6530	19900	33270	46640	60010	73380	86750	100120	113490	126860	140230	153600
PRODUCT 13	5054.242	21000	36945.76	52891.52	68837.27	84783.03	100728.8	116674.5	132620.3	148566.1	164511.8	180457.6
PRODUCT 14	5228.228	22100	38971.77	55843.54	72715.31	89587.09	106458.9	123330.6	140202.4	157074.2	173945.9	190817.7
PRODUCT 15	5402.214	23200	40997.79	58795.57	76593.36	94391.14	112188.9	129986.7	147784.5	165582.3	183380.1	201177.9
PRODUCT 16	5576.2	24300	43023.8	61747.6	80471.4	99195.2	117919	136642.8	155366.6	174090.4	192814.2	211538
PRODUCT 17	5750.186	25400	45049.81	64699.63	84349.44	103999.3	123649.1	143298.9	162948.7	182598.5	202248.3	221898.1
PRODUCT 18	5924.172	26500	47075.83	67651.66	88227.48	108803.3	129379.1	149955	170530.8	191106.6	211682.4	232258.3
PRODUCT 19	6098.159	27600	49101.84	70603.68	92105.52	113607.4	135109.2	156611	178112.9	199614.7	221116.6	242618.4
PRODUCT 20	6272.145	28700	51127.86	73555.71	95983.57	118411.4	140839.3	163267.1	185695	208122.8	230550.7	252978.6
PRODUCT 21	6446.131	29800	53153.87	76507.74	99861.61	123215.5	146569.3	169923.2	193277.1	216631	239984.8	263338.7
PRODUCT 22	6620.117	30900	55179.88	79459.77	103739.7	128019.5	152299.4	176579.3	200859.2	225139.1	249419	273698.8
PRODUCT 23	6794.103	32000	57205.9	82411.79	107617.7	132823.6	158029.5	183235.4	208441.3	233647.2	258853.1	284059
PRODUCT 24	6968.089	33100	59231.91	85363.82	111495.7	137627.6	163759.6	189891.5	216023.4	242155.3	268287.2	294419.1
PRODUCT 25	7142.075	34200	61257.93	88315.85	115373.8	142431.7	169489.6	196547.6	223605.5	250663.4	277721.3	304779.3
PRODUCT 26	7316.061	35300	63283.94	91267.88	119251.8	147235.8	175219.7	203203.6	231187.6	259171.5	287155.5	315139.4
PRODUCT 27	7490.047	36400	65309.95	94219.91	123129.9	152039.8	180949.8	209859.7	238769.7	267679.6	296589.6	325499.5
PRODUCT 28	7664.033	37500	67335.97	97171.93	127007.9	156843.9	186679.8	216515.8	246351.8	276187.7	306023.7	335859.7
PRODUCT 29	7838.019	38600	69361.98	100124	130885.9	161647.9	192409.9	223171.9	253933.9	284695.9	315457.8	346219.8
PRODUCT 30	8012.005	39700	71388	103076	134764	166452	198140	229828	261516	293204	324892	356580
PRODUCT 31	8185.991	40800	73414.01	106028	138642	171256	203870	236484.1	269098.1	301712.1	334326.1	366940.1
PRODUCT 32	8359.977	41900	75440.02	108980	142520.1	176060.1	209600.1	243140.1	276680.2	310220.2	343760.2	377300.2
PRODUCT 33	8533.963	43000	77466.04	111932.1	146398.1	180864.1	215330.2	249796.2	284262.3	318728.3	353194.3	387660.4
PRODUCT 34	8707.949	44100	79492.05	114884.1	150276.2	185668.2	221060.3	256452.3	291844.4	327236.4	362628.5	398020.5
PRODUCT 35	8881.935	45200	81518.07	117836.1	154154.2	190472.3	226790.3	263108.4	299426.5	335744.5	372062.6	408380.7
PRODUCT 36	9055.921	46300	83544.08	120788.2	158032.2	195276.3	232520.4	269764.5	307008.6	344252.6	381496.7	418740.8
PRODUCT 37	9229.907	47400	85570.09	123740.2	161910.3	200080.4	238250.5	276420.6	314590.7	352760.7	390930.8	429100.9
PRODUCT 38	9403.893	48500	87596.11	126692.2	165788.3	204884.4	243980.5	283076.6	322172.8	361268.9	400365	439461.1
PRODUCT 39	9577.879	49600	89622.12	129644.2	169666.4	209688.5	249710.6	289732.7	329754.8	369777	409799.1	449821.2
PRODUCT 40	9751.865	50700	91648.14	132596.3	173544.4	214492.5	255440.7	296388.8	337336.9	378285.1	419233.2	460181.4
PRODUCT 41	9925.851	51800	93674.15	135548.3	177422.4	219296.6	261170.7	303044.9	344919	386793.2	428667.3	470541.5
PRODUCT 42	10099.84	52900	95700.16	138500.3	181300.5	224100.7	266900.8	309701	352501.1	395301.3	438101.5	480901.6
PRODUCT 43	10273.82	54000	97726.18	141452.4	185178.5	228904.7	272630.9	316357.1	360083.2	403809.4	447535.6	491261.8
PRODUCT 44	10447.81	55100	99752.19	144404.4	189056.6	233708.8	278361	323013.1	367665.3	412317.5	456969.7	501621.9
PRODUCT 45	10621.79	56200	101778.2	147356.4	192934.6	238512.8	284091	329669.2	375247.4	420825.6	466403.8	511982.1
PRODUCT 46	10795.78	57300	103804.2	150308.4	196812.7	243316.9	289821.1	336325.3	382829.5	429333.8	475838	522342.2
PRODUCT 47	10969.77	58400	105830.2	153260.5	200690.7	248120.9	295551.2	342981.4	390411.6	437841.9	485272.1	532702.3
PRODUCT 48	11143.75	59500	107856.2	156212.5	204568.7	252925	301281.2	349637.5	397993.7	446350	494706.2	543062.5
PRODUCT 49	11317.74	60600	109882.3	159164.5	208446.8	257729	307011.3	356293.6	405575.8	454858.1	504140.3	553422.6
PRODUCT 50	11491.72	61700	111908.3	162116.6	212324.8	262533.1	312741.4	362949.7	413157.9	463366.2	513574.5	563782.8

consolodate
exam 1
roll no	sub1	sub2	sub3	sub4	sub5	sub6
1001	45	52	59	45	52	59
1002	78	57	36	78	57	36
1003	89	58	27	89	58	27
1004	98	59	20	98	59	20
1005	78	89	100	78	89	100
1006	45	52	59	45	52	59
1007	78	57	36	78	57	36
1008	89	58	27	89	58	27
1009	98	59	20	98	59	20
1010	78	89	100	78	89	100
1011	78	57	36	78	57	36
1012	78	57	36	78	57	36
1013	78	57	36	78	57	36

exam 2
roll no	sub1	sub2	sub3	sub4	sub5	sub6
1001	78	52	26	78	78	78
1002	89	57	25	89	89	89
1003	78	58	38	78	78	78
1004	45	59	73	45	45	45
1005	79	89	99	79	79	79
1006	98	52	6	98	98	98
1007	56	57	58	56	56	56
1008	89	58	27	89	89	89
1009	56	59	62	56	56	56
1010	45	89	133	45	45	45
1011	69	57	45	69	69	69
1012	74	57	40	74	74	74
1013	39	57	75	39	39	39
exam 3
roll no	sub1	sub2	sub3	sub4	sub5	sub6
1001	78	52	26	78	86	78
1002	89	57	25	89	65	89
1003	78	58	38	78	78	78
1004	45	59	73	45	45	45
1005	79	89	99	79	79	79
1006	98	52	78	98	98	98
1007	56	57	99	56	56	56
1008	89	58	68	89	89	89
1009	56	59	78	56	56	56
1010	45	89	133	45	45	45
1011	69	57	45	69	69	69
1012	74	57	40	74	74	74
1013	39	57	75	39	39	39
consolidate data for exam 1,exam2,exam3
sum
max
min
avg

qu	1
sale name	itm1	itm2	itm3	itm4	itm5
aaa	45	0	45	12	0
bb	78	78	89	45	12
ccc	89	156	133	78	24
dd	56	234	177	111	36
ee	78	312	221	144	48
ff	56	390	265	177	60
gg	45	468	309	210	72
jj	89	546	353	243	84

qu	2
sale name	itm1	itm2	itm3	itm4	itm5
aaa	7	0	45	12	0
bb	0	78	89	45	12
ccc	0	156	133	78	24
dd	56	234	177	111	36
ee	8	312	221	144	48
ff	56	78	78	177	60
gg	45	468	98	210	72
jj	89	546	353	243	84

 consolidate data for quat1,quat2

sum

max

min

avg

SCENARIO FOR five period(12,24,36,48)

AMT	100000
RATE	15%
PERIOD	60
EMI	($2,378.99)

SCENARIO FOR THRE  YEARS 

INCOME	780000
EXPEN	95000
PROFIT	685000

MATCH-INDEX

	1990	1991	1992	1993	1994	1995	1996	1997	1998	1999	2000
FIAT	45000	78900	112800	146700	180600	214500	248400	282300	316200	350100	384000
CEAT	89000	89000	89000	89000	89000	89000	89000	89000	89000	89000	89000
GODREJ	95000	99100	103200	107300	111400	115500	119600	123700	127800	131900	136000
TATA	98000	109200	120400	131600	142800	154000	165200	176400	187600	198800	210000
AAA	68000	119300	170600	221900	273200	324500	375800	427100	478400	529700	581000
BBB	95500	129400	163300	197200	231100	265000	298900	332800	366700	400600	434500
CCC	101000	139500	178000	216500	255000	293500	332000	370500	409000	447500	486000
DD	106500	149600	192700	235800	278900	322000	365100	408200	451300	494400	537500
EEEE	112000	159700	207400	255100	302800	350500	398200	445900	493600	541300	589000
FFF	117500	169800	222100	274400	326700	379000	431300	483600	535900	588200	640500
GGG	123000	179900	236800	293700	350600	407500	464400	521300	578200	635100	692000
HHH	128500	190000	251500	313000	374500	436000	497500	559000	620500	682000	743500
III	134000	200100	266200	332300	398400	464500	530600	596700	662800	728900	795000
JJJ	139500	210200	280900	351600	422300	493000	563700	634400	705100	775800	846500
KKK	145000	220300	295600	370900	446200	521500	596800	672100	747400	822700	898000

COMPANY	TATA
YEAR	1995
SALES	154000