Days Times Total Cost per unit

Accomodation 1 1 1 1500
Breakfast 1 2 2 100
Lunch 1 2 2 200
Dinner 1 1 1 250
Normal tea - morning 1 1 1 50
Normal tea - afternoon 2 1 2 50
Inaugural tea and snacks 1 1 1 100
Conference kit 1 1 1 500
Pick up and drop 1 1 1 400
Airfare 1 1 1 10000
Honorarium 1 1 1 4000
Rent for conf hall 2 1 2 10000
Other 1 1 1 40000

Delegates 20 to 40 25 Q1
Oganizing team 10 10 Q2
Speakers 4 4 Q3
TOTAL 39

Total Csot 239250

Sponsorship 100000
Fixed Cost/Delegate 151750
Variable cost 3500
Number of people Cost per day Total cost Fixed Cost Variable Cost
29 43500 43500 6000 37500
39 3900 7800 2800 5000
39 7800 15600 5600 10000
54 13500 13500 7250 6250
39 1950 1950 700 1250
39 1950 3900 1400 2500
59 5900 5900 3400 2500
39 19500 19500 7000 12500
29 11600 11600 1600 10000
4 40000 40000 40000 0
4 16000 16000 16000 0
1 10000 20000 20000 0
1 40000 40000 40000 0
239250

9570
5570
Yes
 Delegates OT Speaker Others
Accomodation Yes No Yes No
Breakfast Yes Yes Yes No
Lunch Yes Yes Yes No
Dinner Yes Yes Yes Yes
Normal tea - morning Yes Yes Yes No
Normal tea - afternoon Yes Yes Yes No
Inaugural tea and snacks Yes Yes Yes Yes
Conference kit Yes Yes Yes No
Pick up and drop Yes No Yes No
Airfare No No Yes No
Honorarium No No Yes No
Delegates OT Speaker Others Total
25 0 4 0 29
25 10 4 0 39
25 10 4 0 39
25 10 4 15 54
25 10 4 0 39
25 10 4 0 39
25 10 4 20 59
25 10 4 0 39
25 0 4 0 29
0 0 4 0 4
0 0 4 0 4
Classes 5 Revenue
Square feet required/student 30 Construction Cost
Construction cost/sq feet (Rs.) 400 Salary
Total Staff Cost/month (Rs.) 70000 Other Costs
Increase in Salary 10% Cashflow
Other costs/year 25000
Increase in other costs 5% Discounting Factor
Students in each class 9.07797901 NPV
Fee per student (Rs.)/year 30000 Total NPV

Total Student 45.389895 Students in each class

Discounting Rate 10%
 0 1 2 3 4 5 6
0 1,361,697 1,361,697 1,361,697 1,361,697 1,361,697 1,361,697
544,679 0 0 0 0 0 0
0 840,000 924,000 1,016,400 1,118,040 1,229,844 1,352,828
0 25,000 26,250 27,563 28,941 30,388 31,907
544,679 496,697 411,447 317,734 214,716 101,465 23,039

1.00 0.91 0.83 0.75 0.68 0.62 0.56

544,679 451,543 340,039 238,719 146,654 63,002 13,005
0

9
 7 8 9 10
1,361,697 1,361,697 1,361,697 1,361,697
0 0 0 0
1,488,111 1,636,922 1,800,615 1,980,676
33,502 35,178 36,936 38,783
159,917 310,403 475,854 657,762

0.51 0.47 0.42 0.39

82,063 144,805 201,809 253,596
Classes 5 Revenue
Square feet required/student 30 Construction Cost
Construction cost/sq feet (Rs.) 400 Salary
Total Staff Cost/month (Rs.) 70000 Other Costs
Increase in Salary 10% Cashflow
Other costs/year 25000
Increase in other costs 5% Discounting Factor
Students in each class 50 NPV
Fee per student (Rs.)/year 7045.15632 Total NPV

Total Student 250 Fee per student

