A primer on implementing compressed simulated annealing for the optimisation of a constrained simulation model in Microsoft Excel

This short paper provides a simple introduction on how a simulation model implemented in Microsoft Excel® can be optimised using Visual Basic for Applications (VBA) programming and the compressed simulated annealing algorithm (Ohlmann et al., 2004; Ohlmann and Thomas, 2007). The standard simulated annealing procedure enters as a special case. Practical advice for determining the parameters that guide the stochastic search process in an annealing algorithm is also given.Research and Development/Tech Change/Emerging Technologies,

Combinatorial optimisation of a large, constrained simulation model: an application of compressed annealing

Simulation models are valuable tools in the analysis of complex, highly constrained economic systems unsuitable for solution by mathematical programming. However, model size may hamper the efforts of practitioners to efficiently identify the most valuable configurations. This paper investigates the efficacy of a new metaheuristic procedure, compressed annealing, for the solution of large, constrained systems. This algorithm is used to investigate the value of incorporating a sown annual pasture, French serradella (Ornithopus sativa Brot. cv. Cadiz), between extended cropping sequences in the central wheat belt of Western Australia. Compressed annealing is shown to be a reliable means of considering constraints in complex optimisation problems in agricultural economics. It is also highlighted that the value of serradella to dryland crop rotations increases with the initial weed burden and the profitability of livestock production.combinatorial optimisation, crop rotation, simulated annealing, Research Methods/ Statistical Methods, C63, Q15,

Optimal Dynamic Management of Agricultural Land-Uses: An Application of Regime Switching

The capacity of global agricultural production to meet increased demand for food from population growth and wealth accumulation is threatened by extensive land degradation. Nonetheless, previous research has focused primarily on the dynamic implications of input management and ignored land-use choice. This paper extends this theory through an examination of the intertemporal management of agricultural land through the use of non-crop inputs, such as fertilizer, and land uses that either degrade or restore productivity. The need to consider the relative total asset value of alternative crops over time is demonstrated. Moreover, higher output prices for degrading crops are shown to increase their relative value, motivating the later adoption of substitutes. An inability of land markets to reflect differences in resource quality and low capital malleability promote greater degradation. However, substitution of complementary effects through input use may help to sustain productivity. These factors are discussed in the context of crop sequence management in Western Australian cropping systems.crop sequences, land degradation, regime switching, International Development, Production Economics, Q15, Q24,