You are on page 1of 10

3I Infotech Limited

Rs Crore

Project Profitability Estimation Statement
Revenue

Total

License Revenue
Implementation Revenue
Customisation revenue
Revenue from Managed Services
Revenue from Software Solutions
Revenue from BPO Operations
AMC Revenue, if any
Third party product Revenue
Any other Revenue
Total Revenue

Month 1

Month 2

Month 3

Month 4

Month 5

57,000,000

11,400,000

11,400,000

11,400,000

11,400,000

11,400,000

57,000,000

11,400,000

11,400,000

11,400,000

11,400,000

11,400,000

Direct Expenses
Capital Recovery for Licenses sale @ 30%
Cost already incurred
Manpower/ Outsourced/ Third party product cost
Customisation Man Months
Customisation - Manpower cost

Senior consultant
Consultant
Jr Consultant

Project Manager/Project Dir 1,1A ,2&2A
Project Manager/Project Dir 3
Project Leader
4
Module Leader/Quality Lead5
Team Member
6
Team Member
7
Team Member
8
Team Member
9
Team Member
Trainee(T)

Outsourced resources
Implementation / Consultancy Man Months
Implementation / Consultancy - Manpower Cost
Project director
Project Manager/Project Dir 1,1A ,2&2A
Project Manager/Project Dir 3
Senior consultant
Project Leader
4
Consultant
Module Leader/Quality Lead5
Jr Consultant
Team Member
6
Team Member
7
Team Member
8
Team Member
9
Team Member
Trainee(T)
Other Consultants
AMC cost, if any
Third party product cost
Any other cost (Pls Specify)
Any Sales Commission Payable
Any taxes, octroi/ sales tax etc to be borne by us not paid by customer

269,974
173,649
106,079
83,467
54,683
32,185
23,977
15,243
17,950
20,000

269,974
173,649
106,079
83,467
54,683
32,185
23,977
15,243
17,950
11,667

Offshore
269,974
173,649
106,079
83,467
54,683
32,185
23,977
15,243
17,950
20,000

269,974
173,649
106,079
83,467
54,683
32,185
23,977
15,243
17,950

Travel Cost
Project related travel
Project related onsite allowance/ accomodation to be provided
Guest House
Rs. 350/- Per bed/Day as per usage
Chargeouts
Estate Charge out
Infra Charge Out
Support services

-

-

-

-

-

-

-

-

-

-

-

0.00
Onsite

Project director

-

No of Manmonths

0.00

Offshore
0
0

No of Manmonths

0
0
0

60

0

250,000
250,000
-

4,585

6,400
3,000
4,585

0.00

Offshore

No of Manmonths
0

60

No of Manmonths
0

60

60.00
700,000
700,000
618,266
4,917,779
1,583,700
-

0.00
-

Onsite

Offshore

No of Manmonths
0

60

50,000
50,000
-

60.00
700,000
700,000
618,266
4,917,779
1,348,740
-

No of Manmonths
0

60

50,000
50,000
-

-

0
0

No of Manmonths

Offshore

-

-

0
0

0.00
-

Onsite

50,000
50,000
###
###

-

0
0

60.00
700,000
700,000
618,266
4,917,779
2,209,433
-

No of Manmonths

Offshore

-

50,000
50,000
-

-

0.00
-

Onsite

60.00
700,000
700,000
618,266
4,917,779
2,835,166

No of Manmonths
-

Onsite

300.00
3,500,000
3,500,000
3,091,328
24,588,895
8,700,047
-

No of Manmonths
-

Onsite

50,000
50,000
-

-

0
0

60.00
700,000
700,000
618,266
4,917,779
723,007
-

-

0
0

Total Direct Cost

40,130,270

9,121,211

8,495,478

7,869,744

7,634,785

7,009,052

Gross Profit

16,869,730

2,278,789

2,904,522

3,530,256

3,765,215

4,390,948

EBDITA

16,869,730

-

-

2,278,789

-

-

2,904,522

-

-

3,530,256

-

-

3,765,215

-

-

4,390,948

