td acu c9737 improve wording search functionality v0.2 costs
DESCRIPTION
OKTRANSCRIPT
E3 Estimation Model
C9737 Improve Wording Search Functionality
Version: 0.2
Issue Date: Thursday, February 28, 2013
Owner: Seliyan Swaminathan
Copyright Information
Trademark InformationCompany, product, or brand names mentioned in this document, may be the trademarks of their owners.
Approved Distribution ListName TitleGayle Sixsmith Xuber Programme Manager
Guidelines
© Xchanging 2012
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical photocopying, recording, or otherwise, without the prior permission of Xchanging.
Xchanging Internal – strictly internal use only. The document and the information it contains must not be shared with anyone who is not an Xchanging employee. This document is confidential to Xchanging and may not be disclosed to third parties in whole or part.
Note only signed hard copies and electronic masters of documents will be controlled. Any other copy may not be current.
Press the button for the required estimation phase. Once figures are entered do NOT press any other button again as figures may be cleared out
document.xls
Xchanging Internal – strictly internal use only
Title C9737 Improve Wording Search FunctionalityE3 Estimation Model
Reviewed by
Version Created by Comment Functional Lead Technical Lead Test Lead Delivery Lead Project Manager
0.1 Seliyan Swaminathan DraftName
Date
0.2 Seliyan Swaminathan After review by SRG and ACE Name
DateName
DateName
DateName
DateName
DateName
DateName
Date
Guidelines
document.xls Page 3
Xchanging Internal – strictly internal use onlyModifications: Functional Area 1 e.g. Underwriting
E3 Estimation Model Estimates are recorded in: Days
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Project Management Analysis
Modification Ref Modification Name Skillset Total Monitoring ReportingC9737 TS01 New system parameter Skillset 1 (e.g. Genius) 1.72 0.22 0.10 0.11 0.10 0.11 0.00 0.00 0.00 0.00C9737 TS02 Change Select Product Wording (GHSL28) Skillset 1 (e.g. Genius) 3.30 0.44 0.30 0.33 0.10 0.11 0.00 0.00 0.00 0.00C9737 Web UI Testing Skillset 1 (e.g. Genius) 1.37 0.22 0.10 0.11 0.10 0.11 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Totals in Days (including Contingency) 6.39 0.88 0.55 0.33 0.00 0.00 0.00
Totals in Days (excluding Contingency) 5.40 0.50 0.30 0.00
Guidance Factors 8% 2% 0% 0%8% 2% 25% 80%
Guidelines
TotalPM
incl cont.Monitoring
incl cont.Reportingincl cont.
TotalAnalysisincl cont.
Functional Specification
Functional Specificationincl rework& incl cont.
Functional Specification
incl cont.
XPERT Default Factors (for information only)
document.xls Page 4
Xchanging Internal – strictly internal use onlyModifications: Functional Area 1 e.g. Underwriting
E3 Estimation Model Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Ref Modification NameC9737 TS01 New system parameterC9737 TS02 Change Select Product Wording (GHSL28)C9737 Web UI Testing
Totals in Days (including Contingency)
Totals in Days (excluding Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Analysis Design
Review Review0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0% 0% 0% 0% 0% 0% 0%20% 20% 20% 80% 20% 20% 5%
Functional Specification
Reworkincl cont.
Reviewincl cont.
Total Architecture
incl cont.Architecture
Design
Architecture Design
incl rework& incl cont.
Architecture Design incl cont.
Architecture Design Rework
incl cont.Review
incl cont.
Total Technical
Specificationincl cont.
Technical Specification
pt I
Technical Specification
pt Iincl rework& incl cont.
document.xls Page 5
Xchanging Internal – strictly internal use onlyModifications: Functional Area 1 e.g. Underwriting
E3 Estimation Model Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Ref Modification NameC9737 TS01 New system parameterC9737 TS02 Change Select Product Wording (GHSL28)C9737 Web UI Testing
Totals in Days (including Contingency)
Totals in Days (excluding Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Design Test Design
Review Review Test Design0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0% 0% 0% 0% 0% 0% 0% 0%80% 20% 20% 30% 80% 20% 20% 20%
Technical Specification
pt Iincl cont.
Technical Specification
pt IRework
incl cont.Review
incl cont.
Technical Specification
pt II
Technical Specification
pt IIincl rework& incl cont.
Technical Specification
pt IIincl cont.
Technical Specification
pt IIRework
incl cont.Review
incl cont.
Total Test Design
incl cont.
Test Design incl rework
& incl cont.
document.xls Page 6
Xchanging Internal – strictly internal use onlyModifications: Functional Area 1 e.g. Underwriting
E3 Estimation Model Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Ref Modification NameC9737 TS01 New system parameterC9737 TS02 Change Select Product Wording (GHSL28)C9737 Web UI Testing
Totals in Days (including Contingency)
Totals in Days (excluding Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Test Design Build
Review0.00 0.00 0.00 0.00 1.17 0.00 0.00 0.00 0.00 0.00 0.00 0.50 0.550.00 0.00 0.00 0.00 2.20 0.00 0.00 0.00 0.00 0.00 0.00 1.20 1.320.00 0.00 0.00 0.00 0.93 0.00 0.00 0.00 0.00 0.00 0.00 0.30 0.330.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 4.30 0.00 0.00 0.00 0.00 2.20
0.00 0.00 0.00 2.00
0% 0% 0% 0% 80% 20% 20%80% 20% 20% 10% 80% 20% 20%
Test Design incl cont.
Test Design Rework
incl cont.Review
incl cont.
Total Build
incl cont.Development Specification
Development Specification incl rework
& incl cont.
Development Specification
incl cont.
Development Specification
Reworkincl cont.
Dev Spec Review
Dev Spec Review
incl cont.
Development & Unit Test
(PUT)Dev & UT
incl cont.
document.xls Page 7
Xchanging Internal – strictly internal use onlyModifications: Functional Area 1 e.g. Underwriting
E3 Estimation Model Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Ref Modification NameC9737 TS01 New system parameterC9737 TS02 Change Select Product Wording (GHSL28)C9737 Web UI Testing
Totals in Days (including Contingency)
Totals in Days (excluding Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Build Testing Contingency
Amount0.10 0.20 0.20 0.22 0.10 0.20 0.33 0.30 0.33 0.00 0.00 10%0.30 0.33 0.30 0.33 0.20 0.22 0.66 0.60 0.66 0.00 0.00 10%0.10 0.20 0.10 0.20 0.10 0.20 0.22 0.20 0.22 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10%
0.73 0.75 0.62 1.21 1.21 0.00
0.50 0.60 0.40 1.10 0.00
20% 25% 10% 50% 0% 10%20% 25% 10% 50% 25% 10%
Dev & UT Review
Dev & UT Review
incl cont.PUT Rework after Testing
PUT Rework after Testing
incl cont.Integration
Testing
Integration Testing
incl cont.
TotalTesting
incl cont.System Testing
System Testing
incl cont.Regression
Testing
Regression Testing
incl cont.
document.xls Page 8
Xchanging Internal – strictly internal use onlyModifications: Functional Area 2 e.g. Claims
E3 Estimation Model Estimates are recorded in: Days
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Analysis Design Test Design
Modification Ref Modification Name Skillset TotalSkillset 1 (e.g. Genius) 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00
Totals in Days (including Contingency) 0.00 0.00 0.00 0.00 0.00 0.00
Guidance FactorsXPERT Default Factors (for information only)
Guidelines
Modification Project
Management
TotalPM
incl cont.
TotalAnalysisincl cont.
Total Architecture
incl cont.
Total Technical
Specificationincl cont.
Total Test Design
incl cont.
document.xls Page 9
Xchanging Internal – strictly internal use onlyFunctional Area 2 e.g. Claims
Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Name
Totals in Days (including Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Build Testing Contingency
Amount0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00
0.00
10%10%
Total Build
incl cont.
Development & Unit Test
(PUT)
TotalTesting
incl cont.
document.xls Page 10
Xchanging Internal – strictly internal use onlyModifications: Functional Area 3 e.g. Finance
E3 Estimation Model Estimates are recorded in: Days
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Analysis Design Test Design
Modification Ref Modification Name Skillset TotalSkillset 1 (e.g. Genius) 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00
Totals in Days (including Contingency) 0.00 0.00 0.00 0.00 0.00 0.00
Guidance FactorsXPERT Default Factors (for information only)
Guidelines
Modification Project
Management
TotalPM
incl cont.
TotalAnalysisincl cont.
Total Architecture
incl cont.
Total Technical
Specificationincl cont.
Total Test Design
incl cont.
document.xls Page 11
Xchanging Internal – strictly internal use onlyFunctional Area 3 e.g. Finance
Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Name
Totals in Days (including Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Build Testing Contingency
Amount0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00
0.00
10%10%
Total Build
incl cont.
Development & Unit Test
(PUT)
TotalTesting
incl cont.
document.xls Page 12
Xchanging Internal – strictly internal use onlyModifications: Functional Area 4 e.g. Workflow
E3 Estimation Model Estimates are recorded in: Days
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Analysis Design Test Design
Modification Ref Modification Name Skillset TotalSkillset 1 (e.g. Genius) 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00
Totals in Days (including Contingency) 0.00 0.00 0.00 0.00 0.00 0.00
Guidance FactorsXPERT Default Factors (for information only)
Guidelines
Modification Project
Management
TotalPM
incl cont.
TotalAnalysisincl cont.
Total Architecture
incl cont.
Total Technical
Specificationincl cont.
Total Test Design
incl cont.
document.xls Page 13
Xchanging Internal – strictly internal use onlyFunctional Area 4 e.g. Workflow
Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Name
Totals in Days (including Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Build Testing Contingency
Amount0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00
0.00
10%10%
Total Build
incl cont.
Development & Unit Test
(PUT)
TotalTesting
incl cont.
document.xls Page 14
Xchanging Internal – strictly internal use onlyModifications: Functional Area 5 e.g. Reporting
E3 Estimation Model Estimates are recorded in: Days
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Analysis Design Test Design
Modification Ref Modification Name Skillset TotalSkillset 1 (e.g. Genius) 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00
Totals in Days (including Contingency) 0.00 0.00 0.00 0.00 0.00 0.00
Guidance FactorsXPERT Default Factors (for information only)
Guidelines
Modification Project
Management
TotalPM
incl cont.
TotalAnalysisincl cont.
Total Architecture
incl cont.
Total Technical
Specificationincl cont.
Total Test Design
incl cont.
document.xls Page 15
Xchanging Internal – strictly internal use onlyFunctional Area 5 e.g. Reporting
Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Name
Totals in Days (including Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Build Testing Contingency
Amount0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00
0.00
10%10%
Total Build
incl cont.
Development & Unit Test
(PUT)
TotalTesting
incl cont.
document.xls Page 16
Xchanging Internal – strictly internal use onlyModifications: Functional Area 6 e.g. Integration
E3 Estimation Model Estimates are recorded in: Days
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Analysis Design Test Design
Modification Ref Modification Name Skillset TotalSkillset 1 (e.g. Genius) 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00
Totals in Days (including Contingency) 0.00 0.00 0.00 0.00 0.00 0.00
Guidance FactorsXPERT Default Factors (for information only)
Guidelines
Modification Project
Management
TotalPM
incl cont.
TotalAnalysisincl cont.
Total Architecture
incl cont.
Total Technical
Specificationincl cont.
Total Test Design
incl cont.
document.xls Page 17
Xchanging Internal – strictly internal use onlyFunctional Area 6 e.g. Integration
Estimates are recorded in:
Development PUT task entry & Phase Totals incl Contingency
Development PUT task entry & phase breakdown totals + contingency
Task Totals + Combined totals for Contingency & Rework
Task Totals + Separate totals for Contingency & Rework
ALL columns displayed including Dev PUT, Totals, Contingency, Rework
Modification Name
Totals in Days (including Contingency)
Guidance FactorsXPERT Default Factors (for information only)
Build Testing Contingency
Amount0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00 0.00 10%0.00 0.00
0.00
10%10%
Total Build
incl cont.
Development & Unit Test
(PUT)
TotalTesting
incl cont.
document.xls Page 18
Xchanging Internal – strictly internal use only
Programme and Project Management Estimation E3 Estimation Model
Project Duration (ETC) in months 0 monthsHours per Day 7.5Weeks per Month 4Minimum Effort (for Modification Tasks) 0.2 days
Programme Management OfficePMO Activities 1.0 7.5 7.5 5.0 1.0
1.0 7.5 7.5 5.0 1.0
Lead RolesFunctional Lead 1.0 7.5 7.5 5.0 1.0Technical Lead 1.0 7.5 7.5 5.0 1.0Testing Lead 1.0 7.5 7.5 5.0 1.0Delivery Lead 1.0 7.5 7.5 5.0 1.0
4.0 30.0 30.0 20.0 4.0
Project ManagerCustomer PM Status Meetings 1.0 0.5 0.0Project Team Status Meetings 1.0 0.5 0.0Internal Project Status Reporting 1.0 0.5 0.0External Project Status Reporting 1.0 0.5 0.0Planning and Plan Maintenance 2.0 1.1 0.0Managing Risks 1.0 0.5 0.0Managing Issues 1.0 0.5 0.0Managing Scope and Change Control 2.0 1.1 0.0Managing on-site consultants 1.0 0.5 0.0Managing Project Team 2.0 1.1 0.0Timesheet Jobcode Maintenance 1.0 0.5 0.0Timesheet Checking 1.0 1.0 0.7 0.0Budget Control 2.0 2.0 1.3 0.0Invoice Checking 1.0 0.1 0.0Resource Management (Web Resource) 1.0 0.5 0.0Organisation/Validation of Estimates 1.0 0.5 0.0Governance Documentation and Process 2.0 1.1 0.0
0.0 21.0 4.0 11.5 0.0
Programme ManagerCustomer Relationship Management 1.0 1.0 0.7 0.0Project Board Meetings 1.0 0.5 0.0Internal Programme Meetings 1.5 0.8 0.0Internal Programme Reporting 1.0 0.5 0.0External Programme Reporting 1.0 0.5 0.0Programme Plan tracking/Plan maintenance 1.0 1.0 0.7 0.0Budget Control 1.0 1.0 0.7 0.0Resource Management 1.0 0.5 0.0Governance Documentation and Process 1.0 0.5 0.0
9.5 3.0 5.4 0.0
Guidelines
One-off (d)
Hours/ week
Hours/ Month
Total Days/ month
Total Days/ Project
One-off (d)
Hours/ week
Hours/ Month
Total Days/ month
Total Days/ Project
One-off (d)
Hours/ week
Hours/ Month
Total Days/ month
Total Days/ Project
One-off (d)
Hours/ week
Hours/ Month
Total Days/ month
Total Days/ Project
Xchanging Internal – strictly internal use only
EXPENSES Days Rate ValueTravel and Subsistance 0.00Flights 0 0 0.00Accommodation 0 0 0.00Miscellaneous 0 0 0.00
Total Currency e.g. GBP 0.00
Guidelines
document.xls Page 20
Xchanging Internal – strictly internal use onlyS3 Schedule Summary
Add Role Add Role Add RoleWARNING - Project Duration is set to zero - correct this on P&PM sheet Add Rate Add Rate Add Rate
COST REVENUE ALTERNATE
Task Days Role Rate Calculated Value Rate Calculated Value Rate Calculated Value
Programme Management 1.00 1.00 0.00 0.00 0.00
Programme Management 0.00 0.00
PMO 1.00 1.00
Project Management 4.88 4.88 0.00 0.00 0.00
General Project Management 0.00 0.00
Modification/Change Management 0.88 0.88
Leads Management 4.00 4.00
PUT 4.30 4.30 0.00 0.00 0.0
Skillset 1 (e.g. Genius) 3.55 3.55
Skillset 2 (e.g. GWS) 0.00 0.00
Skillset 3 (e.g. IRIS) 0.00 0.00
Skillset 4 (e.g. Brokasure) 0.00 0.00
Skillset 5 0.00 0.00
Skillset 6 0.00 0.00
Integration PUT 0.00
Conversion PUT 0.00
PUT Rework During Testing:
Skillset 1 (e.g. Genius) 0.75 0% 0.75
Skillset 2 (e.g. GWS) 0.00 0% 0.00
Skillset 3 (e.g. IRIS) 0.00 0% 0.00
Skillset 4 (e.g. Brokasure) 0.00 0% 0.00
Skillset 5 0.00 0% 0.00
Skillset 6 0.00 0% 0.00
Testing 1.21 1.21 0.00 0.00 0.00
Skillset 1 (e.g. Genius) 1.21 0% 1.21
Skillset 2 (e.g. GWS) 0.00 0% 0.00
Skillset 3 (e.g. IRIS) 0.00 0% 0.00
Skillset 4 (e.g. Brokasure) 0.00 0% 0.00
Skillset 5 0.00 0% 0.00
Skillset 6 0.00 0% 0.00
Solution System Testing 0.00
Mods Regression Testing 0.00 0% 0.00
FFP Evaluation 0.00
Business Readiness 0.00 0.00 0.00 0.00 0.00
Deploy Package Software 0.00
Xchanging Test Environment Preparation 0.00
Customer Environment Preparation (Test, UAT, Production) 0.00
Installation and Configuration (Test) 0.00
Installation and Configuration (UAT) 0.00
Installation and Configuration (Production) 0.00
Data Conversion (Test) 0.00
Environment Testing 0.00
User/Admin Documentation 0.00
User Training 0.00
Admin Training 0.00
Solution Governance Training 0.00
Change Management 0.00
UAT 0.00 0.00 0.00 0.00 0.00
Promote to UAT Environment 0.00
Data Conversion (UAT) 0.00
Environment Testing 0.00
User Acceptance Testing 0.00
User Acceptance Support 0.00
Go Live 0.00 0.00 0.00 0.00 0.00
Promotion to Production Environment 0.00
Data Conversion (Production) 0.00
Post Go Live 0.00 0.00 0.00 0.00 0.00
Post Go Live Support 0.00
Transition to Production 0.00
Project Expenses 0.00 0.00 0.00
Combined Expenses totals 0.00 0.00 0.00
Total 11.39 11.39 Totals 0.00 Totals 0.00 Totals 0.00
Currency e.g. GBP Currency e.g. GBP Currency e.g. GBP
WARNING - Project Duration is set to zero - correct this on P&PM sheetDAYS COST
ETC Total 11.39 ECC Total 0.0
Guidelines
Degree of Confidence
Level of Additional
Contingency
Total Days Estimated plus
Add'l Contingency
Xchanging Internal – strictly internal use onlyNote: These are day ratesRole Cost Sell Alternate Rate NB: These are not real rates andIndia T1 500 1000 600 need changing in order to generateIndia T2 500 1000 600 accurate costs.India T3 500 1000 600
India T4 500 1000 600
India T5 500 1000 600
India T6 500 1000 600
India T7 500 1000 600
India T8 500 1000 600
KL T1 500 1000 600
KL T2 500 1000 600
KL T3 500 1000 600
KL T4 500 1000 600
KL T5 500 1000 600
KL T6 500 1000 600
KL T7 500 1000 600
KL T8 500 1000 600
UK T1 500 1000 600
UK T2 500 1000 600
UK T3 500 1000 600
UK T4 500 1000 600
UK T5 500 1000 600
UK T6 500 1000 600
UK T7 500 1000 600
UK T8 500 1000 600
US T1 500 1000 600
US T2 500 1000 600
US T3 500 1000 600
US T4 500 1000 600
US T5 500 1000 600
US T6 500 1000 600
US T7 500 1000 600
US T8 500 1000 600
Guidelines
Xchanging Internal – strictly internal use only
E3 Estimation ModelModification: C9737 Improve Wording Search F
Estimated Cost: - Alternate rates not usedAlternate rates not used
Estimated Revenue: - Alternate Rates used as Cost RatesAlternate Rates used as Sell Rates
Margin 0.00%
#VALUE!#VALUE!
Guidelines
document.xls Page 23
Xchanging Internal – strictly internal use only
Previous Phase Actuals
Task Actual Cost
Programme Management 0.00 0.00
Programme Management
Project Management 0.00 0.00
Project Management
Analysis 0.00 0.00
Total Time Spent on E1 Estimate
Functional Design 0.00 0.00
Functional Design
Total Time Spent on E2 Estimate
Technical Design 0.00 0.00
Technical Design
Total Time Spent on E3 Estimate
PUT 0.00 0.00
PUT
Conversion PUT
Test Design 0.00 0.00
Define Test Strategy
Test Case Design
Testing 0.00 0.00
Testing
Solution System Testing
Mods Regression Testing
FFP Evaluation
Business Readiness 0.00 0.00
Deploy Package Software
Xchanging Test Environment Preparation
Customer Environment Preparation (Test, UAT, Production)
Installation and Configuration (Test)
Installation and Configuration (UAT)
Installation and Configuration (Production)
Data Conversion (Test)
Environment Testing
User/Admin Documentation
User Training
Admin Training
Solution Governance Training
Change Management
UAT 0.00 0.00
UAT Tasks
Go Live 0.00 0.00
Promotion to Production Environment
Data Conversion (Production)
Post Go Live 0.00 0.00
Post Go Live Support
Transition to Production
Totals 0.00 0.00
Currency e.g. GBP
Guidelines
Actual Time Spent (days)
Calculated Rate
GUIDELINES
TITLE PAGEREVIEWMODS TABSP&PMEXPENSESSUMMARYROLE RATESMARGINACTUALS
Expand the section you are interested in and when finished press the <Alt> + ç (left arrow) button to return to the sheet you were on.