Paper Title:
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.

  Info
Periodical
Edited by
Jerry Tian
Pages
304-309
DOI
10.4028/www.scientific.net/AMR.304.304
Citation
Z. Y. Luo, H. X. Zhao, X. Yuan, Y. Li, "Optimization Problem of Excel Programming Calculation for Mayonnaise Prescription", Advanced Materials Research, Vol. 304, pp. 304-309, 2011
Online since
July 2011
Export
Price
$32.00
Share

In order to see related information, you need to Login.

In order to see related information, you need to Login.

Authors: Meng Hua Fan
Chapter 6: Computational and Computer Science Technology, Simulation, Modeling, Algorithms
Abstract:It is difficult to determine the Mohr-Coulomb failure envelope visually, and it is strongly influenced by abnormal test data evaluating the...
579
Authors: Jing Hui Zhao, Bing Zhou
Chapter 4: Measurement Technology and Instruments
Abstract:Using YanHua USB-4718 eight-channel thermocouple input module, PC machines as the main hardware,the Labview of National Instruments (NI)...
259