Forecast Revenue

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