利用EXCEL进行猪饲料配方

Application of Microsoft Excel in Optimization of Pig Diet Formulation

本文主要介绍了如何利用 Microsoft Office 软件中的 Excel 进行"规划求解"配方设计,分析了养分项目及资源的影子价格对饲料成本的影响,并以猪饲料配方为例进行详尽的演示。从中可以看出,利用 Excel 进行线性规划设计饲料配方,具有灵活、简便、快捷、直观等特点,既可节省购买配方软件的资金,又能直观地完成最低成本配方的任务。

Application of programming function of Microsoft Office Excel in animal diet formulation was thoroughly introduced.The effect of shadow price of resources on the cost of feed was studied.Process of feed formation was illustrated with a example of finishing pig feed formulation.It is simple,rapid, vsual and easy adjust relative values to composite animal feed formulation .It was saved money to buy software and visually attain low-cost feed formulation .