Optimization Problem of Excel Programming Calculation for Mayonnaise Prescription

Abstract:

Article Preview

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 et al., "Optimization Problem of Excel Programming Calculation for Mayonnaise Prescription", Advanced Materials Research, Vol. 304, pp. 304-309, 2011

Online since:

July 2011

Export:

Price:

$35.00

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

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