1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Few Projects are in almost ready state to begin fitness Club Work Project execution will be in phases within and across years Invoice will be generated every 60 days and payment is expected within 7 days of invoice generation Project contract will not break in between Even distribution of work for the entire project No unpredictable changes in the financial,management and operational position of the Builder Fit n Fine will solely be responsible for setting up a fitness club Fit n Fine will solely be responsible for setting up a fitness club Maintenance will be undertaken by Fit 'n Fine Trainers will be provided by Fit 'n Fine Value added services will be allowed in the Club house premises Value added Services will begin in 3 months of the fitness club set up No major national or global events that threaten the stability and health of the country and its citizen No unpredictable changes in price of fitness, medical, or office equipment. Insurance and Utilities to be taken care by Builder/Society A constantly growing economy without any major recession or boom. No rent will be charged to Fit 'n Fine for the club Fit 'n Fine will be responsible only for Fitness Club and not the entire club house
Recruit people from some fitness Academy such as K11. Give them prior notification Several processes occur simultaneously: Planning phase - Draw plan based on Housing complex needs and space Execution Phase - Parallel Activities - Appointed Architect and finalize club design - Select Vendor (New or existing) and award job - Vendor complete the décor - Equipment order placed and received Set up and testing phase - Parallel Activities - Equipment Set up - Internal Training - Testing Total Set up Time
Stage 0
Stage 1
Stage 2
Total
Time in Weeks Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 Wk8 1 1 5 1 1 5 3 2 1 1 1 8 Weeks
Author: Last week buffer for any unexpected scenarios
Author: Last week buffer for any unexpected scenarios
Weeks 1 4 GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set up up up up up up up up up up up up up up up up up up up up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 1
8 9 10 11 12 16 17 18 19 20 23 24 25 26 27 28 31 32 33 34 35 36 39 40 41
2 3 4 5 7 8 9 10
12 13 14 15
17 18 19
2
Resources Project Head Site Head
1 4
Q1 Q2 Q3 Q4
1 14 27 40
13 26 39 52
Achitect on Contract --- Per Site Consulting Money Achitect on Contract --- Per Site Consulting Money
Contractor Fixed Price, so no prob of resources
42 43 44 47 48 49 50 51
52 Q1 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor Trainer House Keeping staff Aerobics Yoga Dietician Technician Total 1 0 0 0 0 0 0 0 1 1 Q2 7 1 0 2 1 0 0 0 2 5 Q3 5 8 0 16 8 1 1 1 3 30 Q4 7 13 0 26 13 8 8 8 5 68 Total 20 13 0 26 13 8 8 8 5 68
6
Buffer
11
16
20
Weeks 1 4 GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set up up up up up up up up up up up up up up up up up up up up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Resources Project Head Site Head 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Phase Phase Phase Phase 1 2 3 4 5 5 5 5 8 8 8 8 Q1 Q2 Q3 Q4 40 40 40 40 1 14 27 40 1 4 9 9 13 26 39 52 40 43 48 48 1 8 9 16 4 11 12 19 9 16 17 24 9 16 17 24 17 20 25 25 24 27 32 32 25 28 33 33 32 35 40 40 8 9 10 11 12 16 17 19 20 23 24 25 27 28 31 32 33 35 36 39 40 41 42 43 47
1 4
Achitect on Contract --- Per Site Consulting Money Achitect on Contract --- Per Site Consulting Money
Contractor Fixed Price, so no prob of resources
48
50
52 Year_2 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total Q1 4 20 0 40 20 13 13 13 5 104 Q2 6 24 0 48 24 20 20 20 7 139 Q3 5 30 0 60 30 24 24 24 8 170 Q4 5 35 0 70 35 30 30 30 10 205 Total 20 35 0 70 35 30 30 30 10 205
Buffer
33 36 41 41
Year_3 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total
Q1 4 40 0 80 40 35 35 35 10 235
Q2 6 44 0 88 44 40 40 40 12 264
Q3 5 50 0 100 50 44 44 44 13 295
Q4 5 55 0 110 55 50 50 50 15 330
Total 20 55 0 110 55 50 50 50 15 330
Year_4 Num of GYMs - Completed Operational GYMs
Q1 4 60
Q2 6 64
Q3 5 70
Q4 5 75
Total 20 75
Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total
0 120 60 55 55 55 15 360
0 128 64 60 60 60 17 389
0 140 70 64 64 64 18 420
0 150 75 70 70 70 20 455
0 150 75 70 70 70 20 455
Year_5 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total
Q1 4 80 0 160 80 75 75 75 20 485
Q2 6 84 0 168 84 80 80 80 22 514
Q3 5 90 0 180 90 84 84 84 23 545
Q4 5 95 0 190 95 90 90 90 25 580
Total 20 95 0 190 95 90 90 90 25 580
Year_6 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1)
Q1 0 100 0 200 100 95 95 95
Q2 0 100 0 200 100 100 100 100
Q3 0 100 0 200 100 100 100 100
Q4 0 100 0 200 100 100 100 100
Total 0 100 0 200 100 100 100 100
Technician Total
25 610
25 625
25 625
25 625
25 625
One GYM Details One time GYM Set Up details Equipment
Interiors
Personnel Cost
Other Misc Cost
Set Up Professional Fee
One Time
Post Set Up Recurring Details Assured Recurring Club Staff Cost
Personnel Cost
Other Misc Cost
Maintenance
Special Programs
Marketing
Recurring
Total (Set Up + 1 Yr Maintenance)
Per Unit Cost
Unit/Ppl
Equipment
Weighing scale Treadmill Cross trainer + cycle Steeper + Twister Multi gym Light weight training Torque GS Free Style Material
Cost Per Unit
17,500 175,000 150,000 5,000 50,000 10,000 100,000 5,000 5000
Units
2 2 1 1 1 1 1 1 1
Total
Interiors includes A.C., Music system etc Total
300000
1
Overall Project Head Site Head - 1 Site Head - 2 Site Head - 3 Site Head - 4 Induction Training Charges Technician's Salary Total - Yearly - 20 GYMs Total - Yearly - 1 GYM Total Cost -- 1 GYM Set up
83333.33 41666.67 41666.67 41666.67 41666.67 5000 10000
1 1 1 1 1 1 5
Telephone Stationary Travel Total Cost -- 1 GYM Set up
1000 500 5000
2 2 1
ssional Fee Set Up Professional Fee Total Total
0 0
0 0
Fitness Club Supervisor Trainer House Keeping staff Raw Materials Total - Monthly Total - Yearly
6000 4500 4500 2500
0 2 1 1
Overall Project Head Site Head - 1 Site Head - 2 Site Head - 3 Site Head - 4 Training Charges Technician's Salary Total - Monthly Total - Yearly
83333.33 41666.67 41666.67 41666.67 41666.67 5000 10000
0 0 0 0 0 0.1 0.25
Telephone Stationary Travel Total - Monthly Total - Yearly
500 500 1000
1 1 0
AMC -- Non Comprehensive Total - Monthly Total - Yearly Total - Monthly Total - Yearly
900
10
Aerobics Trainer Cost Membership Fees Yoga Trainer Cost Membership Fees
9000 600
1 30
8000 500
1 30
Dietician Trainer Cost Session Fees Total - Monthly Total - Yearly
5000 250
1 60
Marketing for value added programs Total - Monthly Total - Yearly Total - Monthly Total - Yearly Total - Monthly Total - Yearly
2500
1
Total
Cost
Normal Price
Offer Price
Cost
Rs. 35,000 Rs. 350,000 Rs. 150,000 Rs. 5,000 Rs. 50,000 Rs. 10,000 Rs. 100,000 Rs. 5,000 Rs. 5,000 Rs. 710,000
Margin 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2
Price
Rs. 42,000 Rs. 420,000 Rs. 180,000 Rs. 6,000 Rs. 60,000 Rs. 12,000 Rs. 120,000 Rs. 6,000 Rs. 6,000 Rs. 852,000
Offer Price
Rs. 38,500 Rs. 385,000 Rs. 165,000 Rs. 5,500 Rs. 55,000 Rs. 11,000 Rs. 110,000 Rs. 5,500 Rs. 5,500 Rs. 781,000
Rs. 300,000 Rs. 300,000
0.2
Rs. 360,000 Rs. 360,000
Rs. 330,000 Rs. 330,000
Rs. 1,000,000 Rs. 500,000 Rs. 416,667 Rs. 416,667 Rs. 375,000 Rs. 5,000 Rs. 50,000
Rs. 2,763,333 Rs. 138,167 Rs. 97,167
0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. 0 Rs. 0 Rs. 0
Rs. 2,000 Rs. 1,000 Rs. 5,000
Rs. 8,000
Rs. 0 Rs. 0 Rs. 5,000
Rs. 5,000
Rs. 0 Rs. 0 Rs. 5,000
Rs. 5,000
Rs. 0
Rs. 0
0 0
Rs. 90,000
Rs. 90,000
Rs. 55,000
Rs. 55,000
Rs. 1,115,167
Rs. 1,307,000
Rs. 1,171,000
Rs. 0 Rs. 9,000 Rs. 4,500 Rs. 2,500 Rs. 16,000 Rs. 192,000
0.2 0.2 0.2 0.2
Rs. 0 Rs. 10,800 Rs. 5,400 Rs. 3,000 Rs. 19,200 Rs. 230,400
Rs. 0 Rs. 10,260 Rs. 5,130 Rs. 2,850 Rs. 18,240 Rs. 218,880
Rs. 0 Rs. 0 Rs. 0 Rs. 0 Rs. 0 Rs. 500 Rs. 2,500
Rs. 3,000 Rs. 36,000
0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 500 Rs. 500 Rs. 0
Rs. 1,000 Rs. 12,000
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 9,000 Rs. 0
Rs. 0
0.2
Rs. 10,800 Rs. 10,800
Rs. 129,600
Rs. 10,800 Rs. 10,800
Rs. 129,600
Rs. 20,000 Rs. 240,000
Rs. 30,000 Rs. 360,000
Rs. 29,040 Rs. 348,480
9000 9000
18000 18000
15300 15300 12750 12750
8000 8000
15000 15000
5000 5000
15000 15000
12750 12750
Rs. 40,800 Rs. 489,600
Rs. 22,000 Rs. 264,000
Rs. 48,000 Rs. 576,000
Rs. 2,500 Rs. 2,500
Rs. 30,000
0.2
Rs. 0 Rs. 0
Rs. 0
Rs. 0 Rs. 0
Rs. 0
Rs. 24,500
Rs. 294,000
Rs. 48,000
Rs. 576,000
Rs. 40,800
Rs. 489,600
Rs. 44,500 Rs. 534,000
Rs. 78,000 Rs. 936,000
Rs. 69,840 Rs. 838,080
Rs. 1,649,167
Rs. 2,243,000
Rs. 2,009,080
4166.67 41666.67 Rs. 0 Rs. 0 Rs. 0 250 Rs. 2,500 48583.33 97166.67
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,649,167 Rs. 2,243,000 Rs. 233,920 10 Rs. 2,009,080 Rs. 359,913 Rs. 107,974 Rs. 251,939 22 15
Rs. 1,115,167 Rs. 1,307,000 Rs. 136,000 10 Rs. 1,171,000 Rs. 55,833 Rs. 16,750 Rs. 39,083
Rs. 534,000 Rs. 936,000 Rs. 97,920 10 Rs. 838,080 Rs. 304,080 Rs. 91,224 Rs. 212,856
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 294,000 Rs. 576,000 Rs. 86,400 15 Rs. 489,600 Rs. 195,600 Rs. 58,680 Rs. 136,920
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance and Value added programs start immediately
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,502,167 Rs. 1,955,000 Rs. 190,720 10 Rs. 1,764,280 Rs. 262,113 Rs. 78,634 Rs. 183,479 17 12
Rs. 1,115,167 Rs. 1,307,000 Rs. 136,000 10 Rs. 1,171,000 Rs. 55,833 Rs. 16,750 Rs. 39,083
Rs. 387,000 Rs. 648,000 Rs. 54,720 8 Rs. 593,280 Rs. 206,280 Rs. 61,884 Rs. 144,396
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 147,000 Rs. 288,000 Rs. 43,200 15 Rs. 244,800 Rs. 97,800 Rs. 29,340 Rs. 68,460
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance starts day one set up is complete Value added programs start after 2 Quarters
One GYM Details One time GYM Set Up details One Time
Post Set Up Recurring Details Assured Recurring
Special Programs
Recurring
Total (Set Up + 1 Yr Maintenance)
Per Unit Cost Total
Unit/Ppl
Total - Monthly Total - Yearly
Total - Monthly Total - Yearly Total - Monthly Total - Yearly
Total
Cost Rs. 1,065,167
Normal Price Rs. 1,247,000
Offer Price Rs. 1,077,200
Rs. 20,000 Rs. 240,000
Rs. 30,000 Rs. 360,000
Rs. 29,040 Rs. 348,480
Rs. 23,000
Rs. 276,000
Rs. 48,000
Rs. 576,000
Rs. 40,800
Rs. 489,600
Rs. 43,000 Rs. 516,000
Rs. 78,000 Rs. 936,000
Rs. 69,840 Rs. 838,080
Rs. 1,581,167
Rs. 2,183,000
Rs. 1,915,280
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,581,167 Rs. 2,183,000 Rs. 267,720 12 Rs. 1,915,280 Rs. 334,113 Rs. 100,234 Rs. 233,879 21 15
Rs. 1,065,167 Rs. 1,247,000 Rs. 169,800 14 Rs. 1,077,200 Rs. 12,033 Rs. 3,610 Rs. 8,423
Rs. 516,000 Rs. 936,000 Rs. 97,920 10 Rs. 838,080 Rs. 322,080 Rs. 96,624 Rs. 225,456
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 276,000 Rs. 576,000 Rs. 86,400 15 Rs. 489,600 Rs. 213,600 Rs. 64,080 Rs. 149,520
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance and Value added programs start immediately
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,443,167 Rs. 1,895,000 Rs. 224,520 12 Rs. 1,670,480 Rs. 227,313 Rs. 68,194 Rs. 159,119 16 11
Rs. 1,065,167 Rs. 1,247,000 Rs. 169,800 14 Rs. 1,077,200 Rs. 12,033 Rs. 3,610 Rs. 8,423
Rs. 378,000 Rs. 648,000 Rs. 54,720 8 Rs. 593,280 Rs. 215,280 Rs. 64,584 Rs. 150,696
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 138,000 Rs. 288,000 Rs. 43,200 15 Rs. 244,800 Rs. 106,800 Rs. 32,040 Rs. 74,760
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance starts day one set up is complete Value added programs start after 2 Quarters
Maintenance Fee for Society
Contribution To Society
OutGo by Society
Maintnenance Fee For Fitness Club Monthly Fund Yearly Fund Fitness Club Monthly Fund Yearly Fund
Flats
Avg PPl/Flat 300 2
200
2
Charges to conduct Value Added programs Monthly Fund Yearly Fund
Member Price Rs. 48,000 Rs. 48,000 Rs. 576,000 Regular Price Rs. 19,200 Rs. 19,200 Rs. 230,400
Discount on Trainer and Staff charges Monthly Fund Yearly Fund
Gross Payment to Club Cash inflow to Society from Club Discount and benefits to society Net OutGo by Society
Total PPL 600
Fee Per Apt Rs. 120
Rs. 36,000 Rs. 432,000
400
Rs. 180
Rs. 36,000 Rs. 432,000
Revenue to Club Rs. 40,800
Rs. 40,800 Rs. 489,600
Contribution Contribution % 15 Rs. 7,200
Rs. 7,200 Rs. 86,400 15 15
Offer Price Rs. 18,240
Rs. 18,240 Rs. 218,880
Discount Discount % Rs. 960
Rs. 960 Rs. 11,520
5 5 5
Rs. 29,040 Rs. 7,200 Rs. 960 Rs. 20,880
One GYM Details Equipment Interiors One Time Club Staff
Special Programs
Events
Maintenance
Internal Monthly
Total Total
20 GYMs --
Total Total
Other Company Cost
Other Fixed Yearly Charges
Net Total (Total Rev - Fixed Yearly Cost)
Gross Profit -- 20 GYM's Gross Profit -- 1 GYM
Operating Profit Interest Income Net Income Before Tax Tax Net Income After Tax
Total
Total Total
Total - Monthly Total - Yearly
Total - Monthly Total - Yearly
Biggest Loser
AMC -- Non Comprehensive Total - Monthly Total - Yearly
750
14
Company cost -- Stationary, Supervision, Phone etc … Total - Monthly Total - Yearly
1000
1
Total Total
Total Total
Overall Project Head Site Head - 1 Site Head - 2 Site Head - 3 Site Head - 4 Telephone
83333.33 41666.67 41666.67 41666.67 41666.67 5000
1 1 1 1 1 1
Stationary Travel Architect Total - Yearly - 20 GYMs Total - Yearly - 1 GYM
5000 5000 10000
1 1 10
Training Charges Technician's Salary Total - Monthly Total - Yearly
5000 10000
1 5
rly Cost)
Cost Rs. 1,540,000 Rs. 500,000 Rs. 2,040,000
Normal Price Rs. 1,848,000 Rs. 600,000 Rs. 2,448,000
Offer Price Rs. 1,663,200 Rs. 540,000 Rs. 2,203,200
Rs. 47,500 Rs. 570,000
Rs. 57,000 Rs. 684,000
Rs. 54,150 Rs. 649,800
Rs. 50,000 Rs. 600,000
Rs. 140,000 Rs. 1,680,000
Rs. 119,000 Rs. 1,428,000
Rs. 10,500 Rs. 0
0.2
Rs. 12,600 Rs. 12,600
Rs. 151,200
Rs. 12,600 Rs. 12,600
Rs. 151,200
Rs. 0 Rs. 0
Rs. 0
0.2
Rs. 0
Rs. 0 Rs. 0
Rs. 0
Rs. 3,210,000
Rs. 4,963,200
Rs. 4,432,200
Rs. 64,200,000
Rs. 99,264,000
Rs. 88,644,000
Rs. 1,000,000 Rs. 500,000 Rs. 416,667 Rs. 416,667 Rs. 375,000 Rs. 60,000
Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0
Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0
Rs. 60,000 Rs. 60,000 Rs. 100,000
Rs. 2,988,333 Rs. 149,417
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 5,000 Rs. 50,000 Rs. 50,000
Rs. 600,000
0 0
Rs. 0 Rs. 0
Rs. 0 Rs. 0 Rs. 0
Rs. 0
Rs. 67,788,333
Rs. 20,805,667 Rs. 1,040,283
#VALUE! #VALUE!
Rs. 99,214,000 Rs. 88,594,000
Rs. 1,040,283 Rs. 364,099 Rs. 676,184
250
30000
7500000
doc_827240949.xls
Few Projects are in almost ready state to begin fitness Club Work Project execution will be in phases within and across years Invoice will be generated every 60 days and payment is expected within 7 days of invoice generation Project contract will not break in between Even distribution of work for the entire project No unpredictable changes in the financial,management and operational position of the Builder Fit n Fine will solely be responsible for setting up a fitness club Fit n Fine will solely be responsible for setting up a fitness club Maintenance will be undertaken by Fit 'n Fine Trainers will be provided by Fit 'n Fine Value added services will be allowed in the Club house premises Value added Services will begin in 3 months of the fitness club set up No major national or global events that threaten the stability and health of the country and its citizen No unpredictable changes in price of fitness, medical, or office equipment. Insurance and Utilities to be taken care by Builder/Society A constantly growing economy without any major recession or boom. No rent will be charged to Fit 'n Fine for the club Fit 'n Fine will be responsible only for Fitness Club and not the entire club house
Recruit people from some fitness Academy such as K11. Give them prior notification Several processes occur simultaneously: Planning phase - Draw plan based on Housing complex needs and space Execution Phase - Parallel Activities - Appointed Architect and finalize club design - Select Vendor (New or existing) and award job - Vendor complete the décor - Equipment order placed and received Set up and testing phase - Parallel Activities - Equipment Set up - Internal Training - Testing Total Set up Time
Stage 0
Stage 1
Stage 2
Total
Time in Weeks Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 Wk8 1 1 5 1 1 5 3 2 1 1 1 8 Weeks
Author: Last week buffer for any unexpected scenarios
Author: Last week buffer for any unexpected scenarios
Weeks 1 4 GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set up up up up up up up up up up up up up up up up up up up up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 1
8 9 10 11 12 16 17 18 19 20 23 24 25 26 27 28 31 32 33 34 35 36 39 40 41
2 3 4 5 7 8 9 10
12 13 14 15
17 18 19
2
Resources Project Head Site Head
1 4
Q1 Q2 Q3 Q4
1 14 27 40
13 26 39 52
Achitect on Contract --- Per Site Consulting Money Achitect on Contract --- Per Site Consulting Money
Contractor Fixed Price, so no prob of resources
42 43 44 47 48 49 50 51
52 Q1 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor Trainer House Keeping staff Aerobics Yoga Dietician Technician Total 1 0 0 0 0 0 0 0 1 1 Q2 7 1 0 2 1 0 0 0 2 5 Q3 5 8 0 16 8 1 1 1 3 30 Q4 7 13 0 26 13 8 8 8 5 68 Total 20 13 0 26 13 8 8 8 5 68
6
Buffer
11
16
20
Weeks 1 4 GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM GYM Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set Set up up up up up up up up up up up up up up up up up up up up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Resources Project Head Site Head 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Phase Phase Phase Phase 1 2 3 4 5 5 5 5 8 8 8 8 Q1 Q2 Q3 Q4 40 40 40 40 1 14 27 40 1 4 9 9 13 26 39 52 40 43 48 48 1 8 9 16 4 11 12 19 9 16 17 24 9 16 17 24 17 20 25 25 24 27 32 32 25 28 33 33 32 35 40 40 8 9 10 11 12 16 17 19 20 23 24 25 27 28 31 32 33 35 36 39 40 41 42 43 47
1 4
Achitect on Contract --- Per Site Consulting Money Achitect on Contract --- Per Site Consulting Money
Contractor Fixed Price, so no prob of resources
48
50
52 Year_2 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total Q1 4 20 0 40 20 13 13 13 5 104 Q2 6 24 0 48 24 20 20 20 7 139 Q3 5 30 0 60 30 24 24 24 8 170 Q4 5 35 0 70 35 30 30 30 10 205 Total 20 35 0 70 35 30 30 30 10 205
Buffer
33 36 41 41
Year_3 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total
Q1 4 40 0 80 40 35 35 35 10 235
Q2 6 44 0 88 44 40 40 40 12 264
Q3 5 50 0 100 50 44 44 44 13 295
Q4 5 55 0 110 55 50 50 50 15 330
Total 20 55 0 110 55 50 50 50 15 330
Year_4 Num of GYMs - Completed Operational GYMs
Q1 4 60
Q2 6 64
Q3 5 70
Q4 5 75
Total 20 75
Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total
0 120 60 55 55 55 15 360
0 128 64 60 60 60 17 389
0 140 70 64 64 64 18 420
0 150 75 70 70 70 20 455
0 150 75 70 70 70 20 455
Year_5 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1) Technician Total
Q1 4 80 0 160 80 75 75 75 20 485
Q2 6 84 0 168 84 80 80 80 22 514
Q3 5 90 0 180 90 84 84 84 23 545
Q4 5 95 0 190 95 90 90 90 25 580
Total 20 95 0 190 95 90 90 90 25 580
Year_6 Num of GYMs - Completed Operational GYMs Fitness Club Supervisor (1) Trainer (2) House Keeping staff (2) Aerobics (1) Yoga (1) Dietician (1)
Q1 0 100 0 200 100 95 95 95
Q2 0 100 0 200 100 100 100 100
Q3 0 100 0 200 100 100 100 100
Q4 0 100 0 200 100 100 100 100
Total 0 100 0 200 100 100 100 100
Technician Total
25 610
25 625
25 625
25 625
25 625
One GYM Details One time GYM Set Up details Equipment
Interiors
Personnel Cost
Other Misc Cost
Set Up Professional Fee
One Time
Post Set Up Recurring Details Assured Recurring Club Staff Cost
Personnel Cost
Other Misc Cost
Maintenance
Special Programs
Marketing
Recurring
Total (Set Up + 1 Yr Maintenance)
Per Unit Cost
Unit/Ppl
Equipment
Weighing scale Treadmill Cross trainer + cycle Steeper + Twister Multi gym Light weight training Torque GS Free Style Material
Cost Per Unit
17,500 175,000 150,000 5,000 50,000 10,000 100,000 5,000 5000
Units
2 2 1 1 1 1 1 1 1
Total
Interiors includes A.C., Music system etc Total
300000
1
Overall Project Head Site Head - 1 Site Head - 2 Site Head - 3 Site Head - 4 Induction Training Charges Technician's Salary Total - Yearly - 20 GYMs Total - Yearly - 1 GYM Total Cost -- 1 GYM Set up
83333.33 41666.67 41666.67 41666.67 41666.67 5000 10000
1 1 1 1 1 1 5
Telephone Stationary Travel Total Cost -- 1 GYM Set up
1000 500 5000
2 2 1
ssional Fee Set Up Professional Fee Total Total
0 0
0 0
Fitness Club Supervisor Trainer House Keeping staff Raw Materials Total - Monthly Total - Yearly
6000 4500 4500 2500
0 2 1 1
Overall Project Head Site Head - 1 Site Head - 2 Site Head - 3 Site Head - 4 Training Charges Technician's Salary Total - Monthly Total - Yearly
83333.33 41666.67 41666.67 41666.67 41666.67 5000 10000
0 0 0 0 0 0.1 0.25
Telephone Stationary Travel Total - Monthly Total - Yearly
500 500 1000
1 1 0
AMC -- Non Comprehensive Total - Monthly Total - Yearly Total - Monthly Total - Yearly
900
10
Aerobics Trainer Cost Membership Fees Yoga Trainer Cost Membership Fees
9000 600
1 30
8000 500
1 30
Dietician Trainer Cost Session Fees Total - Monthly Total - Yearly
5000 250
1 60
Marketing for value added programs Total - Monthly Total - Yearly Total - Monthly Total - Yearly Total - Monthly Total - Yearly
2500
1
Total
Cost
Normal Price
Offer Price
Cost
Rs. 35,000 Rs. 350,000 Rs. 150,000 Rs. 5,000 Rs. 50,000 Rs. 10,000 Rs. 100,000 Rs. 5,000 Rs. 5,000 Rs. 710,000
Margin 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2
Price
Rs. 42,000 Rs. 420,000 Rs. 180,000 Rs. 6,000 Rs. 60,000 Rs. 12,000 Rs. 120,000 Rs. 6,000 Rs. 6,000 Rs. 852,000
Offer Price
Rs. 38,500 Rs. 385,000 Rs. 165,000 Rs. 5,500 Rs. 55,000 Rs. 11,000 Rs. 110,000 Rs. 5,500 Rs. 5,500 Rs. 781,000
Rs. 300,000 Rs. 300,000
0.2
Rs. 360,000 Rs. 360,000
Rs. 330,000 Rs. 330,000
Rs. 1,000,000 Rs. 500,000 Rs. 416,667 Rs. 416,667 Rs. 375,000 Rs. 5,000 Rs. 50,000
Rs. 2,763,333 Rs. 138,167 Rs. 97,167
0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. 0 Rs. 0 Rs. 0
Rs. 2,000 Rs. 1,000 Rs. 5,000
Rs. 8,000
Rs. 0 Rs. 0 Rs. 5,000
Rs. 5,000
Rs. 0 Rs. 0 Rs. 5,000
Rs. 5,000
Rs. 0
Rs. 0
0 0
Rs. 90,000
Rs. 90,000
Rs. 55,000
Rs. 55,000
Rs. 1,115,167
Rs. 1,307,000
Rs. 1,171,000
Rs. 0 Rs. 9,000 Rs. 4,500 Rs. 2,500 Rs. 16,000 Rs. 192,000
0.2 0.2 0.2 0.2
Rs. 0 Rs. 10,800 Rs. 5,400 Rs. 3,000 Rs. 19,200 Rs. 230,400
Rs. 0 Rs. 10,260 Rs. 5,130 Rs. 2,850 Rs. 18,240 Rs. 218,880
Rs. 0 Rs. 0 Rs. 0 Rs. 0 Rs. 0 Rs. 500 Rs. 2,500
Rs. 3,000 Rs. 36,000
0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0 0
Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 500 Rs. 500 Rs. 0
Rs. 1,000 Rs. 12,000
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 9,000 Rs. 0
Rs. 0
0.2
Rs. 10,800 Rs. 10,800
Rs. 129,600
Rs. 10,800 Rs. 10,800
Rs. 129,600
Rs. 20,000 Rs. 240,000
Rs. 30,000 Rs. 360,000
Rs. 29,040 Rs. 348,480
9000 9000
18000 18000
15300 15300 12750 12750
8000 8000
15000 15000
5000 5000
15000 15000
12750 12750
Rs. 40,800 Rs. 489,600
Rs. 22,000 Rs. 264,000
Rs. 48,000 Rs. 576,000
Rs. 2,500 Rs. 2,500
Rs. 30,000
0.2
Rs. 0 Rs. 0
Rs. 0
Rs. 0 Rs. 0
Rs. 0
Rs. 24,500
Rs. 294,000
Rs. 48,000
Rs. 576,000
Rs. 40,800
Rs. 489,600
Rs. 44,500 Rs. 534,000
Rs. 78,000 Rs. 936,000
Rs. 69,840 Rs. 838,080
Rs. 1,649,167
Rs. 2,243,000
Rs. 2,009,080
4166.67 41666.67 Rs. 0 Rs. 0 Rs. 0 250 Rs. 2,500 48583.33 97166.67
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,649,167 Rs. 2,243,000 Rs. 233,920 10 Rs. 2,009,080 Rs. 359,913 Rs. 107,974 Rs. 251,939 22 15
Rs. 1,115,167 Rs. 1,307,000 Rs. 136,000 10 Rs. 1,171,000 Rs. 55,833 Rs. 16,750 Rs. 39,083
Rs. 534,000 Rs. 936,000 Rs. 97,920 10 Rs. 838,080 Rs. 304,080 Rs. 91,224 Rs. 212,856
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 294,000 Rs. 576,000 Rs. 86,400 15 Rs. 489,600 Rs. 195,600 Rs. 58,680 Rs. 136,920
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance and Value added programs start immediately
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,502,167 Rs. 1,955,000 Rs. 190,720 10 Rs. 1,764,280 Rs. 262,113 Rs. 78,634 Rs. 183,479 17 12
Rs. 1,115,167 Rs. 1,307,000 Rs. 136,000 10 Rs. 1,171,000 Rs. 55,833 Rs. 16,750 Rs. 39,083
Rs. 387,000 Rs. 648,000 Rs. 54,720 8 Rs. 593,280 Rs. 206,280 Rs. 61,884 Rs. 144,396
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 147,000 Rs. 288,000 Rs. 43,200 15 Rs. 244,800 Rs. 97,800 Rs. 29,340 Rs. 68,460
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance starts day one set up is complete Value added programs start after 2 Quarters
One GYM Details One time GYM Set Up details One Time
Post Set Up Recurring Details Assured Recurring
Special Programs
Recurring
Total (Set Up + 1 Yr Maintenance)
Per Unit Cost Total
Unit/Ppl
Total - Monthly Total - Yearly
Total - Monthly Total - Yearly Total - Monthly Total - Yearly
Total
Cost Rs. 1,065,167
Normal Price Rs. 1,247,000
Offer Price Rs. 1,077,200
Rs. 20,000 Rs. 240,000
Rs. 30,000 Rs. 360,000
Rs. 29,040 Rs. 348,480
Rs. 23,000
Rs. 276,000
Rs. 48,000
Rs. 576,000
Rs. 40,800
Rs. 489,600
Rs. 43,000 Rs. 516,000
Rs. 78,000 Rs. 936,000
Rs. 69,840 Rs. 838,080
Rs. 1,581,167
Rs. 2,183,000
Rs. 1,915,280
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,581,167 Rs. 2,183,000 Rs. 267,720 12 Rs. 1,915,280 Rs. 334,113 Rs. 100,234 Rs. 233,879 21 15
Rs. 1,065,167 Rs. 1,247,000 Rs. 169,800 14 Rs. 1,077,200 Rs. 12,033 Rs. 3,610 Rs. 8,423
Rs. 516,000 Rs. 936,000 Rs. 97,920 10 Rs. 838,080 Rs. 322,080 Rs. 96,624 Rs. 225,456
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 276,000 Rs. 576,000 Rs. 86,400 15 Rs. 489,600 Rs. 213,600 Rs. 64,080 Rs. 149,520
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance and Value added programs start immediately
One GYM Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Gross Profit % Net Profit % Set Up Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit Maintenance - Total Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Recurring Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Maintenance - Value Added Programs Total Cost Total Regular Price/Revenue Discounts Offered Discount % offered Total Offer Price/Revenue Gross Profit Tax Net Profit
Rs. 1,443,167 Rs. 1,895,000 Rs. 224,520 12 Rs. 1,670,480 Rs. 227,313 Rs. 68,194 Rs. 159,119 16 11
Rs. 1,065,167 Rs. 1,247,000 Rs. 169,800 14 Rs. 1,077,200 Rs. 12,033 Rs. 3,610 Rs. 8,423
Rs. 378,000 Rs. 648,000 Rs. 54,720 8 Rs. 593,280 Rs. 215,280 Rs. 64,584 Rs. 150,696
Rs. 240,000 Rs. 360,000 Rs. 11,520 3 Rs. 348,480 Rs. 108,480 Rs. 32,544 Rs. 75,936
Rs. 138,000 Rs. 288,000 Rs. 43,200 15 Rs. 244,800 Rs. 106,800 Rs. 32,040 Rs. 74,760
Activities Set up Maintenance and Value added Programs Total
Months 2 12 14
Assumption Maintenance starts day one set up is complete Value added programs start after 2 Quarters
Maintenance Fee for Society
Contribution To Society
OutGo by Society
Maintnenance Fee For Fitness Club Monthly Fund Yearly Fund Fitness Club Monthly Fund Yearly Fund
Flats
Avg PPl/Flat 300 2
200
2
Charges to conduct Value Added programs Monthly Fund Yearly Fund
Member Price Rs. 48,000 Rs. 48,000 Rs. 576,000 Regular Price Rs. 19,200 Rs. 19,200 Rs. 230,400
Discount on Trainer and Staff charges Monthly Fund Yearly Fund
Gross Payment to Club Cash inflow to Society from Club Discount and benefits to society Net OutGo by Society
Total PPL 600
Fee Per Apt Rs. 120
Rs. 36,000 Rs. 432,000
400
Rs. 180
Rs. 36,000 Rs. 432,000
Revenue to Club Rs. 40,800
Rs. 40,800 Rs. 489,600
Contribution Contribution % 15 Rs. 7,200
Rs. 7,200 Rs. 86,400 15 15
Offer Price Rs. 18,240
Rs. 18,240 Rs. 218,880
Discount Discount % Rs. 960
Rs. 960 Rs. 11,520
5 5 5
Rs. 29,040 Rs. 7,200 Rs. 960 Rs. 20,880
One GYM Details Equipment Interiors One Time Club Staff
Special Programs
Events
Maintenance
Internal Monthly
Total Total
20 GYMs --
Total Total
Other Company Cost
Other Fixed Yearly Charges
Net Total (Total Rev - Fixed Yearly Cost)
Gross Profit -- 20 GYM's Gross Profit -- 1 GYM
Operating Profit Interest Income Net Income Before Tax Tax Net Income After Tax
Total
Total Total
Total - Monthly Total - Yearly
Total - Monthly Total - Yearly
Biggest Loser
AMC -- Non Comprehensive Total - Monthly Total - Yearly
750
14
Company cost -- Stationary, Supervision, Phone etc … Total - Monthly Total - Yearly
1000
1
Total Total
Total Total
Overall Project Head Site Head - 1 Site Head - 2 Site Head - 3 Site Head - 4 Telephone
83333.33 41666.67 41666.67 41666.67 41666.67 5000
1 1 1 1 1 1
Stationary Travel Architect Total - Yearly - 20 GYMs Total - Yearly - 1 GYM
5000 5000 10000
1 1 10
Training Charges Technician's Salary Total - Monthly Total - Yearly
5000 10000
1 5
rly Cost)
Cost Rs. 1,540,000 Rs. 500,000 Rs. 2,040,000
Normal Price Rs. 1,848,000 Rs. 600,000 Rs. 2,448,000
Offer Price Rs. 1,663,200 Rs. 540,000 Rs. 2,203,200
Rs. 47,500 Rs. 570,000
Rs. 57,000 Rs. 684,000
Rs. 54,150 Rs. 649,800
Rs. 50,000 Rs. 600,000
Rs. 140,000 Rs. 1,680,000
Rs. 119,000 Rs. 1,428,000
Rs. 10,500 Rs. 0
0.2
Rs. 12,600 Rs. 12,600
Rs. 151,200
Rs. 12,600 Rs. 12,600
Rs. 151,200
Rs. 0 Rs. 0
Rs. 0
0.2
Rs. 0
Rs. 0 Rs. 0
Rs. 0
Rs. 3,210,000
Rs. 4,963,200
Rs. 4,432,200
Rs. 64,200,000
Rs. 99,264,000
Rs. 88,644,000
Rs. 1,000,000 Rs. 500,000 Rs. 416,667 Rs. 416,667 Rs. 375,000 Rs. 60,000
Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0
Rs. Rs. Rs. Rs. Rs. Rs.
0 0 0 0 0 0
Rs. 60,000 Rs. 60,000 Rs. 100,000
Rs. 2,988,333 Rs. 149,417
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0 Rs. 0
Rs. 0 Rs. 0
Rs. 5,000 Rs. 50,000 Rs. 50,000
Rs. 600,000
0 0
Rs. 0 Rs. 0
Rs. 0 Rs. 0 Rs. 0
Rs. 0
Rs. 67,788,333
Rs. 20,805,667 Rs. 1,040,283
#VALUE! #VALUE!
Rs. 99,214,000 Rs. 88,594,000
Rs. 1,040,283 Rs. 364,099 Rs. 676,184
250
30000
7500000
doc_827240949.xls