...
Forecast Revenue Accrual
...
...
...
...
...
...
...
...
...
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 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|