Forum Discussion
Help with a 'complicated' measure
HI, timknox
This link works, and the same point confused.
EXAMPLE FOR CONTRACT ITEM 1.1 - 20% that was withheld on 1/11/18; 10% was paid on 1/12/18 and 10% was paid on 1/1/19
EXAMPLE FOR CONTRACT ITEM 1.1 - 30% that was withheld on 1/12/18; 30% was paid on 1/1/19
EXAMPLE FOR CONTRACT ITEM 1.2 - 20% that was withheld on 1/10/18; 20% was paid on 1/12/18
For example
Do you mean it is based on the Percentage Cost Withold (Paid) table,
But why 1.3 has no data, and for 1.1 TOTAL Paid in 1/1/2019 is should 222+23.3+136.8-0=382.1
and 1.2 TOTAL Paid in 1/1/2019 is should 273.95, why it needs to add 136.80?
Best Regards,
Lin
hi Lin,
I am sorry i am not explaining it clearly, but thank you for your help.
So the underlying cost data is contained in the Excel file tblFOO. This show in the [col Total Cost] what should be paid for each [Contract Item] on the [Date].
However, due to contract reasons, a % is sometimes withheld until some work is completed.
This is measured as a % of the original [col Total Cost].
This is demonstrated in the sheet [Percentage Cost Withhold]. NOTE: we do not withhold for every payment or contract item.
So as an example, with Contract Item 1.1, on the 1st Nov 2018 we have decided to withhold 20% of the [col Total Cost] until work is completed. This value is 20% of 233.00 (46.60). So on the 1/11/18 we actually pay only 186.400 (233.00 - 46.60).
Then, using [Percentage Cost Withold (Paid)] you will see that on the 1st Dec 2018 they had completed some of the work, and they were claiming half of the 20% withheld (shown as 10% in the table).
So on 1/12/2018 we will then pay half of the value that was withheld in November - i.e. we pay 23.30 on the 1/12/18.
Similarly in January they claim the balance, so we pay the final 23.30 in January 2019.
Does that help?