1 6. 4. Dell.2 6.8 4.Customisation completion Milestone 4 (Please specify) .500.4.1 7.2 7.6 7.3 4.Warranty Sign off 7 8 9 SLAs 10 Penalty clauses 10. 4.6 Delivery schedule Milestone 1 (Please specify) .130.270 5.4.) Gross Margin % 16.2. Cisco.328 24.700.3 3.1 3.4 3.UAT Milestone 5 (Please specify) . 3.5 3.270 Sagar Karnik Mamta Patil 17th July 2008 .9 License Revenue Implementation Revenue Customisation revenue Revenue from Managed Services Revenue from Software Solutions Revenue from BPO Operations AMC Revenue.22 4.11 Project Costing License Cost @ 30% of License revenue Cost already incurred Customisation cost (including Salary) Customisation effort in no of manmonths Implementation / Consultancy cost (including Salary) Implementation / Consultancy effort in no of manmonths Any other project direct costs such as Project related travel Project related onsite allowance/ accomodation to be provided Guest House .2 2.7 Total Price 57.Contract sign off Milestone 2 (Please specify) .5 8. 4.4 4.000 4 4.588.869.4. 4.3 8.7 4.880.PROPOSAL TERM SHEET 1 2 GEOGRAPHY BUSINESS GROUP South Asia MEI .6 3.Live cutover and data migration Milestone 6 (Please specify) .4 7.1 4.4 8.3 3 Own product / Service (Please mention name of the product) Third party product Others (Please specify) Sun Servers.7 3.6 4. octroi/ sales tax etc to be borne by us not paid by customer Total Cost 250.895 8.1 Name of Sales Person 11 Approved By Sales Head Business Head ED/ MD if required as per gross profit margin norms 12 3.7 Payment Terms Milestone 1 (Please specify) Milestone 2 (Please specify) Milestone 3 (Please specify) Milestone 4 (Please specify) Milestone 5 (Please specify) Milestone 6 (Please specify) Reasons for deviation if payment terms are not as per norms 8.000.3 Acceptance from Development / Customisation / Delivery Team on Efforts Customisation effort in case of product Development effort in case of Products / Services Delivery team in case of Delivery of Solution 7.047 40.091. if any Third party product cost Any other cost Any Sales Commission Payable Any taxes.2 6 Reasons for accepting order if gross margin less than the threshold 6.000 3.2 8.000 300 Date 39.1 8.GAP completion Milestone 3 (Please specify). Microsoft Project Pricing in Rs.730 30% 5 5.2 4.2 3. 4.Per bed/Day as per usage Chargeouts AMC cost. 350/.Rs.000.5 7.3.1 Gross Profit ( Rs.1 2.8 3. if any Third party product Revenue Any other Revenue 57.SA Name of the Prospect/ Client Godrej Upstream Product offered 2.000 3.5 4. 4.9 4.4.3 7.

Project Initiation Document Date of filling initiation form: Project Name: Client Name: Client address/ Telephone: Client contact Person Project Manager: Project Leader: Brief Project Description: Project Type Billing type Warranty Applicable -Yes / No (Mention the period. if yes) Effort Already Spent (in person months) Attachments Customer PID (for ICICI projects only) Proposal Customer PO/ Agreement Project Start Date Project End Date: For CFO Office Project Initiation Form Received Date: Project ID Allocation Date: Project ID .

Road No 16. NO. Panchpakhadi.Ramachandra EMP. Thane 400602 Address: 2) Plot No A 274. 51787 Managed Services monthly advance 5 years Say "y" against documents attached y y 1st Sep 2008 31st Aug 2013 . Wagle Industrial Estate.ocument 23rd July 2008 Managed Services Godrej Upstream Address: 1) Ranka Commercial Plaza. Ramchandra Nagar 2. 51787 NAME. NO. Kamgar Hospital Road.Thane 400604 Alok Srivastava NAME.Ramachandra EMP.

.

License Requisition form Geography initiating request: Business Group (ES/ BPG) Person initiating request: Purpose:(Sale / Repalcement/ Demo / Internal use / Installation on laptop) Product Name: Version: Modules: Remarks: Module Name Type of License No of users Revenue Components Table In this table. Revenue Components Ø      License (Own Product) (Oracle) (Others – please specify) Ø      Installation / Ø      Customization Ø      Support Service Ø      Third Party Supplies Ø      Others (Please specify) Total Contract Value For CFO Office License requisition Form Received Date: License Allocation Date: Asset Code Amount . kindly specify the amounts against the various Revenue components. which make up the total contract value for the project.

Asset Description and Grouping .

