Challenge #213: Optimized Flower Arrangements

[balajilolla]

Spoiler

Spoiler Solution

Very Interesting Challenge! Learnt a new tool

[dkoenawan004]

Now this is a challenge. Had to pull my notes from Inspire APAC and finally figure it out!

Spoiler

[TonyA]

Really simple once I remembered how to use the optimization tool. It seems that every time I run into it I have to learn how to use it all over again.

Spoiler

I played with this a bit, trying different linear programming models. The given solution used GLPK. I also tried Symphony and got a different result with 57 White Daisies and 40 Red Roses and all other values the same. This is arguably slightly better since it gives the same number of flowers at a slightly lower cost (949.05 vs 949.90).

[Kenda]

Spoiler

The last time I used this tool was for the previous Weekly Challenge that required it

 

[JohanRanschaert]

Solution in attach

[JennyMartin]

Spoiler

I forgot you could have lower and upper bounds in the objective function input! I also got slightly different values, as I solved for each arrangement. I ❤️ the optimization tool!

For the video solution I've removed a bit of the complexity by using the lower and upper bounds! https://www.youtube.com/watch?v=Wr-ZS_NdQ2k&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=18&t=0s

[ggruccio]

Sweet Success!!!

Spoiler

I had to step away - mow the lawn - sleep on it:

Had the right idea, but so important to make sure data stays in the correct relative order...which the transpose was not doing for me initially.  Fixed that and realized I had spelled "coefficient" incorrectly as well in the O input. 

Not the easiest tool to master, but kept re-reading the Tool mastery page until something clicked.

[AkimasaKajitani]

My Solution.

Spoiler

 

[kelvin_law1]

Here is my solution:

Spoiler

[PhilipMannering]

I would love to see the solution with constraints in rows. @Ollie and I couldn't get it to work that way for neither love nor money.

Here's the solution with variables in rows at any rate,

Spoiler

woof