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
Alteryx

A solution to last week’s challenge can be found here.  Source: https://www.gardenista.com/posts/flower-arranging-101-a-crash-course-for-the-uninitiated/Source: https://www.gardenista.com/posts/flower-arranging-101-a-crash-course-for-the-uninitiated/

 

A florist is making 10 flower arrangements for a party. He'd like to maximize the total number of flowers in each arrangement.

 

The florist has picked out the seven different kinds of flowers he'd like to include in each arrangement. Each arrangement needs to have between 4 - 8 of each flower, and between 3 - 4 filler greens.

 

His budget is $950. How many of each flower should the florist order?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
213.png

Interesting challenge ... 

Highlighted
Alteryx Partner

I've never used that tool before. Good practice with an unfamiliar tool. Reminds me of my Excel Solver days.

 

Spoiler
Capture.PNG

Watch my solution video here:

Spoiler

 

Highlighted
Alteryx Certified Partner

The Tool Mastery article is a great resource for learning about the Optimization tool - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Optimization/ta-p/3061...

Spoiler
213.PNG
Highlighted
Alteryx Partner

One of these days the optimization tool will just "make sense". Still not quite there...

Spoiler
dsmdavid_0-1587996951347.png

 

Highlighted
Alteryx Certified Partner

This tool remains a complete mistery for me.

Without the help and tool mastery pages, it would have been impossible to use

 

 

Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
16 - Nebula
16 - Nebula

I would echo @dsmdavid 's sentiment

Spoiler
patrick_digan_0-1588008609009.png

 

Highlighted
8 - Asteroid

Never used this one before

Very helpful to walk through the Sample Workflows > Predictive Tool Samples > Prescriptive Analytics > Optimization Input Modes and also reference the Tool Mastery article. 

 

Spoiler
mj_solution.png
7 - Meteor

See my solution attached.

Spoiler
213 Spoiler.PNG