Mb0024 Set -1

Assignment-Set 1

STATISTICS FOR MANAGEMENT

Solution of:-CASE STUDY

TABLE –A Months

jan,2008 feb,2008 mar,2008 apr,2008 may,200 8 jun,2008 jul,2008 aug,2008 sep,2008 oct,2008 nov,2008 dec,2008 Total

Monthly Minimum Balance In INR A/C Holder 1 60000 70000 55000 90000 56000

A/C Holder 2 56000 76000 110000 89000 88000

A/C Holder 3 66000 74000 112000 90000 84000

A/C Holder 4 86000 96000 190000 98000 84000

A/C Holder 5 56000 76000 110000 89000 88000

A/C Holder 6 59000 96000 120000 97000 98000

A/C Holder 7 59000 78000 115000 87000 90000

A/C Holder 8 52000 73000 112000 93000 89000

A/C Holder 9 53000 98000 113000 66000 87000

A/C Holder 10 56000 76000 120000 89000 86000

80000 82000 79000 51000 95000 82000 83000

52000 58000 95000 86000 90000 82000 55000

57000 96000 55000 76000 95000 87000 56000

57000 66000 93000 74000 99000 84000 57000

52000 58000 95000 86000 90000 82000 55000

57000 56000 98000 88000 99000 88000 59000

55000 86000 99000 89000 95000 87000 59000

54000 55000 96000 97000 99000 88000 59000

59000 98000 59000 87000 95000 86000 52000

72000 98000 95000 84000 90000 82000 53000

883000

937000

948000

1084000

937000

1015000

999000

967000

953000

1001000

Use the weighted method for solution. 1st a/c holder Wx=883000, W=12 W.Avg.=883000/12 = 73583 2nd a/c holder Wx=937000, W=12 W.Avg.=937000/12 =78083.33 3rd a/c holder Wx=948000, W=12 W.Avg.=948000/12 = 79000 4th a/c holder Wx=1084000, W=12 W.Avg.=883000/12 = 90333.33 5th a/c holder Wx=937000, W=12 W.Avg.=937000/12 = 78083.33

6th a/c holder Wx=1015000, W=12 W.Avg.=1015000/12 = 84583.33 7th a/c holder Wx=999000, W=12 W.Avg.=999000/12 = 83250 8th a/c holder Wx=967000, W=12 W.Avg.=967000/12 = 80583.333 9th a/c holder Wx=953000, W=12 W.Avg.=953000/12 = 79416.667 10th a/c holder Wx=1001000, W=12 W.Avg.=1001000/12 = 83416.667 Table - B A/c Holder 1st a/c holder 2nd a/c holder 3rd a/c holder 4th a/c holder 5th a/c holder 6th a/c holder 7th a/c holder 8th a/c holder 9th a/c holder 10th a/c holder

Monthly Avg Balance 73583 78083 79000 90333 78083 84583 83250 80583 79416 83416

According to case ABC Branch of XYZ have decided to give 10 Lack of loan each on long term basis to only two of their customer or accountholder, about 20 businessmen had applied for loan in order to develop their business further. In order to reject some of the application as (the fund was limited); the Bank decided that accountholder who had maintained a minimum balance of 50000 INR would only be considered for the loan. As a result, 10 applications were automatically rejected as they were not satisfying the requirement of minimum balance. Now, the 10 applications remained and it was found that monthly minimum balance in all the cases were more than 50000 INR for the last 12 month. If I were assistant manager XYZ Bank, I would select from remained 10 applications choose 4th and 6th A/c Holder for give loan .This is because they are only eligible who are maintaining maximum balance more than remains Eight A/c Holder’s. Only 4th and 6th A/c Holder has maximum average than remains eight A/c Holder. So, it should be consider of them for give loan.