This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.


Solve problems with linear programming and Excel Logo cgma

  Clarence Goh |   Free |   CGMA |   Feb 2019 |   FM magazine

Identifying limited resources and optimising value is a major part of the work of a management accountant. Linear programming tools have been around for many years and this article explains the use of Excel’s free Solver add-in. It provides an example and illustrates the spreadsheets that arise from solving the problem. Having a clear understanding of the variables involved is vital for success.

Topics covered:
  • Management accounting: Technical: Business planning: Planning, forecasting & budgeting, Foundational
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational