Use of a ‘glass-box’ computerized decision support tool (CDST) for the preparation of fertilizer recommendations in oil palm plantations
Thomas Fairhurst (Tropical Crop Consultants Limited), Max Kerstan and Nina Memenga (both Agrisoft Systems)
Fertilizer is the largest variable cost of production in oil palm cultivation. The preparation of fertilizer recommendations is a complex task that should make use of all agronomic data accumulated by a plantation company. The OMPTM agronomic database, now widely used in the oil palm industry, provides the means to store and analyze agronomic data for large-scale plantations. In this paper, we describe a computerized decision support tool (CDST) that provides agronomists with the means to interrogate all agronomic data (leaf and soil analysis, production, field conditions) stored in OMPTM using customized queries for the purpose of estimating nutrient requirements. The user can set up the CDST to determine the least costly source of mineral fertilizers and a fully-costed fertilizer program for each block within a plantation. The CDST provides transparency in terms of methodology, opportunities for peer review by company management and external consultants whilst securing the company’s agronomic intellectual property.
Download the full paper here.
Featured articles on current and upcoming projects
Preview: BMP Field Work Module
Besides ensuring that harvesting and fertilizer application is being carried out according to schedule, maintaining field upkeep standards is one of the most important tasks in the day-to-day work of plantation and field managers. Field work in this sense can encompass any number of different activities including for example manual or chemical weeding, pruning, drainage implementation or repairs, road repairs etc. While of course some particular tasks may only need to be carried out on demand or at irregular intervals, the majority of field upkeep tasks are typically carried out at regular intervals throughout the year. By setting up a good work plan at the beginning of the year, field managers will be able to ensure efficient distribution of labor and other material requirements, derive corresponding field work budgets and of course monitor and react whenever work is falling behind schedule. The aim of the new BMP Field Work module is to give plantation managers a powerful and flexible tool to generate field work schedules or budgets, record field work actuals and actual material and labor usage, and monitor and reconcile differences between the two. While the module will be implemented first in the context of BMP, we have designed it with the requirements of OMP in mind and are planning to transfer the module to OMP in the future.
Defining jobs and material requirements
The new module is based upon the concept of individual field work “jobs” corresponding to particular field work activities. Jobs in BMP can be defined with a short ID which can for example match a budget activity code as well as a longer, more descriptive job name. Furthermore jobs are grouped into categories and subcategories, as shown in figure 1. While users will be able to define jobs and subcategories according to their individual requirements, the main categories will be hard-coded by Agrisoft Systems to facilitate data analysis later on.
Each job can be furnished with a longer description of the precise task to be carried out, as well as a detailed specification of the materials, chemicals, equipment and labor to be used in the job. This specification includes not only a list of the materials to be used but also the desired application rate on a per ha basis, in order to be able to work out the overall material requirements from the field work budget. Specifically for chemicals, it will be possible to define a particular fraction of the block area to be treated in addition to the application rate. This feature is designed to ensure that users can enter the “real” spraying rate for activities like for example path weeding and still obtain a correct budget for the total herbicide requirements even though only a fraction of the block area is to be sprayed. Of course, all drop-down lists of materials, chemicals, equipment and labor categories will be fully customizable by the user. Specifically for chemicals there will be an additional layer of detail in that it will be possible to individually define active ingredients and products as well as their composition in terms of active ingredients.
Field work groups and job frequencies
Having defined a list of jobs, the next step is to work out the actual work schedule for each job, i.e. when it is to be carried out in which cableway or block. The first thing to specify for each job is the frequency, i.e. how many times a year the job is to be carried out. We anticipate that it may be necessary to have different job frequencies in different parts of the plantation. For example, it might be necessary to carry out drainage repairs more frequently in a swampy part of the plantation whereas a more hilly part of the plantation may need less drainage work but more work on activities like terracing. To handle this, it will be possible to define multiple “field work groups” in BMP and to assign cableways to different field work groups as required. Each such field work group should correspond to a family of cableways which are similar in their characteristics and have the same field upkeep requirements. The field group assignment screen, shown in figure 3, includes a helpful summary of the number of cableways and the total area that has been assigned to each group. Of course, it will be possible to copy the field work group assignment from previous budget years and to import this assignment from Excel spreadsheets.
Generating realistic work schedules
Having completed the definition of jobs and the field work group assignment, the next step is to specify the actual budget settings for each field group. The BMP field work budget generator wizard, pictured in figure 4, combines a continuous form where users can specify settings for each job with a visual calendar representation of the work schedule. This visual representation is extremely useful to get an idea of whether the schedule will lead to a relatively even distribution of work throughout the year. While figure 3 shows the budget defined in terms of weeks, it will also be possible to switch to fortnight- or month-based budgeting.
Figure 4 shows various other settings for each job in addition to the aforementioned job frequency. The round length simply specifies the number of weeks (or months/fortnights) in which the field work round should be finished, i.e. in which all cableways in the field work group should be tackled. This setting will be used by the wizard to work out the area which needs to be covered in each week. For example, in a job in which the round length is 6 weeks it will be necessary to cover approximately one sixth of the total area of the field work group in each week. Knowing how many hectares to cover each week is of course naturally leads to the question: in which order should the cableways be tackled? To allow users to specify an order which makes sense in terms of the geographical location of the cableways in the field, it is possible to assign a field work index to each cableway. This index is defined on the field work group definition screen shown in figure 3 and specifies the order in which cableways are to be tackled. Furthermore on the budget generator wizard it is possible to specify custom start cableways for each job, which is important to ensure that different jobs can easily be scheduled to fall into different weeks for a given cableway. For example, assume we have the jobs “pruning”, “drainage repairs” and “weeding” which are all to be carried out with the same frequency and the same round length. Clearly it would be undesirable to schedule all three jobs to be carried out in the same week in each cableway. By choosing suitable different starting cableways in each job it is easy to “stagger” the schedules in such a way that the 3 jobs are scheduled in successive weeks in any given cableway.
Manual budget edits and field work actuals
Although we are confident that the budget generation wizard described above will enable users to create very flexible and effective budgets using relatively few settings, it is of course possible that particular aspects of the budget will need to be tweaked even further. To do this, the BMP field work module will include a screen to manually edit the field work schedule, partially shown in figure 5. Here users will be able to individually enter or edit the area to cover in each week for every cableway and jobs.
Once the field work schedule has been defined using the tools described above, the details of the job specification will allow the program to calculate the required amounts of materials, chemicals, tools and labor for each cableway, week and job. Suitable data analysis forms and reports will be built into the program in order to be able to analyze and extract this information.
In addition to the field work budget, the new field work module will of course also be used to store records on the actual field work carried out and the materials used. The corresponding data entry form, shown in figure 6, allows users to define the area covered by job, day and cableway. Furthermore users will be able to enter the actual materials, chemicals, tools and labor used. To simplify data entry for this part, all materials, chemicals etc. that are part of the job definition will automatically be listed on the screen so that users only have to enter the amounts used. In addition, for additional flexibility it is possible to manually add records for additional or alternative materials that were used without being specified in the original job definition. Of course, it will also be possible to import all this data in the form of Excel spreadsheets.
While we have not yet started on designing the data analysis features for the field work module, it is clear that the data structure described above will allow for many exciting possibilities. For example, it will be possible to have analysis and comparison of material budgets and actuals at different time and spatial levels, reports highlighting situations where we are lagging behind schedule, GIS maps of cableways scheduled for work in the next weeks by job, and much more. We are looking forward to continuing the design and development of this new module and are confident that it will prove to be a very useful addition to both BMP and OMP in the future.
The OMP Ten Year Crop Budget
Access to accurate predictions or budgets of future production is extremely important for oil palm plantation companies. Short-term forecasts based on black bunch counts help companies to plan sales and arrange CPO transport and mill maintenance. Yearly crop budgets form an important component of the overall financial budget and help companies to plan labor allocation and timing of fertilizer application or other field work. However, beyond this also longer term crop budgets are highly important, for example to plan replanting dates, strategic sales contracts or construction of new palm oil mills.
While the first two aspects have been covered in the OMP-AMIS suite for a while with the OMP Crop Forecast and OMP Crop Budget add-ins, Agrisoft Systems now also offers a tool for the longterm budgets with the recent release of the OMP Ten Year Crop Budget (OMP-TYCB). OMP-TYCB was developed in close cooperation with our customers and has particular strengths in taking replanting plans into account.
The way in which OMP-TYCB generates crop budgets can be split into two distinct steps. In the first step, the program evaluates the predicted plantation age spread, i.e. the number of hectares per tree age and division, for each of the next ten years. In the second step, it uses user-defined yield profiles to estimate the yearly production and yield. The calculations in the first step are based on the “current” plantation age spread, i.e. the age spread in the year the budget is being generated. The program offers great flexibility both in setting up the initial plantation age profile and in entering and maintaining yield profiles and replanting plans. For further details please refer to the full length article in the 14th edition of the Agrisoft Systems Newsletter from June 2015.
OMP fertilizer planner module
Site-specific nutrient recommendations
Generating effective fertilizer recommendations is arguably the single most important task for an oil palm agronomist. This is because fertilizers form one of the biggest cost factors in an oil palm plantation, and at the same time nutrient deficiency is often the most important yield-inhibiting factor that can be affected by plantation managers.
It is clear that rough “blanket” approaches to fertilizer application, where the same fertilizer doses are applied to large portions of the plantation, are neither agronomically nor economically effective. On the other hand, every agronomist knows that generating site-specific detailed fertilizer recommendations is typically a difficult and time-consuming task. In many cases it is very important to take into account site-specific knowledge and personal experience from previous years when creating fertilizer recommendations. At the same time it is obvious that at least conceptually a block’s fertilizer requirements should be calculable from measurable parameters including site specific details like soil type and topography, environmental parameters and limitations as well as measurements of plant and soil nutrients. Various scientific studies over the years have uncovered statistically significant correlations that can be used to derive fertilizer requirement indicators, and I believe this type of scientific approach to fertilizer recommendations will only become more important in the future.
A data-driven approach to generating nutrition programmes
The key to generating block-specific fertilizer recommendations using a scientific approach as outlined above is of course the availability of the relevant background data. In this respect OMP users are at a unique advantage as the OMP database already includes a huge amount of information that can flow into the generation of fertilizer recommendations. The logical next step is therefore the inclusion of a tool into the OMP-AMIS software suite which can be used to generate fertilizer recommendations based on the available OMP data. In the shape of the OMP Fertilizer Planner, Agrisoft Systems have now begun developing exactly such a tool, which will be described in more detail in the following. In this development project we are collaborating closely with Tropical Crop Consultants Ltd., led by the well-known agronomist Dr. Thomas Fairhurst.
The OMP Fertilizer Planner Add-In will help users in creating planning fertilizer application in two largely distinct steps. In the first step, the application will generate nutrient recommendations for each block and nutrient using scientific criteria evaluated on the OMP agronomic data set. In the second step, the application will run an optimization routine to find the least costly combination of fertilizers that can be used to fulfill these nutrient recommendations. The program is explicitly designed to give users the option to work with and compare various different recommendation scenarios, making it possible to evaluate different options before deciding on the final fertilizer recommendation for the coming year.
Support for site-specific nutrient rules
Although some scientific relationships between plant tissue nutrient levels and potential yield response have recently emerged which seem to have quite broad applicability, these general rules must of course be supplemented with site-specific criteria to obtain truly realistic recommendations. To handle this, OMP Fertilizer Planner will give the user very extensive possibilities to edit and customize the assumptions and settings used in the generation of the nutrient and fertilizer recommendations. As a case in point, users will be able to define various possible doses for each relevant nutrient as well as a set of rules for when each dose should be applied. Sets of rules and doses can be saved for re-use in different scenarios, so that users will be able to quickly generate and compare several scenarios that have the same general underlying logic but differ slightly in the specific dosages and application rules. With regards to fertilizer recommendations, users will be able to enter location-specific information such as the fertilizer purchasing, transportation and application costs as well as various other settings including minimum amounts of fertilizer to apply and rounding of fertilizer doses.
Reviewing and editing recommendations
Owing to the enormous costs and importance associated with fertilizer applications, we strongly recommend that all recommendations generated by a computer algorithm should be reviewed and double-checked by agronomists before being applied in the field. Of course this applies also to the recommendations generated by the OMP Fertilizer Planner. To help with this, the program will include a variety of data analysis forms, reports and charts to show relevant information such as averaged nutrient and fertilizer recommendation rates by division, field, tree age etc. Based on this information, users should evaluate whether the current recommendations make sense or whether the assumptions used need to be reviewed and edited. Besides changing the underlying scenario assumptions, users will also have the option of manually editing recommendations for single blocks or groups of blocks, giving them full control over the resulting fertilizer recommendations.
In connection with the reviewing of recommendations mentioned above, it will be possible to flag blocks for particular attention depending on criteria defined by the user. This tool can be used to quickly highlight blocks which display certain characteristics that suggest that an agronomist should take a closer look before the program’s recommendations are blindly applied. Examples of such criteria could be wildly fluctuating yield gaps over the previous years, unrealistically high or low leaf nutrient levels, severe erosion scores or insufficient pruning.
We believe that with the features roughly outlined above the OMP Fertilizer Planner will prove to be a great addition to the OMP-AMIS software suite and will turn into an important tool for agronomists looking to generate effective site-specific nutrient and fertilizer recommendations.
Sneak preview: OMP-AMIS 8.8.01
Sneak preview of OMP-AMIS version 8.8.01
Despite the latest OMP-AMIS release lying just three months in the past, the Agrisoft programmers have been extremely busy and the next version of the program is nearing completion. As usual, the upcoming release will combine the addition of new program features with bug fixes and other small improvements. The present article outlines a selection of the most important changes you can look forward to in the new version, which will carry version number 8.8.01.
A long-running development project that is nearing completion concerns the development of a version of OMP-GIS compatible with ESRI ArcGIS. Together with the existing OMP-GIS application for MapInfo, this means that OMP’s thematic mapping features can be used with the two most widely-used GIS programs in the world. OMP-GIS for ArcGIS will include most of the main features familiar from the MapInfo version, including menu-driven thematic mapping, support for adding layers, exporting and printing of maps as well as multi-map layouts.
Rachis magnesium recording and improved data verification tools
Within the OMP-DBMS main program, we have aimed to round off the pest and disease reporting module introduced in version 8.7.03 by adding further relevant information to the data analysis forms and reports. With these additions, we feel that OMP’s pest and disease module is now ready to be an important tool both for yield gap analysis purposes and to investigate which planting materials and environmental conditions lead to blocks that are particularly vulnerable or resistant towards pest or disease attacks. In the OMP leaf analysis section we have added the possibility to record rachis magnesium levels, which have been recently shown to be highly relevant in the analysis of nutrient deficiencies and fertilizer recommendations. Rachis magnesium has also been added to the various leaf analysis forms, reports and charts.
In practice, data maintenance and data validity checks are amongst the most important tasks for OMP operators to regularly carry out, to help avoid incorrect management decisions being made due to wrong data recorded in OMP. To make this task easier, we have greatly expanded and improved the capabilities of the OMP Data Verification tool. With the new tool, users will be able to easily check for unrealistic or missing values of in various production-related quantities including yield, average bunch weight or harvester productivity. Besides production quantities the data verification tool also covers fertilizer application as well as various other block characteristics. Based on the criteria entered by the user, the data verification tool outputs an overview report showing which percentage of blocks fail which criteria as well as a detailed list of all blocks where data needs to be reviewed.
New weekly and fortnightly budget vs actual comparisons
The capabilities of the OMP Harvest Round Recording (HRR) Add-In, which is used for detailed production reporting, have been extended with the addition of a new class of reports showing a comparison of actual and budgeted production. The new reports are available at weekly, fortnightly, 4-weekly (periodical) or monthly aggregation level, and allow managers to get a detailed view of how well they are on the way to meeting their production targets.
The new version 8.8.01 will also see major improvements to the OMP-SIS Add-In, which focuses on the management of oil palm smallholder areas. The entire yield and production reporting section of the add-in has been re-coded to achieve a significant speed increase compared to the previous version of the program. Furthermore, budget vs actual reports similar to those now built into the OMP-HRR Add-In have also been added to SIS on a fortnightly and monthly level. These reports will give plantation managers a quick overview of whether the smallholder areas are producing as expected, and whether the yield reported on a fortnightly basis by each smallholder is realistic or whether further investigation is needed.
Smallholder fruit pickup schedule
Another new tool which we think will prove very helpful in the management of oil palm smallholder production is the new fruit pickup schedule module built into OMP-SIS. The revamped data entry system makes it easy to generate a pickup schedule based on an initial harvesting date and a planned harvest rotation length for each block in which public holidays and Sundays can be automatically excluded. It is possible at any time to reset the schedule for the coming months, for example if the pickup process has already fallen behind the schedule made at the beginning of the year and the manager wishes to restart the counting based on what the current harvesting dates are. The new features are complemented by a selection of data analysis forms and reports that allow managers to see how well the pickup schedule is being implemented. The screenshot below shows an example of such a report which displays information on which percentage of blocks is being picked up how many days late.
The possibility of filtering globally is one of the most powerful data analysis features OMP. This feature has now been added and adapted to the case of the OMP-SIS Add-In. In addition to some of the usual filter fields familiar from the OMP-DBMS main program such as Division, Field, Year, Soil class etc., the OMP-SIS filter allows users to filter for specific farmer ID’s or smallholder groups. These filtering features will greatly help in particular with data analysis of farmer questionnaires of smallholder block data. Finally, the data analysis forms and reports showing the area distribution of smallholder areas by tree age or planting year have been improved.
Rounded budgets and data importing for crop budget and forecast
A new feature in the OMP Crop Budget Add-In is the option to work with rounded monthly production values in the budget. This option is intended for users who prefer to work with budgets of a round number of tons per month rather than directly using the result of multiplying the budgeted yield with monthly percentage and block size. This method is advantageous if users wish to compare or cross-correlate the OMP results with other budget calculations carried out with round monthly production budgets e.g. in MS Excel.
OMP-AMIS version 8.8.01 will make it possible to import data from Excel format in the OMP Crop Budget and OMP Crop Forecast (Black Bunch Count) Add-In programs, where no importing was possible so far. This is particularly useful in the case of the black bunch count add-in, where census data from a large number of blocks has to be recorded every month or every few months at the latest. Finally, as usual the new release will include a number of smaller bug fixes and tweaks to improve the user experience.
Agrisoft Systems at IOPC 2014
In June you can find us at the International Oil Palm Conference 2014, held at the Bali Nusa Dua Convention Center on 17th to 19th June 2014 . More information on the event can be found under http://iopc2014.iopri.org/.
The quarterly Agrisoft Systems newsletter gives an overview of the most important events of the past 3 months, editorial articles focusing on specific aspects of our software as well as an outlook of coming software additions and improvements. The current and previous editions of the newsletter can be downloaded here.
We are always looking for additions to our young and dynamic team. Please visit our careers page for current opportunities.