Field Calculations

This table lists the calculations that the system uses to update fields in the detail area of the Community ProForma form:

Field

Calculation

Mix Base Price

Base Price à Plan Mix

Total Option Profit

Total Option Revenue − Total Option Cost − Option Incentive

Total Revenue

Base House Revenue + Lot Premium + Options + Other Revenue − Discounts and Incentives

Estimated Plan Profit

Total Revenue − Total Cost

ProForma Margin

(Total Revenue − Total Cost) / Total Revenue à 100

Mix Lot Premium

Average Lot Premium à Plan Mix

Mix Other Revenue 2

Other Revenue 2 Ã Plan Mix

Mix Other Revenue 3

Other Revenue 3 Ã Plan Mix

Mix Other Revenue 4

Other Revenue 4 Ã Plan Mix

Total Base Revenue

Mix Base Price + Mix Lot Premium + Mix Other Revenue 2 - 4

Total Option Revenue

Estimated Option Revenue 1 - 5 − Option Incentive

Mix Lot Cost

Land Per Lot Cost à Plan Mix

Option Cost 1 - 5

Option Revenue − (Option Revenue à Option Margin)

Total Option Cost

Total of Option Cost 1 - 5

Mix Cost - Indirect

Indirect Per Lot Cost à Plan Mix

Mix Cost - Selling

Sales and Marketing Per Lot Cost à Plan Mix

Mix Other Cost 4

Other Per Lot Cost à Plan Mix

Extended Other Cost 1 - 10

Override Percentage from the Override Percentage tab à Total Plan Mix Revenue

Total Other Cost

Total of Extended Other Costs and Average Other Costs

Estimated Plan Profit

Not applicable

Estimated Margin

Not applicable