Access Official Technical PDF

Share Summary:LinkedInEmail

Choosing which food crops to prioritize is a multi-factor decision. Production volume alone does not show whether a crop is affordable to grow, important to local needs, commercially competitive or expanding over time. A decision support system using the Weighted Product method can bring these considerations into one structured comparison. A study focused on North Sumatra illustrates the approach, as well as a practical requirement for engineers and decision-makers: verify that the inputs, calculations and reported ranking agree before acting on a result.

Why use a decision support system for crop selection?

Regional development decisions often involve making the best use of local potential. For agriculture, that means assessing several characteristics of candidate crops rather than relying on a single measure. A decision support system (DSS) provides a repeatable way to organize criteria, assign their relative importance and rank alternatives.

The North Sumatra study frames crop selection as a multi-attribute decision-making problem. Its purpose is to identify food crops with potential for development, helping decision-makers compare options against a common set of considerations. The method does not replace agricultural expertise; it makes the logic of a comparison more explicit.

Weighted Product method: criteria and weighting

The study evaluates seven criteria: level of need, operating cost, production quantity, harvested area, selling price, competitiveness and production growth. These measures cover different dimensions of a crop’s potential, from local relevance and cultivation costs to production and market considerations.

Each criterion is scored on a scale from 1 to 5, with higher scores generally representing a more favorable assessment. The study assigns the weights 5, 3, 5, 4, 5, 3 and 5, respectively. This gives the criteria different influence in the final ranking: a change in a more heavily weighted criterion can affect an alternative’s score more than a change in a lower-weighted one.

Before applying the method, criteria must be classified by direction. Benefit criteria are favorable when their values increase, while a cost criterion is favorable when its value decreases. In the Weighted Product method, each criterion value is raised to a power based on its weight. Benefit criteria use positive exponents; cost criteria use negative exponents. The resulting values are multiplied to produce a score for each alternative. Scores can then be normalized so that the alternatives can be compared as relative preferences.

From regional data to a ranked result

Some criteria require additional calculations before scoring. For production quantity and harvested area, the study compares North Sumatra’s contribution with national totals, using 2015 data. Competitiveness is assessed with the Revealed Comparative Advantage (RCA) ratio: the regional share of a crop’s production is compared with that crop’s national share. The study treats an RCA above 1 as an indication of stronger comparative competitiveness.

Production growth is assessed using the Compound Annual Growth Rate (CAGR). Selling-price stability is also considered, with the study’s scale distinguishing stable prices from fluctuating, rising or falling prices and crops described as having no value. These measures are converted into criterion scores before the alternatives are evaluated with Weighted Product.

This sequence matters operationally. A ranking is only as meaningful as the data and scoring rules behind it. Decision-makers should be able to trace each input—from the source data and calculation method through to the assigned score and weight—especially when regional statistics, price assessments and expert judgments are combined.

Validate the ranking before using it

The published example contains a discrepancy that highlights the importance of checking results. Its conclusion identifies cassava as the leading crop and describes it as alternative A4. However, the preference values shown in the worked calculation assign the highest value to V6 (0.1849); V4 is shown as 0.1177. The alternative-to-crop mapping table is not present in the supplied text, so the displayed figures do not allow the reader to verify that A4 corresponds to cassava or reconcile the stated conclusion with the calculated ranking.

This does not invalidate the Weighted Product method itself, but it means the specific winning alternative cannot be confirmed from the presented values alone. In practice, reviewers should check:

  • That each alternative label maps consistently to a named crop throughout the analysis.
  • That benefit and cost criteria use the correct exponent direction.
  • That all criterion scores, weights and intermediate calculations are reproducible.
  • That the final ranking matches the normalized preference values.

These checks are relevant beyond agriculture. Any multi-criteria DSS can produce a clear-looking ranking while still carrying errors in data mapping, criterion direction or reporting. Transparent calculation steps make it easier for technical reviewers and decision-makers to identify such issues before a recommendation informs planning.

Practical implications for regional planning

The main value of this approach is its structured comparison of competing priorities. By considering need, operating cost, production, harvested area, price, competitiveness and growth together, a DSS can help public agencies and other stakeholders examine crop potential from multiple angles. The same framework also makes trade-offs visible: a crop may score well on some criteria while facing disadvantages on others.

For reliable use, the model should be treated as decision support rather than an automatic prescription. Criteria, weights and data need to be documented, and the computed order should be independently checked against the underlying table. If those steps are followed, the Weighted Product method can provide a consistent basis for discussion and help direct attention toward options that merit further assessment.

Conclusion

A Weighted Product decision support system offers a practical way to combine multiple criteria when comparing food crops for regional development. Its usefulness depends not only on selecting relevant measures and weights, but also on correctly classifying costs and benefits, documenting the data and validating the final ranking. In the North Sumatra example, the reported conclusion and displayed preference values do not align, underscoring a simple but essential lesson: verify the calculation before turning a model result into a planning decision.

Access Official Technical PDF

About The Author