bmack11235813
New Member
- Joined
- Apr 17, 2019
- Messages
- 1
I am conducting a bid. I have 5 items I want to purchase at varying quantities and am receiving bids from 4 different vendors. I know how to calculate total min spend and show which vendor to utilize for each item.
Say I want to only set up purchase agreements with only 2 vendors. How can I analyze the data to determine which two vendors I should utilize? Is there a way to make this scalable - say I had 100 items and 20 vendors? Can I set a 'maximum' number of successful vendors and minimize total spend?
I was attempting to use solver but I can't think of the design that makes it work.
-Bryce
<tbody>
</tbody>
Say I want to only set up purchase agreements with only 2 vendors. How can I analyze the data to determine which two vendors I should utilize? Is there a way to make this scalable - say I had 100 items and 20 vendors? Can I set a 'maximum' number of successful vendors and minimize total spend?
I was attempting to use solver but I can't think of the design that makes it work.
-Bryce
Item | Quantity | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Min Bid | Min Vendor |
A | 10 | $10 | $2 | $76 | $3 | $2 | Vendor 2 |
B | 12 | $45 | $24 | $6 | $10 | $6 | Vendor 3 |
C | 4 | $78 | $8 | $40 | $27 | $8 | Vendor 2 |
D | 25 | $45 | $96 | $38 | $4 | $4 | Vendor 4 |
E | 14 | $40 | $56 | $88 | $79 | $40 | Vendor 1 |
Total Spend | $ 784 |
<tbody>
</tbody>