Analytics Archives - Page 11 of 14

The Client Who Changed His Mind (And Why I Finished the Job Anyway)

Years ago, I was doing gigs on Fiverr. Mostly Excel work — macros, pivot tables, solver models. I had a profile and a handful of listings, and I’d written about that whole love/hate experience back in 2017 (short version: the clients who treat you like a vending machine are the price you pay for the ones who bring you genuinely interesting problems). One day, a genuinely interesting problem showed up.

A training company needed help scheduling their staff. Multiple clients, multiple courses, multiple instructors, limited hours, shared equipment, weird simultaneous constraints. Classic Operations Research territory. I said yes.

Continue reading “The Client Who Changed His Mind (And Why I Finished the Job Anyway)”

How many days is five months

“How many days in five months” is a very strange question to write a post about but I am learning about SEO (Search Engine Optimization). And using Ahrefs keyword research tool I found out the question is a very good keyword to target. At the end, I explain how to calculate it using Excel (or any spreadsheet).

This is what Google tells us:

Shadow price in linear programming

Linear programming is a mathematical method that is used to optimize the allocation of resources. It can be applied to a wide range of problems, such as maximizing profits or minimizing costs. One of the key concepts in linear programming is the shadow price, which can be used to determine how a change in one of the constraints of a linear programming problem affects the optimal solution.

The 6 W’s Explained: Who, What, When, Where, Why, How

The six W’s are six questions — who, what, when, where, why and how — that you ask about a problem before you try to solve it. They come out of journalism, where a reporter has to establish the facts of a story, and they got adopted into continuous improvement work for exactly the same reason: you cannot fix something you haven’t described properly.

I spent most of my working life as an operations research analyst, building models for manufacturing and supply chain problems. And the honest lesson from all of it is that the modeling was rarely the hard part. Getting a straight answer to these six questions was the hard part.

Continue reading “The 6 W’s Explained: Who, What, When, Where, Why, How”

What is mathematical programming

Mathematical programming is a field of mathematics that deals with the optimization of complex systems and processes. It has a rich history that dates back to the 1940s when George Dantzig, an American mathematician, developed the simplex method for solving linear programming problems. Since then, it has grown into a vast and dynamic discipline that has found applications in various fields such as finance, transportation, engineering, and operations research.

In this blog post, I will explore the origins of mathematical programming, provide an example of a problem that can be tackled and list some classical problems. I will also discuss some of the software products used in mathematical programming, both open-source and commercial.