About distributing based on costs
This method allows you to calculate direct personnel expense (DPE) and overhead costs based on direct labor costs from your Expense and Other Income accounts for a more precise calculation than the fixed-percentages method.
Because costs vary over time, Ajera temporarily uses fixed percentages to represent DPE and overhead costs on project reports.
Ajera replaces the fixed-percentage amounts with the cost-based amounts when you distribute DPE/overhead costs.
DPE
When you distribute DPE based on costs, Ajera performs the following calculations.
Calculating DPE percent |
For each project transaction that occurs during the date range specified in the Distribute DPE/Overhead window, it:
This determines the percentage of the total cost for which the transaction is responsible.
This determines the DPE cost for the transaction.
This determines the DPE percent of the transaction. For example, if the cost of one project transaction is $60, and the cost of all the transactions is $220, the transaction is responsible for this percentage of the total cost: $60 / $220 = 27.27% If the DPE cost for all general ledger entries is $75, then the DPE cost for the one transaction is: $75 x 27.27% = $20.45 The DPE percent of the $60 transaction cost is: $20.45 / $60 = 34.09% |
Calculating project cost with DPE |
The DPE amount added to your project labor cost is calculated as follows: (Cost Amount x DPE Percent) + Cost Amount For example, if the cost is $60 and DPE percent is 34.09%, then: ($60 x 34.09%) + $60 = $80.45 |
Overhead
When you distribute overhead based on costs, Ajera performs similar calculations.
Calculating overhead percent |
For each project transaction that occurs during the date range specified in the Distribute DPE/Overhead window, it:
This determines the percentage of the total cost for which the transaction is responsible.
This determines the overhead cost for the transaction.
This determines the overhead percent of the transaction. For example, if the cost of one project transaction is $60, and the cost of all the transactions is $220, the transaction is responsible for this percentage of the total cost: $60 / $220 = 27.27% If the overhead cost for all the general ledger entries is $350, then the overhead cost for the one transaction is: 27.27% x $350 = $94.45 The overhead percent for the $60 transaction is: $94.45 / $60 = 159.09% |
||||
Calculating project cost with overhead |
The overhead amount added to your project labor cost is calculated as follows: (Cost Amount x Overhead Percent) + Cost Amount For example, if the cost is $60 and overhead percent is 159.08%, then: ($60 x 159.09%) + $60 = $155.45 |
||||
Calculating burdened cost |
Burdened project cost is calculated as follows:
For example, if the cost amount is $60, the DPE amount is $20.45, and the overhead amount is $127.98, then burdened project cost is: $60 + $20.45 + $127.98 = $208.43
For example, if the cost amount is $60, the DPE amount is $20.45, and the overhead amount is $95.45, then burdened project cost is : $60 + $20 + $95.45 = $175.45
|