巧用Excel设计最低成本饲料配方  

The Application of the Software Excel in Designing of the Lowest Cost Feed Formula

作　　者：刘志敏[1] 程慧芳[1] 孙占田[1] 

机构地区：[1]河北工程大学,河北邯郸056038

出　　处：《中国饲料添加剂》2010年第9期29-32,共4页China Feed Additive

摘　　要：本文详细介绍了利用MicrosoftExcel的线性规划求解功能来设计最低成本饲料配方的操作方法，并以实例加以说明。所设计的用以计算配方的Excel工作表，简单明了、易于操作。这种方法具有计算速度快、增减原料随意和数据修改容易等优点。This paper discussed the way to obtain the lowest cost feed formula using the linear programming of Microsoft Excel in detail, and gave an example. The sheet used to calculate the lowest cost feed formula is very simple and easy to be operated. This method has many advantages such as scientific, quick speed to count, randomly increasing or decreasing raw material and data to modify easy etc.

关 键 词：EXCEL 饲料配方 线性规划 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]