Excel Solver求解器弄乱了我的优化 [英] Excel Solver solver is messing up my optimization
问题描述
我已经设置了一个优化问题，但是我必须做错了什么，我可以使用您的帮助.我有三个公司:阿尔法，布拉沃，查理.他们每个人都完成三个任务:铣削，检查，钻孔.他们每个人需要不同的时间来完成每个任务. Alpha需要12分钟的铣削时间，5分钟的检查时间和10分钟的钻孔时间. Bravo需要10分钟的铣削时间，4分钟的检查时间和8分钟的钻孔时间.查理要求8人进行铣削，4人进行检查，而16人进行钻孔.在每个公司完成所有这些任务后，他们将获得一定的利润，Alpha将获得$ 2.40，Bravo将获得$ 2.50，Charlie将获得$ 3.00.所有这三个公司的最大磨削时间为1200分钟，检查的最大时间为900，钻削的最大时间为1440.目标是使这三个公司的利润最大化.我进行了设置，以使任务的总和不占用求解器更改后剩余的可用时间.我还在求解器中设置了约束，以将每个任务限制为每个任务允许的分配时间.但是，我必须错过一个至关重要的步骤，因为它一直在试图最大化单个公司的分配时间，而不考虑其他公司或其他公司的机会成本.请帮忙！ (如图所示)
I have set up an optimization problem but i must be doing something wrong and I could use your help. I have three firms: alpha, Bravo, Charlie. They each complete three tasks: Milling, Inspecting, Drilling. They each require different amounts of minutes to complete each task. Alpha requires 12 minutes to mill, 5 minutes to inspect and 10 minutes to drill. Bravo requires 10 minutes to mill, 4 to inspect, and 8 to drill. Charlie requires 8 to mill, 4 to inspect, and 16 to drill. After each firm completes all of these tasks they will earn a certain amount of profit, Alpha will earn $2.40, Bravo will earn $2.50, and Charlie will earn $3.00. All three firms have a maximum allotted time of 1200 minutes to mill, 900 to inspect, and 1440 to drill. The goal is to maximize the profit of these three firms. I have set it up so that the sums of the tasks will take away from the available time left when changed by the solver. I have also set constraints within the solver to cap each task to the allotted time allowed per task. I must be missing a vital step however because it keeps trying to just max out the allotted time for an individual firm, not taking in to account the opportunity cost of the other firms or something. Please help! (shown in photos)
推荐答案
我刚刚做了一个尝试，得到了一个不同的答案，因为我假设要实现盈利，公司必须完成铣削过程，然后检查，然后进行钻探，一旦全部完成，那就是1个获利单位-我希望这是有效的.
I have just had a go at this and I get a different answer as I have made the assumption that to achieve the profit the company must complete a milling process, then inspect, then drill and once all are complete then that is 1 unit for the profit - I hope that is valid.
但是，如果不是这样，无论如何，这种布局可能会对您有所帮助.注意，我已经将此设置为求解器的线性模型，并且还注意到整数和非负数的使用.
But if not, then this layout may help you anyway. Note I have set this as a Linear model for the solver and also note the use of integer and non-negative.
那还是很有趣的！
这篇关于Excel Solver求解器弄乱了我的优化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