780 405.235.496 11.496 107.526 0 0 0 0 0 0 0 0 0 0 0 0 0 120.832 0 2.243 10.297 278.392 2.291.100.371 539.520 998.483 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11.077 0 712.780 278.548 23. VAT @ 4% Order to be placed on 594.955 1.093 0 0 421.771 31.GODREJ UPSTREAM FINAL COSTING Particulars PRODUCTS Cisco Catalyst 3750 Core Switch Layer 3 .000 0 200.205 101.000 0 9.771 0 0 125.000 95.313 2.359.000 4 80.807 86.359.093 107.629 0 0 0 3.144.953 Ingram 492.000 0 0 0 2.560 0 224.120 508.243 101.496 107.573 467.151 59.350 0 0 0 259.144.954 0 0 0 0 4.944 844.196 6.781 11.154 1.5% incl of Octroi S.243 14.188.110.750 915 34.140 847. Insurance SERVICES for first 3 Years 8x5xNBD Smartnet Support for Cisco Catalyst 3750 for first 3 years 8x5xNBD Smartnet Support for Cisco Catalyst 2960 Series for first 3 years Premium Support for above UTM for first 3 years Spectrum Support for App Server 1 for first 3 years Spectrum Support for App Server 2 for first 3 years Spectrum Support for Telecom Server 1 for first 3 years Spectrum Support for Telecom Server 2 for first 3 years Support for SAN Switch .624 0 0 0 0 0 0 0 0 0 0 0 0 0 44.306 266.537.537.505 0 0 0 6.000 0 6.387 134.16 Port SUN SAN Storage SUN Tape Library and Back-Up Software Additional HBA cards .873 0 17. AntiSpam.750 462.016.000 0 200.470 18.000 0 14.000 960.526 INgram LOCUZ & Ingram & Redignton LOCUZ & Ingram & Redignton Redington 3i cost Locuz 20.070 256.888 89.371 23.118 Ingram 1.36 % incl VAT and Octroi @ 4.213.922 Ingram .for first 3 years Support on SUN Storage for first 3 years Support on Tape Library for first 3 years Support on DeskTops for first 3 years Manpower Cost for first 3 years Contingency for first 3 years Installation.016.629 0 0 0 150.000 10.895 0 0 0 164.205 105.761 0 0 0 8.935 10.093 0 0 421.000 28 56.070 2.585.922 62. Fine Tuning and Commissioning .984 11.000 3 3 3 3 3 3 3 3 1.144.782 70.715 0 512.515 3 1 1 Locuz & Ingram & Redington Locuz & Ingram & Redington Redington & Insight Redington & Insight Redington DELL SAM Infotech SAM Infotech SAM Infotech SAM Infotech Ingram Ingram Val Rack 18.613 2 14 1.043.371 256.588.350 0 0 0 2.371 373.832 Ingram 94.610.770 620.070 256.313 266.070 2.873 0 0 0 22.T.306 388.955 137.720 423.580 499.368.397 0 0 388.382 Ingram 404.467 375.872 19.520 38. Testing.474 11.580 11.781 0 0 46.894 24.000 3.000 11.895 373.093 107.253 144.016.468 0 0 0 1 1 1 1 1 1 1 4 50 505 505 9 2 315 1 505 4 1 1 2 844.000 6 120.639.720 3.311 0 0 0 0 3.134 0 0 0 156.560 0 24.080 1.081 620.4Gb FC Single Port HBA 16 inch monitors Desktops with 3 years warranty and Win XP Pre-Loaded MS Windows Server Cal Licences MS Windows 2003 Server Enterprise Edition MS SQL 2003 Enterprise Edition Licences MS SQL CAL Licences LINUX for Mail Server with 3 years Support Trend Micro Anti Virus with 3 years support Racks Spares Online back up licence additional Adaptor for core switch for redendency Products Total Insurance on Products @ 2 % Overall Products Total incl.140 847.204 0 405.( Cisco) SUN App Server 1 with VMWare Licences ( AMD) SUN App Server 2 with VMWare Licences ( AMD) SUN Telecom Server 1( Dual CPU Quad core) SUN Telecom Server 2 ( Dual CPU Quad core) SAN Switch .575 47. @ 12.080 1.771.350 0 0 0 2.922 0 62.066 535.312 0 0 375.428 24.998 55.935 14.598 44.423 0 0 1.888 0 89.382 94.000 21.T.853.429.One Time Services for first 3 Years Total SERVICES for next 2 Years 8x5xNBD Smartnet Support for Cisco Catalyst 3750 for next 2 years 8x5xNBD Smartnet Support for Cisco Catalyst 2960 Series for next 2 years Unit Rate Qty Cost Price without Taxes Cost Price Cost price S.000 31.000 0 0 0 700.586 23.298 6.894 20.835.562 24. Web Filter and IDP Licences.653 Ingram 373.000 42 84.474 17.984 118.853.312 95.933 564.228 94.205 86.720 3.392 2.382 0 360.080 1.000 68.560 0 224.48 Port Cisco Catalyst 2960 Series Access Switch 48 Port UTM Device with 5 Years Antivirus.000 427.757.902 404.832 134.000 0 10.297 2.034 620.682.371 256.075 137.140 847.371 373.888 Ingram 2.392 2.872 1 492.

