View source for Template:EstimateCostDetails2019

<noinclude>
Usage:

<nowiki>
{{EstimateCostDetails</nowiki><br />
|Client=Client for estimate rates. Required if an estimate section is to be produced.<br />
|Year=Year for estimate rates. Required if an estimate section is to be produced.<br />
|REQ=Requirements Time. Defaults to zero.<br />
|EST=Estimate Time. Defaults to zero.<br />
|FS=Functional Specification Time. Defaults to zero.<br />
|TS=Technical Specification Time. Defaults to zero.<br />
|DEV=Development Time. Defaults to zero.<br />
|ST=Testing Time. Defaults to zero.<br />
|IMP=Implementation Time. Defaults to zero.<br />
|PM=Project Management Time. If omitted, line is not shown on estimate.<br />
|FSEST=Y if this estimate is for production in a functional specification. Omit if no separate estimate and functional specification sections are required. If the values in the estimate differ from the functional specification, use the fields EREQ, EEST, EFS, ETS, EDEV, ESTT, EIMP and EPM to identify the Estimate values. If these are omitted, the Functional Specification values in fields REQ, EST, FS, TS, DEV, ST, IMP and PM will be used.<br />
|EREQ=Estimate Requirements Time. Defaults to the value specified in REQ if omitted.<br />
|EEST=Estimate Estimate Time. Defaults to the value specified in EST if omitted.<br />
|EFS=Estimate Functional Specification Time. Defaults to the value specified in FS if omitted.<br />
|ETS=Estimate Technical Specification Time. Defaults to the value specified in TS if omitted.<br />
|EDEV=Estimate Development Time. Defaults to the value specified in DEV if omitted.<br />
|ESTT=Estimate Testing Time. Defaults to the value specified in ST if omitted.<br />
|EIMP=Estimate Implementation Time. Defaults to the value specified in IMP if omitted.<br />
|EPM=Estimate Project Management Time. Defaults to the value specified in PM if omitted.<br />
|FOC=Free of Charge - set this to Y to ensure no cost is associated. Defaults to N.<br />
|FIXEDCOST=Fixed Cost - set this to a value to ensure only this cost is associated.<br />
|NOFOOTER=Remove the footer - if omitted, will always be present<br />
|DiscountPerc=Discount Percentage<br />
|DiscountText=Text if discount percentage is non-0<br />
}}
</nowiki>



{{note}} If on a separate page Ensure that you include the relevant Category tag at the bottom of the page.

{{note}} Costs should be numeric. If one is not included, it will default to zero (0).

{{note|This page should be kept up-to-date with the latest cost changes for all clients, otherwise the costs will default to zero (0)}}

