Lot Costing and Reports

Postings, which are executed against a Lot, are recorded in a sub-ledger called "Job Cost Ledger". To view the postings, from the Lot Card run the action "Job Cost Ledger Entries".  

This action opens the page "Job Cost Ledger Entries" which has two actions:

• Navigate
  • This action allows a user to view entries related to the Job Cost Ledger Entry in other ledgers.
• Reallocate to Lots
  • This action allows a user to reallocate (move) the cost of the current Job Ledger Entry to one or more Lots.

Using Reallocate to Lots Action

In the pop-up page select "Job Batch Name", enter "Posting Date" and "Reallocation Rule", select destination Lots and click "Re-allocate to Selected".

The "Reallocation Rule" has the following options:

• Evenly
  • The amount is distributed evenly between selected Lots.
• Per Sq. Footage
  • The amount is distributed between Lots proportionally to Lot square footage.
• Per Lot Offer Price
  • The amount is distributed between Lots proportionally to the Lot offer price.
• Manually
  • The lines that are created in the Job G/L Journal will have zero amounts. A user should manually enter amounts and balance the transaction.

As a result of the action "Re-allocation to Selected", the system will create Job Journal Lines for the destination Lots, balance Job Journal Lines for the source Lot, and post those lines. The amount in the source Job Cost Ledger Entry will be split between destination Lots uniformly (by equal parts). This posting will be reflected in the Job Cost Ledger Entries of the source Lot and the destination Lots.

Job Cost Ledger Entries of a Phase

To view Job Cost Ledger Entries for the whole Phase, search Phases, highlight a Phase, go to Related, and click "Job Cost Ledger Entries" in the page menu.

 

Budget By Lot

Search Phases, highlight a Phase, go to Actions, and select Budget by Lot Action. This page can also be called from "Search " or the Role Center.

The page "Budget by Lot" shows budget summary amounts for each Lot. It provides the ability to calculate amounts using filters by Cost Group, and Cost Detail, as well as to include or not include revenue.

Lot Cost Summary Report

The report shows Estimated, Planned, Budget, Actual (for the period), Actual (to date), and "To Complete" amounts for each Lot. You can open this report by searching Lot Cost Summary or in a Role Center.

The report has an Excel output for manual work.    

Phase Budget Report

The system provides the ability to run a budget report where the amounts for Cost Details are summarized for the whole Phase. To run this report, select a Phase and click Reports, then "Phase Budget Report" in the page menu.

• In the report options, enter the date interval and press "OK".