Agronomy - Estimate profit within Plan
Agronomy - Estimate profit within Plan (-000014)
Template Estimate total cost within Plan is defined as -000014.
As Measures are defined:
- Estimate Cost Total - the SUM of all costs ( task + material + fuel)
- Estimate Profitt per Ha (as AVG) - average profit per ha
- Estimate Profit per Kg (as AVG) - average profit per kg
- Estimate Profit Total ( as AVG) - the profit that we estimate from planned order
- Possible Revenue (as AVG) - the revenue that we expect on the basis of planning
- Market price ( as AVG) - the sale price of produkt ( this data is known)
All other parameters are set as Dimensions.
This Ad-hoc show as cost that we estimated the profit on Plan . That are not necessary the equal to realization.
| Module |
Type of Module ( CROP, FRUIT, GRASS , GARPE) |
| EM |
Expert model |
| EM Version |
Version of expert model |
| EM Name |
Name of expert model |
| Crop Type |
Crop type can be main or catch |
| CA |
Crop area - name |
| CA size |
Crop area - size |
| Plan Key |
Number of plan |
| Plan Name |
Name of the Plan |
| Plan Start Year |
The date when the plan has started |
| Plan End Year |
The date when the plan has end |
| Plan Start Year Month |
The year and the month when plan has started |
| Plan Duration Months |
The durations of plan |
| Plan Plant Start |
The date when plan Plant Started |
| Plan Status |
The plan can have statuses Open, Finished and Crop Rotation |
| Expected Yield Total |
Expected yield on the size of CA |
| Expected Yield Ha |
Expected yield on hectar |
| Task Cost Total |
The total cost of the task |
| Task Cost Total per Ha |
The cost of task per hectar |
| Cost Material |
The cost of all material |
| Plan Material Qty per Ha |
The amount of material per hectare |
| Plan Material Qty Total |
The amount of material per size of CA |
| Cost Fuel |
The cost of all Fuels |
| UM |
Unit of measure for crop |
| Est Cost Total |
The SUM of all costs ( task + material + fuel) |
| (AVG) Est Profit per Ha |
Average profit per ha |
| (AVG) Est Profit per Kg |
Average profit per kg |
| (AVG) Est Profit Total |
Estimate profit that we expect on planned order |
| (AVG) Possible Revenue |
Revenu that we expect on planned order |
| (AVG) Market Price |
The price of the product at the time of sale |
Calculation
Task price: The price of task is in Settings - Items
Material and Fuel Price: The price of task is in Settings - Items
Market price: The price of task is in Settings - Items
Task Cost Total = Task Price X CA Size X Task Durations per ha
Task Cost Total ha = Task price X Task duration per ha
Cost Materila = Material Price X Plan Qty on tab Material on Plan ( fuel is exempt)
Cost Fuel = Fule Price X Plan Qty on tab Material on Plan ( material is exempt)
Est Cost Total = Task Cost Total + Cost Materila + Cost Fuel
(AVG) Est Profit per Ha = Est Profit Total / Ca size
(AVG) Est Profit per Kg = Est Profit Total / Expected Yield Total
(AVG) Est Profit Total = Possible revenue - Est Cost Total
(AVG) Est Possible Revenue = Expected Yield Total X Market price
Market Price = the data is known from Item (sale price)