Discounting Rate 10%
 0 1 2 3 4 5 6
0 1,761,289 1,761,289 1,761,289 1,761,289 1,761,289 1,761,289
3,000,000 0 0 0 0 0 0
0 840,000 924,000 1,016,400 1,118,040 1,229,844 1,352,828
0 25,000 26,250 27,563 28,941 30,388 31,907
3,000,000 896,289 811,039 717,327 614,308 501,057 376,554

1.00 0.91 0.83 0.75 0.68 0.62 0.56

3,000,000 814,808 670,280 538,938 419,581 311,117 212,555
0

7045.15632
 7 8 9 10
1,761,289 1,761,289 1,761,289 1,761,289
0 0 0 0
1,488,111 1,636,922 1,800,615 1,980,676
33,502 35,178 36,936 38,783
239,675 89,189 76,262 258,170

0.51 0.47 0.42 0.39

122,991 41,607 32,342 99,536
Classes 5 Revenue
Square feet required/student 30 Construction Cost
Construction cost/sq feet (Rs.) 400 Salary
Total Staff Cost/month (Rs.) 70000 Other Costs
Increase in Salary 10% Cashflow
Other costs/year 25000
Increase in other costs 5% Discounting Factor
Students in each class 50 NPV
Fee per student (Rs.)/year 30000 Total NPV

Total Student 250 35,261,894

Discounting Rate 10% 10000
15000
20000
25000
30000
35000
40000
45000
50000
 0 1 2 3 4 5 6
0 7,500,000 7,500,000 7,500,000 7,500,000 7,500,000 7,500,000
3,000,000 0 0 0 0 0 0
0 840,000 924,000 1,016,400 1,118,040 1,229,844 1,352,828
0 25,000 26,250 27,563 28,941 30,388 31,907
3,000,000 6,635,000 6,549,750 6,456,038 6,353,019 6,239,768 6,115,265

1.00 0.91 0.83 0.75 0.68 0.62 0.56

3,000,000 6,031,818 5,413,017 4,850,517 4,339,198 3,874,405 3,451,907
35,261,894

30 35 40 45 50 55 60
 7 8 9 10
7,500,000 7,500,000 7,500,000 7,500,000
0 0 0 0
1,488,111 1,636,922 1,800,615 1,980,676
33,502 35,178 36,936 38,783
5,978,386 5,827,900 5,662,449 5,480,541

0.51 0.47 0.42 0.39

3,067,857 2,718,758 2,401,431 2,112,986

65 70
 0.3 0.4 0.3
Candidate Code Score in Academics Score in written test Score in interview
1 90 75 95
2 60 90 80
3 60 80 60
4 70 70 40
5 50 40 45
6 90 80 85
7 95 50 55
8 50 70 95
9 60 60 60
10 75 75 75
Weighted score Selected or not?
85.5 Yes 1
78 Yes 1
68 No 0
61 No 0
44.5 No 0
84.5 Yes 1
65 No 0
71.5 No 0
60 No 0
75 No 0
3
Area (Sq Yards) 200 0
Cleaning (Rs/SqYards) 5 Revenue from sale 0.0
Initial Tax (Rs.) 1000 Purchase of land (100000.0)
Increase in Tax 5% Tax 0.0
CP (Rs.) 100000 Cleaning 0.0
SP (Rs.) 300000 Net Cash Flow (100000.0)
Discount Rate 15%
Discounting Factor 1.00
NPV -100000
Total NPV 42146.2405
IRR 23%
 1 2 3 4 5
0.0 0.0 0.0 0.0 300000.0
0.0 0.0 0.0 0.0 0.0
1000.0 1050.0 1102.5 1157.6 1215.5
1000.0 1000.0 1000.0 1000.0 1000.0
(2000.0) (2050.0) (2102.5) (2157.6) 297784.5

0.87 0.76 0.66 0.57 0.50

-1739.13043 -1550.09452 -1382.42788 -1233.6291 148051.522