Combining 'things' in different ratios
March 5, 2018 8:26 PM   Subscribe

I have $10000 to spend on plants (well I wish I did anyway). My plants come in two sizes which I'll call thing1 and thing2.

Thing1's are $1.21 each and thing2's are $3.50 each.

I want to vary the ratios of thing1 and thing2 while staying under the $10000 limit.

Eventually I hope to put this in a spreadsheet but if I could understand it that'd be great.

Prices for thing1 and thing2 are fixed for now but may vary over time. Also it would be good to add more 'things' in future but for now two 'things' are complicated enough.
posted by unearthed to Work & Money (4 answers total)
 
1.21*qThingOne + 3.5*qThingTwo = 10000
qThingTwo = (10000 - 1.21*qThingOne) / 3.5

q is quantity.

Swap the variables and coefficients (prices) if you want to calculate the other way.

In the future just update prices and amount remaining.
posted by supercres at 8:34 PM on March 5, 2018


Or if you’re visual. The vertical axis is number of thing twos. Start there and go straight right until you hit the line, then go straight down until you hit the horizontal axis. That’s the max number of thing ones.

Or you can start on the horizontal axis and choose the number of thing ones. Then up, then left.

Round down of course.
posted by supercres at 8:40 PM on March 5, 2018 [1 favorite]


Perhaps a different approach to ratios would be the patterns and effects you might like to achieve? If you're actually talking about plants and gardens.
posted by turbid dahlia at 8:40 PM on March 5, 2018 [1 favorite]


Response by poster: Thanks heaps to all of you!, Really, really helpful.

Thanks to;
supercres for a solution I can do manually and see what's going on, also for the graph / nomogram and intro to Wolfram.

turbid dahlia - yes this is real plants and gardens - on a bigger scale, this one's 50000 plants and I'll still be planting in 2020+. The question is centred on reducing planting cost by altering the ratio of (in this case) faster and slower-growing plants.

So plant purchase size ratio is kind but not completely separate from aesthetics.

and Seymour Z I'm working through these different approaches as they are all very useful.
posted by unearthed at 12:44 AM on March 6, 2018


« Older Can I be a piano "tutor"?   |   Insomniac and Asthmatic - Why can't I take... Newer »
This thread is closed to new comments.