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 |
...