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 2.730 30% 5 5.9 4.8 4.3.Rs.5 8.Contract sign off Milestone 2 (Please specify) .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 .091.500.3 8.4.000 4 4.130.000 3.2 2.7 4.1 6.1 Name of Sales Person 11 Approved By Sales Head Business Head ED/ MD if required as per gross profit margin norms 12 3. 4.Warranty Sign off 7 8 9 SLAs 10 Penalty clauses 10.270 5.5 7.3 3.6 7.1 3.000 300 Date 39.6 3.1 7.4. if any Third party product Revenue Any other Revenue 57.Live cutover and data migration Milestone 6 (Please specify) .UAT Milestone 5 (Please specify) .6 4.000 3.4 7.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.4.2.5 4.1 Gross Profit ( Rs.047 40.4.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.22 4. 4.3 3 Own product / Service (Please mention name of the product) Third party product Others (Please specify) Sun Servers.7 Total Price 57. Dell.328 24. Cisco.270 Sagar Karnik Mamta Patil 17th July 2008 .7 3.2 7.3 4.2 6.6 Delivery schedule Milestone 1 (Please specify) .588.1 4. 3. if any Third party product cost Any other cost Any Sales Commission Payable Any taxes. 4.9 License Revenue Implementation Revenue Customisation revenue Revenue from Managed Services Revenue from Software Solutions Revenue from BPO Operations AMC Revenue.2 3. 350/. 4.GAP completion Milestone 3 (Please specify).8 3.4 8. octroi/ sales tax etc to be borne by us not paid by customer Total Cost 250.000.2 4.1 8.895 8. Microsoft Project Pricing in Rs.4 3.SA Name of the Prospect/ Client Godrej Upstream Product offered 2.2 6 Reasons for accepting order if gross margin less than the threshold 6.PROPOSAL TERM SHEET 1 2 GEOGRAPHY BUSINESS GROUP South Asia MEI .880.869. 4. 4.Customisation completion Milestone 4 (Please specify) .000.3 7.700.4 4.2 8.5 3.Per bed/Day as per usage Chargeouts AMC cost.) Gross Margin % 16.

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 .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.

Thane 400604 Alok Srivastava NAME.Road No 16. 51787 Managed Services monthly advance 5 years Say "y" against documents attached y y 1st Sep 2008 31st Aug 2013 . NO.Ramachandra EMP. Wagle Industrial Estate. Kamgar Hospital Road.ocument 23rd July 2008 Managed Services Godrej Upstream Address: 1) Ranka Commercial Plaza. Thane 400602 Address: 2) Plot No A 274. Panchpakhadi. 51787 NAME. NO. Ramchandra Nagar 2.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. kindly specify the amounts against the various Revenue components. 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 . which make up the total contract value for the project.

Asset Description and Grouping .

