# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

## Challenge #213: Optimized Flower Arrangements

Highlighted
Alteryx

Never used the Optimization tool before.

Spoiler

Highlighted
8 - Asteroid

I have chosen the Mixed Integer Program...but the result is the same

Highlighted
Alteryx

Solution attached

Highlighted
Alteryx Certified Partner

This is probably my favorite Alteryx Tool.

It had been while since I used it thought so I had to brush up on the examples located in Help -> Sample Workflows -> Predictive tools samples -> Prescriptive Analysis.

Sample files

But here is my take on this weeks challenge

Spoiler
The Workflow

What I think is cool about the optimization tool, is that is just does its thing!
So in the result the optimization returns an objective value of 417, which means the total number of flowser used.
But if we take the number of each of the optimized flowers, and calculate the total value
Calculate total

Then you can actually see, that the optimization reach a total of 949,90 \$ for the 417 flowers
Total number and Total orice

One thing missing contranit would have to make sure that there was the same amount of flowers in each arrangement.
The optimization gives a result for a total og 57 red roses for the ten arrangement, but you can't really af 5.7 red roses to each arrangement. 😉

Still Climbing
/Verakso

Highlighted
9 - Comet
Highlighted
17 - Castor

Here is my solution.

Highlighted
5 - Atom

My solution, thanks.

Highlighted
8 - Asteroid

Hi! Here my solution WITHOUT Optimization tool 😜 haha

Spoiler
Highlighted
13 - Pulsar

After being off for a couple of weeks, catching back up to the top of the leaderboard.  New tool for me.  Reminds me of learning solver, but much easier to use.

Spoiler

Highlighted
10 - Fireball

Cool, another tool under my belt. Will be probably coming back to this challenge whenever I need to use optimization tool ever again

Spoiler