Forecast Revenue Accrual |
|
|
|
|
|---|---|---|---|---|
|
|
|
|
|
Screen Label |
|
Sample Values |
|
Mouseover text |
Budgeted Revenue |
|
12000 |
|
Revenue Budget from Budget Lines (local Currency) |
Budgeted Cost |
|
10000 |
|
Cost Budget from Budget Lines |
Budgeted Profit |
|
2000 |
|
Budgeted Revenue - Budgeted Cost |
Forecast Final Cost |
|
11500 |
|
|
Forecast Profit |
|
500 |
|
Budgeted Revenue - Forecast Final Cost |
Forecast Profit Markup % on Cost |
4.35% |
|
|
Forecast Profit / Forecast Final Cost as percentage |
Forecast Profit Margin % on Sales |
4.17% |
|
|
Forecast Profit / Budgeted Revenue as percentage |
|
|
|
|
|
Time Costs |
|
500 |
|
Cost of all Time Activity transactions to current Year/Period |
Other Costs |
|
1000 |
|
Cost of all Non Time Activity transactions current Year/Period |
PO Accrual at Cost |
|
200 |
|
PO Accruals for current Year/Period from PO Accruals table (If used. If PO Accrual used then AP Voucher Accruals is not used) |
AP Voucher Accrual at Cost |
|
|
|
AP Voucher Accruals for current Year/Period from PO Accruals table (If used. If AP Voucher Accrual used then PO Accruals is not used) |
Total Cost to Date |
|
1700 |
|
Time Cost + Other Costs + PO or AP Voucher Accruals at Cost |
Costs to Complete |
|
9800 |
|
Forecast Final Cost - Total Cost to Date |
Forecast Final Cost |
|
11500 |
|
Forecast Final Cost from Period Forecast |
|
|
|
|
|
Actual % Complete on Forecast Final Cost |
15% |
|
|
Total Cost to Date / Forecast Final Cost as pecentage |
|
|
|
|
|
Earned Revenue on Actual % Complete |
|
1774 |
|
Actual % Complete on Forecast Final Cost * Budgeted Revenue to max of Budget Rev |
|
|
|
|
|
Earned Profit |
|
74 |
|
Earned Revenue on Actual % Complete - Total Cost to Date |
|
|
|
|
|
Profit Threshold |
10% |
0 |
|
Take no profit if Actual % Complete on ForecastFinalCost < Profit Threshold % . Calculation is Total Cost to Date if Adjusted % Complete on Cost < Profit Threshold % (from Charge Type Threshold Revenue % value ) else Null |
|
|
|
|
|
Profit Retention |
10% |
-7 |
|
Percent of Budgeted Profit to be retained. Auto calculated from Charge Type Profit Retention % value. Always negative. Calculation is Profit Retention % * (Earned Profit + Profit Threshold). Values are Read Only |
Profit to Take |
|
67 |
|
Earned Profit + Profit Threshold + Profit Retention |
|
|
|
|
|
Declared Revenue |
|
1767 |
|
Cost to Date + Profit to Take |
|
|
|
|
|
Revenue Adjustment - General |
|
100 |
|
Manually entered Revenue adjustment |
|
|
|
|
|
Adjusted Revenue |
|
1867 |
|
Declared Revenue + Revenue Adjustment |
|
|
|
|
|
Actual Invoicing |
|
2500 |
|
Invoicing up to and including current period before tax and before retentions |
|
|
|
|
|
WIP Revenue Accrual |
|
-633 |
|
Adjusted Revenue - Actual Invoicing |
|
|
|
|
|
Profit Taken to Date |
|
67 |
|
Adjusted Revenue - Total Cost to Date |
|
|
|
|
|
Loss Provision |
|
0 |
|
If Budgeted Profit is negative then Budgeted Profit else Null. Can be manually adjusted |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|