Length : around 35 minutes
Using what you wrote in exercise 11 or the following correction modelEco_ParisBasin_technic.gms,
1) create an Excel file using the model data (yields, working time and costs)
2) import the data into your model
« A farmer in the Paris basin has a large-scale 100 ha farm. He can grow soft wheat (cleT), rapeseed, spring barley (orgeP) and winter barley (orgeH). For each crop, he can choose between three management systems :
- Intensive (written « intens ») : it is the most intensive system in terms of chemical inputs, with a “preventive” use of phytosanitary products.
- Sustainable (written « rais ») : it involves “sustainable” practices. ». Phytosanitary treatments are determined following the observation of diseases or pests in the plot. The quantities used are adapted to the situation.
- Integrated pest management ( written « protI ») : such practices integrate prophylactic agronomic measures which contribute to a decrease in the pressure caused by pests. They can involve considerations concerning sowing dates, variety choices, crop successions in a plot, etc…
The farmer knows the expected yields, the variable costs, and the working time required for each system and each crop.
He can work 2000 hours a year.
| Yields (q/ha) per crop and management system | |||
| aa Crop |
Management system | ||
| Intensive | Sustainable | Integrated pest management | |
| bleT | 72,8 | 71 | 65 |
| rapeseed | 31 | 29 | 26,3 |
| orgeP | 62,6 | 62 | 56 |
| orgeH | 71 | 70 | 64 |
| Working time (hours per ha) per crop and management system | |||
| aa Crop |
Management system | ||
| Intensive | Sustainable | Integrated pest management | |
| bleT | 3,2 | 3,1 | 3,1 |
| rapeseed | 4 | 3,6 | 4 |
| orgeP | 3,1 | 3,1 | 3,3 |
| orgeH | 3,3 | 3 | 3 |
| Total costs (€/ha) per crop and management system | |||
| aa Crop |
Management system | ||
| Intensive | Sustainable | Integrated pest management | |
| bleT | 652 | 611 | 534 |
| rapeseed | 724 | 635 | 576 |
| orgeP | 668 | 676 | 594 |
| orgeH | 746 | 680 | 587 |
The selling prices of the different crops are : 180€/t for soft wheat, 365€/t for rapeseed, 170€/t for spring barley and 155€/t for winter barley.
The objective of the farmer is to maximize his income. »
The data come from : Ecophyto R&D vers des systèmes de culture économes en produits phytosanitaires – Volet 1. Tome II : Analyse comparative de différents systèmes en grandes cultures. Janvier 2009. INRA et le ministère de l’écologie, de l’énergie, du développement durable et de l’aménagement du territoire.
Solution :
modelEco_dataParisBasin.xlsx
modelEco_ParisBasin_technic_excel.gms
