在企业财务管理工作中,会常常遇到一些最佳值的求解问题,如目标利润最大值、目标成本的最小值。这些问题可以利用建立数学模型来进行解决,但实际应用中由于建立数学模型与求解过程过于麻烦而导致决策者放弃使用。本文探讨了利用Excel中的“规划求解”工具来解决该系列的问题。 In the enterprise financial management work, we often encounter some best value solving problems, such as the maximum target profit, the minimum target cost. These problems can be solved by establishing mathematical models, but in practice, decision-makers abandon the use of mathematics models and solving problems. This article explores the use of Excel in the “Solver” tool to solve the problem of the series.