• Home
  • Blog
    • Archive
  • Services
  • Resources
  • About us
  • Contact
  1. Home
  2. Blog

Job sequencing to minimize completion time

1 March 2021 (1,962 words)

Optimal job sequencing

"Job sequencing" is a common management problem, especially in manufacturing and production businesses.

That is, given a set of jobs, what is the job sequence that takes the minimum total time?

The benefits from improved sequencing can be substantial, while a poor sequencing solution can be expensive. To illustrate how an optimization model can help us make the decision, in this article we solve a simple job sequencing problem using Solver.

  • Excel
  • Solver

Read more ...

Fantasy sports: Pick the best team

22 February 2021 (1,928 words)

Fantasy sports

"Fantasy sports" is a popular pastime. Like in many real sports, the performance of a fantasy sports team may be determined by relatively small margins. The selection of a slightly better team can lead to substantially better performance.

To help achieve better team performance, we explore a team selection optimization model built in Excel and solved with OpenSolver.

  • Excel
  • OpenSolver
  • CBC

Read more ...

One-dimensional packing: Wire cutting

15 February 2021 (2,086 words)

Wire cutting

"Wire cutting" is a common type of production problem. That is, given available stock of wire (or other one-dimensional stock material) and a list of pieces required, what is the best way to cut the stock to fulfil the requirements while minimizing waste?

The benefits from improved cutting can be substantial, while poor cutting choices can be expensive. To illustrate how an optimization model can help us make the decision, in this article we design, build, and solve a wire cutting problem using OpenSolver.

  • Excel
  • OpenSolver
  • Solver
  • CBC

Read more ...

Production mix via graphical LP

8 February 2021 (2,385 words)

Production mix

"Production mix" planning is a common business problem. That is, given available resources, what mix of products should we make to maximize profit?

With potentially many trade-offs between production choices and available resources, deciding on the best volume for each product can be a complex decision. The gains from making a better decision can be substantial, leading to improved profit and more efficient use of resources.

  • Excel

Read more ...

Facility location optimization in Excel

25 January 2021 (2,360 words)

Facility location choices

The "facility location problem" is a common, and often difficult, decision that organizations need to make.

Facilities may include assets such as factories, warehouses, shops, mobile telephone sites, etc. Such assets are typically long-lived, so the decision about where to build them has a long-term impact on the organization.

A wrong, or sub-optimal, decision is likely to be very expensive. To help make the decision, we can model the facility location problem using an optimization model in Excel.

  • Excel
  • OpenSolver
  • Solver

Read more ...

About this blog

11 January 2021 (122 words)

This is a blog about optimization modelling.

Our primary, but not exclusive, emphasis is on models built in Excel and solved using the Solver or OpenSolver add-ins.

Topics include:

  • Optimization model examples, with detailed explanations and Excel spreadsheets available for download.
  • Projects we've worked on recently (anonymized, of course).
  • Links to posts by other optimization bloggers.
  • Interesting developments in the optimization field.
  • Updates to relevant software.
  • Anything else relating to optimization modelling that grabs our attention.

If you want help with your own models, or if you would like to know more about anything mentioned in this blog, then please contact us. To support the creation of new content, please buy us a coffee.

Page 4 of 4

  • 1
  • 2
  • 3
  • 4

Latest

  • Python optimization Rosetta Stone
  • Set up a Python modelling environment
  • Python, welcome
  • Transformation and linearization techniques
  • Logic conditions as constraints - Part 2
  • Logic conditions as constraints - Part 1
  • Decision modeling free textbook
  • Finding almost all paths
  • Taking a dip in the MIP solution pool
  • MIP formulations and linearizations

Archive

  • 2022
    (10 articles)
    • June 2022 (3 articles)
    • May 2022 (1 article)
    • April 2022 (2 articles)
    • March 2022 (2 articles)
    • February 2022 (1 article)
    • January 2022 (1 article)
  • 2021
    (26 articles)
    • December 2021 (2 articles)
    • November 2021 (2 articles)
    • October 2021 (2 articles)
    • September 2021 (2 articles)
    • August 2021 (1 article)
    • July 2021 (1 article)
    • June 2021 (1 article)
    • May 2021 (2 articles)
    • April 2021 (4 articles)
    • March 2021 (4 articles)
    • February 2021 (3 articles)
    • January 2021 (2 articles)

Social

@SolverMax   Buy me a coffee   LinkedIn

Search

© 2020-2022 Solver Max

Term and conditions   Privacy   Contact us