Summary: | The paper demonstrates how a deterministic farm linear programming (LP) model can be made stochastic and simulated using Solver and Simetar© in Excel©. The demonstration is conducted with an LP-model for a dairy farm for a sub arctic region of Norway. The income risks arising from variation in milk and crop yields due to winter damage in leys and pastures have been quantified for farms demonstrating low, medium and high forage yield risk. The estimated distribution of farm profit will be skewed to the left, indicating a downside risk. In the presence of risks, farmers maximize income by producing the milk quota with using surplus forage for meat production. The analysis demonstrated here may assist farmers and farm managers in improving sensitivity analysis for risky variables in farm LP models.
|