Retainage Calculations
This equation shows how the system calculated the percent complete:
(Net Amount) ÷ (Schedule of Values) = (Percent Complete) |
---|
7,200.00 ÷ 12,000.00= .6 |
This equation shows how the system calculated the retainage amount:
(Schedule of Values) × (Retainage Completion) × (Retainage Percentage) = (Retainage Amount) |
---|
12,000.00 × .30 × .10 = 360.00 |
This table shows how the system calculated the retainage for each billing line:
Billing Line |
((Net Amount) + (Markup)) ÷ ((Total Net Amount) + (Markup)) × (Total Retainage Amount) = (Billing Line Retainage Amount) |
---|---|
001 |
(1,200.00 + 25.00) ÷ (7,200.00 + 25.00) × 360 = 61.04 |
002 |
(6,000.00 + 00.00) ÷ (7,200.00 + 25.00) × 360 = 298.96 |
This table shows how the system calculated the discount for each billing line:
Billing Line |
((Cost Amount) + (Markup) - (Retainage)) × (Discount Percent) = (Discount Amount) |
---|---|
001 |
(1,200.00 + 25.00 - 67.27) × .01 = 11.64 |
002 |
(6,000.00 + 00.00 - 329.48) × .01 = 57.01 |