Net Price: How Extrapolation Works
This article shows users how extrapolation works in Net Price in Enji to provide clarity on project costs for a given period.
The Net Price is the project cost (for a given period) in the Margin by project report. It is either calculated from input data for the period or extrapolated from the employee's most recent internal rate (Internal Cost or Internal Rate) if no data has been entered for the current period.
Net price formulas
| Case | Formula | Comment |
|---|---|---|
| Net cost exists for the current period | Current net price = Logged hours in project/Total logged hours * Net cost | Data is taken from the current period |
| Net cost is missing for the current period | Extrapolated net price = Logged hours in project * internal cost Internal_сost = Net cost / Total logged hours | Hours from the current period are multiplied by the internal cost. Hours and net cost, for calculating internal cost, are taken from the most recent period with net cost data |
| Net cost is missing entirely | Extrapolated net price (2) = Logged hours in project * Internal rate | Internal rate is taken from Rates -> Project Rates |
- Internal rate = internal cost, but the difference is:
- Internal rate – is manually entered on Rates -> Project rates
- Internal cost – is calculated as Net cost / Total logged hours
When a user clicks on the Net Price value in the table, a detailed report on the project's cost for the period will open.
In the screenshot, users can see where the Net Price was extrapolated using Internal Cost and where using Internal Rate. "No Data" indicates that there is no rate data for the employee, but there are logged hours in the project.