895 0 0 0 164.496 107.520 38.955 137.382 94.771.598 44.313 266.526 0 0 0 0 0 0 0 0 0 0 0 0 0 120.077 0 712.588.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.134 0 0 0 156.GODREJ UPSTREAM FINAL COSTING Particulars PRODUCTS Cisco Catalyst 3750 Core Switch Layer 3 .204 0 405.075 137.093 107.560 0 24.228 94.080 1.629 0 0 0 150.000 0 10.5% incl of Octroi S.000 0 14.520 998.483 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11.066 535.144.144.922 62.387 134.429.000 42 84.423 0 0 1.496 107.944 844.467 375.T.888 0 89.954 0 0 0 0 4.526 INgram LOCUZ & Ingram & Redignton LOCUZ & Ingram & Redignton Redington 3i cost Locuz 20.562 24.313 2.580 499.144.151 59.955 1.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 0 200.093 107.548 23. Fine Tuning and Commissioning .933 564.935 10.297 278.080 1.780 278.922 0 62.312 0 0 375.935 14.080 1.034 620.093 0 0 421.000 4 80.000 0 9.771 0 0 125.371 373.505 0 0 0 6.537.771 31.311 0 0 0 0 3.213.48 Port Cisco Catalyst 2960 Series Access Switch 48 Port UTM Device with 5 Years Antivirus.205 101.16 Port SUN SAN Storage SUN Tape Library and Back-Up Software Additional HBA cards .368.016.T.235.000 3 3 3 3 3 3 3 3 1.154 1.894 20.428 24. Testing.894 24.359.720 423. @ 12.350 0 0 0 2.580 11.984 11.120 508.872 1 492.902 404.922 Ingram .888 89.205 86.392 2.998 55.070 256.720 3.873 0 17.382 Ingram 404.306 266.000 10.613 2 14 1.093 0 0 421.624 0 0 0 0 0 0 0 0 0 0 0 0 0 44.832 Ingram 94.371 539.000 31.984 118.371 256.750 915 34.371 23.140 847.243 10.895 373.110.000 6 120.832 0 2.835.297 2.140 847.000 0 0 0 700.639.000 21.586 23.953 Ingram 492.560 0 224.243 101.196 6.350 0 0 0 259.682.873 0 0 0 22.043.585.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.371 256.000 427.000 0 6.770 620.781 11.474 17.853.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.629 0 0 0 3.474 11.243 14.832 134.350 0 0 0 2. 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 .496 11.575 47.000 960.000 68.761 0 0 0 8.081 620.560 0 224.000 28 56.359.392 2.016.888 Ingram 2.118 Ingram 1.100.715 0 512.291.000 11.872 19.016.782 70.392 2.253 144.000 0 0 0 2.000 3.537.610.720 3.653 Ingram 373.807 86.397 0 0 388.371 373.205 105.070 2.853.298 6.000 95. Web Filter and IDP Licences.140 847.306 388.188.470 18.( 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 .070 256.757.573 467.750 462.070 2.000 0 200.382 0 360.312 95. AntiSpam.780 405.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. VAT @ 4% Order to be placed on 594.781 0 0 46.36 % incl VAT and Octroi @ 4.

854 5.900 0 0 960.245 100.491 Ingram LOCUZ & Redington & Ingram LOCUZ & Redington & Ingram Redington Redington Redington Third party .189.316 71.253 1.737 348. Fine Tuning and Commissioning .11 2.191 30.776.552.000 125.000 0 2 2 2 2 2 2 2 2 1.000 Total cost per year ( 1+2+3+4+5) 8.771 31.900 0 0 105.000 21.484 0.484 ### ### 5.040 0 0 3.356 544 29 1.184 - 348.000 31.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 .688.p.603.900 0 0 960.400.000 0 0 846 700.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.040 0 0 390.541 63.040 0 0 3.541 42.484 ### 5.167.233 390.774 1.000 42.573.395 71.484 937. 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.253 1.771 21.491 0 0 0 0 0 0 0 0 0 0 0 0 0 Year 2 Year 3 Year 4 year 5 ### ### ### 2.000 300.433 1.000 250.650 Total Cost incurred from year 1 to year 5 Total cost / seats/ 60 months= per seat per month 40.573.966 390.838.000 63.252.245 312.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. Testing.563.191 5.One Time Services for next 2 Years Total 155.191 47.631 173.191 280.776.787 5.688.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.000 0 0 3.815.161.191 47.191 280.700 ### 7.900 ### 8.a.010 2 0 1 310.694.395 71.854 7.552.622 1.395 47.000 0 0 854.395 47.316 7.774 1.688.316 71.166 2.

260 364.312.058.895 Margin Margin % cost to be booked in ISH PID PO to be issued to Locuz ( inclusive of all tax) 10.168 1.275 3.371.957 39.126 4.168 1.371.371 35.371.842 1.126 4.957 2.900 60 Cost 24.884.275 3. also interest Face Value Service Tax 12.851 1.957 2.126 4.36% Monthly Billing 950.851 30% 30% .884.434.895 35.126 4.486.000 500 1.047 12.787 2.420 1.260 364.884.420 1.884.700.058.420.000.851 1.880.371.486.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.144.058.260 364.275 3.588.000.000 35.957 2.067.884.000 40.312.486.371 4.270 250.270 57.275 3.275 57.058.957 2.312.371 any other cost.260 3.371 6.260 364.130.588.168 1.312.144.312.851 1.851 30% 30% 30% 30% 10.000 117.144.058.486.328 9.168 1.126 364.476 1.371.486.591.168 8.555.144.555.476 35.