SOLVED
How to calculate product price using Alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hellyars
13 - Pulsar
‎03-06-2022
07:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A math challenge. See my follow-up comment below. Basically, how do I solve this using an expression in Alteryx?
I want to calculate the unit cost for two truck types, but....
- I know how many of each type (6x6 or 8x8) is being bought. So, I know the ratio of 6x6 to 8x8 trucks.
- I know the total price. So, I can calculate a composite average.
- I also know that the 8x8 should cost 12% more than the 6x6.
- I assume the key is that I know the 8x8 should cost 12% more than the 6x6; I know the ratio of 6x6 to 8x8s, and I know the composite average. But beyond that, my geopolitical background is failing me.
Truck A (6x6) | Truck B (8x8) | Total Qty All Trucks | Total Cost All Trucks | Composite Avg of Both Truck Types Mixed | 6x6 Cost | 8x8 Cost |
161 | 91 | 252 | 92000000 | 365 | X | Y= X*1.12 |
675 | 325 | 1000 | 382000000 | 382 | ||
339 | 219 | 558 | 240000000 | 430 | ||
292 | 109 | 401 | 154000000 | 154 | ||
150 | 850 | 1000 | 389000000 | 389 |
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
‎03-06-2022
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So,my brain says the following, first example... but how do I translate that o an equation in alteryx?
Let x = 6x6 and y= 8x8
x=0.88y (as x is 12% less than y)
161x + 91y = 92M
161(0.88y) + 91y = 92M
141.68y + 91y = 92M
232.68y = 92M
y= 395,392
161x + 91(395,392) = 92M
x= 347,946
‎03-06-2022
09:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just decided to do it in Excel
