Optimization Problem of Excel Programming Calculation for Mayonnaise Prescription

Abstract:

The method combining linear programming theory and computer technology, affords the possibility for the Optimization problem of food prescription in engineering design. Excel's Solver function may be used to solve problems with up to 200 decision variables, enough to calculate the most problems about food prescription. Combined design requirement of mayonnaise prescription, the decision variables, constraint condition and mathematics model of cost are established. The optimization prescription of minimum cost is gotten through the function of Excel programming calculation. It may provide valuable reference for the application of computer in prescription design.

• Periodical: Advanced Materials Research (Volume 304)
• Pages: 304-309
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.304.304
• Online since: July 2011
• Authors: Zhi Yang Luo, Hong Xia Zhao, Xin Yuan, Yuan Li
• Keywords: Excel, Function Optimization, Linear Programming, Mayonnaise, Prescription

References

[1] Ou Jianfeng: Solving planning problems with Excel, Computer and Agriculture (2000), no. 2, pp.26-29.

[2] Huang Yan: The discussion on mayonnaise production, Food science, vol. 17 (1996), no. 11, pp.70-71.

[3] Wang Meigui: The application of optimization techniques in food engineering, Food science (1988), no. 3, pp.1-5.