</noinclude>
{{#vardefine:TitleRate|Rate per Day (£)}}{{#vardefine:TitleCost|Cost (£ Exc. VAT)}}{{#vardefine:Currency|£}}
{{#ifeq:{{{Client}}}|DELG|
    {{#vardefine:CostREQ|850}}
    {{#vardefine:CostEST|850}}
    {{#vardefine:CostFS|850}}
    {{#vardefine:CostTS|850}}
    {{#vardefine:CostDEV|850}}
    {{#vardefine:CostST|850}}
    {{#vardefine:CostIMP|850}}
    {{#vardefine:CostPM|850}}
|
{{#ifeq:{{{Client}}}|RJH|
    {{#vardefine:CostREQ|850}}
    {{#vardefine:CostEST|850}}
    {{#vardefine:CostFS|850}}
    {{#vardefine:CostTS|850}}
    {{#vardefine:CostDEV|850}}
    {{#vardefine:CostST|850}}
    {{#vardefine:CostIMP|850}}
    {{#vardefine:CostPM|850}}
|
{{#ifeq:{{{Client}}}|RMS|
    {{#vardefine:CostREQ|850}}
    {{#vardefine:CostEST|850}}
    {{#vardefine:CostFS|850}}
    {{#vardefine:CostTS|850}}
    {{#vardefine:CostDEV|850}}
    {{#vardefine:CostST|850}}
    {{#vardefine:CostIMP|850}}
    {{#vardefine:CostPM|850}}
|
{{#ifeq:{{{Client}}}|MASH|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|GFG|
    {{#vardefine:CostREQ|850}}
    {{#vardefine:CostEST|850}}
    {{#vardefine:CostFS|850}}
    {{#vardefine:CostTS|850}}
    {{#vardefine:CostDEV|850}}
    {{#vardefine:CostST|850}}
    {{#vardefine:CostIMP|850}}
    {{#vardefine:CostPM|850}}
|
{{#ifeq:{{{Client}}}|TDL|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|EBB|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|JBG|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|CRO|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|MARS|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|ZEN|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|GK|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|DHLT|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|720}}
    {{#vardefine:CostST|720}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|760}}
|
{{#ifeq:{{{Client}}}|HEW|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|750}}
    {{#vardefine:CostST|750}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|750}}
|
{{#ifeq:{{{Client}}}|EXL|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|720}}
    {{#vardefine:CostST|720}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|760}}
|
{{#ifeq:{{{Client}}}|DHL|
    {{#vardefine:CostREQ|750}}
    {{#vardefine:CostEST|750}}
    {{#vardefine:CostFS|750}}
    {{#vardefine:CostTS|750}}
    {{#vardefine:CostDEV|720}}
    {{#vardefine:CostST|720}}
    {{#vardefine:CostIMP|750}}
    {{#vardefine:CostPM|760}}
|
{{#ifeq:{{{Client}}}|CERT|
    {{#vardefine:CostREQ|600}}
    {{#vardefine:CostEST|600}}
    {{#vardefine:CostFS|600}}
    {{#vardefine:CostTS|600}}
    {{#vardefine:CostDEV|600}}
    {{#vardefine:CostST|600}}
    {{#vardefine:CostIMP|600}}
    {{#vardefine:CostPM|600}}
|
{{#ifeq:{{{Client}}}|PROD|
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
    {{#vardefine:CostPM|0}}
|
{{#ifeq:{{{Client}}}|LFS|
    {{#vardefine:CostREQ|600}}
    {{#vardefine:CostEST|600}}
    {{#vardefine:CostFS|600}}
    {{#vardefine:CostTS|600}}
    {{#vardefine:CostDEV|600}}
    {{#vardefine:CostST|600}}
    {{#vardefine:CostIMP|600}}
    {{#vardefine:CostPM|600}}
|
{{#ifeq:{{{Client}}}|PART|
    {{#vardefine:CostREQ|650}}
    {{#vardefine:CostEST|650}}
    {{#vardefine:CostFS|650}}
    {{#vardefine:CostTS|650}}
    {{#vardefine:CostDEV|650}}
    {{#vardefine:CostST|650}}
    {{#vardefine:CostIMP|650}}
    {{#vardefine:CostPM|650}}
|
{{#ifeq:{{{Client}}}|LANE|
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
    {{#vardefine:CostPM|0}}
|
{{#ifeq:{{{Client}}}|NHS|
    {{#vardefine:CostCON|900}}
    {{#vardefine:CostREQ|800}}
    {{#vardefine:CostEST|800}}
    {{#vardefine:CostFS|800}}
    {{#vardefine:CostTS|800}}
    {{#vardefine:CostDEV|700}}
    {{#vardefine:CostST|650}}
    {{#vardefine:CostIMP|800}}
    {{#vardefine:CostPM|850}}
|
<!-- Default charges for 2019 for no client -->
    {{#vardefine:Message|Unknown costs for client/year ({{{Client|No client}}}/{{{Year|No year}}})}}
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
    {{#vardefine:CostPM|0}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
}}
{{#ifeq:{{{#var:COSTEST}}}||
<!-- Default charges for no matching year -->
    {{#vardefine:Message|Unknown costs for client/year ({{{Client|No client}}}/{{{Year|No year}}})}}
}}{{#ifeq:{{{FOC|N}}}|Y|
    {{#vardefine:Message| }}
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
    {{#vardefine:CostPM|0}}
}}{{#if: {{#var:Message}} |{{warning|{{#var:Message}}}} | }}
<table class="wikitable" border="1px" width="100%">
<tr><td bgcolor="silver" colspan={{#ifeq:{{{FSEST}}}|Y|5|4}}>'''Cost Details'''</td></tr>
<tr>
<td bgcolor="silver">'''Activity'''</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">'''Estimate<br />No. of Days'''</td>|}}
<td bgcolor="silver" align="center">'''No. of Days'''</td>
<td bgcolor="silver" align="center">'''{{#var:TitleRate}}'''</td>
<td bgcolor="silver" align="center">'''{{#var:TitleCost}}'''</td>
</tr>
<tr>
<td bgcolor="silver">Requirements</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EREQ|{{{REQ}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{REQ|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostREQ}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{REQ|0}}}*{{#var:CostREQ}} }} |2 }}</td>
</tr>
<tr>
<td bgcolor="silver">Change Request Evaluation</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EEST|{{{EST}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{EST|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostEST}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{EST|0}}}*{{#var:CostEST}} }} |2 }}</td>
</tr>
<tr>
<td bgcolor="silver">Functional Specification</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EFS|{{{FS}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{FS|0}}} |2}}</td>
<td bgcolor="silver" align="center">{{#var:CostFS}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{FS|0}}}*{{#var:CostFS}} }} |2 }}</td>
</tr>
<tr>
<td bgcolor="silver">Technical Specification</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{ETS|{{{TS}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{TS|0}}}|2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostTS}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{TS|0}}}*{{#var:CostTS}} }} |2 }}</td>
</tr>
<tr>
<td bgcolor="silver">Development</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EDEV|{{{DEV}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{DEV|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostDEV}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{DEV|0}}}*{{#var:CostDEV}} }} |2 }}</td>
</tr>
<tr>
<td bgcolor="silver">Testing and Release</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{ESTT|{{{ST}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{ST|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostST}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{ST|0}}}*{{#var:CostST}} }} |2}}</td>
</tr>
<tr>
<td bgcolor="silver">Implementation</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EIMP|{{{IMP}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{IMP|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostIMP}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{IMP|0}}}*{{#var:CostIMP}} }}|2 }}</td>
</tr>
{{#ifeq:{{{PM|X}}}|X||<tr>
<td bgcolor="silver">Project Management</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EPM|{{{PM|0}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{PM|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostPM}}</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: {{{PM|0}}}*{{#var:CostPM}} }}|2 }}</td>
</tr>}}
<tr><td align="right" colspan={{#ifeq:{{{FSEST}}}|Y|5|4}}>{{#ifeq:{{{DiscountPerc|0}}}|0|&nbsp;|<font color="red"><strong>{{{DiscountText}}} {{{DiscountPerc}}}%</strong></font>}}</td></tr>
<tr>
{{#ifeq:{{{FIXEDCOST|N}}}|N|
<td bgcolor="silver">'''TOTAL'''</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{#expr: {{{EREQ|{{{REQ}}}}}}+{{{EEST|{{{EST}}}}}}+{{{EFS|{{{FS}}}}}}+{{{ETS|{{{TS}}}}}}+{{{EDEV|{{{DEV}}}}}}+{{{ESTT|{{{ST}}}}}}+{{{EIMP|{{{IMP}}}}}}+{{{EPM|{{#ifeq:{{{PM|X}}}|X|0|{{{PM|0}}}}}}}} }} |2 }}</td>|}}
<td align="center">{{#number_format: {{#expr: {{{REQ|0}}}+{{{EST|0}}}+{{{FS|0}}}+{{{TS|0}}}+{{{DEV|0}}}+{{{ST|0}}}+{{{IMP|0}}}+{{#ifeq:{{{PM|X}}}|X|0|{{{PM|0}}}}} }} |2 }}</td>
<td bgcolor="silver">&nbsp;</td>
<td align="right">{{#var:Currency}}{{#number_format: {{#expr: (({{{REQ|0}}}* {{#var:CostREQ}})+({{{EST|0}}}* {{#var:CostEST}})+({{{FS|0}}}* {{#var:CostFS}})+({{{TS|0}}}* {{#var:CostTS}})+({{{DEV|0}}}* {{#var:CostDEV}})+({{{ST|0}}}* {{#var:CostST}})+({{{IMP|0}}}* {{#var:CostIMP}})+({{#ifeq:{{{PM|X}}}|X|0|{{{PM|0}}}}}* {{#var:CostPM}})) * ((100 - {{{DiscountPerc|0}}}) / 100) }} |2 }}</td>
|<td bgcolor="silver">'''TOTAL (FIXED COST)'''</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{#expr: {{{EREQ|{{{REQ}}}}}}+{{{EEST|{{{EST}}}}}}+{{{EFS|{{{FS}}}}}}+{{{ETS|{{{TS}}}}}}+{{{EDEV|{{{DEV}}}}}}+{{{ESTT|{{{ST}}}}}}+{{{EIMP|{{{IMP}}}}}}+{{{EPM|{{#ifeq:{{{PM|X}}}|X|0|{{{PM|0}}}}}}}} }} |2 }}</td>|}}
<td align="center">{{#number_format: {{#expr: {{{REQ|0}}}+{{{EST|0}}}+{{{FS|0}}}+{{{TS|0}}}+{{{DEV|0}}}+{{{ST|0}}}+{{{IMP|0}}}+{{#ifeq:{{{PM|X}}}|X|0|{{{PM|0}}}}} }} |2 }}</td>
<td bgcolor="silver">&nbsp;</td>
<td align="right">{{#var:Currency}}{{#number_format:{{{FIXEDCOST}}} |2}}</td>
}}
</tr>
</table>
{{#ifeq:{{{NOFOOTER|N}}}|N|<table width="100%"><tr><td align="center">'''Estimate excludes training, release to live and go live support.'''</td></tr></table>}}
<noinclude>
[[Category:Templates|{{PAGENAME}}]]
</noinclude>