by Viesturs Rozenbergs, Imants Skrupskis, Dace Skrupska, Ērika Rozenberga
RURAL ENVIRONMENT. EDUCATION. PERSONALITY. Jelgava, 20 – 21.03.2013
(download)
Abstract
Possibility of food allowance optimization by using MS Solver tool is analysed in the research. The model is developed by balancing 22 food products and 30 constraints – 8 nutrients and 22 minimum amounts of food products. The new method differs from the applications of linear programming described in the special literature on nutrition science not only with increased nutritional constraints, but also the minimum amount of every product is introduced as constraints, which does not essentially change costs, but provide quality, for example, for tea or coffee it is recommended to define not x≥0, but x≥3. By modifying minimum amounts of tea, coffee, sugar, spices, it is possible to obtain up to 70% economy from the initial rate. Application of the model is approbated in the computer class during practical classes for students of nutrition science.
– – –
NB – To follow up this topic (or others), enter your email in the rectangle at the bottom/right side of this page (you can un-subscribe any time).