900 0 0 960.552.854 5.000 0 2 2 2 2 2 2 2 2 1.900 ### 8.400.000 300.815.484 ### ### 5.189.774 1.900 0 0 105.484 ### 5.161.for next 2 years Support on SUN Storage for next 2 years Support on Tape Library for next 2 years Support on DeskTops for additional 2 years Manpower Cost for next 2 years Contingency for next 2 years ( Trend Micro and LINUX for 2 years ) Installation.563.253 1.688.245 100. on27645540 on reducing balance For 4th & 5th year AMC payout on interest Rental cost for equipments to meet the tight delivery time frames Interest ### 38.356 544 29 1.854 7.838.694.191 47.191 280. Testing.704 Year 1 Total H/w & S/w cost on a reducing balance method Technology Technology including H/w & S/w ammortised over a period of six years Technology Interest Cal @ 11.484 0.776.552.p.900 0 0 960.191 47.040 0 0 390.000 125.603.000 0 0 3.a.000 0 0 846 700.253 1.000 42. Fine Tuning and Commissioning .631 173.316 71.167.191 30.433 1.166 2.573.737 348.245 312.484 937.395 47.573.040 0 0 3.000 63.000 Total cost per year ( 1+2+3+4+5) 8.966 390.000 0 0 854.787 5.000 31.771 31.491 Ingram LOCUZ & Redington & Ingram LOCUZ & Redington & Ingram Redington Redington Redington Third party .040 0 0 3.688.541 63.191 5.774 1.776.184 - 348.395 71.11 2.541 42.316 7.233 390.491 0 0 0 0 0 0 0 0 0 0 0 0 0 Year 2 Year 3 Year 4 year 5 ### ### ### 2.688.395 71.Premium Support for above UTM for next 2 years Spectrum Support for App Server 1 for next 2 years Spectrum Support for App Server 2 for next 2 years Spectrum Support for Telecom Server 1 for next 2 years Spectrum Support for Telecom Server 2 for next 2 years Support for SAN Switch .771 21.000 21.958 Margin Gross margin % Final Price/ price per seat per month 0 0 0 0 0 0 0 0 0 0 0 0 0 1.650 Total Cost incurred from year 1 to year 5 Total cost / seats/ 60 months= per seat per month 40.316 71.700 ### 7.395 47.010 2 0 1 310.252.One Time Services for next 2 Years Total 155.000 250.191 280.622 1.

420 1.000 35.588.312.851 1.144.884. also interest Face Value Service Tax 12.700.555.36% Monthly Billing 950.591.270 57.067.555.312.371.000 500 1.260 364.144.371 any other cost.168 1.957 39.312.884.957 2.260 3.126 4.371.895 Margin Margin % cost to be booked in ISH PID PO to be issued to Locuz ( inclusive of all tax) 10.130.957 2.851 30% 30% 30% 30% 10.880.047 12.000 40.275 3.058.260 364.420 1.371.851 30% 30% .851 1.260 364.312.486.312.275 3.144.884.168 1.895 35.851 1.144.058.275 57.000.434.371 4.588.371.957 2.058.787 2.476 35.168 1.486.842 1.126 4.420.168 8.884.275 3.058.126 364.476 1.168 1.486.884.000 117.486.957 2.Revenue 1 Product cost 2 Service cost for five years 3 Interest on initial cap exp Total Add: Travel cost Total Cost Monthly Revenue Total Order Value No of work station Rate per month per work station No of Months On installaing Amount Amount the product First Year Second Year Third year Fourth Year Fifth Year 24.371.058.371 6.275 3.328 9.371 35.486.126 4.900 60 Cost 24.270 250.260 364.000.126 4.