cutvaga9800
New Member
- Joined
- Sep 5, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello,
I'm having a task about buying some tables for campus. I'm trying to do it with solver but I have no idea about it.
There are 4 campus that need exactly an amount of tables and 5 companies who make an offer. The demanding and capacities of each company is shown below.
The two question here is:
1. Company A only sells table for a campus if that campus order more than or equal to 15 (for each campus).
2. The conditional from company A + Company B sells table by set of three for each campus (quantity of table from company B for each campus mod 3 = 0).
I need to minimize the total cost. Some people told me that I can do it with solver.
I dont know how to setup some conditional constrains. Hoping for some help ASAP. Thanks in advance.
The file is here.
I'm having a task about buying some tables for campus. I'm trying to do it with solver but I have no idea about it.
There are 4 campus that need exactly an amount of tables and 5 companies who make an offer. The demanding and capacities of each company is shown below.
The two question here is:
1. Company A only sells table for a campus if that campus order more than or equal to 15 (for each campus).
2. The conditional from company A + Company B sells table by set of three for each campus (quantity of table from company B for each campus mod 3 = 0).
I need to minimize the total cost. Some people told me that I can do it with solver.
I dont know how to setup some conditional constrains. Hoping for some help ASAP. Thanks in advance.
The file is here.