Turnkey
XYZ 13 Month Project
Days / month 20 Using 8 Hrs/day adjust hours/day in rate tab !!!! Staffing per Phase
Dur (Days) From To
Project Preparation 5 10/1/02 10/4/02 20.0
Business Blueprint 62 10/7/02 12/31/02
Realization 84 1/2/03 4/30/03
Final Preparation 101 5/1/03 9/30/03
Go Live & Support 23 10/1/03 10/31/03
TOTAL 275 15.0
Phase Functional Technical Security Training Travel Total
Project Preparation 4.0 0.0 0.0 0.0 0.0 4.0
Business Blueprint 7.2 1.0 0.0 1.1 0.0 9.3
Realization 7.5 4.5 0.0 0.0 0.0 12.0 10.0
Final Preparation 7.5 5.0 0.0 3.0 0.0 15.5 Travel
Go Live & Support 5.3 3.5 0.0 0.0 0.0 8.8
Training
Change rate % here
5.0 Security
Functional Technical Security Training Travel Total Rate Total w/ billed
Total
rate
w/ billed rate
Project Preparation $ 25,400 $ - $ - $ - $ - $ 25,400 100% $ 25,400
Technical
Business Blueprint $ 446,000 $ 50,000 $ - $ 63,000 $25,000 $ 584,000 100% ###
Realization $ 779,520 $ 332,640 $ - $ - $25,000 $1,137,160 100% ### Functional
Final Preparation $ 748,600 $ 338,800 $ - $ 230,400 $25,000 $1,342,800 100%
0.0 ###
Go Live & Support $ 151,340 $ 73,600 $ - $ - $10,000 $ 234,940 100% ### Bus iness
Project Preparation Blueprint Realization Final Preparation G o Live & Support
Totals $ 2,150,860 $ 795,040 $ - $ 293,400 $85,000 $3,324,300 $ - ###
275 2% 18% 31% 28% 8% Total 8 Blended Rate
PROJECT STAFFING MODEL PROJECT PREPARATION BUSINESS BLUEPRINT REALIZATION FINAL PREPARATION GO LIVE & PROD SUP Days Revenue Cost GPM GPM % Fees Days Hours
Consultant Role Rate/Day Alloc Days Fees Alloc Days Fees Alloc Days Fees Alloc Days Fees Alloc Days Fees ### 2,869 22954 $144.82
10/1/02 5 10/4/02 10/7/02 50 12/31/02 1/2/03 84 4/30/03 5/1/03 77 8/30/02 10/1/03 23 10/31/03
Functional
SAP Project Manager PM $1,480 100% 5 $7,400 100% 50 $74,000 100% 84 $124,320 100% 100 $148,000 100% 23 $34,040 262 $387,760
FI Consultant FI $1,200 100% 5 $6,000 100% 50 $60,000 100% 84 $100,800 100% 77 $92,400 50% 12 $13,800 228 $273,000
CO Consultant CO $1,200 0% 0 $0 100% 50 $60,000 100% 84 $100,800 100% 77 $92,400 50% 12 $13,800 223 $267,000
MM Consultant MM $1,200 100% 5 $6,000 100% 50 $60,000 100% 84 $100,800 100% 77 $92,400 100% 23 $27,600 239 $286,800
PP Consultant PP $1,200 0% 0 $0 100% 50 $60,000 100% 84 $100,800 100% 77 $92,400 100% 23 $27,600 234 $280,800
PM Consultant PM/AM/QM/WM $1,200 0% 0 $0 60% 30 $36,000 50% 42 $50,400 50% 39 $46,200 25% 6 $6,900 116 $139,500
SD Consultant SD1 $1,200 100% 5 $6,000 100% 50 $60,000 100% 84 $100,800 100% 77 $92,400 50% 12 $13,800 228 $273,000
SD Consultant SD2 $1,200 0% 0 $0 60% 30 $36,000 100% 84 $100,800 100% 77 $92,400 50% 12 $13,800 203 $243,000
Subtotal 4.0 20 $25,400 7.2 360 $446,000 7.5 630 $779,520 7.5 601 $748,600 5.3 121 $151,340
Technical
BASIS BASIS $1,200 0% 0 $0 50% 25 $30,000 90% 76 $90,720 100% 77 $92,400 100% 23 $27,600 201 $240,720
ABAP 1 Conv/Int/Rep $800 0% 0 $0 50% 25 $20,000 90% 76 $60,480 100% 77 $61,600 100% 23 $18,400 201 $160,480
ABAP 2 Conv/Int/Rep $800 0% 0 $0 0% 0 $0 90% 76 $60,480 100% 77 $61,600 50% 12 $9,200 164 $131,280
ABAP 3 Conv/Int/Rep $800 0% 0 $0 0% 0 $0 90% 76 $60,480 100% 77 $61,600 50% 12 $9,200 164 $131,280 $795,040 893.5 7148
ABAP 4 Conv/Int/Rep $800 0% 0 $0 0% 0 $0 90% 76 $60,480 100% 77 $61,600 50% 12 $9,200 164 $131,280
Subtotal 0.0 0 $0 1.0 50 $50,000 4.5 378 $332,640 5.0 385 $338,800 3.5 81 $73,600
Security
Subtotal 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 0 $0 0
Training 07/01/03 64 09/30/03
Training FI/CO Training $1,200 0% 0 $0 35% 18 $21,000 0% 0 $0 100% 64 $76,800 0% 0 $0 82 $97,800
Training MM/PP Training $1,200 0% 0 $0 35% 18 $21,000 0% 0 $0 100% 64 $76,800 0% 0 $0 82 $97,800 $293,400 244.5 1956
Training SD Training $1,200 0% 0 $0 35% 18 $21,000 0% 0 $0 100% 64 $76,800 0% 0 $0 82 $97,800
Subtotal 0.0 0 $0 1.1 53 $63,000 0.0 0 $0 3.0 192 $230,400 0.0 0 $0 245 $0 0
Specialists
Travel $85,000 0 0
Travel $0 $25,000 $25,000 $25,000 $10,000
Subtotal 0.0 0 $0 0.0 0 $25,000 0.0 0 $25,000 0.0 0 $25,000 0.0 0 $10,000 85000 $85,000
Grand Totals $584,000 ### ### $234,940
Quarterly Breakdown FY 2002 FY03
Q1 Jan -Mar $852,870 $852,870
Q2 Apr--Jun $807,794 $807,794
Q3 Jul-Sep $785,256 $785,256
Q4 Oct-Dec $609,400 $234,940 $844,340
Total $609,400 $2,680,860 $3,290,260
Page 1
Partnering
Trelleborg 9 Month Build
days / month 20 using 8 hours/day adjust hours/day in rate tab !!!! Staffing per Phase
Project Preparation 5 Days 10/1/02 10/4/02 (mainly leads at non-Functional areas)
Business Blueprint 62 Days 10/7/02 12/31/02 15.0
Realization 84 Days 1/2/03 4/30/03
Final Preparation 101 Days 5/1/03 9/30/03
Go Live & Support 23 Days 10/1/03 10/31/03
TOTAL 275 MONTHS
Functional Technical Security ES / Chg MgtSpecialists Totals
Project Preparation 4.0 0.0 0.0 0.0 0.0 4.0 10.0
Business Blueprint 5.8 1.0 0.0 0.5 0.0 7.3
Realization 6.4 4.5 0.0 1.8 0.0 12.7
Final Preparation 5.2 3.5 0.0 2.5 0.0 11.2
Go Live & Support 5.3 3.5 0.0 0.0 0.0 8.8
Specialists
Change rate % here ES / Chg Mgt
Functional Technical Security ES / Chg MgtSpecialists Tot.100% Rate Total w/ billed rate
Total w/ billed rate Security
5.0
Project Preparation $ 25,000 $ - $ - $ - $ - $ 25,000 100% $ 25,000 Technical
Business Blueprint $ 285,200 $ 52,923 $ - $ 24,056 $ - $ 362,179 100% $ 362,179 Functional
Realization $ 428,400 $ 314,496 $ - $ 120,960 $ - $ 863,856 100% $ 863,856
Final Preparation $ 383,800 $ 294,112 $ - $ 189,896 $ - $ 867,808 100% $ 867,808
Go Live & Support $ 94,300 $ 68,080 $ - $ - $ - $ 162,380 100% $ 162,380
TotalS $ 1,216,700 $ 729,611 $ - $ 334,912 $ - $ 2,281,223 $ - $ 2,281,223
======>>
0.0
100% $ 2,281,223
Project Preparation Business Blueprint Realization Final Preparation Go Live & Support
Project Days
275.00 2% 23% 31% 37% 8%
Consultant Role Lvl Rate PP Alloc PP Days PP Fees Alloc BB Days BB Fees Alloc RZ. Days RZ. Fees Alloc FP Days FP Fees Alloc GOL Days GOL Fees Total 8
10/1/02 5 10/4/02 10/7/02 62 12/31/02 1/2/03 84 4/30/03 5/1/03 101 9/30/03 10/1/03 23 10/31/03 Fees Days Hours
Functional $2,281,223 2,868 22945.21
SAP Tech. Project Lead PM MGR1 $1,400 100% 5 $7,000 80% 50 $69,440 90% 76 $105,840 70% 71 $98,980 100% 23 $32,200
FI Consultant FI FC-4 $1,200 100% 5 $6,000 80% 50 $59,520 90% 76 $90,720 70% 71 $84,840 50% 12 $13,800
CO Consultant(Akzo) CO xxx $0 0% 0 $0 80% 50 $0 90% 76 $0 70% 71 $0 50% 12 $0
MM Consultant MM FC-4 $1,200 100% 5 $6,000 80% 50 $59,520 90% 76 $90,720 70% 71 $84,840 100% 23 $27,600
PP Consultant(Akzo) PP xxx $0 0% 0 $0 80% 50 $0 90% 76 $0 70% 71 $0 100% 23 $0
PM Consultant PM/AM/QM/WM FC-4 $1,200 0% 0 $0 50% 31 $37,200 50% 42 $50,400 25% 25 $30,300 25% 6 $6,900
SD Consultants SD1 FC-4 $1,200 100% 5 $6,000 80% 50 $59,520 90% 76 $90,720 70% 71 $84,840 50% 12 $13,800
SD Consultant (Akzo) SD2 xxx $0 0% 0 $0 50% 31 $0 50% 42 $0 70% 71 $0 50% 12 $0
Subtotal 4.0 20 $25,000 5.8 360 $285,200 6.4 538 $428,400 5.2 520 $383,800 5.3 121 $94,300 $1,216,700 1558.1 12464.8
Technical
BASIS BASIS AC-4 $960 0% 0 $0 49% 30 $28,867 90% 76 $72,576 70% 71 $67,872 100% 23 $22,080
ABAP 1 Reports AC-3 $800 0% 0 $0 49% 30 $24,056 90% 76 $60,480 70% 71 $56,560 100% 23 $18,400
ABAP 2 Interfaces AC-3 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 70% 71 $56,560 50% 12 $9,200
ABAP 3 Conversions AC-3 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 70% 71 $56,560 50% 12 $9,200
ABAP 4 Enhancements AC-3 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 70% 71 $56,560 50% 12 $9,200
Subtotal 0.0 0 $0 1.0 60 $52,923 4.5 378 $314,496 3.5 354 $294,112 3.5 81 $68,080 $729,611 872.14 6977.12
Security
Subtotal 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 $0 0 0
ES / Chg Mgt 0
Training FI Chg Mgt EC-4 $800 0% 0 $0 49% 30 $24,056 90% 76 $60,480 64% 64 $51,308 0% 0 $0
Training MM Document EC-4 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 64% 64 $51,308 0% 0 $0
Training SD Chg Mgt EC-4 $800 0% 0 $0 0% 0 $0 0% 0 $0 64% 64 $51,308 0% 0 $0
Training SD RISK EC-2 $560 0% 0 $0 0% 0 $0 0% 0 $0 64% 64 $35,972 0% 0 $0
Subtotal 0.0 0 $0 0.5 30 $24,056 1.8 151 $120,960 2.5 257 $189,896 0.0 0 $0 $334,912 437.911 3503.288
Specialists 0
Subtotal 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 $0 0 0
Approximate Quarterly Breakdown
QTR4 2002 QTR 1 2003 QTR2 2003 QTR3 2003 QTR 4 2003 TOT 2002 TOT 2003 PROJECT TOTAL
$ 387,179 $647,892 $554,920 $528,852 $162,380 $ 387,179 $1,894,044 2,281,223
Page 2
Staffing
Akzo Nobel 13 Month Project
days / month 20 using 8 hours/day adjust hours/day in rate tab !!!! Staffing per Phase
Duration (mainly leads at non-Functional areas)
Project Preparation 5 Days 10/1/02 10/4/02 10.0
Business Blueprint 62 Days 10/7/02 12/31/02
Realization 84 Days 1/2/03 4/30/03
Final Preparation 101 Days 5/1/03 9/30/03
Go Live & Support 23 Days 10/1/03 10/31/03
TOTAL 275
Functional Technical Security ES / Chg MgtSpecialists Totals
Project Preparation 3.5 0.0 0.0 0.0 0.0 3.5
Business Blueprint 2.1 0.5 0.0 0.5 0.0 3.1
Realization 2.3 3.6 0.0 1.8 0.0 7.7
Final Preparation 1.9 2.8 0.0 1.9 0.0 6.6 5.0
Go Live & Support 1.5 2.5 0.0 0.0 0.0 4.0
Specialists
Change rate % here ES / Chg Mgt
Functional Technical Security ES / Chg MgtSpecialists Tot.100% Rate Total w/ billed rate
Total w/ billed rate Security
Project Preparation $ 15,500 $ - $ - $ - $ - $ 15,500 100% $ 15,500 Technical
Business Blueprint $ 162,440 $ 24,056 $ - $ 24,056 $ - $ 210,552 100% $ 210,552 Functional
Realization $ 240,240 $ 241,920 $ - $ 120,960 $ - $ 603,120 100% $ 603,120
Final Preparation $ 240,380 $ 226,240 $ - $ 153,924 $ - $ 620,544 100% $ 620,544
Go Live & Support $ 43,700 $ 46,000 $ - $ - $ - $ 89,700 100% $ 89,700
Totals $ 702,260 $ 538,216 $ - $ 298,940 $ - $ 1,539,416 $ - $ 1,539,416
======>>
0.0
100% $ 1,539,416
Project Preparation Business Blueprint Realization Final Preparation Go Live & Support
Project Days
275.00 2% 23% 31% 37% 8%
Consultant Role Lvl Rate PP Alloc PP Days PP Fees Alloc BB Days BB Fees Alloc RZ. Days RZ. Fees Alloc FP Days FP Fees Alloc GOL Days GOL Fees Total 8
10/1/02 5 10/4/02 10/7/02 62 12/31/02 1/2/03 84 4/30/03 5/1/03 101 9/30/03 10/1/03 23 10/31/03 Fees Days Hours
Functional $1,539,416 1,614 12909.96
SAP Tech. Project Lead PM MGR1 $1,400 50% 2.5 $3,500 50% 31 $43,400 50% 42 $58,800 50% 51 $70,700 50% 12 $16,100
FI Consultant FI FC-4 $1,200 100% 5 $6,000 80% 50 $59,520 90% 76 $90,720 70% 71 $84,840 50% 12 $13,800
CO Consultant(Akzo) CO xxx $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
MM Consultant(Akzo) MM xxx $0 100% 5 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
PP Consultant(Akzo) PP xxx $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
PM Consultant(Akzo) PM/AM/QM/WM xxx $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
SD Consultants SD1 FC-4 $1,200 100% 5 $6,000 80% 50 $59,520 90% 76 $90,720 70% 71 $84,840 50% 12 $13,800
SD Consultant (Akzo) SD2 xxx $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
Subtotal 3.5 17.5 $15,500 2.1 130 $162,440 2.3 193 $240,240 1.9 192 $240,380 1.5 35 $43,700 $702,260 567.3 4538.4
Technical
BASIS(Akzo) BASIS xxx $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
ABAP 1 Reports AC-3 $800 0% 0 $0 49% 30 $24,056 90% 76 $60,480 70% 71 $56,560 100% 23 $18,400
ABAP 2 Interfaces AC-3 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 70% 71 $56,560 50% 12 $9,200
ABAP 3 Conversions AC-3 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 70% 71 $56,560 50% 12 $9,200
ABAP 4 Enhancements AC-3 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 70% 71 $56,560 50% 12 $9,200
Subtotal 0.0 0 $0 0.5 30 $24,056 3.6 302 $241,920 2.8 283 $226,240 2.5 58 $46,000 $538,216 672.77 5382.16
Security
Subtotal 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 $0 0 0
ES / Chg Mgt 0
Training FI Chg Mgt EC-4 $800 0% 0 $0 49% 30 $24,056 90% 76 $60,480 64% 64 $51,308 0% 0 $0
Training MM Document EC-4 $800 0% 0 $0 0% 0 $0 90% 76 $60,480 64% 64 $51,308 0% 0 $0
Training SD Chg Mgt EC-4 $800 0% 0 $0 0% 0 $0 0% 0 $0 64% 64 $51,308 0% 0 $0
Training SD(Akzo) Risk xxx $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0 0% 0 $0
Subtotal 0.0 0 $0 0.5 30 $24,056 1.8 151 $120,960 1.9 192 $153,924 0.0 0 $0 $298,940 373.675 2989.4
Specialists 0
Subtotal 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 0.0 0 $0 $0 0 0
Approximate Quarterly Breakdown
QTR4 2002 QTR 1 2003 QTR2 2003 QTR3 2003 QTR 4 2003 TOT 2002 TOT 2003 PROJECT TOTAL
$ 226,052 $452,340 $384,090 $387,234 $ 89,700 $ 226,052 $1,313,364 1,539,416
Page 3
Rates
AC-1 $65 520 ABAP
AC-2 $85 680 ABAP
AC-3 $100 800 ABAP
AC-4 $120 960 ABAP
DIR1 $230 1840 VP
DIR2 $250 2000 VP
EC-1 $60 480 Education
EC-2 $70 560 Education
EC-3 $80 640 Education
EC-4 $100 800 Education
FC-1 $120 960 Functional
FC-2 $130 1040 Functional
FC-3 $140 1120 Functional
FC-4 $150 1200 Functional
MGR1 $175 1400 PM
MGR2 $200 1600 PM
NVP1 $275 2200 Exex VP
SVP2 $300 2400 Exex VP
SM1 $250 2000 Specialist
SM2 $260 2080 Specialist
TC-1 $45 360 Offshore
TC_2 $65 520 Offshore
TC-3 $75 600 Offshore
TC-4 $100 800 Offshore
XXX $0 0
Hours/day 8
Page 4